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

{"sheet":"Лист1","index":0,"n_rows":171,"n_cols":12,"rows_kept":171,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[20,2,20,3],[36,2,36,3],[53,2,53,3],[71,2,71,3],[88,2,88,3],[104,2,104,3],[120,2,120,3],[137,2,137,3],[153,2,153,3],[169,2,169,3],[170,2,170,4]]}
["Школа",null,"МБОУ СОШ №12 г Альметьевск",null,null,"Утвердил:","должность","И.О. директора"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Шаяхметова А.Н."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",29,8,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Сырники из творога с кашей молочной \"Дружба\" с маслом сливочным",215,10.55,11.85,39.4,324.45,null,74.77]
[{"$nulls":3},"гор.напиток","Кофейный напиток с молоком",200,3.2,2.7,6,60.7,379]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F9)","v":545},{"$f":"SUM(G6:G9)","v":16.13},{"$f":"SUM(H6:H9)","v":15.31},{"$f":"SUM(I6:I9)","v":67.08},{"$f":"SUM(J6:J9)","v":491.54999999999995},null,{"$f":"SUM(L6:L9)","v":74.77}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F11:F19)","v":0},{"$f":"SUM(G11:G19)","v":0},0,0,0,null,{"$f":"SUM(L11:L19)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F10+F20","v":545},{"$f":"G10+G20","v":16.13},15.31,67.08,491.54999999999995,null,{"$f":"L10+L20","v":74.77}]
[1,2,"Завтрак","гор.блюдо","Котлета из мяса птицы с макаронными изделиями отварными, с маслом сливочным",230,11.45,12.46,31.32,289.95,null,74.77]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов (75С)",200,0.66,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[{"$nulls":3},"закуска","Салат из моркови с яблоками",60,0.64,3.01,5.11,50.91]
[{"$nulls":3},"итого",null,{"$f":"SUM(F22:F25)","v":520},{"$f":"SUM(G22:G25)","v":14.73},{"$f":"SUM(H22:H25)","v":15.92},{"$f":"SUM(I22:I25)","v":70.34},{"$f":"SUM(J22:J25)","v":493.05999999999995},null,{"$f":"SUM(L22:L25)","v":74.77}]
[{"$f":"A22","v":1},{"$f":"B22","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F27:F35)","v":0},{"$f":"SUM(G27:G35)","v":0},{"$f":"SUM(H27:H35)","v":0},{"$f":"SUM(I27:I35)","v":0},{"$f":"SUM(J27:J35)","v":0},null,0]
[{"$f":"A22","v":1},{"$f":"B22","v":2},"Итого за день:",null,null,{"$f":"F26+F36","v":520},{"$f":"G26+G36","v":14.73},{"$f":"H26+H36","v":15.92},{"$f":"I26+I36","v":70.34},{"$f":"J26+J36","v":493.05999999999995},null,74.77]
[1,3,"Завтрак","гор.блюдо","Гуляш из говядины",100,10.39,14.79,10.3,221,260,74.77]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая",150,3.77,2.29,39.72,214,171]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с лимоном",200,0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб","Хлеб ржаной",50,3.3,0.6,19.8,99]
[{"$nulls":3},"кисломол.","Сыр порционно",10,2.63,2.66,0,34.33,15]
[{"$nulls":3},"итого",null,{"$f":"SUM(F38:F42)","v":510},{"$f":"SUM(G38:G42)","v":20.2},{"$f":"SUM(H38:H42)","v":20.36},{"$f":"SUM(I38:I42)","v":79.97},{"$f":"SUM(J38:J42)","v":609.65},null,{"$f":"SUM(L38:L42)","v":74.77}]
[{"$f":"A38","v":1},{"$f":"B38","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F52)","v":0},{"$f":"SUM(G44:G52)","v":0},{"$f":"SUM(H44:H52)","v":0},{"$f":"SUM(I44:I52)","v":0},{"$f":"SUM(J44:J52)","v":0},null,0]
[{"$f":"A38","v":1},{"$f":"B38","v":3},"Итого за день:",null,null,{"$f":"F43+F53","v":510},{"$f":"G43+G53","v":20.2},{"$f":"H43+H53","v":20.36},{"$f":"I43+I53","v":79.97},{"$f":"J43+J53","v":609.65},null,74.77]
[1,4,"Завтрак","гор.блюдо","Птица запеченная",100,10.42,12.43,8.65,192,null,74.77]
[{"$nulls":3},"гор.блюдо","Пюре картофельное с маслом сливочным",153,3.08,6.25,20.47,150.45,312]
[{"$nulls":3},"гор.напиток","Напиток из свежих фруктов (75С)",200,0.34,0.17,21.46,103.5]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"закуска","Свекла отварная дольками",60,1.08,0.06,5.88,28.8]
[{"$nulls":3},"итого",null,{"$f":"SUM(F55:F60)","v":573},{"$f":"SUM(G55:G60)","v":19.18},{"$f":"SUM(H55:H60)","v":19.509999999999998},{"$f":"SUM(I55:I60)","v":83.1},{"$f":"SUM(J55:J60)","v":604.6499999999999},null,{"$f":"SUM(L55:L58)","v":74.77}]
[{"$f":"A55","v":1},{"$f":"B55","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F70)","v":0},{"$f":"SUM(G62:G70)","v":0},{"$f":"SUM(H62:H70)","v":0},{"$f":"SUM(I62:I70)","v":0},{"$f":"SUM(J62:J70)","v":0},null,0]
[{"$f":"A55","v":1},{"$f":"B55","v":4},"Итого за день:",null,null,{"$f":"F61+F71","v":573},{"$f":"G61+G71","v":19.18},{"$f":"H61+H71","v":19.509999999999998},{"$f":"I61+I71","v":83.1},{"$f":"J61+J71","v":604.6499999999999},null,74.77]
[1,5,"Завтрак","гор.блюдо","Тефтели мясные в сметанно-томатном соусе",100,7.08,11.94,8.36,144,"279, 339",74.77]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные с маслом сливочным",185,5.1,3.62,31.96,176.1,203]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов (75С)",200,0.66,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",45,3.42,0.36,22.14,105.75]
[{"$nulls":3},"кисломол.","Сыр порционно",15,3.95,3.99,0,51.5,15]
[{"$nulls":3},"итого",null,{"$f":"SUM(F73:F77)","v":545},{"$f":"SUM(G73:G77)","v":20.209999999999997},{"$f":"SUM(H73:H77)","v":20},{"$f":"SUM(I73:I77)","v":84.49000000000001},{"$f":"SUM(J73:J77)","v":570.1500000000001},null,{"$f":"SUM(L73:L77)","v":74.77}]
[{"$f":"A73","v":1},{"$f":"B73","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F79:F87)","v":0},{"$f":"SUM(G79:G87)","v":0},{"$f":"SUM(H79:H87)","v":0},{"$f":"SUM(I79:I87)","v":0},{"$f":"SUM(J79:J87)","v":0},null,0]
[{"$f":"A73","v":1},{"$f":"B73","v":5},"Итого за день:",null,null,{"$f":"F78+F88","v":545},{"$f":"G78+G88","v":20.209999999999997},{"$f":"H78+H88","v":20},{"$f":"I78+I88","v":84.49000000000001},{"$f":"J78+J88","v":570.1500000000001},null,74.77]
[2,1,"Завтрак","гор.блюдо","Сырники из творога с кашей пшенной молочной с маслом сливочным",245,16.02,18.13,42.98,386.4,null,74.77]
[{"$nulls":3},"гор.напиток","Чай \"Витаминный\" с шиповником",200,0.24,0.09,12.43,54.2,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F93)","v":500},{"$f":"SUM(G90:G93)","v":20.139999999999997},{"$f":"SUM(H90:H93)","v":18.779999999999998},{"$f":"SUM(I90:I93)","v":79.58999999999999},{"$f":"SUM(J90:J93)","v":558.75},null,{"$f":"SUM(L90:L93)","v":74.77}]
[{"$f":"A90","v":2},{"$f":"B90","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F95:F103)","v":0},{"$f":"SUM(G95:G103)","v":0},0,0,0,null,{"$f":"SUM(L95:L103)","v":0}]
[{"$f":"A90","v":2},{"$f":"B90","v":1},"Итого за день:",null,null,{"$f":"F94+F104","v":500},{"$f":"G94+G104","v":20.139999999999997},{"$f":"H94+H104","v":18.779999999999998},{"$f":"I94+I104","v":79.58999999999999},{"$f":"J94+J104","v":558.75},null,74.77]
[2,2,"Завтрак","гор.блюдо","Овощи тушеные с мясом",200,12.48,15.68,19.34,271.5,"143, 241",74.77]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов (75С)",200,0.66,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (апельсины)",180,1.62,0.36,14.58,77.4]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F109)","v":600},{"$f":"SUM(G106:G109)","v":16.080000000000002},{"$f":"SUM(H106:H109)","v":16.369999999999997},{"$f":"SUM(I106:I109)","v":63.870000000000005},{"$f":"SUM(J106:J109)","v":481.30000000000007},null,{"$f":"SUM(L106:L109)","v":74.77}]
[{"$f":"A106","v":2},{"$f":"B106","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F111:F119)","v":0},{"$f":"SUM(G111:G119)","v":0},0,0,0,null,{"$f":"SUM(L111:L119)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":2},"Итого за день:",null,null,{"$f":"F110+F120","v":600},{"$f":"G110+G120","v":16.080000000000002},{"$f":"H110+H120","v":16.369999999999997},{"$f":"I110+I120","v":63.870000000000005},{"$f":"J110+J120","v":481.30000000000007},null,74.77]
[2,3,"Завтрак","гор.блюдо","Плов из говядины с рисовой крупой",200,15.95,19.55,39.75,408.42,265,74.77]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.07,0.02,10.01,40,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F126)","v":545},{"$f":"SUM(G122:G126)","v":19.639999999999997},{"$f":"SUM(H122:H126)","v":20.409999999999997},{"$f":"SUM(I122:I126)","v":79.78},{"$f":"SUM(J122:J126)","v":593.7700000000001},null,{"$f":"SUM(L122:L126)","v":74.77}]
[{"$f":"A122","v":2},{"$f":"B122","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":0},{"$f":"SUM(G128:G136)","v":0},0,0,0,null,{"$f":"SUM(L128:L136)","v":0}]
[{"$f":"A122","v":2},{"$f":"B122","v":3},"Итого за день:",null,null,{"$f":"F127+F137","v":545},{"$f":"G127+G137","v":19.639999999999997},{"$f":"H127+H137","v":20.409999999999997},{"$f":"I127+I137","v":79.78},{"$f":"J127+J137","v":593.7700000000001},null,74.77]
[2,4,"Завтрак","гор.блюдо","Котлета из мяса птицы с макаронными изделиями отварными, с маслом сливочным",230,11.45,12.46,31.32,289.95,null,74.77]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,1.58,3.54,7.6,78.6,382]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"закуска","Салат из моркови",60,0.74,0.06,9.98,49.02]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F142)","v":520},{"$f":"SUM(G139:G142)","v":16.049999999999997},{"$f":"SUM(H139:H142)","v":16.299999999999997},{"$f":"SUM(I139:I142)","v":63.66},{"$f":"SUM(J139:J142)","v":488.06999999999994},null,{"$f":"SUM(L139:L142)","v":74.77}]
[{"$f":"A139","v":2},{"$f":"B139","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F152)","v":0},{"$f":"SUM(G144:G152)","v":0},0,0,0,null,{"$f":"SUM(L144:L152)","v":0}]
[{"$f":"A139","v":2},{"$f":"B139","v":4},"Итого за день:",null,null,{"$f":"F143+F153","v":520},{"$f":"G143+G153","v":16.049999999999997},{"$f":"H143+H153","v":16.299999999999997},{"$f":"I143+I153","v":63.66},{"$f":"J143+J153","v":488.06999999999994},null,74.77]
[2,5,"Завтрак","гор.блюдо","Биточки рыбные с картофельным пюре, с маслом сливочным",228,12.24,12.49,31.49,290.55,null,74.77]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок (75С)",200,0.16,0.16,17.9,74.6,342]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"закуска","Салат из отварной свеклы",60,0.84,3.61,4.96,55.68,52]
[{"$nulls":3},"итого",null,{"$f":"SUM(F155:F158)","v":518},{"$f":"SUM(G155:G158)","v":15.52},{"$f":"SUM(H155:H158)","v":16.5},{"$f":"SUM(I155:I158)","v":69.11},{"$f":"SUM(J155:J158)","v":491.33},null,{"$f":"SUM(L155:L158)","v":74.77}]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F160:F168)","v":0},{"$f":"SUM(G160:G168)","v":0},0,0,0,null,{"$f":"SUM(L160:L168)","v":0}]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Итого за день:",null,null,{"$f":"F159+F169","v":518},{"$f":"G159+G169","v":15.52},16.5,69.11,491.33,null,{"$f":"L159+L169","v":74.77}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F21+F37+F54+F72+F89+#REF!+F105+F121+F138+F154+F170+#REF!)/(IF(F21=0,0,1)+IF(F37=0,0,1)+IF(F54=0,0,1)+IF(F72=0,0,1)+IF(F89=0,0,1)+IF(#REF!=0,0,1)+IF(F105=0,0,1)+IF(F121=0,0,1)+IF(F138=0,0,1)+IF(F154=0,0,1)+IF(F170=0,0,1)+IF(#REF!=0,0,1))","v":{"$error":"#REF!"}},{"$f":"(G21+G37+G54+G72+G89+#REF!+G105+G121+G138+G154+G170+#REF!)/(IF(G21=0,0,1)+IF(G37=0,0,1)+IF(G54=0,0,1)+IF(G72=0,0,1)+IF(G89=0,0,1)+IF(#REF!=0,0,1)+IF(G105=0,0,1)+IF(G121=0,0,1)+IF(G138=0,0,1)+IF(G154=0,0,1)+IF(G170=0,0,1)+IF(#REF!=0,0,1))","v":{"$error":"#REF!"}},{"$f":"(H21+H37+H54+H72+H89+#REF!+H105+H121+H138+H154+H170+#REF!)/(IF(H21=0,0,1)+IF(H37=0,0,1)+IF(H54=0,0,1)+IF(H72=0,0,1)+IF(H89=0,0,1)+IF(#REF!=0,0,1)+IF(H105=0,0,1)+IF(H121=0,0,1)+IF(H138=0,0,1)+IF(H154=0,0,1)+IF(H170=0,0,1)+IF(#REF!=0,0,1))","v":{"$error":"#REF!"}},{"$f":"(I21+I37+I54+I72+I89+#REF!+I105+I121+I138+I154+I170+#REF!)/(IF(I21=0,0,1)+IF(I37=0,0,1)+IF(I54=0,0,1)+IF(I72=0,0,1)+IF(I89=0,0,1)+IF(#REF!=0,0,1)+IF(I105=0,0,1)+IF(I121=0,0,1)+IF(I138=0,0,1)+IF(I154=0,0,1)+IF(I170=0,0,1)+IF(#REF!=0,0,1))","v":{"$error":"#REF!"}},{"$f":"(J21+J37+J54+J72+J89+#REF!+J105+J121+J138+J154+J170+#REF!)/(IF(J21=0,0,1)+IF(J37=0,0,1)+IF(J54=0,0,1)+IF(J72=0,0,1)+IF(J89=0,0,1)+IF(#REF!=0,0,1)+IF(J105=0,0,1)+IF(J121=0,0,1)+IF(J138=0,0,1)+IF(J154=0,0,1)+IF(J170=0,0,1)+IF(#REF!=0,0,1))","v":{"$error":"#REF!"}},null,{"$f":"(L21+L37+L54+L72+L89+#REF!+L105+L121+L138+L154+L170+#REF!)/(IF(L21=0,0,1)+IF(L37=0,0,1)+IF(L54=0,0,1)+IF(L72=0,0,1)+IF(L89=0,0,1)+IF(#REF!=0,0,1)+IF(L105=0,0,1)+IF(L121=0,0,1)+IF(L138=0,0,1)+IF(L154=0,0,1)+IF(L170=0,0,1)+IF(#REF!=0,0,1))","v":{"$error":"#REF!"}}]