{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Первичные параметры","База Данных"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,"Оглавление:"]
[]
[1,"Analytik Jena",null,null,null,"Аббревиатуры ",null,null,"Отправитель"]
[2,"Bio Qiup",null,null,"Б","Бронь",null,null,"Производитель"]
[3,"Bioscape",null,null,"П","Продано",null,null,"EU IMTEX"]
[4,"Braintree",null,null,"Н","Оборудование в наличии у дилеров на складе"]
[5,"Camspec",null,null,"О","Остаток оборудования - свободное"]
[6,"Clean Air Solution",null,null,"С","Складские остатки"]
[7,"Consort"]
[8,"Conviron",null,null,"Дата Б","-Дата бронирования"]
[9,"Daihan",null,null,"Дата ОБ","-Дата окончания брони"]
[10,"Danki",null,null,"Дн до ОБ","Количество дней до окончания бронирования"]
[11,"Ebro"]
[12,"Elga"]
[13,"Esco"]
[14,"Facchini"]
[15,"Fengshi (3W)"]
[16,"Fistreem"]
[17,"Funke Gerber"]
[18,"Haier"]
[19,"Hirschmann"]
[20,"Ika"]
[21,"Jeio Tech"]
[22,"Matachana"]
[23,"MPW"]
[24,"Optika"]
[25,"Orka",null,null,null,"ФИО сотрудников",null,"E-mail:"]
[26,"Plas-Labs",null,null,1,"Абрамова Е.Е."]
[27,"Sanyo/Panasonic",null,null,2,"Акопов Б.Г."]
[28,"Selecta",null,null,3,"Асланянц А.Р."]
[29,"Sonics",null,null,4,"Асланянц С.Р."]
[30,"Vilber Lourmat",null,null,5,"Бобрицкая Е.В."]
[null,null,null,null,6,"Борисова М.Е."]
[null,null,null,null,7,"Вахрушин Е.В."]
[null,null,null,null,8,"Вепренцева Т.Г."]
[null,null,null,null,9,"Володин Ю.А."]
[null,null,null,null,10,"Выганов Д.А."]
[null,null,null,null,11,"Горелов П.В."]
[null,null,null,null,12,"Григорьева Р.З."]
[null,null,null,null,13,"Егоров А.А."]
[null,null,null,null,14,"Искра И.В."]
[null,null,null,null,15,"Коваль М.А."]
[null,null,null,null,16,"Коренев М.В."]
[null,null,null,null,17,"Лапин М.В."]
[null,null,null,null,18,"Лебедева С.Е."]
[null,null,null,null,19,"Ляхов П.Н."]
[null,null,null,null,20,"Молодых М.М."]
[null,null,null,null,21,"Нагаев В.Х."]
[null,null,null,null,22,"Рабчун М.А."]
[null,null,null,null,23,"Сотсков А.С."]
[null,null,null,null,24,"Спиридонова О.А."]
[null,null,null,null,25,"Треножкина Ю.А."]
[null,null,null,null,26,"Трошинкин Д.О."]
[null,null,null,null,null,null,null,"sklad@awt.ru"]

{"sheet":"База Данных","index":1,"n_rows":14,"n_cols":97,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,2,1],[0,83,0,96],[0,17,1,21],[0,22,1,26],[0,7,1,11],[0,12,1,16],[0,37,1,41],[1,93,1,94],[1,95,1,96],[1,83,1,84],[1,85,1,86],[1,87,1,88],[1,89,1,90],[1,91,1,92],[0,77,1,81],[0,2,1,6],[0,67,1,71],[0,72,1,76],[0,42,1,46],[0,47,1,51],[0,52,1,56],[0,57,1,61],[0,62,1,66],[0,27,1,31],[0,32,1,36]]}
["Кат. номер","Наименование Товара","Состояние Заказа",null,null,null,null,"Акопов Б.Г.",null,null,null,null,"Бобрицкая Е.В.",null,null,null,null,"Борисова М.Е.",null,null,null,null,"Вахрушин Е.В.",null,null,null,null,"Выганов Д.А.",null,null,null,null,"Горелов П.В.",null,null,null,null,"Искра И.В.",null,null,null,null,"Коваль М.А.",null,null,null,null,"Коренев М.В.",null,null,null,null,"Лапин М.В.",null,null,null,null,"Лебедева С.Е.",null,null,null,null,"Ляхов П.Н.",null,null,null,null,"Нагаев В.Х.",null,null,null,null,"Сотсков А.С.",null,null,null,null,"Трошинкин Д.О.",null,null,null,null,null,"СКЛАДЫ ДИЛЕРОВ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Омск (МЛК-Сервис)",null,"Санкт-Петербург (ТрансАналит)",null,"Калининград (ГК Вектор)",null,"Новосибирск (Сибирь-комплект)",null,"Пермь (Уралхимэкология)",null,"Пермь (Медуниверсал-М)",null,"Краснодар (ЛабСтар)"]
[null,null,"С","Н","Б","П","О","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П","Б","Дата Б","Дата ОБ","Дн до ОБ","П",null,"Н","Б","Н","Б","Н","Б","Н","Б","Н","Б","Н","Б","Н","Б"]
[]
["Analytik Jena","ИТОГО:",{"$f":"SUM(C6:C14)","v":0},{"$f":"SUM(D6:D14)","v":0},{"$f":"SUM(E6:E14)","v":0},{"$f":"SUM(F6:F14)","v":0},{"$f":"SUM(G6:G14)","v":0},{"$f":"SUM(H6:H14)","v":0},null,null,null,{"$f":"SUM(L6:L14)","v":0},{"$f":"SUM(M6:M14)","v":0},null,null,null,{"$f":"SUM(Q6:Q14)","v":0},{"$f":"SUM(R6:R14)","v":0},null,null,null,{"$f":"SUM(V6:V14)","v":0},{"$f":"SUM(W6:W14)","v":0},null,null,null,{"$f":"SUM(AA6:AA14)","v":0},{"$f":"SUM(AB6:AB14)","v":0},null,null,null,{"$f":"SUM(AF6:AF14)","v":0},{"$f":"SUM(AG6:AG14)","v":0},null,null,null,{"$f":"SUM(AK6:AK14)","v":0},{"$f":"SUM(AL6:AL14)","v":0},null,null,null,{"$f":"SUM(AP6:AP14)","v":0},{"$f":"SUM(AQ6:AQ14)","v":0},null,null,null,{"$f":"SUM(AU6:AU14)","v":0},{"$f":"SUM(AV6:AV14)","v":0},null,null,null,{"$f":"SUM(AZ6:AZ14)","v":0},{"$f":"SUM(BA6:BA14)","v":0},null,null,null,{"$f":"SUM(BE6:BE14)","v":0},{"$f":"SUM(BF6:BF14)","v":0},null,null,null,{"$f":"SUM(BJ6:BJ14)","v":0},{"$f":"SUM(BK6:BK14)","v":0},null,null,null,{"$f":"SUM(BO6:BO14)","v":0},{"$f":"SUM(BP6:BP14)","v":0},null,null,null,{"$f":"SUM(BT6:BT14)","v":0},{"$f":"SUM(BU6:BU14)","v":0},null,null,null,{"$f":"SUM(BY6:BY14)","v":0},{"$f":"SUM(BZ6:BZ14)","v":0},null,null,null,{"$f":"SUM(CD6:CD14)","v":0},null,{"$f":"SUM(CF6:CF14)","v":0},{"$f":"SUM(CG6:CG14)","v":0},{"$f":"SUM(CH6:CH14)","v":0},{"$f":"SUM(CI6:CI14)","v":0},{"$f":"SUM(CJ6:CJ14)","v":0},{"$f":"SUM(CK6:CK14)","v":0},{"$f":"SUM(CL6:CL14)","v":0},{"$f":"SUM(CM6:CM14)","v":0},{"$f":"SUM(CN6:CN14)","v":0},{"$f":"SUM(CO6:CO14)","v":0},{"$f":"SUM(CP6:CP14)","v":0},{"$f":"SUM(CQ6:CQ14)","v":0},{"$f":"SUM(CR6:CR14)","v":0},{"$f":"SUM(CS6:CS14)","v":0}]
[null,null,null,{"$f":"CF6+CH6+CJ6+CL6+CN6+CP6+CR6","v":0},{"$f":"IFERROR(IF((H6+M6+R6+W6+AB6+AG6+AL6+AQ6+AV6+BA6+BF6+BK6+BP6+BU6+BZ6+CG6+CI6+CK6+CM6+CO6+CQ6+CS6)>(C6+D6-F6),\"Ошибка\",(H6+M6+R6+W6+AB6+AG6+AL6+AQ6+AV6+BA6+BF6+BK6+BP6+BU6+BZ6+CG6+CI6+CK6+CM6+CO6+CQ6+CS6)),\"Ошибка\")","v":0},{"$f":"IF((L6+Q6+V6+AA6+AF6+AK6+AP6+AU6+AZ6+BE6+BJ6+BO6+BT6+BY6+CD6)>(D6+C6), \"Ошибка\",(L6+Q6+V6+AA6+AF6+AK6+AP6+AU6+AZ6+BE6+BJ6+BO6+BT6+BY6+CD6))","v":0},{"$f":"IFERROR(C6+D6-E6-F6,\"Ошибка\")","v":0},null,null,{"$f":"IF(ISBLANK(I6),\"\",I6+14)","v":""},{"$f":"IF(J6=\"\",\"\",J6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(N6),\"\",N6+14)","v":""},{"$f":"IF(O6=\"\",\"\",O6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(S6),\"\",S6+14)","v":""},{"$f":"IF(T6=\"\",\"\",T6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(X6),\"\",X6+14)","v":""},{"$f":"IF(Y6=\"\",\"\",Y6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(AC6),\"\",AC6+14)","v":""},{"$f":"IF(AD6=\"\",\"\",AD6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(AH6),\"\",AH6+14)","v":""},{"$f":"IF(AI6=\"\",\"\",AI6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(AM6),\"\",AM6+14)","v":""},{"$f":"IF(AN6=\"\",\"\",AN6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(AR6),\"\",AR6+14)","v":""},{"$f":"IF(AS6=\"\",\"\",AS6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(AW6),\"\",AW6+14)","v":""},{"$f":"IF(AX6=\"\",\"\",AX6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(BB6),\"\",BB6+14)","v":""},{"$f":"IF(BC6=\"\",\"\",BC6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(BG6),\"\",BG6+14)","v":""},{"$f":"IF(BH6=\"\",\"\",BH6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(BL6),\"\",BL6+14)","v":""},{"$f":"IF(BM6=\"\",\"\",BM6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(BQ6),\"\",BQ6+14)","v":""},{"$f":"IF(BR6=\"\",\"\",BR6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(BV6),\"\",BV6+14)","v":""},{"$f":"IF(BW6=\"\",\"\",BW6-TODAY())","v":""},null,null,null,{"$f":"IF(ISBLANK(CA6),\"\",CA6+14)","v":""},{"$f":"IF(CB6=\"\",\"\",CB6-TODAY())","v":""}]
[null,null,null,0,{"$f":"IFERROR(IF((H7+M7+R7+W7+AB7+AG7+AL7+AQ7+AV7+BA7+BF7+BK7+BP7+BU7+BZ7+CG7+CI7+CK7+CM7+CO7+CQ7+CS7)>(C7+D7-F7),\"Ошибка\",(H7+M7+R7+W7+AB7+AG7+AL7+AQ7+AV7+BA7+BF7+BK7+BP7+BU7+BZ7+CG7+CI7+CK7+CM7+CO7+CQ7+CS7)),\"Ошибка\")","v":0},{"$f":"IF((L7+Q7+V7+AA7+AF7+AK7+AP7+AU7+AZ7+BE7+BJ7+BO7+BT7+BY7+CD7)>(D7+C7), \"Ошибка\",(L7+Q7+V7+AA7+AF7+AK7+AP7+AU7+AZ7+BE7+BJ7+BO7+BT7+BY7+CD7))","v":0},{"$f":"IFERROR(C7+D7-E7-F7,\"Ошибка\")","v":0},null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]
[null,null,null,0,0,0,0,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"","",null,null,null,"",""]