radiación para carreteras

Upload: jair-chileno

Post on 09-Jan-2016

214 views

Category:

Documents


0 download

DESCRIPTION

hoja excel para calcular coordenadas de puntos lecturados con teodolito

TRANSCRIPT

Hoja1LEVANTAMIENTO TOPOGRAFICO DE CARRETARA 2KMPROYECTO: Levantamiento Topografico RadiacionPROPIEDAD: UNIVERSIDAD PERUANA UNIONLUGAR: CIUDAD UNIVERSITARIA - CHULLUNQUIANIFECHA: 20/11/12TOPOGRAFO'S: Grupo Amarillo CatINSTRUMENTO: TEODOLITO, MIRA, BRUJULA, GPS

ESTAP. OBSHSHID.I.Angulo HorizontalAngulo VerticalOBSDistancia DistanciaAng. HorizAzimutAzimutProyeccion ParcialCoordenadas TotalesGradosMinSegGradosMinSegHorizontalVertical (Z)Sexag.Sexag.RadEste (X)Norte (Y)Este (X)Norte (Y)Altura (Z)PI-137323782843103936PI-11.50
Ingenieria 02: NOTA: ingresar Altura de InstrumentoNM00000'00000'EstacaA2803275820851930Relleno278.1422.75327.97327.975.72-147.506235.805373089.4948284545.8053958.745A2633950

A373089.4948284545.8053958.745API-1000Cambio de Base0.00B441800084750Relleno43.544.48180.00327.975.72-23.09136.913373066.4038284582.7173963.221B

B373066.4038284582.7173963.221BA000Cambio de Base0.00C24818000852710Relleno246.4419.60180.00327.975.72-130.695208.931372935.7088284791.6483982.821C

C372935.7088284791.6483982.821CB0000.00PI-210818000815850Cambio de Base105.9014.92180.00327.975.72-56.16189.779372879.5478284881.4273997.740PI-2

PI-2372879.5478284881.4273997.740PI-2C000Cambio de Base0.00D96642330954330Relleno95.04-9.5364.39212.363.71-50.877-80.281372828.6708284801.1463988.212D

D372828.6708284801.1463988.212DPI-2000Cambio de Base0.00E2701800097610Relleno265.87-33.13180.00212.363.71-142.320-224.573372686.3518284576.5743955.083E

E372686.3518284576.5743955.083ED000Cambio de Base0.00F25618000925740Relleno255.32-13.21180.00212.363.71-136.670-215.657372549.6818284360.9163941.876F

F372549.6818284360.9163941.876FE000Cambio de Base0.00PI-320418000871750Relleno203.559.61180.00212.363.71-108.957-171.929372440.7248284188.9883951.485PI-3

PI-3372440.7248284188.9883951.485PI-3F000Cambio de Base0.00G104240530871750Relleno103.774.90240.88273.254.77-103.6025.878372337.1218284194.8663956.383G

G372337.1218284194.8663956.383GPI-3000Cambio de Base0.00PI-426018000865040Relleno259.2114.29180.00273.254.77-258.79614.683372078.3258284209.5483970.674PI-4

PI-4372078.3258284209.5483970.674PI-4G000Cambio de Base0.00H89.2125410903830Relleno89.19-1.00125.07218.323.81-55.298-69.977372023.0288284139.5713969.675H

H372023.0288284139.5713969.675HPI-4000Cambio de Base0.00I11218000924210Relleno111.75-5.28180.00218.323.81-69.286-87.679371953.7418284051.8923964.399I

I371953.7418284051.8923964.399IH000Cambio de Base0.00J2618000881135Relleno25.970.82180.00218.323.81-16.104-20.379372006.9248284119.1923970.494J

J372006.9248284119.1923970.494I000Cambio de Base0.00K2118000911650Relleno20.99-0.47180.00218.323.81-13.014-16.468372010.0148284123.1033969.206

372010.0148284123.1033969.206

Hoja2NUMBEREASTINGNORTHINGELEVATION137323782843103936373237;82843102373089.4948284545.8053958.745373089.49391506;8284545.804615663373066.4038284582.7173963.221373066.40340132;8284582.717328244372935.7088284791.6483982.821372935.708147221;8284791.64799155372879.5478284881.4273997.740372879.547215098;8284881.427386156372828.6708284801.1463988.212372828.67029554;8284801.14639427372686.3518284576.5743955.083372686.350512326;8284576.573572768372549.6818284360.9163941.876372549.680796573;8284360.916248269372440.7248284188.9883951.485372440.723524934;8284188.9876424510372337.1218284194.8663956.383372337.121386758;8284194.8655592311372078.3258284209.5483970.674372078.325417804;8284209.5484721212372023.0288284139.5713969.675372023.027703865;8284139.5712817913371953.7418284051.8923964.399371953.741295022;8284051.8919208714372006.9248284119.1923970.494372006.923542057;8284119.1920668915372010.0148284123.1033969.206372010.014053547;8284123.10299368