{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Дата действия","Время действия","Активность","Клиент","Телефон","ЛПР","Адрес","Описание","Статус"]
["2016-10-01",null,"Звонок","Вася","","","","","В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M3,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":"Вася"},"Некачественный лид","Постпродажный сервис"]
["2015-12-02",null,"Встреча","Петя ","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M4,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":"Миша"}]
["2016-03-02",null,"Встреча","Миша","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M5,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":"Маша"}]
["2016-10-01",null,"Встреча","Петя ","","","",null,"Некачественный лид",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M6,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":"Толя"}]
["2015-12-02",null,"Звонок","Вася","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M7,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-03-02",null,"Звонок","Маша","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M8,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-10-01",null,"Звонок","Коля","","","",null,"Постпродажный сервис",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M9,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2015-12-02",null,"Звонок","Коля","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M10,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-03-02",null,"Звонок","Толя","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M11,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-10-01",null,"Звонок","Толя","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M12,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2015-12-02",null,"Звонок","Коля","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M13,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-03-02",null,"Звонок","Толя","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M14,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-10-01",null,"Встреча","Вася","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M15,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2015-12-02",null,"Встреча","Миша","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M16,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-03-02",null,"Встреча","Маша","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M17,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-10-01",null,"Встреча","Миша","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M18,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2015-12-02",null,"Встреча","Петя ","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M19,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-03-02",null,"Встреча","Петя ","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M20,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-10-01",null,"Встреча","Петя ","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M21,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2015-12-02",null,"Звонок","Маша","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M22,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-03-02",null,"Звонок","Миша","","","",null,"В работе",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M23,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2016-10-01",null,"Встреча","Толя","","","",null,"Дедлайн",null,null,null,{"$f":"INDEX(D$1:D$54,MIN(IF(NOT(MMULT(ISNUMBER(MATCH(D$4:D$54&N$4:O$4,D$1:D$54&I$1:I$54,))*ROW(D$4:D$54),{1;1}))*(COUNTIF(M$3:M24,D$4:D$54)=0),ROW(D$4:D$54))))&\"\"","v":""}]
["2015-12-02",null,"Встреча","Коля","","","",null,"В работе"]
["2016-03-02",null,"Встреча","Толя","","","",null,"Дедлайн"]
["2016-10-01",null,"Встреча","Коля","","","",null,"В работе"]
["2015-12-02",null,"Встреча","Коля","","","",null,"Дедлайн"]
["2016-03-02",null,"Звонок","Коля","","","",null,"В работе"]
["2016-10-01",null,"Звонок","Толя","","","",null,"Дедлайн"]
["2015-12-02",null,"Звонок","Толя","","","",null,"В работе"]
["2016-03-02",null,"Звонок","Коля","","","",null,"Дедлайн"]
["2016-10-01",null,"Звонок","Толя","","","",null,"В работе"]
["2015-12-02",null,"Звонок","Петя ","","","",null,"Дедлайн"]
["2016-03-02",null,"Звонок","Вася","","","",null,"В работе"]
["2016-10-01",null,"Звонок","Маша","","","",null,"Дедлайн"]
["2015-12-02",null,"Звонок","Коля","","","",null,"В работе"]
["2015-12-03",null,"Звонок","Коля","","","",null,"Дедлайн"]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]
[null,null,null,null,"","",""]

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

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