{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":1,"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":"Лист1","index":0,"n_rows":65,"n_cols":63,"rows_kept":65,"cut":false,"hidden":false,"merged":[[46,0,47,5],[64,0,65,5],[6,50,6,53],[17,49,17,55],[6,57,6,60],[17,56,17,62],[7,63,16,63],[6,43,6,46],[17,42,17,48],[0,1,0,2],[17,7,17,13],[6,8,6,11],[6,15,6,18],[17,14,17,20],[6,22,6,25],[17,21,17,27],[6,29,6,32],[17,28,17,34],[6,36,6,39],[17,35,17,41]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"I7","v":0},{"$f":"I5","v":0},0,0,0,0,null,{"$f":"P7","v":0},{"$f":"P5","v":0},0,0,0,0,null,{"$f":"W7","v":0},0,0,0,0,0,null,{"$f":"AD7","v":0},0,0,0,0,0,null,{"$f":"AK7","v":0},0,0,0,0,0,null,{"$f":"AR7","v":0},0,0,0,0,0,null,{"$f":"AY7","v":0},0,0,0,0,0,null,{"$f":"BF7","v":0},0,0,0,0,0]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6,null,1,2,3,4,5,6]
[null,null,"Запуск макроса",{"$f":"IF(ISBLANK(C7),\"\",HYPERLINK(SUBSTITUTE(CONCATENATE(\"#\",ADDRESS(1,COLUMN($F$7)+2+7*(ROW()-ROW($F$7)),4),\":\",ADDRESS(1,COLUMN($F$7)+16+7*(ROW()-ROW($F$7)),4)),1,),\"►\"))","v":"►"},null,null,null,{"$f":"FLOOR(COUNTBLANK(I8:N17),6)/6","v":9},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(I7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(I7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(P8:U17),6)/6","v":7},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(P7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(P7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(W8:AB17),6)/6","v":7},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(W7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(W7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(AD8:AI17),6)/6","v":7},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(AD7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(AD7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(AK8:AP17),6)/6","v":8},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(AK7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(AK7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(AR8:AW17),6)/6","v":8},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(AR7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(AR7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(AY8:BD17),6)/6","v":7},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(AY7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(AY7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"FLOOR(COUNTBLANK(BF8:BK17),6)/6","v":0},0,null,null,null,{"$f":"IFERROR(INDEX($A$7:$A$17,MATCH(BF7,$C$7:$C$17,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$7:$B$17,MATCH(BF7,$C$7:$C$17,0)),\"\")","v":""}]
[null,null,"двойной","►",null,null,1,"А",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,"А",1,1,1,1,1,1]
[null,null,"клик","►",null,null,2,"Б",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,"Б",1,1,1,1,1,1]
[null,null,"по F7","►",null,null,3,"В",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,"В",1,1,1,1,1,1]
[null,null,null,"",null,3,4,"Г",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,"Г",1,1,1,2,2,2]
[null,null,null,"",null,null,5,"Д",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,"Д",1,1,1,2,2,2]
[null,null,null,"",null,null,6,"Е",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,"Е",1,1,1,2,2,2]
[null,null,null,"",null,null,7,"Ж",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,"Ж",1,1,1,2,2,2]
[null,null,null,"",null,null,8,"З",null,null,null,null,null,null,"З",0,0,0,0,0,0,"З",0,0,0,0,0,0,"З",0,0,0,0,0,0,"З",null,null,null,null,null,null,"З",null,null,null,null,null,null,"З",0,0,0,0,0,0,"З",1,1,1,2,2,2]
[null,null,null,"",null,null,9,"И",null,null,null,null,null,null,"И",0,0,0,0,0,0,"И",0,0,0,0,0,0,"И",0,0,0,0,0,0,"И",0,0,0,0,0,0,"И",0,0,0,0,0,0,"И",0,0,0,0,0,0,"И",1,1,1,2,2,2]
[null,null,null,"",null,null,10,"К",0,0,0,0,0,0,"К",0,0,0,0,0,0,"К",0,0,0,0,0,0,"К",0,0,0,0,0,0,"К",0,0,0,0,0,0,"К",0,0,0,0,0,0,"К",0,0,0,0,0,0,"К",1,1,1,2,2,2]
[]
[1,1,null,null,null,null,"Закреп"]
[1,2]
[2,3]
[2,4]
[3,5]
[3,6]
[3,7]
[4,8]
[4,9]
[5,10]
[5,11]
[5,12]
[6,13,null,null,null,2]
[6,14,null,null,null,2]
[7,15,null,null,null,1]
[7,16,null,null,null,2]
[7,17,null,null,null,1]
[8,18,null,null,null,10]
[8,19,null,null,null,9]
[9,20,null,null,null,8]
[9,21,null,null,null,10]
[9,22,null,null,null,3]
[10,23,null,null,null,6]
[10,24,null,null,null,14]
[11,25,null,null,null,6]
[11,26,null,null,null,6]
[11,27,null,null,null,8]
[]
["Вариант 1 и 2 выдают это\n(см модуль \"Лист1(Лист1)\")"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Вариант 3 уже работает как надо"]