Tugas Liburan Topo.xlsx

D

M

S

DD

25 100 100 25 25

25 20 100 85 85

25 35 100 75 86

25.423611111 100.34305556 101.69444444 26.4375 26.440555556 0 0

90 180 270 360

-0.448074 6.1257423E-17 6.1257423E-17 -0.59846 -1 -1 0.984382 -1.8377227E-16 -1.8369702E-16 -0.283691 1 1

RAD 0.4437257 1.7513167 1.7749029 0.4614214 0.4614748 0 0

0.4437257 1.7513167 1.7749029 0.4614214 0.4614748 0 0

DD 25.423611 100.34306 101.69444 26.4375 26.440556 0 0

25.423611 100.34306 101.69444 26.4375 26.440556 0 0

D

M

S

25 100 101 26 26 0 0

25 20 41 26 26 0 0

25 35 40 15 26 0 0

No 1 2 3 4 5 6 7 8 9

DD*pi()/180

Sudut D 0 45 90 180 270 25 60 120 295

M 0 0 0 0 0 25 30 20 25

DD S 0 0 0 0 0 25 30 20 25

Sin

Cos

Radians Tan

Sin

0 0 1 0 0 45 0.7071068 0.7071068 1 0.7071068 90 1 6.123E-17 1.633E+16 1 180 1.225E-16 -1 -1.22E-16 1.225E-16 270 -1 -1.84E-16 5.444E+15 -1 25.423611 0.4293074 0.9031585 0.47534 0.4293074 60.508333 0.8704273 0.492297 1.768094 0.8704273 120.33889 0.8630529 -0.505114 -1.708632 0.8630529 295.42361 -0.903158 0.4293074 -2.103757 -0.903158

Radians Cos

Tan

1 0 0.7071068 1 6.123E-17 1.633E+16 -1 -1.22E-16 -1.84E-16 5.444E+15 0.9031585 0.47534 0.492297 1.768094 -0.505114 -1.708632 0.4293074 -2.103757

Asimut (alfa) D M S 100 45 25 50 50 30

Jarak (dAB) 150.452 300

DX

DY

Koordinat No Titik X Y dAB sin alfa dAB cos alfa 1500.000 5000.000 P1 147.8082248 -28.0808293 1647.808 4971.919 P2 232.6211725 189.439674 1880.429 5161.359 P3

No Titik

KOORDINAT X Y

HITUNGAN SUDUT JURUSAN(ASIMUTH)DAN JARAK DARI 2 KOORDINAT PERUBAHAN JARAK SUDUT JURUSAN (ASIMUT) DX DY (meter) RAD DD D

1 2

10 50

10 50

40

40

56.56854249 0.7853981634

1 2

10 50

10 60

40

50

64.03124237 0.6747409422 38.659808254

38

1 2

100 50

10 60

-50

50

70.71067812 -0.785398163

315

315

1 2

12 32

12 32

20

20

28.28427125 0.7853981634

225

225

1

1 2

0 50

0 50

50

50

70.71067812 0.7853981634

45

45

2

1 2

0 50

0 -50

50

-50

70.71067812 -0.785398163

135

135

3

1 2

0 -50

0 -50

-50

-50

70.71067812 0.7853981634

225

225

4

1 2

0 50

0 50

50

50

70.71067812 0.7853981634

405

405

45

45

RDINAT USAN (ASIMUT) M

S

0

0

39

35.30971

0

0

0

0

0

0

0

0

0

0

0

0

HITUNGAN SUDUT JURUSAN DAN JARAK DARI 2 KOORDINAT Asimut AB Koordinat Selisih No (aAB) Jarak AB Keterangan Titik X Y D M S DX DY A 500.000 100.000 -100.000 -50.000 111.803 243 26 6 KW III B 400.000 50.000 63.435 243.435 243.435 cara 1 =IF(F5=0,IF(E5>0,90,270),IF(E5<0,IF(F5<0,E7+180,E7+360),IF(F5<0,E7+180,E7))) cara 2 =IF(AND(E5>0,F5>0),E7,IF(AND(E5>0,F5<0),E7+180,IF(AND(E5<0,F5<0),E7+180,IF(AN D(E5<0,F5>0),E7+360,IF(AND(E5>0,F5=0),90,IF(AND(E5<0,F5=0),270,IF(AND(E5=0,F5< 0),180))))))) Ket

=IF(F7=0,"Sumbu Y Positif",IF(AND(F7>0,F7<90),"KW I",IF(F7=90,"Sumbu X Positif",IF(AND(F7>90,F7<180),"KW II",IF(F7=180,"Sumbu Y Negatif",IF(AND(F7>180,F7<270),"KW III",IF(F7=270,"Sumbu X Negatif","KW IV")))))))

Hitungan Koordinat Poligon Sudut b

No Titik

Azimuth a

Jarak

DX D Sin a DY D Cos a

A

1500.000 100

B

138

45

210

55

25

150.452 147.808225 -28.080829 1647.808

30

49

142.255 122.588204 72.17075

33

1770.396 90

D

45

24 59

C

Koordinat X

26

22

135.550 135.546013 -1.0396247 1905.942

Poligon Koordinat Y

No Titik

5000.000

A

4971.919

B

Sudut DD

Azimuth

100.7569444 138.7566667 59.51361111 5044.090

C

5043.050

D

210.9258333 90.43944444

Hitungan Koordinat Poligon No Titik

Sudut b D M S

kor (fb)

96

-4.8

Azimuth a D M S

Jarak m

DX d sin a kor/fx m m

DY d cos a kor/fy m m

P1 178 21 P2

38

20

P3

107 33

18

-4.8

P4

64

51

-4.8

P5

20

206 34

50

78.286

2.254

-0.007 -78.254 0.002

261 42 44.8

97.023

-96.010 -0.009 -13.985 0.003

334 9

31.6

67.680

-29.500 -0.006 60.912

0.002

89 48 45.4

61.606

61.606 -0.006

0.201

0.002

63 14

69.088

61.685 -0.006 31.114

0.002

373.683

0.035

0.010

-4.8

P1

64

53

5

-4.8

S

540

0

24

-24

Sdms= 537 178 144 Sdd= 540.006666667 kps= -24 " Jumlah Titik= 5 Sudut yang diukur= D

0

0.2

-0.035

KPA= 0.035

-0.010

KPO= -0.010

inat Poligon Koordinat X m

Y m

No Titik

1000.000000

1000.000000

P1

1002.246858

921.748643

P2

Sudut DD Azimuth DD

907.766330

P3

107.554

876.721415

968.680584

P4

64.346

1000.000000

968.883787 1000.000000

P5 P1

178.350

178.350

Luas 921748.643241

261.712

261.712

909805.951946

334.159

334.159

877845.470953

449.813

89.813

849441.164406

423.233

63.233

938321.336056

96.638

906.228003

938.321336

Azimuth DD dgn pernyataan

206.579 64.883 4497162.5666 luas=

Luas 1002246.85772 835314.432371 795858.181108 908933.6594 968883.787093 4511236.91769 7037.17554424 7037.17554424

tinjau

berdiri

Titik

tinggi alat

FORMULIR PEMETAAN SITUASI Bacaan Benang BA

BT

BB

2.800 2.700 2.500 1.400 1.400 1.400 1.400

2.760 2.484 2.365 1.338 0.804 1.282 1.133

Bacaan Lingkaran Jarak Horizontal Vertikal Optis (Do) Datar (Dd) d m s d m

Dd sin a DX

BM A B C a b 1 2

1.360 2.840 2.916 2.634 1.462 1.996 1.518 1.667

230 117 318 332 332 152 152

20 20 40 10 10 10 10

0 0 0 0 0 0 0

88 90 89 91 91 90 91

5 4 91 40 12 50 4

8 43.2 26.9 12.4 119.2 23.6 53.4

7.9910509714 -6.151 43.1999415135 38.377 26.8978126608 -17.764 12.3895105813 -5.785 119.1477206739 -55.630 23.595008011 11.017 53.381494396 24.924

ETAAN SITUASI Dd cos a

Beda Tinggi

DY

(Dh)

-5.101 -19.836 20.197 10.956 105.363 -20.865 -47.206

j

-1.173 -1.390 -1.383 -0.400 -2.536 -0.383 -1.034

Koordinat X 2000.000 1993.849 2038.377 1982.236 1994.215 1944.370 2011.017 2024.924

Y 1000.000 994.899 980.164 1020.197 1010.956 1105.363 979.135 952.794

Ket Z 700.000 698.827 698.610 698.617 699.600 697.464 699.617 698.966

Titik Kerangka

Sudut Horizontal

Sudut Vertikal

(a) DD 230.3333333333 117.3333333333 318.6666666667 332.1666666667 332.1666666667 152.1666666667 152.1666666667

(Z) DD 88.0833333333 90.0666666667 90.5166666667 91.6666666667 91.2 90.8333333333 91.0666666667