{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Свод","Стеллаж№1","Номенклатура","ЛистПодЗаказ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Стеллаж","Ярус","Позиция","КодПродукции","Наименование продукции (Номенклатура)","Дата прихода","Количество"]
[null,1,5,1,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C3-$D3,{4,\"C5\";3,\"F5\";2,\"I5\"},2,)))","v":"ТЛТ00003733"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C3-$D3,{4,\"D5\";3,\"J5\";2,\"G5\"},2,)))","v":"Номенклатура10"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C3-$D3,{4,\"D6\";3,\"G6\";2,\"J6\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C3-$D3,{4,\"E6\";3,\"H6\";2,\"K6\"},2,)))","v":1}]
[null,1,5,2,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C4-$D4,{4,\"C5\";3,\"F5\";2,\"I5\"},2,)))","v":"ТЛТ00003729"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C4-$D4,{4,\"D5\";3,\"J5\";2,\"G5\"},2,)))","v":"Номенклатура2"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C4-$D4,{4,\"D6\";3,\"G6\";2,\"J6\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C4-$D4,{4,\"E6\";3,\"H6\";2,\"K6\"},2,)))","v":14}]
[null,1,5,3,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C5-$D5,{4,\"C5\";3,\"F5\";2,\"I5\"},2,)))","v":"ТЛТ00000516"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C5-$D5,{4,\"D5\";3,\"J5\";2,\"G5\"},2,)))","v":"Номенклатура9"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C5-$D5,{4,\"D6\";3,\"G6\";2,\"J6\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C5-$D5,{4,\"E6\";3,\"H6\";2,\"K6\"},2,)))","v":45}]
[null,1,4,1,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C6-$D6,{3,\"C7\";2,\"F7\";2,\"I7\"},2,)))","v":"ТЛТ00003729"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C6-$D6,{3,\"D7\";2,\"J7\";1,\"G7\"},2,)))","v":"Номенклатура9"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C6-$D6,{3,\"D8\";2,\"G8\";1,\"J8\"},2,)))","v":"2020-02-11"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C6-$D6,{3,\"E8\";2,\"H8\";1,\"K8\"},2,)))","v":54}]
[null,1,4,2,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C7-$D7,{3,\"C7\";2,\"F7\";1,\"I7\"},2,)))","v":"ТЛТ00003716"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C7-$D7,{3,\"D7\";2,\"J7\";1,\"G7\"},2,)))","v":"Номенклатура9"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C7-$D7,{3,\"D8\";2,\"G8\";1,\"J8\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C7-$D7,{3,\"E8\";2,\"H8\";1,\"K8\"},2,)))","v":2356}]
[null,1,4,3,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C8-$D8,{3,\"C7\";2,\"F7\";1,\"I7\"},2,)))","v":"ТЛТ00003729"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C8-$D8,{3,\"D7\";2,\"J7\";1,\"G7\"},2,)))","v":"Номенклатура5"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C8-$D8,{3,\"D8\";2,\"G8\";1,\"J8\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C8-$D8,{3,\"E8\";2,\"H8\";1,\"K8\"},2,)))","v":1}]
[null,1,3,1,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C9-$D9,{2,\"C9\";1,\"F9\";0,\"I9\"},2,)))","v":"ТЛТ00003733"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C9-$D9,{2,\"D9\";1,\"G9\";0,\"J9\"},2,)))","v":"Номенклатура10"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C9-$D9,{2,\"D10\";1,\"G10\";0,\"J10\"},2,)))","v":"2020-02-14"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C9-$D9,{2,\"E10\";1,\"H10\";0,\"K10\"},2,)))","v":5445}]
[null,1,3,2,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C10-$D10,{2,\"C9\";1,\"F9\";0,\"I9\"},2,)))","v":"ТЛТ00003716"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C10-$D10,{2,\"D9\";1,\"G9\";0,\"J9\"},2,)))","v":"Номенклатура5"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C10-$D10,{2,\"D10\";1,\"G10\";0,\"J10\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C10-$D10,{2,\"E10\";1,\"H10\";0,\"K10\"},2,)))","v":5654}]
[null,1,3,3,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C11-$D11,{2,\"C9\";1,\"F9\";0,\"I9\"},2,)))","v":"ТЛТ00003720"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C11-$D11,{2,\"D9\";1,\"G9\";0,\"J9\"},2,)))","v":"Номенклатура8"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C11-$D11,{2,\"D10\";1,\"G10\";0,\"J10\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C11-$D11,{2,\"E10\";1,\"H10\";0,\"K10\"},2,)))","v":1}]
[null,1,2,1,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C12-$D12,{1,\"C11\";0,\"F11\";-1,\"I11\"},2,)))","v":"ТЛТ00003720"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C12-$D12,{1,\"D11\";0,\"G11\";-1,\"J11\"},2,)))","v":"Номенклатура8"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C12-$D12,{1,\"D12\";0,\"G12\";-1,\"J12\"},2,)))","v":"2020-02-17"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C12-$D12,{1,\"E12\";0,\"H12\";-1,\"K12\"},2,)))","v":345}]
[null,1,2,2,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C13-$D13,{1,\"C11\";0,\"F11\";-1,\"I11\"},2,)))","v":"ТЛТ00003733"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C13-$D13,{1,\"D11\";0,\"G11\";-1,\"J11\"},2,)))","v":"Номенклатура10"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C13-$D13,{1,\"D12\";0,\"G12\";-1,\"J12\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C13-$D13,{1,\"E12\";0,\"H12\";-1,\"K12\"},2,)))","v":1}]
[null,1,2,3,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C14-$D14,{1,\"C11\";0,\"F11\";-1,\"I11\"},2,)))","v":"ТЛТ00003719"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C14-$D14,{1,\"D11\";0,\"G11\";-1,\"J11\"},2,)))","v":"Номенклатура7"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C14-$D14,{1,\"D12\";0,\"G12\";-1,\"J12\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C14-$D14,{1,\"E12\";0,\"H12\";-1,\"K12\"},2,)))","v":1}]
[null,1,1,1,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C15-$D15,{0,\"C13\";-1,\"F13\";-2,\"I13\"},2,)))","v":"Заказ1"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C15-$D15,{0,\"D13\";-1,\"G13\";-2,\"J13\"},2,)))","v":"Под заказ покупателя №1"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C15-$D15,{0,\"D14\";-1,\"G14\";-2,\"J14\"},2,)))","v":"2020-02-22"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C15-$D15,{0,\"E14\";-1,\"H14\";-2,\"K14\"},2,)))","v":34}]
[null,1,1,2,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C16-$D16,{0,\"C13\";-1,\"F13\";-2,\"I13\"},2,)))","v":"Заказ2"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C16-$D16,{0,\"D13\";-1,\"G13\";-2,\"J13\"},2,)))","v":"Под заказ покупателя №2"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C16-$D16,{0,\"D14\";-1,\"G14\";-2,\"J14\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C16-$D16,{0,\"E14\";-1,\"H14\";-2,\"K14\"},2,)))","v":1}]
[null,1,1,3,{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C17-$D17,{0,\"C13\";-1,\"F13\";-2,\"I13\"},2,)))","v":"Заказ3"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C17-$D17,{0,\"D13\";-1,\"G13\";-2,\"J13\"},2,)))","v":"Под заказ покупателя №3"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C17-$D17,{0,\"D14\";-1,\"G14\";-2,\"J14\"},2,)))","v":"2020-02-01"},{"$f":"INDIRECT(CONCATENATE(\"Стеллаж№1!\",VLOOKUP($C17-$D17,{0,\"E14\";-1,\"H14\";-2,\"K14\"},2,)))","v":1}]

{"sheet":"Стеллаж№1","index":1,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,8,2,10],[4,8,5,8],[4,1,5,1],[1,2,1,4],[4,2,5,2],[2,5,2,7],[4,5,5,5],[4,3,4,4],[1,5,1,7],[1,8,1,10],[4,6,4,7],[1,1,3,1],[2,2,2,4],[4,9,4,10],[10,9,10,10],[12,9,12,10],[12,3,12,4],[10,1,11,1],[10,2,11,2],[10,5,11,5],[10,8,11,8],[12,1,13,1],[12,2,13,2],[12,5,13,5],[12,8,13,8],[10,3,10,4],[10,6,10,7],[12,6,12,7],[8,9,8,10],[6,1,7,1],[6,2,7,2],[6,5,7,5],[6,8,7,8],[8,1,9,1],[8,2,9,2],[8,5,9,5],[8,8,9,8],[6,3,6,4],[8,3,8,4],[6,6,6,7],[8,6,8,7],[6,9,6,10]]}
[]
[null,"Стеллаж №1","Позиция №1",null,null,"Позиция №2",null,null,"Позиция №3"]
[null,null,"Наименование продукции (Номенклатура)",null,null,"Наименование продукции (Номенклатура)",null,null,"Наименование продукции (Номенклатура)"]
[null,null,"Код продукции","Дата прихода","Количество","Код продукции","Дата прихода","Количество","Код продукции","Дата прихода","Количество"]
[null,"Ярус №5","ТЛТ00003733",{"$f":"VLOOKUP(C5,Номенклатура!$B:$C,2,0)","v":"Номенклатура10"},null,"ТЛТ00003729",{"$f":"VLOOKUP(F5,Номенклатура!$B:$C,2,0)","v":"Номенклатура9"},null,"ТЛТ00000516",{"$f":"VLOOKUP(I5,Номенклатура!$B:$C,2,0)","v":"Номенклатура2"}]
[null,null,null,"2020-02-01",1,null,"2020-02-01",14,null,"2020-02-01",45]
[null,"Ярус №4","ТЛТ00003729",{"$f":"VLOOKUP(C7,Номенклатура!$B:$C,2,0)","v":"Номенклатура9"},null,"ТЛТ00003716",{"$f":"VLOOKUP(F7,Номенклатура!$B:$C,2,0)","v":"Номенклатура5"},null,"ТЛТ00003729",{"$f":"VLOOKUP(I7,Номенклатура!$B:$C,2,0)","v":"Номенклатура9"}]
[null,null,null,"2020-02-11",54,null,"2020-02-01",2356,null,"2020-02-01",1]
[null,"Ярус №3","ТЛТ00003733",{"$f":"VLOOKUP(C9,Номенклатура!$B:$C,2,0)","v":"Номенклатура10"},null,"ТЛТ00003716",{"$f":"VLOOKUP(F9,Номенклатура!$B:$C,2,0)","v":"Номенклатура5"},null,"ТЛТ00003720",{"$f":"VLOOKUP(I9,Номенклатура!$B:$C,2,0)","v":"Номенклатура8"}]
[null,null,null,"2020-02-14",5445,null,"2020-02-01",5654,null,"2020-02-01",1]
[null,"Ярус №2","ТЛТ00003720",{"$f":"VLOOKUP(C11,Номенклатура!$B:$C,2,0)","v":"Номенклатура8"},null,"ТЛТ00003733",{"$f":"VLOOKUP(F11,Номенклатура!$B:$C,2,0)","v":"Номенклатура10"},null,"ТЛТ00003719",{"$f":"VLOOKUP(I11,Номенклатура!$B:$C,2,0)","v":"Номенклатура7"}]
[null,null,null,"2020-02-17",345,null,"2020-02-01",1,null,"2020-02-01",1]
[null,"Ярус №1","Заказ1",{"$f":"VLOOKUP(C13,Номенклатура!$B:$C,2,0)","v":"Под заказ покупателя №1"},null,"Заказ2",{"$f":"VLOOKUP(F13,Номенклатура!$B:$C,2,0)","v":"Под заказ покупателя №2"},null,"Заказ3",{"$f":"VLOOKUP(I13,Номенклатура!$B:$C,2,0)","v":"Под заказ покупателя №3"}]
[null,null,null,"2020-02-22",34,null,"2020-02-01",1,null,"2020-02-01",1]

{"sheet":"Номенклатура","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Пустая"]
[null,"ТЛТ00000515","Номенклатура1"]
[null,"ТЛТ00000516","Номенклатура2"]
[null,"ТЛТ00002188","Номенклатура3"]
[null,"ТЛТ00003709","Номенклатура4"]
[null,"ТЛТ00003715","Номенклатура4"]
[null,"ТЛТ00003716","Номенклатура5"]
[null,"ТЛТ00003718","Номенклатура6"]
[null,"ТЛТ00003719","Номенклатура7"]
[null,"ТЛТ00003720","Номенклатура8"]
[null,"ТЛТ00003729","Номенклатура9"]
[null,"ТЛТ00003733","Номенклатура10"]
[null,"Заказ1","Под заказ покупателя №1"]
[null,"Заказ2","Под заказ покупателя №2"]
[null,"Заказ3","Под заказ покупателя №3"]
[null,"Заказ4","Под заказ покупателя №4"]
[null,"Заказ5","Под заказ покупателя №5"]

{"sheet":"ЛистПодЗаказ","index":3,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[[25,1,26,1],[25,2,25,3],[27,1,28,1],[27,2,27,3],[47,1,48,1],[47,2,47,3],[41,1,42,1],[41,2,41,3],[43,1,44,1],[43,2,43,3],[45,1,46,1],[45,2,45,3],[35,1,36,1],[35,2,35,3],[37,1,38,1],[37,2,37,3],[39,1,40,1],[39,2,39,3],[29,1,30,1],[29,2,29,3],[31,1,32,1],[31,2,31,3],[33,1,34,1],[33,2,33,3],[23,1,24,1],[23,2,23,3],[19,1,20,1],[19,2,19,3],[21,1,22,1],[21,2,21,3],[13,1,14,1],[13,2,13,3],[15,1,16,1],[15,2,15,3],[17,1,18,1],[17,2,17,3],[7,1,8,1],[7,2,7,3],[9,1,10,1],[9,2,9,3],[11,1,12,1],[11,2,11,3],[1,1,2,1],[1,2,1,3],[3,1,4,1],[3,2,3,3],[5,1,6,1],[5,2,5,3]]}
[]
[null,"Пустая",{"$f":"VLOOKUP(B2,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B4,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B6,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B8,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B10,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B12,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B14,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B16,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B18,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B20,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B22,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B24,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B26,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B28,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B30,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B32,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B34,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B36,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B38,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B40,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B42,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B44,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B46,Номенклатура!$B:$C,2,0)","v":0}]
[]
[null,"Пустая",{"$f":"VLOOKUP(B48,Номенклатура!$B:$C,2,0)","v":0}]