senati poligonal.xlsx

13
Nota: Ingresar sólo los campos con letras en rojo ESPECIALIDAD UNIVERSIADAD CONTINENTAL DE CIENCIAS E INGENIERIA CURSO TOPOGRAFIA 2 LADO ESTACION ESTADIA ANGULO HORZONT. ANGULO VERTICAL G M S G M S AZAB N-A-B 202 44 20 1 A G-A-B 29.90 126 35 35 91 56 21 2 B A-B-C 45.20 156 48 14 96 15 22 3 C B-C-D 105.50 56 36 40 87 56 09 4 D C-D-E 27.10 92 41 52 88 41 40 5 E D-E-F 19.00 220 04 41 89 27 03 6 F E-F-G 36.20 47 45 15 87 58 51 7 G F-G-A 36.10 199 27 45 89 56 47 8 9 10 11 12 13 14 15 16 17 18 19 20 ANGULO ANGULO HORZONT. ANGULO ANGULO G M S HORZ. AZAB 202 44 20 AZAB 202°44'20'' A 126 35 35 A 126°35'35'' B 156 48 14 ANGULOS EN DECIMALES= B 156°48'14'' C 56 36 40 C 56°36'40'' D 92 41 52 D 92°41'52'' E 220 04 41 E 220°4'41'' F 47 45 15 F 47°45'15'' G 199 27 45 G 199°27'45'' CALCULOS DE TOPOGRAFIA DATOS DE CAMPO

Upload: frankespinoza

Post on 02-Oct-2015

13 views

Category:

Documents


2 download

DESCRIPTION

senati

TRANSCRIPT

PLANILLA MEJORADANota: Ingresar slo los campos con letras en rojoESPECIALIDADUNIVERSIADAD CONTINENTAL DE CIENCIAS E INGENIERIACURSOTOPOGRAFIA 2LADOESTACIONESTADIAANGULO HORZONT.ANGULO VERTICALALTURAGMSGMSINSTRUMENAZABN-A-B20244201AG-A-B29.9012635359156211.452BA-B-C45.2015648149615221.533CB-C-D105.505636408756091.544DC-D-E27.109241528841401.515ED-E-F19.0022004418927031.526FE-F-G36.204745158758511.507GF-G-A36.1019927458956471.472891011121314151617181920

ANGULOANGULO HORZONT.ANGULOANGULOANGULOGMSHORZ.HORZ.DECIMAZAB2024420AZAB20244'20''202.7388888889A1263535A12635'35''126.5930555556B1564814ANGULOS EN DECIMALES=B15648'14''156.8038888889C563640C5636'40''56.6111111111D924152D9241'52''92.6977777778E2200441E2204'41''220.0780555556F474515F4745'15''47.7541666667G1992745G19927'45''199.4625GMSEn Decim.TOLERANCIA DE EQUIPO00100'1''0.0002777778

Numero de lados7

Sumatoria de angulos internos =9000'0''900

SUMA DE ANGULOS INTERNOS9000'2''900.0005555556Error de Angulo Interno-00'2''-0.0005555556TOLERANCIA00'2.65''0.0007349309POR LO TANTO EST DENTRO DE LA TOLERANCIA!

compensacion angulo interno-00'0.29''-0.0000793651

ANGULOS COMPENSADOS

ANGULOANGULOANGULOHORZ.HORZ.DECIMAZAB20244'20''202.7388888889A12635'34.71''126.5929761905B15648'13.71''156.8038095238C5636'39.71''56.611031746D9241'51.71''92.6976984127E2204'40.71''220.0779761905F4745'14.71''47.7540873016G19927'44.71''199.4624206349SUMA DE ANGULOS COMPENSADOS9000'0''900

ANGULOANGULOANGULO DEAZIMUT DECIM.AZIMUTRUMBOHORZ.DECIMAZIMUTSAZAB202.7388888889A126.5929761905AzAB202.738888888920244'20''S2244'20''W0B156.8038095238AzBC179.542698412717932'33.71''S027'26.29''EC56.611031746AzCD56.1537301587569'13.43''N569'13.43''ED92.6976984127AzDE328.851428571432851'5.14''N318'54.86''WE220.0779761905AzEF8.9294047619855'45.86''N855'45.86''EF47.7540873016AzFG236.683492063523641'0.57''S5641'0.57''WG199.4624206349AzGA256.14591269842568'45.29''S768'45.29''W

ANGULOANGULO VERTICALANGULOANGULOGMSVERT.DECIMA915621A91.93916666673.830798611111111B961522B96.25611111114.010671296296296C875609C87.93583333333.6639930555555558D884140D88.69444444443.6956018518518516E892703E89.45083333333.7271180555555556F875851F87.98083333333.665868055555556CALCULO DE COTASG895647G89.94638888893.7477662037037036

CALCULOSCOTA PARTIDA3200.00ANGULOLADOESTADIAANG. REDUC (DECIMALES)
Alex: ANGULO ALFA REDICIFOANG. REDUCIDO (GRADOS)DISTANCIA HORIZONTALDISTANCIA VERTICALLADODISTANCIA VERTICALCOTAAA-B29.90-1.93916666670.0807986111111110429.8658-1.0112A3200.000BB-C45.20-6.25611111110.2606712962962962644.6632-4.8962A-B-1.01123198.989CC-D105.502.06416666670.08600694444444439105.36313.7975B-C-4.89623194.093DD-E27.101.30555555560.05439814814814821627.08590.6173C-D3.79753197.890EE-F19.000.54916666670.02288194444444435818.99830.1821D-E0.61733198.507FF-G36.202.01916666670.0841319444444443136.15511.2747E-F0.18213198.689GG-A36.100.05361111110.002233796296296238536.10000.0338F-G1.27473199.964G-A0.03383199.998

TOLERANCIA DE TRABAJO

CALCULO DE COTAS (Error de Cotas)0.00208

Correccion de Error de Cierre (COMPENSADO COTAS)0.000296909PERIMETRO (DISTANCIA HORIZONTAL)298.2314PERIMETRO EN KILOMETROS0.2982314FACTOR DE TOLERANCIA0.0200000ERROR MAXIMO(Para Cotas)0.0109221125toma el valor + y/o -POR LO TANTO EST DENTRO DE LA TOLERANCIA!

COTAS COMPENSADAS

PUNTODIST. VERTICAL COMPENSADOSCOTA COMPENSADOSA3200.000A-B-1.01093198.989B-C-4.89593194.093C-D3.79783197.891D-E0.61763198.509E-F0.18243198.691F-G1.27503199.966G-A0.03413200.000

LADOAZIMUTSDISTANCIAxyHORIZONTALSen(Az)*DH)Cos(Az)*DHzA-B202.738888888929.8658-11.5441-27.5445B-C179.542698412744.66320.3565-44.6618C-D56.1537301587105.363187.507858.6837D-E328.851428571427.0859-14.010423.1809E-F8.929404761918.99832.948918.7680F-G236.683492063536.1551-30.2129-19.8587G-A256.145912698436.1000-35.0498-8.6441298.2314-0.0041-0.0764

SUMA DE COORDENADASxy-0.00414-0.0764CALCULO DE ERROR LINEAL0.07655ERROR RELATIVO1/3895.8

CORRECCIONESC.X= (-X/P)*d0.0000139C.Y= (-Y/P)*d0.0002563C.X0.0000139C.Y0.0002563

C.X0.0000139C.Y0.0002563CALCULANDO CORRECIN DE LAS DISTANCIASLADODISTANCIAC.XC.YLADOLADOHORIZONTAL0.000013890.00025631xyxyA-B29.86580.0004150.007655A-B-11.5441-27.5445A-B-11.54366-27.53682B-C44.66320.0006200.011448B-C0.3565-44.6618B-C0.35709-44.65038C-D105.36310.0014640.027005CORRECION= C-D87.507858.6837CORRECION=C-D87.5092358.71074D-E27.08590.0003760.006942D-E-14.010423.1809D-E-14.0100723.18787E-F18.99830.0002640.004869E-F2.948918.7680E-F2.9491218.77287F-G36.15510.0005020.009267F-G-30.2129-19.8587F-G-30.21244-19.84939G-A36.10000.0005010.009253G-A-35.0498-8.6441G-A-35.04927-8.634890.0036550.06744335.04568.567735.049278.63489

CUADRO DE CORRECIONESLADODISTANCIAC.XC.YxyxyHORIZONTAL0.000013890.00025631A-B29.86580.0004150.007655-11.5441-27.5445-11.54366-27.53682B-C44.66320.0006200.0114480.3565-44.66180.35709-44.65038C-D105.36310.0014640.02700587.507858.683787.5092358.71074D-E27.08590.0003760.006942-14.010423.1809-14.0100723.18787E-F18.99830.0002640.0048692.948918.76802.9491218.77287F-G36.15510.0005020.009267-30.2129-19.8587-30.21244-19.84939G-A36.10000.0005010.009253-35.0498-8.6441-35.04927-8.6348935.049278.63489

LADOCxCy

A-B-11.5437-27.536820B-C0.3571-44.650376C-D87.509258.710740D-E-14.010123.187865E-F2.949118.772872F-G-30.2124-19.849392G-A-35.0493-8.634888SUMA 35.058.63CORRECION5000.0010000.00LADOANGULOLADOESTE NORTEC.XC.YC.XC.YXYA-B-11.5437-27.536820A5000.0010000.00B-C0.3571-44.650376BA-B-11.5437-27.53684988.469972.46C-D87.509258.710740CB-C0.3571-44.65044988.819927.81D-E-14.010123.187865DC-D87.509258.71075076.329986.52E-F2.949118.772872ED-E-14.010123.18795062.3110009.71F-G-30.2124-19.849392FE-F2.949118.77295065.2610028.48G-A-35.0493-8.634888GF-G-30.2124-19.84945035.0510008.63AG-A-35.0493-8.63495000.0010000.00SUMA 35.04938.634888

ANGULOESTE NORTECOTA

A5000.0010000.003200.000B4988.469972.463198.989C4988.819927.813194.093D5076.329986.523197.891E5062.3110009.713198.509F5065.2610028.483198.691G5035.0510008.633199.966A

CALCULOS DE TOPOGRAFIADATOS DE CAMPOCOMPENSADO ANGUNLOS INTERNOSAZIMUTS Y RUMBOSDISTANCIA HORIZONTAL, VERTICAL Y COTASCOMPENSACION DE COTASCORRECIONESCOORDENADAS PARCIALESCOORDENADAS CUADRO DE RESUMENCALCULO DE COORDENADAS