{"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":158,"n_cols":12,"rows_kept":158,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[16,2,16,3],[28,2,28,3],[40,2,40,3],[59,2,59,3],[71,2,71,3],[80,2,80,3],[99,2,99,3],[118,2,118,3],[137,2,137,3],[156,2,156,3],[157,2,157,4]]}
["Школа",null,"МБОУ \"Паньшинская СШ им. Гули Королевой\"",null,null,"Утвердил:","должность","Директор ООО \"ДонАппетит\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Лукашевич Е.Н."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша вязкая молочная рисовая",200,5.5999999999999996,10.6,40.700000000000003,275,174]
[{"$nulls":4},"Блинчики с джемом в.асс",120,9.3000000000000007,10.9,47.799999999999997,326.69999999999999,338]
[null,null,null,"гор.напиток","Чай с сахаром","200/15",0.20000000000000001,0,15,60.5,685]
[null,null,null,"хлеб","пшеничный",40,3,0.20000000000000001,19.5,91.900000000000006,"ТТК №6"]
[]
[]
[]
[null,null,null,"итого",null,575,{"$f":"SUM(G6:G12)","v":18.100000000000001},21.699999999999999,{"$f":"SUM(I6:I12)","v":123},{"$f":"SUM(J6:J12)","v":754.10000000000002},null,{"$f":"SUM(L6:L12)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Полдник","закуска","Яблоки печеные №372",100,0.40000000000000002,0.40000000000000002,24.899999999999999,107.59999999999999,372]
[null,null,null,"напиток","Сок фруктовый №707",200,1.1000000000000001,0.20000000000000001,19.5,83.400000000000006,707]
[null,null,null,"итого",null,{"$f":"SUM(F14:F15)","v":300},{"$f":"SUM(G14:G15)","v":1.5},{"$f":"SUM(H14:H15)","v":0.60000000000000009},{"$f":"SUM(I14:I15)","v":44.399999999999999},{"$f":"SUM(J14:J15)","v":191},null,{"$f":"SUM(L15:L15)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F16","v":875},{"$f":"G13+G16","v":19.600000000000001},{"$f":"H13+H16","v":22.300000000000001},{"$f":"I13+I16","v":167.40000000000001},{"$f":"J13+J16","v":945.10000000000002},null,{"$f":"L13+L16","v":0}]
[1,2,"Завтрак","гор.блюдо","Каша из пшена и риса дружба молочная №294",200,5.5999999999999996,10.6,40.700000000000003,223,175]
[null,null,null,"гор.блюдо","Омлет натуральный",120,8.3000000000000007,9.3000000000000007,12.6,97.5,144]
[null,null,null,"гор.напиток","Чай с сахаром и лимоном","200/15/5",0.29999999999999999,0,15.199999999999999,60,377]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.20000000000000001,19.5,91.900000000000006,"ТТК №6",105.70999999999999]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,500,{"$f":"SUM(G18:G24)","v":17.200000000000003},{"$f":"SUM(H18:H24)","v":20.099999999999998},{"$f":"SUM(I18:I24)","v":88},{"$f":"SUM(J18:J24)","v":472.39999999999998},null,{"$f":"SUM(L19:L24)","v":105.70999999999999}]
[{"$f":"A18","v":1},{"$f":"B18","v":2},"Полдник","закуска","Фрукты свежие(яблоко)",120,0.40000000000000002,0.40000000000000002,9.5,45.600000000000001,338]
[null,null,null,"1 блюдо","Чай с сахаром каркаде ",180,0.20000000000000001,0,13.5,54.399999999999999,685]
[null,null,null,"итого",null,{"$f":"SUM(F26:F27)","v":300},{"$f":"SUM(G26:G27)","v":0.60000000000000009},{"$f":"SUM(H26:H27)","v":0.40000000000000002},{"$f":"SUM(I26:I27)","v":23},{"$f":"SUM(J26:J27)","v":100},null,{"$f":"SUM(L26:L27)","v":0}]
[{"$f":"A18","v":1},{"$f":"B18","v":2},"Итого за день:",null,null,{"$f":"F25+F28","v":800},{"$f":"G25+G28","v":17.800000000000004},{"$f":"H25+H28","v":20.499999999999996},{"$f":"I25+I28","v":111},{"$f":"J25+J28","v":572.39999999999998},null,{"$f":"L25+L28","v":105.70999999999999}]
[1,3,"Завтрак","гор.блюдо","Фрикадельки по-калининградски",50,5.2000000000000002,5.2999999999999998,4.2999999999999998,89.900000000000006]
[null,null,null,"гор.блюдо","Гречка по-купечески",200,21.899999999999999,25.300000000000001,40.100000000000001,425,"ТТК№468"]
[null,null,null,"гор.напиток","Чай черный с яблоком ",200,0.29999999999999999,0.10000000000000001,10.199999999999999,43,547]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.20000000000000001,19.5,91.900000000000006,"ТТК №6",105.70999999999999]
[null,null,null,"офощи","Овощи по сезону (огурец свежий, помидор свежий, капуста квашеная, помидор соленый, огурец соленый, свекла отварная)",60,0.5,0.10000000000000001,0.10000000000000001,7.5999999999999996,"ТТК №1,2,3,4,5"]
[]
[]
[null,null,null,"итого",null,550,{"$f":"SUM(G30:G36)","v":30.899999999999999},{"$f":"SUM(H30:H36)","v":31.000000000000004},{"$f":"SUM(I30:I36)","v":74.199999999999989},{"$f":"SUM(J30:J36)","v":657.39999999999998},null,{"$f":"SUM(L30:L36)","v":105.70999999999999}]
[{"$f":"A30","v":1},{"$f":"B30","v":3},"Полдник","закуска","Фрукты свежие(яблоко)",120,0.5,0.5,11.4,54.700000000000003,338]
[null,null,null,"1 блюдо","Сок фруктовый №707",180,0.90000000000000002,0.20000000000000001,17.699999999999999,80.299999999999997,707]
[null,null,null,"итого",null,{"$f":"SUM(F38:F39)","v":300},{"$f":"SUM(G38:G39)","v":1.3999999999999999},{"$f":"SUM(H38:H39)","v":0.69999999999999996},{"$f":"SUM(I38:I39)","v":29.100000000000001},{"$f":"SUM(J38:J39)","v":135},null,{"$f":"SUM(L38:L39)","v":0}]
[{"$f":"A30","v":1},{"$f":"B30","v":3},"Итого за день:",null,null,{"$f":"F37+F40","v":850},{"$f":"G37+G40","v":32.299999999999997},{"$f":"H37+H40","v":31.700000000000003},{"$f":"I37+I40","v":103.29999999999998},{"$f":"J37+J40","v":792.39999999999998},null,{"$f":"L37+L40","v":105.70999999999999}]
[1,4,"Завтрак","гор.блюдо","Каша вязкая молочная кукурузная ",200,5.5999999999999996,10.6,40.700000000000003,223,118]
[null,null,null,"закуска","Сырники творожные с джемом",90,14.5,13.800000000000001,47.100000000000001,370,291]
[null,null,null,"гор.напиток","Чай с сахаром","200/15",0.10000000000000001,0,17.300000000000001,59.299999999999997,376]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.20000000000000001,19.5,91.900000000000006,"ТТК № 6",105.70999999999999]
[]
[]
[]
[null,null,null,"итого",null,515,{"$f":"SUM(G42:G48)","v":23.200000000000003},{"$f":"SUM(H42:H48)","v":24.599999999999998},{"$f":"SUM(I42:I48)","v":124.60000000000001},{"$f":"SUM(J42:J48)","v":744.19999999999993},null,{"$f":"SUM(L42:L48)","v":105.70999999999999}]
[{"$f":"A42","v":1},{"$f":"B42","v":4},"Полдник","закуска","Кондитерские изделия (печенье, вафли)",20,1.6000000000000001,2,14.4,80.799999999999997]
[null,null,null,"1 блюдо","Фрукты свежие(яблоко)",100,0.40000000000000002,0.40000000000000002,9.5,45.600000000000001,338]
[null,null,null,"2 блюдо","Чай с сахаром и лимоном",180,0.20000000000000001,0,13.5,55.399999999999999,377]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F50:F58)","v":300},{"$f":"SUM(G50:G58)","v":2.2000000000000002},{"$f":"SUM(H50:H58)","v":2.3999999999999999},{"$f":"SUM(I50:I58)","v":37.399999999999999},{"$f":"SUM(J50:J58)","v":181.80000000000001},null,{"$f":"SUM(L50:L58)","v":0}]
[{"$f":"A42","v":1},{"$f":"B42","v":4},"Итого за день:",null,null,{"$f":"F49+F59","v":815},{"$f":"G49+G59","v":25.400000000000002},{"$f":"H49+H59","v":26.999999999999996},{"$f":"I49+I59","v":162},{"$f":"J49+J59","v":926},null,{"$f":"L49+L59","v":105.70999999999999}]
[1,5,"Завтрак","гор.блюдо","Каша из смеси круп (гречневая, овсяная, пшено) вязкая с морковью",185,6.5,11.1,30.800000000000001,255,202]
[null,null,null,"гор.блюдо","блинчики с джемом в асс.",120,9.3000000000000007,10.9,47.799999999999997,326.69999999999999,338]
[null,null,null,"гор.напиток","чай с сахаром каркаде",215,0.20000000000000001,0,15,60.5,685]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.20000000000000001,19.5,91.900000000000006,"ТТК № 6",105.70999999999999]
[null,null,null,"фрукты"]
[]
[null,null,null,"итого",null,560,{"$f":"SUM(G61:G66)","v":19},{"$f":"SUM(H61:H66)","v":22.199999999999999},{"$f":"SUM(I61:I66)","v":113.09999999999999},{"$f":"SUM(J61:J66)","v":734.10000000000002},null,{"$f":"SUM(L61:L66)","v":105.70999999999999}]
[{"$f":"A61","v":1},{"$f":"B61","v":5},"Обед","закуска","Фрукты свежие(яблоко)",100,0.40000000000000002,0.40000000000000002,9.5,45.600000000000001,338]
[null,null,null,"1 блюдо","Сок фруктовый №707",180,0.90000000000000002,0.20000000000000001,17.699999999999999,80.299999999999997,707]
[]
[null,null,null,"итого",null,{"$f":"SUM(F68:F70)","v":280},{"$f":"SUM(G68:G70)","v":1.3},{"$f":"SUM(H68:H70)","v":0.60000000000000009},{"$f":"SUM(I68:I70)","v":27.199999999999999},{"$f":"SUM(J68:J70)","v":125.90000000000001},null,{"$f":"SUM(L68:L70)","v":0}]
[{"$f":"A61","v":1},{"$f":"B61","v":5},"Итого за день:",null,null,{"$f":"F67+F71","v":840},{"$f":"G67+G71","v":20.300000000000001},{"$f":"H67+H71","v":22.800000000000001},{"$f":"I67+I71","v":140.29999999999998},{"$f":"J67+J71","v":860},null,{"$f":"L67+L71","v":105.70999999999999}]
[2,1,"Завтрак","гор.блюдо","Гуляш из мяса птицы",90,11.1,10.4,3.2000000000000002,150.30000000000001,337]
[{"$nulls":4},"Каша вязкая гречневая ",150,6.0999999999999996,4.7999999999999998,37.799999999999997,178.19999999999999,3.2000000000000002]
[null,null,null,"гор.напиток","Чай с сахаром","200/15",0.10000000000000001,0,17.300000000000001,59.299999999999997,376]
[null,null,null,"хлеб","Хлеб пшеничный",45,3.7999999999999998,0.20000000000000001,21.899999999999999,103.40000000000001,"ТТК № 6",105.70999999999999]
[]
[]
[]
[null,null,null,"итого",null,500,{"$f":"SUM(G73:G79)","v":21.100000000000001},{"$f":"SUM(H73:H79)","v":15.399999999999999},{"$f":"SUM(I73:I79)","v":80.199999999999989},{"$f":"SUM(J73:J79)","v":491.20000000000005},null,{"$f":"SUM(L73:L79)","v":105.70999999999999}]
[{"$f":"A73","v":2},{"$f":"B73","v":1},"Итого за день:",null,null,{"$f":"F80+#REF!","v":{"$error":"#REF!"}},{"$f":"G80+#REF!","v":{"$error":"#REF!"}},{"$f":"H80+#REF!","v":{"$error":"#REF!"}},{"$f":"I80+#REF!","v":{"$error":"#REF!"}},{"$f":"J80+#REF!","v":{"$error":"#REF!"}},null,{"$f":"L80+#REF!","v":{"$error":"#REF!"}}]
[2,2,"Завтрак","гор.блюдо","Каша овсяная на молоке",200,5,10.1,30.5,260.80000000000001,175]
[null,null,null,"гор.блюдо","Пицца школьная вар1",100,12.800000000000001,22.800000000000001,65.400000000000006,368.69999999999999,288]
[null,null,null,"гор.напиток","Чай с сахаром и лимоном","200/15/5",0.29999999999999999,0,15.199999999999999,60,377]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,520,{"$f":"SUM(G82:G88)","v":18.100000000000001},{"$f":"SUM(H82:H88)","v":32.899999999999999},{"$f":"SUM(I82:I88)","v":111.10000000000001},{"$f":"SUM(J82:J88)","v":689.5},null,{"$f":"SUM(L82:L88)","v":0}]
[{"$f":"A82","v":2},{"$f":"B82","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(F90:F98)","v":0},{"$f":"SUM(G90:G98)","v":0},{"$f":"SUM(H90:H98)","v":0},{"$f":"SUM(I90:I98)","v":0},{"$f":"SUM(J90:J98)","v":0},null,{"$f":"SUM(L90:L98)","v":0}]
[{"$f":"A82","v":2},{"$f":"B82","v":2},"Итого за день:",null,null,{"$f":"F89+F99","v":520},{"$f":"G89+G99","v":18.100000000000001},{"$f":"H89+H99","v":32.899999999999999},{"$f":"I89+I99","v":111.10000000000001},{"$f":"J89+J99","v":689.5},null,{"$f":"L89+L99","v":0}]
[2,3,"Завтрак","гор.блюдо","Оладьи со сгущенным молоком",150,6.5,6.7999999999999998,40.200000000000003,217.19999999999999,180]
[null,null,null,"гор.блюдо","Каша вязкая гречневая",200,5.5999999999999996,10.6,40.700000000000003,223,116]
[null,null,null,"гор.напиток","Чай с сахаром каркаде","200/15",0.20000000000000001,0,15,60.5,685]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.20000000000000001,19.5,91.900000000000006,"ТТК №6",105.70999999999999]
[]
[]
[]
[null,null,null,"итого",null,525,{"$f":"SUM(G101:G107)","v":15.299999999999999},{"$f":"SUM(H101:H107)","v":17.599999999999998},{"$f":"SUM(I101:I107)","v":115.40000000000001},{"$f":"SUM(J101:J107)","v":592.60000000000002},null,{"$f":"SUM(L101:L107)","v":105.70999999999999}]
[{"$f":"A101","v":2},{"$f":"B101","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(F109:F117)","v":0},{"$f":"SUM(G109:G117)","v":0},{"$f":"SUM(H109:H117)","v":0},{"$f":"SUM(I109:I117)","v":0},{"$f":"SUM(J109:J117)","v":0},null,{"$f":"SUM(L109:L117)","v":0}]
[{"$f":"A101","v":2},{"$f":"B101","v":3},"Итого за день:",null,null,{"$f":"F108+F118","v":525},{"$f":"G108+G118","v":15.299999999999999},{"$f":"H108+H118","v":17.599999999999998},{"$f":"I108+I118","v":115.40000000000001},{"$f":"J108+J118","v":592.60000000000002},null,{"$f":"L108+L118","v":105.70999999999999}]
[2,4,"Завтрак","гор.блюдо","Каша молочная вязкая с тыквой",200,5,10.1,30.5,260.80000000000001,120]
[null,null,null,"гор.блюдо","Вриттата с сыром и ветчиной",100,9.5999999999999996,10.300000000000001,1.6000000000000001,137.59999999999999,186]
[null,null,null,"гор.напиток","Чай черный с яблоком","200/15",0.29999999999999999,0.10000000000000001,10.199999999999999,43,"ТТК №547"]
[null,null,null,"хлеб","Хлеб пшеничный",55,4.0999999999999996,0.29999999999999999,26.800000000000001,126.40000000000001,"ТТК №6",105.70999999999999]
[{"$nulls":4},"соус томатный ",30,1.1000000000000001,2.5,2.5,32,593]
[]
[]
[null,null,null,"итого",null,515,{"$f":"SUM(G120:G126)","v":20.100000000000001},{"$f":"SUM(H120:H126)","v":23.300000000000001},{"$f":"SUM(I120:I126)","v":71.599999999999994},{"$f":"SUM(J120:J126)","v":599.79999999999995},null,{"$f":"SUM(L120:L126)","v":105.70999999999999}]
[{"$f":"A120","v":2},{"$f":"B120","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(F128:F136)","v":0},{"$f":"SUM(G128:G136)","v":0},{"$f":"SUM(H128:H136)","v":0},{"$f":"SUM(I128:I136)","v":0},{"$f":"SUM(J128:J136)","v":0},null,{"$f":"SUM(L128:L136)","v":0}]
[{"$f":"A120","v":2},{"$f":"B120","v":4},"Итого за день:",null,null,{"$f":"F127+F137","v":515},{"$f":"G127+G137","v":20.100000000000001},{"$f":"H127+H137","v":23.300000000000001},{"$f":"I127+I137","v":71.599999999999994},{"$f":"J127+J137","v":599.79999999999995},null,{"$f":"L127+L137","v":105.70999999999999}]
[2,5,"Завтрак","гор.блюдо","Каша молочная манная жидкая",200,5.5,7.2000000000000002,33.600000000000001,243,311]
[null,null,null,"гор.блюдо","Запеканка из творога",120,12.699999999999999,6,27.899999999999999,216.5,154]
[null,null,null,"гор.напиток","Чай с сахаром ","200/15/",0.10000000000000001,0,17.300000000000001,59.299999999999997,376]
[null,null,null,"хлеб","Хлеб пшеничный ",55,4.0999999999999996,0.29999999999999999,26.800000000000001,126.40000000000001,null,105.70999999999999]
[]
[]
[]
[null,null,null,"итого",null,535,{"$f":"SUM(G139:G145)","v":22.399999999999999},{"$f":"SUM(H139:H145)","v":13.5},{"$f":"SUM(I139:I145)","v":105.59999999999999},{"$f":"SUM(J139:J145)","v":645.19999999999993},null,{"$f":"SUM(L139:L145)","v":105.70999999999999}]
[{"$f":"A139","v":2},{"$f":"B139","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(F147:F155)","v":0},{"$f":"SUM(G147:G155)","v":0},{"$f":"SUM(H147:H155)","v":0},{"$f":"SUM(I147:I155)","v":0},{"$f":"SUM(J147:J155)","v":0},null,{"$f":"SUM(L147:L155)","v":0}]
[{"$f":"A139","v":2},{"$f":"B139","v":5},"Итого за день:",null,null,{"$f":"F146+F156","v":535},{"$f":"G146+G156","v":22.399999999999999},{"$f":"H146+H156","v":13.5},{"$f":"I146+I156","v":105.59999999999999},{"$f":"J146+J156","v":645.19999999999993},null,{"$f":"L146+L156","v":105.70999999999999}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F17+F29+F41+F60+F72+F81+F100+F119+F138+F157)/(IF(F17=0,0,1)+IF(F29=0,0,1)+IF(F41=0,0,1)+IF(F60=0,0,1)+IF(F72=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))","v":{"$error":"#REF!"}},19.199999999999999,19.600000000000001,81,549.39999999999998,null,{"$f":"(L17+L29+L41+L60+L72+L81+L100+L119+L138+L157)/(IF(L17=0,0,1)+IF(L29=0,0,1)+IF(L41=0,0,1)+IF(L60=0,0,1)+IF(L72=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))","v":{"$error":"#REF!"}}]