{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Сухофрукты","Изюм","Шиповник","Курага","Бананы","Яблоки"],"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":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[49,5,49,7],[50,5,50,7],[51,5,51,7],[13,5,13,7],[13,3,13,4],[51,3,51,4],[45,5,45,7],[46,5,46,7],[47,5,47,7],[48,5,48,7],[39,5,39,7],[40,5,40,7],[41,5,41,7],[42,5,42,7],[43,5,43,7],[44,5,44,7],[38,5,38,7],[27,5,27,7],[28,5,28,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[33,5,33,7],[34,5,34,7],[35,5,35,7],[36,5,36,7],[37,5,37,7],[26,5,26,7],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[9,5,9,7],[10,5,10,7],[11,5,11,7],[12,5,12,7],[7,5,7,7],[14,5,14,7],[49,3,49,4],[50,3,50,4],[1,11,1,12],[2,11,2,12],[4,1,4,3],[4,4,4,12],[6,5,6,7],[8,5,8,7],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[42,3,42,4],[39,3,39,4],[40,3,40,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[41,3,41,4],[30,3,30,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[18,3,18,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[7,3,7,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[5,3,5,4],[6,3,6,4]]}
[0]
[null,"Склад","Стеллаж","Ед. изм.",null,"Цена","Марка","Сорт","Профиль","Размер","Наменкла-турный №","Номер запаса"]
[null,null,null,"кг"]
[]
[null,"Наименование материала",null,null,{"$f":"ИМЯЛИСТА()","v":"Сухофрукты"}]
[]
[null,"Дата записи","№ Доку-мента","Пор. № записи",null,"От кого получено или кому отпущено",null,null,"Приход","Расход","Остаток","Общий расход","Общий остаток"]
[null,"2021-07-31",null,178,null,null,null,null,null,null,7.4,3.7,11.1]
[null,"2021-08-01",null,{"$f":"IF(AND(D8 <> \"\", K9 <> \"\"), D8 + 1, \"\")","v":179},null,{"$f":"IF(AND(I9 <> \"\", J9 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I9 <> \"\", J9 = \"\"), Поставщик(), IF(AND(I9 = \"\", J9 <> \"\"), \"Кухня\", \"\")))","v":"Кухня"},null,null,null,0.5,{"$f":"IF(OR(I9<>\"\",J9<>\"\"),K8-J9+I9,\"\")","v":6.9}]
[null,null,null,{"$f":"IF(AND(D9 <> \"\", K10 <> \"\"), D9 + 1, \"\")","v":180},null,{"$f":"IF(AND(I10 <> \"\", J10 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I10 <> \"\", J10 = \"\"), Поставщик(), IF(AND(I10 = \"\", J10 <> \"\"), \"Кухня\", \"\")))","v":"Кухня"},null,null,null,6.9,{"$f":"IF(OR(I10<>\"\",J10<>\"\"),K9-J10+I10,\"\")","v":0}]
[null,null,null,{"$f":"IF(AND(D10 <> \"\", K11 <> \"\"), D10 + 1, \"\")","v":""},null,{"$f":"IF(AND(I11 <> \"\", J11 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I11 <> \"\", J11 = \"\"), Поставщик(), IF(AND(I11 = \"\", J11 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I11<>\"\",J11<>\"\"),K10-J11+I11,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I12 <> \"\", J12 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I12 <> \"\", J12 = \"\"), Поставщик(), IF(AND(I12 = \"\", J12 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I13 <> \"\", J13 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I13 <> \"\", J13 = \"\"), Поставщик(), IF(AND(I13 = \"\", J13 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I14 <> \"\", J14 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I14 <> \"\", J14 = \"\"), Поставщик(), IF(AND(I14 = \"\", J14 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I15 <> \"\", J15 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I15 <> \"\", J15 = \"\"), Поставщик(), IF(AND(I15 = \"\", J15 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I15<>\"\",J15<>\"\"),K14-J15+I15,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I16 <> \"\", J16 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I16 <> \"\", J16 = \"\"), Поставщик(), IF(AND(I16 = \"\", J16 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I17 <> \"\", J17 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I17 <> \"\", J17 = \"\"), Поставщик(), IF(AND(I17 = \"\", J17 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I18 <> \"\", J18 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I18 <> \"\", J18 = \"\"), Поставщик(), IF(AND(I18 = \"\", J18 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I19 <> \"\", J19 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I19 <> \"\", J19 = \"\"), Поставщик(), IF(AND(I19 = \"\", J19 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I20 <> \"\", J20 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I20 <> \"\", J20 = \"\"), Поставщик(), IF(AND(I20 = \"\", J20 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I21 <> \"\", J21 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I21 <> \"\", J21 = \"\"), Поставщик(), IF(AND(I21 = \"\", J21 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I22 <> \"\", J22 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I22 <> \"\", J22 = \"\"), Поставщик(), IF(AND(I22 = \"\", J22 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I23 <> \"\", J23 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I23 <> \"\", J23 = \"\"), Поставщик(), IF(AND(I23 = \"\", J23 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I24 <> \"\", J24 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I24 <> \"\", J24 = \"\"), Поставщик(), IF(AND(I24 = \"\", J24 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I25 <> \"\", J25 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I25 <> \"\", J25 = \"\"), Поставщик(), IF(AND(I25 = \"\", J25 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I26 <> \"\", J26 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I26 <> \"\", J26 = \"\"), Поставщик(), IF(AND(I26 = \"\", J26 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I27 <> \"\", J27 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I27 <> \"\", J27 = \"\"), Поставщик(), IF(AND(I27 = \"\", J27 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I28 <> \"\", J28 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I28 <> \"\", J28 = \"\"), Поставщик(), IF(AND(I28 = \"\", J28 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I29 <> \"\", J29 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I29 <> \"\", J29 = \"\"), Поставщик(), IF(AND(I29 = \"\", J29 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I30 <> \"\", J30 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I30 <> \"\", J30 = \"\"), Поставщик(), IF(AND(I30 = \"\", J30 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I31 <> \"\", J31 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I31 <> \"\", J31 = \"\"), Поставщик(), IF(AND(I31 = \"\", J31 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I32 <> \"\", J32 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I32 <> \"\", J32 = \"\"), Поставщик(), IF(AND(I32 = \"\", J32 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I33 <> \"\", J33 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I33 <> \"\", J33 = \"\"), Поставщик(), IF(AND(I33 = \"\", J33 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I34 <> \"\", J34 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I34 <> \"\", J34 = \"\"), Поставщик(), IF(AND(I34 = \"\", J34 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I35 <> \"\", J35 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I35 <> \"\", J35 = \"\"), Поставщик(), IF(AND(I35 = \"\", J35 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I36 <> \"\", J36 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I36 <> \"\", J36 = \"\"), Поставщик(), IF(AND(I36 = \"\", J36 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I37 <> \"\", J37 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I37 <> \"\", J37 = \"\"), Поставщик(), IF(AND(I37 = \"\", J37 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I38 <> \"\", J38 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I38 <> \"\", J38 = \"\"), Поставщик(), IF(AND(I38 = \"\", J38 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I39 <> \"\", J39 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I39 <> \"\", J39 = \"\"), Поставщик(), IF(AND(I39 = \"\", J39 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I40 <> \"\", J40 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I40 <> \"\", J40 = \"\"), Поставщик(), IF(AND(I40 = \"\", J40 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I41 <> \"\", J41 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I41 <> \"\", J41 = \"\"), Поставщик(), IF(AND(I41 = \"\", J41 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I42 <> \"\", J42 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I42 <> \"\", J42 = \"\"), Поставщик(), IF(AND(I42 = \"\", J42 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I43 <> \"\", J43 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I43 <> \"\", J43 = \"\"), Поставщик(), IF(AND(I43 = \"\", J43 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I44 <> \"\", J44 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I44 <> \"\", J44 = \"\"), Поставщик(), IF(AND(I44 = \"\", J44 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I45 <> \"\", J45 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I45 <> \"\", J45 = \"\"), Поставщик(), IF(AND(I45 = \"\", J45 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I46 <> \"\", J46 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I46 <> \"\", J46 = \"\"), Поставщик(), IF(AND(I46 = \"\", J46 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I47 <> \"\", J47 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I47 <> \"\", J47 = \"\"), Поставщик(), IF(AND(I47 = \"\", J47 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I48 <> \"\", J48 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I48 <> \"\", J48 = \"\"), Поставщик(), IF(AND(I48 = \"\", J48 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I49 <> \"\", J49 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I49 <> \"\", J49 = \"\"), Поставщик(), IF(AND(I49 = \"\", J49 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I50 <> \"\", J50 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I50 <> \"\", J50 = \"\"), Поставщик(), IF(AND(I50 = \"\", J50 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I51 <> \"\", J51 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I51 <> \"\", J51 = \"\"), Поставщик(), IF(AND(I51 = \"\", J51 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I52 <> \"\", J52 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I52 <> \"\", J52 = \"\"), Поставщик(), IF(AND(I52 = \"\", J52 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]

{"sheet":"Изюм","index":1,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,7],[1,3,1,4],[1,11,1,12],[2,3,2,4],[2,11,2,12],[3,3,3,4],[4,1,4,3],[4,4,4,12],[5,3,5,4],[6,3,6,4],[6,5,6,7],[7,3,7,4],[7,5,7,7],[9,3,9,4],[9,5,9,7],[10,3,10,4],[10,5,10,7],[11,3,11,4],[11,5,11,7],[12,3,12,4],[12,5,12,7],[13,3,13,4],[13,5,13,7],[14,3,14,4],[14,5,14,7],[15,3,15,4],[15,5,15,7],[16,3,16,4],[16,5,16,7],[17,3,17,4],[17,5,17,7],[18,3,18,4],[18,5,18,7],[19,3,19,4],[19,5,19,7],[20,3,20,4],[20,5,20,7],[21,3,21,4],[21,5,21,7],[22,3,22,4],[22,5,22,7],[23,3,23,4],[23,5,23,7],[24,3,24,4],[24,5,24,7],[25,3,25,4],[25,5,25,7],[26,3,26,4],[26,5,26,7],[27,3,27,4],[27,5,27,7],[28,3,28,4],[28,5,28,7],[29,3,29,4],[29,5,29,7],[30,3,30,4],[30,5,30,7],[31,3,31,4],[31,5,31,7],[32,3,32,4],[32,5,32,7],[33,3,33,4],[33,5,33,7],[34,3,34,4],[34,5,34,7],[35,3,35,4],[35,5,35,7],[36,3,36,4],[36,5,36,7],[37,3,37,4],[37,5,37,7],[38,3,38,4],[38,5,38,7],[39,3,39,4],[39,5,39,7],[40,3,40,4],[40,5,40,7],[41,3,41,4],[41,5,41,7],[42,3,42,4],[42,5,42,7],[43,3,43,4],[43,5,43,7],[44,3,44,4],[44,5,44,7],[45,3,45,4],[45,5,45,7],[46,3,46,4],[46,5,46,7],[47,3,47,4],[47,5,47,7],[51,3,51,4],[51,5,51,7],[48,3,48,4],[48,5,48,7],[49,3,49,4],[49,5,49,7],[50,3,50,4],[50,5,50,7]]}
[0]
[null,"Склад","Стеллаж","Ед. изм.",null,"Цена","Марка","Сорт","Профиль","Размер","Наменкла-турный №","Номер запаса"]
[null,null,null,"кг"]
[]
[null,"Наименование материала",null,null,{"$f":"ИМЯЛИСТА()","v":"Изюм"}]
[]
[null,"Дата записи","№ Доку-мента","Пор. № записи",null,"От кого получено или кому отпущено",null,null,"Приход","Расход","Остаток","Общий расход","Общий остаток"]
[null,"2021-07-31",null,126,null,null,null,null,null,null,3.5,1.1000000000000001,4.5999999999999996]
[null,"2021-08-03",null,{"$f":"IF(AND(D8 <> \"\", K9 <> \"\"), D8 + 1, \"\")","v":127},null,{"$f":"IF(AND(I9 <> \"\", J9 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I9 <> \"\", J9 = \"\"), Поставщик(), IF(AND(I9 = \"\", J9 <> \"\"), \"Кухня\", \"\")))","v":"Кухня"},null,null,null,0.2,{"$f":"IF(OR(I9<>\"\",J9<>\"\"),K8-J9+I9,\"\")","v":3.3}]
[null,null,null,"",null,{"$f":"IF(AND(I10 <> \"\", J10 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I10 <> \"\", J10 = \"\"), Поставщик(), IF(AND(I10 = \"\", J10 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I10<>\"\",J10<>\"\"),K9-J10+I10,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I11 <> \"\", J11 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I11 <> \"\", J11 = \"\"), Поставщик(), IF(AND(I11 = \"\", J11 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I11<>\"\",J11<>\"\"),K10-J11+I11,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I12 <> \"\", J12 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I12 <> \"\", J12 = \"\"), Поставщик(), IF(AND(I12 = \"\", J12 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I13 <> \"\", J13 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I13 <> \"\", J13 = \"\"), Поставщик(), IF(AND(I13 = \"\", J13 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I14 <> \"\", J14 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I14 <> \"\", J14 = \"\"), Поставщик(), IF(AND(I14 = \"\", J14 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I15 <> \"\", J15 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I15 <> \"\", J15 = \"\"), Поставщик(), IF(AND(I15 = \"\", J15 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I15<>\"\",J15<>\"\"),K14-J15+I15,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I16 <> \"\", J16 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I16 <> \"\", J16 = \"\"), Поставщик(), IF(AND(I16 = \"\", J16 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I17 <> \"\", J17 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I17 <> \"\", J17 = \"\"), Поставщик(), IF(AND(I17 = \"\", J17 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I18 <> \"\", J18 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I18 <> \"\", J18 = \"\"), Поставщик(), IF(AND(I18 = \"\", J18 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I19 <> \"\", J19 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I19 <> \"\", J19 = \"\"), Поставщик(), IF(AND(I19 = \"\", J19 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I20 <> \"\", J20 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I20 <> \"\", J20 = \"\"), Поставщик(), IF(AND(I20 = \"\", J20 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I21 <> \"\", J21 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I21 <> \"\", J21 = \"\"), Поставщик(), IF(AND(I21 = \"\", J21 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I22 <> \"\", J22 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I22 <> \"\", J22 = \"\"), Поставщик(), IF(AND(I22 = \"\", J22 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I23 <> \"\", J23 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I23 <> \"\", J23 = \"\"), Поставщик(), IF(AND(I23 = \"\", J23 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I24 <> \"\", J24 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I24 <> \"\", J24 = \"\"), Поставщик(), IF(AND(I24 = \"\", J24 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I25 <> \"\", J25 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I25 <> \"\", J25 = \"\"), Поставщик(), IF(AND(I25 = \"\", J25 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I26 <> \"\", J26 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I26 <> \"\", J26 = \"\"), Поставщик(), IF(AND(I26 = \"\", J26 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I27 <> \"\", J27 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I27 <> \"\", J27 = \"\"), Поставщик(), IF(AND(I27 = \"\", J27 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I28 <> \"\", J28 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I28 <> \"\", J28 = \"\"), Поставщик(), IF(AND(I28 = \"\", J28 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I29 <> \"\", J29 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I29 <> \"\", J29 = \"\"), Поставщик(), IF(AND(I29 = \"\", J29 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I30 <> \"\", J30 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I30 <> \"\", J30 = \"\"), Поставщик(), IF(AND(I30 = \"\", J30 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I31 <> \"\", J31 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I31 <> \"\", J31 = \"\"), Поставщик(), IF(AND(I31 = \"\", J31 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I32 <> \"\", J32 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I32 <> \"\", J32 = \"\"), Поставщик(), IF(AND(I32 = \"\", J32 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I33 <> \"\", J33 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I33 <> \"\", J33 = \"\"), Поставщик(), IF(AND(I33 = \"\", J33 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I34 <> \"\", J34 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I34 <> \"\", J34 = \"\"), Поставщик(), IF(AND(I34 = \"\", J34 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I35 <> \"\", J35 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I35 <> \"\", J35 = \"\"), Поставщик(), IF(AND(I35 = \"\", J35 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I36 <> \"\", J36 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I36 <> \"\", J36 = \"\"), Поставщик(), IF(AND(I36 = \"\", J36 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I37 <> \"\", J37 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I37 <> \"\", J37 = \"\"), Поставщик(), IF(AND(I37 = \"\", J37 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I38 <> \"\", J38 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I38 <> \"\", J38 = \"\"), Поставщик(), IF(AND(I38 = \"\", J38 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I39 <> \"\", J39 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I39 <> \"\", J39 = \"\"), Поставщик(), IF(AND(I39 = \"\", J39 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I40 <> \"\", J40 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I40 <> \"\", J40 = \"\"), Поставщик(), IF(AND(I40 = \"\", J40 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I41 <> \"\", J41 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I41 <> \"\", J41 = \"\"), Поставщик(), IF(AND(I41 = \"\", J41 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I42 <> \"\", J42 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I42 <> \"\", J42 = \"\"), Поставщик(), IF(AND(I42 = \"\", J42 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I43 <> \"\", J43 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I43 <> \"\", J43 = \"\"), Поставщик(), IF(AND(I43 = \"\", J43 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I44 <> \"\", J44 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I44 <> \"\", J44 = \"\"), Поставщик(), IF(AND(I44 = \"\", J44 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I45 <> \"\", J45 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I45 <> \"\", J45 = \"\"), Поставщик(), IF(AND(I45 = \"\", J45 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I46 <> \"\", J46 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I46 <> \"\", J46 = \"\"), Поставщик(), IF(AND(I46 = \"\", J46 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I47 <> \"\", J47 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I47 <> \"\", J47 = \"\"), Поставщик(), IF(AND(I47 = \"\", J47 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I48 <> \"\", J48 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I48 <> \"\", J48 = \"\"), Поставщик(), IF(AND(I48 = \"\", J48 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I49 <> \"\", J49 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I49 <> \"\", J49 = \"\"), Поставщик(), IF(AND(I49 = \"\", J49 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I50 <> \"\", J50 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I50 <> \"\", J50 = \"\"), Поставщик(), IF(AND(I50 = \"\", J50 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I51 <> \"\", J51 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I51 <> \"\", J51 = \"\"), Поставщик(), IF(AND(I51 = \"\", J51 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I52 <> \"\", J52 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I52 <> \"\", J52 = \"\"), Поставщик(), IF(AND(I52 = \"\", J52 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]

{"sheet":"Шиповник","index":2,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,7],[1,3,1,4],[1,11,1,12],[2,3,2,4],[2,11,2,12],[3,3,3,4],[4,1,4,3],[4,4,4,12],[5,3,5,4],[6,3,6,4],[6,5,6,7],[7,3,7,4],[7,5,7,7],[9,3,9,4],[9,5,9,7],[10,3,10,4],[10,5,10,7],[11,3,11,4],[11,5,11,7],[12,3,12,4],[12,5,12,7],[13,3,13,4],[13,5,13,7],[14,3,14,4],[14,5,14,7],[15,3,15,4],[15,5,15,7],[16,3,16,4],[16,5,16,7],[17,3,17,4],[17,5,17,7],[18,3,18,4],[18,5,18,7],[19,3,19,4],[19,5,19,7],[20,3,20,4],[20,5,20,7],[21,3,21,4],[21,5,21,7],[22,3,22,4],[22,5,22,7],[23,3,23,4],[23,5,23,7],[24,3,24,4],[24,5,24,7],[25,3,25,4],[25,5,25,7],[26,3,26,4],[26,5,26,7],[27,3,27,4],[27,5,27,7],[28,3,28,4],[28,5,28,7],[29,3,29,4],[29,5,29,7],[30,3,30,4],[30,5,30,7],[31,3,31,4],[31,5,31,7],[32,3,32,4],[32,5,32,7],[33,3,33,4],[33,5,33,7],[34,3,34,4],[34,5,34,7],[35,3,35,4],[35,5,35,7],[36,3,36,4],[36,5,36,7],[37,3,37,4],[37,5,37,7],[38,3,38,4],[38,5,38,7],[39,3,39,4],[39,5,39,7],[40,3,40,4],[40,5,40,7],[41,3,41,4],[41,5,41,7],[42,3,42,4],[42,5,42,7],[43,3,43,4],[43,5,43,7],[44,3,44,4],[44,5,44,7],[45,3,45,4],[45,5,45,7],[46,3,46,4],[46,5,46,7],[47,3,47,4],[47,5,47,7],[51,3,51,4],[51,5,51,7],[48,3,48,4],[48,5,48,7],[49,3,49,4],[49,5,49,7],[50,3,50,4],[50,5,50,7]]}
[0]
[null,"Склад","Стеллаж","Ед. изм.",null,"Цена","Марка","Сорт","Профиль","Размер","Наменкла-турный №","Номер запаса"]
[null,null,null,"кг"]
[]
[null,"Наименование материала",null,null,{"$f":"ИМЯЛИСТА()","v":"Шиповник"}]
[]
[null,"Дата записи","№ Доку-мента","Пор. № записи",null,"От кого получено или кому отпущено",null,null,"Приход","Расход","Остаток","Общий расход","Общий остаток"]
[null,"2021-07-31",null,122,null,null,null,null,null,null,3.3,2.2000000000000002,5.5]
[null,null,null,{"$f":"IF(AND(D8 <> \"\", K9 <> \"\"), D8 + 1, \"\")","v":""},null,{"$f":"IF(AND(I9 <> \"\", J9 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I9 <> \"\", J9 = \"\"), Поставщик(), IF(AND(I9 = \"\", J9 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I9<>\"\",J9<>\"\"),K8-J9+I9,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I10 <> \"\", J10 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I10 <> \"\", J10 = \"\"), Поставщик(), IF(AND(I10 = \"\", J10 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I10<>\"\",J10<>\"\"),K9-J10+I10,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I11 <> \"\", J11 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I11 <> \"\", J11 = \"\"), Поставщик(), IF(AND(I11 = \"\", J11 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I11<>\"\",J11<>\"\"),K10-J11+I11,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I12 <> \"\", J12 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I12 <> \"\", J12 = \"\"), Поставщик(), IF(AND(I12 = \"\", J12 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I13 <> \"\", J13 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I13 <> \"\", J13 = \"\"), Поставщик(), IF(AND(I13 = \"\", J13 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I14 <> \"\", J14 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I14 <> \"\", J14 = \"\"), Поставщик(), IF(AND(I14 = \"\", J14 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I15 <> \"\", J15 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I15 <> \"\", J15 = \"\"), Поставщик(), IF(AND(I15 = \"\", J15 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I15<>\"\",J15<>\"\"),K14-J15+I15,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I16 <> \"\", J16 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I16 <> \"\", J16 = \"\"), Поставщик(), IF(AND(I16 = \"\", J16 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I17 <> \"\", J17 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I17 <> \"\", J17 = \"\"), Поставщик(), IF(AND(I17 = \"\", J17 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I18 <> \"\", J18 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I18 <> \"\", J18 = \"\"), Поставщик(), IF(AND(I18 = \"\", J18 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I19 <> \"\", J19 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I19 <> \"\", J19 = \"\"), Поставщик(), IF(AND(I19 = \"\", J19 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I20 <> \"\", J20 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I20 <> \"\", J20 = \"\"), Поставщик(), IF(AND(I20 = \"\", J20 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I21 <> \"\", J21 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I21 <> \"\", J21 = \"\"), Поставщик(), IF(AND(I21 = \"\", J21 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I22 <> \"\", J22 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I22 <> \"\", J22 = \"\"), Поставщик(), IF(AND(I22 = \"\", J22 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I23 <> \"\", J23 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I23 <> \"\", J23 = \"\"), Поставщик(), IF(AND(I23 = \"\", J23 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I24 <> \"\", J24 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I24 <> \"\", J24 = \"\"), Поставщик(), IF(AND(I24 = \"\", J24 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I25 <> \"\", J25 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I25 <> \"\", J25 = \"\"), Поставщик(), IF(AND(I25 = \"\", J25 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I26 <> \"\", J26 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I26 <> \"\", J26 = \"\"), Поставщик(), IF(AND(I26 = \"\", J26 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I27 <> \"\", J27 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I27 <> \"\", J27 = \"\"), Поставщик(), IF(AND(I27 = \"\", J27 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I28 <> \"\", J28 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I28 <> \"\", J28 = \"\"), Поставщик(), IF(AND(I28 = \"\", J28 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I29 <> \"\", J29 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I29 <> \"\", J29 = \"\"), Поставщик(), IF(AND(I29 = \"\", J29 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I30 <> \"\", J30 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I30 <> \"\", J30 = \"\"), Поставщик(), IF(AND(I30 = \"\", J30 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I31 <> \"\", J31 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I31 <> \"\", J31 = \"\"), Поставщик(), IF(AND(I31 = \"\", J31 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I32 <> \"\", J32 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I32 <> \"\", J32 = \"\"), Поставщик(), IF(AND(I32 = \"\", J32 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I33 <> \"\", J33 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I33 <> \"\", J33 = \"\"), Поставщик(), IF(AND(I33 = \"\", J33 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I34 <> \"\", J34 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I34 <> \"\", J34 = \"\"), Поставщик(), IF(AND(I34 = \"\", J34 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I35 <> \"\", J35 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I35 <> \"\", J35 = \"\"), Поставщик(), IF(AND(I35 = \"\", J35 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I36 <> \"\", J36 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I36 <> \"\", J36 = \"\"), Поставщик(), IF(AND(I36 = \"\", J36 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I37 <> \"\", J37 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I37 <> \"\", J37 = \"\"), Поставщик(), IF(AND(I37 = \"\", J37 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I38 <> \"\", J38 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I38 <> \"\", J38 = \"\"), Поставщик(), IF(AND(I38 = \"\", J38 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I39 <> \"\", J39 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I39 <> \"\", J39 = \"\"), Поставщик(), IF(AND(I39 = \"\", J39 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I40 <> \"\", J40 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I40 <> \"\", J40 = \"\"), Поставщик(), IF(AND(I40 = \"\", J40 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I41 <> \"\", J41 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I41 <> \"\", J41 = \"\"), Поставщик(), IF(AND(I41 = \"\", J41 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I42 <> \"\", J42 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I42 <> \"\", J42 = \"\"), Поставщик(), IF(AND(I42 = \"\", J42 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I43 <> \"\", J43 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I43 <> \"\", J43 = \"\"), Поставщик(), IF(AND(I43 = \"\", J43 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I44 <> \"\", J44 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I44 <> \"\", J44 = \"\"), Поставщик(), IF(AND(I44 = \"\", J44 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I45 <> \"\", J45 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I45 <> \"\", J45 = \"\"), Поставщик(), IF(AND(I45 = \"\", J45 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I46 <> \"\", J46 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I46 <> \"\", J46 = \"\"), Поставщик(), IF(AND(I46 = \"\", J46 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I47 <> \"\", J47 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I47 <> \"\", J47 = \"\"), Поставщик(), IF(AND(I47 = \"\", J47 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I48 <> \"\", J48 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I48 <> \"\", J48 = \"\"), Поставщик(), IF(AND(I48 = \"\", J48 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I49 <> \"\", J49 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I49 <> \"\", J49 = \"\"), Поставщик(), IF(AND(I49 = \"\", J49 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I50 <> \"\", J50 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I50 <> \"\", J50 = \"\"), Поставщик(), IF(AND(I50 = \"\", J50 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I51 <> \"\", J51 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I51 <> \"\", J51 = \"\"), Поставщик(), IF(AND(I51 = \"\", J51 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I52 <> \"\", J52 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I52 <> \"\", J52 = \"\"), Поставщик(), IF(AND(I52 = \"\", J52 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]

{"sheet":"Курага","index":3,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,7],[1,3,1,4],[1,11,1,12],[2,3,2,4],[2,11,2,12],[3,3,3,4],[4,1,4,3],[4,4,4,12],[5,3,5,4],[6,3,6,4],[6,5,6,7],[7,3,7,4],[7,5,7,7],[9,3,9,4],[9,5,9,7],[10,3,10,4],[10,5,10,7],[11,3,11,4],[11,5,11,7],[12,3,12,4],[12,5,12,7],[13,3,13,4],[13,5,13,7],[14,3,14,4],[14,5,14,7],[15,3,15,4],[15,5,15,7],[16,3,16,4],[16,5,16,7],[17,3,17,4],[17,5,17,7],[18,3,18,4],[18,5,18,7],[19,3,19,4],[19,5,19,7],[20,3,20,4],[20,5,20,7],[21,3,21,4],[21,5,21,7],[22,3,22,4],[22,5,22,7],[23,3,23,4],[23,5,23,7],[24,3,24,4],[24,5,24,7],[25,3,25,4],[25,5,25,7],[26,3,26,4],[26,5,26,7],[27,3,27,4],[27,5,27,7],[28,3,28,4],[28,5,28,7],[29,3,29,4],[29,5,29,7],[30,3,30,4],[30,5,30,7],[31,3,31,4],[31,5,31,7],[32,3,32,4],[32,5,32,7],[33,3,33,4],[33,5,33,7],[34,3,34,4],[34,5,34,7],[35,3,35,4],[35,5,35,7],[36,3,36,4],[36,5,36,7],[37,3,37,4],[37,5,37,7],[38,3,38,4],[38,5,38,7],[39,3,39,4],[39,5,39,7],[40,3,40,4],[40,5,40,7],[41,3,41,4],[41,5,41,7],[42,3,42,4],[42,5,42,7],[43,3,43,4],[43,5,43,7],[44,3,44,4],[44,5,44,7],[45,3,45,4],[45,5,45,7],[46,3,46,4],[46,5,46,7],[47,3,47,4],[47,5,47,7],[51,3,51,4],[51,5,51,7],[48,3,48,4],[48,5,48,7],[49,3,49,4],[49,5,49,7],[50,3,50,4],[50,5,50,7]]}
[0]
[null,"Склад","Стеллаж","Ед. изм.",null,"Цена","Марка","Сорт","Профиль","Размер","Наменкла-турный №","Номер запаса"]
[null,null,null,"кг"]
[]
[null,"Наименование материала",null,null,{"$f":"ИМЯЛИСТА()","v":"Курага"}]
[]
[null,"Дата записи","№ Доку-мента","Пор. № записи",null,"От кого получено или кому отпущено",null,null,"Приход","Расход","Остаток","Общий расход","Общий остаток"]
[null,"2021-07-31",null,121,null,"Кухня",null,null,null,0.2,3.2,1.8,5.2]
[null,null,null,{"$f":"IF(AND(D8 <> \"\", K9 <> \"\"), D8 + 1, \"\")","v":""},null,{"$f":"IF(AND(I9 <> \"\", J9 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I9 <> \"\", J9 = \"\"), Поставщик(), IF(AND(I9 = \"\", J9 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I9<>\"\",J9<>\"\"),K8-J9+I9,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I10 <> \"\", J10 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I10 <> \"\", J10 = \"\"), Поставщик(), IF(AND(I10 = \"\", J10 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I10<>\"\",J10<>\"\"),K9-J10+I10,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I11 <> \"\", J11 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I11 <> \"\", J11 = \"\"), Поставщик(), IF(AND(I11 = \"\", J11 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I11<>\"\",J11<>\"\"),K10-J11+I11,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I12 <> \"\", J12 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I12 <> \"\", J12 = \"\"), Поставщик(), IF(AND(I12 = \"\", J12 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I13 <> \"\", J13 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I13 <> \"\", J13 = \"\"), Поставщик(), IF(AND(I13 = \"\", J13 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I14 <> \"\", J14 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I14 <> \"\", J14 = \"\"), Поставщик(), IF(AND(I14 = \"\", J14 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I15 <> \"\", J15 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I15 <> \"\", J15 = \"\"), Поставщик(), IF(AND(I15 = \"\", J15 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I15<>\"\",J15<>\"\"),K14-J15+I15,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I16 <> \"\", J16 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I16 <> \"\", J16 = \"\"), Поставщик(), IF(AND(I16 = \"\", J16 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I17 <> \"\", J17 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I17 <> \"\", J17 = \"\"), Поставщик(), IF(AND(I17 = \"\", J17 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I18 <> \"\", J18 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I18 <> \"\", J18 = \"\"), Поставщик(), IF(AND(I18 = \"\", J18 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I19 <> \"\", J19 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I19 <> \"\", J19 = \"\"), Поставщик(), IF(AND(I19 = \"\", J19 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I20 <> \"\", J20 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I20 <> \"\", J20 = \"\"), Поставщик(), IF(AND(I20 = \"\", J20 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I21 <> \"\", J21 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I21 <> \"\", J21 = \"\"), Поставщик(), IF(AND(I21 = \"\", J21 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I22 <> \"\", J22 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I22 <> \"\", J22 = \"\"), Поставщик(), IF(AND(I22 = \"\", J22 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I23 <> \"\", J23 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I23 <> \"\", J23 = \"\"), Поставщик(), IF(AND(I23 = \"\", J23 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I24 <> \"\", J24 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I24 <> \"\", J24 = \"\"), Поставщик(), IF(AND(I24 = \"\", J24 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I25 <> \"\", J25 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I25 <> \"\", J25 = \"\"), Поставщик(), IF(AND(I25 = \"\", J25 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I26 <> \"\", J26 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I26 <> \"\", J26 = \"\"), Поставщик(), IF(AND(I26 = \"\", J26 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I27 <> \"\", J27 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I27 <> \"\", J27 = \"\"), Поставщик(), IF(AND(I27 = \"\", J27 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I28 <> \"\", J28 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I28 <> \"\", J28 = \"\"), Поставщик(), IF(AND(I28 = \"\", J28 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I29 <> \"\", J29 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I29 <> \"\", J29 = \"\"), Поставщик(), IF(AND(I29 = \"\", J29 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I30 <> \"\", J30 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I30 <> \"\", J30 = \"\"), Поставщик(), IF(AND(I30 = \"\", J30 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I31 <> \"\", J31 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I31 <> \"\", J31 = \"\"), Поставщик(), IF(AND(I31 = \"\", J31 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I32 <> \"\", J32 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I32 <> \"\", J32 = \"\"), Поставщик(), IF(AND(I32 = \"\", J32 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I33 <> \"\", J33 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I33 <> \"\", J33 = \"\"), Поставщик(), IF(AND(I33 = \"\", J33 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I34 <> \"\", J34 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I34 <> \"\", J34 = \"\"), Поставщик(), IF(AND(I34 = \"\", J34 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I35 <> \"\", J35 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I35 <> \"\", J35 = \"\"), Поставщик(), IF(AND(I35 = \"\", J35 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I36 <> \"\", J36 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I36 <> \"\", J36 = \"\"), Поставщик(), IF(AND(I36 = \"\", J36 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I37 <> \"\", J37 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I37 <> \"\", J37 = \"\"), Поставщик(), IF(AND(I37 = \"\", J37 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I38 <> \"\", J38 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I38 <> \"\", J38 = \"\"), Поставщик(), IF(AND(I38 = \"\", J38 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I39 <> \"\", J39 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I39 <> \"\", J39 = \"\"), Поставщик(), IF(AND(I39 = \"\", J39 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I40 <> \"\", J40 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I40 <> \"\", J40 = \"\"), Поставщик(), IF(AND(I40 = \"\", J40 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I41 <> \"\", J41 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I41 <> \"\", J41 = \"\"), Поставщик(), IF(AND(I41 = \"\", J41 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I42 <> \"\", J42 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I42 <> \"\", J42 = \"\"), Поставщик(), IF(AND(I42 = \"\", J42 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I43 <> \"\", J43 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I43 <> \"\", J43 = \"\"), Поставщик(), IF(AND(I43 = \"\", J43 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I44 <> \"\", J44 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I44 <> \"\", J44 = \"\"), Поставщик(), IF(AND(I44 = \"\", J44 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I45 <> \"\", J45 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I45 <> \"\", J45 = \"\"), Поставщик(), IF(AND(I45 = \"\", J45 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I46 <> \"\", J46 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I46 <> \"\", J46 = \"\"), Поставщик(), IF(AND(I46 = \"\", J46 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I47 <> \"\", J47 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I47 <> \"\", J47 = \"\"), Поставщик(), IF(AND(I47 = \"\", J47 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I48 <> \"\", J48 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I48 <> \"\", J48 = \"\"), Поставщик(), IF(AND(I48 = \"\", J48 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I49 <> \"\", J49 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I49 <> \"\", J49 = \"\"), Поставщик(), IF(AND(I49 = \"\", J49 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I50 <> \"\", J50 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I50 <> \"\", J50 = \"\"), Поставщик(), IF(AND(I50 = \"\", J50 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I51 <> \"\", J51 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I51 <> \"\", J51 = \"\"), Поставщик(), IF(AND(I51 = \"\", J51 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I52 <> \"\", J52 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I52 <> \"\", J52 = \"\"), Поставщик(), IF(AND(I52 = \"\", J52 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]

{"sheet":"Бананы","index":4,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,7],[1,3,1,4],[1,11,1,12],[2,3,2,4],[2,11,2,12],[3,3,3,4],[4,1,4,3],[4,4,4,12],[5,3,5,4],[6,3,6,4],[6,5,6,7],[7,3,7,4],[7,5,7,7],[9,3,9,4],[9,5,9,7],[10,3,10,4],[10,5,10,7],[11,3,11,4],[11,5,11,7],[12,3,12,4],[12,5,12,7],[13,3,13,4],[13,5,13,7],[14,3,14,4],[14,5,14,7],[15,3,15,4],[15,5,15,7],[16,3,16,4],[16,5,16,7],[17,3,17,4],[17,5,17,7],[18,3,18,4],[18,5,18,7],[19,3,19,4],[19,5,19,7],[20,3,20,4],[20,5,20,7],[21,3,21,4],[21,5,21,7],[22,3,22,4],[22,5,22,7],[23,3,23,4],[23,5,23,7],[24,3,24,4],[24,5,24,7],[25,3,25,4],[25,5,25,7],[26,3,26,4],[26,5,26,7],[27,3,27,4],[27,5,27,7],[28,3,28,4],[28,5,28,7],[29,3,29,4],[29,5,29,7],[30,3,30,4],[30,5,30,7],[31,3,31,4],[31,5,31,7],[32,3,32,4],[32,5,32,7],[33,3,33,4],[33,5,33,7],[34,3,34,4],[34,5,34,7],[35,3,35,4],[35,5,35,7],[36,3,36,4],[36,5,36,7],[37,3,37,4],[37,5,37,7],[38,3,38,4],[38,5,38,7],[39,3,39,4],[39,5,39,7],[40,3,40,4],[40,5,40,7],[41,3,41,4],[41,5,41,7],[42,3,42,4],[42,5,42,7],[43,3,43,4],[43,5,43,7],[44,3,44,4],[44,5,44,7],[45,3,45,4],[45,5,45,7],[46,3,46,4],[46,5,46,7],[47,3,47,4],[47,5,47,7],[51,3,51,4],[51,5,51,7],[48,3,48,4],[48,5,48,7],[49,3,49,4],[49,5,49,7],[50,3,50,4],[50,5,50,7]]}
[0]
[null,"Склад","Стеллаж","Ед. изм.",null,"Цена","Марка","Сорт","Профиль","Размер","Наменкла-турный №","Номер запаса"]
[null,null,null,"кг"]
[]
[null,"Наименование материала",null,null,{"$f":"ИМЯЛИСТА()","v":"Бананы"}]
[]
[null,"Дата записи","№ Доку-мента","Пор. № записи",null,"От кого получено или кому отпущено",null,null,"Приход","Расход","Остаток","Общий расход","Общий остаток"]
[null,"2021-07-31",null,180,null,"Кухня",null,null,null,6.7,6.7,63,76.400000000000006]
[null,"2021-08-01",null,181,null,null,null,null,null,6.7,0]
[null,null,null,{"$f":"IF(AND(D9 <> \"\", K10 <> \"\"), D9 + 1, \"\")","v":""},null,{"$f":"IF(AND(I10 <> \"\", J10 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I10 <> \"\", J10 = \"\"), Поставщик(), IF(AND(I10 = \"\", J10 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I10<>\"\",J10<>\"\"),K9-J10+I10,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I11 <> \"\", J11 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I11 <> \"\", J11 = \"\"), Поставщик(), IF(AND(I11 = \"\", J11 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I11<>\"\",J11<>\"\"),K10-J11+I11,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I12 <> \"\", J12 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I12 <> \"\", J12 = \"\"), Поставщик(), IF(AND(I12 = \"\", J12 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I13 <> \"\", J13 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I13 <> \"\", J13 = \"\"), Поставщик(), IF(AND(I13 = \"\", J13 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I14 <> \"\", J14 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I14 <> \"\", J14 = \"\"), Поставщик(), IF(AND(I14 = \"\", J14 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I15 <> \"\", J15 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I15 <> \"\", J15 = \"\"), Поставщик(), IF(AND(I15 = \"\", J15 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I15<>\"\",J15<>\"\"),K14-J15+I15,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I16 <> \"\", J16 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I16 <> \"\", J16 = \"\"), Поставщик(), IF(AND(I16 = \"\", J16 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I17 <> \"\", J17 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I17 <> \"\", J17 = \"\"), Поставщик(), IF(AND(I17 = \"\", J17 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I18 <> \"\", J18 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I18 <> \"\", J18 = \"\"), Поставщик(), IF(AND(I18 = \"\", J18 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I19 <> \"\", J19 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I19 <> \"\", J19 = \"\"), Поставщик(), IF(AND(I19 = \"\", J19 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I20 <> \"\", J20 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I20 <> \"\", J20 = \"\"), Поставщик(), IF(AND(I20 = \"\", J20 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I21 <> \"\", J21 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I21 <> \"\", J21 = \"\"), Поставщик(), IF(AND(I21 = \"\", J21 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I22 <> \"\", J22 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I22 <> \"\", J22 = \"\"), Поставщик(), IF(AND(I22 = \"\", J22 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I23 <> \"\", J23 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I23 <> \"\", J23 = \"\"), Поставщик(), IF(AND(I23 = \"\", J23 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I24 <> \"\", J24 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I24 <> \"\", J24 = \"\"), Поставщик(), IF(AND(I24 = \"\", J24 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I25 <> \"\", J25 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I25 <> \"\", J25 = \"\"), Поставщик(), IF(AND(I25 = \"\", J25 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I26 <> \"\", J26 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I26 <> \"\", J26 = \"\"), Поставщик(), IF(AND(I26 = \"\", J26 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I27 <> \"\", J27 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I27 <> \"\", J27 = \"\"), Поставщик(), IF(AND(I27 = \"\", J27 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I28 <> \"\", J28 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I28 <> \"\", J28 = \"\"), Поставщик(), IF(AND(I28 = \"\", J28 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I29 <> \"\", J29 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I29 <> \"\", J29 = \"\"), Поставщик(), IF(AND(I29 = \"\", J29 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I30 <> \"\", J30 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I30 <> \"\", J30 = \"\"), Поставщик(), IF(AND(I30 = \"\", J30 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I31 <> \"\", J31 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I31 <> \"\", J31 = \"\"), Поставщик(), IF(AND(I31 = \"\", J31 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I32 <> \"\", J32 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I32 <> \"\", J32 = \"\"), Поставщик(), IF(AND(I32 = \"\", J32 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I33 <> \"\", J33 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I33 <> \"\", J33 = \"\"), Поставщик(), IF(AND(I33 = \"\", J33 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I34 <> \"\", J34 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I34 <> \"\", J34 = \"\"), Поставщик(), IF(AND(I34 = \"\", J34 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I35 <> \"\", J35 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I35 <> \"\", J35 = \"\"), Поставщик(), IF(AND(I35 = \"\", J35 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I36 <> \"\", J36 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I36 <> \"\", J36 = \"\"), Поставщик(), IF(AND(I36 = \"\", J36 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I37 <> \"\", J37 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I37 <> \"\", J37 = \"\"), Поставщик(), IF(AND(I37 = \"\", J37 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I38 <> \"\", J38 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I38 <> \"\", J38 = \"\"), Поставщик(), IF(AND(I38 = \"\", J38 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I39 <> \"\", J39 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I39 <> \"\", J39 = \"\"), Поставщик(), IF(AND(I39 = \"\", J39 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I40 <> \"\", J40 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I40 <> \"\", J40 = \"\"), Поставщик(), IF(AND(I40 = \"\", J40 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I41 <> \"\", J41 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I41 <> \"\", J41 = \"\"), Поставщик(), IF(AND(I41 = \"\", J41 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I42 <> \"\", J42 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I42 <> \"\", J42 = \"\"), Поставщик(), IF(AND(I42 = \"\", J42 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I43 <> \"\", J43 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I43 <> \"\", J43 = \"\"), Поставщик(), IF(AND(I43 = \"\", J43 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I44 <> \"\", J44 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I44 <> \"\", J44 = \"\"), Поставщик(), IF(AND(I44 = \"\", J44 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I45 <> \"\", J45 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I45 <> \"\", J45 = \"\"), Поставщик(), IF(AND(I45 = \"\", J45 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I46 <> \"\", J46 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I46 <> \"\", J46 = \"\"), Поставщик(), IF(AND(I46 = \"\", J46 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I47 <> \"\", J47 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I47 <> \"\", J47 = \"\"), Поставщик(), IF(AND(I47 = \"\", J47 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I48 <> \"\", J48 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I48 <> \"\", J48 = \"\"), Поставщик(), IF(AND(I48 = \"\", J48 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I49 <> \"\", J49 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I49 <> \"\", J49 = \"\"), Поставщик(), IF(AND(I49 = \"\", J49 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I50 <> \"\", J50 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I50 <> \"\", J50 = \"\"), Поставщик(), IF(AND(I50 = \"\", J50 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I51 <> \"\", J51 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I51 <> \"\", J51 = \"\"), Поставщик(), IF(AND(I51 = \"\", J51 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I52 <> \"\", J52 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I52 <> \"\", J52 = \"\"), Поставщик(), IF(AND(I52 = \"\", J52 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]

{"sheet":"Яблоки","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[8,3,8,4],[8,5,8,7],[1,3,1,4],[1,11,1,12],[2,3,2,4],[2,11,2,12],[3,3,3,4],[4,1,4,3],[4,4,4,12],[5,3,5,4],[6,3,6,4],[6,5,6,7],[7,3,7,4],[7,5,7,7],[9,3,9,4],[9,5,9,7],[10,3,10,4],[10,5,10,7],[11,3,11,4],[11,5,11,7],[12,3,12,4],[12,5,12,7],[13,3,13,4],[13,5,13,7],[14,3,14,4],[14,5,14,7],[15,3,15,4],[15,5,15,7],[16,3,16,4],[16,5,16,7],[17,3,17,4],[17,5,17,7],[18,3,18,4],[18,5,18,7],[19,3,19,4],[19,5,19,7],[20,3,20,4],[20,5,20,7],[21,3,21,4],[21,5,21,7],[22,3,22,4],[22,5,22,7],[23,3,23,4],[23,5,23,7],[24,3,24,4],[24,5,24,7],[25,3,25,4],[25,5,25,7],[26,3,26,4],[26,5,26,7],[27,3,27,4],[27,5,27,7],[28,3,28,4],[28,5,28,7],[29,3,29,4],[29,5,29,7],[30,3,30,4],[30,5,30,7],[31,3,31,4],[31,5,31,7],[32,3,32,4],[32,5,32,7],[33,3,33,4],[33,5,33,7],[34,3,34,4],[34,5,34,7],[35,3,35,4],[35,5,35,7],[36,3,36,4],[36,5,36,7],[37,3,37,4],[37,5,37,7],[38,3,38,4],[38,5,38,7],[39,3,39,4],[39,5,39,7],[40,3,40,4],[40,5,40,7],[41,3,41,4],[41,5,41,7],[42,3,42,4],[42,5,42,7],[43,3,43,4],[43,5,43,7],[44,3,44,4],[44,5,44,7],[45,3,45,4],[45,5,45,7],[46,3,46,4],[46,5,46,7],[47,3,47,4],[47,5,47,7],[51,3,51,4],[51,5,51,7],[48,3,48,4],[48,5,48,7],[49,3,49,4],[49,5,49,7],[50,3,50,4],[50,5,50,7]]}
[0]
[null,"Склад","Стеллаж","Ед. изм.",null,"Цена","Марка","Сорт","Профиль","Размер","Наменкла-турный №","Номер запаса"]
[null,null,null,"кг"]
[]
[null,"Наименование материала",null,null,{"$f":"ИМЯЛИСТА()","v":"Яблоки"}]
[]
[null,"Дата записи","№ Доку-мента","Пор. № записи",null,"От кого получено или кому отпущено",null,null,"Приход","Расход","Остаток","Общий расход","Общий остаток"]
[null,"2021-07-31",null,178,null,null,null,null,null,null,9.4,3.7,11.1]
[null,"2021-08-01",null,{"$f":"IF(AND(D8 <> \"\", K9 <> \"\"), D8 + 1, \"\")","v":179},null,{"$f":"IF(AND(I9 <> \"\", J9 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I9 <> \"\", J9 = \"\"), Поставщик(), IF(AND(I9 = \"\", J9 <> \"\"), \"Кухня\", \"\")))","v":"Кухня"},null,null,null,5.6,{"$f":"IF(OR(I9<>\"\",J9<>\"\"),K8-J9+I9,\"\")","v":3.8000000000000007}]
[null,null,null,180,null,{"$f":"IF(AND(I10 <> \"\", J10 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I10 <> \"\", J10 = \"\"), Поставщик(), IF(AND(I10 = \"\", J10 <> \"\"), \"Кухня\", \"\")))","v":"Кухня"},null,null,null,3.8,{"$f":"IF(OR(I10<>\"\",J10<>\"\"),K9-J10+I10,\"\")","v":8.8817841970012523E-16}]
[null,null,null,"",null,{"$f":"IF(AND(I11 <> \"\", J11 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I11 <> \"\", J11 = \"\"), Поставщик(), IF(AND(I11 = \"\", J11 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I11<>\"\",J11<>\"\"),K10-J11+I11,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I12 <> \"\", J12 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I12 <> \"\", J12 = \"\"), Поставщик(), IF(AND(I12 = \"\", J12 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I13 <> \"\", J13 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I13 <> \"\", J13 = \"\"), Поставщик(), IF(AND(I13 = \"\", J13 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I14 <> \"\", J14 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I14 <> \"\", J14 = \"\"), Поставщик(), IF(AND(I14 = \"\", J14 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I15 <> \"\", J15 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I15 <> \"\", J15 = \"\"), Поставщик(), IF(AND(I15 = \"\", J15 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,{"$f":"IF(OR(I15<>\"\",J15<>\"\"),K14-J15+I15,\"\")","v":""}]
[null,null,null,"",null,{"$f":"IF(AND(I16 <> \"\", J16 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I16 <> \"\", J16 = \"\"), Поставщик(), IF(AND(I16 = \"\", J16 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I17 <> \"\", J17 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I17 <> \"\", J17 = \"\"), Поставщик(), IF(AND(I17 = \"\", J17 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I18 <> \"\", J18 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I18 <> \"\", J18 = \"\"), Поставщик(), IF(AND(I18 = \"\", J18 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I19 <> \"\", J19 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I19 <> \"\", J19 = \"\"), Поставщик(), IF(AND(I19 = \"\", J19 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I20 <> \"\", J20 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I20 <> \"\", J20 = \"\"), Поставщик(), IF(AND(I20 = \"\", J20 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I21 <> \"\", J21 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I21 <> \"\", J21 = \"\"), Поставщик(), IF(AND(I21 = \"\", J21 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I22 <> \"\", J22 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I22 <> \"\", J22 = \"\"), Поставщик(), IF(AND(I22 = \"\", J22 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I23 <> \"\", J23 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I23 <> \"\", J23 = \"\"), Поставщик(), IF(AND(I23 = \"\", J23 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I24 <> \"\", J24 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I24 <> \"\", J24 = \"\"), Поставщик(), IF(AND(I24 = \"\", J24 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I25 <> \"\", J25 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I25 <> \"\", J25 = \"\"), Поставщик(), IF(AND(I25 = \"\", J25 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I26 <> \"\", J26 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I26 <> \"\", J26 = \"\"), Поставщик(), IF(AND(I26 = \"\", J26 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I27 <> \"\", J27 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I27 <> \"\", J27 = \"\"), Поставщик(), IF(AND(I27 = \"\", J27 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I28 <> \"\", J28 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I28 <> \"\", J28 = \"\"), Поставщик(), IF(AND(I28 = \"\", J28 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I29 <> \"\", J29 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I29 <> \"\", J29 = \"\"), Поставщик(), IF(AND(I29 = \"\", J29 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I30 <> \"\", J30 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I30 <> \"\", J30 = \"\"), Поставщик(), IF(AND(I30 = \"\", J30 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I31 <> \"\", J31 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I31 <> \"\", J31 = \"\"), Поставщик(), IF(AND(I31 = \"\", J31 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I32 <> \"\", J32 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I32 <> \"\", J32 = \"\"), Поставщик(), IF(AND(I32 = \"\", J32 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I33 <> \"\", J33 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I33 <> \"\", J33 = \"\"), Поставщик(), IF(AND(I33 = \"\", J33 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I34 <> \"\", J34 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I34 <> \"\", J34 = \"\"), Поставщик(), IF(AND(I34 = \"\", J34 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I35 <> \"\", J35 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I35 <> \"\", J35 = \"\"), Поставщик(), IF(AND(I35 = \"\", J35 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I36 <> \"\", J36 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I36 <> \"\", J36 = \"\"), Поставщик(), IF(AND(I36 = \"\", J36 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I37 <> \"\", J37 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I37 <> \"\", J37 = \"\"), Поставщик(), IF(AND(I37 = \"\", J37 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I38 <> \"\", J38 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I38 <> \"\", J38 = \"\"), Поставщик(), IF(AND(I38 = \"\", J38 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I39 <> \"\", J39 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I39 <> \"\", J39 = \"\"), Поставщик(), IF(AND(I39 = \"\", J39 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I40 <> \"\", J40 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I40 <> \"\", J40 = \"\"), Поставщик(), IF(AND(I40 = \"\", J40 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I41 <> \"\", J41 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I41 <> \"\", J41 = \"\"), Поставщик(), IF(AND(I41 = \"\", J41 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I42 <> \"\", J42 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I42 <> \"\", J42 = \"\"), Поставщик(), IF(AND(I42 = \"\", J42 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I43 <> \"\", J43 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I43 <> \"\", J43 = \"\"), Поставщик(), IF(AND(I43 = \"\", J43 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I44 <> \"\", J44 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I44 <> \"\", J44 = \"\"), Поставщик(), IF(AND(I44 = \"\", J44 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I45 <> \"\", J45 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I45 <> \"\", J45 = \"\"), Поставщик(), IF(AND(I45 = \"\", J45 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I46 <> \"\", J46 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I46 <> \"\", J46 = \"\"), Поставщик(), IF(AND(I46 = \"\", J46 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I47 <> \"\", J47 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I47 <> \"\", J47 = \"\"), Поставщик(), IF(AND(I47 = \"\", J47 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I48 <> \"\", J48 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I48 <> \"\", J48 = \"\"), Поставщик(), IF(AND(I48 = \"\", J48 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I49 <> \"\", J49 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I49 <> \"\", J49 = \"\"), Поставщик(), IF(AND(I49 = \"\", J49 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I50 <> \"\", J50 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I50 <> \"\", J50 = \"\"), Поставщик(), IF(AND(I50 = \"\", J50 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I51 <> \"\", J51 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I51 <> \"\", J51 = \"\"), Поставщик(), IF(AND(I51 = \"\", J51 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]
[null,null,null,"",null,{"$f":"IF(AND(I52 <> \"\", J52 <> \"\"), CONCATENATE(\"Кухня\", \", \", Поставщик()), IF(AND(I52 <> \"\", J52 = \"\"), Поставщик(), IF(AND(I52 = \"\", J52 <> \"\"), \"Кухня\", \"\")))","v":""},null,null,null,null,""]