{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":196,"n_cols":12,"rows_kept":196,"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],[80,2,80,3],[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]]}
["Школа",null,"МБОУ СОШ №6",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Владимирова"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша манная",200,39,11.8,47,305.5,384,21.22]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.6,0.9,43.9,182.1,294,3.3]
[{"$nulls":3},"хлеб","Бутерброд с сыром",50,5.8,5,17,122.5,3,14.74]
[{"$nulls":3},"фрукты","Апельсин",200,1.8,0.4,18.2,86,null,42]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":650},{"$f":"SUM(G6:G12)","v":47.199999999999996},18.1,126.10000000000001,696.1,null,{"$f":"SUM(L6:L12)","v":81.25999999999999}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп картофельный с горохом",250,35.1,24.9,16.5,452.6,226,25]
[{"$nulls":3},"2 блюдо","Птица, тушеная с овощами",90,25.7,8.7,9,362.3,649,42]
[{"$nulls":3},"гарнир","Рис отварной",150,19.7,8.5,31.6,198.6,378,25]
[{"$nulls":3},"напиток","Напиток",200,2.9,1.2,49.6,219,1010,15]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[{"$nulls":4},"Соус красный основной",50,1.3,2.93,5.6,66,759,5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":790},{"$f":"SUM(G14:G22)","v":89},47.23,137.7,1441.3,null,{"$f":"SUM(L14:L22)","v":115}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":1440},{"$f":"G13+G23","v":136.2},65.33,263.8,2137.4,null,{"$f":"L13+L23","v":196.26}]
[1,2,"Завтрак","гор.блюдо","Каша пшенная на молоке",200,38,18.1,49.82,329.1,173,21.34]
[]
[{"$nulls":3},"гор.напиток","Кофейный напиток ",200,19.7,1.8,22.8,113,958,7.12]
[{"$nulls":3},"хлеб","Бутерброд с колбасой",50,5.7,7.8,17,157,8,9.78]
[{"$nulls":3},"фрукты","Яблоко",200,0.8,0.8,19.6,94,null,28]
[{"$nulls":4},"Яйцо вареное",40,0.5,5.1,0.32,70,null,15]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":690},{"$f":"SUM(G25:G31)","v":64.7},{"$f":"SUM(H25:H31)","v":33.6},{"$f":"SUM(I25:I31)","v":109.53999999999999},{"$f":"SUM(J25:J31)","v":763.1},null,81.24000000000001]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Щи из свежей капусты с картофелем",250,34.2,29.7,8.9,524.3,187,30]
[{"$nulls":3},"2 блюдо","Котлета мясная",90,13.68,16.29,6.8,206.1,608,35]
[{"$nulls":3},"гарнир","Макароны отварные",180,5.02,10.7,27.6,202.14,414,30]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.33,0.02,14.7,77.6,1052,12]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[{"$nulls":4},"Соус красный основной",50,1.3,2.93,5.6,66,759,5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":820},{"$f":"SUM(G33:G41)","v":58.83},{"$f":"SUM(H33:H41)","v":60.64},{"$f":"SUM(I33:I41)","v":89},{"$f":"SUM(J33:J41)","v":1218.94},null,115]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":1510},{"$f":"G32+G42","v":123.53},{"$f":"H32+H42","v":94.24000000000001},{"$f":"I32+I42","v":198.54},{"$f":"J32+J42","v":1982.04},null,196.24]
[1,3,"Завтрак","гор.блюдо","Запеканка творожная ",210,66.32,60.78,28.07,852.6,469,34.21]
[]
[{"$nulls":3},"гор.напиток","Какао ",200,4.2,4.3,26.5,156.6,382,12.9]
[{"$nulls":3},"хлеб","Бутерброд с маслом",50,2.3,9.1,17,135.6,1,19.24]
[{"$nulls":3},"фрукты","Апельсин",200,1.8,0.4,18.2,86,null,42]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":660},{"$f":"SUM(G44:G50)","v":74.61999999999999},{"$f":"SUM(H44:H50)","v":74.58},{"$f":"SUM(I44:I50)","v":89.77},{"$f":"SUM(J44:J50)","v":1230.8},null,108.35]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп с рыбными консервами",250,6.4,5.5,23,192.9,270,27]
[{"$nulls":3},"2 блюдо","Сосиска отварная",90,9.02,8.9,1.7,117.8,null,40]
[{"$nulls":3},"гарнир","Картофельное пюре",200,5.19,4.4,38.2,213.7,299,35]
[{"$nulls":3},"напиток","Кисель",200,0,0,32,91.2,187,10]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":790},{"$f":"SUM(G52:G60)","v":24.91},{"$f":"SUM(H52:H60)","v":19.8},{"$f":"SUM(I52:I60)","v":120.30000000000001},{"$f":"SUM(J52:J60)","v":758.4000000000001},null,115]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":1450},{"$f":"G51+G61","v":99.52999999999999},{"$f":"H51+H61","v":94.38},{"$f":"I51+I61","v":210.07},{"$f":"J51+J61","v":1989.2},null,223.35]
[1,4,"Завтрак","гор.блюдо","Макароны отварные с сосиской",240,14.04,19.6,29.3,482.3,414,37.19]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.6,0.9,43.9,182.1,294,3.3]
[{"$nulls":3},"хлеб","Бутерброд с сыром",50,5.8,5,17,122.5,3,14.74]
[{"$nulls":3},"фрукты","Яблоко",200,0.8,0.8,19.6,94,null,28]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":690},{"$f":"SUM(G63:G69)","v":21.24},{"$f":"SUM(H63:H69)","v":26.3},{"$f":"SUM(I63:I69)","v":109.80000000000001},{"$f":"SUM(J63:J69)","v":880.9},null,83.22999999999999]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Борщ с курицей",250,40,30.16,22.9,486,197,35]
[{"$nulls":3},"2 блюдо","Котлета куриная",90,14,6.3,7.65,144,667,35]
[{"$nulls":3},"гарнир","Каша гречневая ",180,11.2,10.5,54,307.6,378,25]
[{"$nulls":3},"напиток","Компот из шиповника",200,5,1.3,45.8,77.6,1052,12]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[{"$nulls":4},"Соус красный основной",50,1.3,2.93,5.6,66,759,5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":820},{"$f":"SUM(G71:G79)","v":75.8},{"$f":"SUM(H71:H79)","v":52.19},{"$f":"SUM(I71:I79)","v":161.35},{"$f":"SUM(J71:J79)","v":1224},null,115]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":1510},{"$f":"G70+G80","v":97.03999999999999},{"$f":"H70+H80","v":78.49},{"$f":"I70+I80","v":271.15},{"$f":"J70+J80","v":2104.9},null,198.23]
[1,5,"Завтрак","гор.блюдо","Омлет натуральный",250,97,58.33,46.67,1085,215,60]
[]
[{"$nulls":3},"гор.напиток","Кофейный напиток ",200,19.7,1.8,22.8,113,958,7.12]
[{"$nulls":3},"хлеб","Бутерброд с колбасой",50,5.7,7.8,17,157,8,9.78]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":500},{"$f":"SUM(G82:G88)","v":122.4},{"$f":"SUM(H82:H88)","v":67.92999999999999},{"$f":"SUM(I82:I88)","v":86.47},{"$f":"SUM(J82:J88)","v":1355},null,76.9]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп куриный с макаронными изделиями",250,35.1,24.9,16.5,452.6,254,30]
[{"$nulls":3},"2 блюдо","Капуста тушеная с курицей",200,42.2,26.8,17,408.1,315,70]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.33,0.015,14.7,77.6,1052,12]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,72.4,null,3]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F98)","v":700},{"$f":"SUM(G90:G98)","v":81.93},{"$f":"SUM(H90:H98)","v":52.715},{"$f":"SUM(I90:I98)","v":73.6},{"$f":"SUM(J90:J98)","v":1010.7},null,115]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":1200},{"$f":"G89+G99","v":204.33},{"$f":"H89+H99","v":120.645},{"$f":"I89+I99","v":160.07},{"$f":"J89+J99","v":2365.7},null,191.9]
[2,1,"Завтрак","гор.блюдо","Каша рисовая ",200,33.9,11.6,53.2,402.6,175,23.31]
[]
[{"$nulls":3},"гор.напиток","Какао",200,4.2,4.3,26.5,156.6,382,12.9]
[{"$nulls":3},"хлеб","Бутерброд с сыром",50,5.8,5,17,122.5,3,14.74]
[{"$nulls":3},"фрукты","Яблоко",200,0.8,0.8,19.6,94,null,28]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":650},{"$f":"SUM(G101:G107)","v":44.699999999999996},21.7,116.30000000000001,775.7,null,{"$f":"SUM(L101:L107)","v":78.95}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Рассольник",250,40,30.16,22.9,477.3,197,32]
[{"$nulls":3},"2 блюдо","Котлета мясная",90,13.68,16.29,6.8,206.1,608,35]
[{"$nulls":3},"гарнир","Каша гречневая ",180,11.2,10.5,54,307.6,378,25]
[{"$nulls":3},"напиток","Напиток",200,2.9,1.2,49.6,219,1010,15]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[{"$nulls":4},"Соус красный основной",50,1.3,2.93,5.6,66,759,5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":820},{"$f":"SUM(G109:G117)","v":73.38},62.080000000000005,164.3,1418.8,null,{"$f":"SUM(L109:L117)","v":115}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Итого за день:",null,null,{"$f":"F108+F118","v":1470},{"$f":"G108+G118","v":118.07999999999998},{"$f":"H108+H118","v":83.78},{"$f":"I108+I118","v":280.6},{"$f":"J108+J118","v":2194.5},null,193.95]
[2,2,"Завтрак","гор.блюдо","Макароны с сыром",195,8.52,14.9,27.6,207.2,414,24.11]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.6,0.9,43.9,182.1,294,3.3]
[{"$nulls":3},"хлеб","Бутерброд с маслом",50,2.3,9.1,17,135.6,1,19.24]
[{"$nulls":3},"фрукты","Апельсин",200,1.8,0.4,18.2,86,null,42]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":645},{"$f":"SUM(G120:G126)","v":13.219999999999999},25.299999999999997,106.7,610.9,null,{"$f":"SUM(L120:L126)","v":88.65}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп картофельный с фасолью",250,35.1,24.9,16.5,452.6,206,35]
[{"$nulls":3},"2 блюдо","Котлета рыбная",90,35.4,21.7,20.4,152.9,510,30]
[{"$nulls":3},"гарнир","Картофельное пюре",200,5.19,4.4,38.2,213.7,299,35]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.33,0.015,14.7,77.6,1052,12]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":790},{"$f":"SUM(G128:G136)","v":80.32},52.01499999999999,115.19999999999999,1039.6000000000001,null,{"$f":"SUM(L128:L136)","v":115}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Итого за день:",null,null,{"$f":"F127+F137","v":1435},{"$f":"G127+G137","v":93.53999999999999},{"$f":"H127+H137","v":77.315},{"$f":"I127+I137","v":221.89999999999998},{"$f":"J127+J137","v":1650.5},null,203.65]
[2,3,"Завтрак","гор.блюдо","Каша геркулесовая",250,14.8,22,59,337.96,175,23.51]
[]
[{"$nulls":3},"гор.напиток","Кофейный напиток ",200,19.7,1.8,22.8,113,958,7.12]
[{"$nulls":3},"хлеб","Бутерброд с колбасой",50,5.7,7.8,17,157,8,9.78]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F145)","v":500},{"$f":"SUM(G139:G145)","v":40.2},31.6,98.8,607.96,null,{"$f":"SUM(L139:L145)","v":40.410000000000004}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп крестьянский",250,40.6,30.16,24,484.5,null,32]
[{"$nulls":3},"2 блюдо","Гуляш из свинины",90,25.7,8.7,9,362.3,null,45]
[{"$nulls":3},"гарнир","Макароны отварные",200,5.02,10.7,27.6,163.7,414,25]
[{"$nulls":3},"напиток","Кисель",200,0,0,32,243,187,10]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F155)","v":790},{"$f":"SUM(G147:G155)","v":75.61999999999999},50.56,118,1396.3,null,{"$f":"SUM(L147:L155)","v":115}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Итого за день:",null,null,{"$f":"F146+F156","v":1290},{"$f":"G146+G156","v":115.82},{"$f":"H146+H156","v":82.16},{"$f":"I146+I156","v":216.8},{"$f":"J146+J156","v":2004.26},null,155.41]
[2,4,"Завтрак","гор.блюдо","Каша \"Дружба\"",200,36.6,12.2,48.1,320.2,null,22.49]
[]
[{"$nulls":3},"гор.напиток","Какао ",200,4.2,4.3,26.5,156.6,382,12.9]
[{"$nulls":3},"хлеб","Бутерброд с сыром",50,5.8,5,17,122.5,3,14.74]
[{"$nulls":3},"фрукты","Апельсин",200,1.8,0.4,18.2,86,null,42]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F158:F164)","v":650},{"$f":"SUM(G158:G164)","v":48.4},21.9,109.8,685.3,null,{"$f":"SUM(L158:L164)","v":92.13}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Борщ с курицей",250,40,30.16,22.9,486,197,35]
[{"$nulls":3},"2 блюдо","Котлета куриная",90,14,6.3,7.65,144,667,35]
[{"$nulls":3},"гарнир","Рис отварной",150,19.7,8.5,31.6,198.6,378,25]
[{"$nulls":3},"напиток","Компот из шиповника",200,5,1.3,45.8,220.4,1052,12]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[{"$nulls":4},"Соус красный основной",50,1.3,2.93,5.6,66,759,5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F174)","v":790},{"$f":"SUM(G166:G174)","v":84.3},50.19,138.95,1257.8,null,{"$f":"SUM(L166:L174)","v":115}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Итого за день:",null,null,{"$f":"F165+F175","v":1440},{"$f":"G165+G175","v":132.7},{"$f":"H165+H175","v":72.09},{"$f":"I165+I175","v":248.75},{"$f":"J165+J175","v":1943.1},null,207.13]
[2,5,"Завтрак","гор.блюдо","Омлет натуральный",250,97,58.33,46.67,1085,215,60]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.6,0.9,43.9,182.1,294,2.01]
[{"$nulls":3},"хлеб","Бутерброд с колбасой",50,5.7,7.8,17,157,8,9.64]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F177:F183)","v":500},{"$f":"SUM(G177:G183)","v":103.3},67.03,107.57,1424.1,null,{"$f":"SUM(L177:L183)","v":71.65}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Щи из свежей капусты с картофелем",250,34.2,29.7,8.9,524.3,187,30]
[{"$nulls":3},"2 блюдо","Жаркое по-домашнему",200,36.6,22.3,16.5,438.6,642,70]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из сухофруктов",200,0.33,0.015,14.7,77.6,1052,12]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,4.3,1,25.4,142.8,null,3]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":700},{"$f":"SUM(G185:G193)","v":75.43},53.015,65.5,1183.3,null,{"$f":"SUM(L185:L193)","v":115}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Итого за день:",null,null,{"$f":"F184+F194","v":1200},{"$f":"G184+G194","v":178.73000000000002},{"$f":"H184+H194","v":120.045},{"$f":"I184+I194","v":173.07},{"$f":"J184+J194","v":2607.3999999999996},null,186.65]
[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":1394.5},{"$f":"(G24+G43+G62+G81+G100+G119+G138+G157+G176+G195)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G81=0,0,1)+IF(G100=0,0,1)+IF(G119=0,0,1)+IF(G138=0,0,1)+IF(G157=0,0,1)+IF(G176=0,0,1)+IF(G195=0,0,1))","v":129.95},88.8475,224.47500000000005,2097.9,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":195.27700000000004}]