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

{"sheet":"Лист1","index":0,"n_rows":203,"n_cols":12,"rows_kept":203,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[43,2,43,3],[63,2,63,3],[82,2,82,3],[102,2,102,3],[121,2,121,3],[141,2,141,3],[161,2,161,3],[181,2,181,3],[201,2,201,3],[202,2,202,4]]}
["Школа",null,"МБОУ \"Гимназия №18- \"Галэм\" Приволжского района г. Казани",null,null,"Утвердил:","должность","Заместитель генерального директора АО \"Департамент продовольствия и социального питания\" г.Казань"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Агапова А. К."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",9,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты из мяса птицы",90,10.493,{"v":9.73,"d":"9.730"},6.771,157,"ТТК от 2024 г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая ",150,6.622,5.399,25.875,179,"№302/2015г,Дели"]
[{"$nulls":3},"гор.напиток","Напиток из вишни",200,{"v":0.12,"d":"0.120"},{"v":0.03,"d":"0.030"},{"v":11.57,"d":"11.570"},48,"ТТК №2694 от 14.09.2023 г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки) ",100,{"v":0.4,"d":"0.400"},{"v":0.4,"d":"0.400"},{"v":9.8,"d":"9.800"},47,"№338 Дели 2015г "]
[{"$nulls":4},"Фруктовое пюре ",125,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},15,60]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":705},20.155,15.919,87.856,582,null,92.76]
[{"$f":"A6","v":1},1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":0},0,0,0,0,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},1,"Итого за день:",null,null,{"$f":"F13+F23","v":705},20.155,15.919,87.856,582,null,{"$f":"L13+L23","v":92.76}]
[1,2,"Завтрак","гор.блюдо","Жаркое из птицы (грудки куриные)",190,11.912,10.698,{"v":29.09,"d":"29.090"},260,"ТТК № 2739 от 07.12.2023г"]
[]
[{"$nulls":3},"гор.напиток","Напиток яблочный",200,{"v":0.1,"d":"0.100"},0.1,{"v":12.43,"d":"12.430"},52,"ТТК №2693 от 14.09.2023 г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,0.931,3.051,5.645,54,"№45/2015г,Дели"]
[{"$nulls":4},"Батончик (в ассортименте)",30,{"v":1.8,"d":"1.800"},{"v":6.2,"d":"6.200"},{"v":15.4,"d":"15.400"},128]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":520},{"$f":"SUM(G25:G31)","v":17.263},{"$f":"SUM(H25:H31)","v":20.409},{"$f":"SUM(I25:I31)","v":81.405},{"$f":"SUM(J25:J31)","v":585},null,92.76]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F34:F42)","v":0},0,0,0,0,null,{"$f":"SUM(L34:L42)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F33+F43","v":520},17.263,20.409,81.405,585,null,{"$f":"L33+L43","v":92.76}]
[1,3,"Завтрак","гор.блюдо","Гуляш из филе грудок индейки",90,9.002,7.246,1.873,109,"ТТК июль 2021 г"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.602,5.068,35.906,212,"№309/2015г Дели"]
[{"$nulls":3},"гор.напиток","Напиток из шиповника",200,0.012,{"v":1E-3,"d":"0.001"},10.178,41,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":3},"закуска","Салат из свеклы отварной (с маслом)",60,0.855,3.653,5.016,56,"№52/2015г,Дели"]
[{"$nulls":4},"Маффин шоколадный",30,2.068,4.341,14.864,107,"ТТК от 19.06.2025 г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F51)","v":570},20.059000000000005,20.669,86.677,616,null,92.76]
[{"$f":"A45","v":1},3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F54:F62)","v":0},0,0,0,0,null,{"$f":"SUM(L54:L62)","v":0}]
[{"$f":"A45","v":1},3,"Итого за день:",null,null,{"$f":"F53+F63","v":570},20.059000000000005,20.669,86.677,616,null,{"$f":"L53+L63","v":92.76}]
[1,4,"Завтрак","гор.блюдо","Плов с говядиной",190,13.604,15.543,35.965,338,"ТТК 2021г"]
[]
[{"$nulls":3},"гор.напиток","Компот из свежих плодов (яблоки)",200,{"v":0.08,"d":"0.080"},{"v":0.08,"d":"0.080"},{"v":11.94,"d":"11.940"},49,"ТТК от 2021г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,{"v":0.4,"d":"0.400"},{"v":0.4,"d":"0.400"},{"v":9.8,"d":"9.800"},47,"№338 Дели 2015г "]
[{"$nulls":4},"Печенье сдобное шоколадное ",15,1.166,4.183,9.224,79,"ТТК(Акт19.09.2018г)"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F71)","v":545},17.77,20.566,85.769,604,null,92.76]
[{"$f":"A65","v":1},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F73:F81)","v":0},0,0,0,0,null,{"$f":"SUM(L73:L81)","v":0}]
[{"$f":"A65","v":1},4,"Итого за день:",null,null,{"$f":"F72+F82","v":545},17.77,20.566,85.769,604,null,{"$f":"L72+L82","v":92.76}]
[1,5,"Завтрак","гор.блюдо","Котлеты аппетитные мясо-куриные",90,9.069,6.869,8.996,134,"ТТК от 01.11.2022 г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.282,4.657,22.027,146,"№312/2015г Дели"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,{"v":2E-3,"d":"0.002"},7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":3},"закуска","Салат из моркови",60,0.702,3.051,{"v":6.72,"d":"6.720"},58,"№49 Сбор.2004г./ТТК"]
[{"$nulls":4},"Вафли весовые 1 шт",21,2.75,2.5,13,86]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F90)","v":569},18.33,17.439,77.569,547,null,92.76]
[{"$f":"A84","v":1},5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F93:F101)","v":0},0,0,0,0,null,{"$f":"SUM(L93:L101)","v":0}]
[{"$f":"A84","v":1},5,"Итого за день:",null,null,{"$f":"F92+F102","v":569},18.33,17.439,77.569,547,null,{"$f":"L92+L102","v":92.76}]
[2,1,"Завтрак","гор.блюдо","Котлеты куриные \"Нежные\"",90,10.857,10.288,8.947,172,"ТТК №1517 от 28.07.2021г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая",150,6.622,5.399,25.875,179,"№302/2015г,Дели"]
[{"$nulls":3},"гор.напиток","Напиток из вишни",200,{"v":0.12,"d":"0.120"},{"v":0.03,"d":"0.030"},{"v":11.57,"d":"11.570"},48,"ТТК №2694 от 14.09.2023 г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":4},"Фруктовое пюре",125,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":15,"d":"15.000"},60]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F104:F109)","v":605},{"$f":"SUM(G104:G109)","v":20.119},{"$f":"SUM(H104:H109)","v":16.077},{"$f":"SUM(I104:I109)","v":80.232},{"$f":"SUM(J104:J109)","v":550},null,92.76]
[{"$f":"A104","v":2},1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F112:F120)","v":0},0,0,0,0,null,{"$f":"SUM(L112:L120)","v":0}]
[{"$f":"A104","v":2},1,"Итого за день:",null,null,{"$f":"F111+F121","v":605},20.119,16.077,80.232,550,null,{"$f":"L111+L121","v":92.76}]
[2,2,"Завтрак","гор.блюдо","Жаркое по-домашнему",190,12.616,13.616,28.791,289,"ТТК 2023г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",208,0.007,{"v":2E-3,"d":"0.002"},7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,0.931,3.051,5.645,54,"№45/2015г,Дели"]
[{"$nulls":4},"Вафли весовые 1 шт",21,{"v":2.75,"d":"2.750"},{"v":2.5,"d":"2.500"},{"v":13,"d":"13.000"},86]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F123:F129)","v":519},18.823999999999998,19.529,74.262,552,null,92.76]
[{"$f":"A123","v":2},2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F132:F140)","v":0},0,0,0,0,null,{"$f":"SUM(L132:L140)","v":0}]
[{"$f":"A123","v":2},2,"Итого за день:",null,null,{"$f":"F131+F141","v":519},18.823999999999998,19.529,74.262,552,null,{"$f":"L131+L141","v":92.76}]
[2,3,"Завтрак","гор.блюдо","Плов с куриными грудками",190,{"v":12.76,"d":"12.760"},13.684,32.883,306,"ТТК 2021г"]
[]
[{"$nulls":3},"гор.напиток","Напиток из шиповника",200,0.012,{"v":1E-3,"d":"0.001"},10.178,41,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,{"v":0.4,"d":"0.400"},{"v":0.4,"d":"0.400"},{"v":9.8,"d":"9.800"},47,"№338 Дели 2015г "]
[]
[{"$nulls":4},"Батончик (в ассортименте)",30,{"v":1.8,"d":"1.800"},{"v":6.2,"d":"6.200"},{"v":15.4,"d":"15.400"},128]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F143:F149)","v":560},{"$f":"SUM(G143:G149)","v":17.492},20.645,87.10100000000001,613,null,92.76]
[{"$f":"A143","v":2},3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F152:F160)","v":0},0,0,0,0,null,{"$f":"SUM(L152:L160)","v":0}]
[{"$f":"A143","v":2},3,"Итого за день:",null,null,{"$f":"F151+F161","v":560},17.492,20.645,87.10100000000001,613,null,{"$f":"L151+L161","v":92.76}]
[2,4,"Завтрак","гор.блюдо","Фрикассе из куриных грудок",90,{"v":8.15,"d":"8.150"},5.604,3.241,96,"ТТК июль 2021г"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.602,5.068,35.906,212,"№309/2015г Дели"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,{"v":2E-3,"d":"0.002"},7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":3},"закуска","Салат любительский",60,0.971,5.053,3.05,63,"ТТК от 3.02.2022"]
[{"$nulls":4},"Кекс Волжский",50,2.754,3.843,18.934,121,"Актк/прораб. 10.11.2015г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F163:F169)","v":598},20.004,19.93,87.957,615,null,92.76]
[{"$f":"A163","v":2},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F172:F180)","v":0},0,0,0,0,null,{"$f":"SUM(L172:L180)","v":0}]
[{"$f":"A163","v":2},4,"Итого за день:",null,null,{"$f":"F171+F181","v":598},20.004,19.93,87.957,615,null,{"$f":"L171+L181","v":92.76}]
[2,5,"Завтрак","гор.блюдо","Котлеты сытные",90,11.659,8.304,8.104,154,"ТТК №3410 от 06.10.2023г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.282,4.657,22.027,146,"ТТК"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,{"v":0.8,"d":"0.800"},0.064,{"v":9.46,"d":"9.460"},42,"ТТК №2693 от 14.09.2023г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,{"v":2.52,"d":"2.520"},{"v":0.36,"d":"0.360"},{"v":18.84,"d":"18.840"},91]
[]
[{"$nulls":3},"закуска","Салат из моркови",60,0.702,3.051,{"v":6.72,"d":"6.720"},58,"№49 Сбор.2004г./ТТК"]
[{"$nulls":4},"Печенье сдобное Американер с кунжутом",15,1.246,4.314,{"v":9.27,"d":"9.270"},81]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F183:F189)","v":555},20.209,20.75,74.42099999999999,572,null,92.76]
[{"$f":"A183","v":2},5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F192:F200)","v":0},0,0,0,0,null,{"$f":"SUM(L192:L200)","v":0}]
[{"$f":"A183","v":2},5,"Итого за день:",null,null,{"$f":"F191+F201","v":555},20.209,20.75,74.42099999999999,572,null,{"$f":"L191+L201","v":92.76}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F44+F64+F83+F103+F122+F142+F162+F182+F202)/(IF(F24=0,0,1)+IF(F44=0,0,1)+IF(F64=0,0,1)+IF(F83=0,0,1)+IF(F103=0,0,1)+IF(F122=0,0,1)+IF(F142=0,0,1)+IF(F162=0,0,1)+IF(F182=0,0,1)+IF(F202=0,0,1))","v":574.6},{"$f":"(G24+G44+G64+G83+G103+G122+G142+G162+G182+G202)/(IF(G24=0,0,1)+IF(G44=0,0,1)+IF(G64=0,0,1)+IF(G83=0,0,1)+IF(G103=0,0,1)+IF(G122=0,0,1)+IF(G142=0,0,1)+IF(G162=0,0,1)+IF(G182=0,0,1)+IF(G202=0,0,1))","v":19.0225},{"$f":"(H24+H44+H64+H83+H103+H122+H142+H162+H182+H202)/(IF(H24=0,0,1)+IF(H44=0,0,1)+IF(H64=0,0,1)+IF(H83=0,0,1)+IF(H103=0,0,1)+IF(H122=0,0,1)+IF(H142=0,0,1)+IF(H162=0,0,1)+IF(H182=0,0,1)+IF(H202=0,0,1))","v":19.1933},{"$f":"(I24+I44+I64+I83+I103+I122+I142+I162+I182+I202)/(IF(I24=0,0,1)+IF(I44=0,0,1)+IF(I64=0,0,1)+IF(I83=0,0,1)+IF(I103=0,0,1)+IF(I122=0,0,1)+IF(I142=0,0,1)+IF(I162=0,0,1)+IF(I182=0,0,1)+IF(I202=0,0,1))","v":82.3249},{"$f":"(J24+J44+J64+J83+J103+J122+J142+J162+J182+J202)/(IF(J24=0,0,1)+IF(J44=0,0,1)+IF(J64=0,0,1)+IF(J83=0,0,1)+IF(J103=0,0,1)+IF(J122=0,0,1)+IF(J142=0,0,1)+IF(J162=0,0,1)+IF(J182=0,0,1)+IF(J202=0,0,1))","v":583.6},null,{"$f":"(L24+L44+L64+L83+L103+L122+L142+L162+L182+L202)/(IF(L24=0,0,1)+IF(L44=0,0,1)+IF(L64=0,0,1)+IF(L83=0,0,1)+IF(L103=0,0,1)+IF(L122=0,0,1)+IF(L142=0,0,1)+IF(L162=0,0,1)+IF(L182=0,0,1)+IF(L202=0,0,1))","v":92.76}]