Excel Alinyemen Horizontal.xlsx

DATA YANG DIKETAHUI TITIK

X

Y

A

3 392

7 2 4 .0 7

B

2 349

13 0

C

1 941

1 1 8 2 .7 

D

4 4 7 .9 9

1  0 7 .3 1

E

4 4 8 .8 2

71

TABEL AZIMUTH RENCANA JALAN

TTIK A B C D E

KOORDINAT X

Y

3 392

7 2 4 .0 7

2 349 1 941 4 4 7 . 99 4 48 . 82

X'

Y'

10 43

! 9 4 .0 7

4 08

1 0 ! 2 .7 

1 4 9 3 .0 1

4 2 4 .! !

0 .8 3

1 ! 3  .3 1

13 0 1 1 8 2 .7  1  0 7 .3 1 71

JARAK "#$

1200.320020347

ARC TAN X'%Y'

AZIMUTH

&

RENC. TIK

0.33!1021 240.33!1021

1129.0!0737182

21.18397!33 338.81024337 98.48091771!728900



1!!2.1989442723

74.124!0874 28!.873!4912 !2.94247!21071400

(C

1!3.31022420

0.0309!43!97

C

!417.88!282313

180.0309!43 10!.842!94732!000

)IRAL*)IRAL

+, 0

-#%/#

 #/ 10 >@>6 @/;/# "&$ 98.481  0.1!3 R#5 112.04133080202900 R ,5/5/ "R$ 2!0.0000

#6, #6,

 49.240! L 429.70442!14134000

#6,

L 6:6/; 8 !9.4088!032828000

#6,

< 3.3180013388800

#6,

- 208.02972!80000

#6,

61 !40.7807!74!82000

#6,

E 188.!434!7941784000

#6,

T

=

L

410.394

=

429.7044 ok

TA T->5?/5 A*B*C @AB 1200.320020347 TA A 0 TA T1 !9.!393!030142000 TA T1 1!18.94820088410000

 /,/-
130

#6,

8.403734099

#6,

 /,/- ;>  =L  @

!!0

#6,

13.190230991 *1.20384702

 #6,

;/, <,-,//5 5?/5 R

2!0.0000

∆

98.481

,

0

#6, F -#%/#

*1!4.70442!141



A

1.2

#6,

5

4



2.4

#6,



0.8

#6,

/-/6 :+,6,/--5? ''

0.0744310799713333

#6,

/-/6 /,/- / - >#<, @
0.0322

#6,

/-/6 <,?,/5 Z

0.2!2

#6,

;/, <,-,//5 @ ->5?/5 B ;/>,

13.4419811!1

#6,

4

;/, 1 ;/>,

3.

;/, ,5/5/

14.4

#/-/ @/- <,;> @<,;/,

#6,

0.891244

(ULL CIRCLE

,

0

-#%/#

R#5

112.041330802

#6,

R,5

1000

#6,

>@>6 ->5?/5

84.9

F

T1

911.3701!4034

#6,

E

3!2.99270808!230

#6,

L

1478.119343!14000

#6,

R,5/5/

=

R#5

1000

=

@BC

1129.0!0737182

TA T1

1!18.948200884

61

!40.7807!74

TA TC

119!.8!897191410

TA CT

273.9724070!410

112.0413 ok

/,/-
130

#6,

2.112073404

#6,

!!0

#6,

- ;>  @  =L

*88.4427232!1 900

0.043279!2 *97.91!8831!7

,-,//5 5?/5 R

1000

#6,

∆

84.9

F

,

0

-#%/#

)

.1

#6,

A

1.2

#6,

5

4



2.4

#6,



0.8

#6,

0.0180!1731

#6,

-/6 :+,6,/--5? ''



TD

0.0080400323

#6,

0.03

#6,

12.91!407893

#6,

/-/6 <,?,/5 Z  <,-,//5 @ ->5?/5 B ;/>,

4

;/, 1 ;/>,

3.

;/, ,5/5/

14.4

#/-/ @/- <,;> @<,;/,

#6,

*44.0!9717!7

0.300844!088



)IRAL * CIRCLE * )IRAL

,

0

 #/

-#%/#

10



2

>@>6 @/;/# "&$

10!.842!9473

R#5

112.231948234

#6,

2!0

#6,

!.729

#6,

D#/

12.7!9212881

#6,



0.094014

R ,5/5/ "R$ D

.940 

B

#

##/

12!

#5/, L 1. B,@//,-/5 /-6> 6#<> @ ;5?->5? <,/;/5 L

!0 #

2. B,@//,-/5 ;/5@/ ,;/  L

!238

TA C*D*E @DE

1!3.31022420

,@//,-/5 ?// 56,>

@CD

1!!2.1989442723

L

TA CT

273.9724070!4

,@//,-/5 /-6> <,/;

T1

911.3701!40

L

19.03128 !0

TA T2

294!.27437002290

,@//,-/5 <,>//5 -

TA C

3020.27437002290

L

TA C

3407.09979027210

L /5? @?>5/

TA T2

3482.09979027210

!3.33333 7!

TA E

448.8718038480

@/,/ / /#<5? ->5?/5  /,/-
L 6:6/;



X



Y



<



#6,

T2



E



!32.97

#6,

129.097!70!88



127.409!84023!

#6,

∆

10!.842!9473

,

0

-#%/#

)

.1

#6,

A

1.2

#6,

5

4



2.4

#6,



0.8

#6,

#6, F

/-/6 :+,6,/--5? 0.07443108

#6,

/-/6 /,/- / - >#<, @
#6,

/-/6 <,?,/5 0.2!2

#6,

;/, <,-,//5 @ ->5?/5

;/>,



14.3134217273

2!0

B

L



R

Z



-

;/, <,-,//5 5?/5

TD

∆C

#6,

 =L

''



170

 /,/- ;>

 @



13.44210!23

#6,

4

;/, 1 ;/>,

3.

#6,

;/, ,5/5/

14.4

#6,

#/-/ @/- <,;> @<,;/,

*1.927!8



0.87!28

?/; ? -,/

T

3

#6,

C

0.4

R

0.02!

+,=80

0.03!

+, 70

5/5 #;56/ ;5?->5? <,/; #6, ;/5@//5 #;56/5? #6, #6,

@#%@-3

F F #6, #6, #6, #6, #6, #6, #6, #6,

38.82!2