hoja calculo de Trabajo Topografico

Post on 13-Sep-2015

219 views 4 download

description

Trabajo Topografico

Transcript of hoja calculo de Trabajo Topografico

Hoja1TRIANGULACIONcompensacion por el metodo "minimos cuadrados"ANG CORREGIDOnum.gardosminseggradosradseno()log()EC"d"d^2DKVseg corregidosgradosseg para sumargradosminseg1334204'33.701111111111110.58819535050.5548605611-0.25581614333.15697660119.96650126010.61314337011.7031760280028643E-433.701281428713910.613143370081031133424.6131433700810322293808'29.6355555555555550.51723802020.4944813466-0.30585008670.00166666666666515083.701055148613.6978092132-0.05945897281.07802556481.46730067144.075835198349751E-429.635963139075391.467300671405910329389.467300671405913494815'49.804166666666670.86924668970.7638429657-0.11699591651.77904786143.16501129310.92998488922.583291358930208E-449.804424995802560.9299848892148749494815.9299848892148754665130'66.858333333333331.16689804920.9195359386-0.0364312924-2.7777777777515666E-40.89989633370.80981341132.30448648760.0716856171.26364326643.5101201843327335E-466.858684345351761.263643266359784665131.2636432663597865215441'21.911388888888890.38242587980.3731722046-0.42809071175.234672981127.40180121940.35436948319.843596752837883E-521.911487324856420.35436948310216376215441.354369483102166412532'41.4255555555555550.7230123390.6616463706-0.17937406552.7777777776805124E-42.38610794615.6935111303-2.3639454603-0.07353699791.30352602083.6209056132246846E-441.425917646116881.3035260207608865412533.303526020760884785437'85.076944444444451.48487279830.9963108442-0.00160514270.18136530750.03289337481.12897379283.1360383133216107E-485.077258048275781.1289737927957885438.128973792795788313507'31.5852777777777760.55126709250.5237670364-0.2808618376-9.36804471818323.424462295611.726942013772.494282916-0.12454846121.57807407214.383539089236641E-431.58571613168671.578074072125190731358.57807407212519355297174'359.9983333333sumasuma corregida360.0007330598794355297180.03595954'360000'

para hallar "d"Ngardosminseggradosradseno()log()133.042.003'33.70083333330.58819050240.5548565277-0.2558193002229.038.007'29.63527777780.5172331720.4944771326-0.3058537878349.048.014'49.80388888890.86924184150.7638398367-0.1169976955466.051.029'66.85805555561.16689320110.9195340332-0.0364321923521.054.040'21.91111111110.38242103170.3731677067-0.4280959464641.025.031'41.42527777780.72300749090.6616427354-0.1793764516785.0436'85.07666666671.48486795010.9963104281-0.001605324831.035.006'31.5850.55126224430.5237629065-0.2808652621

182.63901556584563

Hoja2compensacion por el metodo de "aproximaciones sucesivas"correccionesnum.gardosminseggradosradseno()log()cal. Errlogsen()+101 correccion2 correccion3 correccion4 correcciontotalang compen1334204'33.701111111111110.58819535050.5548605611-0.25581614333.15697660119.74418385671.3888888888757833E-42.0833333333314386E-42.0833333333314386E-4-0.000001171-0.0000011713.460512166309493E-433.7014571623277433.042.05.2457843798708842293808'29.6355555555555550.51723802020.4944813466-0.30585008670.53.70105514869.6941499133-2.7777777777515666E-41.3888888888757833E-42.0833333333314386E-40.0000011713.483932278104951E-429.63590394878336629.038.09.2542156201159293494815'49.804166666666670.86924668970.7638429657-0.11699591651.77904786149.8830040835-1.3888888888402562E-42.0833333333314386E-4-0.0000011710.00006827349.8042349401055249.048.015.2457843798839584665130'66.858333333333331.16689804920.9195359386-0.0364312924-0.50.89989633379.96356870762.7777777776805124E-4-1.3888888888402562E-42.0833333333314386E-40.0000011710.00007061566.8584039487833866.051.030.254215620154815215441'21.911388888888890.38242587980.3731722046-0.42809071175.23467298119.5719092883-1.3888888888757833E-42.0833333333314386E-4-0.0000011710.00006827321.91145716232774621.054.041.245784379886746412532'41.4255555555555550.7230123390.6616463706-0.17937406550.752.38610794619.8206259345-1.3888888888757833E-42.0833333333314386E-40.0000011710.00007061541.4256261710055941.025.032.254215620122295785437'85.076944444444451.48487279830.9963108442-0.00160514270.18136530759.99839485731.3888888888402562E-42.0833333333314386E-4-0.0000011713.460512166273966E-485.0772904956610785.04.038.2457843798681558313507'31.5852777777777760.55126709250.5237670364-0.2808618376-9.36804471823.42446229569.71913816241.3888888888402562E-42.0833333333314386E-40.0000011713.483932278069424E-431.58562617100558331.035.08.254215620097227355297174'359.9983333333suma20.763584475139.197492085939.1974827178suma360.0355.0297.0180.03595954'360.00.00.0para hallar "d" disminuido en -1'Ngardosminseggradosradseno()log()133.042.003'33.70083333330.58819050240.5548565277-0.2558193002229.038.007'29.63527777780.5172331720.4944771326-0.3058537878349.048.014.049.80388888890.86924184150.7638398367-0.1169976955466.051.029.066.85805555561.16689320110.9195340332-0.0364321923521.054.040.021.91111111110.38242103170.3731677067-0.4280959464641.025.031.041.42527777780.72300749090.6616427354-0.1793764516785.0436.085.07666666671.48486795010.9963104281-0.001605324831.035.006'31.5850.55126224430.5237629065-0.2808652621

Hoja3