{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Form"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":21,"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":"Form","index":0,"n_rows":124,"n_cols":32,"rows_kept":124,"cut":false,"hidden":false,"merged":[[49,0,49,13],[48,5,48,13],[48,0,48,4],[0,0,0,13],[3,0,3,13],[22,0,22,13],[27,0,27,13],[24,0,24,13],[25,5,25,13],[1,0,1,3],[2,0,2,3],[1,4,1,8],[2,4,2,8],[25,0,25,4],[8,0,9,13],[5,8,6,8],[1,9,1,11],[2,9,2,11],[1,12,1,13],[4,9,4,13],[5,9,6,13],[7,9,7,13],[4,2,4,5],[4,0,4,1],[5,0,5,1],[6,0,6,1],[5,2,5,5],[6,2,6,5],[7,0,7,1],[7,2,7,5],[10,5,10,13],[11,2,11,3],[10,2,10,4],[23,0,23,13],[18,2,18,3],[10,1,11,1],[10,0,11,0],[17,2,17,3],[16,2,16,3],[15,2,15,3],[14,2,14,3],[13,2,13,3],[12,2,12,3],[19,2,19,3],[38,0,39,13],[29,1,29,5],[36,1,36,13],[20,2,20,3],[21,2,21,3]]}
["Заполняется представителем заказчика"]
["Наименование организации:",null,null,null,null,null,null,null,null,"Дата заполнения:",null,null,"очистить форму"]
["Адрес пункта продажи и контактный телефон:",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-10-05"}]
[]
["Код",null,"Описание причины обмена:",null,null,null,null,null,"Код","Описание причины обмена:"]
["А",null,"Ошибка отдела Клиентского Сервиса J&J при обработке заказа",null,null,null,null,null,"Г","Медицинская жалоба от конечного пользователя \n(клинические симптомы, побочные эффекты, дайте подробное описание в поле «Комментарий»)"]
["Б",null,"Ошибка заказчика при размещении заказа"]
["В",null,"Жалоба на качество продукции от конечного пользователя \n(Механические дефекты продукта, упаковки, этикетки, др. Опишите в поле «Комментарий»)",null,null,null,null,null,"Д","Страхование при подборе торических и мультифокальных линз (Опишите причину возврата линз в поле «Комментарий»)"]
["ИНФОРМАЦИЯ ПО ПРОДУКТАМ НА ОБМЕН*"]
[]
["№","КОД","Описание продукта на возврат в J&J",null,null,"Описание продукта на обмен заказчику"]
[null,null,"Наименование продукта, кол-во в упаковке",null,"Кол-во упаковок","Наименование продукта, кол-во в упаковке",null,null,"Базовая кривизна","Оптическая сила","Цилиндр","Ось","Аддидация","Кол-во упаковок"]
[1,null,{"$f":"F13","v":0},null,{"$f":"N13","v":0},null,{"$f":"VLOOKUP($F13,$A$54:$C$72,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F13,$A$54:$B$72,2,0)","v":{"$error":"#N/A"}}]
[2,null,{"$f":"F14","v":0},null,{"$f":"N14","v":0},null,{"$f":"VLOOKUP($F14,$A$54:$C$72,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($F14,$A$54:$B$72,2,0)","v":{"$error":"#N/A"}}]
[3,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[4,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[5,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[6,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[7,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[8,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[9,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[10,null,0,null,0,null,{"$error":"#N/A"},{"$error":"#N/A"}]
["Комментарий (указать соответствующий номер строки из таблицы выше)"]
[]
["* при обмене большего количества можно пользоваться стандартной формой заказа"]
["Ф.И.О. представителя заказчика, подпись:"]
[]
["Заполняется сотрудником J&J*"]
[null,"Номер заказчика в ERP SAP : _____________________________________________________________"]
[null,"Подтверждение соответствия критериям качества*:\n۷ - ДА; Х - НЕТ; Ч - часть упаковок соответствует, часть не соответствует",null,null,null,null,null,null,"1          2","3          4","5          6","7          8","9        10"]
[null,"Соответствие критериям по каталогу дефектов MKTG-VWA-EMEA-RU-DC-0005",null,null,null,null,null,null,"□ □","□ □","□ □","□ □","□ □"]
[null,"Соответствие критериям по остаточным срокам годности MKTG-EMEA-RU-DC-0008",null,null,null,null,null,null,"□ □","□ □","□ □","□ □","□ □"]
[null,"Товар без подозрения на контрафакт",null,null,null,null,null,null,"□ □","□ □","□ □","□ □","□ □"]
[null,"Товарный стикер нанесен в соответствии с  MKTG-VWA-EMEA-RU-DC-0001**",null,null,null,null,null,null,"□ □","□ □","□ □","□ □","□ □"]
[]
[null,"* Не применимо для категорий обменов с кодами причин В, Г и Д. Оставить поля пустыми в случае отсутствия запроса на обмен по данным причинам"]
[null,"В случае частичного соответствия указать комментарии ниже, включая количества несоответствующих упаковок\nПродукты, не соответствующие критериям приемлемости  необходимо принимать в карантин"]
[null,"**","На упаковку может быть нанесена более старая версия товарного стикера, чем указано в MKTG-VWA-EMEA-RU-DC-0001"]
["Комментарий к обмену (к комментарию указать соответствующий номер строки из таблицы выше, указать, при наличии, внутренний номер жалобы по информации от сотрудников отдела Клиентского сервиса. Пи необходимости, указать комментарии по результатам оценки качества. Отметить Н\\П если не применимо):                                                                        "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Н\\П□"]
[]
[]
[]
[]
[]
[]
[]
["Ф.И.О. сотрудника J&J, подпись, дата проведения обмена (ДДММГГГГ):"]
["*ВНИМАНИЕ: При получении запроса на обмен по причинам с кодами В и Г необходимо незамедлительно направить копию данной формы в отдел Клиентского сервиса "]
[]
[]
["Продукт",null,null,"БКривизна","БКривизна","Оптическая сила","Цилиндр","Ось","Аддидация"]
["1-Day ACUVUE MOIST, 30pk","П1",null,8.5,"9,0","-12.00","-0,75",10,"L",null,null,"П1","П2","П3","П4","П5","П6","П7","П8","П9","П10","П11","П12","П13","П14","П15","П16","П17","П18","П19","П20","П21"]
["1-Day ACUVUE MOIST, 90pk","П2",null,8.5,"9,0",-11.5,"-1,25",20,"M",null,null,8.5,8.5,8.5,8.5,8.5,8.5,8.5,8.5,8.5,8.5,8.4,8.4,8.4,8.4,8.6,8.3000000000000007,8.5,8.5,8.5,8.5,8.4]
["1-Day ACUVUE MOIST, 180pk","П3",null,8.5,"9,0","-11.00","-1,75",30,"H",null,null,"9,0","9,0","9,0",null,null,"9,0","9,0","9,0","9,0","9,0",null,8.8000000000000007,8.8000000000000007,8.8000000000000007,null,8.6999999999999993,null,null,null,"9,0"]
["1-Day ACUVUE MOIST for ASTIGMATISM, 30pk","П4","ASTIGMATISM",8.5,0,-10.5,"-2,25",40]
["1-Day ACUVUE MOIST for ASTIGMATISM, 90pk","П5","ASTIGMATISM",8.5,0,"-10.00","-2,75",50]
["1-Day ACUVUE TruEye, 30pk","П6",null,8.5,"9,0",-9.5,null,60]
["1-Day ACUVUE TruEye, 90pk","П7",null,8.5,"9,0","-9.00",null,70]
["1-Day ACUVUE TruEye, 180pk","П8",null,8.5,"9,0",-8.75,null,80]
["1 DAY ACUVUE OASYS WITH HYDRALUXE, 30pk","П9",null,8.5,"9,0",-8.5,null,90]
["1 DAY ACUVUE OASYS WITH HYDRALUXE, 90pk","П10",null,8.5,"9,0",-8.25,null,100]
["1-DAY ACUVUE MOIST MULTIFOCAL WITH LACREON, 30pk","П11","MLTF",0,8.4,"-8.00",null,110]
["ACUVUE OASYS, 6pk","П12",null,8.4,8.8000000000000007,-7.75,null,120]
["ACUVUE OASYS, 12pk","П13",null,8.4,8.8000000000000007,-7.5,null,130]
["ACUVUE OASYS, 24pk","П14",null,8.4,8.8000000000000007,-7.25,null,140]
["ACUVUE OASYS for ASTIGMATISM, 6pk","П15","ASTIGMATISM",0,8.6,"-7.00",null,150]
["ACUVUE 2, 6pk","П16",null,8.3000000000000007,8.6999999999999993,-6.75,null,160]
["ACUVUE OASYS HYDRALUXE FOR ASTIGMATISM, 30pk","П19","ASTIGMATISM",0,8.5,-6.5,null,170]
["1-D ACUVUE OASYS MAX, 30pk","П20",null,8.5,"9,0",-6.25,null,180]
["ACUVUE OASYS MULTIFOCAL, 6pk","П21","MLTF",null,null,"-6.00"]
[null,null,null,null,null,-5.75]
[null,null,null,null,null,-5.5]
[null,null,null,null,null,-5.25]
[null,null,null,null,null,"-5.00"]
[null,null,null,null,null,-4.75]
[null,null,null,null,null,-4.5]
[null,null,null,null,null,-4.25]
[null,null,null,null,null,"-4.00"]
[null,null,null,null,null,-3.75]
[null,null,null,null,null,-3.5]
[null,null,null,null,null,-3.25]
[null,null,null,null,null,"-3.00"]
[null,null,null,null,null,-2.75]
[null,null,null,null,null,-2.5]
[null,null,null,null,null,-2.25]
[null,null,null,null,null,"-2.00"]
[null,null,null,null,null,-1.75]
[null,null,null,null,null,-1.5]
[null,null,null,null,null,-1.25]
[null,null,null,null,null,"-1.00"]
[null,null,null,null,null,-0.75]
[null,null,null,null,null,-0.5]
[null,null,null,null,null,-0.25]
[null,null,null,null,null,"+0.00"]
[null,null,null,null,null,"+0,25"]
[null,null,null,null,null,"+0,5"]
[null,null,null,null,null,"+0,75"]
[null,null,null,null,null,"+1.00"]
[null,null,null,null,null,"+1,25"]
[null,null,null,null,null,"+1,5"]
[null,null,null,null,null,"+1,75"]
[null,null,null,null,null,"+2.00"]
[null,null,null,null,null,"+2,25"]
[null,null,null,null,null,"+2,5"]
[null,null,null,null,null,"+2,75"]
[null,null,null,null,null,"+3.00"]
[null,null,null,null,null,"+3,25"]
[null,null,null,null,null,"+3,5"]
[null,null,null,null,null,"+3,75"]
[null,null,null,null,null,"+4.00"]
[null,null,null,null,null,"+4,25"]
[null,null,null,null,null,"+4,5"]
[null,null,null,null,null,"+4,75"]
[null,null,null,null,null,"+5.00"]
[null,null,null,null,null,"+5,25"]
[null,null,null,null,null,"+5,5"]
[null,null,null,null,null,"+5,75"]
[null,null,null,null,null,"+6.00"]
[null,null,null,null,null,"+6,5"]
[null,null,null,null,null,"+7.00"]
[null,null,null,null,null,"+7,5"]
[null,null,null,null,null,"+8.00"]