{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["свод","м1","ОСН_М1","плавание (2)","отжимание (2)","Стрельба (2)","плавание","отжимание","Стрельба"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,2,1,3]]}
[]
["2019-07-30"]
[]
[]
[]
[null,"а","1998-05-17",{"$f":"DATEDIF(C6,свод!$A$2,\"y\")","v":21}]
[null,"б","1999-07-04",{"$f":"DATEDIF(C7,свод!$A$2,\"y\")","v":20}]
[null,"в","1993-07-01",{"$f":"DATEDIF(C8,свод!$A$2,\"y\")","v":26}]
[null,"г","2000-10-17",{"$f":"DATEDIF(C9,свод!$A$2,\"y\")","v":18}]
[null,"д","1989-10-17",{"$f":"DATEDIF(C10,свод!$A$2,\"y\")","v":29}]

{"sheet":"м1","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"а","1998-05-17",{"$f":"DATEDIF(C6,свод!$A$2,\"y\")","v":21},null,null,null,null,5,{"$f":"IF(I6=\"\",\"\",MAX((I6>=--(ОСН_М1!A$1:A$100))*(ОСН_М1!A$1:A$100<>\"\")*ROW(ОСН_М1!A$1:A$100)))","v":46}]
[null,"б","1999-07-04",{"$f":"DATEDIF(C7,свод!$A$2,\"y\")","v":20},null,null,null,null,12,{"$f":"IF(I7=\"\",\"\",MAX((I7>=--(ОСН_М1!A$1:A$100))*(ОСН_М1!A$1:A$100<>\"\")*ROW(ОСН_М1!A$1:A$100)))","v":62}]
[null,"в","1993-07-01",{"$f":"DATEDIF(C8,свод!$A$2,\"y\")","v":26},null,null,null,null,12,{"$f":"IF(I8=\"\",\"\",MAX((I8>=--(ОСН_М1!A$1:A$100))*(ОСН_М1!A$1:A$100<>\"\")*ROW(ОСН_М1!A$1:A$100)))","v":62},46]
[null,"г","2000-10-17",{"$f":"DATEDIF(C9,свод!$A$2,\"y\")","v":18},null,null,null,null,13,{"$f":"IF(I9=\"\",\"\",MAX((I9>=--(ОСН_М1!A$1:A$100))*(ОСН_М1!A$1:A$100<>\"\")*ROW(ОСН_М1!A$1:A$100)))","v":63}]
[null,"д","1989-10-17",{"$f":"DATEDIF(C10,свод!$A$2,\"y\")","v":29},null,null,null,null,14,{"$f":"IF(I10=\"\",\"\",MAX((I10>=--(ОСН_М1!A$1:A$100))*(ОСН_М1!A$1:A$100<>\"\")*ROW(ОСН_М1!A$1:A$100)))","v":63},52]
[]
[null,null,null,null,"1. если в столбце D будет значение от 18 до 24 (18,19,20,21,22,23,24), то формула в столбце J ищет значение на листе осн_м1 в столбце А, но если"]
[null,null,null,null,"2. в столбце D будет значение от 25 до 29 (25,26,27,28,29) то формула в столбце J должна искать значение на листе осн_м1 в столбце В"]

{"sheet":"ОСН_М1","index":2,"n_rows":100,"n_cols":2,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["1"]
[]
[]
[]
[]
[]
[null,1]
[]
[]
["2",2]
[]
[]
[null,3]
[]
[]
[null,4]
[]
[]
["3",5]
[]
[]
[null,6]
[]
[]
[null,7]
[]
[]
[null,8]
[]
[]
[null,9]
[]
[]
["4",10]
[]
[]
[null,11]
[]
[]
["5",12]
[]
[]
[null,13]
[]
[]
[null,14]
["6"]
[]
[null,15]
[]
[]
[null,16]
[]
["7"]
["9",17]
["11"]
["13"]
["15",18]
["17"]
["19"]
["21",19]
["22"]
["23"]
["24",20]
["25"]
["26"]
["27",21]
["28"]
[]
["29",22]
[]
["30"]
[null,23]
["31"]
[]
["32",24]
[]
["33"]
[null,25]
["34"]
[]
[null,26]
["35"]
[]
[null,27]
["36"]
[]
[null,28]
[]
["37"]
[null,29]
[]
[]
["38",30]

{"sheet":"плавание (2)","index":3,"n_rows":102,"n_cols":2,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,3,1,3]]}
["плавание","Очки"]
["25 м"]
[60.1,1]
[60.05,2]
[1.02,3]
[1,4]
[58,5]
[57,6]
[56,7]
[55,8]
[54,9]
[53,10]
[52,11]
[51,12]
[50,13]
[49,14]
[48,15]
[47,16]
[46,17]
[45,18]
[44.2,19]
[43.4,20]
[42.6,21]
[41.8,22]
[41,23]
[40.4,24]
[39.799999999999997,25]
[39.200000000000003,26]
[38.6,27]
[38,28]
[37.5,29]
[37,30]
[36.5,31]
[36,32]
[35.5,33]
[35,34]
[34.5,35]
[34,36]
[33.5,37]
[33,38]
[32.5,39]
[32,40]
[31.6,41]
[31.2,42]
[30.8,43]
[30.4,44]
[30,45]
[29.6,46]
[29.2,47]
[28.8,48]
[28.4,49]
[28,50]
[27.7,51]
[27.4,52]
[27.1,53]
[26.8,54]
[26.5,55]
[26.2,56]
[25.9,57]
[25.6,58]
[25.3,59]
[25,60]
[24.7,61]
[24.4,62]
[24.1,63]
[23.8,64]
[23.5,65]
[23.2,66]
[22.9,67]
[22.6,68]
[22.3,69]
[22,70]
[21.7,71]
[21.4,72]
[21.1,73]
[20.8,74]
[20.5,75]
[20.2,76]
[19.899999999999999,77]
[19.600000000000001,78]
[19.3,79]
[19,80]
[18.8,81]
[18.600000000000001,82]
[18.399999999999999,83]
[18.2,84]
[18,85]
[17.8,86]
[17.600000000000001,87]
[17.399999999999999,88]
[17.2,89]
[17,90]
[16.8,91]
[16.600000000000001,92]
[16.399999999999999,93]
[16.2,94]
[16,95]
[15.8,96]
[15.6,97]
[15.4,98]
[15.2,99]
[15,100]

{"sheet":"отжимание (2)","index":4,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,3,1,3]]}
["Стрельба ","Очки"]
["ВП\n5в\n"]
["-",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["-",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[1,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["-",4]
["-",5]
[2,6]
["-",7]
["-",8]
[3,9]
["-",10]
["-",11]
[4,12]
["-",13]
["-",14]
[5,15]
["-",16]
["-",17]
[6,18]
["-",19]
["-",20]
[7,21]
["-",22]
["-",23]
[8,24]
["-",25]
["-",26]
[9,27]
["-",28]
["-",29]
[10,30]
["-",31]
[11,32]
["-",33]
[12,34]
["-",35]
[13,36]
["-",37]
[14,38]
["-",39]
[15,40]
["-",41]
[16,42]
["-",43]
[17,44]
["-",45]
[18,46]
["-",47]
[19,48]
["-",49]
[20,50]
[21,51]
[22,52]
[23,53]
[24,54]
[25,55]
[26,56]
[27,57]
[28,58]
[29,59]
[30,60]
[31,61]
[32,62]
[33,63]
[34,64]
[35,65]
[36,66]
[37,67]
[38,68]
[39,69]
[40,70]
[42,71]
[44,72]
[46,73]
[48,74]
[50,75]
[52,76]
[54,77]
[56,78]
[58,79]
[60,80]
[62,81]
[64,82]
[66,83]
[68,84]
[70,85]
[72,86]
[74,87]
[76,88]
[78,89]
[80,90]
[82,91]
[84,92]
[86,93]
[88,94]
[90,95]
[92,96]
[94,97]
[96,98]
[98,99]
[100,100]

{"sheet":"Стрельба (2)","index":5,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,3,1,3],[0,1,1,1]]}
["Стрельба ","Очки"]
["ВП\n5в\n"]
[1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[2,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[4,4]
[5,5]
[6,6]
[7,7]
[8,8]
[9,9]
[10,10]
["-",11]
[11,12]
["-",13]
[12,14]
["-",15]
[13,16]
["-",17]
[14,18]
["-",19]
[15,20]
["-",21]
[16,22]
["-",23]
[17,24]
["-",25]
[18,26]
["-",27]
[19,28]
["-",29]
[20,30]
["-",31]
[21,32]
["-",33]
[22,34]
["-",35]
[23,36]
["-",37]
[24,38]
["-",39]
[25,40]
["-",41]
[26,42]
["-",43]
[27,44]
["-",45]
[28,46]
["-",47]
[29,48]
["-",49]
[30,50]
["-",51]
[31,52]
["-",53]
[32,54]
["-",55]
[33,56]
["-",57]
[34,58]
["-",59]
[35,60]
["-",61]
[36,62]
["-",63]
[37,64]
["-",65]
[38,66]
["-",67]
[39,68]
["-",69]
[40,70]
["-",71]
["-",72]
[41,73]
["-",74]
["-",75]
[42,76]
["-",77]
["-",78]
[43,79]
["-",80]
["-",81]
[44,82]
["-",83]
["-",84]
[45,85]
["-",86]
["-",87]
[46,88]
["-",89]
["-",90]
[47,91]
["-",92]
["-",93]
[48,94]
["-",95]
["-",96]
[49,97]
["-",98]
["-",99]
[50,100]

{"sheet":"плавание","index":6,"n_rows":102,"n_cols":2,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,3,1,3]]}
["плавание","Очки"]
["25 м"]
[60.1,1]
[60.05,2]
[1.02,3]
[1,4]
[58,5]
[57,6]
[56,7]
[55,8]
[54,9]
[53,10]
[52,11]
[51,12]
[50,13]
[49,14]
[48,15]
[47,16]
[46,17]
[45,18]
[44.2,19]
[43.4,20]
[42.6,21]
[41.8,22]
[41,23]
[40.4,24]
[39.799999999999997,25]
[39.200000000000003,26]
[38.6,27]
[38,28]
[37.5,29]
[37,30]
[36.5,31]
[36,32]
[35.5,33]
[35,34]
[34.5,35]
[34,36]
[33.5,37]
[33,38]
[32.5,39]
[32,40]
[31.6,41]
[31.2,42]
[30.8,43]
[30.4,44]
[30,45]
[29.6,46]
[29.2,47]
[28.8,48]
[28.4,49]
[28,50]
[27.7,51]
[27.4,52]
[27.1,53]
[26.8,54]
[26.5,55]
[26.2,56]
[25.9,57]
[25.6,58]
[25.3,59]
[25,60]
[24.7,61]
[24.4,62]
[24.1,63]
[23.8,64]
[23.5,65]
[23.2,66]
[22.9,67]
[22.6,68]
[22.3,69]
[22,70]
[21.7,71]
[21.4,72]
[21.1,73]
[20.8,74]
[20.5,75]
[20.2,76]
[19.899999999999999,77]
[19.600000000000001,78]
[19.3,79]
[19,80]
[18.8,81]
[18.600000000000001,82]
[18.399999999999999,83]
[18.2,84]
[18,85]
[17.8,86]
[17.600000000000001,87]
[17.399999999999999,88]
[17.2,89]
[17,90]
[16.8,91]
[16.600000000000001,92]
[16.399999999999999,93]
[16.2,94]
[16,95]
[15.8,96]
[15.6,97]
[15.4,98]
[15.2,99]
[15,100]

{"sheet":"отжимание","index":7,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,3,1,3]]}
["Стрельба ","Очки"]
["ВП\n5в\n"]
["-",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["-",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[1,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["-",4]
["-",5]
[2,6]
["-",7]
["-",8]
[3,9]
["-",10]
["-",11]
[4,12]
["-",13]
["-",14]
[5,15]
["-",16]
["-",17]
[6,18]
["-",19]
["-",20]
[7,21]
["-",22]
["-",23]
[8,24]
["-",25]
["-",26]
[9,27]
["-",28]
["-",29]
[10,30]
["-",31]
[11,32]
["-",33]
[12,34]
["-",35]
[13,36]
["-",37]
[14,38]
["-",39]
[15,40]
["-",41]
[16,42]
["-",43]
[17,44]
["-",45]
[18,46]
["-",47]
[19,48]
["-",49]
[20,50]
[21,51]
[22,52]
[23,53]
[24,54]
[25,55]
[26,56]
[27,57]
[28,58]
[29,59]
[30,60]
[31,61]
[32,62]
[33,63]
[34,64]
[35,65]
[36,66]
[37,67]
[38,68]
[39,69]
[40,70]
[42,71]
[44,72]
[46,73]
[48,74]
[50,75]
[52,76]
[54,77]
[56,78]
[58,79]
[60,80]
[62,81]
[64,82]
[66,83]
[68,84]
[70,85]
[72,86]
[74,87]
[76,88]
[78,89]
[80,90]
[82,91]
[84,92]
[86,93]
[88,94]
[90,95]
[92,96]
[94,97]
[96,98]
[98,99]
[100,100]

{"sheet":"Стрельба","index":8,"n_rows":102,"n_cols":19,"rows_kept":102,"cut":false,"hidden":true,"merged":[[0,3,1,3],[0,1,1,1]]}
["Стрельба ","Очки"]
["ВП\n5в\n"]
[1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[2,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[4,4]
[5,5]
[6,6]
[7,7]
[8,8]
[9,9]
[10,10]
["-",11]
[11,12]
["-",13]
[12,14]
["-",15]
[13,16]
["-",17]
[14,18]
["-",19]
[15,20]
["-",21]
[16,22]
["-",23]
[17,24]
["-",25]
[18,26]
["-",27]
[19,28]
["-",29]
[20,30]
["-",31]
[21,32]
["-",33]
[22,34]
["-",35]
[23,36]
["-",37]
[24,38]
["-",39]
[25,40]
["-",41]
[26,42]
["-",43]
[27,44]
["-",45]
[28,46]
["-",47]
[29,48]
["-",49]
[30,50]
["-",51]
[31,52]
["-",53]
[32,54]
["-",55]
[33,56]
["-",57]
[34,58]
["-",59]
[35,60]
["-",61]
[36,62]
["-",63]
[37,64]
["-",65]
[38,66]
["-",67]
[39,68]
["-",69]
[40,70]
["-",71]
["-",72]
[41,73]
["-",74]
["-",75]
[42,76]
["-",77]
["-",78]
[43,79]
["-",80]
["-",81]
[44,82]
["-",83]
["-",84]
[45,85]
["-",86]
["-",87]
[46,88]
["-",89]
["-",90]
[47,91]
["-",92]
["-",93]
[48,94]
["-",95]
["-",96]
[49,97]
["-",98]
["-",99]
[50,100]