{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["20.05.15","Образец","Аналитика"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"20.05.15","index":0,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[77,0,77,6],[77,7,77,8],[78,0,78,6],[78,7,78,8],[79,0,79,6],[79,7,79,8]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TEXT(TODAY(),\"ММММ\")","v":"Апрель"}]
["Звонков","МПП1","МПП2","МПП3","МПП4","МПП5","МПП6","МПП7","МПП8",null,{"$f":"B3","v":"МПП1"},{"$f":"C3","v":"МПП2"},"МПП3","МПП4","МПП5","МПП6","МПП7","МПП8"]
[1,"14:11:40Звонок","14:11:41Диалог","14:11:42Звонок","14:11:43Звонок","14:11:45Диалог","14:11:47Диалог","14:11:49Звонок","14:11:50Звонок",null,{"$f":"RIGHT(B4,6)","v":"Звонок"},{"$f":"RIGHT(C4,6)","v":"Диалог"},"Звонок","Звонок","Диалог","Диалог","Звонок","Звонок"]
[2,"14:11:40Диалог","14:11:41Звонок","14:11:42Диалог","14:11:43Диалог","14:11:45Диалог","14:11:47Диалог","14:11:49Звонок","14:11:50Звонок",null,{"$f":"RIGHT(B5,6)","v":"Диалог"},"Звонок","Диалог","Диалог","Диалог","Диалог","Звонок","Звонок"]
[3,"14:13:42Звонок",null,null,null,"14:11:45Диалог","14:11:48Звонок","14:11:49Диалог","14:11:51Звонок",null,"Звонок","","","","Диалог","Звонок","Диалог","Звонок"]
[4,"14:16:23Диалог",null,null,null,"14:11:45Диалог","14:11:48Звонок","14:11:50Диалог","14:11:51Звонок",null,"Диалог","","","","Диалог","Звонок","Диалог","Звонок"]
[5,"14:16:23Диалог",null,null,null,"14:11:46Звонок",null,null,"14:11:51Звонок",null,"Диалог","","","","Звонок","","","Звонок"]
[6,"14:16:24Диалог",null,null,null,"14:11:46Звонок",null,null,null,null,"Диалог","","","","Звонок","","",""]
[7,"14:16:24Диалог",null,null,null,"14:11:46Звонок",null,null,null,null,"Диалог","","","","Звонок","","",""]
[8,"14:16:25Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[9,"14:16:25Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[10,"14:16:25Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[11,"14:16:25Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[12,"14:16:26Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[13,"14:16:26Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[14,"14:16:26Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[15,"14:16:26Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[16,"14:16:26Звонок",null,null,null,null,null,null,null,null,"Звонок","","","","","","",""]
[17,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[18,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[19,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[20,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[21,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[22,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[23,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[24,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[25,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[26,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[27,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[28,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[29,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[30,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[31,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[32,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[33,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[34,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[35,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[36,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[37,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[38,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[39,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[40,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[41,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[42,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[43,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[44,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[45,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[46,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[47,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(B50,6)","v":""},"","","","","","",""]
[48,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[49,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[50,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[51,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[52,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[53,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[54,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[55,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[56,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[57,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[58,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[59,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[60,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[61,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[62,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[63,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[64,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[65,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[66,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[67,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[68,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[69,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[70,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
["Звонков",{"$f":"COUNTIF(K4:K73,\"Звонок\")","v":11},{"$f":"COUNTIF(L4:L73,\"Звонок\")","v":1},1,1,3,2,2,5]
["Диалогов",{"$f":"COUNTIF(K4:K73,\"Диалог\")","v":5},{"$f":"COUNTIF(L4:L73,\"Диалог\")","v":1},1,1,4,2,2,0]
["Встреч"]
["Воронка",{"$f":"IFERROR(B76/B75,0)","v":0},{"$f":"IFERROR(C76/C75,0)","v":0},0,0,0,0,0,0]
["ИТОГО ЗВОНКОВ",null,null,null,null,null,null,{"$f":"SUM(B74:I74)","v":26}]
["ИТОГО ДИАЛОГОВ",null,null,null,null,null,null,{"$f":"SUM(B75:I75)","v":16}]
["ИТОГО ВСТРЕЧ",null,null,null,null,null,null,{"$f":"SUM(B76:I76)","v":0}]

{"sheet":"Образец","index":1,"n_rows":80,"n_cols":18,"rows_kept":80,"cut":false,"hidden":false,"merged":[[77,0,77,6],[77,7,77,8],[79,0,79,6],[79,7,79,8],[78,0,78,6],[78,7,78,8]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TEXT(TODAY(),\"ММММ\")","v":"Апрель"}]
["Звонков","МПП1","МПП2","МПП3","МПП4","МПП5","МПП6","МПП7","МПП8",null,{"$f":"B3","v":"МПП1"},{"$f":"C3","v":"МПП2"},"МПП3","МПП4","МПП5","МПП6",{"$f":"H3","v":"МПП7"},{"$f":"I3","v":"МПП8"}]
[1,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(B4,6)","v":""},{"$f":"RIGHT(C4,6)","v":""},"","","","","",""]
[2,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(B5,6)","v":""},{"$f":"RIGHT(C5,6)","v":""},{"$f":"RIGHT(D5,6)","v":""},{"$f":"RIGHT(E5,6)","v":""},{"$f":"RIGHT(F5,6)","v":""},{"$f":"RIGHT(G5,6)","v":""},{"$f":"RIGHT(H5,6)","v":""},{"$f":"RIGHT(I5,6)","v":""}]
[3,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[4,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[5,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[6,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[7,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[8,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[9,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[10,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[11,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[12,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[13,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[14,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[15,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[16,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[17,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[18,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[19,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[20,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[21,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[22,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[23,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[24,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[25,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[26,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[27,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[28,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[29,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[30,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[31,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[32,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[33,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[34,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[35,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[36,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[37,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[38,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[39,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[40,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[41,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[42,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[43,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[44,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[45,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[46,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[47,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[48,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[49,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[50,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[51,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[52,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[53,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[54,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[55,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[56,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[57,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[58,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[59,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[60,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[61,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[62,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[63,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[64,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[65,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[66,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(B69,6)","v":""},{"$f":"RIGHT(C69,6)","v":""},{"$f":"RIGHT(D69,6)","v":""},{"$f":"RIGHT(E69,6)","v":""},{"$f":"RIGHT(F69,6)","v":""},{"$f":"RIGHT(G69,6)","v":""},{"$f":"RIGHT(H69,6)","v":""},{"$f":"RIGHT(I69,6)","v":""}]
[67,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[68,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[69,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
[70,null,null,null,null,null,null,null,null,null,"","","","","","","",""]
["Звонков",{"$f":"COUNTIF(K4:K73,\"Звонок\")","v":0},{"$f":"COUNTIF(L4:L73,\"Звонок\")","v":0},0,0,0,0,0,0]
["Диалогов",{"$f":"COUNTIF(K4:K73,\"Диалог\")","v":0},{"$f":"COUNTIF(L4:L73,\"Диалог\")","v":0},0,0,0,0,0,0]
["Встреч"]
["Воронка",{"$f":"IFERROR(B76/B75,0)","v":0},{"$f":"IFERROR(C76/C75,0)","v":0},0,0,0,0,0,0]
["ИТОГО ЗВОНКОВ",null,null,null,null,null,null,{"$f":"SUM(B74:I74)","v":0}]
["ИТОГО ДИАЛОГОВ",null,null,null,null,null,null,{"$f":"SUM(B75:I75)","v":0}]
["ИТОГО ВСТРЕЧ",null,null,null,null,null,null,{"$f":"SUM(B76:I76)","v":0}]

{"sheet":"Аналитика","index":2,"n_rows":27,"n_cols":40,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,33,16,36],[0,0,0,32],[21,0,23,0],[24,0,26,0],[1,0,2,0],[1,1,2,1],[3,0,5,0],[6,0,8,0],[9,0,11,0],[12,0,14,0],[15,0,17,0],[18,0,20,0]]}
["Май"]
["МПП","Активность",{"$f":"VLOOKUP(A1,AM3:AN14,2,FALSE)","v":"2015-05-01"},{"$f":"IFERROR(IF(TEXT((C2+1),\"ММММ\")=$A$1,C2+1,\" \"),\" \")","v":"2015-05-02"},{"$f":"IFERROR(IF(TEXT((D2+1),\"ММММ\")=$A$1,D2+1,\" \"),\" \")","v":"2015-05-03"},"2015-05-04","2015-05-05","2015-05-06","2015-05-07","2015-05-08","2015-05-09","2015-05-10","2015-05-11","2015-05-12","2015-05-13","2015-05-14","2015-05-15","2015-05-16","2015-05-17","2015-05-18","2015-05-19","2015-05-20","2015-05-21","2015-05-22","2015-05-23","2015-05-24","2015-05-25","2015-05-26","2015-05-27","2015-05-28","2015-05-29","2015-05-30","2015-05-31","В ячейке V4 расположена формула, которая ищет на листе соответствующем дате определенные значения.\nТак как файл будет пересохраняться раз в месяц с обозначением нового месяца, то даты в строке 2 будут меняться. Можно ли заставить формулу искать лист автоматически соответствующий значению даты в ячейке, а не прописывать его в ручную в каждой формуле?\n=ЕСЛИОШИБКА(ГПР($A$4;'V2'!B3:I77;72;ЛОЖЬ);\" \")"]
[null,null,{"$f":"TEXT(C2,\"ДДД\")","v":"Пт"},{"$f":"TEXT(D2,\"ДДД\")","v":"Сб"},"Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс",null,null,null,null,null,"январь","2015-01-01"]
[{"$f":"Образец!B3","v":"МПП1"},"Наборов",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(HLOOKUP($A$4,'20.05.15'!B3:I77,72,FALSE),\" \")","v":11},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"февраль","2015-02-01"]
[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,"март","2015-03-01"]
[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,"апрель","2015-04-01"]
[{"$f":"Образец!C3","v":"МПП2"},"Наборов",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,"май","2015-05-01"]
[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,"июнь","2015-06-01"]
[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,"июль","2015-07-01"]
[{"$f":"Образец!D3","v":"МПП3"},"Наборов",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,"август","2015-08-01"]
[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,"сентябрь","2015-09-01"]
[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,"октябрь","2015-10-01"]
[{"$f":"Образец!E3","v":"МПП4"},"Наборов",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,"ноябрь","2015-11-01"]
[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,"декабрь","2015-12-01"]
[null,"Встреч"]
[{"$f":"Образец!F3","v":"МПП5"},"Наборов"]
[null,"Диалогов"]
[null,"Встреч"]
[{"$f":"Образец!G3","v":"МПП6"},"Наборов"]
[null,"Диалогов"]
[null,"Встреч"]
[{"$f":"Образец!H3","v":"МПП7"},"Наборов"]
[null,"Диалогов"]
[null,"Встреч"]
[{"$f":"Образец!I3","v":"МПП8"},"Наборов"]
[null,"Диалогов"]
[null,"Встреч"]