{"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":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[40,2,40,3],[58,2,58,3],[76,2,76,3],[94,2,94,3],[112,2,112,3],[130,2,130,3],[148,2,148,3],[166,2,166,3],[184,2,184,3],[185,2,185,4]]}
["Школа",null,"МКОУ СОШ с.п.Красноармейское",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Шадова М.В."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Бефстроганов из курийного филе с кашей пшенной",250,19.5,10.25,36.16,313.9,290,53.33]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.85]
[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.12},{"$f":"SUM(H6:H11)","v":12.95},{"$f":"SUM(I6:I11)","v":76.26},{"$f":"SUM(J6:J11)","v":534.3},null,{"$f":"SUM(L6:L11)","v":58.18}]
[{"$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},0,0,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.12},12.95,76.26,534.3,null,{"$f":"L12+L22","v":58.18}]
[1,2,"Завтрак","гор.блюдо","Котлеты из говядины с кашей перловой и соусом",290,20.4,19.6,47.15,450.05,416,67.09]
[null,null,null,"гор.напиток","Какао с молоком",200,7,4.6,19.4,154,382,12.98]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[null,null,null,"Закуска","Огурцы свежие",90,0.8,0.3,1.9,14,null,7.2]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F24:F29)","v":640},{"$f":"SUM(G24:G29)","v":34.62},{"$f":"SUM(H24:H29)","v":27.2},{"$f":"SUM(I24:I29)","v":94.55},{"$f":"SUM(J24:J29)","v":782.45},null,{"$f":"SUM(L24:L29)","v":90.27}]
[{"$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,0]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F30+F40","v":640},{"$f":"G30+G40","v":34.62},{"$f":"H30+H40","v":27.2},{"$f":"I30+I40","v":94.55},{"$f":"J30+J40","v":782.45},null,90.27]
[1,3,"Завтрак","гор.блюдо","Жаркое из говядины",240,12.24,20.6,18.72,300,120609,77.73]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.93]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F42:F47)","v":500},{"$f":"SUM(G42:G47)","v":18.86},{"$f":"SUM(H42:H47)","v":23.3},{"$f":"SUM(I42:I47)","v":58.82},{"$f":"SUM(J42:J47)","v":520.4},null,{"$f":"SUM(L42:L47)","v":82.66}]
[{"$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,0]
[{"$f":"A42","v":1},{"$f":"B42","v":3},"Итого за день:",null,null,{"$f":"F48+F58","v":500},{"$f":"G48+G58","v":18.86},{"$f":"H48+H58","v":23.3},{"$f":"I48+I58","v":58.82},{"$f":"J48+J58","v":520.4},null,82.66]
[1,4,"Завтрак","гор.блюдо","Тефтели из говядины с кашей гречневой и соусом",290,19.84,24.7,35.9,444.05,418,69.33]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.93]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[null,null,null,"Закуска","Огурцы свежие",90,0.8,0.3,1.9,14,null,7.2]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F60:F65)","v":640},{"$f":"SUM(G60:G65)","v":27.26},{"$f":"SUM(H60:H65)","v":27.7},{"$f":"SUM(I60:I65)","v":77.9},{"$f":"SUM(J60:J65)","v":678.45},null,{"$f":"SUM(L60:L65)","v":81.46}]
[{"$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,0]
[{"$f":"A60","v":1},{"$f":"B60","v":4},"Итого за день:",null,null,{"$f":"F66+F76","v":640},{"$f":"G66+G76","v":27.26},{"$f":"H66+H76","v":27.7},{"$f":"I66+I76","v":77.9},{"$f":"J66+J76","v":678.45},null,81.46]
[1,5,"Завтрак","гор.блюдо","Котлеты из куриного филе с макаронами и сметанным соусом",290,26.8,15.54,46.09,420.3,406,60.02]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.93]
[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":64.95}]
[{"$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,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,64.95]
[2,1,"Завтрак","гор.блюдо","Плов из говядины",240,19.2,9.6,93.6,525.6,381,76.48]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.93]
[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.41}]
[{"$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},0,0,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,81.41]
[2,2,"Завтрак","гор.блюдо","Биточки из говядины с кашей перловой и соусом",290,23.01,17.71,39.32,408.65,795,65.57]
[null,null,null,"гор.напиток","Кисель",200,0,0,13.8,55.6,1096,6.98]
[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":75.55}]
[{"$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},0,0,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,75.55]
[2,3,"Завтрак","гор.блюдо","Котлеты из курийного филе с кашей пшенной и соусом",290,26.5,15.84,40.49,407.7,406,62.09]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.93]
[null,null,null,"хлеб","Хлеб",60,6.42,2.7,26.1,164.4,701.1,3]
[null,null,null,"Закуска","Огурцы свежие",90,0.8,0.3,1.9,14,null,7.2]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F132:F137)","v":640},{"$f":"SUM(G132:G137)","v":33.92},{"$f":"SUM(H132:H137)","v":18.84},{"$f":"SUM(I132:I137)","v":82.49},{"$f":"SUM(J132:J137)","v":642.1},null,{"$f":"SUM(L132:L137)","v":74.22}]
[{"$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},0,0,0,null,{"$f":"SUM(L139:L147)","v":0}]
[{"$f":"A132","v":2},{"$f":"B132","v":3},"Итого за день:",null,null,{"$f":"F138+F148","v":640},{"$f":"G138+G148","v":33.92},{"$f":"H138+H148","v":18.84},{"$f":"I138+I148","v":82.49},{"$f":"J138+J148","v":642.1},null,74.22]
[2,4,"Завтрак","гор.блюдо","Рыба тушенная с макаронами и соусом",290,22.92,13.48,44.91,383.69,638,47.18]
[null,null,null,"гор.напиток","Чай с сахаром",200,0.2,0,14,56,1167,1.93]
[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,14]
[]
[]
[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.48},{"$f":"SUM(J150:J155)","v":712.59},null,{"$f":"SUM(L150:L155)","v":66.11}]
[{"$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},0,0,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.48},{"$f":"J156+J166","v":712.59},null,66.11]
[2,5,"Завтрак","гор.блюдо","Котлеты из куринного филе с картофельным пюре и сметанным соусом",290,23.95,21.09,20.64,362.55,406,74.38]
[null,null,null,"гор.напиток","Какао с молоком",200,7,4.6,19.4,154,382,12.98]
[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.39},{"$f":"SUM(I168:I173)","v":66.14},{"$f":"SUM(J168:J173)","v":680.95},null,{"$f":"SUM(L168:L173)","v":90.36}]
[{"$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},0,0,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.39},{"$f":"I174+I184","v":66.14},{"$f":"J174+J184","v":680.95},null,90.36]
[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":566},{"$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.678},{"$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":20.818},{"$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":86.275},{"$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":656.659},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":76.517}]