{"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":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Дата действия","Время действия","Активность","Клиент",null,"Клиент","Телефон","ЛПР","Адрес","Описание","Статус"]
["2016-10-01",null,"Звонок","Вася",{"$f":"IF(AND(F2<>\"\",MATCH(F2,F$1:F2,)=ROW()),E1+1,E1)","v":1},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D2=D$2:D$37,K$2:K$37),)))=0,D2,\"\")","v":"Вася"},"","","","","В работе",null,"Некачественный лид",{"$f":"IFERROR(VLOOKUP(ROW(N1),E$2:F$37,2,),\"\")","v":"Вася"}]
["2015-12-02",null,"Встреча","Петя ",{"$f":"IF(AND(F3<>\"\",MATCH(F3,F$1:F3,)=ROW()),E2+1,E2)","v":1},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D3=D$2:D$37,K$2:K$37),)))=0,D3,\"\")","v":""},"","","",null,"Дедлайн",null,"Постпродажный сервис",{"$f":"IFERROR(VLOOKUP(ROW(N2),E$2:F$37,2,),\"\")","v":"Миша"}]
["2016-03-02",null,"Встреча","Миша",{"$f":"IF(AND(F4<>\"\",MATCH(F4,F$1:F4,)=ROW()),E3+1,E3)","v":2},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D4=D$2:D$37,K$2:K$37),)))=0,D4,\"\")","v":"Миша"},"","","",null,"Дедлайн",null,null,"Маша"]
["2016-10-01",null,"Встреча","Петя ",{"$f":"IF(AND(F5<>\"\",MATCH(F5,F$1:F5,)=ROW()),E4+1,E4)","v":2},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D5=D$2:D$37,K$2:K$37),)))=0,D5,\"\")","v":""},"","","",null,"Некачественный лид",null,null,"Толя"]
["2015-12-02",null,"Звонок","Вася",{"$f":"IF(AND(F6<>\"\",MATCH(F6,F$1:F6,)=ROW()),E5+1,E5)","v":2},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D6=D$2:D$37,K$2:K$37),)))=0,D6,\"\")","v":"Вася"},"","","",null,"В работе",null,null,""]
["2016-03-02",null,"Звонок","Маша",{"$f":"IF(AND(F7<>\"\",MATCH(F7,F$1:F7,)=ROW()),E6+1,E6)","v":3},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D7=D$2:D$37,K$2:K$37),)))=0,D7,\"\")","v":"Маша"},"","","",null,"Дедлайн",null,null,""]
["2016-10-01",null,"Звонок","Коля",{"$f":"IF(AND(F8<>\"\",MATCH(F8,F$1:F8,)=ROW()),E7+1,E7)","v":3},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D8=D$2:D$37,K$2:K$37),)))=0,D8,\"\")","v":""},"","","",null,"Постпродажный сервис",null,null,""]
["2015-12-02",null,"Звонок","Коля",{"$f":"IF(AND(F9<>\"\",MATCH(F9,F$1:F9,)=ROW()),E8+1,E8)","v":3},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D9=D$2:D$37,K$2:K$37),)))=0,D9,\"\")","v":""},"","","",null,"В работе",null,null,""]
["2016-03-02",null,"Звонок","Толя",{"$f":"IF(AND(F10<>\"\",MATCH(F10,F$1:F10,)=ROW()),E9+1,E9)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D10=D$2:D$37,K$2:K$37),)))=0,D10,\"\")","v":"Толя"},"","","",null,"Дедлайн",null,null,""]
["2016-10-01",null,"Звонок","Толя",{"$f":"IF(AND(F11<>\"\",MATCH(F11,F$1:F11,)=ROW()),E10+1,E10)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D11=D$2:D$37,K$2:K$37),)))=0,D11,\"\")","v":"Толя"},"","","",null,"Дедлайн",null,null,""]
["2015-12-02",null,"Звонок","Коля",{"$f":"IF(AND(F12<>\"\",MATCH(F12,F$1:F12,)=ROW()),E11+1,E11)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D12=D$2:D$37,K$2:K$37),)))=0,D12,\"\")","v":""},"","","",null,"В работе"]
["2016-03-02",null,"Звонок","Толя",{"$f":"IF(AND(F13<>\"\",MATCH(F13,F$1:F13,)=ROW()),E12+1,E12)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D13=D$2:D$37,K$2:K$37),)))=0,D13,\"\")","v":"Толя"},"","","",null,"Дедлайн"]
["2016-10-01",null,"Встреча","Вася",{"$f":"IF(AND(F14<>\"\",MATCH(F14,F$1:F14,)=ROW()),E13+1,E13)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D14=D$2:D$37,K$2:K$37),)))=0,D14,\"\")","v":"Вася"},"","","",null,"В работе"]
["2015-12-02",null,"Встреча","Миша",{"$f":"IF(AND(F15<>\"\",MATCH(F15,F$1:F15,)=ROW()),E14+1,E14)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D15=D$2:D$37,K$2:K$37),)))=0,D15,\"\")","v":"Миша"},"","","",null,"Дедлайн"]
["2016-03-02",null,"Встреча","Маша",{"$f":"IF(AND(F16<>\"\",MATCH(F16,F$1:F16,)=ROW()),E15+1,E15)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D16=D$2:D$37,K$2:K$37),)))=0,D16,\"\")","v":"Маша"},"","","",null,"В работе"]
["2016-10-01",null,"Встреча","Миша",{"$f":"IF(AND(F17<>\"\",MATCH(F17,F$1:F17,)=ROW()),E16+1,E16)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D17=D$2:D$37,K$2:K$37),)))=0,D17,\"\")","v":"Миша"},"","","",null,"Дедлайн"]
["2015-12-02",null,"Встреча","Петя ",{"$f":"IF(AND(F18<>\"\",MATCH(F18,F$1:F18,)=ROW()),E17+1,E17)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D18=D$2:D$37,K$2:K$37),)))=0,D18,\"\")","v":""},"","","",null,"В работе"]
["2016-03-02",null,"Встреча","Петя ",{"$f":"IF(AND(F19<>\"\",MATCH(F19,F$1:F19,)=ROW()),E18+1,E18)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D19=D$2:D$37,K$2:K$37),)))=0,D19,\"\")","v":""},"","","",null,"Дедлайн"]
["2016-10-01",null,"Встреча","Петя ",{"$f":"IF(AND(F20<>\"\",MATCH(F20,F$1:F20,)=ROW()),E19+1,E19)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D20=D$2:D$37,K$2:K$37),)))=0,D20,\"\")","v":""},"","","",null,"В работе"]
["2015-12-02",null,"Звонок","Маша",{"$f":"IF(AND(F21<>\"\",MATCH(F21,F$1:F21,)=ROW()),E20+1,E20)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D21=D$2:D$37,K$2:K$37),)))=0,D21,\"\")","v":"Маша"},"","","",null,"Дедлайн"]
["2016-03-02",null,"Звонок","Миша",{"$f":"IF(AND(F22<>\"\",MATCH(F22,F$1:F22,)=ROW()),E21+1,E21)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D22=D$2:D$37,K$2:K$37),)))=0,D22,\"\")","v":"Миша"},"","","",null,"В работе"]
["2016-10-01",null,"Встреча","Толя",{"$f":"IF(AND(F23<>\"\",MATCH(F23,F$1:F23,)=ROW()),E22+1,E22)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D23=D$2:D$37,K$2:K$37),)))=0,D23,\"\")","v":"Толя"},"","","",null,"Дедлайн"]
["2015-12-02",null,"Встреча","Коля",{"$f":"IF(AND(F24<>\"\",MATCH(F24,F$1:F24,)=ROW()),E23+1,E23)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D24=D$2:D$37,K$2:K$37),)))=0,D24,\"\")","v":""},"","","",null,"В работе"]
["2016-03-02",null,"Встреча","Толя",{"$f":"IF(AND(F25<>\"\",MATCH(F25,F$1:F25,)=ROW()),E24+1,E24)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D25=D$2:D$37,K$2:K$37),)))=0,D25,\"\")","v":"Толя"},"","","",null,"Дедлайн"]
["2016-10-01",null,"Встреча","Коля",{"$f":"IF(AND(F26<>\"\",MATCH(F26,F$1:F26,)=ROW()),E25+1,E25)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D26=D$2:D$37,K$2:K$37),)))=0,D26,\"\")","v":""},"","","",null,"В работе"]
["2015-12-02",null,"Встреча","Коля",{"$f":"IF(AND(F27<>\"\",MATCH(F27,F$1:F27,)=ROW()),E26+1,E26)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D27=D$2:D$37,K$2:K$37),)))=0,D27,\"\")","v":""},"","","",null,"Дедлайн"]
["2016-03-02",null,"Звонок","Коля",{"$f":"IF(AND(F28<>\"\",MATCH(F28,F$1:F28,)=ROW()),E27+1,E27)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D28=D$2:D$37,K$2:K$37),)))=0,D28,\"\")","v":""},"","","",null,"В работе"]
["2016-10-01",null,"Звонок","Толя",{"$f":"IF(AND(F29<>\"\",MATCH(F29,F$1:F29,)=ROW()),E28+1,E28)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D29=D$2:D$37,K$2:K$37),)))=0,D29,\"\")","v":"Толя"},"","","",null,"Дедлайн"]
["2015-12-02",null,"Звонок","Толя",{"$f":"IF(AND(F30<>\"\",MATCH(F30,F$1:F30,)=ROW()),E29+1,E29)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D30=D$2:D$37,K$2:K$37),)))=0,D30,\"\")","v":"Толя"},"","","",null,"В работе"]
["2016-03-02",null,"Звонок","Коля",{"$f":"IF(AND(F31<>\"\",MATCH(F31,F$1:F31,)=ROW()),E30+1,E30)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D31=D$2:D$37,K$2:K$37),)))=0,D31,\"\")","v":""},"","","",null,"Дедлайн"]
["2016-10-01",null,"Звонок","Толя",{"$f":"IF(AND(F32<>\"\",MATCH(F32,F$1:F32,)=ROW()),E31+1,E31)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D32=D$2:D$37,K$2:K$37),)))=0,D32,\"\")","v":"Толя"},"","","",null,"В работе"]
["2015-12-02",null,"Звонок","Петя ",{"$f":"IF(AND(F33<>\"\",MATCH(F33,F$1:F33,)=ROW()),E32+1,E32)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D33=D$2:D$37,K$2:K$37),)))=0,D33,\"\")","v":""},"","","",null,"Дедлайн"]
["2016-03-02",null,"Звонок","Вася",{"$f":"IF(AND(F34<>\"\",MATCH(F34,F$1:F34,)=ROW()),E33+1,E33)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D34=D$2:D$37,K$2:K$37),)))=0,D34,\"\")","v":"Вася"},"","","",null,"В работе"]
["2016-10-01",null,"Звонок","Маша",{"$f":"IF(AND(F35<>\"\",MATCH(F35,F$1:F35,)=ROW()),E34+1,E34)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D35=D$2:D$37,K$2:K$37),)))=0,D35,\"\")","v":"Маша"},"","","",null,"Дедлайн"]
["2015-12-02",null,"Звонок","Коля",{"$f":"IF(AND(F36<>\"\",MATCH(F36,F$1:F36,)=ROW()),E35+1,E35)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D36=D$2:D$37,K$2:K$37),)))=0,D36,\"\")","v":""},"","","",null,"В работе"]
["2015-12-03",null,"Звонок","Коля",{"$f":"IF(AND(F37<>\"\",MATCH(F37,F$1:F37,)=ROW()),E36+1,E36)","v":4},{"$f":"IF(SUM(--ISNUMBER(MATCH(M$2:M$3,IF(D37=D$2:D$37,K$2:K$37),)))=0,D37,\"\")","v":""},"","","",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,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":[]}