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

{"sheet":"Лист1","index":0,"n_rows":200,"n_cols":12,"rows_kept":200,"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],[101,2,101,3],[120,2,120,3],[140,2,140,3],[159,2,159,3],[179,2,179,3],[198,2,198,3],[199,2,199,4]]}
["Школа",null,"МБОУ \"Гимназия №18- \"Галэм\" Приволжского района г. Казани",null,null,"Согласовал:","должность","Заместитель генерального директора АО \"Департамент продовольствия и социального питания\" г.Казань"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Агапова А. К."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",28,2,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Наггетсы куриные с кукурузой консервированной",94,9.073,10.553,11.323,177,"ТТК от 17.01.2022 г"]
[{"$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},"хлеб ","Хлеб пшеничный",20,{"v":1.52,"d":"1.520"},{"v":0.16,"d":"0.160"},{"v":9.84,"d":"9.840"},47]
[]
[{"$nulls":4},"Творог детский в упаковке обнимама",50,{"v":4,"d":"4.000"},{"v":5,"d":"5.000"},{"v":1.95,"d":"1.950"},69]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":522},20.202,20.783,67.005,537,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":522},20.202,20.783,67.005,537,null,{"$f":"L13+L23","v":92.76}]
[1,2,"Завтрак","гор.блюдо","Картофель тушеный с фаршем",180,13.405,12.451,26.784,273,"ТТК № 3690 06.02.2026 г"]
[]
[{"$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.855,3.653,5.016,56,"№52/2015г,Дели"]
[{"$nulls":4},"Печенье сдобное Американер с кунжутом",15,1.246,4.314,{"v":9.27,"d":"9.270"},81,"ТТК  от 2021г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":503},{"$f":"SUM(G25:G31)","v":18.032999999999998},{"$f":"SUM(H25:H31)","v":20.78},{"$f":"SUM(I25:I31)","v":67.896},{"$f":"SUM(J25:J31)","v":533},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":503},18.032999999999998,20.78,67.896,533,null,{"$f":"L33+L43","v":92.76}]
[1,3,"Завтрак","гор.блюдо","Плов с куриными грудками",190,{"v":12.76,"d":"12.760"},13.684,32.883,306,"ТТК 2021г июль"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",213,0.052,0.007,8.136,34,"ТТК от 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(F45:F51)","v":573},17.532,20.651,85.05900000000001,606,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":573},17.532,20.651,85.05900000000001,606,null,{"$f":"L53+L63","v":92.76}]
[1,4,"Завтрак","гор.блюдо","Макаронник с мясом (запечённый)",180,16.664,20.084,40.538,410,"ТТК от 11.11.2021г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,{"v":2E-3,"d":"0.002"},7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный",20,{"v":1,"d":"1.000"},{"v":0.2,"d":"0.200"},{"v":9,"d":"9.000"},44]
[{"$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":3},"итого",null,{"$f":"SUM(F65:F71)","v":508},18.071,20.685999999999996,67.324,533,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":508},18.071,20.685999999999996,67.324,533,null,{"$f":"L72+L82","v":92.76}]
[1,5,"Завтрак","гор.блюдо","Котлеты сытные ",90,13.459,14.248,6.104,203,"ТТК №3410 от 06.10.2025г"]
[{"$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":4},"Сок фруктовый",200,{"v":0,"d":"0.000"},0,{"v":22,"d":"22.000"},90,"ТТК"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F89)","v":688},{"$f":"SUM(G84:G89)","v":19.268},{"$f":"SUM(H84:H89)","v":19.267},{"$f":"SUM(I84:I89)","v":76.957},{"$f":"SUM(J84:J89)","v":562},null,92.76]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F92:F100)","v":0},0,0,0,0,null,{"$f":"SUM(L92:L100)","v":0}]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Итого за день:",null,null,{"$f":"F91+F101","v":688},19.268,19.267,76.957,562,null,{"$f":"L91+L101","v":92.76}]
[2,1,"Завтрак","гор.блюдо","Фрикадельки из птицы в соусе",95,13.015,14.079,3.276,192,"ТТК №3340 от 11.08.2025"]
[{"$nulls":3},"гор.блюдо","Рис отварной",150,3.834,5.434,40.014,224,"№304/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":4},"Фруктовое пюре",125,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":15,"d":"15.000"},60]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F103:F108)","v":618},{"$f":"SUM(G103:G108)","v":19.376},{"$f":"SUM(H103:H108)","v":19.875},{"$f":"SUM(I103:I108)","v":85.116},{"$f":"SUM(J103:J108)","v":599},null,92.76]
[{"$f":"A103","v":2},{"$f":"B103","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F111:F119)","v":0},0,0,0,0,null,{"$f":"SUM(L111:L119)","v":0}]
[{"$f":"A103","v":2},{"$f":"B103","v":1},"Итого за день:",null,null,{"$f":"F110+F120","v":618},19.376,19.875,85.116,599,null,{"$f":"L110+L120","v":92.76}]
[2,2,"Завтрак","гор.блюдо","Грудка куриная (филе) по-французски",180,15.907,16.601,19.908,293,"ТТК (АКТ от 10.07.2019г Комбинат)"]
[]
[{"$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.855,3.653,5.016,56,"№52/2015г,Дели"]
[{"$nulls":4},"Батончики EGO",25,0.825,{"v":0.14,"d":"0.140"},{"v":16.55,"d":"16.550"},82,"УОП"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F128)","v":513},20.114,20.755999999999997,68.3,554,null,92.76]
[{"$f":"A122","v":2},2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F131:F139)","v":0},0,0,0,0,null,{"$f":"SUM(L131:L139)","v":0}]
[{"$f":"A122","v":2},2,"Итого за день:",null,null,{"$f":"F130+F140","v":513},20.114,20.755999999999997,68.3,554,null,{"$f":"L130+L140","v":92.76}]
[2,3,"Завтрак","гор.блюдо","Гуляш из филе грудок индейки",90,9.002,7.246,1.873,109,"ТТК июль 2021 г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая",150,6.622,5.399,25.875,179,"№302/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":4},"Пирог \"Зебра\"",50,2.033,6.686,31.785,195,"ТТК от 19.06.2025 г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F142:F147)","v":538},{"$f":"SUM(G142:G147)","v":20.184},{"$f":"SUM(H142:H147)","v":19.692999999999998},{"$f":"SUM(I142:I147)","v":86.359},{"$f":"SUM(J142:J147)","v":606},null,92.76]
[{"$f":"A142","v":2},{"$f":"B142","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F150:F158)","v":0},0,0,0,0,null,{"$f":"SUM(L150:L158)","v":0}]
[{"$f":"A142","v":2},{"$f":"B142","v":3},"Итого за день:",null,null,{"$f":"F149+F159","v":538},20.184,19.692999999999998,86.359,606,null,{"$f":"L149+L159","v":92.76}]
[2,4,"Завтрак","гор.блюдо","Плов с говядиной",190,13.604,15.543,45.965,378,"ТТК 2021г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,{"v":2E-3,"d":"0.002"},7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный",20,{"v":1,"d":"1.000"},{"v":0.2,"d":"0.200"},{"v":9,"d":"9.000"},44]
[{"$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(F161:F167)","v":533},16.177,20.328,81.97500000000001,580,null,92.76]
[{"$f":"A161","v":2},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F170:F178)","v":0},0,0,0,0,null,{"$f":"SUM(L170:L178)","v":0}]
[{"$f":"A161","v":2},4,"Итого за день:",null,null,{"$f":"F169+F179","v":533},16.177,20.328,81.97500000000001,580,null,{"$f":"L169+L179","v":92.76}]
[2,5,"Завтрак","гор.блюдо","Котлеты аппетитные мясо-куриные",90,12.769,13.869,7.996,204,"ТТК от 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},"хлеб ","Хлеб пшеничный",20,{"v":1.52,"d":"1.520"},{"v":0.16,"d":"0.160"},{"v":9.84,"d":"9.840"},47]
[]
[{"$nulls":4},"Сок фруктовый",200,{"v":0,"d":"0.000"},0,{"v":22,"d":"22.000"},90,"ТТК"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F181:F186)","v":668},{"$f":"SUM(G181:G186)","v":17.578000000000003},{"$f":"SUM(H181:H186)","v":18.688},{"$f":"SUM(I181:I186)","v":69.849},{"$f":"SUM(J181:J186)","v":519},null,92.76]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F189:F197)","v":0},0,0,0,0,null,{"$f":"SUM(L189:L197)","v":0}]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Итого за день:",null,null,{"$f":"F188+F198","v":668},17.578000000000003,18.688,69.849,519,null,{"$f":"L188+L198","v":92.76}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F44+F64+F83+F102+F121+F141+F160+F180+F199)/(IF(F24=0,0,1)+IF(F44=0,0,1)+IF(F64=0,0,1)+IF(F83=0,0,1)+IF(F102=0,0,1)+IF(F121=0,0,1)+IF(F141=0,0,1)+IF(F160=0,0,1)+IF(F180=0,0,1)+IF(F199=0,0,1))","v":566.4},{"$f":"(G24+G44+G64+G83+G102+G121+G141+G160+G180+G199)/(IF(G24=0,0,1)+IF(G44=0,0,1)+IF(G64=0,0,1)+IF(G83=0,0,1)+IF(G102=0,0,1)+IF(G121=0,0,1)+IF(G141=0,0,1)+IF(G160=0,0,1)+IF(G180=0,0,1)+IF(G199=0,0,1))","v":18.6535},{"$f":"(H24+H44+H64+H83+H102+H121+H141+H160+H180+H199)/(IF(H24=0,0,1)+IF(H44=0,0,1)+IF(H64=0,0,1)+IF(H83=0,0,1)+IF(H102=0,0,1)+IF(H121=0,0,1)+IF(H141=0,0,1)+IF(H160=0,0,1)+IF(H180=0,0,1)+IF(H199=0,0,1))","v":20.150699999999997},{"$f":"(I24+I44+I64+I83+I102+I121+I141+I160+I180+I199)/(IF(I24=0,0,1)+IF(I44=0,0,1)+IF(I64=0,0,1)+IF(I83=0,0,1)+IF(I102=0,0,1)+IF(I121=0,0,1)+IF(I141=0,0,1)+IF(I160=0,0,1)+IF(I180=0,0,1)+IF(I199=0,0,1))","v":75.58400000000002},{"$f":"(J24+J44+J64+J83+J102+J121+J141+J160+J180+J199)/(IF(J24=0,0,1)+IF(J44=0,0,1)+IF(J64=0,0,1)+IF(J83=0,0,1)+IF(J102=0,0,1)+IF(J121=0,0,1)+IF(J141=0,0,1)+IF(J160=0,0,1)+IF(J180=0,0,1)+IF(J199=0,0,1))","v":562.9},null,{"$f":"(L24+L44+L64+L83+L102+L121+L141+L160+L180+L199)/(IF(L24=0,0,1)+IF(L44=0,0,1)+IF(L64=0,0,1)+IF(L83=0,0,1)+IF(L102=0,0,1)+IF(L121=0,0,1)+IF(L141=0,0,1)+IF(L160=0,0,1)+IF(L180=0,0,1)+IF(L199=0,0,1))","v":92.76}]