{"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":176,"n_cols":12,"rows_kept":176,"cut":false,"hidden":false,"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,"МБОУ СОШ № 26 им. Макового Н.Н.",null,null,"Утвердил:","должность","директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Акименко Т..П."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",5,11,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша манная молочная с маслом сливочным",150,5,7,35,206,106,13.17]
[null,null,null,"гор.напиток","Чай с сахаром",180,0,0,14,55,376,1.28]
[null,null,null,"хлеб","Ватрушка с творогом, Бутерброд с маслом",80,7,14,28,264,"таб,3",40.54]
[null,null,null,"фрукты","Яблоки",150,1,1,8,45,"таб",15]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F10)","v":560},{"$f":"SUM(G6:G10)","v":13},22,85,570,null,{"$f":"SUM(L6:L10)","v":69.99}]
[{"$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(F12:F20)","v":0},{"$f":"SUM(G12:G20)","v":0},0,0,0,null,{"$f":"SUM(L12:L20)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F11+F21","v":560},{"$f":"G11+G21","v":13},22,85,570,null,{"$f":"L11+L21","v":69.99}]
[1,2,"Завтрак","гор.блюдо","Рыба, тушенная(горбуша),Картофельное пюре",250,19,15,36,337,299.23,75.8]
[null,null,null,"гор.напиток","Чай с лимоном",180,0,0,14,55,377,2.86]
[null,null,null,"хлеб","Хлеб пшеничный,Хлеб ржаной ",45,3,0,20,97,"таб",2.91]
[null,null,null,"закуска","Салат из свеклы отварной",60,1,1,7,38,23,3.84]
[]
[null,null,null,"итого",null,{"$f":"SUM(F23:F27)","v":535},{"$f":"SUM(G23:G27)","v":23},{"$f":"SUM(H23:H27)","v":16},{"$f":"SUM(I23:I27)","v":77},{"$f":"SUM(J23:J27)","v":527},null,85.41]
[{"$f":"A23","v":1},{"$f":"B23","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,null,null,"итого",null,{"$f":"SUM(F29:F37)","v":0},{"$f":"SUM(G29:G37)","v":0},{"$f":"SUM(H29:H37)","v":0},{"$f":"SUM(I29:I37)","v":0},{"$f":"SUM(J29:J37)","v":0},null,0]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Итого за день:",null,null,{"$f":"F28+F38","v":535},{"$f":"G28+G38","v":23},{"$f":"H28+H38","v":16},{"$f":"I28+I38","v":77},{"$f":"J28+J38","v":527},null,85.41]
[1,3,"Завтрак","гор.блюдо","Плов из отварной птицы(тушка)",200,13,17,30,302,375,45.52]
[null,null,null,"гор.напиток","Кофейный напиток с молоком",200,5,5,18,135,286,13.32]
[null,null,null,"хлеб","Хлеб пшеничный, Хлеб ржаной ",45,4,0,20,97,"таб",2.91]
[null,null,null,"закуска","Салат из квашеной капусты с яблоком",60,1,1,4,29,8,8.08]
[null,null,null,"фрукты","Яблоки",150,1,1,8,45,"таб",15]
[null,null,null,"итого",null,{"$f":"SUM(F40:F44)","v":655},{"$f":"SUM(G40:G44)","v":24},{"$f":"SUM(H40:H44)","v":24},{"$f":"SUM(I40:I44)","v":80},{"$f":"SUM(J40:J44)","v":608},null,84.83]
[{"$f":"A40","v":1},{"$f":"B40","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(F46:F54)","v":0},{"$f":"SUM(G46:G54)","v":0},{"$f":"SUM(H46:H54)","v":0},{"$f":"SUM(I46:I54)","v":0},{"$f":"SUM(J46:J54)","v":0},null,0]
[{"$f":"A40","v":1},{"$f":"B40","v":3},"Итого за день:",null,null,{"$f":"F45+F55","v":655},{"$f":"G45+G55","v":24},{"$f":"H45+H55","v":24},{"$f":"I45+I55","v":80},{"$f":"J45+J55","v":608},null,84.83]
[1,4,"Завтрак","гор.блюдо","Котлеты  из птицы(куры-филе),Соус томатный с овощами,Каша пшеничная вязкая",255,20,12,38,356,"294, 349, 223",47.81]
[null,null,null,"гор.напиток","Чай с сахаром",180,0,0,14,55,376,1.28]
[null,null,null,"хлеб","Хлеб пшеничный,Хлеб ржаной ",45,4,0,20,97,"таб",2.91]
[null,null,null,"закуска","Салат из квашеной капусты",60,1,1,3,21,47,8.1]
[]
[null,null,null,"итого",null,{"$f":"SUM(F57:F61)","v":540},{"$f":"SUM(G57:G61)","v":25},{"$f":"SUM(H57:H61)","v":13},{"$f":"SUM(I57:I61)","v":75},{"$f":"SUM(J57:J61)","v":529},null,60.1]
[{"$f":"A57","v":1},{"$f":"B57","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,null,null,"итого",null,{"$f":"SUM(F63:F71)","v":0},{"$f":"SUM(G63:G71)","v":0},{"$f":"SUM(H63:H71)","v":0},{"$f":"SUM(I63:I71)","v":0},{"$f":"SUM(J63:J71)","v":0},null,0]
[{"$f":"A57","v":1},{"$f":"B57","v":4},"Итого за день:",null,null,{"$f":"F62+F72","v":540},{"$f":"G62+G72","v":25},{"$f":"H62+H72","v":13},{"$f":"I62+I72","v":75},{"$f":"J62+J72","v":529},null,60.1]
[1,5,"Завтрак","гор.блюдо","Жаркое по-домашнему (свинина)",250,21,15,42,364,259,51.33]
[null,null,null,"гор.напиток","Чай фруктовый",180,0,0,17,65,"ттк",6.08]
[null,null,null,"хлеб","Хлеб пшеничный,Хлеб ржаной ",45,4,0,20,97,"таб",2.91]
[null,null,null,"закуска","Овощи соленые(помидор)",60,0,0,1,8,70,9.09]
[]
[null,null,null,"итого",null,{"$f":"SUM(F74:F78)","v":535},{"$f":"SUM(G74:G78)","v":25},{"$f":"SUM(H74:H78)","v":15},{"$f":"SUM(I74:I78)","v":80},{"$f":"SUM(J74:J78)","v":534},null,69.41]
[{"$f":"A74","v":1},{"$f":"B74","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(F80:F88)","v":0},{"$f":"SUM(G80:G88)","v":0},{"$f":"SUM(H80:H88)","v":0},{"$f":"SUM(I80:I88)","v":0},{"$f":"SUM(J80:J88)","v":0},null,0]
[{"$f":"A74","v":1},{"$f":"B74","v":5},"Итого за день:",null,null,{"$f":"F79+F89","v":535},{"$f":"G79+G89","v":25},{"$f":"H79+H89","v":15},{"$f":"I79+I89","v":80},{"$f":"J79+J89","v":534},null,69.41]
[2,1,"Завтрак","гор.блюдо","Каша вязкая (рисовая) с маслом",150,6,10,40,248,"124з",19.12]
[null,null,null,"гор.напиток","Чай с лимоном",180,0,0,14,55,377,2.86]
[null,null,null,"хлеб","Батон, Пирожок ",70,6,5,36,209,"таб",28.6]
[null,null,null,"закуска","Яйцо вареное,Сыр порционный",62,7,9,0,103,"209, 29",22.53]
[null,null,null,"фрукты","Яблоки",150,1,1,8,45,"таб",15]
[null,null,null,"итого",null,{"$f":"SUM(F91:F95)","v":612},{"$f":"SUM(G91:G95)","v":20},25,98,660,null,{"$f":"SUM(L91:L95)","v":88.11}]
[{"$f":"A91","v":2},{"$f":"B91","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(F97:F105)","v":0},{"$f":"SUM(G97:G105)","v":0},0,0,0,null,{"$f":"SUM(L97:L105)","v":0}]
[{"$f":"A91","v":2},{"$f":"B91","v":1},"Итого за день:",null,null,{"$f":"F96+F106","v":612},{"$f":"G96+G106","v":20},{"$f":"H96+H106","v":25},{"$f":"I96+I106","v":98},{"$f":"J96+J106","v":660},null,88.11]
[2,2,"Завтрак","гор.блюдо","Рыба припущенная(горбуша), Соус сметанный , Картофельное пюре",270,20,17,32,349,"77, 330, 312",88.6]
[null,null,null,"гор.напиток","Чай фруктовый",180,0,0,17,65,"ттк",6.08]
[null,null,null,"хлеб","Хлеб пшеничный,Хлеб ржаной ",45,4,0,20,97,"таб",2.91]
[null,null,null,"закуска","Овощи соленые(огурцы)",60,0,0,1,8,70,9.9]
[]
[null,null,null,"итого",null,{"$f":"SUM(F108:F112)","v":555},{"$f":"SUM(G108:G112)","v":24},17,70,519,null,{"$f":"SUM(L108:L112)","v":107.49}]
[{"$f":"A108","v":2},{"$f":"B108","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,null,null,"итого",null,{"$f":"SUM(F114:F122)","v":0},{"$f":"SUM(G114:G122)","v":0},0,0,0,null,{"$f":"SUM(L114:L122)","v":0}]
[{"$f":"A108","v":2},{"$f":"B108","v":2},"Итого за день:",null,null,{"$f":"F113+F123","v":555},{"$f":"G113+G123","v":24},{"$f":"H113+H123","v":17},{"$f":"I113+I123","v":70},{"$f":"J113+J123","v":519},null,107.49]
[2,3,"Завтрак","гор.блюдо","Суфле из птицы, Каша гречневая,Соус молочный",275,19,17,35,346,"368, 219, 326",68.32]
[null,null,null,"гор.напиток","Чай с сахаром",180,0,0,14,55,376,1.28]
[null,null,null,"хлеб","Хлеб пшеничный, Хлеб ржаной ",45,3,0,20,97,"таб",2.91]
[null,null,null,"сладкое","Печенье сахарное",25,2,2,19,104,"таб",4.06]
[]
[null,null,null,"итого",null,{"$f":"SUM(F125:F129)","v":525},{"$f":"SUM(G125:G129)","v":24},19,88,602,null,{"$f":"SUM(L125:L129)","v":76.57}]
[{"$f":"A125","v":2},{"$f":"B125","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,null,null,"итого",null,{"$f":"SUM(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},0,0,0,null,{"$f":"SUM(L131:L139)","v":0}]
[{"$f":"A125","v":2},{"$f":"B125","v":3},"Итого за день:",null,null,{"$f":"F130+F140","v":525},{"$f":"G130+G140","v":24},{"$f":"H130+H140","v":19},{"$f":"I130+I140","v":88},{"$f":"J130+J140","v":602},null,76.57]
[2,4,"Завтрак","гор.блюдо","Гуляш (свинина), Макаронные изделия отварные",240,23,15,37,356,"299, 228",49.53]
[null,null,null,"гор.напиток","Чай фруктовый",180,0,0,17,65,"ттк",6.08]
[null,null,null,"хлеб","Хлеб пшеничный,Хлеб ржаной ",45,4,0,20,97,"таб",2.91]
[null,null,null,"закуска","Салат из кукурузы",60,1,1,7,40,299,15.26]
[]
[null,null,null,"итого",null,{"$f":"SUM(F142:F146)","v":525},{"$f":"SUM(G142:G146)","v":28},16,81,558,null,{"$f":"SUM(L142:L146)","v":73.78}]
[{"$f":"A142","v":2},{"$f":"B142","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(F148:F156)","v":0},{"$f":"SUM(G148:G156)","v":0},0,0,0,null,{"$f":"SUM(L148:L156)","v":0}]
[{"$f":"A142","v":2},{"$f":"B142","v":4},"Итого за день:",null,null,{"$f":"F147+F157","v":525},{"$f":"G147+G157","v":28},{"$f":"H147+H157","v":16},{"$f":"I147+I157","v":81},{"$f":"J147+J157","v":558},null,73.78]
[2,5,"Завтрак","гор.блюдо","Запеканка  из творога, Молоко сгущеное с сахаром",180,22,19,34,378,"313, 250",52.67]
[null,null,null,"гор.напиток","Кофейный напиток с молоком",200,5,5,18,135,286,13.32]
[null,null,null,"хлеб","Бутерброд  маслом",30,2,6,12,104,"таб",7.76]
[null,null,null,"фрукты","Яблоки",150,1,1,8,45,"таб",15]
[]
[null,null,null,"итого",null,{"$f":"SUM(F159:F163)","v":560},{"$f":"SUM(G159:G163)","v":30},31,72,662,null,{"$f":"SUM(L159:L163)","v":88.75}]
[{"$f":"A159","v":2},{"$f":"B159","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,null,null,"итого",null,{"$f":"SUM(F165:F173)","v":0},{"$f":"SUM(G165:G173)","v":0},0,0,0,null,{"$f":"SUM(L165:L173)","v":0}]
[{"$f":"A159","v":2},{"$f":"B159","v":5},"Итого за день:",null,null,{"$f":"F164+F174","v":560},{"$f":"G164+G174","v":30},{"$f":"H164+H174","v":31},{"$f":"I164+I174","v":72},{"$f":"J164+J174","v":662},null,88.75]
[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":560.2},{"$f":"(G22+G39+G56+G73+G90+G107+G124+G141+G158+G175)/(IF(G22=0,0,1)+IF(G39=0,0,1)+IF(G56=0,0,1)+IF(G73=0,0,1)+IF(G90=0,0,1)+IF(G107=0,0,1)+IF(G124=0,0,1)+IF(G141=0,0,1)+IF(G158=0,0,1)+IF(G175=0,0,1))","v":23.6},{"$f":"(H22+H39+H56+H73+H90+H107+H124+H141+H158+H175)/(IF(H22=0,0,1)+IF(H39=0,0,1)+IF(H56=0,0,1)+IF(H73=0,0,1)+IF(H90=0,0,1)+IF(H107=0,0,1)+IF(H124=0,0,1)+IF(H141=0,0,1)+IF(H158=0,0,1)+IF(H175=0,0,1))","v":19.8},{"$f":"(I22+I39+I56+I73+I90+I107+I124+I141+I158+I175)/(IF(I22=0,0,1)+IF(I39=0,0,1)+IF(I56=0,0,1)+IF(I73=0,0,1)+IF(I90=0,0,1)+IF(I107=0,0,1)+IF(I124=0,0,1)+IF(I141=0,0,1)+IF(I158=0,0,1)+IF(I175=0,0,1))","v":80.6},{"$f":"(J22+J39+J56+J73+J90+J107+J124+J141+J158+J175)/(IF(J22=0,0,1)+IF(J39=0,0,1)+IF(J56=0,0,1)+IF(J73=0,0,1)+IF(J90=0,0,1)+IF(J107=0,0,1)+IF(J124=0,0,1)+IF(J141=0,0,1)+IF(J158=0,0,1)+IF(J175=0,0,1))","v":576.9},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":80.444}]