{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["сводная таблица","I степень","II степень","III степень","Сертификат","БП"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":7,"n_cols":20,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"ФИО","Учебное заведение","Город","Предмет","Класс","Колли-чество баллов","Степень","Баллы","Педагог","Вариант отправки","Номер заказа","Проверил","Серия диплома","Для сохранения документа дважды кликните \"распечатать документ\"",null,null,null,"Лист","Ячейка"]
[1,"Иванова Мария","Д/с №55","Москва","Изобразительное искусство",3,{"$f":"I2*100/15","v":86.666666666666671},{"$f":"IF(AND(OR(G2<100,G2=100),OR(G2>87,G2=87)),\"I\",IF(AND(OR(G2<87,G2=86),OR(G2>75,G2=75)),\"II\",IF(AND(OR(G2<75,G2=74),OR(G2>60,G2=60)),\"III\",IF(AND(G2<60,OR(G2>0,G2=0)),\"Участие\"))))","v":"II"},13,"Ивановой С.И.",null,null,null,{"$f":"IF(E2=\"Изобразительное искусство\",\"ИЗО\",IF(E2=\"Танцы\",\"Т\"))","v":"ИЗО"},"Сохранить документ",null,null,null,{"$f":"H2 & \" степень\"","v":"II степень"},"AL12"]
[{"$f":"A2+1","v":2},"Кошкин Георгий","Д/с №56","Москва","Изобразительное искусство",3,{"$f":"I3*100/15","v":66.666666666666671},{"$f":"IF(AND(OR(G3<100,G3=100),OR(G3>87,G3=87)),\"I\",IF(AND(OR(G3<87,G3=86),OR(G3>75,G3=75)),\"II\",IF(AND(OR(G3<75,G3=74),OR(G3>60,G3=60)),\"III\",IF(AND(G3<60,OR(G3>0,G3=0)),\"Участие\"))))","v":"III"},10,null,null,null,null,{"$f":"IF(E3=\"Изобразительное искусство\",\"ИЗО\",IF(E3=\"Танцы\",\"Т\"))","v":"ИЗО"},"Сохранить документ",null,null,null,{"$f":"H3 & \" степень\"","v":"III степень"},"AL12"]
[{"$f":"A3+1","v":3},"Кошкин Георгий","Д/с №57","Москва","Танцы",3,100,"I",15,null,null,null,null,"Т","Сохранить документ",null,null,null,"I степень","AL12"]
[4,"Кошкин Георгий","Д/с №58","Москва","Танцы",3,40,"Участие",6,null,null,null,null,"Т","Сохранить документ",null,null,null,"Сертификат","T9"]
[5,"Иванова Мария","Д/с №59","Москва","Танцы",3,100,"I",15,null,null,null,null,"Т","Сохранить документ",null,null,null,"I степень","AL12"]
[6,"Трофимов Игорь","Д/с №60","Москва","Танцы",3,100,"I",15,null,null,null,null,"Т","Сохранить документ",null,null,null,"I степень","AL12"]

{"sheet":"I степень","index":1,"n_rows":38,"n_cols":38,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,4,38,7],[27,3,28,50],[24,3,25,48],[30,17,30,19],[11,33,12,35],[11,37,12,41],[17,19,18,33],[20,26,20,30],[22,23,22,29]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!N:N)","v":"Т"},null,null,null,6]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Диплом"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",null,null,"степени"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"награждаетя"]
[]
[null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!B:B)","v":"Трофимов Игорь"}]
[]
[]
[null,null,null,{"$f":"CONCATENATE(LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!C:C),\", г. \",LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!D:D))","v":"Д/с №60, г. Москва"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!G:G)","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!E:E)","v":"Танцы"}]
[]
[]
[]
[]
[null,null,null,null,"2015 г."]

{"sheet":"II степень","index":2,"n_rows":37,"n_cols":38,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,4,37,7],[11,33,12,35],[11,37,12,41],[23,3,24,48],[26,3,27,50],[29,17,29,19],[15,19,16,33],[18,26,18,30],[20,23,20,29]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!N:N)","v":"ИЗО"},null,null,null,1]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Диплом"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"II",null,null,"степени"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"награждаетя"]
[]
[]
[null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!B:B)","v":"Иванова Мария"}]
[]
[]
[null,null,null,{"$f":"CONCATENATE(LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!C:C),\", г. \",LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!D:D))","v":"Д/с №55, г. Москва"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!G:G)","v":86.666666666666671}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!E:E)","v":"Изобразительное искусство"}]
[]
[]
[]
[]
[null,null,null,null,"2015 г."]

{"sheet":"III степень","index":3,"n_rows":37,"n_cols":38,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,4,37,7],[11,33,12,35],[11,37,12,41],[23,3,24,48],[26,3,27,50],[29,17,29,19],[14,18,15,32],[17,25,17,29],[19,22,19,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!N:N)","v":"ИЗО"},null,null,null,2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Диплом"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"III",null,null,"степени"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"награждаетя"]
[]
[]
[]
[null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!B:B)","v":"Кошкин Георгий"}]
[]
[]
[null,null,null,{"$f":"CONCATENATE(LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!C:C),\", г. \",LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!D:D))","v":"Д/с №56, г. Москва"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!G:G)","v":66.666666666666671}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AL12,'сводная таблица'!A:A,'сводная таблица'!E:E)","v":"Изобразительное искусство"}]
[]
[]
[]
[]
[null,null,null,null,"2015 г."]

{"sheet":"Сертификат","index":4,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,11,28,25],[37,3,37,6],[8,15,9,17],[8,19,9,23],[24,2,24,25],[26,2,26,25]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(T9,'сводная таблица'!A:A,'сводная таблица'!N:N)","v":"Т"},null,null,null,4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"LOOKUP(T9,'сводная таблица'!A:A,'сводная таблица'!B:B)","v":"Кошкин Георгий"}]
[]
[null,null,{"$f":"CONCATENATE(LOOKUP(T9,'сводная таблица'!A:A,'сводная таблица'!C:C),\", г. \",LOOKUP(T9,'сводная таблица'!A:A,'сводная таблица'!D:D))","v":"Д/с №58, г. Москва"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(T9,'сводная таблица'!A:A,'сводная таблица'!E:E)","v":"Танцы"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2015 г."]

{"sheet":"БП","index":5,"n_rows":37,"n_cols":25,"rows_kept":37,"cut":false,"hidden":false,"merged":[[14,24,15,31],[23,3,24,44],[26,3,27,44],[36,3,37,6],[18,17,18,30],[20,20,20,26]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Организаторы работы выражают"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"благодарность"]
[]
[]
[null,null,null,{"$f":"LOOKUP(Y15,'сводная таблица'!A:A,'сводная таблица'!J:J)","v":"Ивановой С.И."}]
[]
[]
[null,null,null,{"$f":"CONCATENATE(LOOKUP(Y15,'сводная таблица'!A:A,'сводная таблица'!C:C),\", г. \",LOOKUP(Y15,'сводная таблица'!A:A,'сводная таблица'!D:D))","v":"Д/с №55, г. Москва"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2015 г."]