{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Лист1","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["№   пп","Работник",null,"№","Кто есть","остался","Для списка",null,"дата1","дата2","в отпуске"]
[1,null,null,1,"Чел1",{"$f":"IF(OR(COUNTIF($B$2:$B$11,E2),COUNTIF($K$2:$K$11,E2)),\"\",ROW(E2)-ROW($E$2)+1)","v":""},{"$f":"IF(D2>COUNT($F$2:$F$11),\"\",INDEX($E$2:$E$11,SMALL($F$2:$F$11,ROW(E2)-ROW(E1))))","v":"Чел 2"},null,"10.06.2013","20.06.2013",{"$f":" IF( (I2-TODAY())*(J2-TODAY()) <= 0,E2,  \"\" )","v":"Чел1"},null,{"$f":"IF(K2=\"\",\"\",\"с  \" & I2 & \"  по  \" &J2)","v":"с  10.06.2013  по  20.06.2013"}]
[2,null,null,2,"Чел 2",{"$f":"IF(OR(COUNTIF($B$2:$B$11,E3),COUNTIF($K$2:$K$11,E3)),\"\",ROW(E3)-ROW($E$2)+1)","v":2},{"$f":"IF(D3>COUNT($F$2:$F$11),\"\",INDEX($E$2:$E$11,SMALL($F$2:$F$11,ROW(E3)-1)))","v":"Чел 4"},null,"20.08.2013","25.10.2013","",null,{"$f":"IF(K3=\"\",\"\",\"с  \" & I3 & \"  по  \" &J3)","v":""}]
[3,null,null,3,"Чел 3","","Чел 5",null,"08.05.2013","14.06.2013","Чел 3",null,{"$f":"IF(K4=\"\",\"\",\"с  \" & I4 & \"  по  \" &J4)","v":"с  08.05.2013  по  14.06.2013"}]
[4,null,null,4,"Чел 4",4,"Чел 6",null,null,null,""]
[5,null,null,5,"Чел 5",5,"Чел 7",null,null,null,""]
[6,null,null,6,"Чел 6",6,"Чел 8",null,null,null,""]
[7,null,null,7,"Чел 7",7,"Чел 9",null,null,null,""]
[8,null,null,8,"Чел 8",8,"Чел 10",null,null,null,""]
[9,null,null,9,"Чел 9",9,"",null,null,null,""]
[10,null,null,10,"Чел 10",10,"",null,null,null,""]

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