{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["27"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":5,"defined_names":24,"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":"27","index":0,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,3,1,10],[3,1,4,1],[3,2,4,2],[3,3,3,6],[3,7,3,10],[3,11,4,11]]}
[]
[null,null,null,"Планирование отпусков на 2015г"]
[]
[null,"Должность","Ф.И.О.","Отпуск по плану 1 ч.",null,null,null,"Отпуск по плану 2 ч.",null,null,null,"Остаток дней "]
["№",null,null,"Дней отп.","Начало","Окончание","Всего дней","Дней отп.","Начало","Окончание","Всего дней"]
[{"$f":"IF(ISBLANK(C6),\"\",COUNTA($C$6:C6))","v":1},{"$f":"'[1]1'!C7","v":"Должн 1"},{"$f":"'[1]1'!B7","v":"Сотрудник 1"},10,"2015-01-07",{"$f":"IF(ДНИОТП(E6,D6,$M$7:$M$21)<=0,\"\",ДНИОТП(E6,D6,$M$7:$M$21))","v":"2015-01-17"},{"$f":"IFERROR((F6-E6+1),\"\")","v":11},{"$f":"L6-D6","v":16},"2015-07-01",{"$f":"IF(ДНИОТП(I6,H6,$M$7:$M$21)<=0,\"\",ДНИОТП(I6,H6,$M$7:$M$21))","v":"2015-07-16"},{"$f":"IFERROR((J6-I6+1),\"\")","v":16},{"$f":"'[1]1'!E7","v":26},"Праздники"]
[{"$f":"IF(ISBLANK(C7),\"\",COUNTA($C$6:C7))","v":2},{"$f":"'[1]1'!C8","v":"Должн 2"},{"$f":"'[1]1'!B8","v":"Сотрудник 2"},10,"2015-01-08",{"$f":"IF(ДНИОТП(E7,D7,$M$7:$M$21)<=0,\"\",ДНИОТП(E7,D7,$M$7:$M$21))","v":"2015-01-17"},{"$f":"IFERROR((F7-E7+1),\"\")","v":10},17,"2015-07-14",{"$f":"IF(ДНИОТП(I7,H7,$M$7:$M$21)<=0,\"\",ДНИОТП(I7,H7,$M$7:$M$21))","v":"2015-07-30"},{"$f":"IFERROR((J7-I7+1),\"\")","v":17},{"$f":"'[1]1'!E8","v":27},"2015-01-01"]
[{"$f":"IF(ISBLANK(C8),\"\",COUNTA($C$6:C8))","v":3},{"$f":"'[1]1'!C9","v":"Должн 3"},{"$f":"'[1]1'!B9","v":"Сотрудник 3"},10,"2015-01-09",{"$f":"IF(ДНИОТП(E8,D8,$M$7:$M$21)<=0,\"\",ДНИОТП(E8,D8,$M$7:$M$21))","v":"2015-01-18"},10,15,"2015-07-15",{"$f":"IF(ДНИОТП(I8,H8,$M$7:$M$21)<=0,\"\",ДНИОТП(I8,H8,$M$7:$M$21))","v":"2015-07-29"},15,{"$f":"'[1]1'!E9","v":25},"2015-01-02"]
[{"$f":"IF(ISBLANK(C9),\"\",COUNTA($C$6:C9))","v":4},{"$f":"'[1]1'!C10","v":"Должн 4"},{"$f":"'[1]1'!B10","v":"Сотрудник 4"},10,"2015-01-10",{"$f":"IF(ДНИОТП(E9,D9,$M$7:$M$21)<=0,\"\",ДНИОТП(E9,D9,$M$7:$M$21))","v":"2015-01-19"},10,12,"2015-07-16",{"$f":"IF(ДНИОТП(I9,H9,$M$7:$M$21)<=0,\"\",ДНИОТП(I9,H9,$M$7:$M$21))","v":"2015-07-27"},12,{"$f":"'[1]1'!E10","v":22},"2015-01-03"]
[{"$f":"IF(ISBLANK(C10),\"\",COUNTA($C$6:C10))","v":5},{"$f":"'[1]1'!C11","v":"Должн 5"},{"$f":"'[1]1'!B11","v":"Сотрудник 5"},10,"2015-01-11",{"$f":"IF(ДНИОТП(E10,D10,$M$7:$M$21)<=0,\"\",ДНИОТП(E10,D10,$M$7:$M$21))","v":"2015-01-20"},10,8,"2015-07-17",{"$f":"IF(ДНИОТП(I10,H10,$M$7:$M$21)<=0,\"\",ДНИОТП(I10,H10,$M$7:$M$21))","v":"2015-07-24"},8,{"$f":"'[1]1'!E11","v":18},"2015-01-04"]
[{"$f":"IF(ISBLANK(C11),\"\",COUNTA($C$6:C11))","v":6},{"$f":"'[1]1'!C12","v":"Должн 6"},{"$f":"'[1]1'!B12","v":"Сотрудник 6"},10,"2015-01-12",{"$f":"IF(ДНИОТП(E11,D11,$M$7:$M$21)<=0,\"\",ДНИОТП(E11,D11,$M$7:$M$21))","v":"2015-01-21"},10,7,"2015-07-18",{"$f":"IF(ДНИОТП(I11,H11,$M$7:$M$21)<=0,\"\",ДНИОТП(I11,H11,$M$7:$M$21))","v":"2015-07-24"},7,{"$f":"'[1]1'!E12","v":17},"2015-01-05"]
[{"$f":"IF(ISBLANK(C12),\"\",COUNTA($C$6:C12))","v":7},{"$f":"'[1]1'!C13","v":"Должн 7"},{"$f":"'[1]1'!B13","v":"Сотрудник 7"},10,"2015-01-13",{"$f":"IF(ДНИОТП(E12,D12,$M$7:$M$21)<=0,\"\",ДНИОТП(E12,D12,$M$7:$M$21))","v":"2015-01-22"},10,6,"2015-07-19",{"$f":"IF(ДНИОТП(I12,H12,$M$7:$M$21)<=0,\"\",ДНИОТП(I12,H12,$M$7:$M$21))","v":"2015-07-24"},6,{"$f":"'[1]1'!E13","v":16},"2015-01-06"]
[{"$f":"IF(ISBLANK(C13),\"\",COUNTA($C$6:C13))","v":8},{"$f":"'[1]1'!C14","v":"Должн 8"},{"$f":"'[1]1'!B14","v":"Сотрудник 8"},10,"2015-01-14",{"$f":"IF(ДНИОТП(E13,D13,$M$7:$M$21)<=0,\"\",ДНИОТП(E13,D13,$M$7:$M$21))","v":"2015-01-23"},10,4,"2015-07-20",{"$f":"IF(ДНИОТП(I13,H13,$M$7:$M$21)<=0,\"\",ДНИОТП(I13,H13,$M$7:$M$21))","v":"2015-07-23"},4,{"$f":"'[1]1'!E14","v":14},"2015-01-07"]
[{"$f":"IF(ISBLANK(C14),\"\",COUNTA($C$6:C14))","v":9},{"$f":"'[1]1'!C15","v":"Должн 9"},{"$f":"'[1]1'!B15","v":"Сотрудник 9"},10,"2015-01-15",{"$f":"IF(ДНИОТП(E14,D14,$M$7:$M$21)<=0,\"\",ДНИОТП(E14,D14,$M$7:$M$21))","v":"2015-01-24"},10,2,"2015-07-21",{"$f":"IF(ДНИОТП(I14,H14,$M$7:$M$21)<=0,\"\",ДНИОТП(I14,H14,$M$7:$M$21))","v":"2015-07-22"},2,{"$f":"'[1]1'!E15","v":12},"2015-01-08"]
[{"$f":"IF(ISBLANK(C15),\"\",COUNTA($C$6:C15))","v":10},{"$f":"'[1]1'!C16","v":"Должн 10"},{"$f":"'[1]1'!B16","v":"Сотрудник 10"},10,"2015-01-16",{"$f":"IF(ДНИОТП(E15,D15,$M$7:$M$21)<=0,\"\",ДНИОТП(E15,D15,$M$7:$M$21))","v":"2015-01-25"},10,3,"2015-07-22",{"$f":"IF(ДНИОТП(I15,H15,$M$7:$M$21)<=0,\"\",ДНИОТП(I15,H15,$M$7:$M$21))","v":"2015-07-24"},3,{"$f":"'[1]1'!E16","v":13},"2015-02-23"]
[{"$f":"IF(ISBLANK(C16),\"\",COUNTA($C$6:C16))","v":11},{"$f":"'[1]1'!C17","v":"Должн 11"},{"$f":"'[1]1'!B17","v":"Сотрудник 11"},10,"2015-01-17",{"$f":"IF(ДНИОТП(E16,D16,$M$7:$M$21)<=0,\"\",ДНИОТП(E16,D16,$M$7:$M$21))","v":"2015-01-26"},10,12,"2015-07-23",{"$f":"IF(ДНИОТП(I16,H16,$M$7:$M$21)<=0,\"\",ДНИОТП(I16,H16,$M$7:$M$21))","v":"2015-08-03"},12,{"$f":"'[1]1'!E17","v":22},"2015-03-08"]
[{"$f":"IF(ISBLANK(C17),\"\",COUNTA($C$6:C17))","v":12},{"$f":"'[1]1'!C18","v":"Должн 12"},{"$f":"'[1]1'!B18","v":"Сотрудник 12"},10,"2015-01-18",{"$f":"IF(ДНИОТП(E17,D17,$M$7:$M$21)<=0,\"\",ДНИОТП(E17,D17,$M$7:$M$21))","v":"2015-01-27"},10,5,"2015-07-24",{"$f":"IF(ДНИОТП(I17,H17,$M$7:$M$21)<=0,\"\",ДНИОТП(I17,H17,$M$7:$M$21))","v":"2015-07-28"},5,{"$f":"'[1]1'!E18","v":15},"2015-05-01"]
[{"$f":"IF(ISBLANK(C18),\"\",COUNTA($C$6:C18))","v":13},{"$f":"'[1]1'!C19","v":"Должн 13"},{"$f":"'[1]1'!B19","v":"Сотрудник 13"},10,"2015-01-19",{"$f":"IF(ДНИОТП(E18,D18,$M$7:$M$21)<=0,\"\",ДНИОТП(E18,D18,$M$7:$M$21))","v":"2015-01-28"},10,7,"2015-07-25",{"$f":"IF(ДНИОТП(I18,H18,$M$7:$M$21)<=0,\"\",ДНИОТП(I18,H18,$M$7:$M$21))","v":"2015-07-31"},7,{"$f":"'[1]1'!E19","v":17},"2015-05-09"]
[{"$f":"IF(ISBLANK(C19),\"\",COUNTA($C$6:C19))","v":14},{"$f":"'[1]1'!C20","v":"Должн 14"},{"$f":"'[1]1'!B20","v":"Сотрудник 14"},10,"2015-01-20",{"$f":"IF(ДНИОТП(E19,D19,$M$7:$M$21)<=0,\"\",ДНИОТП(E19,D19,$M$7:$M$21))","v":"2015-01-29"},10,8,"2015-07-26",{"$f":"IF(ДНИОТП(I19,H19,$M$7:$M$21)<=0,\"\",ДНИОТП(I19,H19,$M$7:$M$21))","v":"2015-08-02"},8,{"$f":"'[1]1'!E20","v":18},"2014-06-12"]
[{"$f":"IF(ISBLANK(C20),\"\",COUNTA($C$6:C20))","v":15},{"$f":"'[1]1'!C21","v":"Должн 15"},{"$f":"'[1]1'!B21","v":"Сотрудник 15"},10,"2015-01-21",{"$f":"IF(ДНИОТП(E20,D20,$M$7:$M$21)<=0,\"\",ДНИОТП(E20,D20,$M$7:$M$21))","v":"2015-01-30"},10,11,"2015-07-27",{"$f":"IF(ДНИОТП(I20,H20,$M$7:$M$21)<=0,\"\",ДНИОТП(I20,H20,$M$7:$M$21))","v":"2015-08-06"},11,{"$f":"'[1]1'!E21","v":21},"2014-11-04"]
[{"$f":"IF(ISBLANK(C21),\"\",COUNTA($C$6:C21))","v":16},{"$f":"'[1]1'!C22","v":"Должн 16"},{"$f":"'[1]1'!B22","v":"Сотрудник 16"},10,"2015-01-22",{"$f":"IF(ДНИОТП(E21,D21,$M$7:$M$21)<=0,\"\",ДНИОТП(E21,D21,$M$7:$M$21))","v":"2015-01-31"},10,8,"2015-07-28",{"$f":"IF(ДНИОТП(I21,H21,$M$7:$M$21)<=0,\"\",ДНИОТП(I21,H21,$M$7:$M$21))","v":"2015-08-04"},8,{"$f":"'[1]1'!E22","v":18}]
[{"$f":"IF(ISBLANK(C22),\"\",COUNTA($C$6:C22))","v":17},{"$f":"'[1]1'!C23","v":"Должн 17"},{"$f":"'[1]1'!B23","v":"Сотрудник 17"},10,"2015-01-23",{"$f":"IF(ДНИОТП(E22,D22,$M$7:$M$21)<=0,\"\",ДНИОТП(E22,D22,$M$7:$M$21))","v":"2015-02-01"},10,8,"2015-07-29",{"$f":"IF(ДНИОТП(I22,H22,$M$7:$M$21)<=0,\"\",ДНИОТП(I22,H22,$M$7:$M$21))","v":"2015-08-05"},8,{"$f":"'[1]1'!E23","v":18}]
[{"$f":"IF(ISBLANK(C23),\"\",COUNTA($C$6:C23))","v":18},{"$f":"'[1]1'!C24","v":"Должн 18"},{"$f":"'[1]1'!B24","v":"Сотрудник 18"},10,"2015-01-24",{"$f":"IF(ДНИОТП(E23,D23,$M$7:$M$21)<=0,\"\",ДНИОТП(E23,D23,$M$7:$M$21))","v":"2015-02-02"},10,6,"2015-07-30",{"$f":"IF(ДНИОТП(I23,H23,$M$7:$M$21)<=0,\"\",ДНИОТП(I23,H23,$M$7:$M$21))","v":"2015-08-04"},6,{"$f":"'[1]1'!E24","v":16}]
[{"$f":"IF(ISBLANK(C24),\"\",COUNTA($C$6:C24))","v":19},{"$f":"'[1]1'!C25","v":"Должн 19"},{"$f":"'[1]1'!B25","v":"Сотрудник 19"},10,"2015-01-25",{"$f":"IF(ДНИОТП(E24,D24,$M$7:$M$21)<=0,\"\",ДНИОТП(E24,D24,$M$7:$M$21))","v":"2015-02-03"},10,8,"2015-07-31",{"$f":"IF(ДНИОТП(I24,H24,$M$7:$M$21)<=0,\"\",ДНИОТП(I24,H24,$M$7:$M$21))","v":"2015-08-07"},8,{"$f":"'[1]1'!E25","v":18}]
[{"$f":"IF(ISBLANK(C25),\"\",COUNTA($C$6:C25))","v":20},{"$f":"'[1]1'!C26","v":"Должн 20"},{"$f":"'[1]1'!B26","v":"Сотрудник 20"},10,"2015-01-26",{"$f":"IF(ДНИОТП(E25,D25,$M$7:$M$21)<=0,\"\",ДНИОТП(E25,D25,$M$7:$M$21))","v":"2015-02-04"},10,7,"2015-08-01",{"$f":"IF(ДНИОТП(I25,H25,$M$7:$M$21)<=0,\"\",ДНИОТП(I25,H25,$M$7:$M$21))","v":"2015-08-07"},7,{"$f":"'[1]1'!E26","v":17}]
[{"$f":"IF(ISBLANK(C26),\"\",COUNTA($C$6:C26))","v":21},{"$f":"'[1]1'!C27","v":"Должн 21"},{"$f":"'[1]1'!B27","v":"Сотрудник 21"},6,"2015-01-27",{"$f":"IF(ДНИОТП(E26,D26,$M$7:$M$21)<=0,\"\",ДНИОТП(E26,D26,$M$7:$M$21))","v":"2015-02-01"},6,1,"2015-08-02",{"$f":"IF(ДНИОТП(I26,H26,$M$7:$M$21)<=0,\"\",ДНИОТП(I26,H26,$M$7:$M$21))","v":"2015-08-02"},1,{"$f":"'[1]1'!E27","v":7}]
[{"$f":"IF(ISBLANK(C27),\"\",COUNTA($C$6:C27))","v":22},{"$f":"'[1]1'!C28","v":"Должн 22"},{"$f":"'[1]1'!B28","v":"Сотрудник 22"},10,"2015-01-28",{"$f":"IF(ДНИОТП(E27,D27,$M$7:$M$21)<=0,\"\",ДНИОТП(E27,D27,$M$7:$M$21))","v":"2015-02-06"},10,6,"2015-08-03",{"$f":"IF(ДНИОТП(I27,H27,$M$7:$M$21)<=0,\"\",ДНИОТП(I27,H27,$M$7:$M$21))","v":"2015-08-08"},6,{"$f":"'[1]1'!E28","v":16}]
[{"$f":"IF(ISBLANK(C28),\"\",COUNTA($C$6:C28))","v":23},{"$f":"'[1]1'!C29","v":"Должн 23"},{"$f":"'[1]1'!B29","v":"Сотрудник 23"},6,"2015-01-29",{"$f":"IF(ДНИОТП(E28,D28,$M$7:$M$21)<=0,\"\",ДНИОТП(E28,D28,$M$7:$M$21))","v":"2015-02-03"},6,-1,"2015-08-04",{"$f":"IF(ДНИОТП(I28,H28,$M$7:$M$21)<=0,\"\",ДНИОТП(I28,H28,$M$7:$M$21))","v":"2015-08-02"},-1,{"$f":"'[1]1'!E29","v":5}]
[{"$f":"IF(ISBLANK(C29),\"\",COUNTA($C$6:C29))","v":24},{"$f":"'[1]1'!C30","v":"Должн 24"},{"$f":"'[1]1'!B30","v":"Сотрудник 24"},10,"2015-01-30",{"$f":"IF(ДНИОТП(E29,D29,$M$7:$M$21)<=0,\"\",ДНИОТП(E29,D29,$M$7:$M$21))","v":"2015-02-08"},10,4,"2015-08-05",{"$f":"IF(ДНИОТП(I29,H29,$M$7:$M$21)<=0,\"\",ДНИОТП(I29,H29,$M$7:$M$21))","v":"2015-08-08"},4,{"$f":"'[1]1'!E30","v":14}]
[{"$f":"IF(ISBLANK(C30),\"\",COUNTA($C$6:C30))","v":25},{"$f":"'[1]1'!C31","v":"Должн 25"},{"$f":"'[1]1'!B31","v":"Сотрудник 25"},10,"2015-01-31",{"$f":"IF(ДНИОТП(E30,D30,$M$7:$M$21)<=0,\"\",ДНИОТП(E30,D30,$M$7:$M$21))","v":"2015-02-09"},10,4,"2015-08-06",{"$f":"IF(ДНИОТП(I30,H30,$M$7:$M$21)<=0,\"\",ДНИОТП(I30,H30,$M$7:$M$21))","v":"2015-08-09"},4,{"$f":"'[1]1'!E31","v":14}]
[]
[null,"Примечание:"]
[null,"Вводим количестыо дней для отпуска или для первой части, если отпуск разбивается."]
[null,"Вводим дату начала отпуска или первой его части, если отпуск разбивается"]
[null,"Вводим дату начала отпуска второй его части, если отпускные дни остались"]