{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["home","konfig","qtl","vypocty","chcil","data","stat"],"not_rendered":{"charts":2,"images":5,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"home","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,2,9,3],[0,2,0,12],[13,11,13,12],[3,11,4,12],[2,11,2,12],[2,2,2,3],[3,2,4,3],[2,5,2,6],[3,5,4,6],[2,8,2,9],[3,8,4,9],[7,5,7,6],[8,5,9,6],[7,8,7,9],[8,8,9,9],[7,11,7,12],[8,11,9,12],[7,2,7,3]]}
[null,null,{"$f":"CONCATENATE(\"Aktuální přehled průměrných plemenných hodnot z výpočtu\",\" \",vypocty!C6)","v":"Aktuální přehled průměrných plemenných hodnot z výpočtu 0/0"}]
[]
[null,null,"Celkem genomováno zvířat",null,null,"Průměrný gSIH",null,null,"Průměrná gPH kg M",null,null,"Průměrná gPH kg B"]
[null,null,{"$f":"vypocty!C1","v":0},null,null,{"$f":"vypocty!C2","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C3","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C4","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,{"$f":"vypocty!B5","v":9247},null,null,{"$f":"vypocty!C2-(INDIRECT(\"stat!AR7\"))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C3-(INDIRECT(\"stat!B7\"))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C4-(INDIRECT(\"stat!E7\"))","v":{"$error":"#DIV/0!"}}]
["1. Aktuální přehled"]
["2. Konfigurace",null,"Průměrný index produkce",null,null,"Průměrný index končetin",null,null,"Průměrný index vemene",null,null,"Průměrný typ"]
["3. Nastavení chov. cíle",null,{"$f":"vypocty!C9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C10","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C11","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C12","v":{"$error":"#DIV/0!"}}]
["4. PH zvířat"]
[null,null,null,{"$f":"vypocty!C9-(INDIRECT(\"stat!L7\"))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C10-(INDIRECT(\"stat!AM7\"))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C11-(INDIRECT(\"stat!AN7\"))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"vypocty!C12-(INDIRECT(\"stat!AL7\"))","v":{"$error":"#DIV/0!"}}]

{"sheet":"konfig","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Aktuální verze programu",{"$f":"vypocty!B14","v":1}]
[null,null,"Vaše verze",1]
[]
[]
["1. Aktuální přehled"]
["2. Konfigurace"]
["3. Nastavení chov. cíle"]
["4. PH zvířat"]

{"sheet":"qtl","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,7,2,8]]}
[]
[]
[null,null,"beta kasein",null,null,null,null,"BLAD"]
[null,null,"ID","Zvíře","Otec","QTL",null,"ID","Zvíře","Otec","QTL"]
[null,null,1,null,null,null,null,1]
[]
["1. Aktuální přehled"]
["2. Konfigurace"]
["3. Nastavení chov. cíle"]
["4. PH zvířat"]
["5. QTLka "]

{"sheet":"vypocty","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,6,10,7]]}
["celkem zvířat:",{"$f":"COUNT(INDIRECT(\"data!F7:F10000\"))","v":0},{"$f":"SUBTOTAL(103,INDIRECT(\"data!F7:F10000\"))","v":0}]
["průměrný gSIH",{"$f":"AVERAGE(INDIRECT(\"data!G7:G10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!G7:G10000\"))","v":{"$error":"#DIV/0!"}},null,null,null,"Tooltip"]
["průměrná PH kg M",{"$f":"AVERAGE(INDIRECT(\"data!J7:J10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!J7:J10000\"))","v":{"$error":"#DIV/0!"}}]
["průměrná PH kg B",{"$f":"AVERAGE(INDIRECT(\"data!M7:M10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!M7:M10000\"))","v":{"$error":"#DIV/0!"}},null,null,null,"Point Index",52]
["počet zvířat",{"$f":"INDIRECT(\"stat!B10\")","v":9247}]
["Výpočet datum",{"$f":"INDIRECT(\"data!F7\")","v":0},{"$f":"CONCATENATE(RIGHT(B6,2),\"/\",LEFT(B6,4))","v":"0/0"},null,null,null,{"$f":"INDEX(INDEX(tab_data,,1),(myPointIndex))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"INDEX(INDEX(tab_data,,4),(myPointIndex))","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"Živé?: \",INDEX(INDEX(tab_data,,3),(myPointIndex)))","v":{"$error":"#REF!"}}]
[]
["index produkce",{"$f":"AVERAGE(INDIRECT(\"data!U7:U10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!U7:U10000\"))","v":{"$error":"#DIV/0!"}},null,null,null,"gSIH",{"$f":"INDEX(INDEX(tab_data,,7),myPointIndex)","v":{"$error":"#REF!"}}]
["index konč.",{"$f":"AVERAGE(INDIRECT(\"data!V7:V10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!V7:V10000\"))","v":{"$error":"#DIV/0!"}},null,null,null,"vl. index",{"$f":"INDEX(INDEX(tab_data,,8),myPointIndex)","v":{"$error":"#REF!"}}]
["index vemene",{"$f":"AVERAGE(INDIRECT(\"data!W7:W10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!W7:W10000\"))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"CONCATENATE(INDEX(INDEX(tab_data,,10),myPointIndex),\" M \",INDEX(INDEX(tab_data,,11),myPointIndex),\" kg T \",INDEX(INDEX(tab_data,,12),myPointIndex),\" % T \",INDEX(INDEX(tab_data,,13),myPointIndex),\" kg B \",INDEX(INDEX(tab_data,,14),myPointIndex),\" %B\")","v":{"$error":"#REF!"}}]
["typ celkem",{"$f":"AVERAGE(INDIRECT(\"data!Z7:Z10000\"))","v":{"$error":"#DIV/0!"}},{"$f":"SUBTOTAL(101,INDIRECT(\"data!Z7:Z10000\"))","v":{"$error":"#DIV/0!"}}]
[]
["verze programu",{"$f":"INDIRECT(\"stat!B11\")","v":1}]

{"sheet":"chcil","index":4,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Nastavení chovatelského cíle:"]
[]
[null,null,null,"Produkce",null,null,null,null,"Exteriér",null,null,null,null,"Fitness"]
[null,null,null,null,null,100,null,null,null,null,100,null,null,null,null,100]
[null,null,null,{"$f":"F4/J20","v":33.333333333333336},null,null,null,null,{"$f":"K4/J20","v":33.333333333333336},null,null,null,null,{"$f":"P4/J20","v":33.333333333333336}]
[null,null,null,"Mléko",null,null,null,null,"Končetiny",null,null,null,null,"Somatické buňky"]
["1. Aktuální přehled",null,null,null,null,100,null,null,null,null,100,null,null,null,null,100]
["2. Konfigurace"]
["3. Nastavení chov. cíle",null,null,"Tuk",null,null,null,null,"Vemeno",null,null,null,null,"Dlouhověkost"]
["4. PH zvířat",null,null,null,null,100,null,null,null,null,100,null,null,null,null,100]
[]
[null,null,null,"Bílkovina",null,null,null,"Končetiny",null,"Vemeno",null,null,"Somatické buňky",null,"Dlouhověkost"]
[null,null,null,null,null,100,null,{"$f":"K7/J26","v":50},":",{"$f":"K10/J26","v":50},null,null,{"$f":"P7/J29","v":50},":",{"$f":"P10/J29","v":50}]
[]
[null,null,"Mléko",null,"Tuk",null,"Bílkovina"]
[null,null,{"$f":"F7/J23","v":33.333333333333336},":",{"$f":"F10/J23","v":33.333333333333336},":",{"$f":"F13/J23","v":33.333333333333336}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"(F4+K4+P4)/100","v":3}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"(F7+F10+F13)/100","v":3}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"(K7+K10)/100","v":2}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"(P7+P10)/100","v":2}]

{"sheet":"data","index":5,"n_rows":6,"n_cols":30,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,15,1,16],[2,0,2,1],[1,3,1,4],[1,6,1,7],[1,9,1,10],[1,12,1,13]]}
[]
["Hlavní přehled",null,null,"Barevné indikátory:",null,null,"hodnota paří do\n10% nejhorších",null,null,"hodnota paří do\n25% nejhorších",null,null,"hodnota paří do\n25% nejlepších",null,null,"hodnota paří do\n10% nejlepších"]
["kliknutím se přesunete zpět"]
[]
[null,null,null,null,null,null,null,null,null,"Plemenné hodnoty produkce",null,null,null,null,"RPH produkce",null,null,null,null,null,"Dílčí indexy",null,null,"Fitnes znaky",null,"Exteriér - souhrnné charakteristiky"]
["Číslo zv.","DN","Ž.M","Otec","Matka","Datum","gSIH","Vlastní I.","R%","M kg","T kg","T %","B kg","B %","kg M","kg T","% T","kg B","% B","SB","I. prod.","I. kon.","I. vem.","DLH","Doj.","Typ","Ml. s.","ST","Kon.","Vem."]

{"sheet":"stat","index":6,"n_rows":11,"n_cols":45,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Záhlaví","PHMLK","PHTUKkg","PHTUKp","PHBLKkg","PHBLKp","RPHMLK","RPHTUKkg","RPHTUKp","RPHBLKkg","RPHBLKp","idxMLK","RPHSB","RPHramec","RPHshrud","RPHhltela","RPHhran","RPHsklzade","RPHsirzade","RPHpzk-zz","RPHpzk-zb","RPHuhelpaz","RPHprupvem","RPHrozmPstr","RPHdlkstr","RPHhlvem","RPHvyskazad","RPHzavvaz","RPHrozmZstr","RPHsirkazad","RPHkvalkost","RPHchodivos","RPHkondice","RPHmlsila","RPHstavbatela","RPHkoncetin","RPHvemeno","RPHcelkem","idxKON","idxVEMENO","RPHpld-pl","RPHvpl-pl","RPHdlv","gSIH","RPHdoj"]
["Percentil",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43]
["[0]10",-178,0,-0.2,-1,-0.11,96,100,88,99,87,102,91,84,89,89,90,86,88,89,85,89,89,85,89,84,91,85,86,89,88,85,85,80,84,86.8,86,86,93.7,95.68,94,0,95,106.8,85]
["[1]25",166,12,-0.09,8,-0.06,103,109,95,106,93,108.4,96,91,94,95,96,92,94,95,91,94,95,92,94,92,99,91,92,98,95,93,90,86,92,94,95,96,100.5,103.3,97,0,100,113.7,93]
["[2]75",894,34,0.14000000000000001,26,0.04,118,124,108,122,105,120.1,110,106,105,107,108,105,108,109,105,105,109,106,107,107,115,103,106,115,109,109,102,100,108,110,111,112,113.7,116.5,105,0,109,125.7,112]
["[3]90",1246,44,0.26,35,0.1,125,131,116,130,112,125.5,115,113,110,112,114,110,114,116,110,110,115,112,113,114,121,108,112,122,115,117,107,107,115,116,117,119,118.5,120.7,108,0,112,130.9,121]
["Průměr",525.15626689736996,22.656969828051999,3.0198983454093001E-2,16.494646912512,-8.0642370498539995E-3,110.50243322159,115.96160917054,101.80847842544,114.10576403157999,99.029414945387998,114.00511517248999,102.95609386828001,98.524602573807996,99.850221693522002,100.54688006921,101.90569914567,98.399805342272998,100.760570996,102.37093111279,97.965177895533998,99.616416134963004,102.0381745431,98.956959013733993,100.69806423705,99.255974910782001,106.30658591976,96.726073321076996,99.035362820374004,105.99762085000999,101.78825565048,101.25154104034,96.247864172164,93.238023142640998,99.680328755272001,101.7265058938,102.24580945171,103.18276197685999,106.62422407267,109.24536606466999,100.78782307775001,0,103.86925489348,119.30297393748999,102.80372012545]
["Max",2774,96,0.9,73,0.44,155,167,154,162,153,149,141,140,129,141,137,134,137,144,139,135,144,135,148,141,145,133,139,154,141,147,128,142,139,150,140,143,141,131.9,122,0,122,152.4,158]
["Min",-2126,-60,-0.79,-53,-0.35,57,57,53,55,58,68.599999999999994,54,46,64,65,54,65,63,62,52,67,60,61,67,54,53,59,49,43,48,54,63,48,40,56,50,48,55.4,68.2,74,0,71,71.400000000000006,50]
["počet",9247]
["verze:",1]