{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["11-18 лет"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"11-18 лет","index":0,"n_rows":270,"n_cols":21,"rows_kept":270,"merged":[[0,0,0,1],[0,14,0,20],[1,0,1,6],[1,14,1,20],[2,0,2,6],[2,14,2,20],[5,0,5,20],[7,0,7,20],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,8,5],[8,6,9,6],[8,7,8,11],[8,12,8,20],[29,0,29,20],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,30,5],[30,6,31,6],[30,7,30,11],[30,12,30,20],[51,0,51,20],[52,0,53,0],[52,1,53,1],[52,2,53,2],[52,3,52,5],[52,6,53,6],[52,7,52,11],[52,12,52,20],[74,0,74,20],[75,0,76,0],[75,1,76,1],[75,2,76,2],[75,3,75,5],[75,6,76,6],[75,7,75,11],[75,12,75,20],[96,0,96,20],[97,0,98,0],[97,1,98,1],[97,2,98,2],[97,3,97,5],[97,6,98,6],[97,7,97,11],[97,12,97,20],[118,0,118,20],[119,0,120,0],[119,1,120,1],[119,2,120,2],[119,3,119,5],[119,6,120,6],[119,7,119,11],[119,12,119,20],[134,0,134,20],[135,0,136,0],[135,1,136,1],[135,2,136,2],[135,3,135,5],[135,6,136,6],[135,7,135,11],[135,12,135,20],[155,0,155,20],[156,0,157,0],[156,1,157,1],[156,2,157,2],[156,3,156,5],[156,6,157,6],[156,7,156,11],[156,12,156,20],[177,0,177,20],[178,0,179,0],[178,1,179,1],[178,2,179,2],[178,3,178,5],[178,6,179,6],[178,7,178,11],[178,12,178,20],[199,0,199,20],[200,0,201,0],[200,1,201,1],[200,2,201,2],[200,3,200,5],[200,6,201,6],[200,7,200,11],[200,12,200,20],[221,0,221,20],[222,0,223,0],[222,1,223,1],[222,2,223,2],[222,3,222,5],[222,6,223,6],[222,7,222,11],[222,12,222,20],[244,0,244,20],[245,0,246,0],[245,1,246,1],[245,2,246,2],[245,3,245,5],[245,6,246,6],[245,7,245,11],[245,12,245,20],[260,3,260,14],[261,0,261,18],[262,1,264,1],[262,2,262,4],[262,5,263,5],[262,6,262,10],[262,11,262,19],[269,1,269,9]]}
["СОГЛАСОВАНО",{"$nulls":13},"УТВЕРЖДЕНО"]
[]
[]
[]
[]
["Меню  для организации 2-х разового питания детей возрасте от 11 до 18 лет в образовательных учреждениях Мензелинского района РТ  на 1 полугодие 2025-2026 учебный год. "]
[]
["1 день, 1 неделя"]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Понедельник, 1 неделя"]
[null,"Завтрак","11-18"]
["54-13з","Салат из свеклы отварной с растительным маслом",100,1.34,4.48,7.61,76.1,0.01,0.03,1.14,0,4,131,227,32,18,36,1.2,19.98,0.6,19]
["54-11г-2020","Картофельное пюре",180,3.69,6.37,23.79,167.3,0.14,0.12,28.55,0.11,12,195,750,47,34,101,1.2,34.15,1,51.35]
["№ Т/К 272","Котлета рубленная из говядины с соусом","65/35",9.3,7.1,11.8,148.6,0,0,0,0,1.4,0,0,16,19.2,97,1.7,0,0,0]
["54-2гн-2020","Чай с сахаром",200,0.2,0,6.4,26.8,0,0.01,0.3,0,0.04,0.68,20.76,66.08,3.83,7.18,0.73,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",620,{"$f":"SUM(D14:D19)","v":17.35},{"$f":"SUM(E14:E19)","v":18.310000000000002},66.14,499.9,0.21000000000000002,0.19,29.990000000000002,0.11,17.439999999999998,548.6800000000001,1065.76,172.07999999999998,87.43,285.78000000000003,5.8100000000000005,54.769999999999996,8.98,73.25]
[null,"Обед","11-18"]
["54-7з-2020","Салат из белокочанной капусты с растительным маслом",60,1.5,6.1,6.2,85.8,0.03,0.04,122.25,0,34.78,88.69,247.73,40.39,15.18,30.31,0.55,10.73,0.26,12.66]
["№ Т/к 100","Суп картофельный с вермишелью",250,10,7.35,30.2,214.4,0.1,0,0.2,0,6.6,0,0,23.9,23.4,57.7,1.1,0,0,0]
["т/к №410","Треугольник П/Ф ",70,5.7,5,29.8,221.7,0.1,0,0,0,1.5,0,0,26.8,25.7,100.5,1.5,0,0,0]
["54-4гн-2020","Чай с молоком и сахаром",200,1.6,1.1,8.6,50.9,0.01,0.07,6.9,0,0.3,19.68,81.35,103.48,9.92,46.33,0.78,4.5,0.88,10]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за обед",{"$f":"SUM(C22:C26)","v":600},20.1,19.75,81.5,607,0.28,0.13,129.35,0,43.18,230.37,378.08,201.57,83.60000000000001,266.44,4.710000000000001,15.23,7.32,22.66]
[null,"Итого за день",{"$f":"C27+C20","v":1220},37.45,38.06,147.64,1106.9,0.49000000000000005,0.32,159.34,0.11,60.62,779.0500000000001,1443.84,373.65,171.03000000000003,552.22,10.520000000000001,70,16.3,95.91]
[]
["2 день, 1 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Вторник, 1 неделя"]
[null,"Завтрак","11-18"]
["Пром.","Кондитерское изделие (простая сушка, пряник, печенье, вафли)",30,1.42,0.17,8.94,43,0.03,0.01,0,0,0,79,24,4,6,16,0.4,0,0,0]
["№ Т/к 67","Щи из свежей капусты с картофелем",250,1.9,5.1,9.3,90.5,0,0,0.2,0,12.4,0,0,41.5,22,42.7,1.1,0,0,0]
["№ Т/к 438","Напиток яблочный",200,0.1,0.1,13.9,57.8,0,0,0,0,1,0,0,12.3,3.7,2.4,0.5,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",{"$f":"SUM(C36:C40)","v":520},{"$f":"SUM(D36:D40)","v":6.239999999999999},{"$f":"SUM(E36:E40)","v":5.7299999999999995},48.68000000000001,272.40000000000003,0.09,0.04,0.2,0,13.4,301,92,68.8,44.1,105.69999999999999,2.9800000000000004,0.64,7.38,2.9]
[null,"Обед","11-18"]
["№Т/К 41","Салат из моркови с сахаром и растительным маслом",60,0.5,6.1,4.3,74.3,0.03,0.03,732.9,0,3.63,89.79,123.26,13.5,15.57,22.38,0.66,10.19,0.09,21.57]
["54-4г-2020","Каша гречневая рассыпчатая",180,9.87,7.61,43.12,280.5,0.26,0.14,23.02,0.11,0,180,263,57,144,217,4.8,26.73,4.3,19.27]
["№Т/К 272","Котлета мясная с соусом ","65/35",11.28,7.37,12.4,179.2,0,0,0.1,0,1.8,0,0,18.9,22.1,115.5,1.9,0,0,0]
["54-1хн-2020","Компот из смеси сухофруктов",200,0.47,0,14.78,65,0,0,15,0,0,0,0,108,2,4,0.1,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за обед",{"$f":"SUM(C43:C48)","v":480},24.939999999999998,21.44,91.14,680.1,0.35000000000000003,0.2,771.02,0.11,5.43,491.79,454.26,208.4,196.07,403.48,8.44,37.56,11.77,43.74]
[null,"Итого за день",{"$f":"C49+C41","v":1000},31.179999999999996,27.17,139.82,952.5,0.44000000000000006,0.24000000000000002,771.22,0.11,18.83,792.79,546.26,277.2,240.17,509.18,11.42,38.2,19.15,46.64]
[]
["3 день, 1 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Среда, 1 неделя"]
[null,"Завтрак","11-18"]
["№ Т/К 40","Салат картофельный с морковью и растительным маслом",100,2.4,7.2,8.9,110.4,0.1,0,0.6,0,5.6,0,0,25,21.9,55.7,1,0,0,0]
["№ Т/К 62","Борщ",250,2.7,5.9,15.3,126.6,0.1,0,0.3,0,11.4,0,0,49.9,32.1,65.6,1.7,0,0,0]
["54-2гн-2020","Чай -заварка",200,0.2,0,6.4,26.8,0,0.01,0.3,0,0.04,0.68,20.76,66.08,3.83,7.18,0.73,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Булочка ванильная",60,4.68,4.03,30.46,177,0.05,0.02,19.12,0.15,0,241,50,18,6,41,0.5,33.36,3.1,11.03]
[null,"Итого за завтрак",{"$f":"SUM(C58:C62)","v":630},{"$f":"SUM(D58:D62)","v":11.28},{"$f":"SUM(E58:E62)","v":17.330000000000002},67.76,475,0.29000000000000004,0.05,20.32,0.15,17.04,363.68,119.76,165.98000000000002,73.23,201.07999999999998,4.71,33.36,9.28,11.03]
[null,"Обед","11-18"]
["54-16з-2020","Винегрет с растительным маслом",60,0.7,5.4,4,67.1,0.02,0.02,72.89,0,2.26,200.99,127.85,12.1,9.66,21.4,0.41,7.86,0.13,11.85]
["54-1г-2020","Макароны отварные",180,6.39,5.91,39.36,236.2,0.07,0.03,22.03,0.11,0,179,64,127,9,48,0.9,24.92,0.1,14.31]
["Т/к №290","Птица тушеная","80/30",8.65,7.83,3.9,145,0.1,0,0,0,1.5,0,0,26.4,16.6,115.3,0.9,0,0,0]
["54-3гн-2020","Чай с лимоном и сахаром","200/7/7",0.2,0.1,6.6,27.9,0,0.01,0.38,0,1.16,1.26,30.23,67,4.56,8.52,0.77,0.01,0.02,0.7]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Фрукт (яблоко, банан, апельсин)",100,0.6,0.6,14.7,66.6,0.04,0.03,7.5,0,15,39,417,24,14,17,3.3,3,0.4,12]
[null,"Итого за обед",704,{"$f":"SUM(D65:D71)","v":19.36},{"$f":"SUM(E65:E71)","v":20.200000000000003},85.10000000000001,623.9,0.29,0.12,102.8,0.11,19.92,642.25,707.0799999999999,267.5,66.22,254.82,7.26,36.43,8.03,41.76]
[null,"Итого за день",{"$f":"C72+C63","v":1334},{"$f":"D72+D63","v":30.64},{"$f":"E72+E63","v":37.53},152.86,1098.9,0.5800000000000001,0.16999999999999998,123.12,0.26,36.96,1005.9300000000001,826.8399999999999,433.48,139.45,455.9,11.969999999999999,69.78999999999999,17.31,52.79]
[]
["4 день, 1 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Четверг, 1 неделя"]
[null,"Завтрак","11-18"]
["№ Т/К 50","Салат свеколка с маслом растительным",100,1.8,10.1,16.2,163.2,0,0,0.1,0,3.5,0,0,45.5,27.5,52.8,1.5,0,0,0]
["№ Т/к ","Суп рисовый",250,2.4,2,19.7,105.4,0.1,0,0.2,0,5.8,0,0,21.9,25.4,58.9,0.8,0,0,0]
["54-2гн-2020","Чай с сахаром",200,0.2,0,6.4,26.8,0,0.01,0.3,0,0.04,0.68,20.76,66.08,3.83,7.18,0.73,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",{"$f":"SUM(C81:C85)","v":590},7.22,12.459999999999999,58.84,376.5,0.16,0.04,0.6000000000000001,0,9.34,222.68,88.76,144.48000000000002,69.13,163.48,4.01,0.64,7.38,2.9]
[null,"Обед","11-18"]
["54-9з-2020","Салат из белокочанной капусты с морковью, яблоками и растительным маслом",60,0.8,6.1,3.6,72.5,0.02,0.02,241.63,0,17.32,87.51,160.14,23.5,11.17,18.8,0.56,9.87,0.15,10.98]
["54-11г-2020","Картофельное пюре",180,3.69,6.37,23.79,167.3,0.14,0.12,28.55,0.11,12,195,750,47,34,101,1.2,34.15,1,51.35]
["т/к №296","\"Ёжики\" мясные 2 шт",100,10.8,7.3,22.5,240.1,0,0,0,0,1.6,0,0,26.8,23.9,129.9,1.8,0,0,0]
["Т/к №430","Чай с сахаром и яблоком","200/7/10",0.2,0,8.2,34.1,0,0,0,0,0.4,0,0,14.1,6.5,8.4,0.9,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
[null,"Итого за обед",597,{"$f":"SUM(D88:D93)","v":18.31},{"$f":"SUM(E88:E93)","v":20.13},74.63000000000001,595.1,0.22,0.16999999999999998,270.18,0.11,31.32,504.51,978.14,122.39999999999999,87.97,302.7,5.44,44.66,8.53,65.23]
[null,"Итого за день",{"$f":"C94+C86","v":1187},25.529999999999998,32.589999999999996,133.47000000000003,971.6,0.38,0.21,270.78000000000003,0.11,40.66,727.19,1066.9,266.88,157.1,466.17999999999995,9.45,45.3,15.91,68.13000000000001]
[]
["5 день, 1 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Пятница, 1 неделя"]
[null,"Завтрак","11-18"]
["54-6о","Яйцо вареное (1 шт)",40,3.28,2.05,0.25,56.6,0.02,0.14,62.4,0.88,0,41,46,19,4,67,0.9,8,10.8,22]
["№ Т/к №110","Бульон с лапшой домашней",250,7.4,2.3,37.2,200.5,0.1,0,0.1,0,0.2,0,0,33.6,13.2,72.6,0.9,0,0,0]
["54-21гн-2020","Какао с молоком",200,4.7,3.5,12.5,100.4,0.04,0.16,17.25,0,0.68,49.95,220.33,167.68,34.32,130.28,1.09,11.7,2.29,38.25]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",{"$f":"SUM(C103:C107)","v":530},{"$f":"SUM(D103:D107)","v":18.2},{"$f":"SUM(E103:E107)","v":8.209999999999999},66.49000000000001,438.59999999999997,0.22,0.33000000000000007,79.75,0.88,0.8800000000000001,312.95,334.33000000000004,231.28,63.919999999999995,314.48,3.87,20.34,20.47,63.15]
[null,"Обед","11-18"]
["54-11з-2020","Салат из моркови с яблоками с растительным маслом",60,0.5,6.1,4.3,74.3,0.03,0.03,732.9,0,3.63,89.79,123.26,13.5,15.57,22.38,0.66,10.19,0.09,21.57]
["54-12м-2020","Плов с курицей","170/50",20.34,8.18,36.38,300.4,0.08,0.07,159.36,0,2,301,316,80,87,193,1.7,41.15,21.6,129.9]
["54-1хн-2020","Компот из смеси сухофруктов",200,0.47,0,14.78,65,0,0,15,0,0,0,0,108,2,4,0.1,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Булочка ванильная",60,4.68,4.03,30.46,177,0.05,0.02,19.12,0.15,0,241,50,18,6,41,0.5,33.36,3.1,11.03]
[null,"Итого за обед",560,{"$f":"SUM(D110:D114)","v":27.29},{"$f":"SUM(E110:E114)","v":18.509999999999998},92.62,650.9,0.2,0.14,926.38,0.15,5.63,753.79,538.26,226.5,119.97,291.98,3.74,84.69999999999999,30.970000000000002,162.5]
[null,"Итого за день",{"$f":"C115+C108","v":1090},{"$f":"D115+D108","v":45.489999999999995},26.72,159.11,1089.5,0.42000000000000004,0.4700000000000001,1006.13,1.03,6.51,1066.74,872.59,457.78,183.89,606.46,7.61,105.03999999999999,51.44,225.65]
[]
[]
["6 день, 1 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Пятница, 1 неделя"]
[null,"Горячий завтрак","11-18"]
["54-16з-2020","Винегрет с растительным маслом",60,0.7,5.4,4,67.1,0.02,0.02,72.89,0,2.26,200.99,127.85,12.1,9.66,21.4,0.41,7.86,0.13,11.85]
["54-3г","Макароны отварные с сыром",200,10.55,9.1,38.21,277,0.08,0.07,44.88,0.26,0,321,77,208,14,133,1,27.56,2.6,13.82]
["54-21гн-2020","Кофейный напиток с молоком",200,3.9,2.9,11.2,86,0.03,0.13,13.29,0,0.52,38.55,183.98,148.32,30.67,106.79,1.06,9,1.76,20]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Сушка простая",10,1.09,0.13,6.88,33.1,0.02,0.01,0,0,0,46,15,3,4,11,0.3,0,0,0]
[null,"Итого за Завтрак",{"$f":"SUM(C125:C130)","v":510},{"$f":"SUM(D125:D130)","v":19.06},17.889999999999997,76.83,544.3,0.21,0.26,131.06,0.26,2.78,828.54,471.83,382.41999999999996,70.72999999999999,316.79,3.75,45.06,11.87,48.57]
[null,"Итого за день",{"$f":"C131","v":510},{"$f":"D131","v":19.06},{"$f":"E131","v":17.889999999999997},76.83,544.3,0.21,0.26,131.06,0.26,2.78,828.54,471.83,382.41999999999996,70.72999999999999,316.79,3.75,45.06,11.87,48.57]
[]
[]
["7 день, 2 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Понедельник, 2 неделя"]
[null,"Завтрак","11-18"]
["№ Т/К 40","Салат картофельный с морковью и растительным маслом",100,2.4,7.2,8.9,110.4,0.1,0,0.6,0,5.6,0,0,25,21.9,55.7,1,0,0,0]
["№ т/к 207","Макаронник","220/7",10.9,12.2,36.2,290.6,0.2,0,0.1,0,0,0,0,30.8,16,88.5,1.8,0,0,0]
["54-2гн-2020","Чай -заварка",200,0.2,0,6.4,26.8,0,0.01,0.3,0,0.04,0.68,20.76,66.08,3.83,7.18,0.73,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",567,{"$f":"SUM(D141:D145)","v":16.32},{"$f":"SUM(E141:E145)","v":19.759999999999998},68.04,508.9,0.36000000000000004,0.04,1,0,5.64,222.68,88.76,132.88,54.129999999999995,195.98,4.51,0.64,7.38,2.9]
[null,"Обед","11-18"]
["№Т/К 41","Салат из моркови с сахаром и растительным маслом",60,0.5,6.1,4.3,74.3,0.03,0.03,732.9,0,3.63,89.79,123.26,13.5,15.57,22.38,0.66,10.19,0.09,21.57]
[62,"Борщ",250,13.1,7.3,20.1,180,0.1,0,0.3,0,12,0,0,55,33.4,72.4,1.6,0,0,0]
["Т/к №430","Чай с сахаром и яблоком","200/7/10",0.2,0,8.2,34.1,0,0,0,0,0.4,0,0,14.1,6.5,8.4,0.9,0,0,0]
["Пром.","Булочка ванильная",60,4.68,4.03,30.46,177,0.05,0.02,19.12,0.15,0,241,50,18,6,41,0.5,33.36,3.1,11.03]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за обед",607,{"$f":"SUM(D148:D152)","v":19.779999999999998},17.63,69.76,499.6,0.22,0.07,752.3199999999999,0.15,16.029999999999998,452.79,222.26,107.6,70.87,175.78,4.44,43.55,9.37,32.6]
[null,"Итого за день",{"$f":"C153+C146","v":1174},{"$f":"D153+D146","v":36.099999999999994},37.39,137.8,1008.5,0.5800000000000001,0.11000000000000001,753.3199999999999,0.15,21.669999999999998,675.47,311.02,240.48,125,371.76,8.95,44.19,16.75,35.5]
[]
["8 день, 2 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Вторник, 2 неделя"]
[null,"Завтрак","11-18"]
["№ т/к 15","Салат из отварной моркови (порциями)",100,1.3,0.1,6.9,35,0.1,0,2.5,0,5,0,0,51,38,55,1,0,0,0]
["№ Т/к №110","Бульон с лапшой домашней",250,7.4,2.3,37.2,200.5,0.1,0,0.1,0,0.2,0,0,33.6,13.2,72.6,0.9,0,0,0]
["№ Т/к 438","Напиток яблочный",200,0.1,0.1,13.9,57.8,0,0,0,0,1,0,0,12.3,3.7,2.4,0.5,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",{"$f":"SUM(C162:C166)","v":590},{"$f":"SUM(D162:D166)","v":11.620000000000001},{"$f":"SUM(E162:E166)","v":2.8600000000000003},74.54,374.4,0.26,0.03,2.6,0,6.2,222,68,107.89999999999999,67.30000000000001,174.6,3.38,0.64,7.38,2.9]
[null,"Обед","11-18"]
["54-9з-2020","Салат из белокочанной капусты с морковью, яблоками и растительным маслом",60,0.8,6.1,3.6,72.5,0.02,0.02,241.63,0,17.32,87.51,160.14,23.5,11.17,18.8,0.56,9.87,0.15,10.98]
["54-12м-2020","Плов с курицей","170/50",20.34,8.18,36.38,300.4,0.08,0.07,159.36,0,2,301,316,80,87,193,1.7,41.15,21.6,129.9]
["54-3гн-2020","Чай с лимоном и сахаром","200/7/7",0.2,0.1,6.6,27.9,0,0.01,0.38,0,1.16,1.26,30.23,67,4.56,8.52,0.77,0.01,0.02,0.7]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Кондитерское изделие(печенье, сушка, пряник)",36,2.7,3.53,26.78,149.7,0.021,0.014,2.376,0,0,90.288,32.87,9.187,6.264,28.188,0.658,0,0,0]
[null,"Итого за обед",570,{"$f":"SUM(D169:D174)","v":26.86},{"$f":"SUM(E169:E174)","v":18.27},89.9,631.5999999999999,0.181,0.14400000000000002,403.746,0,20.48,702.058,607.24,190.687,121.394,293.108,4.668,51.669999999999995,29.15,144.48]
[null,"Итого за день",{"$f":"C175+C167","v":1160},38.480000000000004,21.13,164.44,1005.9999999999999,0.441,0.17400000000000002,406.346,0,26.68,924.058,675.24,298.587,188.69400000000002,467.70799999999997,8.048,52.309999999999995,36.53,147.38]
[]
["9 день, 2 неделя"]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Среда, 2 неделя"]
[null,"Завтрак","11-18"]
["Пром.","Кондитерское изделие (простая сушка, пряник, печенье, вафли)",15,1.42,0.17,8.94,43,0.03,0.01,0,0,0,79,24,4,6,16,0.4,0,0,0]
["№ Т/к 67","Щи из свежей капусты с картофелем",250,1.9,5.1,9.3,90.5,0,0,0.2,0,12.4,0,0,41.5,22,42.7,1.1,0,0,0]
["54-2гн-2020","Чай с сахаром",200,0.19,0.04,6.42,26.8,0,0.01,0.3,0,0,1,21,66,4,7,0.7,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",{"$f":"SUM(C184:C188)","v":505},{"$f":"SUM(D184:D188)","v":6.329999999999999},{"$f":"SUM(E184:E188)","v":5.67},41.2,241.40000000000003,0.09,0.05,0.5,0,12.4,302,113,122.5,44.4,110.30000000000001,3.1800000000000006,0.64,7.38,2.9]
[null,"Обед","11-18"]
["54-13з-2020","Салат из свеклы отварной с растительным маслом",60,0.8,2.7,4.6,45.6,0.01,0.02,0.68,0,2.28,78.77,136.27,19.21,10.95,21.51,0.7,11.99,0.35,11.4]
["54-22м-2020","Рагу из курицы","160/60",3.69,6.37,23.79,239,0.14,0.12,28.55,0.11,12,195,750,47,34,101,1.2,34.15,1,51.35]
["54-21гн-2020","Кофейный напиток с молоком",200,8.31,8.37,15.42,86,0,0,38.45,0.01,1.79,3,43,45.75,35.13,109,1.6,0,0,0]
["Пром.","Хлеб ржаной",20,3.9,2.9,11.2,34.2,0.03,0.13,13.29,0,0.52,38.55,183.98,148.32,30.67,106.79,1.06,9,1.76,20]
["Пром.","Хлеб пшеничный",20,1.3,0.2,6.7,46.9,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Фрукт (яблоко, банан, апельсин)",180,1.52,0.16,9.84,66.6,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
[null,"Итого за обед",700,{"$f":"SUM(D191:D196)","v":19.52},{"$f":"SUM(E191:E196)","v":20.699999999999996},71.55000000000001,{"$f":"SUM(G191:G196)","v":518.3},0.24000000000000002,0.30000000000000004,80.97,0.12,16.59,537.3199999999999,1181.25,271.28,123.15000000000002,382.90000000000003,5.540000000000001,55.78,10.489999999999998,85.65]
[null,"Итого за день",{"$f":"C197+C189","v":1205},25.849999999999998,26.369999999999997,112.75000000000001,759.7,0.33,0.35000000000000003,81.47,0.12,28.990000000000002,839.3199999999999,1294.25,393.78,167.55,493.20000000000005,8.720000000000002,56.42,17.869999999999997,88.55000000000001]
[]
["10 день, 2 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Четверг, 2 неделя"]
[null,"Завтрак","11-18"]
["№ Т/К 50","Салат свеколка с маслом растительным",100,1.8,10.1,16.2,163.2,0,0,0.1,0,3.5,0,0,45.5,27.5,52.8,1.5,0,0,0]
["№ Т/к100","Суп картофельный с вермишелью",250,2.8,2.8,20.2,118,0.1,0,0.2,0,6.6,0,0,23.9,23.4,57.7,1.1,0,0,0]
["54-3гн-2020","Чай с лимоном и сахаром",207,0.2,0.1,6.6,27.9,0,0.01,0.38,0,1.16,1.26,30.23,67,4.56,8.52,0.77,0.01,0.02,0.7]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
[null,"Итого за завтрак",{"$f":"SUM(C206:C210)","v":597},{"$f":"SUM(D206:D210)","v":7.619999999999999},{"$f":"SUM(E206:E210)","v":13.359999999999998},59.540000000000006,390.19999999999993,0.16,0.04,0.68,0,11.26,223.26,98.23,147.4,67.86,163.62,4.3500000000000005,0.65,7.3999999999999995,3.5999999999999996]
[null,"Обед","11-18"]
["54-7з-2020","Салат из белокочанной капусты с растительным маслом",60,1.5,6.1,6.2,85.8,0.03,0.04,122.25,0,34.78,88.69,247.73,40.39,15.18,30.31,0.55,10.73,0.26,12.66]
["54-4г-2020","Каша гречневая рассыпчатая",180,9.87,7.61,43.12,280.5,0.26,0.14,23.02,0.11,0,180,263,57,144,217,4.8,26.73,4.3,19.27]
["54-7р-2020","Рыба припущенная в молоко","70/30",8.06,4.42,2.89,131.6,0.08,0.11,9.02,0.16,1,111,347,68,44,202,0.7,133.48,11.9,572.6]
["54-1хн-2020","Компот из смеси сухофруктов",200,0.47,0,14.78,65,0,0,15,0,0,0,0,108,2,4,0.1,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за обед",580,{"$f":"SUM(D213:D218)","v":22.72},{"$f":"SUM(E213:E218)","v":18.490000000000002},83.53,{"$f":"SUM(G213:G218)","v":644},0.43000000000000005,0.32000000000000006,169.29000000000002,0.27,35.78,601.69,925.73,284.39,217.58,497.91,7.13,171.57999999999998,23.84,607.43]
[null,"Итого за день",{"$f":"C219+C211","v":1177},{"$f":"D219+D211","v":30.339999999999996},31.85,143.07,1034.1999999999998,0.5900000000000001,0.36000000000000004,169.97000000000003,0.27,47.04,824.95,1023.96,431.78999999999996,285.44,661.53,11.48,172.23,31.24,611.03]
[]
["11 день, 2 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Пятница, 2 неделя"]
[null,"Завтрак","11-18"]
["Пром.","Кондитерское изделие (сушка простая, пряник, печенье, вафли)",30,1.77,1.41,22.5,109.8,0.02,0,0,0,0,0,18,3,2,13,0.2,0,0,0]
["№ Т/к 99","Суп картофельный с бобовыми",250,5.7,4.5,18.8,139,0.3,0,0.2,0,4.6,0,0,35.7,32.5,77.8,2,0,0,0]
["54-2гн-2020","Чай -заварка",200,0.2,0,6.4,26.8,0,0.01,0.3,0,0.04,0.68,20.76,66.08,3.83,7.18,0.73,0,0,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
[null,"Итого за завтрак",{"$f":"SUM(C228:C232)","v":520},{"$f":"SUM(D228:D232)","v":10.490000000000002},{"$f":"SUM(E228:E232)","v":6.2700000000000005},64.24,356.7,0.38,0.04,0.5,0,4.64,222.68,106.76,115.78,50.73,142.57999999999998,3.91,0.64,7.38,2.9]
[null,"Обед","11-18"]
["54-16з-2020","Винегрет с растительным маслом",60,0.7,5.4,4,67.1,0.02,0.02,72.89,0,2.26,200.99,127.85,12.1,9.66,21.4,0.41,7.86,0.13,11.85]
["54-1г-2020","Макароны отварные",180,6.39,5.91,39.36,236.2,0.07,0.03,22.03,0.11,0,179,64,127,9,48,0.9,24.92,0.1,14.31]
["54-2м-2020 ","Гуляш из говядины ","60/40",6.99,6.54,8.3,130.8,0.04,0.12,25.46,0.07,1,122,322,55,23,166,2.5,17.06,0.4,62.71]
["54-2гн-2020","Чай с сахаром",200,0.19,0.04,6.42,26.8,0,0.01,0.3,0,0,1,21,66,4,7,0.7,0,0,0]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
[null,"Итого за Обед",580,{"$f":"SUM(D235:D240)","v":17.09},18.25,74.62,{"$f":"SUM(G235:G240)","v":542},0.19,0.21,120.67999999999999,0.18,3.26,724.99,602.85,271.1,58.059999999999995,287,5.49,50.480000000000004,8.01,91.77000000000001]
[null,"Итого за день",{"$f":"C241+C233","v":1100},{"$f":"D241+D233","v":27.580000000000002},24.52,138.86,898.7,0.5700000000000001,0.25,121.17999999999999,0.18,7.8999999999999995,947.6700000000001,709.61,386.88,108.78999999999999,429.58,9.4,51.120000000000005,15.39,94.67000000000002]
[]
[]
["12 день, 2 неделя "]
["№ рецептуры","Прием пищи, наименование блюда","Масса","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[{"$nulls":3},"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Пятница, 2 неделя"]
[null,"Горячий завтрак","11-18"]
["54-9з-2020","Салат из белокочанной капусты с морковью, яблоками и растительным маслом",60,0.8,6.1,3.6,72.5,0.02,0.02,241.63,0,17.32,87.51,160.14,23.5,11.17,18.8,0.56,9.87,0.15,10.98]
["54-1т-2020","Запеканка из творога ",180,35.58,12.81,26.95,361.4,0.07,0.38,61.35,0.18,0,217,193,268,38,349,1,34.58,47,59.55]
["Пром.","Молоко сгущенное с сахаром",20,1.44,1.7,11.1,65.5,0.01,0.08,9.4,0,0,26,73,61,7,44,0,1.4,0.6,7]
["54-3гн-2020","Чай с лимоном и сахаром","200/7/7",0.2,0.1,6.6,27.9,0,0.01,0.38,0,1.16,1.26,30.23,67,4.56,8.52,0.77,0.01,0.02,0.7]
["Пром.","Хлеб ржаной",20,1.3,0.2,6.7,34.2,0.04,0.02,0,0,0,122,49,7,9.4,31.6,0.78,0,6.18,0]
["Пром.","Хлеб пшеничный",20,1.52,0.16,9.84,46.9,0.02,0.01,0,0,0,100,19,4,3,13,0.2,0.64,1.2,2.9]
["Пром.","Сушка простая",10,1.09,0.13,6.88,33.1,0.02,0.01,0,0,0,46,15,3,4,11,0.3,0,0,0]
[null,"Итого за Завтрак",524,{"$f":"SUM(D251:D257)","v":41.93},21.2,71.67,641.5,0.18,0.53,312.76,0.18,18.48,599.77,539.37,433.5,77.13000000000001,475.92,3.6100000000000003,46.49999999999999,55.150000000000006,81.13000000000001]
[null,"Итого за день",{"$f":"C258","v":524},{"$f":"D258","v":41.93},{"$f":"E258","v":21.2},71.67,641.5,0.18,0.53,312.76,0.18,18.48,599.77,539.37,433.5,77.13000000000001,475.92,3.6100000000000003,46.49999999999999,55.150000000000006,81.13000000000001]
[]
[{"$nulls":3},"ИТОГО ПО  МЕНЮ"]
[]
[null,"ИТОГО","Пищевые вещества",null,null,"Энергетическая ценность","Витамины",{"$nulls":4},"Минеральные вещества"]
[null,null,"Белки","Жиры","Углеводы",null,"B1","B2","A","D","C","Na","K","Ca","Mg","P","Fe","I","Se","F"]
[null,null,"г","г","г","ккал","мг","мг","мкг рет.экв","мкг","мг","мг","мг","мг","мг","мг","мг","мкг","мкг","мкг"]
[null,"Итого за весь период",{"$f":"D28+D50+D73+D95+D116+D154+D176+D198+D220+D242+D259+D132","v":389.63},{"$f":"E28+E50+E73+E95+E116+E154+E176+E198+E220+E242+E259+E132","v":342.41999999999996},1578.3200000000002,11112.3,5.211,3.444,4306.696,2.7800000000000002,317.11999999999995,10011.478000000003,9781.71,4376.427,1914.9740000000002,5806.428,104.92800000000001,796.1600000000001,304.9100000000001,1595.95]
[null,"Среднее значение",{"$f":"C266/12","v":{"v":32.469166666666666,"d":"32.47"}},{"$f":"D266/12","v":{"v":28.534999999999997,"d":"28.54"}},{"v":131.52666666666667,"d":"131.53"},{"v":926.025,"d":"926.03"},{"v":0.43425,"d":"0.43"},{"v":0.287,"d":"0.29"},{"v":358.8913333333333,"d":"358.89"},{"v":0.2316666666666667,"d":"0.23"},{"v":26.426666666666662,"d":"26.43"},{"v":834.2898333333336,"d":"834.29"},{"v":815.1424999999999,"d":"815.14"},{"v":364.70225,"d":"364.70"},{"v":159.5811666666667,"d":"159.58"},{"v":483.86899999999997,"d":"483.87"},{"v":8.744000000000002,"d":"8.74"},{"v":66.34666666666668,"d":"66.35"},{"v":25.409166666666675,"d":"25.41"},{"v":132.99583333333334,"d":"133.00"}]
[null,"Содержание белков, жиров, углеводов в меню за период в % от калорийности",15.45,{"$f":"D266*9/F266*100","v":{"v":27.733052563375722,"d":"27.73"}},{"$f":"E266*4*100/F266","v":{"v":56.8134409618171,"d":"56.81"}}]
[]
[null,"Овощи для салатов (морковь, лук, капуста, картофель) урожай 2025 года"]