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

{"sheet":"Лист2","index":0,"n_rows":125,"n_cols":11,"rows_kept":125,"merged":[[5,0,5,10],[6,0,6,10],[7,1,9,1],[7,2,8,2],[7,3,7,5],[7,6,9,6],[7,7,7,8],[7,10,10,10],[8,3,9,3],[8,4,9,4],[8,5,9,5],[10,0,10,1],[11,0,11,1],[12,0,19,0],[21,0,21,1],[22,0,28,0],[30,0,30,1],[31,0,38,0],[40,0,40,1],[41,0,48,0],[50,0,50,1],[51,0,57,0],[59,0,59,10],[60,0,65,0],[67,0,67,1],[68,0,75,0],[77,0,77,1],[78,0,84,0],[86,0,86,1],[87,0,94,0],[96,0,96,1],[97,0,104,0],[106,0,106,1],[107,0,112,0],[114,0,114,1],[115,0,120,0],[125,0,125,10],[126,0,126,10]]}
["Согласовано",{"$nulls":6},"Утверждаю"]
["Начальник отдела образования ",{"$nulls":6},"Директор ____________________"]
["Сармановского муниципального района"]
["______________Г.Я.Идрисова"]
[]
["ПРИМЕРНОЕ 12 ДНЕВНОЕ МЕНЮ "]
["для организации бесплатного горячего  питания для обучающихся начальных классов образовательных организаций Республики Татарстан"]
[null,"Наименование блюда","Выход блюда(гр)","Пищевые вещества(г)",null,null,"Энергетическая ценность (ккал)","Минеральные вещества (мг)",null,"Витамины (мг)","№ тех. карты"]
[{"$nulls":3},"Б","Ж","У",null,"Са","Р","С"]
[]
[null,null,"1-4 кл","1-4 кл","1-4 кл","1-4 кл","1-4 кл","1-4 кл","1-4 кл","1-4 кл"]
["1 неделя  1 день (понедельник)"]
["Горячий Завтрак","Салат из моркови с сахаром",60,0.516,2.132,4.45,50,23.302,10.85,13.43,62]
[null,"Бифштекс рубленный ",100,8.32,7.15,9.72,200,11.01,127.02,null,266]
[null,"Каша вязкая гречнивая","150",6.662,9.024,34.9,170,37.352,170.553,null,303]
[null,"Вафли",20,5.5,6.5,34.9,210.9,8,null,25.1]
[null,"Апельсин",100,0.9,0.2,8.1,43,40,14,53.2]
[null,"Чай с молоком","150/50/15",1.52,1.35,14.76,81,40,92.8,1.33,378]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D13:D20)","v":26.698},{"$f":"SUM(E13:E20)","v":26.795999999999996},{"$f":"SUM(F13:F20)","v":116.32},{"$f":"SUM(G13:G20)","v":869.9},{"$f":"SUM(H13:H20)","v":168.42399999999998},447.44300000000004,93.06]
["1 неделя  2 день (вторник)"]
["Горячий Завтрак","Салат из белокочанной капусты","60",0.78,6.1,19.7,158.64,192.17,156.05,1.09,390]
[null,"Рагу из птицы","50/150",12.3,17.66,29.85,313,57.66,201.911,8.076,289]
[null,"Булочки сдобные \"Ромашка\" ",90,3.9,3.6,28.5,196,13.6,22.13,null,34]
[null,"Кофейный напиток","200",3.6,2.67,29.2,155,158.67,132,1.47,379]
[null,"Яблоко","100",0.26,0.17,11.41,52,35.5,42.58,8.23]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D23:D29)","v":24.120000000000005},30.64,128.15,989.64,466.36,586.8910000000001,18.866]
["1 неделя  3 день (среда)"]
["Горячий Завтрак","Салат из свеклы отварной",60,0.855,3.653,11.58,56,121.09,84.582,7.7,52]
[null,"Гуляш из говядины","50/50",10.5,11.03,3.184,196,66.806,215.174,3.89,256]
[null,"Макаронные изделия отварные с маслом","150/5",5.1,4.468,28.5,187,16.457,57.009,null,203]
[null,"Пряники","20",0.75,3.25,30.5,181,null,null,0]
[null,"Какао с молоком",200,3.78,0.67,26,125,133.33,111.11,1.33,382]
[null,"Банан",100,1.5,0.5,21,96,3,5,{"v":11,"d":"11.00"}]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D32:D39)","v":25.765},24.011,130.25400000000002,956,349.443,505.095,23.92]
["1 неделя  4 день (четверг)"]
["Горячий Завтрак","Салат овощной с яблоками",60,3.5,6.11,9.9,124,126.88,120.41,11.31,56]
[null,"Сыр порционный",20,2.18,0.5,0.78,16.12,11.31,11.36,0.09]
[null,"Котлеты рубленные из птицы","100",10.24,5.37,19.36,159,89.43,158,0,295]
[null,"Картофельное пюре",150,3.09,8.282,22,172,47.805,98.835,7.943,312]
[null,"Вафли",20,5.5,6.5,34.9,210.9,8,null,25.1]
[null,"Сок фруктовый",200,1,0.2,20.2,92,9.6,2,4.4]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D42:D49)","v":28.79},27.401999999999997,116.63,889.02,301.785,422.825,48.842999999999996]
["1 неделя  5 день (пятница)"]
["Горячий Завтрак","Салат из моркови с яблоками",60,0.66,0.12,2.28,14,3.861,8.4,15.6,59]
[null,"Горбуша тушеные  с овощами",80,9.8,3.1,2.7,78.1,6.5,23,1.6,268]
[null,"Рис отварной",150,3.834,5.434,29.6,210,11.46,84.15,null,304]
[null,"Кисель",200,0,0,20,76,0.48,null,{"v":0,"d":"0.00"},122]
[null,"Груша",100,0.36,0.14,12.13,57,6.2,1,5.6]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D52:D58)","v":17.934},9.234,76.19999999999999,550.1,37.261,148.77,{"v":22.799999999999997,"d":"22.80"}]
["1 неделя 6 день (суббота)"]
["Горячий Завтрак","Плоды и ягоды свежие яблоки",100,0.4,0.4,7.35,47,16,11,8,338]
[null,"Булочки сдобные \"Ромашка\" ",90,3.9,3.6,28.5,196,13.6,22.13,null,34]
[null,"Пельмени мясные отварные","180/5",10.34,12.175,20.34,237,79.453,239.018,0.491,392]
[null,"Кофейный напиток с молоком","200",3.6,2.67,29.2,155,158.67,132,1.47,379]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D62:D66)","v":21.12},18.884999999999998,87.53,703,260.48299999999995,425.36800000000005,1.9609999999999999]
["2 неделя  1 день (понедельник)"]
["Горячий Завтрак","Апельсин",100,0.4,0.4,7.35,47,46,11,{"v":8,"d":"8.00"},338]
[null,"Салат из белокочанной капусты",60,0.78,1.94,3.87,36,16.98,45.98,6.25,45]
[null,"Фрикадельки в соусе","55",8.33,7.743,3.194,175,100.53,110.53,0.65,280]
[null,"Каша гречневая рассыпчатая",150,6.662,9.024,34,170,37.352,170.553,"-"]
[null,"Чай с сахаром","200/15",0.53,null,9.47,40,13.6,22.13,0.27,376]
[null,"Вафли",20,5.5,6.5,34.9,210.9,8,null,25.1]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D69:D76)","v":25.482000000000003},{"$f":"SUM(E69:E76)","v":26.046999999999997},{"$f":"SUM(F69:F76)","v":102.27399999999999},{"$f":"SUM(G69:G76)","v":793.9},{"$f":"SUM(H69:H76)","v":231.22199999999998},{"$f":"SUM(I70:I76)","v":381.413},{"$f":"SUM(J69:J76)","v":40.27}]
["2 неделя  2 день (вторник)"]
["Горячий Завтрак","Салат из белокочанной капусты",60,0.78,1.94,3.87,36,16.98,45.98,6.25,45]
[null,"Ленивые голубцы","200",11.6,17.5,7.4,235.7,83.07,273,4.9,291]
[null,"Ряженка",200,5.8,5,8.4,108,248,184,{"v":0.6,"d":"0.60"}]
[null,"Булочки сдобные \"Ромашка\" ",90,3.9,3.6,28.5,196,13.6,22.13,null,34]
[null,"Банан",100,1.5,0.5,21,96,3,5,{"v":11,"d":"11.00"}]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D79:D85)","v":26.86},28.98,78.66,786.7,373.41,562.33,22.75]
["2 неделя  3 день (среда)"]
["Горячий Завтрак","Салат из свеклы отварной","60",0.855,3.653,11.58,56,121.09,84.58,7.7,52]
[null,"Биточки рыбные(минтай)",100,6.45,4.24,7.49,116,44.02,137.06,0.48,234]
[null,"Картофельное пюре",150,3.09,8.282,22,172,47.805,98.835,7.943,312]
[null,"Компот из сухофруктов",200,0.04,0,0,94.2,6.4,3.6,1.08,868]
[null,"Вафли",20,5.5,6.5,34.9,210.9,8,null,25.1]
[null,"Груша",100,0.36,0.14,12.13,57,6.2,1,5.6]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D88:D95)","v":19.575},{"$f":"SUM(E88:E95)","v":23.255},{"$f":"SUM(F88:F95)","v":97.58999999999999},{"$f":"SUM(G88:G95)","v":821.1},{"$f":"SUM(H88:H95)","v":242.275},{"$f":"SUM(I88:I95)","v":357.295},{"$f":"SUM(J88:J95)","v":{"v":47.903,"d":"47.90"}}]
["2 неделя  4 день (четверг)"]
["Горячий Завтрак","Салат из моркови с сахаром",60,0.516,2.132,4.45,50,23.302,10.85,13.43,62]
[null,"Тефтели с рисом из гов.мясом",80,10.8,16.7,13.4,248,34.56,110.1,1.017,280]
[null,"Макароны отварные с маслом","150/5",5.1,4.468,28.5,187,16.457,57.009,null,203]
[null,"Какао с молоком",200,3.78,0.67,26,125,133.33,111.11,1.33,382]
[null,"Пряники","20",0.75,3.25,30.5,181,null,null,0]
[null,"Яблоко","100",0.26,0.17,11.41,52,35.5,42.58,8.23]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D98:D105)","v":24.486000000000004},27.830000000000002,123.74999999999999,958,251.909,363.869,{"v":24.006999999999998,"d":"24.01"}]
["2 неделя  5 день (пятница)"]
["Горячий Завтрак","Салат из свеклы отварной","60",0.855,3.653,11.58,56,121.09,84.58,7.7,52]
[null,"Жаркое из  говядины","50/150",12.3,17.66,29.85,313,57.66,201.911,8.076,289]
[null,"Чай с сахаром","200/15",0.53,null,9.47,40,13.6,22.13,0.27,376]
[null,"Сок фруктовый 0,2",200,0.4,0.4,7.35,47,46,11,{"v":8,"d":"8.00"},338]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D108:D113)","v":17.365000000000002},22.152999999999995,67.74,571,247.10999999999999,351.841,{"v":24.046,"d":"24.05"}]
["2 неделя  6 день (суббота)"]
["Горячий завтрак","Яблоко","100",0.26,0.17,11.41,52,35.5,42.58,8.23]
[null,"Булочки сдобные \"Ромашка\" ",90,3.9,3.6,28.5,196,13.6,22.13,null,34]
[null,"Салат овощной с яблоками",60,0.66,0.12,2.28,14,3.861,8.4,15.6,59]
[null,"Пельмени мясные отварные","180/5",10.34,12.175,20.34,237,79.453,239.018,0.491,392]
["Обед","Чай с лимоном","200/15/7",0.084,0.012,15.185,62,3.25,1.54,2.8,377]
[null,"Хлеб ржаной ",20,1,0.2,9,44,2.76,12.72]
[null,"Хлеб рж-пшеничный","30",2.28,0.24,0.49,71,6,19.5]
["Итого",null,null,{"$f":"SUM(D117:D119)","v":14.899999999999999},15.895000000000001,51.120000000000005,447,96.914,269.548,{"v":16.091,"d":"16.09"}]
[null,"Итого за 12 дней",null,{"$f":"SUM(D21,D30,D40,D50,D59,D77,D86,D96,D106,D114,D123)","v":251.975},262.243,1088.688,8632.36,2766.1130000000003,4397.320000000001,{"v":382.55600000000004,"d":"382.56"}]
[null,"Средняя величина за 1 день",null,{"$f":"D124/12","v":{"v":20.997916666666665,"d":"21.00"}},{"v":21.853583333333333,"d":"21.85"},{"v":90.724,"d":"90.72"},{"v":719.3633333333333,"d":"719.36"},{"$f":"H124/12","v":{"v":230.50941666666668,"d":"230.51"}},{"v":366.4433333333334,"d":"366.44"},{"v":31.87966666666667,"d":"31.88"}]

{"sheet":"Лист3","index":1,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[0,0,0,15],[1,0,1,15],[2,0,2,15],[3,1,5,1],[3,2,4,3],[3,4,3,9],[3,10,5,11],[3,12,5,13],[3,14,5,14],[3,15,6,15],[4,4,5,5],[4,6,5,7],[4,8,5,9],[5,2,5,3],[6,0,6,1],[7,0,10,0],[7,1,7,2],[12,0,15,0],[12,1,12,2],[17,0,20,0],[17,1,17,2],[22,0,25,0],[27,0,30,0],[32,0,32,1],[34,0,34,15],[35,0,36,15]]}
["Наименование сборника рецептур:Сборник рецептур блюд и кулинарных изделий для предприятий общественного питания / Авт.-сост: А.И.Здобнов, В.А. Цыганенко, М.И.Цыганенко, М.И.Пересичный- К.А.С.К. 2005 г."]
["ПРИМЕРНОЕ 5 ДНЕВНОЕ МЕНЮ ДЛЯ ГРУПП ПРОДЛЕННОГО ДНЯ  ОБЩЕОБРАЗОВАТЕЛЬНЫХ  УЧРЕЖДЕНИЙ САРМАНОВСКОГО МУНИЦИПАЛЬНОГО РАЙОНА "]
["на  2 полугодие 2018-2019 учебного  года"]
[null,"Наименование блюда","Выход блюда(гр)",null,"Пищевые вещества(г)",{"$nulls":5},"Энергетическая ценность (ккал)",null,"Минеральн.вещества, мг",null,"Витамины, мг","№ тех. карты"]
[{"$nulls":4},"Б",null,"Ж",null,"У"]
[]
[null,null,"1-4 кл",null,"1-4 кл",null,"1-4 кл",null,"1-4 кл",null,"1-4 кл",null,"Са","Р","С"]
["Обед","Понедельник"]
[null,"ЩИ с капустой и картофелем",250,null,1.75,null,4.84,null,8.49,null,84.75,null,73.33,47.63,18.46,187]
[null,"Компот из смеси сухофруктов",200,null,0.04,null,0,null,24.76,null,94.2,null,{"v":6.4,"d":"6.40"},3.6,1.08,868]
[null,"Хлеб рж-пшеничный","55",null,2.72,null,0.49,null,0.74,null,74.6,null,{"v":0.111,"d":"0.11"},21.65,0,61]
[null,"ИТОГО",null,null,{"$f":"SUM(E9:E11)","v":4.51},0,5.33,0,33.99,0,253.54999999999998,0,{"v":79.84100000000001,"d":"79.84"},72.88,19.54]
["Обед","Вторник"]
[null,"Суп картофельный с горохом на м/к бульоне",250,null,5.5,null,5.28,null,16.33,null,134.7,null,{"v":5.7,"d":"5.70"},10.8,7.8,206]
[null,"Чай сладкий  с сахаром",200,null,1.2,null,3.06,null,13,null,49.28,null,{"v":11.6,"d":"11.60"},0,6,943]
[null,"Хлеб рж-пшеничный","55",null,2.72,null,0.49,null,0.74,null,74.6,null,{"v":0.111,"d":"0.11"},21.65,0,61]
[null,"ИТОГО",null,null,{"$f":"SUM(E14:E16)","v":9.42},0,8.83,0,30.069999999999997,0,258.58,0,{"v":17.411,"d":"17.41"},32.45,13.8]
["Обед","Среда"]
[null,"Суп рисовый с картофелем на м/к бульоне",250,null,1.98,null,2.74,null,14.58,null,90.75,null,23.05,62.55,8.25,204]
[null,"Кисель фруктово-ягодный",200,null,0.1,null,0,null,31.46,null,126.22,null,{"v":0.2,"d":"0.20"},0,0,122]
[null,"Хлеб рж-пшеничный","55",null,2.72,null,0.49,null,0.74,null,74.6,null,{"v":0.111,"d":"0.11"},21.65,0,61]
[null,"ИТОГО",null,null,{"$f":"SUM(E19:E21)","v":4.800000000000001},0,3.2300000000000004,0,46.78,0,291.57,0,{"v":23.361,"d":"23.36"},84.19999999999999,8.25]
["Обед","Четверг"]
[null,"Жаркое по-домашнему","50/100",null,17.21,null,4.67,null,41.16,null,496.88,null,{"v":48.6,"d":"48.60"},526.5,14.02,96]
[null,"Чай сладкий  с сахаром",200,null,1.2,null,3.06,null,13,null,49.28,null,{"v":11.6,"d":"11.60"},0,6,943]
[null,"Хлеб рж-пшеничный","55",null,2.72,null,0.49,null,0.74,null,74.6,null,{"v":0.111,"d":"0.11"},21.65,0,61]
[null,"ИТОГО",null,null,{"$f":"SUM(E24:E26)","v":21.13},0,8.22,0,54.9,0,620.76,0,{"v":60.311,"d":"60.31"},548.15,20.02]
["Обед","Пятница"]
[null,"Суп с макаронными изделиями и картофелем на м/к бульоне",250,null,3.75,null,1.75,null,8,null,62.75,null,{"v":2.9,"d":"2.90"},14.4,7.8,208]
[null,"Компот из смеси сухофруктов",200,null,0.04,null,0,null,24.76,null,94.2,null,{"v":6.4,"d":"6.40"},3.6,1.08,868]
[null,"Хлеб рж-пшеничный","55",null,2.72,null,0.49,null,0.74,null,74.6,null,{"v":0.111,"d":"0.11"},21.65,0,61]
[null,"ИТОГО",null,null,{"$f":"SUM(E29:E31)","v":6.51},0,2.24,0,33.50000000000001,0,231.54999999999998,0,{"v":9.411000000000001,"d":"9.41"},39.65,8.879999999999999]
["Итого за 5 дней",{"$nulls":3},{"$f":"E12+E17+E22+E27+E32","v":46.37},0,27.85,0,199.24,0,1656.01,0,{"v":190.335,"d":"190.34"},777.3299999999999,70.49]
[null,"Средняя величина за 1 день",null,null,{"$f":"E33/5","v":{"v":9.274,"d":"9.27"}},{"v":0,"d":"0.00"},5.57,{"v":0,"d":"0.00"},{"v":39.848,"d":"39.85"},{"v":0,"d":"0.00"},{"v":331.202,"d":"331.20"},{"v":0,"d":"0.00"},{"v":38.067,"d":"38.07"},{"v":155.46599999999998,"d":"155.47"},{"v":14.097999999999999,"d":"14.10"}]
[]
["Наименование сборника рецептур:Сборник рецептур блюд и кулинарных изделий для предприятий общественного питания / Авт.-сост: А.И.Здобнов, В.А. Цыганенко, М.И.Цыганенко, М.И.Пересичный- К.А.С.К. 2005 г."]