{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":198,"n_cols":12,"rows_kept":198,"cut":false,"hidden":false,"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],[100,2,100,3],[119,2,119,3],[138,2,138,3],[158,2,158,3],[177,2,177,3],[196,2,196,3],[197,2,197,4]]}
["Школа",{"$nulls":4},"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Симисинова Т.Б."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",null,null,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша пшенная молочная с маслом сливочным","230/10",6.46,5.33,"32, 80",205.35,"262/ 96"]
[{"$nulls":4},"Сыр порционно",10,"2, 60","2, 70",0,35,"5/13"]
[null,null,null,"гор.напиток","Какао с молоком",200,3.9,3.5,22.9,138,"642/96"]
[null,null,null,"хлеб","Батон нарезной",50,"3, 75","1, 45","25, 70",131,"ттк115"]
[null,null,null,"фрукты"]
[{"$nulls":4},"Масло сливочное",10,"0, 08","7, 25","0, 13","66, 10","ттк109"]
[]
[null,null,null,"итого",null,500,"16, 80","20, 23","81, 53","576, 95"]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[null,null,null,"1 блюдо","Щи из свежей капусты с мясом и сметаной",200,"4, 24",4,"15, 84",116," 120/96"]
[null,null,null,"2 блюдо","Индейка по строгановски",100,"13, 41","19, 81","3, 88","243, 30","ТТК-87"]
[null,null,null,"гарнир","Макароны отварные ",150,5.3,3.8,32.4,184.99,"273/96"]
[null,null,null,"напиток","Кисель витамин.\"Витошка\"",200,0,0,25,"97, 36","ТТК-88"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 42","0, 54","18, 90","99, 45","ттк110"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 30","11, 62",53,"ттк114"]
[]
[]
[null,null,null,"итого",null,700,"28, 32","28, 45","107, 65","794, 10",null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,1550,"51, 47","53, 34","237, 33",1619.9,null,{"$f":"L13+L23","v":0}]
[1,2,"Завтрак","гор.блюдо","Запеканка творожная с рисом с молоком сгущенным","200/10","30, 45",20.79,"44, 94",496.2,".14/5"]
[{"$nulls":4},"Кондитерское изделие",20,0.74,3.22,13.98,88,"пром"]
[null,null,null,"гор.напиток","Кофейный напиток на молоке",200,3,"2, 90","13, 40",89,"ТК103"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[{"$nulls":4},"Сыр порционно",10,2.6,2.7,0,35,".5/13"]
[]
[null,null,null,"итого",null,500,40.54,31.06,98.02,840.7,null,{"$f":"SUM(L25:L31)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска","Омлет запеченный с сыром",100,"11, 58","12, 98","1, 5","168, 33","285/96"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо","Шницель из мяса говядины",90,12.78,12.51,5.76,186.3,"416/96"]
[null,null,null,"гарнир","Капуста тушеная",150,3.4,2.9,13.6,94,"482/96"]
[null,null,null,"напиток","Компот из сухофруктов",200,0.5,0,20.1,83,"588/96"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,1.95,0.3,11.63,53,"ттк114"]
[null,null,null,"фрукты","Фрукт свежий",100,"1, 5","0, 50",21,96,"ТТК"]
[]
[null,null,null,"итого",null,705,35.13,22.77,92.49,780.25,null,{"$f":"SUM(L33:L41)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,1505,86.8,68.06,235.11,1957.61,null,{"$f":"L32+L42","v":0}]
[1,3,"Завтрак","гор.блюдо","Каша гречневая молочная с маслом сливочным","230/10",8.28,7.59,33.69,207,"262/96"]
[{"$nulls":4},"Яйцо отварное",40,"5, 10","4, 60","0, 30",63,".1/ 6"]
[null,null,null,"гор.напиток","Чай с молоком",200,1.4,1.6,16.4,86,"ттк-111"]
[null,null,null,"хлеб","Батон нарезной",50,"3, 75","1, 45","25, 70",131,"ТТК115"]
[null,null,null,"фрукты"]
[{"$nulls":4},"Масло сливочное",10,"0, 08","7, 25","0, 13","66, 10","1/13"]
[]
[null,null,null,"итого",null,510,18.61,22.49,76.22,554.6,null,{"$f":"SUM(L44:L50)","v":0}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска"]
[null,null,null,"1 блюдо","Рассольник Ленинградский с мясом и сметаной",200,"5, 28","7, 84","19, 65","97, 28","129/96"]
[null,null,null,"2 блюдо","Рыба запеченная под молочным соусом",120,13.1,14.54,17.35,250.27,"320/96"]
[null,null,null,"гарнир","Картофельное пюре ",150,3.09,4.2,"20, 60",133,"472/96"]
[null,null,null,"напиток","Напиток из шиповника",200,0.2,0.1,18.3,75,"20/ 10"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[]
[]
[null,null,null,"итого",null,735,27.04,27.52,106.43,708,null,{"$f":"SUM(L52:L60)","v":0}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,1565,57.28,58.95,235.97,1602.16,null,{"$f":"L51+L61","v":0}]
[1,4,"Завтрак","гор.блюдо","Омлет натуральный",80,7.81,10.5,1.4,131]
[{"$nulls":4},"Кондитерское изделие",50,3.1,1.2,22.95,109,"пром"]
[null,null,null,"гор.напиток","Какао с молоком",200,3.9,3.5,22.9,138,"ттк103"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[{"$nulls":4},"Картофель запеченный из варенного",120,2.88,10,22.8,138,"10/3л"]
[]
[null,null,null,"итого",null,500,21.44,26.65,95.75,648.5,null,{"$f":"SUM(L63:L69)","v":0}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска","Салат из св.кап.и св.огурцов и м/р",60,0.78,3,2.16,39,"2025-01-13"]
[null,null,null,"1 блюдо","Суп картофельный с бобовыми и м/г",200,1.6,5.6,8.4,91.2,"138/96"]
[null,null,null,"2 блюдо","Плов ",250,"18, 50","20, 60","43, 20",432,"403/96"]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Напиток лимонный",200,0,0,"0, 10",32,"646/96"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[null,null,null,"фрукты"]
[]
[null,null,null,"итого",null,775,25.47,31.04,82.23,778.65,null,{"$f":"SUM(L71:L79)","v":0}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,1575,60.97,72.39,212.84,1762.55,null,{"$f":"L70+L80","v":0}]
[1,5,"Завтрак","гор.блюдо","Каша молочная герклесовая с м/сл.","230/10",8.18,8.51,31.28,231.15,"262/96"]
[{"$nulls":4},"Сыр порционно",10,2.6,2.7,0,35,"2013-05-01"]
[null,null,null,"гор.напиток","Кофейный напиток на молоке",200,3,2.9,13.4,63,"629/96"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,500,17.53,15.56,70.38,487.65,null,{"$f":"SUM(L82:L88)","v":0}]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп -пюре из разных овощей ",200,2.64,3.6,9.83,84.16,"167/96"]
[{"$nulls":4},"Гренки ",20,"1, 70","0, 20","10, 80",51,"36/2"]
[null,null,null,"2 блюдо","Цыпленок тушенный в соусе",100,16.2,17,2.7,253.53,"ттк-67"]
[null,null,null,"гарнир","Каша гречневая рассыпчатая с овощами",150,"8, 60","6, 80","37, 80",247,"59/ 3"]
[null,null,null,"напиток","Компот из кураги",200,0.3,0,17.9,73,"ттк85"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[]
[]
[null,null,null,"итого",null,735,34.81,28.44,218.34,857.78,null,{"$f":"SUM(L90:L99)","v":0}]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,1540,65.04,54.83,338.75,1763.58,null,{"$f":"L89+L100","v":0}]
[2,1,"Завтрак","гор.блюдо","Каша пшенная молочная с маслом сливочным",200,"6, 49",6,"31, 20",205,"262/96"]
[{"$nulls":4},"Омлет с сыром",60,"9, 80","17, 82","1, 56",205,"257/ 96"]
[null,null,null,"гор.напиток","Чай с молоком",200,"1, 40","1, 40","11, 20",63,"ттк111"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,510,"21, 44","26, 67","69, 66",605.7,null,{"$f":"SUM(L102:L108)","v":0}]
[{"$f":"A102","v":2},{"$f":"B102","v":1},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп картофельный с рыбой","200/ 10","7, 20",4,"12, 96","101, 71","20/2"]
[null,null,null,"2 блюдо","Гуляш",100,14.1,"15, 70","4, 70",220,"401/ 96"]
[null,null,null,"гарнир","Макароны отварные",150,"5, 29","4, 63","32, 40","184, 99","469/ 96"]
[null,null,null,"напиток","Сок фруктовый",200,1,0,25,110,"ттк116"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[]
[]
[null,null,null,"итого",null,730,32.96,25.17,105.99,705,null,{"$f":"SUM(L110:L118)","v":0}]
[{"$f":"A102","v":2},{"$f":"B102","v":1},"Итого за день:",null,null,1540,58.3,61.94,238.65,1660.3,null,{"$f":"L109+L119","v":0}]
[2,2,"Завтрак","гор.блюдо","Каша манная молочная с маслом сливочным",200,"5, 30","5, 10","27, 50",177,"262/96"]
[{"$nulls":4},"Сыр порционно",10,"3, 90","4, 05",0,35,"5/13"]
[null,null,null,"гор.напиток","Какао с молоком",200,3.9,3.5,22.9,138,"ттк103"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[{"$nulls":4},"Кондитерское изделие (конфета)",40,"1, 47","6, 44","27, 96",176]
[]
[null,null,null,"итого",null,500,17.02,19.19,104.06,658.5,null,{"$f":"SUM(L121:L127)","v":0}]
[{"$f":"A121","v":2},{"$f":"B121","v":2},"Обед","закуска","Запеканка из творога с м/сгущ","100/20",13.5,11.8,28.7,277.4,"297/96"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо","Суфле Рыбка",100,13.9,11.7,9.56,198,"43/03"]
[null,null,null,"гарнир","Картофельное пюре",150,2.9,4.2,"21, 90",137,"2025-03-01"]
[null,null,null,"напиток","Компот из св/м ягод",200,"0, 60","0, 20","27, 40",107,"ттк81"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[null,null,null,"фрукты","Фрукт свежий ",100,"1, 50","0, 50","18, 20","83, 20","ТТК"]
[]
[null,null,null,"итого",null,775,37.86,29.44,136.9,969.85,null,{"$f":"SUM(L129:L137)","v":0}]
[{"$f":"A121","v":2},{"$f":"B121","v":2},"Итого за день:",null,null,1575,64.98,59.93,288.76,1962.15,null,{"$f":"L128+L138","v":0}]
[2,3,"Завтрак","гор.блюдо","Пудинг из творого с молоком сгущенным","100/20","14, 60","10, 50","20, 90",236,"296/96"]
[{"$nulls":4},"Йогурт молочный",125,5.1,3.1,7.3,71.25,"пром"]
[]
[null,null,null,"гор.напиток","Кофейный напиток на молоке",200,3,2.9,13.4,91,"ттк-103"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,500,26.45,17.95,66.9,530.75,null,{"$f":"SUM(L140:L147)","v":0}]
[{"$f":"A140","v":2},{"$f":"B140","v":3},"Обед","закуска"]
[null,null,null,"1 блюдо","Борщ с мясом и сметаной",200,"1, 84","4, 72","14, 41","91, 20","110/96"]
[null,null,null,"2 блюдо","Колбаски \"Витаминные\"",90,11.79,13.86,2.83,225.9,"64/ 03"]
[null,null,null,"гарнир","Рис, припущенный с овощами",150,"3, 79","5, 79","38, 11","220, 50","36/ 03"]
[null,null,null,"напиток","Кисель витаминный \"Витошка\"",200,0,0,25,"97, 60","ттк88"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[]
[]
[null,null,null,"итого",null,800,23.41,25.22,110.88,787.65,null,{"$f":"SUM(L149:L157)","v":0}]
[{"$f":"A140","v":2},{"$f":"B140","v":3},"Итого за день:",null,null,1600,62.26,53.17,242.35,1714.4,null,{"$f":"L148+L158","v":0}]
[2,4,"Завтрак","гор.блюдо","Каша ассорти (рис, пшено) молочная с маслом сливочным",200,"7, 20","5, 18","44, 56",254,"35/ 03"]
[{"$nulls":4},"Яйцо отварное",40,5.1,4.6,0.3,63,"1/ 6"]
[null,null,null,"гор.напиток","Чай с молоком",200,1.4,1.4,11.2,63,"ттк111"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[{"$nulls":4},"Масло сливочное",10,"0, 06","5, 80","0, 10","52, 80","1/ 13"]
[]
[null,null,null,"итого",null,500,17.51,18.43,81.86,565.3,null,{"$f":"SUM(L160:L166)","v":0}]
[{"$f":"A160","v":2},{"$f":"B160","v":4},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп картофельный с мак.изд и м/птицы",200,"2, 60",3.4,20,"107, 20","148/96"]
[null,null,null,"2 блюдо","Биточки по - белорусски",90,"19, 60","16, 16","1, 30",241,"16/ 8"]
[null,null,null,"гарнир","Рагу овощное ",150,0.99,3.69,13.5,96.99,"4/10"]
[null,null,null,"напиток","Компот из кураги с изюмом",200,"0, 60",0,"20, 20",164,"4/10"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[null,null,null,"Фрукт"]
[]
[null,null,null,"итого",null,710,29.16,24.09,85.53,761.64,null,{"$f":"SUM(L168:L176)","v":0}]
[{"$f":"A160","v":2},{"$f":"B160","v":4},"Итого за день:",null,null,1610,57.27,52.42,226.54,1803.74,null,{"$f":"L167+L177","v":0}]
[2,5,"Завтрак","гор.блюдо","Макароны, запеченные с яйцом",270,11.37,15.53,38.34,337.5,"20/4"]
[]
[null,null,null,"гор.напиток","Какао с молоком",200,3.9,3.5,22.9,138,"642/96"]
[null,null,null,"хлеб","Батон \"нарезной\"",50,"3, 75","1, 45","25, 70",131,"тк115"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F179:F185)","v":520},19.02,20.48,86.94,608,null,{"$f":"SUM(L179:L185)","v":0}]
[{"$f":"A179","v":2},{"$f":"B179","v":5},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп картофельный с макароннными изделиями и мясом птицы",200,"3, 2","4, 89","21, 8",114,"139/96"]
[null,null,null,"2 блюдо","Бифщтекс \"Оригинал\"",90,15.23,11.93,4.74,187.5,"ТТК52"]
[null,null,null,"гарнир","Каша гречнивая рассыпчатая с овощами",150,8.6,6.8,37.8,247,"59/3"]
[null,null,null,"напиток","Напиток из шиповника",200,"0, 20","0, 10","18, 30",75,"20/ 10"]
[null,null,null,"хлеб бел.","Хлеб \"Крестьянский\"",45,"3, 5","0, 54","18, 90","99, 45","ттк113"]
[null,null,null,"хлеб черн.","Хлеб \"Чусовской\"",25,"1, 95","0, 90","11, 62","80, 50","ттк114"]
[]
[]
[null,null,null,"итого",null,765,33.1,24.86,115,785.95,null,{"$f":"SUM(L187:L195)","v":0}]
[{"$f":"A179","v":2},{"$f":"B179","v":5},"Итого за день:",null,null,1585,57.92,53.74,256.64,1788.23,null,{"$f":"L186+L196","v":0}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F101+F120+F139+F159+F178+F197)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F81=0,0,1)+IF(F101=0,0,1)+IF(F120=0,0,1)+IF(F139=0,0,1)+IF(F159=0,0,1)+IF(F178=0,0,1)+IF(F197=0,0,1))","v":1564.5}]