{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["сводные","Данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":120,"n_cols":14,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
["8",{"$f":"WEEKNUM(NOW(),2)-($A$1-COLUMN())&\" нед.\"","v":"38 нед."},{"$f":"WEEKNUM(NOW(),2)-($A$1-COLUMN())&\" нед.\"","v":"39 нед."},"40 нед.","41 нед.","42 нед.","43 нед.","44 нед.","45 нед.",null,null,null,"35 нед.",{"$f":"IF(ISBLANK(M1),\"\",COUNTIF($B$1:$K$1,\"=\"&M1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"36 нед.",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"37 нед.",0]
["Признак Должность","Приёмщик",null,null,null,null,null,null,null,null,null,null,"38 нед.",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"39 нед.",1]
["Сумма по полю КолвоПаллет","Неделя",null,null,null,null,null,null,null,null,null,null,"40 нед.",1]
["РЦ","38 нед.","39 нед.","40 нед.","41 нед.","42 нед.","Общий итог",null,null,null,null,null,"41 нед.",1]
["Замкадье",651,667,129,1065,581,3093,null,null,null,null,null,"42 нед.",1]
["Общий итог",651,667,129,1065,581,3093,null,null,null,null,null,"43 нед.",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"44 нед.",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"45 нед.",1]
["Признак Должность","(Все)",null,null,null,null,null,null,null,null,null,null,"46 нед.",0]
[null,null,null,null,null,null,null,null,null,null,null,null,"47 нед.",0]
["Сумма по полю КолвоПаллет","Неделя",null,null,null,null,null,null,null,null,null,null,"48 нед.",0]
["РЦ","38 нед.","39 нед.","40 нед.","41 нед.","42 нед.","(пусто)","Общий итог",null,null,null,null,"49 нед.",0]
["(пусто)",null,null,null,null,null,null,null,null,null,null,null,null,""]
["Замкадье",651,667,162,1065,581,null,3126,null,null,null,null,null,""]
["Общий итог",651,667,162,1065,581,null,3126,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,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,""]
["Столбцы N и M можно скрыть или перенести на другой лист где данные не будут мешать.",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,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,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,null,null,null,{"$f":"IF(ISBLANK(M33),\"\",COUNTIF($B$1:$K$1,\"=\"&M33))","v":""}]
[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,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,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,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,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,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,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,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,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,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":"IF(ISBLANK(M65),\"\",COUNTIF($B$1:$K$1,\"=\"&M65))","v":""}]
[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,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,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,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,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,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,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,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,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,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":"IF(ISBLANK(M97),\"\",COUNTIF($B$1:$K$1,\"=\"&M97))","v":""}]
[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,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,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,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,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,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,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,null,null,null,null,null,""]

{"sheet":"Данные","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["РЦ","Неделя","День","Приемщик","Смена ут","Признак Должность","Сумма по полю Сумма по полю КолвоПаллет","Среднее по полю Время смены","Признак"]
["Замкадье","35 нед.","25.8","Зайков Игорь Виталиевич","День","Приёмщик",185,9,{"$f":"IF(OR(F2=\"Приемщик\",F2=\"Приёмщик\"),IF(G2<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","36 нед.","3.9","Бархударов Муслим Амирович","День","Приёмщик",309,9,{"$f":"IF(OR(F3=\"Приемщик\",F3=\"Приёмщик\"),IF(G3<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","36 нед.","3.9","Зайков Игорь Виталиевич","День","Приёмщик",194,9,""]
["Замкадье","37 нед.","8.9","Бархударов Муслим Амирович","День","Приёмщик",261,9,{"$f":"IF(OR(F5=\"Приемщик\",F5=\"Приёмщик\"),IF(G5<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","37 нед.","8.9","Магденко Андрей Николаевич","День","Не приёмщик",1,9,""]
["Замкадье","38 нед.","15.9","Бархударов Муслим Амирович","День","Приёмщик",189,9,{"$f":"IF(OR(F7=\"Приемщик\",F7=\"Приёмщик\"),IF(G7<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","38 нед.","15.9","Гончаров Алексей Юрьевич","День","Приёмщик",462,9,""]
["Замкадье","39 нед.","22.9","Сареева Мария Николаевна","День","Приёмщик",430,9,{"$f":"IF(OR(F9=\"Приемщик\",F9=\"Приёмщик\"),IF(G9<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","39 нед.","22.9","Никитин Владимир Федорович","Ночь","Приёмщик",237,11,""]
["Замкадье","40 нед.","30.9","Зайков Игорь Виталиевич","День","Приёмщик",129,9,{"$f":"IF(OR(F11=\"Приемщик\",F11=\"Приёмщик\"),IF(G11<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","40 нед.","30.9","Магденко Андрей Николаевич","День","Не приёмщик",33,9,""]
["Замкадье","41 нед.","6.10","Бархударов Муслим Амирович","День","Приёмщик",353,9,{"$f":"IF(OR(F13=\"Приемщик\",F13=\"Приёмщик\"),IF(G13<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","41 нед.","6.10","Гончаров Алексей Юрьевич","День","Приёмщик",712,9,""]
["Замкадье","42 нед.","13.10","Бархударов Муслим Амирович","День","Приёмщик",338,9,{"$f":"IF(OR(F15=\"Приемщик\",F15=\"Приёмщик\"),IF(G15<10,\"Не исп\",\"\"),\"\")","v":""}]
["Замкадье","42 нед.","13.10","Зайков Игорь Виталиевич","День","Приёмщик",243,9,""]
["Замкадье","43 нед.","13.11","Зайков Игорь Виталиевич","День","Приёмщик",243,9]
["Замкадье","44 нед.","13.12","Зайков Игорь Виталиевич","День","Приёмщик",243,9]
["Замкадье","45 нед.","13.13","Зайков Игорь Виталиевич","День","Приёмщик",243,9]
["Замкадье","46 нед.","13.14","Зайков Игорь Виталиевич","День","Приёмщик",243,9]
["Замкадье","47 нед.","13.15","Зайков Игорь Виталиевич","День","Приёмщик",243,9]
["Замкадье","48 нед.","13.16","Зайков Игорь Виталиевич","День","Приёмщик",243,9]
["Замкадье","49 нед.","13.17","Зайков Игорь Виталиевич","День","Приёмщик",243,9]