{"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":186,"n_cols":12,"rows_kept":186,"cut":false,"hidden":false,"merged":[[148,2,148,3],[166,2,166,3],[184,2,184,3],[185,2,185,4],[58,2,58,3],[76,2,76,3],[94,2,94,3],[112,2,112,3],[130,2,130,3],[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[40,2,40,3]]}
["Школа",null,"МКОУ СОШ им.А.О.Шомахова с.п. Тамбовское",null,null,"Утвердил:","должность","И.о.директора"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Мухамеджанова З.Г."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",3,2,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Бефстроганов из курийного филе с кашей пшенной",250,19.5,10.25,36.16,313.9,290,53.81]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.8]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F11)","v":510},{"$f":"SUM(G6:G11)","v":26.119999999999997},{"$f":"SUM(H6:H11)","v":12.95},{"$f":"SUM(I6:I11)","v":76.25999999999999},{"$f":"SUM(J6:J11)","v":534.3},null,{"$f":"SUM(L6:L11)","v":58.61}]
[{"$f":"A6","v":1},{"$f":"B6","v":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(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":510},{"$f":"G12+G22","v":26.119999999999997},{"$f":"H12+H22","v":12.95},{"$f":"I12+I22","v":76.25999999999999},{"$f":"J12+J22","v":534.3},null,{"$f":"L12+L22","v":58.61}]
[1,2,"Завтрак","гор.блюдо","Жаркое из говядины",240,12.24,20.6,18.72,300,120609,81.11]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.88]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F24:F29)","v":500},{"$f":"SUM(G24:G29)","v":18.86},{"$f":"SUM(H24:H29)","v":23.3},{"$f":"SUM(I24:I29)","v":58.82},{"$f":"SUM(J24:J29)","v":520.4},null,{"$f":"SUM(L24:L29)","v":85.99}]
[{"$f":"A24","v":1},{"$f":"B24","v":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(F31:F39)","v":0},{"$f":"SUM(G31:G39)","v":0},{"$f":"SUM(H31:H39)","v":0},{"$f":"SUM(I31:I39)","v":0},{"$f":"SUM(J31:J39)","v":0},null,{"$f":"SUM(L31:L39)","v":0}]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F30+F40","v":500},{"$f":"G30+G40","v":18.86},{"$f":"H30+H40","v":23.3},{"$f":"I30+I40","v":58.82},{"$f":"J30+J40","v":520.4},null,{"$f":"L30+L40","v":85.99}]
[1,3,"Завтрак","гор.блюдо","Тефтели из говядины с кашей гречневой и соусом",290,19.84,24.7,35.9,444.05,418,68.64]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.88]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F42:F47)","v":550},{"$f":"SUM(G42:G47)","v":26.46},{"$f":"SUM(H42:H47)","v":27.4},{"$f":"SUM(I42:I47)","v":76},{"$f":"SUM(J42:J47)","v":664.45},null,{"$f":"SUM(L42:L47)","v":73.52}]
[{"$f":"A42","v":1},{"$f":"B42","v":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(F49:F57)","v":0},{"$f":"SUM(G49:G57)","v":0},{"$f":"SUM(H49:H57)","v":0},{"$f":"SUM(I49:I57)","v":0},{"$f":"SUM(J49:J57)","v":0},null,{"$f":"SUM(L49:L57)","v":0}]
[{"$f":"A42","v":1},{"$f":"B42","v":3},"Итого за день:",null,null,{"$f":"F48+F58","v":550},{"$f":"G48+G58","v":26.46},{"$f":"H48+H58","v":27.4},{"$f":"I48+I58","v":76},{"$f":"J48+J58","v":664.45},null,{"$f":"L48+L58","v":73.52}]
[1,4,"Завтрак","гор.блюдо","Котлеты из говядины с кашей перловой и соусом",290,20.4,19.6,47.15,450.05,416,66.05]
[null,null,null,"гор.напиток","Какао с молоком",200,7,4.6,19.4,154,382,13.63]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[null,null,null,"Закуска","Салат из вареной свеклы",70,1.8,5.1,10.8,96.6,52,4.29]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F60:F65)","v":620},{"$f":"SUM(G60:G65)","v":35.62},{"$f":"SUM(H60:H65)","v":32},{"$f":"SUM(I60:I65)","v":103.45},{"$f":"SUM(J60:J65)","v":865.05},null,{"$f":"SUM(L60:L65)","v":86.97}]
[{"$f":"A60","v":1},{"$f":"B60","v":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(F67:F75)","v":0},{"$f":"SUM(G67:G75)","v":0},{"$f":"SUM(H67:H75)","v":0},{"$f":"SUM(I67:I75)","v":0},{"$f":"SUM(J67:J75)","v":0},null,{"$f":"SUM(L67:L75)","v":0}]
[{"$f":"A60","v":1},{"$f":"B60","v":4},"Итого за день:",null,null,{"$f":"F66+F76","v":620},{"$f":"G66+G76","v":35.62},{"$f":"H66+H76","v":32},{"$f":"I66+I76","v":103.45},{"$f":"J66+J76","v":865.05},null,{"$f":"L66+L76","v":86.97}]
[1,5,"Завтрак","гор.блюдо","Котлеты из куриного филе с макаронами и сметанным соусом",290,26.8,15.54,46.09,420.3,406,65.06]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.88]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F78:F83)","v":550},{"$f":"SUM(G78:G83)","v":33.42},{"$f":"SUM(H78:H83)","v":18.24},{"$f":"SUM(I78:I83)","v":86.19},{"$f":"SUM(J78:J83)","v":640.7},null,{"$f":"SUM(L78:L83)","v":69.94}]
[{"$f":"A78","v":1},{"$f":"B78","v":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(F85:F93)","v":0},{"$f":"SUM(G85:G93)","v":0},{"$f":"SUM(H85:H93)","v":0},{"$f":"SUM(I85:I93)","v":0},{"$f":"SUM(J85:J93)","v":0},null,{"$f":"SUM(L85:L93)","v":0}]
[{"$f":"A78","v":1},{"$f":"B78","v":5},"Итого за день:",null,null,{"$f":"F84+F94","v":550},{"$f":"G84+G94","v":33.42},{"$f":"H84+H94","v":18.24},{"$f":"I84+I94","v":86.19},{"$f":"J84+J94","v":640.7},null,{"$f":"L84+L94","v":69.94}]
[2,1,"Завтрак","гор.блюдо","Плов из говядины",240,19.2,9.6,93.6,525.6,381,76.26]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.88]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F96:F101)","v":500},{"$f":"SUM(G96:G101)","v":25.82},{"$f":"SUM(H96:H101)","v":12.3},{"$f":"SUM(I96:I101)","v":133.7},{"$f":"SUM(J96:J101)","v":746},null,{"$f":"SUM(L96:L101)","v":81.14}]
[{"$f":"A96","v":2},{"$f":"B96","v":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(F103:F111)","v":0},{"$f":"SUM(G103:G111)","v":0},{"$f":"SUM(H103:H111)","v":0},{"$f":"SUM(I103:I111)","v":0},{"$f":"SUM(J103:J111)","v":0},null,{"$f":"SUM(L103:L111)","v":0}]
[{"$f":"A96","v":2},{"$f":"B96","v":1},"Итого за день:",null,null,{"$f":"F102+F112","v":500},{"$f":"G102+G112","v":25.82},{"$f":"H102+H112","v":12.3},{"$f":"I102+I112","v":133.7},{"$f":"J102+J112","v":746},null,{"$f":"L102+L112","v":81.14}]
[2,2,"Завтрак","гор.блюдо","Биточки из говядины с кашей перловой и соусом",290,23.01,17.71,39.32,408.65,795,64.37]
[null,null,null,"гор.напиток","Кисель",200,0,0,13.8,55.6,1096,7.43]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F114:F119)","v":550},{"$f":"SUM(G114:G119)","v":29.43},{"$f":"SUM(H114:H119)","v":20.41},{"$f":"SUM(I114:I119)","v":79.22},{"$f":"SUM(J114:J119)","v":628.65},null,{"$f":"SUM(L114:L119)","v":74.80000000000001}]
[{"$f":"A114","v":2},{"$f":"B114","v":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(F121:F129)","v":0},{"$f":"SUM(G121:G129)","v":0},{"$f":"SUM(H121:H129)","v":0},{"$f":"SUM(I121:I129)","v":0},{"$f":"SUM(J121:J129)","v":0},null,{"$f":"SUM(L121:L129)","v":0}]
[{"$f":"A114","v":2},{"$f":"B114","v":2},"Итого за день:",null,null,{"$f":"F120+F130","v":550},{"$f":"G120+G130","v":29.43},{"$f":"H120+H130","v":20.41},{"$f":"I120+I130","v":79.22},{"$f":"J120+J130","v":628.65},null,{"$f":"L120+L130","v":74.80000000000001}]
[2,3,"Завтрак","гор.блюдо","Котлеты из курийного филе с кашей пшенной и соусом",290,26.5,15.84,40.49,407.7,406,59.53]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.88]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[null,null,null,"Закуска","Салат из свежей капусты",100,1.5,1.7,7.2,50.2,91,7.8]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F132:F137)","v":650},{"$f":"SUM(G132:G137)","v":34.62},{"$f":"SUM(H132:H137)","v":20.24},{"$f":"SUM(I132:I137)","v":87.79},{"$f":"SUM(J132:J137)","v":678.3000000000001},null,{"$f":"SUM(L132:L137)","v":72.21}]
[{"$f":"A132","v":2},{"$f":"B132","v":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(F139:F147)","v":0},{"$f":"SUM(G139:G147)","v":0},{"$f":"SUM(H139:H147)","v":0},{"$f":"SUM(I139:I147)","v":0},{"$f":"SUM(J139:J147)","v":0},null,{"$f":"SUM(L139:L147)","v":0}]
[{"$f":"A132","v":2},{"$f":"B132","v":3},"Итого за день:",null,null,{"$f":"F138+F148","v":650},{"$f":"G138+G148","v":34.62},{"$f":"H138+H148","v":20.24},{"$f":"I138+I148","v":87.79},{"$f":"J138+J148","v":678.3000000000001},null,{"$f":"L138+L148","v":72.21}]
[2,4,"Завтрак","гор.блюдо","Рыба тушенная с макаронами и соусом",290,22.92,13.48,44.91,383.69,638,40.44]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.88]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[null,null,null,"Сладкое","Мармелад",30,0.42,2.67,22.47,108.5,119,15]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F150:F155)","v":580},{"$f":"SUM(G150:G155)","v":29.96},{"$f":"SUM(H150:H155)","v":18.85},{"$f":"SUM(I150:I155)","v":107.47999999999999},{"$f":"SUM(J150:J155)","v":712.59},null,{"$f":"SUM(L150:L155)","v":60.32}]
[{"$f":"A150","v":2},{"$f":"B150","v":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(F157:F165)","v":0},{"$f":"SUM(G157:G165)","v":0},{"$f":"SUM(H157:H165)","v":0},{"$f":"SUM(I157:I165)","v":0},{"$f":"SUM(J157:J165)","v":0},null,{"$f":"SUM(L157:L165)","v":0}]
[{"$f":"A150","v":2},{"$f":"B150","v":4},"Итого за день:",null,null,{"$f":"F156+F166","v":580},{"$f":"G156+G166","v":29.96},{"$f":"H156+H166","v":18.85},{"$f":"I156+I166","v":107.47999999999999},{"$f":"J156+J166","v":712.59},null,{"$f":"L156+L166","v":60.32}]
[2,5,"Завтрак","гор.блюдо","Котлеты из куринного филе с картофельным пюре и сметанным соусом",290,23.95,21.09,20.64,362.55,406,71.42]
[null,null,null,"гор.напиток","Какао с молоком",200,7,4.6,19.4,154,382,12.13]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F168:F173)","v":550},{"$f":"SUM(G168:G173)","v":37.37},{"$f":"SUM(H168:H173)","v":28.389999999999997},{"$f":"SUM(I168:I173)","v":66.14},{"$f":"SUM(J168:J173)","v":680.9499999999999},null,{"$f":"SUM(L168:L173)","v":86.55}]
[{"$f":"A168","v":2},{"$f":"B168","v":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(F175:F183)","v":0},{"$f":"SUM(G175:G183)","v":0},{"$f":"SUM(H175:H183)","v":0},{"$f":"SUM(I175:I183)","v":0},{"$f":"SUM(J175:J183)","v":0},null,{"$f":"SUM(L175:L183)","v":0}]
[{"$f":"A168","v":2},{"$f":"B168","v":5},"Итого за день:",null,null,{"$f":"F174+F184","v":550},{"$f":"G174+G184","v":37.37},{"$f":"H174+H184","v":28.389999999999997},{"$f":"I174+I184","v":66.14},{"$f":"J174+J184","v":680.9499999999999},null,{"$f":"L174+L184","v":86.55}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F41+F59+F77+F95+F113+F131+F149+F167+F185)/(IF(F23=0, 0, 1)+IF(F41=0, 0, 1)+IF(F59=0, 0, 1)+IF(F77=0, 0, 1)+IF(F95=0, 0, 1)+IF(F113=0, 0, 1)+IF(F131=0, 0, 1)+IF(F149=0, 0, 1)+IF(F167=0, 0, 1)+IF(F185=0, 0, 1))","v":556},{"$f":"(G23+G41+G59+G77+G95+G113+G131+G149+G167+G185)/(IF(G23=0, 0, 1)+IF(G41=0, 0, 1)+IF(G59=0, 0, 1)+IF(G77=0, 0, 1)+IF(G95=0, 0, 1)+IF(G113=0, 0, 1)+IF(G131=0, 0, 1)+IF(G149=0, 0, 1)+IF(G167=0, 0, 1)+IF(G185=0, 0, 1))","v":29.768},{"$f":"(H23+H41+H59+H77+H95+H113+H131+H149+H167+H185)/(IF(H23=0, 0, 1)+IF(H41=0, 0, 1)+IF(H59=0, 0, 1)+IF(H77=0, 0, 1)+IF(H95=0, 0, 1)+IF(H113=0, 0, 1)+IF(H131=0, 0, 1)+IF(H149=0, 0, 1)+IF(H167=0, 0, 1)+IF(H185=0, 0, 1))","v":21.407999999999998},{"$f":"(I23+I41+I59+I77+I95+I113+I131+I149+I167+I185)/(IF(I23=0, 0, 1)+IF(I41=0, 0, 1)+IF(I59=0, 0, 1)+IF(I77=0, 0, 1)+IF(I95=0, 0, 1)+IF(I113=0, 0, 1)+IF(I131=0, 0, 1)+IF(I149=0, 0, 1)+IF(I167=0, 0, 1)+IF(I185=0, 0, 1))","v":87.505},{"$f":"(J23+J41+J59+J77+J95+J113+J131+J149+J167+J185)/(IF(J23=0, 0, 1)+IF(J41=0, 0, 1)+IF(J59=0, 0, 1)+IF(J77=0, 0, 1)+IF(J95=0, 0, 1)+IF(J113=0, 0, 1)+IF(J131=0, 0, 1)+IF(J149=0, 0, 1)+IF(J167=0, 0, 1)+IF(J185=0, 0, 1))","v":667.1389999999999},null,{"$f":"(L23+L41+L59+L77+L95+L113+L131+L149+L167+L185)/(IF(L23=0, 0, 1)+IF(L41=0, 0, 1)+IF(L59=0, 0, 1)+IF(L77=0, 0, 1)+IF(L95=0, 0, 1)+IF(L113=0, 0, 1)+IF(L131=0, 0, 1)+IF(L149=0, 0, 1)+IF(L167=0, 0, 1)+IF(L185=0, 0, 1))","v":75.00500000000001}]