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