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

{"sheet":"Лист1","index":0,"n_rows":198,"n_cols":12,"rows_kept":198,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[24,2,24,3],[43,2,43,3],[63,2,63,3],[82,2,82,3],[101,2,101,3],[120,2,120,3],[139,2,139,3],[158,2,158,3],[177,2,177,3],[196,2,196,3],[197,2,197,4]]}
["Школа",null,"МБОУ \"Гимназия №152 г.Казани\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Сорокина Н.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",26,9,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","каша вязкая молочная из пшенной крупы с маслом",155,8.603,6.988,20.069,178,"173/2015",89.77]
[{"$nulls":4},"сосиски отварные",50,6.1,5.132,1.5,77,"243/2015"]
[{"$nulls":3},"гор.напиток","напиток из шиповника",200,0.012,1E-3,10.178,41,"ттк2021"]
[{"$nulls":3},"хлеб","батон",30,2.25,0.87,15.42,79]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"батончик \"Финики-кокос-кунжут\"",16.5,1,3.4,8.5,70]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,2015]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":551.5},{"$f":"SUM(G6:G13)","v":18.365},16.790999999999997,65.467,492,null,{"$f":"SUM(L6:L13)","v":89.77}]
[{"$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(F15:F23)","v":0},{"$f":"SUM(G15:G23)","v":0},0,0,0,null,{"$f":"SUM(L15:L23)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F14+F24","v":551.5},{"$f":"G14+G24","v":18.365},16.790999999999997,65.467,492,null,{"$f":"L14+L24","v":89.77}]
[1,2,"Завтрак","гор.блюдо","каша вязкая молочная из геркулесовой крупы с маслом",155,7.349,5.596,28.525,194,"173/2015",89.77]
[{"$nulls":4},"блинчики со сгущенным молоком",60,3.555,1.949,22.275,121,"ттк2018"]
[{"$nulls":3},"гор.напиток","чай с сахаром",208,0.021,0.005,7.989,32,"ттк2021"]
[{"$nulls":3},"хлеб","бутерброд с сыром",50,4.96,8.08,15.5,155,"2015-03-01"]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"творог детский в упаковке ДМК",50,4,5,1.95,69]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F32)","v":523},{"$f":"SUM(G26:G32)","v":19.885},{"$f":"SUM(H26:H32)","v":20.63},{"$f":"SUM(I26:I32)","v":76.23899999999999},{"$f":"SUM(J26:J32)","v":571},null,89.77]
[{"$f":"A26","v":1},{"$f":"B26","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},{"$f":"SUM(G34:G42)","v":0},{"$f":"SUM(H34:H42)","v":0},{"$f":"SUM(I34:I42)","v":0},{"$f":"SUM(J34:J42)","v":0},null,0]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F33+F43","v":523},{"$f":"G33+G43","v":19.885},{"$f":"H33+H43","v":20.63},{"$f":"I33+I43","v":76.23899999999999},{"$f":"J33+J43","v":571},null,89.77]
[1,3,"Завтрак","гор.блюдо","макаронны отварные с сыром, маслом",185,7.597,9.348,33.995,251,"ттк2019",89.77]
[]
[{"$nulls":3},"гор.напиток","напиток из вишни",200,0.12,0.03,11.57,48,"ттк2023"]
[{"$nulls":3},"хлеб","батон",30,2.25,0.87,15.42,79]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"кисломолочный продукт ДМК",125,3.5,3.125,5.125,63]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"338/2015"]
[{"$nulls":4},"печенье весовое",16,1.104,2.208,11.856,71]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F52)","v":656},{"$f":"SUM(G45:G52)","v":14.971},{"$f":"SUM(H45:H52)","v":15.981},{"$f":"SUM(I45:I52)","v":87.76599999999999},{"$f":"SUM(J45:J52)","v":559},null,89.77]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F54:F62)","v":0},{"$f":"SUM(G54:G62)","v":0},{"$f":"SUM(H54:H62)","v":0},{"$f":"SUM(I54:I62)","v":0},{"$f":"SUM(J54:J62)","v":0},null,0]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Итого за день:",null,null,{"$f":"F53+F63","v":656},{"$f":"G53+G63","v":14.971},{"$f":"H53+H63","v":15.981},{"$f":"I53+I63","v":87.76599999999999},{"$f":"J53+J63","v":559},null,89.77]
[1,4,"Завтрак","гор.блюдо","каша вязкая молочная из полбяной крупы с маслом ",155,8.917,8.565,25.059,213,"ттк",89.77]
[]
[{"$nulls":3},"гор.напиток","напиток из шиповника",200,0.012,1E-3,10.178,41,"ттк2021"]
[{"$nulls":3},"хлеб","батон",30,2.25,0.87,15.42,79]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"оладьи со сгущенным молоком",80,3.8,6.938,13.5,132,"ттк2025"]
[{"$nulls":4},"фруктовое пюре",125,null,null,15,60]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F71)","v":590},{"$f":"SUM(G65:G71)","v":14.979},{"$f":"SUM(H65:H71)","v":16.374},{"$f":"SUM(I65:I71)","v":79.15700000000001},{"$f":"SUM(J65:J71)","v":525},null,89.77]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F73:F81)","v":0},{"$f":"SUM(G73:G81)","v":0},{"$f":"SUM(H73:H81)","v":0},{"$f":"SUM(I73:I81)","v":0},{"$f":"SUM(J73:J81)","v":0},null,0]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Итого за день:",null,null,{"$f":"F72+F82","v":590},{"$f":"G72+G82","v":14.979},{"$f":"H72+H82","v":16.374},{"$f":"I72+I82","v":79.15700000000001},{"$f":"J72+J82","v":525},null,89.77]
[1,5,"Завтрак","гор.блюдо","каша вязкая молочная из рисовой и пшенной крупы с маслом",155,8.664,5.325,24.377,180,"175/2015",89.77]
[]
[{"$nulls":3},"гор.напиток","напиток из вишни",200,0.12,0.03,11.57,48,"ттк2023"]
[{"$nulls":3},"хлеб","батон ",30,2.25,0.87,15.42,79]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"кекс волжский",50,5.5,10.4,17.8,187,"акт2015"]
[{"$nulls":4},"кисломолочный продукт ДМК",125,3.5,3.125,5.125,63]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F90)","v":560},{"$f":"SUM(G84:G90)","v":20.034},{"$f":"SUM(H84:H90)","v":19.75},{"$f":"SUM(I84:I90)","v":74.292},{"$f":"SUM(J84:J90)","v":557},null,89.77]
[{"$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},{"$f":"SUM(G92:G100)","v":0},{"$f":"SUM(H92:H100)","v":0},{"$f":"SUM(I92:I100)","v":0},{"$f":"SUM(J92:J100)","v":0},null,0]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Итого за день:",null,null,{"$f":"F91+F101","v":560},{"$f":"G91+G101","v":20.034},{"$f":"H91+H101","v":19.75},{"$f":"I91+I101","v":74.292},{"$f":"J91+J101","v":557},null,89.77]
[2,1,"Завтрак","гор.блюдо","каша гречневая вязкая",150,3.462,4.634,21.789,143,"ттк2014",89.77]
[{"$nulls":4},"бифштекс рубленный по-домашнему с соусом для запекания",90,11.535,14.852,10.026,220,"ттк2022"]
[{"$nulls":3},"гор.напиток","компот из замороженной компотной смеси",200,0.135,0.023,11.15,46,"ттк2021"]
[{"$nulls":3},"хлеб","хлеб пшеничный/хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"овощные палочки из огурцов",30,0.21,0.03,0.57,3,"ттк2021"]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,2015]
[{"$nulls":3},"итого",null,{"$f":"SUM(F103:F109)","v":610},{"$f":"SUM(G103:G109)","v":18.262},20.299,72.17500000000001,550,null,{"$f":"SUM(L103:L109)","v":89.77}]
[{"$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},{"$f":"SUM(G111:G119)","v":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":610},{"$f":"G110+G120","v":18.262},{"$f":"H110+H120","v":20.299},{"$f":"I110+I120","v":72.17500000000001},{"$f":"J110+J120","v":550},null,89.77]
[2,2,"Завтрак","гор.блюдо","жаркое из филе куриных грудок",190,14.363,15.717,29.286,316,"ттк2021",89.77]
[{"$nulls":4},"овощи натуральные свежие (помидоры)",60,0.66,0.12,2.28,14,"71/2015"]
[{"$nulls":3},"гор.напиток","чай с сахаром",208,0.021,0.005,7.989,32,"ттк 2021"]
[{"$nulls":3},"хлеб","хлеб пшеничный/хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"338/2015"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F128)","v":598},{"$f":"SUM(G122:G128)","v":17.964},16.602,68.195,500,null,{"$f":"SUM(L122:L128)","v":89.77}]
[{"$f":"A122","v":2},{"$f":"B122","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F130:F138)","v":0},{"$f":"SUM(G130:G138)","v":0},0,0,0,null,{"$f":"SUM(L130:L138)","v":0}]
[{"$f":"A122","v":2},{"$f":"B122","v":2},"Итого за день:",null,null,{"$f":"F129+F139","v":598},{"$f":"G129+G139","v":17.964},{"$f":"H129+H139","v":16.602},{"$f":"I129+I139","v":68.195},{"$f":"J129+J139","v":500},null,89.77]
[2,3,"Завтрак","гор.блюдо","пельмени для умников и умниц отварные с маслом",185,15.935,13.359,38.197,337,"ттк2015",89.77]
[{"$nulls":4},"батончик \"финики-кокос-кунжут\"",16.5,1,3.4,8.5,70]
[{"$nulls":3},"гор.напиток","напиток из шиповника",200,0.012,1E-3,10.178,41,"ттк2021"]
[{"$nulls":3},"хлеб","хлеб пшеничный/хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"салат из моркови",60,0.709,3.052,6.759,58,"49/2004"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F141:F147)","v":501.5},{"$f":"SUM(G141:G147)","v":20.176000000000002},20.172,82.474,597,null,{"$f":"SUM(L141:L147)","v":89.77}]
[{"$f":"A141","v":2},{"$f":"B141","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F149:F157)","v":0},{"$f":"SUM(G149:G157)","v":0},0,0,0,null,{"$f":"SUM(L149:L157)","v":0}]
[{"$f":"A141","v":2},{"$f":"B141","v":3},"Итого за день:",null,null,{"$f":"F148+F158","v":501.5},{"$f":"G148+G158","v":20.176000000000002},{"$f":"H148+H158","v":20.172},{"$f":"I148+I158","v":82.474},{"$f":"J148+J158","v":597},null,89.77]
[2,4,"Завтрак","гор.блюдо","макаронные изделия отварные",150,5.602,3.868,29.306,174,"309/2015",89.77]
[{"$nulls":4},"фрикасе из куриных грудок",90,8.026,8.476,1.236,113,"ттк2021"]
[{"$nulls":3},"гор.напиток","компот из замороженной компотной смеси",200,0.135,0.023,11.15,46,"ттк2021"]
[{"$nulls":3},"хлеб","хлеб пшеничный/хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"салат из свеклы",60,0.855,3.653,5.016,56,"2015/52"]
[{"$nulls":4},"маффин классический",30,2.168,4.341,11.864,101]
[{"$nulls":3},"итого",null,{"$f":"SUM(F160:F166)","v":570},{"$f":"SUM(G160:G166)","v":19.306},20.721,77.412,581,null,{"$f":"SUM(L160:L166)","v":89.77}]
[{"$f":"A160","v":2},{"$f":"B160","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F168:F176)","v":0},{"$f":"SUM(G168:G176)","v":0},0,0,0,null,{"$f":"SUM(L168:L176)","v":0}]
[{"$f":"A160","v":2},{"$f":"B160","v":4},"Итого за день:",null,null,{"$f":"F167+F177","v":570},{"$f":"G167+G177","v":19.306},{"$f":"H167+H177","v":20.721},{"$f":"I167+I177","v":77.412},{"$f":"J167+J177","v":581},null,89.77]
[2,5,"Завтрак","гор.блюдо","картофель запеченный",150,3.507,8.224,28.402,202,"акт 2016",89.77]
[{"$nulls":4},"ежики мясные с рисом в соусе для запекания",90,9.683,3.838,9.085,110,"ттк2024"]
[{"$nulls":3},"гор.напиток","чай без сахара",200,0.021,0.005,0.005,0]
[{"$nulls":3},"хлеб","хлеб пшеничный/хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"овощи натуральные свежие (огурцы)",30,0.21,0.03,0.57,3,"71/2015"]
[{"$nulls":4},"печенье сдобное вкусное",30,2.216,8.233,18.848,158,"акт2019"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F179:F185)","v":540},{"$f":"SUM(G179:G185)","v":18.157},20.69,75.75,564,null,{"$f":"SUM(L179:L185)","v":89.77}]
[{"$f":"A179","v":2},{"$f":"B179","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F187:F195)","v":0},{"$f":"SUM(G187:G195)","v":0},0,0,0,null,{"$f":"SUM(L187:L195)","v":0}]
[{"$f":"A179","v":2},{"$f":"B179","v":5},"Итого за день:",null,null,{"$f":"F186+F196","v":540},{"$f":"G186+G196","v":18.157},{"$f":"H186+H196","v":20.69},{"$f":"I186+I196","v":75.75},{"$f":"J186+J196","v":564},null,89.77]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F44+F64+F83+F102+F121+F140+F159+F178+F197)/(IF(F25=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(F140=0,0,1)+IF(F159=0,0,1)+IF(F178=0,0,1)+IF(F197=0,0,1))","v":570},{"$f":"(G25+G44+G64+G83+G102+G121+G140+G159+G178+G197)/(IF(G25=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(G140=0,0,1)+IF(G159=0,0,1)+IF(G178=0,0,1)+IF(G197=0,0,1))","v":18.209900000000005},18.801,75.89270000000002,549.6,null,{"$f":"(L25+L44+L64+L83+L102+L121+L140+L159+L178+L197)/(IF(L25=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(L140=0,0,1)+IF(L159=0,0,1)+IF(L178=0,0,1)+IF(L197=0,0,1))","v":89.77}]