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

{"sheet":"Лист1","index":0,"n_rows":176,"n_cols":12,"rows_kept":176,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[21,2,21,3],[38,2,38,3],[55,2,55,3],[72,2,72,3],[89,2,89,3],[106,2,106,3],[123,2,123,3],[140,2,140,3],[157,2,157,3],[174,2,174,3],[175,2,175,4]]}
["Школа",null,"МБОУ \"СОШ №27\"",null,null,"Согласование:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Шарапов Р.С."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,9,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","хлеб бел.","Бутерброд с маслом","40",2.36,7.49,14.89,136,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","75",5.6,2.16,38.36,195.52]
[{"$nulls":3},"гор.блюдо","Каша \"Дружба\" молочная с маслом сливочным","185",10.48,10.43,25.24,217.4]
[{"$nulls":3},"гор.напиток","Чай с сахаром и лимоном","200",0.13,0.02,8.2,34.02]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F6+F7+F8+F9","v":"500"},{"$f":"SUM(G6:G11)","v":"18.57"},"20.1","86.69","582.94",null,{"$f":"SUM(L6:L11)","v":"37.55"}]
[{"$f":"A6","v":"1"},"1","Обед","1 блюдо","Щи из свежей капусты с картофелем, со сметаной",205,3.74,14.71,6.5,79.9,null,77.59]
[{"$nulls":3},"2 блюдо","Шницель куриный",90,10.53,10.02,5.13,195.51]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным",153,5.78,1.28,42.96,226.1]
[{"$nulls":3},"напиток","Напиток из сухофруктов",200,0.7,0.1,32,132.8]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",45,2.97,0.54,17.82,89.1]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F13:F20)","v":"718"},"25.62","26.85","116.71","782.16",null,{"$f":"SUM(L13:L20)","v":"77.59"}]
[{"$f":"A6","v":"1"},"1","Итого за день:",null,null,{"$f":"F12+F21","v":"1218"},"44.19","46.95","203.4","1365.1",null,{"$f":"L12+L21","v":"115.14"}]
[1,2,"Завтрак","хлеб бел.","Бутерброд с сыром и маслом сливочным","50",6.27,7.86,14.83,155,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","50",3.75,1.45,25.7,131]
[{"$nulls":3},"гор.блюдо","Каша геркулнсовая молочная","200",6.23,6.86,32,215]
[{"$nulls":3},"гор.напиток","Кофейный напиток с молоком","200",3.17,2.68,9.98,60.1]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F23+F24+F25+F26","v":"500"},{"$f":"SUM(G23:G28)","v":"19.42"},"18.85","82.51","561.1",null,{"$f":"SUM(L23:L28)","v":"37.55"}]
[{"$f":"A23","v":"1"},"2","Обед","1 блюдо","Рассольник Ленинградский со сметаной",205,7.74,12.82,9.76,143.9,null,77.59]
[{"$nulls":3},"2 блюдо","Овощи тушенные с мясом",200,12.69,13.53,44.88,363.45]
[{"$nulls":3},"доп.гарнир","Горошек консервированный",30,0.87,0.82,1.74,17.76]
[{"$nulls":3},"напиток","Напиток из изюма и яблок",200,0.38,0.13,29.3,119.94]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",35,2.66,0.28,17.22,82.25]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.78,0.32,10.69,53.46]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F30:F37)","v":"700"},"26.12","27.9","113.59","780.76",null,{"$f":"SUM(L30:L37)","v":"77.59"}]
[{"$f":"A23","v":"1"},"2","Итого за день:",null,null,{"$f":"F29+F38","v":"1200"},"45.54","46.75","196.1","1341.86",null,{"$f":"L29+L38","v":"115.14"}]
[1,3,"Завтрак","фрукты","Яблоки","100",0.4,0.4,9.8,47,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","50",3.75,1.45,25.7,131]
[{"$nulls":3},"гор.блюдо","Каша молочная гречневая с маслом сливочным","153",14.78,17.48,36.21,375.05]
[{"$nulls":3},"гор.напиток","Чай с сахаром ","200",0.07,0.02,8,32]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F40+F41+F42+F43","v":"503"},{"$f":"SUM(G40:G45)","v":"19"},"19.35","79.71","585.05",null,{"$f":"SUM(L40:L45)","v":"37.55"}]
[{"$f":"A40","v":"1"},"3","Обед","1 блюдо","Суп-лапша домашняя с картофелем",200,5.05,5.43,9.3,92.6,null,77.59]
[{"$nulls":3},"2 блюдо","Плов из куриной грудки",200,14.42,18.43,40.93,370.5]
[{"$nulls":3},"доп.гарнир","Кукуруза консервированная",30,0.86,1.85,2.41,29.79]
[{"$nulls":3},"напиток","Кисель",200,0.6,0.1,30.2,143.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",45,2.97,0.54,17.82,89.1]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F47:F54)","v":"700"},"25.8","26.55","112.96","784.34",null,{"$f":"SUM(L47:L54)","v":"77.59"}]
[{"$f":"A40","v":"1"},"3","Итого за день:",null,null,{"$f":"F46+F55","v":"1203"},"44.8","45.9","192.67","1369.39",null,{"$f":"L46+L55","v":"115.14"}]
[1,4,"Завтрак","сладкое","Печенье","50",3.7,4.7,16.55,203.5,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","65",4.87,1.88,33.38,170.13]
[{"$nulls":3},"гор.блюдо","Каша пшенная молочная вязкая с маслом сливочным","185",9.91,12.46,28.73,201.94]
[{"$nulls":3},"гор.напиток","Какао с молоком","200",0.07,0.02,7.85,29.8]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F57+F58+F59+F60","v":"500"},{"$f":"SUM(G57:G62)","v":"18.55"},"19.06","86.51","605.37",null,{"$f":"SUM(L57:L62)","v":"37.55"}]
[{"$f":"A57","v":"1"},"4","Обед","1 блюдо","Борщ из свежей капусты с картофелем",250,8.8,7.92,40.93,223.75,null,77.59]
[{"$nulls":3},"2 блюдо","Запеканка картофельная с мясом",180,13.19,19.59,28.15,340.09]
[{"$nulls":3},"доп.гарнир","Салат из моркови с сахаром",60,0.74,0.06,6.89,49.02]
[{"$nulls":3},"напиток","Напиток из шиповника",200,0.66,0.09,20.04,84.8]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.5,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F64:F71)","v":"730"},"26.21","28.06","113.77","784.26",null,{"$f":"SUM(L64:L71)","v":"77.59"}]
[{"$f":"A57","v":"1"},"4","Итого за день:",null,null,{"$f":"F63+F72","v":"1230"},"44.76","47.12","200.28","1389.63",null,{"$f":"L63+L72","v":"115.14"}]
[1,5,"Завтрак","фрукты","Апельсины","100",0.9,0.2,8.1,43,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","50",3.75,1.45,25.7,131]
[{"$nulls":3},"гор.блюдо","Каша кукурузная молочная","180",13.59,17.75,43.31,350.2]
[{"$nulls":3},"гор.напиток","Чай с сахаром и лимоном","200",0.13,0.02,8.2,34.02]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F74+F75+F76+F77","v":"530"},{"$f":"SUM(G74:G79)","v":"18.37"},"19.42","85.31","558.22",null,{"$f":"SUM(L74:L79)","v":"37.55"}]
[{"$f":"A74","v":"1"},"5","Обед","1 блюдо","Суп гороховый с гренками",210,7.49,14.58,40.36,278.62,null,77.59]
[{"$nulls":3},"2 блюдо","Птица тушеная в сметанно-томатном соусе",100,11.65,11.66,3.51,166]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом",153,5.78,1.28,42.96,226.1]
[{"$nulls":3},"напиток","Компот из свежих яблок",200,0.16,0.16,10.91,46.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.5,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F81:F88)","v":"703"},"27.9","28.08","115.5","803.92",null,{"$f":"SUM(L81:L88)","v":"77.59"}]
[{"$f":"A74","v":"1"},"5","Итого за день:",null,null,{"$f":"F80+F89","v":"1233"},"46.27","47.5","200.81","1362.14",null,{"$f":"L80+L89","v":"115.14"}]
[2,6,"Завтрак","сладкое","Печенье","30",2.22,2.82,21.93,122.1,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","70",5.25,2.03,35.98,183.4]
[{"$nulls":3},"гор.блюдо","Каша геркулесовая молочная","200",11.23,13.86,21,216]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с яблоком","200",0.11,0.06,8.97,36.68]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F91+F92+F93+F94","v":"500"},{"$f":"SUM(G91:G96)","v":"18.81"},"18.77","87.88","558.18",null,{"$f":"SUM(L91:L96)","v":"37.55"}]
[{"$f":"A91","v":"2"},"6","Обед","1 блюдо","Борщ из свежей капусты с картофелем со сметаной",205,5.57,8.69,18.93,191.1,null,77.59]
[{"$nulls":3},"2 блюдо","Тефтели говяжьи",90,11.62,10.37,10.1,170.42]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая с маслом сливочным",153,4.9,7.69,45.56,265.3]
[{"$nulls":3},"напиток","Сок фруктовый (нектар плодовый)",200,1,0,20.2,84.8]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.65,0.3,9.9,49.5]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F98:F105)","v":"703"},"27.02","27.29","119.45","831.62",null,{"$f":"SUM(L98:L105)","v":"77.59"}]
[{"$f":"A91","v":"2"},"6","Итого за день:",null,null,{"$f":"F97+F106","v":"1203"},"45.83","46.06","207.33","1389.8",null,{"$f":"L97+L106","v":"115.14"}]
[2,7,"Завтрак","хлеб бел.","Батон нарезной","60",4.5,1.74,30.84,157.2,null,37.55]
[{"$nulls":3},"хлеб бел.","Бутерброд с маслом сливочным","40",2.36,7.49,14.89,136]
[{"$nulls":3},"гор.блюдо","Каша пшенная молочная","200",11.58,9.98,28.73,243.8]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с шиповником","200",0.13,0.02,8.2,34.02]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F108+F109+F110+F111","v":"500"},{"$f":"SUM(G108:G113)","v":"18.57"},"19.23","82.66","571.02",null,{"$f":"SUM(L108:L113)","v":"37.55"}]
[{"$f":"A108","v":"2"},"7","Обед","1 блюдо","Рассольник Ленинградский со сметаной",205,6.74,7.82,9.76,153.9,null,77.59]
[{"$nulls":3},"2 блюдо","Жаркое из птицы (куриных грудок)",200,15.01,17.27,51.76,393.54]
[{"$nulls":3},"доп. гарнир","Горошек консервированный",40,1.15,1.09,2.31,23.68]
[{"$nulls":3},"напиток","Напиток из изюма и яблок",200,0.38,0.13,29.03,119.94]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F115:F122)","v":"700"},"26.5","26.75","113.08","789.41",null,{"$f":"SUM(L115:L122)","v":"77.59"}]
[{"$f":"A108","v":"2"},"7","Итого за день:",null,null,{"$f":"F114+F123","v":"1200"},"45.07","45.98","195.74","1360.43",null,{"$f":"L114+L123","v":"115.14"}]
[2,8,"Завтрак","фрукты","Яблоки","100",0.4,0.4,9.8,47,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","45",3.38,1.31,23.13,117.9]
[{"$nulls":3},"гор.блюдо","Каша рисовая молочная (вязкая) с маслом сливочным","155",14.48,17.32,38.52,389.33]
[{"$nulls":3},"гор.напиток","Чай с сахаром и лимоном","200",0.13,0.02,8.2,34.02]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F125+F126+F127+F128","v":"500"},{"$f":"SUM(G125:G130)","v":"18.39"},"19.05","79.65","588.25",null,{"$f":"SUM(L125:L130)","v":"37.55"}]
[{"$f":"A125","v":"2"},"8","Обед","1 блюдо","Суп картофельный с горохом",200,9.39,15.22,13.23,248.6,null,77.59]
[{"$nulls":3},"2 блюдо","Биточки рыбные",90,5.48,9.57,4.71,64.33]
[{"$nulls":3},"гарнир","Макаронные изделия (рожки) отварные с маслом сливочным",153,5.78,1.28,42.96,226.1]
[{"$nulls":3},"напиток","Напиток из сухофруктов",200,0.7,0.1,32,132.8]
[{"$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(F132:F139)","v":"703"},"25.61","26.77","119.54","801.73",null,{"$f":"SUM(L132:L139)","v":"77.59"}]
[{"$f":"A125","v":"2"},"8","Итого за день:",null,null,{"$f":"F131+F140","v":"1203"},"44","45.82","199.19","1389.98",null,{"$f":"L131+L140","v":"115.14"}]
[2,9,"Завтрак","хлеб бел.","Блины с маслом сливочным","50",2.52,4.31,14.02,105,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","50",3.75,1.45,25.7,131]
[{"$nulls":3},"гор.блюдо","Каша пшеничная молочная","200",12.58,13.98,38.7,293.8]
[{"$nulls":3},"гор.напиток","Чай с сахаром ","200",0.07,0.02,8,32]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F142+F143+F144+F145","v":"500"},{"$f":"SUM(G142:G147)","v":"18.92"},"19.76","86.42","561.8",null,{"$f":"SUM(L142:L147)","v":"37.55"}]
[{"$f":"A142","v":"2"},"9","Обед","1 блюдо","Щи из св.капусты с картофелем",200,8.61,12.96,26.32,271.8,null,77.59]
[{"$nulls":3},"2 блюдо","Котлеты Нежные из куриных грудок",90,12.89,8.41,28.78,201.8]
[{"$nulls":3},"гарнир","Картофельное пюре с маслом сливочным",153,1.09,6.98,10.48,147.05]
[{"$nulls":3},"напиток","Кисель",200,0.6,0.1,30.2,103.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",35,2.66,0.28,17.22,82.25]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.65,0.3,9.9,49.5]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F149:F156)","v":"703"},"27.5","29.03","122.9","856",null,{"$f":"SUM(L149:L156)","v":"77.59"}]
[{"$f":"A142","v":"2"},"9","Итого за день:",null,null,{"$f":"F148+F157","v":"1203"},"46.42","48.79","209.32","1417.8",null,{"$f":"L148+L157","v":"115.14"}]
[2,10,"Завтрак","фрукты","Яблоки","100",0.4,0.4,9.8,47,null,37.55]
[{"$nulls":3},"хлеб бел.","Батон нарезной","50",3.76,1.74,30.84,132]
[{"$nulls":3},"гор.блюдо","Запеканка из творога с повидлом","150",15.1,14.48,36.67,367.4]
[{"$nulls":3},"гор.напиток","Какао с молоком","200",0.08,4.54,10.61,38.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"F159+F160+F161+F162","v":"500"},{"$f":"SUM(G159:G164)","v":"19.34"},"21.16","87.92","585",null,{"$f":"SUM(L159:L164)","v":"37.55"}]
[{"$f":"A159","v":"2"},"10","Обед","1 блюдо","Суп картофельный с вермешелью",200,8.15,9.27,43.96,254.6,null,77.59]
[{"$nulls":3},"2 блюдо","Плов из куриной грудки",200,14.42,18.43,40.93,370.5]
[{"$nulls":3},"доп.гарнир","Свекла отварная (дольками)",60,0.9,0.02,5.27,24.77]
[{"$nulls":3},"напиток","Компот из свежих яблок",200,0.16,0.16,10.91,46.6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.5,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F173)","v":"700"},"26.45","28.28","118.83","783.07",null,{"$f":"SUM(L166:L173)","v":"77.59"}]
[{"$f":"A159","v":"2"},"10","Итого за день:",null,null,{"$f":"F165+F174","v":"1200"},"45.79","49.44","206.75","1368.07",null,{"$f":"L165+L174","v":"115.14"}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F22+F39+F56+F73+F90+F107+F124+F141+F158+F175)/(IF(F22=0,0,1)+IF(F39=0,0,1)+IF(F56=0,0,1)+IF(F73=0,0,1)+IF(F90=0,0,1)+IF(F107=0,0,1)+IF(F124=0,0,1)+IF(F141=0,0,1)+IF(F158=0,0,1)+IF(F175=0,0,1))","v":"1209.3"},"45.267","47.031","201.159","1375.42",null,{"$f":"(L22+L39+L56+L73+L90+L107+L124+L141+L158+L175)/(IF(L22=0,0,1)+IF(L39=0,0,1)+IF(L56=0,0,1)+IF(L73=0,0,1)+IF(L90=0,0,1)+IF(L107=0,0,1)+IF(L124=0,0,1)+IF(L141=0,0,1)+IF(L158=0,0,1)+IF(L175=0,0,1))","v":"115.14"}]