{"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," Dulgheru Nicoleta",1999,20438,"MDA",null,null,{"$f":"$B$10","v":1},{"$f":"$C$10","v":" Dulgheru Nicoleta"},{"$f":"$D$10","v":1999},{"$f":"$E$10","v":20438},{"$f":"$F$10","v":"MDA"}]
[null,{"$f":"B10+1","v":2},"Kindelan Casanas Melissa Marian",1999,21737,"CUB",null,null,{"$f":"$B$11","v":2},{"$f":"$C$11","v":"Kindelan Casanas Melissa Marian"},{"$f":"$D$11","v":1999},{"$f":"$E$11","v":21737},{"$f":"$F$11","v":"CUB"}]
[null,3,"Mainovskaya Yelizaveta",1999,22863,"KAZ",null,null,{"$f":"$B$16","v":7},{"$f":"$C$16","v":"Osokin Ksenia"},{"$f":"$D$16","v":2001},{"$f":"$E$16","v":29146},{"$f":"$F$16","v":"ISR"}]
[null,4,"Balickaya Margaritaa",2001,"","UKR",null,null,{"$f":"$B$15","v":6},{"$f":"$C$15","v":"Maria Pires Delgado Testas "},{"$f":"$D$15","v":2000},{"$f":"$E$15","v":22900},{"$f":"$F$15","v":"POR"}]
[null,5," Le Thi Mai Huong",1999,22843,"CZE",null,null,{"$f":"$B$13","v":4},{"$f":"$C$13","v":"Balickaya Margaritaa"},{"$f":"$D$13","v":2001},{"$f":"$E$13","v":""},{"$f":"$F$13","v":"UKR"}]
[null,6,"Maria Pires Delgado Testas ",2000,22900,"POR",null,null,{"$f":"$B$12","v":3},{"$f":"$C$12","v":"Mainovskaya Yelizaveta"},{"$f":"$D$12","v":1999},{"$f":"$E$12","v":22863},{"$f":"$F$12","v":"KAZ"}]
[null,7,"Osokin Ksenia",2001,29146,"ISR",null,null,{"$f":"$B$14","v":5},{"$f":"$C$14","v":" Le Thi Mai Huong"},{"$f":"$D$14","v":1999},{"$f":"$E$14","v":22843},{"$f":"$F$14","v":"CZE"}]
[null,8,"Annenkova Irina",1999,23094,"RUS Moskow",null,null,{"$f":"$B$17","v":8},{"$f":"$C$17","v":"Annenkova Irina"},{"$f":"$D$17","v":1999},{"$f":"$E$17","v":23094},{"$f":"$F$17","v":"RUS Moskow"}]

{"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$10","v":1},{"$f":"Data!$C$10","v":" Dulgheru Nicoleta"},"D",6.4,7,7.1,7.5,null,{"$f":"(SUM(E10:H10)-(MIN(E10:H10)+MAX(E10:H10)))/2","v":7.05},null,{"$f":"SUM(J10:J11)-SUM(K10:K11)","v":15.583333333333332},{"$f":"RANK(L10,$L$10:$L$25,0)","v":2}]
[null,null,null,"E",8.6999999999999993,8.5,8.6,8.5,8.3000000000000007,{"$f":"(SUM(E11:I11)-(MIN(E11:I11)+MAX(E11:I11)))/3","v":8.5333333333333314}]
[null,{"$f":"Data!$B$11","v":2},{"$f":"Data!$C$11","v":"Kindelan Casanas Melissa Marian"},"D",null,null,null,null,null,{"$f":"(SUM(E12:H12)-(MIN(E12:H12)+MAX(E12:H12)))/2","v":0},null,14.617000000000001,{"$f":"RANK(L12,$L$10:$L$25,0)","v":4}]
[null,null,null,"E",null,null,null,null,null,{"$f":"(SUM(E13:I13)-(MIN(E13:I13)+MAX(E13:I13)))/3","v":0}]
[null,{"$f":"Data!$B$16","v":7},{"$f":"Data!$C$16","v":"Osokin Ksenia"},"D",null,null,null,null,null,{"$f":"(SUM(E14:H14)-(MIN(E14:H14)+MAX(E14:H14)))/2","v":0},null,13.75,{"$f":"RANK(L14,$L$10:$L$25,0)","v":6}]
[null,null,null,"E",null,null,null,null,null,{"$f":"(SUM(E15:I15)-(MIN(E15:I15)+MAX(E15:I15)))/3","v":0}]
[null,{"$f":"Data!$B$15","v":6},{"$f":"Data!$C$15","v":"Maria Pires Delgado Testas "},"D",5.0999999999999996,4.7,4,5,null,{"$f":"(SUM(E16:H16)-(MIN(E16:H16)+MAX(E16:H16)))/2","v":4.8500000000000005},null,{"$f":"SUM(J16:J17)-SUM(K16:K17)","v":12.283333333333335},{"$f":"RANK(L16,$L$10:$L$25,0)","v":8}]
[null,null,null,"E",7.4,7.9,7.5,7.4,7.1,{"$f":"(SUM(E17:I17)-(MIN(E17:I17)+MAX(E17:I17)))/3","v":7.4333333333333345}]
[null,{"$f":"Data!$B$13","v":4},{"$f":"Data!$C$13","v":"Balickaya Margaritaa"},"D",null,null,null,null,null,{"$f":"(SUM(E18:H18)-(MIN(E18:H18)+MAX(E18:H18)))/2","v":0},null,14.35,{"$f":"RANK(L18,$L$10:$L$25,0)","v":5}]
[null,null,null,"E",null,null,null,null,null,{"$f":"(SUM(E19:I19)-(MIN(E19:I19)+MAX(E19:I19)))/3","v":0}]
[null,{"$f":"Data!$B$12","v":3},{"$f":"Data!$C$12","v":"Mainovskaya Yelizaveta"},"D",null,null,null,null,null,{"$f":"(SUM(E20:H20)-(MIN(E20:H20)+MAX(E20:H20)))/2","v":0},null,15.032999999999999,{"$f":"RANK(L20,$L$10:$L$25,0)","v":3}]
[null,null,null,"E",null,null,null,null,null,{"$f":"(SUM(E21:I21)-(MIN(E21:I21)+MAX(E21:I21)))/3","v":0}]
[null,{"$f":"Data!$B$14","v":5},{"$f":"Data!$C$14","v":" Le Thi Mai Huong"},"D",6.2,5.4,4.3,5.8,null,{"$f":"(SUM(E22:H22)-(MIN(E22:H22)+MAX(E22:H22)))/2","v":5.6000000000000014},null,{"$f":"SUM(J22:J23)-SUM(K22:K23)","v":13.2},{"$f":"RANK(L22,$L$10:$L$25,0)","v":7}]
[null,null,null,"E",7.9,7.9,7.6,7.3,6.7,{"$f":"(SUM(E23:I23)-(MIN(E23:I23)+MAX(E23:I23)))/3","v":7.5999999999999988}]
[null,{"$f":"Data!$B$17","v":8},{"$f":"Data!$C$17","v":"Annenkova Irina"},"D",7.8,7.5,7.3,7.8,null,{"$f":"(SUM(E24:H24)-(MIN(E24:H24)+MAX(E24:H24)))/2","v":7.6500000000000012},null,{"$f":"SUM(J24:J25)-SUM(K24:K25)","v":16.350000000000001},{"$f":"RANK(L24,$L$10:$L$25,0)","v":1}]
[null,null,null,"E",8.6,8.6,8.6999999999999993,8.8000000000000007,8.8000000000000007,{"$f":"(SUM(E25:I25)-(MIN(E25:I25)+MAX(E25:I25)))/3","v":8.7000000000000011}]

{"sheet":"Protocol","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,3,7,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Сводный протокол","Мяч"]
[null,"№","Гимнастка","Год","Разряд","Город","Тренер","Вид 1","Сумма","Место"]
[null,1,{"$f":"IF(ISBLANK(Data!$C$17), \"\", Data!$C$17)","v":"Annenkova Irina"},{"$f":"IF(ISBLANK(Data!$D$17), \"\", Data!$D$17)","v":1999},{"$f":"IF(ISBLANK(Data!$E$17), \"\", Data!$E$17)","v":23094},{"$f":"IF(ISBLANK(Data!$F$17), \"\", Data!$F$17)","v":"RUS Moskow"},{"$f":"IF(ISBLANK(Data!$G$17), \"\", Data!$G$17)","v":""},{"$f":"'Вид 1'!$L$24","v":16.350000000000001},{"$f":"SUM(H10:H10)","v":16.350000000000001},{"$f":"RANK(I10,$I$10:$I$17,0)","v":1}]
[null,2,{"$f":"IF(ISBLANK(Data!$C$10), \"\", Data!$C$10)","v":" Dulgheru Nicoleta"},{"$f":"IF(ISBLANK(Data!$D$10), \"\", Data!$D$10)","v":1999},{"$f":"IF(ISBLANK(Data!$E$10), \"\", Data!$E$10)","v":20438},{"$f":"IF(ISBLANK(Data!$F$10), \"\", Data!$F$10)","v":"MDA"},{"$f":"IF(ISBLANK(Data!$G$10), \"\", Data!$G$10)","v":""},{"$f":"'Вид 1'!$L$10","v":15.583333333333332},{"$f":"SUM(H11:H11)","v":15.583333333333332},{"$f":"RANK(I11,$I$10:$I$17,0)","v":2}]
[null,3,{"$f":"IF(ISBLANK(Data!$C$12), \"\", Data!$C$12)","v":"Mainovskaya Yelizaveta"},{"$f":"IF(ISBLANK(Data!$D$12), \"\", Data!$D$12)","v":1999},{"$f":"IF(ISBLANK(Data!$E$12), \"\", Data!$E$12)","v":22863},{"$f":"IF(ISBLANK(Data!$F$12), \"\", Data!$F$12)","v":"KAZ"},{"$f":"IF(ISBLANK(Data!$G$12), \"\", Data!$G$12)","v":""},{"$f":"'Вид 1'!$L$20","v":15.032999999999999},{"$f":"SUM(H12:H12)","v":15.032999999999999},{"$f":"RANK(I12,$I$10:$I$17,0)","v":3}]
[null,4,{"$f":"IF(ISBLANK(Data!$C$11), \"\", Data!$C$11)","v":"Kindelan Casanas Melissa Marian"},{"$f":"IF(ISBLANK(Data!$D$11), \"\", Data!$D$11)","v":1999},{"$f":"IF(ISBLANK(Data!$E$11), \"\", Data!$E$11)","v":21737},{"$f":"IF(ISBLANK(Data!$F$11), \"\", Data!$F$11)","v":"CUB"},{"$f":"IF(ISBLANK(Data!$G$11), \"\", Data!$G$11)","v":""},{"$f":"'Вид 1'!$L$12","v":14.617000000000001},{"$f":"SUM(H13:H13)","v":14.617000000000001},{"$f":"RANK(I13,$I$10:$I$17,0)","v":4}]
[null,5,{"$f":"IF(ISBLANK(Data!$C$13), \"\", Data!$C$13)","v":"Balickaya Margaritaa"},{"$f":"IF(ISBLANK(Data!$D$13), \"\", Data!$D$13)","v":2001},{"$f":"IF(ISBLANK(Data!$E$13), \"\", Data!$E$13)","v":""},{"$f":"IF(ISBLANK(Data!$F$13), \"\", Data!$F$13)","v":"UKR"},{"$f":"IF(ISBLANK(Data!$G$13), \"\", Data!$G$13)","v":""},{"$f":"'Вид 1'!$L$18","v":14.35},{"$f":"SUM(H14:H14)","v":14.35},{"$f":"RANK(I14,$I$10:$I$17,0)","v":5}]
[null,6,{"$f":"IF(ISBLANK(Data!$C$16), \"\", Data!$C$16)","v":"Osokin Ksenia"},{"$f":"IF(ISBLANK(Data!$D$16), \"\", Data!$D$16)","v":2001},{"$f":"IF(ISBLANK(Data!$E$16), \"\", Data!$E$16)","v":29146},{"$f":"IF(ISBLANK(Data!$F$16), \"\", Data!$F$16)","v":"ISR"},{"$f":"IF(ISBLANK(Data!$G$16), \"\", Data!$G$16)","v":""},{"$f":"'Вид 1'!$L$14","v":13.75},{"$f":"SUM(H15:H15)","v":13.75},{"$f":"RANK(I15,$I$10:$I$17,0)","v":6}]
[null,7,{"$f":"IF(ISBLANK(Data!$C$14), \"\", Data!$C$14)","v":" Le Thi Mai Huong"},{"$f":"IF(ISBLANK(Data!$D$14), \"\", Data!$D$14)","v":1999},{"$f":"IF(ISBLANK(Data!$E$14), \"\", Data!$E$14)","v":22843},{"$f":"IF(ISBLANK(Data!$F$14), \"\", Data!$F$14)","v":"CZE"},{"$f":"IF(ISBLANK(Data!$G$14), \"\", Data!$G$14)","v":""},{"$f":"'Вид 1'!$L$22","v":13.2},{"$f":"SUM(H16:H16)","v":13.2},{"$f":"RANK(I16,$I$10:$I$17,0)","v":7}]
[null,8,{"$f":"IF(ISBLANK(Data!$C$15), \"\", Data!$C$15)","v":"Maria Pires Delgado Testas "},{"$f":"IF(ISBLANK(Data!$D$15), \"\", Data!$D$15)","v":2000},{"$f":"IF(ISBLANK(Data!$E$15), \"\", Data!$E$15)","v":22900},{"$f":"IF(ISBLANK(Data!$F$15), \"\", Data!$F$15)","v":"POR"},{"$f":"IF(ISBLANK(Data!$G$15), \"\", Data!$G$15)","v":""},{"$f":"'Вид 1'!$L$16","v":12.283333333333335},{"$f":"SUM(H17:H17)","v":12.283333333333335},{"$f":"RANK(I17,$I$10:$I$17,0)","v":8}]
[]
[]
[null,null,"Главный судья"]
[]
[null,null,"Главный секретарь"]