{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["7--11лет","11-17лет"],"read":"whole","date_system":"1900"}

{"sheet":"7--11лет","index":0,"n_rows":235,"n_cols":12,"rows_kept":235,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[61,2,61,3],[80,2,80,3],[99,2,99,3],[138,2,138,3],[157,2,157,3],[176,2,176,3],[195,2,195,3],[234,2,234,4]]}
["Школа",null,"МБОУ\"Зеленорощинская СОШ имени М. Горького\"  ",null,null,"Согласовано:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Анисахарова А.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",9,"01",2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:G12)","v":0},0,0,0,null,{"$f":"SUM(L6:L12)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска","Зеленый горошек к/с(доп гарнир)",40,1.19,2.08,2.5,33.44]
[{"$nulls":3},"1 блюдо","котлета из мяса птицы",90,10.2,12.93,13.79,198]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Макаронные изделия отварные с маслом сливочным","150/5",5.7,4.3,31.99,189.3,203]
[{"$nulls":3},"напиток","Компот из сухофруктов(75с)",200,0.56,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":360},{"$f":"SUM(G14:G22)","v":19.63},19.759999999999998,82.19,572.9399999999999,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":360},{"$f":"G13+G23","v":19.63},19.759999999999998,82.19,572.9399999999999,null,{"$f":"L13+L23","v":0}]
[1,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":0},{"$f":"SUM(G25:G31)","v":0},{"$f":"SUM(H25:H31)","v":0},{"$f":"SUM(I25:I31)","v":0},{"$f":"SUM(J25:J31)","v":0},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо","Сырники из творога с молочной кашей \"Дружба\"","50/150",12.92,14.39,31.09,292.26,175.219]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Чай с сахаром","190/10",0.07,0.02,10.01,40,376]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":130},{"$f":"SUM(G33:G41)","v":15.370000000000001},{"$f":"SUM(H33:H41)","v":15.17},{"$f":"SUM(I33:I41)","v":62.78},{"$f":"SUM(J33:J41)","v":438.65999999999997},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":130},{"$f":"G32+G42","v":15.370000000000001},{"$f":"H32+H42","v":15.17},{"$f":"I32+I42","v":62.78},{"$f":"J32+J42","v":438.65999999999997},null,0]
[1,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":0},{"$f":"SUM(G44:G50)","v":0},{"$f":"SUM(H44:H50)","v":0},{"$f":"SUM(I44:I50)","v":0},{"$f":"SUM(J44:J50)","v":0},null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска","Сыр порционно",10,2.63,2.66,0,34.33,15]
[{"$nulls":3},"1 блюдо","Гуляш из говядины","50/50",10.39,14.79,10.3,221,260]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая",150,3.77,2.29,39.72,214,171]
[{"$nulls":3},"напиток","Чай с сахаром с лимоном","185/10/5",0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",50,3.3,0.5,19.8,99]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":210},{"$f":"SUM(G52:G60)","v":20.2},{"$f":"SUM(H52:H60)","v":20.259999999999998},{"$f":"SUM(I52:I60)","v":79.97},{"$f":"SUM(J52:J60)","v":609.65},null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":210},{"$f":"G51+G61","v":20.2},{"$f":"H51+H61","v":20.259999999999998},{"$f":"I51+I61","v":79.97},{"$f":"J51+J61","v":609.65},null,0]
[1,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":0},{"$f":"SUM(G63:G69)","v":0},{"$f":"SUM(H63:H69)","v":0},{"$f":"SUM(I63:I69)","v":0},{"$f":"SUM(J63:J69)","v":0},null,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска","Салат из свеклы отварнойс маслом растительным",60,0.84,3.61,4.96,55.68,52]
[{"$nulls":3},"1 блюдо","котлета из мяса птицы",90,10.2,12.93,13.79,198,80]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","пюре картофельное с маслом сливочным","150/3",4.11,3.55,30.79,202.8,312]
[{"$nulls":3},"напиток","чай с сахаром с яблоком","180/10/10",0.11,0.06,10.98,44.7,376]
[{"$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":"SUM(F71:F79)","v":200},{"$f":"SUM(G71:G79)","v":18.759999999999998},{"$f":"SUM(H71:H79)","v":20.669999999999998},{"$f":"SUM(I71:I79)","v":82.24},{"$f":"SUM(J71:J79)","v":607.58},null,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":200},{"$f":"G70+G80","v":18.759999999999998},{"$f":"H70+H80","v":20.669999999999998},{"$f":"I70+I80","v":82.24},{"$f":"J70+J80","v":607.58},null,0]
[1,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":0},{"$f":"SUM(G82:G88)","v":0},{"$f":"SUM(H82:H88)","v":0},{"$f":"SUM(I82:I88)","v":0},{"$f":"SUM(J82:J88)","v":0},null,0]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо","Сыр порционно",15,3.95,3.99,0,51.5,15]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Пельмени мясные отварные с маслом сливочным","150/5",8.79,11.2,31.4,295.65,390]
[{"$nulls":3},"напиток","Кофейный напиток с молоком ",200,3.17,2.68,15.9,100.6,379]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F98)","v":370},{"$f":"SUM(G90:G98)","v":20.19},{"$f":"SUM(H90:H98)","v":18.83},{"$f":"SUM(I90:I98)","v":81.28},{"$f":"SUM(J90:J98)","v":612.9},null,0]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":370},{"$f":"G89+G99","v":20.19},{"$f":"H89+H99","v":18.83},{"$f":"I89+I99","v":81.28},{"$f":"J89+J99","v":612.9},null,{"$f":"L89+L99","v":0}]
[1,6,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":0},{"$f":"SUM(G101:G107)","v":0},0,0,0,0,{"$f":"SUM(L101:L107)","v":0}]
[{"$f":"A81","v":1},6,"Обед","закуска","Салат из квашеной капусты",60,1.02,3,5.07,51.42,47]
[{"$nulls":3},"1 блюдо","Биточки рыбные",90,13.17,10.7,15.79,193.3,234]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Рис отварной рассыпчатый с маслом сливочным","150/3",3.63,6.5,37.58,223.35,302]
[{"$nulls":3},"напиток","Чай с сахаром с лимоном","185/10/5",0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":180},{"$f":"SUM(G109:G117)","v":19.91},20.58,80.47,568.7900000000001,null,{"$f":"SUM(L109:L117)","v":0}]
[{"$f":"A81","v":1},6,"Итого за день:",null,null,{"$f":"F88+F118","v":180},{"$f":"G88+G118","v":19.91},20.58,80.47,568.7900000000001,null,0]
[2,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":0},{"$f":"SUM(G120:G126)","v":0},0,0,0,null,{"$f":"SUM(L120:L126)","v":0}]
[]
[2,1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Котлета из мяса птицы",90,10.2,12.93,13.79,198,182]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Каша пшенная молочная с маслом сливочным","180/3",4.09,5.08,37.26,216.9,182]
[{"$nulls":3},"напиток","Чай витаминный с шиповником","185/10/5",0.24,0.09,12.43,54.2,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F129:F137)","v":145},{"$f":"SUM(G129:G137)","v":18.41},18.659999999999997,87.66,587.2499999999999,null,{"$f":"SUM(L129:L137)","v":0}]
[2,1,"Итого за день:",null,null,{"$f":"F108+F138","v":145},{"$f":"G108+G138","v":18.41},{"$f":"H108+H138","v":18.659999999999997},{"$f":"I108+I138","v":87.66},{"$f":"J108+J138","v":587.2499999999999},null,0]
[2,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F140:F146)","v":0},{"$f":"SUM(G140:G146)","v":0},0,0,0,null,{"$f":"SUM(L140:L146)","v":0}]
[{"$f":"A140","v":2},{"$f":"B140","v":2},"Обед","закуска","Плоды и ягоды свежие ",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Плов из говядины с рисовой крупой","50/150",15.95,19.55,39.75,408.42,265]
[{"$nulls":3},"напиток","чай с сахаром ","190/10",0.07,0.02,10.01,40,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,58.75]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F148:F156)","v":145},{"$f":"SUM(G148:G156)","v":19.639999999999997},20.409999999999997,79.78,593.7700000000001,null,{"$f":"SUM(L148:L156)","v":0}]
[{"$f":"A140","v":2},{"$f":"B140","v":2},"Итого за день:",null,null,{"$f":"F147+F157","v":145},{"$f":"G147+G157","v":19.639999999999997},{"$f":"H147+H157","v":20.409999999999997},{"$f":"I147+I157","v":79.78},{"$f":"J147+J157","v":593.7700000000001},null,0]
[2,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F159:F165)","v":0},{"$f":"SUM(G159:G165)","v":0},0,0,0,null,{"$f":"SUM(L159:L165)","v":0}]
[{"$f":"A159","v":2},{"$f":"B159","v":3},"Обед","закуска","Капуста тушеная(д/г)",50,1.03,1.62,4.71,37.55,321]
[{"$nulls":3},"1 блюдо","Рыба тушеная в томате с овощами","50/50",9.05,6.09,3.8,105,229]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Пюре картофельное",150,3.09,8.282,22,172,312]
[{"$nulls":3},"напиток","Компот из свежих яблок (75 С)",200,0.16,0.16,17.9,74.6,342]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",35,2.66,0.28,17.22,82.25]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F167:F175)","v":435},{"$f":"SUM(G167:G175)","v":15.99},16.432000000000002,65.63,471.4,null,{"$f":"SUM(L167:L175)","v":0}]
[{"$f":"A159","v":2},{"$f":"B159","v":3},"Итого за день:",null,null,{"$f":"F166+F176","v":435},{"$f":"G166+G176","v":15.99},{"$f":"H166+H176","v":16.432000000000002},{"$f":"I166+I176","v":65.63},{"$f":"J166+J176","v":471.4},null,0]
[2,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F178:F184)","v":0},{"$f":"SUM(G178:G184)","v":0},0,0,0,null,{"$f":"SUM(L178:L184)","v":0}]
[{"$f":"A178","v":2},{"$f":"B178","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Тефтели куриные с гречневой крупой в сметанно - томатном соусе","60/40",3.17,5.19,9.85,118.01]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","макаронные изделия отвар с маслом","180/3",6.64,7.6,31.78,221.94,203]
[{"$nulls":3},"напиток","Какао с молоком",200,4.08,3.54,7.6,78.6,382]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F186:F194)","v":230},{"$f":"SUM(G186:G194)","v":16.169999999999998},16.569999999999997,63.99,489.04999999999995,null,{"$f":"SUM(L186:L194)","v":0}]
[{"$f":"A178","v":2},{"$f":"B178","v":4},"Итого за день:",null,null,{"$f":"F185+F195","v":230},{"$f":"G185+G195","v":16.169999999999998},{"$f":"H185+H195","v":16.569999999999997},{"$f":"I185+I195","v":63.99},{"$f":"J185+J195","v":489.04999999999995},null,0]
[2,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F197:F203)","v":0},{"$f":"SUM(G197:G203)","v":0},0,0,0,null,{"$f":"SUM(L197:L203)","v":0}]
[{"$f":"A197","v":2},5,"Обед","закуска","Плоды и ягоды свежие ",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо","Овощи тушенные с мясом ","50/150",12.48,15.68,19.34,271.5,143]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из сухофруктов(75С)",200,0.66,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F205:F213)","v":330},{"$f":"SUM(G205:G213)","v":15.82},16.409999999999997,65.93,482.3,null,{"$f":"SUM(L205:L213)","v":0}]
[{"$f":"A197","v":2},{"$f":"B197","v":5},"Итого за день:",null,null,{"$f":"F204+F214","v":330},{"$f":"G204+G214","v":15.82},16.409999999999997,65.93,482.3,null,{"$f":"L204+L214","v":0}]
[2,6,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F216:F222)","v":0},{"$f":"SUM(G216:G222)","v":0},0,0,0,null,{"$f":"SUM(L216:L222)","v":0}]
[{"$f":"A216","v":2},6,"Обед","закуска","Салат из отварной маркови и свеклы с зеленым горошком к/с",60,0.96,2.11,4.33,40.5]
[{"$nulls":3},"1 блюдо","Котлеты Аппетитные",90,12.9,12.15,13.15,214.2]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая с маслом сливочным","150/3",3.79,4.47,39.76,233.8,171]
[{"$nulls":3},"напиток","чай с сахаром с лимоном","185/10/5",0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F224:F232)","v":180},{"$f":"SUM(G224:G232)","v":20.04},18.99,82.15,600.82,null,{"$f":"SUM(L224:L232)","v":0}]
[{"$f":"A216","v":2},{"$f":"B216","v":6},"Итого за день:",null,null,{"$f":"F223+F233","v":180},{"$f":"G223+G233","v":20.04},18.99,82.15,600.82,null,{"$f":"L223+L233","v":0}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F100+F139+F158+F177+F196+F234)/(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(F139=0,0,1)+IF(F158=0,0,1)+IF(F177=0,0,1)+IF(F196=0,0,1)+IF(F234=0,0,1))","v":240.5},{"$f":"(G24+G43+G62+G81+G100+G139+G158+G177+G196+G234)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G81=0,0,1)+IF(G100=0,0,1)+IF(G139=0,0,1)+IF(G158=0,0,1)+IF(G177=0,0,1)+IF(G196=0,0,1)+IF(G234=0,0,1))","v":18.439999999999998},{"$f":"(H24+H43+H62+H81+H100+H139+H158+H177+H196+H234)/(IF(H24=0,0,1)+IF(H43=0,0,1)+IF(H62=0,0,1)+IF(H81=0,0,1)+IF(H100=0,0,1)+IF(H139=0,0,1)+IF(H158=0,0,1)+IF(H177=0,0,1)+IF(H196=0,0,1)+IF(H234=0,0,1))","v":18.575200000000002},{"$f":"(I24+I43+I62+I81+I100+I139+I158+I177+I196+I234)/(IF(I24=0,0,1)+IF(I43=0,0,1)+IF(I62=0,0,1)+IF(I81=0,0,1)+IF(I100=0,0,1)+IF(I139=0,0,1)+IF(I158=0,0,1)+IF(I177=0,0,1)+IF(I196=0,0,1)+IF(I234=0,0,1))","v":76.767},{"$f":"(J24+J43+J62+J81+J100+J139+J158+J177+J196+J234)/(IF(J24=0,0,1)+IF(J43=0,0,1)+IF(J62=0,0,1)+IF(J81=0,0,1)+IF(J100=0,0,1)+IF(J139=0,0,1)+IF(J158=0,0,1)+IF(J177=0,0,1)+IF(J196=0,0,1)+IF(J234=0,0,1))","v":558.4019999999999},null,{"$f":"(L24+L43+L62+L81+L100+L139+L158+L177+L196+L234)/(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(L139=0,0,1)+IF(L158=0,0,1)+IF(L177=0,0,1)+IF(L196=0,0,1)+IF(L234=0,0,1))","v":{"$error":"#DIV/0!"}}]

{"sheet":"11-17лет","index":1,"n_rows":235,"n_cols":12,"rows_kept":235}
["Школа",null,"МБОУ\"Зеленорощинская СОШ имени М. Горького\"  ",null,null,"Согласовано:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Анисахарова А.В."]
["Возрастная категория",{"$nulls":3},"11-17 лет",null,"дата",9,"01",2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:G12)","v":0},0,0,0,null,{"$f":"SUM(L6:L12)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска","Зеленый горошек к/с(доп гарнир)",40,1.19,2.08,2.5,33.44]
[{"$nulls":3},"1 блюдо","котлета из мяса птицы",90,10.2,12.93,13.79,198]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Макаронные изделия отварные с маслом сливочным","150/5",5.7,4.3,31.99,189.3,203]
[{"$nulls":3},"напиток","Компот из сухофруктов(75с)",200,0.56,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб бел.","хлеб пшеничный",30,"1900-01-02T06:43:12",0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",35,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":395},{"$f":"SUM(G14:G22)","v":21.91},19.999999999999996,96.95,643.4399999999999,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":395},{"$f":"G13+G23","v":21.91},19.999999999999996,96.95,643.4399999999999,null,{"$f":"L13+L23","v":0}]
[1,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":0},{"$f":"SUM(G25:G31)","v":0},0,0,0,null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо","Каша  молочная   каша \"Дружба\"","180/3",5.42,5.89,30.05,194.4,175]
[{"$nulls":3},"2 блюдо","Сырники из творога",50,8.73,10.73,8.24,157,219]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Чай с сахаром","190/10",0.07,0.02,10.01,40,376]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",40,2.54,0.48,15.84,79.2]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":190},{"$f":"SUM(G33:G41)","v":17.16},17.52,73.94,517.6,null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":190},{"$f":"G32+G42","v":17.16},17.52,73.94,517.6,null,0]
[1,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":0},{"$f":"SUM(G44:G50)","v":0},0,0,0,null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска","Сыр порционно",10,2.63,2.66,0,34.33,15]
[{"$nulls":3},"1 блюдо","Гуляш из говядины","50/50",10.39,14.79,10.3,221,260]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая",180,4.55,4.93,47.71,76.6,171]
[{"$nulls":3},"напиток","Чай с сахаром с лимоном","185/10/5",0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",40,2.64,0.48,15.84,79.2]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":250},{"$f":"SUM(G52:G60)","v":21.84},23.04,93.84000000000002,499.44999999999993,null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":250},{"$f":"G51+G61","v":21.84},23.04,93.84000000000002,499.44999999999993,null,0]
[1,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":0},{"$f":"SUM(G63:G69)","v":0},0,0,0,null,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска","Салат из свеклы отварнойс маслом растительным",100,1.41,6.01,8.26,92.8,52]
[{"$nulls":3},"1 блюдо","котлета из мяса птицы",90,10.2,12.93,13.79,198,80]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","пюре картофельное с маслом сливочным","150/3",4.11,3.55,30.79,202.8,312]
[{"$nulls":3},"напиток","чай с сахаром с яблоком","180/10/10",0.11,0.06,10.98,44.7,376]
[{"$nulls":3},"хлеб бел.","хлеб пшеничный ",30,28,0.24,14.76,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":250},{"$f":"SUM(G71:G79)","v":45.809999999999995},23.149999999999995,90.46,668.2,null,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":250},{"$f":"G70+G80","v":45.809999999999995},23.149999999999995,90.46,668.2,null,0]
[1,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":0},{"$f":"SUM(G82:G88)","v":0},0,0,0,null,0]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Пельмени мясные отварные с маслом сливочным","195/5",19.54,21.05,40.8,374.45,390]
[{"$nulls":3},"напиток","Чай с сахаром","190/10",0.07,0.02,10.01,40,376]
[{"$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":"SUM(F90:F98)","v":150},{"$f":"SUM(G90:G98)","v":23.509999999999998},21.99,82.32999999999998,567.85,null,0]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":150},{"$f":"G89+G99","v":23.509999999999998},{"$f":"H89+H99","v":21.99},{"$f":"I89+I99","v":82.32999999999998},{"$f":"J89+J99","v":567.85},null,{"$f":"L89+L99","v":0}]
[1,6,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":0},{"$f":"SUM(G101:G107)","v":0},0,0,0,0,0]
[{"$f":"A81","v":1},6,"Обед","закуска","Квашеная капуста (доп.гарнир)",50,0.85,2.5,4.23,42.85]
[{"$nulls":3},"1 блюдо","Биточки рыбные",90,13.17,10.7,15.79,193.3,234]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Рис отварной рассыпчатый с маслом сливочным","150/3",3.63,6.5,37.58,223.35,302]
[{"$nulls":3},"напиток","Чай с сахаром с лимоном","185/10/5",0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.78,70.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",40,2.64,0.48,15.84,79.2]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":210},{"$f":"SUM(G109:G117)","v":22.68},20.439999999999998,98.37,650.52,null,{"$f":"SUM(L109:L117)","v":0}]
[{"$f":"A81","v":1},6,"Итого за день:",null,null,{"$f":"F88+F118","v":210},{"$f":"G88+G118","v":22.68},20.439999999999998,98.37,650.52,null,0]
[2,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":0},{"$f":"SUM(G120:G126)","v":0},0,0,0,null,{"$f":"SUM(L120:L126)","v":0}]
[]
[2,1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Котлета из мяса птицы",100,11.33,14.36,15.32,220]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Каша пшенная молочная с маслом сливочным",200,7.43,4.46,36.91,219,182]
[{"$nulls":3},"напиток","Чай витаминный с шиповником","185/10/5",0.24,0.09,12.43,54.2,376]
[{"$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":"SUM(F129:F137)","v":350},{"$f":"SUM(G129:G137)","v":22.499999999999996},19.43,86.38,599.6,null,{"$f":"SUM(L129:L137)","v":0}]
[2,1,"Итого за день:",null,null,{"$f":"F108+F138","v":350},{"$f":"G108+G138","v":22.499999999999996},19.43,86.38,599.6,null,0]
[2,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F140:F146)","v":0},{"$f":"SUM(G140:G146)","v":0},0,0,0,null,{"$f":"SUM(L140:L146)","v":0}]
[{"$f":"A140","v":2},{"$f":"B140","v":2},"Обед","закуска","Плоды и ягоды свежие ",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Плов из говядины с рисовой крупой","50/200",18.97,23.12,51.79,509.8,265]
[{"$nulls":3},"напиток","чай с сахаром ","190/10",0.07,0.02,10.01,40,376]
[{"$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":"SUM(F148:F156)","v":150},{"$f":"SUM(G148:G156)","v":22.939999999999998},24.06,93.32000000000001,703.1999999999999,null,{"$f":"SUM(L148:L156)","v":0}]
[{"$f":"A140","v":2},{"$f":"B140","v":2},"Итого за день:",null,null,{"$f":"F147+F157","v":150},{"$f":"G147+G157","v":22.939999999999998},24.06,93.32000000000001,703.1999999999999,null,0]
[2,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F159:F165)","v":0},{"$f":"SUM(G159:G165)","v":0},0,0,0,null,{"$f":"SUM(L159:L165)","v":0}]
[{"$f":"A159","v":2},{"$f":"B159","v":3},"Обед","закуска","Капуста тушеная(д/г)",50,1.03,1.62,4.71,37.55,321]
[{"$nulls":3},"1 блюдо","Рыба тушеная в томате с овощами","50/50",9.05,6.09,3.8,105,229]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Пюре картофельное",180,3.68,5.75,24.53,164.7,312]
[{"$nulls":3},"напиток","Компот из свежих яблок (75 С)",200,0.16,0.16,17.9,74.6,342]
[{"$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(F167:F175)","v":490},{"$f":"SUM(G167:G175)","v":18.18},14.22,77.58,511.75,null,{"$f":"SUM(L167:L175)","v":0}]
[{"$f":"A159","v":2},{"$f":"B159","v":3},"Итого за день:",null,null,{"$f":"F166+F176","v":490},{"$f":"G166+G176","v":18.18},14.22,77.58,511.75,null,0]
[2,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F178:F184)","v":0},{"$f":"SUM(G178:G184)","v":0},0,0,0,null,{"$f":"SUM(L178:L184)","v":0}]
[{"$f":"A178","v":2},{"$f":"B178","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Тефтели куриные с гречневой крупой в сметанно - томатном соусе","60/40",3.17,5.19,9.85,118.01]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","макаронные изделия отвар с маслом",200,7.56,0.84,42.5,208,203]
[{"$nulls":3},"напиток","Какао с молоком",200,4.08,3.54,7.6,78.6,382]
[{"$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":"SUM(F186:F194)","v":450},{"$f":"SUM(G186:G194)","v":18.310000000000002},10.09,81.67,511.01,null,{"$f":"SUM(L186:L194)","v":0}]
[{"$f":"A178","v":2},{"$f":"B178","v":4},"Итого за день:",null,null,{"$f":"F185+F195","v":450},{"$f":"G185+G195","v":18.310000000000002},10.09,81.67,511.01,null,0]
[2,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F197:F203)","v":0},{"$f":"SUM(G197:G203)","v":0},0,0,0,null,{"$f":"SUM(L197:L203)","v":0}]
[{"$f":"A197","v":2},5,"Обед","закуска","Плоды и ягоды свежие ",100,0.4,0.4,9.8,47]
[{"$nulls":3},"1 блюдо","Овощи тушенные с мясом ","50/150",12.48,15.68,19.34,271.5,143]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из сухофруктов(75С)",200,0.66,0.09,22.03,92.8,349]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F205:F213)","v":360},{"$f":"SUM(G205:G213)","v":17.8},16.769999999999996,77.81,541.7,null,{"$f":"SUM(L205:L213)","v":0}]
[{"$f":"A197","v":2},{"$f":"B197","v":5},"Итого за день:",null,null,{"$f":"F204+F214","v":360},{"$f":"G204+G214","v":17.8},16.769999999999996,77.81,541.7,null,{"$f":"L204+L214","v":0}]
[2,6,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F216:F222)","v":0},{"$f":"SUM(G216:G222)","v":0},0,0,0,null,{"$f":"SUM(L216:L222)","v":0}]
[{"$f":"A216","v":2},6,"Обед","закуска","Салат из отварной маркови и свеклы с зеленым горошком к/с",100,1.6,2.71,12.4,77.5]
[{"$nulls":3},"1 блюдо","Котлеты Аппетитные",90,12.9,12.15,13.15]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая с маслом сливочным","150/3",3.79,4.47,39.76,233.8,171]
[{"$nulls":3},"напиток","чай с сахаром с лимоном","185/10/5",0.11,0.02,10.15,41.32,377]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,1.98,0.36,11.88,59.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F224:F232)","v":220},{"$f":"SUM(G224:G232)","v":20.38},19.709999999999997,87.34,412.02,null,{"$f":"SUM(L224:L232)","v":0}]
[{"$f":"A216","v":2},{"$f":"B216","v":6},"Итого за день:",null,null,{"$f":"F223+F233","v":220},{"$f":"G223+G233","v":20.38},19.709999999999997,87.34,412.02,null,{"$f":"L223+L233","v":0}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F100+F139+F158+F177+F196+F234)/(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(F139=0,0,1)+IF(F158=0,0,1)+IF(F177=0,0,1)+IF(F196=0,0,1)+IF(F234=0,0,1))","v":289.5},{"$f":"(G24+G43+G62+G81+G100+G139+G158+G177+G196+G234)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G81=0,0,1)+IF(G100=0,0,1)+IF(G139=0,0,1)+IF(G158=0,0,1)+IF(G177=0,0,1)+IF(G196=0,0,1)+IF(G234=0,0,1))","v":23.253999999999998},{"$f":"(H24+H43+H62+H81+H100+H139+H158+H177+H196+H234)/(IF(H24=0,0,1)+IF(H43=0,0,1)+IF(H62=0,0,1)+IF(H81=0,0,1)+IF(H100=0,0,1)+IF(H139=0,0,1)+IF(H158=0,0,1)+IF(H177=0,0,1)+IF(H196=0,0,1)+IF(H234=0,0,1))","v":19.321},{"$f":"(I24+I43+I62+I81+I100+I139+I158+I177+I196+I234)/(IF(I24=0,0,1)+IF(I43=0,0,1)+IF(I62=0,0,1)+IF(I81=0,0,1)+IF(I100=0,0,1)+IF(I139=0,0,1)+IF(I158=0,0,1)+IF(I177=0,0,1)+IF(I196=0,0,1)+IF(I234=0,0,1))","v":86.381},{"$f":"(J24+J43+J62+J81+J100+J139+J158+J177+J196+J234)/(IF(J24=0,0,1)+IF(J43=0,0,1)+IF(J62=0,0,1)+IF(J81=0,0,1)+IF(J100=0,0,1)+IF(J139=0,0,1)+IF(J158=0,0,1)+IF(J177=0,0,1)+IF(J196=0,0,1)+IF(J234=0,0,1))","v":563.4119999999999},null,{"$f":"(L24+L43+L62+L81+L100+L139+L158+L177+L196+L234)/(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(L139=0,0,1)+IF(L158=0,0,1)+IF(L177=0,0,1)+IF(L196=0,0,1)+IF(L234=0,0,1))","v":{"$error":"#DIV/0!"}}]