{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["штатное расписание","штатная расстановка","сформировать ШР"],"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":33,"n_cols":44,"rows_kept":33,"cut":false,"hidden":false,"merged":[[17,43,18,47],[18,7,18,9],[18,34,18,36],[18,37,18,39],[4,0,4,47],[3,0,3,47],[2,0,2,47],[13,0,13,30],[13,34,13,37],[13,40,13,41],[13,43,13,46],[12,0,12,3],[12,4,12,5],[12,9,12,12],[14,0,14,47],[15,0,15,27],[9,39,9,47],[10,20,10,27],[10,28,10,47],[12,15,12,16],[12,17,12,47],[7,0,7,42],[7,43,7,47],[8,0,8,38],[8,39,8,42],[8,43,8,47],[9,0,9,38],[0,0,0,44],[1,0,1,44],[5,0,5,47],[6,0,6,42],[6,43,6,47],[11,0,11,14],[11,15,11,19],[11,20,11,27],[11,28,11,47],[10,0,10,14],[10,15,10,19],[28,27,28,30],[22,0,22,6],[22,31,22,33],[22,7,22,9],[22,10,22,23],[22,24,22,26],[22,27,22,30],[25,0,25,6],[25,31,25,33],[27,0,27,6],[27,31,27,33],[26,0,26,6],[26,31,26,33],[26,7,26,9],[26,10,26,23],[24,7,24,9],[24,10,24,23],[24,24,24,26],[24,27,24,30],[24,0,24,6],[24,31,24,33],[23,0,23,6],[19,37,19,39],[20,0,20,6],[20,31,20,33],[20,34,20,36],[20,37,20,39],[19,7,19,9],[19,10,19,23],[19,24,19,26],[21,0,21,6],[21,31,21,33],[21,34,21,36],[21,7,21,9],[21,10,21,23],[21,24,21,26],[21,27,21,30],[15,28,15,33],[15,34,15,39],[15,40,15,47],[16,0,16,47],[19,40,19,42],[19,43,19,47],[20,7,20,9],[20,10,20,23],[20,24,20,26],[20,27,20,30],[20,40,20,42],[20,43,20,47],[19,27,19,30],[19,0,19,6],[19,31,19,33],[19,34,19,36],[18,0,18,6],[18,31,18,33],[17,10,18,23],[17,24,18,26],[17,27,18,30],[17,31,17,39],[17,0,17,9],[17,40,18,42],[21,40,21,42],[21,43,21,47],[22,40,22,42],[22,43,22,47],[23,7,23,9],[23,10,23,23],[23,24,23,26],[23,27,23,30],[23,40,23,42],[23,43,23,47],[22,37,22,39],[23,37,23,39],[21,37,21,39],[24,40,24,42],[23,31,23,33],[23,34,23,36],[22,34,22,36],[24,43,24,47],[25,7,25,9],[25,10,25,23],[25,24,25,26],[25,27,25,30],[25,40,25,42],[25,43,25,47],[25,37,25,39],[25,34,25,36],[24,34,24,36],[24,37,24,39],[26,40,26,42],[26,43,26,47],[27,7,27,9],[27,10,27,23],[27,24,27,26],[27,27,27,30],[27,40,27,42],[27,43,27,47],[26,24,26,26],[26,27,26,30],[27,37,27,39],[26,34,26,36],[26,37,26,39],[27,34,27,36],[30,0,30,20],[32,0,32,20],[32,22,32,27],[32,29,32,42],[32,43,32,47],[28,40,28,42],[28,43,28,47],[29,0,29,13],[29,14,29,20],[29,22,29,27],[29,29,29,42],[29,43,29,47],[30,43,30,47],[31,0,31,20],[31,22,31,27],[31,29,31,42],[31,43,31,47],[30,22,30,27],[30,29,30,42],[28,31,28,33],[28,34,28,36],[28,37,28,39],[28,0,28,23],[28,24,28,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"     УТВЕРЖДАЮ"]
["на период",null,null,null,null,null,"с \"",null,"\"",null,null,null,null,"20",null,"г."]
["Руководитель организации",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Борисов С.А."]
[]
[null,null,null,null,null,null,null,null,null,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":"Y29","v":5.75},null,null,null,null,null,"единиц"]
[]
["Структурное подразделение",null,null,null,null,null,null,null,null,null,"Должность (специальность, профессия), разряд, класс (категория) квалификации",null,null,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руб (гр.5 +гр.6+гр.7+гр.8) х гр.4",null,null,"Примечание"]
["наименование",null,null,null,null,null,null,"код"]
["1",null,null,null,null,null,null,"2",null,null,"3",null,null,null,null,null,null,null,null,null,null,null,null,null,"4",null,null,"5",null,null,null,"6",null,null,"7",null,null,"8",null,null,"9",null,null,"10"]
["Технический департамент",null,null,null,null,null,null,null,null,null,"старший инженер",null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,60000,null,null,null,10000,null,null,null,null,null,1400]
["Технический департамент",null,null,null,null,null,null,null,null,null,"инженер",null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,null,null,40000]
["Бухгалтерия",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,50000]
["Бухгалтерия",null,null,null,null,null,null,null,null,null,"бухгалтер",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,null,null,30000]
[]
[]
[]
[]
["Итого",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y21:AA28)","v":5.75},null,null,{"$f":"SUM(AB21:AE28)","v":180000},null,null,null,{"$f":"SUM(AF21:AH28)","v":10000},null,null,{"$f":"SUM(AI21:AK28)","v":0},null,null,{"$f":"SUM(AL21:AN28)","v":1400},null,null,{"$f":"SUM(AO21:AQ28)","v":0}]
["Руководитель кадровой службы",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Орлова Е.А."]
["должность",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," личная подпись",null,null,null,null,null,null,"расшифровка подписи"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Авдеева О.Г."]
["Главный бухгалтер",null,null,null,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":19,"n_cols":39,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,2],[12,0,12,2],[10,3,13,3],[10,0,10,2],[11,0,11,2],[13,0,13,2],[1,9,1,33],[2,0,7,2],[3,28,4,28],[3,29,4,29],[2,28,2,31],[4,14,4,15],[3,7,6,7],[3,6,6,6],[3,26,4,26],[3,27,4,27],[2,10,7,10],[2,4,7,4],[2,11,4,11],[3,13,4,13],[3,12,4,12],[3,8,6,8],[5,34,6,34],[9,0,9,4],[3,31,4,31],[3,32,4,32],[3,25,4,25],[2,34,4,34],[3,5,7,5],[2,32,2,33],[3,30,4,30],[4,17,4,18],[4,20,4,21],[3,14,3,22],[3,23,4,23],[3,24,4,24],[2,12,2,27],[2,5,2,8],[0,0,0,4],[14,0,14,2],[15,0,15,2],[16,0,16,2],[2,3,7,3],[14,3,17,3],[17,0,17,2],[1,0,1,4],[8,0,8,2]]}
["Общество с ограниченной ответственностью  \"Марта\"",null,null,null,null,"Руководитель кадровой службы","Орлова Е.А.","Должность руководителя организации","генеральный директор","ФИО руководителя организации","Борисов С.А.","Главный бухгалтер","Авдеева О.Г."]
["Итого штатных единиц по организации",null,null,null,null,{"$f":"SUM(G11:G18)","v":5.75}]
["НАИМЕНОВАНИЕ СТРУКТУРНОГО ПОДРАЗДЕЛЕНИЯ   /   Аббревиатура",null,null,"Количество штатных единиц в подраздлении","НАИМЕНОВАНИЕ ДОЛЖНОСТИ СОГЛАСНО ШТАТНОМУ РАСПИСАНИЮ","СТАТУС  ДОЛЖНОСТИ И РАБОТНИКА",null,null,null,"Ф.И.О. СОТРУДНИКА","ПРИМЕЧАНИЕ ПО РАБОТНИКУ","ПРИМЕЧАНИЕ \n ПО \nОПЛАТЕ ТРУДА /\nУТВЕРЖДЕННЫЕ ПРЕДЕЛЫ ЗАРАБОТНОЙ ПЛАТЫ \nсправочно \nПО СЗ \nлибо укажите иные условия ","УСЛОВИЯ СОГЛАСНО ТРУДОВОМУ ДОГОВОРУ (ШТАТНОЕ РАСПИСАНИЕ) gross",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"БАЗОВАЯ СТАВКА ПРЕМИИ gross",null,null,null,"ВРЕМЕННАЯ ДОПЛАТА gross",null,"ФОТ ПО ШТАТНОМУ РАСПИСАНИЮ","Максимум по должности","Установлено сотруднику (с учетом занимаемой ставки, но без учета квартальной, полугодовой и годовой премии)","Установлено сотруднику (с учетом занимаемой ставки, c учетом квартальной, полугодовой и годовой премии)","Ежемесячная сумма на руки (за вычетом НДФЛ)"]
[null,null,null,null,null,"ВИД ТРУДОВОГО ДОГОВОРА","ЗАНЯТАЯ СТАВКА (ЗС)","ДЕКРЕТНИЦЫ","ВАКАНСИИ",null,null,null,"оклад","ДОПЛАТА","НАДБАВКИ",null,null,null,null,null,null,null,null,"% РАЙОН. КОЭФ-НТ                      ","СУММА \nРАЙОННОГО \nКОЭФ-НТА                      ","%\nНАДБАВКА                           ","СУММА ПРОЦЕНТНОЙ НАДБАВКИ\nSПр                                                   ","ВСЕГО\n gross \nсогласно ТРУДОВОМУ ДОГОВОРУ\n            ","ЕЖЕМЕСЯЧНАЯ           ","КВАРТАЛЬНАЯ              "," ПОЛУГОДОВАЯ            ","ГОДОВАЯ","СУММА               ","ПЕРИОД ДОПЛАТЫ (00.00.00-00.00.00)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"НАДБАВКИ (ДЕЛЬТА)                                        мин. - макс.",null,"УТВ.\n СУММА                                                           НАДБАВКИ                ","НАДБАВКИ 2 (ДЕЛЬТА)                                        мин. - макс.",null,"УТВ.\n СУММА                                                           НАДБАВКИ                 2","НАДБАВКИ 3 (ДЕЛЬТА)                                        мин. - макс.",null,"УТВ.\n СУММА                                                           НАДБАВКИ                 3"]
[null,null,null,null,null,null,null,null,null,null,null,"ОБОЗНАЧЕНИЕ","Ок","Дп1к","-","-","Нд","-","-","Нд","-","-","Нд","РК","SРК","Пр","SПр","∑TDgr","М","Кв","Пг","Г","ВрД",null,"ФОТ"]
[null,null,null,null,null,null,null,null,null,null,null,"ФОРМУЛА РАСЧЕТА",null,null,"-","-","-","-","-","-","-","-","-","-","(Ок+Дп1к+Нд+M)*РК","-","(Ок+Дп1к+Нд)*Пр","Ок+Дп1к+Нд\n+SРК+SПр","-","-","-","-","-"]
[null,null,null,null,null,null,{"$f":"SUM(G11:G19)","v":5.75},{"$f":"SUM(H11:H19)","v":1.5},{"$f":"SUM(I11:I19)","v":0.5},null,null,"ИТОГОВАЯ СУММА ПО ОРГАНИЗАЦИИ",{"$f":"SUM(M11:M19)","v":320000},20000,5000,10000,10000,0,0,0,0,0,0,null,{"$f":"SUM(Y11:Y19)","v":1400},null,{"$f":"SUM(AA11:AA19)","v":15000},274800,10000,30000,60000,60000,120000,null,{"$f":"SUM(AI11:AI19)","v":376400},{"$f":"SUM(AJ11:AJ19)","v":110000},{"$f":"SUM(AK11:AK19)","v":282300},{"$f":"SUM(AL11:AL19)","v":484800},{"$f":"SUM(AM11:AM19)","v":245601}]
["выберите подразделение"]
["Склад",null,null,null,null,null,{"$f":"SUMIF($A11:$C19,$A$10,G11:G19)","v":0},{"$f":"SUMIF($A11:$C19,$A$10,H11:H19)","v":0},{"$f":"SUMIF($A11:$C19,$A$10,I11:I19)","v":0},null,null,null,{"$f":"SUMIF($A11:$C19,$A$10,M11:M19)","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMIF($A11:$C19,$A$10,Y11:Y19)","v":0},null,{"$f":"SUMIF($A11:$C19,$A$10,AA11:AA19)","v":0},0,0,0,0,0,0,null,{"$f":"SUMIF($A11:$C19,$A$10,AI11:AI19)","v":0},{"$f":"SUMIF($A11:$C19,$A$10,AJ11:AJ19)","v":0},{"$f":"SUMIF($A11:$C19,$A$10,AK11:AK19)","v":0},{"$f":"SUMIF($A11:$C19,$A$10,AL11:AL19)","v":0},{"$f":"SUMIF($A11:$C19,$A$10,AM11:AM19)","v":0}]
["Технический департамент",null,null,{"$f":"SUM(G11:G14)","v":3.25},"старший инженер","бессрочный",0.75,0,0,"Иванов Андрей Викторович",null,null,60000,20000,5000,10000,10000,null,null,null,null,null,null,1.4E-2,{"$f":"(M11+N11+Q11+T11+W11+AC11)*X11","v":1400},0.15,{"$f":"(M11+N11+Q11+AC11)*Z11","v":15000},{"$f":"(M11+N11+Q11+T11+W11+Y11+AA11)*G11","v":79800},10000,30000,60000,60000,120000,null,{"$f":"M11+N11+Q11+T11+W11+Y11+AA11+AC11","v":116400},110000,{"$f":"G11*(M11+N11+Q11+T11+W11+Y11+AA11+AC11)","v":87300},{"$f":"G11*(M11+N11+Q11+T11+W11+Y11+AA11+AC11+AD11+AE11+AF11+AG11)","v":289800},{"$f":"AK11*0.87","v":75951}]
["Технический департамент",null,null,null,"инженер","бессрочный",0.5,0,0.5,"Петров Леонид Васильевич",null,null,40000,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M12+N12+Q12+T12+W12+AC12)*X12","v":0},null,{"$f":"(M12+N12+Q12+AC12)*Z12","v":0},{"$f":"(M12+N12+Q12+T12+W12+Y12+AA12)*G12","v":20000},null,null,null,null,null,null,{"$f":"M12+N12+Q12+T12+W12+Y12+AA12+AC12","v":40000},null,{"$f":"G12*(M12+N12+Q12+T12+W12+Y12+AA12+AC12)","v":20000},{"$f":"G12*(M12+N12+Q12+T12+W12+Y12+AA12+AC12+AD12+AE12+AF12+AG12)","v":20000},{"$f":"AK12*0.87","v":17400}]
["Технический департамент",null,null,null,"инженер","бессрочный",1,0,0,"Сидоров Антон Михайлович",null,null,40000,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M13+N13+Q13+T13+W13+AC13)*X13","v":0},null,{"$f":"(M13+N13+Q13+AC13)*Z13","v":0},40000,null,null,null,null,null,null,40000,null,{"$f":"G13*(M13+N13+Q13+T13+W13+Y13+AA13+AC13)","v":40000},{"$f":"G13*(M13+N13+Q13+T13+W13+Y13+AA13+AC13+AD13+AE13+AF13+AG13)","v":40000},{"$f":"AK13*0.87","v":34800}]
["Технический департамент",null,null,null,"инженер","бессрочный",1,0,0,"Сидоров Антон Михайлович",null,null,40000,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M14+N14+Q14+T14+W14+AC14)*X14","v":0},null,{"$f":"(M14+N14+Q14+AC14)*Z14","v":0},40000,null,null,null,null,null,null,40000,null,{"$f":"G14*(M14+N14+Q14+T14+W14+Y14+AA14+AC14)","v":40000},{"$f":"G14*(M14+N14+Q14+T14+W14+Y14+AA14+AC14+AD14+AE14+AF14+AG14)","v":40000},{"$f":"AK14*0.87","v":34800}]
["Бухгалтерия",null,null,{"$f":"SUM(G15:G18)","v":2.5},"главный бухгалтер","бессрочный",1,0,0,"Авдеева Оксана Георгиевна",null,null,50000,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M15+N15+Q15+T15+W15+AC15)*X15","v":0},null,{"$f":"(M15+N15+Q15+AC15)*Z15","v":0},50000,null,null,null,null,null,null,50000,null,{"$f":"G15*(M15+N15+Q15+T15+W15+Y15+AA15+AC15)","v":50000},{"$f":"G15*(M15+N15+Q15+T15+W15+Y15+AA15+AC15+AD15+AE15+AF15+AG15)","v":50000},{"$f":"AK15*0.87","v":43500}]
["Бухгалтерия",null,null,null,"бухгалтер","срочный",1,1,0,"Васильева Людмила Петровна","до окончания отпуска по уходу за ребенком основного сотрудника",null,30000,null,null,null,null,null,null,null,null,null,null,null,0,null,0,30000,null,null,null,null,null,null,30000,null,30000,30000,26100]
["Бухгалтерия",null,null,null,"бухгалтер","бессрочный",0.5,0.5,0,"Шишкина Антонина Алексеевна",null,null,30000,null,null,null,null,null,null,null,null,null,null,null,0,null,0,15000,null,null,null,null,null,null,30000,null,15000,15000,13050]
["Бухгалтерия",null,null,null,"бухгалтер","бессрочный",0,0,0," ","вакансия",null,30000,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,null,null,null,null,null,null,30000,null,0,0,0]
[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":"(M19+N19+Q19+T19+W19+AC19)*X19","v":0},null,{"$f":"(M19+N19+Q19+AC19)*Z19","v":0},0,null,null,null,null,null,null,0,null,{"$f":"G19*(M19+N19+Q19+T19+W19+Y19+AA19+AC19)","v":0},{"$f":"G19*(M19+N19+Q19+T19+W19+Y19+AA19+AC19+AD19+AE19+AF19+AG19)","v":0},{"$f":"AK19*0.87","v":0}]

{"sheet":"сформировать ШР","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}