{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":176,"n_cols":16,"rows_kept":176,"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,"МБОУ \"Школа №65\" г.Казань",null,null,"Утвердил:","должность","Директор школы"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Соркина Ж.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",4,12,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты \"Аппетитные\" мясо-куриные",90,{"v":13.75,"d":"14"},{"v":12.27,"d":"12"},8,197,"ТТК 2022 г"]
[{"$nulls":3},"гор.блюдо","Каша рисовая вязкая",140,{"v":2.15,"d":"2"},{"v":3.85,"d":"4"},{"v":22.35,"d":"22"},133,"№303/2015"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,{"v":0.02,"d":"0"},null,{"v":7.99,"d":"8"},32,"№630/1996 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,{"v":1.25,"d":"1"},{"v":0.18,"d":"0"},{"v":9.42,"d":"9"},46]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,{"v":1.88,"d":"2"},{"v":4.31,"d":"4"},{"v":16.4,"d":"16"},112,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F10)","v":518},{"$f":"SUM(G6:G10)","v":19.05},{"$f":"SUM(H6:H10)","v":20.61},{"$f":"SUM(I6:I10)","v":64.16},{"$f":"SUM(J6:J10)","v":520},null,66.8]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":518},{"$f":"G11+G21","v":19.05},20.61,64.16,520,null,{"$f":"L11+L21","v":66.8}]
[1,2,"Завтрак","гор.блюдо","Жаркое по-домашнему",160,14.64,12.94,21.63,262,"ТТК 2023 г"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.06,18.46,79,"ТТК 2021 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"фрукты","Десерт фруктовый",60,0.24,0.24,5.88,28,"№532/2013г"]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.59,6.1,8.6,93,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F23:F27)","v":500},{"$f":"SUM(G23:G27)","v":18.52},{"$f":"SUM(H23:H27)","v":19.52},{"$f":"SUM(I23:I27)","v":63.99000000000001},{"$f":"SUM(J23:J27)","v":508},null,66.8]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":500},{"$f":"G28+G38","v":18.52},{"$f":"H28+H38","v":19.52},{"$f":"I28+I38","v":63.99000000000001},{"$f":"J28+J38","v":508},null,66.8]
[1,3,"Завтрак","гор.блюдо","Гуляш из птицы",90,11.25,12.57,2.96,170,"ТТК 2021 г"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",140,5.27,4.17,33.55,193,"№202/2015 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,null,7.99,32,"№630/1996 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.59,3.16,13.61,95,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F40:F44)","v":518},{"$f":"SUM(G40:G44)","v":19.38},{"$f":"SUM(H40:H44)","v":20.080000000000002},{"$f":"SUM(I40:I44)","v":67.53},{"$f":"SUM(J40:J44)","v":536},null,66.8]
[{"$f":"A40","v":1},{"$f":"B40","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":518},{"$f":"G45+G55","v":19.38},{"$f":"H45+H55","v":20.080000000000002},{"$f":"I45+I55","v":67.53},{"$f":"J45+J55","v":536},null,66.8]
[1,4,"Завтрак","гор.блюдо","Плов с птицей",160,12.16,10.6,25.87,248,"ТТК 2021 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,null,7.99,32,"№630/1996 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"фрукты","Десерт фруктовый",60,0.24,0.24,5.88,28,"№532/2013г"]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.88,4.31,16.4,112,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F57:F61)","v":508},{"$f":"SUM(G57:G61)","v":15.55},{"$f":"SUM(H57:H61)","v":15.329999999999998},{"$f":"SUM(I57:I61)","v":65.56},{"$f":"SUM(J57:J61)","v":466},null,66.8]
[{"$f":"A57","v":1},{"$f":"B57","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":508},{"$f":"G62+G72","v":15.55},{"$f":"H62+H72","v":15.329999999999998},{"$f":"I62+I72","v":65.56},{"$f":"J62+J72","v":466},null,66.8]
[1,5,"Завтрак","гор.блюдо","Биточки рыбные из фарша минтая",90,12.25,5.57,5.92,123,"ТТК 2021 г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",140,3.06,5.95,21.36,151,"№312/2015 г"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.06,18.46,79,"ТТК 2023 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.88,6.08,9.4,100,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F74:F78)","v":510},{"$f":"SUM(G74:G78)","v":19.24},{"$f":"SUM(H74:H78)","v":17.84},{"$f":"SUM(I74:I78)","v":64.56},{"$f":"SUM(J74:J78)","v":499},null,66.8]
[{"$f":"A74","v":1},{"$f":"B74","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":510},{"$f":"G79+G89","v":19.24},{"$f":"H79+H89","v":17.84},{"$f":"I79+I89","v":64.56},{"$f":"J79+J89","v":499},null,66.8]
[2,1,"Завтрак","гор.блюдо","Ёжики с мясом и рисом в соусе томатном",100,9.56,10.42,9.23,169,"ТТК 2020"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",140,5.27,4.17,33.55,193,"№202/2015 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,null,7.99,32,"№630/1996 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.88,4.31,16.4,112,"ТТК 2023",{"$nulls":4},0]
[{"$nulls":3},"итого",null,{"$f":"SUM(F91:F95)","v":528},{"$f":"SUM(G91:G95)","v":17.98},{"$f":"SUM(H91:H95)","v":19.08},{"$f":"SUM(I91:I95)","v":76.59},{"$f":"SUM(J91:J95)","v":552},null,66.8]
[{"$f":"A91","v":2},{"$f":"B91","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":528},{"$f":"G96+G106","v":17.98},{"$f":"H96+H106","v":19.08},{"$f":"I96+I106","v":76.59},{"$f":"J96+J106","v":552},null,66.8]
[2,2,"Завтрак","гор.блюдо","Жаркое из птицы",160,13.64,12.63,32.57,299,"ТТК 2023 г"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.06,18.46,79,"ТТК 2023"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"фрукты","Десерт фруктовый",60,0.24,0.24,5.88,28,"№532/2013г"]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.59,6.1,8.6,93,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F108:F112)","v":500},{"$f":"SUM(G108:G112)","v":17.520000000000003},{"$f":"SUM(H108:H112)","v":19.21},{"$f":"SUM(I108:I112)","v":74.92999999999999},{"$f":"SUM(J108:J112)","v":545},null,66.8]
[{"$f":"A108","v":2},{"$f":"B108","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":500},{"$f":"G113+G123","v":17.520000000000003},{"$f":"H113+H123","v":19.21},{"$f":"I113+I123","v":74.92999999999999},{"$f":"J113+J123","v":545},null,66.8]
[2,3,"Завтрак","гор.блюдо","Сосиски отварные",200,10.4,12.24,7.69,183,"№243/2015 г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая вязкая",140,3.26,4.33,20.55,134,"№303/2015 г"]
[{"$nulls":3},"гор.напиток","Напиток яблочный",200,0.1,0.1,12.43,52,"№701/2004"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.59,3.18,13.61,95,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F125:F129)","v":620},{"$f":"SUM(G125:G129)","v":16.6},{"$f":"SUM(H125:H129)","v":20.03},{"$f":"SUM(I125:I129)","v":63.7},{"$f":"SUM(J125:J129)","v":510},null,66.8]
[{"$f":"A125","v":2},{"$f":"B125","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":620},{"$f":"G130+G140","v":16.6},{"$f":"H130+H140","v":20.03},{"$f":"I130+I140","v":63.7},{"$f":"J130+J140","v":510},null,66.8]
[2,4,"Завтрак","гор.блюдо","Плов с говядиной",160,14.67,12.67,31.21,298,"ТТК 2021 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,null,7.99,32,"№630/1996"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"фрукты","Десерт фруктовый",60,0.24,0.24,5.88,28,"№532/2013г"]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.88,4.31,16.4,112,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F142:F146)","v":508},{"$f":"SUM(G142:G146)","v":18.06},{"$f":"SUM(H142:H146)","v":17.4},{"$f":"SUM(I142:I146)","v":70.9},{"$f":"SUM(J142:J146)","v":516},null,66.8]
[{"$f":"A142","v":2},{"$f":"B142","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":508},{"$f":"G147+G157","v":18.06},{"$f":"H147+H157","v":17.4},{"$f":"I147+I157","v":70.9},{"$f":"J147+J157","v":516},null,66.8]
[2,5,"Завтрак","гор.блюдо","Биточки рыбные из фарша минтая",90,12.25,5.57,5.92,123,"ТТК 2021 г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",140,3.06,5.95,21.36,151,"№312/2015 г"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.06,18.46,79,"ТТК 2023 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1.25,0.18,9.42,46]
[{"$nulls":3},"закуска","Салат-бар в ассортименте",60,1.88,6.08,9.4,100,"ТТК 2023"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F159:F163)","v":510},{"$f":"SUM(G159:G163)","v":19.24},{"$f":"SUM(H159:H163)","v":17.84},{"$f":"SUM(I159:I163)","v":64.56},{"$f":"SUM(J159:J163)","v":499},null,66.8]
[{"$f":"A159","v":2},{"$f":"B159","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":510},{"$f":"G164+G174","v":19.24},{"$f":"H164+H174","v":17.84},{"$f":"I164+I174","v":64.56},{"$f":"J164+J174","v":499},null,66.8]
[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":522},{"$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":18.114},{"$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":18.694},{"$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":67.648},{"$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":515.1},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":66.79999999999998}]