{"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":196,"n_cols":14,"rows_kept":196,"cut":false,"hidden":false,"merged":[[99,2,99,3],[118,2,118,3],[137,2,137,3],[156,2,156,3],[175,2,175,3],[194,2,194,3],[195,2,195,4],[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[61,2,61,3],[80,2,80,3]]}
["Школа",null,"МБОУ СОШ № 84",null,null,"Утвердил:","должность","Диспетчер по питанию"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Показаньева И.А"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",18.0,1.0,2024.0]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1.0,1.0,"Завтрак","гор.блюдо","Каша вязкая молочная из пшенна с маслом","200/10",7.52,11.72,37.05,285.0,173.01,29.0]
[]
[null,null,null,"гор.напиток","Кофейный напиток с молоком",200.0,3.17,2.68,15.95,100.6,379.0,17.09]
[null,null,null,"хлеб","Батон ",30.0,1.76,0.29,13.34,61.0,null,10.0,null,"                 "]
[null,null,null,"фрукты","Яблоко ",100.0,0.4,0.4,9.8,47.0,3338.0,17.94]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":330},12.85,15.09,76.14,493.6,null,{"$f":"SUM(L6:L12)","v":74.03}]
[{"$f":"A6","v":1},1,"Обед","фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[null,null,null,"1 блюдо","Щи из свежей капусты с картофелем со сметаной","200/10",1.6,5.2,6.4,83.8,46.23,17.38]
[null,null,null,"2 блюдо","Гуляш из  филе индейки",100.0,14.1,12.2,5.6,203.4,280.05,59.17]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150.0,10.4,15.8,50.1,390.3,917.0,12.05]
[null,null,null,"напиток","Кисель \"Витошка\"",200.0,null,null,24.0,95.0,82.03,11.16]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.52]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.01]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F14:F22)","v":650},30.5,34.2,125.4,961,null,{"$f":"SUM(L14:L22)","v":122.99}]
[{"$f":"A6","v":1},1,"Итого за день:",null,null,{"$f":"F13+F23","v":980},43.35,49.29,201.54,1454.6,null,{"$f":"L13+L23","v":197.02}]
[1.0,2.0,"Завтрак","гор.блюдо","Омлет натуральный с   маслом",150.0,15.0,26.9,2.7,312.6,160.02,65.0]
[null,null,null,"хол.блюдо","Салат из  свеклы",60.0,0.9,2.1,5.4,43.2,20.14,8.92]
[null,null,null,"гор.напиток","Чай с сахаром",200.0,0.2,null,13.7,51.2,197.0,3.38]
[null,null,null,"хлеб","Батон витаминизированный",30.0,2.3,0.9,15.2,78.6,299.0,2.48]
[null,null,null,"выпечка","Кейк",45.0,2.5,5.0,28.5,166.1,524.01,17.25]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F25:F31)","v":485},20.9,34.9,65.5,651.7,null,{"$f":"SUM(L25:L31)","v":97.03}]
[{"$f":"A25","v":1},2,"Обед","закуска","Выпечка из слоеного теста",50.0,3.5,5.8,33.9,204.2,401.07,14.95]
[null,null,null,"1 блюдо","Суп картофельный с  макаронными изделиями",200.0,2.3,2.0,16.7,96.0,71.06,12.55]
[null,null,null,"2 блюдо","Котлета  мясная",90.0,14.5,11.5,10.2,206.2,308.14,52.11]
[null,null,null,"гарнир","Капуста тушеная",150.0,2.6,4.7,10.9,88.4,482.16,19.4]
[null,null,null,"напиток","Напиток \"Здоровье\" из вишни",200.0,0.1,0.1,21.8,85.7,625.0,8.68]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.52]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.01]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F33:F41)","v":740},26.8,24.5,118.1,801.5,null,{"$f":"SUM(L33:L41)","v":110.22}]
[{"$f":"A25","v":1},2,"Итого за день:",null,null,{"$f":"F32+F42","v":1225},47.7,59.4,183.6,1453.2,null,{"$f":"L32+L42","v":207.25}]
[1.0,3.0,"Завтрак","гор.блюдо","Филе  куриное в красном соусе",100.0,15.3,3.8,0.3,94.5,171.2,59.51]
[null,null,null,"гарнир","Макаронные изделия отварные/Огурец свежий 150/20",170.0,5.3,4.7,35.6,209.3,150.02,15.53]
[null,null,null,"гор.напиток","Чай с  лимоном",207.0,0.3,0.1,13.9,53.2,198.0,6.48]
[null,null,null,"хлеб","Батон витаминизированный",30.0,2.3,0.9,15.2,78.6,299.0,2.48]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F44:F50)","v":507},23.2,9.5,65,435.6,null,{"$f":"SUM(L44:L50)","v":84}]
[{"$f":"A44","v":1},3,"Обед","закуска"]
[null,null,null,"1 блюдо","Рассольник домашний со  сметаной",210.0,1.9,6.3,12.4,115.6,70.1,24.47]
[null,null,null,"2 блюдо","Запеканка пикантная из филе куры",100.0,12.4,6.9,2.0,106.8,684.0,63.99]
[null,null,null,"гарнир","Рис припущенный/Огурец свежий 150/20",170.0,2.3,8.5,21.4,174.0,232.28,19.11]
[null,null,null,"напиток","Компот из свежих  яблок",200.0,0.2,0.2,27.9,109.0,209.01,9.51]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.52]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.01]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F52:F60)","v":730},20.6,22.3,88.3,626.4,null,{"$f":"SUM(L52:L60)","v":119.61}]
[{"$f":"A44","v":1},3,"Итого за день:",null,null,{"$f":"F51+F61","v":1237},43.8,31.8,153.3,1062,null,{"$f":"L51+L61","v":203.61}]
[1.0,4.0,"Завтрак","гор.блюдо","Пудинг  творожный c молочным  соусом (на сгущенном молоке)",130.0,13.4,8.9,24.0,228.5,188.17,55.0]
[]
[null,null,null,"гор.напиток","Чай с сахаром",200.0,0.2,null,13.7,51.2,197.0,3.38]
[null,null,null,"хлеб","Бутерброд с маслом",40.0,2.3,9.2,15.3,153.4,1.02,14.79]
[null,null,null,"фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F63:F69)","v":520},16.5,18.7,67.7,500.6,null,{"$f":"SUM(L63:L69)","v":93.87}]
[{"$f":"A63","v":1},4,"Обед","фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[null,null,null,"1 блюдо","Борщ с капустой  и картофелем со сметаной",210.0,1.6,5.2,8.1,94.5,49.09,20.24]
[null,null,null,"2 блюдо","Котлета рыбная",90.0,14.3,5.1,13.6,157.7,141.47,33.4]
[null,null,null,"гарнир","Картофельное пюре",150.0,3.2,5.2,11.0,140.7,472.99,27.83]
[null,null,null,"напиток","Компот из смеси сухофруктов",200.0,0.4,null,26.3,104.0,212.01,7.68]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.73]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.15]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F71:F79)","v":850},23.9,16.5,98.3,685.4,null,{"$f":"SUM(L71:L79)","v":112.73}]
[{"$f":"A63","v":1},4,"Итого за день:",null,null,{"$f":"F70+F80","v":1370},40.4,35.2,166,1186,null,{"$f":"L70+L80","v":206.6}]
[1.0,5.0,"Завтрак","гор.блюдо","Каша молочная  геркулесовая  с маслом",210.0,7.1,12.3,29.3,256.5,257.36,24.0]
[]
[null,null,null,"гор.напиток","Чай с молоком",200.0,1.5,1.5,15.8,77.3,630.96,9.28]
[null,null,null,"хлеб","Батон витаминизированный",30.0,2.3,0.9,15.2,78.6,299.0,2.48]
[null,null,null,"сладкое","Йогурт фруктовый",1.0,3.0,1.2,8.5,77.0,null,39.32]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F82:F88)","v":441},13.9,15.9,68.8,489.4,null,{"$f":"SUM(L82:L88)","v":75.08}]
[{"$f":"A82","v":1},5,"Обед","закуска"]
[null,null,null,"1 блюдо","Суп-пюре из разных овощей  с гренками",210.0,2.6,3.3,13.9,96.4,82.19,13.43]
[null,null,null,"2 блюдо","Наггетсы из  филе куры по-домашнему",90.0,23.4,7.7,9.2,201.5,888.0,74.68]
[null,null,null,"гарнир","Макаронные изделия отварные/Огурец свежий 150/20",170.0,5.3,4.7,35.6,209.3,150.02,13.94]
[null,null,null,"напиток","Напиток из вишни",200.0,0.2,0.1,23.7,91.2,612.0,14.31]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.52]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.01]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F90:F98)","v":720},35.3,16.2,107,719.4,null,{"$f":"SUM(L90:L98)","v":118.89}]
[{"$f":"A82","v":1},5,"Итого за день:",null,null,{"$f":"F89+F99","v":1161},49.2,32.1,175.8,1208.8,null,{"$f":"L89+L99","v":193.97}]
[2.0,1.0,"Завтрак","гор.блюдо","Каша молочная ячневая с маслом сливочным",210.0,7.0,12.0,38.6,292.1,560.03,26.99]
[]
[null,null,null,"гор.напиток","Кофейный напиток с молоком",200.0,2.8,2.1,21.0,103.0,692.04,15.86]
[null,null,null,"хлеб","Бутерброд с  сыром",45.0,6.2,4.9,15.2,131.4,3.1,17.86]
[null,null,null,"фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F101:F107)","v":605},16.6,19.6,89.5,594,null,{"$f":"SUM(L101:L107)","v":81.41}]
[{"$f":"A101","v":2},1,"Обед","закуска","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[null,null,null,"1 блюдо","Суп из овощей со сметаной",210.0,1.6,5.3,7.8,91.5,58.24,21.33]
[null,null,null,"2 блюдо","Филе  куриное в красном соусе",100.0,15.3,3.8,0.3,94.5,171.2,55.62]
[null,null,null,"гарнир","Рис \"Золотистый\"",150.0,3.7,4.7,37.3,209.7,232.0,16.45]
[null,null,null,"напиток","Напиток витаминизированный \"Витошка\"",200.0,null,null,19.4,78.0,213.05,9.22]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.52]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.01]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F109:F117)","v":860},25,14.8,104.1,662.2,null,{"$f":"SUM(L109:L117)","v":125.85}]
[{"$f":"A101","v":2},1,"Итого за день:",null,null,{"$f":"F108+F118","v":1465},41.6,34.4,193.6,1256.2,null,{"$f":"L108+L118","v":207.26}]
[2.0,2.0,"Завтрак","гор.блюдо","Омлет натуральный с   маслом",150.0,15.0,26.9,2.7,312.6,160.02,65.0]
[null,null,null,"закуска","Огурец малосольный",60.0,0.5,0.1,1.6,8.4,1110.0,12.8]
[null,null,null,"гор.напиток","Чай с сахаром",200.0,0.2,null,13.7,51.2,197.0,3.38]
[null,null,null,"хлеб","Батон витаминизированный",30.0,2.3,0.9,15.2,78.6,299.0,2.48]
[null,null,null,"фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F120:F126)","v":590},18.6,28.5,47.9,518.3,null,{"$f":"SUM(L120:L126)","v":104.36}]
[{"$f":"A120","v":2},2,"Обед","закуска","Огурец малосольный",60.0,0.5,0.1,1.6,8.4,1110.0,10.85]
[null,null,null,"1 блюдо","Рассольник ленинградский  со сметаной",210.0,2.0,5.3,13.9,113.8,56.17,19.14]
[null,null,null,"2 блюдо","Шницель  мясной",90.0,14.2,13.6,11.2,229.3,308.17,50.0]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150.0,10.4,15.8,50.1,390.3,917.0,12.56]
[null,null,null,"напиток","Компот из смеси сухофруктов",200.0,0.4,null,26.3,104.0,212.01,7.68]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.73]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.15]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F128:F136)","v":760},31.3,35.2,127.7,966.8,null,{"$f":"SUM(L128:L136)","v":103.11}]
[{"$f":"A120","v":2},2,"Итого за день:",null,null,{"$f":"F127+F137","v":1350},49.9,63.7,175.6,1485.1,null,{"$f":"L127+L137","v":207.47}]
[2.0,3.0,"Завтрак","гор.блюдо","Суфле  рыбное \"Витаминка\"",90.0,11.1,9.2,8.9,158.5,886.04,43.18]
[null,null,null,"гарнир","Картофельное пюре/Огурец свежий 150/20",170.0,3.2,5.2,10.8,138.2,472.62,31.13]
[null,null,null,"гор.напиток","Чай с  лимоном",207.0,0.3,0.1,13.9,53.2,198.0,6.48]
[null,null,null,"хлеб","Батон  витаминизированный",50.0,3.8,1.5,25.3,131.0,299.07,4.14]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F139:F145)","v":517},18.4,16,58.9,480.9,null,{"$f":"SUM(L139:L145)","v":84.93}]
[{"$f":"A139","v":2},3,"Обед","закуска"]
[null,null,null,"1 блюдо","Суп картофельный с горохом",200.0,4.3,3.6,17.0,118.5,63.14,12.81]
[null,null,null,"2 блюдо","Кура  запеченная   по-домашнему",90.0,17.4,11.5,0.7,161.3,184.14,73.51]
[null,null,null,"гарнир","Макаронные изделия отварные/Огурец свежий 150/20",170.0,5.3,4.7,35.6,209.3,150.02,13.94]
[null,null,null,"напиток","Компот из свежих  яблок",200.0,0.2,0.2,27.9,109.0,209.01,9.51]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.52]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.01]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F147:F155)","v":710},31,20.4,105.8,719.1,null,{"$f":"SUM(L147:L155)","v":112.3}]
[{"$f":"A139","v":2},3,"Итого за день:",null,null,{"$f":"F146+F156","v":1227},49.4,36.4,164.7,1200,null,{"$f":"L146+L156","v":197.23}]
[2.0,4.0,"Завтрак","гор.блюдо","Пудинг  творожный c молочным  соусом (на сгущенном молоке)",130.0,13.4,8.9,24.0,228.5,188.17,55.0]
[]
[null,null,null,"гор.напиток","Чай с сахаром",200.0,0.2,null,13.7,51.2,197.0,3.38]
[null,null,null,"хлеб","Бутерброд с маслом",40.0,2.3,9.2,15.3,153.4,1.02,14.79]
[null,null,null,"фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F158:F164)","v":520},16.5,18.7,67.7,500.6,null,{"$f":"SUM(L158:L164)","v":93.87}]
[{"$f":"A158","v":2},4,"Обед","фрукты","Яблоко свежее",150.0,0.6,0.6,14.7,67.5,351.02,20.7]
[null,null,null,"1 блюдо","Борщ с капустой  и картофелем со сметаной",210.0,1.6,5.2,8.1,94.5,49.09,20.24]
[null,null,null,"2 блюдо","Плов  из  свинины",235.0,11.6,25.6,38.8,456.4,276.62,47.4]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Напиток из вишни",200.0,0.2,0.1,23.7,91.2,612.0,14.27]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.73]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.15]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F166:F174)","v":845},17.8,31.9,109.9,830.6,null,{"$f":"SUM(L166:L174)","v":105.49}]
[{"$f":"A158","v":2},4,"Итого за день:",null,null,{"$f":"F165+F175","v":1365},34.3,50.6,177.6,1331.2,null,{"$f":"L165+L175","v":199.36}]
[2.0,5.0,"Завтрак","гор.блюдо","Каша молочная  рисовая с маслом сливочным",210.0,8.8,13.6,63.1,412.0,257.82,29.52]
[]
[null,null,null,"гор.напиток","Чай с молоком",200.0,1.5,1.5,15.8,77.3,630.96,9.28]
[null,null,null,"хлеб","Батон витаминизированный",30.0,2.3,0.9,15.2,78.6,299.0,2.48]
[null,null,null,"сладкое","Йогурт фруктовый",1.0,3.0,1.2,8.5,77.0,null,39.32]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F177:F183)","v":441},15.6,17.2,102.6,644.9,null,{"$f":"SUM(L177:L183)","v":80.6}]
[{"$f":"A177","v":2},5,"Обед","закуска","Выпечка из слоеного теста",50.0,3.5,5.8,33.9,204.2,401.07,14.95]
[null,null,null,"1 блюдо","Суп картофельный с  макаронными изделиями",200.0,2.3,2.0,16.7,96.0,71.06,13.29]
[null,null,null,"2 блюдо","Зразы рубленные с  капустой",90.0,11.4,12.7,10.0,204.7,687.17,42.1]
[null,null,null,"гарнир","Картофельное пюре",150.0,3.2,5.2,11.0,140.7,472.99,27.83]
[null,null,null,"напиток","Напиток из шиповника",200.0,0.6,null,22.1,88.0,213.01,12.64]
[null,null,null,"хлеб бел.","Хлеб   пшеничный с отрубями",30.0,2.3,0.2,14.6,71.4,299.08,1.73]
[null,null,null,"хлеб черн.","Хлеб   ржаной",20.0,1.5,0.2,10.0,49.6,299.12,1.15]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F185:F193)","v":740},24.8,26.1,118.3,854.6,null,{"$f":"SUM(L185:L193)","v":113.69}]
[{"$f":"A177","v":2},5,"Итого за день:",null,null,{"$f":"F184+F194","v":1181},40.4,43.3,220.9,1499.5,null,{"$f":"L184+L194","v":194.29}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F100+F119+F138+F157+F176+F195)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F81=0,0,1)+IF(F100=0,0,1)+IF(F119=0,0,1)+IF(F138=0,0,1)+IF(F157=0,0,1)+IF(F176=0,0,1)+IF(F195=0,0,1))","v":1256.1},44.005,43.619,181.264,1313.66,null,{"$f":"(L24+L43+L62+L81+L100+L119+L138+L157+L176+L195)/(IF(L24=0,0,1)+IF(L43=0,0,1)+IF(L62=0,0,1)+IF(L81=0,0,1)+IF(L100=0,0,1)+IF(L119=0,0,1)+IF(L138=0,0,1)+IF(L157=0,0,1)+IF(L176=0,0,1)+IF(L195=0,0,1))","v":201.406}]