{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["График","Условия"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":27,"n_cols":41,"rows_kept":27,"cut":false,"hidden":false,"merged":[[23,0,23,2],[22,0,22,3],[19,0,19,3],[8,39,9,39],[2,19,2,33],[4,19,4,33],[8,40,9,40],[8,1,9,1],[20,0,20,2],[8,0,9,0],[7,37,7,38],[8,36,9,36],[8,2,9,2],[8,3,9,3],[8,38,9,38],[8,37,9,37],[8,35,9,35],[1,7,1,17],[2,7,2,17],[3,7,3,17],[4,7,4,17],[4,0,4,2],[1,0,1,2],[2,0,2,2],[3,0,3,2]]}
["Общие условия:",null,null,null,"Условия и условные обозначения: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Как это работает? ",null,null,null,null,"Обязательно включите макросы при открытии файла!"]
["Максим. длительность раб. недели, час",null,null,40,"\"фиксировать\"",null,null," - График зафиксирован и не изменяется после\nнажатия на кнопку \"Построить график\"",null,null,null,null,null,null,null,null,null,null,null,"1. Заполните ячейки, залитые желтым (при необходимости)"]
["Длительность раб. года, час",null,null,1971,"\"изменять\" ",null,null," - После нажатия на кнопку \"Построить график\" \nстроится график с учетом указанных выходных",null,null,null,null,null,null,null,null,null,null,null,"2. Проставьте сотрудникам  рабочие часы и выходные (значок \"-\"),\nкоторые Вы хотите зафиксировать"]
["Кол-во рабочих часов в месяц на 1 сотрудника, не более",null,null,{"$f":"(D3+120)/365*COUNT(E10:AI10)","v":177.59178082191781},null," - ",null," - Выходные дни. Дни, обозначенные значком \" - \", \nпри построении графика НЕ назначаюстя рабочими. ",null,null,null,null,null,null,null,null,null,null,null,"3. Нажмите кнопку \"Построить график\""]
["Общий бюджет часов (на всех сотрудников)",null,null,840,null,null,null,"Значок \" - \"выбирается из списка, выпадающего при\nнажатии на треугольник справа активной от ячейки.",null,null,null,null,null,null,null,null,null,null,null,"4. Вы можете вносить необходимые изменеия в график\nв любой момент. Построенный график можно скопировать\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,null,null,null,null,null,null,"Итого по графику"]
["Табел.\nномер","Номер\nп/п","Профессия\n(должность)","Ф.И.О.","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ","ВС","ПН","Фиксировать\nили изменять\nграфик при расчете","Бюджет часов\nпо ТК","Часы","Дни","Дата","Подпись"]
[null,null,null,null,1,2,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,29,30,31]
["0228",1,"директор","Макаров",8,8,null,null,8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,null," -","фиксировать",{"$f":"$D$4","v":177.59178082191781},{"$f":"SUMIF(E11:AI11,\">0\")","v":168},{"$f":"COUNTIF(E11:AI11,\">0\")","v":21}]
["0321",2,"ст.продавец","Иванов",null,null,null,null," -"," -",null,null,null,null,null,null,null," -",null,null,null,null,null," -"," -",null,null,null,null,null," -"," -",null,null," -","изменять",{"$f":"$D$4","v":177.59178082191781},{"$f":"SUMIF(E12:AI12,\">0\")","v":0},{"$f":"COUNTIF(E12:AI12,\">0\")","v":0}]
["0417",3,"ст.продавец","Петров",null," -"," -",null,null,null,null,null," -"," -",null,null,null,null,null," -"," -",null,null,null,null,null," -"," -",null,null,null,null,null,null," -","изменять",177.59178082191781,{"$f":"SUMIF(E13:AI13,\">0\")","v":0},0]
["0513",4,"продавец","Сидоров",null,null,null,null,null," -"," -",null,null,null,null,null,null," -"," -",null,null,null," -",null,null,null,null,null," -"," -",null,null,null,null," -","изменять",177.59178082191781,{"$f":"SUMIF(E14:AI14,\">0\")","v":0},0]
["0609",5,"продавец","Леонов",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," -","изменять",177.59178082191781,{"$f":"SUMIF(E15:AI15,\">0\")","v":0},0]
["Итого",null,null,null,{"$f":"COUNTIF(E11:E15,\">0\")","v":1},1,0,0,1,1,1,1,0,0,1,1,1,1,1,0,0,1,1,1,1,1,0,0,{"$f":"COUNTIF(AC11:AC15,\">0\")","v":1},1,1,1,1,0,0,null,{"$f":"D5","v":840},{"$f":"SUM(AL11:AL15)","v":168}]
["Check",null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Условия для автоматического формирования графика:"]
["Продолжительность рабочего дня по умолчанию, часов",null,null,8]
[]
["Обязательное присутствие в смене\n(если устанавливается): "]
["Должность (заполняется автоматически\nпри добавлении в график",null,null,"Кол-во человек\n(заполните)"]
["директор",null,null,0]
["ст.продавец",null,null,1]
["продавец",null,null,1]

{"sheet":"Условия","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Часы",null,"Фиксация"]
[" -"]
[4,null,"фиксировать"]
[5,null,"изменять"]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]