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

{"sheet":"Лист1","index":0,"n_rows":181,"n_cols":12,"rows_kept":181,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[39,2,39,3],[57,2,57,3],[74,2,74,3],[92,2,92,3],[109,2,109,3],[126,2,126,3],[143,2,143,3],[161,2,161,3],[179,2,179,3],[180,2,180,4]]}
["Школа",null,"МБОУ \"Гимназия №179-цо\" г. Казань",null,null,"Утвердил:","должность","Заместитель Генерального директора"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Агапова А.К."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",30,12,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты из мяса птицы",90,10.493,9.73,6.771,157,"№338 Дели 2024"]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая",150,6.622,5.399,25.875,179,"№302/2015г Дели"]
[{"$nulls":3},"гор.напиток","Напиток из вишни",200,0.12,0.03,11.57,48,"ТТК №2694 от 14.09.2023"]
[{"$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,null,15,60]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":705},{"$f":"SUM(G6:G11)","v":20.155},{"$f":"SUM(H6:H11)","v":15.919},{"$f":"SUM(I6:I11)","v":87.856},{"$f":"SUM(J6:J11)","v":582},null,92.76]
[{"$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(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},0,0,0,null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":705},{"$f":"G12+G22","v":20.155},15.919,87.856,582,null,{"$f":"L12+L22","v":92.76}]
[1,2,"Завтрак","гор.блюдо","Жаркое из птицы (грудки куриные)",190,11.912,10.698,29.09,260,"ТТК№2739 от 07.12.2023"]
[{"$nulls":3},"гор.напиток","Напиток яблочный",200,0.1,0.1,12.43,52,"№701 Сбор.рецеп.2004"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"закуска","Салат из белокачанной капусты",60,0.931,3.051,5.645,54,"№45/2015 Дели"]
[{"$nulls":3},"конд. изд.","Батончик (в ассортименте)",30,1.8,6.2,15.4,128]
[{"$nulls":3},"итого",null,{"$f":"SUM(F24:F28)","v":520},{"$f":"SUM(G24:G28)","v":17.263},{"$f":"SUM(H24:H28)","v":20.409},{"$f":"SUM(I24:I28)","v":81.405},{"$f":"SUM(J24:J28)","v":585},null,92.76]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F30:F38)","v":0},{"$f":"SUM(G30:G38)","v":0},{"$f":"SUM(H30:H38)","v":0},{"$f":"SUM(I30:I38)","v":0},{"$f":"SUM(J30:J38)","v":0},null,0]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F29+F39","v":520},{"$f":"G29+G39","v":17.263},{"$f":"H29+H39","v":20.409},{"$f":"I29+I39","v":81.405},{"$f":"J29+J39","v":585},null,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,1E-3,10.178,41,"ТТК от 2021"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"закуска","Салат из свеклы отварной (с маслом)",60,0.855,3.653,5.016,56,"№52/2015гДели"]
[{"$nulls":3},"конд. изд.","Маффин шоколадный",30,2.068,4.341,14.864,107,"от1.03.2019"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F41:F46)","v":570},{"$f":"SUM(G41:G46)","v":20.059000000000005},{"$f":"SUM(H41:H46)","v":20.669},{"$f":"SUM(I41:I46)","v":86.677},{"$f":"SUM(J41:J46)","v":616},null,92.76]
[{"$f":"A41","v":1},{"$f":"B41","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F48:F56)","v":0},{"$f":"SUM(G48:G56)","v":0},{"$f":"SUM(H48:H56)","v":0},{"$f":"SUM(I48:I56)","v":0},{"$f":"SUM(J48:J56)","v":0},null,0]
[{"$f":"A41","v":1},{"$f":"B41","v":3},"Итого за день:",null,null,{"$f":"F47+F57","v":570},{"$f":"G47+G57","v":20.059000000000005},{"$f":"H47+H57","v":20.669},{"$f":"I47+I57","v":86.677},{"$f":"J47+J57","v":616},null,92.76]
[1,4,"Завтрак","гор.блюдо","Плов с говядиной",190,13.604,15.543,35.965,338,"ТТК 2021 г июль"]
[{"$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":3},"конд. изд.","Печенье сдобное шоколадное",15,1.166,4.183,9.224,79]
[{"$nulls":3},"итого",null,{"$f":"SUM(F59:F63)","v":545},{"$f":"SUM(G59:G63)","v":17.77},{"$f":"SUM(H59:H63)","v":20.566},{"$f":"SUM(I59:I63)","v":85.769},{"$f":"SUM(J59:J63)","v":604},null,92.76]
[{"$f":"A59","v":1},{"$f":"B59","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F73)","v":0},{"$f":"SUM(G65:G73)","v":0},{"$f":"SUM(H65:H73)","v":0},{"$f":"SUM(I65:I73)","v":0},{"$f":"SUM(J65:J73)","v":0},null,0]
[{"$f":"A59","v":1},{"$f":"B59","v":4},"Итого за день:",null,null,{"$f":"F64+F74","v":545},{"$f":"G64+G74","v":17.77},{"$f":"H64+H74","v":20.566},{"$f":"I64+I74","v":85.769},{"$f":"J64+J74","v":604},null,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,2E-3,7.986,32,"ТТК от 2021"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"конд.изд.","Вафли весовые",21,2.75,2.5,13,86]
[{"$nulls":3},"закуска","Салат из моркови",60,0.702,3.051,6.72,58,"ТТК"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F76:F81)","v":569},{"$f":"SUM(G76:G81)","v":18.33},{"$f":"SUM(H76:H81)","v":17.439},{"$f":"SUM(I76:I81)","v":77.569},{"$f":"SUM(J76:J81)","v":547},null,92.76]
[{"$f":"A76","v":1},{"$f":"B76","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F83:F91)","v":0},{"$f":"SUM(G83:G91)","v":0},{"$f":"SUM(H83:H91)","v":0},{"$f":"SUM(I83:I91)","v":0},{"$f":"SUM(J83:J91)","v":0},null,0]
[{"$f":"A76","v":1},{"$f":"B76","v":5},"Итого за день:",null,null,{"$f":"F82+F92","v":569},{"$f":"G82+G92","v":18.33},{"$f":"H82+H92","v":17.439},{"$f":"I82+I92","v":77.569},{"$f":"J82+J92","v":547},null,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,"№303/2015г Дели"]
[{"$nulls":3},"гор.напиток","Напиток из вишни",200,0.12,0.03,11.57,48,"ТТК №2694 от 14.09.2023"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":4},"Фруктовое пюре",125,0,0,15,60]
[{"$nulls":3},"итого",null,{"$f":"SUM(F94:F98)","v":605},{"$f":"SUM(G94:G98)","v":20.119},{"$f":"SUM(H94:H98)","v":16.077},{"$f":"SUM(I94:I98)","v":80.232},{"$f":"SUM(J94:J98)","v":550},null,92.76]
[{"$f":"A94","v":2},{"$f":"B94","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F100:F108)","v":0},{"$f":"SUM(G100:G108)","v":0},0,0,0,null,{"$f":"SUM(L100:L108)","v":0}]
[{"$f":"A94","v":2},{"$f":"B94","v":1},"Итого за день:",null,null,{"$f":"F99+F109","v":605},{"$f":"G99+G109","v":20.119},{"$f":"H99+H109","v":16.077},{"$f":"I99+I109","v":80.232},{"$f":"J99+J109","v":550},null,92.76]
[2,2,"Завтрак","гор.блюдо","Жаркое по-домашнему",190,12.616,13.616,28.791,289,"ТТК 2023г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.007,2E-3,7.986,32,"ТТК от 2023г"]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный/ Хлеб пшеничный",42,2.52,0.36,18.84,91]
[{"$nulls":3},"закуска","Салат из белокачанной капусты",60,0.931,3.051,5.645,54,"№45/2015 Дели"]
[{"$nulls":3},"конд. изд.","Вафли весовые",21,2.75,2.5,13,86]
[{"$nulls":3},"итого",null,{"$f":"SUM(F111:F115)","v":521},{"$f":"SUM(G111:G115)","v":18.823999999999998},{"$f":"SUM(H111:H115)","v":19.529},{"$f":"SUM(I111:I115)","v":74.262},{"$f":"SUM(J111:J115)","v":552},null,92.76]
[{"$f":"A111","v":2},{"$f":"B111","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F117:F125)","v":0},{"$f":"SUM(G117:G125)","v":0},0,0,0,null,{"$f":"SUM(L117:L125)","v":0}]
[{"$f":"A111","v":2},{"$f":"B111","v":2},"Итого за день:",null,null,{"$f":"F116+F126","v":521},{"$f":"G116+G126","v":18.823999999999998},{"$f":"H116+H126","v":19.529},{"$f":"I116+I126","v":74.262},{"$f":"J116+J126","v":552},null,92.76]
[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":3},"конд. изд.","Батончик (в ассортименте)",30,1.8,6.2,15.4,128]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F132)","v":560},{"$f":"SUM(G128:G132)","v":17.492},{"$f":"SUM(H128:H132)","v":20.645},{"$f":"SUM(I128:I132)","v":87.10100000000001},{"$f":"SUM(J128:J132)","v":613},null,92.76]
[{"$f":"A128","v":2},{"$f":"B128","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F134:F142)","v":0},{"$f":"SUM(G134:G142)","v":0},0,0,0,null,{"$f":"SUM(L134:L142)","v":0}]
[{"$f":"A128","v":2},{"$f":"B128","v":3},"Итого за день:",null,null,{"$f":"F133+F143","v":560},{"$f":"G133+G143","v":17.492},{"$f":"H133+H143","v":20.645},{"$f":"I133+I143","v":87.10100000000001},{"$f":"J133+J143","v":613},null,92.76]
[2,4,"Завтрак","гор.блюдо","Фрикассе из куриных грудок",90,8.15,5.604,3.241,96,"ТТК июль 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.971,5.053,3.05,63,"ТТКот 3.02.2022"]
[{"$nulls":3},"конд. изд.","Кекс волжский",50,2.754,3.843,18.934,121,"Акт к/прораб.10.11.2015"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F145:F150)","v":598},{"$f":"SUM(G145:G150)","v":20.004},{"$f":"SUM(H145:H150)","v":19.93},{"$f":"SUM(I145:I150)","v":87.957},{"$f":"SUM(J145:J150)","v":615},null,92.76]
[{"$f":"A145","v":2},{"$f":"B145","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F152:F160)","v":0},{"$f":"SUM(G152:G160)","v":0},0,0,0,null,{"$f":"SUM(L152:L160)","v":0}]
[{"$f":"A145","v":2},{"$f":"B145","v":4},"Итого за день:",null,null,{"$f":"F151+F161","v":598},{"$f":"G151+G161","v":20.004},{"$f":"H151+H161","v":19.93},{"$f":"I151+I161","v":87.957},{"$f":"J151+J161","v":615},null,92.76]
[2,5,"Завтрак","гор.блюдо","Котлеты сытные",90,11.659,8.304,8.104,154,"ТТК №3410 от 06.10.2025 г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.282,4.657,22.027,146,"№312/2015 Дели"]
[{"$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.702,3.051,6.72,58,"ТТК"]
[{"$nulls":3},"конд. изд.","Печенье сдобное Американер с кунжутом",15,1.246,4.314,9.27,81,"№338"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F163:F168)","v":555},{"$f":"SUM(G163:G168)","v":20.209},{"$f":"SUM(H163:H168)","v":20.75},{"$f":"SUM(I163:I168)","v":74.42099999999999},{"$f":"SUM(J163:J168)","v":572},null,92.76]
[{"$f":"A163","v":2},{"$f":"B163","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F170:F178)","v":0},{"$f":"SUM(G170:G178)","v":0},0,0,0,null,{"$f":"SUM(L170:L178)","v":0}]
[{"$f":"A163","v":2},{"$f":"B163","v":5},"Итого за день:",null,null,{"$f":"F169+F179","v":555},{"$f":"G169+G179","v":20.209},{"$f":"H169+H179","v":20.75},{"$f":"I169+I179","v":74.42099999999999},{"$f":"J169+J179","v":572},null,92.76]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F40+F58+F75+F93+F110+F127+F144+F162+F180)/(IF(F23=0,0,1)+IF(F40=0,0,1)+IF(F58=0,0,1)+IF(F75=0,0,1)+IF(F93=0,0,1)+IF(F110=0,0,1)+IF(F127=0,0,1)+IF(F144=0,0,1)+IF(F162=0,0,1)+IF(F180=0,0,1))","v":574.8},{"$f":"(G23+G40+G58+G75+G93+G110+G127+G144+G162+G180)/(IF(G23=0,0,1)+IF(G40=0,0,1)+IF(G58=0,0,1)+IF(G75=0,0,1)+IF(G93=0,0,1)+IF(G110=0,0,1)+IF(G127=0,0,1)+IF(G144=0,0,1)+IF(G162=0,0,1)+IF(G180=0,0,1))","v":19.0225},{"$f":"(H23+H40+H58+H75+H93+H110+H127+H144+H162+H180)/(IF(H23=0,0,1)+IF(H40=0,0,1)+IF(H58=0,0,1)+IF(H75=0,0,1)+IF(H93=0,0,1)+IF(H110=0,0,1)+IF(H127=0,0,1)+IF(H144=0,0,1)+IF(H162=0,0,1)+IF(H180=0,0,1))","v":19.1933},{"$f":"(I23+I40+I58+I75+I93+I110+I127+I144+I162+I180)/(IF(I23=0,0,1)+IF(I40=0,0,1)+IF(I58=0,0,1)+IF(I75=0,0,1)+IF(I93=0,0,1)+IF(I110=0,0,1)+IF(I127=0,0,1)+IF(I144=0,0,1)+IF(I162=0,0,1)+IF(I180=0,0,1))","v":82.3249},{"$f":"(J23+J40+J58+J75+J93+J110+J127+J144+J162+J180)/(IF(J23=0,0,1)+IF(J40=0,0,1)+IF(J58=0,0,1)+IF(J75=0,0,1)+IF(J93=0,0,1)+IF(J110=0,0,1)+IF(J127=0,0,1)+IF(J144=0,0,1)+IF(J162=0,0,1)+IF(J180=0,0,1))","v":583.6},null,{"$f":"(L23+L40+L58+L75+L93+L110+L127+L144+L162+L180)/(IF(L23=0,0,1)+IF(L40=0,0,1)+IF(L58=0,0,1)+IF(L75=0,0,1)+IF(L93=0,0,1)+IF(L110=0,0,1)+IF(L127=0,0,1)+IF(L144=0,0,1)+IF(L162=0,0,1)+IF(L180=0,0,1))","v":92.76}]