{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Логика","Как должно быть"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Код.обращения","Номер клиента","Дата создания","Дата закрытия","Тема обращения","Повторка"]
[222,555555,"2019-03-01T15:16:00","2019-03-01T19:16:00","Обслуживание","Единичное"]
[233,555555,"2019-03-02T15:16:00","2019-03-03T09:16:00","Продажи","Единичное"]
[244,555555,"2019-03-03T18:16:00","2019-03-04T15:15:59.985","Продажи","Повторное"]
[255,555621,"2019-03-02T15:16:00","2019-03-02T20:16:00","Реклама","Единичное"]
[266,555621,"2019-03-03T18:16:00","2019-03-07T06:15:59.935","Реклама","Повторное"]
[277,236589,"2019-03-04T15:15:59.985","2019-03-11T16:15:59.870","Обслуживание","Единичное"]
[288,238589,"2019-03-05T12:15:59.965","2019-03-16T02:15:59.805","Обслуживание","Единичное"]
[299,240589,"2019-03-06T09:15:59.950","2019-03-20T12:15:59.740","Продажи","Единичное"]
[310,242589,"2019-03-07T06:15:59.935","2019-03-24T22:15:59.675","Продажи","Единичное"]
[321,244589,"2019-03-08T03:15:59.920","2019-03-29T08:15:59.610","Реклама","Единичное"]
[332,246589,"2019-03-09T00:15:59.905","2019-04-02T18:15:59.545","Обслуживание","Единичное"]
[343,248589,"2019-03-09T21:15:59.890","2019-04-07T04:15:59.480","Продажи","Единичное"]
[354,250589,"2019-03-10T18:15:59.875","2019-04-11T14:15:59.415","Продажи","Единичное"]
[365,252589,"2019-03-11T15:15:59.860","2019-04-16T00:15:59.350","Реклама","Единичное"]
[376,254589,"2019-03-12T12:15:59.845","2019-04-20T10:15:59.285","Обслуживание","Единичное"]
[387,256589,"2019-03-13T09:15:59.830","2019-04-24T20:15:59.220","Продажи","Единичное"]
[398,258589,"2019-03-14T06:15:59.815","2019-04-29T06:15:59.155","Продажи","Единичное"]
[409,260589,"2019-03-15T03:15:59.800","2019-05-03T16:15:59.090","Реклама","Единичное"]
[420,262589,"2019-03-16T00:15:59.785","2019-05-08T02:15:59.025","Обслуживание","Единичное"]
[431,264589,"2019-03-16T21:15:59.770","2019-05-12T12:15:58.960","Продажи","Единичное"]
[442,266589,"2019-03-17T18:15:59.755","2019-05-16T22:15:58.895","Продажи","Единичное"]
[453,268589,"2019-03-03T18:16:00","2019-05-21T08:15:58.830","Реклама","Единичное"]
[464,270589,"2019-03-04T15:15:59.985","2019-05-25T18:15:58.765","Обслуживание","Единичное"]
[475,272589,"2019-03-05T12:15:59.965","2019-05-30T04:15:58.700","Продажи","Единичное"]
[486,274589,"2019-03-06T09:15:59.950","2019-06-03T14:15:58.635","Продажи","Единичное"]
[497,276589,"2019-03-07T06:15:59.935","2019-06-08T00:15:58.570","Реклама","Единичное"]
[508,278589,"2019-03-08T03:15:59.920","2019-06-12T10:15:58.505","Обслуживание","Единичное"]
[519,280589,"2019-03-09T00:15:59.905","2019-06-16T20:15:58.440","Продажи","Единичное"]
[530,282589,"2019-03-09T21:15:59.890","2019-06-21T06:15:58.375","Продажи","Единичное"]

{"sheet":"Логика","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Код.обращения","Номер клиента","Дата создания","Дата закрытия","Тема обращения","Повторка"]
["а","а1","а2","а3","а4"]
["б","б1","б2","б3","б4"]
["в","в1","в2","в3","в4"]
[]
[]
[]
[]
["По какому принципу расчитывается:"]
["Если(и(а1=б1;а4=б4);Если(и((б2-а3)<2;(б2-а3)>0);\"Повторка\");\"Еденичное\")"]
[]
[]
["Если 2 раза встречается номер клиента и одинаковой темой(если нет - то это еденичное), то необходимо проверить, если Дата закрытия предыдущего обращения по этому номеру на 2 дня меньше даны создания нового - это повторка, если нет -еденичное"]

{"sheet":"Как должно быть","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Код.обращения","Номер клиента","Дата создания","Дата закрытия","Тема обращения","Повторка"]
[222,555555,"2019-03-01T15:16:00","2019-03-01T19:16:00","Обслуживание","Еденичное"]
[233,555555,"2019-03-02T15:16:00","2019-03-03T09:16:00","Продажи","Еденичное"]
[244,555555,"2019-03-03T18:16:00","2019-03-04T15:15:59.985","Продажи","Повторка"]
[255,555621,"2019-03-02T15:16:00","2019-03-02T20:16:00","Реклама","Еденичное"]
[266,555621,"2019-03-03T18:16:00","2019-03-07T06:15:59.935","Реклама","Повторка"]
[277,236589,"2019-03-04T15:15:59.985","2019-03-11T16:15:59.870","Обслуживание","Еденичное"]
[288,238589,"2019-03-05T12:15:59.965","2019-03-16T02:15:59.805","Обслуживание","Еденичное"]
[299,240589,"2019-03-06T09:15:59.950","2019-03-20T12:15:59.740","Продажи","Еденичное"]
[310,242589,"2019-03-07T06:15:59.935","2019-03-24T22:15:59.675","Продажи","Еденичное"]
[321,244589,"2019-03-08T03:15:59.920","2019-03-29T08:15:59.610","Реклама","Еденичное"]
[332,246589,"2019-03-09T00:15:59.905","2019-04-02T18:15:59.545","Обслуживание","Еденичное"]
[343,248589,"2019-03-09T21:15:59.890","2019-04-07T04:15:59.480","Продажи","Еденичное"]
[354,250589,"2019-03-10T18:15:59.875","2019-04-11T14:15:59.415","Продажи","Еденичное"]
[365,252589,"2019-03-11T15:15:59.860","2019-04-16T00:15:59.350","Реклама","Еденичное"]
[376,254589,"2019-03-12T12:15:59.845","2019-04-20T10:15:59.285","Обслуживание","Еденичное"]
[387,256589,"2019-03-13T09:15:59.830","2019-04-24T20:15:59.220","Продажи","Еденичное"]
[398,258589,"2019-03-14T06:15:59.815","2019-04-29T06:15:59.155","Продажи","Еденичное"]
[409,260589,"2019-03-15T03:15:59.800","2019-05-03T16:15:59.090","Реклама","Еденичное"]
[420,262589,"2019-03-16T00:15:59.785","2019-05-08T02:15:59.025","Обслуживание","Еденичное"]
[431,264589,"2019-03-16T21:15:59.770","2019-05-12T12:15:58.960","Продажи","Еденичное"]
[442,266589,"2019-03-17T18:15:59.755","2019-05-16T22:15:58.895","Продажи","Еденичное"]
[453,268589,"2019-03-03T18:16:00","2019-05-21T08:15:58.830","Реклама","Еденичное"]
[464,270589,"2019-03-04T15:15:59.985","2019-05-25T18:15:58.765","Обслуживание","Еденичное"]
[475,272589,"2019-03-05T12:15:59.965","2019-05-30T04:15:58.700","Продажи","Еденичное"]
[486,274589,"2019-03-06T09:15:59.950","2019-06-03T14:15:58.635","Продажи","Еденичное"]
[497,276589,"2019-03-07T06:15:59.935","2019-06-08T00:15:58.570","Реклама","Еденичное"]
[508,278589,"2019-03-08T03:15:59.920","2019-06-12T10:15:58.505","Обслуживание","Еденичное"]
[519,280589,"2019-03-09T00:15:59.905","2019-06-16T20:15:58.440","Продажи","Еденичное"]
[530,282589,"2019-03-09T21:15:59.890","2019-06-21T06:15:58.375","Продажи","Еденичное"]