ID Dilci usek Vzdalenost Rychlost teplota zmena od pocatku "Onacit jednotlive zaznamy jejich ID (1,2,3,…nebo i jinak)" 3 65 -17.5 Zjistit celkovou vzdalenost 3 71 -17.4 0.1 Zjistit prumernou dilci vzdalenost 13 82 -17.2 0.3 "Prumernou, max a min rychlost. Které ID je max a které je min." 3 65 -17.0 0.5 Spocitat zmenu teploty oproti prvnimu zaznamu 11 85 -17.1 0.4 6 68 -17.1 3 78 -17.1 8 77 -16.5 16 70 -16.2 14 79 -16.1 3 67 -16.1 11 64 -15.9 15 88 -15.9 3 72 -15.9 6 58 -15.8 19 68 -15.7 5 85 -15.7 3 82 -15.6 3 81 -15.3 4 78 -15.1 5 93 -14.9 18 69 -14.9 11 47 -14.8 20 51 -14.6 7 72 -14.6 3 65 -14.6 8 57 -14.7 19 67 -14.6 7 78 -14.5 17 71 -14.4 3 55 -14.4 4 56 -14.3 19 68 -14.1 9 73 -13.9 2 79 -13.7 17 77 -13.9 2 68 -13.8 4 60 -13.7 3 70 -13.9 13 80 -14.2 11 59 -14.3 2 54 -14.3 4 62 -14.4 21 75 -14.5 7 65 -14.7 8 60 -14.9 3 75 -14.8 3 50 -14.6 4 62 -14.6 8 59 -14.4 11 73 -14.4 20 60 -14.1 16 66 -13.7 10 49 -13.7 4 65 -13.7 2 76 -13.7 9 59 3 63 -13.6 8 66 -12.4 3 47 -12 6 64 -11.2 7 66 -10.5 5 53 -10.2 3 54 -9.4 6 54 -8.1 3 58 -7.6 5 61 -7.4 4 61 -7.5 5 61 -7.5 2 69 -7.5 5 53 -7.4 14 44 -7.7 6 71 -7.9 5 79 -7.2 5 53 -7.3 8 53 -8 10 51 -7.9 8 37 -8.4 14 69 -8.2 16 50 -7 5 69 -6.9 3 57 -7.3 4 35 -7.7 18 49 -7.6 4 74 -7.5 4 77 -7.4 3 47 -7.4 7 62 -7.4 12 56 -7.4 18 54 -7.6 20 56 -7.9 13 56 -7.5 12 51 -7.7 15 47 -8 13 56 -7.4 9 69 -7.2 13 61 -7.2 6 60 -7.4 3 56 -7.2 7 55 -7 ##### Sheet/List 2 ##### rok_season lok As_prim_data Cd_prim_data Co_prim_data Cr_prim_data Cu_prim_data Ni_prim_data Pb_prim_data J05 ZL 1 5.647 0.264 15.534 39.25 24.87 56.07 27.18 J05 ZL 10 5.4 0.57 9.2 29.3 21.6 28.6 18.8 Převeďte do podoby: J05 ZL 11 7.3 0.55 11.1 41.8 29.9 34.8 22.7 V řádcích jsou lokality J05 ZL 12 9.0 2.32 11.3 163.6 43.7 44.3 32.9 "Ve sloupcích jsou kovy tak, že pro každý kov jsou všechna 4 období za sebou" J05 ZL 13 8.3 1.10 12.0 93.0 37.3 40.5 31.5 "tj. As jaro 2005, As podzim 2005, As jaro 2006, As podzim 2006" J05 ZL 14 5.3 0.34 9.0 39.7 23.1 32.6 14.3 "Jak si sloupce označíte je na vás, musíte ale vědět co je to za kov a období" J05 ZL 2 5.843 0.449 14.657 37.16 29.89 54.57 25.79 J05 ZL 3 3.368 0.200 8.384 20.10 16.70 29.12 18.15 J05 ZL 4 3.802 0.178 8.751 21.30 15.57 32.87 14.55 J05 ZL 5 4.727 0.251 9.493 25.63 23.64 32.44 19.73 J05 ZL 6 3.386 0.208 8.347 22.12 17.84 30.16 17.28 J05 ZL 7 5.230 0.391 10.985 39.49 41.73 42.47 26.01 J05 ZL 8 6.266 0.489 12.930 49.84 45.03 50.70 26.31 J05 ZL 9 3.625 0.352 7.811 27.29 30.47 27.75 16.16 J06 ZL 1 5.664 0.383 13.870 42.37 32.93 56.43 25.04 J06 ZL 10 6.568 0.428 9.278 34.74 23.59 28.46 24.94 J06 ZL 11 6.053 0.260 8.480 30.47 17.86 25.52 21.14 J06 ZL 12 4.082 0.241 6.875 22.47 13.45 20.05 20.08 J06 ZL 13 10.170 2.904 11.530 262.80 45.05 42.14 41.46 J06 ZL 14 4.036 0.295 6.715 30.06 14.95 19.87 16.13 J06 ZL 2 5.226 0.195 12.310 31.15 30.16 46.82 29.27 J06 ZL 3 3.656 0.127 7.871 18.80 18.15 29.09 12.37 J06 ZL 4 4.520 0.164 9.643 27.86 33.38 38.28 23.10 J06 ZL 5 4.654 0.191 8.388 23.43 22.66 29.09 19.69 J06 ZL 6 4.915 0.182 8.606 24.21 31.06 30.53 22.64 J06 ZL 7 4.686 0.608 8.698 35.72 41.44 35.68 26.30 J06 ZL 8 9.949 0.522 12.660 70.24 42.48 44.01 32.14 J06 ZL 9 6.673 0.591 10.390 54.76 44.78 36.22 34.95 P05 ZL 1 7.367 0.212 19.191 47.44 38.06 67.01 21.28 P05 ZL 10 7.243 0.503 10.856 38.10 36.72 33.24 24.26 P05 ZL 11 7.052 0.522 10.758 40.38 35.66 41.33 23.88 P05 ZL 12 12.301 4.191 14.111 239.24 66.06 60.47 47.06 P05 ZL 13 12.108 3.539 10.955 255.20 53.19 42.51 37.46 P05 ZL 14 5.048 1.027 7.431 31.47 29.22 24.23 15.44 P05 ZL 2 5.148 0.337 13.268 44.50 49.76 54.02 25.97 P05 ZL 3 4.961 0.153 7.543 22.03 30.99 30.22 18.88 P05 ZL 4 3.472 0.147 8.750 22.09 28.08 32.85 14.16 P05 ZL 5 5.305 0.186 8.997 25.42 28.55 29.58 30.15 P05 ZL 6 3.001 0.122 7.375 19.40 24.30 26.04 12.02 P05 ZL 7 5.702 0.485 11.017 46.06 76.08 42.63 31.10 P05 ZL 8 5.809 0.509 9.805 43.90 48.35 35.01 22.33 P05 ZL 9 3.552 0.145 7.788 26.72 28.12 21.37 11.60 P06 ZL 1 5.114 0.223 12.950 47.57 28.95 53.78 19.65 P06 ZL 10 6.717 0.379 9.353 33.33 22.15 28.71 20.91 P06 ZL 11 6.342 0.407 8.675 29.66 21.95 27.07 21.18 P06 ZL 12 5.362 0.383 7.580 32.74 18.66 24.04 18.70 P06 ZL 13 10.890 2.202 11.940 175.70 45.30 43.70 41.64 P06 ZL 14 6.520 0.470 8.231 40.89 24.94 26.96 20.43 P06 ZL 2 5.699 0.219 10.740 30.51 35.01 44.21 29.94 P06 ZL 3 5.435 0.151 6.402 18.80 27.34 25.66 29.07 P06 ZL 4 5.374 0.395 11.480 45.87 60.24 51.07 30.75 P06 ZL 5 3.863 0.158 6.178 19.30 19.93 24.06 16.91 P06 ZL 6 4.219 0.258 8.188 28.84 37.29 33.90 24.54 P06 ZL 7 4.298 0.609 7.363 31.51 44.35 29.46 23.15 P06 ZL 8 8.001 0.624 9.951 53.07 39.89 35.83 27.90 P06 ZL 9 5.826 0.480 9.363 43.30 39.46 29.60 30.58