{"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":170,"n_cols":12,"rows_kept":170,"cut":false,"hidden":false,"merged":[[0,7,0,10],[1,7,1,10],[20,2,20,3],[0,2,0,4],[168,2,168,3],[169,2,169,4],[54,2,54,3],[71,2,71,3],[87,2,87,3],[104,2,104,3],[153,2,153,3],[136,2,136,3],[121,2,121,3],[38,2,38,3]]}
["Школа",null,23,null,null,"Согласовано","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Н.В. Бирюкова"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор. блюдо","Каша вязкая молочная из пшена с маслом","200/10",5.71,8.95,28.25,217.14,173.01]
[null,null,null,"гор. напиток","Кофейный напиток с молоком",200,3.17,2.68,15.95,100.6,379]
[null,null,null,"хлеб","Батон витамин.",65,{"$nulls":4},428]
[{"$nulls":4},"Сыр (порциями)",25,1.25,1.25,null,16.45,15]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G6, G7, G9)","v":10.129999999999999},12.88,44.2,{"$f":"SUM(J6, J7, J9)","v":334.19},null,{"$f":"SUM(L6:L10)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","1 блюдо","Суп-пюре из гороха",200,5.95,3.64,13.28,118.8,21.01]
[{"$nulls":4},"Гренки",20,0.18,0.02,1.1,5.18,371]
[null,null,null,"2 блюдо","Гуляш свинина","60/60",12.44,32.89,3.4,360.44,260]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150,23.94,25.85,107.78,757.01,171]
[null,null,null,"напиток","Компот из смеси сухофруктов ",200,0.66,0.09,32.01,132.8,349]
[null,null,null,"хлеб","Батон витамин.",40,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G12:G19)","v":43.17},{"$f":"SUM(H12:H19)","v":62.49},{"$f":"SUM(I12:I19)","v":157.57},{"$f":"SUM(J12:J19)","v":1374.2299999999998},null,{"$f":"SUM(L12:L19)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F11+F20","v":0},{"$f":"G11+G20","v":53.3},{"$f":"H11+H20","v":75.37},{"$f":"I11+I20","v":201.76999999999998},{"$f":"J11+J20","v":1708.4199999999998},null,{"$f":"L11+L20","v":0}]
[1,2,"Завтрак","гор. блюдо","Зразы рубленные из свинины",90,11.22,30.41,11.46,362.49,274]
[null,null,null,"гарнир","Макаронные изделия отварные с маслом сл.",150,4.55,4.82,25.39,163.09,309]
[null,null,null,"хлеб","Батон витамин.",40,{"$nulls":4},428]
[null,null,null,"гор. напиток","Чай с лимоном","200/7",0.13,0.02,14.69,59.9,377]
[{"$nulls":4},"Икра кабачковая",60,1.01,2.59,5.26,48.17,1]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G22:G28)","v":16.91},{"$f":"SUM(H22:H28)","v":37.84},56.8,633.65,null,{"$f":"SUM(L22:L28)","v":0}]
[{"$f":"A22","v":1},{"$f":"B22","v":2},"Обед","1 блюдо","Борщ с капустой и картофелем на курином бульоне","200/10",2.05,5.82,23.03,152.39,82.02]
[null,null,null,"2 блюдо","Зразы рубленные из свинины",100,12.47,33.79,12.73,402.77,274]
[null,null,null,"гарнир","Макаронные изделия отварные с маслом сливочным",150,4.55,4.82,25.39,163.09,309]
[{"$nulls":4},"Икра кабачковая",100,1.68,4.32,8.77,80.28,1]
[null,null,null,"напиток","Чай с сахаром",200,0.07,0.02,15,60,376]
[null,null,null,"хлеб","Батон витамин.",50,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G30:G37)","v":20.82},{"$f":"SUM(H30:H37)","v":48.77},{"$f":"SUM(I30:I37)","v":84.92},{"$f":"SUM(J30:J37)","v":858.53},null,{"$f":"SUM(L30:L37)","v":0}]
[{"$f":"A22","v":1},{"$f":"B22","v":2},"Итого за день:",null,null,0,{"$f":"G29+G38","v":37.730000000000004},{"$f":"H29+H38","v":86.61000000000001},{"$f":"I29+I38","v":141.72},{"$f":"J29+J38","v":1492.1799999999998},null,{"$f":"L29+L38","v":0}]
[1,3,"Завтрак","гор. блюдо","Каша вязкая молочная ячневая с маслом","200/10",9.06,13.62,48.54,354.11,174.01]
[null,null,null,"гор. напиток","Какао на молоке ",200,6.7,3.4,21,143,382.01]
[null,null,null,"фрукты","Фрукт свежий",1,0.8,0.8,19.6,94,338]
[null,null,null,"хлеб","Батон витамин.",40,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G40:G45)","v":16.560000000000002},{"$f":"SUM(H40:H45)","v":17.82},{"$f":"SUM(I40:I45)","v":89.13999999999999},{"$f":"SUM(J40:J45)","v":591.11},null,{"$f":"SUM(L40:L45)","v":0}]
[{"$f":"A40","v":1},{"$f":"B40","v":3},"Обед","1 блюдо ","Суп картофельный с макаронными изделиями на курином бульоне",200,2.12,2.23,19.38,137.6,103]
[null,null,null,"2 блюдо ","Бедро куриное запечёное",110,18.17,17.28,15.61,258.27,6]
[null,null,null,"гарнир","Рис с овощами",150,3.8,7.14,39.6,237.59,205]
[null,null,null,"напиток","Компот из ягод (заморозка)",200,0.52,0.18,28.86,122.6,388]
[null,null,null,"хлеб","Батон витамин.",50,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G47:G53)","v":24.610000000000003},{"$f":"SUM(H47:H53)","v":26.830000000000002},{"$f":"SUM(I47:I53)","v":103.45},{"$f":"SUM(J47:J53)","v":756.0600000000001},null,{"$f":"SUM(L47:L53)","v":0}]
[{"$f":"A40","v":1},{"$f":"B40","v":3},"Итого за день:",null,null,{"$f":"F46+F54","v":0},{"$f":"G46+G54","v":41.17},{"$f":"H46+H54","v":44.650000000000006},{"$f":"I46+I54","v":192.58999999999997},{"$f":"J46+J54","v":1347.17},null,{"$f":"L46+L54","v":0}]
[1,4,"Завтрак","гор. блюдо","Тефтели 2-й вариант (свин)","60/30",12.03,27.84,20.07,385.47,279]
[null,null,null,"гарнир","Пюре картофельное",150,3.1,4.8,20.5,137.3,312]
[null,null,null,"гор. напиток","Напиток \"Витошка Лайт\"",200,0.07,null,16,65,352.04]
[null,null,null,"хлеб","Батон витамин.",60,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G56:G61)","v":15.2},{"$f":"SUM(H56:H61)","v":32.64},{"$f":"SUM(I56:I61)","v":56.57},{"$f":"SUM(J56:J61)","v":587.77},null,{"$f":"SUM(L56:L61)","v":0}]
[{"$f":"A56","v":1},{"$f":"B56","v":4},"Обед","1 блюдо","Рассольник ленинградский на курином бульоне ","200/10",3.52,3.24,30.11,137.6,137.6]
[null,null,null,"2 блюдо","Суфле из отварной рыбы",120,5.89,14.76,19.15,332.5,332.5]
[null,null,null,"гарнир","Пюре картофельное ",150,3.1,4.8,20.5,137.3,137.3]
[null,null,null,"напиток","Напиток \"Витошка Лайт\"",200,"","",16,65,65]
[null,null,null,"хлеб","Батон витамин. ",60,{"$nulls":4},""]
[]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G63:G70)","v":12.51},{"$f":"SUM(H63:H70)","v":22.8},{"$f":"SUM(I63:I70)","v":85.75999999999999},{"$f":"SUM(J63:J70)","v":672.4000000000001},null,{"$f":"SUM(L63:L70)","v":0}]
[{"$f":"A56","v":1},{"$f":"B56","v":4},"Итого за день:",null,null,0,{"$f":"G62+G71","v":27.71},{"$f":"H62+H71","v":55.44},{"$f":"I62+I71","v":142.32999999999998},{"$f":"J62+J71","v":1260.17},null,{"$f":"L62+L71","v":0}]
[1,5,"Завтрак","гор. блюдо","Запеканка из творога с морковью ",170,23.12,20.06,21.59,358.7,13.05]
[{"$nulls":4},"Молоко сгущенное ",30,2.16,9,16.8,147,2]
[null,null,null,"гор. напиток","Чай с сахаром",200,0.07,0.02,15,60,376]
[null,null,null,"хлеб","Батон витамин.",100,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G73:G77)","v":25.35},{"$f":"SUM(H73:H77)","v":29.08},{"$f":"SUM(I73:I77)","v":53.39},{"$f":"SUM(J73:J77)","v":565.7},null,{"$f":"SUM(L73:L77)","v":0}]
[{"$f":"A73","v":1},{"$f":"B73","v":5},"Обед","1 блюдо","Щи из свежей капусты с картофелем на курином бульоне","200/10",6.14,3.97,17.38,111.46,88.02]
[null,null,null,"2 блюдо","Паста болоньезе с куриным филе",200,26.28,11.47,51.61,416.41,54.15]
[{"$nulls":4},"Икра кабачковая",60,1.01,2.59,5.26,48.17,1]
[null,null,null,"напиток","Напиток из плодов шиповника ",200,0.68,0.28,20.76,88.2,388]
[null,null,null,"хлеб","Батон витамин.",50,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G80:G86)","v":34.11},{"$f":"SUM(H80:H86)","v":18.310000000000002},{"$f":"SUM(I80:I86)","v":95.01},{"$f":"SUM(J80:J86)","v":664.24},null,{"$f":"SUM(L80:L86)","v":0}]
[{"$f":"A73","v":1},{"$f":"B73","v":5},"Итого за день:",null,null,0,{"$f":"G79+G87","v":59.46},{"$f":"H79+H87","v":47.39},{"$f":"I79+I87","v":148.4},{"$f":"J79+J87","v":1229.94},null,{"$f":"L79+L87","v":0}]
[2,1,"Завтрак","гор.блюдо","Каша вязкая молочная пшеничная с маслом","200/10",5.71,8.95,28.25,217.14,173.01]
[{"$nulls":4},"Сыр (порциями)",25,1.25,1.25,null,13.15,15]
[null,null,null,"гор. напиток","Кофейные напиток с молоком",200,3.17,2.68,15.95,100.6,379]
[null,null,null,"хлеб","Батон витамин.",70,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G89:G94)","v":10.129999999999999},{"$f":"SUM(H89:H94)","v":12.879999999999999},{"$f":"SUM(I89:I94)","v":44.2},{"$f":"SUM(J89:J94)","v":330.89},null,{"$f":"SUM(L89:L94)","v":0}]
[{"$f":"A89","v":2},{"$f":"B89","v":1},"Обед","1 блюдо ","Суп-пюре из гороха",200,5.95,3.64,13.28,118.8,21.01]
[{"$nulls":4},"Гренки ",20,0.18,0.02,1.1,5.18,371]
[null,null,null,"2 блюдо","Гуляш свинина","50/50",10.37,27.41,2.83,300.37,260]
[null,null,null,"гарнир","Каша гречневая рассыпчатая ",150,23.94,25.85,107.78,757.01,171]
[null,null,null,"напиток ","Компот из ягод (заморозка)",200,0.52,0.18,28.86,122.6,388]
[null,null,null,"хлеб","Батон витамин.",50]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G96:G103)","v":40.96},{"$f":"SUM(H96:H103)","v":57.1},{"$f":"SUM(I96:I103)","v":153.85000000000002},{"$f":"SUM(J96:J103)","v":1303.96},null,{"$f":"SUM(L96:L103)","v":0}]
[{"$f":"A89","v":2},{"$f":"B89","v":1},"Итого за день:",null,null,0,{"$f":"G95+G104","v":51.09},{"$f":"H95+H104","v":69.98},{"$f":"I95+I104","v":198.05},{"$f":"J95+J104","v":1634.85},null,{"$f":"L95+L104","v":0}]
[2,2,"Завтрак","гор. блюдо","Зразы рубленые из свинины",90,11.22,30.41,11.46,362.49,274]
[null,null,null,"гарнир","Макаронные изделия отварные с маслом сл.","1900-05-29",4.55,4.82,25.39,163.09,309]
[null,null,null,"гор. напиток","Чай с сахаром",200,0.07,0.02,15,60,376]
[null,null,null,"хлеб","Батон витамин.",50,{"$nulls":4},428]
[null,null,null,"фрукты","Фрукт свежий",1,0.8,0.8,19.6,94]
[]
[null,null,null,"итого",null,null,16.64,{"$f":"SUM(H106:H110)","v":36.050000000000004},{"$f":"SUM(I106:I110)","v":71.45},{"$f":"SUM(J106:J110)","v":679.58},null,{"$f":"SUM(L106:L110)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":2},"Обед","1 блюдо","Борщ с капустой и картофелем на курином бульоне","200/10",2.05,5.82,23.03,152.39,82.02]
[null,null,null,"2 блюдо","Зразы рубленые из свинины",90,11.22,30.41,11.46,362.49,274]
[null,null,null,"гарнир","Макаронные изделия отварные с маслом сливочным ",150,4.55,4.82,25.39,163.09,309]
[null,null,null,"напиток","Чай с сахаром ",200,0.07,0.02,15,60,376]
[null,null,null,"хлеб","Батон витамин.",70,{"$nulls":4},428]
[null,null,null,"фрукты ","Фрукт свежий ",1,0.8,0.8,19.6,94]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G113:G119)","v":18.69},{"$f":"SUM(H113:H119)","v":41.870000000000005},{"$f":"SUM(I113:I119)","v":94.47999999999999},{"$f":"SUM(J113:J119)","v":831.97},null,{"$f":"SUM(L113:L119)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":2},"Итого за день:",null,null,{"$f":"F112+F121","v":0},{"$f":"G112+G121","v":35.33},{"$f":"H112+H121","v":77.92000000000002},{"$f":"I112+I121","v":165.93},{"$f":"J112+J121","v":1511.5500000000002},null,{"$f":"L112+L121","v":0}]
[2,3,"Завтрак","гор. блюдо","Омлет натуральный",150,9.48,16.92,1.85,197.11,210]
[{"$nulls":4},"Кукуруза консервированная ",50,7.25,1.5,24.75,144.5,3]
[null,null,null,"гор. напиток","Чай с молоком",200,1.52,1.36,15.9,81,378]
[null,null,null,"хлеб","Батон витамин. ",100,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G123:G128)","v":18.25},{"$f":"SUM(H123:H128)","v":19.78},{"$f":"SUM(I123:I128)","v":42.5},{"$f":"SUM(J123:J128)","v":422.61},null,{"$f":"SUM(L123:L128)","v":0}]
[{"$f":"A123","v":2},{"$f":"B123","v":3},"Обед","1 блюдо","Щи из свежей капусты с картофелем на курином бульоне ","250/10",7.6,4.92,21.52,138,88.02]
[null,null,null,"2 блюдо","Плов с куриным филе ",240,23.31,27.09,74.61,600.93,291]
[null,null,null,"напиток","Напиток\"Витошка Лайт\" ",200,0,0,16,65,352]
[null,null,null,"хлеб","Батон витамин.",60,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G130:G135)","v":30.909999999999997},{"$f":"SUM(H130:H135)","v":32.01},{"$f":"SUM(I130:I135)","v":112.13},{"$f":"SUM(J130:J135)","v":803.93},null,{"$f":"SUM(L130:L135)","v":0}]
[{"$f":"A123","v":2},{"$f":"B123","v":3},"Итого за день:",null,null,0,{"$f":"G129+G136","v":49.16},{"$f":"H129+H136","v":51.79},{"$f":"I129+I136","v":154.63},{"$f":"J129+J136","v":1226.54},null,{"$f":"L129+L136","v":0}]
[2,4,"Завтрак","гор. блюдо","Шницель (свинина)",90,10.56,27.34,10.83,333.84,268.03]
[null,null,null,"гарнир","Рис с овощами ",150,3.8,7.14,39.6,237.59,205]
[null,null,null,"напиток","Компот из смеси сухофруктов",200,0.66,0.09,32.01,132.8,349]
[null,null,null,"хлеб","Батон витамин.",40,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G138:G143)","v":15.02},{"$f":"SUM(H138:H143)","v":34.57},{"$f":"SUM(I138:I143)","v":82.44},{"$f":"SUM(J138:J143)","v":704.23},null,{"$f":"SUM(L138:L143)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":4},"Обед","1 блюдо","Рассольник ленинградский на курином бульоне ","200/10",3.52,3.24,30.11,137.6,96.02]
[null,null,null,"2 блюдо","Тефтели 2 вариант (свин.)","60/30",12.03,27.84,20.07,385.47,279]
[null,null,null,"гарнир","Пюре картофельное ",150,3.1,4.8,20.5,137.3,312]
[null,null,null,"напиток ","Чай с лимоном","200/7",0.13,0.02,14.69,59.9,349]
[null,null,null,"хлеб","Батон витамин.",50,{"$nulls":4},428]
[null,null,null,"овощи","Огурец свежий порционный",60,0.08,0.02,0.2,1.3,71]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G145:G152)","v":18.859999999999996},{"$f":"SUM(H145:H152)","v":35.92},{"$f":"SUM(I145:I152)","v":85.57000000000001},{"$f":"SUM(J145:J152)","v":721.57},null,{"$f":"SUM(L145:L152)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":4},"Итого за день:",null,null,0,{"$f":"G144+G153","v":33.879999999999995},{"$f":"H144+H153","v":70.49000000000001},{"$f":"I144+I153","v":168.01},{"$f":"J144+J153","v":1425.8000000000002},null,{"$f":"L144+L153","v":0}]
[2,5,"Завтрак","гор. блюдо","Запеканка творожная с яблоком ",170,69.32,88,74.69,677.65,223.14]
[{"$nulls":4},"Молоко сгущенное ",30,2.16,9,16.8,147,2]
[null,null,null,"гор. напиток","Чай с сахаром ",200,0.07,0.02,15,60,376]
[null,null,null,"хлеб","Батон витамин.",100,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G155:G159)","v":71.54999999999998},{"$f":"SUM(H155:H159)","v":97.02},{"$f":"SUM(I155:I159)","v":106.49},{"$f":"SUM(J155:J159)","v":884.65},null,{"$f":"SUM(L155:L159)","v":0}]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Обед","1 блюдо","Суп картофельный с макаронными изделиями на курином бульоне ",200,2.12,2.23,19.39,137.6,103.03]
[null,null,null,"2 блюдо","Каша \"Царская\" с филе куриным",240,22.76,16.97,93.96,725.55,44.03]
[null,null,null,"напиток","Компот из клубники",200,0.2,1,7.4,39,54.09]
[null,null,null,"хлеб","Батон витамин.",60,{"$nulls":4},428]
[]
[]
[null,null,null,"итого",null,null,{"$f":"SUM(G162:G167)","v":25.080000000000002},{"$f":"SUM(H162:H167)","v":20.2},{"$f":"SUM(I162:I167)","v":120.75},{"$f":"SUM(J162:J167)","v":902.15},null,{"$f":"SUM(L162:L167)","v":0}]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Итого за день:",null,null,0,{"$f":"G161+G168","v":96.62999999999998},{"$f":"H161+H168","v":117.22},{"$f":"I161+I168","v":227.24},{"$f":"J161+J168","v":1786.8},null,{"$f":"L161+L168","v":0}]
[null,null,"Среднее значение за период:",null,null,0,{"$f":"(G21+G39+G55+G72+G88+G105+G122+G137+G154+G169)/(IF(G21=0, 0, 1)+IF(G39=0, 0, 1)+IF(G55=0, 0, 1)+IF(G72=0, 0, 1)+IF(G88=0, 0, 1)+IF(G105=0, 0, 1)+IF(G122=0, 0, 1)+IF(G137=0, 0, 1)+IF(G154=0, 0, 1)+IF(G169=0, 0, 1))","v":48.54600000000001},{"$f":"(H21+H39+H55+H72+H88+H105+H122+H137+H154+H169)/(IF(H21=0, 0, 1)+IF(H39=0, 0, 1)+IF(H55=0, 0, 1)+IF(H72=0, 0, 1)+IF(H88=0, 0, 1)+IF(H105=0, 0, 1)+IF(H122=0, 0, 1)+IF(H137=0, 0, 1)+IF(H154=0, 0, 1)+IF(H169=0, 0, 1))","v":69.686},{"$f":"(I21+I39+I55+I72+I88+I105+I122+I137+I154+I169)/(IF(I21=0, 0, 1)+IF(I39=0, 0, 1)+IF(I55=0, 0, 1)+IF(I72=0, 0, 1)+IF(I88=0, 0, 1)+IF(I105=0, 0, 1)+IF(I122=0, 0, 1)+IF(I137=0, 0, 1)+IF(I154=0, 0, 1)+IF(I169=0, 0, 1))","v":174.067},{"$f":"(J21+J39+J55+J72+J88+J105+J122+J137+J154+J169)/(IF(J21=0, 0, 1)+IF(J39=0, 0, 1)+IF(J55=0, 0, 1)+IF(J72=0, 0, 1)+IF(J88=0, 0, 1)+IF(J105=0, 0, 1)+IF(J122=0, 0, 1)+IF(J137=0, 0, 1)+IF(J154=0, 0, 1)+IF(J169=0, 0, 1))","v":1462.3419999999999},null,0]