{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Штатка","Табель","Зарплата"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":119,"n_cols":9,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Штатное расписание"]
[null,"Отчетный период","Статус работника",null,null,"Фамилия",null,null,"Столбец для поиска должностей в табеле)))\nпо фамилии и месяцу"]
[{"$f":"IF(AND(Табель!D$1=B3,C3=\"Работает\"),A2+1,A2)","v":0},"2017-01-01","Работает",null,null,"Иванов1","Директор",null,{"$f":"F3&B3","v":"Иванов142736"}]
[{"$f":"IF(AND(Табель!D$1=B4,C4=\"Работает\"),A3+1,A3)","v":0},"2017-01-01","Работает",null,null,"Иванов2","Бухгалтер",null,{"$f":"F4&B4","v":"Иванов242736"}]
[{"$f":"IF(AND(Табель!D$1=B5,C5=\"Работает\"),A4+1,A4)","v":0},"2017-01-01","Работает",null,null,"Иванов3","ОК",null,"Иванов342736"]
[{"$f":"IF(AND(Табель!D$1=B6,C6=\"Работает\"),A5+1,A5)","v":0},"2017-01-01","Работает",null,null,"Иванов4","Кассир",null,"Иванов442736"]
[{"$f":"IF(AND(Табель!D$1=B7,C7=\"Работает\"),A6+1,A6)","v":0},"2017-01-01","Работает",null,null,"Иванов5","Инженер ТБ",null,"Иванов542736"]
[{"$f":"IF(AND(Табель!D$1=B8,C8=\"Работает\"),A7+1,A7)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов6","Экономист",null,"Иванов642736"]
[{"$f":"IF(AND(Табель!D$1=B9,C9=\"Работает\"),A8+1,A8)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов7","Сторож",null,"Иванов742736"]
[{"$f":"IF(AND(Табель!D$1=B10,C10=\"Работает\"),A9+1,A9)","v":0},"2017-01-01","Работает",null,null,"Иванов8","Директор",null,{"$f":"F10&B10","v":"Иванов842736"}]
[{"$f":"IF(AND(Табель!D$1=B11,C11=\"Работает\"),A10+1,A10)","v":0},"2017-01-01","Работает",null,null,"Иванов9","Бухгалтер",null,{"$f":"F11&B11","v":"Иванов942736"}]
[{"$f":"IF(AND(Табель!D$1=B12,C12=\"Работает\"),A11+1,A11)","v":0},"2017-01-01","Работает",null,null,"Иванов10","ОК",null,"Иванов1042736"]
[{"$f":"IF(AND(Табель!D$1=B13,C13=\"Работает\"),A12+1,A12)","v":0},"2017-01-01","Работает",null,null,"Иванов11","Кассир",null,"Иванов1142736"]
[{"$f":"IF(AND(Табель!D$1=B14,C14=\"Работает\"),A13+1,A13)","v":0},"2017-01-01","Работает",null,null,"Иванов12","Инженер ТБ",null,"Иванов1242736"]
[{"$f":"IF(AND(Табель!D$1=B15,C15=\"Работает\"),A14+1,A14)","v":0},"2017-01-01","Работает",null,null,"Иванов13","Экономист",null,"Иванов1342736"]
[{"$f":"IF(AND(Табель!D$1=B16,C16=\"Работает\"),A15+1,A15)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов14","Сторож",null,"Иванов1442736"]
[{"$f":"IF(AND(Табель!D$1=B17,C17=\"Работает\"),A16+1,A16)","v":0},"2017-01-01","Работает",null,null,"Иванов15","Директор",null,{"$f":"F17&B17","v":"Иванов1542736"}]
[{"$f":"IF(AND(Табель!D$1=B18,C18=\"Работает\"),A17+1,A17)","v":0},"2017-01-01","Работает",null,null,"Иванов16","Бухгалтер",null,{"$f":"F18&B18","v":"Иванов1642736"}]
[{"$f":"IF(AND(Табель!D$1=B19,C19=\"Работает\"),A18+1,A18)","v":0},"2017-01-01","Работает",null,null,"Иванов17","ОК",null,"Иванов1742736"]
[{"$f":"IF(AND(Табель!D$1=B20,C20=\"Работает\"),A19+1,A19)","v":0},"2017-01-01","Работает",null,null,"Иванов18","Кассир",null,"Иванов1842736"]
[{"$f":"IF(AND(Табель!D$1=B21,C21=\"Работает\"),A20+1,A20)","v":0},"2017-01-01","Работает",null,null,"Иванов19","Инженер ТБ",null,"Иванов1942736"]
[{"$f":"IF(AND(Табель!D$1=B22,C22=\"Работает\"),A21+1,A21)","v":0},"2017-01-01","Работает",null,null,"Иванов20","Экономист",null,"Иванов2042736"]
[{"$f":"IF(AND(Табель!D$1=B23,C23=\"Работает\"),A22+1,A22)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов21","Сторож",null,"Иванов2142736"]
[{"$f":"IF(AND(Табель!D$1=B24,C24=\"Работает\"),A23+1,A23)","v":0},"2017-01-01","Работает",null,null,"Иванов22","Директор",null,{"$f":"F24&B24","v":"Иванов2242736"}]
[{"$f":"IF(AND(Табель!D$1=B25,C25=\"Работает\"),A24+1,A24)","v":0},"2017-01-01","Работает",null,null,"Иванов23","Бухгалтер",null,{"$f":"F25&B25","v":"Иванов2342736"}]
[{"$f":"IF(AND(Табель!D$1=B26,C26=\"Работает\"),A25+1,A25)","v":0},"2017-01-01","Работает",null,null,"Иванов24","ОК",null,"Иванов2442736"]
[{"$f":"IF(AND(Табель!D$1=B27,C27=\"Работает\"),A26+1,A26)","v":0},"2017-01-01","Работает",null,null,"Иванов25","Кассир",null,"Иванов2542736"]
[{"$f":"IF(AND(Табель!D$1=B28,C28=\"Работает\"),A27+1,A27)","v":0},"2017-01-01","Работает",null,null,"Иванов26","Инженер ТБ",null,"Иванов2642736"]
[{"$f":"IF(AND(Табель!D$1=B29,C29=\"Работает\"),A28+1,A28)","v":0},"2017-01-01","Работает",null,null,"Иванов27","Экономист",null,"Иванов2742736"]
[{"$f":"IF(AND(Табель!D$1=B30,C30=\"Работает\"),A29+1,A29)","v":0},"2017-01-01","Работает",null,null,"Иванов28","Сторож",null,"Иванов2842736"]
[{"$f":"IF(AND(Табель!D$1=B31,C31=\"Работает\"),A30+1,A30)","v":0},"2017-01-01","Работает",null,null,"Иванов29","Директор",null,{"$f":"F31&B31","v":"Иванов2942736"}]
[{"$f":"IF(AND(Табель!D$1=B32,C32=\"Работает\"),A31+1,A31)","v":0},"2017-01-01","Работает",null,null,"Иванов30","Бухгалтер",null,{"$f":"F32&B32","v":"Иванов3042736"}]
[{"$f":"IF(AND(Табель!D$1=B33,C33=\"Работает\"),A32+1,A32)","v":0},"2017-01-01","Работает",null,null,"Иванов31","ОК",null,"Иванов3142736"]
[{"$f":"IF(AND(Табель!D$1=B34,C34=\"Работает\"),A33+1,A33)","v":0},"2017-01-01","Работает",null,null,"Иванов32","Кассир",null,"Иванов3242736"]
[{"$f":"IF(AND(Табель!D$1=B35,C35=\"Работает\"),A34+1,A34)","v":0},"2017-01-01","Работает",null,null,"Иванов33","Инженер ТБ",null,"Иванов3342736"]
[{"$f":"IF(AND(Табель!D$1=B36,C36=\"Работает\"),A35+1,A35)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов34","Экономист",null,"Иванов3442736"]
[{"$f":"IF(AND(Табель!D$1=B37,C37=\"Работает\"),A36+1,A36)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов35","Сторож",null,"Иванов3542736"]
[{"$f":"IF(AND(Табель!D$1=B38,C38=\"Работает\"),A37+1,A37)","v":0},"2017-01-01","Работает",null,null,"Иванов36","Директор",null,{"$f":"F38&B38","v":"Иванов3642736"}]
[{"$f":"IF(AND(Табель!D$1=B39,C39=\"Работает\"),A38+1,A38)","v":0},"2017-01-01","Работает",null,null,"Иванов37","Бухгалтер",null,{"$f":"F39&B39","v":"Иванов3742736"}]
[{"$f":"IF(AND(Табель!D$1=B40,C40=\"Работает\"),A39+1,A39)","v":0},"2017-01-01","Работает",null,null,"Иванов38","ОК",null,"Иванов3842736"]
[{"$f":"IF(AND(Табель!D$1=B41,C41=\"Работает\"),A40+1,A40)","v":0},"2017-01-01","Работает",null,null,"Иванов39","Кассир",null,"Иванов3942736"]
[{"$f":"IF(AND(Табель!D$1=B42,C42=\"Работает\"),A41+1,A41)","v":0},"2017-01-01","Работает",null,null,"Иванов40","Инженер ТБ",null,"Иванов4042736"]
[{"$f":"IF(AND(Табель!D$1=B43,C43=\"Работает\"),A42+1,A42)","v":0},"2017-01-01","Работает",null,null,"Иванов41","Экономист",null,"Иванов4142736"]
[{"$f":"IF(AND(Табель!D$1=B44,C44=\"Работает\"),A43+1,A43)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов42","Сторож",null,"Иванов4242736"]
[{"$f":"IF(AND(Табель!D$1=B45,C45=\"Работает\"),A44+1,A44)","v":0},"2017-01-01","Работает",null,null,"Иванов43","Директор",null,{"$f":"F45&B45","v":"Иванов4342736"}]
[{"$f":"IF(AND(Табель!D$1=B46,C46=\"Работает\"),A45+1,A45)","v":0},"2017-01-01","Работает",null,null,"Иванов44","Бухгалтер",null,{"$f":"F46&B46","v":"Иванов4442736"}]
[{"$f":"IF(AND(Табель!D$1=B47,C47=\"Работает\"),A46+1,A46)","v":0},"2017-01-01","Работает",null,null,"Иванов45","ОК",null,"Иванов4542736"]
[{"$f":"IF(AND(Табель!D$1=B48,C48=\"Работает\"),A47+1,A47)","v":0},"2017-01-01","Работает",null,null,"Иванов46","Кассир",null,"Иванов4642736"]
[{"$f":"IF(AND(Табель!D$1=B49,C49=\"Работает\"),A48+1,A48)","v":0},"2017-01-01","Работает",null,null,"Иванов47","Инженер ТБ",null,"Иванов4742736"]
[{"$f":"IF(AND(Табель!D$1=B50,C50=\"Работает\"),A49+1,A49)","v":0},"2017-01-01","Работает",null,null,"Иванов48","Экономист",null,"Иванов4842736"]
[{"$f":"IF(AND(Табель!D$1=B51,C51=\"Работает\"),A50+1,A50)","v":0},"2017-01-01","Рассчитан",null,null,"Иванов49","Сторож",null,"Иванов4942736"]
[{"$f":"IF(AND(Табель!D$1=B52,C52=\"Работает\"),A51+1,A51)","v":0},"2017-01-01","Работает",null,null,"Иванов50","Директор",null,{"$f":"F52&B52","v":"Иванов5042736"}]
[{"$f":"IF(AND(Табель!D$1=B53,C53=\"Работает\"),A52+1,A52)","v":0},"2017-01-01","Работает",null,null,"Иванов51","Бухгалтер",null,{"$f":"F53&B53","v":"Иванов5142736"}]
[{"$f":"IF(AND(Табель!D$1=B54,C54=\"Работает\"),A53+1,A53)","v":0},"2017-01-01","Работает",null,null,"Иванов52","ОК",null,"Иванов5242736"]
[{"$f":"IF(AND(Табель!D$1=B55,C55=\"Работает\"),A54+1,A54)","v":0},"2017-01-01","Работает",null,null,"Иванов53","Кассир",null,"Иванов5342736"]
[{"$f":"IF(AND(Табель!D$1=B56,C56=\"Работает\"),A55+1,A55)","v":0},"2017-01-01","Работает",null,null,"Иванов54","Инженер ТБ",null,"Иванов5442736"]
[{"$f":"IF(AND(Табель!D$1=B57,C57=\"Работает\"),A56+1,A56)","v":0},"2017-01-01","Работает",null,null,"Иванов55","Экономист",null,"Иванов5542736"]
[{"$f":"IF(AND(Табель!D$1=B58,C58=\"Работает\"),A57+1,A57)","v":0},"2017-01-01","Работает",null,null,"Иванов56","Сторож",null,"Иванов5642736"]
[{"$f":"IF(AND(Табель!D$1=B59,C59=\"Работает\"),A58+1,A58)","v":1},"2017-02-01","Работает",null,null,"Иванов57","Директор",null,"Иванов5742767"]
[{"$f":"IF(AND(Табель!D$1=B60,C60=\"Работает\"),A59+1,A59)","v":2},"2017-02-01","Работает",null,null,"Иванов58","Бухгалтер",null,"Иванов5842767"]
[{"$f":"IF(AND(Табель!D$1=B61,C61=\"Работает\"),A60+1,A60)","v":3},"2017-02-01","Работает",null,null,"Иванов59","ОК",null,"Иванов5942767"]
[{"$f":"IF(AND(Табель!D$1=B62,C62=\"Работает\"),A61+1,A61)","v":4},"2017-02-01","Работает",null,null,"Иванов60","Кассир",null,"Иванов6042767"]
[{"$f":"IF(AND(Табель!D$1=B63,C63=\"Работает\"),A62+1,A62)","v":5},"2017-02-01","Работает",null,null,"Иванов61","Инженер ТБ",null,"Иванов6142767"]
[{"$f":"IF(AND(Табель!D$1=B64,C64=\"Работает\"),A63+1,A63)","v":5},"2017-02-01","Уволен",null,null,"Иванов62","Экономист",null,"Иванов6242767"]
[{"$f":"IF(AND(Табель!D$1=B65,C65=\"Работает\"),A64+1,A64)","v":6},"2017-02-01","Работает",null,null,"Иванов63","Экономист 2",null,"Иванов6342767"]
[{"$f":"IF(AND(Табель!D$1=B66,C66=\"Работает\"),A65+1,A65)","v":7},"2017-02-01","Работает",null,null,"Иванов64","Директор",null,{"$f":"F66&B66","v":"Иванов6442767"}]
[{"$f":"IF(AND(Табель!D$1=B67,C67=\"Работает\"),A66+1,A66)","v":8},"2017-02-01","Работает",null,null,"Иванов65","Бухгалтер",null,"Иванов6542767"]
[{"$f":"IF(AND(Табель!D$1=B68,C68=\"Работает\"),A67+1,A67)","v":9},"2017-02-01","Работает",null,null,"Иванов66","ОК",null,"Иванов6642767"]
[{"$f":"IF(AND(Табель!D$1=B69,C69=\"Работает\"),A68+1,A68)","v":10},"2017-02-01","Работает",null,null,"Иванов67","Кассир",null,"Иванов6742767"]
[{"$f":"IF(AND(Табель!D$1=B70,C70=\"Работает\"),A69+1,A69)","v":11},"2017-02-01","Работает",null,null,"Иванов68","Инженер ТБ",null,"Иванов6842767"]
[{"$f":"IF(AND(Табель!D$1=B71,C71=\"Работает\"),A70+1,A70)","v":11},"2017-02-01","Уволен",null,null,"Иванов69","Экономист",null,"Иванов6942767"]
[{"$f":"IF(AND(Табель!D$1=B72,C72=\"Работает\"),A71+1,A71)","v":12},"2017-02-01","Работает",null,null,"Иванов70","Экономист 2",null,"Иванов7042767"]
[{"$f":"IF(AND(Табель!D$1=B73,C73=\"Работает\"),A72+1,A72)","v":13},"2017-02-01","Работает",null,null,"Иванов71","Директор",null,"Иванов7142767"]
[{"$f":"IF(AND(Табель!D$1=B74,C74=\"Работает\"),A73+1,A73)","v":14},"2017-02-01","Работает",null,null,"Иванов72","Бухгалтер",null,"Иванов7242767"]
[{"$f":"IF(AND(Табель!D$1=B75,C75=\"Работает\"),A74+1,A74)","v":15},"2017-02-01","Работает",null,null,"Иванов73","ОК",null,"Иванов7342767"]
[{"$f":"IF(AND(Табель!D$1=B76,C76=\"Работает\"),A75+1,A75)","v":16},"2017-02-01","Работает",null,null,"Иванов74","Кассир",null,"Иванов7442767"]
[{"$f":"IF(AND(Табель!D$1=B77,C77=\"Работает\"),A76+1,A76)","v":17},"2017-02-01","Работает",null,null,"Иванов75","Инженер ТБ",null,"Иванов7542767"]
[{"$f":"IF(AND(Табель!D$1=B78,C78=\"Работает\"),A77+1,A77)","v":17},"2017-02-01","Уволен",null,null,"Иванов76","Экономист",null,"Иванов7642767"]
[{"$f":"IF(AND(Табель!D$1=B79,C79=\"Работает\"),A78+1,A78)","v":18},"2017-02-01","Работает",null,null,"Иванов77","Экономист 2",null,"Иванов7742767"]
[{"$f":"IF(AND(Табель!D$1=B80,C80=\"Работает\"),A79+1,A79)","v":19},"2017-02-01","Работает",null,null,"Иванов78","Директор",null,{"$f":"F80&B80","v":"Иванов7842767"}]
[{"$f":"IF(AND(Табель!D$1=B81,C81=\"Работает\"),A80+1,A80)","v":20},"2017-02-01","Работает",null,null,"Иванов79","Бухгалтер",null,"Иванов7942767"]
[{"$f":"IF(AND(Табель!D$1=B82,C82=\"Работает\"),A81+1,A81)","v":21},"2017-02-01","Работает",null,null,"Иванов80","ОК",null,"Иванов8042767"]
[{"$f":"IF(AND(Табель!D$1=B83,C83=\"Работает\"),A82+1,A82)","v":22},"2017-02-01","Работает",null,null,"Иванов81","Кассир",null,"Иванов8142767"]
[{"$f":"IF(AND(Табель!D$1=B84,C84=\"Работает\"),A83+1,A83)","v":23},"2017-02-01","Работает",null,null,"Иванов82","Инженер ТБ",null,"Иванов8242767"]
[{"$f":"IF(AND(Табель!D$1=B85,C85=\"Работает\"),A84+1,A84)","v":23},"2017-02-01","Уволен",null,null,"Иванов83","Экономист",null,"Иванов8342767"]
[{"$f":"IF(AND(Табель!D$1=B86,C86=\"Работает\"),A85+1,A85)","v":24},"2017-02-01","Работает",null,null,"Иванов84","Экономист 2",null,"Иванов8442767"]
[{"$f":"IF(AND(Табель!D$1=B87,C87=\"Работает\"),A86+1,A86)","v":25},"2017-02-01","Работает",null,null,"Иванов85","Директор",null,"Иванов8542767"]
[{"$f":"IF(AND(Табель!D$1=B88,C88=\"Работает\"),A87+1,A87)","v":26},"2017-02-01","Работает",null,null,"Иванов86","Бухгалтер",null,"Иванов8642767"]
[{"$f":"IF(AND(Табель!D$1=B89,C89=\"Работает\"),A88+1,A88)","v":27},"2017-02-01","Работает",null,null,"Иванов87","ОК",null,"Иванов8742767"]
[{"$f":"IF(AND(Табель!D$1=B90,C90=\"Работает\"),A89+1,A89)","v":28},"2017-02-01","Работает",null,null,"Иванов88","Кассир",null,"Иванов8842767"]
[{"$f":"IF(AND(Табель!D$1=B91,C91=\"Работает\"),A90+1,A90)","v":29},"2017-02-01","Работает",null,null,"Иванов89","Инженер ТБ",null,"Иванов8942767"]
[{"$f":"IF(AND(Табель!D$1=B92,C92=\"Работает\"),A91+1,A91)","v":29},"2017-02-01","Уволен",null,null,"Иванов90","Экономист",null,"Иванов9042767"]
[{"$f":"IF(AND(Табель!D$1=B93,C93=\"Работает\"),A92+1,A92)","v":30},"2017-02-01","Работает",null,null,"Иванов91","Экономист 2",null,"Иванов9142767"]
[{"$f":"IF(AND(Табель!D$1=B94,C94=\"Работает\"),A93+1,A93)","v":31},"2017-02-01","Работает",null,null,"Иванов92","Директор",null,"Иванов9242767"]
[{"$f":"IF(AND(Табель!D$1=B95,C95=\"Работает\"),A94+1,A94)","v":32},"2017-02-01","Работает",null,null,"Иванов93","Бухгалтер",null,"Иванов9342767"]
[{"$f":"IF(AND(Табель!D$1=B96,C96=\"Работает\"),A95+1,A95)","v":33},"2017-02-01","Работает",null,null,"Иванов94","ОК",null,"Иванов9442767"]
[{"$f":"IF(AND(Табель!D$1=B97,C97=\"Работает\"),A96+1,A96)","v":34},"2017-02-01","Работает",null,null,"Иванов95","Кассир",null,"Иванов9542767"]
[{"$f":"IF(AND(Табель!D$1=B98,C98=\"Работает\"),A97+1,A97)","v":35},"2017-02-01","Работает",null,null,"Иванов96","Инженер ТБ",null,"Иванов9642767"]
[{"$f":"IF(AND(Табель!D$1=B99,C99=\"Работает\"),A98+1,A98)","v":35},"2017-02-01","Уволен",null,null,"Иванов97","Экономист",null,"Иванов9742767"]
[{"$f":"IF(AND(Табель!D$1=B100,C100=\"Работает\"),A99+1,A99)","v":36},"2017-02-01","Работает",null,null,"Иванов98","Экономист 2",null,"Иванов9842767"]
[{"$f":"IF(AND(Табель!D$1=B101,C101=\"Работает\"),A100+1,A100)","v":37},"2017-02-01","Работает",null,null,"Иванов99","Директор",null,"Иванов9942767"]
[{"$f":"IF(AND(Табель!D$1=B102,C102=\"Работает\"),A101+1,A101)","v":38},"2017-02-01","Работает",null,null,"Иванов100","Бухгалтер",null,"Иванов10042767"]
[{"$f":"IF(AND(Табель!D$1=B103,C103=\"Работает\"),A102+1,A102)","v":39},"2017-02-01","Работает",null,null,"Иванов101","ОК",null,"Иванов10142767"]
[{"$f":"IF(AND(Табель!D$1=B104,C104=\"Работает\"),A103+1,A103)","v":40},"2017-02-01","Работает",null,null,"Иванов102","Кассир",null,"Иванов10242767"]
[{"$f":"IF(AND(Табель!D$1=B105,C105=\"Работает\"),A104+1,A104)","v":41},"2017-02-01","Работает",null,null,"Иванов103","Инженер ТБ",null,"Иванов10342767"]
[{"$f":"IF(AND(Табель!D$1=B106,C106=\"Работает\"),A105+1,A105)","v":41},"2017-02-01","Уволен",null,null,"Иванов104","Экономист",null,"Иванов10442767"]
[{"$f":"IF(AND(Табель!D$1=B107,C107=\"Работает\"),A106+1,A106)","v":42},"2017-02-01","Работает",null,null,"Иванов105","Экономист 2",null,"Иванов10542767"]
[{"$f":"IF(AND(Табель!D$1=B108,C108=\"Работает\"),A107+1,A107)","v":43},"2017-02-01","Работает",null,null,"Иванов106","Директор",null,{"$f":"F108&B108","v":"Иванов10642767"}]
[{"$f":"IF(AND(Табель!D$1=B109,C109=\"Работает\"),A108+1,A108)","v":44},"2017-02-01","Работает",null,null,"Иванов107","Бухгалтер",null,"Иванов10742767"]
[{"$f":"IF(AND(Табель!D$1=B110,C110=\"Работает\"),A109+1,A109)","v":45},"2017-02-01","Работает",null,null,"Иванов108","ОК",null,"Иванов10842767"]
[{"$f":"IF(AND(Табель!D$1=B111,C111=\"Работает\"),A110+1,A110)","v":46},"2017-02-01","Работает",null,null,"Иванов109","Кассир",null,"Иванов10942767"]
[{"$f":"IF(AND(Табель!D$1=B112,C112=\"Работает\"),A111+1,A111)","v":47},"2017-02-01","Работает",null,null,"Иванов110","Инженер ТБ",null,"Иванов11042767"]
[{"$f":"IF(AND(Табель!D$1=B113,C113=\"Работает\"),A112+1,A112)","v":47},"2017-02-01","Уволен",null,null,"Иванов111","Экономист",null,"Иванов11142767"]
[{"$f":"IF(AND(Табель!D$1=B114,C114=\"Работает\"),A113+1,A113)","v":48},"2017-02-01","Работает",null,null,"Иванов112","Экономист 2",null,"Иванов11242767"]
[{"$f":"IF(AND(Табель!D$1=B115,C115=\"Работает\"),A114+1,A114)","v":48},"2017-03-01","Работает",null,null,"Иванов113","Директор",null,"Иванов11342795"]
[{"$f":"IF(AND(Табель!D$1=B116,C116=\"Работает\"),A115+1,A115)","v":48},"2017-03-01","Работает",null,null,"Иванов114","Бухгалтер",null,"Иванов11442795"]
[{"$f":"IF(AND(Табель!D$1=B117,C117=\"Работает\"),A116+1,A116)","v":48},"2017-03-01","Работает",null,null,"Иванов115","ОК",null,"Иванов11542795"]
[{"$f":"IF(AND(Табель!D$1=B118,C118=\"Работает\"),A117+1,A117)","v":48},"2017-03-01","Работает",null,null,"Иванов116","Кассир",null,"Иванов11642795"]
[{"$f":"IF(AND(Табель!D$1=B119,C119=\"Работает\"),A118+1,A118)","v":48},"2017-03-01","Работает",null,null,"Иванов117","Инженер ТБ",null,"Иванов11742795"]

{"sheet":"Табель","index":1,"n_rows":57,"n_cols":42,"rows_kept":57,"cut":false,"hidden":false,"merged":[[5,0,6,0],[5,41,6,41],[5,36,6,36],[5,37,6,37],[5,38,6,38],[5,39,6,39],[5,40,6,40],[5,1,6,1],[5,2,6,2],[5,3,5,33],[5,34,6,34],[5,35,6,35],[0,10,3,36],[0,3,0,5]]}
[null,"Табель учета рабочего времени",null,"2017-02-01",null,null,null,null,null,null,"Идея такова. После смены месяца на листе Табель - меняются Фамилии согластно дате в Штатке и должностя. После обновления списка остаются пустые строки и не вычисляется суммирование по итоговым часам за месяц. Хочется упростить бухгалтерам жизнь))) и по факту избавиться от проблемы с удалением формул!!!! Для этого думал использовать макрос автозаполнения форматов и формул в ячейках от D до AP столбцов. Нашел подходящий по всем параметрам макрос и попытался как могу приделать к файлу.\nВопреки всем ожиданиям макросник не сработал и выдал ошибку. Причину пока не нашел да и если честно не очень силен я в программировании а сроки поджимают -  начальство давит ))))"]
[]
[]
[]
[]
["№","ФИО","Должность","Дни месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Рабочие дни","Вахта","ТО","ТО-2","Ремонт","Отпуск","Команд","Рабочие часы"]
[null,null,null,{"$f":"DAY(D1)","v":"1900-01-01"},{"$f":"IF(ISERR(D7+1),\"\",IF(D7+1<=DAY(EOMONTH($D$1,0)),D7+1,\"\"))","v":2},{"$f":"IF(ISERR(E7+1),\"\",IF(E7+1<=DAY(EOMONTH($D$1,0)),E7+1,\"\"))","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,"","",""]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B1),Штатка!$A:$G,COLUMN(F1),),\"\")","v":"Иванов57"},{"$f":"IFERROR(VLOOKUP(ROW(C1),Штатка!$A:$G,COLUMN(G1),),\"\")","v":"Директор"},"в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в",{"$f":"COUNTA(D8:AH8)-AM8-AN8","v":31},{"$f":"COUNTIF(D8:AH8,\"В\")","v":27},{"$f":"COUNTIF(D8:AH8,\"ТО-1\")","v":0},{"$f":"COUNTIF(D8:AH8,\"ТО-2\")","v":0},{"$f":"COUNTIF(D8:AH8,\"Р\")","v":0},{"$f":"COUNTIF(D8:AH8,\"О\")","v":0},{"$f":"COUNTIF(D8:AH8,\"К\")","v":0},{"$f":"(ROUND(SUM(D8:AH8)*24,0)/24)+AJ8/2.4+AK8/2.4+AL8/2.4+AO8/2.4","v":12.583333333333334}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B2),Штатка!$A:$G,COLUMN(F2),),\"\")","v":"Иванов58"},{"$f":"IFERROR(VLOOKUP(ROW(C2),Штатка!$A:$G,COLUMN(G2),),\"\")","v":"Бухгалтер"},"в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в",{"$f":"COUNTA(D9:AH9)-AM9-AN9","v":31},{"$f":"COUNTIF(D9:AH9,\"В\")","v":27},{"$f":"COUNTIF(D9:AH9,\"ТО-1\")","v":0},{"$f":"COUNTIF(D9:AH9,\"ТО-2\")","v":0},{"$f":"COUNTIF(D9:AH9,\"Р\")","v":0},{"$f":"COUNTIF(D9:AH9,\"О\")","v":0},{"$f":"COUNTIF(D9:AH9,\"К\")","v":0},12.583333333333334]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B3),Штатка!$A:$G,COLUMN(F3),),\"\")","v":"Иванов59"},{"$f":"IFERROR(VLOOKUP(ROW(C3),Штатка!$A:$G,COLUMN(G3),),\"\")","v":"ОК"},"в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в","в","08:00:00","в","в","в","в","в",31,27,0,0,0,0,0,12.583333333333334]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B4),Штатка!$A:$G,COLUMN(F4),),\"\")","v":"Иванов60"},{"$f":"IFERROR(VLOOKUP(ROW(C4),Штатка!$A:$G,COLUMN(G4),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B5),Штатка!$A:$G,COLUMN(F5),),\"\")","v":"Иванов61"},{"$f":"IFERROR(VLOOKUP(ROW(C5),Штатка!$A:$G,COLUMN(G5),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B6),Штатка!$A:$G,COLUMN(F6),),\"\")","v":"Иванов63"},{"$f":"IFERROR(VLOOKUP(ROW(C6),Штатка!$A:$G,COLUMN(G6),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B7),Штатка!$A:$G,COLUMN(F7),),\"\")","v":"Иванов64"},{"$f":"IFERROR(VLOOKUP(ROW(C7),Штатка!$A:$G,COLUMN(G7),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B8),Штатка!$A:$G,COLUMN(F8),),\"\")","v":"Иванов65"},{"$f":"IFERROR(VLOOKUP(ROW(C8),Штатка!$A:$G,COLUMN(G8),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B9),Штатка!$A:$G,COLUMN(F9),),\"\")","v":"Иванов66"},{"$f":"IFERROR(VLOOKUP(ROW(C9),Штатка!$A:$G,COLUMN(G9),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B10),Штатка!$A:$G,COLUMN(F10),),\"\")","v":"Иванов67"},{"$f":"IFERROR(VLOOKUP(ROW(C10),Штатка!$A:$G,COLUMN(G10),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B11),Штатка!$A:$G,COLUMN(F11),),\"\")","v":"Иванов68"},{"$f":"IFERROR(VLOOKUP(ROW(C11),Штатка!$A:$G,COLUMN(G11),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B12),Штатка!$A:$G,COLUMN(F12),),\"\")","v":"Иванов70"},{"$f":"IFERROR(VLOOKUP(ROW(C12),Штатка!$A:$G,COLUMN(G12),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B13),Штатка!$A:$G,COLUMN(F13),),\"\")","v":"Иванов71"},{"$f":"IFERROR(VLOOKUP(ROW(C13),Штатка!$A:$G,COLUMN(G13),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B14),Штатка!$A:$G,COLUMN(F14),),\"\")","v":"Иванов72"},{"$f":"IFERROR(VLOOKUP(ROW(C14),Штатка!$A:$G,COLUMN(G14),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B15),Штатка!$A:$G,COLUMN(F15),),\"\")","v":"Иванов73"},{"$f":"IFERROR(VLOOKUP(ROW(C15),Штатка!$A:$G,COLUMN(G15),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B16),Штатка!$A:$G,COLUMN(F16),),\"\")","v":"Иванов74"},{"$f":"IFERROR(VLOOKUP(ROW(C16),Штатка!$A:$G,COLUMN(G16),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B17),Штатка!$A:$G,COLUMN(F17),),\"\")","v":"Иванов75"},{"$f":"IFERROR(VLOOKUP(ROW(C17),Штатка!$A:$G,COLUMN(G17),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B18),Штатка!$A:$G,COLUMN(F18),),\"\")","v":"Иванов77"},{"$f":"IFERROR(VLOOKUP(ROW(C18),Штатка!$A:$G,COLUMN(G18),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B19),Штатка!$A:$G,COLUMN(F19),),\"\")","v":"Иванов78"},{"$f":"IFERROR(VLOOKUP(ROW(C19),Штатка!$A:$G,COLUMN(G19),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B20),Штатка!$A:$G,COLUMN(F20),),\"\")","v":"Иванов79"},{"$f":"IFERROR(VLOOKUP(ROW(C20),Штатка!$A:$G,COLUMN(G20),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B21),Штатка!$A:$G,COLUMN(F21),),\"\")","v":"Иванов80"},{"$f":"IFERROR(VLOOKUP(ROW(C21),Штатка!$A:$G,COLUMN(G21),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B22),Штатка!$A:$G,COLUMN(F22),),\"\")","v":"Иванов81"},{"$f":"IFERROR(VLOOKUP(ROW(C22),Штатка!$A:$G,COLUMN(G22),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B23),Штатка!$A:$G,COLUMN(F23),),\"\")","v":"Иванов82"},{"$f":"IFERROR(VLOOKUP(ROW(C23),Штатка!$A:$G,COLUMN(G23),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B24),Штатка!$A:$G,COLUMN(F24),),\"\")","v":"Иванов84"},{"$f":"IFERROR(VLOOKUP(ROW(C24),Штатка!$A:$G,COLUMN(G24),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B25),Штатка!$A:$G,COLUMN(F25),),\"\")","v":"Иванов85"},{"$f":"IFERROR(VLOOKUP(ROW(C25),Штатка!$A:$G,COLUMN(G25),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B26),Штатка!$A:$G,COLUMN(F26),),\"\")","v":"Иванов86"},{"$f":"IFERROR(VLOOKUP(ROW(C26),Штатка!$A:$G,COLUMN(G26),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B27),Штатка!$A:$G,COLUMN(F27),),\"\")","v":"Иванов87"},{"$f":"IFERROR(VLOOKUP(ROW(C27),Штатка!$A:$G,COLUMN(G27),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B28),Штатка!$A:$G,COLUMN(F28),),\"\")","v":"Иванов88"},{"$f":"IFERROR(VLOOKUP(ROW(C28),Штатка!$A:$G,COLUMN(G28),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B29),Штатка!$A:$G,COLUMN(F29),),\"\")","v":"Иванов89"},{"$f":"IFERROR(VLOOKUP(ROW(C29),Штатка!$A:$G,COLUMN(G29),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B30),Штатка!$A:$G,COLUMN(F30),),\"\")","v":"Иванов91"},{"$f":"IFERROR(VLOOKUP(ROW(C30),Штатка!$A:$G,COLUMN(G30),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B31),Штатка!$A:$G,COLUMN(F31),),\"\")","v":"Иванов92"},{"$f":"IFERROR(VLOOKUP(ROW(C31),Штатка!$A:$G,COLUMN(G31),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B32),Штатка!$A:$G,COLUMN(F32),),\"\")","v":"Иванов93"},{"$f":"IFERROR(VLOOKUP(ROW(C32),Штатка!$A:$G,COLUMN(G32),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B33),Штатка!$A:$G,COLUMN(F33),),\"\")","v":"Иванов94"},{"$f":"IFERROR(VLOOKUP(ROW(C33),Штатка!$A:$G,COLUMN(G33),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B34),Штатка!$A:$G,COLUMN(F34),),\"\")","v":"Иванов95"},{"$f":"IFERROR(VLOOKUP(ROW(C34),Штатка!$A:$G,COLUMN(G34),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B35),Штатка!$A:$G,COLUMN(F35),),\"\")","v":"Иванов96"},{"$f":"IFERROR(VLOOKUP(ROW(C35),Штатка!$A:$G,COLUMN(G35),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B36),Штатка!$A:$G,COLUMN(F36),),\"\")","v":"Иванов98"},{"$f":"IFERROR(VLOOKUP(ROW(C36),Штатка!$A:$G,COLUMN(G36),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B37),Штатка!$A:$G,COLUMN(F37),),\"\")","v":"Иванов99"},{"$f":"IFERROR(VLOOKUP(ROW(C37),Штатка!$A:$G,COLUMN(G37),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B38),Штатка!$A:$G,COLUMN(F38),),\"\")","v":"Иванов100"},{"$f":"IFERROR(VLOOKUP(ROW(C38),Штатка!$A:$G,COLUMN(G38),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B39),Штатка!$A:$G,COLUMN(F39),),\"\")","v":"Иванов101"},{"$f":"IFERROR(VLOOKUP(ROW(C39),Штатка!$A:$G,COLUMN(G39),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B40),Штатка!$A:$G,COLUMN(F40),),\"\")","v":"Иванов102"},{"$f":"IFERROR(VLOOKUP(ROW(C40),Штатка!$A:$G,COLUMN(G40),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B41),Штатка!$A:$G,COLUMN(F41),),\"\")","v":"Иванов103"},{"$f":"IFERROR(VLOOKUP(ROW(C41),Штатка!$A:$G,COLUMN(G41),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B42),Штатка!$A:$G,COLUMN(F42),),\"\")","v":"Иванов105"},{"$f":"IFERROR(VLOOKUP(ROW(C42),Штатка!$A:$G,COLUMN(G42),),\"\")","v":"Экономист 2"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B43),Штатка!$A:$G,COLUMN(F43),),\"\")","v":"Иванов106"},{"$f":"IFERROR(VLOOKUP(ROW(C43),Штатка!$A:$G,COLUMN(G43),),\"\")","v":"Директор"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B44),Штатка!$A:$G,COLUMN(F44),),\"\")","v":"Иванов107"},{"$f":"IFERROR(VLOOKUP(ROW(C44),Штатка!$A:$G,COLUMN(G44),),\"\")","v":"Бухгалтер"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B45),Штатка!$A:$G,COLUMN(F45),),\"\")","v":"Иванов108"},{"$f":"IFERROR(VLOOKUP(ROW(C45),Штатка!$A:$G,COLUMN(G45),),\"\")","v":"ОК"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B46),Штатка!$A:$G,COLUMN(F46),),\"\")","v":"Иванов109"},{"$f":"IFERROR(VLOOKUP(ROW(C46),Штатка!$A:$G,COLUMN(G46),),\"\")","v":"Кассир"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B47),Штатка!$A:$G,COLUMN(F47),),\"\")","v":"Иванов110"},{"$f":"IFERROR(VLOOKUP(ROW(C47),Штатка!$A:$G,COLUMN(G47),),\"\")","v":"Инженер ТБ"}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B48),Штатка!$A:$G,COLUMN(F48),),\"\")","v":"Иванов112"},{"$f":"IFERROR(VLOOKUP(ROW(C48),Штатка!$A:$G,COLUMN(G48),),\"\")","v":"Экономист 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,{"$f":"COUNTA(D55:AH55)-AM55-AN55","v":0},{"$f":"COUNTIF(D55:AH55,\"В\")","v":0},{"$f":"COUNTIF(D55:AH55,\"ТО-1\")","v":0},{"$f":"COUNTIF(D55:AH55,\"ТО-2\")","v":0},{"$f":"COUNTIF(D55:AH55,\"Р\")","v":0},{"$f":"COUNTIF(D55:AH55,\"О\")","v":0},{"$f":"COUNTIF(D55:AH55,\"К\")","v":0},{"$f":"(ROUND(SUM(D55:AH55)*24,0)/24)+AJ55/2.4+AK55/2.4+AL55/2.4+AO55/2.4","v":0}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B49),Штатка!$A:$G,COLUMN(F49),),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW(C49),Штатка!$A:$G,COLUMN(G49),),\"\")","v":""}]
[1,{"$f":"IFERROR(VLOOKUP(ROW(B50),Штатка!$A:$G,COLUMN(F50),),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW(C50),Штатка!$A:$G,COLUMN(G50),),\"\")","v":""}]

{"sheet":"Зарплата","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,1,1,"А",{"$f":"D3&C3","v":"А1"},{"$f":"C3&D3&E3","v":"1АА1"}]
[null,2]
[null,3]