{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Эл. вид","Люди"],"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":"Эл. вид","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[19,2,20,2],[21,2,22,2],[21,1,22,1],[19,1,20,1],[11,2,12,2],[13,2,14,2],[15,2,16,2],[17,2,18,2],[13,1,14,1],[15,1,16,1],[17,1,18,1],[11,1,12,1],[1,2,2,2],[3,2,4,2],[5,2,6,2],[7,2,8,2],[9,2,10,2],[1,1,2,1],[3,1,4,1],[5,1,6,1],[15,0,16,0],[17,0,18,0],[7,1,8,1],[9,1,10,1],[19,0,20,0],[21,0,22,0],[11,0,12,0],[13,0,14,0],[1,0,2,0],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0]]}
["Дата: 22.06.2013"]
[null,"Чел 3","Чел 18"]
[]
[null,"Чел 9","Чел 16"]
[]
[null,"Чел 4","Чел 17"]
[]
[null,"Чел 7"]

{"sheet":"Люди","index":1,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Все вместе",null,"Дата 1","Дата 2","В отуске","Информация"]
[null,"-----------","-----------","Отпускники",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I2),\"\",ROW(I2)-ROW($I$2)+1)","v":1},null,1,"Чел 1",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I2),COUNTIF('Эл. вид'!$B$2:$B$23,I2)),\"\",ROW(I2)-ROW($I$2)+1)","v":1},"07.07.2013","04.09.2013",{"$f":" IF( (K2-TODAY())*(L2-TODAY()) <= 0,I2,  \"\" )","v":""},{"$f":"M2 & IF(M2=\"\",\"\",\"    с  \" & K2 & \"  по  \" &L2)","v":""},1,{"$f":"IF(COUNTIF($M$2:$M$11,N2),\"\",ROW(N2)-ROW($N$2)+1)","v":""}]
[1,{"$f":"IF(H2>COUNT($J$2:$J$11),\"\",INDEX($I$2:$I$11,SMALL($J$2:$J$11,ROW(I2)-ROW(I$1))))","v":"Чел 1"},{"$f":"IF(H13>COUNT($J$13:$J$22),\"\",INDEX($I$13:$I$22,SMALL($J$13:$J$22,ROW(I13)-ROW(I$12))))","v":"Чел 11"},{"$f":"IF(O2>COUNT($P$2:$P$22),\"\",INDEX($N$2:$N$22,SMALL($P$2:$P$22,ROW(N2)-ROW(N$1))))","v":"Чел 5    с  01.06.2013  по  03.07.2013"},null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I3),\"\",ROW(I3)-ROW($I$2)+1)","v":2},null,2,"Чел 2",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I3),COUNTIF('Эл. вид'!$B$2:$B$23,I3)),\"\",ROW(I3)-ROW($I$2)+1)","v":2},"01.04.2013","05.06.2013","","",2,{"$f":"IF(COUNTIF($M$2:$M$11,N3),\"\",ROW(N3)-ROW($N$2)+1)","v":""}]
[2,{"$f":"IF(H3>COUNT($J$2:$J$11),\"\",INDEX($I$2:$I$11,SMALL($J$2:$J$11,ROW(I3)-ROW(I$1))))","v":"Чел 2"},{"$f":"IF(H14>COUNT($J$13:$J$22),\"\",INDEX($I$13:$I$22,SMALL($J$13:$J$22,ROW(I14)-ROW(I$12))))","v":"Чел 14"},"Чел 10    с  01.06.2013  по  03.07.2013",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I4),\"\",ROW(I4)-ROW($I$2)+1)","v":""},null,3,"Чел 3",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I4),COUNTIF('Эл. вид'!$B$2:$B$23,I4)),\"\",ROW(I4)-ROW($I$2)+1)","v":""},"11.11.2013","12.12.2013","","",3,""]
[3,"Чел 6","Чел 15","Чел 12    с  03.06.2013  по  04.07.2013",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I5),\"\",ROW(I5)-ROW($I$2)+1)","v":""},null,4,"Чел 4",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I5),COUNTIF('Эл. вид'!$B$2:$B$23,I5)),\"\",ROW(I5)-ROW($I$2)+1)","v":""},"01.08.2013","01.09.2013","","",4,""]
[4,"Чел 8","Чел 19","Чел 13    с  03.06.2013  по  04.07.2013",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I6),\"\",ROW(I6)-ROW($I$2)+1)","v":5},null,5,"Чел 5",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I6),COUNTIF('Эл. вид'!$B$2:$B$23,I6)),\"\",ROW(I6)-ROW($I$2)+1)","v":""},"01.06.2013","03.07.2013","Чел 5","Чел 5    с  01.06.2013  по  03.07.2013",5,5]
[5,"","","Чел 20    с  03.06.2013  по  04.07.2013",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I7),\"\",ROW(I7)-ROW($I$2)+1)","v":6},null,6,"Чел 6",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I7),COUNTIF('Эл. вид'!$B$2:$B$23,I7)),\"\",ROW(I7)-ROW($I$2)+1)","v":6},"23.06.2013","24.07.2013","","",6,""]
[6,"","","",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I8),\"\",ROW(I8)-ROW($I$2)+1)","v":""},null,7,"Чел 7",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I8),COUNTIF('Эл. вид'!$B$2:$B$23,I8)),\"\",ROW(I8)-ROW($I$2)+1)","v":""},"09.12.2013","17.01.2014","","",7,""]
[7,"","","",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I9),\"\",ROW(I9)-ROW($I$2)+1)","v":8},null,8,"Чел 8",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I9),COUNTIF('Эл. вид'!$B$2:$B$23,I9)),\"\",ROW(I9)-ROW($I$2)+1)","v":8},"12.08.2013","20.09.2013","","",8,""]
[8,"","","",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I10),\"\",ROW(I10)-ROW($I$2)+1)","v":""},null,9,"Чел 9",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I10),COUNTIF('Эл. вид'!$B$2:$B$23,I10)),\"\",ROW(I10)-ROW($I$2)+1)","v":""},null,null,"","",9,""]
[9,"","","",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I11),\"\",ROW(I11)-ROW($I$2)+1)","v":10},null,10,"Чел 10",{"$f":"IF(OR(COUNTIF($M$2:$M$11,I11),COUNTIF('Эл. вид'!$B$2:$B$23,I11)),\"\",ROW(I11)-ROW($I$2)+1)","v":""},"01.06.2013","03.07.2013","Чел 10","Чел 10    с  01.06.2013  по  03.07.2013",10,10]
[10,"","","",null,{"$f":"IF(COUNTIF('Эл. вид'!$B$2:$B$23,I12),\"\",ROW(I12)-ROW($I$2)+1)","v":11},null,null,null,{"$f":"IF(OR(COUNTIF($M$2:$M$11,I12),COUNTIF('Эл. вид'!$B$2:$B$23,I12)),\"\",ROW(I12)-ROW($I$2)+1)","v":11},null,null,null,"",11,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C2:C23,I13),\"\",ROW(I13)-ROW($I$2)+1)","v":12},null,1,"Чел 11",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I13),COUNTIF('Эл. вид'!$C$2:$C$23,I13)),\"\",ROW(I13)-ROW($I$13)+1)","v":1},"30.09.2013","29.10.2013",{"$f":" IF( (K13-TODAY())*(L13-TODAY()) <= 0,I13,  \"\" )","v":""},"",12,""]
[null,null,null,{"$f":"IF(COUNTIF($M$13:$M$22,I13),\"\",ROW(I13)-ROW($I$13)+1)","v":1},null,{"$f":"IF(COUNTIF('Эл. вид'!C3:C24,I14),\"\",ROW(I14)-ROW($I$2)+1)","v":13},null,2,"Чел 12",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I14),COUNTIF('Эл. вид'!$C$2:$C$23,I14)),\"\",ROW(I14)-ROW($I$13)+1)","v":""},"03.06.2013","04.07.2013","Чел 12","Чел 12    с  03.06.2013  по  04.07.2013",13,13]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C4:C24,I15),\"\",ROW(I15)-ROW($I$2)+1)","v":14},null,3,"Чел 13",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I15),COUNTIF('Эл. вид'!$C$2:$C$23,I15)),\"\",ROW(I15)-ROW($I$13)+1)","v":""},"03.06.2013","04.07.2013","Чел 13","Чел 13    с  03.06.2013  по  04.07.2013",14,14]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C5:C24,I16),\"\",ROW(I16)-ROW($I$2)+1)","v":15},null,4,"Чел 14",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I16),COUNTIF('Эл. вид'!$C$2:$C$23,I16)),\"\",ROW(I16)-ROW($I$13)+1)","v":4},"08.07.2013","16.08.2013",{"$f":" IF( (K16-TODAY())*(L16-TODAY()) <= 0,I16,  \"\" )","v":""},"",15,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C6:C24,I17),\"\",ROW(I17)-ROW($I$2)+1)","v":16},null,5,"Чел 15",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I17),COUNTIF('Эл. вид'!$C$2:$C$23,I17)),\"\",ROW(I17)-ROW($I$13)+1)","v":5},"08.07.2013","16.08.2013","","",16,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C7:C25,I18),\"\",ROW(I18)-ROW($I$2)+1)","v":17},null,6,"Чел 16",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I18),COUNTIF('Эл. вид'!$C$2:$C$23,I18)),\"\",ROW(I18)-ROW($I$13)+1)","v":""},"08.07.2013","16.08.2013","","",17,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C8:C26,I19),\"\",ROW(I19)-ROW($I$2)+1)","v":18},null,7,"Чел 17",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I19),COUNTIF('Эл. вид'!$C$2:$C$23,I19)),\"\",ROW(I19)-ROW($I$13)+1)","v":""},"08.07.2013","16.08.2013","","",18,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C9:C27,I20),\"\",ROW(I20)-ROW($I$2)+1)","v":19},null,8,"Чел 18",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I20),COUNTIF('Эл. вид'!$C$2:$C$23,I20)),\"\",ROW(I20)-ROW($I$13)+1)","v":""},"01.05.2013","13.06.2013","","",19,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C10:C28,I21),\"\",ROW(I21)-ROW($I$2)+1)","v":20},null,9,"Чел 19",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I21),COUNTIF('Эл. вид'!$C$2:$C$23,I21)),\"\",ROW(I21)-ROW($I$13)+1)","v":9},"24.06.2013","12.08.2013",{"$f":" IF( (K21-TODAY())*(L21-TODAY()) <= 0,I21,  \"\" )","v":""},"",20,""]
[null,null,null,null,null,{"$f":"IF(COUNTIF('Эл. вид'!C11:C29,I22),\"\",ROW(I22)-ROW($I$2)+1)","v":21},null,10,"Чел 20",{"$f":"IF(OR(COUNTIF($M$13:$M$22,I22),COUNTIF('Эл. вид'!$C$2:$C$23,I22)),\"\",ROW(I22)-ROW($I$13)+1)","v":""},"03.06.2013","04.07.2013","Чел 20","Чел 20    с  03.06.2013  по  04.07.2013",21,21]