{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Лист1","index":0,"n_rows":191,"n_cols":12,"rows_kept":191,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[61,2,61,3],[79,2,79,3],[97,2,97,3],[115,2,115,3],[133,2,133,3],[152,2,152,3],[171,2,171,3],[189,2,189,3],[190,2,190,4]]}
["Школа",null,"Школа №  9",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Иванова М.В."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",1,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:G12)","v":0},0,0,0]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска","Салат \"Здоровье\"",60,1,6,5,77,7]
[null,null,null,"1 блюдо","Суп картофельный с горохом, тушенкой",210,8,10,18,189,139]
[null,null,null,"2 блюдо","Тефтели с соусом",140,14,18,19,287,461]
[null,null,null,"гарнир","Макаронные изделия отварные",150,5,5,37,216,515]
[null,null,null,"напиток","Какао с молоком ",200,3,5,25,149,693]
[null,null,null,"хлеб бел.","Хлеб витаминный  1 кус.",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F14:F22)","v":791.25},{"$f":"SUM(G14:G22)","v":34},44,122,1004]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":791.25},{"$f":"G13+G23","v":34},44,122,1004]
[1,2,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F25:F31)","v":0},{"$f":"SUM(G25:G31)","v":0},{"$f":"SUM(H25:H31)","v":0},{"$f":"SUM(I25:I31)","v":0},{"$f":"SUM(J25:J31)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска","Морковь отварная с маслом растительным ",60,1,6,4,73,"сб.2004"]
[null,null,null,"1 блюдо","Щи из свежей капусты со сметаной ",206,5,9,7,127,124]
[null,null,null,"2 блюдо","Плов по-узбекски ",200,19,24,41,457,444]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Компот из слив  ",200,null,null,34,134,585]
[null,null,null,"хлеб бел.","Хлеб витаминный ",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F33:F41)","v":697.25},{"$f":"SUM(G33:G41)","v":28},{"$f":"SUM(H33:H41)","v":39},{"$f":"SUM(I33:I41)","v":104},{"$f":"SUM(J33:J41)","v":877}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":697.25},{"$f":"G32+G42","v":28},{"$f":"H32+H42","v":39},{"$f":"I32+I42","v":104},{"$f":"J32+J42","v":877}]
[1,3,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F44:F50)","v":0},{"$f":"SUM(G44:G50)","v":0},{"$f":"SUM(H44:H50)","v":0},{"$f":"SUM(I44:I50)","v":0},{"$f":"SUM(J44:J50)","v":0}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска","Салат из свежей капусты",60,1,5,5,69,43.200400000000002]
[null,null,null,"1 блюдо","Рассольник Ленинградский  со сметаной",206,2,6,14,122,132]
[null,null,null,"2 блюдо","Суфле Рыбка (минтай)  с соусом ",140,19,17,9,263,43.200299999999999]
[null,null,null,"гарнир","Картофельное пюре ",160,3,6,22,156,520]
[null,null,null,"напиток","Напиток Витошка ",200,null,null,9,34,81]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F52:F60)","v":797.25},{"$f":"SUM(G52:G60)","v":28},{"$f":"SUM(H52:H60)","v":34},{"$f":"SUM(I52:I60)","v":77},{"$f":"SUM(J52:J60)","v":730}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":797.25},{"$f":"G51+G61","v":28},{"$f":"H51+H61","v":34},{"$f":"I51+I61","v":77},{"$f":"J51+J61","v":730}]
[1,4,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F63:F69)","v":0},{"$f":"SUM(G63:G69)","v":0},{"$f":"SUM(H63:H69)","v":0},{"$f":"SUM(I63:I69)","v":0},{"$f":"SUM(J63:J69)","v":0}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска","Салат из свежих помидоров",60,1,12,3,122,19]
[null,null,null,"1 блюдо","Борщ из свежей капусты со сметаной ",210,2,6,11,102,110]
[null,null,null,"2 блюдо","Гуляш ",100,9,28,3,410,437]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150,4,7,39,233,"ст.246"]
[null,null,null,"напиток","Чай с сахаром",215,null,null,15,57,685]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[null,null,null,"итого",null,{"$f":"SUM(F71:F78)","v":766.25},{"$f":"SUM(G71:G78)","v":19},{"$f":"SUM(H71:H78)","v":53},{"$f":"SUM(I71:I78)","v":89},{"$f":"SUM(J71:J78)","v":1010}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F79","v":766.25},{"$f":"G70+G79","v":19},{"$f":"H70+H79","v":53},{"$f":"I70+I79","v":89},{"$f":"J70+J79","v":1010}]
[1,5,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F81:F87)","v":0},{"$f":"SUM(G81:G87)","v":0},{"$f":"SUM(H81:H87)","v":0},{"$f":"SUM(I81:I87)","v":0},{"$f":"SUM(J81:J87)","v":0}]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Обед","закуска","Салат из свежей капусты с вареной свеклой",60,1,6,7,83,11]
[null,null,null,"1 блюдо","Суп картофельный с  крупой, цыпленком",210,6,7,14,141,138]
[null,null,null,"2 блюдо","Котлета Дружба с соусом",140,12,34,8,430,45]
[null,null,null,"гарнир","Картофельное пюре",150,3,6,22,156,520]
[null,null,null,"напиток","Напиток Витошка ",200,null,null,9,34,81]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[null,null,null,"итого",null,{"$f":"SUM(F89:F96)","v":791.25},{"$f":"SUM(G89:G96)","v":25},{"$f":"SUM(H89:H96)","v":53},{"$f":"SUM(I89:I96)","v":78},{"$f":"SUM(J89:J96)","v":930}]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F88+F97","v":791.25},{"$f":"G88+G97","v":25},{"$f":"H88+H97","v":53},{"$f":"I88+I97","v":78},{"$f":"J88+J97","v":930}]
[2,1,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F99:F105)","v":0},{"$f":"SUM(G99:G105)","v":0},0,0,0]
[{"$f":"A99","v":2},{"$f":"B99","v":1},"Обед","закуска","Нарезка овощная (огурец)",60,0,0,2,8,24]
[null,null,null,"1 блюдо","Суп-пюре с гренками",220,4,5,24,159,171]
[null,null,null,"2 блюдо","Капуста тушеная с мясом",195,13,29,17,491,534]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Чай с сахаром ",215,null,null,15,57,685]
[null,null,null,"хлеб бел.","Хлеб витаминный ",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[null,null,null,"итого",null,{"$f":"SUM(F107:F114)","v":721.25},{"$f":"SUM(G107:G114)","v":20},{"$f":"SUM(H107:H114)","v":34},{"$f":"SUM(I107:I114)","v":76},{"$f":"SUM(J107:J114)","v":801}]
[{"$f":"A99","v":2},{"$f":"B99","v":1},"Итого за день:",null,null,{"$f":"F106+F115","v":721.25},{"$f":"G106+G115","v":20},{"$f":"H106+H115","v":34},{"$f":"I106+I115","v":76},{"$f":"J106+J115","v":801}]
[2,2,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F117:F123)","v":0},{"$f":"SUM(G117:G123)","v":0},0,0,0]
[{"$f":"A117","v":2},{"$f":"B117","v":2},"Обед","закуска","Свекла отварная с маслом растительным",60,1,1,5,28,2004]
[null,null,null,"1 блюдо","Суп из овощей со сметаной",206,5,9,10,142,135]
[null,null,null,"2 блюдо","Суфле из филе птицы с соусом",140,14,20,11,283,506]
[null,null,null,"гарнир","Макаронные изделия отварные",150,5,5,37,216,516]
[null,null,null,"напиток","Напиток из ягод",200,null,null,26,102,700]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[null,null,null,"итого",null,{"$f":"SUM(F125:F132)","v":787.25},{"$f":"SUM(G125:G132)","v":28},{"$f":"SUM(H125:H132)","v":35},{"$f":"SUM(I125:I132)","v":107},{"$f":"SUM(J125:J132)","v":857}]
[{"$f":"A117","v":2},{"$f":"B117","v":2},"Итого за день:",null,null,{"$f":"F124+F133","v":787.25},{"$f":"G124+G133","v":28},{"$f":"H124+H133","v":35},{"$f":"I124+I133","v":107},{"$f":"J124+J133","v":857}]
[2,3,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F135:F141)","v":0},{"$f":"SUM(G135:G141)","v":0},0,0,0]
[{"$f":"A135","v":2},{"$f":"B135","v":3},"Обед","закуска","Салат из свежих помидоров, огурцов",60,1,8,9,86,20]
[null,null,null,"1 блюдо","Суп картофельный с крупой и рыбой ",210,4,4,14,107,138]
[null,null,null,"2 блюдо","Котлета Аленушкина загадка",90,115,14,10,229,52]
[null,null,null,"гарнир","Макаронные изделия отварные",150,5,5,37,216,516]
[null,null,null,"напиток","Компот из сухофруктов",200,1,null,31,123,639]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F143:F151)","v":741.25},{"$f":"SUM(G143:G151)","v":129},31,119,847]
[{"$f":"A135","v":2},{"$f":"B135","v":3},"Итого за день:",null,null,{"$f":"F142+F152","v":741.25},{"$f":"G142+G152","v":129},{"$f":"H142+H152","v":31},{"$f":"I142+I152","v":119},{"$f":"J142+J152","v":847}]
[2,4,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F154:F160)","v":0},{"$f":"SUM(G154:G160)","v":0},0,0,0]
[{"$f":"A154","v":2},{"$f":"B154","v":4},"Обед","закуска","Салат \"Бурячок\"",60,1,9,4,100,16]
[null,null,null,"1 блюдо","Рассольник Домашний  со сметаной",210,2,6,12,115,131]
[null,null,null,"2 блюдо","Фрикадельки из курицы с соусом",145,14,20,7,261,63]
[null,null,null,"гарнир","Каша перловая (пшеничная) рассыпчатая",150,5,5,33,199,"т.4,2004"]
[null,null,null,"напиток","Напиток Витошка",200,null,null,9,34,81]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F162:F170)","v":796.25},{"$f":"SUM(G162:G170)","v":25},{"$f":"SUM(H162:H170)","v":40},{"$f":"SUM(I162:I170)","v":83},{"$f":"SUM(J162:J170)","v":795}]
[{"$f":"A154","v":2},{"$f":"B154","v":4},"Итого за день:",null,null,{"$f":"F161+F171","v":796.25},{"$f":"G161+G171","v":25},{"$f":"H161+H171","v":40},{"$f":"I161+I171","v":83},{"$f":"J161+J171","v":795}]
[2,5,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F173:F179)","v":0},{"$f":"SUM(G173:G179)","v":0},0,0,0]
[{"$f":"A173","v":2},{"$f":"B173","v":5},"Обед","закуска","Салат \"Здоровье\"",60,1,6,5,77,7]
[null,null,null,"1 блюдо","Суп картофельный с горохом, сметаной ",210,7,9,18,174,139]
[null,null,null,"2 блюдо","Жаркое по-домашнему",205,21,20,35,411,436]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Кофейный напиток с молоком",200,4,4,20,121,692]
[null,null,null,"хлеб бел.","Хлеб витаминный",31.25,3,null,18,86]
[null,null,null,"хлеб черн."]
[]
[null,null,null,"итого",null,{"$f":"SUM(F181:F188)","v":706.25},{"$f":"SUM(G181:G188)","v":36},{"$f":"SUM(H181:H188)","v":39},{"$f":"SUM(I181:I188)","v":96},{"$f":"SUM(J181:J188)","v":869}]
[{"$f":"A173","v":2},{"$f":"B173","v":5},"Итого за день:",null,null,{"$f":"F180+F189","v":706.25},{"$f":"G180+G189","v":36},{"$f":"H180+H189","v":39},{"$f":"I180+I189","v":96},{"$f":"J180+J189","v":869}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F80+F98+F116+F134+F153+F172+F190)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F80=0,0,1)+IF(F98=0,0,1)+IF(F116=0,0,1)+IF(F134=0,0,1)+IF(F153=0,0,1)+IF(F172=0,0,1)+IF(F190=0,0,1))","v":759.54999999999995},{"$f":"(G24+G43+G62+G80+G98+G116+G134+G153+G172+G190)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G80=0,0,1)+IF(G98=0,0,1)+IF(G116=0,0,1)+IF(G134=0,0,1)+IF(G153=0,0,1)+IF(G172=0,0,1)+IF(G190=0,0,1))","v":37.200000000000003},{"$f":"(H24+H43+H62+H80+H98+H116+H134+H153+H172+H190)/(IF(H24=0,0,1)+IF(H43=0,0,1)+IF(H62=0,0,1)+IF(H80=0,0,1)+IF(H98=0,0,1)+IF(H116=0,0,1)+IF(H134=0,0,1)+IF(H153=0,0,1)+IF(H172=0,0,1)+IF(H190=0,0,1))","v":40.200000000000003},{"$f":"(I24+I43+I62+I80+I98+I116+I134+I153+I172+I190)/(IF(I24=0,0,1)+IF(I43=0,0,1)+IF(I62=0,0,1)+IF(I80=0,0,1)+IF(I98=0,0,1)+IF(I116=0,0,1)+IF(I134=0,0,1)+IF(I153=0,0,1)+IF(I172=0,0,1)+IF(I190=0,0,1))","v":95.099999999999994},{"$f":"(J24+J43+J62+J80+J98+J116+J134+J153+J172+J190)/(IF(J24=0,0,1)+IF(J43=0,0,1)+IF(J62=0,0,1)+IF(J80=0,0,1)+IF(J98=0,0,1)+IF(J116=0,0,1)+IF(J134=0,0,1)+IF(J153=0,0,1)+IF(J172=0,0,1)+IF(J190=0,0,1))","v":872}]