{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["2006 и мл","60","длина","метание","500","Побед и приз","Сводный","КОМАНДНЫЙ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"2006 и мл","index":0,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,0,2,20],[0,0,1,20]]}
["Добрый день. Помогите пожалуйста заполнить эту таблицу результатами с листов соответсвующего вида программы."]
[]
["Девочки  "]
["номер","Фамилия имя","Дата рождения","60м","очки авт","место","прыжок в длину ","очки","место","Сумма \n2х видов","место","метание мяча","очки","Место","Сумма \n3х видов","Место","бег\n500м.","очки","Место","сумма","Место"]
[0,0,"00:00:00",0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,"0"]
[null,"А",null,null,null,null,null,null,null,{"$f":"SUM(E6+H6)","v":0},{"$f":"IF(J6<=0,0,RANK(J6,J$6:J$19,0))","v":0},null,null,null,{"$f":"SUM(E6+H6+M6)","v":0},{"$f":"IF(O6<=0,0,RANK(O6,O$6:O$19,0))","v":0},null,null,null,{"$f":"SUM(E6+H6+M6+R6)","v":0},{"$f":"IF(T6<=0,0,RANK(T6,T$6:T$12,0))","v":0}]
[null,"Б",null,null,null,null,null,null,null,0,{"$f":"IF(J7<=0,0,RANK(J7,J$6:J$19,0))","v":0},null,null,null,0,{"$f":"IF(O7<=0,0,RANK(O7,O$6:O$19,0))","v":0},null,null,null,0,{"$f":"IF(T7<=0,0,RANK(T7,T$6:T$12,0))","v":0}]
[null,"В",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T8<=0,0,RANK(T8,T$6:T$12,0))","v":0}]
[null,"Г",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T9<=0,0,RANK(T9,T$6:T$21,0))","v":0}]
[null,"Д",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T10<=0,0,RANK(T10,T$6:T$21,0))","v":0}]
[null,"Е",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T11<=0,0,RANK(T11,T$6:T$12,0))","v":0}]
[null,"Ж",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T12<=0,0,RANK(T12,T$6:T$12,0))","v":0}]
[null,"З",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T13<=0,0,RANK(T13,T$6:T$12,0))","v":0}]
[null,"И",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T14<=0,0,RANK(T14,T$6:T$12,0))","v":0}]
[null,"К",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"IF(T15<=0,0,RANK(T15,T$6:T$21,0))","v":0}]
[null,"Л",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"М",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"Н",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"О",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"П",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"Р",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"С",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"Т",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"У",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,"Ф",null,null,null,null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]

{"sheet":"60","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,2],[2,3,2,5],[3,0,3,5]]}
[]
[]
[]
["Девочки  "]
["номер","Фамилия имя","Дата рождения","бег\n60м.","очки","Место"]
[0,0,"00:00:00",0,0,0]
[null,"А",null,10.8,152,{"$f":"IF(D7<=0,0,RANK(D7,D$7:D$13,D7-1))","v":5}]
[null,"Б",null,10.9,154,{"$f":"IF(D8<=0,0,RANK(D8,D$7:D$13,D8-1))","v":6}]
[null,"В",null,11,156,7]
[null,"Г",null,8.8000000000000007,97,1]
[null,"Д",null,8.9,101,2]
[null,"Е",null,9,104,3]
[null,"Ж",null,9.1,107,4]
[null,"З",null,9.1999999999999993,110,{"$f":"IF(D14<=0,0,RANK(D14,D$7:D$26,D14-1))","v":5}]
[null,"И",null,9.3000000000000007,113,6]
[null,"К",null,9.4,116,7]
[null,"Л",null,9.5,119,8]
[null,"М",null,9.6,122,9]
[null,"Н",null,9.6999999999999993,125,10]
[null,"О",null,9.8000000000000007,128,11]
[null,"П",null,9.9,131,12]
[null,"Р",null,10,134,13]
[null,"С",null,10.1,137,14]
[null,"Т",null,10.199999999999999,140,15]
[null,"У",null,10.3,142,16]
[null,"Ф",null,10.4,144,17]

{"sheet":"длина","index":2,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8]]}
[]
[]
[]
["Девочки"]
["номер","Фамилия имя","Дата рождения",1,2,3,"прыжок в длину ","очки","место"]
[0,0,"00:00:00",0,0,0,0,0,0]
[null,"А",null,372,null,null,{"$f":"MAX(D7,E7,F7)","v":372},39,{"$f":"IF(G7<=0,0,RANK(G7,G$7:G$26,0))","v":20}]
[null,"Б",null,375,null,null,375,40,{"$f":"IF(G8<=0,0,RANK(G8,G$7:G$26,0))","v":19}]
[null,"В",null,378,null,null,378,41,18]
[null,"Г",null,381,null,null,381,42,17]
[null,"Д",null,384,null,null,384,43,16]
[null,"Е",null,387,null,null,387,44,15]
[null,"Ж",null,390,null,null,390,45,14]
[null,"З",null,392,null,null,392,46,13]
[null,"И",null,394,null,null,394,47,12]
[null,"К",null,396,null,null,396,48,11]
[null,"Л",null,398,null,null,398,49,10]
[null,"М",null,400,null,null,400,50,9]
[null,"Н",null,403,null,null,403,51,8]
[null,"О",null,406,null,null,406,52,7]
[null,"П",null,409,null,null,409,53,6]
[null,"Р",null,412,null,null,{"$f":"MAX(D22,E22,F22)","v":412},54,5]
[null,"С",null,415,null,null,415,55,4]
[null,"Т",null,418,null,null,418,56,3]
[null,"У",null,421,null,null,421,57,2]
[null,"Ф",null,424,null,null,424,58,1]

{"sheet":"метание","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,2],[3,0,3,8]]}
[]
[]
[]
["Девочки "]
["номер","Фамилия имя","Дата рождения",1,2,3,"метание мяча","очки","Место"]
[null,"А",null,25,26,30,{"$f":"MAX(D6:F6)","v":30},48,{"$f":"IF(G6<=0,0,RANK(G6,G$6:G$12,0))","v":5}]
[null,"Б",null,25,null,null,{"$f":"MAX(D7:F7)","v":25},38,{"$f":"IF(G7<=0,0,RANK(G7,G$6:G$12,0))","v":7}]
[null,"В",null,29,null,null,29,46,6]
[null,"Г",null,32,null,null,32,52,4]
[null,"Д",null,33,null,null,33,54,3]
[null,"Е",null,35,null,null,35,58,2]
[null,"Ж",null,37,null,null,37,62,1]
[null,"З",null,29,null,null,29,46,{"$f":"IF(G13<=0,0,RANK(G13,G$6:G$25,0))","v":11}]
[null,"И",null,15,null,null,15,18,20]
[null,"К",null,18,null,null,18,24,18]
[null,"Л",null,28,null,null,{"$f":"MAX(D16:F16)","v":28},44,14]
[null,"М",null,16,null,null,16,20,19]
[null,"Н",null,22,null,null,22,32,17]
[null,"О",null,27,null,null,27,42,15]
[null,"П",null,39,null,null,39,66,3]
[null,"Р",null,48,null,null,48,84,1]
[null,"С",null,41,null,null,41,70,2]
[null,"Т",null,30,null,null,30,48,9]
[null,"У",null,29,null,null,29,46,11]
[null,"Ф",null,38,null,null,38,64,4]

{"sheet":"500","index":4,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,2],[2,3,2,5],[3,0,3,5]]}
[]
[]
[]
["Девочки  "]
["номер","Фамилия имя","Дата рождения","бег\n500м.","очки","Место"]
[0,0,"00:00:00","00:00:00",0,0]
[null,"А",null,"00:01:20.400",32.5,{"$f":"IF(D7<=0,0,RANK(D7,D$7:D$13,D7-1))","v":1}]
[null,"Б",null,"00:01:20.600",33,{"$f":"IF(D8<=0,0,RANK(D8,D$7:D$13,D8-1))","v":2}]
[null,"В",null,"00:01:20.800",33.5,3]
[null,"Г",null,"00:01:21",34,4]
[null,"Д",null,"00:01:21.200",34.5,5]
[null,"Е",null,"00:01:21.400",35,6]
[null,"Ж",null,"00:01:21.600",35.5,7]
[null,"З",null,"00:01:21.800",36,{"$f":"IF(D14<=0,0,RANK(D14,D$7:D$26,D14-1))","v":8}]
[null,"И",null,"00:01:22",36.5,9]
[null,"К",null,"00:01:22.200",37,10]
[null,"Л",null,"00:01:22.400",37.5,11]
[null,"М",null,"00:01:22.600",38,12]
[null,"Н",null,"00:01:22.800",38.5,13]
[null,"О",null,"00:01:23",39,14]
[null,"П",null,"00:01:23.200",39.5,15]
[null,"Р",null,"00:01:24",41.5,16]
[null,"С",null,"00:01:24.300",42,17]
[null,"Т",null,"00:01:24.600",42.5,18]
[null,"У",null,"00:01:24.900",43,19]
[null,"Ф",null,"00:01:25.200",43.5,20]

{"sheet":"Побед и приз","index":5,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,2,7]]}
["Сюда занести лучшие 10 результатов с каждого вида"]
[]
[]
["номер","Фамилия имя","Дата рождения",null,60,"финал","место"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["номер","Фамилия имя","Дата рождения",1,2,3,"прыжок в длину ","место"]
[null,null,null,null,null,null,{"$f":"MAX(D17:F17)","v":0}]
[null,null,null,null,null,null,{"$f":"MAX(D18:F18)","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[]
["номер","Фамилия имя","Дата рождения","метание мяча","очки","Место"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["номер","Фамилия имя","Дата рождения","бег\n500м.","Место"]

{"sheet":"Сводный","index":6,"n_rows":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,19,9,24],[0,0,0,17],[1,0,1,17],[2,0,2,7],[2,12,2,17],[3,0,3,17],[3,21,5,24]]}
["Заполнить Командный листок"]
[]
[]
["Девочки 2006-2007г.р.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Количество результатов\n по которым будут считать результат   \n Число может меняться "]
["№","Фамилия имя","Дата рожд","Команда","60м","очки","прыжок в длину ","очки","сумма 2х видов","место","метание","очки","Сумма \n3х видов","место","бег \n500 м","очки","сумма","Место",null,null,4]
[1,"А",null,"АА"]
[2,"Б",null,"АА"]
[3,"В",null,"АА"]
[4,"Г",null,"АА"]
[5,"Д",null,"АА",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(LARGE($Q$6:$Q$10,{1,2,3,4}))","v":{"$error":"#NUM!"}},"Сумма наибольших значений исходя из числа U5"]
[]
[1,"Е",null,"ББ"]
[2,"Ж",null,"ББ"]
[3,"З",null,"ББ"]
[4,"И",null,"ББ"]
[5,"К",null,"ББ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(LARGE($Q$12:$Q$16,{1,2,3,4}))","v":{"$error":"#NUM!"}}]
[]
[1,"Л",null,"ВВ"]
[2,"М",null,"ВВ"]
[3,"Н",null,"ВВ"]
[4,"О",null,"ВВ"]
[5,"П",null,"ВВ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(LARGE($Q$18:$Q$22,{1,2,3,4}))","v":{"$error":"#NUM!"}}]
[]
[1,"Р",null,"ГГ"]
[2,"С",null,"ГГ"]
[3,"Т",null,"ГГ"]
[4,"У",null,"ГГ"]
[5,"Ф",null,"ГГ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(LARGE($Q$24:$Q$28,{1,2,3,4}))","v":{"$error":"#NUM!"}}]

{"sheet":"КОМАНДНЫЙ","index":7,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,0,8,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"КОМАНДЫ","Очки","Место"]
[null,1,"АА","Командные очки из листа сводный"]
[null,2,"ББ"]
[null,3,"ВВ"]
[null,4,"ГГ"]