{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Лист4","Лист1","Лист2","Лист3"],"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":"Лист4","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист1","index":1,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[[43,0,43,18],[41,0,41,18],[0,0,0,18],[2,0,2,18],[1,0,1,18],[42,0,42,18]]}
["Тренировки по футболу"]
["2 класс"]
["Мальчики"]
["№","Фамилия Имя","Класс","21.09 ПТ","28.09 ПТ","05.10 ПТ","08.10 ПН","12.10 ПТ","15.10 ПН","22.10 ПН","23.11 ПТ","26.11 ПН","03.12 ПН","07.12 ПТ","13","14","15","16","17","18","Пропуск занятий Минус к среднему баллу","Средний балл","Место"]
[1,"Участник №1",2,6,7,6.5,"Н",6,"Н","Н",7,"Н","Н",8,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},{"$f":"AVERAGE(D5:T5)-U5","v":6.75},{"$f":"RANK(V5,$V$5:$V$40)","v":1}]
[2,"Участник №2",2,6,6.5,6.5,"Н",6,"Н","Н",6,"Н","Н",6.5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},6.25,2]
[7,"Участник №3",2,"Н",6,5.5,"Н",5.5,"Н","Н",6.5,"Н","Н",8,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},6.1,3]
[5,"Участник №4",2,6,5.5,6,5.5,"Н",5.5,6.5,"Н",8,7,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},5.85,5]
[4,"Участник №5",2,5,6,6,5.5,"Н",6,6,5.5,7,7,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},6,4]
[3,"Участник №6",2,6,6.5,6,"Н",6,"Н","Н",5.5,"Н","Н",5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},5.833333333333333,6]
[9,"Участник №7",2,5,5.5,5.5,5.5,"Н",6,6,5,6.5,5.5,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},5.6111111111111107,7]
[8,"Участник №8",2,"Н",6.5,5.5,"Н",6,"Н","Н",5.5,"Н","Н",5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},5.5,9]
[10,"Участник №9",2,4,7,5.5,5,"Н",5.5,6.5,"Н",5,6,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},5.5625,8]
[6,"Участник №10",2,5.5,5.5,7,"Н","Н","Н","Н","Н","Н","Н",5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},5.35,11]
[11,"Участник №11",2,"Н",5,5.5,"Н",4.5,"Н","Н",7,"Н","Н",6,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},5.3999999999999995,10]
[12,"Участник №12",2,"Н",5.5,5.5,"Н",4.5,"Н","Н",5,"Н","Н",4.5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},4.8,12]
[13,"Участник №13",2,6,5,4.5,"Н",4.5,"Н","Н",5,"Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},4.8,12]
[17,"Участник №14",2,5,"Н","Н","Н","Н","Н","Н","Н","Н","Н",5.5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.8},4.45,17]
[14,"Участник №15",2,5.5,"Н","Н","Н",4.5,"Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},4.5999999999999996,14]
[16,"Участник №16",2,"Н",5.5,4.5,"Н",5,"Н","Н",4.5,"Н","Н",4.5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},4.5999999999999996,14]
[15,"Участник №17",2,"Н",6,4.5,"Н",4.5,"Н","Н",4.5,"Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},4.4749999999999996,16]
[19,"Участник №18",2,5.5,5,3,"Н",4.5,"Н","Н",4.5,"Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},4.416666666666667,18]
[18,"Участник №19",2,"Н",4.5,4,"Н",5,"Н","Н",5,"Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},4.3,19]
[24,"Участник №20",2,4.5,4.5,"Н",5,"Н",4,"Н","Н",3.5,6,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},4.1833333333333327,21]
[20,"Участник №21",2,"Н",5,4,"Н",4.5,"Н","Н",4.5,"Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},4.2,20]
[22,"Участник №22",2,4,4.5,"Н","Н",4.5,"Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},3.9333333333333331,22]
[21,"Участник №23",2,5.5,4,3.5,3.5,"Н",3.5,6,"Н","Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},3.9333333333333331,22]
[23,"Участник №24",2,4.5,"Н","Н","Н","Н","Н","Н",4.5,"Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.60000000000000009},3.7333333333333329,25]
[27,"Участник №25",2,"Н",5,3.5,"Н",4,"Н","Н","Н","Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},3.7250000000000001,26]
[25,"Участник №26",2,4.5,5,3,"Н",4,"Н","Н",4,"Н","Н",3,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},3.9166666666666665,24]
[26,"Участник №27",2,"Н",4.5,"Н","Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":1.4000000000000001},3.0999999999999996,34]
[29,"Участник №28",2,5,4.5,1.5,"Н","Н","Н","Н",4.5,"Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},3.4750000000000001,28]
[32,"Участник №29",2,4,4,3,"Н",3.5,"Н","Н",3,"Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},3.5833333333333335,27]
[28,"Участник №30",2,"Н",5,3.5,"Н",4,"Н","Н","Н","Н","Н",2.5,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},3.35,32]
[30,"Участник №31",2,"Н","Н",3,"Н",4,"Н","Н",4.5,"Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.60000000000000009},3.2333333333333334,33]
[31,"Участник №32",2,4,3.5,1,3.5,"Н",2.5,"Н","Н",5,5.5,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.2},3.3714285714285714,31]
[35,"Участник №33",2,5,4,1.5,"Н",2,"Н","Н",2,"Н","Н",6,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},3.4166666666666665,29]
[33,"Участник №34",2,4,4,3,"Н",3.5,"Н","Н",2,"Н","Н",4,null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0},3.4166666666666665,29]
[34,"Участник №35",2,4,"Н",2.5,"Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.8},2.4500000000000002,36]
[36,"Участник №36",2,4,4.5,1,2,"Н","Н","Н","Н",3.5,2.5,"Н",null,null,null,null,null,null,{"$f":"0.2*Count_Color(Таблица1[[#This Row],[21.09 ПТ]:[18]])","v":0.4},2.5166666666666666,35]
[]
["Тренировки по футболу"]
["2 класс"]
["Девочки"]
["№","Фамилия Имя","Класс","21.09 ПТ","28.09 ПТ","05.10 ПТ","08.10 ПН","12.10 ПТ","15.10 ПН","22.10 ПН","23.11 ПТ","26.11 ПН","03.12 ПН","07.12 ПТ","13","14","15","16","17","18","Пропуск занятий Минус к среднему баллу","Средний балл","Место"]
[2,"Участник №1",2,5.5,"Н",6,6,"Н",7,6.5,"Н",8,8,"Н",null,null,null,null,null,null,0,{"$f":"AVERAGE(D46:T46)-U46","v":6.7142857142857144},{"$f":"RANK(V46,$V$46:$V$61)","v":2}]
[1,"Участник №2",2,"Н","Н","Н","Н","Н","Н","Н",7,"Н","Н","Н",null,null,null,null,null,null,0,7,1]
[3,"Участник №3",2,"Н","Н",6,"Н",5.5,"Н","Н",7,"Н","Н",6.5,null,null,null,null,null,null,0,6.25,5]
[4,"Участник №4",2,"Н",6.5,"Н","Н",6,"Н","Н","Н","Н","Н",6.5,null,null,null,null,null,null,0,6.333333333333333,4]
[null,"Участник №5",2,"Н","Н","Н","Н","Н","Н","Н","Н","Н","Н",6.5,null,null,null,null,null,null,0,6.5,3]
[5,"Участник №6",2,"Н",6,"Н","Н","Н","Н","Н",6,"Н","Н",6.5,null,null,null,null,null,null,0,6.166666666666667,7]
[8,"Участник №7",2,"Н","Н","Н","Н","Н","Н","Н",6,"Н","Н",6.5,null,null,null,null,null,null,0,6.25,5]
[6,"Участник №8",2,4.5,"Н",7,6,"Н",6.5,"Н","Н","Н","Н","Н",null,null,null,null,null,null,0,6,8]
[7,"Участник №9",2,"Н",6,"Н","Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,0,6,8]
[9,"Участник №10",2,"Н",6,"Н","Н","Н",6,"Н","Н","Н","Н","Н",null,null,null,null,null,null,0,6,8]
[11,"Участник №11",2,"Н",6,"Н","Н",5,"Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,0,5.5,11]
[10,"Участник №12",2,"Н","Н",5.5,5.5,"Н",6,"Н","Н","Н",5,"Н",null,null,null,null,null,null,0,5.5,11]
[12,"Участник №13",2,5,6,"Н","Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,0,5.5,11]
[13,"Участник №14",2,5.5,"Н",5,"Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,0,5.25,14]
[14,"Участник №15",2,"Н","Н",5,"Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,0,5,15]
[15,"Участник №16",2,4.5,"Н","Н","Н","Н","Н","Н","Н","Н","Н","Н",null,null,null,null,null,null,0,4.5,16]

{"sheet":"Лист2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}