{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Главный"],"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":"Главный","index":0,"n_rows":862,"n_cols":13,"rows_kept":862,"cut":false,"hidden":false,"merged":[[840,6,840,8],[9,0,15,0],[9,1,15,1],[17,2,37,2],[17,1,37,1],[9,4,15,4],[39,2,50,2],[39,1,50,1],[17,4,37,4],[17,0,37,0],[52,1,56,1],[52,0,56,0],[58,4,59,4],[64,0,66,0],[64,4,66,4],[64,2,66,2],[6,5,6,8],[52,3,56,3],[9,2,15,2],[9,3,15,3],[58,0,59,0],[17,3,37,3],[39,4,50,4],[39,3,50,3],[52,2,56,2],[58,2,59,2],[39,0,50,0],[52,4,56,4],[58,1,59,1],[58,3,59,3],[64,3,66,3],[61,4,62,4],[61,3,62,3],[61,2,62,2],[61,1,62,1],[78,4,105,4],[78,3,105,3],[78,2,105,2],[78,1,105,1],[78,0,105,0],[61,0,62,0],[68,4,76,4],[68,3,76,3],[68,2,76,2],[68,1,76,1],[68,0,76,0],[64,1,66,1]]}
[]
[1932,null,null,null,null,null,3434]
[]
[]
[]
[]
["№ Заявки","Дата ПЗ","Дата ВЗ","Т","С","З а к а з а т ь",null,null,null,null,"Где заказано","Опл.","Приход"]
["307/1485","2012-09-21",null,"И",null,"Столешница 3000*900*40, 1подгиб","2385/s",1,null,null,"Слотекс",null,"2012-10-03"]
[".",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K9=\"скл.\",\"на скл.\",\"\")","v":""}]
["199/1817","2012-09-20","2012-09-28","И","М","Столешница 3000*600*27, 1завал","2848/s",2,null,null,"Слотекс",null,"2012-10-03"]
[null,null,null,null,null,"Стеновая панель 3000*600*4,5","2848/s",2,null,null,"Слотекс",null,"2012-10-03"]
[null,null,null,null,null,"XXXXXXXXXXXXXXXXXXXXXXXXXXX",null,null,null,null,"+",null,"не пришло"]
[null,null,null,null,null,"Мойка, Чаша справа","NORM 45 3 1/2",1,null,null,"Мойки.RU",null,"2012-10-01"]
[null,null,null,null,null,"Корзина","L-200",1,"2х уровневая",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Плинтус ","корнер 307",2,"",null,"скл.",null,{"$f":"IF(K15=\"скл.\",\"на скл.\",\"\")","v":"на скл."}]
[null,null,null,null,null,"Заглушки к плинтусу","",2,"2 внутр, 2 торц",null,"скл.",null,{"$f":"IF(K16=\"скл.\",\"на скл.\",\"\")","v":"на скл."}]
[".",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K17=\"скл.\",\"на скл.\",\"\")","v":""}]
["208/1619","2012-08-31","2012-10-01","И","С","Столешница 3000*900*40, б/з","0004/е-1",1,null,null,"Слотекс",null,"2012-09-28"]
[null,null,null,null,null,"ДСП","Черный",5,"2750*1830",null,"Закрома",null,"2012-09-27"]
[null,null,null,null,null,"Петля Blum 110* с доводкой и регулируемой отв. планкой под саморез",null,25,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"Ручки 8.1066.0160.40","55(6)",20,"",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Тандембокс  85*450",null,2,"",null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"Тандембокс  85*450 с одним рейлингом",null,2,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"Сушилка L-500","Inoxa",1,"2х уровневая",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Ящик TopVolume2","40.5240.0000.5",1,"Макмарт",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Направляющая левая","558.50001B KLI V20 ZN",1,"",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Направляющая правая","558.50001B K RE V20 ZN",1,"",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Aventos HK02",null,2,"",null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"Корзина Sige Sigma-Soft","арт. 002Т01212",1,"",null,"Бланко",null,"2012-09-25"]
[null,null,null,null,null,"Полкодержатели (нестандарт)","Пеликан 40*40",5,"",null,"A M I X",null,"2012-09-24"]
[null,null,null,null,null,"Менсолодержатель","арт. 024",2,"МАКМАРТ",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Стекло 4мм, ромб-сетка, б/цв., б/о","696*389",2,"(Императорский стиль ул. Расстанная, д. 1А\nтел./факс: (812) 712-84-11\ne-mail: imperatorsk-stil@mail.ru",null,"Имп. Стиль",null,"2012-10-03"]
[null,null,null,null,null,"Стекло 5мм, б/цв., еврокромка, полировка","363*283",2,null,null,"ИП Миронов",null,"2012-10-01"]
[null,null,null,null,null,"ABS …rehau raukantex ",601,2,"35*2 - 20 метров, 19*2 - бухта",null,"Сфинкс",null,"2012-09-25"]
[null,null,null,null,null,"ABS 43*2","Magic 3D 741E",20,null,null,"Сфинкс",null,"2012-09-25"]
[null,null,null,null,null,"Цоколь     ПВХ               Н-120","арт. 0421",1,"",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Плинтус Rehau","корнер 319",2,"600-2, 550, 350, 300, 2500",null,"Слотекс",null,"2012-09-26"]
[null,null,null,null,null,"Заглушки к плинтусу","",3,"6 загл, 3 внутр",null,"Слотекс",null,"2012-09-26"]
[".",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K39=\"скл.\",\"на скл.\",\"\")","v":""}]
["178/1611","2012-08-22","2012-10-01","И","В","Столешница 3000*600*40, б/з","2908/6",1,null,null,"Слотекс",null,"2012-09-28"]
[null,null,null,null,null,"Столешница 3000*900*40, б/з","2908/6",1,null,null,"Слотекс",null,"2012-09-28"]
[null,null,null,null,null,"Петля Blum 110* с доводкой и регулируемой отв. планкой под саморез",null,12,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"Петля Blum прямая, с доводкой и регулируемой отв. планкой под саморез",null,2,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"Ручки рейлинг, хром глянец","256(356)",3,null,null,"A M I X",null,"2012-09-24"]
[null,null,null,null,null,"Тандембокс  85*420 HETTICH",null,3,null,null,"A M I X",null,"2012-09-24"]
[null,null,null,null,null,"Мойка Флорентино, черная","Сардиния FG ",1,null,null,"Сантехмир",null,"2012-09-25"]
[null,null,null,null,null,"AVENTOS HL 06","",1,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"AVENTOS HL 07",null,2,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"AVENTOS HK-S02","",2,null,null,"Фурнитура М",null,"2012-09-25"]
[null,null,null,null,null,"ABS 19*0,4","серый",1,null,null,"Закрома",null,"2012-09-27"]
[null,null,null,null,null,"ABS 43*2","Magic 3D751E",10,null,null,"Сфинкс",null,"2012-09-25"]
[".",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K52=\"скл.\",\"на скл.\",\"\")","v":""}]
["119/1773","2012-09-17","2012-10-01","И","М","ДСП","Серебро",5,"2750*1830",null,"Закрома",null,"2012-10-08"]
[null,null,null,null,null,"Сушилка ","900 FIT",1,"2х уровневая",null,"A M I X",null,"2012-09-24"]
[null,null,null,null,null,"Корзина",200,1,"2х уровневая",null,"ММ",null,"2012-09-26"]
[null,null,null,null,null,"Полкодержатели (нестандарт)","пеликан 105*105",4,"",null,"A M I X",null,"2012-09-24"]
[null,null,null,null,null,"Стекло 4мм, Роса, б/цв., б/о","981*389",2,null,null,"ИП Миронов",null,"2012-10-01"]
[".",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(K58=\"скл.\",\"на скл.\",\"\")","v":""}]
["288/1671","2012-09-24",null,null,null,"Стекло 5мм, б/цв., еврокромка, полировка","364*190",2,null,null,"ИП Миронов",null,"2012-10-01"]
[null,null,null,null,null,"Стекло 5мм, б/цв., еврокромка, полировка","474*290",1,null,null,"ИП Миронов",null,"2012-10-01"]
[".",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(K61=\"скл.\",\"на скл.\",\"\")","v":""}]
["Склад",null,null,null,null,"Направляющие *450 белые",null,"3 коробки",null,null,"A M I X",null,"2012-09-24"]
[null,null,null,null,null,"Угол к цоколю 5075",null,"3 шт.",null,null,"ММ",null,"на скл."]
[".",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(K64=\"скл.\",\"на скл.\",\"\")","v":""}]
["249/1849","2012-09-25","2012-10-03","И","М","Столешница 3000*600*27, 1завал","2848/s",2,null,null,"Слотекс",null,"2012-10-08"]
[null,null,null,null,null,"Стеновая панель 3000*600*4,5","2848/s",2,null,null,"Слотекс",null,"2012-10-08"]
[null,null,null,null,null,"Корзина","L-150",1,"2х уровневая",null,"ММ",null,"2012-09-26"]
[".",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(K68=\"скл.\",\"на скл.\",\"\")","v":""}]
["Склад",null,null,null,null,"Саморез потай","4*20",2000,null,null,"A M I X",null,"2012-09-26"]
[null,null,null,null,null,"Ручка релинг хром глянец",128,100,null,null,"A M I X",null,"2012-09-26"]
[null,null,null,null,null,"Крабы 804.16.01.VI.00",null,1,null,null,"ММ",null,"2012-09-28"]
[null,null,null,null,null,"Труба хром глянец D=16",null,5,null,null,"A M I X",null,"2012-09-26"]
[null,null,null,null,null,"Угол к трубе 90*",null,5,null,null,"A M I X",null,"2012-09-26"]
[null,null,null,null,null,"Планка торц. д/стол. 28 ",null,"20+20",null,null,"A M I X",null,"2012-09-26"]
[null,null,null,null,null,"Планка соед. д/стол. 28",null,20,null,null,"A M I X",null,"2012-09-26"]
[null,null,null,null,null,"KLOK",null,100,null,null,"скл.",null,{"$f":"IF(K76=\"скл.\",\"на скл.\",\"\")","v":"на скл."}]
[null,null,null,null,null,"Стяжка д/стол. 100мм.",null,60,null,null,"GTV-Meridian",null,"2012-09-27"]
[".",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K78=\"скл.\",\"на скл.\",\"\")","v":""}]
["209/1825","2012-09-26",null,"И","В","ДСП бежевый 2800*2070*16 Egger","U108 ST15",8,"Базис",null,"Базис",null,"2012-09-26"]
[null,null,null,null,null,"ДСП бежевый 2800*2070*25 Egger","U108 ST15",3,"Базис",null,"Базис",null,"2012-09-26"]
[null,null,null,null,null,"Экономпанель МДФ Уникрем 1200*2400 шаг 100","Е 1224 Уникрем","2 шт.","Базис",null,"Базис",null,"2012-09-26"]
[null,null,null,null,null,"Комплект вставок для экономпанели уникрем","ВН 12/23","2 компл.","Лайдер",null,"Базис",null,"2012-09-26"]
[null,null,null,null,null,"ДСП дуб ВЕНГЕ Гагарин или Дубровка 2440*1830*16","",5,"СевЗапМебель",null,"Сервер",null,"2012-09-26"]
[null,null,null,null,null,"ДСП БЕЛЫЙ гладкий 2440*1830*16","",3,"Прогресс М",null,"Прогресс М",null,"2012-09-26"]
[null,null,null,null,null,"ABS бежевый под ДСП 19*2 ",null,"100 м.","Кредо",null,"Кредо",null,"2012-09-27"]
[null,null,null,null,null,"ABS бежевый под ДСП 28*2 (42*2)","","100 м.","Кредо",null,"Кредо",null,"2012-09-27"]
[null,null,null,null,null,"ABS под ДСП дуб ВЕНГЕ Гагарин 2*19 или шире","","150 м.","СевЗапМебель",null,"Сервер",null,"2012-09-26"]
[null,null,null,null,null,"Крючок для экономпанели l-150 хром глянец D6 мм.","F 291",50,"Базис",null,"Базис",null,"2012-09-26"]
[null,null,null,null,null,"Крючок для экономпанели l-200 хром глянец двухрожковый D 6мм.","F 302",25,"Лайдер",null,"Лайдер",null,"2012-09-28"]
[null,null,null,null,null,"Зеркало серебро 4 мм. торцы еврокромка, полировка","148*700",1,"СтеклоБалт",null,"СтеклоБалт",null,"2012-10-05"]
[null,null,null,null,null,"Стекло б/ц 8 мм. ","Приложен файл Стекло для полки",8,"СтеклоБалт",null,"СтеклоБалт",null,"2012-10-05"]
[null,null,null,null,null,"Стекло б/ц 10 мм. торцы еврокромка, полировка ","1245*465",4,"СтеклоБалт",null,"СтеклоБалт",null,"2012-10-05"]
[null,null,null,null,null,"Зеркало серебро 4 мм. торцы еврокромка, полировка ","148*1077",2,"СтеклоБалт",null,"СтеклоБалт",null,"2012-10-05"]
[null,null,null,null,null,"Стекло б/ц 10 мм. торцы еврокромка, полировка ","1200*465",1,"СтеклоБалт",null,"СтеклоБалт",null,"2012-10-05"]
[null,null,null,null,null,"Ручки кнопка Gamet, Хром глянец RC006CP.4","GN3204 ",24,"Boyard",null,"Boyard",null,"2012-09-27"]
[null,null,null,null,null,"Уголок хром глянец L-2500, (СМ. СЕРТЕЖ Уголок)","",15,"+",null,"+",null,"2012-09-28"]
[null,null,null,null,null,"Саморезы черные по дереву L-42","",150,"Юрий, нал.",null,"Юрий, нал.",null,"на скл."]
[null,null,null,null,null,"Направляющие шарик.    L-450 H- 45","",5,"GTV-Meridian",null,"A M I X",null,"2012-09-27"]
[null,null,null,null,null,"Направляющие шарик.    L-550 H- 45","",8,"GTV-Meridian",null,"GTV-Meridian",null,"2012-09-27"]
[null,null,null,null,null,"Эксцентрик D-15+Шток (резьба-евровинт)","",150,"ММ",null,"ММ",null,"2012-09-28"]
[null,null,null,null,null,"Фреза по дереву прямая D10 мм. Р.Д.25 мм.","",3,"скл.",null,"скл.",null,{"$f":"IF(K101=\"скл.\",\"на скл.\",\"\")","v":"на скл."}]
[null,null,null,null,null,"Саморезы     6 х 120 потай","",50,"Юрий, нал.",null,"Юрий, нал.",null,"2012-09-28"]
[null,null,null,null,null,"Саморезы     6 х 65 полукруг под крест","",40,"Юрий, нал.",null,"Юрий, нал.",null,"на скл."]
[null,null,null,null,null,"Копыта регулируемые забивные","",200,"ММ",null,"GTV-Meridian",null,"2012-09-27"]
[null,null,null,null,null,"Пеликан L-100-105, Хром Глянец","PP-DP0105 ",16,"GTV-Meridian",null,"GTV-Meridian",null,"2012-09-27"]
[null,null,null,null,null,"Планка монт. для крабов",null,8,null,null,"ММ",null,"2012-09-28"]
[".",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(K107=\"скл.\",\"на скл.\",\"\")","v":""}]
["218/1635",null,null,null,null,"Крепление","024",1,null,null,"ММ",null,"2012-09-28"]
[".",null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(K109=\"скл.\",\"на скл.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2012-11-29"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Здравствуйте, уважаемые специалисты по Excel и VBA. Решение моей несложной проблемы наверняка содержится в других, уже реализованных задачах, но сам я вычленить часть кода не могу. Ситуация следующая: в столбце A записаны номера заказов, в остальных столбцах таблицы другая информация, касающаяся соответствующих номеров. Причем одному номеру из столбца A может соответствовать несколько строк. В этом случае ячейки с номером объединены. Десятки раз в день необходимо найти номер заказа и прочитать информацию справа. Для этого мне приходится каждый раз выделять столбец A, нажимать Ctrl+f, вводить номер, нажимать кнопку \"Найти\" столько раз, сколько раз попадается нужный номер в столбце. А в идеале хотелось бы, чтобы поле поиска находилось на панели быстрого доступа вместе с кнопкой \"Найти\" и задача сводилась бы к вводу в поле поиска нужного номера и нажатию кнопки (либо нескольким нажатиям, если номеров в столбце несколько)."]