{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":216,"n_cols":20,"rows_kept":216,"cut":false,"hidden":false,"merged":[]}
[]
["Есть совпадения?"]
[{"$f":"OR(A6:A215=A7:A216)","v":false}]
[]
["без итераций"]
[{"$f":"RANDBETWEEN(1,15)","v":11},null,{"$f":"MOD(C6+RANDBETWEEN(0,13),15)+1","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[{"$f":"MOD(A6+RANDBETWEEN(0,13),15)+1","v":7}]
[{"$f":"MOD(A7+RANDBETWEEN(0,13),15)+1","v":15}]
[3]
[9,null,"Математическая проверка фопмулы:"]
[2]
[10,null,null,"смещения",0,1,2,3,4,5,6,7,8,9,10,11,12,13,null,"Есть совпадения?"]
[3,null,"нач. число",null,"след.число"]
[14,null,1,null,{"$f":"MOD($C14+E$12,15)+1","v":2},{"$f":"MOD($C14+F$12,15)+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,null,{"$f":"OR(C14=E14:R14)","v":false}]
[11,null,2,null,{"$f":"MOD($C15+E$12,15)+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,1,null,{"$f":"OR(C15=E15:R15)","v":false}]
[6,null,3,null,4,5,6,7,8,9,10,11,12,13,14,15,1,2,null,{"$f":"OR(C16=E16:R16)","v":false}]
[10,null,4,null,5,6,7,8,9,10,11,12,13,14,15,1,2,3,null,{"$f":"OR(C17=E17:R17)","v":false}]
[4,null,5,null,6,7,8,9,10,11,12,13,14,15,1,2,3,4,null,{"$f":"OR(C18=E18:R18)","v":false}]
[11,null,6,null,7,8,9,10,11,12,13,14,15,1,2,3,4,5,null,{"$f":"OR(C19=E19:R19)","v":false}]
[4,null,7,null,8,9,10,11,12,13,14,15,1,2,3,4,5,6,null,{"$f":"OR(C20=E20:R20)","v":false}]
[10,null,8,null,9,10,11,12,13,14,15,1,2,3,4,5,6,7,null,{"$f":"OR(C21=E21:R21)","v":false}]
[7,null,9,null,10,11,12,13,14,15,1,2,3,4,5,6,7,8,null,{"$f":"OR(C22=E22:R22)","v":false}]
[6,null,10,null,11,12,13,14,15,1,2,3,4,5,6,7,8,9,null,{"$f":"OR(C23=E23:R23)","v":false}]
[5,null,11,null,12,13,14,15,1,2,3,4,5,6,7,8,9,10,null,{"$f":"OR(C24=E24:R24)","v":false}]
[3,null,12,null,13,14,15,1,2,3,4,5,6,7,8,9,10,11,null,{"$f":"OR(C25=E25:R25)","v":false}]
[1,null,13,null,14,15,1,2,3,4,5,6,7,8,9,10,11,12,null,{"$f":"OR(C26=E26:R26)","v":false}]
[14,null,14,null,15,1,2,3,4,5,6,7,8,9,10,11,12,13,null,{"$f":"OR(C27=E27:R27)","v":false}]
[1,null,15,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,null,{"$f":"OR(C28=E28:R28)","v":false}]
[8]
[13]
[9]
[11]
[10]
[1]
[3]
[13]
[6]
[1]
[11]
[9]
[13]
[15]
[3]
[8]
[11]
[10]
[15]
[3]
[9]
[14]
[3]
[4]
[8]
[3]
[6]
[13]
[4]
[12]
[7]
[8]
[1]
[14]
[1]
[5]
[7]
[4]
[8]
[10]
[7]
[3]
[14]
[{"$f":"MOD(A71+RANDBETWEEN(0,13),15)+1","v":3}]
[11]
[15]
[9]
[1]
[3]
[14]
[12]
[14]
[9]
[12]
[4]
[11]
[1]
[5]
[14]
[6]
[14]
[10]
[12]
[11]
[3]
[1]
[5]
[3]
[7]
[9]
[13]
[15]
[2]
[5]
[13]
[2]
[10]
[14]
[3]
[6]
[14]
[12]
[3]
[10]
[14]
[1]
[11]
[2]
[10]
[12]
[8]
[2]
[4]
[12]
[7]
[9]
[2]
[3]
[5]
[10]
[8]
[15]
[9]
[1]
[7]
[13]
[3]
[{"$f":"MOD(A135+RANDBETWEEN(0,13),15)+1","v":12}]
[3]
[10]
[1]
[6]
[4]
[9]
[10]
[13]
[15]
[11]
[6]
[7]
[6]
[9]
[10]
[4]
[14]
[6]
[13]
[2]
[11]
[10]
[3]
[8]
[4]
[15]
[9]
[6]
[11]
[6]
[10]
[7]
[3]
[5]
[6]
[11]
[10]
[12]
[15]
[8]
[13]
[6]
[9]
[13]
[6]
[4]
[6]
[7]
[4]
[7]
[2]
[11]
[3]
[5]
[6]
[11]
[1]
[7]
[14]
[13]
[6]
[1]
[8]
[{"$f":"MOD(A199+RANDBETWEEN(0,13),15)+1","v":14}]
[9]
[11]
[13]
[11]
[8]
[13]
[3]
[9]
[5]
[13]
[4]
[14]
[13]
[6]
[9]
[15]