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

{"sheet":"Лист1","index":0,"n_rows":193,"n_cols":12,"rows_kept":193,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[41,2,41,3],[60,2,60,3],[79,2,79,3],[98,2,98,3],[117,2,117,3],[135,2,135,3],[154,2,154,3],[173,2,173,3],[191,2,191,3],[192,2,192,4]]}
["Школа",null,"МБОУ \"Выделянская СОШ\"",null,null,"Утвердил:","должность","Директор "]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Безусова Е.Г."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша молочная жидкая манная, с сахаром и маслом",220,6.55,9.74,37.5,264.55,"181/2017м",28.72]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,3.8,2.9,11.3,86.5,"54-23гн/2022н",20]
[{"$nulls":3},"хлеб","хлеб пшеничный,кондитерские изделия ",80,6.01,4.38,39.34,221.9,"701/2010м, 399/2017м",41]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":500},{"$f":"SUM(G6:G12)","v":16.36},17.02,88.14,572.95,null,{"$f":"SUM(L6:L12)","v":89.72}]
[{"$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(F14:F22)","v":0},{"$f":"SUM(G14:G22)","v":0},0,0,0,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":500},{"$f":"G13+G23","v":16.36},17.02,88.14,572.95,null,{"$f":"L13+L23","v":89.72}]
[1,2,"Завтрак","гор.блюдо","Тефтели запеченные в соусе 90/20, макаронные изделия отварные с маслом",270,19.42,{"v":15.1,"d":"15.10"},44.41,391.16,"15м/2022н 203/2017м",72.72]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.2,0,10.38,42.42,"54-2гн/2022н",15]
[{"$nulls":3},"хлеб","Хлеб пшеничный ",40,2.1,3,14.49,70.14,"701/2010м",5]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F30)","v":510},22.5,{"v":18.1,"d":"18.10"},73.9,549.32,null,89.72]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},{"$f":"SUM(H32:H40)","v":0},{"$f":"SUM(I32:I40)","v":0},{"$f":"SUM(J32:J40)","v":0},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":510},23,{"$f":"H31+H41","v":18.1},74,{"$f":"J31+J41","v":549.32},null,89.72]
[1,3,"Завтрак","гор.блюдо","Каша молочная пшеничная, жидкая с маслом и сахаром",200,8.16,6.96,38.52,249.72,"182/2017м",31.72]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,3.6,3.6,12.6,100.4,"54-21гн/2022н",20]
[{"$nulls":3},"хлеб","Хлеб пшеничный",40,3.16,0.4,19.32,93.52,"701/2010м",10]
[{"$nulls":3},"фрукты","Фрукты по сезону ",100,0.4,0.4,9.8,47,"338/2017м",28]
[{"$nulls":3},"закуска"]
[]
[{"$nulls":3},"итого",null,540,{"$f":"SUM(G43:G49)","v":15.32},{"$f":"SUM(H43:H49)","v":11.360000000000001},{"$f":"SUM(I43:I49)","v":80.24},{"$f":"SUM(J43:J49)","v":490.64},null,89.72]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F51:F59)","v":0},{"$f":"SUM(G51:G59)","v":0},{"$f":"SUM(H51:H59)","v":0},{"$f":"SUM(I51:I59)","v":0},{"$f":"SUM(J51:J59)","v":0},null,0]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F50+F60","v":540},{"$f":"G50+G60","v":15.32},{"$f":"H50+H60","v":11.360000000000001},{"$f":"I50+I60","v":80.24},{"$f":"J50+J60","v":490.64},null,89.72]
[1,4,"Завтрак","гор.блюдо","Гречка по-купечески с мясом",200,13.2,17.87,37.5,363,"458/2002г",45.72]
[]
[{"$nulls":3},"гор.напиток","Чай каркаде",200,0.16,0.08,7.18,30.08,"54-45гн/2022н",20]
[{"$nulls":3},"хлеб","Хлеб пшеничный",40,3.16,0.4,19.32,93.52,"701/2010м ",10]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"закуска","Капуста квашенная с растительным маслом ",60,1.02,3,5.07,51.42,"47/2017м",14]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F68)","v":500},17.54,{"$f":"SUM(H62:H68)","v":21.349999999999998},{"$f":"SUM(I62:I68)","v":69.07},{"$f":"SUM(J62:J68)","v":538.02},null,89.72]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F70:F78)","v":0},{"$f":"SUM(G70:G78)","v":0},{"$f":"SUM(H70:H78)","v":0},{"$f":"SUM(I70:I78)","v":0},{"$f":"SUM(J70:J78)","v":0},null,0]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Итого за день:",null,null,500,{"$f":"G69+G79","v":17.54},{"$f":"H69+H79","v":21.349999999999998},{"$f":"I69+I79","v":69.07},{"$f":"J69+J79","v":538.02},null,89.72]
[1,5,"Завтрак","гор.блюдо","Плов из птицы",200,14.54,15.46,34.2,334.41,"291/2017м",48.72]
[]
[{"$nulls":3},"гор.напиток","Чай с лимоном",200,0.3,0,10.58,43.52,"54-3гн/2022н",18]
[{"$nulls":3},"хлеб","Хлеб пшеничный",40,3.16,0.4,19.32,93.52,"701/2010м ",10]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"закуска","Овощи по сезону в нарезке(огурец)",60,0.48,0.06,1.02,6,"70/2017м",13]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F81:F87)","v":500},{"$f":"SUM(G81:G87)","v":18.48},15.96,65.8,481.45,null,{"$f":"SUM(L81:L87)","v":89.72}]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F89:F97)","v":0},{"$f":"SUM(G89:G97)","v":0},{"$f":"SUM(H89:H97)","v":0},{"$f":"SUM(I89:I97)","v":0},{"$f":"SUM(J89:J97)","v":0},null,0]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,514,{"$f":"G88+G98","v":18.48},16,66,481,null,{"$f":"L88+L98","v":89.72}]
[2,1,"Завтрак","гор.блюдо","Каша \"Дружба\" молочная из риса и пшена",220,5.71,5.8,43.46,248.88,"54-16к/2022н",34]
[]
[{"$nulls":3},"гор.напиток","Чай с сахором ",200,3.8,2.9,11.3,86.5,"54-23гн/2022н",20]
[{"$nulls":3},"хлеб","Хлеб пшеничный,кондитерские изделия ",80,6.01,5.18,32.34,201.1,"701/2010м, 399/2017м",35.72]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F100:F106)","v":500},16.78,14.98,98.27,598.7,null,{"$f":"SUM(L100:L106)","v":89.72}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F108:F116)","v":0},{"$f":"SUM(G108:G116)","v":0},0,0,0,null,{"$f":"SUM(L108:L116)","v":0}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Итого за день:",null,null,{"$f":"F107+F117","v":500},17,15,98,599,null,{"$f":"L107+L117","v":89.72}]
[2,2,"Завтрак","гор.блюдо","Рыба(минтай)тушеная в томате с овощами,каша рисовая рассыпчатая",250,17.4,14,45.3,376.8,"229/2017м,171/2017м",61.72]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гор.напиток","Чай с лимоном 200/70",207,0.3,0,10.58,43.52,"54-3гн/2022н",18]
[{"$nulls":3},"хлеб","Хлеб пшеничный",45,2.1,0.3,14.49,70.14,"701/2010м ",10]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F119:F124)","v":502},20.58,17,74.99,536.06,null,{"$f":"SUM(L119:L124)","v":89.72}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F126:F134)","v":0},{"$f":"SUM(G126:G134)","v":0},0,0,0,null,{"$f":"SUM(L126:L134)","v":0}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Итого за день:",null,null,{"$f":"F125+F135","v":502},21,{"$f":"H125+H135","v":17},75,{"$f":"J125+J135","v":536.06},null,89.72]
[2,3,"Завтрак","гор.блюдо","Каша молочная овсяная жидкая,с маслом и сахаром.",230,7.09,10.65,40.09,285.33,"182/2017м",29.72]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,3.6,3.6,12.6,100.4,"54-21гн/2022н",20]
[{"$nulls":3},"хлеб","Хлеб пшеничный , печенье",70,3.56,0.8,29.12,140.52,"701/2010м п. т",40]
[]
[{"$nulls":3},"закуска"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F137:F143)","v":500},{"$f":"SUM(G137:G143)","v":14.25},15.05,81.81,526.25,null,{"$f":"SUM(L137:L143)","v":89.72}]
[{"$f":"A137","v":2},{"$f":"B137","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F145:F153)","v":0},{"$f":"SUM(G145:G153)","v":0},0,0,0,null,{"$f":"SUM(L145:L153)","v":0}]
[{"$f":"A137","v":2},{"$f":"B137","v":3},"Итого за день:",null,null,{"$f":"F144+F154","v":500},14,15,82,526,null,{"$f":"L144+L154","v":89.72}]
[2,4,"Завтрак","гор.блюдо","Котлеты рубленные из кур, каша рассыпчатая гречневая",240,16.34,16.45,44.29,390.37,"294/2017м,171/2017м",52.72]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гор.напиток","Чай каркаде",200,0.16,0.08,7.18,30.08,"54-45гн/2022н",20]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.1,0.3,14.49,70.14,"701/2010м",5]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"закуска","Закуска из овощей(икра кабачковая)",60,1.62,2.82,8.72,66.99,"101/2004л",12]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F156:F162)","v":530},21.71,21.93,90.29,649.25,null,{"$f":"SUM(L156:L162)","v":89.72}]
[{"$f":"A156","v":2},{"$f":"B156","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F164:F172)","v":0},{"$f":"SUM(G164:G172)","v":0},0,0,0,null,{"$f":"SUM(L164:L172)","v":0}]
[{"$f":"A156","v":2},{"$f":"B156","v":4},"Итого за день:",null,null,{"$f":"F163+F173","v":530},22,22,90,649,null,{"$f":"L163+L173","v":89.72}]
[2,5,"Завтрак","гор.блюдо","Тефтели запеченные в соусе 90/20,макаронные изделия отварные с маслом",260,19.42,15.1,44.41,391.16,"15м/2022н,203/2017м",61.72]
[]
[{"$nulls":3},"гор.напиток","Чай с лимоном",200,0.3,0,10.58,43.52,"54-3гн/2022н",18]
[{"$nulls":3},"хлеб","Хлеб пшеничный ",40,2.1,0.3,14.49,70.14,"701/2010м ",10]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F175:F180)","v":500},22.5,18.1,73.9,549.32,null,{"$f":"SUM(L175:L180)","v":89.72}]
[{"$f":"A175","v":2},{"$f":"B175","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F182:F190)","v":0},{"$f":"SUM(G182:G190)","v":0},0,0,0,null,{"$f":"SUM(L182:L190)","v":0}]
[{"$f":"A175","v":2},{"$f":"B175","v":5},"Итого за день:",null,null,{"$f":"F181+F191","v":500},{"$f":"G181+G191","v":22.5},{"$f":"H181+H191","v":18.1},{"$f":"I181+I191","v":73.9},{"$f":"J181+J191","v":549.32},null,89.72]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F42+F61+F80+F99+F118+F136+F155+F174+F192)/(IF(F24=0,0,1)+IF(F42=0,0,1)+IF(F61=0,0,1)+IF(F80=0,0,1)+IF(F99=0,0,1)+IF(F118=0,0,1)+IF(F136=0,0,1)+IF(F155=0,0,1)+IF(F174=0,0,1)+IF(F192=0,0,1))","v":509.6},{"$f":"(G24+G42+G61+G80+G99+G118+G136+G155+G174+G192)/(IF(G24=0,0,1)+IF(G42=0,0,1)+IF(G61=0,0,1)+IF(G80=0,0,1)+IF(G99=0,0,1)+IF(G118=0,0,1)+IF(G136=0,0,1)+IF(G155=0,0,1)+IF(G174=0,0,1)+IF(G192=0,0,1))","v":18.72},{"$f":"(H24+H42+H61+H80+H99+H118+H136+H155+H174+H192)/(IF(H24=0,0,1)+IF(H42=0,0,1)+IF(H61=0,0,1)+IF(H80=0,0,1)+IF(H99=0,0,1)+IF(H118=0,0,1)+IF(H136=0,0,1)+IF(H155=0,0,1)+IF(H174=0,0,1)+IF(H192=0,0,1))","v":17.092999999999996},{"$f":"(I24+I42+I61+I80+I99+I118+I136+I155+I174+I192)/(IF(I24=0,0,1)+IF(I42=0,0,1)+IF(I61=0,0,1)+IF(I80=0,0,1)+IF(I99=0,0,1)+IF(I118=0,0,1)+IF(I136=0,0,1)+IF(I155=0,0,1)+IF(I174=0,0,1)+IF(I192=0,0,1))","v":79.635},{"$f":"(J24+J42+J61+J80+J99+J118+J136+J155+J174+J192)/(IF(J24=0,0,1)+IF(J42=0,0,1)+IF(J61=0,0,1)+IF(J80=0,0,1)+IF(J99=0,0,1)+IF(J118=0,0,1)+IF(J136=0,0,1)+IF(J155=0,0,1)+IF(J174=0,0,1)+IF(J192=0,0,1))","v":549.131},null,{"$f":"(L24+L42+L61+L80+L99+L118+L136+L155+L174+L192)/(IF(L24=0,0,1)+IF(L42=0,0,1)+IF(L61=0,0,1)+IF(L80=0,0,1)+IF(L99=0,0,1)+IF(L118=0,0,1)+IF(L136=0,0,1)+IF(L155=0,0,1)+IF(L174=0,0,1)+IF(L192=0,0,1))","v":89.72000000000001}]