{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":196,"n_cols":11,"rows_kept":196,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,6,0,9],[1,6,1,9],[23,1,23,2],[42,1,42,2],[61,1,61,2],[80,1,80,2],[99,1,99,2],[118,1,118,2],[137,1,137,2],[156,1,156,2],[175,1,175,2],[194,1,194,2],[195,1,195,3]]}
[null,"МАОУ \"Троельжанская СОШ\"",null,null,"Утвердил:","должность","директор"]
[{"$nulls":5},"фамилия","Мясникова Т.А."]
[null,null,null,"7-11 лет",null,"дата",2,9,2024]
[{"$nulls":6},"день","месяц","год"]
["День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,"Завтрак","гор.блюдо","Курица в томате с овощами /рис отварной/бутерброд с сыром  ",290,20.23,24.72,44.93,484,"405/414/90",85.26]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0,0.6,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,3.6,0.48,21.44,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E6:E12)","v":550},{"$f":"SUM(F6:F12)","v":23.83},{"$f":"SUM(G6:G12)","v":25.8},{"$f":"SUM(H6:H12)","v":81.37},{"$f":"SUM(I6:I12)","v":667},null,{"$f":"SUM(K6:K12)","v":96.26}]
[{"$f":"A6","v":1},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E14:E22)","v":0},0,0,0,0,null,{"$f":"SUM(K14:K22)","v":0}]
[{"$f":"A6","v":1},"Итого за день:",null,null,{"$f":"E13+E23","v":550},23.83,25.8,81.37,667,null,{"$f":"K13+K23","v":96.26}]
[2,"Завтрак","гор.блюдо","Кнели из кур с соусом /каша гречневая/вафли  ",280,19.75,21.1,68.41,542,null,84.01]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0.1,null,15,60,null,5]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,null,7.25]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E25:E31)","v":540},{"$f":"SUM(F25:F31)","v":24.11},{"$f":"SUM(G25:G31)","v":21.7},{"$f":"SUM(H25:H31)","v":108.19},{"$f":"SUM(I25:I31)","v":725},null,{"$f":"SUM(K25:K31)","v":96.26}]
[{"$f":"A25","v":2},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E33:E41)","v":0},0,0,0,0,null,{"$f":"SUM(K33:K41)","v":0}]
[{"$f":"A25","v":2},"Итого за день:",null,null,{"$f":"E32+E42","v":540},24.11,21.7,108.19,725,null,{"$f":"K32+K42","v":96.26}]
[3,"Завтрак","гор.блюдо","Котлета рыбная с соусом /картофельное пюре/печенье ",280,14.07,14.07,47.9,376,"345/435/590",78.26]
[]
[null,null,"гор.напиток","Компот из яблок ",200,0.5,0.2,23.1,96,507,12]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E44:E50)","v":540},{"$f":"SUM(F44:F50)","v":18.83},{"$f":"SUM(G44:G50)","v":14.87},{"$f":"SUM(H44:H50)","v":95.78},{"$f":"SUM(I44:I50)","v":595},null,{"$f":"SUM(K44:K50)","v":96.26}]
[{"$f":"A44","v":3},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E52:E60)","v":0},0,0,0,0,null,{"$f":"SUM(K52:K60)","v":0}]
[{"$f":"A44","v":3},"Итого за день:",null,null,{"$f":"E51+E61","v":540},18.83,14.87,95.78,595,null,{"$f":"K51+K61","v":96.26}]
[4,"Завтрак","гор.блюдо","Фрикадельки из кур/каша ячневая/пряник ",285,16.14,20.26,57.93,468,"410/435/255/589",72.48]
[]
[null,null,"гор.напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,16.35]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,"108/109",7.43]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E63:E69)","v":545},{"$f":"SUM(F63:F69)","v":20.9},{"$f":"SUM(G63:G69)","v":20.86},{"$f":"SUM(H63:H69)","v":109.71},{"$f":"SUM(I63:I69)","v":701},null,{"$f":"SUM(K63:K69)","v":96.26}]
[{"$f":"A63","v":4},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E71:E79)","v":0},0,0,0,0,null,{"$f":"SUM(K71:K79)","v":0}]
[{"$f":"A63","v":4},"Итого за день:",null,null,{"$f":"E70+E80","v":545},20.9,20.86,109.71,701,null,{"$f":"K70+K80","v":96.26}]
[5,"Завтрак","гор.блюдо","Тефтели из говядины с соусом /каша пшенная/вафли",280,17.68,21.34,59.03,499,"388/258/588",81.06]
[]
[null,null,"гор.напиток","Напиток из шиповника",200,0.7,0.3,22.8,97,519,9.2]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E82:E88)","v":540},{"$f":"SUM(F82:F88)","v":22.64},{"$f":"SUM(G82:G88)","v":22.24},{"$f":"SUM(H82:H88)","v":106.61},{"$f":"SUM(I82:I88)","v":719},null,{"$f":"SUM(K82:K88)","v":96.26}]
[{"$f":"A82","v":5},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E90:E98)","v":0},0,0,0,0,null,{"$f":"SUM(K90:K98)","v":0}]
[{"$f":"A82","v":5},"Итого за день:",null,null,{"$f":"E89+E99","v":540},22.64,22.24,106.61,719,null,{"$f":"K89+K99","v":96.26}]
[1,"Завтрак","гор.блюдо","Котлета \"Школьная\" с соусом /макар.изд.отварные/вафли ",280,15.87,10.64,63.31,413,"388/237/590",81.06]
[]
[null,null,"гор.напиток","Чай с лимоном ",200,0.1,null,15.2,61,null,9.2]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,501,6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E101:E107)","v":540},{"$f":"SUM(F101:F107)","v":20.23},{"$f":"SUM(G101:G107)","v":11.24},{"$f":"SUM(H101:H107)","v":103.29},{"$f":"SUM(I101:I107)","v":597},null,{"$f":"SUM(K101:K107)","v":96.26}]
[{"$f":"A101","v":1},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E109:E117)","v":0},0,0,0,0,null,{"$f":"SUM(K109:K117)","v":0}]
[{"$f":"A101","v":1},"Итого за день:",null,null,{"$f":"E108+E118","v":540},20.23,11.24,103.29,597,null,{"$f":"K108+K118","v":96.26}]
[2,"Завтрак","гор.блюдо","Рыба,туш.в томате с овощами/рис отварной/печенье  ",280,14.81,14.16,60.33,432,"343/414/564",73.91]
[]
[null,null,"гор.напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,16.35]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E120:E126)","v":540},{"$f":"SUM(F120:F126)","v":19.57},{"$f":"SUM(G120:G126)","v":14.76},{"$f":"SUM(H120:H126)","v":112.11},{"$f":"SUM(I120:I126)","v":665},null,{"$f":"SUM(K120:K126)","v":96.26}]
[{"$f":"A120","v":2},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E128:E136)","v":0},0,0,0,0,null,{"$f":"SUM(K128:K136)","v":0}]
[{"$f":"A120","v":2},"Итого за день:",null,null,{"$f":"E127+E137","v":540},19.57,14.76,112.11,665,null,{"$f":"K127+K137","v":96.26}]
[3,"Завтрак","гор.блюдо","Фрикадельки из кур с соусом /каша гречневая/бутерброд с сыром ",295,23.33,25.53,53.39,527,"410/435/237/90",82.74]
[]
[null,null,"гор.напиток","Напиток из шиповника",200,0.7,0.3,22.8,97,519,9.2]
[null,null,"хлеб","Хлеб пшеничный ",40,3.04,0.32,19.68,94,108,4.32]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E139:E145)","v":535},{"$f":"SUM(F139:F145)","v":27.07},{"$f":"SUM(G139:G145)","v":26.15},{"$f":"SUM(H139:H145)","v":95.87},{"$f":"SUM(I139:I145)","v":718},null,{"$f":"SUM(K139:K145)","v":96.26}]
[{"$f":"A139","v":3},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E147:E155)","v":0},0,0,0,0,null,{"$f":"SUM(K147:K155)","v":0}]
[{"$f":"A139","v":3},"Итого за день:",null,null,{"$f":"E146+E156","v":535},27.07,26.15,95.87,718,null,{"$f":"K146+K156","v":96.26}]
[4,"Завтрак","гор.блюдо","Жаркое-по домашнему/пряник ",280,30.62,27.15,40.92,530,"369/589",79.65]
[]
[null,null,"гор.напиток","Кофейный напиток ",200,3.2,2.7,15.9,79,501,10.61]
[null,null,"хлеб","Хлеб пшеничный /хлеб ржаной ",60,4.26,0.6,24.78,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E158:E164)","v":540},{"$f":"SUM(F158:F164)","v":38.08},{"$f":"SUM(G158:G164)","v":30.45},{"$f":"SUM(H158:H164)","v":81.6},{"$f":"SUM(I158:I164)","v":732},null,{"$f":"SUM(K158:K164)","v":96.26}]
[{"$f":"A158","v":4},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E166:E174)","v":0},0,0,0,0,null,{"$f":"SUM(K166:K174)","v":0}]
[{"$f":"A158","v":4},"Итого за день:",null,null,{"$f":"E165+E175","v":540},38.08,30.45,81.6,732,null,{"$f":"K165+K175","v":96.26}]
[5,"Завтрак","гор.блюдо","Кнели из кур с соусом /каша ячневая/печенье ",280,19.86,25.62,68.86,585,"411/435/563",76.52]
[]
[null,null,"гор.напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,16.35]
[null,null,"хлеб","Хлеб пшеничный ",30,2.28,0.24,14.76,71,108,3.39]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E177:E183)","v":510},{"$f":"SUM(F177:F183)","v":22.64},{"$f":"SUM(G177:G183)","v":25.86},{"$f":"SUM(H177:H183)","v":110.62},{"$f":"SUM(I177:I183)","v":766},null,{"$f":"SUM(K177:K183)","v":96.26}]
[{"$f":"A177","v":5},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E185:E193)","v":0},0,0,0,0,null,{"$f":"SUM(K185:K193)","v":0}]
[{"$f":"A177","v":5},"Итого за день:",null,null,{"$f":"E184+E194","v":510},22.64,25.86,110.62,766,null,{"$f":"K184+K194","v":96.26}]
[null,"Среднее значение за период:",null,null,{"$f":"(E24+E43+E62+E81+E100+E119+E138+E157+E176+E195)/(IF(E24=0,0,1)+IF(E43=0,0,1)+IF(E62=0,0,1)+IF(E81=0,0,1)+IF(E100=0,0,1)+IF(E119=0,0,1)+IF(E138=0,0,1)+IF(E157=0,0,1)+IF(E176=0,0,1)+IF(E195=0,0,1))","v":538},23.79,21.393,100.515,688.5,null,{"$f":"(K24+K43+K62+K81+K100+K119+K138+K157+K176+K195)/(IF(K24=0,0,1)+IF(K43=0,0,1)+IF(K62=0,0,1)+IF(K81=0,0,1)+IF(K100=0,0,1)+IF(K119=0,0,1)+IF(K138=0,0,1)+IF(K157=0,0,1)+IF(K176=0,0,1)+IF(K195=0,0,1))","v":96.26}]