hoja de calculo

12
CALCULOS DE CAR PRESENTADA A : INGENIERA CLAUDIA ESTACION SUB AZIMUT G M S DEC A B 167 22 40 167.377778 S 1 123 56 40 123.944444 S 2 67 45 65 67.7680556 N B C 69 52 35 69.8763889 N 3 358 31 34 358.526111 N 4 313 9 59 313.166389 N C D 346 53 10 346.886111 N 5 202 16 46 202.279444 S 6 156 27 27 156.4575 S D A 259 24 25 259.406944 S 7 98 40 29 98.6747222 S 8 54 51 21 54.8558333 N A B 167 22 40 167.377778 S N -E S - A B 0 12.622222 0 56.055555 67.7680556 112.23194 B C 69.8763889 110.12361 0 0 0 0 C D 0 0 0 0 0 23.5 D A 0 0 0 81.325277 54.8558333 125.14416 A B 0 12.622222

Upload: edison-vargas

Post on 20-Jun-2015

570 views

Category:

Documents


3 download

TRANSCRIPT

Page 1: hoja de calculo

CALCULOS DE CARTERA TOPOGRAFICA PARA LEVANTAMIENTOS POLIGONAL (POLIGONAL CERRADA)

PRESENTADA A : INGENIERA CLAUDIA YANETH ACERO ALVAREZ, PRESENTADA POR: JORGE LEONARDO MATEUS RIVERA ;COD 200820202

ESTACION SUBAZIMUT RUMBO

G M S DEC GA

B 167 22 40 167.377778 S 121 123 56 40 123.944444 S 562 67 45 65 67.7680556 N 67

B C 69 52 35 69.8763889 N 693 358 31 34 358.526111 N 134 313 9 59 313.166389 N 79

C D 346 53 10 346.886111 N 135 202 16 46 202.279444 S 226 156 27 27 156.4575 S 23

D A 259 24 25 259.406944 S 797 98 40 29 98.6747222 S 818 54 51 21 54.8558333 N 54

A B 167 22 40 167.377778 S 12

CONDICIONES PARA EL CALCULO DEL RUMBON -E S - E

A B 0 12.62222222222220 56.0555555555556

67.7680556 112.231944444444B C 69.8763889 110.123611111111

0 00 0

C D 0 00 00 23.5425

D A 0 00 81.3252777777778

54.8558333 125.144166666667A B 0 12.6222222222223

Page 2: hoja de calculo

A B 0 12.62222222222220 56.0555555555556

67.7680556 0B C 69.8763889 0

0 00 0

C D 0 00 00 23.5425

D A 0 00 81.3252777777778

54.8558333 0B 0 12.6222222222223

Page 3: hoja de calculo

CALCULOS DE CARTERA TOPOGRAFICA PARA LEVANTAMIENTOS POLIGONAL (POLIGONAL CERRADA)

PRESENTADA A : INGENIERA CLAUDIA YANETH ACERO ALVAREZ, PRESENTADA POR: JORGE LEONARDO MATEUS RIVERA ;COD 200820202

RUMBO ANGULO EXTERNOM S DEC G M S DEC

37 20 E 12.62222223 20 E 56.0555556

46 5 E 67.768055652 35 E 69.8763889 82 3 40 82.06111116 50 W 13.1138889 54 34 54 54.5816667

24 25 W 79.4069444 65 23 54 65.39833336 50 W 13.1138889 96 34 20 96.5722222

16 46 W 22.2794444 23 45 12 23.753333332 33 E 23.5425 23 17 28 23.291111124 25 W 79.4069444 92 5 0 92.083333319 31 E 81.3252778 76 23 43 76.395277851 21 E 54.8558333 78 23 54 78.398333337 20 E 12.6222222 87 32 0 87.5333333

SUMATORIA REAL DE LOS ANGULOS 358.25SUMATORIA TEORICA DE ANGULOS 360ERROR DE CIERRE 1 45 0 1.75CORRECCION ANGULAR 0.4375

CONDICIONES PARA EL CALCULO DEL RUMBOS -W N - W RUMBO

-12.6222222222222 192.622222222222-56.0555555555556 236.055555555556-112.231944444444 292.231944444445-110.123611111111 290.123611111111

0 1.473888888888890 46.83361111111110 13.1138888888889

22.2794444444444 157.720555555556-23.5425 203.5425

79.4069444444444 100.593055555556-81.3252777777778 261.325277777778-125.144166666667 305.144166666667-12.6222222222223 192.622222222222

Page 4: hoja de calculo

0 0 12.62222220 0 56.05555560 0 67.76805560 0 69.87638890 1.47388888888889 1.473888890 46.8336111111111 46.83361110 13.1138888888889 13.1138889

22.2794444444444 0 22.27944440 0 23.5425

79.4069444444444 0 79.40694440 0 81.32527780 0 54.85583330 0 12.6222222

Page 5: hoja de calculo

CALCULOS DE CARTERA TOPOGRAFICA PARA LEVANTAMIENTOS POLIGONAL (POLIGONAL CERRADA)

PRESENTADA A : INGENIERA CLAUDIA YANETH ACERO ALVAREZ, PRESENTADA POR: JORGE LEONARDO MATEUS RIVERA ;COD 200820202

ANG.EXT.CORREGIDODIST

PROYECCIONESG M S DEC N

73.73 065 087 32.9170533

82 29 55 82.4986111111111 58.78 20.223062654 34 54 54.5816666666667 67 66.977833165 23 54 65.3983333333333 98 67.04369797 0 35 97.0097222222222 63.15 61.50311123 45 12 23.7533333333333 43 023 17 28 23.2911111111111 78 092 31 15 92.5208333333333 59.4 076 23 43 76.3952777777778 34 078 23 54 78.3983333333333 65 37.416324187 58 15 87.9708333333333 73.73 0

PERIMETRO 255.06

360 SUMATORIAS 81.7261735360 ERROR DE CIERRE

0 CONSTANTE DE CORRECCION

area distancias15082599.4219853 14785145.6709863 -71.618109715140171.5532603 14928358.8226575 20.486141315133929.2292442 15392913.8426612 61.7857483

15031961.3396771 15290293.7929737 -10.6537799Sumatoria 60388661.5441668 60396712.1292787

GRADO DE PRECISIÓN 1404.4874722

perimetro del terreno 261.447708653761

area del terreno (m2) 4025.29255594686

Page 6: hoja de calculo

PROYECCIONES PROYECCIONES CORREGIDAS COORDENADASS E W N S E W N

500071.9480994 16.1116075 0 0 71.6181097 16.5198844 0 4928.3818936.2952709 53.9226604 0 0 36.2952709 53.9226604 0 4963.70473

0 80.532401 0 32.9170533 0 80.532401 0 5032.917050 55.1916311 0 20.4861413 0 55.5171229 0 4948.868030 0 1.72333225 66.9778331 0 0 1.72333225 4995.359720 0 71.4782673 67.043697 0 0 71.4782673 4995.425590 0 14.3279393 61.7857483 0 0 13.9782487 5010.65378

39.7898691 0 16.3023408 0 39.7898691 0 16.3023408 4909.0781671.5075954 31.1554778 0 0 71.5075954 31.1554778 0 4877.3604410.9196335 0 58.3876837 0 10.6537799 0 58.0587586 50005.12803985 33.6110578 0 0 5.12803985 33.6110578 0 5005.52574

0 53.1509049 0 37.4163241 0 53.1509049 0 5048.070171.9480994 16.1116075 0 0 71.6181097 16.5198844 0 4928.38189

82.8677329 71.3032386 72.7156229 82.2718896 82.2718896 72.0370073 72.0370073-1.14155936 -1.41238432 0 0-0.00447565 -0.00553746

distancias16.5198844 5129.15363 272.90658 73.498708955.5171229 1750.91646 3082.15094 69.5202661

-13.9782487 2006.43506 195.391437 46.9236241

-58.0587586 1742.16124 3370.81945 71.5051095

CARTERA DE CAMPOESTACION PUNTO AZIMUT ANGULO EXTERNO

G M S G M SA

B 167 22 401 123 56 402 67 45 65

Page 7: hoja de calculo

B C 82 3 403 54 34 544 65 23 54

C D 96 34 205 23 45 126 23 17 28

D A 92 5 07 76 23 438 78 23 54

A B 87 32 0

Page 8: hoja de calculo

COORDENADAS COORDENADAS CONCATENADASE

3000 3000,50003016.51988 3016.51988439706,4928.381890328763053.92266 3053.92266044678,4963.70472909123

3080.5324 3080.53240096259,5032.917053258173072.03701 3072.03700731283,4948.868031626263014.79655 3014.79655214404,4995.359723422592945.04162 2945.0416171343,4995.425587341333058.05876 3058.05875859473,5010.653779892363055.73467 3055.7346665016,4909.07816251273103.19249 3103.19248508192,4877.36043619067

30003091.669823111.209663016.51988

CARTERA DE CAMPO

DISTobservaciones

73.73 Vertice poligonal65 Edificio87 Edificio

Page 9: hoja de calculo

58.78 Vertice poligonal67 Edificio98 Edificio

63.15 Vertice poligonal43 Edificio78 Edificio

59.4 Vertice poligonal34 Edificio65 Edificio

73.73 Vertice poligonal