{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":41,"n_cols":23,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,14,0,22],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[9,1,9,2],[9,3,9,4],[27,0,27,2],[5,1,5,2],[5,3,5,4],[3,1,3,2],[5,5,5,6],[5,7,5,8],[5,9,5,10],[7,1,7,2],[7,3,7,4],[7,5,7,6],[7,7,7,8],[7,9,7,10],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Вспомогательные столбцы"]
[null,"G1",null,"G2",null,"G3",null,"G4",null,"G5",null,null,null,null,"G1",null,"G2",null,"G3",null,"G4",null,"G5"]
[null,"Взял","Сдал","Взял","Сдал","Взял","Сдал","Взял","Сдал","Взял","Сдал"]
[null,"Арндт Ирина ",null,"Новиков Сергей",null,"Новиков Сергей",null,"Новикова Ирина",null,"Ситдиков Рафик"]
[null,"2012-04-22","Продлён","2012-08-22","2012-11-20","2011-11-06","2012-05-22","2012-02-26","Продлён","2012-06-24","2012-08-02",null,null,null,{"$f":"IF(AND(B5=\"\",C5=\"\"),0,IF(B5=\"\",IF(AND(B3<=$C$29,C5>=$A$29),1,0),IF(C5=\"\",IF(AND(B5<=$C$29,TODAY()>=$A$29),1,0),IF(AND(C5=\"Продлён\",B7=\"\"),IF(AND(B5<=$C$29,C7>=$A$29),1,0),IF(C5=\"Продлён\",IF(AND(B5<=$C$29,B7>=$A$29),1,0),IF(AND(B5<=$C$29,C5>=$A$29),1,0))))))","v":0},null,{"$f":"IF(AND(D5=\"\",E5=\"\"),0,IF(D5=\"\",IF(AND(D3<=$C$29,E5>=$A$29),1,0),IF(E5=\"\",IF(AND(D5<=$C$29,TODAY()>=$A$29),1,0),IF(AND(E5=\"Продлён\",D7=\"\"),IF(AND(D5<=$C$29,E7>=$A$29),1,0),IF(E5=\"Продлён\",IF(AND(D5<=$C$29,D7>=$A$29),1,0),IF(AND(D5<=$C$29,E5>=$A$29),1,0))))))","v":0},null,{"$f":"IF(AND(F5=\"\",G5=\"\"),0,IF(F5=\"\",IF(AND(F3<=$C$29,G5>=$A$29),1,0),IF(G5=\"\",IF(AND(F5<=$C$29,TODAY()>=$A$29),1,0),IF(AND(G5=\"Продлён\",F7=\"\"),IF(AND(F5<=$C$29,G7>=$A$29),1,0),IF(G5=\"Продлён\",IF(AND(F5<=$C$29,F7>=$A$29),1,0),IF(AND(F5<=$C$29,G5>=$A$29),1,0))))))","v":0},null,{"$f":"IF(AND(H5=\"\",I5=\"\"),0,IF(H5=\"\",IF(AND(H3<=$C$29,I5>=$A$29),1,0),IF(I5=\"\",IF(AND(H5<=$C$29,TODAY()>=$A$29),1,0),IF(AND(I5=\"Продлён\",H7=\"\"),IF(AND(H5<=$C$29,I7>=$A$29),1,0),IF(I5=\"Продлён\",IF(AND(H5<=$C$29,H7>=$A$29),1,0),IF(AND(H5<=$C$29,I5>=$A$29),1,0))))))","v":0},null,{"$f":"IF(AND(J5=\"\",K5=\"\"),0,IF(J5=\"\",IF(AND(J3<=$C$29,K5>=$A$29),1,0),IF(K5=\"\",IF(AND(J5<=$C$29,TODAY()>=$A$29),1,0),IF(AND(K5=\"Продлён\",J7=\"\"),IF(AND(J5<=$C$29,K7>=$A$29),1,0),IF(K5=\"Продлён\",IF(AND(J5<=$C$29,J7>=$A$29),1,0),IF(AND(J5<=$C$29,K5>=$A$29),1,0))))))","v":0}]
[null,"Арндт Ирина ",null,"Арндт Катерина",null,"Вильгельм Томас",null,"Новикова Ирина",null,"Алёхин Олег"]
[null,"2012-09-01","2013-01-02","2013-01-23","2013-03-01","2012-09-30","Продлён","2012-08-19","2012-09-30","2013-01-02","2013-02-03",null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF(AND(J7=\"\",K7=\"\"),0,IF(J7=\"\",IF(AND(J5<=$C$29,K7>=$A$29),1,0),IF(K7=\"\",IF(AND(J7<=$C$29,TODAY()>=$A$29),1,0),IF(AND(K7=\"Продлён\",J9=\"\"),IF(AND(J7<=$C$29,K9>=$A$29),1,0),IF(K7=\"Продлён\",IF(AND(J7<=$C$29,J9>=$A$29),1,0),IF(AND(J7<=$C$29,K7>=$A$29),1,0))))))","v":0}]
[null,"Мошнегуца Максим",null,"Новиков Сергей",null,"Вильгельм Томас",null,"Арндт Катерина",null,"Ситдиков Рафик"]
[null,"2013-03-23","Продлён","2013-04-10","2013-05-29","2013-01-30","2013-05-05","2013-01-23","2013-05-19","2013-04-08","2013-05-26",null,null,null,0,null,0,null,0,null,0,null,0]
[null,"Мошнегуца Максим",null,"Арндт Андрей",null,null,"Вильгельм Томас",null,"Ситдиков Рафик",null,"Арндт Ирина"]
[null,"2013-07-23","2013-08-23","2013-06-30","2013-08-18","2013-07-03","2013-11-24","2013-09-05","2013-11-11","2013-08-18","2013-12-08",null,null,null,0,null,0,null,1,null,1,null,1]
[null,null,"Ситдиков Рафик",null,"Ситдиков Рафик",null,"Ситдиков Рафик",null,"Каспер Мария",null,"Арндт Катерина"]
[null,"2013-11-12","2014-02-23","2013-10-15","2013-11-12","2014-01-06","2014-02-23","2014-02-05","2014-06-08","2014-02-09","2014-06-22",null,null,null,0,null,1,null,0,null,0,null,0]
[null,null,"Мюллер Николай ",null,"Вильгельм Томас",null,"Вильгельм Раиса",null,"Кайбелева Натал.",null,"Каспер Мария"]
[null,"2014-04-04","2014-04-04","2013-11-24","Продлён","2014-04-03","2014-04-20","2014-07-02","Продлён","2014-07-13","2014-07-23",null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,"Вильгельм Томас",null,"Вильгельм Томас",null,"Вильгельм Томас",null,"Кайбелева Натал.",null,"Ситдиков Рафик"]
[null,"2014-05-14","Продлён","2014-03-24","2014-07-09","2014-07-06","2014-07-13",null,"2015-04-05","2014-08-04","2014-09-02",null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,"Вильгельм Томас",null,"Алёхин Олег",null,"Кайбелева Натал.",null,"Алёхин Олег",null,"Алёхина Ольга"]
[null,"2014-09-14","2014-11-19","2014-08-13","2014-08-24","2014-08-03","Продлён","2015-08-16",null,"2014-10-09","2014-12-28",null,null,null,0,null,0,null,0,null,0,null,0]
[null,null,"Ситдиков Рафик",null,"Короткий Михаил",null,"Кайбелева Натал.",null,null,null,"Ситдиков Рафик"]
[null,"2015-01-05","2015-03-26","2014-09-21","2015-02-08",null,"2015-03-29",null,null,"2015-03-09","Продлён",null,null,null,{"$f":"IF(AND(B21=\"\",C21=\"\"),0,IF(B21=\"\",IF(AND(B19<=$C$29,C21>=$A$29),1,0),IF(C21=\"\",IF(AND(B21<=$C$29,TODAY()>=$A$29),1,0),IF(AND(C21=\"Продлён\",B23=\"\"),IF(AND(B21<=$C$29,C23>=$A$29),1,0),IF(C21=\"Продлён\",IF(AND(B21<=$C$29,B23>=$A$29),1,0),IF(AND(B21<=$C$29,C21>=$A$29),1,0))))))","v":0},null,0,null,0,null,0,null,{"$f":"IF(AND(J21=\"\",K21=\"\"),0,IF(J21=\"\",IF(AND(J19<=$C$29,K21>=$A$29),1,0),IF(K21=\"\",IF(AND(J21<=$C$29,TODAY()>=$A$29),1,0),IF(AND(K21=\"Продлён\",J23=\"\"),IF(AND(J21<=$C$29,K23>=$A$29),1,0),IF(K21=\"Продлён\",IF(AND(J21<=$C$29,J23>=$A$29),1,0),IF(AND(J21<=$C$29,K21>=$A$29),1,0))))))","v":0}]
[null,null,"Новикова Ирина",null,"Арндт Катерина",null,"Короткий Михаил",null,null,null,"Ситдиков Рафик"]
[null,"2015-06-08",null,"2015-03-25","2015-07-26","2015-07-26",null,null,null,null,"2015-07-31",null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF(AND(J23=\"\",K23=\"\"),0,IF(J23=\"\",IF(AND(J21<=$C$29,K23>=$A$29),1,0),IF(K23=\"\",IF(AND(J23<=$C$29,TODAY()>=$A$29),1,0),IF(AND(K23=\"Продлён\",J25=\"\"),IF(AND(J23<=$C$29,K25>=$A$29),1,0),IF(K23=\"Продлён\",IF(AND(J23<=$C$29,J25>=$A$29),1,0),IF(AND(J23<=$C$29,K23>=$A$29),1,0))))))","v":0}]
[]
[]
[null,{"$f":"IF(SUM(O4:O24)>0,1,0)","v":0},null,{"$f":"IF(SUM(Q4:Q24)>0,1,0)","v":1},null,{"$f":"IF(SUM(S4:S24)>0,1,0)","v":1},null,{"$f":"IF(SUM(U4:U24)>0,1,0)","v":1},null,{"$f":"IF(SUM(W4:W24)>0,1,0)","v":1}]
[]
["Заданний интервал"]
["2013-08-25",":","2013-10-25"]
["Тема:      Анализ ситуации в заданном интервале времени"]
["Здравствуйте, уважаемые, форумчяни!"]
["Мне неободимо реализовать реализовать следующую задачу.   Есть таблица, в которой фиксируется у кого"]
[" находится предмет (G1 - G5). Когда он взял и когда вернул, Необходимо, чтобы под колонкой в жёлтой клетке"]
["появлялось \"1\", если в заданний период времени он у кого то находился и наоборот, если он не у кого не находился"]
["в этот период времени - \"0\"."]
["Пробовал найти решение, но я не очень силён в EKCELе , Если использовать условное форматирование, то там тоже "]
["надо формулу использовывать"]
["Заданий интервал можно задать по разному, не кретично, лишь бы это было доступно для пользования"]
["подскажите, пожалуйста, как это реализовать или укажите ссылку, где подобная задача решалось. "]
[]
["2013-08-25",":","2013-10-25"]

{"sheet":"Лист2","index":1,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,13,4,15],[6,1,6,2],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[8,7,8,8],[8,9,8,10],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[12,1,12,2],[12,3,12,4],[8,1,8,2],[8,3,8,4],[8,5,8,6]]}
[null,"2012-04-22","2013-11-11"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CountG(N7:P26,B1,C1)","v":1}]
[]
[null,"G1",null,"G2",null,"G3",null,"G4",null,"G5",null,null,null,"G1"]
[null,"Взял","Сдал","Взял","Сдал","Взял","Сдал","Взял","Сдал","Взял","Сдал",null,null,"Работник","Взял","Сдал"]
[null,"Арндт Ирина ",null,"Новиков Сергей",null,"Новиков Сергей",null,"Новикова Ирина",null,"Ситдиков Рафик",null,null,null,"Арндт Ирина","2012-04-22","2012-05-29"]
[null,"2012-04-22","Продлён","2012-08-22","2012-11-20","2011-11-06","2012-05-22","2012-02-26","Продлён","2012-06-24","2012-08-02",null,null,"Арндт Ирина","2012-09-01","2013-01-02"]
[null,"Арндт Ирина ",null,"Арндт Катерина",null,"Вильгельм Томас",null,"Новикова Ирина",null,"Алёхин Олег",null,null,null,"Мошнегуца Максим","2013-03-23","2013-04-23"]
[null,"2012-09-01","2013-01-02","2013-01-23","2013-03-01","2012-09-30","Продлён","2012-08-19","2012-09-30","2013-01-02","2013-02-03",null,null,"Мошнегуца Максим","2013-07-23","Продлён"]
[null,"Мошнегуца Максим",null,"Новиков Сергей",null,"Вильгельм Томас",null,"Арндт Катерина",null,"Ситдиков Рафик",null,null,null,"Ситдиков Рафик","2013-11-12","2014-02-23"]
[null,"2013-03-23","Продлён","2013-04-10","2013-05-29","2013-01-30","2013-05-05","2013-01-23","2013-05-19","2013-04-08","2013-05-26",null,null,"Мюллер Николай ","2014-04-04","2014-04-04"]
[null,"Мошнегуца Максим",null,"Арндт Андрей",null,null,"Вильгельм Томас",null,"Ситдиков Рафик",null,"Арндт Ирина",null,null,"Вильгельм Томас","2014-05-14","2014-08-22"]
[null,"2013-07-23","2013-08-23","2013-06-30","2013-08-18","2013-07-03","2013-11-24","2013-09-05","2013-11-11","2013-08-18","2013-12-08",null,null,"Вильгельм Томас","2014-09-14","2014-11-19"]
[null,null,"Ситдиков Рафик",null,"Ситдиков Рафик",null,"Ситдиков Рафик",null,"Каспер Мария",null,"Арндт Катерина",null,null,"Ситдиков Рафик","2015-01-05"]
[null,"2013-11-12","2014-02-23","2013-10-15","2013-11-12","2014-01-06","2014-02-23","2014-02-05","2014-06-08","2014-02-09","2014-06-22"]
[null,null,"Мюллер Николай ",null,"Вильгельм Томас",null,"Вильгельм Раиса",null,"Кайбелева Натал.",null,"Каспер Мария"]
[null,"2014-04-04","2014-04-04","2013-11-24","Продлён","2014-04-03","2014-04-20","2014-07-02","Продлён","2014-07-13","2014-07-23"]
[null,null,"Вильгельм Томас",null,"Вильгельм Томас",null,"Вильгельм Томас",null,"Кайбелева Натал.",null,"Ситдиков Рафик"]
[null,"2014-05-14","Продлён","2014-03-24","2014-07-09","2014-07-06","2014-07-13",null,"2015-04-05","2014-08-04","2014-09-02"]
[null,null,"Вильгельм Томас",null,"Алёхин Олег",null,"Кайбелева Натал.",null,"Алёхин Олег",null,"Алёхина Ольга"]
[null,"2014-09-14","2014-11-19","2014-08-13","2014-08-24","2014-08-03","Продлён","2015-08-16",null,"2014-10-09","2014-12-28"]
[null,null,"Ситдиков Рафик",null,"Короткий Михаил",null,"Кайбелева Натал.",null,null,null,"Ситдиков Рафик"]
[null,"2015-01-05","2015-03-26","2014-09-21","2015-02-08",null,"2015-03-29",null,null,"2015-03-09","Продлён"]
[null,null,"Новикова Ирина",null,"Арндт Катерина",null,"Короткий Михаил",null,null,null,"Ситдиков Рафик"]
[null,"2015-06-08",null,"2015-03-25","2015-07-26","2015-07-26",null,null,null,null,"2015-07-31"]

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