{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["График","Лист1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":3,"defined_names":12,"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":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,6],[3,7,3,10]]}
[]
[]
[]
["№","Должность","Ф.И.О.","Отпуск по плану 1 ч.",null,null,null,"Отпуск по плану 2 ч.",null,null,null,null,"Праздники"]
[null,null,null,"Дней отп.","Начало","Окончание","Всего дней","Дней отп.","Начало","Окончание","Всего дней",null,"2014-01-01"]
[{"$f":"IF(ISBLANK(C6),\"\",COUNTA($C$6:C6))","v":1},"Кадровик","Алымова",14,"2014-03-17",{"$f":"IF(ДНИОТП(E6,D6,$M$5:$M$19)<=0,\"\",ДНИОТП(E6,D6,$M$5:$M$19))","v":"2014-03-30"},{"$f":"IFERROR((F6-E6+1),\"\")","v":14},14,"2014-08-11",{"$f":"IF(ДНИОТП(I6,H6,$M$5:$M$19)<=0,\"\",ДНИОТП(I6,H6,$M$5:$M$19))","v":"2014-08-24"},{"$f":"IFERROR((J6-I6+1),\"\")","v":14},null,"2014-01-02"]
[{"$f":"IF(ISBLANK(C7),\"\",COUNTA($C$6:C7))","v":2},"Электрик","Безродный",14,"2014-06-17",{"$f":"IF(ДНИОТП(E7,D7,$M$5:$M$19)<=0,\"\",ДНИОТП(E7,D7,$M$5:$M$19))","v":"2014-06-30"},{"$f":"IFERROR((F7-E7+1),\"\")","v":14},14,"2014-11-25",{"$f":"IF(ДНИОТП(I7,H7,$M$5:$M$19)<=0,\"\",ДНИОТП(I7,H7,$M$5:$M$19))","v":"2014-12-08"},{"$f":"IFERROR((J7-I7+1),\"\")","v":14},null,"2014-01-03"]
[{"$f":"IF(ISBLANK(C8),\"\",COUNTA($C$6:C8))","v":3},"ДИП","Волков",14,"2014-03-03",{"$f":"IF(ДНИОТП(E8,D8,$M$5:$M$19)<=0,\"\",ДНИОТП(E8,D8,$M$5:$M$19))","v":"2014-03-17"},{"$f":"IFERROR((F8-E8+1),\"\")","v":15},14,"2014-08-26",{"$f":"IF(ДНИОТП(I8,H8,$M$5:$M$19)<=0,\"\",ДНИОТП(I8,H8,$M$5:$M$19))","v":"2014-09-08"},{"$f":"IFERROR((J8-I8+1),\"\")","v":14},null,"2014-01-04"]
[{"$f":"IF(ISBLANK(C9),\"\",COUNTA($C$6:C9))","v":4},"Инженер","Городной",null,null,{"$f":"IF(ДНИОТП(E9,D9,$M$5:$M$19)<=0,\"\",ДНИОТП(E9,D9,$M$5:$M$19))","v":""},{"$f":"IFERROR((F9-E9+1),\"\")","v":""},28,"2014-10-13",{"$f":"IF(ДНИОТП(I9,H9,$M$5:$M$19)<=0,\"\",ДНИОТП(I9,H9,$M$5:$M$19))","v":"2014-11-10"},{"$f":"IFERROR((J9-I9+1),\"\")","v":29},null,"2014-01-05"]
[{"$f":"IF(ISBLANK(C10),\"\",COUNTA($C$6:C10))","v":5},"Слнсарб","Дорохов",14,"2014-04-08",{"$f":"IF(ДНИОТП(E10,D10,$M$5:$M$19)<=0,\"\",ДНИОТП(E10,D10,$M$5:$M$19))","v":"2014-04-21"},{"$f":"IFERROR((F10-E10+1),\"\")","v":14},14,"2014-09-01",{"$f":"IF(ДНИОТП(I10,H10,$M$5:$M$19)<=0,\"\",ДНИОТП(I10,H10,$M$5:$M$19))","v":"2014-09-14"},{"$f":"IFERROR((J10-I10+1),\"\")","v":14},null,"2014-01-06"]
[{"$f":"IF(ISBLANK(C11),\"\",COUNTA($C$6:C11))","v":6},"Инженер","Завардин",14,"2014-02-11",{"$f":"IF(ДНИОТП(E11,D11,$M$5:$M$19)<=0,\"\",ДНИОТП(E11,D11,$M$5:$M$19))","v":"2014-02-25"},{"$f":"IFERROR((F11-E11+1),\"\")","v":15},14,"2014-10-30",{"$f":"IF(ДНИОТП(I11,H11,$M$5:$M$19)<=0,\"\",ДНИОТП(I11,H11,$M$5:$M$19))","v":"2014-11-13"},{"$f":"IFERROR((J11-I11+1),\"\")","v":15},null,"2014-01-07"]
[{"$f":"IF(ISBLANK(C12),\"\",COUNTA($C$6:C12))","v":7},"Бухгалтер","Зубенина",14,"2014-02-11",{"$f":"IF(ДНИОТП(E12,D12,$M$5:$M$19)<=0,\"\",ДНИОТП(E12,D12,$M$5:$M$19))","v":"2014-02-25"},{"$f":"IFERROR((F12-E12+1),\"\")","v":15},14,"2014-09-03",{"$f":"IF(ДНИОТП(I12,H12,$M$5:$M$19)<=0,\"\",ДНИОТП(I12,H12,$M$5:$M$19))","v":"2014-09-16"},{"$f":"IFERROR((J12-I12+1),\"\")","v":14},null,"2014-01-08"]
[{"$f":"IF(ISBLANK(C13),\"\",COUNTA($C$6:C13))","v":8},"Мастер","Иванов",14,"2014-01-09",{"$f":"IF(ДНИОТП(E13,D13,$M$5:$M$19)<=0,\"\",ДНИОТП(E13,D13,$M$5:$M$19))","v":"2014-01-22"},{"$f":"IFERROR((F13-E13+1),\"\")","v":14},14,"2014-07-01",{"$f":"IF(ДНИОТП(I13,H13,$M$5:$M$19)<=0,\"\",ДНИОТП(I13,H13,$M$5:$M$19))","v":"2014-07-14"},{"$f":"IFERROR((J13-I13+1),\"\")","v":14},null,"2014-02-23"]
[{"$f":"IF(ISBLANK(C14),\"\",COUNTA($C$6:C14))","v":9},"ДИП","Кузнецов",14,"2014-04-01",{"$f":"IF(ДНИОТП(E14,D14,$M$5:$M$19)<=0,\"\",ДНИОТП(E14,D14,$M$5:$M$19))","v":"2014-04-14"},{"$f":"IFERROR((F14-E14+1),\"\")","v":14},14,"2014-07-07",{"$f":"IF(ДНИОТП(I14,H14,$M$5:$M$19)<=0,\"\",ДНИОТП(I14,H14,$M$5:$M$19))","v":"2014-07-20"},{"$f":"IFERROR((J14-I14+1),\"\")","v":14},null,"2014-03-08"]
[{"$f":"IF(ISBLANK(C15),\"\",COUNTA($C$6:C15))","v":10},"Водитель","Пасечный",14,"2014-01-07",{"$f":"IF(ДНИОТП(E15,D15,$M$5:$M$19)<=0,\"\",ДНИОТП(E15,D15,$M$5:$M$19))","v":"2014-01-21"},{"$f":"IFERROR((F15-E15+1),\"\")","v":15},14,"2014-09-16",{"$f":"IF(ДНИОТП(I15,H15,$M$5:$M$19)<=0,\"\",ДНИОТП(I15,H15,$M$5:$M$19))","v":"2014-09-29"},{"$f":"IFERROR((J15-I15+1),\"\")","v":14},null,"2014-05-01"]
[{"$f":"IF(ISBLANK(C16),\"\",COUNTA($C$6:C16))","v":11},"Инж. прог.","Петров",14,"2014-01-01",{"$f":"IF(ДНИОТП(E16,D16,$M$5:$M$19)<=0,\"\",ДНИОТП(E16,D16,$M$5:$M$19))","v":"2014-01-21"},{"$f":"IFERROR((F16-E16+1),\"\")","v":21},14,"2014-10-01",{"$f":"IF(ДНИОТП(I16,H16,$M$5:$M$19)<=0,\"\",ДНИОТП(I16,H16,$M$5:$M$19))","v":"2014-10-14"},{"$f":"IFERROR((J16-I16+1),\"\")","v":14},null,"2014-05-02"]
[{"$f":"IF(ISBLANK(C17),\"\",COUNTA($C$6:C17))","v":12},"Уборщица","Прилепская",14,"2014-04-03",{"$f":"IF(ДНИОТП(E17,D17,$M$5:$M$19)<=0,\"\",ДНИОТП(E17,D17,$M$5:$M$19))","v":"2014-04-16"},{"$f":"IFERROR((F17-E17+1),\"\")","v":14},14,"2014-11-03",{"$f":"IF(ДНИОТП(I17,H17,$M$5:$M$19)<=0,\"\",ДНИОТП(I17,H17,$M$5:$M$19))","v":"2014-11-17"},{"$f":"IFERROR((J17-I17+1),\"\")","v":15},null,"2014-05-09"]
[{"$f":"IF(ISBLANK(C18),\"\",COUNTA($C$6:C18))","v":13},"Секреиаоь","Савушкина",14,"2014-02-04",{"$f":"IF(ДНИОТП(E18,D18,$M$5:$M$19)<=0,\"\",ДНИОТП(E18,D18,$M$5:$M$19))","v":"2014-02-17"},{"$f":"IFERROR((F18-E18+1),\"\")","v":14},14,"2014-08-11",{"$f":"IF(ДНИОТП(I18,H18,$M$5:$M$19)<=0,\"\",ДНИОТП(I18,H18,$M$5:$M$19))","v":"2014-08-24"},{"$f":"IFERROR((J18-I18+1),\"\")","v":14},null,"2014-06-12"]
[{"$f":"IF(ISBLANK(C19),\"\",COUNTA($C$6:C19))","v":14},"Инженер","Сидоров",14,"2014-05-01",{"$f":"IF(ДНИОТП(E19,D19,$M$5:$M$19)<=0,\"\",ДНИОТП(E19,D19,$M$5:$M$19))","v":"2014-05-16"},{"$f":"IFERROR((F19-E19+1),\"\")","v":16},14,"2014-08-01",{"$f":"IF(ДНИОТП(I19,H19,$M$5:$M$19)<=0,\"\",ДНИОТП(I19,H19,$M$5:$M$19))","v":"2014-08-14"},{"$f":"IFERROR((J19-I19+1),\"\")","v":14},null,"2014-11-04"]
[{"$f":"IF(ISBLANK(C20),\"\",COUNTA($C$6:C20))","v":15},"Инженер","Смирнов",28,"2014-02-15",{"$f":"IF(ДНИОТП(E20,D20,$M$5:$M$19)<=0,\"\",ДНИОТП(E20,D20,$M$5:$M$19))","v":"2014-03-16"},{"$f":"IFERROR((F20-E20+1),\"\")","v":30},null,null,{"$f":"IF(ДНИОТП(I20,H20,$M$5:$M$19)<=0,\"\",ДНИОТП(I20,H20,$M$5:$M$19))","v":""},{"$f":"IFERROR((J20-I20+1),\"\")","v":""}]
[{"$f":"IF(ISBLANK(C21),\"\",COUNTA($C$6:C21))","v":16},"Слесарь","Смирнов",null,null,{"$f":"IF(ДНИОТП(E21,D21,$M$5:$M$19)<=0,\"\",ДНИОТП(E21,D21,$M$5:$M$19))","v":""},{"$f":"IFERROR((F21-E21+1),\"\")","v":""},28,"2014-10-15",{"$f":"IF(ДНИОТП(I21,H21,$M$5:$M$19)<=0,\"\",ДНИОТП(I21,H21,$M$5:$M$19))","v":"2014-11-12"},{"$f":"IFERROR((J21-I21+1),\"\")","v":29}]
[{"$f":"IF(ISBLANK(C22),\"\",COUNTA($C$6:C22))","v":17},"Водитель","Тараканов",28,"2014-03-01",{"$f":"IF(ДНИОТП(E22,D22,$M$5:$M$19)<=0,\"\",ДНИОТП(E22,D22,$M$5:$M$19))","v":"2014-03-29"},{"$f":"IFERROR((F22-E22+1),\"\")","v":29},null,null,{"$f":"IF(ДНИОТП(I22,H22,$M$5:$M$19)<=0,\"\",ДНИОТП(I22,H22,$M$5:$M$19))","v":""},{"$f":"IFERROR((J22-I22+1),\"\")","v":""}]
[{"$f":"IF(ISBLANK(C23),\"\",COUNTA($C$6:C23))","v":18},"Столяр","Терехин",14,"2014-02-17",{"$f":"IF(ДНИОТП(E23,D23,$M$5:$M$19)<=0,\"\",ДНИОТП(E23,D23,$M$5:$M$19))","v":"2014-03-03"},{"$f":"IFERROR((F23-E23+1),\"\")","v":15},14,"2014-10-14",{"$f":"IF(ДНИОТП(I23,H23,$M$5:$M$19)<=0,\"\",ДНИОТП(I23,H23,$M$5:$M$19))","v":"2014-10-27"},{"$f":"IFERROR((J23-I23+1),\"\")","v":14}]
[{"$f":"IF(ISBLANK(C24),\"\",COUNTA($C$6:C24))","v":19},"Бригадир","Ушаков",null,null,{"$f":"IF(ДНИОТП(E24,D24,$M$5:$M$19)<=0,\"\",ДНИОТП(E24,D24,$M$5:$M$19))","v":""},{"$f":"IFERROR((F24-E24+1),\"\")","v":""},28,"2014-07-25",{"$f":"IF(ДНИОТП(I24,H24,$M$5:$M$19)<=0,\"\",ДНИОТП(I24,H24,$M$5:$M$19))","v":"2014-08-21"},{"$f":"IFERROR((J24-I24+1),\"\")","v":28}]
[{"$f":"IF(ISBLANK(C25),\"\",COUNTA($C$6:C25))","v":20},"Инженер","Хохлов",14,"2014-03-01",{"$f":"IF(ДНИОТП(E25,D25,$M$5:$M$19)<=0,\"\",ДНИОТП(E25,D25,$M$5:$M$19))","v":"2014-03-15"},{"$f":"IFERROR((F25-E25+1),\"\")","v":15},14,"2014-11-28",{"$f":"IF(ДНИОТП(I25,H25,$M$5:$M$19)<=0,\"\",ДНИОТП(I25,H25,$M$5:$M$19))","v":"2014-12-11"},{"$f":"IFERROR((J25-I25+1),\"\")","v":14}]

{"sheet":"Лист1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}