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

{"sheet":"Лист1","index":0,"n_rows":98,"n_cols":12,"rows_kept":98,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[97,2,97,4]]}
["Школа",null,"МБОУ \"Нижнеуратьмнская СОШ НМР РТ",null,null,"Согласование:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Хайруллина Р.Р."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",2,9,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","доп.гарнир","Яйцо вареное",40,5.08,{"v":4.6,"d":"4.60"},0.28,{"v":63,"d":"63.00"}]
[{"$nulls":3},"гор.блюдо","Котлеты Домашние с гречкой",90,{"v":6.4,"d":"6.40"},11.14,35.71,{"v":248,"d":"248.00"}]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным",153,5.68,2.88,31.96,{"v":176.1,"d":"176.10"}]
[{"$nulls":3},"напиток","Чай с молоком и сахаром",200,1.52,1.35,8.92,53.07]
[{"$nulls":3},"хлеб черн.","Хлеб пшеничный ",20,1.52,0.16,9.84,{"v":47,"d":"47.00"}]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":503},{"$f":"SUM(G6:G12)","v":{"v":20.2,"d":"20.20"}},{"$f":"SUM(H6:H12)","v":{"v":20.130000000000003,"d":"20.13"}},{"$f":"SUM(I6:I12)","v":{"v":86.71000000000001,"d":"86.71"}},{"$f":"SUM(J6:J12)","v":{"v":587.1700000000001,"d":"587.17"}},null,80.66]
[1,2,"Завтрак","фрукты","яблоко",100,{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9.8,"d":"9.80"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"гор. блюдо","Запеканка картофельная с птицей",180,13.58,16.26,52.09,{"v":404.1,"d":"404.10"}]
[{"$nulls":3},"напиток","Кофейный напиток с молоком",200,3.17,2.68,9.98,{"v":60.1,"d":"60.10"}]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный ",20,1.52,0.16,9.84,{"v":47,"d":"47.00"}]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F19)","v":500},{"$f":"SUM(G14:G19)","v":{"v":18.669999999999998,"d":"18.67"}},{"$f":"SUM(H14:H19)","v":{"v":19.5,"d":"19.50"}},{"$f":"SUM(I14:I19)","v":{"v":81.71000000000001,"d":"81.71"}},{"$f":"SUM(J14:J19)","v":{"v":558.2,"d":"558.20"}},null,80.66]
[1,3,"Завтрак","хлеб бел.","бутерброд с повидлом",60,2.37,0.87,34.92,153.6]
[{"$nulls":3},"гор.блюдо","Плов из куриной грудки",200,14.42,17.96,26.93,330.5]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном",200,0.13,0.02,8.2,34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F21:F27)","v":500},{"$f":"SUM(G21:G27)","v":19.759999999999998},{"$f":"SUM(H21:H27)","v":19.25},{"$f":"SUM(I21:I27)","v":87.81},{"$f":"SUM(J21:J27)","v":604.72},null,80.66]
[1,4,"Завтрак","хлеб бел.","Хлеб пшеничный с сыром",30,4.15,2.82,11.88,{"$f":"34.33+J33","v":93.72999999999999}]
[{"$nulls":3},"гор.блюдо","Котлеты \"Нежные\" из куриных грудок",90,6.6,12.93,13.79,169.8]
[{"$nulls":3},"гарнир","Каша пшеничная (вязкая) с маслом сливочным",153,6.7,4.38,35.99,227]
[{"$nulls":3},"напиток","Напиток из урюка",200,0.75,0.06,15.95,68.52]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F29:F35)","v":503},{"$f":"SUM(G29:G35)","v":20.18},{"$f":"SUM(H29:H35)","v":20.549999999999997},{"$f":"SUM(I29:I35)","v":89.49},{"$f":"SUM(J29:J35)","v":618.4499999999999},null,80.66]
[1,5,"Завтрак","фрукты","Яблоки",100,0.4,0.4,9.8,47]
[{"$nulls":3},"гор.блюдо","Сырники из творога со сгущенным молоком","150",15.55,18.35,40.33,398.93]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.07,0.02,8,32]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный ",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F37+F38+F39+F40+F41","v":500},{"$f":"G37+G38+G39+G40+G41","v":19.52},19.29,79.85,584.33,null,80.66]
[1,6,"Завтрак","сладкое","Печенье",20,1.48,1.88,5.42,62.14]
[{"$nulls":3},"гор.блюдо","Курица запеченная",90,9.55,9.49,{"v":0,"d":"0.00"},200.66]
[{"$nulls":3},"гарнир","Каша гречневая (вязкая) с маслом сливочным",153,{"v":4.6,"d":"4.60"},7.19,39.56,{"v":165.3,"d":"165.30"}]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном",200,0.13,0.02,{"v":8.2,"d":"8.20"},34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,{"v":0.23999999999999996,"d":"0.24"},{"v":14.759999999999998,"d":"14.76"},{"v":70.5,"d":"70.50"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F51)","v":523},{"$f":"SUM(G45:G51)","v":{"v":20.020000000000003,"d":"20.02"}},{"$f":"SUM(H45:H51)","v":19.18},79.82,592.02,null,80.66]
[2,7,"Завтрак","гор.блюдо","Биточки рыбные",50,6.27,7.86,14.83,155]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным",90,8.58,8.98,16.21,170.2]
[{"$nulls":3},"напиток","Чай с сахаром, с яблоком",153,3.68,2.88,31.96,176.1]
[{"$nulls":3},"хлеб бел.","Бутерброд с маслом сливочным",200,0.11,0.06,8.97,36.68]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.52,0.16,9.84,47]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F53:F59)","v":513},{"$f":"SUM(G53:G59)","v":20.16},{"$f":"SUM(H53:H59)","v":19.939999999999998},{"$f":"SUM(I53:I59)","v":81.81},{"$f":"SUM(J53:J59)","v":584.9799999999999},null,80.66]
[2,8,"Завтрак","фрукты","яблоко",200,{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9.8,"d":"9.80"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"гор.блюдо","Жаркое из птицы (куриных грудок)",100,17.01,18.47,52.76,473.54]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,{"v":8,"d":"8.00"},{"v":32,"d":"32.00"}]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,{"v":47,"d":"47.00"}]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F61:F66)","v":520},{"$f":"SUM(G61:G66)","v":{"v":19,"d":"19.00"}},{"v":19.049999999999997,"d":"19.05"},{"v":80.4,"d":"80.40"},599.54,null,80.66]
[2,9,"Завтрак","гор.блюдо","Котлеты Здоровье из куриных грудок",90,11.2,10.96,24.82,229.63]
[{"$nulls":3},"гарнир","Каша гречневая вязкая с маслом сливочным",153,4.6,7.19,20.56,165.3]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном",200,0.13,0.02,8.2,34.02]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F68:F74)","v":503},{"$f":"SUM(G68:G74)","v":20.19},{"$f":"SUM(H68:H74)","v":18.77},{"$f":"SUM(I68:I74)","v":80.22},{"$f":"SUM(J68:J74)","v":558.85},null,80.66]
[2,10,"Завтрак ","сладкое","Печенье",20,1.48,1.88,5.42,62.14]
[{"$nulls":3},"гор.блюдо","Тефтели  мясные с геркулесом",90,11.4,9.91,24.86,179.59]
[{"$nulls":3},"гарнир","Пюре картофельное  с маслом сливочным",153,3.09,6.98,12.48,157.55]
[{"$nulls":3},"напиток","Сок фруктовый ( нектар плодовый)",200,1,0,20.2,84.8]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный ",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.63,0.03,9.9,33]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F76:F82)","v":508},{"$f":"SUM(G76:G82)","v":20.119999999999997},{"$f":"SUM(H76:H82)","v":18.96},{"$f":"SUM(I76:I82)","v":82.70000000000002},{"$f":"SUM(J76:J82)","v":564.08},null,80.66]
[2,11,"Завтрак","фрукты","Яблоко",100,0.4,0.4,9.8,47]
[{"$nulls":3},"гор.блюдо","Сосиска с томатным соусом , с рисом отварным ",250,12.62,15.31,59.57,426.7]
[{"$nulls":3},"напиток","Какао с молоком",200,4.08,3.54,2.61,58.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный ",20,1.52,0.16,9.84,47]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F88)","v":570},{"$f":"SUM(G84:G88)","v":18.62},19.41,81.82000000000001,579.3,null,{"$f":"SUM(L83:L88)","v":80.66}]
[2,12,"Завтрак","гор.блюдо","Котлета рубленная из куриной грудки",90,9.7,11.63,14.99,209.8]
[{"$nulls":3},"гарнир","Пюре гороховое с маслом сливочным",153,6.09,8.26,30.06,244.95]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,8,32]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.23999999999999996,14.759999999999998,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F91:F95)","v":503},{"$f":"SUM(G91:G95)","v":20.12},20.509999999999998,79.69,616.65,null,{"$f":"SUM(L90:L95)","v":80.66}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F13+F20+F28+F36+F44+F52+F60+F67+F75+F83+F90+F97)/12","v":{"v":512.1666666666666,"d":"512"}},{"v":19.713333333333335,"d":"20"},{"v":19.544999999999998,"d":"20"},{"v":82.66916666666668,"d":"83"},{"v":587.3575,"d":"587"},0]