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

{"sheet":"Лист1","index":0,"n_rows":229,"n_cols":12,"rows_kept":229,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[41,2,41,3],[60,2,60,3],[79,2,79,3],[97,2,97,3],[115,2,115,3],[134,2,134,3],[153,2,153,3],[172,2,172,3],[191,2,191,3],[209,2,209,3],[227,2,227,3],[228,2,228,4]]}
["Школа",null,"МБОУ \"Лицей №2\"",null,null,"Согласовал:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Зелинский Руслан Владимирович"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",2,9,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша молочная \"Дружба\" с маслом",160,5.6,7.6,29.5,209,311]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62,1]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,14.76,75,376]
[{"$nulls":3},"гор.напиток","Чай с лимоном и сахаром",217,0.1,0,9.47,37,686]
[{"$nulls":3},"выпечка","Булочка домашняя",80,5.84,5.84,44.32,286.4,769]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":517},{"$f":"SUM(G6:G11)","v":15.77},{"$f":"SUM(H6:H11)","v":14.639999999999999},{"$f":"SUM(I6:I11)","v":110.35},{"$f":"SUM(J6:J11)","v":669.4},null,66.76]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},0,0,0,null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":517},{"$f":"G12+G22","v":15.77},14.639999999999999,110.35,669.4,null,{"$f":"L12+L22","v":66.76}]
[1,2,"Завтрак","гор.блюдо","Сосиски (халяль) отварные с маслом",110,10,21.7,0.8,238,413]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Компот из кураги",200,1.3,0.1,32.4,130,638]
[{"$nulls":3},"гарнир","Гарнир гречневый ",155,8.7,5.7,37.8,240,297]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F24:F30)","v":525},{"$f":"SUM(G24:G30)","v":24.23},28.7,98.3,745,null,66.76]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},0,0,0,null,0]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":525},{"$f":"G31+G41","v":24.23},28.7,98.3,745,null,66.76]
[1,3,"Завтрак","гор.блюдо","Горбуша, тушенная в томате с овощами",120,23.2,11.6,4.7,216,374]
[{"$nulls":3},"гор.блюдо","Гарнир рисовый ",155,3.58,3.92,36.8,200,297]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Горячий шоколад",200,3.3,3.1,13.6,94,693]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F43:F49)","v":535},{"$f":"SUM(G43:G49)","v":34.31},19.82,82.39999999999999,647,null,66.76]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F51:F59)","v":0},{"$f":"SUM(G51:G59)","v":0},0,0,0,null,0]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F50+F60","v":535},{"$f":"G50+G60","v":34.31},19.82,82.39999999999999,647,null,66.76]
[1,4,"Завтрак","гор.блюдо","Ёжики из говядины с рисом в соусе том.",120,11.4,16.2,13.4,246,462]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",155,5.5,3.92,32.83,192,332]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Компот из смеси сухофруктов",200,0.5,0.1,31.2,121,639]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F68)","v":535},{"$f":"SUM(G62:G68)","v":21.63},21.419999999999998,104.73,696,null,66.76]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F70:F78)","v":0},{"$f":"SUM(G70:G78)","v":0},0,0,0,null,0]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Итого за день:",null,null,{"$f":"F69+F79","v":535},{"$f":"G69+G79","v":21.63},21.419999999999998,104.73,696,null,66.76]
[1,5,"Завтрак","гор.блюдо","Каша манная молочная жидкая с маслом",160,5.4,7.2,26.8,194,311]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Кофейный напиток на молоке",200,3.2,2.8,18.5,109,692]
[{"$nulls":3},"закуска","Сыр порциями",30,6.96,8.85,0,109.2,2004]
[{"$nulls":3},"закуска","Яйцо вареное ",50,6.3,5.3,0.5,78,19555]
[{"$nulls":3},"итого",null,{"$f":"SUM(F81:F86)","v":500},{"$f":"SUM(G81:G86)","v":26.090000000000003},{"$f":"SUM(H81:H86)","v":25.349999999999998},{"$f":"SUM(I81:I86)","v":73.1},{"$f":"SUM(J81:J86)","v":627.2},null,66.76]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F88:F96)","v":0},{"$f":"SUM(G88:G96)","v":0},0,0,0,null,0]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F87+F97","v":500},{"$f":"G87+G97","v":26.090000000000003},25.349999999999998,73.1,627.2,null,66.76]
[1,6,"Завтрак","гор.блюдо","Пельмени мясные отварные с бульоном",250,27.9,14.4,53.5,441,1033]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Компот из компотной смеси (заморож.яг)",200,0.21,0.04,12.3,73,123]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F99:F104)","v":510},{"$f":"SUM(G99:G104)","v":32.339999999999996},{"$f":"SUM(H99:H104)","v":15.639999999999999},{"$f":"SUM(I99:I104)","v":93.1},{"$f":"SUM(J99:J104)","v":651},null,66.76]
[{"$f":"A99","v":1},6,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F114)","v":0},{"$f":"SUM(G106:G114)","v":0},0,0,0,null,{"$f":"SUM(L106:L114)","v":0}]
[{"$f":"A99","v":1},{"$f":"B99","v":6},"Итого за день:",null,null,{"$f":"F105+F115","v":510},{"$f":"G105+G115","v":32.339999999999996},15.639999999999999,93.1,651,null,66.76]
[2,1,"Завтрак","гор.блюдо","Каша пшеничная молочная с маслом",160,5.42,6.08,26.6,178,311]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Чай с лимоном и сахаром",217,0.1,0,9.3,37,686]
[{"$nulls":3},"выпечка","Ватрушка с творогом",80,0.8,4.8,31,209,741]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F117:F123)","v":517},{"$f":"SUM(G117:G123)","v":10.55},12.08,94.2,561,null,66.76]
[{"$f":"A117","v":2},{"$f":"B117","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F125:F133)","v":0},{"$f":"SUM(G125:G133)","v":0},0,0,0,null,{"$f":"SUM(L125:L133)","v":0}]
[{"$f":"A117","v":2},{"$f":"B117","v":1},"Итого за день:",null,null,{"$f":"F124+F134","v":517},{"$f":"G124+G134","v":10.55},12.08,94.2,561,null,66.76]
[2,2,"Завтрак","гор.блюдо","Сосиски (халяль) отварные с маслом",110,10,21.7,0.8,238,413]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",155,5.5,3.92,32.83,192,332]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Напиток из плодов шиповника",200,0.6,0.2,27,111,705]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F136:F142)","v":525},{"$f":"SUM(G136:G142)","v":20.330000000000002},27.019999999999996,87.92999999999999,678,null,66.76]
[{"$f":"A136","v":2},2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F152)","v":0},{"$f":"SUM(G144:G152)","v":0},0,0,0,null,{"$f":"SUM(L144:L152)","v":0}]
[{"$f":"A136","v":2},{"$f":"B136","v":2},"Итого за день:",null,null,{"$f":"F143+F153","v":525},{"$f":"G143+G153","v":20.330000000000002},27.019999999999996,87.92999999999999,678,null,66.76]
[2,3,"Завтрак","гор.блюдо","Горбуша, тушенная в томате с овощами",120,23.2,11.6,4.7,216,374]
[{"$nulls":3},"гор.блюдо","Гарнир рисовый ",155,3.58,3.92,36.8,200,297]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Компот из свежих фруктов",200,0.2,0.1,17.2,68,631]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F155:F161)","v":535},{"$f":"SUM(G155:G161)","v":31.21},16.82,86,621,null,66.76]
[{"$f":"A155","v":2},3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F163:F171)","v":0},{"$f":"SUM(G163:G171)","v":0},0,0,0,null,{"$f":"SUM(L163:L171)","v":0}]
[{"$f":"A155","v":2},{"$f":"B155","v":3},"Итого за день:",null,null,{"$f":"F162+F172","v":535},{"$f":"G162+G172","v":31.21},16.82,86,621,null,66.76]
[2,4,"Завтрак","гор.блюдо","Котлеты из мяса говядины с маслом",155,20.6,18.3,17.5,320,451]
[{"$nulls":3},"гор.блюдо","Пюре гороховое",155,14.7,4.8,34.7,243,107]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Кисель",200,0,0,20,76,648]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F174:F180)","v":570},{"$f":"SUM(G174:G180)","v":39.529999999999994},24.3,99.5,776,null,66.76]
[{"$f":"A174","v":2},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F182:F190)","v":0},{"$f":"SUM(G182:G190)","v":0},0,0,0,null,{"$f":"SUM(L182:L190)","v":0}]
[{"$f":"A174","v":2},{"$f":"B174","v":4},"Итого за день:",null,null,{"$f":"F181+F191","v":570},{"$f":"G181+G191","v":39.529999999999994},24.3,99.5,776,null,66.76]
[2,5,"Завтрак","гор.блюдо","Каша ячневая молочная с маслом",160,5.22,6,26.82,183,302]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Компот из кураги",200,1.3,0.1,32.4,130,638]
[{"$nulls":3},"закуска","Сыр порциями",30,6.96,8.85,0,109.2,2004]
[{"$nulls":3},"закуска","Яйцо вареное ",50,6.3,5.3,0.5,78,19555]
[{"$nulls":3},"итого",null,{"$f":"SUM(F193:F198)","v":500},{"$f":"SUM(G193:G198)","v":24.01},{"$f":"SUM(H193:H198)","v":21.45},{"$f":"SUM(I193:I198)","v":87.02000000000001},{"$f":"SUM(J193:J198)","v":637.2},null,66.76]
[{"$f":"A193","v":2},5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F200:F208)","v":0},{"$f":"SUM(G200:G208)","v":0},0,0,0,null,{"$f":"SUM(L200:L208)","v":0}]
[{"$f":"A193","v":2},{"$f":"B193","v":5},"Итого за день:",null,null,{"$f":"F199+F209","v":500},{"$f":"G199+G209","v":24.01},21.45,87.02000000000001,637.2,null,{"$f":"L199+L209","v":66.76}]
[2,6,"Завтрак","гор.блюдо","Каша гречневая с овощами, мясным фаршем.",200,26.1,25.3,38.6,490,2015]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,1]
[{"$nulls":3},"хлеб","Хлеб ржаной (ржано-пшеничный)",30,1.98,0.33,12.3,62]
[{"$nulls":3},"гор.напиток","Компот из свежих фруктов",200,0.2,0.1,17.2,68,631]
[{"$nulls":3},"закуска","Овощи свежие ( огурцы )",60,0.48,0.06,1.68,9,2015]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F211:F216)","v":520},{"$f":"SUM(G211:G216)","v":31.01},{"$f":"SUM(H211:H216)","v":26.66},{"$f":"SUM(I211:I216)","v":84.78000000000002},{"$f":"SUM(J211:J216)","v":704},null,66.76]
[{"$f":"A211","v":2},6,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F218:F226)","v":0},{"$f":"SUM(G218:G226)","v":0},0,0,0,null,{"$f":"SUM(L218:L226)","v":0}]
[{"$f":"A211","v":2},{"$f":"B211","v":6},"Итого за день:",null,null,{"$f":"F217+F227","v":520},{"$f":"G217+G227","v":31.01},26.66,84.78000000000002,704,null,{"$f":"L217+L227","v":66.76}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F80+F98+F116+F135+F154+F173+F192)/(IF(F23=0,0,1)+IF(F42=0,0,1)+IF(F61=0,0,1)+IF(F80=0,0,1)+IF(F98=0,0,1)+IF(F116=0,0,1)+IF(F135=0,0,1)+IF(F154=0,0,1)+IF(F173=0,0,1)+IF(F192=0,0,1))","v":526.9},{"$f":"(G23+G42+G61+G80+G98+G116+G135+G154+G173+G192)/(IF(G23=0,0,1)+IF(G42=0,0,1)+IF(G61=0,0,1)+IF(G80=0,0,1)+IF(G98=0,0,1)+IF(G116=0,0,1)+IF(G135=0,0,1)+IF(G154=0,0,1)+IF(G173=0,0,1)+IF(G192=0,0,1))","v":25.599000000000004},{"$f":"(H23+H42+H61+H80+H98+H116+H135+H154+H173+H192)/(IF(H23=0,0,1)+IF(H42=0,0,1)+IF(H61=0,0,1)+IF(H80=0,0,1)+IF(H98=0,0,1)+IF(H116=0,0,1)+IF(H135=0,0,1)+IF(H154=0,0,1)+IF(H173=0,0,1)+IF(H192=0,0,1))","v":20.579},{"$f":"(I23+I42+I61+I80+I98+I116+I135+I154+I173+I192)/(IF(I23=0,0,1)+IF(I42=0,0,1)+IF(I61=0,0,1)+IF(I80=0,0,1)+IF(I98=0,0,1)+IF(I116=0,0,1)+IF(I135=0,0,1)+IF(I154=0,0,1)+IF(I173=0,0,1)+IF(I192=0,0,1))","v":92.961},{"$f":"(J23+J42+J61+J80+J98+J116+J135+J154+J173+J192)/(IF(J23=0,0,1)+IF(J42=0,0,1)+IF(J61=0,0,1)+IF(J80=0,0,1)+IF(J98=0,0,1)+IF(J116=0,0,1)+IF(J135=0,0,1)+IF(J154=0,0,1)+IF(J173=0,0,1)+IF(J192=0,0,1))","v":667.1600000000001},null,{"$f":"(L23+L42+L61+L80+L98+L116+L135+L154+L173+L192)/(IF(L23=0,0,1)+IF(L42=0,0,1)+IF(L61=0,0,1)+IF(L80=0,0,1)+IF(L98=0,0,1)+IF(L116=0,0,1)+IF(L135=0,0,1)+IF(L154=0,0,1)+IF(L173=0,0,1)+IF(L192=0,0,1))","v":66.76}]