K36 calculator

[Abriekman]

Target: Abriekman_mother | 37,5% Polish | 12,5% Ukrainian Cossack | 25% Siberian Russian | 25% Bulgarian
Distance: 778.4432% / 7.78443186 | R4P
49.0 Ukrainian_Chernihiv
26.8 Greek_Central
20.4 Erzya
3.8 Brahui

[Ajeje Brazorf]

Run calculators on the command line with ADMIXTURE

I now figured out a faster way to run a calculator for a large batch of samples, which is to simply use the `-P` option of ADMIXTURE to project the samples. See section 2.14 of the ADMIXTURE manual (https://dalexander.github.io/admixtu...ure-manual.pdf). For example the following code runs Eurogenes K36 for all samples in the 1240K version of the Reich dataset (which took only about 2 hours on my computer, even though it would've taken about 4 days with the Python admix script):

wget https://reichdata.hms.harvard.edu/pub/datasets/amh_repo/curated_releases/V50/V50.0/SHARE/public.dir/v50.0_1240K_public.{anno,geno,ind,snp}
f=v50.0_HO_public;convertf -p <(printf %s\\n genotypename:\ $f.geno snpname:\ $f.snp indivname:\ $f.ind outputformat:\ PACKEDPED genotypeoutname:\ $f.bed snpoutname:\ $f.bim indivoutname:\ $f.fam)
curl -Lso K36.zip 'https://drive.google.com/uc?export=download&id=1vOJptDkvjDuukjDFQXhgnDDL0zHUJ4YN'
unzip K36.zip
plink --allow-no-sex --bfile v50.0_1240K_public  --extract <(cut -d\  -f1 K36.alleles) --geno .9999 --make-bed
cut -d\  -f1 K36.alleles|paste - K36.36.F|awk 'NR==FNR{a[$1]=$0;next}{print a[$2]}' - plink.bim|cut -f2 >plink.36.P.in
admixture -j4 -P plink.bed 36
cut -d\  -f2 plink.fam|paste - <(awk '{for(i=1;i<=NF;i++)$i=sprintf("%.2f",100*$i)}1' plink.36.Q)|awk -F\\t 'NR==FNR{a[$2]=$13;next}{print a[$1]":"$0}' v50.0_1240K_public.anno -|tr '\t ' ,|sort>reich.k36.1240k

The `--geno .9999` option is not actually needed in this case, but if you run ADMIXTURE with a smaller set of samples and you don't include the `--geno` option, then it can result in an error that "all genotypes are missing for a SNP locus".

You can download a zip file for the calculator files for K36 from here: https://onedrive.live.com/?authkey=%...1FDFEB45%21141. (Mirror: https://drive.google.com/file/d/1vOJ...hgnDDL0zHUJ4YN.)

Here's a CSV file for the K36 results of samples in the Reich dataset: https://drive.google.com/file/d/1dGD...IV4Cg6KnKHPeeX. I used the 1240K version when available and the HO version only for samples that were missing from the 1240K version. Eurogenes K36 has about 160,000 overlapping SNPs with the 1240K version but only about 50,000 overlapping SNPs with the HO version.

The zip file linked above includes the text file `Eurogenes_K36_refs.txt` which contains a list of samples that were used as references for Eurogenes K36. I excluded a total of 1868 samples from the CSV file where the part after the last underscore of the sample ID in the text file was the same as the version ID or master ID of a sample in the Reich dataset. But many samples had different names in the text file and the Reich dataset, so I wasn't able to remove all samples that suffer from the calculator effect because they were used as references in K36. For example some Chuvash samples like `Chuvash13` get almost 100% of the Volga-Ural component because of the calculator effect, but others like `Ttr-473` only get about 20%.

The following code generates population averages so that it removes duplicate samples, it removes samples with less than 200,000 SNPs, it removes samples that have been marked as contaminated, and it removes various suffixes from the population names:

curl -Lso reich.k36.csv 'https://drive.google.com/uc?export=download&id=1dGDy5_jpDR6vxXYz1qIV4Cg6KnKHPeeX'
curl -LsO https://reichdata.hms.harvard.edu/pub/datasets/amh_repo/curated_releases/V50/V50.0/SHARE/public.dir/v50.0_HO_public.anno
LC_ALL=C sort -t$'\t' -rnk14 v50.0_HO_public.anno|awk -F\\t '!a[$3]++&&$14>=2e5{print$2}'|awk -F'[:,]' 'NR==FNR{a[$0];next}$2 in a' - <(sed 1d reich.k36.csv)|sed 's/:[^,]*//'||grep -v ^\\.\\.|sed -E 's/(_(son|daughter|brother|sister|father|mother|published|all|dup)|[._][12]d\.|[._]rel)[^,]*//'|sed -E 's/\.(SG|SDG|DG|WGA)//'|grev -v ^Ignore_|grep -Ev '_(contam|fail)'|awk -F, '{n[$1]++;for(i=2;i<=NF;i++){a[$1,i]+=$i}}END{for(i in n){o=i;for(j=2;j<=NF;j++)o=o FS sprintf("%.2f",a[i,j]/n[i]);print o}}'|sort|cat <(head -n1 reich.k36.csv) ->reich.k36.csv.ave

[J. Ketch]

.

Thanks to Yamyatkah (sic) from beyond the grave, will take some time but I'll try to make ancient averages from that and incorporate the moderns.

[Jana]

Posting my most accurate values here (from merged kit Ancestry+23andme+MyHeritage), because I think my K36 in user list comes from less accurate myheritage raw data:

Feiichy,0,0,0,1.25,0,8.84,0,0,9.04,0,18.16,1.06,8.2,7.08,6.16,10.12,0,12.83,0,0,0,3.7,4.72,5.88,0,0,0,0,0,0,0,0,0,0,0.88,2.08

Looks good! I am now paying closer attention to this calc, probably best we have for moderns while for ancients it's G25.

Distance to: Feiichy

6.09110827 Croatian
7.30954855 Bosnian
8.48463906 Hungarian
8.66259776 Slovenian
9.15240406 Serb
11.41354020 Romanian
11.58159747 Montenegrin
12.20868134 Czech
13.02315246 Austrian
13.08325265 Slovak
13.68920743 Bulgarian
14.68305826 Ukrainian
15.55546206 Moldovan
15.87896722 Polish
17.97768617 German
18.46924471 North_Macedonian
19.26584024 Swiss_German
20.29613264 Belarusian
20.90823761 Afrikaner
21.65470388 Walloon
21.67911899 Flemish
22.20204495 Albanian
22.27141666 French
23.27279313 Russian
24.62366951 Greek

Target: Feiichy
Distance: 5.9832% / 5.98315404

83.9 Croatian
6.8 Bosnian
6.3 Swiss_Italian
3.0 Lithuanian

Distance to: Feiichy

6.01782900 96.20% Croatian + 3.80% Swiss_Italian
6.05363124 97.60% Croatian + 2.40% Spanish
6.05599294 98.80% Croatian + 1.20% Sardinian
6.06928148 98.20% Croatian + 1.80% Portuguese
6.07803328 9.00% Bosnian + 91.00% Croatian
6.08909814 0.80% Albanian + 99.20% Croatian
6.09038796 99.00% Croatian + 1.00% Romanian
6.71105803 65.40% Bosnian + 34.60% Slovenian
7.00897679 93.00% Bosnian + 7.00% Spanish
7.04373750 15.20% Austrian + 84.80% Bosnian
7.05815012 90.40% Bosnian + 9.60% Swiss_German
7.07307529 93.60% Bosnian + 6.40% Portuguese
7.07321704 38.60% Polish + 61.40% Romanian
7.07527632 71.80% Bosnian + 28.20% Hungarian
7.07615137 46.20% Serb + 53.80% Slovenian
7.08308631 92.20% Bosnian + 7.80% French
7.13597114 93.80% Bosnian + 6.20% Swiss_Italian
7.18409856 93.80% Bosnian + 6.20% Walloon
7.19065983 94.00% Bosnian + 6.00% Flemish
7.19955781 88.60% Bosnian + 11.40% Czech
7.22871789 5.20% Afrikaner + 94.80% Bosnian
7.26296517 94.40% Bosnian + 5.60% Polish
7.26306468 95.20% Bosnian + 4.80% German
7.26548668 98.40% Bosnian + 1.60% Sardinian
7.26965285 97.00% Bosnian + 3.00% English

[Jana]

testing with smaller regions, nice! And will try to make smaller Croatian averages in collaboration with some members here

Distance to: Feiichy

6.09110827 Croatian
7.30954855 Bosnian
7.66105084 Moldova_North
8.48463906 Hungarian
8.66259776 Slovenian
8.91715201 Moldova_Centre
9.15240406 Serb
9.30965091 Romanian_Northeast
9.61274154 Austrian_Carinthia
9.85012690 Carpathian_Rusyns
9.98535928 Austrian_Styria
9.99463856 Serb_Dalmatia
10.12177356 Ukrainian_Zakarpattia
10.38528767 Czech_Moravia
11.24460760 Slovak_2
11.33751295 Romanian_Southwest
11.39676270 Czech_Bohemia
11.41354020 Romanian
11.56462710 Ukrainian_Lviv
11.58159747 Montenegrin
11.69769635 Romanian_Southeast
12.20868134 Czech
12.21755295 German_North_Bohemia
12.59642807 Montenegrin
13.08325265 Slovak

Target: Feiichy
Distance: 5.6252% / 5.62524234

35.5 Croatian
26.0 Moldova_North
23.3 German_Brandenburg_outlier(Beeskow)
10.4 Swiss_Italian
2.4 Spanish_Baleares
1.5 Albanian_Kosovo
0.9 Darginian

Distance to: Feiichy

5.99934272 96.00% Croatian + 4.00% Spanish_Baleares
6.01578112 97.00% Croatian + 3.00% Spanish_Valencia
6.01782900 96.20% Croatian + 3.80% Swiss_Italian
6.01925330 97.00% Croatian + 3.00% Spanish_Castello
6.03084269 97.00% Croatian + 3.00% Spanish_Terres_de_l'Ebre
6.04090376 97.20% Croatian + 2.80% Spanish_Lleida
6.04110173 97.40% Croatian + 2.60% Spanish_Valencia
6.04146673 97.40% Croatian + 2.60% Spanish_Catalunya_Central
6.04357955 97.20% Croatian + 2.80% Spanish_Barcelones
6.04374112 97.20% Croatian + 2.80% Spanish_Camp_de_Tarragona
6.04380254 97.20% Croatian + 2.80% Spanish_Peri-Barcelona
6.04447310 97.80% Croatian + 2.20% Spanish_Cantabria
6.05363124 97.60% Croatian + 2.40% Spanish
6.05497498 97.60% Croatian + 2.40% Spanish_Eivissa
6.05599294 98.80% Croatian + 1.20% Sardinian
6.06088873 93.00% Croatian + 7.00% Serb_Dalmatia
6.06207827 97.80% Croatian + 2.20% Spanish_Mallorca
6.06317067 97.80% Croatian + 2.20% Spanish_Girona
6.06460327 95.60% Croatian + 4.40% German_Brandenburg_outlier(Beeskow)
6.06514629 98.00% Croatian + 2.00% Spanish_Penedes
6.06928148 98.20% Croatian + 1.80% Portuguese
6.07010111 90.20% Croatian + 9.80% Moldova_North
6.07108073 98.20% Croatian + 1.80% Italian_Tuscany
6.07160344 98.20% Croatian + 1.80% French_Corsican
6.07313608 98.60% Croatian + 1.40% Spanish_Aragon

[Jana]

For Creoda to add into regional spreadsheet; Croats from Gorski Kotar (sample size 20)

Croat_Gorski_Kotar,0.0145,0.304,0.677,1.283,0.0,8.1785,0.0,0.0,6.378,0.0,14.8695,1.2845,8.723,8.996,3.9025,7.5975,0.0,11.478,0.0,0.697,0.3245,7.044,3.106,11.05,0.0,0.0335,0.0,0.0,0.0,0.0,0.132,0.0,0.809,0.0,0.8935,2.2095

They are a historical mix of Croat, Slovene and Gottschee German population.

https://en.wikipedia.org/wiki/Gorski_Kotar

Individual samples:

result,0,1.96,3.41,3.35,0,15.05,0,0,4.59,0,13.85,1.65,12.33,8.86,0.81,9.37,0,7.74,0,0,0.66,5.72,0,6.99,0,0,0,0,0,0,0.34,0,1.57,0,0,1.7 
result,0,0,0.17,0.26,0,6.7,0,0,5.15,0,16.03,0,7.61,9.21,3.51,6.88,0,16.36,0,1.68,1.75,6.85,2.92,11.28,0,0,0,0,0,0,0,0,0.6,0,0.27,2.77
result,0.29,0.53,0.64,2.92,0,10.19,0,0,3.77,0,13.96,1.83,9.55,10.91,3.28,7.23,0,11.34,0,1.54,0,6.73,1.65,11.08,0,0,0,0,0,0,0,0,1.06,0,0.42,1.04
result,0,1.05,0.62,0,0,3.86,0,0,5.26,0,14.83,5.6,11.58,11.71,3.86,7.51,0,13.61,0,0,0.22,6.06,0.06,13.18,0,0.67,0,0,0,0,0,0,0,0,0,0.27
result,0,0,0,3.95,0,11.3,0,0,6.67,0,15.39,2.49,8.08,9.01,3.99,4.47,0,12.1,0,0,1.76,7.66,3.23,6.38,0,0,0,0,0,0,0.51,0,1.8,0,0,1.18
result,0,0,1.6,3.31,0,7.43,0,0,7.62,0,17.11,2.75,7.72,8.71,3.23,0.21,0,10.37,0,0,0,14.5,1.6,8.77,0,0,0,0,0,0,0,0,2.91,0,1.68,0.49
result,0,0,0.09,0,0,9.85,0,0,9.28,0,8.94,0.75,8.18,12.39,4,2.18,0,13.54,0,1.73,0,5.49,3.77,11.51,0,0,0,0,0,0,1.09,0,0,0,1.44,5.71
result,0,0,1.53,1.43,0,8.21,0,0,8.96,0,21.67,0,8,9.36,2.74,5.24,0,10.11,0,0,0.25,6.92,1.15,9.99,0,0,0,0,0,0,0,0,0.6,0,1.24,2.61
result,0,0,0,1.21,0,8.83,0,0,7.69,0,13.83,1.31,3.45,12.45,6.16,0,0,9.63,0,0,0,12.31,7.12,10.81,0,0,0,0,0,0,0.7,0,0.29,0,0,4.2
result,0,0.46,0,0,0,7.1,0,0,7.56,0,15.38,0,5.85,6.66,6.12,9.4,0,12.97,0,0.19,0,5.79,2.34,11.94,0,0,0,0,0,0,0,0,1.8,0,2.83,3.55
result,0,0,0.37,0,0,8.31,0,0,6.77,0,12.34,0,9.12,7.35,3.58,14.42,0,13.19,0,0,0.35,6.39,4.85,10.95,0,0,0,0,0,0,0,0,0,0,0,2
result,0,0,0,0.86,0,6.84,0,0,6.05,0,15.65,0,7.21,10.52,3.75,7.24,0,10.23,0,4.25,0,7.39,0.4,13.95,0,0,0,0,0,0,0,0,0.06,0,2.21,3.39
result,0,0.86,0.06,1.3,0,11.25,0,0,5.99,0,17.88,5.44,6.44,7.14,5.8,10.15,0,2.78,0,1.49,0,5.57,1.98,13.44,0,0,0,0,0,0,0,0,0.48,0,0.72,1.23
result,0,0,1.4,0.68,0,5.79,0,0,2.5,0,13.96,0,9.92,4.98,6.54,8.66,0,18.18,0,1.38,0,5.28,1.9,15.04,0,0,0,0,0,0,0,0,0,0,0,3.79
result,0,0,1.58,3.64,0,8.39,0,0,3.91,0,9.78,0,9.14,10.27,5.26,13.15,0,13.39,0,0,0,7.22,3.63,10.64,0,0,0,0,0,0,0,0,0,0,0,0
result,0,0,0.82,0.18,0,7.47,0,0,7.21,0,11.83,0.14,6.34,10.54,3.18,11.61,0,11.57,0,0,0,8.26,5.28,13.9,0,0,0,0,0,0,0,0,0,0,1.68,0
result,0,0,0,0,0,9.07,0,0,5.71,0,12.09,2.04,11.23,8.27,4.31,11.33,0,4.96,0,0,1.5,7.29,4.01,13.43,0,0,0,0,0,0,0,0,1.54,0,3.24,0
result,0,1.22,1.25,1.03,0,2.63,0,0,9.49,0,18.9,1.69,10.77,6.96,4.08,7.34,0,8.89,0,0.76,0,5.92,6.11,5.17,0,0,0,0,0,0,0,0,1.65,0,0,6.09
result,0,0,0,1.43,0,6.98,0,0,5.03,0,13.64,0,10.07,7.88,1.37,6.7,0,13.89,0,0.92,0,9.34,5.22,11.59,0,0,0,0,0,0,0,0,1.82,0,1.33,2.79
result,0,0,0,0.11,0,8.32,0,0,8.35,0,20.33,0,11.87,6.74,2.48,8.86,0,14.71,0,0,0,0.19,4.9,10.96,0,0,0,0,0,0,0,0,0,0,0.81,1.38

Many are very German shifted. This region is most German shifted in entire Croatia.

[Jana]

Distance to: Croat_Gorski_kotar

3.80599048 Hungarian
4.37644188 Austrian_Carinthia
4.90839622 Slovenian
5.48851287 Czech_Moravia
5.52328014 Croatian
6.68491313 Czech_Bohemia
6.88800795 Czech
6.98710122 German_Thuringia_East
7.18331146 German_Saxony
7.46636548 Austrian_Styria
7.54295522 Slovak_2
7.68952427 Bosnian
8.17605061 German_East
8.90562089 German_North_Bohemia
8.92943299 Ukrainian_Zakarpattia
9.14355858 Slovak
9.36294951 Moldova_North
9.46054721 Romanian_Northeast
9.53926011 Moldova_Centre
9.55855499 German_County_Glatz
9.62195165 Carpathian_Rusyns
9.84371391 German_Saxony-Anhalt_South
9.84564236 Serb
10.13380992 German_Thuringia_Central
10.69817010 German_Bavaria_Oberpfalz

Target: Croat_Gorski_Kotar
Distance: 1.8027% / 1.80266448 | ADC: 0.5x RC

38.4 Croatian
19.9 Hungarian
18.0 German_Saxony
12.6 German_Saxony-Anhalt_South
5.7 Czech_Bohemia
5.4 Austrian_Salzburg-Upper_Austria

Distance to: Croat_Gorski_Kotar

2.44063161 65.80% Ukrainian_Zakarpattia + 34.20% Walloon
2.54936667 66.00% Croatian + 34.00% German_Saxony-Anhalt_South
2.56315010 34.20% German_Saarland + 65.80% Ukrainian_Zakarpattia
2.64406770 58.00% Croatian + 42.00% German_Saxony
2.70935289 56.80% Bosnian + 43.20% German_Saxony-Anhalt_South
2.73261278 47.20% Bosnian + 52.80% German_Thuringia_East
2.73984553 48.60% German_Saxony-Anhalt_South + 51.40% Moldova_North
2.76036218 38.00% German_Baden-Württemberg + 62.00% Ukrainian_Zakarpattia
2.77442114 76.80% Czech_Bohemia + 23.20% Italian_North
2.78489924 21.60% German_Saxony-Anhalt_South + 78.40% Hungarian
2.79482355 36.80% German_North_Rhine + 63.20% Ukrainian_Zakarpattia
2.81558475 80.00% Czech_Bohemia + 20.00% Italian_Val_Borbera
2.81622785 74.80% Czech_Bohemia + 25.20% Italian_Friuli
2.82815128 27.80% German_Saxony + 72.20% Hungarian
2.84911697 43.80% Austrian_Salzburg-Upper_Austria + 56.20% Ukrainian_Zakarpattia
2.87053923 21.60% German_County_Glatz + 78.40% Hungarian
2.87827229 35.20% Flemish + 64.80% Ukrainian_Zakarpattia
2.88156893 16.20% German_Brandenburg_Northwest + 83.80% Hungarian
2.90211055 57.40% Croatian + 42.60% German_Thuringia_East
2.90422003 74.40% Czech_Bohemia + 25.60% Italian_Veneto
2.91070613 37.60% German_South + 62.40% Ukrainian_Zakarpattia
2.91736562 59.20% German_East + 40.80% Romanian_Southwest
2.91954225 58.00% German_Saxony + 42.00% Moldova_Centre
2.92212740 18.40% Austrian_Salzburg-Upper_Austria + 81.60% Hungarian
2.94387506 82.20% Czech_Bohemia + 17.80% Italian_Tuscany

[Jana]

Will try to compile some other regions later.

[J. Ketch]

For Creoda to add into regional spreadsheet; Croats from Gorski Kotar (sample size 20)

Croat_Gorski_Kotar,0.0145,0.304,0.677,1.283,0.0,8.1785,0.0,0.0,6.378,0.0,14.8695,1.2845,8.723,8.996,3.9025,7.5975,0.0,11.478,0.0,0.697,0.3245,7.044,3.106,11.05,0.0,0.0335,0.0,0.0,0.0,0.0,0.132,0.0,0.809,0.0,0.8935,2.2095

They are a historical mix of Croat, Slovene and Gottschee German population.

https://en.wikipedia.org/wiki/Gorski_Kotar

Individual samples:

result,0,1.96,3.41,3.35,0,15.05,0,0,4.59,0,13.85,1.65,12.33,8.86,0.81,9.37,0,7.74,0,0,0.66,5.72,0,6.99,0,0,0,0,0,0,0.34,0,1.57,0,0,1.7 
result,0,0,0.17,0.26,0,6.7,0,0,5.15,0,16.03,0,7.61,9.21,3.51,6.88,0,16.36,0,1.68,1.75,6.85,2.92,11.28,0,0,0,0,0,0,0,0,0.6,0,0.27,2.77
result,0.29,0.53,0.64,2.92,0,10.19,0,0,3.77,0,13.96,1.83,9.55,10.91,3.28,7.23,0,11.34,0,1.54,0,6.73,1.65,11.08,0,0,0,0,0,0,0,0,1.06,0,0.42,1.04
result,0,1.05,0.62,0,0,3.86,0,0,5.26,0,14.83,5.6,11.58,11.71,3.86,7.51,0,13.61,0,0,0.22,6.06,0.06,13.18,0,0.67,0,0,0,0,0,0,0,0,0,0.27
result,0,0,0,3.95,0,11.3,0,0,6.67,0,15.39,2.49,8.08,9.01,3.99,4.47,0,12.1,0,0,1.76,7.66,3.23,6.38,0,0,0,0,0,0,0.51,0,1.8,0,0,1.18
result,0,0,1.6,3.31,0,7.43,0,0,7.62,0,17.11,2.75,7.72,8.71,3.23,0.21,0,10.37,0,0,0,14.5,1.6,8.77,0,0,0,0,0,0,0,0,2.91,0,1.68,0.49
result,0,0,0.09,0,0,9.85,0,0,9.28,0,8.94,0.75,8.18,12.39,4,2.18,0,13.54,0,1.73,0,5.49,3.77,11.51,0,0,0,0,0,0,1.09,0,0,0,1.44,5.71
result,0,0,1.53,1.43,0,8.21,0,0,8.96,0,21.67,0,8,9.36,2.74,5.24,0,10.11,0,0,0.25,6.92,1.15,9.99,0,0,0,0,0,0,0,0,0.6,0,1.24,2.61
result,0,0,0,1.21,0,8.83,0,0,7.69,0,13.83,1.31,3.45,12.45,6.16,0,0,9.63,0,0,0,12.31,7.12,10.81,0,0,0,0,0,0,0.7,0,0.29,0,0,4.2
result,0,0.46,0,0,0,7.1,0,0,7.56,0,15.38,0,5.85,6.66,6.12,9.4,0,12.97,0,0.19,0,5.79,2.34,11.94,0,0,0,0,0,0,0,0,1.8,0,2.83,3.55
result,0,0,0.37,0,0,8.31,0,0,6.77,0,12.34,0,9.12,7.35,3.58,14.42,0,13.19,0,0,0.35,6.39,4.85,10.95,0,0,0,0,0,0,0,0,0,0,0,2
result,0,0,0,0.86,0,6.84,0,0,6.05,0,15.65,0,7.21,10.52,3.75,7.24,0,10.23,0,4.25,0,7.39,0.4,13.95,0,0,0,0,0,0,0,0,0.06,0,2.21,3.39
result,0,0.86,0.06,1.3,0,11.25,0,0,5.99,0,17.88,5.44,6.44,7.14,5.8,10.15,0,2.78,0,1.49,0,5.57,1.98,13.44,0,0,0,0,0,0,0,0,0.48,0,0.72,1.23
result,0,0,1.4,0.68,0,5.79,0,0,2.5,0,13.96,0,9.92,4.98,6.54,8.66,0,18.18,0,1.38,0,5.28,1.9,15.04,0,0,0,0,0,0,0,0,0,0,0,3.79
result,0,0,1.58,3.64,0,8.39,0,0,3.91,0,9.78,0,9.14,10.27,5.26,13.15,0,13.39,0,0,0,7.22,3.63,10.64,0,0,0,0,0,0,0,0,0,0,0,0
result,0,0,0.82,0.18,0,7.47,0,0,7.21,0,11.83,0.14,6.34,10.54,3.18,11.61,0,11.57,0,0,0,8.26,5.28,13.9,0,0,0,0,0,0,0,0,0,0,1.68,0
result,0,0,0,0,0,9.07,0,0,5.71,0,12.09,2.04,11.23,8.27,4.31,11.33,0,4.96,0,0,1.5,7.29,4.01,13.43,0,0,0,0,0,0,0,0,1.54,0,3.24,0
result,0,1.22,1.25,1.03,0,2.63,0,0,9.49,0,18.9,1.69,10.77,6.96,4.08,7.34,0,8.89,0,0.76,0,5.92,6.11,5.17,0,0,0,0,0,0,0,0,1.65,0,0,6.09
result,0,0,0,1.43,0,6.98,0,0,5.03,0,13.64,0,10.07,7.88,1.37,6.7,0,13.89,0,0.92,0,9.34,5.22,11.59,0,0,0,0,0,0,0,0,1.82,0,1.33,2.79
result,0,0,0,0.11,0,8.32,0,0,8.35,0,20.33,0,11.87,6.74,2.48,8.86,0,14.71,0,0,0,0.19,4.9,10.96,0,0,0,0,0,0,0,0,0,0,0.81,1.38

Many are very German shifted. This region is most German shifted in entire Croatia.

Thanks, added, and you're welcome to edit my K36 sheets like the others, as you see fit

[Jana]

Thank you very much! It's a really good calc