{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Распоряжение","Служебка вызов","Отчет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
["№ п/п","Ф.И.О","Должность","Вид работ",null,"Вып.:","Подпись ","Примечание","Планируемы процент выполнения"]
[1,null,1,1]
[2]
[3]
[4]
[5]
[{"$f":"IF(ISBLANK(B7),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B8),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B9),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B10),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B11),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B12),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B13),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B14),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B15),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B16),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B17),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B18),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B19),\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(ISBLANK(B20),\"x\",ROW(A1))","v":"x"}]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]

{"sheet":"Служебка вызов","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,6],[38,1,39,1],[38,3,39,3],[38,2,39,2],[38,4,39,6],[1,4,1,5],[2,1,8,1],[2,2,8,2],[2,3,8,3],[2,6,8,6],[9,1,37,1],[9,2,37,2],[9,3,37,3],[9,6,37,6]]}
[null,{"$f":"\" запланирована работа\"&\" \"&SUM(C3:C38)&\" \"&\"человек\"","v":" запланирована работа 0 человек"}]
["Для расчота","Категория персонала ","Численность","Таб. время (план), час.","Планируемые работы",null,"Объем работ н/час"]
[1,3,null,null,123,123]
[2,null,null,null,123,123]
[{"$f":"IF(E5=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E6=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E7=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E8=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E9=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E10=\"\",\"x\",ROW(#REF!))","v":"x"},5]
[{"$f":"IF(E11=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E12=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E13=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E14=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E15=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E16=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E17=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E18=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E19=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E20=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E21=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E22=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E23=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E24=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E25=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E26=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E27=\"\",\"x\",ROW(A1))","v":"x"}]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
[null,"Итого на отгул:",{"$f":"(C10+C3)-E39","v":0},"Итого на отгул:",{"$f":"COUNTIF(Распоряжение!H2:H36,\"Отгул\")","v":0}]

{"sheet":"Отчет","index":2,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,1,36,1],[8,2,36,2],[8,3,36,3],[8,6,36,6],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,6],[0,4,0,5],[1,1,7,1],[1,2,7,2],[1,3,7,3],[1,6,7,6]]}
["Для расчота","Категория персонала ","Численность","Таб. время (план), час.","Планируемые работы",null,"Объем работ н/час"]
[1,3,null,null,"л",null,{"$f":"C2*6","v":0}]
[2,null,null,null,"л"]
[3]
[4]
[5]
[6]
[{"$f":"IF(E8=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E9=\"\",\"x\",ROW(#REF!))","v":"x"},5,null,null,null,null,{"$f":"C9*6","v":0}]
[{"$f":"IF(E10=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E11=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E12=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E13=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E14=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E15=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E16=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E17=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E18=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E19=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E20=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E21=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E22=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E23=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E24=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E25=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E26=\"\",\"x\",ROW(#REF!))","v":"x"}]
[{"$f":"IF(E27=\"\",\"x\",ROW(A1))","v":"x"}]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
["x"]
[null,"Итого на отгул:",{"$f":"(C9+C2)-E38","v":0},"Итого на отгул:",{"$f":"COUNTIF(Распоряжение!H2:H36,\"Отгул\")","v":0}]