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

{"sheet":"Лист1","index":0,"n_rows":204,"n_cols":12,"rows_kept":204,"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],[122,2,122,3],[142,2,142,3],[162,2,162,3],[182,2,182,3],[202,2,202,3],[203,2,203,4]]}
[" Школа",null,"МБОУ \"Гимназия №18- \"Галэм\" Приволжского района г.Казани",null,null,"Утвердил:","должность","Заместитель генерального директора АО\"Департамент продовольствия и социального питания\" г.Казань"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Агапова А. К."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",29,11,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты из мяса птицы ",90,8.093,9.93,7.071,150,"ТТК от 2021г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая",150,6.622,5.399,25.875,179,"№302/2015г Дели"]
[{"$nulls":3},"гор.напиток","Компот из замороженной компотной смеси",200,0.135,0.023,11.15,46,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"№338 Дели 2015г"]
[{"$nulls":4},"Фруктовое пюре ",125,0,0,15,60]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":705},17.77,16.112,87.73599999999999,573,null,89.77]
[{"$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},17.77,16.112,87.73599999999999,573,null,{"$f":"L13+L23","v":89.77}]
[1,2,"Завтрак","гор.блюдо","Жаркое из птицы (грудки куриные)",190,12.912,10.698,33.99,284,"ТТК июль 2021г"]
[]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.064,9.46,42,"ТТК №2693 от 14.09.2023г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,0.931,3.051,5.645,54,"№45 Сбор. 2015г Дели"]
[{"$nulls":4},"Батончики (в ассортимент)",30,1.8,6.2,15.4,128]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":520},18.963000000000005,20.373,83.33500000000001,599,null,89.77]
[{"$f":"A25","v":1},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},2,"Итого за день:",null,null,{"$f":"F33+F43","v":520},18.963000000000005,20.373,83.33500000000001,599,null,{"$f":"L33+L43","v":89.77}]
[1,3,"Завтрак","гор.блюдо","Гуляш из филе грудок индейки",90,9.102,7.346,1.893,110,"ТТК 2021г июль"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.602,5.068,35.906,212,"№309/2015г. Дели"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",208,0.007,2E-3,7.986,32,"ТТК от 2021г."]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[]
[{"$nulls":3},"закуска","Салат из свеклы отварной (с маслом)",60,0.855,3.653,5.016,56,"Сб., М:ДеЛи плюс, 2015, рец.№52"]
[{"$nulls":4},"Маффин шоколадный",30,2.068,4.341,14.864,107,"от 1.03.2019г."]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F51)","v":578},20.154000000000003,20.77,84.50500000000001,608,null,89.77]
[{"$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":578},20.154000000000003,20.77,84.50500000000001,608,null,{"$f":"L53+L63","v":89.77}]
[1,4,"Завтрак","гор.блюдо","Плов с говядиной",190,13.604,15.543,35.965,338,"ТТК Сентябрь 2023г"]
[]
[{"$nulls":3},"гор.напиток","Компот из свежих плодов (яблоки)",200,0.08,0.08,11.94,49,"ТТК от 2021г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"№338 Дели 2015г"]
[{"$nulls":4},"Печенье сдобное шоколадное ",15,1.166,4.183,9.224,79,"Акт от 2021г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F71)","v":545},{"$f":"SUM(G65:G71)","v":17.77},20.566,85.769,604,null,89.77]
[{"$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":89.77}]
[1,5,"Завтрак","гор.блюдо","Котлеты аппетитные мясо-куриные",90,10.769,9.869,8.996,168,"ТТК №2144 от 1.11.2022г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.282,4.657,22.027,146,"по акту от 21.09.2020"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",208,0.007,2E-3,7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[]
[{"$nulls":3},"закуска","Салат из моркови",60,0.702,3.051,6.72,58,"№49 Сбор. 2004г/ТТК"]
[{"$nulls":4},"Вафли весовые 1 шт",21,2.75,2.5,13,86]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F90)","v":569},20.03,20.439,77.569,581,null,89.77]
[{"$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},20.03,20.439,77.569,581,null,{"$f":"L92+L102","v":89.77}]
[2,1,"Завтрак","гор.блюдо","Котлеты сытные ",90,13.159,13.248,8.104,204,"ТТК  №3408 от 06.10.2025г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая вязкая",150,3.5,4.643,22.028,144,"№303/2015г. Дели"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,2E-3,7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"№338 Дели 2015г"]
[]
[{"$nulls":4},"Оладьи со сгущеным молоком 1 шт",35,0.54,1.544,3.975,32,"ТТК от 2025г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F104:F110)","v":623},20.125999999999998,20.196999999999996,70.73299999999999,550,null,89.77]
[{"$f":"A104","v":2},1,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F113:F121)","v":0},0,0,0,0,null,{"$f":"SUM(L113:L121)","v":0}]
[{"$f":"A104","v":2},1,"Итого за день:",null,null,{"$f":"F112+F122","v":623},20.125999999999998,20.196999999999996,70.73299999999999,550,null,{"$f":"L112+L122","v":89.77}]
[2,2,"Завтрак","гор.блюдо","Жаркое по- домашнему",190,12.616,13.616,28.791,289,"ТТК Сентябрь 2023г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",208,0.007,2E-3,7.986,32,"ТТК от 2021г."]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,0.931,3.051,5.645,54,"№45 Сбор. 2015г. Дели"]
[{"$nulls":4},"Вафли весовые 1 шт",21,2.75,2.5,13,86]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F124:F130)","v":519},18.823999999999998,19.529,74.262,552,null,89.77]
[{"$f":"A124","v":2},2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F133:F141)","v":0},0,0,0,0,null,{"$f":"SUM(L133:L141)","v":0}]
[{"$f":"A124","v":2},2,"Итого за день:",null,null,{"$f":"F132+F142","v":519},18.823999999999998,19.529,74.262,552,null,{"$f":"L132+L142","v":89.77}]
[2,3,"Завтрак","гор.блюдо","Плов с куриными грудками",190,12.76,13.684,32.883,306,"ТТК 2021г июль"]
[]
[{"$nulls":3},"гор.напиток","Напиток из шиповника",200,0.012,1E-3,10.178,41,"ТТК от 2021г"]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"№338 Дели 2015г"]
[]
[{"$nulls":4},"Батончики (в ассортимент)",30,1.8,6.2,15.4,128]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F150)","v":560},{"$f":"SUM(G144:G150)","v":17.492},20.645,87.10100000000001,613,null,89.77]
[{"$f":"A144","v":2},3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F153:F161)","v":0},0,0,0,0,null,{"$f":"SUM(L153:L161)","v":0}]
[{"$f":"A144","v":2},3,"Итого за день:",null,null,{"$f":"F152+F162","v":560},17.492,20.645,87.10100000000001,613,null,{"$f":"L152+L162","v":89.77}]
[2,4,"Завтрак","гор.блюдо","Фрикассе из куриных грудок",100,9.055,7.071,3.601,114,"ТТК №3412 от 06.10.2025г"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.602,5.068,35.906,212,"№309/2015г. Дели"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,2E-3,7.986,32,"ТТК от 2021г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[]
[{"$nulls":3},"закуска","Салат из свеклы отварной ( с маслом)",60,0.855,3.653,5.016,56,"Сб., М:ДеЛи плюс, 2015, рец.№52"]
[{"$nulls":4},"Маффин классический",30,2.068,4.341,14.864,107,"ТТК от 19.06.2025г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F164:F170)","v":588},20.107000000000003,20.495,86.21300000000001,612,null,89.77]
[{"$f":"A164","v":2},4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F173:F181)","v":0},0,0,0,0,null,{"$f":"SUM(L173:L181)","v":0}]
[{"$f":"A164","v":2},4,"Итого за день:",null,null,{"$f":"F172+F182","v":588},20.107000000000003,20.495,86.21300000000001,612,null,{"$f":"L172+L182","v":89.77}]
[2,5,"Завтрак","гор.блюдо","Котлеты куриные \"Нежные\"",90,11.557,8.288,6.947,149,"ТТК №1517 от 28.07.2021г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.282,4.657,22.027,146,"по акту от 21.09.2020"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",208,0.007,2E-3,7.986,32,"ТТК от 2021г."]
[{"$nulls":3},"хлеб ","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[]
[{"$nulls":3},"закуска","Салат из моркови",60,0.702,3.051,6.72,58,"№49 Сбор. 2004г/ТТК"]
[{"$nulls":4},"Печенье сдобное Американер с кунжутом",15,1.246,4.314,9.27,81,"ТТК от 2021г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F184:F190)","v":563},19.313999999999997,20.672,71.78999999999999,557,null,89.77]
[{"$f":"A184","v":2},5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F193:F201)","v":0},0,0,0,0,null,{"$f":"SUM(L193:L201)","v":0}]
[{"$f":"A184","v":2},5,"Итого за день:",null,null,{"$f":"F192+F202","v":563},19.313999999999997,20.672,71.78999999999999,557,null,{"$f":"L192+L202","v":89.77}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F44+F64+F83+F103+F123+F143+F163+F183+F203)/(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(F123=0,0,1)+IF(F143=0,0,1)+IF(F163=0,0,1)+IF(F183=0,0,1)+IF(F203=0,0,1))","v":577},19.055,19.9798,80.9013,584.9,null,{"$f":"(L24+L44+L64+L83+L103+L123+L143+L163+L183+L203)/(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(L123=0,0,1)+IF(L143=0,0,1)+IF(L163=0,0,1)+IF(L183=0,0,1)+IF(L203=0,0,1))","v":89.77}]