{"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":196,"n_cols":12,"rows_kept":196,"cut":false,"hidden":false,"merged":[[194,2,194,3],[195,2,195,4],[61,2,61,3],[80,2,80,3],[99,2,99,3],[118,2,118,3],[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[156,2,156,3],[175,2,175,3],[137,2,137,3]]}
["Школа",null,"МБОУ \"Добрушинская средняя школа\"",null,null,"Утвердил:","должность","И.о директора"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Эмир-Аметова Э. Р. "]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",9.0,1.0,2024.0]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1.0,1.0,"Завтрак","гор.блюдо",{"$nulls":7},73.71]
[null,null,null,"гор.блюдо","каша жидкая молочная пшеничная",250.0,10.2,14.8,46.2,361.0,182.0]
[null,null,null,"гор.напиток","какао с молоком",200.0,5.53,4.56,19.7,145.4,382.0]
[null,null,null,"хлеб","хлеб  с маслом сливочным и сыром",40.0,2.45,7.55,14.6,136.0,3.0]
[null,null,null,"фрукты","фрукты свежие",100.0,0.4,0.4,9.8,47.0,338.0]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.24,8.48,42.8,"ПР"]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":"610"},"19.96","27.55","98.78","732.2",null,{"$f":"SUM(L6:L12)","v":"73.71"}]
[{"$f":"A6","v":"1"},"1","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F14:F22)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L14:L22)","v":"0"}]
[{"$f":"A6","v":"1"},"1","Итого за день:",null,null,{"$f":"F13+F23","v":"610"},"19.96","27.55","98.78","732.2",null,{"$f":"L13+L23","v":"73.71"}]
[1.0,2.0,"Завтрак","гор.блюдо","пудинг из печени ",90.0,13.08,15.6,6.8,242.0,283.0,73.71]
[null,null,null,"гарнир","картофельное пюре",150.0,3.36,7.36,28.0,192.0,128.0]
[null,null,null,"гор.напиток","кисель",200.0,0.13,0.05,24.5,117.0,350.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты"]
[null,null,null,"закуска","салат из свеклы отварной/огурец консервированный",60.0,1.1,3.65,5.02,58.34,"52/70"]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[null,null,null,"итого",null,{"$f":"SUM(F25:F31)","v":"550"},"21.42","27.16","87.29","722.28",null,{"$f":"SUM(L25:L31)","v":"73.71"}]
[{"$f":"A25","v":"1"},"2","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F33:F41)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L33:L41)","v":"0"}]
[{"$f":"A25","v":"1"},"2","Итого за день:",null,null,{"$f":"F32+F42","v":"550"},"21.42","27.16","87.29","722.28",null,{"$f":"L32+L42","v":"73.71"}]
[1.0,3.0,"Завтрак","гор.блюдо","тефтели с соусом",110.0,10.7,9.01,10.72,187.0,278.0,73.71]
[null,null,null,"гарнир","каша гречневая вязкая",150.0,4.73,5.17,21.2,150.35,303.0]
[null,null,null,"гор.напиток","чай с сахаром",215.0,0.07,0.02,15.0,60.0,376.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты"]
[null,null,null,"закуска","салат из свежей капусты",60.0,0.8,1.9,3.8,36.0,45.0]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[null,null,null,"итого",null,{"$f":"SUM(F44:F50)","v":"585"},"20.05","16.6","73.69","546.29",null,{"$f":"SUM(L44:L50)","v":"73.71"}]
[{"$f":"A44","v":"1"},"3","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F52:F60)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L52:L60)","v":"0"}]
[{"$f":"A44","v":"1"},"3","Итого за день:",null,null,{"$f":"F51+F61","v":"585"},"20.05","16.6","73.69","546.29",null,{"$f":"L51+L61","v":"73.71"}]
[1.0,4.0,"Завтрак","гор.блюдо","котлета куриная с соусом",90.0,9.28,10.28,10.5,173.0,"294/366",73.71]
[null,null,null,"гарнир","каша вязкая рисовая",150.0,3.7,7.7,26.0,188.0,303.0]
[null,null,null,"гор.напиток","сок фруктовый",200.0,1.0,0.0,20.2,84.8,389.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты"]
[null,null,null,"закуска","винегрет овощной",60.0,0.84,6.0,4.38,75.0,67.0]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[null,null,null,"итого",null,{"$f":"SUM(F63:F69)","v":"550"},"18.57","24.48","84.05","633.74",null,{"$f":"SUM(L63:L69)","v":"73.71"}]
[{"$f":"A63","v":"1"},"4","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F71:F79)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L71:L79)","v":"0"}]
[{"$f":"A63","v":"1"},"4","Итого за день:",null,null,{"$f":"F70+F80","v":"550"},"18.57","24.48","84.05","633.74",null,{"$f":"L70+L80","v":"73.71"}]
[1.0,5.0,"Завтрак","гор.блюдо","пудинг из творога с молоком сгущенным",150.0,21.16,18.4,42.2,419.0,222.0,73.71]
[]
[null,null,null,"гор.напиток","кефир или простокваша",200.0,5.8,5.0,8.0,100.0,386.0]
[null,null,null,"хлеб"]
[null,null,null,"фрукты","фрукты свежие",110.0,0.4,0.4,9.8,47.0,338.0]
[null,null,null,"сладкое","кондитерские изделия",40.0,2.7,3.0,28.8,154.0,"ПР"]
[]
[null,null,null,"итого",null,{"$f":"SUM(F82:F88)","v":"500"},"30.06","26.8","88.8","720",null,{"$f":"SUM(L82:L88)","v":"73.71"}]
[{"$f":"A82","v":"1"},"5","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F90:F98)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L90:L98)","v":"0"}]
[{"$f":"A82","v":"1"},"5","Итого за день:",null,null,{"$f":"F89+F99","v":"500"},"30.06","26.8","88.8","720",null,{"$f":"L89+L99","v":"73.71"}]
[2.0,1.0,"Завтрак","гор.блюдо","каша жидкая молочная манная",250.0,10.2,14.8,46.2,361.0,181.0,73.71]
[]
[null,null,null,"гор.напиток","кофейный напиток с молоком",200.0,4.62,3.93,18.3,127.0,379.0]
[null,null,null,"хлеб","хлеб с маслом сливочным",40.0,2.45,7.55,14.6,136.0,3.0]
[null,null,null,"фрукты","фрукты свежие",100.0,0.4,0.4,9.8,47.0,338.0]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[]
[null,null,null,"итого",null,{"$f":"SUM(F101:F107)","v":"610"},"19.05","26.88","97.38","713.8",null,{"$f":"SUM(L101:L107)","v":"73.71"}]
[{"$f":"A101","v":"2"},"1","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F109:F117)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L109:L117)","v":"0"}]
[{"$f":"A101","v":"2"},"1","Итого за день:",null,null,{"$f":"F108+F118","v":"610"},"19.05","26.88","97.38","713.8",null,{"$f":"L108+L118","v":"73.71"}]
[2.0,2.0,"Завтрак","гор.блюдо",{"$nulls":7},73.71]
[null,null,null,"гарнир","макароны с маслом и сыром",170.0,16.3,13.0,31.47,284.28,203.0]
[null,null,null,"гор.напиток","чай с сахаром",215.0,0.07,0.02,15.0,60.0,376.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты","фрукты свежие",110.0,0.4,0.4,9.8,47.0,338.0]
[]
[null,null,null,"закуска","икра кабачковая",80.0,2.2,5.7,11.6,107.1,73.0]
[null,null,null,"итого",null,{"$f":"SUM(F120:F126)","v":"605"},"21.34","19.42","82.36","568.52",null,{"$f":"SUM(L120:L126)","v":"73.71"}]
[{"$f":"A120","v":"2"},"2","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F128:F136)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L128:L136)","v":"0"}]
[{"$f":"A120","v":"2"},"2","Итого за день:",null,null,{"$f":"F127+F137","v":"605"},"21.34","19.42","82.36","568.52",null,{"$f":"L127+L137","v":"73.71"}]
[2.0,3.0,"Завтрак","гор.блюдо","рагу из овощей",150.0,2.66,6.49,12.9,213.0,143.0,73.71]
[null,null,null,"2 блюдо","омлет натуральный",90.0,8.36,10.9,1.58,174.0,210.0]
[null,null,null,"гор.напиток","чай с сахаром",215.0,0.07,0.02,15.0,60.0,376.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты"]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[null,null,null,"закуска","огурцы консервированные",60.0,0.48,0.1,1.02,6.0,70.0]
[null,null,null,"итого",null,{"$f":"SUM(F139:F145)","v":"565"},"15.32","18.01","53.47","565.94",null,{"$f":"SUM(L139:L145)","v":"73.71"}]
[{"$f":"A139","v":"2"},"3","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F147:F155)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L147:L155)","v":"0"}]
[{"$f":"A139","v":"2"},"3","Итого за день:",null,null,{"$f":"F146+F156","v":"565"},"15.32","18.01","53.47","565.94",null,{"$f":"L146+L156","v":"73.71"}]
[2.0,4.0,"Завтрак","гор.блюдо","фрикадельки рыбные с соусом",90.0,9.2,7.9,6.53,134.44,"240/366",73.71]
[null,null,null,"гарнир","картофельное пюре",150.0,3.36,7.36,28.0,192.0,128.0]
[null,null,null,"гор.напиток","сок фруктовый",200.0,1.0,0.0,20.2,84.8,376.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты"]
[null,null,null,"закуска","салат из свеклы с огурцами солеными",60.0,0.85,3.62,3.77,51.0,55.0]
[null,null,null,"хлеб","хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[null,null,null,"итого",null,{"$f":"SUM(F158:F164)","v":"550"},"18.16","19.38","81.47","575.18",null,{"$f":"SUM(L158:L164)","v":"73.71"}]
[{"$f":"A158","v":"2"},"4","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F166:F174)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L166:L174)","v":"0"}]
[{"$f":"A158","v":"2"},"4","Итого за день:",null,null,{"$f":"F165+F175","v":"550"},"18.16","19.38","81.47","575.18",null,{"$f":"L165+L175","v":"73.71"}]
[2.0,5.0,"Завтрак","гор.блюдо","тефтели с соусом",110.0,10.7,9.01,10.72,187.0,278.0,73.71]
[null,null,null,"гарнир","каша вязкая рисовая",150.0,3.7,7.7,26.0,188.0,303.0]
[null,null,null,"гор.напиток","компот из сухофруктов",200.0,0.66,0.09,32.04,132.8,349.0]
[null,null,null,"хлеб","хлеб пшеничный",30.0,2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"фрукты"]
[null,null,null,"закуска","салат из свежей капусты",60.0,0.8,1.9,3.8,36.0,45.0]
[{"$nulls":4},"хлеб ржаной",20.0,1.38,0.2,8.48,42.8,"ПР"]
[null,null,null,"итого",null,{"$f":"SUM(F177:F183)","v":"570"},"19.61","19.2","95.53","656.74",null,{"$f":"SUM(L177:L183)","v":"73.71"}]
[{"$f":"A177","v":"2"},"5","Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F185:F193)","v":"0"},"0","0","0","0",null,{"$f":"SUM(L185:L193)","v":"0"}]
[{"$f":"A177","v":"2"},"5","Итого за день:",null,null,{"$f":"F184+F194","v":"570"},"19.61","19.2","95.53","656.74",null,{"$f":"L184+L194","v":"73.71"}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F100+F119+F138+F157+F176+F195)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F81=0,0,1)+IF(F100=0,0,1)+IF(F119=0,0,1)+IF(F138=0,0,1)+IF(F157=0,0,1)+IF(F176=0,0,1)+IF(F195=0,0,1))","v":"569.5"},"20.354","22.548","84.282","643.469",null,{"$f":"(L24+L43+L62+L81+L100+L119+L138+L157+L176+L195)/(IF(L24=0,0,1)+IF(L43=0,0,1)+IF(L62=0,0,1)+IF(L81=0,0,1)+IF(L100=0,0,1)+IF(L119=0,0,1)+IF(L138=0,0,1)+IF(L157=0,0,1)+IF(L176=0,0,1)+IF(L195=0,0,1))","v":"73.71"}]