{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Данные","Пример календаря","Игры по дням","Таблица"],"not_rendered":{"charts":0,"images":4,"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":"Данные","index":0,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,0,22,6],[0,12,0,14],[0,0,0,2],[0,3,0,9],[1,0,1,1],[1,3,1,4],[1,6,1,9],[2,8,2,9],[3,0,3,2],[3,4,3,6],[4,0,4,2],[4,4,4,6],[2,0,2,2],[2,4,2,6]]}
["Наименование турнира",null,null,null,null,null,null,null,null,null,null,null,"Список участников турнира"]
["Дата начала",null,"2018-04-13","Дата окончания",null,"2018-04-15","Количество дней проведения турнира",null,null,null,{"$f":"F2-C2+1","v":3},null,"№ п.п.","Название команды","Город"]
["Количество игр в первый день",null,null,5,"Количество игр в последний день",null,null,null,"Всего игр",null,{"$f":"D4*(D4-1)/2*H4","v":21},null,{"$f":"IF(N3=\"\",\"\",ROW()-2)","v":1},"Команда 1","А"]
["Количество команд участниц",null,null,{"$f":"COUNT(M3:M52)","v":7},"Количество кругов",null,null,1,null,null,null,null,{"$f":"IF(N4=\"\",\"\",ROW()-2)","v":2},"Команда 2","Б"]
["Количество групп",null,null,null,"Количество команд в группе",null,null,{"$f":"IFERROR(D4/D5,\"\")","v":""},null,null,null,null,3,"Команда 3","В"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Команда 4","Г"]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Команда 5","Д"]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Команда 6","Е"]
[null,null,null,null,null,null,null,null,null,null,null,null,7,"Команда 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,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,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Пример календаря","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,5,2,10]]}
["№ игры","Команда А","Команда Б"]
[1,"Команда 2\n(Б)","Команда 7\n(Ж)",null,null,"На данном листе производится создание пар исключающих повторение и задвоение игр"]
[2,"Команда 3\n(В)","Команда 6\n(Е)"]
[3,"Команда 4\n(Г)","Команда 5\n(Д)"]
[4,"Команда 6\n(Е)","Команда 4\n(Г)"]
[5,"Команда 7\n(Ж)","Команда 3\n(В)"]
[6,"Команда 1\n(А)","Команда 2\n(Б)"]
[7,"Команда 3\n(В)","Команда 1\n(А)"]
[8,"Команда 4\n(Г)","Команда 7\n(Ж)"]
[9,"Команда 5\n(Д)","Команда 6\n(Е)"]
[10,"Команда 7\n(Ж)","Команда 5\n(Д)"]
[11,"Команда 1\n(А)","Команда 4\n(Г)"]
[12,"Команда 2\n(Б)","Команда 3\n(В)"]
[13,"Команда 4\n(Г)","Команда 2\n(Б)"]
[14,"Команда 5\n(Д)","Команда 1\n(А)"]
[15,"Команда 6\n(Е)","Команда 7\n(Ж)"]
[16,"Команда 1\n(А)","Команда 6\n(Е)"]
[17,"Команда 2\n(Б)","Команда 5\n(Д)"]
[18,"Команда 3\n(В)","Команда 4\n(Г)"]
[19,"Команда 5\n(Д)","Команда 3\n(В)"]
[20,"Команда 6\n(Е)","Команда 2\n(Б)"]
[21,"Команда 7\n(Ж)","Команда 1\n(А)"]

{"sheet":"Игры по дням","index":2,"n_rows":100,"n_cols":11,"rows_kept":100,"cut":false,"hidden":false,"merged":[[2,10,14,16]]}
[null,null,null,1,"Игровой день"]
["№ игры","Дата","Время","Команда А","Команда Б","Счет А",null,"Счет Б","ОТ или Б"]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""},null,"На этом листе формируется расписание игровых дней, по нажатию кнопки \"Заполнение календаря\" вы можете увидеть по не заполненным ячейкам сколько и в какой день будет сформировано игровых пар и принеобходимости внести коррективы на листе \"Данные\". Перед этимнажать \"Очистка формы\", на листе \"Данные\" нажать \"Создать календарь\" и повторить  верхнюю часть данного примечания. До того как сформировать пары вы по своему желанию в списке пар можете записать в подготовленные ячейки или по одной команде в пару исходя ииз потребностей турнирра и условия прибытия и убытия команд.  После чего нажмите кнопку \"Заполнение пар\" и рарарасписание игр по дням сформируется. В колонки счет заполняйте результаты матчей, при системе с овертаймом и булитами проставляйте \"б\". На листе \"Таблица\" происходит формирование таблицы. Таблица формируется по двум ститемам начисления очков, которую выберете."]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,2,"Игровой день",null,null,null,{"$f":"\"\"","v":""}]
["№ игры","Дата","Время","Команда А","Команда Б","Счет А",null,"Счет Б",{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,3,"Игровой день",null,null,null,{"$f":"\"\"","v":""}]
["№ игры","Дата","Время","Команда А","Команда Б","Счет А",null,"Счет Б",{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,"-","-",null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"\"\"","v":""}]

{"sheet":"Таблица","index":3,"n_rows":34,"n_cols":62,"rows_kept":34,"cut":false,"hidden":false,"merged":[[13,8,13,11],[20,28,21,28],[22,25,23,25],[24,25,25,25],[26,25,27,25],[28,25,29,25],[30,25,31,25],[32,25,33,25],[22,28,23,28],[24,28,25,28],[26,28,27,28],[28,28,29,28],[30,28,31,28],[32,28,33,28],[16,0,16,35],[17,0,17,35],[18,2,18,4],[18,5,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,19],[18,20,18,22],[18,25,19,25],[18,28,19,28],[20,0,21,0],[20,1,21,1],[20,23,21,23],[20,24,21,24],[20,26,21,26],[20,27,21,27],[18,35,19,35],[19,2,19,4],[19,5,19,7],[19,8,19,10],[19,11,19,13],[19,14,19,16],[19,17,19,19],[19,20,19,22],[18,26,19,26],[18,27,19,27],[18,29,19,31],[18,32,19,32],[18,33,19,33],[18,34,19,34],[18,23,19,23],[18,24,19,24],[20,35,21,35],[20,25,21,25],[20,57,21,57],[20,58,21,58],[20,59,21,59],[20,60,21,60],[20,61,21,61],[20,29,21,29],[20,30,21,30],[20,31,21,31],[20,32,21,32],[20,33,21,33],[20,34,21,34],[22,59,23,59],[22,60,23,60],[22,61,23,61],[22,29,23,29],[22,30,23,30],[22,31,23,31],[22,32,23,32],[22,33,23,33],[22,34,23,34],[24,0,25,0],[24,1,25,1],[24,23,25,23],[24,24,25,24],[24,26,25,26],[24,27,25,27],[22,35,23,35],[22,57,23,57],[22,58,23,58],[22,0,23,0],[22,1,23,1],[22,23,23,23],[22,24,23,24],[22,26,23,26],[22,27,23,27],[24,35,25,35],[24,57,25,57],[24,58,25,58],[24,59,25,59],[24,60,25,60],[24,61,25,61],[24,29,25,29],[24,30,25,30],[24,31,25,31],[24,32,25,32],[24,33,25,33],[24,34,25,34],[26,59,27,59],[26,60,27,60],[26,61,27,61],[26,29,27,29],[26,30,27,30],[26,31,27,31],[26,32,27,32],[26,33,27,33],[26,34,27,34],[28,0,29,0],[28,1,29,1],[28,23,29,23],[28,24,29,24],[28,26,29,26],[28,27,29,27],[26,35,27,35],[26,57,27,57],[26,58,27,58],[26,0,27,0],[26,1,27,1],[26,23,27,23],[26,24,27,24],[26,26,27,26],[26,27,27,27],[28,35,29,35],[28,57,29,57],[28,58,29,58],[28,59,29,59],[28,60,29,60],[28,61,29,61],[28,29,29,29],[28,30,29,30],[28,31,29,31],[28,32,29,32],[28,33,29,33],[28,34,29,34],[30,59,31,59],[30,60,31,60],[30,61,31,61],[30,29,31,29],[30,30,31,30],[30,31,31,31],[30,32,31,32],[30,33,31,33],[30,34,31,34],[32,0,33,0],[32,1,33,1],[32,23,33,23],[32,24,33,24],[32,26,33,26],[32,27,33,27],[30,35,31,35],[30,57,31,57],[30,58,31,58],[30,0,31,0],[30,1,31,1],[30,23,31,23],[30,24,31,24],[30,26,31,26],[30,27,31,27],[32,35,33,35],[32,57,33,57],[32,58,33,58],[32,59,33,59],[32,60,33,60],[32,61,33,61],[32,29,33,29],[32,30,33,30],[32,31,33,31],[32,32,33,32],[32,33,33,33],[32,34,33,34]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,2]
[]
[]
[]
[]
[]
[null,null,{"$f":"B21","v":"Команда 1\n(А)"},null,null,{"$f":"B23","v":"Команда 2\n(Б)"},null,null,{"$f":"B25","v":"Команда 3\n(В)"},null,null,{"$f":"B27","v":"Команда 4\n(Г)"},null,null,{"$f":"B29","v":"Команда 5\n(Д)"},null,null,{"$f":"B31","v":"Команда 6\n(Е)"},null,null,{"$f":"B33","v":"Команда 7\n(Ж)"},null,null,"И","В","В (от)","Н","П","П (от)","Шайбы",null,null,"РШ","О","Рейтинг","М",null,1,null,null,2,null,null,3,null,null,4,null,null,5,null,null,6,null,null,7]
["№ п.п.","Команда",{"$f":"A21","v":1},null,null,{"$f":"A23","v":2},null,null,{"$f":"A25","v":3},null,null,{"$f":"A27","v":4},null,null,{"$f":"A29","v":5},null,null,{"$f":"A31","v":6},null,null,{"$f":"A33","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH21","v":0},null,null,{"$f":"AH23","v":0},null,null,{"$f":"AH25","v":0},null,null,{"$f":"AH27","v":0},null,null,{"$f":"AH29","v":0},null,null,{"$f":"AH31","v":0},null,null,{"$f":"AH33","v":0},null,"Очки М собой",null,"Ш",null,"Разн"]
[1,{"$f":"IF(A21=Данные!M3,CONCATENATE(Данные!N3,CHAR(10),\"(\",Данные!O3,\")\"),\"\")","v":"Команда 1\n(А)"},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&F19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&F19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(F19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(F19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(F21=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(F19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(F19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&F19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&F19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(I19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(I19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(I21=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(I19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(I19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(L19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(L19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(L21=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(L19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(L19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(O21=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(R21=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B21&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(U21=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B21&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"SUM(Y21:AC22)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C22:W22,2),IF($AB$13=2,COUNTIF(C22:W22,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C22:W22,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C22:W22,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C22:W22,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C22:W22,1),0)","v":0},{"$f":"SUM(C21,F21,I21,L21,O21,R21,U21)","v":0},"-",{"$f":"SUM(E21,H21,K21,N21,Q21,T21,W21)","v":0},{"$f":"AD21-AF21","v":0},{"$f":"SUM(C22:W22)","v":0},{"$f":"AH21*100000000000000+ BF21*1000000000000 + (BJ21+500)*1000000000 +(AG21+500)*1000000+Y21*10000+AD21*100+100-A21","v":500500000099},{"$f":"_xlfn.RANK.EQ(AI21,$AI$21:$AI$34)","v":1},{"$f":"IF($AH21=AL$20,C21,\"\")","v":""},null,{"$f":"IF($AH21=AL$20,E21,\"\")","v":""},{"$f":"IF($AH21=AO$20,F21,\"\")","v":""},null,{"$f":"IF($AH21=AO$20,H21,\"\")","v":""},{"$f":"IF($AH21=AR$20,I21,\"\")","v":""},null,{"$f":"IF($AH21=AR$20,K21,\"\")","v":""},{"$f":"IF($AH21=AU$20,L21,\"\")","v":""},null,{"$f":"IF($AH21=AU$20,N21,\"\")","v":""},{"$f":"IF($AH21=AX$20,O21,\"\")","v":""},null,{"$f":"IF($AH21=AX$20,Q21,\"\")","v":""},{"$f":"IF($AH21=BA$20,R21,\"\")","v":""},null,{"$f":"IF($AH21=BA$20,T21,\"\")","v":""},{"$f":"IF($AH21=BD$20,U21,\"\")","v":""},null,{"$f":"IF($AH21=BD$20,W21,\"\")","v":""},{"$f":"SUM(AK22:BE22)","v":0},{"$f":"SUM(AK21,AN21,AQ21,AT21,AW21,AZ21,BC21)","v":0},"-",{"$f":"SUM(AM21,AP21,AS21,AV21,AY21,BB21,BE21)","v":0},{"$f":"BF21-BI21","v":0}]
[null,null,null,{"$f":"\"\"","v":""},null,{"$f":"IF(AB13=2,IF(ISTEXT(INDEX('Игры по дням'!$I$3:$I$100,MATCH(B21&F19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$I$3:$I$100,MATCH(B21&F19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISTEXT(INDEX('Игры по дням'!$I$3:$I$100,MATCH(F19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$I$3:$I$100,MATCH(F19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\")),\"\")","v":""},{"$f":"IF($AB$13=1,IF(OR(F21=\"\",H21=\"\"),\"\",IF(F21>H21,2,IF(F21=H21,1,0))),IF($AB$13=2,IF(OR(F21=\"\",H21=\"\"),\"\",IF(F21>H21,IF(F22=\"\",3,2),IF(H21>F21,IF(F22=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISTEXT(INDEX('Игры по дням'!$I$3:$I$100,MATCH(B21&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$I$3:$I$100,MATCH(B21&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISTEXT(INDEX('Игры по дням'!$I$3:$I$100,MATCH(I19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$I$3:$I$100,MATCH(I19&B21,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF($AB$13=1,IF(OR(I21=\"\",K21=\"\"),\"\",IF(I21>K21,2,IF(I21=K21,1,0))),IF($AB$13=2,IF(OR(I21=\"\",K21=\"\"),\"\",IF(I21>K21,IF(I22=\"\",3,2),IF(K21>I21,IF(I22=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&L20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&L20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(L20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(L20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF($AB$13=1,IF(OR(L21=\"\",N21=\"\"),\"\",IF(L21>N21,2,IF(L21=N21,1,0))),IF($AB$13=2,IF(OR(L21=\"\",N21=\"\"),\"\",IF(L21>N21,IF(L22=\"\",3,2),IF(N21>L21,IF(L22=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&O20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&O20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(O20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(O20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF($AB$13=1,IF(OR(O21=\"\",Q21=\"\"),\"\",IF(O21>Q21,2,IF(O21=Q21,1,0))),IF($AB$13=2,IF(OR(O21=\"\",Q21=\"\"),\"\",IF(O21>Q21,IF(O22=\"\",3,2),IF(Q21>O21,IF(O22=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&R20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&R20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(R20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(R20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF($AB$13=1,IF(OR(R21=\"\",T21=\"\"),\"\",IF(R21>T21,2,IF(R21=T21,1,0))),IF($AB$13=2,IF(OR(R21=\"\",T21=\"\"),\"\",IF(R21>T21,IF(R22=\"\",3,2),IF(T21>R21,IF(R22=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&U20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B22&U20,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U20&B22,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF($AB$13=1,IF(OR(U21=\"\",W21=\"\"),\"\",IF(U21>W21,2,IF(U21=W21,1,0))),IF($AB$13=2,IF(OR(U21=\"\",W21=\"\"),\"\",IF(U21>W21,IF(U22=\"\",3,2),IF(W21>U21,IF(U22=\"\",0,1),\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH21=AL$20,D22,\"\")","v":""},null,null,{"$f":"IF($AH21=AO$20,G22,\"\")","v":""},null,null,{"$f":"IF($AH21=AR$20,J22,\"\")","v":""},null,null,{"$f":"IF($AH21=AU$20,M22,\"\")","v":""},null,null,{"$f":"IF($AH21=AX$20,P22,\"\")","v":""},null,null,{"$f":"IF($AH21=BA$20,S22,\"\")","v":""},null,null,{"$f":"IF($AH21=BD$20,V22,\"\")","v":""}]
[2,{"$f":"IF(A23=Данные!M4,CONCATENATE(Данные!N4,CHAR(10),\"(\",Данные!O4,\")\"),\"\")","v":"Команда 2\n(Б)"},{"$f":"IF(ISBLANK(H21),\"\",H21)","v":""},{"$f":"IF(C23=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(F21),\"\",F21)","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(I19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(I19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(I23=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(I19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(I19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&I19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(L19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(L19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(L23=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(L19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(L19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(O23=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(R23=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B23&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(U23=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B23,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B23&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"SUM(Y23:AC24)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C24:W24,2),IF($AB$13=2,COUNTIF(C24:W24,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C24:W24,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C24:W24,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C24:W24,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C24:W24,1),0)","v":0},{"$f":"SUM(C23,F23,I23,L23,O23,R23,U23)","v":0},"-",{"$f":"SUM(E23,H23,K23,N23,Q23,T23,W23)","v":0},{"$f":"AD23-AF23","v":0},{"$f":"SUM(C24:W24)","v":0},{"$f":"AH23*100000000000000+ BF23*1000000000000 + (BJ23+500)*1000000000 +(AG23+500)*1000000+Y23*10000+AD23*100+100-A23","v":500500000098},{"$f":"_xlfn.RANK.EQ(AI23,$AI$21:$AI$34)","v":2},{"$f":"IF($AH23=AL$20,C23,\"\")","v":""},null,{"$f":"IF($AH23=AL$20,E23,\"\")","v":""},{"$f":"IF($AH23=AO$20,F23,\"\")","v":""},null,{"$f":"IF($AH23=AO$20,H23,\"\")","v":""},{"$f":"IF($AH23=AR$20,I23,\"\")","v":""},null,{"$f":"IF($AH23=AR$20,K23,\"\")","v":""},{"$f":"IF($AH23=AU$20,L23,\"\")","v":""},null,{"$f":"IF($AH23=AU$20,N23,\"\")","v":""},{"$f":"IF($AH23=AX$20,O23,\"\")","v":""},null,{"$f":"IF($AH23=AX$20,Q23,\"\")","v":""},{"$f":"IF($AH23=BA$20,R23,\"\")","v":""},null,{"$f":"IF($AH23=BA$20,T23,\"\")","v":""},{"$f":"IF($AH23=BD$20,U23,\"\")","v":""},null,{"$f":"IF($AH23=BD$20,W23,\"\")","v":""},{"$f":"SUM(AK24:BE24)","v":0},{"$f":"SUM(AK23,AN23,AQ23,AT23,AW23,AZ23,BC23)","v":0},"-",{"$f":"SUM(AM23,AP23,AS23,AV23,AY23,BB23,BE23)","v":0},{"$f":"BF23-BI23","v":0}]
[null,null,{"$f":"IF(ISBLANK(F22),\"\",F22)","v":""},{"$f":"IF($AB$13=1,IF(OR(C23=\"\",E23=\"\"),\"\",IF(C23>E23,2,IF(C23=E23,1,0))),IF($AB$13=2,IF(OR(C23=\"\",E23=\"\"),\"\",IF(C23>E23,IF(C24=\"\",3,2),IF(E23>C23,IF(C24=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(I23=\"\",K23=\"\"),\"\",IF(I23>K23,2,IF(I23=K23,1,0))),IF($AB$13=2,IF(OR(I23=\"\",K23=\"\"),\"\",IF(I23>K23,IF(I24=\"\",3,2),IF(K23>I23,IF(I24=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(L23=\"\",N23=\"\"),\"\",IF(L23>N23,2,IF(L23=N23,1,0))),IF($AB$13=2,IF(OR(L23=\"\",N23=\"\"),\"\",IF(L23>N23,IF(L24=\"\",3,2),IF(N23>L23,IF(L24=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(O23=\"\",Q23=\"\"),\"\",IF(O23>Q23,2,IF(O23=Q23,1,0))),IF($AB$13=2,IF(OR(O23=\"\",Q23=\"\"),\"\",IF(O23>Q23,IF(O24=\"\",3,2),IF(Q23>O23,IF(O24=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(R23=\"\",T23=\"\"),\"\",IF(R23>T23,2,IF(R23=T23,1,0))),IF($AB$13=2,IF(OR(R23=\"\",T23=\"\"),\"\",IF(R23>T23,IF(R24=\"\",3,2),IF(T23>R23,IF(R24=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(U23=\"\",W23=\"\"),\"\",IF(U23>W23,2,IF(U23=W23,1,0))),IF($AB$13=2,IF(OR(U23=\"\",W23=\"\"),\"\",IF(U23>W23,IF(U24=\"\",3,2),IF(W23>U23,IF(U24=\"\",0,1),\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH23=AL$20,D24,\"\")","v":""},null,null,{"$f":"IF($AH23=AO$20,G24,\"\")","v":""},null,null,{"$f":"IF($AH23=AR$20,J24,\"\")","v":""},null,null,{"$f":"IF($AH23=AU$20,M24,\"\")","v":""},null,null,{"$f":"IF($AH23=AX$20,P24,\"\")","v":""},null,null,{"$f":"IF($AH23=BA$20,S24,\"\")","v":""},null,null,{"$f":"IF($AH23=BD$20,V24,\"\")","v":""}]
[3,{"$f":"IF(A25=Данные!M5,CONCATENATE(Данные!N5,CHAR(10),\"(\",Данные!O5,\")\"),\"\")","v":"Команда 3\n(В)"},{"$f":"IF(ISBLANK(K21),\"\",K21)","v":""},{"$f":"IF(C25=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(I21),\"\",I21)","v":""},{"$f":"IF(ISBLANK(K23),\"\",K23)","v":""},{"$f":"IF(F25=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(I23),\"\",I23)","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(L19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(L19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(L25=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(L19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(L19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&L19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(O25=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(R25=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B25&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(U25=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B25,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B25&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"SUM(Y25:AC26)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C26:W26,2),IF($AB$13=2,COUNTIF(C26:W26,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C26:W26,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C26:W26,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C26:W26,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C26:W26,1),0)","v":0},{"$f":"SUM(C25,F25,I25,L25,O25,R25,U25)","v":0},"-",{"$f":"SUM(E25,H25,K25,N25,Q25,T25,W25)","v":0},{"$f":"AD25-AF25","v":0},{"$f":"SUM(C26:W26)","v":0},{"$f":"AH25*100000000000000+ BF25*1000000000000 + (BJ25+500)*1000000000 +(AG25+500)*1000000+Y25*10000+AD25*100+100-A25","v":500500000097},{"$f":"_xlfn.RANK.EQ(AI25,$AI$21:$AI$34)","v":3},{"$f":"IF($AH25=AL$20,C25,\"\")","v":""},null,{"$f":"IF($AH25=AL$20,E25,\"\")","v":""},{"$f":"IF($AH25=AO$20,F25,\"\")","v":""},null,{"$f":"IF($AH25=AO$20,H25,\"\")","v":""},{"$f":"IF($AH25=AR$20,I25,\"\")","v":""},null,{"$f":"IF($AH25=AR$20,K25,\"\")","v":""},{"$f":"IF($AH25=AU$20,L25,\"\")","v":""},null,{"$f":"IF($AH25=AU$20,N25,\"\")","v":""},{"$f":"IF($AH25=AX$20,O25,\"\")","v":""},null,{"$f":"IF($AH25=AX$20,Q25,\"\")","v":""},{"$f":"IF($AH25=BA$20,R25,\"\")","v":""},null,{"$f":"IF($AH25=BA$20,T25,\"\")","v":""},{"$f":"IF($AH25=BD$20,U25,\"\")","v":""},null,{"$f":"IF($AH25=BD$20,W25,\"\")","v":""},{"$f":"SUM(AK26:BE26)","v":0},{"$f":"SUM(AK25,AN25,AQ25,AT25,AW25,AZ25,BC25)","v":0},"-",{"$f":"SUM(AM25,AP25,AS25,AV25,AY25,BB25,BE25)","v":0},{"$f":"BF25-BI25","v":0}]
[null,null,{"$f":"IF(ISBLANK(I22),\"\",I22)","v":""},{"$f":"IF($AB$13=1,IF(OR(C25=\"\",E25=\"\"),\"\",IF(C25>E25,2,IF(C25=E25,1,0))),IF($AB$13=2,IF(OR(C25=\"\",E25=\"\"),\"\",IF(C25>E25,IF(C26=\"\",3,2),IF(E25>C25,IF(C26=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(I24),\"\",I24)","v":""},{"$f":"IF($AB$13=1,IF(OR(F25=\"\",H25=\"\"),\"\",IF(F25>H25,2,IF(F25=H25,1,0))),IF($AB$13=2,IF(OR(F25=\"\",H25=\"\"),\"\",IF(F25>H25,IF(F26=\"\",3,2),IF(H25>F25,IF(F26=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(L25=\"\",N25=\"\"),\"\",IF(L25>N25,2,IF(L25=N25,1,0))),IF($AB$13=2,IF(OR(L25=\"\",N25=\"\"),\"\",IF(L25>N25,IF(L26=\"\",3,2),IF(N25>L25,IF(L26=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(O25=\"\",Q25=\"\"),\"\",IF(O25>Q25,2,IF(O25=Q25,1,0))),IF($AB$13=2,IF(OR(O25=\"\",Q25=\"\"),\"\",IF(O25>Q25,IF(O26=\"\",3,2),IF(Q25>O25,IF(O26=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(R25=\"\",T25=\"\"),\"\",IF(R25>T25,2,IF(R25=T25,1,0))),IF($AB$13=2,IF(OR(R25=\"\",T25=\"\"),\"\",IF(R25>T25,IF(R26=\"\",3,2),IF(T25>R25,IF(R26=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(U25=\"\",W25=\"\"),\"\",IF(U25>W25,2,IF(U25=W25,1,0))),IF($AB$13=2,IF(OR(U25=\"\",W25=\"\"),\"\",IF(U25>W25,IF(U26=\"\",3,2),IF(W25>U25,IF(U26=\"\",0,1),\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH25=AL$20,D26,\"\")","v":""},null,null,{"$f":"IF($AH25=AO$20,G26,\"\")","v":""},null,null,{"$f":"IF($AH25=AR$20,J26,\"\")","v":""},null,null,{"$f":"IF($AH25=AU$20,M26,\"\")","v":""},null,null,{"$f":"IF($AH25=AX$20,P26,\"\")","v":""},null,null,{"$f":"IF($AH25=BA$20,S26,\"\")","v":""},null,null,{"$f":"IF($AH25=BD$20,V26,\"\")","v":""}]
[4,{"$f":"IF(A27=Данные!M6,CONCATENATE(Данные!N6,CHAR(10),\"(\",Данные!O6,\")\"),\"\")","v":"Команда 4\n(Г)"},{"$f":"IF(ISBLANK(N21),\"\",N21)","v":""},{"$f":"IF(C27=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(L21),\"\",L21)","v":""},{"$f":"IF(ISBLANK(N23),\"\",N23)","v":""},{"$f":"IF(F27=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(L23),\"\",L23)","v":""},{"$f":"IF(ISBLANK(N25),\"\",N25)","v":""},{"$f":"IF(I27=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(L25),\"\",L25)","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B27&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B27&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(O19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(O27=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(O19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B27&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B27&O19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B27&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B27&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(R27=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B27&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B27&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B27&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B27&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(U27=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B27,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B27&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B27&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"SUM(Y27:AC28)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C28:W28,2),IF($AB$13=2,COUNTIF(C28:W28,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C28:W28,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C28:W28,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C28:W28,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C28:W28,1),0)","v":0},{"$f":"SUM(C27,F27,I27,L27,O27,R27,U27)","v":0},"-",{"$f":"SUM(E27,H27,K27,N27,Q27,T27,W27)","v":0},{"$f":"AD27-AF27","v":0},{"$f":"SUM(C28:W28)","v":0},{"$f":"AH27*100000000000000+ BF27*1000000000000 + (BJ27+500)*1000000000 +(AG27+500)*1000000+Y27*10000+AD27*100+100-A27","v":500500000096},{"$f":"_xlfn.RANK.EQ(AI27,$AI$21:$AI$34)","v":4},{"$f":"IF($AH27=AL$20,C27,\"\")","v":""},null,{"$f":"IF($AH27=AL$20,E27,\"\")","v":""},{"$f":"IF($AH27=AO$20,F27,\"\")","v":""},null,{"$f":"IF($AH27=AO$20,H27,\"\")","v":""},{"$f":"IF($AH27=AR$20,I27,\"\")","v":""},null,{"$f":"IF($AH27=AR$20,K27,\"\")","v":""},{"$f":"IF($AH27=AU$20,L27,\"\")","v":""},null,{"$f":"IF($AH27=AU$20,N27,\"\")","v":""},{"$f":"IF($AH27=AX$20,O27,\"\")","v":""},null,{"$f":"IF($AH27=AX$20,Q27,\"\")","v":""},{"$f":"IF($AH27=BA$20,R27,\"\")","v":""},null,{"$f":"IF($AH27=BA$20,T27,\"\")","v":""},{"$f":"IF($AH27=BD$20,U27,\"\")","v":""},null,{"$f":"IF($AH27=BD$20,W27,\"\")","v":""},{"$f":"SUM(AK28:BE28)","v":0},{"$f":"SUM(AK27,AN27,AQ27,AT27,AW27,AZ27,BC27)","v":0},"-",{"$f":"SUM(AM27,AP27,AS27,AV27,AY27,BB27,BE27)","v":0},{"$f":"BF27-BI27","v":0}]
[null,null,{"$f":"IF(ISBLANK(L22),\"\",L22)","v":""},{"$f":"IF($AB$13=1,IF(OR(C27=\"\",E27=\"\"),\"\",IF(C27>E27,2,IF(C27=E27,1,0))),IF($AB$13=2,IF(OR(C27=\"\",E27=\"\"),\"\",IF(C27>E27,IF(C28=\"\",3,2),IF(E27>C27,IF(C28=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(L24),\"\",L24)","v":""},{"$f":"IF($AB$13=1,IF(OR(F27=\"\",H27=\"\"),\"\",IF(F27>H27,2,IF(F27=H27,1,0))),IF($AB$13=2,IF(OR(F27=\"\",H27=\"\"),\"\",IF(F27>H27,IF(F28=\"\",3,2),IF(H27>F27,IF(F28=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(L26),\"\",L26)","v":""},{"$f":"IF($AB$13=1,IF(OR(I27=\"\",K27=\"\"),\"\",IF(I27>K27,2,IF(I27=K27,1,0))),IF($AB$13=2,IF(OR(I27=\"\",K27=\"\"),\"\",IF(I27>K27,IF(I28=\"\",3,2),IF(K27>I27,IF(I28=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(O27=\"\",Q27=\"\"),\"\",IF(O27>Q27,2,IF(O27=Q27,1,0))),IF($AB$13=2,IF(OR(O27=\"\",Q27=\"\"),\"\",IF(O27>Q27,IF(O28=\"\",3,2),IF(Q27>O27,IF(O28=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(R27=\"\",T27=\"\"),\"\",IF(R27>T27,2,IF(R27=T27,1,0))),IF($AB$13=2,IF(OR(R27=\"\",T27=\"\"),\"\",IF(R27>T27,IF(R28=\"\",3,2),IF(T27>R27,IF(R28=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(U27=\"\",W27=\"\"),\"\",IF(U27>W27,2,IF(U27=W27,1,0))),IF($AB$13=2,IF(OR(U27=\"\",W27=\"\"),\"\",IF(U27>W27,IF(U28=\"\",3,2),IF(W27>U27,IF(U28=\"\",0,1),\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH27=AL$20,D28,\"\")","v":""},null,null,{"$f":"IF($AH27=AO$20,G28,\"\")","v":""},null,null,{"$f":"IF($AH27=AR$20,J28,\"\")","v":""},null,null,{"$f":"IF($AH27=AU$20,M28,\"\")","v":""},null,null,{"$f":"IF($AH27=AX$20,P28,\"\")","v":""},null,null,{"$f":"IF($AH27=BA$20,S28,\"\")","v":""},null,null,{"$f":"IF($AH27=BD$20,V28,\"\")","v":""}]
[5,{"$f":"IF(A29=Данные!M7,CONCATENATE(Данные!N7,CHAR(10),\"(\",Данные!O7,\")\"),\"\")","v":"Команда 5\n(Д)"},{"$f":"IF(ISBLANK(Q21),\"\",Q21)","v":""},{"$f":"IF(C29=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(O21),\"\",O21)","v":""},{"$f":"IF(ISBLANK(Q23),\"\",Q23)","v":""},{"$f":"IF(F29=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(L23),\"\",L23)","v":""},{"$f":"IF(ISBLANK(Q25),\"\",Q25)","v":""},{"$f":"IF(I29=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(O25),\"\",O25)","v":""},{"$f":"IF(ISBLANK(Q27),\"\",Q27)","v":""},{"$f":"IF(L29=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(O27),\"\",O27)","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B29&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B29&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(R19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(R29=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(R19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B29&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B29&R19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B29&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B29&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(U29=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B29,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B29&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B29&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"SUM(Y29:AC30)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C30:W30,2),IF($AB$13=2,COUNTIF(C30:W30,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C30:W30,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C30:W30,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C30:W30,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C30:W30,1),0)","v":0},{"$f":"SUM(C29,F29,I29,L29,O29,R29,U29)","v":0},"-",{"$f":"SUM(E29,H29,K29,N29,Q29,T29,W29)","v":0},{"$f":"AD29-AF29","v":0},{"$f":"SUM(C30:W30)","v":0},{"$f":"AH29*100000000000000+ BF29*1000000000000 + (BJ29+500)*1000000000 +(AG29+500)*1000000+Y29*10000+AD29*100+100-A29","v":500500000095},{"$f":"_xlfn.RANK.EQ(AI29,$AI$21:$AI$34)","v":5},{"$f":"IF($AH29=AL$20,C29,\"\")","v":""},null,{"$f":"IF($AH29=AL$20,E29,\"\")","v":""},{"$f":"IF($AH29=AO$20,F29,\"\")","v":""},null,{"$f":"IF($AH29=AO$20,H29,\"\")","v":""},{"$f":"IF($AH29=AR$20,I29,\"\")","v":""},null,{"$f":"IF($AH29=AR$20,K29,\"\")","v":""},{"$f":"IF($AH29=AU$20,L29,\"\")","v":""},null,{"$f":"IF($AH29=AU$20,N29,\"\")","v":""},{"$f":"IF($AH29=AX$20,O29,\"\")","v":""},null,{"$f":"IF($AH29=AX$20,Q29,\"\")","v":""},{"$f":"IF($AH29=BA$20,R29,\"\")","v":""},null,{"$f":"IF($AH29=BA$20,T29,\"\")","v":""},{"$f":"IF($AH29=BD$20,U29,\"\")","v":""},null,{"$f":"IF($AH29=BD$20,W29,\"\")","v":""},{"$f":"SUM(AK30:BE30)","v":0},{"$f":"SUM(AK29,AN29,AQ29,AT29,AW29,AZ29,BC29)","v":0},"-",{"$f":"SUM(AM29,AP29,AS29,AV29,AY29,BB29,BE29)","v":0},{"$f":"BF29-BI29","v":0}]
[null,null,{"$f":"IF(ISBLANK(O22),\"\",O22)","v":""},{"$f":"IF($AB$13=1,IF(OR(C29=\"\",E29=\"\"),\"\",IF(C29>E29,2,IF(C29=E29,1,0))),IF($AB$13=2,IF(OR(C29=\"\",E29=\"\"),\"\",IF(C29>E29,IF(C30=\"\",3,2),IF(E29>C29,IF(C30=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(O24),\"\",O24)","v":""},{"$f":"IF($AB$13=1,IF(OR(F29=\"\",H29=\"\"),\"\",IF(F29>H29,2,IF(F29=H29,1,0))),IF($AB$13=2,IF(OR(F29=\"\",H29=\"\"),\"\",IF(F29>H29,IF(F30=\"\",3,2),IF(H29>F29,IF(F30=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(O26),\"\",O26)","v":""},{"$f":"IF($AB$13=1,IF(OR(I29=\"\",K29=\"\"),\"\",IF(I29>K29,2,IF(I29=K29,1,0))),IF($AB$13=2,IF(OR(I29=\"\",K29=\"\"),\"\",IF(I29>K29,IF(I30=\"\",3,2),IF(K29>I29,IF(I30=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(O28),\"\",O28)","v":""},{"$f":"IF($AB$13=1,IF(OR(L29=\"\",N29=\"\"),\"\",IF(L29>N29,2,IF(L29=N29,1,0))),IF($AB$13=2,IF(OR(L29=\"\",N29=\"\"),\"\",IF(L29>N29,IF(L30=\"\",3,2),IF(N29>L29,IF(L30=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(R29=\"\",T29=\"\"),\"\",IF(R29>T29,2,IF(R29=T29,1,0))),IF($AB$13=2,IF(OR(R29=\"\",T29=\"\"),\"\",IF(R29>T29,IF(R30=\"\",3,2),IF(T29>R29,IF(R30=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(U29=\"\",W29=\"\"),\"\",IF(U29>W29,2,IF(U29=W29,1,0))),IF($AB$13=2,IF(OR(U29=\"\",W29=\"\"),\"\",IF(U29>W29,IF(U30=\"\",3,2),IF(W29>U29,IF(U30=\"\",0,1),\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH29=AL$20,D30,\"\")","v":""},null,null,{"$f":"IF($AH29=AO$20,G30,\"\")","v":""},null,null,{"$f":"IF($AH29=AR$20,J30,\"\")","v":""},null,null,{"$f":"IF($AH29=AU$20,M30,\"\")","v":""},null,null,{"$f":"IF($AH29=AX$20,P30,\"\")","v":""},null,null,{"$f":"IF($AH29=BA$20,S30,\"\")","v":""},null,null,{"$f":"IF($AH29=BD$20,V30,\"\")","v":""}]
[6,{"$f":"IF(A31=Данные!M8,CONCATENATE(Данные!N8,CHAR(10),\"(\",Данные!O8,\")\"),\"\")","v":"Команда 6\n(Е)"},{"$f":"IF(ISBLANK(T21),\"\",T21)","v":""},{"$f":"IF(C31=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(R21),\"\",R21)","v":""},{"$f":"IF(ISBLANK(T23),\"\",T23)","v":""},{"$f":"IF(F31=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(R23),\"\",R23)","v":""},{"$f":"IF(ISBLANK(T25),\"\",T25)","v":""},{"$f":"IF(I31=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(R25),\"\",R25)","v":""},{"$f":"IF(ISBLANK(T27),\"\",T27)","v":""},{"$f":"IF(L31=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(R27),\"\",R27)","v":""},{"$f":"IF(ISBLANK(T29),\"\",T29)","v":""},{"$f":"IF(O31=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(R29),\"\",R29)","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(B31&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(B31&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B31,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(U19&B31,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"IF(U31=\"\",\"\",\":\")","v":""},{"$f":"IF(ISNUMBER(INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B31,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$F$3:$F$100,MATCH(U19&B31,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),IF(ISNUMBER(INDEX('Игры по дням'!$H$3:$H$100,MATCH(B31&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0))),INDEX('Игры по дням'!$H$3:$H$100,MATCH(B31&U19,'Игры по дням'!$D$3:$D$100&'Игры по дням'!$E$3:$E$100,0)),\"\"))","v":""},{"$f":"SUM(Y31:AC32)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C32:W32,2),IF($AB$13=2,COUNTIF(C32:W32,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C32:W32,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C32:W32,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C32:W32,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C32:W32,1),0)","v":0},{"$f":"SUM(C31,F31,I31,L31,O31,R31,U31)","v":0},"-",{"$f":"SUM(E31,H31,K31,N31,Q31,T31,W31)","v":0},{"$f":"AD31-AF31","v":0},{"$f":"SUM(C32:W32)","v":0},{"$f":"AH31*100000000000000+ BF31*1000000000000 + (BJ31+500)*1000000000 +(AG31+500)*1000000+Y31*10000+AD31*100+100-A31","v":500500000094},{"$f":"_xlfn.RANK.EQ(AI31,$AI$21:$AI$34)","v":6},{"$f":"IF($AH31=AL$20,C31,\"\")","v":""},null,{"$f":"IF($AH31=AL$20,E31,\"\")","v":""},{"$f":"IF($AH31=AO$20,F31,\"\")","v":""},null,{"$f":"IF($AH31=AO$20,H31,\"\")","v":""},{"$f":"IF($AH31=AR$20,I31,\"\")","v":""},null,{"$f":"IF($AH31=AR$20,K31,\"\")","v":""},{"$f":"IF($AH31=AU$20,L31,\"\")","v":""},null,{"$f":"IF($AH31=AU$20,N31,\"\")","v":""},{"$f":"IF($AH31=AX$20,O31,\"\")","v":""},null,{"$f":"IF($AH31=AX$20,Q31,\"\")","v":""},{"$f":"IF($AH31=BA$20,R31,\"\")","v":""},null,{"$f":"IF($AH31=BA$20,T31,\"\")","v":""},{"$f":"IF($AH31=BD$20,U31,\"\")","v":""},null,{"$f":"IF($AH31=BD$20,W31,\"\")","v":""},{"$f":"SUM(AK32:BE32)","v":0},{"$f":"SUM(AK31,AN31,AQ31,AT31,AW31,AZ31,BC31)","v":0},"-",{"$f":"SUM(AM31,AP31,AS31,AV31,AY31,BB31,BE31)","v":0},{"$f":"BF31-BI31","v":0}]
[null,null,{"$f":"IF(ISBLANK(R22),\"\",R22)","v":""},{"$f":"IF($AB$13=1,IF(OR(C31=\"\",E31=\"\"),\"\",IF(C31>E31,2,IF(C31=E31,1,0))),IF($AB$13=2,IF(OR(C31=\"\",E31=\"\"),\"\",IF(C31>E31,IF(C32=\"\",3,2),IF(E31>C31,IF(C32=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(R24),\"\",R24)","v":""},{"$f":"IF($AB$13=1,IF(OR(F31=\"\",H31=\"\"),\"\",IF(F31>H31,2,IF(F31=H31,1,0))),IF($AB$13=2,IF(OR(F31=\"\",H31=\"\"),\"\",IF(F31>H31,IF(F32=\"\",3,2),IF(H31>F31,IF(F32=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(R26),\"\",R26)","v":""},{"$f":"IF($AB$13=1,IF(OR(I31=\"\",K31=\"\"),\"\",IF(I31>K31,2,IF(I31=K31,1,0))),IF($AB$13=2,IF(OR(I31=\"\",K31=\"\"),\"\",IF(I31>K31,IF(I32=\"\",3,2),IF(K31>I31,IF(I32=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(R28),\"\",R28)","v":""},{"$f":"IF($AB$13=1,IF(OR(L31=\"\",N31=\"\"),\"\",IF(L31>N31,2,IF(L31=N31,1,0))),IF($AB$13=2,IF(OR(L31=\"\",N31=\"\"),\"\",IF(L31>N31,IF(L32=\"\",3,2),IF(N31>L31,IF(L32=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(R30),\"\",R30)","v":""},{"$f":"IF($AB$13=1,IF(OR(O31=\"\",Q31=\"\"),\"\",IF(O31>Q31,2,IF(O31=Q31,1,0))),IF($AB$13=2,IF(OR(O31=\"\",Q31=\"\"),\"\",IF(O31>Q31,IF(O32=\"\",3,2),IF(Q31>O31,IF(O32=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"\"\"","v":""},null,null,{"$f":"IF($AB$13=1,IF(OR(U31=\"\",W31=\"\"),\"\",IF(U31>W31,2,IF(U31=W31,1,0))),IF($AB$13=2,IF(OR(U31=\"\",W31=\"\"),\"\",IF(U31>W31,IF(U32=\"\",3,2),IF(W31>U31,IF(U32=\"\",0,1),\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH31=AL$20,D32,\"\")","v":""},null,null,{"$f":"IF($AH31=AO$20,G32,\"\")","v":""},null,null,{"$f":"IF($AH31=AR$20,J32,\"\")","v":""},null,null,{"$f":"IF($AH31=AU$20,M32,\"\")","v":""},null,null,{"$f":"IF($AH31=AX$20,P32,\"\")","v":""},null,null,{"$f":"IF($AH31=BA$20,S32,\"\")","v":""},null,null,{"$f":"IF($AH31=BD$20,V32,\"\")","v":""}]
[7,{"$f":"IF(A33=Данные!M9,CONCATENATE(Данные!N9,CHAR(10),\"(\",Данные!O9,\")\"),\"\")","v":"Команда 7\n(Ж)"},{"$f":"IF(ISBLANK(W21),\"\",W21)","v":""},{"$f":"IF(C33=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(U21),\"\",U21)","v":""},{"$f":"IF(ISBLANK(W23),\"\",W23)","v":""},{"$f":"IF(F33=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(U23),\"\",U23)","v":""},{"$f":"IF(ISBLANK(W25),\"\",W25)","v":""},{"$f":"IF(I33=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(U25),\"\",U25)","v":""},{"$f":"IF(ISBLANK(T27),\"\",T27)","v":""},{"$f":"IF(L33=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(R27),\"\",R27)","v":""},{"$f":"IF(ISBLANK(W29),\"\",W29)","v":""},{"$f":"IF(O33=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(U29),\"\",U29)","v":""},{"$f":"IF(ISBLANK(W31),\"\",W31)","v":""},{"$f":"IF(R33=\"\",\"\",\":\")","v":""},{"$f":"IF(ISBLANK(U31),\"\",U31)","v":""},{"$f":"\"\"","v":""},null,{"$f":"\"\"","v":""},{"$f":"SUM(Y33:AC34)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C34:W34,2),IF($AB$13=2,COUNTIF(C34:W34,3)))","v":0},{"$f":"IF($AB$13=2,COUNTIF(C34:W34,2),0)","v":0},{"$f":"IF($AB$13=1,COUNTIF(C34:W34,1),IF($AB$13=2,0))","v":0},{"$f":"COUNTIF(C34:W34,0)","v":0},{"$f":"IF($AB$13=2,COUNTIF(C34:W34,1),0)","v":0},{"$f":"SUM(C33,F33,I33,L33,O33,R33,U33)","v":0},"-",{"$f":"SUM(E33,H33,K33,N33,Q33,T33,W33)","v":0},{"$f":"AD33-AF33","v":0},{"$f":"SUM(C34:W34)","v":0},{"$f":"AH33*100000000000000+ BF33*1000000000000 + (BJ33+500)*1000000000 +(AG33+500)*1000000+Y33*10000+AD33*100+100-A33","v":500500000093},{"$f":"_xlfn.RANK.EQ(AI33,$AI$21:$AI$34)","v":7},{"$f":"IF($AH33=AL$20,C33,\"\")","v":""},null,{"$f":"IF($AH33=AL$20,E33,\"\")","v":""},{"$f":"IF($AH33=AO$20,F33,\"\")","v":""},null,{"$f":"IF($AH33=AO$20,H33,\"\")","v":""},{"$f":"IF($AH33=AR$20,I33,\"\")","v":""},null,{"$f":"IF($AH33=AR$20,K33,\"\")","v":""},{"$f":"IF($AH33=AU$20,L33,\"\")","v":""},null,{"$f":"IF($AH33=AU$20,N33,\"\")","v":""},{"$f":"IF($AH33=AX$20,O33,\"\")","v":""},null,{"$f":"IF($AH33=AX$20,Q33,\"\")","v":""},{"$f":"IF($AH33=BA$20,R33,\"\")","v":""},null,{"$f":"IF($AH33=BA$20,T33,\"\")","v":""},{"$f":"IF($AH33=BD$20,U33,\"\")","v":""},null,{"$f":"IF($AH33=BD$20,W33,\"\")","v":""},{"$f":"SUM(AK34:BE34)","v":0},{"$f":"SUM(AK33,AN33,AQ33,AT33,AW33,AZ33,BC33)","v":0},"-",{"$f":"SUM(AM33,AP33,AS33,AV33,AY33,BB33,BE33)","v":0},{"$f":"BF33-BI33","v":0}]
[null,null,{"$f":"IF(ISBLANK(U22),\"\",U22)","v":""},{"$f":"IF($AB$13=1,IF(OR(C33=\"\",E33=\"\"),\"\",IF(C33>E33,2,IF(C33=E33,1,0))),IF($AB$13=2,IF(OR(C33=\"\",E33=\"\"),\"\",IF(C33>E33,IF(C34=\"\",3,2),IF(E33>C33,IF(C34=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(U24),\"\",U24)","v":""},{"$f":"IF($AB$13=1,IF(OR(F33=\"\",H33=\"\"),\"\",IF(F33>H33,2,IF(F33=H33,1,0))),IF($AB$13=2,IF(OR(F33=\"\",H33=\"\"),\"\",IF(F33>H33,IF(F34=\"\",3,2),IF(H33>F33,IF(F34=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(U26),\"\",U26)","v":""},{"$f":"IF($AB$13=1,IF(OR(I33=\"\",K33=\"\"),\"\",IF(I33>K33,2,IF(I33=K33,1,0))),IF($AB$13=2,IF(OR(I33=\"\",K33=\"\"),\"\",IF(I33>K33,IF(I34=\"\",3,2),IF(K33>I33,IF(I34=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(U28),\"\",U28)","v":""},{"$f":"IF($AB$13=1,IF(OR(L33=\"\",N33=\"\"),\"\",IF(L33>N33,2,IF(L33=N33,1,0))),IF($AB$13=2,IF(OR(L33=\"\",N33=\"\"),\"\",IF(L33>N33,IF(L34=\"\",3,2),IF(N33>L33,IF(L34=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(U30),\"\",U30)","v":""},{"$f":"IF($AB$13=1,IF(OR(O33=\"\",Q33=\"\"),\"\",IF(O33>Q33,2,IF(O33=Q33,1,0))),IF($AB$13=2,IF(OR(O33=\"\",Q33=\"\"),\"\",IF(O33>Q33,IF(O34=\"\",3,2),IF(Q33>O33,IF(O34=\"\",0,1),\"\")))))","v":""},null,{"$f":"IF(ISBLANK(U32),\"\",U32)","v":""},{"$f":"IF($AB$13=1,IF(OR(R33=\"\",T33=\"\"),\"\",IF(R33>T33,2,IF(R33=T33,1,0))),IF($AB$13=2,IF(OR(R33=\"\",T33=\"\"),\"\",IF(R33>T33,IF(R34=\"\",3,2),IF(T33>R33,IF(R34=\"\",0,1),\"\")))))","v":""},null,null,{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AH33=AL$20,D34,\"\")","v":""},null,null,{"$f":"IF($AH33=AO$20,G34,\"\")","v":""},null,null,{"$f":"IF($AH33=AR$20,J34,\"\")","v":""},null,null,{"$f":"IF($AH33=AU$20,M34,\"\")","v":""},null,null,{"$f":"IF($AH33=AX$20,P34,\"\")","v":""},null,null,{"$f":"IF($AH33=BA$20,S34,\"\")","v":""},null,null,{"$f":"IF($AH33=BD$20,V34,\"\")","v":""}]