{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Состав блюд","Прих","Выгрузка из прих.накл."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":77,"n_cols":27,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Первые блюда",null,null,null,null,"Вторые блюда",null,null,null,null,"Гарниры",null,null,null,null,"Салаты",null,null,null,null,"Напитки"]
["Борщ украинский",null,null,{"$f":"COUNTIF(A$2:A3,\"№\")","v":1},null,"Котлета по-киевски",null,null,{"$f":"COUNTIF(F$2:F3,\"№\")","v":1},null,"Рис отварной",null,null,{"$f":"COUNTIF(K$2:K3,\"№\")","v":1},null,"Салат \"Оливье\"",null,null,{"$f":"COUNTIF(P$2:P3,\"№\")","v":1},null,"Чай",null,null,{"$f":"COUNTIF(U$2:U3,\"№\")","v":1}]
["№","Наименование продукта","Норма, г",{"$f":"COUNTIF(A$2:A4,\"№\")","v":1},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(F$2:F4,\"№\")","v":1},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(K$2:K4,\"№\")","v":1},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(P$2:P4,\"№\")","v":1},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(U$2:U4,\"№\")","v":1},null,null,"Наименование продукта"]
[1,"Свекла",40,{"$f":"COUNTIF(A$2:A5,\"№\")","v":1},null,1,"Курица",40,{"$f":"COUNTIF(F$2:F5,\"№\")","v":1},null,1,"Рис",40,{"$f":"COUNTIF(K$2:K5,\"№\")","v":1},null,1,"Морковь",40,{"$f":"COUNTIF(P$2:P5,\"№\")","v":1},null,1,"Чай",40,{"$f":"COUNTIF(U$2:U5,\"№\")","v":1},null,null,"Говядина"]
[2,"Капуста",10,{"$f":"COUNTIF(A$2:A6,\"№\")","v":1},null,2,"Лук",10,{"$f":"COUNTIF(F$2:F6,\"№\")","v":1},null,2,"Соль",10,{"$f":"COUNTIF(K$2:K6,\"№\")","v":1},null,2,"Картофель",10,{"$f":"COUNTIF(P$2:P6,\"№\")","v":1},null,2,"Сахар",10,{"$f":"COUNTIF(U$2:U6,\"№\")","v":1},null,null,"Гречка"]
[3,"Картофель",30,{"$f":"COUNTIF(A$2:A7,\"№\")","v":1},null,3,"Масло растительное",30,{"$f":"COUNTIF(F$2:F7,\"№\")","v":1},null,3,"Масло сливочное",30,{"$f":"COUNTIF(K$2:K7,\"№\")","v":1},null,3,"Соль",30,{"$f":"COUNTIF(P$2:P7,\"№\")","v":1},null,3,null,null,{"$f":"COUNTIF(U$2:U7,\"№\")","v":1},null,null,"Какао в порошке"]
[4,"Лавровый лист",32,{"$f":"COUNTIF(A$2:A8,\"№\")","v":1},null,4,"Сыр",32,{"$f":"COUNTIF(F$2:F8,\"№\")","v":1},null,4,null,null,{"$f":"COUNTIF(K$2:K8,\"№\")","v":1},null,4,"Колбаса \"Докторская\"",32,{"$f":"COUNTIF(P$2:P8,\"№\")","v":1},null,4,null,null,{"$f":"COUNTIF(U$2:U8,\"№\")","v":1},null,null,"Капуста"]
[5,"Лук",5,{"$f":"COUNTIF(A$2:A9,\"№\")","v":1},null,5,"Сухари панировочные",5,{"$f":"COUNTIF(F$2:F9,\"№\")","v":1},null,5,null,null,{"$f":"COUNTIF(K$2:K9,\"№\")","v":1},null,5,"Яйца куриные",5,{"$f":"COUNTIF(P$2:P9,\"№\")","v":1},null,5,null,null,{"$f":"COUNTIF(U$2:U9,\"№\")","v":1},null,null,"Картофель"]
[6,"Морковь",26,{"$f":"COUNTIF(A$2:A10,\"№\")","v":1},null,6,{"$f":"INDIRECT(\"Таблица6[Наименование продукта]\")","v":"Колбаса \"Докторская\""},26,{"$f":"COUNTIF(F$2:F10,\"№\")","v":1},null,6,null,null,{"$f":"COUNTIF(K$2:K10,\"№\")","v":1},null,6,"Колбаса \"Докторская\"",26,{"$f":"COUNTIF(P$2:P10,\"№\")","v":1},null,6,null,null,{"$f":"COUNTIF(U$2:U10,\"№\")","v":1},null,null,"Колбаса \"Докторская\""]
[7,"Соль",10,{"$f":"COUNTIF(A$2:A14,\"№\")","v":1},null,7,null,null,{"$f":"COUNTIF(F$2:F14,\"№\")","v":1},null,7,null,null,{"$f":"COUNTIF(K$2:K14,\"№\")","v":1},null,7,"Огурец свежий",10,{"$f":"COUNTIF(P$2:P14,\"№\")","v":1},null,7,null,null,{"$f":"COUNTIF(U$2:U14,\"№\")","v":1},null,null,"Курица"]
[8,"Уксус 9%-ный",10,{"$f":"COUNTIF(A$2:A15,\"№\")","v":1},null,8,null,null,{"$f":"COUNTIF(F$2:F15,\"№\")","v":1},null,8,null,null,{"$f":"COUNTIF(K$2:K15,\"№\")","v":1},null,8,"Майонез",10,{"$f":"COUNTIF(P$2:P15,\"№\")","v":1},null,8,null,null,{"$f":"COUNTIF(U$2:U15,\"№\")","v":1},null,null,"Лавровый лист"]
[9,"Томатная паста",10,{"$f":"COUNTIF(A$2:A16,\"№\")","v":1},null,9,null,null,{"$f":"COUNTIF(F$2:F16,\"№\")","v":1},null,9,null,null,{"$f":"COUNTIF(K$2:K16,\"№\")","v":1},null,9,null,null,{"$f":"COUNTIF(P$2:P16,\"№\")","v":1},null,9,null,null,{"$f":"COUNTIF(U$2:U16,\"№\")","v":1},null,null,"Лук"]
[10,"Перец сладкий",10,{"$f":"COUNTIF(A$2:A17,\"№\")","v":1},null,10,null,null,{"$f":"COUNTIF(F$2:F17,\"№\")","v":1},null,10,null,null,{"$f":"COUNTIF(K$2:K17,\"№\")","v":1},null,10,null,null,{"$f":"COUNTIF(P$2:P17,\"№\")","v":1},null,10,null,null,{"$f":"COUNTIF(U$2:U17,\"№\")","v":1},null,null,"Майонез"]
[11,{"$f":"INDIRECT(\"Таблица6[Наименование продукта]\")","v":"Масло растительное"},10,{"$f":"COUNTIF(A$2:A15,\"№\")","v":1},null,11,null,null,{"$f":"COUNTIF(F$2:F15,\"№\")","v":1},null,11,null,null,{"$f":"COUNTIF(K$2:K15,\"№\")","v":1},null,11,null,null,{"$f":"COUNTIF(P$2:P15,\"№\")","v":1},null,11,null,null,{"$f":"COUNTIF(U$2:U15,\"№\")","v":1},null,null,"Масло растительное"]
[12,null,null,{"$f":"COUNTIF(A$2:A16,\"№\")","v":1},null,12,null,null,{"$f":"COUNTIF(F$2:F16,\"№\")","v":1},null,12,null,null,{"$f":"COUNTIF(K$2:K16,\"№\")","v":1},null,12,null,null,{"$f":"COUNTIF(P$2:P16,\"№\")","v":1},null,12,null,null,{"$f":"COUNTIF(U$2:U16,\"№\")","v":1},null,null,"Масло сливочное"]
[13,null,null,{"$f":"COUNTIF(A$2:A17,\"№\")","v":1},null,13,null,null,{"$f":"COUNTIF(F$2:F17,\"№\")","v":1},null,13,null,null,{"$f":"COUNTIF(K$2:K17,\"№\")","v":1},null,13,null,null,{"$f":"COUNTIF(P$2:P17,\"№\")","v":1},null,13,null,null,{"$f":"COUNTIF(U$2:U17,\"№\")","v":1},null,null,"Морковь"]
[14,null,null,null,null,14,null,null,null,null,14,null,null,null,null,14,null,null,null,null,14,null,null,null,null,null,"Огурец свежий"]
[15,null,null,null,null,15,null,null,null,null,15,null,null,null,null,15,null,null,null,null,15,null,null,null,null,null,"Перец сладкий"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Помидоры"]
["Щи",null,null,{"$f":"COUNTIF(A$2:A21,\"№\")","v":2},null,"Жаркое по-домашнему",null,null,{"$f":"COUNTIF(F$2:F21,\"№\")","v":2},null,"Гречка отварная",null,null,{"$f":"COUNTIF(K$2:K21,\"№\")","v":2},null,"Салат \"Капустный\"",null,null,{"$f":"COUNTIF(P$2:P21,\"№\")","v":2},null,"Какао",null,null,{"$f":"COUNTIF(U$2:U21,\"№\")","v":2},null,null,"Рис"]
["№","Наименование продукта","Норма, г",{"$f":"COUNTIF(A$2:A22,\"№\")","v":2},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(F$2:F22,\"№\")","v":2},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(K$2:K22,\"№\")","v":2},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(P$2:P22,\"№\")","v":2},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(U$2:U22,\"№\")","v":2},null,null,"Сахар"]
[1,"Капуста",100,{"$f":"COUNTIF(A$2:A23,\"№\")","v":2},null,1,"Свинина",100,{"$f":"COUNTIF(F$2:F23,\"№\")","v":2},null,1,"Гречка",100,{"$f":"COUNTIF(K$2:K23,\"№\")","v":2},null,1,"Капуста",100,{"$f":"COUNTIF(P$2:P23,\"№\")","v":2},null,1,"Какао в порошке",100,{"$f":"COUNTIF(U$2:U23,\"№\")","v":2},null,null,"Свекла"]
[2,"Морковь",32,{"$f":"COUNTIF(A$2:A24,\"№\")","v":2},null,2,"Морковь",32,{"$f":"COUNTIF(F$2:F24,\"№\")","v":2},null,2,"Масло сливочное",32,{"$f":"COUNTIF(K$2:K24,\"№\")","v":2},null,2,"Морковь",32,{"$f":"COUNTIF(P$2:P24,\"№\")","v":2},null,2,"Сахар",32,{"$f":"COUNTIF(U$2:U24,\"№\")","v":2},null,null,"Свинина"]
[3,"Картофель",5,{"$f":"COUNTIF(A$2:A25,\"№\")","v":2},null,3,"Томатная паста",5,{"$f":"COUNTIF(F$2:F25,\"№\")","v":2},null,3,"Соль",5,{"$f":"COUNTIF(K$2:K25,\"№\")","v":2},null,3,"Лук",5,{"$f":"COUNTIF(P$2:P25,\"№\")","v":2},null,3,null,null,{"$f":"COUNTIF(U$2:U25,\"№\")","v":2},null,null,"Соль"]
[4,"Лук",10,{"$f":"COUNTIF(A$2:A26,\"№\")","v":2},null,4,"Лук",10,{"$f":"COUNTIF(F$2:F26,\"№\")","v":2},null,4,null,null,{"$f":"COUNTIF(K$2:K26,\"№\")","v":2},null,4,"Масло растительное",10,{"$f":"COUNTIF(P$2:P26,\"№\")","v":2},null,4,null,null,{"$f":"COUNTIF(U$2:U26,\"№\")","v":2},null,null,"Сухари панировочные"]
[5,"Масло растительное",10,{"$f":"COUNTIF(A$2:A27,\"№\")","v":2},null,5,"Масло растительное",10,{"$f":"COUNTIF(F$2:F27,\"№\")","v":2},null,5,null,null,{"$f":"COUNTIF(K$2:K27,\"№\")","v":2},null,5,"Соль",10,{"$f":"COUNTIF(P$2:P27,\"№\")","v":2},null,5,null,null,{"$f":"COUNTIF(U$2:U27,\"№\")","v":2},null,null,"Сыр"]
[6,"Соль",80,{"$f":"COUNTIF(A$2:A28,\"№\")","v":2},null,6,"Соль",80,{"$f":"COUNTIF(F$2:F28,\"№\")","v":2},null,6,null,null,{"$f":"COUNTIF(K$2:K28,\"№\")","v":2},null,6,"Уксус 9%-ный",80,{"$f":"COUNTIF(P$2:P28,\"№\")","v":2},null,6,null,null,{"$f":"COUNTIF(U$2:U28,\"№\")","v":2},null,null,"Томатная паста"]
[7,"Говядина",5,{"$f":"COUNTIF(A$2:A29,\"№\")","v":2},null,7,"Картофель",5,{"$f":"COUNTIF(F$2:F29,\"№\")","v":2},null,7,null,null,{"$f":"COUNTIF(K$2:K29,\"№\")","v":2},null,7,null,null,{"$f":"COUNTIF(P$2:P29,\"№\")","v":2},null,7,null,null,{"$f":"COUNTIF(U$2:U29,\"№\")","v":2},null,null,"Уксус 9%-ный"]
[8,"Лавровый лист",10,{"$f":"COUNTIF(A$2:A30,\"№\")","v":2},null,8,null,null,{"$f":"COUNTIF(F$2:F30,\"№\")","v":2},null,8,null,null,{"$f":"COUNTIF(K$2:K30,\"№\")","v":2},null,8,null,null,{"$f":"COUNTIF(P$2:P30,\"№\")","v":2},null,8,null,null,{"$f":"COUNTIF(U$2:U30,\"№\")","v":2},null,null,"Чай"]
[9,"Перец сладкий",5,{"$f":"COUNTIF(A$2:A31,\"№\")","v":2},null,9,null,null,{"$f":"COUNTIF(F$2:F31,\"№\")","v":2},null,9,null,null,{"$f":"COUNTIF(K$2:K31,\"№\")","v":2},null,9,null,null,{"$f":"COUNTIF(P$2:P31,\"№\")","v":2},null,9,null,null,{"$f":"COUNTIF(U$2:U31,\"№\")","v":2},null,null,"Яйца куриные"]
[10,null,null,{"$f":"COUNTIF(A$2:A32,\"№\")","v":2},null,10,null,null,{"$f":"COUNTIF(F$2:F32,\"№\")","v":2},null,10,null,null,{"$f":"COUNTIF(K$2:K32,\"№\")","v":2},null,10,null,null,{"$f":"COUNTIF(P$2:P32,\"№\")","v":2},null,10,null,null,{"$f":"COUNTIF(U$2:U32,\"№\")","v":2},null,null,"Чеснок"]
[11,null,null,{"$f":"COUNTIF(A$2:A33,\"№\")","v":2},null,11,null,null,{"$f":"COUNTIF(F$2:F33,\"№\")","v":2},null,11,null,null,{"$f":"COUNTIF(K$2:K33,\"№\")","v":2},null,11,null,null,{"$f":"COUNTIF(P$2:P33,\"№\")","v":2},null,11,null,null,{"$f":"COUNTIF(U$2:U33,\"№\")","v":2},null,null,"сс"]
[12,null,null,{"$f":"COUNTIF(A$2:A34,\"№\")","v":2},null,12,null,null,{"$f":"COUNTIF(F$2:F34,\"№\")","v":2},null,12,null,null,{"$f":"COUNTIF(K$2:K34,\"№\")","v":2},null,12,null,null,{"$f":"COUNTIF(P$2:P34,\"№\")","v":2},null,12,null,null,{"$f":"COUNTIF(U$2:U34,\"№\")","v":2},null,null,"Сало"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Спирт"]
["Суп вермишелевый",null,null,{"$f":"COUNTIF(A$2:A36,\"№\")","v":3},null,"Азу с рисом",null,null,{"$f":"COUNTIF(F$2:F36,\"№\")","v":3},null,"Пюре картофельное",null,null,{"$f":"COUNTIF(K$2:K36,\"№\")","v":3},null,"Салат \"Мимоза\"",null,null,{"$f":"COUNTIF(P$2:P36,\"№\")","v":3},null,"Компот из яблок",null,null,{"$f":"COUNTIF(U$2:U36,\"№\")","v":3}]
["№","Наименование продукта","Норма, г",{"$f":"COUNTIF(A$2:A37,\"№\")","v":3},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(F$2:F37,\"№\")","v":3},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(K$2:K37,\"№\")","v":3},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(P$2:P37,\"№\")","v":3},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(U$2:U37,\"№\")","v":3}]
[1,null,null,{"$f":"COUNTIF(A$2:A38,\"№\")","v":3},null,1,null,null,{"$f":"COUNTIF(F$2:F38,\"№\")","v":3},null,1,null,null,{"$f":"COUNTIF(K$2:K38,\"№\")","v":3},null,1,null,null,{"$f":"COUNTIF(P$2:P38,\"№\")","v":3},null,1,null,null,{"$f":"COUNTIF(U$2:U38,\"№\")","v":3}]
[2,null,null,{"$f":"COUNTIF(A$2:A39,\"№\")","v":3},null,2,null,null,{"$f":"COUNTIF(F$2:F39,\"№\")","v":3},null,2,null,null,{"$f":"COUNTIF(K$2:K39,\"№\")","v":3},null,2,null,null,{"$f":"COUNTIF(P$2:P39,\"№\")","v":3},null,2,null,null,{"$f":"COUNTIF(U$2:U39,\"№\")","v":3}]
[3,null,null,{"$f":"COUNTIF(A$2:A40,\"№\")","v":3},null,3,null,null,{"$f":"COUNTIF(F$2:F40,\"№\")","v":3},null,3,null,null,{"$f":"COUNTIF(K$2:K40,\"№\")","v":3},null,3,null,null,{"$f":"COUNTIF(P$2:P40,\"№\")","v":3},null,3,null,null,{"$f":"COUNTIF(U$2:U40,\"№\")","v":3}]
[4,null,null,{"$f":"COUNTIF(A$2:A41,\"№\")","v":3},null,4,null,null,{"$f":"COUNTIF(F$2:F41,\"№\")","v":3},null,4,null,null,{"$f":"COUNTIF(K$2:K41,\"№\")","v":3},null,4,null,null,{"$f":"COUNTIF(P$2:P41,\"№\")","v":3},null,4,null,null,{"$f":"COUNTIF(U$2:U41,\"№\")","v":3}]
[5,null,null,{"$f":"COUNTIF(A$2:A42,\"№\")","v":3},null,5,null,null,{"$f":"COUNTIF(F$2:F42,\"№\")","v":3},null,5,null,null,{"$f":"COUNTIF(K$2:K42,\"№\")","v":3},null,5,null,null,{"$f":"COUNTIF(P$2:P42,\"№\")","v":3},null,5,null,null,{"$f":"COUNTIF(U$2:U42,\"№\")","v":3}]
[6,null,null,{"$f":"COUNTIF(A$2:A43,\"№\")","v":3},null,6,null,null,{"$f":"COUNTIF(F$2:F43,\"№\")","v":3},null,6,null,null,{"$f":"COUNTIF(K$2:K43,\"№\")","v":3},null,6,null,null,{"$f":"COUNTIF(P$2:P43,\"№\")","v":3},null,6,null,null,{"$f":"COUNTIF(U$2:U43,\"№\")","v":3}]
[7,null,null,{"$f":"COUNTIF(A$2:A44,\"№\")","v":3},null,7,null,null,{"$f":"COUNTIF(F$2:F44,\"№\")","v":3},null,7,null,null,{"$f":"COUNTIF(K$2:K44,\"№\")","v":3},null,7,null,null,{"$f":"COUNTIF(P$2:P44,\"№\")","v":3},null,7,null,null,{"$f":"COUNTIF(U$2:U44,\"№\")","v":3}]
[8,null,null,{"$f":"COUNTIF(A$2:A45,\"№\")","v":3},null,8,null,null,{"$f":"COUNTIF(F$2:F45,\"№\")","v":3},null,8,null,null,{"$f":"COUNTIF(K$2:K45,\"№\")","v":3},null,8,null,null,{"$f":"COUNTIF(P$2:P45,\"№\")","v":3},null,8,null,null,{"$f":"COUNTIF(U$2:U45,\"№\")","v":3}]
[9,null,null,{"$f":"COUNTIF(A$2:A46,\"№\")","v":3},null,9,null,null,{"$f":"COUNTIF(F$2:F46,\"№\")","v":3},null,9,null,null,{"$f":"COUNTIF(K$2:K46,\"№\")","v":3},null,9,null,null,{"$f":"COUNTIF(P$2:P46,\"№\")","v":3},null,9,null,null,{"$f":"COUNTIF(U$2:U46,\"№\")","v":3}]
[10,null,null,{"$f":"COUNTIF(A$2:A47,\"№\")","v":3},null,10,null,null,{"$f":"COUNTIF(F$2:F47,\"№\")","v":3},null,10,null,null,{"$f":"COUNTIF(K$2:K47,\"№\")","v":3},null,10,null,null,{"$f":"COUNTIF(P$2:P47,\"№\")","v":3},null,10,null,null,{"$f":"COUNTIF(U$2:U47,\"№\")","v":3}]
[11,null,null,{"$f":"COUNTIF(A$2:A48,\"№\")","v":3},null,11,null,null,{"$f":"COUNTIF(F$2:F48,\"№\")","v":3},null,11,null,null,{"$f":"COUNTIF(K$2:K48,\"№\")","v":3},null,11,null,null,{"$f":"COUNTIF(P$2:P48,\"№\")","v":3},null,11,null,null,{"$f":"COUNTIF(U$2:U48,\"№\")","v":3}]
[12,null,null,{"$f":"COUNTIF(A$2:A49,\"№\")","v":3},null,12,null,null,{"$f":"COUNTIF(F$2:F49,\"№\")","v":3},null,12,null,null,{"$f":"COUNTIF(K$2:K49,\"№\")","v":3},null,12,null,null,{"$f":"COUNTIF(P$2:P49,\"№\")","v":3},null,12,null,null,{"$f":"COUNTIF(U$2:U49,\"№\")","v":3}]
[]
["Суп фасолевый",null,null,{"$f":"COUNTIF(A$2:A51,\"№\")","v":4},null,"Гречка по-купечески",null,null,{"$f":"COUNTIF(F$2:F51,\"№\")","v":4},null,"Картофель жареный",null,null,{"$f":"COUNTIF(K$2:K51,\"№\")","v":4},null,"Салат \"Крабовый\"",null,null,{"$f":"COUNTIF(P$2:P51,\"№\")","v":4},null,"Компот из сухофруктов",null,null,{"$f":"COUNTIF(U$2:U51,\"№\")","v":4}]
["№","Наименование продукта","Норма, г",{"$f":"COUNTIF(A$2:A52,\"№\")","v":4},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(F$2:F52,\"№\")","v":4},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(K$2:K52,\"№\")","v":4},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(P$2:P52,\"№\")","v":4},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(U$2:U52,\"№\")","v":4}]
[1,null,null,{"$f":"COUNTIF(A$2:A53,\"№\")","v":4},null,1,null,null,{"$f":"COUNTIF(F$2:F53,\"№\")","v":4},null,1,null,null,{"$f":"COUNTIF(K$2:K53,\"№\")","v":4},null,1,null,null,{"$f":"COUNTIF(P$2:P53,\"№\")","v":4},null,1,null,null,{"$f":"COUNTIF(U$2:U53,\"№\")","v":4}]
[2,null,null,{"$f":"COUNTIF(A$2:A54,\"№\")","v":4},null,2,null,null,{"$f":"COUNTIF(F$2:F54,\"№\")","v":4},null,2,null,null,{"$f":"COUNTIF(K$2:K54,\"№\")","v":4},null,2,null,null,{"$f":"COUNTIF(P$2:P54,\"№\")","v":4},null,2,null,null,{"$f":"COUNTIF(U$2:U54,\"№\")","v":4}]
[3,null,null,{"$f":"COUNTIF(A$2:A55,\"№\")","v":4},null,3,null,null,{"$f":"COUNTIF(F$2:F55,\"№\")","v":4},null,3,null,null,{"$f":"COUNTIF(K$2:K55,\"№\")","v":4},null,3,null,null,{"$f":"COUNTIF(P$2:P55,\"№\")","v":4},null,3,null,null,{"$f":"COUNTIF(U$2:U55,\"№\")","v":4}]
[4,null,null,{"$f":"COUNTIF(A$2:A57,\"№\")","v":4},null,4,null,null,{"$f":"COUNTIF(F$2:F57,\"№\")","v":4},null,4,null,null,{"$f":"COUNTIF(K$2:K57,\"№\")","v":4},null,4,null,null,{"$f":"COUNTIF(P$2:P57,\"№\")","v":4},null,4,null,null,{"$f":"COUNTIF(U$2:U57,\"№\")","v":4}]
[5,null,null,null,null,5,null,null,null,null,5,null,null,null,null,5,null,null,null,null,5]
[6,null,null,{"$f":"COUNTIF(A$2:A58,\"№\")","v":4},null,6,null,null,{"$f":"COUNTIF(F$2:F58,\"№\")","v":4},null,6,null,null,{"$f":"COUNTIF(K$2:K58,\"№\")","v":4},null,6,null,null,{"$f":"COUNTIF(P$2:P58,\"№\")","v":4},null,6,null,null,{"$f":"COUNTIF(U$2:U58,\"№\")","v":4}]
[7,null,null,{"$f":"COUNTIF(A$2:A59,\"№\")","v":4},null,7,null,null,{"$f":"COUNTIF(F$2:F59,\"№\")","v":4},null,7,null,null,{"$f":"COUNTIF(K$2:K59,\"№\")","v":4},null,7,null,null,{"$f":"COUNTIF(P$2:P59,\"№\")","v":4},null,7,null,null,{"$f":"COUNTIF(U$2:U59,\"№\")","v":4}]
[8,null,null,{"$f":"COUNTIF(A$2:A60,\"№\")","v":4},null,8,null,null,{"$f":"COUNTIF(F$2:F60,\"№\")","v":4},null,8,null,null,{"$f":"COUNTIF(K$2:K60,\"№\")","v":4},null,8,null,null,{"$f":"COUNTIF(P$2:P60,\"№\")","v":4},null,8,null,null,{"$f":"COUNTIF(U$2:U60,\"№\")","v":4}]
[9,null,null,{"$f":"COUNTIF(A$2:A61,\"№\")","v":4},null,9,null,null,{"$f":"COUNTIF(F$2:F61,\"№\")","v":4},null,9,null,null,{"$f":"COUNTIF(K$2:K61,\"№\")","v":4},null,9,null,null,{"$f":"COUNTIF(P$2:P61,\"№\")","v":4},null,9,null,null,{"$f":"COUNTIF(U$2:U61,\"№\")","v":4}]
[10,null,null,null,null,10,null,null,null,null,10,null,null,null,null,10,null,null,null,null,10]
[11,null,null,null,null,11,null,null,null,null,11,null,null,null,null,11,null,null,null,null,11]
[]
["рмрпм",null,null,{"$f":"COUNTIF(A$2:A65,\"№\")","v":5},null,"олто",null,null,{"$f":"COUNTIF(F$2:F65,\"№\")","v":5},null,null,null,null,{"$f":"COUNTIF(K$2:K65,\"№\")","v":5},null,null,null,null,{"$f":"COUNTIF(P$2:P65,\"№\")","v":5},null,null,null,null,{"$f":"COUNTIF(U$2:U65,\"№\")","v":5}]
["№","Наименование продукта","Норма, г",{"$f":"COUNTIF(A$2:A66,\"№\")","v":5},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(F$2:F66,\"№\")","v":5},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(K$2:K66,\"№\")","v":5},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(P$2:P66,\"№\")","v":5},null,"№","Наименование продукта","Норма, г",{"$f":"COUNTIF(U$2:U66,\"№\")","v":5}]
[1,null,null,{"$f":"COUNTIF(A$2:A67,\"№\")","v":5},null,1,null,null,{"$f":"COUNTIF(F$2:F67,\"№\")","v":5},null,1,null,null,{"$f":"COUNTIF(K$2:K67,\"№\")","v":5},null,1,null,null,{"$f":"COUNTIF(P$2:P67,\"№\")","v":5},null,1,null,null,{"$f":"COUNTIF(U$2:U67,\"№\")","v":5}]
[2,null,null,{"$f":"COUNTIF(A$2:A68,\"№\")","v":5},null,2,null,null,{"$f":"COUNTIF(F$2:F68,\"№\")","v":5},null,2,null,null,{"$f":"COUNTIF(K$2:K68,\"№\")","v":5},null,2,null,null,{"$f":"COUNTIF(P$2:P68,\"№\")","v":5},null,2,null,null,{"$f":"COUNTIF(U$2:U68,\"№\")","v":5}]
[3,null,null,{"$f":"COUNTIF(A$2:A69,\"№\")","v":5},null,3,null,null,{"$f":"COUNTIF(F$2:F69,\"№\")","v":5},null,3,null,null,{"$f":"COUNTIF(K$2:K69,\"№\")","v":5},null,3,null,null,{"$f":"COUNTIF(P$2:P69,\"№\")","v":5},null,3,null,null,{"$f":"COUNTIF(U$2:U69,\"№\")","v":5}]
[4,null,null,{"$f":"COUNTIF(A$2:A70,\"№\")","v":5},null,4,null,null,{"$f":"COUNTIF(F$2:F70,\"№\")","v":5},null,4,null,null,{"$f":"COUNTIF(K$2:K70,\"№\")","v":5},null,4,null,null,{"$f":"COUNTIF(P$2:P70,\"№\")","v":5},null,4,null,null,{"$f":"COUNTIF(U$2:U70,\"№\")","v":5}]
[5,null,null,{"$f":"COUNTIF(A$2:A71,\"№\")","v":5},null,5,null,null,{"$f":"COUNTIF(F$2:F71,\"№\")","v":5},null,5,null,null,{"$f":"COUNTIF(K$2:K71,\"№\")","v":5},null,5,null,null,{"$f":"COUNTIF(P$2:P71,\"№\")","v":5},null,5,null,null,{"$f":"COUNTIF(U$2:U71,\"№\")","v":5}]
[6,null,null,{"$f":"COUNTIF(A$2:A72,\"№\")","v":5},null,6,null,null,{"$f":"COUNTIF(F$2:F72,\"№\")","v":5},null,6,null,null,{"$f":"COUNTIF(K$2:K72,\"№\")","v":5},null,6,null,null,{"$f":"COUNTIF(P$2:P72,\"№\")","v":5},null,6,null,null,{"$f":"COUNTIF(U$2:U72,\"№\")","v":5}]
[7,null,null,{"$f":"COUNTIF(A$2:A73,\"№\")","v":5},null,7,null,null,{"$f":"COUNTIF(F$2:F73,\"№\")","v":5},null,7,null,null,{"$f":"COUNTIF(K$2:K73,\"№\")","v":5},null,7,null,null,{"$f":"COUNTIF(P$2:P73,\"№\")","v":5},null,7,null,null,{"$f":"COUNTIF(U$2:U73,\"№\")","v":5}]
[8,null,null,{"$f":"COUNTIF(A$2:A74,\"№\")","v":5},null,8,null,null,{"$f":"COUNTIF(F$2:F74,\"№\")","v":5},null,8,null,null,{"$f":"COUNTIF(K$2:K74,\"№\")","v":5},null,8,null,null,{"$f":"COUNTIF(P$2:P74,\"№\")","v":5},null,8,null,null,{"$f":"COUNTIF(U$2:U74,\"№\")","v":5}]
[9,null,null,{"$f":"COUNTIF(A$2:A75,\"№\")","v":5},null,9,null,null,{"$f":"COUNTIF(F$2:F75,\"№\")","v":5},null,9,null,null,{"$f":"COUNTIF(K$2:K75,\"№\")","v":5},null,9,null,null,{"$f":"COUNTIF(P$2:P75,\"№\")","v":5},null,9,null,null,{"$f":"COUNTIF(U$2:U75,\"№\")","v":5}]
[10,null,null,{"$f":"COUNTIF(A$2:A76,\"№\")","v":5},null,10,null,null,{"$f":"COUNTIF(F$2:F76,\"№\")","v":5},null,10,null,null,{"$f":"COUNTIF(K$2:K76,\"№\")","v":5},null,10,null,null,{"$f":"COUNTIF(P$2:P76,\"№\")","v":5},null,10,null,null,{"$f":"COUNTIF(U$2:U76,\"№\")","v":5}]
[11,null,null,{"$f":"COUNTIF(A$2:A77,\"№\")","v":5},null,11,null,null,{"$f":"COUNTIF(F$2:F77,\"№\")","v":5},null,11,null,null,{"$f":"COUNTIF(K$2:K77,\"№\")","v":5},null,11,null,null,{"$f":"COUNTIF(P$2:P77,\"№\")","v":5},null,11,null,null,{"$f":"COUNTIF(U$2:U77,\"№\")","v":5}]
[12,null,null,{"$f":"COUNTIF(A$2:A78,\"№\")","v":5},null,12,null,null,{"$f":"COUNTIF(F$2:F78,\"№\")","v":5},null,12,null,null,{"$f":"COUNTIF(K$2:K78,\"№\")","v":5},null,12,null,null,{"$f":"COUNTIF(P$2:P78,\"№\")","v":5},null,12,null,null,{"$f":"COUNTIF(U$2:U78,\"№\")","v":5}]

{"sheet":"Прих","index":1,"n_rows":59,"n_cols":28,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,15,35,19],[36,15,36,19],[37,15,37,19],[38,15,38,19],[39,15,39,19],[40,15,40,19],[47,15,47,19],[48,15,48,19],[49,15,49,19],[41,15,41,19],[42,15,42,19],[43,15,43,19],[44,15,44,19],[45,15,45,19],[46,15,46,19],[43,22,43,23],[44,22,44,23],[45,22,45,23],[46,22,46,23],[47,22,47,23],[48,22,48,23],[37,22,37,23],[38,22,38,23],[39,22,39,23],[40,22,40,23],[41,22,41,23],[42,22,42,23],[41,20,41,21],[48,20,48,21],[49,20,49,21],[29,22,29,23],[30,22,30,23],[31,22,31,23],[32,22,32,23],[33,22,33,23],[34,22,34,23],[35,22,35,23],[36,22,36,23],[42,20,42,21],[43,20,43,21],[44,20,44,21],[45,20,45,21],[46,20,46,21],[47,20,47,21],[35,20,35,21],[36,20,36,21],[37,20,37,21],[38,20,38,21],[39,20,39,21],[40,20,40,21],[29,20,29,21],[47,6,47,12],[48,6,48,12],[39,13,39,14],[40,13,40,14],[41,13,41,14],[42,13,42,14],[43,13,43,14],[44,13,44,14],[39,6,39,12],[40,6,40,12],[29,6,29,12],[30,6,30,12],[31,6,31,12],[32,6,32,12],[33,6,33,12],[34,6,34,12],[31,20,31,21],[32,20,32,21],[33,20,33,21],[34,20,34,21],[30,20,30,21],[29,15,29,19],[30,15,30,19],[31,15,31,19],[32,15,32,19],[33,15,33,19],[29,13,29,14],[30,13,30,14],[31,13,31,14],[32,13,32,14],[33,13,33,14],[34,13,34,14],[34,15,34,19],[35,13,35,14],[36,13,36,14],[57,6,57,12],[57,13,57,14],[53,6,53,12],[53,13,53,14],[50,6,50,12],[50,13,50,14],[43,6,43,12],[41,6,41,12],[42,6,42,12],[37,13,37,14],[38,13,38,14],[49,6,49,12],[35,6,35,12],[36,6,36,12],[37,6,37,12],[38,6,38,12],[47,13,47,14],[48,13,48,14],[45,13,45,14],[44,6,44,12],[45,6,45,12],[46,6,46,12],[57,15,57,19],[57,20,57,21],[57,22,57,23],[55,6,55,12],[55,13,55,14],[55,15,55,19],[55,20,55,21],[55,22,55,23],[56,6,56,12],[56,13,56,14],[56,15,56,19],[56,20,56,21],[56,22,56,23],[53,15,53,19],[53,20,53,21],[53,22,53,23],[54,6,54,12],[54,13,54,14],[54,15,54,19],[54,20,54,21],[54,22,54,23],[51,6,51,12],[51,13,51,14],[51,15,51,19],[51,20,51,21],[51,22,51,23],[52,6,52,12],[52,13,52,14],[52,15,52,19],[52,20,52,21],[52,22,52,23],[26,6,26,12],[26,13,26,14],[26,15,26,19],[26,20,26,21],[26,22,26,23],[59,5,59,23],[58,5,58,21],[58,22,58,23],[27,6,27,12],[27,13,27,14],[27,15,27,19],[27,20,27,21],[27,22,27,23],[28,6,28,12],[28,13,28,14],[28,15,28,19],[28,20,28,21],[28,22,28,23],[50,15,50,19],[50,20,50,21],[50,22,50,23],[49,13,49,14],[49,22,49,23],[46,13,46,14],[24,6,24,12],[24,13,24,14],[24,15,24,19],[24,20,24,21],[24,22,24,23],[25,6,25,12],[25,13,25,14],[25,15,25,19],[25,20,25,21],[25,22,25,23],[22,6,22,12],[22,13,22,14],[22,15,22,19],[22,20,22,21],[22,22,22,23],[23,6,23,12],[23,13,23,14],[23,15,23,19],[23,20,23,21],[23,22,23,23],[20,6,20,12],[20,13,20,14],[20,15,20,19],[20,20,20,21],[20,22,20,23],[21,6,21,12],[21,13,21,14],[21,15,21,19],[21,20,21,21],[21,22,21,23],[18,6,18,12],[18,13,18,14],[18,15,18,19],[18,20,18,21],[18,22,18,23],[19,6,19,12],[19,13,19,14],[19,15,19,19],[19,20,19,21],[19,22,19,23],[16,6,16,12],[16,13,16,14],[16,15,16,19],[16,20,16,21],[16,22,16,23],[17,6,17,12],[17,13,17,14],[17,15,17,19],[17,20,17,21],[17,22,17,23],[12,5,12,23],[13,5,13,10],[13,11,13,17],[13,18,13,22],[7,26,11,26],[14,6,14,10],[14,11,14,17],[14,18,14,22],[15,5,15,23],[7,30,11,30],[8,5,8,11],[9,5,9,20],[9,21,9,23],[10,5,10,8],[10,9,10,20],[10,21,10,23],[11,5,11,16],[11,17,11,20],[11,21,11,23],[7,5,7,11],[7,12,8,20],[7,21,8,23],[0,5,0,23],[1,5,1,11],[1,12,1,23],[2,5,2,23],[3,5,3,20],[3,21,3,23],[7,27,11,27],[7,28,11,28],[7,29,11,29],[6,5,6,18],[6,19,6,20],[6,21,6,23],[4,5,4,15],[4,16,4,20],[4,21,4,23],[5,5,5,18],[5,19,5,20],[5,21,5,23]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Унифицированная форма № ОП-1\nУтверждена постановлением Госкомстата\nРоссии от 25.12.98 № 132  ",null,null,null,null,null,null,null,null,null,null,null,null,null,"День",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Месяц",9]
[null,null,null,null,"Товар",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Код",null,null,null,null,"Год",2022]
[null,null,null,null,"Борщ украинский",null,null,null,null,null,null,null,null,null,null,null,"Форма по ОКУД",null,null,null,null,330501]
[null,null,null,null,{"$f":"IF(AND(E5<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E2))=ROW(E1)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E2)),\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"по ОКПО"]
[null,null,null,null,{"$f":"IF(AND(E6<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E3))=ROW(E2)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E3)),\"\")","v":{"$error":"#REF!"}},"ООО \"Метро\""]
[null,null,null,null,{"$f":"IF(AND(E7<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E4))=ROW(E3)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E4)),\"\")","v":{"$error":"#REF!"}},"наименование поставщика",null,null,null,null,null,null,"Вид деятельности по ОКДП"]
[null,null,null,null,{"$f":"IF(AND(E8<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E5))=ROW(E4)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E5)),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"IF(AND(E9<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E6))=ROW(E5)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E6)),\"\")","v":{"$error":"#REF!"}},"ООО \"Сервис-М\""]
[null,null,null,null,{"$f":"IF(AND(E10<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E7))=ROW(E6)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E7)),\"\")","v":{"$error":"#REF!"}},"наименование получателя"]
[null,null,null,null,{"$f":"IF(AND(E11<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E8))=ROW(E7)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E8)),\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,"Вид операции"]
[null,null,null,null,{"$f":"IF(AND(E12<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E9))=ROW(E8)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E9)),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"IF(AND(E13<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E10))=ROW(E9)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E10)),\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Номер документа",null,null,null,null,null,null,"Дата прихода"]
[null,null,null,null,{"$f":"IF(AND(E14<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E11))=ROW(E10)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E11)),\"\")","v":{"$error":"#REF!"}},null,"ПРИХОДНАЯ НАКЛАДНАЯ",null,null,null,null,1,null,null,null,null,null,null,{"$f":"DATE($AB$4,$AB$3,$AB$2)","v":"2022-09-01"}]
[null,null,null,null,{"$f":"IF(AND(E15<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E12))=ROW(E11)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E12)),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"IF(AND(#REF!<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E14))=ROW(E13)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E14)),\"\")","v":{"$error":"#REF!"}},"№","Продукты",null,null,null,null,null,null,"Ед.",null,"Количество, кг",null,null,null,null,"Цена закупки, руб",null,"Сумма, руб"]
[null,null,null,null,{"$f":"IF(AND(E17<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E15))=ROW(E14)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E15)),\"\")","v":{"$error":"#REF!"}},1,"Гречка",null,null,null,null,null,null,"кг",null,5,null,null,null,null,50,null,{"$f":"IFERROR(P18*U18,\"\")","v":250}]
[null,null,null,null,{"$f":"IF(AND(E18<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E16))=ROW(E15)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E16)),\"\")","v":{"$error":"#REF!"}},2,"Рис",null,null,null,null,null,null,"кг",null,5,null,null,null,null,50,null,{"$f":"IFERROR(P19*U19,\"\")","v":250}]
[null,null,null,null,{"$f":"IF(AND(E19<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(#REF!))=ROW(E16)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(#REF!)),\"\")","v":{"$error":"#REF!"}},3,"Гречка",null,null,null,null,null,null,"кг",null,2,null,null,null,null,50,null,100]
[null,null,null,null,{"$f":"IF(AND(E20<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E17))=ROW(#REF!)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E17)),\"\")","v":{"$error":"#REF!"}},4,"Гречка",null,null,null,null,null,null,"кг",null,5,null,null,null,null,50,null,250]
[null,null,null,null,{"$f":"IF(AND(E21<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E18))=ROW(E17)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E18)),\"\")","v":{"$error":"#REF!"}},5,"Сахар",null,null,null,null,null,null,"кг",null,10,null,null,null,null,505,null,5050]
[null,null,null,null,{"$f":"IF(AND(E22<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E19))=ROW(E18)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E19)),\"\")","v":{"$error":"#REF!"}},6,"Сахар",null,null,null,null,null,null,"кг",null,2,null,null,null,null,5,null,10]
[null,null,null,null,{"$f":"IF(AND(E23<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E20))=ROW(E19)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E20)),\"\")","v":{"$error":"#REF!"}},7,"Помидоры",null,null,null,null,null,null,"кг",null,2,null,null,null,null,5,null,10]
[null,null,null,null,{"$f":"IF(AND(E24<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E21))=ROW(E20)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E21)),\"\")","v":{"$error":"#REF!"}},8,"Помидоры",null,null,null,null,null,null,"кг",null,2,null,null,null,null,5,null,10]
[null,null,null,null,{"$f":"IF(AND(E25<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E22))=ROW(E21)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E22)),\"\")","v":{"$error":"#REF!"}},9,"Помидоры",null,null,null,null,null,null,"кг",null,2,null,null,null,null,50,null,100]
[null,null,null,null,{"$f":"IF(AND(E26<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E23))=ROW(E22)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E23)),\"\")","v":{"$error":"#REF!"}},10,"Помидоры",null,null,null,null,null,null,"кг",null,2,null,null,null,null,50,null,100]
[null,null,null,null,{"$f":"IF(AND(E27<>\"\",INDEX('Состав блюд'!A:A,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E24))=ROW(E23)),INDEX('Состав блюд'!B:B,MATCH(INDEX(#REF!,MATCH(E$5,#REF!,)),'Состав блюд'!D:D,)+ROW(E24)),\"\")","v":{"$error":"#REF!"}},11,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P28*U28,\"\")","v":0}]
[null,null,null,null,null,12,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,13,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P30*U30,\"\")","v":0}]
[null,null,null,null,null,14,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P31*U31,\"\")","v":0}]
[null,null,null,null,null,15,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,16,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,17,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,18,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,19,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,20,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,21,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,22,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,23,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P40*U40,\"\")","v":0}]
[null,null,null,null,null,24,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P41*U41,\"\")","v":0}]
[null,null,null,null,null,25,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,26,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,27,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,28,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,29,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,30,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,31,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P48*U48,\"\")","v":0}]
[null,null,null,null,null,32,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,33,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,34,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,35,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,36,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,37,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,38,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P55*U55,\"\")","v":0}]
[null,null,null,null,null,39,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,40,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,{"$f":"IFERROR(P57*U57,\"\")","v":0}]
[null,null,null,null,null,41,"Помидоры",null,null,null,null,null,null,"кг",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,"Итого стоимость, руб",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W18:X58)","v":6130}]

{"sheet":"Выгрузка из прих.накл.","index":2,"n_rows":5,"n_cols":36,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Дата","№ документа","Итого","Прим","Говядина","Гречка","Какао в порошке","Капуста","Картофель","Колбаса \"Докторская\"","Курица","Лавровый лист","Лук","Майонез","Масло растительное","Масло сливочное","Морковь","Огурец свежий","Перец сладкий","Помидоры","Рис","Сахар","Свекла","Свинина","Соль","Сухари панировочные","Сыр","Томатная паста","Уксус 9%-ный","Чай","Яйца куриные","рм","итм","Укроп","Сало","Спирт"]
["2022-09-01",1,6130,null,null,600,null,null,null,null,null,null,null,null,null,null,null,null,null,220,250,5060]
["2022-09-01",1,"__________",null,null,"50руб./кг",null,null,null,null,null,null,null,null,null,null,null,null,null,"50руб./кг","50руб./кг","5руб./кг"]
["2022-09-01",1,6130,null,null,600,null,null,null,null,null,null,null,null,null,null,null,null,null,220,250,5060]
["2022-09-01",1,"__________",null,null,"50руб./кг",null,null,null,null,null,null,null,null,null,null,null,null,null,"50руб./кг","50руб./кг","5руб./кг"]