{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ФИО и должность людей","ТЛР","шаблон для ТЛР","По начальнкам","шаблон По начальнкам"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":48,"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":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Name","Фио","Специальность","Место проживания","Смена","Титул","Бригадир"]
["Расстановка Воробьёв","Рыжих Е.В","Мастер СМР","ВЖГ","День","ПУС 500","Григорьев Алексей Сергеевич"]
["Расстановка Воробьёв","Гайдамакин Р.Б","Производитель работ","ВЖГ","Ночь","ПУС 500","Герасимов Игорь Геннадьевич"]
["Расстановка Воробьёв","Пыжик Р.Б","Сварщик РАД","ВЖГ","Ночь","ПУС 500","Герасимов Игорь Геннадьевич"]
["Расстановка Матвеев","Барсук Василий Александрович","Монтажник ТТ","АГХК","День","3.1.1.09.857","Григорьев Алексей Сергеевич"]
["Расстановка Матвеев","Бауэр Андрей Эдуардович","Монтажник ТТ","АГХК","Ночь","3.1.1.09.857","Григорьев Алексей Сергеевич"]
["Расстановка Савельев","Манытов Матвей Сергеевич","Арматурщик","АГХК","День","3.1.1.09.857","Зубанов Андрей Александрович"]
["Расстановка Савельев","Покацкий Константин Сергеевич","Арматурщик","АГХК","День","3.1.1.09.857","Зубанов Андрей Александрович"]
["Расстановка Савельев","Хомушку Ачыты Орланович","Плотник","АГХК","День","4.1.1.20.722","Бегаев Алексей Николаевич"]
["Расстановка Савельев","Таран Николай Михайлович ","Плотник","АГХК","Ночь","4.1.1.20.722","Герасимов Игорь Геннадьевич"]

{"sheet":"ТЛР","index":1,"n_rows":92,"n_cols":12,"rows_kept":92,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,2,1,10],[2,0,3,0],[2,1,3,1],[2,2,3,2],[3,7,3,8],[2,9,3,11],[2,7,2,8],[56,0,88,0],[2,3,2,4],[3,5,3,6],[2,5,2,6],[3,3,3,4],[5,0,54,0]]}
["Информация о задействованных технико-людских ресурсах \nпри строительстве объекта:  Амурский ГПЗ. ОЗХ, P2. Огнезащита"]
[null,null,"по состоянию на 13.11.2020 г.  "]
[" ","Наименование ресурсов","Ед. изм",null,null,null,null,null,null,"ВСЕГО \n АГПЗ"]
[null,null,null,"ПУС 500",null,"3.1.1.09.857",null,"4.1.1.20.722"]
[null,null,null,"день","ночь","день","ночь","день","ночь","день","ночь","Итого"]
["Техника","Автокраны","ед "]
[null,"Автокран 25 т","ед ",3,2,1]
[null,"Автокран 30 т","ед ",null,null,1,1]
[null,"Автокран 50 т","ед ",null,null,1,2]
[null,"Автокран 60 т","ед "]
[null,"Автокран 75 т","ед "]
[null,"Автокран 120 т","ед "]
[null,"Автокран башенный ","ед "]
[null,"Бульдозеры","ед "]
[null,"Бульдозер komatsu","ед "]
[null,"Катки","ед "]
[null,"Каток Jcb","ед "]
[null,"Экскаваторы","ед "]
[null,"Экскаватор рс-300","ед "]
[null,"Экскаватор рс-400","ед "]
[null,"Экскаватор колесный js200w ","ед "]
[null,"Экскаватор-погрузчик jcb","ед "]
[null,"Экскаватор мини pc-35mr-3, 55","ед "]
[null,"Подъемники","ед "]
[null,"Коленчатый подъемник 16","ед ",null,null,null,null,null,null,{"$f":"SUM(D25,F25,H25,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,)","v":{"$error":"#REF!"}},{"$f":"SUM(E25,G25,I25,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,)","v":{"$error":"#REF!"}},{"$f":"SUM(J25:K25)","v":{"$error":"#REF!"}}]
[null,"Коленчатый подъемник 26","ед ",null,null,null,null,null,null,{"$f":"SUM(D26,F26,H26,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,)","v":{"$error":"#REF!"}},{"$f":"SUM(E26,G26,I26,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,#REF!,)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Коленчатый подъемник 32","ед "]
[null,"Коленчатый подъемник 41","ед "]
[null,"Коленчатый подъемник 43","ед "]
[null,"Погрузчики","ед "]
[null,"Погрузчик вилочный js200w т2","ед "]
[null,"Погрузчик фронтальный 422 zх средний","ед "]
[null,"Погрузчик с телескопической стрелой 540v140","ед "]
[null,"Погрузчик мини 30d 4*4  con","ед "]
[null,"Погрузчик многоходовый combilift","ед "]
[null,"Грузовые автомобили","ед "]
[null,"Бортовая с кму","ед "]
[null,"Бортовой грузовой газ","ед "]
[null,"Тягач седельный  с кму","ед "]
[null,"Тягач седельный без кму","ед "]
[null,"Самосвал","ед "]
[null,"Тралл","ед "]
[null,"Автобусы и легковой транспорт","ед "]
[null,"Автобус ( вместимость 53 чел)","ед "]
[null,"Автобус(вместимость 30 человек)","ед "]
[null,"Микроавтобус (вместимость 16 мест)","ед "]
[null,"Микроавтобус соболь (вместимость до 8 мест)","ед "]
[null,"Уаз патриот пикап","ед "]
[null,"Малая механизация","ед "]
[null,"Мачта осветительная дизельная ","ед "]
[null,"Виброплита","ед "]
[null,"Дэс","ед "]
[null,"Cварочник denyo","ед "]
[null,"Мотопомпа дизельная daishin swt-50yd","ед "]
[null,"Всего","ед "]
[null,null,null,"день","ночь","день","ночь","день","ночь","день","ночь","Итого"]
["Люди","Линейный ИТР","чел"]
[null,"Начальник участка","чел"]
[null,"Мастер СМР","чел",1,null,null,null,null,null,1,null,1]
[null,"Производитель работ","чел",null,1,null,null,null,null,null,1,1]
[null,"Бетонщики/каменьщики","чел"]
[null,"Арматурщик","чел",null,null,2,null,null,null,2,null,2]
[null,"Бетонщик","чел"]
[null,"Плотник","чел"]
[null,"Каменщик","чел"]
[null,"Сварщики","чел"]
[null,"Сварщик РД","чел"]
[null,"Сварщик РАД","чел",1,null,null,null,null,null,1,null,1]
[null,"Электрогазосварщик","чел"]
[null,"Оператор термист","чел"]
[null,"Газорезчик","чел"]
[null,"Электрики","чел"]
[null,"Электромонтёр","чел"]
[null,"Электромонтажник","чел"]
[null,"Отделочники","чел"]
[null,"Штукатур","чел"]
[null,"Облицовщик","чел"]
[null,"Отделочник","чел"]
[null,"Плиточник","чел",null,null,null,null,1,1,2,null,2]
[null,"Маляр","чел"]
[null,"Монтажники","чел"]
[null,"Монтажник ТТ","чел",null,null,1,1,null,null,1,1,2]
[null,"Монтажник ТО","чел"]
[null,"Монтажник СТиЖБК","чел"]
[null,"Монтажник МК","чел"]
[null,"Прочие","чел"]
[null,"Подсобный рабочий","чел"]
[null,"Стропальщик","чел"]
[null,"ИТОГО:","чел"]
[]
[null,"Прямой","чел"]
[null,"Косвенный","чел"]

{"sheet":"шаблон для ТЛР","index":2,"n_rows":89,"n_cols":2,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
[]
[]
[]
[]
["день","ночь"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A6:A54)","v":0},{"$f":"SUM(B6:B54)","v":0}]
["день","ночь"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A57:A88)","v":0},{"$f":"SUM(B57:B88)","v":0}]

{"sheet":"По начальнкам","index":3,"n_rows":90,"n_cols":19,"rows_kept":90,"cut":false,"hidden":false,"merged":[[89,2,89,3],[89,7,89,8],[88,1,89,1],[88,11,89,11],[89,9,89,10],[2,14,2,15],[89,12,89,13],[89,14,89,15],[88,6,89,6],[2,11,3,11],[2,9,2,10],[2,6,3,6],[2,7,2,8],[0,0,0,18],[2,16,2,17],[2,18,3,18],[88,18,89,18],[89,16,89,17],[1,12,1,18],[1,7,1,11],[2,2,2,3],[2,4,2,5],[6,0,54,0],[56,0,87,0],[1,2,1,6],[1,0,3,1],[4,0,4,1],[89,4,89,5],[2,12,2,13]]}
["Мобилизация персонала на строительную площадку"]
["Персонал",null,"Расстановка Воробьёв",null,null,null,null,"Расстановка Матвеев",null,null,null,null,"Расстановка Савельев"]
[null,null,"ПУС 500",null,"Всего",null,"Итого","3.1.1.09.857",null,"Всего",null,"Итого","3.1.1.09.857",null,"4.1.1.20.722",null,"Всего",null,"Итого"]
[null,null,"день","ночь","день","ночь",null,"день","ночь","день","ночь",null,"день","ночь","день","ночь","день","ночь"]
["Ответственный ИТР",null,"Гагарин С.С.","Мироненко О.В.",null,null,null,"Громчевский Р.В.","Безнасюк Д.Л.",null,null,null,"Громчевский Р.В.","Безнасюк Д.Л.","Громчевский Р.В.","Безнасюк Д.Л."]
[null,"ТЕХНИКА"]
[null,"Автокраны",null,null,{"$f":"SUMIF($C$4:$D$4,E$4,$C7:$D7)","v":0},0,{"$f":"F7+E7","v":0},null,null,{"$f":"SUMIF($H$4:$I$4,J$4,$H7:$I7)","v":0},0,{"$f":"J7+K7","v":0},null,null,null,null,{"$f":"SUMIF($H$4:$I$4,Q$4,$H7:$I7)","v":0},0,{"$f":"Q7+R7","v":0}]
[null,"Автокран 25 т",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автокран 30 т",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автокран 50 т",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автокран 60 т",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автокран 75 т",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автокран 120 т",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автокран башенный ",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Бульдозеры",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Бульдозер komatsu",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Катки",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Каток Jcb",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Экскаваторы",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Экскаватор рс-300",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Экскаватор рс-400",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Экскаватор колесный js200w ",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Экскаватор-погрузчик jcb",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Экскаватор мини pc-35mr-3, 55",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Подъемники",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Коленчатый подъемник 16",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Коленчатый подъемник 26",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Коленчатый подъемник 32",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Коленчатый подъемник 41",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Коленчатый подъемник 43",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Погрузчики",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Погрузчик вилочный js200w т2",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Погрузчик фронтальный 422 zх средний",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Погрузчик с телескопической стрелой 540v140",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Погрузчик мини 30d 4*4  con",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Погрузчик многоходовый combilift",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[null,"Грузовые автомобили",null,null,{"$f":"SUMIF($C$4:$D$4,E$4,$C37:$D37)","v":0},0,0,null,null,{"$f":"SUMIF($H$4:$I$4,J$4,$H37:$I37)","v":0},0,0,null,null,null,null,{"$f":"SUMIF($H$4:$I$4,Q$4,$H37:$I37)","v":0},0,0]
[null,"Бортовая с кму",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Бортовой грузовой газ",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Тягач седельный  с кму",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Тягач седельный без кму",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Самосвал",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Тралл",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автобусы и легковой транспорт",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автобус ( вместимость 53 чел)",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Автобус(вместимость 30 человек)",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Микроавтобус (вместимость 16 мест)",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Микроавтобус соболь (вместимость до 8 мест)",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Уаз патриот пикап",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Малая механизация",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Мачта осветительная дизельная ",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Виброплита",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Дэс",null,null,0,0,0,null,null,0,0,0,null,null,null,null,0,0,0]
[null,"Cварочник denyo"]
[null,"Мотопомпа дизельная daishin swt-50yd"]
[null,"ЛЮДИ"]
[null,"Линейный ИТР"]
[null,"Начальник участка",1,null,1,null,1]
[null,"Мастер СМР"]
[null,"Производитель работ",null,1,null,1,1]
[null,"Бетонщики/каменьщики"]
[null,"Арматурщик",null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,2]
[null,"Бетонщик"]
[null,"Плотник",null,null,null,null,null,null,null,null,null,null,null,null,1,1,null,null,2]
[null,"Каменщик"]
[null,"Сварщики"]
[null,"Сварщик РД"]
[null,"Сварщик РАД",null,1,null,1,1]
[null,"Электрогазосварщик"]
[null,"Оператор термист"]
[null,"Газорезчик"]
[null,"Электрики"]
[null,"Электромонтёр"]
[null,"Электромонтажник"]
[null,"Отделочники"]
[null,"Штукатур"]
[null,"Облицовщик"]
[null,"Отделочник"]
[null,"Плиточник"]
[null,"Маляр"]
[null,"Монтажники"]
[null,"Монтажник ТТ",null,null,null,null,null,1,1,1,1,2]
[null,"Монтажник ТО"]
[null,"Монтажник СТиЖБК"]
[null,"Монтажник МК"]
[null,"Прочие"]
[null,"Подсобный рабочий"]
[null,"Стропальщик"]
[null,"Всего",{"$f":"SUM(C7:C53)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(M7:M53)","v":0},0,{"$f":"SUM(O7:O53)","v":0},0,0,0,0]
[null,null,{"$f":"C89+D89","v":0},null,{"$f":"E89+F89","v":0},null,null,{"$f":"H89+I89","v":0},null,{"$f":"J89+K89","v":0},null,null,{"$f":"M89+N89","v":0},null,{"$f":"O89+P89","v":0},null,{"$f":"Q89+R89","v":0}]

{"sheet":"шаблон По начальнкам","index":4,"n_rows":90,"n_cols":2,"rows_kept":90,"cut":false,"hidden":false,"merged":[[89,0,89,1],[0,0,0,1],[1,0,1,1],[2,0,2,1]]}
[]
[]
[]
["день","ночь"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A7:A53)","v":0},0]
[{"$f":"A89+B89","v":0}]