{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Templ","Data","Вид 1","Protocol"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":4,"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":"Templ","index":0,"n_rows":32,"n_cols":28,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,26,6,26],[5,27,6,27],[19,16,22,16],[3,1,3,6],[14,3,14,6],[5,15,6,15],[5,16,6,16],[3,8,3,12],[3,13,3,16]]}
[1]
[]
[]
[null,"Список участников соревнований",null,null,null,null,null,null,"Название соревнований"]
[null,"№","Гимнастка","Год","Разряд","Город","Тренер",null,null,1,2,3,4,"Оценка","Сбавка","Сумма","МЕСТО",null,null,1,2,3,4,5,"Оценка","Сбавка","Сумма","МЕСТО"]
[null,1,null,null,null,null,null,null,"D",null,null,null,null,{"$f":"(SUM(J6:M6)-(MIN(J6:M6)+MAX(J6:M6)))/2","v":0},null,{"$f":"SUM(N6:N7)-SUM(O6:O7)","v":0},null,null,"D",null,null,null,null,null,{"$f":"(SUM(T6:W6)-(MIN(T6:W6)+MAX(T6:W6)))/2","v":0},null,{"$f":"SUM(Y6:Y7)-SUM(Z6:Z7)","v":0}]
[null,{"$f":"B6+1","v":2},null,null,null,null,null,null,"E",null,null,null,null,{"$f":"(SUM(J7:M7)-(MIN(J7:M7)+MAX(J7:M7)))/2","v":0},null,null,null,null,"E",null,null,null,null,null,{"$f":"(SUM(T7:X7)-(MIN(T7:X7)+MAX(T7:X7)))/3","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Сводный протокол"]
[]
[]
[]
[null,"№","Команда/Гимнастка","г.р.","Разряд","Город","Тренер",null,null,1,2,3,4,"Оценка","Сбавка","Сумма","МЕСТО"]
[null,1,null,null,null,null,null,null,"D1",null,null,null,null,{"$f":"(SUM(J20:M20)-(MIN(J20:M20)+MAX(J20:M20)))/2","v":0},null,{"$f":"SUM(N20:N23)-SUM(O20:O23)","v":0}]
[null,null,null,null,null,null,null,null,"D2",null,null,null,null,0]
[null,null,null,null,null,null,null,null,"A",null,null,null,null,{"$f":"(SUM(J22:M22)-(MIN(J22:M22)+MAX(J22:M22)))/2","v":0}]
[null,null,null,null,null,null,null,null,"E",null,null,null,null,{"$f":"(SUM(J23:M23)-(MIN(J23:M23)+MAX(J23:M23)))/2","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,"Главный судья"]
[]
[null,null,"Главный секретарь"]

{"sheet":"Data","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,1,7,6]]}
[]
[null,null,"Вид соревнований","Индивидуальные"]
[null,null,"Число участников",8]
[]
[null,null,"Количество видов:",1]
[null,null,"Вид оценки:",5]
[]
[null,"Список участников соревнований",null,null,null,null,null,null,"Жеребьевка"]
[null,"№","Гимнастка","Год","Разряд","Город","Тренер",null,"№","Гимнастка","Год","Разряд","Город"]
[null,1,"Serdyukova Anastasiya",1997,"09590","UZB",null,null,{"$f":"$B$17","v":8},{"$f":"$C$17","v":"Duquesne Cartaya /Yansy De La Caridad"},{"$f":"$D$17","v":1997},{"$f":"$E$17","v":23132},{"$f":"$F$17","v":"CUB"}]
[null,{"$f":"B10+1","v":2},"Polishchuk Viktoriia",1994,29944,"RUS Irkutsk",null,null,{"$f":"$B$10","v":1},{"$f":"$C$10","v":"Serdyukova Anastasiya"},{"$f":"$D$10","v":1997},{"$f":"$E$10","v":"09590"},{"$f":"$F$10","v":"UZB"}]
[null,3,"Liubomeiscaia Iuliana",1996,16583,"MDA",null,null,{"$f":"$B$11","v":2},{"$f":"$C$11","v":"Polishchuk Viktoriia"},{"$f":"$D$11","v":1994},{"$f":"$E$11","v":29944},{"$f":"$F$11","v":"RUS Irkutsk"}]
[null,4,"Milacic Milena",1995,18878,"SER",null,null,{"$f":"$B$14","v":5},{"$f":"$C$14","v":"Hamrikova Nataly"},{"$f":"$D$14","v":1993},{"$f":"$E$14","v":10481},{"$f":"$F$14","v":"CZE"}]
[null,5,"Hamrikova Nataly",1993,10481,"CZE",null,null,{"$f":"$B$12","v":3},{"$f":"$C$12","v":"Liubomeiscaia Iuliana"},{"$f":"$D$12","v":1996},{"$f":"$E$12","v":16583},{"$f":"$F$12","v":"MDA"}]
[null,6,"Sherstuk Irina",1998,"","UKR",null,null,{"$f":"$B$16","v":7},{"$f":"$C$16","v":" Omirou Irena"},{"$f":"$D$16","v":1998},{"$f":"$E$16","v":18614},{"$f":"$F$16","v":"CYP"}]
[null,7," Omirou Irena",1998,18614,"CYP",null,null,{"$f":"$B$13","v":4},{"$f":"$C$13","v":"Milacic Milena"},{"$f":"$D$13","v":1995},{"$f":"$E$13","v":18878},{"$f":"$F$13","v":"SER"}]
[null,8,"Duquesne Cartaya /Yansy De La Caridad",1997,23132,"CUB",null,null,{"$f":"$B$15","v":6},{"$f":"$C$15","v":"Sherstuk Irina"},{"$f":"$D$15","v":1998},{"$f":"$E$15","v":""},{"$f":"$F$15","v":"UKR"}]

{"sheet":"Вид 1","index":2,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[13,2,14,2],[9,12,10,12],[11,11,12,11],[11,12,12,12],[13,11,14,11],[13,12,14,12],[21,1,22,1],[21,2,22,2],[23,1,24,1],[23,2,24,2],[9,11,10,11],[15,1,16,1],[15,2,16,2],[17,1,18,1],[17,2,18,2],[19,1,20,1],[19,2,20,2],[9,1,10,1],[9,2,10,2],[11,1,12,1],[11,2,12,2],[13,1,14,1],[21,11,22,11],[21,12,22,12],[23,11,24,11],[23,12,24,12],[15,11,16,11],[15,12,16,12],[17,11,18,11],[17,12,18,12],[19,11,20,11],[19,12,20,12]]}
[null,null,null,2,9,13]
[]
[]
[]
[]
[]
[]
[]
[null,"№","Гимнастка",null,1,2,3,4,5,"Оценка","Сбавка","Сумма","МЕСТО"]
[null,{"$f":"Data!$B$17","v":8},{"$f":"Data!$C$17","v":"Duquesne Cartaya /Yansy De La Caridad"},"D",5.7,6.5,6,6.5,null,{"$f":"(SUM(E10:H10)-(MIN(E10:H10)+MAX(E10:H10)))/2","v":6.25},null,{"$f":"SUM(J10:J11)-SUM(K10:K11)","v":13.816666666666666},{"$f":"RANK(L10,$L$10:$L$25,0)","v":7}]
[null,null,null,"E",8.1999999999999993,7.4,7.7,7.5,7.5,{"$f":"(SUM(E11:I11)-(MIN(E11:I11)+MAX(E11:I11)))/3","v":7.5666666666666655}]
[null,{"$f":"Data!$B$10","v":1},{"$f":"Data!$C$10","v":"Serdyukova Anastasiya"},"D",8,8.6,7.9,8.6,null,{"$f":"(SUM(E12:H12)-(MIN(E12:H12)+MAX(E12:H12)))/2","v":8.3000000000000007},null,{"$f":"SUM(J12:J13)-SUM(K12:K13)","v":16.600000000000001},{"$f":"RANK(L12,$L$10:$L$25,0)","v":2}]
[null,null,null,"E",8.1,8.3000000000000007,8.1,8.6,8.5,{"$f":"(SUM(E13:I13)-(MIN(E13:I13)+MAX(E13:I13)))/3","v":8.3000000000000007}]
[null,{"$f":"Data!$B$11","v":2},{"$f":"Data!$C$11","v":"Polishchuk Viktoriia"},"D",8.6999999999999993,8.1999999999999993,7.8,8.8000000000000007,null,{"$f":"(SUM(E14:H14)-(MIN(E14:H14)+MAX(E14:H14)))/2","v":8.4499999999999993},null,{"$f":"SUM(J14:J15)-SUM(K14:K15)","v":16.95},{"$f":"RANK(L14,$L$10:$L$25,0)","v":1}]
[null,null,null,"E",8.9,8.5,8.6,8.4,8.3000000000000007,{"$f":"(SUM(E15:I15)-(MIN(E15:I15)+MAX(E15:I15)))/3","v":8.5}]
[null,{"$f":"Data!$B$14","v":5},{"$f":"Data!$C$14","v":"Hamrikova Nataly"},"D",7.4,7,5.6,6.8,null,{"$f":"(SUM(E16:H16)-(MIN(E16:H16)+MAX(E16:H16)))/2","v":6.9},null,{"$f":"SUM(J16:J17)-SUM(K16:K17)","v":15},{"$f":"RANK(L16,$L$10:$L$25,0)","v":3}]
[null,null,null,"E",8.4,8,8.3000000000000007,8,7.4,{"$f":"(SUM(E17:I17)-(MIN(E17:I17)+MAX(E17:I17)))/3","v":8.1}]
[null,{"$f":"Data!$B$12","v":3},{"$f":"Data!$C$12","v":"Liubomeiscaia Iuliana"},"D",6.5,7.2,6.4,7.3,null,{"$f":"(SUM(E18:H18)-(MIN(E18:H18)+MAX(E18:H18)))/2","v":6.8500000000000014},null,{"$f":"SUM(J18:J19)-SUM(K18:K19)","v":14.483333333333334},{"$f":"RANK(L18,$L$10:$L$25,0)","v":5}]
[null,null,null,"E",8.1,7.8,8.1,7.9,7.8,{"$f":"(SUM(E19:I19)-(MIN(E19:I19)+MAX(E19:I19)))/3","v":7.9333333333333327},0.3]
[null,{"$f":"Data!$B$16","v":7},{"$f":"Data!$C$16","v":" Omirou Irena"},"D",5.4,6,5.5,6.3,null,{"$f":"(SUM(E20:H20)-(MIN(E20:H20)+MAX(E20:H20)))/2","v":5.75},null,{"$f":"SUM(J20:J21)-SUM(K20:K21)","v":13.383333333333333},{"$f":"RANK(L20,$L$10:$L$25,0)","v":8}]
[null,null,null,"E",7.6,7.5,7.8,7.9,7.5,{"$f":"(SUM(E21:I21)-(MIN(E21:I21)+MAX(E21:I21)))/3","v":7.6333333333333329}]
[null,{"$f":"Data!$B$13","v":4},{"$f":"Data!$C$13","v":"Milacic Milena"},"D",6,6.6,5.8,6.4,null,{"$f":"(SUM(E22:H22)-(MIN(E22:H22)+MAX(E22:H22)))/2","v":6.1999999999999993},null,{"$f":"SUM(J22:J23)-SUM(K22:K23)","v":13.866666666666667},{"$f":"RANK(L22,$L$10:$L$25,0)","v":6}]
[null,null,null,"E",7.4,7.8,7.7,7.6,7.7,{"$f":"(SUM(E23:I23)-(MIN(E23:I23)+MAX(E23:I23)))/3","v":7.6666666666666679}]
[null,{"$f":"Data!$B$15","v":6},{"$f":"Data!$C$15","v":"Sherstuk Irina"},"D",7,6.9,6.7,7.2,null,{"$f":"(SUM(E24:H24)-(MIN(E24:H24)+MAX(E24:H24)))/2","v":6.95},null,{"$f":"SUM(J24:J25)-SUM(K24:K25)","v":14.883333333333333},{"$f":"RANK(L24,$L$10:$L$25,0)","v":4}]
[null,null,null,"E",7.9,7.5,8.1999999999999993,7.9,8,{"$f":"(SUM(E25:I25)-(MIN(E25:I25)+MAX(E25:I25)))/3","v":7.9333333333333336}]

{"sheet":"Protocol","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,3,7,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Сводный протокол"]
[null,"№","Гимнастка","Год","Город","Тренер","Вид 1","Место"]
[null,1,{"$f":"IF(ISBLANK(Data!$C$11), \"\", Data!$C$11)","v":"Polishchuk Viktoriia"},{"$f":"IF(ISBLANK(Data!$D$11), \"\", Data!$D$11)","v":1994},{"$f":"IF(ISBLANK(Data!$F$11), \"\", Data!$F$11)","v":"RUS Irkutsk"},{"$f":"IF(ISBLANK(Data!$G$11), \"\", Data!$G$11)","v":""},{"$f":"'Вид 1'!$L$14","v":16.95},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,2,{"$f":"IF(ISBLANK(Data!$C$10), \"\", Data!$C$10)","v":"Serdyukova Anastasiya"},{"$f":"IF(ISBLANK(Data!$D$10), \"\", Data!$D$10)","v":1997},{"$f":"IF(ISBLANK(Data!$F$10), \"\", Data!$F$10)","v":"UZB"},{"$f":"IF(ISBLANK(Data!$G$10), \"\", Data!$G$10)","v":""},{"$f":"'Вид 1'!$L$12","v":16.600000000000001},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,3,{"$f":"IF(ISBLANK(Data!$C$14), \"\", Data!$C$14)","v":"Hamrikova Nataly"},{"$f":"IF(ISBLANK(Data!$D$14), \"\", Data!$D$14)","v":1993},{"$f":"IF(ISBLANK(Data!$F$14), \"\", Data!$F$14)","v":"CZE"},{"$f":"IF(ISBLANK(Data!$G$14), \"\", Data!$G$14)","v":""},{"$f":"'Вид 1'!$L$16","v":15},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,4,{"$f":"IF(ISBLANK(Data!$C$15), \"\", Data!$C$15)","v":"Sherstuk Irina"},{"$f":"IF(ISBLANK(Data!$D$15), \"\", Data!$D$15)","v":1998},{"$f":"IF(ISBLANK(Data!$F$15), \"\", Data!$F$15)","v":"UKR"},{"$f":"IF(ISBLANK(Data!$G$15), \"\", Data!$G$15)","v":""},{"$f":"'Вид 1'!$L$24","v":14.883333333333333},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,5,{"$f":"IF(ISBLANK(Data!$C$12), \"\", Data!$C$12)","v":"Liubomeiscaia Iuliana"},{"$f":"IF(ISBLANK(Data!$D$12), \"\", Data!$D$12)","v":1996},{"$f":"IF(ISBLANK(Data!$F$12), \"\", Data!$F$12)","v":"MDA"},{"$f":"IF(ISBLANK(Data!$G$12), \"\", Data!$G$12)","v":""},{"$f":"'Вид 1'!$L$18","v":14.483333333333334},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,6,{"$f":"IF(ISBLANK(Data!$C$13), \"\", Data!$C$13)","v":"Milacic Milena"},{"$f":"IF(ISBLANK(Data!$D$13), \"\", Data!$D$13)","v":1995},{"$f":"IF(ISBLANK(Data!$F$13), \"\", Data!$F$13)","v":"SER"},{"$f":"IF(ISBLANK(Data!$G$13), \"\", Data!$G$13)","v":""},{"$f":"'Вид 1'!$L$22","v":13.866666666666667},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,7,{"$f":"IF(ISBLANK(Data!$C$17), \"\", Data!$C$17)","v":"Duquesne Cartaya /Yansy De La Caridad"},{"$f":"IF(ISBLANK(Data!$D$17), \"\", Data!$D$17)","v":1997},{"$f":"IF(ISBLANK(Data!$F$17), \"\", Data!$F$17)","v":"CUB"},{"$f":"IF(ISBLANK(Data!$G$17), \"\", Data!$G$17)","v":""},{"$f":"'Вид 1'!$L$10","v":13.816666666666666},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[null,8,{"$f":"IF(ISBLANK(Data!$C$16), \"\", Data!$C$16)","v":" Omirou Irena"},{"$f":"IF(ISBLANK(Data!$D$16), \"\", Data!$D$16)","v":1998},{"$f":"IF(ISBLANK(Data!$F$16), \"\", Data!$F$16)","v":"CYP"},{"$f":"IF(ISBLANK(Data!$G$16), \"\", Data!$G$16)","v":""},{"$f":"'Вид 1'!$L$20","v":13.383333333333333},{"$f":"RANK(#REF!,#REF!,0)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Главный судья"]
[]
[null,null,"Главный секретарь"]