{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Report","Сводная таблица","Диаграмма"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":2},"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":"Report","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,3,0,7]]}
[null,null,null,"Данные за неделю",null,null,null,null,{"$f":"SUMPRODUCT(Report!$H$4:$H$3744*(Report!$C$4:$C$3744=$B35)*(Report!$I$4:$I$3744=C$34)*(LEFT(Report!$J$4:$J$3744)=\"X\"))","v":0}]
[]
[]
["Пакет","X20","Client","2020-12-18 00:00:00",6,"2020-12-18 06:30:58","2020-12-18 06:31:22","00:00:24","Пакет","X20","Operator1"]
["Упаковка","E58","Client","2020-12-18 00:00:00",7,"2020-12-18 07:41:06","2020-12-18 07:41:07","00:00:01","Упаковка","E58","Operator1"]
["Коробка","X30","Client","2020-12-18 00:00:00",7,"2020-12-18 07:41:17","2020-12-18 07:41:28","00:00:11","Коробка","X30","Operator3"]
["Пакет","E65","Client","2020-12-18 00:00:00",7,"2020-12-18 07:12:34","2020-12-18 07:12:47","00:00:13","Пакет","E65","Operator4"]
["Упаковка","X92","Client","2020-12-18 00:00:00",7,"2020-12-18 07:41:14","2020-12-18 07:41:15","00:00:01","Упаковка","X92","Operator3"]
["Коробка","E12","Client","2020-12-18 00:00:00",7,"2020-12-18 07:41:10","2020-12-18 07:41:11","00:00:01","Коробка","E12","Operator3"]
["Пакет","X20","арпрп","2020-12-18 00:00:00",8,"2020-12-18 08:05:21","2020-12-18 08:05:34","00:00:13","Пакет","X20","Operator4"]
["Упаковка","E58","прр","2020-12-18 00:00:00",8,"2020-12-18 08:39:19","2020-12-18 08:40:13","00:00:54","Упаковка","E58","Client"]
["Коробка","X30","прпр","2020-12-18 00:00:00",8,"2020-12-18 08:43:45","2020-12-18 08:43:54","00:00:09","Коробка","X30","Operator4"]
["Пакет","E65","парпар","2020-12-18 00:00:00",8,"2020-12-18 08:34:07","2020-12-18 08:34:18","00:00:11","Пакет","E65","Operator3"]
["Упаковка","X92","парпар","2020-12-18 00:00:00",8,"2020-12-18 08:41:25","2020-12-18 08:41:47","00:00:22","Упаковка","X92","Client"]
["Коробка","E12","парпар","2020-12-18 00:00:00",8,"2020-12-18 08:36:44","2020-12-18 08:37:10","00:00:26","Коробка","E12","Operator4"]
["Пакет","E12","Client","2020-12-18 00:00:00",8,"2020-12-18 08:20:31","2020-12-18 08:20:49","00:00:18","Пакет","X20","Operator3"]
["Упаковка","X92","Client","2020-12-18 00:00:00",8,"2020-12-18 08:11:20","2020-12-18 08:11:32","00:00:12","Упаковка","E58","Operator3"]
["Коробка","E12","Client","2020-12-18 00:00:00",8,"2020-12-18 08:24:44","2020-12-18 08:24:49","00:00:05","Коробка","X30","Operator3"]
["Пакет","X20","Client","2020-12-18 00:00:00",9,"2020-12-18 09:28:26","2020-12-18 09:31:19","00:02:53","Пакет","E65","Operator4"]
["Упаковка","E58","Client","2020-12-18 00:00:00",10,"2020-12-18 10:47:50","2020-12-18 10:48:32","00:00:42","Упаковка","X92","Operator4"]
["Коробка","X30","Client","2020-12-18 00:00:00",11,"2020-12-18 11:28:39","2020-12-18 11:28:50","00:00:11","Коробка","E12","Operator4"]
["Пакет","E65","Client","2020-12-18 00:00:00",11,"2020-12-18 11:20:32","2020-12-18 11:20:41","00:00:09","Пакет","X20","Operator4"]
["Упаковка","X92","Client","2020-12-18 00:00:00",11,"2020-12-18 11:00:58","2020-12-18 11:01:16","00:00:18","Упаковка","E58","Operator4"]
["Коробка","E12","Client","2020-12-18 00:00:00",11,"2020-12-18 11:28:35","2020-12-18 11:28:37","00:00:02","Коробка","X30","Operator4"]
["Пакет","X20","Client","2020-12-18 00:00:00",12,"2020-12-18 12:01:15","2020-12-18 12:01:30","00:00:15","Пакет","E65","Operator4"]
["Упаковка","E58","парпар","2020-12-18 00:00:00",12,"2020-12-18 12:07:12","2020-12-18 12:07:24","00:00:12","Упаковка","X92","Operator4"]
["Коробка","X30","парпар","2020-12-18 00:00:00",12,"2020-12-18 12:01:31","2020-12-18 12:02:11","00:00:40","Коробка","E12","Operator4"]
["Пакет","E65","Client","2020-12-18 00:00:00",12,"2020-12-18 12:05:00","2020-12-18 12:05:14","00:00:14","Пакет","X20","Operator4"]
["Упаковка","X92","Client","2020-12-18 00:00:00",12,"2020-12-18 12:41:02","2020-12-18 12:41:16","00:00:14","Упаковка","E58","парпар"]
["Коробка","E12","Client","2020-12-18 00:00:00",12,"2020-12-18 12:41:45","2020-12-18 12:41:47","00:00:02","Коробка","X30","Operator4"]
["Пакет","X20","Client","2020-12-18 00:00:00",12,"2020-12-18 12:47:28","2020-12-18 12:47:40","00:00:12","Пакет","E65","Operator4"]
["Упаковка","E58","парпар","2020-12-18 00:00:00",13,"2020-12-18 13:32:05","2020-12-18 13:32:14","00:00:09","Упаковка","X92","Operator3"]
["Коробка","X20","парпар","2020-12-18 00:00:00",13,"2020-12-18 13:30:38","2020-12-18 13:31:05","00:00:27","Коробка","E12","Operator3"]
["Пакет","E58","парпар","2020-12-18 00:00:00",13,"2020-12-18 13:34:55","2020-12-18 13:35:42","00:00:47","Пакет","X20","парпар"]
["Упаковка","X30","Client","2020-12-18 00:00:00",13,"2020-12-18 13:45:01","2020-12-18 13:45:19","00:00:18","Упаковка","E58","Operator4"]
["Коробка","E65","Client","2020-12-18 00:00:00",13,"2020-12-18 13:31:09","2020-12-18 13:31:14","00:00:05","Коробка","X30","Operator3"]
["Пакет","X92","парпар","2020-12-18 00:00:00",14,"2020-12-18 14:03:36","2020-12-18 14:03:56","00:00:20","Пакет","E65","Operator4"]
["Упаковка","E12","парпар","2020-12-18 00:00:00",15,"2020-12-18 15:54:04","2020-12-18 15:54:10","00:00:06","Упаковка","X92","Operator4"]
["Коробка","X20","парпар","2020-12-18 00:00:00",16,"2020-12-18 16:03:30","2020-12-18 16:03:56","00:00:26","Коробка","E12","Operator4"]
["Пакет","E58","Client","2020-12-18 00:00:00",16,"2020-12-18 16:18:09","2020-12-18 16:18:15","00:00:06","Пакет","X20","Operator4"]
["Упаковка","X30","парпар","2020-12-18 00:00:00",17,"2020-12-18 17:59:21","2020-12-18 17:59:26","00:00:05","Упаковка","E58","Operator4"]
["Коробка","E65","Client","2020-12-18 00:00:00",17,"2020-12-18 17:32:17","2020-12-18 17:32:32","00:00:15","Коробка","X30","Operator4"]
["Пакет","X92","Client","2020-12-18 00:00:00",17,"2020-12-18 17:45:25","2020-12-18 17:45:49","00:00:24","Пакет","E65","Operator4"]
["Упаковка","E12","Client","2020-12-18 00:00:00",17,"2020-12-18 17:37:10","2020-12-18 17:37:17","00:00:07","Упаковка","X92","Operator4"]
["Коробка","X20","Client","2020-12-18 00:00:00",17,"2020-12-18 17:58:15","2020-12-18 17:58:22","00:00:07","Коробка","E12","Operator4"]
["Пакет","E58","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:03:16","2020-12-18 18:03:23","00:00:07","Пакет","X20","парпар"]
["Упаковка","X30","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:06:53","2020-12-18 18:07:25","00:00:32","Упаковка","E58","парпар"]
["Коробка","E65","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:29:02","2020-12-18 18:29:05","00:00:03","Коробка","X30","Operator4"]
["Пакет","X92","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:21:41","2020-12-18 18:22:08","00:00:27","Пакет","E65","парпар"]
["Упаковка","E12","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:05:21","2020-12-18 18:05:50","00:00:29","Упаковка","X92","парпар"]
["Коробка","X20","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:12:48","2020-12-18 18:12:53","00:00:05","Коробка","E12","парпар"]
["Коробка","E58","парпар","2020-12-18 00:00:00",18,"2020-12-18 18:15:47","2020-12-18 18:16:38","00:00:51","Коробка","E12","парпар"]

{"sheet":"Сводная таблица","index":1,"n_rows":78,"n_cols":13,"rows_kept":78,"cut":false,"hidden":true,"merged":[[0,3,0,7],[1,3,1,7]]}
[null,null,null,"Данные за неделю"]
[null,null,null,"Данные за неделю"]
["Смена","Оператор","Звонки","Дата","Время","Дата начала","Дата конца","время2","день недели","номер марки","Марка","Наименование","Значение"]
[{"$f":"IF(E4=\"\",\"\",IF(OR(Report!E4>=22,Report!E4<=5),\"утро\",IF(AND(Report!E4>=6,Report!E4<=13),\"день\",IF(AND(Report!E4>=14,Report!E4<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K4)=\"O\",Report!C4=\"Client\"),Report!K4,IF(AND(LEFT(Report!C4)=\"O\",Report!K4=\"Client\"),Report!C4,\"\"))","v":"Operator1"},{"$f":"IF(AND(LEFT(Report!K4)=\"O\",Report!C4=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C4)=\"O\",Report!K4=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",DATEVALUE(Report!D4))","v":"2020-12-18"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",IF(Report!E4=0,\"00:00-00:59\",IF(Report!E4=1,\"01:00-01:59\",IF(Report!E4=2,\"02:00-02:59\",IF(Report!E4=3,\"03:00-03:59\",IF(Report!E4=4,\"04:00-04:59\",IF(Report!E4=5,\"05:00-05:59\",IF(Report!E4=6,\"06:00-06:59\",IF(Report!E4=7,\"07:00-07:59\",IF(Report!E4=8,\"08:00-08:59\",IF(Report!E4=9,\"09:00-09:59\",Report!E4&\":00-\"&Report!E4&\":59\")))))))))))","v":"06:00-06:59"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",DATEVALUE(LEFT(Report!F4,10))+TIMEVALUE(RIGHT(Report!F4,8)))","v":"2020-12-18T06:30:58"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",DATEVALUE(LEFT(Report!G4,10))+TIMEVALUE(RIGHT(Report!G4,8)))","v":"2020-12-18T06:31:22"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",TIMEVALUE(RIGHT(Report!H4,8)))","v":"00:00:24"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",D4)","v":"2020-12-18"},{"$f":"IF(AND(LEFT(Report!K4)=\"O\",Report!C4=\"Client\"),Report!B4,IF(AND(LEFT(Report!C4)=\"O\",Report!K4=\"Client\"),Report!J4,\"\"))","v":"X20"},{"$f":"IF(AND(LEFT(Report!K4)=\"O\",Report!C4=\"Client\"),Report!A4,IF(AND(LEFT(Report!C4)=\"O\",Report!K4=\"Client\"),Report!I4,\"\"))","v":"Пакет"},{"$f":"IF(LEFT(J4)=\"X\",\"Саморезы\",IF(LEFT(J4)=\"E\",\"Гвозди\",\"\"))","v":"Саморезы"},{"$f":"IF(AND(C4=\"\",K4=\"\"),\"\",\"1\")","v":"1"}]
[{"$f":"IF(E5=\"\",\"\",IF(OR(Report!E5>=22,Report!E5<=5),\"утро\",IF(AND(Report!E5>=6,Report!E5<=13),\"день\",IF(AND(Report!E5>=14,Report!E5<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K5)=\"O\",Report!C5=\"Client\"),Report!K5,IF(AND(LEFT(Report!C5)=\"O\",Report!K5=\"Client\"),Report!C5,\"\"))","v":"Operator1"},{"$f":"IF(AND(LEFT(Report!K5)=\"O\",Report!C5=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C5)=\"O\",Report!K5=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",DATEVALUE(Report!D5))","v":"2020-12-18"},{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",IF(Report!E5=0,\"00:00-00:59\",IF(Report!E5=1,\"01:00-01:59\",IF(Report!E5=2,\"02:00-02:59\",IF(Report!E5=3,\"03:00-03:59\",IF(Report!E5=4,\"04:00-04:59\",IF(Report!E5=5,\"05:00-05:59\",IF(Report!E5=6,\"06:00-06:59\",IF(Report!E5=7,\"07:00-07:59\",IF(Report!E5=8,\"08:00-08:59\",IF(Report!E5=9,\"09:00-09:59\",Report!E5&\":00-\"&Report!E5&\":59\")))))))))))","v":"07:00-07:59"},{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",DATEVALUE(LEFT(Report!F5,10))+TIMEVALUE(RIGHT(Report!F5,8)))","v":"2020-12-18T07:41:06"},{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",DATEVALUE(LEFT(Report!G5,10))+TIMEVALUE(RIGHT(Report!G5,8)))","v":"2020-12-18T07:41:07"},{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",TIMEVALUE(RIGHT(Report!H5,8)))","v":"00:00:01"},{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",D5)","v":"2020-12-18"},{"$f":"IF(AND(LEFT(Report!K5)=\"O\",Report!C5=\"Client\"),Report!B5,IF(AND(LEFT(Report!C5)=\"O\",Report!K5=\"Client\"),Report!J5,\"\"))","v":"E58"},{"$f":"IF(AND(LEFT(Report!K5)=\"O\",Report!C5=\"Client\"),Report!A5,IF(AND(LEFT(Report!C5)=\"O\",Report!K5=\"Client\"),Report!I5,\"\"))","v":"Упаковка"},"Гвозди",{"$f":"IF(AND(C5=\"\",K5=\"\"),\"\",\"1\")","v":"1"}]
[{"$f":"IF(E6=\"\",\"\",IF(OR(Report!E6>=22,Report!E6<=5),\"утро\",IF(AND(Report!E6>=6,Report!E6<=13),\"день\",IF(AND(Report!E6>=14,Report!E6<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K6)=\"O\",Report!C6=\"Client\"),Report!K6,IF(AND(LEFT(Report!C6)=\"O\",Report!K6=\"Client\"),Report!C6,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K6)=\"O\",Report!C6=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C6)=\"O\",Report!K6=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C6=\"\",K6=\"\"),\"\",DATEVALUE(Report!D6))","v":"2020-12-18"},{"$f":"IF(AND(C6=\"\",K6=\"\"),\"\",IF(Report!E6=0,\"00:00-00:59\",IF(Report!E6=1,\"01:00-01:59\",IF(Report!E6=2,\"02:00-02:59\",IF(Report!E6=3,\"03:00-03:59\",IF(Report!E6=4,\"04:00-04:59\",IF(Report!E6=5,\"05:00-05:59\",IF(Report!E6=6,\"06:00-06:59\",IF(Report!E6=7,\"07:00-07:59\",IF(Report!E6=8,\"08:00-08:59\",IF(Report!E6=9,\"09:00-09:59\",Report!E6&\":00-\"&Report!E6&\":59\")))))))))))","v":"07:00-07:59"},{"$f":"IF(AND(C6=\"\",K6=\"\"),\"\",DATEVALUE(LEFT(Report!F6,10))+TIMEVALUE(RIGHT(Report!F6,8)))","v":"2020-12-18T07:41:17"},{"$f":"IF(AND(C6=\"\",K6=\"\"),\"\",DATEVALUE(LEFT(Report!G6,10))+TIMEVALUE(RIGHT(Report!G6,8)))","v":"2020-12-18T07:41:28"},{"$f":"IF(AND(C6=\"\",K6=\"\"),\"\",TIMEVALUE(RIGHT(Report!H6,8)))","v":"00:00:11"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K6)=\"O\",Report!C6=\"Client\"),Report!B6,IF(AND(LEFT(Report!C6)=\"O\",Report!K6=\"Client\"),Report!J6,\"\"))","v":"X30"},{"$f":"IF(AND(LEFT(Report!K6)=\"O\",Report!C6=\"Client\"),Report!A6,IF(AND(LEFT(Report!C6)=\"O\",Report!K6=\"Client\"),Report!I6,\"\"))","v":"Коробка"},"Саморезы","1"]
[{"$f":"IF(E7=\"\",\"\",IF(OR(Report!E7>=22,Report!E7<=5),\"утро\",IF(AND(Report!E7>=6,Report!E7<=13),\"день\",IF(AND(Report!E7>=14,Report!E7<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K7)=\"O\",Report!C7=\"Client\"),Report!K7,IF(AND(LEFT(Report!C7)=\"O\",Report!K7=\"Client\"),Report!C7,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K7)=\"O\",Report!C7=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C7)=\"O\",Report!K7=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C7=\"\",K7=\"\"),\"\",DATEVALUE(Report!D7))","v":"2020-12-18"},{"$f":"IF(AND(C7=\"\",K7=\"\"),\"\",IF(Report!E7=0,\"00:00-00:59\",IF(Report!E7=1,\"01:00-01:59\",IF(Report!E7=2,\"02:00-02:59\",IF(Report!E7=3,\"03:00-03:59\",IF(Report!E7=4,\"04:00-04:59\",IF(Report!E7=5,\"05:00-05:59\",IF(Report!E7=6,\"06:00-06:59\",IF(Report!E7=7,\"07:00-07:59\",IF(Report!E7=8,\"08:00-08:59\",IF(Report!E7=9,\"09:00-09:59\",Report!E7&\":00-\"&Report!E7&\":59\")))))))))))","v":"07:00-07:59"},{"$f":"IF(AND(C7=\"\",K7=\"\"),\"\",DATEVALUE(LEFT(Report!F7,10))+TIMEVALUE(RIGHT(Report!F7,8)))","v":"2020-12-18T07:12:34"},{"$f":"IF(AND(C7=\"\",K7=\"\"),\"\",DATEVALUE(LEFT(Report!G7,10))+TIMEVALUE(RIGHT(Report!G7,8)))","v":"2020-12-18T07:12:47"},{"$f":"IF(AND(C7=\"\",K7=\"\"),\"\",TIMEVALUE(RIGHT(Report!H7,8)))","v":"00:00:13"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K7)=\"O\",Report!C7=\"Client\"),Report!B7,IF(AND(LEFT(Report!C7)=\"O\",Report!K7=\"Client\"),Report!J7,\"\"))","v":"E65"},{"$f":"IF(AND(LEFT(Report!K7)=\"O\",Report!C7=\"Client\"),Report!A7,IF(AND(LEFT(Report!C7)=\"O\",Report!K7=\"Client\"),Report!I7,\"\"))","v":"Пакет"},"Гвозди","1"]
[{"$f":"IF(E8=\"\",\"\",IF(OR(Report!E8>=22,Report!E8<=5),\"утро\",IF(AND(Report!E8>=6,Report!E8<=13),\"день\",IF(AND(Report!E8>=14,Report!E8<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K8)=\"O\",Report!C8=\"Client\"),Report!K8,IF(AND(LEFT(Report!C8)=\"O\",Report!K8=\"Client\"),Report!C8,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K8)=\"O\",Report!C8=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C8)=\"O\",Report!K8=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C8=\"\",K8=\"\"),\"\",DATEVALUE(Report!D8))","v":"2020-12-18"},{"$f":"IF(AND(C8=\"\",K8=\"\"),\"\",IF(Report!E8=0,\"00:00-00:59\",IF(Report!E8=1,\"01:00-01:59\",IF(Report!E8=2,\"02:00-02:59\",IF(Report!E8=3,\"03:00-03:59\",IF(Report!E8=4,\"04:00-04:59\",IF(Report!E8=5,\"05:00-05:59\",IF(Report!E8=6,\"06:00-06:59\",IF(Report!E8=7,\"07:00-07:59\",IF(Report!E8=8,\"08:00-08:59\",IF(Report!E8=9,\"09:00-09:59\",Report!E8&\":00-\"&Report!E8&\":59\")))))))))))","v":"07:00-07:59"},{"$f":"IF(AND(C8=\"\",K8=\"\"),\"\",DATEVALUE(LEFT(Report!F8,10))+TIMEVALUE(RIGHT(Report!F8,8)))","v":"2020-12-18T07:41:14"},{"$f":"IF(AND(C8=\"\",K8=\"\"),\"\",DATEVALUE(LEFT(Report!G8,10))+TIMEVALUE(RIGHT(Report!G8,8)))","v":"2020-12-18T07:41:15"},{"$f":"IF(AND(C8=\"\",K8=\"\"),\"\",TIMEVALUE(RIGHT(Report!H8,8)))","v":"00:00:01"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K8)=\"O\",Report!C8=\"Client\"),Report!B8,IF(AND(LEFT(Report!C8)=\"O\",Report!K8=\"Client\"),Report!J8,\"\"))","v":"X92"},{"$f":"IF(AND(LEFT(Report!K8)=\"O\",Report!C8=\"Client\"),Report!A8,IF(AND(LEFT(Report!C8)=\"O\",Report!K8=\"Client\"),Report!I8,\"\"))","v":"Упаковка"},"Саморезы","1"]
[{"$f":"IF(E9=\"\",\"\",IF(OR(Report!E9>=22,Report!E9<=5),\"утро\",IF(AND(Report!E9>=6,Report!E9<=13),\"день\",IF(AND(Report!E9>=14,Report!E9<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K9)=\"O\",Report!C9=\"Client\"),Report!K9,IF(AND(LEFT(Report!C9)=\"O\",Report!K9=\"Client\"),Report!C9,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K9)=\"O\",Report!C9=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C9)=\"O\",Report!K9=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C9=\"\",K9=\"\"),\"\",DATEVALUE(Report!D9))","v":"2020-12-18"},{"$f":"IF(AND(C9=\"\",K9=\"\"),\"\",IF(Report!E9=0,\"00:00-00:59\",IF(Report!E9=1,\"01:00-01:59\",IF(Report!E9=2,\"02:00-02:59\",IF(Report!E9=3,\"03:00-03:59\",IF(Report!E9=4,\"04:00-04:59\",IF(Report!E9=5,\"05:00-05:59\",IF(Report!E9=6,\"06:00-06:59\",IF(Report!E9=7,\"07:00-07:59\",IF(Report!E9=8,\"08:00-08:59\",IF(Report!E9=9,\"09:00-09:59\",Report!E9&\":00-\"&Report!E9&\":59\")))))))))))","v":"07:00-07:59"},{"$f":"IF(AND(C9=\"\",K9=\"\"),\"\",DATEVALUE(LEFT(Report!F9,10))+TIMEVALUE(RIGHT(Report!F9,8)))","v":"2020-12-18T07:41:10"},{"$f":"IF(AND(C9=\"\",K9=\"\"),\"\",DATEVALUE(LEFT(Report!G9,10))+TIMEVALUE(RIGHT(Report!G9,8)))","v":"2020-12-18T07:41:11"},{"$f":"IF(AND(C9=\"\",K9=\"\"),\"\",TIMEVALUE(RIGHT(Report!H9,8)))","v":"00:00:01"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K9)=\"O\",Report!C9=\"Client\"),Report!B9,IF(AND(LEFT(Report!C9)=\"O\",Report!K9=\"Client\"),Report!J9,\"\"))","v":"E12"},{"$f":"IF(AND(LEFT(Report!K9)=\"O\",Report!C9=\"Client\"),Report!A9,IF(AND(LEFT(Report!C9)=\"O\",Report!K9=\"Client\"),Report!I9,\"\"))","v":"Коробка"},"Гвозди","1"]
[{"$f":"IF(E10=\"\",\"\",IF(OR(Report!E10>=22,Report!E10<=5),\"утро\",IF(AND(Report!E10>=6,Report!E10<=13),\"день\",IF(AND(Report!E10>=14,Report!E10<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K10)=\"O\",Report!C10=\"Client\"),Report!K10,IF(AND(LEFT(Report!C10)=\"O\",Report!K10=\"Client\"),Report!C10,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K10)=\"O\",Report!C10=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C10)=\"O\",Report!K10=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",DATEVALUE(Report!D10))","v":""},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",IF(Report!E10=0,\"00:00-00:59\",IF(Report!E10=1,\"01:00-01:59\",IF(Report!E10=2,\"02:00-02:59\",IF(Report!E10=3,\"03:00-03:59\",IF(Report!E10=4,\"04:00-04:59\",IF(Report!E10=5,\"05:00-05:59\",IF(Report!E10=6,\"06:00-06:59\",IF(Report!E10=7,\"07:00-07:59\",IF(Report!E10=8,\"08:00-08:59\",IF(Report!E10=9,\"09:00-09:59\",Report!E10&\":00-\"&Report!E10&\":59\")))))))))))","v":""},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",DATEVALUE(LEFT(Report!F10,10))+TIMEVALUE(RIGHT(Report!F10,8)))","v":""},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",DATEVALUE(LEFT(Report!G10,10))+TIMEVALUE(RIGHT(Report!G10,8)))","v":""},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",TIMEVALUE(RIGHT(Report!H10,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K10)=\"O\",Report!C10=\"Client\"),Report!B10,IF(AND(LEFT(Report!C10)=\"O\",Report!K10=\"Client\"),Report!J10,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K10)=\"O\",Report!C10=\"Client\"),Report!A10,IF(AND(LEFT(Report!C10)=\"O\",Report!K10=\"Client\"),Report!I10,\"\"))","v":""},"",""]
[{"$f":"IF(E11=\"\",\"\",IF(OR(Report!E11>=22,Report!E11<=5),\"утро\",IF(AND(Report!E11>=6,Report!E11<=13),\"день\",IF(AND(Report!E11>=14,Report!E11<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K11)=\"O\",Report!C11=\"Client\"),Report!K11,IF(AND(LEFT(Report!C11)=\"O\",Report!K11=\"Client\"),Report!C11,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K11)=\"O\",Report!C11=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C11)=\"O\",Report!K11=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",DATEVALUE(Report!D11))","v":""},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",IF(Report!E11=0,\"00:00-00:59\",IF(Report!E11=1,\"01:00-01:59\",IF(Report!E11=2,\"02:00-02:59\",IF(Report!E11=3,\"03:00-03:59\",IF(Report!E11=4,\"04:00-04:59\",IF(Report!E11=5,\"05:00-05:59\",IF(Report!E11=6,\"06:00-06:59\",IF(Report!E11=7,\"07:00-07:59\",IF(Report!E11=8,\"08:00-08:59\",IF(Report!E11=9,\"09:00-09:59\",Report!E11&\":00-\"&Report!E11&\":59\")))))))))))","v":""},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",DATEVALUE(LEFT(Report!F11,10))+TIMEVALUE(RIGHT(Report!F11,8)))","v":""},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",DATEVALUE(LEFT(Report!G11,10))+TIMEVALUE(RIGHT(Report!G11,8)))","v":""},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",TIMEVALUE(RIGHT(Report!H11,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K11)=\"O\",Report!C11=\"Client\"),Report!B11,IF(AND(LEFT(Report!C11)=\"O\",Report!K11=\"Client\"),Report!J11,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K11)=\"O\",Report!C11=\"Client\"),Report!A11,IF(AND(LEFT(Report!C11)=\"O\",Report!K11=\"Client\"),Report!I11,\"\"))","v":""},"",""]
[{"$f":"IF(E12=\"\",\"\",IF(OR(Report!E12>=22,Report!E12<=5),\"утро\",IF(AND(Report!E12>=6,Report!E12<=13),\"день\",IF(AND(Report!E12>=14,Report!E12<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K12)=\"O\",Report!C12=\"Client\"),Report!K12,IF(AND(LEFT(Report!C12)=\"O\",Report!K12=\"Client\"),Report!C12,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K12)=\"O\",Report!C12=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C12)=\"O\",Report!K12=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",DATEVALUE(Report!D12))","v":""},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",IF(Report!E12=0,\"00:00-00:59\",IF(Report!E12=1,\"01:00-01:59\",IF(Report!E12=2,\"02:00-02:59\",IF(Report!E12=3,\"03:00-03:59\",IF(Report!E12=4,\"04:00-04:59\",IF(Report!E12=5,\"05:00-05:59\",IF(Report!E12=6,\"06:00-06:59\",IF(Report!E12=7,\"07:00-07:59\",IF(Report!E12=8,\"08:00-08:59\",IF(Report!E12=9,\"09:00-09:59\",Report!E12&\":00-\"&Report!E12&\":59\")))))))))))","v":""},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",DATEVALUE(LEFT(Report!F12,10))+TIMEVALUE(RIGHT(Report!F12,8)))","v":""},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",DATEVALUE(LEFT(Report!G12,10))+TIMEVALUE(RIGHT(Report!G12,8)))","v":""},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",TIMEVALUE(RIGHT(Report!H12,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K12)=\"O\",Report!C12=\"Client\"),Report!B12,IF(AND(LEFT(Report!C12)=\"O\",Report!K12=\"Client\"),Report!J12,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K12)=\"O\",Report!C12=\"Client\"),Report!A12,IF(AND(LEFT(Report!C12)=\"O\",Report!K12=\"Client\"),Report!I12,\"\"))","v":""},"",""]
[{"$f":"IF(E13=\"\",\"\",IF(OR(Report!E13>=22,Report!E13<=5),\"утро\",IF(AND(Report!E13>=6,Report!E13<=13),\"день\",IF(AND(Report!E13>=14,Report!E13<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K13)=\"O\",Report!C13=\"Client\"),Report!K13,IF(AND(LEFT(Report!C13)=\"O\",Report!K13=\"Client\"),Report!C13,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K13)=\"O\",Report!C13=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C13)=\"O\",Report!K13=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",DATEVALUE(Report!D13))","v":""},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",IF(Report!E13=0,\"00:00-00:59\",IF(Report!E13=1,\"01:00-01:59\",IF(Report!E13=2,\"02:00-02:59\",IF(Report!E13=3,\"03:00-03:59\",IF(Report!E13=4,\"04:00-04:59\",IF(Report!E13=5,\"05:00-05:59\",IF(Report!E13=6,\"06:00-06:59\",IF(Report!E13=7,\"07:00-07:59\",IF(Report!E13=8,\"08:00-08:59\",IF(Report!E13=9,\"09:00-09:59\",Report!E13&\":00-\"&Report!E13&\":59\")))))))))))","v":""},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",DATEVALUE(LEFT(Report!F13,10))+TIMEVALUE(RIGHT(Report!F13,8)))","v":""},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",DATEVALUE(LEFT(Report!G13,10))+TIMEVALUE(RIGHT(Report!G13,8)))","v":""},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",TIMEVALUE(RIGHT(Report!H13,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K13)=\"O\",Report!C13=\"Client\"),Report!B13,IF(AND(LEFT(Report!C13)=\"O\",Report!K13=\"Client\"),Report!J13,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K13)=\"O\",Report!C13=\"Client\"),Report!A13,IF(AND(LEFT(Report!C13)=\"O\",Report!K13=\"Client\"),Report!I13,\"\"))","v":""},"",""]
[{"$f":"IF(E14=\"\",\"\",IF(OR(Report!E14>=22,Report!E14<=5),\"утро\",IF(AND(Report!E14>=6,Report!E14<=13),\"день\",IF(AND(Report!E14>=14,Report!E14<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K14)=\"O\",Report!C14=\"Client\"),Report!K14,IF(AND(LEFT(Report!C14)=\"O\",Report!K14=\"Client\"),Report!C14,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K14)=\"O\",Report!C14=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C14)=\"O\",Report!K14=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",DATEVALUE(Report!D14))","v":""},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",IF(Report!E14=0,\"00:00-00:59\",IF(Report!E14=1,\"01:00-01:59\",IF(Report!E14=2,\"02:00-02:59\",IF(Report!E14=3,\"03:00-03:59\",IF(Report!E14=4,\"04:00-04:59\",IF(Report!E14=5,\"05:00-05:59\",IF(Report!E14=6,\"06:00-06:59\",IF(Report!E14=7,\"07:00-07:59\",IF(Report!E14=8,\"08:00-08:59\",IF(Report!E14=9,\"09:00-09:59\",Report!E14&\":00-\"&Report!E14&\":59\")))))))))))","v":""},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",DATEVALUE(LEFT(Report!F14,10))+TIMEVALUE(RIGHT(Report!F14,8)))","v":""},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",DATEVALUE(LEFT(Report!G14,10))+TIMEVALUE(RIGHT(Report!G14,8)))","v":""},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",TIMEVALUE(RIGHT(Report!H14,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K14)=\"O\",Report!C14=\"Client\"),Report!B14,IF(AND(LEFT(Report!C14)=\"O\",Report!K14=\"Client\"),Report!J14,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K14)=\"O\",Report!C14=\"Client\"),Report!A14,IF(AND(LEFT(Report!C14)=\"O\",Report!K14=\"Client\"),Report!I14,\"\"))","v":""},"",""]
[{"$f":"IF(E15=\"\",\"\",IF(OR(Report!E15>=22,Report!E15<=5),\"утро\",IF(AND(Report!E15>=6,Report!E15<=13),\"день\",IF(AND(Report!E15>=14,Report!E15<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K15)=\"O\",Report!C15=\"Client\"),Report!K15,IF(AND(LEFT(Report!C15)=\"O\",Report!K15=\"Client\"),Report!C15,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K15)=\"O\",Report!C15=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C15)=\"O\",Report!K15=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",DATEVALUE(Report!D15))","v":""},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",IF(Report!E15=0,\"00:00-00:59\",IF(Report!E15=1,\"01:00-01:59\",IF(Report!E15=2,\"02:00-02:59\",IF(Report!E15=3,\"03:00-03:59\",IF(Report!E15=4,\"04:00-04:59\",IF(Report!E15=5,\"05:00-05:59\",IF(Report!E15=6,\"06:00-06:59\",IF(Report!E15=7,\"07:00-07:59\",IF(Report!E15=8,\"08:00-08:59\",IF(Report!E15=9,\"09:00-09:59\",Report!E15&\":00-\"&Report!E15&\":59\")))))))))))","v":""},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",DATEVALUE(LEFT(Report!F15,10))+TIMEVALUE(RIGHT(Report!F15,8)))","v":""},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",DATEVALUE(LEFT(Report!G15,10))+TIMEVALUE(RIGHT(Report!G15,8)))","v":""},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",TIMEVALUE(RIGHT(Report!H15,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K15)=\"O\",Report!C15=\"Client\"),Report!B15,IF(AND(LEFT(Report!C15)=\"O\",Report!K15=\"Client\"),Report!J15,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K15)=\"O\",Report!C15=\"Client\"),Report!A15,IF(AND(LEFT(Report!C15)=\"O\",Report!K15=\"Client\"),Report!I15,\"\"))","v":""},"",""]
[{"$f":"IF(E16=\"\",\"\",IF(OR(Report!E16>=22,Report!E16<=5),\"утро\",IF(AND(Report!E16>=6,Report!E16<=13),\"день\",IF(AND(Report!E16>=14,Report!E16<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K16)=\"O\",Report!C16=\"Client\"),Report!K16,IF(AND(LEFT(Report!C16)=\"O\",Report!K16=\"Client\"),Report!C16,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K16)=\"O\",Report!C16=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C16)=\"O\",Report!K16=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",DATEVALUE(Report!D16))","v":"2020-12-18"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",IF(Report!E16=0,\"00:00-00:59\",IF(Report!E16=1,\"01:00-01:59\",IF(Report!E16=2,\"02:00-02:59\",IF(Report!E16=3,\"03:00-03:59\",IF(Report!E16=4,\"04:00-04:59\",IF(Report!E16=5,\"05:00-05:59\",IF(Report!E16=6,\"06:00-06:59\",IF(Report!E16=7,\"07:00-07:59\",IF(Report!E16=8,\"08:00-08:59\",IF(Report!E16=9,\"09:00-09:59\",Report!E16&\":00-\"&Report!E16&\":59\")))))))))))","v":"08:00-08:59"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",DATEVALUE(LEFT(Report!F16,10))+TIMEVALUE(RIGHT(Report!F16,8)))","v":"2020-12-18T08:20:31"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",DATEVALUE(LEFT(Report!G16,10))+TIMEVALUE(RIGHT(Report!G16,8)))","v":"2020-12-18T08:20:49"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",TIMEVALUE(RIGHT(Report!H16,8)))","v":"00:00:18"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K16)=\"O\",Report!C16=\"Client\"),Report!B16,IF(AND(LEFT(Report!C16)=\"O\",Report!K16=\"Client\"),Report!J16,\"\"))","v":"E12"},{"$f":"IF(AND(LEFT(Report!K16)=\"O\",Report!C16=\"Client\"),Report!A16,IF(AND(LEFT(Report!C16)=\"O\",Report!K16=\"Client\"),Report!I16,\"\"))","v":"Пакет"},"Гвозди","1"]
[{"$f":"IF(E17=\"\",\"\",IF(OR(Report!E17>=22,Report!E17<=5),\"утро\",IF(AND(Report!E17>=6,Report!E17<=13),\"день\",IF(AND(Report!E17>=14,Report!E17<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K17)=\"O\",Report!C17=\"Client\"),Report!K17,IF(AND(LEFT(Report!C17)=\"O\",Report!K17=\"Client\"),Report!C17,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K17)=\"O\",Report!C17=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C17)=\"O\",Report!K17=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",DATEVALUE(Report!D17))","v":"2020-12-18"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",IF(Report!E17=0,\"00:00-00:59\",IF(Report!E17=1,\"01:00-01:59\",IF(Report!E17=2,\"02:00-02:59\",IF(Report!E17=3,\"03:00-03:59\",IF(Report!E17=4,\"04:00-04:59\",IF(Report!E17=5,\"05:00-05:59\",IF(Report!E17=6,\"06:00-06:59\",IF(Report!E17=7,\"07:00-07:59\",IF(Report!E17=8,\"08:00-08:59\",IF(Report!E17=9,\"09:00-09:59\",Report!E17&\":00-\"&Report!E17&\":59\")))))))))))","v":"08:00-08:59"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",DATEVALUE(LEFT(Report!F17,10))+TIMEVALUE(RIGHT(Report!F17,8)))","v":"2020-12-18T08:11:20"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",DATEVALUE(LEFT(Report!G17,10))+TIMEVALUE(RIGHT(Report!G17,8)))","v":"2020-12-18T08:11:32"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",TIMEVALUE(RIGHT(Report!H17,8)))","v":"00:00:12"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K17)=\"O\",Report!C17=\"Client\"),Report!B17,IF(AND(LEFT(Report!C17)=\"O\",Report!K17=\"Client\"),Report!J17,\"\"))","v":"X92"},{"$f":"IF(AND(LEFT(Report!K17)=\"O\",Report!C17=\"Client\"),Report!A17,IF(AND(LEFT(Report!C17)=\"O\",Report!K17=\"Client\"),Report!I17,\"\"))","v":"Упаковка"},"Саморезы","1"]
[{"$f":"IF(E18=\"\",\"\",IF(OR(Report!E18>=22,Report!E18<=5),\"утро\",IF(AND(Report!E18>=6,Report!E18<=13),\"день\",IF(AND(Report!E18>=14,Report!E18<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K18)=\"O\",Report!C18=\"Client\"),Report!K18,IF(AND(LEFT(Report!C18)=\"O\",Report!K18=\"Client\"),Report!C18,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K18)=\"O\",Report!C18=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C18)=\"O\",Report!K18=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",DATEVALUE(Report!D18))","v":"2020-12-18"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",IF(Report!E18=0,\"00:00-00:59\",IF(Report!E18=1,\"01:00-01:59\",IF(Report!E18=2,\"02:00-02:59\",IF(Report!E18=3,\"03:00-03:59\",IF(Report!E18=4,\"04:00-04:59\",IF(Report!E18=5,\"05:00-05:59\",IF(Report!E18=6,\"06:00-06:59\",IF(Report!E18=7,\"07:00-07:59\",IF(Report!E18=8,\"08:00-08:59\",IF(Report!E18=9,\"09:00-09:59\",Report!E18&\":00-\"&Report!E18&\":59\")))))))))))","v":"08:00-08:59"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",DATEVALUE(LEFT(Report!F18,10))+TIMEVALUE(RIGHT(Report!F18,8)))","v":"2020-12-18T08:24:44"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",DATEVALUE(LEFT(Report!G18,10))+TIMEVALUE(RIGHT(Report!G18,8)))","v":"2020-12-18T08:24:49"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",TIMEVALUE(RIGHT(Report!H18,8)))","v":"00:00:05"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K18)=\"O\",Report!C18=\"Client\"),Report!B18,IF(AND(LEFT(Report!C18)=\"O\",Report!K18=\"Client\"),Report!J18,\"\"))","v":"E12"},{"$f":"IF(AND(LEFT(Report!K18)=\"O\",Report!C18=\"Client\"),Report!A18,IF(AND(LEFT(Report!C18)=\"O\",Report!K18=\"Client\"),Report!I18,\"\"))","v":"Коробка"},"Гвозди","1"]
[{"$f":"IF(E19=\"\",\"\",IF(OR(Report!E19>=22,Report!E19<=5),\"утро\",IF(AND(Report!E19>=6,Report!E19<=13),\"день\",IF(AND(Report!E19>=14,Report!E19<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K19)=\"O\",Report!C19=\"Client\"),Report!K19,IF(AND(LEFT(Report!C19)=\"O\",Report!K19=\"Client\"),Report!C19,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K19)=\"O\",Report!C19=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C19)=\"O\",Report!K19=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",DATEVALUE(Report!D19))","v":"2020-12-18"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",IF(Report!E19=0,\"00:00-00:59\",IF(Report!E19=1,\"01:00-01:59\",IF(Report!E19=2,\"02:00-02:59\",IF(Report!E19=3,\"03:00-03:59\",IF(Report!E19=4,\"04:00-04:59\",IF(Report!E19=5,\"05:00-05:59\",IF(Report!E19=6,\"06:00-06:59\",IF(Report!E19=7,\"07:00-07:59\",IF(Report!E19=8,\"08:00-08:59\",IF(Report!E19=9,\"09:00-09:59\",Report!E19&\":00-\"&Report!E19&\":59\")))))))))))","v":"09:00-09:59"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",DATEVALUE(LEFT(Report!F19,10))+TIMEVALUE(RIGHT(Report!F19,8)))","v":"2020-12-18T09:28:26"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",DATEVALUE(LEFT(Report!G19,10))+TIMEVALUE(RIGHT(Report!G19,8)))","v":"2020-12-18T09:31:19"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",TIMEVALUE(RIGHT(Report!H19,8)))","v":"00:02:53"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K19)=\"O\",Report!C19=\"Client\"),Report!B19,IF(AND(LEFT(Report!C19)=\"O\",Report!K19=\"Client\"),Report!J19,\"\"))","v":"X20"},{"$f":"IF(AND(LEFT(Report!K19)=\"O\",Report!C19=\"Client\"),Report!A19,IF(AND(LEFT(Report!C19)=\"O\",Report!K19=\"Client\"),Report!I19,\"\"))","v":"Пакет"},"Саморезы","1"]
[{"$f":"IF(E20=\"\",\"\",IF(OR(Report!E20>=22,Report!E20<=5),\"утро\",IF(AND(Report!E20>=6,Report!E20<=13),\"день\",IF(AND(Report!E20>=14,Report!E20<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K20)=\"O\",Report!C20=\"Client\"),Report!K20,IF(AND(LEFT(Report!C20)=\"O\",Report!K20=\"Client\"),Report!C20,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K20)=\"O\",Report!C20=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C20)=\"O\",Report!K20=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",DATEVALUE(Report!D20))","v":"2020-12-18"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",IF(Report!E20=0,\"00:00-00:59\",IF(Report!E20=1,\"01:00-01:59\",IF(Report!E20=2,\"02:00-02:59\",IF(Report!E20=3,\"03:00-03:59\",IF(Report!E20=4,\"04:00-04:59\",IF(Report!E20=5,\"05:00-05:59\",IF(Report!E20=6,\"06:00-06:59\",IF(Report!E20=7,\"07:00-07:59\",IF(Report!E20=8,\"08:00-08:59\",IF(Report!E20=9,\"09:00-09:59\",Report!E20&\":00-\"&Report!E20&\":59\")))))))))))","v":"10:00-10:59"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",DATEVALUE(LEFT(Report!F20,10))+TIMEVALUE(RIGHT(Report!F20,8)))","v":"2020-12-18T10:47:50"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",DATEVALUE(LEFT(Report!G20,10))+TIMEVALUE(RIGHT(Report!G20,8)))","v":"2020-12-18T10:48:32"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",TIMEVALUE(RIGHT(Report!H20,8)))","v":"00:00:42"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K20)=\"O\",Report!C20=\"Client\"),Report!B20,IF(AND(LEFT(Report!C20)=\"O\",Report!K20=\"Client\"),Report!J20,\"\"))","v":"E58"},{"$f":"IF(AND(LEFT(Report!K20)=\"O\",Report!C20=\"Client\"),Report!A20,IF(AND(LEFT(Report!C20)=\"O\",Report!K20=\"Client\"),Report!I20,\"\"))","v":"Упаковка"},"Гвозди","1"]
[{"$f":"IF(E21=\"\",\"\",IF(OR(Report!E21>=22,Report!E21<=5),\"утро\",IF(AND(Report!E21>=6,Report!E21<=13),\"день\",IF(AND(Report!E21>=14,Report!E21<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K21)=\"O\",Report!C21=\"Client\"),Report!K21,IF(AND(LEFT(Report!C21)=\"O\",Report!K21=\"Client\"),Report!C21,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K21)=\"O\",Report!C21=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C21)=\"O\",Report!K21=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",DATEVALUE(Report!D21))","v":"2020-12-18"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",IF(Report!E21=0,\"00:00-00:59\",IF(Report!E21=1,\"01:00-01:59\",IF(Report!E21=2,\"02:00-02:59\",IF(Report!E21=3,\"03:00-03:59\",IF(Report!E21=4,\"04:00-04:59\",IF(Report!E21=5,\"05:00-05:59\",IF(Report!E21=6,\"06:00-06:59\",IF(Report!E21=7,\"07:00-07:59\",IF(Report!E21=8,\"08:00-08:59\",IF(Report!E21=9,\"09:00-09:59\",Report!E21&\":00-\"&Report!E21&\":59\")))))))))))","v":"11:00-11:59"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",DATEVALUE(LEFT(Report!F21,10))+TIMEVALUE(RIGHT(Report!F21,8)))","v":"2020-12-18T11:28:39"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",DATEVALUE(LEFT(Report!G21,10))+TIMEVALUE(RIGHT(Report!G21,8)))","v":"2020-12-18T11:28:50"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",TIMEVALUE(RIGHT(Report!H21,8)))","v":"00:00:11"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K21)=\"O\",Report!C21=\"Client\"),Report!B21,IF(AND(LEFT(Report!C21)=\"O\",Report!K21=\"Client\"),Report!J21,\"\"))","v":"X30"},{"$f":"IF(AND(LEFT(Report!K21)=\"O\",Report!C21=\"Client\"),Report!A21,IF(AND(LEFT(Report!C21)=\"O\",Report!K21=\"Client\"),Report!I21,\"\"))","v":"Коробка"},"Саморезы","1"]
[{"$f":"IF(E22=\"\",\"\",IF(OR(Report!E22>=22,Report!E22<=5),\"утро\",IF(AND(Report!E22>=6,Report!E22<=13),\"день\",IF(AND(Report!E22>=14,Report!E22<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K22)=\"O\",Report!C22=\"Client\"),Report!K22,IF(AND(LEFT(Report!C22)=\"O\",Report!K22=\"Client\"),Report!C22,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K22)=\"O\",Report!C22=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C22)=\"O\",Report!K22=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",DATEVALUE(Report!D22))","v":"2020-12-18"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",IF(Report!E22=0,\"00:00-00:59\",IF(Report!E22=1,\"01:00-01:59\",IF(Report!E22=2,\"02:00-02:59\",IF(Report!E22=3,\"03:00-03:59\",IF(Report!E22=4,\"04:00-04:59\",IF(Report!E22=5,\"05:00-05:59\",IF(Report!E22=6,\"06:00-06:59\",IF(Report!E22=7,\"07:00-07:59\",IF(Report!E22=8,\"08:00-08:59\",IF(Report!E22=9,\"09:00-09:59\",Report!E22&\":00-\"&Report!E22&\":59\")))))))))))","v":"11:00-11:59"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",DATEVALUE(LEFT(Report!F22,10))+TIMEVALUE(RIGHT(Report!F22,8)))","v":"2020-12-18T11:20:32"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",DATEVALUE(LEFT(Report!G22,10))+TIMEVALUE(RIGHT(Report!G22,8)))","v":"2020-12-18T11:20:41"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",TIMEVALUE(RIGHT(Report!H22,8)))","v":"00:00:09"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K22)=\"O\",Report!C22=\"Client\"),Report!B22,IF(AND(LEFT(Report!C22)=\"O\",Report!K22=\"Client\"),Report!J22,\"\"))","v":"E65"},{"$f":"IF(AND(LEFT(Report!K22)=\"O\",Report!C22=\"Client\"),Report!A22,IF(AND(LEFT(Report!C22)=\"O\",Report!K22=\"Client\"),Report!I22,\"\"))","v":"Пакет"},"Гвозди","1"]
[{"$f":"IF(E23=\"\",\"\",IF(OR(Report!E23>=22,Report!E23<=5),\"утро\",IF(AND(Report!E23>=6,Report!E23<=13),\"день\",IF(AND(Report!E23>=14,Report!E23<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K23)=\"O\",Report!C23=\"Client\"),Report!K23,IF(AND(LEFT(Report!C23)=\"O\",Report!K23=\"Client\"),Report!C23,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K23)=\"O\",Report!C23=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C23)=\"O\",Report!K23=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",DATEVALUE(Report!D23))","v":"2020-12-18"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",IF(Report!E23=0,\"00:00-00:59\",IF(Report!E23=1,\"01:00-01:59\",IF(Report!E23=2,\"02:00-02:59\",IF(Report!E23=3,\"03:00-03:59\",IF(Report!E23=4,\"04:00-04:59\",IF(Report!E23=5,\"05:00-05:59\",IF(Report!E23=6,\"06:00-06:59\",IF(Report!E23=7,\"07:00-07:59\",IF(Report!E23=8,\"08:00-08:59\",IF(Report!E23=9,\"09:00-09:59\",Report!E23&\":00-\"&Report!E23&\":59\")))))))))))","v":"11:00-11:59"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",DATEVALUE(LEFT(Report!F23,10))+TIMEVALUE(RIGHT(Report!F23,8)))","v":"2020-12-18T11:00:58"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",DATEVALUE(LEFT(Report!G23,10))+TIMEVALUE(RIGHT(Report!G23,8)))","v":"2020-12-18T11:01:16"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",TIMEVALUE(RIGHT(Report!H23,8)))","v":"00:00:18"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K23)=\"O\",Report!C23=\"Client\"),Report!B23,IF(AND(LEFT(Report!C23)=\"O\",Report!K23=\"Client\"),Report!J23,\"\"))","v":"X92"},{"$f":"IF(AND(LEFT(Report!K23)=\"O\",Report!C23=\"Client\"),Report!A23,IF(AND(LEFT(Report!C23)=\"O\",Report!K23=\"Client\"),Report!I23,\"\"))","v":"Упаковка"},"Саморезы","1"]
[{"$f":"IF(E24=\"\",\"\",IF(OR(Report!E24>=22,Report!E24<=5),\"утро\",IF(AND(Report!E24>=6,Report!E24<=13),\"день\",IF(AND(Report!E24>=14,Report!E24<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K24)=\"O\",Report!C24=\"Client\"),Report!K24,IF(AND(LEFT(Report!C24)=\"O\",Report!K24=\"Client\"),Report!C24,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K24)=\"O\",Report!C24=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C24)=\"O\",Report!K24=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",DATEVALUE(Report!D24))","v":"2020-12-18"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",IF(Report!E24=0,\"00:00-00:59\",IF(Report!E24=1,\"01:00-01:59\",IF(Report!E24=2,\"02:00-02:59\",IF(Report!E24=3,\"03:00-03:59\",IF(Report!E24=4,\"04:00-04:59\",IF(Report!E24=5,\"05:00-05:59\",IF(Report!E24=6,\"06:00-06:59\",IF(Report!E24=7,\"07:00-07:59\",IF(Report!E24=8,\"08:00-08:59\",IF(Report!E24=9,\"09:00-09:59\",Report!E24&\":00-\"&Report!E24&\":59\")))))))))))","v":"11:00-11:59"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",DATEVALUE(LEFT(Report!F24,10))+TIMEVALUE(RIGHT(Report!F24,8)))","v":"2020-12-18T11:28:35"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",DATEVALUE(LEFT(Report!G24,10))+TIMEVALUE(RIGHT(Report!G24,8)))","v":"2020-12-18T11:28:37"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",TIMEVALUE(RIGHT(Report!H24,8)))","v":"00:00:02"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K24)=\"O\",Report!C24=\"Client\"),Report!B24,IF(AND(LEFT(Report!C24)=\"O\",Report!K24=\"Client\"),Report!J24,\"\"))","v":"E12"},{"$f":"IF(AND(LEFT(Report!K24)=\"O\",Report!C24=\"Client\"),Report!A24,IF(AND(LEFT(Report!C24)=\"O\",Report!K24=\"Client\"),Report!I24,\"\"))","v":"Коробка"},"Гвозди","1"]
[{"$f":"IF(E25=\"\",\"\",IF(OR(Report!E25>=22,Report!E25<=5),\"утро\",IF(AND(Report!E25>=6,Report!E25<=13),\"день\",IF(AND(Report!E25>=14,Report!E25<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K25)=\"O\",Report!C25=\"Client\"),Report!K25,IF(AND(LEFT(Report!C25)=\"O\",Report!K25=\"Client\"),Report!C25,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K25)=\"O\",Report!C25=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C25)=\"O\",Report!K25=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",DATEVALUE(Report!D25))","v":"2020-12-18"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",IF(Report!E25=0,\"00:00-00:59\",IF(Report!E25=1,\"01:00-01:59\",IF(Report!E25=2,\"02:00-02:59\",IF(Report!E25=3,\"03:00-03:59\",IF(Report!E25=4,\"04:00-04:59\",IF(Report!E25=5,\"05:00-05:59\",IF(Report!E25=6,\"06:00-06:59\",IF(Report!E25=7,\"07:00-07:59\",IF(Report!E25=8,\"08:00-08:59\",IF(Report!E25=9,\"09:00-09:59\",Report!E25&\":00-\"&Report!E25&\":59\")))))))))))","v":"12:00-12:59"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",DATEVALUE(LEFT(Report!F25,10))+TIMEVALUE(RIGHT(Report!F25,8)))","v":"2020-12-18T12:01:15"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",DATEVALUE(LEFT(Report!G25,10))+TIMEVALUE(RIGHT(Report!G25,8)))","v":"2020-12-18T12:01:30"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",TIMEVALUE(RIGHT(Report!H25,8)))","v":"00:00:15"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K25)=\"O\",Report!C25=\"Client\"),Report!B25,IF(AND(LEFT(Report!C25)=\"O\",Report!K25=\"Client\"),Report!J25,\"\"))","v":"X20"},{"$f":"IF(AND(LEFT(Report!K25)=\"O\",Report!C25=\"Client\"),Report!A25,IF(AND(LEFT(Report!C25)=\"O\",Report!K25=\"Client\"),Report!I25,\"\"))","v":"Пакет"},"Саморезы","1"]
[{"$f":"IF(E26=\"\",\"\",IF(OR(Report!E26>=22,Report!E26<=5),\"утро\",IF(AND(Report!E26>=6,Report!E26<=13),\"день\",IF(AND(Report!E26>=14,Report!E26<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K26)=\"O\",Report!C26=\"Client\"),Report!K26,IF(AND(LEFT(Report!C26)=\"O\",Report!K26=\"Client\"),Report!C26,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K26)=\"O\",Report!C26=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C26)=\"O\",Report!K26=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",DATEVALUE(Report!D26))","v":""},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",IF(Report!E26=0,\"00:00-00:59\",IF(Report!E26=1,\"01:00-01:59\",IF(Report!E26=2,\"02:00-02:59\",IF(Report!E26=3,\"03:00-03:59\",IF(Report!E26=4,\"04:00-04:59\",IF(Report!E26=5,\"05:00-05:59\",IF(Report!E26=6,\"06:00-06:59\",IF(Report!E26=7,\"07:00-07:59\",IF(Report!E26=8,\"08:00-08:59\",IF(Report!E26=9,\"09:00-09:59\",Report!E26&\":00-\"&Report!E26&\":59\")))))))))))","v":""},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",DATEVALUE(LEFT(Report!F26,10))+TIMEVALUE(RIGHT(Report!F26,8)))","v":""},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",DATEVALUE(LEFT(Report!G26,10))+TIMEVALUE(RIGHT(Report!G26,8)))","v":""},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",TIMEVALUE(RIGHT(Report!H26,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K26)=\"O\",Report!C26=\"Client\"),Report!B26,IF(AND(LEFT(Report!C26)=\"O\",Report!K26=\"Client\"),Report!J26,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K26)=\"O\",Report!C26=\"Client\"),Report!A26,IF(AND(LEFT(Report!C26)=\"O\",Report!K26=\"Client\"),Report!I26,\"\"))","v":""},"",""]
[{"$f":"IF(E27=\"\",\"\",IF(OR(Report!E27>=22,Report!E27<=5),\"утро\",IF(AND(Report!E27>=6,Report!E27<=13),\"день\",IF(AND(Report!E27>=14,Report!E27<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K27)=\"O\",Report!C27=\"Client\"),Report!K27,IF(AND(LEFT(Report!C27)=\"O\",Report!K27=\"Client\"),Report!C27,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K27)=\"O\",Report!C27=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C27)=\"O\",Report!K27=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",DATEVALUE(Report!D27))","v":""},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",IF(Report!E27=0,\"00:00-00:59\",IF(Report!E27=1,\"01:00-01:59\",IF(Report!E27=2,\"02:00-02:59\",IF(Report!E27=3,\"03:00-03:59\",IF(Report!E27=4,\"04:00-04:59\",IF(Report!E27=5,\"05:00-05:59\",IF(Report!E27=6,\"06:00-06:59\",IF(Report!E27=7,\"07:00-07:59\",IF(Report!E27=8,\"08:00-08:59\",IF(Report!E27=9,\"09:00-09:59\",Report!E27&\":00-\"&Report!E27&\":59\")))))))))))","v":""},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",DATEVALUE(LEFT(Report!F27,10))+TIMEVALUE(RIGHT(Report!F27,8)))","v":""},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",DATEVALUE(LEFT(Report!G27,10))+TIMEVALUE(RIGHT(Report!G27,8)))","v":""},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",TIMEVALUE(RIGHT(Report!H27,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K27)=\"O\",Report!C27=\"Client\"),Report!B27,IF(AND(LEFT(Report!C27)=\"O\",Report!K27=\"Client\"),Report!J27,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K27)=\"O\",Report!C27=\"Client\"),Report!A27,IF(AND(LEFT(Report!C27)=\"O\",Report!K27=\"Client\"),Report!I27,\"\"))","v":""},"",""]
[{"$f":"IF(E28=\"\",\"\",IF(OR(Report!E28>=22,Report!E28<=5),\"утро\",IF(AND(Report!E28>=6,Report!E28<=13),\"день\",IF(AND(Report!E28>=14,Report!E28<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K28)=\"O\",Report!C28=\"Client\"),Report!K28,IF(AND(LEFT(Report!C28)=\"O\",Report!K28=\"Client\"),Report!C28,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K28)=\"O\",Report!C28=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C28)=\"O\",Report!K28=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",DATEVALUE(Report!D28))","v":"2020-12-18"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",IF(Report!E28=0,\"00:00-00:59\",IF(Report!E28=1,\"01:00-01:59\",IF(Report!E28=2,\"02:00-02:59\",IF(Report!E28=3,\"03:00-03:59\",IF(Report!E28=4,\"04:00-04:59\",IF(Report!E28=5,\"05:00-05:59\",IF(Report!E28=6,\"06:00-06:59\",IF(Report!E28=7,\"07:00-07:59\",IF(Report!E28=8,\"08:00-08:59\",IF(Report!E28=9,\"09:00-09:59\",Report!E28&\":00-\"&Report!E28&\":59\")))))))))))","v":"12:00-12:59"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",DATEVALUE(LEFT(Report!F28,10))+TIMEVALUE(RIGHT(Report!F28,8)))","v":"2020-12-18T12:05:00"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",DATEVALUE(LEFT(Report!G28,10))+TIMEVALUE(RIGHT(Report!G28,8)))","v":"2020-12-18T12:05:14"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",TIMEVALUE(RIGHT(Report!H28,8)))","v":"00:00:14"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K28)=\"O\",Report!C28=\"Client\"),Report!B28,IF(AND(LEFT(Report!C28)=\"O\",Report!K28=\"Client\"),Report!J28,\"\"))","v":"E65"},{"$f":"IF(AND(LEFT(Report!K28)=\"O\",Report!C28=\"Client\"),Report!A28,IF(AND(LEFT(Report!C28)=\"O\",Report!K28=\"Client\"),Report!I28,\"\"))","v":"Пакет"},"Гвозди","1"]
[{"$f":"IF(E29=\"\",\"\",IF(OR(Report!E29>=22,Report!E29<=5),\"утро\",IF(AND(Report!E29>=6,Report!E29<=13),\"день\",IF(AND(Report!E29>=14,Report!E29<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K29)=\"O\",Report!C29=\"Client\"),Report!K29,IF(AND(LEFT(Report!C29)=\"O\",Report!K29=\"Client\"),Report!C29,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K29)=\"O\",Report!C29=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C29)=\"O\",Report!K29=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",DATEVALUE(Report!D29))","v":""},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",IF(Report!E29=0,\"00:00-00:59\",IF(Report!E29=1,\"01:00-01:59\",IF(Report!E29=2,\"02:00-02:59\",IF(Report!E29=3,\"03:00-03:59\",IF(Report!E29=4,\"04:00-04:59\",IF(Report!E29=5,\"05:00-05:59\",IF(Report!E29=6,\"06:00-06:59\",IF(Report!E29=7,\"07:00-07:59\",IF(Report!E29=8,\"08:00-08:59\",IF(Report!E29=9,\"09:00-09:59\",Report!E29&\":00-\"&Report!E29&\":59\")))))))))))","v":""},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",DATEVALUE(LEFT(Report!F29,10))+TIMEVALUE(RIGHT(Report!F29,8)))","v":""},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",DATEVALUE(LEFT(Report!G29,10))+TIMEVALUE(RIGHT(Report!G29,8)))","v":""},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",TIMEVALUE(RIGHT(Report!H29,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K29)=\"O\",Report!C29=\"Client\"),Report!B29,IF(AND(LEFT(Report!C29)=\"O\",Report!K29=\"Client\"),Report!J29,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K29)=\"O\",Report!C29=\"Client\"),Report!A29,IF(AND(LEFT(Report!C29)=\"O\",Report!K29=\"Client\"),Report!I29,\"\"))","v":""},"",""]
[{"$f":"IF(E30=\"\",\"\",IF(OR(Report!E30>=22,Report!E30<=5),\"утро\",IF(AND(Report!E30>=6,Report!E30<=13),\"день\",IF(AND(Report!E30>=14,Report!E30<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K30)=\"O\",Report!C30=\"Client\"),Report!K30,IF(AND(LEFT(Report!C30)=\"O\",Report!K30=\"Client\"),Report!C30,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K30)=\"O\",Report!C30=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C30)=\"O\",Report!K30=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C30=\"\",K30=\"\"),\"\",DATEVALUE(Report!D30))","v":"2020-12-18"},{"$f":"IF(AND(C30=\"\",K30=\"\"),\"\",IF(Report!E30=0,\"00:00-00:59\",IF(Report!E30=1,\"01:00-01:59\",IF(Report!E30=2,\"02:00-02:59\",IF(Report!E30=3,\"03:00-03:59\",IF(Report!E30=4,\"04:00-04:59\",IF(Report!E30=5,\"05:00-05:59\",IF(Report!E30=6,\"06:00-06:59\",IF(Report!E30=7,\"07:00-07:59\",IF(Report!E30=8,\"08:00-08:59\",IF(Report!E30=9,\"09:00-09:59\",Report!E30&\":00-\"&Report!E30&\":59\")))))))))))","v":"12:00-12:59"},{"$f":"IF(AND(C30=\"\",K30=\"\"),\"\",DATEVALUE(LEFT(Report!F30,10))+TIMEVALUE(RIGHT(Report!F30,8)))","v":"2020-12-18T12:41:45"},{"$f":"IF(AND(C30=\"\",K30=\"\"),\"\",DATEVALUE(LEFT(Report!G30,10))+TIMEVALUE(RIGHT(Report!G30,8)))","v":"2020-12-18T12:41:47"},{"$f":"IF(AND(C30=\"\",K30=\"\"),\"\",TIMEVALUE(RIGHT(Report!H30,8)))","v":"00:00:02"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K30)=\"O\",Report!C30=\"Client\"),Report!B30,IF(AND(LEFT(Report!C30)=\"O\",Report!K30=\"Client\"),Report!J30,\"\"))","v":"E12"},{"$f":"IF(AND(LEFT(Report!K30)=\"O\",Report!C30=\"Client\"),Report!A30,IF(AND(LEFT(Report!C30)=\"O\",Report!K30=\"Client\"),Report!I30,\"\"))","v":"Коробка"},"Гвозди","1"]
[{"$f":"IF(E31=\"\",\"\",IF(OR(Report!E31>=22,Report!E31<=5),\"утро\",IF(AND(Report!E31>=6,Report!E31<=13),\"день\",IF(AND(Report!E31>=14,Report!E31<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K31)=\"O\",Report!C31=\"Client\"),Report!K31,IF(AND(LEFT(Report!C31)=\"O\",Report!K31=\"Client\"),Report!C31,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K31)=\"O\",Report!C31=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C31)=\"O\",Report!K31=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C31=\"\",K31=\"\"),\"\",DATEVALUE(Report!D31))","v":"2020-12-18"},{"$f":"IF(AND(C31=\"\",K31=\"\"),\"\",IF(Report!E31=0,\"00:00-00:59\",IF(Report!E31=1,\"01:00-01:59\",IF(Report!E31=2,\"02:00-02:59\",IF(Report!E31=3,\"03:00-03:59\",IF(Report!E31=4,\"04:00-04:59\",IF(Report!E31=5,\"05:00-05:59\",IF(Report!E31=6,\"06:00-06:59\",IF(Report!E31=7,\"07:00-07:59\",IF(Report!E31=8,\"08:00-08:59\",IF(Report!E31=9,\"09:00-09:59\",Report!E31&\":00-\"&Report!E31&\":59\")))))))))))","v":"12:00-12:59"},{"$f":"IF(AND(C31=\"\",K31=\"\"),\"\",DATEVALUE(LEFT(Report!F31,10))+TIMEVALUE(RIGHT(Report!F31,8)))","v":"2020-12-18T12:47:28"},{"$f":"IF(AND(C31=\"\",K31=\"\"),\"\",DATEVALUE(LEFT(Report!G31,10))+TIMEVALUE(RIGHT(Report!G31,8)))","v":"2020-12-18T12:47:40"},{"$f":"IF(AND(C31=\"\",K31=\"\"),\"\",TIMEVALUE(RIGHT(Report!H31,8)))","v":"00:00:12"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K31)=\"O\",Report!C31=\"Client\"),Report!B31,IF(AND(LEFT(Report!C31)=\"O\",Report!K31=\"Client\"),Report!J31,\"\"))","v":"X20"},{"$f":"IF(AND(LEFT(Report!K31)=\"O\",Report!C31=\"Client\"),Report!A31,IF(AND(LEFT(Report!C31)=\"O\",Report!K31=\"Client\"),Report!I31,\"\"))","v":"Пакет"},"Саморезы","1"]
[{"$f":"IF(E32=\"\",\"\",IF(OR(Report!E32>=22,Report!E32<=5),\"утро\",IF(AND(Report!E32>=6,Report!E32<=13),\"день\",IF(AND(Report!E32>=14,Report!E32<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K32)=\"O\",Report!C32=\"Client\"),Report!K32,IF(AND(LEFT(Report!C32)=\"O\",Report!K32=\"Client\"),Report!C32,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K32)=\"O\",Report!C32=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C32)=\"O\",Report!K32=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C32=\"\",K32=\"\"),\"\",DATEVALUE(Report!D32))","v":""},{"$f":"IF(AND(C32=\"\",K32=\"\"),\"\",IF(Report!E32=0,\"00:00-00:59\",IF(Report!E32=1,\"01:00-01:59\",IF(Report!E32=2,\"02:00-02:59\",IF(Report!E32=3,\"03:00-03:59\",IF(Report!E32=4,\"04:00-04:59\",IF(Report!E32=5,\"05:00-05:59\",IF(Report!E32=6,\"06:00-06:59\",IF(Report!E32=7,\"07:00-07:59\",IF(Report!E32=8,\"08:00-08:59\",IF(Report!E32=9,\"09:00-09:59\",Report!E32&\":00-\"&Report!E32&\":59\")))))))))))","v":""},{"$f":"IF(AND(C32=\"\",K32=\"\"),\"\",DATEVALUE(LEFT(Report!F32,10))+TIMEVALUE(RIGHT(Report!F32,8)))","v":""},{"$f":"IF(AND(C32=\"\",K32=\"\"),\"\",DATEVALUE(LEFT(Report!G32,10))+TIMEVALUE(RIGHT(Report!G32,8)))","v":""},{"$f":"IF(AND(C32=\"\",K32=\"\"),\"\",TIMEVALUE(RIGHT(Report!H32,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K32)=\"O\",Report!C32=\"Client\"),Report!B32,IF(AND(LEFT(Report!C32)=\"O\",Report!K32=\"Client\"),Report!J32,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K32)=\"O\",Report!C32=\"Client\"),Report!A32,IF(AND(LEFT(Report!C32)=\"O\",Report!K32=\"Client\"),Report!I32,\"\"))","v":""},"",""]
[{"$f":"IF(E33=\"\",\"\",IF(OR(Report!E33>=22,Report!E33<=5),\"утро\",IF(AND(Report!E33>=6,Report!E33<=13),\"день\",IF(AND(Report!E33>=14,Report!E33<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K33)=\"O\",Report!C33=\"Client\"),Report!K33,IF(AND(LEFT(Report!C33)=\"O\",Report!K33=\"Client\"),Report!C33,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K33)=\"O\",Report!C33=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C33)=\"O\",Report!K33=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C33=\"\",K33=\"\"),\"\",DATEVALUE(Report!D33))","v":""},{"$f":"IF(AND(C33=\"\",K33=\"\"),\"\",IF(Report!E33=0,\"00:00-00:59\",IF(Report!E33=1,\"01:00-01:59\",IF(Report!E33=2,\"02:00-02:59\",IF(Report!E33=3,\"03:00-03:59\",IF(Report!E33=4,\"04:00-04:59\",IF(Report!E33=5,\"05:00-05:59\",IF(Report!E33=6,\"06:00-06:59\",IF(Report!E33=7,\"07:00-07:59\",IF(Report!E33=8,\"08:00-08:59\",IF(Report!E33=9,\"09:00-09:59\",Report!E33&\":00-\"&Report!E33&\":59\")))))))))))","v":""},{"$f":"IF(AND(C33=\"\",K33=\"\"),\"\",DATEVALUE(LEFT(Report!F33,10))+TIMEVALUE(RIGHT(Report!F33,8)))","v":""},{"$f":"IF(AND(C33=\"\",K33=\"\"),\"\",DATEVALUE(LEFT(Report!G33,10))+TIMEVALUE(RIGHT(Report!G33,8)))","v":""},{"$f":"IF(AND(C33=\"\",K33=\"\"),\"\",TIMEVALUE(RIGHT(Report!H33,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K33)=\"O\",Report!C33=\"Client\"),Report!B33,IF(AND(LEFT(Report!C33)=\"O\",Report!K33=\"Client\"),Report!J33,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K33)=\"O\",Report!C33=\"Client\"),Report!A33,IF(AND(LEFT(Report!C33)=\"O\",Report!K33=\"Client\"),Report!I33,\"\"))","v":""},"",""]
[{"$f":"IF(E34=\"\",\"\",IF(OR(Report!E34>=22,Report!E34<=5),\"утро\",IF(AND(Report!E34>=6,Report!E34<=13),\"день\",IF(AND(Report!E34>=14,Report!E34<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K34)=\"O\",Report!C34=\"Client\"),Report!K34,IF(AND(LEFT(Report!C34)=\"O\",Report!K34=\"Client\"),Report!C34,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K34)=\"O\",Report!C34=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C34)=\"O\",Report!K34=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C34=\"\",K34=\"\"),\"\",DATEVALUE(Report!D34))","v":""},{"$f":"IF(AND(C34=\"\",K34=\"\"),\"\",IF(Report!E34=0,\"00:00-00:59\",IF(Report!E34=1,\"01:00-01:59\",IF(Report!E34=2,\"02:00-02:59\",IF(Report!E34=3,\"03:00-03:59\",IF(Report!E34=4,\"04:00-04:59\",IF(Report!E34=5,\"05:00-05:59\",IF(Report!E34=6,\"06:00-06:59\",IF(Report!E34=7,\"07:00-07:59\",IF(Report!E34=8,\"08:00-08:59\",IF(Report!E34=9,\"09:00-09:59\",Report!E34&\":00-\"&Report!E34&\":59\")))))))))))","v":""},{"$f":"IF(AND(C34=\"\",K34=\"\"),\"\",DATEVALUE(LEFT(Report!F34,10))+TIMEVALUE(RIGHT(Report!F34,8)))","v":""},{"$f":"IF(AND(C34=\"\",K34=\"\"),\"\",DATEVALUE(LEFT(Report!G34,10))+TIMEVALUE(RIGHT(Report!G34,8)))","v":""},{"$f":"IF(AND(C34=\"\",K34=\"\"),\"\",TIMEVALUE(RIGHT(Report!H34,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K34)=\"O\",Report!C34=\"Client\"),Report!B34,IF(AND(LEFT(Report!C34)=\"O\",Report!K34=\"Client\"),Report!J34,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K34)=\"O\",Report!C34=\"Client\"),Report!A34,IF(AND(LEFT(Report!C34)=\"O\",Report!K34=\"Client\"),Report!I34,\"\"))","v":""},"",""]
[{"$f":"IF(E35=\"\",\"\",IF(OR(Report!E35>=22,Report!E35<=5),\"утро\",IF(AND(Report!E35>=6,Report!E35<=13),\"день\",IF(AND(Report!E35>=14,Report!E35<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K35)=\"O\",Report!C35=\"Client\"),Report!K35,IF(AND(LEFT(Report!C35)=\"O\",Report!K35=\"Client\"),Report!C35,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K35)=\"O\",Report!C35=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C35)=\"O\",Report!K35=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C35=\"\",K35=\"\"),\"\",DATEVALUE(Report!D35))","v":"2020-12-18"},{"$f":"IF(AND(C35=\"\",K35=\"\"),\"\",IF(Report!E35=0,\"00:00-00:59\",IF(Report!E35=1,\"01:00-01:59\",IF(Report!E35=2,\"02:00-02:59\",IF(Report!E35=3,\"03:00-03:59\",IF(Report!E35=4,\"04:00-04:59\",IF(Report!E35=5,\"05:00-05:59\",IF(Report!E35=6,\"06:00-06:59\",IF(Report!E35=7,\"07:00-07:59\",IF(Report!E35=8,\"08:00-08:59\",IF(Report!E35=9,\"09:00-09:59\",Report!E35&\":00-\"&Report!E35&\":59\")))))))))))","v":"13:00-13:59"},{"$f":"IF(AND(C35=\"\",K35=\"\"),\"\",DATEVALUE(LEFT(Report!F35,10))+TIMEVALUE(RIGHT(Report!F35,8)))","v":"2020-12-18T13:45:01"},{"$f":"IF(AND(C35=\"\",K35=\"\"),\"\",DATEVALUE(LEFT(Report!G35,10))+TIMEVALUE(RIGHT(Report!G35,8)))","v":"2020-12-18T13:45:19"},{"$f":"IF(AND(C35=\"\",K35=\"\"),\"\",TIMEVALUE(RIGHT(Report!H35,8)))","v":"00:00:18"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K35)=\"O\",Report!C35=\"Client\"),Report!B35,IF(AND(LEFT(Report!C35)=\"O\",Report!K35=\"Client\"),Report!J35,\"\"))","v":"X30"},{"$f":"IF(AND(LEFT(Report!K35)=\"O\",Report!C35=\"Client\"),Report!A35,IF(AND(LEFT(Report!C35)=\"O\",Report!K35=\"Client\"),Report!I35,\"\"))","v":"Упаковка"},"Саморезы","1"]
[{"$f":"IF(E36=\"\",\"\",IF(OR(Report!E36>=22,Report!E36<=5),\"утро\",IF(AND(Report!E36>=6,Report!E36<=13),\"день\",IF(AND(Report!E36>=14,Report!E36<=21),\"вечер\",\"\"))))","v":"день"},{"$f":"IF(AND(LEFT(Report!K36)=\"O\",Report!C36=\"Client\"),Report!K36,IF(AND(LEFT(Report!C36)=\"O\",Report!K36=\"Client\"),Report!C36,\"\"))","v":"Operator3"},{"$f":"IF(AND(LEFT(Report!K36)=\"O\",Report!C36=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C36)=\"O\",Report!K36=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C36=\"\",K36=\"\"),\"\",DATEVALUE(Report!D36))","v":"2020-12-18"},{"$f":"IF(AND(C36=\"\",K36=\"\"),\"\",IF(Report!E36=0,\"00:00-00:59\",IF(Report!E36=1,\"01:00-01:59\",IF(Report!E36=2,\"02:00-02:59\",IF(Report!E36=3,\"03:00-03:59\",IF(Report!E36=4,\"04:00-04:59\",IF(Report!E36=5,\"05:00-05:59\",IF(Report!E36=6,\"06:00-06:59\",IF(Report!E36=7,\"07:00-07:59\",IF(Report!E36=8,\"08:00-08:59\",IF(Report!E36=9,\"09:00-09:59\",Report!E36&\":00-\"&Report!E36&\":59\")))))))))))","v":"13:00-13:59"},{"$f":"IF(AND(C36=\"\",K36=\"\"),\"\",DATEVALUE(LEFT(Report!F36,10))+TIMEVALUE(RIGHT(Report!F36,8)))","v":"2020-12-18T13:31:09"},{"$f":"IF(AND(C36=\"\",K36=\"\"),\"\",DATEVALUE(LEFT(Report!G36,10))+TIMEVALUE(RIGHT(Report!G36,8)))","v":"2020-12-18T13:31:14"},{"$f":"IF(AND(C36=\"\",K36=\"\"),\"\",TIMEVALUE(RIGHT(Report!H36,8)))","v":"00:00:05"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K36)=\"O\",Report!C36=\"Client\"),Report!B36,IF(AND(LEFT(Report!C36)=\"O\",Report!K36=\"Client\"),Report!J36,\"\"))","v":"E65"},{"$f":"IF(AND(LEFT(Report!K36)=\"O\",Report!C36=\"Client\"),Report!A36,IF(AND(LEFT(Report!C36)=\"O\",Report!K36=\"Client\"),Report!I36,\"\"))","v":"Коробка"},{"$f":"IF(LEFT(J36)=\"X\",\"Саморезы\",IF(LEFT(J36)=\"E\",\"Гвозди\",\"\"))","v":"Гвозди"},"1"]
[{"$f":"IF(E37=\"\",\"\",IF(OR(Report!E37>=22,Report!E37<=5),\"утро\",IF(AND(Report!E37>=6,Report!E37<=13),\"день\",IF(AND(Report!E37>=14,Report!E37<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K37)=\"O\",Report!C37=\"Client\"),Report!K37,IF(AND(LEFT(Report!C37)=\"O\",Report!K37=\"Client\"),Report!C37,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K37)=\"O\",Report!C37=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C37)=\"O\",Report!K37=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C37=\"\",K37=\"\"),\"\",DATEVALUE(Report!D37))","v":""},{"$f":"IF(AND(C37=\"\",K37=\"\"),\"\",IF(Report!E37=0,\"00:00-00:59\",IF(Report!E37=1,\"01:00-01:59\",IF(Report!E37=2,\"02:00-02:59\",IF(Report!E37=3,\"03:00-03:59\",IF(Report!E37=4,\"04:00-04:59\",IF(Report!E37=5,\"05:00-05:59\",IF(Report!E37=6,\"06:00-06:59\",IF(Report!E37=7,\"07:00-07:59\",IF(Report!E37=8,\"08:00-08:59\",IF(Report!E37=9,\"09:00-09:59\",Report!E37&\":00-\"&Report!E37&\":59\")))))))))))","v":""},{"$f":"IF(AND(C37=\"\",K37=\"\"),\"\",DATEVALUE(LEFT(Report!F37,10))+TIMEVALUE(RIGHT(Report!F37,8)))","v":""},{"$f":"IF(AND(C37=\"\",K37=\"\"),\"\",DATEVALUE(LEFT(Report!G37,10))+TIMEVALUE(RIGHT(Report!G37,8)))","v":""},{"$f":"IF(AND(C37=\"\",K37=\"\"),\"\",TIMEVALUE(RIGHT(Report!H37,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K37)=\"O\",Report!C37=\"Client\"),Report!B37,IF(AND(LEFT(Report!C37)=\"O\",Report!K37=\"Client\"),Report!J37,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K37)=\"O\",Report!C37=\"Client\"),Report!A37,IF(AND(LEFT(Report!C37)=\"O\",Report!K37=\"Client\"),Report!I37,\"\"))","v":""},"",""]
[{"$f":"IF(E38=\"\",\"\",IF(OR(Report!E38>=22,Report!E38<=5),\"утро\",IF(AND(Report!E38>=6,Report!E38<=13),\"день\",IF(AND(Report!E38>=14,Report!E38<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K38)=\"O\",Report!C38=\"Client\"),Report!K38,IF(AND(LEFT(Report!C38)=\"O\",Report!K38=\"Client\"),Report!C38,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K38)=\"O\",Report!C38=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C38)=\"O\",Report!K38=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C38=\"\",K38=\"\"),\"\",DATEVALUE(Report!D38))","v":""},{"$f":"IF(AND(C38=\"\",K38=\"\"),\"\",IF(Report!E38=0,\"00:00-00:59\",IF(Report!E38=1,\"01:00-01:59\",IF(Report!E38=2,\"02:00-02:59\",IF(Report!E38=3,\"03:00-03:59\",IF(Report!E38=4,\"04:00-04:59\",IF(Report!E38=5,\"05:00-05:59\",IF(Report!E38=6,\"06:00-06:59\",IF(Report!E38=7,\"07:00-07:59\",IF(Report!E38=8,\"08:00-08:59\",IF(Report!E38=9,\"09:00-09:59\",Report!E38&\":00-\"&Report!E38&\":59\")))))))))))","v":""},{"$f":"IF(AND(C38=\"\",K38=\"\"),\"\",DATEVALUE(LEFT(Report!F38,10))+TIMEVALUE(RIGHT(Report!F38,8)))","v":""},{"$f":"IF(AND(C38=\"\",K38=\"\"),\"\",DATEVALUE(LEFT(Report!G38,10))+TIMEVALUE(RIGHT(Report!G38,8)))","v":""},{"$f":"IF(AND(C38=\"\",K38=\"\"),\"\",TIMEVALUE(RIGHT(Report!H38,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K38)=\"O\",Report!C38=\"Client\"),Report!B38,IF(AND(LEFT(Report!C38)=\"O\",Report!K38=\"Client\"),Report!J38,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K38)=\"O\",Report!C38=\"Client\"),Report!A38,IF(AND(LEFT(Report!C38)=\"O\",Report!K38=\"Client\"),Report!I38,\"\"))","v":""},"",""]
[{"$f":"IF(E39=\"\",\"\",IF(OR(Report!E39>=22,Report!E39<=5),\"утро\",IF(AND(Report!E39>=6,Report!E39<=13),\"день\",IF(AND(Report!E39>=14,Report!E39<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K39)=\"O\",Report!C39=\"Client\"),Report!K39,IF(AND(LEFT(Report!C39)=\"O\",Report!K39=\"Client\"),Report!C39,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K39)=\"O\",Report!C39=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C39)=\"O\",Report!K39=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C39=\"\",K39=\"\"),\"\",DATEVALUE(Report!D39))","v":""},{"$f":"IF(AND(C39=\"\",K39=\"\"),\"\",IF(Report!E39=0,\"00:00-00:59\",IF(Report!E39=1,\"01:00-01:59\",IF(Report!E39=2,\"02:00-02:59\",IF(Report!E39=3,\"03:00-03:59\",IF(Report!E39=4,\"04:00-04:59\",IF(Report!E39=5,\"05:00-05:59\",IF(Report!E39=6,\"06:00-06:59\",IF(Report!E39=7,\"07:00-07:59\",IF(Report!E39=8,\"08:00-08:59\",IF(Report!E39=9,\"09:00-09:59\",Report!E39&\":00-\"&Report!E39&\":59\")))))))))))","v":""},{"$f":"IF(AND(C39=\"\",K39=\"\"),\"\",DATEVALUE(LEFT(Report!F39,10))+TIMEVALUE(RIGHT(Report!F39,8)))","v":""},{"$f":"IF(AND(C39=\"\",K39=\"\"),\"\",DATEVALUE(LEFT(Report!G39,10))+TIMEVALUE(RIGHT(Report!G39,8)))","v":""},{"$f":"IF(AND(C39=\"\",K39=\"\"),\"\",TIMEVALUE(RIGHT(Report!H39,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K39)=\"O\",Report!C39=\"Client\"),Report!B39,IF(AND(LEFT(Report!C39)=\"O\",Report!K39=\"Client\"),Report!J39,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K39)=\"O\",Report!C39=\"Client\"),Report!A39,IF(AND(LEFT(Report!C39)=\"O\",Report!K39=\"Client\"),Report!I39,\"\"))","v":""},"",""]
[{"$f":"IF(E40=\"\",\"\",IF(OR(Report!E40>=22,Report!E40<=5),\"утро\",IF(AND(Report!E40>=6,Report!E40<=13),\"день\",IF(AND(Report!E40>=14,Report!E40<=21),\"вечер\",\"\"))))","v":"вечер"},{"$f":"IF(AND(LEFT(Report!K40)=\"O\",Report!C40=\"Client\"),Report!K40,IF(AND(LEFT(Report!C40)=\"O\",Report!K40=\"Client\"),Report!C40,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K40)=\"O\",Report!C40=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C40)=\"O\",Report!K40=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C40=\"\",K40=\"\"),\"\",DATEVALUE(Report!D40))","v":"2020-12-18"},{"$f":"IF(AND(C40=\"\",K40=\"\"),\"\",IF(Report!E40=0,\"00:00-00:59\",IF(Report!E40=1,\"01:00-01:59\",IF(Report!E40=2,\"02:00-02:59\",IF(Report!E40=3,\"03:00-03:59\",IF(Report!E40=4,\"04:00-04:59\",IF(Report!E40=5,\"05:00-05:59\",IF(Report!E40=6,\"06:00-06:59\",IF(Report!E40=7,\"07:00-07:59\",IF(Report!E40=8,\"08:00-08:59\",IF(Report!E40=9,\"09:00-09:59\",Report!E40&\":00-\"&Report!E40&\":59\")))))))))))","v":"16:00-16:59"},{"$f":"IF(AND(C40=\"\",K40=\"\"),\"\",DATEVALUE(LEFT(Report!F40,10))+TIMEVALUE(RIGHT(Report!F40,8)))","v":"2020-12-18T16:18:09"},{"$f":"IF(AND(C40=\"\",K40=\"\"),\"\",DATEVALUE(LEFT(Report!G40,10))+TIMEVALUE(RIGHT(Report!G40,8)))","v":"2020-12-18T16:18:15"},{"$f":"IF(AND(C40=\"\",K40=\"\"),\"\",TIMEVALUE(RIGHT(Report!H40,8)))","v":"00:00:06"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K40)=\"O\",Report!C40=\"Client\"),Report!B40,IF(AND(LEFT(Report!C40)=\"O\",Report!K40=\"Client\"),Report!J40,\"\"))","v":"E58"},{"$f":"IF(AND(LEFT(Report!K40)=\"O\",Report!C40=\"Client\"),Report!A40,IF(AND(LEFT(Report!C40)=\"O\",Report!K40=\"Client\"),Report!I40,\"\"))","v":"Пакет"},"Гвозди","1"]
[{"$f":"IF(E41=\"\",\"\",IF(OR(Report!E41>=22,Report!E41<=5),\"утро\",IF(AND(Report!E41>=6,Report!E41<=13),\"день\",IF(AND(Report!E41>=14,Report!E41<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K41)=\"O\",Report!C41=\"Client\"),Report!K41,IF(AND(LEFT(Report!C41)=\"O\",Report!K41=\"Client\"),Report!C41,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K41)=\"O\",Report!C41=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C41)=\"O\",Report!K41=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C41=\"\",K41=\"\"),\"\",DATEVALUE(Report!D41))","v":""},{"$f":"IF(AND(C41=\"\",K41=\"\"),\"\",IF(Report!E41=0,\"00:00-00:59\",IF(Report!E41=1,\"01:00-01:59\",IF(Report!E41=2,\"02:00-02:59\",IF(Report!E41=3,\"03:00-03:59\",IF(Report!E41=4,\"04:00-04:59\",IF(Report!E41=5,\"05:00-05:59\",IF(Report!E41=6,\"06:00-06:59\",IF(Report!E41=7,\"07:00-07:59\",IF(Report!E41=8,\"08:00-08:59\",IF(Report!E41=9,\"09:00-09:59\",Report!E41&\":00-\"&Report!E41&\":59\")))))))))))","v":""},{"$f":"IF(AND(C41=\"\",K41=\"\"),\"\",DATEVALUE(LEFT(Report!F41,10))+TIMEVALUE(RIGHT(Report!F41,8)))","v":""},{"$f":"IF(AND(C41=\"\",K41=\"\"),\"\",DATEVALUE(LEFT(Report!G41,10))+TIMEVALUE(RIGHT(Report!G41,8)))","v":""},{"$f":"IF(AND(C41=\"\",K41=\"\"),\"\",TIMEVALUE(RIGHT(Report!H41,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K41)=\"O\",Report!C41=\"Client\"),Report!B41,IF(AND(LEFT(Report!C41)=\"O\",Report!K41=\"Client\"),Report!J41,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K41)=\"O\",Report!C41=\"Client\"),Report!A41,IF(AND(LEFT(Report!C41)=\"O\",Report!K41=\"Client\"),Report!I41,\"\"))","v":""},"",""]
[{"$f":"IF(E42=\"\",\"\",IF(OR(Report!E42>=22,Report!E42<=5),\"утро\",IF(AND(Report!E42>=6,Report!E42<=13),\"день\",IF(AND(Report!E42>=14,Report!E42<=21),\"вечер\",\"\"))))","v":"вечер"},{"$f":"IF(AND(LEFT(Report!K42)=\"O\",Report!C42=\"Client\"),Report!K42,IF(AND(LEFT(Report!C42)=\"O\",Report!K42=\"Client\"),Report!C42,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K42)=\"O\",Report!C42=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C42)=\"O\",Report!K42=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C42=\"\",K42=\"\"),\"\",DATEVALUE(Report!D42))","v":"2020-12-18"},{"$f":"IF(AND(C42=\"\",K42=\"\"),\"\",IF(Report!E42=0,\"00:00-00:59\",IF(Report!E42=1,\"01:00-01:59\",IF(Report!E42=2,\"02:00-02:59\",IF(Report!E42=3,\"03:00-03:59\",IF(Report!E42=4,\"04:00-04:59\",IF(Report!E42=5,\"05:00-05:59\",IF(Report!E42=6,\"06:00-06:59\",IF(Report!E42=7,\"07:00-07:59\",IF(Report!E42=8,\"08:00-08:59\",IF(Report!E42=9,\"09:00-09:59\",Report!E42&\":00-\"&Report!E42&\":59\")))))))))))","v":"17:00-17:59"},{"$f":"IF(AND(C42=\"\",K42=\"\"),\"\",DATEVALUE(LEFT(Report!F42,10))+TIMEVALUE(RIGHT(Report!F42,8)))","v":"2020-12-18T17:32:17"},{"$f":"IF(AND(C42=\"\",K42=\"\"),\"\",DATEVALUE(LEFT(Report!G42,10))+TIMEVALUE(RIGHT(Report!G42,8)))","v":"2020-12-18T17:32:32"},{"$f":"IF(AND(C42=\"\",K42=\"\"),\"\",TIMEVALUE(RIGHT(Report!H42,8)))","v":"00:00:15"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K42)=\"O\",Report!C42=\"Client\"),Report!B42,IF(AND(LEFT(Report!C42)=\"O\",Report!K42=\"Client\"),Report!J42,\"\"))","v":"E65"},{"$f":"IF(AND(LEFT(Report!K42)=\"O\",Report!C42=\"Client\"),Report!A42,IF(AND(LEFT(Report!C42)=\"O\",Report!K42=\"Client\"),Report!I42,\"\"))","v":"Коробка"},"Гвозди","1"]
[{"$f":"IF(E43=\"\",\"\",IF(OR(Report!E43>=22,Report!E43<=5),\"утро\",IF(AND(Report!E43>=6,Report!E43<=13),\"день\",IF(AND(Report!E43>=14,Report!E43<=21),\"вечер\",\"\"))))","v":"вечер"},{"$f":"IF(AND(LEFT(Report!K43)=\"O\",Report!C43=\"Client\"),Report!K43,IF(AND(LEFT(Report!C43)=\"O\",Report!K43=\"Client\"),Report!C43,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K43)=\"O\",Report!C43=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C43)=\"O\",Report!K43=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C43=\"\",K43=\"\"),\"\",DATEVALUE(Report!D43))","v":"2020-12-18"},{"$f":"IF(AND(C43=\"\",K43=\"\"),\"\",IF(Report!E43=0,\"00:00-00:59\",IF(Report!E43=1,\"01:00-01:59\",IF(Report!E43=2,\"02:00-02:59\",IF(Report!E43=3,\"03:00-03:59\",IF(Report!E43=4,\"04:00-04:59\",IF(Report!E43=5,\"05:00-05:59\",IF(Report!E43=6,\"06:00-06:59\",IF(Report!E43=7,\"07:00-07:59\",IF(Report!E43=8,\"08:00-08:59\",IF(Report!E43=9,\"09:00-09:59\",Report!E43&\":00-\"&Report!E43&\":59\")))))))))))","v":"17:00-17:59"},{"$f":"IF(AND(C43=\"\",K43=\"\"),\"\",DATEVALUE(LEFT(Report!F43,10))+TIMEVALUE(RIGHT(Report!F43,8)))","v":"2020-12-18T17:45:25"},{"$f":"IF(AND(C43=\"\",K43=\"\"),\"\",DATEVALUE(LEFT(Report!G43,10))+TIMEVALUE(RIGHT(Report!G43,8)))","v":"2020-12-18T17:45:49"},{"$f":"IF(AND(C43=\"\",K43=\"\"),\"\",TIMEVALUE(RIGHT(Report!H43,8)))","v":"00:00:24"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K43)=\"O\",Report!C43=\"Client\"),Report!B43,IF(AND(LEFT(Report!C43)=\"O\",Report!K43=\"Client\"),Report!J43,\"\"))","v":"X92"},{"$f":"IF(AND(LEFT(Report!K43)=\"O\",Report!C43=\"Client\"),Report!A43,IF(AND(LEFT(Report!C43)=\"O\",Report!K43=\"Client\"),Report!I43,\"\"))","v":"Пакет"},"Саморезы","1"]
[{"$f":"IF(E44=\"\",\"\",IF(OR(Report!E44>=22,Report!E44<=5),\"утро\",IF(AND(Report!E44>=6,Report!E44<=13),\"день\",IF(AND(Report!E44>=14,Report!E44<=21),\"вечер\",\"\"))))","v":"вечер"},{"$f":"IF(AND(LEFT(Report!K44)=\"O\",Report!C44=\"Client\"),Report!K44,IF(AND(LEFT(Report!C44)=\"O\",Report!K44=\"Client\"),Report!C44,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K44)=\"O\",Report!C44=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C44)=\"O\",Report!K44=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C44=\"\",K44=\"\"),\"\",DATEVALUE(Report!D44))","v":"2020-12-18"},{"$f":"IF(AND(C44=\"\",K44=\"\"),\"\",IF(Report!E44=0,\"00:00-00:59\",IF(Report!E44=1,\"01:00-01:59\",IF(Report!E44=2,\"02:00-02:59\",IF(Report!E44=3,\"03:00-03:59\",IF(Report!E44=4,\"04:00-04:59\",IF(Report!E44=5,\"05:00-05:59\",IF(Report!E44=6,\"06:00-06:59\",IF(Report!E44=7,\"07:00-07:59\",IF(Report!E44=8,\"08:00-08:59\",IF(Report!E44=9,\"09:00-09:59\",Report!E44&\":00-\"&Report!E44&\":59\")))))))))))","v":"17:00-17:59"},{"$f":"IF(AND(C44=\"\",K44=\"\"),\"\",DATEVALUE(LEFT(Report!F44,10))+TIMEVALUE(RIGHT(Report!F44,8)))","v":"2020-12-18T17:37:10"},{"$f":"IF(AND(C44=\"\",K44=\"\"),\"\",DATEVALUE(LEFT(Report!G44,10))+TIMEVALUE(RIGHT(Report!G44,8)))","v":"2020-12-18T17:37:17"},{"$f":"IF(AND(C44=\"\",K44=\"\"),\"\",TIMEVALUE(RIGHT(Report!H44,8)))","v":"00:00:07"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K44)=\"O\",Report!C44=\"Client\"),Report!B44,IF(AND(LEFT(Report!C44)=\"O\",Report!K44=\"Client\"),Report!J44,\"\"))","v":"E12"},{"$f":"IF(AND(LEFT(Report!K44)=\"O\",Report!C44=\"Client\"),Report!A44,IF(AND(LEFT(Report!C44)=\"O\",Report!K44=\"Client\"),Report!I44,\"\"))","v":"Упаковка"},"Гвозди","1"]
[{"$f":"IF(E45=\"\",\"\",IF(OR(Report!E45>=22,Report!E45<=5),\"утро\",IF(AND(Report!E45>=6,Report!E45<=13),\"день\",IF(AND(Report!E45>=14,Report!E45<=21),\"вечер\",\"\"))))","v":"вечер"},{"$f":"IF(AND(LEFT(Report!K45)=\"O\",Report!C45=\"Client\"),Report!K45,IF(AND(LEFT(Report!C45)=\"O\",Report!K45=\"Client\"),Report!C45,\"\"))","v":"Operator4"},{"$f":"IF(AND(LEFT(Report!K45)=\"O\",Report!C45=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C45)=\"O\",Report!K45=\"Client\"),\"Исходящие\",\"\"))","v":"Входящие"},{"$f":"IF(AND(C45=\"\",K45=\"\"),\"\",DATEVALUE(Report!D45))","v":"2020-12-18"},{"$f":"IF(AND(C45=\"\",K45=\"\"),\"\",IF(Report!E45=0,\"00:00-00:59\",IF(Report!E45=1,\"01:00-01:59\",IF(Report!E45=2,\"02:00-02:59\",IF(Report!E45=3,\"03:00-03:59\",IF(Report!E45=4,\"04:00-04:59\",IF(Report!E45=5,\"05:00-05:59\",IF(Report!E45=6,\"06:00-06:59\",IF(Report!E45=7,\"07:00-07:59\",IF(Report!E45=8,\"08:00-08:59\",IF(Report!E45=9,\"09:00-09:59\",Report!E45&\":00-\"&Report!E45&\":59\")))))))))))","v":"17:00-17:59"},{"$f":"IF(AND(C45=\"\",K45=\"\"),\"\",DATEVALUE(LEFT(Report!F45,10))+TIMEVALUE(RIGHT(Report!F45,8)))","v":"2020-12-18T17:58:15"},{"$f":"IF(AND(C45=\"\",K45=\"\"),\"\",DATEVALUE(LEFT(Report!G45,10))+TIMEVALUE(RIGHT(Report!G45,8)))","v":"2020-12-18T17:58:22"},{"$f":"IF(AND(C45=\"\",K45=\"\"),\"\",TIMEVALUE(RIGHT(Report!H45,8)))","v":"00:00:07"},"2020-12-18",{"$f":"IF(AND(LEFT(Report!K45)=\"O\",Report!C45=\"Client\"),Report!B45,IF(AND(LEFT(Report!C45)=\"O\",Report!K45=\"Client\"),Report!J45,\"\"))","v":"X20"},{"$f":"IF(AND(LEFT(Report!K45)=\"O\",Report!C45=\"Client\"),Report!A45,IF(AND(LEFT(Report!C45)=\"O\",Report!K45=\"Client\"),Report!I45,\"\"))","v":"Коробка"},"Саморезы","1"]
[{"$f":"IF(E46=\"\",\"\",IF(OR(Report!E46>=22,Report!E46<=5),\"утро\",IF(AND(Report!E46>=6,Report!E46<=13),\"день\",IF(AND(Report!E46>=14,Report!E46<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K46)=\"O\",Report!C46=\"Client\"),Report!K46,IF(AND(LEFT(Report!C46)=\"O\",Report!K46=\"Client\"),Report!C46,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K46)=\"O\",Report!C46=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C46)=\"O\",Report!K46=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C46=\"\",K46=\"\"),\"\",DATEVALUE(Report!D46))","v":""},{"$f":"IF(AND(C46=\"\",K46=\"\"),\"\",IF(Report!E46=0,\"00:00-00:59\",IF(Report!E46=1,\"01:00-01:59\",IF(Report!E46=2,\"02:00-02:59\",IF(Report!E46=3,\"03:00-03:59\",IF(Report!E46=4,\"04:00-04:59\",IF(Report!E46=5,\"05:00-05:59\",IF(Report!E46=6,\"06:00-06:59\",IF(Report!E46=7,\"07:00-07:59\",IF(Report!E46=8,\"08:00-08:59\",IF(Report!E46=9,\"09:00-09:59\",Report!E46&\":00-\"&Report!E46&\":59\")))))))))))","v":""},{"$f":"IF(AND(C46=\"\",K46=\"\"),\"\",DATEVALUE(LEFT(Report!F46,10))+TIMEVALUE(RIGHT(Report!F46,8)))","v":""},{"$f":"IF(AND(C46=\"\",K46=\"\"),\"\",DATEVALUE(LEFT(Report!G46,10))+TIMEVALUE(RIGHT(Report!G46,8)))","v":""},{"$f":"IF(AND(C46=\"\",K46=\"\"),\"\",TIMEVALUE(RIGHT(Report!H46,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K46)=\"O\",Report!C46=\"Client\"),Report!B46,IF(AND(LEFT(Report!C46)=\"O\",Report!K46=\"Client\"),Report!J46,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K46)=\"O\",Report!C46=\"Client\"),Report!A46,IF(AND(LEFT(Report!C46)=\"O\",Report!K46=\"Client\"),Report!I46,\"\"))","v":""},"",""]
[{"$f":"IF(E47=\"\",\"\",IF(OR(Report!E47>=22,Report!E47<=5),\"утро\",IF(AND(Report!E47>=6,Report!E47<=13),\"день\",IF(AND(Report!E47>=14,Report!E47<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K47)=\"O\",Report!C47=\"Client\"),Report!K47,IF(AND(LEFT(Report!C47)=\"O\",Report!K47=\"Client\"),Report!C47,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K47)=\"O\",Report!C47=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C47)=\"O\",Report!K47=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C47=\"\",K47=\"\"),\"\",DATEVALUE(Report!D47))","v":""},{"$f":"IF(AND(C47=\"\",K47=\"\"),\"\",IF(Report!E47=0,\"00:00-00:59\",IF(Report!E47=1,\"01:00-01:59\",IF(Report!E47=2,\"02:00-02:59\",IF(Report!E47=3,\"03:00-03:59\",IF(Report!E47=4,\"04:00-04:59\",IF(Report!E47=5,\"05:00-05:59\",IF(Report!E47=6,\"06:00-06:59\",IF(Report!E47=7,\"07:00-07:59\",IF(Report!E47=8,\"08:00-08:59\",IF(Report!E47=9,\"09:00-09:59\",Report!E47&\":00-\"&Report!E47&\":59\")))))))))))","v":""},{"$f":"IF(AND(C47=\"\",K47=\"\"),\"\",DATEVALUE(LEFT(Report!F47,10))+TIMEVALUE(RIGHT(Report!F47,8)))","v":""},{"$f":"IF(AND(C47=\"\",K47=\"\"),\"\",DATEVALUE(LEFT(Report!G47,10))+TIMEVALUE(RIGHT(Report!G47,8)))","v":""},{"$f":"IF(AND(C47=\"\",K47=\"\"),\"\",TIMEVALUE(RIGHT(Report!H47,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K47)=\"O\",Report!C47=\"Client\"),Report!B47,IF(AND(LEFT(Report!C47)=\"O\",Report!K47=\"Client\"),Report!J47,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K47)=\"O\",Report!C47=\"Client\"),Report!A47,IF(AND(LEFT(Report!C47)=\"O\",Report!K47=\"Client\"),Report!I47,\"\"))","v":""},"",""]
[{"$f":"IF(E48=\"\",\"\",IF(OR(Report!E48>=22,Report!E48<=5),\"утро\",IF(AND(Report!E48>=6,Report!E48<=13),\"день\",IF(AND(Report!E48>=14,Report!E48<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K48)=\"O\",Report!C48=\"Client\"),Report!K48,IF(AND(LEFT(Report!C48)=\"O\",Report!K48=\"Client\"),Report!C48,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K48)=\"O\",Report!C48=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C48)=\"O\",Report!K48=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C48=\"\",K48=\"\"),\"\",DATEVALUE(Report!D48))","v":""},{"$f":"IF(AND(C48=\"\",K48=\"\"),\"\",IF(Report!E48=0,\"00:00-00:59\",IF(Report!E48=1,\"01:00-01:59\",IF(Report!E48=2,\"02:00-02:59\",IF(Report!E48=3,\"03:00-03:59\",IF(Report!E48=4,\"04:00-04:59\",IF(Report!E48=5,\"05:00-05:59\",IF(Report!E48=6,\"06:00-06:59\",IF(Report!E48=7,\"07:00-07:59\",IF(Report!E48=8,\"08:00-08:59\",IF(Report!E48=9,\"09:00-09:59\",Report!E48&\":00-\"&Report!E48&\":59\")))))))))))","v":""},{"$f":"IF(AND(C48=\"\",K48=\"\"),\"\",DATEVALUE(LEFT(Report!F48,10))+TIMEVALUE(RIGHT(Report!F48,8)))","v":""},{"$f":"IF(AND(C48=\"\",K48=\"\"),\"\",DATEVALUE(LEFT(Report!G48,10))+TIMEVALUE(RIGHT(Report!G48,8)))","v":""},{"$f":"IF(AND(C48=\"\",K48=\"\"),\"\",TIMEVALUE(RIGHT(Report!H48,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K48)=\"O\",Report!C48=\"Client\"),Report!B48,IF(AND(LEFT(Report!C48)=\"O\",Report!K48=\"Client\"),Report!J48,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K48)=\"O\",Report!C48=\"Client\"),Report!A48,IF(AND(LEFT(Report!C48)=\"O\",Report!K48=\"Client\"),Report!I48,\"\"))","v":""},"",""]
[{"$f":"IF(E49=\"\",\"\",IF(OR(Report!E49>=22,Report!E49<=5),\"утро\",IF(AND(Report!E49>=6,Report!E49<=13),\"день\",IF(AND(Report!E49>=14,Report!E49<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K49)=\"O\",Report!C49=\"Client\"),Report!K49,IF(AND(LEFT(Report!C49)=\"O\",Report!K49=\"Client\"),Report!C49,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K49)=\"O\",Report!C49=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C49)=\"O\",Report!K49=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C49=\"\",K49=\"\"),\"\",DATEVALUE(Report!D49))","v":""},{"$f":"IF(AND(C49=\"\",K49=\"\"),\"\",IF(Report!E49=0,\"00:00-00:59\",IF(Report!E49=1,\"01:00-01:59\",IF(Report!E49=2,\"02:00-02:59\",IF(Report!E49=3,\"03:00-03:59\",IF(Report!E49=4,\"04:00-04:59\",IF(Report!E49=5,\"05:00-05:59\",IF(Report!E49=6,\"06:00-06:59\",IF(Report!E49=7,\"07:00-07:59\",IF(Report!E49=8,\"08:00-08:59\",IF(Report!E49=9,\"09:00-09:59\",Report!E49&\":00-\"&Report!E49&\":59\")))))))))))","v":""},{"$f":"IF(AND(C49=\"\",K49=\"\"),\"\",DATEVALUE(LEFT(Report!F49,10))+TIMEVALUE(RIGHT(Report!F49,8)))","v":""},{"$f":"IF(AND(C49=\"\",K49=\"\"),\"\",DATEVALUE(LEFT(Report!G49,10))+TIMEVALUE(RIGHT(Report!G49,8)))","v":""},{"$f":"IF(AND(C49=\"\",K49=\"\"),\"\",TIMEVALUE(RIGHT(Report!H49,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K49)=\"O\",Report!C49=\"Client\"),Report!B49,IF(AND(LEFT(Report!C49)=\"O\",Report!K49=\"Client\"),Report!J49,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K49)=\"O\",Report!C49=\"Client\"),Report!A49,IF(AND(LEFT(Report!C49)=\"O\",Report!K49=\"Client\"),Report!I49,\"\"))","v":""},"",""]
[{"$f":"IF(E50=\"\",\"\",IF(OR(Report!E50>=22,Report!E50<=5),\"утро\",IF(AND(Report!E50>=6,Report!E50<=13),\"день\",IF(AND(Report!E50>=14,Report!E50<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K50)=\"O\",Report!C50=\"Client\"),Report!K50,IF(AND(LEFT(Report!C50)=\"O\",Report!K50=\"Client\"),Report!C50,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K50)=\"O\",Report!C50=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C50)=\"O\",Report!K50=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C50=\"\",K50=\"\"),\"\",DATEVALUE(Report!D50))","v":""},{"$f":"IF(AND(C50=\"\",K50=\"\"),\"\",IF(Report!E50=0,\"00:00-00:59\",IF(Report!E50=1,\"01:00-01:59\",IF(Report!E50=2,\"02:00-02:59\",IF(Report!E50=3,\"03:00-03:59\",IF(Report!E50=4,\"04:00-04:59\",IF(Report!E50=5,\"05:00-05:59\",IF(Report!E50=6,\"06:00-06:59\",IF(Report!E50=7,\"07:00-07:59\",IF(Report!E50=8,\"08:00-08:59\",IF(Report!E50=9,\"09:00-09:59\",Report!E50&\":00-\"&Report!E50&\":59\")))))))))))","v":""},{"$f":"IF(AND(C50=\"\",K50=\"\"),\"\",DATEVALUE(LEFT(Report!F50,10))+TIMEVALUE(RIGHT(Report!F50,8)))","v":""},{"$f":"IF(AND(C50=\"\",K50=\"\"),\"\",DATEVALUE(LEFT(Report!G50,10))+TIMEVALUE(RIGHT(Report!G50,8)))","v":""},{"$f":"IF(AND(C50=\"\",K50=\"\"),\"\",TIMEVALUE(RIGHT(Report!H50,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K50)=\"O\",Report!C50=\"Client\"),Report!B50,IF(AND(LEFT(Report!C50)=\"O\",Report!K50=\"Client\"),Report!J50,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K50)=\"O\",Report!C50=\"Client\"),Report!A50,IF(AND(LEFT(Report!C50)=\"O\",Report!K50=\"Client\"),Report!I50,\"\"))","v":""},"",""]
[{"$f":"IF(E51=\"\",\"\",IF(OR(Report!E51>=22,Report!E51<=5),\"утро\",IF(AND(Report!E51>=6,Report!E51<=13),\"день\",IF(AND(Report!E51>=14,Report!E51<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K51)=\"O\",Report!C51=\"Client\"),Report!K51,IF(AND(LEFT(Report!C51)=\"O\",Report!K51=\"Client\"),Report!C51,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K51)=\"O\",Report!C51=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C51)=\"O\",Report!K51=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C51=\"\",K51=\"\"),\"\",DATEVALUE(Report!D51))","v":""},{"$f":"IF(AND(C51=\"\",K51=\"\"),\"\",IF(Report!E51=0,\"00:00-00:59\",IF(Report!E51=1,\"01:00-01:59\",IF(Report!E51=2,\"02:00-02:59\",IF(Report!E51=3,\"03:00-03:59\",IF(Report!E51=4,\"04:00-04:59\",IF(Report!E51=5,\"05:00-05:59\",IF(Report!E51=6,\"06:00-06:59\",IF(Report!E51=7,\"07:00-07:59\",IF(Report!E51=8,\"08:00-08:59\",IF(Report!E51=9,\"09:00-09:59\",Report!E51&\":00-\"&Report!E51&\":59\")))))))))))","v":""},{"$f":"IF(AND(C51=\"\",K51=\"\"),\"\",DATEVALUE(LEFT(Report!F51,10))+TIMEVALUE(RIGHT(Report!F51,8)))","v":""},{"$f":"IF(AND(C51=\"\",K51=\"\"),\"\",DATEVALUE(LEFT(Report!G51,10))+TIMEVALUE(RIGHT(Report!G51,8)))","v":""},{"$f":"IF(AND(C51=\"\",K51=\"\"),\"\",TIMEVALUE(RIGHT(Report!H51,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K51)=\"O\",Report!C51=\"Client\"),Report!B51,IF(AND(LEFT(Report!C51)=\"O\",Report!K51=\"Client\"),Report!J51,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K51)=\"O\",Report!C51=\"Client\"),Report!A51,IF(AND(LEFT(Report!C51)=\"O\",Report!K51=\"Client\"),Report!I51,\"\"))","v":""},"",""]
[{"$f":"IF(E52=\"\",\"\",IF(OR(Report!E52>=22,Report!E52<=5),\"утро\",IF(AND(Report!E52>=6,Report!E52<=13),\"день\",IF(AND(Report!E52>=14,Report!E52<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K52)=\"O\",Report!C52=\"Client\"),Report!K52,IF(AND(LEFT(Report!C52)=\"O\",Report!K52=\"Client\"),Report!C52,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K52)=\"O\",Report!C52=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C52)=\"O\",Report!K52=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C52=\"\",K52=\"\"),\"\",DATEVALUE(Report!D52))","v":""},{"$f":"IF(AND(C52=\"\",K52=\"\"),\"\",IF(Report!E52=0,\"00:00-00:59\",IF(Report!E52=1,\"01:00-01:59\",IF(Report!E52=2,\"02:00-02:59\",IF(Report!E52=3,\"03:00-03:59\",IF(Report!E52=4,\"04:00-04:59\",IF(Report!E52=5,\"05:00-05:59\",IF(Report!E52=6,\"06:00-06:59\",IF(Report!E52=7,\"07:00-07:59\",IF(Report!E52=8,\"08:00-08:59\",IF(Report!E52=9,\"09:00-09:59\",Report!E52&\":00-\"&Report!E52&\":59\")))))))))))","v":""},{"$f":"IF(AND(C52=\"\",K52=\"\"),\"\",DATEVALUE(LEFT(Report!F52,10))+TIMEVALUE(RIGHT(Report!F52,8)))","v":""},{"$f":"IF(AND(C52=\"\",K52=\"\"),\"\",DATEVALUE(LEFT(Report!G52,10))+TIMEVALUE(RIGHT(Report!G52,8)))","v":""},{"$f":"IF(AND(C52=\"\",K52=\"\"),\"\",TIMEVALUE(RIGHT(Report!H52,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K52)=\"O\",Report!C52=\"Client\"),Report!B52,IF(AND(LEFT(Report!C52)=\"O\",Report!K52=\"Client\"),Report!J52,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K52)=\"O\",Report!C52=\"Client\"),Report!A52,IF(AND(LEFT(Report!C52)=\"O\",Report!K52=\"Client\"),Report!I52,\"\"))","v":""},"",""]
[{"$f":"IF(E53=\"\",\"\",IF(OR(Report!E53>=22,Report!E53<=5),\"утро\",IF(AND(Report!E53>=6,Report!E53<=13),\"день\",IF(AND(Report!E53>=14,Report!E53<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K53)=\"O\",Report!C53=\"Client\"),Report!K53,IF(AND(LEFT(Report!C53)=\"O\",Report!K53=\"Client\"),Report!C53,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K53)=\"O\",Report!C53=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C53)=\"O\",Report!K53=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C53=\"\",K53=\"\"),\"\",DATEVALUE(Report!D53))","v":""},{"$f":"IF(AND(C53=\"\",K53=\"\"),\"\",IF(Report!E53=0,\"00:00-00:59\",IF(Report!E53=1,\"01:00-01:59\",IF(Report!E53=2,\"02:00-02:59\",IF(Report!E53=3,\"03:00-03:59\",IF(Report!E53=4,\"04:00-04:59\",IF(Report!E53=5,\"05:00-05:59\",IF(Report!E53=6,\"06:00-06:59\",IF(Report!E53=7,\"07:00-07:59\",IF(Report!E53=8,\"08:00-08:59\",IF(Report!E53=9,\"09:00-09:59\",Report!E53&\":00-\"&Report!E53&\":59\")))))))))))","v":""},{"$f":"IF(AND(C53=\"\",K53=\"\"),\"\",DATEVALUE(LEFT(Report!F53,10))+TIMEVALUE(RIGHT(Report!F53,8)))","v":""},{"$f":"IF(AND(C53=\"\",K53=\"\"),\"\",DATEVALUE(LEFT(Report!G53,10))+TIMEVALUE(RIGHT(Report!G53,8)))","v":""},{"$f":"IF(AND(C53=\"\",K53=\"\"),\"\",TIMEVALUE(RIGHT(Report!H53,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K53)=\"O\",Report!C53=\"Client\"),Report!B53,IF(AND(LEFT(Report!C53)=\"O\",Report!K53=\"Client\"),Report!J53,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K53)=\"O\",Report!C53=\"Client\"),Report!A53,IF(AND(LEFT(Report!C53)=\"O\",Report!K53=\"Client\"),Report!I53,\"\"))","v":""},"",""]
[{"$f":"IF(E54=\"\",\"\",IF(OR(Report!E54>=22,Report!E54<=5),\"утро\",IF(AND(Report!E54>=6,Report!E54<=13),\"день\",IF(AND(Report!E54>=14,Report!E54<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K54)=\"O\",Report!C54=\"Client\"),Report!K54,IF(AND(LEFT(Report!C54)=\"O\",Report!K54=\"Client\"),Report!C54,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K54)=\"O\",Report!C54=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C54)=\"O\",Report!K54=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C54=\"\",K54=\"\"),\"\",DATEVALUE(Report!D54))","v":""},{"$f":"IF(AND(C54=\"\",K54=\"\"),\"\",IF(Report!E54=0,\"00:00-00:59\",IF(Report!E54=1,\"01:00-01:59\",IF(Report!E54=2,\"02:00-02:59\",IF(Report!E54=3,\"03:00-03:59\",IF(Report!E54=4,\"04:00-04:59\",IF(Report!E54=5,\"05:00-05:59\",IF(Report!E54=6,\"06:00-06:59\",IF(Report!E54=7,\"07:00-07:59\",IF(Report!E54=8,\"08:00-08:59\",IF(Report!E54=9,\"09:00-09:59\",Report!E54&\":00-\"&Report!E54&\":59\")))))))))))","v":""},{"$f":"IF(AND(C54=\"\",K54=\"\"),\"\",DATEVALUE(LEFT(Report!F54,10))+TIMEVALUE(RIGHT(Report!F54,8)))","v":""},{"$f":"IF(AND(C54=\"\",K54=\"\"),\"\",DATEVALUE(LEFT(Report!G54,10))+TIMEVALUE(RIGHT(Report!G54,8)))","v":""},{"$f":"IF(AND(C54=\"\",K54=\"\"),\"\",TIMEVALUE(RIGHT(Report!H54,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K54)=\"O\",Report!C54=\"Client\"),Report!B54,IF(AND(LEFT(Report!C54)=\"O\",Report!K54=\"Client\"),Report!J54,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K54)=\"O\",Report!C54=\"Client\"),Report!A54,IF(AND(LEFT(Report!C54)=\"O\",Report!K54=\"Client\"),Report!I54,\"\"))","v":""},"",""]
[{"$f":"IF(E55=\"\",\"\",IF(OR(Report!E55>=22,Report!E55<=5),\"утро\",IF(AND(Report!E55>=6,Report!E55<=13),\"день\",IF(AND(Report!E55>=14,Report!E55<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K55)=\"O\",Report!C55=\"Client\"),Report!K55,IF(AND(LEFT(Report!C55)=\"O\",Report!K55=\"Client\"),Report!C55,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K55)=\"O\",Report!C55=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C55)=\"O\",Report!K55=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C55=\"\",K55=\"\"),\"\",DATEVALUE(Report!D55))","v":""},{"$f":"IF(AND(C55=\"\",K55=\"\"),\"\",IF(Report!E55=0,\"00:00-00:59\",IF(Report!E55=1,\"01:00-01:59\",IF(Report!E55=2,\"02:00-02:59\",IF(Report!E55=3,\"03:00-03:59\",IF(Report!E55=4,\"04:00-04:59\",IF(Report!E55=5,\"05:00-05:59\",IF(Report!E55=6,\"06:00-06:59\",IF(Report!E55=7,\"07:00-07:59\",IF(Report!E55=8,\"08:00-08:59\",IF(Report!E55=9,\"09:00-09:59\",Report!E55&\":00-\"&Report!E55&\":59\")))))))))))","v":""},{"$f":"IF(AND(C55=\"\",K55=\"\"),\"\",DATEVALUE(LEFT(Report!F55,10))+TIMEVALUE(RIGHT(Report!F55,8)))","v":""},{"$f":"IF(AND(C55=\"\",K55=\"\"),\"\",DATEVALUE(LEFT(Report!G55,10))+TIMEVALUE(RIGHT(Report!G55,8)))","v":""},{"$f":"IF(AND(C55=\"\",K55=\"\"),\"\",TIMEVALUE(RIGHT(Report!H55,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K55)=\"O\",Report!C55=\"Client\"),Report!B55,IF(AND(LEFT(Report!C55)=\"O\",Report!K55=\"Client\"),Report!J55,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K55)=\"O\",Report!C55=\"Client\"),Report!A55,IF(AND(LEFT(Report!C55)=\"O\",Report!K55=\"Client\"),Report!I55,\"\"))","v":""},"",""]
[{"$f":"IF(E56=\"\",\"\",IF(OR(Report!E56>=22,Report!E56<=5),\"утро\",IF(AND(Report!E56>=6,Report!E56<=13),\"день\",IF(AND(Report!E56>=14,Report!E56<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K56)=\"O\",Report!C56=\"Client\"),Report!K56,IF(AND(LEFT(Report!C56)=\"O\",Report!K56=\"Client\"),Report!C56,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K56)=\"O\",Report!C56=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C56)=\"O\",Report!K56=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C56=\"\",K56=\"\"),\"\",DATEVALUE(Report!D56))","v":""},{"$f":"IF(AND(C56=\"\",K56=\"\"),\"\",IF(Report!E56=0,\"00:00-00:59\",IF(Report!E56=1,\"01:00-01:59\",IF(Report!E56=2,\"02:00-02:59\",IF(Report!E56=3,\"03:00-03:59\",IF(Report!E56=4,\"04:00-04:59\",IF(Report!E56=5,\"05:00-05:59\",IF(Report!E56=6,\"06:00-06:59\",IF(Report!E56=7,\"07:00-07:59\",IF(Report!E56=8,\"08:00-08:59\",IF(Report!E56=9,\"09:00-09:59\",Report!E56&\":00-\"&Report!E56&\":59\")))))))))))","v":""},{"$f":"IF(AND(C56=\"\",K56=\"\"),\"\",DATEVALUE(LEFT(Report!F56,10))+TIMEVALUE(RIGHT(Report!F56,8)))","v":""},{"$f":"IF(AND(C56=\"\",K56=\"\"),\"\",DATEVALUE(LEFT(Report!G56,10))+TIMEVALUE(RIGHT(Report!G56,8)))","v":""},{"$f":"IF(AND(C56=\"\",K56=\"\"),\"\",TIMEVALUE(RIGHT(Report!H56,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K56)=\"O\",Report!C56=\"Client\"),Report!B56,IF(AND(LEFT(Report!C56)=\"O\",Report!K56=\"Client\"),Report!J56,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K56)=\"O\",Report!C56=\"Client\"),Report!A56,IF(AND(LEFT(Report!C56)=\"O\",Report!K56=\"Client\"),Report!I56,\"\"))","v":""},"",""]
[{"$f":"IF(E57=\"\",\"\",IF(OR(Report!E57>=22,Report!E57<=5),\"утро\",IF(AND(Report!E57>=6,Report!E57<=13),\"день\",IF(AND(Report!E57>=14,Report!E57<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K57)=\"O\",Report!C57=\"Client\"),Report!K57,IF(AND(LEFT(Report!C57)=\"O\",Report!K57=\"Client\"),Report!C57,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K57)=\"O\",Report!C57=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C57)=\"O\",Report!K57=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C57=\"\",K57=\"\"),\"\",DATEVALUE(Report!D57))","v":""},{"$f":"IF(AND(C57=\"\",K57=\"\"),\"\",IF(Report!E57=0,\"00:00-00:59\",IF(Report!E57=1,\"01:00-01:59\",IF(Report!E57=2,\"02:00-02:59\",IF(Report!E57=3,\"03:00-03:59\",IF(Report!E57=4,\"04:00-04:59\",IF(Report!E57=5,\"05:00-05:59\",IF(Report!E57=6,\"06:00-06:59\",IF(Report!E57=7,\"07:00-07:59\",IF(Report!E57=8,\"08:00-08:59\",IF(Report!E57=9,\"09:00-09:59\",Report!E57&\":00-\"&Report!E57&\":59\")))))))))))","v":""},{"$f":"IF(AND(C57=\"\",K57=\"\"),\"\",DATEVALUE(LEFT(Report!F57,10))+TIMEVALUE(RIGHT(Report!F57,8)))","v":""},{"$f":"IF(AND(C57=\"\",K57=\"\"),\"\",DATEVALUE(LEFT(Report!G57,10))+TIMEVALUE(RIGHT(Report!G57,8)))","v":""},{"$f":"IF(AND(C57=\"\",K57=\"\"),\"\",TIMEVALUE(RIGHT(Report!H57,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K57)=\"O\",Report!C57=\"Client\"),Report!B57,IF(AND(LEFT(Report!C57)=\"O\",Report!K57=\"Client\"),Report!J57,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K57)=\"O\",Report!C57=\"Client\"),Report!A57,IF(AND(LEFT(Report!C57)=\"O\",Report!K57=\"Client\"),Report!I57,\"\"))","v":""},"",""]
[{"$f":"IF(E58=\"\",\"\",IF(OR(Report!E58>=22,Report!E58<=5),\"утро\",IF(AND(Report!E58>=6,Report!E58<=13),\"день\",IF(AND(Report!E58>=14,Report!E58<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K58)=\"O\",Report!C58=\"Client\"),Report!K58,IF(AND(LEFT(Report!C58)=\"O\",Report!K58=\"Client\"),Report!C58,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K58)=\"O\",Report!C58=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C58)=\"O\",Report!K58=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C58=\"\",K58=\"\"),\"\",DATEVALUE(Report!D58))","v":""},{"$f":"IF(AND(C58=\"\",K58=\"\"),\"\",IF(Report!E58=0,\"00:00-00:59\",IF(Report!E58=1,\"01:00-01:59\",IF(Report!E58=2,\"02:00-02:59\",IF(Report!E58=3,\"03:00-03:59\",IF(Report!E58=4,\"04:00-04:59\",IF(Report!E58=5,\"05:00-05:59\",IF(Report!E58=6,\"06:00-06:59\",IF(Report!E58=7,\"07:00-07:59\",IF(Report!E58=8,\"08:00-08:59\",IF(Report!E58=9,\"09:00-09:59\",Report!E58&\":00-\"&Report!E58&\":59\")))))))))))","v":""},{"$f":"IF(AND(C58=\"\",K58=\"\"),\"\",DATEVALUE(LEFT(Report!F58,10))+TIMEVALUE(RIGHT(Report!F58,8)))","v":""},{"$f":"IF(AND(C58=\"\",K58=\"\"),\"\",DATEVALUE(LEFT(Report!G58,10))+TIMEVALUE(RIGHT(Report!G58,8)))","v":""},{"$f":"IF(AND(C58=\"\",K58=\"\"),\"\",TIMEVALUE(RIGHT(Report!H58,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K58)=\"O\",Report!C58=\"Client\"),Report!B58,IF(AND(LEFT(Report!C58)=\"O\",Report!K58=\"Client\"),Report!J58,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K58)=\"O\",Report!C58=\"Client\"),Report!A58,IF(AND(LEFT(Report!C58)=\"O\",Report!K58=\"Client\"),Report!I58,\"\"))","v":""},"",""]
[{"$f":"IF(E59=\"\",\"\",IF(OR(Report!E59>=22,Report!E59<=5),\"утро\",IF(AND(Report!E59>=6,Report!E59<=13),\"день\",IF(AND(Report!E59>=14,Report!E59<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K59)=\"O\",Report!C59=\"Client\"),Report!K59,IF(AND(LEFT(Report!C59)=\"O\",Report!K59=\"Client\"),Report!C59,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K59)=\"O\",Report!C59=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C59)=\"O\",Report!K59=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C59=\"\",K59=\"\"),\"\",DATEVALUE(Report!D59))","v":""},{"$f":"IF(AND(C59=\"\",K59=\"\"),\"\",IF(Report!E59=0,\"00:00-00:59\",IF(Report!E59=1,\"01:00-01:59\",IF(Report!E59=2,\"02:00-02:59\",IF(Report!E59=3,\"03:00-03:59\",IF(Report!E59=4,\"04:00-04:59\",IF(Report!E59=5,\"05:00-05:59\",IF(Report!E59=6,\"06:00-06:59\",IF(Report!E59=7,\"07:00-07:59\",IF(Report!E59=8,\"08:00-08:59\",IF(Report!E59=9,\"09:00-09:59\",Report!E59&\":00-\"&Report!E59&\":59\")))))))))))","v":""},{"$f":"IF(AND(C59=\"\",K59=\"\"),\"\",DATEVALUE(LEFT(Report!F59,10))+TIMEVALUE(RIGHT(Report!F59,8)))","v":""},{"$f":"IF(AND(C59=\"\",K59=\"\"),\"\",DATEVALUE(LEFT(Report!G59,10))+TIMEVALUE(RIGHT(Report!G59,8)))","v":""},{"$f":"IF(AND(C59=\"\",K59=\"\"),\"\",TIMEVALUE(RIGHT(Report!H59,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K59)=\"O\",Report!C59=\"Client\"),Report!B59,IF(AND(LEFT(Report!C59)=\"O\",Report!K59=\"Client\"),Report!J59,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K59)=\"O\",Report!C59=\"Client\"),Report!A59,IF(AND(LEFT(Report!C59)=\"O\",Report!K59=\"Client\"),Report!I59,\"\"))","v":""},"",""]
[{"$f":"IF(E60=\"\",\"\",IF(OR(Report!E60>=22,Report!E60<=5),\"утро\",IF(AND(Report!E60>=6,Report!E60<=13),\"день\",IF(AND(Report!E60>=14,Report!E60<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K60)=\"O\",Report!C60=\"Client\"),Report!K60,IF(AND(LEFT(Report!C60)=\"O\",Report!K60=\"Client\"),Report!C60,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K60)=\"O\",Report!C60=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C60)=\"O\",Report!K60=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C60=\"\",K60=\"\"),\"\",DATEVALUE(Report!D60))","v":""},{"$f":"IF(AND(C60=\"\",K60=\"\"),\"\",IF(Report!E60=0,\"00:00-00:59\",IF(Report!E60=1,\"01:00-01:59\",IF(Report!E60=2,\"02:00-02:59\",IF(Report!E60=3,\"03:00-03:59\",IF(Report!E60=4,\"04:00-04:59\",IF(Report!E60=5,\"05:00-05:59\",IF(Report!E60=6,\"06:00-06:59\",IF(Report!E60=7,\"07:00-07:59\",IF(Report!E60=8,\"08:00-08:59\",IF(Report!E60=9,\"09:00-09:59\",Report!E60&\":00-\"&Report!E60&\":59\")))))))))))","v":""},{"$f":"IF(AND(C60=\"\",K60=\"\"),\"\",DATEVALUE(LEFT(Report!F60,10))+TIMEVALUE(RIGHT(Report!F60,8)))","v":""},{"$f":"IF(AND(C60=\"\",K60=\"\"),\"\",DATEVALUE(LEFT(Report!G60,10))+TIMEVALUE(RIGHT(Report!G60,8)))","v":""},{"$f":"IF(AND(C60=\"\",K60=\"\"),\"\",TIMEVALUE(RIGHT(Report!H60,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K60)=\"O\",Report!C60=\"Client\"),Report!B60,IF(AND(LEFT(Report!C60)=\"O\",Report!K60=\"Client\"),Report!J60,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K60)=\"O\",Report!C60=\"Client\"),Report!A60,IF(AND(LEFT(Report!C60)=\"O\",Report!K60=\"Client\"),Report!I60,\"\"))","v":""},"",""]
[{"$f":"IF(E61=\"\",\"\",IF(OR(Report!E61>=22,Report!E61<=5),\"утро\",IF(AND(Report!E61>=6,Report!E61<=13),\"день\",IF(AND(Report!E61>=14,Report!E61<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K61)=\"O\",Report!C61=\"Client\"),Report!K61,IF(AND(LEFT(Report!C61)=\"O\",Report!K61=\"Client\"),Report!C61,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K61)=\"O\",Report!C61=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C61)=\"O\",Report!K61=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C61=\"\",K61=\"\"),\"\",DATEVALUE(Report!D61))","v":""},{"$f":"IF(AND(C61=\"\",K61=\"\"),\"\",IF(Report!E61=0,\"00:00-00:59\",IF(Report!E61=1,\"01:00-01:59\",IF(Report!E61=2,\"02:00-02:59\",IF(Report!E61=3,\"03:00-03:59\",IF(Report!E61=4,\"04:00-04:59\",IF(Report!E61=5,\"05:00-05:59\",IF(Report!E61=6,\"06:00-06:59\",IF(Report!E61=7,\"07:00-07:59\",IF(Report!E61=8,\"08:00-08:59\",IF(Report!E61=9,\"09:00-09:59\",Report!E61&\":00-\"&Report!E61&\":59\")))))))))))","v":""},{"$f":"IF(AND(C61=\"\",K61=\"\"),\"\",DATEVALUE(LEFT(Report!F61,10))+TIMEVALUE(RIGHT(Report!F61,8)))","v":""},{"$f":"IF(AND(C61=\"\",K61=\"\"),\"\",DATEVALUE(LEFT(Report!G61,10))+TIMEVALUE(RIGHT(Report!G61,8)))","v":""},{"$f":"IF(AND(C61=\"\",K61=\"\"),\"\",TIMEVALUE(RIGHT(Report!H61,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K61)=\"O\",Report!C61=\"Client\"),Report!B61,IF(AND(LEFT(Report!C61)=\"O\",Report!K61=\"Client\"),Report!J61,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K61)=\"O\",Report!C61=\"Client\"),Report!A61,IF(AND(LEFT(Report!C61)=\"O\",Report!K61=\"Client\"),Report!I61,\"\"))","v":""},"",""]
[{"$f":"IF(E62=\"\",\"\",IF(OR(Report!E62>=22,Report!E62<=5),\"утро\",IF(AND(Report!E62>=6,Report!E62<=13),\"день\",IF(AND(Report!E62>=14,Report!E62<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K62)=\"O\",Report!C62=\"Client\"),Report!K62,IF(AND(LEFT(Report!C62)=\"O\",Report!K62=\"Client\"),Report!C62,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K62)=\"O\",Report!C62=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C62)=\"O\",Report!K62=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C62=\"\",K62=\"\"),\"\",DATEVALUE(Report!D62))","v":""},{"$f":"IF(AND(C62=\"\",K62=\"\"),\"\",IF(Report!E62=0,\"00:00-00:59\",IF(Report!E62=1,\"01:00-01:59\",IF(Report!E62=2,\"02:00-02:59\",IF(Report!E62=3,\"03:00-03:59\",IF(Report!E62=4,\"04:00-04:59\",IF(Report!E62=5,\"05:00-05:59\",IF(Report!E62=6,\"06:00-06:59\",IF(Report!E62=7,\"07:00-07:59\",IF(Report!E62=8,\"08:00-08:59\",IF(Report!E62=9,\"09:00-09:59\",Report!E62&\":00-\"&Report!E62&\":59\")))))))))))","v":""},{"$f":"IF(AND(C62=\"\",K62=\"\"),\"\",DATEVALUE(LEFT(Report!F62,10))+TIMEVALUE(RIGHT(Report!F62,8)))","v":""},{"$f":"IF(AND(C62=\"\",K62=\"\"),\"\",DATEVALUE(LEFT(Report!G62,10))+TIMEVALUE(RIGHT(Report!G62,8)))","v":""},{"$f":"IF(AND(C62=\"\",K62=\"\"),\"\",TIMEVALUE(RIGHT(Report!H62,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K62)=\"O\",Report!C62=\"Client\"),Report!B62,IF(AND(LEFT(Report!C62)=\"O\",Report!K62=\"Client\"),Report!J62,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K62)=\"O\",Report!C62=\"Client\"),Report!A62,IF(AND(LEFT(Report!C62)=\"O\",Report!K62=\"Client\"),Report!I62,\"\"))","v":""},"",""]
[{"$f":"IF(E63=\"\",\"\",IF(OR(Report!E63>=22,Report!E63<=5),\"утро\",IF(AND(Report!E63>=6,Report!E63<=13),\"день\",IF(AND(Report!E63>=14,Report!E63<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K63)=\"O\",Report!C63=\"Client\"),Report!K63,IF(AND(LEFT(Report!C63)=\"O\",Report!K63=\"Client\"),Report!C63,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K63)=\"O\",Report!C63=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C63)=\"O\",Report!K63=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C63=\"\",K63=\"\"),\"\",DATEVALUE(Report!D63))","v":""},{"$f":"IF(AND(C63=\"\",K63=\"\"),\"\",IF(Report!E63=0,\"00:00-00:59\",IF(Report!E63=1,\"01:00-01:59\",IF(Report!E63=2,\"02:00-02:59\",IF(Report!E63=3,\"03:00-03:59\",IF(Report!E63=4,\"04:00-04:59\",IF(Report!E63=5,\"05:00-05:59\",IF(Report!E63=6,\"06:00-06:59\",IF(Report!E63=7,\"07:00-07:59\",IF(Report!E63=8,\"08:00-08:59\",IF(Report!E63=9,\"09:00-09:59\",Report!E63&\":00-\"&Report!E63&\":59\")))))))))))","v":""},{"$f":"IF(AND(C63=\"\",K63=\"\"),\"\",DATEVALUE(LEFT(Report!F63,10))+TIMEVALUE(RIGHT(Report!F63,8)))","v":""},{"$f":"IF(AND(C63=\"\",K63=\"\"),\"\",DATEVALUE(LEFT(Report!G63,10))+TIMEVALUE(RIGHT(Report!G63,8)))","v":""},{"$f":"IF(AND(C63=\"\",K63=\"\"),\"\",TIMEVALUE(RIGHT(Report!H63,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K63)=\"O\",Report!C63=\"Client\"),Report!B63,IF(AND(LEFT(Report!C63)=\"O\",Report!K63=\"Client\"),Report!J63,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K63)=\"O\",Report!C63=\"Client\"),Report!A63,IF(AND(LEFT(Report!C63)=\"O\",Report!K63=\"Client\"),Report!I63,\"\"))","v":""},"",""]
[{"$f":"IF(E64=\"\",\"\",IF(OR(Report!E64>=22,Report!E64<=5),\"утро\",IF(AND(Report!E64>=6,Report!E64<=13),\"день\",IF(AND(Report!E64>=14,Report!E64<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K64)=\"O\",Report!C64=\"Client\"),Report!K64,IF(AND(LEFT(Report!C64)=\"O\",Report!K64=\"Client\"),Report!C64,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K64)=\"O\",Report!C64=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C64)=\"O\",Report!K64=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C64=\"\",K64=\"\"),\"\",DATEVALUE(Report!D64))","v":""},{"$f":"IF(AND(C64=\"\",K64=\"\"),\"\",IF(Report!E64=0,\"00:00-00:59\",IF(Report!E64=1,\"01:00-01:59\",IF(Report!E64=2,\"02:00-02:59\",IF(Report!E64=3,\"03:00-03:59\",IF(Report!E64=4,\"04:00-04:59\",IF(Report!E64=5,\"05:00-05:59\",IF(Report!E64=6,\"06:00-06:59\",IF(Report!E64=7,\"07:00-07:59\",IF(Report!E64=8,\"08:00-08:59\",IF(Report!E64=9,\"09:00-09:59\",Report!E64&\":00-\"&Report!E64&\":59\")))))))))))","v":""},{"$f":"IF(AND(C64=\"\",K64=\"\"),\"\",DATEVALUE(LEFT(Report!F64,10))+TIMEVALUE(RIGHT(Report!F64,8)))","v":""},{"$f":"IF(AND(C64=\"\",K64=\"\"),\"\",DATEVALUE(LEFT(Report!G64,10))+TIMEVALUE(RIGHT(Report!G64,8)))","v":""},{"$f":"IF(AND(C64=\"\",K64=\"\"),\"\",TIMEVALUE(RIGHT(Report!H64,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K64)=\"O\",Report!C64=\"Client\"),Report!B64,IF(AND(LEFT(Report!C64)=\"O\",Report!K64=\"Client\"),Report!J64,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K64)=\"O\",Report!C64=\"Client\"),Report!A64,IF(AND(LEFT(Report!C64)=\"O\",Report!K64=\"Client\"),Report!I64,\"\"))","v":""},"",""]
[{"$f":"IF(E65=\"\",\"\",IF(OR(Report!E65>=22,Report!E65<=5),\"утро\",IF(AND(Report!E65>=6,Report!E65<=13),\"день\",IF(AND(Report!E65>=14,Report!E65<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K65)=\"O\",Report!C65=\"Client\"),Report!K65,IF(AND(LEFT(Report!C65)=\"O\",Report!K65=\"Client\"),Report!C65,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K65)=\"O\",Report!C65=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C65)=\"O\",Report!K65=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C65=\"\",K65=\"\"),\"\",DATEVALUE(Report!D65))","v":""},{"$f":"IF(AND(C65=\"\",K65=\"\"),\"\",IF(Report!E65=0,\"00:00-00:59\",IF(Report!E65=1,\"01:00-01:59\",IF(Report!E65=2,\"02:00-02:59\",IF(Report!E65=3,\"03:00-03:59\",IF(Report!E65=4,\"04:00-04:59\",IF(Report!E65=5,\"05:00-05:59\",IF(Report!E65=6,\"06:00-06:59\",IF(Report!E65=7,\"07:00-07:59\",IF(Report!E65=8,\"08:00-08:59\",IF(Report!E65=9,\"09:00-09:59\",Report!E65&\":00-\"&Report!E65&\":59\")))))))))))","v":""},{"$f":"IF(AND(C65=\"\",K65=\"\"),\"\",DATEVALUE(LEFT(Report!F65,10))+TIMEVALUE(RIGHT(Report!F65,8)))","v":""},{"$f":"IF(AND(C65=\"\",K65=\"\"),\"\",DATEVALUE(LEFT(Report!G65,10))+TIMEVALUE(RIGHT(Report!G65,8)))","v":""},{"$f":"IF(AND(C65=\"\",K65=\"\"),\"\",TIMEVALUE(RIGHT(Report!H65,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K65)=\"O\",Report!C65=\"Client\"),Report!B65,IF(AND(LEFT(Report!C65)=\"O\",Report!K65=\"Client\"),Report!J65,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K65)=\"O\",Report!C65=\"Client\"),Report!A65,IF(AND(LEFT(Report!C65)=\"O\",Report!K65=\"Client\"),Report!I65,\"\"))","v":""},"",""]
[{"$f":"IF(E66=\"\",\"\",IF(OR(Report!E66>=22,Report!E66<=5),\"утро\",IF(AND(Report!E66>=6,Report!E66<=13),\"день\",IF(AND(Report!E66>=14,Report!E66<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K66)=\"O\",Report!C66=\"Client\"),Report!K66,IF(AND(LEFT(Report!C66)=\"O\",Report!K66=\"Client\"),Report!C66,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K66)=\"O\",Report!C66=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C66)=\"O\",Report!K66=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C66=\"\",K66=\"\"),\"\",DATEVALUE(Report!D66))","v":""},{"$f":"IF(AND(C66=\"\",K66=\"\"),\"\",IF(Report!E66=0,\"00:00-00:59\",IF(Report!E66=1,\"01:00-01:59\",IF(Report!E66=2,\"02:00-02:59\",IF(Report!E66=3,\"03:00-03:59\",IF(Report!E66=4,\"04:00-04:59\",IF(Report!E66=5,\"05:00-05:59\",IF(Report!E66=6,\"06:00-06:59\",IF(Report!E66=7,\"07:00-07:59\",IF(Report!E66=8,\"08:00-08:59\",IF(Report!E66=9,\"09:00-09:59\",Report!E66&\":00-\"&Report!E66&\":59\")))))))))))","v":""},{"$f":"IF(AND(C66=\"\",K66=\"\"),\"\",DATEVALUE(LEFT(Report!F66,10))+TIMEVALUE(RIGHT(Report!F66,8)))","v":""},{"$f":"IF(AND(C66=\"\",K66=\"\"),\"\",DATEVALUE(LEFT(Report!G66,10))+TIMEVALUE(RIGHT(Report!G66,8)))","v":""},{"$f":"IF(AND(C66=\"\",K66=\"\"),\"\",TIMEVALUE(RIGHT(Report!H66,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K66)=\"O\",Report!C66=\"Client\"),Report!B66,IF(AND(LEFT(Report!C66)=\"O\",Report!K66=\"Client\"),Report!J66,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K66)=\"O\",Report!C66=\"Client\"),Report!A66,IF(AND(LEFT(Report!C66)=\"O\",Report!K66=\"Client\"),Report!I66,\"\"))","v":""},"",""]
[{"$f":"IF(E67=\"\",\"\",IF(OR(Report!E67>=22,Report!E67<=5),\"утро\",IF(AND(Report!E67>=6,Report!E67<=13),\"день\",IF(AND(Report!E67>=14,Report!E67<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K67)=\"O\",Report!C67=\"Client\"),Report!K67,IF(AND(LEFT(Report!C67)=\"O\",Report!K67=\"Client\"),Report!C67,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K67)=\"O\",Report!C67=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C67)=\"O\",Report!K67=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C67=\"\",K67=\"\"),\"\",DATEVALUE(Report!D67))","v":""},{"$f":"IF(AND(C67=\"\",K67=\"\"),\"\",IF(Report!E67=0,\"00:00-00:59\",IF(Report!E67=1,\"01:00-01:59\",IF(Report!E67=2,\"02:00-02:59\",IF(Report!E67=3,\"03:00-03:59\",IF(Report!E67=4,\"04:00-04:59\",IF(Report!E67=5,\"05:00-05:59\",IF(Report!E67=6,\"06:00-06:59\",IF(Report!E67=7,\"07:00-07:59\",IF(Report!E67=8,\"08:00-08:59\",IF(Report!E67=9,\"09:00-09:59\",Report!E67&\":00-\"&Report!E67&\":59\")))))))))))","v":""},{"$f":"IF(AND(C67=\"\",K67=\"\"),\"\",DATEVALUE(LEFT(Report!F67,10))+TIMEVALUE(RIGHT(Report!F67,8)))","v":""},{"$f":"IF(AND(C67=\"\",K67=\"\"),\"\",DATEVALUE(LEFT(Report!G67,10))+TIMEVALUE(RIGHT(Report!G67,8)))","v":""},{"$f":"IF(AND(C67=\"\",K67=\"\"),\"\",TIMEVALUE(RIGHT(Report!H67,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K67)=\"O\",Report!C67=\"Client\"),Report!B67,IF(AND(LEFT(Report!C67)=\"O\",Report!K67=\"Client\"),Report!J67,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K67)=\"O\",Report!C67=\"Client\"),Report!A67,IF(AND(LEFT(Report!C67)=\"O\",Report!K67=\"Client\"),Report!I67,\"\"))","v":""},"",""]
[{"$f":"IF(E68=\"\",\"\",IF(OR(Report!E68>=22,Report!E68<=5),\"утро\",IF(AND(Report!E68>=6,Report!E68<=13),\"день\",IF(AND(Report!E68>=14,Report!E68<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K68)=\"O\",Report!C68=\"Client\"),Report!K68,IF(AND(LEFT(Report!C68)=\"O\",Report!K68=\"Client\"),Report!C68,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K68)=\"O\",Report!C68=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C68)=\"O\",Report!K68=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C68=\"\",K68=\"\"),\"\",DATEVALUE(Report!D68))","v":""},{"$f":"IF(AND(C68=\"\",K68=\"\"),\"\",IF(Report!E68=0,\"00:00-00:59\",IF(Report!E68=1,\"01:00-01:59\",IF(Report!E68=2,\"02:00-02:59\",IF(Report!E68=3,\"03:00-03:59\",IF(Report!E68=4,\"04:00-04:59\",IF(Report!E68=5,\"05:00-05:59\",IF(Report!E68=6,\"06:00-06:59\",IF(Report!E68=7,\"07:00-07:59\",IF(Report!E68=8,\"08:00-08:59\",IF(Report!E68=9,\"09:00-09:59\",Report!E68&\":00-\"&Report!E68&\":59\")))))))))))","v":""},{"$f":"IF(AND(C68=\"\",K68=\"\"),\"\",DATEVALUE(LEFT(Report!F68,10))+TIMEVALUE(RIGHT(Report!F68,8)))","v":""},{"$f":"IF(AND(C68=\"\",K68=\"\"),\"\",DATEVALUE(LEFT(Report!G68,10))+TIMEVALUE(RIGHT(Report!G68,8)))","v":""},{"$f":"IF(AND(C68=\"\",K68=\"\"),\"\",TIMEVALUE(RIGHT(Report!H68,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K68)=\"O\",Report!C68=\"Client\"),Report!B68,IF(AND(LEFT(Report!C68)=\"O\",Report!K68=\"Client\"),Report!J68,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K68)=\"O\",Report!C68=\"Client\"),Report!A68,IF(AND(LEFT(Report!C68)=\"O\",Report!K68=\"Client\"),Report!I68,\"\"))","v":""},{"$f":"IF(LEFT(J68)=\"X\",\"Саморезы\",IF(LEFT(J68)=\"E\",\"Гвозди\",\"\"))","v":""},""]
[{"$f":"IF(E69=\"\",\"\",IF(OR(Report!E69>=22,Report!E69<=5),\"утро\",IF(AND(Report!E69>=6,Report!E69<=13),\"день\",IF(AND(Report!E69>=14,Report!E69<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K69)=\"O\",Report!C69=\"Client\"),Report!K69,IF(AND(LEFT(Report!C69)=\"O\",Report!K69=\"Client\"),Report!C69,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K69)=\"O\",Report!C69=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C69)=\"O\",Report!K69=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",DATEVALUE(Report!D69))","v":""},{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",IF(Report!E69=0,\"00:00-00:59\",IF(Report!E69=1,\"01:00-01:59\",IF(Report!E69=2,\"02:00-02:59\",IF(Report!E69=3,\"03:00-03:59\",IF(Report!E69=4,\"04:00-04:59\",IF(Report!E69=5,\"05:00-05:59\",IF(Report!E69=6,\"06:00-06:59\",IF(Report!E69=7,\"07:00-07:59\",IF(Report!E69=8,\"08:00-08:59\",IF(Report!E69=9,\"09:00-09:59\",Report!E69&\":00-\"&Report!E69&\":59\")))))))))))","v":""},{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",DATEVALUE(LEFT(Report!F69,10))+TIMEVALUE(RIGHT(Report!F69,8)))","v":""},{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",DATEVALUE(LEFT(Report!G69,10))+TIMEVALUE(RIGHT(Report!G69,8)))","v":""},{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",TIMEVALUE(RIGHT(Report!H69,8)))","v":""},{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",D69)","v":""},{"$f":"IF(AND(LEFT(Report!K69)=\"O\",Report!C69=\"Client\"),Report!B69,IF(AND(LEFT(Report!C69)=\"O\",Report!K69=\"Client\"),Report!J69,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K69)=\"O\",Report!C69=\"Client\"),Report!A69,IF(AND(LEFT(Report!C69)=\"O\",Report!K69=\"Client\"),Report!I69,\"\"))","v":""},"",{"$f":"IF(AND(C69=\"\",K69=\"\"),\"\",\"1\")","v":""}]
[{"$f":"IF(E70=\"\",\"\",IF(OR(Report!E70>=22,Report!E70<=5),\"утро\",IF(AND(Report!E70>=6,Report!E70<=13),\"день\",IF(AND(Report!E70>=14,Report!E70<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K70)=\"O\",Report!C70=\"Client\"),Report!K70,IF(AND(LEFT(Report!C70)=\"O\",Report!K70=\"Client\"),Report!C70,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K70)=\"O\",Report!C70=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C70)=\"O\",Report!K70=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C70=\"\",K70=\"\"),\"\",DATEVALUE(Report!D70))","v":""},{"$f":"IF(AND(C70=\"\",K70=\"\"),\"\",IF(Report!E70=0,\"00:00-00:59\",IF(Report!E70=1,\"01:00-01:59\",IF(Report!E70=2,\"02:00-02:59\",IF(Report!E70=3,\"03:00-03:59\",IF(Report!E70=4,\"04:00-04:59\",IF(Report!E70=5,\"05:00-05:59\",IF(Report!E70=6,\"06:00-06:59\",IF(Report!E70=7,\"07:00-07:59\",IF(Report!E70=8,\"08:00-08:59\",IF(Report!E70=9,\"09:00-09:59\",Report!E70&\":00-\"&Report!E70&\":59\")))))))))))","v":""},{"$f":"IF(AND(C70=\"\",K70=\"\"),\"\",DATEVALUE(LEFT(Report!F70,10))+TIMEVALUE(RIGHT(Report!F70,8)))","v":""},{"$f":"IF(AND(C70=\"\",K70=\"\"),\"\",DATEVALUE(LEFT(Report!G70,10))+TIMEVALUE(RIGHT(Report!G70,8)))","v":""},{"$f":"IF(AND(C70=\"\",K70=\"\"),\"\",TIMEVALUE(RIGHT(Report!H70,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K70)=\"O\",Report!C70=\"Client\"),Report!B70,IF(AND(LEFT(Report!C70)=\"O\",Report!K70=\"Client\"),Report!J70,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K70)=\"O\",Report!C70=\"Client\"),Report!A70,IF(AND(LEFT(Report!C70)=\"O\",Report!K70=\"Client\"),Report!I70,\"\"))","v":""},"",""]
[{"$f":"IF(E71=\"\",\"\",IF(OR(Report!E71>=22,Report!E71<=5),\"утро\",IF(AND(Report!E71>=6,Report!E71<=13),\"день\",IF(AND(Report!E71>=14,Report!E71<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K71)=\"O\",Report!C71=\"Client\"),Report!K71,IF(AND(LEFT(Report!C71)=\"O\",Report!K71=\"Client\"),Report!C71,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K71)=\"O\",Report!C71=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C71)=\"O\",Report!K71=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C71=\"\",K71=\"\"),\"\",DATEVALUE(Report!D71))","v":""},{"$f":"IF(AND(C71=\"\",K71=\"\"),\"\",IF(Report!E71=0,\"00:00-00:59\",IF(Report!E71=1,\"01:00-01:59\",IF(Report!E71=2,\"02:00-02:59\",IF(Report!E71=3,\"03:00-03:59\",IF(Report!E71=4,\"04:00-04:59\",IF(Report!E71=5,\"05:00-05:59\",IF(Report!E71=6,\"06:00-06:59\",IF(Report!E71=7,\"07:00-07:59\",IF(Report!E71=8,\"08:00-08:59\",IF(Report!E71=9,\"09:00-09:59\",Report!E71&\":00-\"&Report!E71&\":59\")))))))))))","v":""},{"$f":"IF(AND(C71=\"\",K71=\"\"),\"\",DATEVALUE(LEFT(Report!F71,10))+TIMEVALUE(RIGHT(Report!F71,8)))","v":""},{"$f":"IF(AND(C71=\"\",K71=\"\"),\"\",DATEVALUE(LEFT(Report!G71,10))+TIMEVALUE(RIGHT(Report!G71,8)))","v":""},{"$f":"IF(AND(C71=\"\",K71=\"\"),\"\",TIMEVALUE(RIGHT(Report!H71,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K71)=\"O\",Report!C71=\"Client\"),Report!B71,IF(AND(LEFT(Report!C71)=\"O\",Report!K71=\"Client\"),Report!J71,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K71)=\"O\",Report!C71=\"Client\"),Report!A71,IF(AND(LEFT(Report!C71)=\"O\",Report!K71=\"Client\"),Report!I71,\"\"))","v":""},"",""]
[{"$f":"IF(E72=\"\",\"\",IF(OR(Report!E72>=22,Report!E72<=5),\"утро\",IF(AND(Report!E72>=6,Report!E72<=13),\"день\",IF(AND(Report!E72>=14,Report!E72<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K72)=\"O\",Report!C72=\"Client\"),Report!K72,IF(AND(LEFT(Report!C72)=\"O\",Report!K72=\"Client\"),Report!C72,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K72)=\"O\",Report!C72=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C72)=\"O\",Report!K72=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C72=\"\",K72=\"\"),\"\",DATEVALUE(Report!D72))","v":""},{"$f":"IF(AND(C72=\"\",K72=\"\"),\"\",IF(Report!E72=0,\"00:00-00:59\",IF(Report!E72=1,\"01:00-01:59\",IF(Report!E72=2,\"02:00-02:59\",IF(Report!E72=3,\"03:00-03:59\",IF(Report!E72=4,\"04:00-04:59\",IF(Report!E72=5,\"05:00-05:59\",IF(Report!E72=6,\"06:00-06:59\",IF(Report!E72=7,\"07:00-07:59\",IF(Report!E72=8,\"08:00-08:59\",IF(Report!E72=9,\"09:00-09:59\",Report!E72&\":00-\"&Report!E72&\":59\")))))))))))","v":""},{"$f":"IF(AND(C72=\"\",K72=\"\"),\"\",DATEVALUE(LEFT(Report!F72,10))+TIMEVALUE(RIGHT(Report!F72,8)))","v":""},{"$f":"IF(AND(C72=\"\",K72=\"\"),\"\",DATEVALUE(LEFT(Report!G72,10))+TIMEVALUE(RIGHT(Report!G72,8)))","v":""},{"$f":"IF(AND(C72=\"\",K72=\"\"),\"\",TIMEVALUE(RIGHT(Report!H72,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K72)=\"O\",Report!C72=\"Client\"),Report!B72,IF(AND(LEFT(Report!C72)=\"O\",Report!K72=\"Client\"),Report!J72,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K72)=\"O\",Report!C72=\"Client\"),Report!A72,IF(AND(LEFT(Report!C72)=\"O\",Report!K72=\"Client\"),Report!I72,\"\"))","v":""},"",""]
[{"$f":"IF(E73=\"\",\"\",IF(OR(Report!E73>=22,Report!E73<=5),\"утро\",IF(AND(Report!E73>=6,Report!E73<=13),\"день\",IF(AND(Report!E73>=14,Report!E73<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K73)=\"O\",Report!C73=\"Client\"),Report!K73,IF(AND(LEFT(Report!C73)=\"O\",Report!K73=\"Client\"),Report!C73,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K73)=\"O\",Report!C73=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C73)=\"O\",Report!K73=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C73=\"\",K73=\"\"),\"\",DATEVALUE(Report!D73))","v":""},{"$f":"IF(AND(C73=\"\",K73=\"\"),\"\",IF(Report!E73=0,\"00:00-00:59\",IF(Report!E73=1,\"01:00-01:59\",IF(Report!E73=2,\"02:00-02:59\",IF(Report!E73=3,\"03:00-03:59\",IF(Report!E73=4,\"04:00-04:59\",IF(Report!E73=5,\"05:00-05:59\",IF(Report!E73=6,\"06:00-06:59\",IF(Report!E73=7,\"07:00-07:59\",IF(Report!E73=8,\"08:00-08:59\",IF(Report!E73=9,\"09:00-09:59\",Report!E73&\":00-\"&Report!E73&\":59\")))))))))))","v":""},{"$f":"IF(AND(C73=\"\",K73=\"\"),\"\",DATEVALUE(LEFT(Report!F73,10))+TIMEVALUE(RIGHT(Report!F73,8)))","v":""},{"$f":"IF(AND(C73=\"\",K73=\"\"),\"\",DATEVALUE(LEFT(Report!G73,10))+TIMEVALUE(RIGHT(Report!G73,8)))","v":""},{"$f":"IF(AND(C73=\"\",K73=\"\"),\"\",TIMEVALUE(RIGHT(Report!H73,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K73)=\"O\",Report!C73=\"Client\"),Report!B73,IF(AND(LEFT(Report!C73)=\"O\",Report!K73=\"Client\"),Report!J73,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K73)=\"O\",Report!C73=\"Client\"),Report!A73,IF(AND(LEFT(Report!C73)=\"O\",Report!K73=\"Client\"),Report!I73,\"\"))","v":""},"",""]
[{"$f":"IF(E74=\"\",\"\",IF(OR(Report!E74>=22,Report!E74<=5),\"утро\",IF(AND(Report!E74>=6,Report!E74<=13),\"день\",IF(AND(Report!E74>=14,Report!E74<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K74)=\"O\",Report!C74=\"Client\"),Report!K74,IF(AND(LEFT(Report!C74)=\"O\",Report!K74=\"Client\"),Report!C74,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K74)=\"O\",Report!C74=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C74)=\"O\",Report!K74=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C74=\"\",K74=\"\"),\"\",DATEVALUE(Report!D74))","v":""},{"$f":"IF(AND(C74=\"\",K74=\"\"),\"\",IF(Report!E74=0,\"00:00-00:59\",IF(Report!E74=1,\"01:00-01:59\",IF(Report!E74=2,\"02:00-02:59\",IF(Report!E74=3,\"03:00-03:59\",IF(Report!E74=4,\"04:00-04:59\",IF(Report!E74=5,\"05:00-05:59\",IF(Report!E74=6,\"06:00-06:59\",IF(Report!E74=7,\"07:00-07:59\",IF(Report!E74=8,\"08:00-08:59\",IF(Report!E74=9,\"09:00-09:59\",Report!E74&\":00-\"&Report!E74&\":59\")))))))))))","v":""},{"$f":"IF(AND(C74=\"\",K74=\"\"),\"\",DATEVALUE(LEFT(Report!F74,10))+TIMEVALUE(RIGHT(Report!F74,8)))","v":""},{"$f":"IF(AND(C74=\"\",K74=\"\"),\"\",DATEVALUE(LEFT(Report!G74,10))+TIMEVALUE(RIGHT(Report!G74,8)))","v":""},{"$f":"IF(AND(C74=\"\",K74=\"\"),\"\",TIMEVALUE(RIGHT(Report!H74,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K74)=\"O\",Report!C74=\"Client\"),Report!B74,IF(AND(LEFT(Report!C74)=\"O\",Report!K74=\"Client\"),Report!J74,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K74)=\"O\",Report!C74=\"Client\"),Report!A74,IF(AND(LEFT(Report!C74)=\"O\",Report!K74=\"Client\"),Report!I74,\"\"))","v":""},"",""]
[{"$f":"IF(E75=\"\",\"\",IF(OR(Report!E75>=22,Report!E75<=5),\"утро\",IF(AND(Report!E75>=6,Report!E75<=13),\"день\",IF(AND(Report!E75>=14,Report!E75<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K75)=\"O\",Report!C75=\"Client\"),Report!K75,IF(AND(LEFT(Report!C75)=\"O\",Report!K75=\"Client\"),Report!C75,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K75)=\"O\",Report!C75=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C75)=\"O\",Report!K75=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C75=\"\",K75=\"\"),\"\",DATEVALUE(Report!D75))","v":""},{"$f":"IF(AND(C75=\"\",K75=\"\"),\"\",IF(Report!E75=0,\"00:00-00:59\",IF(Report!E75=1,\"01:00-01:59\",IF(Report!E75=2,\"02:00-02:59\",IF(Report!E75=3,\"03:00-03:59\",IF(Report!E75=4,\"04:00-04:59\",IF(Report!E75=5,\"05:00-05:59\",IF(Report!E75=6,\"06:00-06:59\",IF(Report!E75=7,\"07:00-07:59\",IF(Report!E75=8,\"08:00-08:59\",IF(Report!E75=9,\"09:00-09:59\",Report!E75&\":00-\"&Report!E75&\":59\")))))))))))","v":""},{"$f":"IF(AND(C75=\"\",K75=\"\"),\"\",DATEVALUE(LEFT(Report!F75,10))+TIMEVALUE(RIGHT(Report!F75,8)))","v":""},{"$f":"IF(AND(C75=\"\",K75=\"\"),\"\",DATEVALUE(LEFT(Report!G75,10))+TIMEVALUE(RIGHT(Report!G75,8)))","v":""},{"$f":"IF(AND(C75=\"\",K75=\"\"),\"\",TIMEVALUE(RIGHT(Report!H75,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K75)=\"O\",Report!C75=\"Client\"),Report!B75,IF(AND(LEFT(Report!C75)=\"O\",Report!K75=\"Client\"),Report!J75,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K75)=\"O\",Report!C75=\"Client\"),Report!A75,IF(AND(LEFT(Report!C75)=\"O\",Report!K75=\"Client\"),Report!I75,\"\"))","v":""},"",""]
[{"$f":"IF(E76=\"\",\"\",IF(OR(Report!E76>=22,Report!E76<=5),\"утро\",IF(AND(Report!E76>=6,Report!E76<=13),\"день\",IF(AND(Report!E76>=14,Report!E76<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K76)=\"O\",Report!C76=\"Client\"),Report!K76,IF(AND(LEFT(Report!C76)=\"O\",Report!K76=\"Client\"),Report!C76,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K76)=\"O\",Report!C76=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C76)=\"O\",Report!K76=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C76=\"\",K76=\"\"),\"\",DATEVALUE(Report!D76))","v":""},{"$f":"IF(AND(C76=\"\",K76=\"\"),\"\",IF(Report!E76=0,\"00:00-00:59\",IF(Report!E76=1,\"01:00-01:59\",IF(Report!E76=2,\"02:00-02:59\",IF(Report!E76=3,\"03:00-03:59\",IF(Report!E76=4,\"04:00-04:59\",IF(Report!E76=5,\"05:00-05:59\",IF(Report!E76=6,\"06:00-06:59\",IF(Report!E76=7,\"07:00-07:59\",IF(Report!E76=8,\"08:00-08:59\",IF(Report!E76=9,\"09:00-09:59\",Report!E76&\":00-\"&Report!E76&\":59\")))))))))))","v":""},{"$f":"IF(AND(C76=\"\",K76=\"\"),\"\",DATEVALUE(LEFT(Report!F76,10))+TIMEVALUE(RIGHT(Report!F76,8)))","v":""},{"$f":"IF(AND(C76=\"\",K76=\"\"),\"\",DATEVALUE(LEFT(Report!G76,10))+TIMEVALUE(RIGHT(Report!G76,8)))","v":""},{"$f":"IF(AND(C76=\"\",K76=\"\"),\"\",TIMEVALUE(RIGHT(Report!H76,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K76)=\"O\",Report!C76=\"Client\"),Report!B76,IF(AND(LEFT(Report!C76)=\"O\",Report!K76=\"Client\"),Report!J76,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K76)=\"O\",Report!C76=\"Client\"),Report!A76,IF(AND(LEFT(Report!C76)=\"O\",Report!K76=\"Client\"),Report!I76,\"\"))","v":""},"",""]
[{"$f":"IF(E77=\"\",\"\",IF(OR(Report!E77>=22,Report!E77<=5),\"утро\",IF(AND(Report!E77>=6,Report!E77<=13),\"день\",IF(AND(Report!E77>=14,Report!E77<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K77)=\"O\",Report!C77=\"Client\"),Report!K77,IF(AND(LEFT(Report!C77)=\"O\",Report!K77=\"Client\"),Report!C77,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K77)=\"O\",Report!C77=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C77)=\"O\",Report!K77=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C77=\"\",K77=\"\"),\"\",DATEVALUE(Report!D77))","v":""},{"$f":"IF(AND(C77=\"\",K77=\"\"),\"\",IF(Report!E77=0,\"00:00-00:59\",IF(Report!E77=1,\"01:00-01:59\",IF(Report!E77=2,\"02:00-02:59\",IF(Report!E77=3,\"03:00-03:59\",IF(Report!E77=4,\"04:00-04:59\",IF(Report!E77=5,\"05:00-05:59\",IF(Report!E77=6,\"06:00-06:59\",IF(Report!E77=7,\"07:00-07:59\",IF(Report!E77=8,\"08:00-08:59\",IF(Report!E77=9,\"09:00-09:59\",Report!E77&\":00-\"&Report!E77&\":59\")))))))))))","v":""},{"$f":"IF(AND(C77=\"\",K77=\"\"),\"\",DATEVALUE(LEFT(Report!F77,10))+TIMEVALUE(RIGHT(Report!F77,8)))","v":""},{"$f":"IF(AND(C77=\"\",K77=\"\"),\"\",DATEVALUE(LEFT(Report!G77,10))+TIMEVALUE(RIGHT(Report!G77,8)))","v":""},{"$f":"IF(AND(C77=\"\",K77=\"\"),\"\",TIMEVALUE(RIGHT(Report!H77,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K77)=\"O\",Report!C77=\"Client\"),Report!B77,IF(AND(LEFT(Report!C77)=\"O\",Report!K77=\"Client\"),Report!J77,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K77)=\"O\",Report!C77=\"Client\"),Report!A77,IF(AND(LEFT(Report!C77)=\"O\",Report!K77=\"Client\"),Report!I77,\"\"))","v":""},"",""]
[{"$f":"IF(E78=\"\",\"\",IF(OR(Report!E78>=22,Report!E78<=5),\"утро\",IF(AND(Report!E78>=6,Report!E78<=13),\"день\",IF(AND(Report!E78>=14,Report!E78<=21),\"вечер\",\"\"))))","v":""},{"$f":"IF(AND(LEFT(Report!K78)=\"O\",Report!C78=\"Client\"),Report!K78,IF(AND(LEFT(Report!C78)=\"O\",Report!K78=\"Client\"),Report!C78,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K78)=\"O\",Report!C78=\"Client\"),\"Входящие\",IF(AND(LEFT(Report!C78)=\"O\",Report!K78=\"Client\"),\"Исходящие\",\"\"))","v":""},{"$f":"IF(AND(C78=\"\",K78=\"\"),\"\",DATEVALUE(Report!D78))","v":""},{"$f":"IF(AND(C78=\"\",K78=\"\"),\"\",IF(Report!E78=0,\"00:00-00:59\",IF(Report!E78=1,\"01:00-01:59\",IF(Report!E78=2,\"02:00-02:59\",IF(Report!E78=3,\"03:00-03:59\",IF(Report!E78=4,\"04:00-04:59\",IF(Report!E78=5,\"05:00-05:59\",IF(Report!E78=6,\"06:00-06:59\",IF(Report!E78=7,\"07:00-07:59\",IF(Report!E78=8,\"08:00-08:59\",IF(Report!E78=9,\"09:00-09:59\",Report!E78&\":00-\"&Report!E78&\":59\")))))))))))","v":""},{"$f":"IF(AND(C78=\"\",K78=\"\"),\"\",DATEVALUE(LEFT(Report!F78,10))+TIMEVALUE(RIGHT(Report!F78,8)))","v":""},{"$f":"IF(AND(C78=\"\",K78=\"\"),\"\",DATEVALUE(LEFT(Report!G78,10))+TIMEVALUE(RIGHT(Report!G78,8)))","v":""},{"$f":"IF(AND(C78=\"\",K78=\"\"),\"\",TIMEVALUE(RIGHT(Report!H78,8)))","v":""},"",{"$f":"IF(AND(LEFT(Report!K78)=\"O\",Report!C78=\"Client\"),Report!B78,IF(AND(LEFT(Report!C78)=\"O\",Report!K78=\"Client\"),Report!J78,\"\"))","v":""},{"$f":"IF(AND(LEFT(Report!K78)=\"O\",Report!C78=\"Client\"),Report!A78,IF(AND(LEFT(Report!C78)=\"O\",Report!K78=\"Client\"),Report!I78,\"\"))","v":""},"",""]

{"sheet":"Диаграмма","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Количество по полю Значение","Названия столбцов"]
["Названия строк",null,"Коробка","Пакет","Упаковка","Общий итог"]
[null,49,null,null,null,49]
["06:00-06:59",null,null,1,null,1]
["07:00-07:59",null,2,1,2,5]
["08:00-08:59",null,1,1,1,3]
["09:00-09:59",null,null,1,null,1]
["10:00-10:59",null,null,null,1,1]
["11:00-11:59",null,2,1,1,4]
["12:00-12:59",null,1,3,null,4]
["13:00-13:59",null,1,null,1,2]
["16:00-16:59",null,null,1,null,1]
["17:00-17:59",null,2,1,1,4]
["Общий итог",49,9,10,7,75]
[]
[]
["Количество по полю Значение","Названия столбцов"]
["Названия строк",null,"Входящие","Общий итог"]
[null,49,null,49]
["Operator1",null,2,2]
["Operator3",null,7,7]
["Operator4",null,17,17]
["Общий итог",49,26,75]