Laborator-5.docx

Aplicația Nr_5 Calculul Coordonatelor prin metoda Radierii - Programul Excel – Să se calculeze coordonatele punctelor utilizând metoda radierii. Date cunoscute: Coordonatele bazei

Punct

Coordonatele absolute

Cota

hp

X[m] Y[m] H[m] 1 586300.3760 393044.0400 344.681 100-123 2 586240.6860 392870.6340 345.901 124-125 126-130

Carnet de teren Măsurători Punct stație

ST. 1 1.65

Punct vizat 2 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119

L[m] 183.3940 152.8070 132.8250 116.1590 117.9700 104.8190 104.9350 103.3390 91.6950 86.6700 75.9920 76.0400 57.7530 57.8560 46.6860 46.7060 37.7700 36.6470 37.2170 41.9840 39.5330

V[g.c.cc] 100.1227 99.7751 99.9526 99.9300 99.9496 100.0106 100.0029 100.0244 100.1251 100.1341 100.1890 100.1703 100.6730 100.4529 100.6675 100.6314 101.2498 101.6766 101.3426 101.0913 101.4930

Hz [g.c.cc] 278.896 278.701 284.811 287.035 285.469 287.599 288.331 287.893 286.559 288.89 289.829 290.762 288.758 292.339 295.034 295.435 302.45 302.001 295.781 291.437 309.468

Distanța 1-2 2

0.1 0.1 1.5 2.3

183.3917581

120 121 122 123 124 125 126 127 128 129 130

42.4500 47.5180 48.1770 48.7470 51.9850 59.5460 59.6340 48.7370 31.3090 28.7440 22.3550

101.6364 101.8719 101.3983 101.9492 99.9543 100.2114 101.2592 101.2849 100.4427 100.1023 99.4458

318.215 328.178 329.025 329.764 333.905 341.011 342.894 343.168 311.301 305.367 304.675

Prelucrarea datelor: 1.Calculul distanței orizaontale.

D=L*cos((100-V)*pi()/200) 2.Calculul unghiului ω.

𝐻𝑧𝑛 − 𝐻𝑧2 + 𝐼𝑓(𝐻𝑧𝑛 − 𝐻𝑧2 > 400, −400,0) 3.Determinarea orientărilor.

𝛳1−2 = atan (

𝑌2− 𝑌1 200 + 𝐼𝑓(𝑋2 − 𝑋1 < 0,200, 𝐼𝑓(𝑌2− 𝑌1 < 0,400,0)) )∗ 𝑋2 − 𝑋1 𝑝𝑖( ) 𝛳𝑛 = 𝛳𝑢 + 𝜔 + 𝐼𝑓(𝛳𝑢 + 𝜔 > 0, −400,0)

4.Determinarea coordonatelor punctelor radiate. 𝑋 = 𝑋𝑎 + 𝐷 ∗ cos⁡(𝛳 ∗

𝑝𝑖( ) ) 200

𝑌 = 𝑌𝑎 + 𝐷 ∗ sin⁡(𝛳 ∗

𝑝𝑖( ) ) 200

𝐻 = 𝐻𝑎 + 𝐷 ∗ tan ((100 − 𝑉) ∗

𝑝𝑖( ) ) + 𝐻𝑎 − 𝐻𝑝 200

Prelucrarea datelor Distanța orizontala 183.3937 152.8060 132.8250 116.1589 117.9700 104.8190 104.9350 103.3390 91.6948 86.6698 75.9917 76.0397 57.7498 57.8545 46.6834 46.7037 37.7627 36.6343 37.2087 41.9778 39.5221 42.4360 47.4975 48.1654 48.7242 51.9850 59.5457 59.6223 48.7271 31.3082 28.7440 22.3542

w

Orientari

X

Y

H

399.8046 5.9148 8.1391 6.5726 8.7028 9.4345 8.9969 7.6630 9.9940 10.9325 11.8662 9.8619 13.4431 16.1378 16.5390 23.5539 23.1046 16.8850 12.5408 30.5722 39.3185 49.2816 50.1291 50.8681 55.0088 62.1151 63.9982 64.2720 32.4050 26.4710 25.7789

278.8950 278.6996 284.6144 292.7535 299.3261 308.0289 317.4634 326.4603 334.1233 344.1173 355.0498 366.9160 376.7779 390.2210 6.3588 22.8978 46.4517 69.5563 86.4413 98.9821 129.5543 168.8728 218.1544 268.2835 319.1516 374.1604 36.2755 100.2737 164.5457 196.9507 223.4217 249.2006

586240.6854 586250.1977 586268.5868 586287.1823 586299.1272 586313.5604 586328.8015 586342.1014 586347.2052 586355.7443 586358.1991 586366.3767 586354.3261 586357.5493 586346.8268 586344.0912 586328.5244 586317.2347 586308.2409 586301.0472 586282.6803 586262.9123 586254.7968 586277.3603 586314.8137 586348.1373 586350.5136 586300.1197 586259.0121 586269.1037 586273.5555 586284.3720

392870.6322 392899.7076 392915.0752 392928.6328 392926.0766 392940.0535 392943.0284 392949.4993 392965.2049 392977.3616 392994.7325 393006.2783 393023.4385 393035.1879 393048.6951 393060.4784 393069.2133 393076.5647 393080.4080 393086.0125 393079.3792 393063.9720 393030.6781 393001.7295 392997.5040 393023.5145 393076.1634 393103.6618 393069.7957 393045.5391 393033.7019 393028.4330

345.878 345.371 344.93 344.959 344.924 344.814 344.826 344.791 344.651 344.648 344.605 344.628 344.22 344.419 344.342 344.368 344.09 343.866 344.046 344.111 343.904 343.74 343.434 343.773 343.339 343.268 343.033 342.852 343.047 343.813 343.985 344.226