y1 y2 y3 y4 x1 3 1 8 0 0 6.480740698 11.22497216 12.08304597 6.557438524 8.660254038 7 8.485281374 1 9.055385138 x2 2 5 4 3 6.480740698 0 6.480740698 9.273618495 8.062257748 5.744562647 2.645751311 3.741657387 5.916079783 7.348469228 x3 0 8 6 8 11.22497216 6.480740698 0 7.348469228 13.45362405 3.605551275 4.582575695 8.124038405 11.09053651 10.95445115 x4 7 8 8 9 12.08304597 9.273618495 7.348469228 0 12.04159458 5.744562647 8.306623863 8.602325267 12.12435565 10.48808848 x5 8 0 4 1 6.557438524 8.062257748 13.45362405 12.04159458 0 11.13552873 9.899494937 6.8556546 6 5.744562647 x6 2 6 8 7 8.660254038 5.744562647 3.605551275 5.744562647 11.13552873 0 3.741657387 7.416198487 8.717797887 9.433981132 x7 1 6 6 4 7 2.645751311 4.582575695 8.306623863 9.899494937 3.741657387 0 5.744562647 6.782329983 9 x8 5 5 2 4 8.485281374 3.741657387 8.124038405 8.602325267 6.8556546 7.416198487 5.744562647 0 7.810249676 5.477225575 x9 3 1 7 0 1 5.916079783 11.09053651 12.12435565 6 8.717797887 6.782329983 7.810249676 0 8.426149773 x10 6 0 2 6 9.055385138 7.348469228 10.95445115 10.48808848 5.744562647 9.433981132 9 5.477225575 8.426149773 0 1.00 -0.43 -0.33 -0.06 3 2 0 7 8 2 1 5 3 6 -0.43 1.00 0.31 0.74 1 5 8 8 0 6 6 5 1 0 -0.33 0.31 1.00 0.07 8 4 6 8 4 8 6 2 7 2 -0.06 0.74 0.07 1.00 0 3 8 9 1 7 4 4 0 6 ##### Sheet/List 2 ##### Odkazy pomocí stylu A1 Odkazy pomocí pojmenovaných oblastí Text vzorového vzorce B5+C5 SUM(B5:C5) B6/B$5 Oblast pojmenovaná blok1 Lokalita Vojkovice Maloměřice Suma Součet Prevalence Prevalence 1 Počet ryb 31 35 66 66 5 Acanthocephalus anguilae 4 2 6 6 0.129032258 0.057142857 6 Apophalus muhlingi 0 1 1 1 0 0.028571429 1 Caryophylaeus brachycolis 1 0 1 1 0.032258065 0 2 cysta 0 1 1 1 0 0.028571429 8 Dactylogyrus folkmanovae 22 33 55 55 0.709677419 0.942857143 9 Dactylogyrus juvenil 0 8 8 8 0 0.228571429 5 Dactylogyrus nanoides 1 3 4 4 0.032258065 0.085714286 2 Dactylogyrus similis 0 0 0 0 0 0 Dactylogyrus sp_ 11 12 23 23 0.35483871 0.342857143 Součet oblasti blok1 Dactylogyrus vistulae 30 18 48 48 0.967741935 0.514285714 #NÁZEV? Dactylogyrus vranoviensis 0 0 0 0 0 0 SUM(blok1) Text vzorového vzorce Diplostomum spathaceum 5 3 8 8 0.161290323 0.085714286 Gyrodactylus gracilihamatus 0 3 3 3 0 0.085714286 Gyrodactylus hemibarbi 0 0 0 0 0 0 Gyrodactylus vimbi 0 1 1 1 0 0.028571429 Paradiplozoon ergensi 31 26 57 57 1 0.742857143 Philometra abdominalis 2 11 13 13 0.064516129 0.314285714 Philometra obturans 0 0 0 0 0 0 Piscicola geometra 6 3 9 9 0.193548387 0.085714286 Pomporhynchus laevis 15 16 31 31 0.483870968 0.457142857 Proteocephalus torulosus 1 0 1 1 0.032258065 0 Počet druhů parazitů 12 15 Text vzorového vzorce "COUNTIF(B6:B34;"">0"")" ##### Sheet/List 3 ##### Maticové vzorce Výpočet Euklidovské vzdálenosti mezi body Normální vzorec Normální vzorec 10 2 20 rozměr1 1 5 5 7 4 6 12 3 36 rozměr1 rozměr2 3 5 8 7 9 6 5 4 20 1 3 0 4.472135955 6.403124237 7.211102551 6.708203932 5.830951895 8 5 40 5 5 4.472135955 0 3 2.828427125 4.123105626 1.414213562 4 8 32 5 8 6.403124237 3 0 2.236067977 1.414213562 2.236067977 7 9 63 7 7 7.211102551 2.828427125 2.236067977 0 3.605551275 1.414213562 9 11 99 4 9 6.708203932 4.123105626 1.414213562 3.605551275 0 3.605551275 suma součinů řádků 310 6 6 5.830951895 1.414213562 2.236067977 1.414213562 3.605551275 0 Maticový vzorec Maticový vzorec 10 2 rozměr1 1 5 5 7 4 6 12 3 rozměr1 rozměr2 3 5 8 7 9 6 5 4 1 3 0 4.472135955 6.403124237 7.211102551 6.708203932 5.830951895 8 5 5 5 4.472135955 0 3 2.828427125 4.123105626 1.414213562 4 8 5 8 6.403124237 3 0 2.236067977 1.414213562 2.236067977 7 9 7 7 7.211102551 2.828427125 2.236067977 0 3.605551275 1.414213562 9 11 4 9 6.708203932 4.123105626 1.414213562 3.605551275 0 3.605551275 suma součinů řádků 310 6 6 5.830951895 1.414213562 2.236067977 1.414213562 3.605551275 0 Maticová funkce (nezbytné použití maticových vzorců) Součin matic 2 -3 -2 3 -3 -1 0 5 1 2 1 3 4 2 -19 3 -12 2 -3 3 13 6 3 2 14 -8 ##### Sheet/List 4 ##### y1 y2 y3 y4 x1 5 2 2 8 0 11.13552873 9.273618495 7.937253933 11.22497216 8.062257748 8.774964387 7.211102551 5.099019514 7.071067812 x2 0 7 7 1 11.13552873 0 6.480740698 7.549834435 6.164414003 7.937253933 9.949874371 10 8.602325267 4.69041576 x3 5 3 8 1 9.273618495 6.480740698 0 3 5.477225575 5.196152423 7.810249676 11.22497216 8.246211251 7.071067812 x4 4 1 8 3 7.937253933 7.549834435 3 0 5 2.449489743 9.055385138 11.18033989 7.416198487 6.8556546 x5 0 1 8 0 11.22497216 6.164414003 5.477225575 5 0 4.582575695 12.60952021 13.6381817 8.366600265 7.745966692 x6 2 0 8 4 8.062257748 7.937253933 5.196152423 2.449489743 4.582575695 0 10.86278049 11.61895004 7.280109889 6.8556546 x7 9 8 6 5 8.774964387 9.949874371 7.810249676 9.055385138 12.60952021 10.86278049 0 7.141428429 10.53565375 8.306623863 x8 4 9 3 9 7.211102551 10 11.22497216 11.18033989 13.6381817 11.61895004 7.141428429 0 9.055385138 6.164414003 x9 2 2 1 4 5.099019514 8.602325267 8.246211251 7.416198487 8.366600265 7.280109889 10.53565375 9.055385138 0 5.830951895 x10 1 6 5 5 7.071067812 4.69041576 7.071067812 6.8556546 7.745966692 6.8556546 8.306623863 6.164414003 5.830951895 0 1.00 0.27 -0.12 0.42 5 0 5 4 0 2 9 4 2 1 0.27 1.00 -0.23 0.37 2 7 3 1 1 0 8 9 2 6 -0.12 -0.23 1.00 -0.71 2 7 8 8 8 8 6 3 1 5 0.42 0.37 -0.71 1.00 8 1 1 3 0 4 5 9 4 5 ##### Sheet/List 5 ##### 1 2 3 4 5 6 7 8 9 10 1 0 1 7.211102551 8.124038405 8.306623863 6.244997998 6.782329983 8.366600265 6.8556546 4.795831523 1 1 2 3 5 6 8 98 5 9 2 1 0 7.416198487 8.774964387 8.94427191 6.164414003 7.141428429 8.888194417 7.348469228 4.472135955 0 12 3 7 4 8 7 8 5 4 3 7.211102551 7.416198487 0 11.04536102 5.916079783 5 7.071067812 4.69041576 9.848857802 8.062257748 0 0 5 6 8 9 7 8 9 2 4 8.124038405 8.774964387 11.04536102 0 11.70469991 10.81665383 11.40175425 12.24744871 3 9.110433579 0 0 0 5 4 8 5 4 1 3 5 8.306623863 8.94427191 5.916079783 11.70469991 0 7.348469228 4.795831523 1.732050808 10.86278049 10 0 0 0 0 4 6 5 9 8 8 6 6.244997998 6.164414003 5 10.81665383 7.348469228 0 4.795831523 7 8.485281374 4.242640687 0 0 0 0 0 9 2 4 5 9 7 6.782329983 7.141428429 7.071067812 11.40175425 4.795831523 4.795831523 0 5.477225575 9.539392014 6.708203932 0 0 0 0 0 0 8 3 5 6 8 8.366600265 8.888194417 4.69041576 12.24744871 1.732050808 7 5.477225575 0 11.35781669 10.04987562 0 0 0 0 0 0 0 8 8 4 9 6.8556546 7.348469228 9.848857802 3 10.86278049 8.485281374 9.539392014 11.35781669 0 6.480740698 0 0 0 0 0 0 0 0 5 2 10 4.795831523 4.472135955 8.062257748 9.110433579 10 4.242640687 6.708203932 10.04987562 6.480740698 0 0 0 0 0 0 0 0 0 0 4 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 2 0 2 0 0 0 0 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 3 0 0 8 0 0 0 0 0 0 0 3 0 0 1 0 0 0 0 0 0 0 4 0 0 0 6 0 0 0 0 0 0 4 0 0 0 1 0 0 0 0 0 0 5 0 0 0 0 9 0 0 0 0 0 5 0 0 0 0 1 0 0 0 0 0 6 0 0 0 0 0 11 0 0 0 0 6 0 0 0 0 0 1 0 0 0 0 7 0 0 0 0 0 0 22 0 0 0 7 0 0 0 0 0 0 1 0 0 0 8 0 0 0 0 0 0 0 1 0 0 8 0 0 0 0 0 0 0 1 0 0 9 0 0 0 0 0 0 0 0 6 0 9 0 0 0 0 0 0 0 0 1 0 10 0 0 0 0 0 0 0 0 0 3 10 0 0 0 0 0 0 0 0 0 1 1 2 3 4 5 6 7 8 9 10 1 2 3 4 5 6 7 8 9 10 1 7 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 0 7 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 3 0 0 7 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 4 0 0 0 7 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 5 0 0 0 0 7 0 0 0 0 0 5 0 0 0 0 0 0 0 0 0 0 6 0 0 0 0 0 7 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 7 0 0 0 7 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 0 0 7 0 0 8 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 0 7 0 9 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 0 0 7 10 0 0 0 0 0 0 0 0 0 0 9 4 7 9 6 6 6 4 8 4 4 1 6 1 0 7 8 0 ##### Sheet/List 6 ##### 8 3 9 3 0 7 0.600245048 1 0.085749293 1 11.66190379 0.085749293 1 6 0.514495755 7 0.600245048 7 6 ##### Sheet/List 7 ##### 6 8 9 9 9 9 7 3 15 17 16 12 5 8 7 7 0 8 4 4 5 16 11 11 9 0 2 5 7 5 8 4 16 5 10 9 1 2 4 7 8 2 5 7 9 4 9 14 2 8 4 0 2 8 9 6 4 16 13 6 0 8 9 4 0 0 9 1 0 8 18 5 3 9 0 7 102 9 b c 0 2 3 3 0 0 0 3 1 6 7 9 6 1 109 7 2 1 8 28 9 4 9 5 86 7 2 5 48 5 8 4 89 0 0 6 30 0 0 6 30 6 5 1 51 6 2 4 3 6 8 9 46 50 66 56 1 8 8 8 5 5 1 91 54 64 17 8 7 9 3 1 2 0 107 92 117 79 2 0 4 18 16 24 18 8 7 3 89 86 105 79 6 2 2 40 48 62 56 7 3 0 45 57 71 66 1 5 8 67 39 49 14 ##### Sheet/List 8 ##### 4 2 36 0 9 7 8 4 8 1 3 5 8 760 4 8 0 0 0 0 4 1 -4 2 -4 2 -6 3 -6 3 -8 4 -8 4 -1 -1 1 3 0 -2 4 1 -3 -1 -1 1 3 0 -2 0 4 1 -3 0 3 9 7 -0.294117647 -0.235294118 0.352941176 0.058823529 1 0 3 1 0.196078431 -0.176470588 -0.235294118 0.071895425 2 1 8 6 0.137254902 0.676470588 -0.264705882 -0.016339869 9 9 9 3 -0.117647059 -0.794117647 0.441176471 -0.009803922 ##### Sheet/List 10 ##### 9 0 9 7 1 3 2 1 10 3 11 8 0 2 7 2 5 1 6 5 5 3 13 7 0 0 7 7 4 4 7 1 4 4 14 8 4 8 5 9 0 6 3 7 4 14 8 16 9 6 7 8 6 7 0 9 15 13 7 17 9 6 5 1 2 0 9 0 11 6 14 1 7 1 3 0 25 1 b c 8 3 0 3 0 0 0 0 6 6 5 7 9 1 70 6 3 6 8 36 8 5 7 1 55 1 6 6 55 7 3 4 35 0 5 6 46 1 8 7 72 0 7 6 62 6 4 2 2 2 1 0 40 24 40 8 1 7 8 5 0 8 1 69 50 65 23 5 1 4 4 6 1 2 31 34 17 9 1 4 0 22 2 33 4 5 1 9 51 64 22 19 5 2 5 40 40 26 12 9 7 6 77 54 71 19 9 3 6 57 54 39 15