{"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,"МКОУ \"Торгунская СШ\"",null,null,"Утвердил:","должность","директор ООО \"Комбинат Питания\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Н.А. Мундашева"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",19,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша \"Дружба\"",150,6.5,8.3,25.1,211,"356/2022",136.37]
[{"$nulls":3},"гор.напиток","Кофейный напиток злаковый на молоке",200,{"v":3,"d":"3.0"},1.8,{"v":26,"d":"26.0"},124,"774/2022"]
[{"$nulls":3},"хлеб","Бутерброд с сыром 40/10",50,6.1,8.7,14.8,162,"3/2017"]
[{"$nulls":3},"фрукты","Фрукт свежий (яблоко)",100,0.4,0.4,9.8,44,"338/2017"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":500},16,19.2,75.7,541,null,{"$f":"SUM(L6:L12)","v":136.37}]
[{"$f":"A6","v":1},1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":0},0,0,0,0,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},1,"Итого за день:",null,null,{"$f":"F13+F23","v":500},16,19.2,75.7,541,null,{"$f":"L13+L23","v":136.37}]
[1,2,"Завтрак","гор.блюдо","Плов из птицы",200,16.4,19.9,34.8,354,"291/2017",136.37]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,{"v":0,"d":"0.0"},{"v":10,"d":"10.0"},40,"782/2022"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",40,2.7,0.8,17.6,88,"23/2022"]
[{"$nulls":3},"закуска","Овощи сезонные порционно (вареная свекла)",60,0.9,0.1,5.3,26,"т.24/1996"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":500},20.199999999999996,20.8,67.7,508,null,{"$f":"SUM(L25:L31)","v":136.37}]
[{"$f":"A25","v":1},2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":0},0,0,0,0,null,{"$f":"SUM(L33:L41)","v":0}]
[{"$f":"A25","v":1},2,"Итого за день:",null,null,{"$f":"F32+F42","v":500},20.199999999999996,20.8,67.7,508,null,{"$f":"L32+L42","v":136.37}]
[1,3,"Завтрак","гор.блюдо","Котлеты из говядины",90,12.4,14.8,11.8,231,"268/2017",136.37]
[{"$nulls":3},"гор.блюдо","Бобовые отварные",150,14.1,6.9,33.5,255,"306/2017"]
[{"$nulls":3},"гор.напиток","Чай каркаде с сахаром",200,0.2,{"v":0,"d":"0.0"},{"v":15,"d":"15.0"},58,"ТТК 23А"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",30,2.1,0.6,13.2,66,"23/2022"]
[{"$nulls":3},"закуска","Овощи сезонные порционно (вареная свекла)",60,0.9,0.1,5.3,26,"т.24/1996"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":530},{"$f":"SUM(G44:G50)","v":29.7},22.400000000000006,78.8,636,null,{"$f":"SUM(L44:L50)","v":136.37}]
[{"$f":"A44","v":1},3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":0},0,0,0,0,null,{"$f":"SUM(L52:L60)","v":0}]
[{"$f":"A44","v":1},3,"Итого за день:",null,null,{"$f":"F51+F61","v":530},29.7,22.400000000000006,78.8,636,null,{"$f":"L51+L61","v":136.37}]
[1,4,"Завтрак","гор.блюдо","Лапшевник с творогом с соусом молочным",230,10.9,15.3,38.8,257,"208/2017",136.37]
[{"$nulls":3},"гор.напиток","Чай каркаде с сахаром",200,0.2,{"v":0,"d":"0.0"},{"v":15,"d":"15.0"},58,"ТТК 23А"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",40,2.7,0.8,17.6,88,"23/2022"]
[{"$nulls":3},"сладкое","Печенье сахарное",30,3.8,4.1,{"v":14,"d":"14.0"},91,208]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":500},17.6,20.200000000000003,85.4,494,null,{"$f":"SUM(L63:L69)","v":136.37}]
[{"$f":"A63","v":1},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":0},0,0,0,0,null,{"$f":"SUM(L71:L79)","v":0}]
[{"$f":"A63","v":1},4,"Итого за день:",null,null,{"$f":"F70+F80","v":500},17.6,20.200000000000003,85.4,494,null,{"$f":"L70+L80","v":136.37}]
[1,5,"Завтрак","гор.блюдо","Котлеты рыбные любительские",90,11.7,10.6,8.6,179,"467/2022",136.37]
[{"$nulls":3},"гор.блюдо","Картофель отварной",150,3.6,5.8,28.6,176,"310/2017"]
[{"$nulls":3},"гор.напиток","Чай фруктовый",200,0.2,{"v":0,"d":"0.0"},12.2,43,"783/2022"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",30,2.1,0.06,13.2,66,"23/2022"]
[{"$nulls":3},"закуска","Овощи сезонные порционно (вареная свекла)",60,0.9,0.1,5.3,26,"т.24/1996"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":530},18.499999999999996,16.56,67.9,490,null,{"$f":"SUM(L82:L88)","v":136.37}]
[{"$f":"A82","v":1},5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F98)","v":0},0,0,0,0,null,{"$f":"SUM(L90:L98)","v":0}]
[{"$f":"A82","v":1},5,"Итого за день:",null,null,{"$f":"F89+F99","v":530},18.499999999999996,16.56,67.9,490,null,{"$f":"L89+L99","v":136.37}]
[2,1,"Завтрак","гор.блюдо","Каша жидкая молочная из манной крупы с маслом сливочным",160,7.5,8.9,28.3,217,"181/2017",136.37]
[{"$nulls":3},"гор.напиток","Кофейный напиток злаковый на молоке",200,{"v":3,"d":"3.0"},1.8,{"v":26,"d":"26.0"},124,"774/2022"]
[{"$nulls":3},"хлеб","Бутерброд с маслом 35/5",40,4.5,7.5,14.9,136,"1/2017"]
[{"$nulls":3},"фрукты","Фрукт свежий (яблоко)",100,0.4,0.4,9.8,44,"338/2017"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":500},15.4,18.6,79,521,null,{"$f":"SUM(L101:L107)","v":136.37}]
[{"$f":"A101","v":2},1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":0},0,0,0,0,null,{"$f":"SUM(L109:L117)","v":0}]
[{"$f":"A101","v":2},1,"Итого за день:",null,null,{"$f":"F108+F118","v":500},{"v":15.4,"d":"15"},{"v":18.6,"d":"19"},79,521,null,{"$f":"L108+L118","v":136.37}]
[2,2,"Завтрак","гор.блюдо","Гуляш из мяса птицы",100,8.4,10.3,9.4,126,"580/2022",136.37]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.3,6.2,35.3,221,"309/2017"]
[{"$nulls":3},"гор.напиток","Чай каркаде с сахаром",200,0.2,{"v":0,"d":"0.0"},{"v":15,"d":"15.0"},58,"ТТК 23А"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",30,2.1,0.6,13.2,66,"23/2022"]
[{"$nulls":3},"закуска","Овощи сезонные порционно (квашеная капуста)",60,0.9,0.1,5.3,26,"т.24/1996"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":540},16.9,17.200000000000003,78.19999999999999,497,null,{"$f":"SUM(L120:L126)","v":136.37}]
[{"$f":"A120","v":2},2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":0},0,0,0,0,null,{"$f":"SUM(L128:L136)","v":0}]
[{"$f":"A120","v":2},2,"Итого за день:",null,null,{"$f":"F127+F137","v":540},16.9,17.200000000000003,78.19999999999999,497,null,{"$f":"L127+L137","v":136.37}]
[2,3,"Завтрак","гор.блюдо","Шницель рубленый куриный",90,11.7,11.2,14.6,189,"622/2022",136.37]
[{"$nulls":3},"гор.блюдо","Рис с овощами",150,3.5,4.6,33.5,180,"665/2022"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,{"v":0,"d":"0.0"},{"v":10,"d":"10.0"},40,"782/2022"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",30,2.1,0.6,13.2,66,"23/2022"]
[{"$nulls":3},"закуска","Овощи сезонные порционно (вареная свекла)",60,0.9,0.1,5.3,26,"т.24/1996"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F145)","v":530},18.4,16.5,76.6,501,null,{"$f":"SUM(L139:L145)","v":136.37}]
[{"$f":"A139","v":2},3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F155)","v":0},0,0,0,0,null,{"$f":"SUM(L147:L155)","v":0}]
[{"$f":"A139","v":2},3,"Итого за день:",null,null,{"$f":"F146+F156","v":530},{"v":18.4,"d":"18"},{"v":16.5,"d":"17"},{"v":76.6,"d":"77"},501,null,{"$f":"L146+L156","v":136.37}]
[2,4,"Завтрак","гор.блюдо","Каша жидкая молочная из рисовой крупы с маслом сливочным",150,6.7,7.6,24.4,156,"182/2017",136.37]
[{"$nulls":3},"гор.напиток","Кофейный напиток злаковый на молоке",200,{"v":3,"d":"3.0"},1.8,{"v":26,"d":"26.0"},124,"774/2022"]
[{"$nulls":3},"хлеб","Бутерброд с повидлом",55,4.4,5.9,27.8,156,"2/2017"]
[{"$nulls":3},"фрукты","Фрукт свежий (яблоко)",100,1.5,0.5,{"v":21,"d":"21.0"},96,"338/2017"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F158:F164)","v":505},15.6,15.8,99.2,532,null,{"$f":"SUM(L158:L164)","v":136.37}]
[{"$f":"A158","v":2},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F174)","v":0},0,0,0,0,null,{"$f":"SUM(L166:L174)","v":0}]
[{"$f":"A158","v":2},4,"Итого за день:",null,null,{"$f":"F165+F175","v":505},15.6,15.8,{"v":99.2,"d":"99"},532,null,{"$f":"L165+L175","v":136.37}]
[2,5,"Завтрак","гор.блюдо","Тефтели (2 вариант) из говядины с соусом сметанным с томатом",90,{"v":10,"d":"10.0"},14.1,21.6,223,"279/2017 331/2017",136.37]
[{"$nulls":3},"гор.блюдо","Каша вязкая гречневая",150,4.7,{"v":5,"d":"5.0"},22.3,169,"303/2017"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,{"v":0,"d":"0.0"},{"v":10,"d":"10.0"},40,"782/2022"]
[{"$nulls":3},"хлеб","Хлеб из муки пшеничной",30,{"v":2,"d":"2.0"},0.6,13.2,66,"23/2022"]
[{"$nulls":3},"закуска","Овощи сезонные порционно (квашеная капуста)",60,0.9,0.1,5.3,26,"т.24/1996"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F177:F183)","v":530},17.799999999999997,19.800000000000004,72.4,524,null,{"$f":"SUM(L177:L183)","v":136.37}]
[{"$f":"A177","v":2},5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":0},0,0,0,0,null,{"$f":"SUM(L185:L193)","v":0}]
[{"$f":"A177","v":2},5,"Итого за день:",null,null,{"$f":"F184+F194","v":530},17.799999999999997,19.800000000000004,72.4,524,null,{"$f":"L184+L194","v":136.37}]
[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":516.5},18.610000000000003,18.706000000000007,78.09,524.4,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":136.36999999999998}]