{"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":[[118,2,118,3],[137,2,137,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],[194,2,194,3],[195,2,195,4],[61,2,61,3],[80,2,80,3],[99,2,99,3]]}
["Школа",null,"МБОУ \"Добрушинская средняя школа\"",null,null,"Утвердил:","должность","И.о директора школы"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","О. Д. Сабуркин"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",12.0,1.0,2026.0]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1.0,1.0,"Завтрак","гор.блюдо","каша жидкая молочная пшеничная","200",8.2,12.0,37.0,289.0,182.0]
[null,null,null,"гор.напиток","какао с молоком","180",5.0,4.1,17.7,131.0,382.0]
[null,null,null,"хлеб","хлеб  с маслом сливочным и сыром","50",5.8,8.3,14.8,172.0,1.0]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"          ПР"]
[null,null,null,"фрукты","фрукты свежие","100",0.4,0.4,9.8,47.0,338.0]
[]
[]
[null,null,null,"итого",null,550.0,{"$f":"SUM(G6:G12)","v":"20.78"},25.04,{"$f":"SUM(I6:I12)","v":"87.78 "},"681.8",null,85.55]
[{"$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":"F108+F23","v":"550"},20.78,25.04,87.78,681.8,null,85.55]
[1.0,2.0,"Завтрак","2 блюдо","пудинг из печени","90",13.08,15.6,6.8,242.0,283.0,85.55]
[null,null,null,"закуска","салат из свеклы отварной /огурец консервированный","60",1.1,3.65,5.02,58.34,"52/70"]
[null,null,null,"гарнир","картофельное пюре ","150",3.36,7.36,28.0,192.0,128.0]
[null,null,null,"хлеб","хлеб пшеничный","30",2.37,0.3,14.49,70.14,"  ПР"]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8," ПР"]
[null,null,null,"гор.напиток","кисель","180",0.12,0.05,22.0,105.3,350.0]
[]
[null,null,null,"итого",null,530.0,{"$f":"SUM(G25:G31)","v":"21.41"},27.2,{"$f":"SUM(I25:I31)","v":"84.79"},"710.58",null,85.55]
[{"$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":"530"},"21.41","27.2","84.79","710.58",null,{"$f":"L32+L42","v":"85.55"}]
[1.0,3.0,"Завтрак","закуска","салат из свежей капусты","60",0.8,1.9,3.8,36.0,45.0]
[null,null,null,"2 блюдо","тефтели с соусом","90",7.7,8.4,8.8,149.0,278.0]
[null,null,null,"гарнир","каша гречневая вязкая","150",4.73,5.17,21.2,150.35,303.0]
[null,null,null,"хлеб","хлеб пшеничный","30",2.37,0.3,14.49,70.14,"          ПР"]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"          ПР"]
[null,null,null,"гор.напиток","чай с сахаром","180",0.06,0.02,12.6,50.2,376.0]
[]
[null,null,null,"итого",null,"530",17.04,16.03,69.37,498.49,null,85.55]
[{"$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":"530"},"17.04","16.03","69.37","498.49",null,{"$f":"L51+L61","v":"85.55"}]
[1.0,4.0,"Завтрак","закуска","винегрет овощной","60",0.84,6.0,4.38,75.0,67.0]
[null,null,null,"гарнир","каша вязкая рисовая ","150",3.7,7.7,26.0,188.0,303.0]
[null,null,null,"2 блюдо","котлета куриная с соусом","90",9.28,10.28,10.5,173.0,"294/366"]
[null,null,null,"напиток","сок фруктовый","200",1.0,0.0,20.2,84.8,389.0]
[null,null,null,"хлеб","хлеб пшеничный","30",2.37,0.3,14.49,70.14,"          ПР"]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"          ПР"]
[]
[null,null,null,"итого",null,550.0,18.57,24.54,84.05,633.74,null,85.55]
[{"$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.54,{"$f":"I70+I80","v":"84.05"},"633.74",null,{"$f":"L70+L80","v":"85.55"}]
[1.0,5.0,"Завтрак","гор.блюдо","пудинг из творога с молоком сгущенным","150",21.16,18.4,42.2,419.0,222.0]
[null,null,null,"сладкое","кондитерские изделия","40",2.7,3.0,28.8,154.0,"ПР"]
[null,null,null,"напиток","кефир или простокваша","205",5.95,5.13,8.2,102.5,386.0]
[null,null,null,"фрукты","фрукты свежие","110",0.4,0.4,9.8,47.0,338.0]
[]
[]
[]
[null,null,null,"итого",null,505.0,{"$f":"SUM(G82:G88)","v":"30.21"},"26.93","89","722.5",null,85.55]
[{"$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":"505"},"30.21","26.93","89","722.5",null,{"$f":"L89+L99","v":"85.55"}]
[2.0,1.0,"Завтрак","гор.блюдо","каша жидкая молочная манная","200",8.2,12.0,37.0,289.0,181.0]
[null,null,null,"гор.напиток","кофейный напиток с молоком ","180",4.16,3.5,16.5,114.3,379.0]
[null,null,null,"хлеб","хлеб с маслом сливочным и сыром","50",5.8,8.3,14.8,172.0,1.0]
[null,null,null,"фрукты","фрукты свежие","100",0.4,0.4,9.8,47.0,338.0]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"ПР"]
[]
[]
[null,null,null,"итого",null,"550",{"$f":"SUM(G101:G107)","v":"19.94"},24.44,{"$f":"SUM(I101:I107)","v":"86.58"},665.1,null,85.55]
[{"$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,550.0,19.94,24.44,86.58,665.1,null,85.55]
[2.0,2.0,"Завтрак","закуска","икра кабачковая","60",1.64,4.3,8.7,80.3,73.0]
[null,null,null,"2 блюдо","макароны отварные /омлет натуральный","240",14.0,16.9,33.05,376.24,"203/210"]
[null,null,null,"хлеб","хлеб пшеничный","30",2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"напиток","сок фруктовый","200",1.0,0.0,20.2,84.8,389.0]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"ПР"]
[]
[]
[null,null,null,"итого",null,550.0,{"$f":"SUM(G120:G126)","v":"20.39"},21.75,{"$f":"SUM(I120:I126)","v":"84.92"},"654.28",null,85.55]
[{"$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":"550"},"20.39","21.75","84.92","654.28",null,{"$f":"L127+L137","v":"85.55"}]
[2.0,3.0,"Завтрак","гор.блюдо","каша жидкая молочная пшенная","250",10.3,15.0,46.0,361.3,182.0]
[null,null,null,"гор.напиток","чай с сахаром","180",0.06,0.02,12.6,50.2,376.0]
[null,null,null,"хлеб","хлеб с маслом сливочным ","40",2.45,7.55,14.6,136.0,3.0]
[null,null,null,"сладкое","кисломолочный продукт","95",2.9,2.5,4.0,50.0,386.0]
[]
[]
[]
[null,null,null,"итого",null,565.0,{"$f":"SUM(G139:G145)","v":"15.71"},25.07,{"$f":"SUM(I139:I145)","v":"77.20 "},"597.5",null,85.55]
[{"$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.71","25.07","77.20 ","597.5",null,{"$f":"L146+L156","v":"85.55"}]
[2.0,4.0,"Завтрак","2 блюдо","рыба припущенная","105",12.0,8.3,6.7,102.4,"227/330"]
[null,null,null,"гарнир","картофельное пюре ","150",3.36,7.36,28.0,192.0,128.0]
[null,null,null,"гор.напиток","чай с сахаром","180",0.06,0.02,12.6,50.2,376.0]
[null,null,null,"хлеб","хлеб пшеничный","30",2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"закуска","салат из свеклы отварной ","60",0.86,3.65,5.02,56.34,52.0]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"          ПР"]
[]
[null,null,null,"итого",null,545.0,{"$f":"SUM(G158:G164)","v":"20.03"},19.87,{"$f":"SUM(I158:I164)","v":"75.29"},"513.88",null,85.55]
[{"$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":"545"},"20.03","19.87","75.29","513.88",null,{"$f":"L165+L175","v":"85.55"}]
[2.0,5.0,"Завтрак","закуска","салат из свежей капусты","60",0.8,1.9,3.8,36.0,45.0]
[null,null,null,"2 блюдо","тефтели с соусом","90",7.7,8.4,8.8,149.0,278.0]
[null,null,null,"гарнир","каша гречневая вязкая","150",4.73,5.17,21.2,150.35,303.0]
[null,null,null,"хлеб","хлеб пшеничный","30",2.37,0.3,14.49,70.14,"ПР"]
[null,null,null,"хлеб","хлеб ржаной","20",1.38,0.2,8.48,42.8,"          ПР"]
[null,null,null,"гор.напиток","компот из сухофруктов","200",0.66,0.09,32.04,132.8,349.0]
[null,null,null,"фрукты","фрукты свежие","110",0.4,0.4,9.8,47.0,338.0]
[null,null,null,"итого",null,660.0,{"$f":"SUM(G177:G183)","v":"18.04"},16.5,{"$f":"SUM(I177:I183)","v":"98.61"},"628.09",null,85.55]
[{"$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,0.0,{"$f":"SUM(G185:G193)","v":"0"},"0","0","0",null,{"$f":"SUM(L185:L193)","v":"0"}]
[{"$f":"A177","v":"2"},"5","Итого за день:",null,null,660.0,{"$f":"G184+G194","v":"18.04"},"16.50 ","98.61","628.09",null,{"$f":"L184+L194","v":"85.55"}]
[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":"553.5"},"20.212","22.737","83.759","630.596",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":"85.55"}]