LOK SNIH VZOREK VRSTVA KOD Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. SUMIF součet pro vzorek Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. SUMIFS součet pro sjezdovku LOK SNIH Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. AVERAGEIF průměr pro vzorek Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. VI Z 1 0–3 VI-Z-1 2 2 3 VI-Z-1 7 14 4 5 VI Z 8 19 8 28 VI-Z-1 2.333333333 4.666666667 2 2.5 VI Z 1 3–6 VI-Z-1 1 8 1 2 VI-Z-2 1 5 4 23 VI N 1 2 0 2 VI-Z-2 1 2.5 2 7.666666667 VI Z 1 6–10 VI-Z-1 4 4 3 VI-N-1 0 0 0 0 RO Z 1 24 0 6 VI-N-1 #DIV/0! #DIV/0! #DIV/0! #DIV/0! VI Z 2 0–3 VI-Z-2 7 VI-N-2 1 2 0 2 RO N 1 5 0 0 VI-N-2 1 2 #DIV/0! 1 VI Z 2 3–6 VI-Z-2 1 4 1 9 RO-Z-1 1 0 0 5 RO-Z-1 1 #DIV/0! #DIV/0! 5 VI Z 2 6–9 VI-Z-2 1 3 7 RO-Z-2 0 24 0 1 RO-Z-2 #DIV/0! 12 #DIV/0! 1 VI N 1 0–3 VI-N-1 RO-N-1 1 4 0 0 RO-N-1 1 2 #DIV/0! #DIV/0! VI N 1 3–6 VI-N-1 RO-N-2 0 1 0 0 RO-N-2 NA 1 NA NA VI N 1 6–10 VI-N-1 VI N 2 0–3 VI-N-2 1 VI N 2 3–6 VI-N-2 VI N 2 6–9 VI-N-2 1 2 1 RO Z 1 0–3 RO-Z-1 5 RO Z 1 3–9 RO-Z-1 1 RO Z 2 0–3 RO-Z-2 RO Z 2 3–6 RO-Z-2 13 1 RO Z 2 "6–10,5" RO-Z-2 11 RO N 1 0–3 RO-N-1 RO N 1 3–6 RO-N-1 RO N 1 6–9 RO-N-1 3 RO N 1 9–12 RO-N-1 1 1 RO N 2 0–3 RO-N-2 RO N 2 3–6 RO-N-2 RO N 2 6–9 RO-N-2 RO N 2 9–x RO-N-2 1 ##### Sheet/List 2 ##### LOK SNIH VZOREK VRSTVA KOD Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. COUNTIF počet vrstev pro vzorek počet vrstev COUNTIF počet nenulových abundancí Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. "COUNTIFS počet ""obydlených"" vrstev pro vzorek" Enchytraeus sp. juv. Enchytronia parva Fridericia ?minor Fridericia spp. VI Z 1 0–3 VI-Z-1 2 2 3 VI-Z-1 3 7 11 4 9 VI-Z-1 3 3 2 2 VI Z 1 3–6 VI-Z-1 1 8 1 2 VI-Z-2 3 VI-Z-2 1 2 2 3 VI Z 1 6–10 VI-Z-1 4 4 3 VI-N-1 3 VI-N-1 0 0 0 0 VI Z 2 0–3 VI-Z-2 7 VI-N-2 3 VI-N-2 1 1 0 2 VI Z 2 3–6 VI-Z-2 1 4 1 9 RO-Z-1 2 RO-Z-1 1 0 0 1 VI Z 2 6–9 VI-Z-2 1 3 7 RO-Z-2 3 RO-Z-2 0 2 0 1 VI N 1 0–3 VI-N-1 RO-N-1 4 RO-N-1 1 2 0 0 VI N 1 3–6 VI-N-1 RO-N-2 4 RO-N-2 0 1 0 0 VI N 1 6–10 VI-N-1 VI N 2 0–3 VI-N-2 1 VI N 2 3–6 VI-N-2 VI N 2 6–9 VI-N-2 1 2 1 RO Z 1 0–3 RO-Z-1 5 RO Z 1 3–9 RO-Z-1 1 RO Z 2 0–3 RO-Z-2 RO Z 2 3–6 RO-Z-2 13 1 RO Z 2 "6–10,5" RO-Z-2 11 RO N 1 0–3 RO-N-1 RO N 1 3–6 RO-N-1 RO N 1 6–9 RO-N-1 3 RO N 1 9–12 RO-N-1 1 1 RO N 2 0–3 RO-N-2 RO N 2 3–6 RO-N-2 RO N 2 6–9 RO-N-2 RO N 2 9–x RO-N-2 1 ##### Sheet/List 3 ##### Vzorek Sezóna Rok LOK SNIH VZOREK VRSTVA KOD Achaeta spp. Achaeta spp. 1 pár pyriformních žláz Achaeta spp. 2 páry pyriformních žláz Achaeta spp. bez pyriformních žláz Achaeta affinis Achaeta camerani Achaeta danica Achaeta eiseni Achaeta unibulba Buchholzia appendiculata Cognettia spp. Cognettia chlorophila Cognettia sphagnetorum s. l. Enchytraeus buchholzi Enchytraeus bulbosus Enchytraeus lacteus Enchytraeus norvegicus Enchytraeus sp. juv. Enchytronia holochaeta Enchytronia parva (small diverticula) Enchytronia parva (large diverticula) Enchytronia spp. Fridericia anomala Fridericia bisetosa Fridericia bulboides Fridericia connata Fridericia cylindrica Fridericia deformis Fridericia dura Fridericia galba Fridericia lenta Fridericia maculata Fridericia ?minor Fridericia nemoralis Fridericia paranemoralis Fridericia paroniana Fridericia raxiensis Fridericia sylvatica Fridericia spp. Henlea perpusilla Henlea ventriculosa Hrabeiella periglandulata Marionina clavata Marionina minutissima Marionina simillima Marionina spp. Oconnorella cambrensis Oconnorella tubifera Stercutus niveus Enchytraeidae indet. POZNAMKY VI-Z1 0–3 jaro 2018 VI Z 1 0–3 VI-Z-1 2 2 1 1 3 "1x F. paroniana, 1x mrtvá Frid., 47 sgm" VI-Z1 3–6 jaro 2018 VI Z 1 3–6 VI-Z-1 1 8 1 1 1 2 VI-Z1 6–10 jaro 2018 VI Z 1 6–10 VI-Z-1 4 4 3 1 VI-Z2 0–3 jaro 2018 VI Z 2 0–3 VI-Z-2 2 2 7 VI-Z2 3–6 jaro 2018 VI Z 2 3–6 VI-Z-2 1 1 4 10 1 2 1 9 "1x F. paroniana, 1x F. minor?" VI-Z2 6–9 jaro 2018 VI Z 2 6–9 VI-Z-2 1 3 1 1 7 "3x F. minor? (Frid. Č. 5, 53 sgm; Frid. Č. 6, 46 sgm, Frid. Č. 7, 45sgm)" VI-Z3 0–3 jaro 2018 VI Z 3 0–3 VI-Z-3 1 1 1 5 1 VI-Z3 3–6 jaro 2018 VI Z 3 3–6 VI-Z-3 2 4 1 VI-Z3 6–9 jaro 2018 VI Z 3 6–9 VI-Z-3 3 5 VI-Z4 0–3 jaro 2018 VI Z 4 0–3 VI-Z-4 1 1 VI-Z4 3–6 jaro 2018 VI Z 4 3–6 VI-Z-4 1 1 1 1 1 "VI-Z4 6–8,5" jaro 2018 VI Z 4 "6–8,5" VI-Z-4 VI-Z5 0–3 jaro 2018 VI Z 5 0–3 VI-Z-5 1 VI-Z5 3–6 jaro 2018 VI Z 5 3–6 VI-Z-5 "VI-Z5 6–8,5" jaro 2018 VI Z 5 "6–8,5" VI-Z-5 1 VI-N1 0–3 jaro 2018 VI N 1 0–3 VI-N-1 VI-N1 3–6 jaro 2018 VI N 1 3–6 VI-N-1 VI-N1 6–10 jaro 2018 VI N 1 6–10 VI-N-1 VI-N2 0–3 jaro 2018 VI N 2 0–3 VI-N-2 1 VI-N2 3–6 jaro 2018 VI N 2 3–6 VI-N-2 VI-N2 6–9 jaro 2018 VI N 2 6–9 VI-N-2 1 2 1 VI-N3 0–3 jaro 2018 VI N 3 0–3 VI-N-3 4 21 3 1 VI-N3 3–6 jaro 2018 VI N 3 3–6 VI-N-3 3 8 2 1 12 2 1 3 x Achaeta sp. VI-N4 0–3 jaro 2018 VI N 4 0–3 VI-N-4 1 VI-N4 3–6 jaro 2018 VI N 4 3–6 VI-N-4 4 VI-N5 0–3 jaro 2018 VI N 5 0–3 VI-N-5 VI-N5 3–6 jaro 2018 VI N 5 3–6 VI-N-5 2 RO-Z1 0–3 jaro 2018 RO Z 1 0–3 RO-Z-1 5 2 RO-Z1 3–9 jaro 2018 RO Z 1 3–9 RO-Z-1 1 RO-Z2 0–3 jaro 2018 RO Z 2 0–3 RO-Z-2 10 RO-Z2 3–6 jaro 2018 RO Z 2 3–6 RO-Z-2 13 1 66 4 "RO-Z2 6–10,5" jaro 2018 RO Z 2 "6–10,5" RO-Z-2 11 18 RO-Z3 0–3 jaro 2018 RO Z 3 0–3 RO-Z-3 5 7 20 "6x A. camerani, 1x Frid. Sp." RO-Z3 3–6 jaro 2018 RO Z 3 3–6 RO-Z-3 37 35 15 1 1 4x A. camerani RO-Z3 6–10 jaro 2018 RO Z 3 6–10 RO-Z-3 26 50 24 1 "1x M. simillima, 1x A. camerani" RO-Z4 0–3 jaro 2018 RO Z 4 0–3 RO-Z-4 4 1 RO-Z4 3–6 jaro 2018 RO Z 4 3–6 RO-Z-4 11 15 3 6 RO-Z5 0–3 jaro 2018 RO Z 5 0–3 RO-Z-5 2 RO-Z5 3–6 jaro 2018 RO Z 5 3–6 RO-Z-5 12 3 1 RO-Z5 6–10 jaro 2018 RO Z 5 6–10 RO-Z-5 2 4 1 1 1x M. simillima RO-N1 0–3 jaro 2018 RO N 1 0–3 RO-N-1 RO-N1 3–6 jaro 2018 RO N 1 3–6 RO-N-1 8 5x O. tubifera RO-N1 6–9 jaro 2018 RO N 1 6–9 RO-N-1 3 1 2 4 5 2 "2x M. simillima, 5x O. tubifera" RO-N1 9–12 jaro 2018 RO N 1 9–12 RO-N-1 1 1 5 1 1 3 1x O. tubifera RO-N2 0–3 jaro 2018 RO N 2 0–3 RO-N-2 2 2 RO-N2 3–6 jaro 2018 RO N 2 3–6 RO-N-2 1 1 1x Cog. Sphag. S.l. RO-N2 6–9 jaro 2018 RO N 2 6–9 RO-N-2 1 RO-N2 9–x jaro 2018 RO N 2 9–x RO-N-2 1 RO-N3 0–3 jaro 2018 RO N 3 0–3 RO-N-3 1 1 1 RO-N3 3–6 jaro 2018 RO N 3 3–6 RO-N-3 RO-N3 6–x jaro 2018 RO N 3 6–x RO-N-3 1 2 RO-N4 0–3 jaro 2018 RO N 4 0–3 RO-N-4 1 RO-N4 3–6 jaro 2018 RO N 4 3–6 RO-N-4 1 RO-N4 6–12 jaro 2018 RO N 4 6–12 RO-N-4 4 10 1 1x Marionina sp. RO-N5 0–3 jaro 2018 RO N 5 0–3 RO-N-5 2 1 1 RO-N5 3–6 jaro 2018 RO N 5 3–6 RO-N-5 3 1 2 1 RO-N5 6–9 jaro 2018 RO N 5 6–9 RO-N-5 12 9 RO-N5 9–12 jaro 2018 RO N 5 9–12 RO-N-5 4 1 ##### Sheet/List 4 ##### LOK SNIH VZOREK KOD Achaeta spp. Achaeta spp. 1 pár pyriformních žláz Achaeta spp. 2 páry pyriformních žláz Achaeta spp. bez pyriformních žláz Achaeta affinis Achaeta camerani Achaeta danica Achaeta eiseni Achaeta unibulba Buchholzia appendiculata Cognettia spp. Cognettia chlorophila Cognettia sphagnetorum s. l. Enchytraeus buchholzi Enchytraeus bulbosus Enchytraeus lacteus Enchytraeus norvegicus Enchytraeus sp. juv. Enchytronia holochaeta Enchytronia parva (small diverticula) Enchytronia parva (large diverticula) Enchytronia spp. Fridericia anomala Fridericia bisetosa Fridericia bulboides Fridericia connata Fridericia cylindrica Fridericia deformis Fridericia dura Fridericia galba Fridericia lenta Fridericia maculata Fridericia ?minor Fridericia nemoralis Fridericia paranemoralis Fridericia paroniana Fridericia raxiensis Fridericia sylvatica Fridericia spp. Henlea perpusilla Henlea ventriculosa Hrabeiella periglandulata Marionina clavata Marionina minutissima Marionina simillima Marionina spp. Oconnorella cambrensis Oconnorella tubifera Stercutus niveus Enchytraeidae indet. VI Z 1 VI-Z-1 0 0 0 0 VI Z 2 VI-Z-2 0 0 0 0 VI Z 3 VI-Z-3 0 0 0 0 VI Z 4 VI-Z-4 0 0 0 0 VI Z 5 VI-Z-5 0 0 0 0 VI N 1 VI-N-1 0 0 0 0 VI N 2 VI-N-2 0 0 0 0 VI N 3 VI-N-3 3 0 12 0 VI N 4 VI-N-4 0 0 0 0 VI N 5 VI-N-5 0 0 0 0 RO Z 1 RO-Z-1 0 0 0 0 RO Z 2 RO-Z-2 0 0 0 0 RO Z 3 RO-Z-3 63 0 0 90 RO Z 4 RO-Z-4 0 0 0 0 RO Z 5 RO-Z-5 0 0 0 0 RO N 1 RO-N-1 0 0 0 0 RO N 2 RO-N-2 0 0 0 0 RO N 3 RO-N-3 0 0 0 0 RO N 4 RO-N-4 0 0 0 0 RO N 5 RO-N-5 0 0 0 0