{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["сводная таблица","Диплом","Сертификат","БП","Учет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["№ п/п","Номер заказа","ФИО","Учебное заведение","Город","Предмет","Класс","Коли-чество ответов","Педагог в р.п.","Вариант отправки","Проверил","Коли-чество баллов","Степень","Серия диплома","Для сохранения документа дважды кликните \"распечатать документ\""]
[1,2516,"Иванова Ольга","ГБОУ СОШ №25","Москва","математика",5,15,"Леваровой Елене Андреевне","эл.вар.",null,{"$f":"H2*100/15","v":100},{"$f":"IF(AND(OR(L2<100,L2=100),OR(L2>87,L2=87)),\"I СТЕПЕНИ\",IF(AND(OR(L2<87,L2=86),OR(L2>75,L2=75)),\"II СТЕПЕНИ\",IF(AND(OR(L2<75,L2=74),OR(L2>60,L2=60)),\"III СТЕПЕНИ\",IF(AND(L2<60,OR(L2>0,L2=0)),\"сертификат\"))))","v":"I СТЕПЕНИ"},{"$f":"IF(F2=\"Литературное чтение\",\"ЛЧ\",IF(F2=\"литература\",\"Л\",IF(F2=\"русский язык\",\"РЯ\",IF(F2=\"Математика\",\"М\",IF(F2=\"окружающий мир\",\"ОМ\",IF(F2=\"английский язык\",\"АЯ\",IF(F2=\"Немецкий язык\",\"НЯ\",IF(F2=\"История\",\"И\",IF(F2=\"Обществознание\",\"О\",IF(F2=\"География\",\"Г\",IF(F2=\"Биология\",\"Б\",IF(F2=\"Информатика\",\"И\"))))))))))))","v":"М"},"Сохранить документ","Диплом"]
[2,2516,"Иванова Ольга","ГБОУ СОШ №25","Москва","русский язык",5,8,null,"эл.вар.",null,{"$f":"H3*100/15","v":53.333333333333336},{"$f":"IF(AND(OR(L3<100,L3=100),OR(L3>87,L3=87)),\"I СТЕПЕНИ\",IF(AND(OR(L3<87,L3=86),OR(L3>75,L3=75)),\"II СТЕПЕНИ\",IF(AND(OR(L3<75,L3=74),OR(L3>60,L3=60)),\"III СТЕПЕНИ\",IF(AND(L3<60,OR(L3>0,L3=0)),\"сертификат\"))))","v":"сертификат"},{"$f":"IF(F3=\"Литературное чтение\",\"ЛЧ\",IF(F3=\"литература\",\"Л\",IF(F3=\"русский язык\",\"РЯ\",IF(F3=\"Математика\",\"М\",IF(F3=\"окружающий мир\",\"ОМ\",IF(F3=\"английский язык\",\"АЯ\",IF(F3=\"Немецкий язык\",\"НЯ\",IF(F3=\"История\",\"И\",IF(F3=\"Обществознание\",\"О\",IF(F3=\"География\",\"Г\",IF(F3=\"Биология\",\"Б\",IF(F3=\"Информатика\",\"И\"))))))))))))","v":"РЯ"},"Сохранить документ","Сертификат"]
[3,2516,"Иванова Ольга","ГБОУ СОШ №25","Москва","литература",5,13,null,"эл.вар.",null,86.666666666666671,"II СТЕПЕНИ","Л","Сохранить документ","БП"]

{"sheet":"Диплом","index":1,"n_rows":50,"n_cols":38,"rows_kept":50,"cut":false,"hidden":false,"merged":[[35,2,36,37],[49,2,50,37],[23,2,23,37],[24,2,24,37],[26,2,27,37],[29,2,30,37],[33,2,34,37],[10,25,11,27],[10,29,11,34],[22,2,22,37],[18,2,19,37],[14,2,16,37]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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(AD11,'сводная таблица'!A:A,'сводная таблица'!N:N)","v":"М"},null,null,null,{"$f":"AL12","v":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,1]
[]
[]
[null,null,"ДИПЛОМ"]
[]
[]
[]
[null,null,{"$f":"LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!M:M)","v":"I СТЕПЕНИ"}]
[]
[]
[]
[null,null,"Всероссийского конкурса"]
[null,null,"\"Алдын\""]
[null,null,"награждается"]
[]
[null,null,{"$f":"CONCATENATE(LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!C:C),\", \",LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!G:G),\" класс\")","v":"Иванова Ольга, 5 класс"}]
[]
[]
[null,null,{"$f":"CONCATENATE(LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!D:D),\", \",LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!E:E))","v":"ГБОУ СОШ №25, Москва"}]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"Набравший(ая)   \",LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!L:L),\"   баллов\")","v":"Набравший(ая)   100   баллов"}]
[]
[null,null,{"$f":"CONCATENATE(\"по предмету   \",LOOKUP(AD11,'сводная таблица'!A:A,'сводная таблица'!F:F))","v":"по предмету   математика"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Май 2016 г."]

{"sheet":"Сертификат","index":2,"n_rows":54,"n_cols":38,"rows_kept":54,"cut":false,"hidden":false,"merged":[[40,2,41,40],[53,2,54,40],[11,25,12,27],[11,29,12,34],[16,2,18,40],[20,2,22,40],[26,2,27,40],[29,2,30,40],[34,2,34,40],[35,2,35,40],[36,2,36,40]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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(AD12,'сводная таблица'!A:A,'сводная таблица'!N:N)","v":"РЯ"},null,null,null,{"$f":"AL12","v":2},null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[null,null,"СЕРТИФИКАТ"]
[]
[]
[]
[null,null,"УЧАСТНИКА"]
[]
[]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(LOOKUP(AD12,'сводная таблица'!A:A,'сводная таблица'!C:C),\", \",LOOKUP(AD12,'сводная таблица'!A:A,'сводная таблица'!G:G),\" класс\")","v":"Иванова Ольга, 5 класс"}]
[]
[]
[null,null,{"$f":"CONCATENATE(LOOKUP(AD12,'сводная таблица'!A:A,'сводная таблица'!D:D),\", \",LOOKUP(AD12,'сводная таблица'!A:A,'сводная таблица'!E:E))","v":"ГБОУ СОШ №25, Москва"}]
[]
[]
[]
[]
[null,null,"Принял(а) участие во"]
[null,null,"Всероссийском конкурсе"]
[null,null,"\"Алдын\""]
[]
[]
[]
[null,null,{"$f":"CONCATENATE(\"по предмету   \",LOOKUP(AD12,'сводная таблица'!A:A,'сводная таблица'!F:F))","v":"по предмету   русский язык"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Май 2016 г."]

{"sheet":"БП","index":3,"n_rows":51,"n_cols":38,"rows_kept":51,"cut":false,"hidden":false,"merged":[[32,2,33,37],[36,2,36,37],[37,2,37,37],[50,2,51,38],[12,29,13,34],[24,2,24,37],[25,2,25,37],[26,2,26,37],[29,2,30,37],[19,1,21,38],[15,1,17,38]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,3]
[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":"Y15","v":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,1]
[null,"БАГОДАРСТВЕННОЕ"]
[]
[]
[]
[null,"ПИСЬМО"]
[]
[]
[]
[]
[null,null,"Оргкомитет Всероссийского конкурса"]
[null,null,"\"Алдын\""]
[null,null,"выражает благодарность"]
[]
[]
[null,null,{"$f":"LOOKUP(AD13,'сводная таблица'!A:A,'сводная таблица'!I:I)","v":"Леваровой Елене Андреевне"}]
[]
[]
[null,null,{"$f":"CONCATENATE(LOOKUP(AD13,'сводная таблица'!A:A,'сводная таблица'!D:D),\", \",LOOKUP(AD13,'сводная таблица'!A:A,'сводная таблица'!E:E))","v":"ГБОУ СОШ №25, Москва"}]
[]
[]
[]
[null,null,"за организацию и проведение"]
[null,null,"конкурса"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Май 2016 г."]

{"sheet":"Учет","index":4,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,8,0,9],[2,4,2,6],[1,3,1,6],[2,3,3,3],[2,1,3,1],[2,2,3,2],[1,1,1,2]]}
[null,"подписка",null,null,null,null,null,null,"проверка"]
[null,"эл. Вар.",null,"Почта России",null,null,null,null,"№ заказа","Количество"]
[null,"№ заказа","Количество","№ заказа","Количество"]
[null,null,null,null,"диплом","сертификат","БП"]