{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Zpracování dat","Grafy"],"not_rendered":{"charts":13,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"Zpracování dat","index":0,"n_rows":61,"n_cols":38,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,5,7,6],[16,26,16,27],[3,17,3,32],[3,1,3,2],[4,7,4,14],[16,30,16,31],[4,29,4,30],[4,17,4,18],[4,19,4,20],[15,18,15,19],[16,18,16,19],[17,18,17,19],[12,18,12,23],[15,22,15,23],[16,22,16,23],[17,22,17,23],[17,30,17,31],[4,5,4,6],[5,5,5,6],[6,5,6,6],[12,26,12,31],[13,26,14,27],[13,28,13,29],[13,30,14,31],[15,26,15,27],[15,30,15,31],[4,31,4,32],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,27,4,28],[17,7,17,14],[13,18,14,19],[13,22,14,23],[13,20,13,21],[18,26,18,27],[17,26,17,27],[18,30,18,31],[21,18,21,23],[22,18,23,19],[18,18,18,19],[19,18,19,19],[21,26,21,31],[22,26,23,27],[22,28,22,29],[22,30,23,31],[18,22,18,23],[27,18,27,19],[27,22,27,23],[22,20,22,21],[22,22,23,23],[24,18,24,19],[24,22,24,23],[25,18,25,19],[25,22,25,23],[25,30,25,31],[26,26,26,27],[26,30,26,31],[26,18,26,19],[26,22,26,23],[27,26,27,27],[27,30,27,31],[8,5,8,6],[9,5,9,6],[10,5,10,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[18,5,18,6],[17,5,17,6],[16,5,16,15],[24,26,24,27],[24,30,24,31],[25,26,25,27],[30,22,30,25],[30,26,30,29],[30,30,30,33],[30,34,30,37],[30,6,30,9],[30,10,30,13],[30,14,30,17],[30,18,30,21]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodové hodnocení jednotlivých ukázek"]
["Vzorek",null,"Body",null,null,"Metoda digitalizace",null,"Ukázka",null,null,null,null,null,null,null,"Průměr",null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8]
[1,"→",3,null,null,null,null,1,2,3,4,5,6,7,8,null,null,"Suma","Průměr","Suma","Průměr","Suma","Průměr","Suma","Průměr","Suma","Průměr","Suma","Průměr","Suma","Průměr","Suma","Průměr"]
[10,"→",2,null,null,"Barrandov",null,81,81,48,54,75,38,61,79,{"$f":"SUM(H7:O7)/(8)","v":64.625},null,81,{"$f":"R7/$H$14","v":4.05},81,{"$f":"T7/$H$14","v":4.05},48,{"$f":"V7/$H$14","v":2.4},54,{"$f":"X7/$H$14","v":2.7},75,{"$f":"Z7/$H$14","v":3.75},38,{"$f":"AB7/$H$14","v":1.9},61,{"$f":"AD7/$H$14","v":3.05},79,{"$f":"AF7/$H$14","v":3.95}]
[19,"→",3,null,null,"COSP",null,78,58,50,62,71,39,63,79,{"$f":"SUM(H8:O8)/(8)","v":62.5},null,78,{"$f":"R8/$H$14","v":3.9},58,{"$f":"T8/$H$14","v":2.9},50,{"$f":"V8/$H$14","v":2.5},62,{"$f":"X8/$H$14","v":3.1},71,{"$f":"Z8/$H$14","v":3.55},39,{"$f":"AB8/$H$14","v":1.95},63,{"$f":"AD8/$H$14","v":3.15},79,{"$f":"AF8/$H$14","v":3.95}]
[32,"→",3,null,null,"Ressonances",null,79,79,50,61,81,45,61,78,66.75,null,79,3.95,79,3.95,50,2.5,61,3.05,81,4.05,45,2.25,61,3.05,78,3.9]
[12,"→",3,null,null,"Sounddirect",null,69,72,55,64,67,42,62,50,60.125,null,69,3.45,72,3.6,55,2.75,64,3.2,67,3.35,42,2.1,62,3.1,50,2.5]
[23,"→",3,null,null,"Průměr",null,{"$f":"SUM(H7:H10)/($H$14*4)","v":3.8374999999999999},{"$f":"SUM(I7:I10)/($H$14*4)","v":3.625},2.5375000000000001,3.0125000000000002,3.6749999999999998,2.0499999999999998,3.0874999999999999,3.5750000000000002]
[29,"→",3]
[6,"→",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Průměrné hodnocení pro film Vlčí jáma",null,null,null,null,null,null,null,"Průměrné hodnocení pro film C a k polní maršálek"]
[11,"→",4,null,null,null,"počet osob:",20,null,null,null,null,null,null,null,null,null,null,"Metoda digitalizace",null,"Ukázka číslo:",null,"Průměr celkem:",null,null,null,"Metoda digitalizace",null,"Ukázka číslo:",null,"Průměr celkem:"]
[20,"→",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 (1)","2 (8)",null,null,null,null,null,null,"1 (3)","2 (6)"]
[26,"→",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrandov",null,{"$f":"S7","v":4.05},{"$f":"AG7","v":3.95},{"$f":"AVERAGE(U16:V16)","v":4},null,null,null,"Barrandov",null,{"$f":"W7","v":2.4},{"$f":"AC7","v":1.9},{"$f":"AVERAGE(AC16:AD16)","v":2.15}]
[5,"→",3,null,null,"Souhn výsledků Posuzování na subjektivních škálách",null,null,null,null,null,null,null,null,null,null,null,null,"COSP",null,{"$f":"S8","v":3.9},{"$f":"AG8","v":3.95},{"$f":"AVERAGE(U17:V17)","v":3.9249999999999998},null,null,null,"COSP",null,{"$f":"W8","v":2.5},{"$f":"AC8","v":1.95},{"$f":"AVERAGE(AC17:AD17)","v":2.2250000000000001}]
[8,"→",4,null,null,"Metoda digitalizace",null,"Ukázka",null,null,null,null,null,null,null,"Průměr",null,null,"Ressonances",null,3.95,3.9,3.9249999999999998,null,null,null,"Ressonances",null,2.5,2.25,2.375]
[14,"→",2,null,null,null,null,1,2,3,4,5,6,7,8,null,null,null,"Sounddirect",null,3.45,2.5,2.9750000000000001,null,null,null,"Sounddirect",null,2.75,2.1,2.4249999999999998]
[17,"→",3,null,null,"Barrandov",null,{"$f":"H7/$H$14","v":4.05},{"$f":"I7/$H$14","v":4.05},2.4,2.7,3.75,1.9,3.05,3.95,{"$f":"SUM(H20:O20)/8","v":3.2312499999999997}]
[31,"→",4,null,null,"COSP",null,{"$f":"H8/$H$14","v":3.9},2.9,2.5,3.1,3.55,1.95,3.15,3.95,{"$f":"SUM(H21:O21)/8","v":3.1249999999999996}]
[25,"→",4,null,null,"Ressonances",null,3.95,3.95,2.5,3.05,4.05,2.25,3.05,3.9,3.3374999999999999,null,null,"Průměrné hodnocení pro film Jedenácté přikázání",null,null,null,null,null,null,null,"Průměrné hodnocení pro film Markéta Lazarová"]
[2,"→",3,null,null,"Sounddirect",null,3.45,3.6,2.75,3.2,3.35,2.1,3.1,2.5,3.0062500000000005,null,null,"Metoda digitalizace",null,"Ukázka číslo:",null,"Průměr celkem:",null,null,null,"Metoda digitalizace",null,"Ukázka číslo:",null,"Průměr celkem:"]
[27,"→",3,null,null,"Průměr",null,{"$f":"SUM(H20:H23)/4","v":3.8374999999999995},{"$f":"SUM(I20:I23)/4","v":3.6249999999999996},2.5375000000000001,3.0125000000000002,3.6749999999999998,2.0499999999999998,3.0874999999999999,3.5750000000000002,null,null,null,null,null,"1 (4)","2 (7)",null,null,null,null,null,null,"1 (2)","2 (5)"]
[24,"→",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrandov",null,{"$f":"Y7","v":2.7},{"$f":"AE7","v":3.05},{"$f":"AVERAGE(U25:V25)","v":2.875},null,null,null,"Barrandov",null,{"$f":"U7","v":4.05},{"$f":"AA7","v":3.75},{"$f":"AVERAGE(AC25:AD25)","v":3.9}]
[4,"→",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COSP",null,{"$f":"Y8","v":3.1},{"$f":"AE8","v":3.15},{"$f":"AVERAGE(U26:V26)","v":3.125},null,null,null,"COSP",null,{"$f":"U8","v":2.9},{"$f":"AA8","v":3.55},{"$f":"AVERAGE(AC26:AD26)","v":3.2249999999999996}]
[15,"→",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ressonances",null,3.05,3.05,3.05,null,null,null,"Ressonances",null,3.95,4.05,4]
[21,"→",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sounddirect",null,3.2,3.1,3.1500000000000004,null,null,null,"Sounddirect",null,3.6,3.35,3.4750000000000001]
[30,"→",3]
[3,"→",2]
[28,"→",4,null,null,"Posluchač č.","Ukázka 1",null,null,null,"Ukázka 2",null,null,null,"Ukázka 3",null,null,null,"Ukázka 4",null,null,null,"Ukázka 5",null,null,null,"Ukázka 6",null,null,null,"Ukázka 7",null,null,null,"Ukázka 8"]
[18,"→",5,null,null,null,"Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd","Barr","COSP","Ress","Soundd"]
[13,"→",5,null,null,1,5,3,4,4,4,2,4,4,4,4,3,3,3,4,3,5,4,4,5,3,3,2,5,3,3,3,4,3,4,5,5,2]
[16,"→",5,null,null,2,5,3,4,4,4,2,4,4,4,4,3,3,3,4,3,5,4,4,5,3,3,2,5,3,3,3,4,3,4,5,5,2]
[22,"→",2,null,null,3,3,3,1,1,4,2,4,2,2,2,3,4,3,4,3,4,3,2,3,1,1,2,2,2,4,4,2,3,4,3,3,2]
[9,"→",3,null,null,4,3,5,5,4,5,3,4,4,2,3,1,2,3,3,3,2,4,3,4,3,2,2,1,1,2,3,2,3,3,3,4,3]
[7,"→",2,null,null,5,5,4,5,4,5,3,5,4,3,3,2,3,3,3,4,4,4,4,4,4,2,2,2,2,3,4,3,4,4,4,4,1]
[null,null,null,null,null,6,3,5,5,4,4,4,4,4,2,1,2,2,2,3,2,2,5,4,5,4,1,1,1,2,2,3,2,3,5,4,4,2]
[null,null,null,null,null,7,4,4,5,4,3,2,3,3,1,1,1,2,3,3,3,3,3,2,3,4,1,1,1,1,4,3,3,3,3,3,4,1]
[null,null,null,null,null,8,4,5,4,4,4,3,4,4,2,2,2,2,3,3,2,3,4,4,4,4,2,2,2,2,2,2,2,2,4,4,3,4]
[null,null,null,null,null,9,3,3,3,2,3,2,3,3,3,3,3,4,2,3,4,1,3,2,5,5,2,2,2,2,4,5,5,2,4,4,3,4]
[null,null,null,null,null,10,5,3,3,4,5,4,4,4,3,4,4,3,3,3,4,4,5,5,5,4,3,3,3,3,3,3,3,4,4,5,5,4]
[null,null,null,null,null,11,3,4,5,4,5,4,5,4,2,2,2,3,2,2,3,2,4,4,4,4,2,2,2,1,3,2,3,3,5,5,4,2]
[null,null,null,null,null,12,4,5,5,3,4,3,4,4,3,2,3,3,1,2,1,3,3,4,3,3,1,2,1,2,1,1,2,1,4,4,4,2]
[null,null,null,null,null,13,4,4,5,4,3,2,2,3,1,1,1,2,4,3,3,3,3,2,3,4,1,1,1,1,4,3,3,3,4,3,4,3]
[null,null,null,null,null,14,5,5,4,4,5,4,4,4,3,1,3,2,3,3,3,4,4,4,3,3,2,2,2,1,4,3,4,4,4,3,3,3]
[null,null,null,null,null,15,4,3,3,1,4,2,4,2,2,2,3,3,3,4,3,4,3,2,3,1,1,2,2,2,4,4,3,3,4,3,3,2]
[null,null,null,null,null,16,5,3,3,4,5,4,4,4,3,4,4,3,3,3,4,4,5,5,5,4,3,3,3,3,3,3,3,4,4,5,5,4]
[null,null,null,null,null,17,4,5,2,2,4,3,5,3,2,2,2,3,2,2,2,2,3,5,4,2,1,2,3,2,2,3,3,3,4,4,3,2]
[null,null,null,null,null,18,5,5,5,4,4,4,4,5,3,4,3,3,3,4,4,2,4,4,5,4,3,3,3,4,4,4,4,4,4,4,4,2]
[null,null,null,null,null,19,4,3,5,4,3,3,3,3,1,1,2,2,3,3,3,3,4,2,3,4,1,1,2,2,4,3,3,3,3,3,4,2]
[null,null,null,null,null,20,3,3,3,4,3,2,5,4,2,4,3,3,2,3,4,4,3,5,5,3,3,2,2,3,2,4,3,4,4,5,4,3]
[]
[]
[]
[]
[]
[null,null,null,null,4,null,2.15,null,2.875,null,3.9]
[null,null,null,null,3.9249999999999998,null,2.2250000000000001,null,3.125,null,3.2249999999999996]
[null,null,null,null,3.9249999999999998,null,2.375,null,3.05,null,4]
[null,null,null,null,2.9750000000000001,null,2.4249999999999998,null,3.1500000000000004,null,3.4750000000000001]

{"sheet":"Grafy","index":1,"n_rows":74,"n_cols":2,"rows_kept":74,"cut":false,"hidden":false,"merged":[[20,1,20,26],[37,1,37,26],[55,1,55,26],[73,1,73,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vlčí jáma"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C. a k. polní maršálek"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Jedenácté přikázání"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Markéta Lazarová"]