{"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":true,"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":29,"n_cols":13,"rows_kept":29,"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!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(C10=\"\",K10=\"\"),\"\",DATEVALUE(Report!D16))","v":"2020-12-18"},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",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(C10=\"\",K10=\"\"),\"\",DATEVALUE(LEFT(Report!F16,10))+TIMEVALUE(RIGHT(Report!F16,8)))","v":"2020-12-18T08:20:31"},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",DATEVALUE(LEFT(Report!G16,10))+TIMEVALUE(RIGHT(Report!G16,8)))","v":"2020-12-18T08:20:49"},{"$f":"IF(AND(C10=\"\",K10=\"\"),\"\",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(E11=\"\",\"\",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(C11=\"\",K11=\"\"),\"\",DATEVALUE(Report!D17))","v":"2020-12-18"},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",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(C11=\"\",K11=\"\"),\"\",DATEVALUE(LEFT(Report!F17,10))+TIMEVALUE(RIGHT(Report!F17,8)))","v":"2020-12-18T08:11:20"},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",DATEVALUE(LEFT(Report!G17,10))+TIMEVALUE(RIGHT(Report!G17,8)))","v":"2020-12-18T08:11:32"},{"$f":"IF(AND(C11=\"\",K11=\"\"),\"\",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(E12=\"\",\"\",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(C12=\"\",K12=\"\"),\"\",DATEVALUE(Report!D18))","v":"2020-12-18"},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",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(C12=\"\",K12=\"\"),\"\",DATEVALUE(LEFT(Report!F18,10))+TIMEVALUE(RIGHT(Report!F18,8)))","v":"2020-12-18T08:24:44"},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",DATEVALUE(LEFT(Report!G18,10))+TIMEVALUE(RIGHT(Report!G18,8)))","v":"2020-12-18T08:24:49"},{"$f":"IF(AND(C12=\"\",K12=\"\"),\"\",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(E13=\"\",\"\",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(C13=\"\",K13=\"\"),\"\",DATEVALUE(Report!D19))","v":"2020-12-18"},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",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(C13=\"\",K13=\"\"),\"\",DATEVALUE(LEFT(Report!F19,10))+TIMEVALUE(RIGHT(Report!F19,8)))","v":"2020-12-18T09:28:26"},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",DATEVALUE(LEFT(Report!G19,10))+TIMEVALUE(RIGHT(Report!G19,8)))","v":"2020-12-18T09:31:19"},{"$f":"IF(AND(C13=\"\",K13=\"\"),\"\",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(E14=\"\",\"\",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(C14=\"\",K14=\"\"),\"\",DATEVALUE(Report!D20))","v":"2020-12-18"},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",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(C14=\"\",K14=\"\"),\"\",DATEVALUE(LEFT(Report!F20,10))+TIMEVALUE(RIGHT(Report!F20,8)))","v":"2020-12-18T10:47:50"},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",DATEVALUE(LEFT(Report!G20,10))+TIMEVALUE(RIGHT(Report!G20,8)))","v":"2020-12-18T10:48:32"},{"$f":"IF(AND(C14=\"\",K14=\"\"),\"\",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(E15=\"\",\"\",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(C15=\"\",K15=\"\"),\"\",DATEVALUE(Report!D21))","v":"2020-12-18"},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",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(C15=\"\",K15=\"\"),\"\",DATEVALUE(LEFT(Report!F21,10))+TIMEVALUE(RIGHT(Report!F21,8)))","v":"2020-12-18T11:28:39"},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",DATEVALUE(LEFT(Report!G21,10))+TIMEVALUE(RIGHT(Report!G21,8)))","v":"2020-12-18T11:28:50"},{"$f":"IF(AND(C15=\"\",K15=\"\"),\"\",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(E16=\"\",\"\",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(C16=\"\",K16=\"\"),\"\",DATEVALUE(Report!D22))","v":"2020-12-18"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",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(C16=\"\",K16=\"\"),\"\",DATEVALUE(LEFT(Report!F22,10))+TIMEVALUE(RIGHT(Report!F22,8)))","v":"2020-12-18T11:20:32"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",DATEVALUE(LEFT(Report!G22,10))+TIMEVALUE(RIGHT(Report!G22,8)))","v":"2020-12-18T11:20:41"},{"$f":"IF(AND(C16=\"\",K16=\"\"),\"\",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(E17=\"\",\"\",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(C17=\"\",K17=\"\"),\"\",DATEVALUE(Report!D23))","v":"2020-12-18"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",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(C17=\"\",K17=\"\"),\"\",DATEVALUE(LEFT(Report!F23,10))+TIMEVALUE(RIGHT(Report!F23,8)))","v":"2020-12-18T11:00:58"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",DATEVALUE(LEFT(Report!G23,10))+TIMEVALUE(RIGHT(Report!G23,8)))","v":"2020-12-18T11:01:16"},{"$f":"IF(AND(C17=\"\",K17=\"\"),\"\",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(E18=\"\",\"\",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(C18=\"\",K18=\"\"),\"\",DATEVALUE(Report!D24))","v":"2020-12-18"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",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(C18=\"\",K18=\"\"),\"\",DATEVALUE(LEFT(Report!F24,10))+TIMEVALUE(RIGHT(Report!F24,8)))","v":"2020-12-18T11:28:35"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",DATEVALUE(LEFT(Report!G24,10))+TIMEVALUE(RIGHT(Report!G24,8)))","v":"2020-12-18T11:28:37"},{"$f":"IF(AND(C18=\"\",K18=\"\"),\"\",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(E19=\"\",\"\",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(C19=\"\",K19=\"\"),\"\",DATEVALUE(Report!D25))","v":"2020-12-18"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",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(C19=\"\",K19=\"\"),\"\",DATEVALUE(LEFT(Report!F25,10))+TIMEVALUE(RIGHT(Report!F25,8)))","v":"2020-12-18T12:01:15"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",DATEVALUE(LEFT(Report!G25,10))+TIMEVALUE(RIGHT(Report!G25,8)))","v":"2020-12-18T12:01:30"},{"$f":"IF(AND(C19=\"\",K19=\"\"),\"\",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(E20=\"\",\"\",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(C20=\"\",K20=\"\"),\"\",DATEVALUE(Report!D28))","v":"2020-12-18"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",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(C20=\"\",K20=\"\"),\"\",DATEVALUE(LEFT(Report!F28,10))+TIMEVALUE(RIGHT(Report!F28,8)))","v":"2020-12-18T12:05:00"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",DATEVALUE(LEFT(Report!G28,10))+TIMEVALUE(RIGHT(Report!G28,8)))","v":"2020-12-18T12:05:14"},{"$f":"IF(AND(C20=\"\",K20=\"\"),\"\",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(E21=\"\",\"\",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(C21=\"\",K21=\"\"),\"\",DATEVALUE(Report!D30))","v":"2020-12-18"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",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(C21=\"\",K21=\"\"),\"\",DATEVALUE(LEFT(Report!F30,10))+TIMEVALUE(RIGHT(Report!F30,8)))","v":"2020-12-18T12:41:45"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",DATEVALUE(LEFT(Report!G30,10))+TIMEVALUE(RIGHT(Report!G30,8)))","v":"2020-12-18T12:41:47"},{"$f":"IF(AND(C21=\"\",K21=\"\"),\"\",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(E22=\"\",\"\",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(C22=\"\",K22=\"\"),\"\",DATEVALUE(Report!D31))","v":"2020-12-18"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",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(C22=\"\",K22=\"\"),\"\",DATEVALUE(LEFT(Report!F31,10))+TIMEVALUE(RIGHT(Report!F31,8)))","v":"2020-12-18T12:47:28"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",DATEVALUE(LEFT(Report!G31,10))+TIMEVALUE(RIGHT(Report!G31,8)))","v":"2020-12-18T12:47:40"},{"$f":"IF(AND(C22=\"\",K22=\"\"),\"\",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(E23=\"\",\"\",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(C23=\"\",K23=\"\"),\"\",DATEVALUE(Report!D35))","v":"2020-12-18"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",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(C23=\"\",K23=\"\"),\"\",DATEVALUE(LEFT(Report!F35,10))+TIMEVALUE(RIGHT(Report!F35,8)))","v":"2020-12-18T13:45:01"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",DATEVALUE(LEFT(Report!G35,10))+TIMEVALUE(RIGHT(Report!G35,8)))","v":"2020-12-18T13:45:19"},{"$f":"IF(AND(C23=\"\",K23=\"\"),\"\",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(E24=\"\",\"\",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(C24=\"\",K24=\"\"),\"\",DATEVALUE(Report!D36))","v":"2020-12-18"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",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(C24=\"\",K24=\"\"),\"\",DATEVALUE(LEFT(Report!F36,10))+TIMEVALUE(RIGHT(Report!F36,8)))","v":"2020-12-18T13:31:09"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",DATEVALUE(LEFT(Report!G36,10))+TIMEVALUE(RIGHT(Report!G36,8)))","v":"2020-12-18T13:31:14"},{"$f":"IF(AND(C24=\"\",K24=\"\"),\"\",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(J24)=\"X\",\"Саморезы\",IF(LEFT(J24)=\"E\",\"Гвозди\",\"\"))","v":"Гвозди"},"1"]
[{"$f":"IF(E25=\"\",\"\",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(C25=\"\",K25=\"\"),\"\",DATEVALUE(Report!D40))","v":"2020-12-18"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",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(C25=\"\",K25=\"\"),\"\",DATEVALUE(LEFT(Report!F40,10))+TIMEVALUE(RIGHT(Report!F40,8)))","v":"2020-12-18T16:18:09"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",DATEVALUE(LEFT(Report!G40,10))+TIMEVALUE(RIGHT(Report!G40,8)))","v":"2020-12-18T16:18:15"},{"$f":"IF(AND(C25=\"\",K25=\"\"),\"\",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(E26=\"\",\"\",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(C26=\"\",K26=\"\"),\"\",DATEVALUE(Report!D42))","v":"2020-12-18"},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",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(C26=\"\",K26=\"\"),\"\",DATEVALUE(LEFT(Report!F42,10))+TIMEVALUE(RIGHT(Report!F42,8)))","v":"2020-12-18T17:32:17"},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",DATEVALUE(LEFT(Report!G42,10))+TIMEVALUE(RIGHT(Report!G42,8)))","v":"2020-12-18T17:32:32"},{"$f":"IF(AND(C26=\"\",K26=\"\"),\"\",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(E27=\"\",\"\",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(C27=\"\",K27=\"\"),\"\",DATEVALUE(Report!D43))","v":"2020-12-18"},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",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(C27=\"\",K27=\"\"),\"\",DATEVALUE(LEFT(Report!F43,10))+TIMEVALUE(RIGHT(Report!F43,8)))","v":"2020-12-18T17:45:25"},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",DATEVALUE(LEFT(Report!G43,10))+TIMEVALUE(RIGHT(Report!G43,8)))","v":"2020-12-18T17:45:49"},{"$f":"IF(AND(C27=\"\",K27=\"\"),\"\",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(E28=\"\",\"\",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(C28=\"\",K28=\"\"),\"\",DATEVALUE(Report!D44))","v":"2020-12-18"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",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(C28=\"\",K28=\"\"),\"\",DATEVALUE(LEFT(Report!F44,10))+TIMEVALUE(RIGHT(Report!F44,8)))","v":"2020-12-18T17:37:10"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",DATEVALUE(LEFT(Report!G44,10))+TIMEVALUE(RIGHT(Report!G44,8)))","v":"2020-12-18T17:37:17"},{"$f":"IF(AND(C28=\"\",K28=\"\"),\"\",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(E29=\"\",\"\",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(C29=\"\",K29=\"\"),\"\",DATEVALUE(Report!D45))","v":"2020-12-18"},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",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(C29=\"\",K29=\"\"),\"\",DATEVALUE(LEFT(Report!F45,10))+TIMEVALUE(RIGHT(Report!F45,8)))","v":"2020-12-18T17:58:15"},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",DATEVALUE(LEFT(Report!G45,10))+TIMEVALUE(RIGHT(Report!G45,8)))","v":"2020-12-18T17:58:22"},{"$f":"IF(AND(C29=\"\",K29=\"\"),\"\",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"]

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