{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["List1","Smíšená čísla a zlomky"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"List1","index":0,"n_rows":32,"n_cols":48,"rows_kept":32,"cut":false,"hidden":true,"merged":[[14,22,15,22],[16,22,17,22],[18,22,19,22],[20,22,21,22],[2,22,3,22],[4,22,5,22],[6,22,7,22],[8,22,9,22],[10,22,11,22],[12,22,13,22]]}
[]
[null,null,null,"první číslo","čitatel","jmenovatel"]
[null,null,null,{"$f":"RANDBETWEEN(0,10)","v":7},{"$f":"RANDBETWEEN(0,9)","v":4},{"$f":"IF(E3=0,RANDBETWEEN(1,10),RANDBETWEEN(E3+1,10))","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D3","v":7},{"$f":"E3","v":4},{"$f":"W3*X4+X3","v":46}]
[null,null,null,5,6,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F3","v":6},{"$f":"X4","v":6}]
[null,null,null,7,0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D5","v":7},{"$f":"E5","v":0},{"$f":"W5*X6+X5","v":49}]
[null,null,null,4,2,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F5","v":7},{"$f":"X6","v":7}]
[null,null,null,10,0,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D7","v":10},{"$f":"E7","v":0},{"$f":"W7*X8+X7","v":90}]
[null,null,null,9,0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F7","v":9},{"$f":"X8","v":9}]
[null,null,null,5,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9","v":5},{"$f":"E9","v":1},{"$f":"W9*X10+X9","v":11}]
[null,null,null,8,5,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F9","v":2},{"$f":"X10","v":2}]
[null,null,null,6,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D11","v":6},{"$f":"E11","v":9},{"$f":"W11*X12+X11","v":69}]
[null,null,null,4,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F11","v":10},{"$f":"X12","v":10}]
[null,null,null,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D13","v":0},{"$f":"E13","v":0},{"$f":"W13*X14+X13","v":0}]
[null,null,null,10,4,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F13","v":2},{"$f":"X14","v":2}]
[null,null,null,5,5,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15","v":5},{"$f":"E15","v":5},{"$f":"W15*X16+X15","v":40}]
[null,null,null,7,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F15","v":7},{"$f":"X16","v":7}]
[null,null,null,9,7,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17","v":9},{"$f":"E17","v":7},{"$f":"W17*X18+X17","v":79}]
[null,null,null,2,2,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F17","v":8},{"$f":"X18","v":8}]
[null,null,null,6,1,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D19","v":6},{"$f":"E19","v":1},{"$f":"W19*X20+X19","v":25}]
[null,null,null,10,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F19","v":4},{"$f":"X20","v":4}]
[null,null,null,5,7,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D21","v":5},{"$f":"E21","v":7},{"$f":"W21*X22+X21","v":57}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F21","v":10},{"$f":"X22","v":10}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S32/10,I3, A3,T32/10,D3,N32,B3,K3)","v":"007"}]

{"sheet":"Smíšená čísla a zlomky","index":1,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,17,15,20],[1,11,1,12],[2,13,3,13],[4,13,5,13],[6,13,7,13],[8,13,9,13],[14,13,15,13],[16,13,17,13],[20,10,21,10],[2,11,3,11],[4,11,5,11],[6,11,7,11],[8,11,9,11],[10,11,11,11],[12,11,13,11],[14,11,15,11],[18,13,19,13],[20,13,21,13],[20,11,21,11],[10,13,11,13],[12,13,13,13],[16,11,17,11],[18,11,19,11],[20,5,21,5],[2,10,3,10],[4,10,5,10],[6,10,7,10],[8,10,9,10],[10,10,11,10],[12,10,13,10],[14,10,15,10],[16,10,17,10],[18,10,19,10],[4,5,5,5],[6,5,7,5],[8,5,9,5],[10,5,11,5],[12,5,13,5],[14,5,15,5],[2,0,3,0],[4,0,5,0],[14,0,15,0],[16,0,17,0],[2,3,3,3],[4,3,5,3],[6,3,7,3],[8,3,9,3],[10,3,11,3],[20,3,21,3],[6,0,7,0],[8,0,9,0],[10,0,11,0],[12,0,13,0],[18,0,19,0],[20,0,21,0],[16,3,17,3],[18,3,19,3],[12,3,13,3],[14,3,15,3],[2,5,3,5],[16,5,17,5],[18,5,19,5]]}
[]
[null,null,null,null,"výsledek",null,null,null,null,null,null,"výsledek"]
[0,3,3,"=",null,{"$f":"IF(OR(ISBLANK(E4),ISBLANK(E3)),\" \",IF(AND(E4=C4,E3=C3),\"OK\",\" fuj !!\"))","v":" "},null,6,1,25,"=",null,null,{"$f":"IF(OR(ISBLANK(M4),ISBLANK(M3),ISBLANK(L3)),\" \",IF(AND(L3=H3,M3=I3,M4=I4),\"OK\",\" fuj !!\"))","v":" "},null,null,null,"Výsledky pište do modrých polí. Kontroluje se celý výsledek.                                                 .                                                                  U převodů na zlomky vždy zadávejte výsledek ve tvaru zlomku. Např: smíšené číslo 4a0/1 se převeďte na 4/1.                                    .                                                                                                                         U převodů na smíšená čísla nepřevádějte zlomek do základního tvaru. Např.: číslo 106/10 se převeďte na 10a6/10. I když by bylo možné také zapsat ve tvaru 10a3/5.                                                              .                                                                 Pro zadání dalších příkladů klikněte na tlačítko nad sloupcem.     "]
[null,4,4,null,null,null,null,null,4,4]
[5,4,54,"=",null,{"$f":"IF(OR(ISBLANK(E6),ISBLANK(E5)),\" \",IF(AND(E6=C6,E5=C5),\"OK\",\" fuj !!\"))","v":" "},null,3,6,27,"=",null,null,{"$f":"IF(OR(ISBLANK(M6),ISBLANK(M5),ISBLANK(L5)),\" \",IF(AND(L5=H5,M5=I5,M6=I6),\"OK\",\" fuj !!\"))","v":" "}]
[null,10,10,null,null,null,null,null,7,7]
[10,7,97,"=",null,{"$f":"IF(OR(ISBLANK(E8),ISBLANK(E7)),\" \",IF(AND(E8=C8,E7=C7),\"OK\",\" fuj !!\"))","v":" "},null,3,1,7,"=",null,null,{"$f":"IF(OR(ISBLANK(M8),ISBLANK(M7),ISBLANK(L7)),\" \",IF(AND(L7=H7,M7=I7,M8=I8),\"OK\",\" fuj !!\"))","v":" "}]
[null,9,9,null,null,null,null,null,2,2]
[7,8,71,"=",null,{"$f":"IF(OR(ISBLANK(E10),ISBLANK(E9)),\" \",IF(AND(E10=C10,E9=C9),\"OK\",\" fuj !!\"))","v":" "},null,2,1,9,"=",null,null,{"$f":"IF(OR(ISBLANK(M10),ISBLANK(M9),ISBLANK(L9)),\" \",IF(AND(L9=H9,M9=I9,M10=I10),\"OK\",\" fuj !!\"))","v":" "}]
[null,9,9,null,null,null,null,null,4,4]
[0,9,9,"=",null,{"$f":"IF(OR(ISBLANK(E12),ISBLANK(E11)),\" \",IF(AND(E12=C12,E11=C11),\"OK\",\" fuj !!\"))","v":" "},null,3,6,30,"=",null,null,{"$f":"IF(OR(ISBLANK(M12),ISBLANK(M11),ISBLANK(L11)),\" \",IF(AND(L11=H11,M11=I11,M12=I12),\"OK\",\" fuj !!\"))","v":" "}]
[null,10,10,null,null,null,null,null,8,8]
[9,7,97,"=",null,{"$f":"IF(OR(ISBLANK(E14),ISBLANK(E13)),\" \",IF(AND(E14=C14,E13=C13),\"OK\",\" fuj !!\"))","v":" "},null,0,9,9,"=",null,null,{"$f":"IF(OR(ISBLANK(M14),ISBLANK(M13),ISBLANK(L13)),\" \",IF(AND(L13=H13,M13=I13,M14=I14),\"OK\",\" fuj !!\"))","v":" "}]
[null,10,10,null,null,null,null,null,10,10]
[4,1,33,"=",null,{"$f":"IF(OR(ISBLANK(E16),ISBLANK(E15)),\" \",IF(AND(E16=C16,E15=C15),\"OK\",\" fuj !!\"))","v":" "},null,7,4,46,"=",null,null,{"$f":"IF(OR(ISBLANK(M16),ISBLANK(M15),ISBLANK(L15)),\" \",IF(AND(L15=H15,M15=I15,M16=I16),\"OK\",\" fuj !!\"))","v":" "}]
[null,8,8,null,null,null,null,null,6,6]
[2,3,21,"=",null,{"$f":"IF(OR(ISBLANK(E18),ISBLANK(E17)),\" \",IF(AND(E18=C18,E17=C17),\"OK\",\" fuj !!\"))","v":" "},null,7,1,36,"=",null,null,{"$f":"IF(OR(ISBLANK(M18),ISBLANK(M17),ISBLANK(L17)),\" \",IF(AND(L17=H17,M17=I17,M18=I18),\"OK\",\" fuj !!\"))","v":" "}]
[null,9,9,null,null,null,null,null,5,5]
[6,7,61,"=",null,{"$f":"IF(OR(ISBLANK(E20),ISBLANK(E19)),\" \",IF(AND(E20=C20,E19=C19),\"OK\",\" fuj !!\"))","v":" "},null,9,8,98,"=",null,null,{"$f":"IF(OR(ISBLANK(M20),ISBLANK(M19),ISBLANK(L19)),\" \",IF(AND(L19=H19,M19=I19,M20=I20),\"OK\",\" fuj !!\"))","v":" "}]
[null,9,9,null,null,null,null,null,10,10]
[2,5,19,"=",null,{"$f":"IF(OR(ISBLANK(E22),ISBLANK(E21)),\" \",IF(AND(E22=C22,E21=C21),\"OK\",\" fuj !!\"))","v":" "},null,2,3,21,"=",null,null,{"$f":"IF(OR(ISBLANK(M22),ISBLANK(M21),ISBLANK(L21)),\" \",IF(AND(L21=H21,M21=I21,M22=I22),\"OK\",\" fuj !!\"))","v":" "}]
[null,7,7,null,null,null,null,null,9,9]
[null,null,null,null,null,{"$f":"IF(ISBLANK(E23),\" \",IF(E23=B23,\"OK\",\" fuj !!\"))","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(L23),\" \",IF(L23=K23,\"OK\",\" fuj !!\"))","v":" "}]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[null,null,null,null,null," "]