{"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],[24,2,24,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],[178,2,178,3],[198,2,198,3],[199,2,199,4]]}
["Школа",null,"МБОУ \"Школа №57 г.Казани\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Панарина Э.Н."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",9,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","каша гречневая рассыпчатая",150,6.622,5.399,25.875,179,null,92.76]
[{"$nulls":4},"котлеты из птицы запеченные",90,10.493,9.73,6.771,157]
[{"$nulls":3},"гор.напиток","напиток из вишни",200,0.12,0.03,11.57,48]
[{"$nulls":3},"хлеб","хлеб пшеничный/ хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":4},"фруктовое пюре",125,0,0,15,60]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":705},{"$f":"SUM(G6:G13)","v":20.155},15.919,87.856,582,null,{"$f":"SUM(L6:L13)","v":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(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":705},{"$f":"G14+G24","v":20.155},15.919,87.856,582,null,{"$f":"L14+L24","v":92.76}]
[1,2,"Завтрак","гор.блюдо","жаркое из филе куриных грудок",190,11.912,10.698,29.09,260,"ттк2021",92.76]
[]
[{"$nulls":3},"гор.напиток","напиток яблочный",200,0.1,0.1,12.43,52,"701/2004"]
[{"$nulls":3},"хлеб","хлеб пшеничный/ хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"салат из белокачанной капусты",60,0.931,3.051,5.645,54,"45/2015"]
[{"$nulls":4},"батончик",30,1.8,6.2,15.4,128,"15/2015"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F32)","v":520},{"$f":"SUM(G26:G32)","v":17.263},{"$f":"SUM(H26:H32)","v":20.409},{"$f":"SUM(I26:I32)","v":81.405},{"$f":"SUM(J26:J32)","v":585},null,92.76]
[{"$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":520},{"$f":"G33+G43","v":17.263},{"$f":"H33+H43","v":20.409},{"$f":"I33+I43","v":81.405},{"$f":"J33+J43","v":585},null,92.76]
[1,3,"Завтрак","гор.блюдо","макаронные изделия отварные",150,5.602,5.068,35.906,212,"309/2015",92.76]
[{"$nulls":4},"гуляш из филе грудок индейки",90,9.002,7.246,1.873,109,"ттк2021"]
[{"$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.855,3.653,5.016,56,"2015/52"]
[{"$nulls":4},"маффин шоколадный",30,2.068,4.341,14.864,107,2019]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F52)","v":570},{"$f":"SUM(G45:G52)","v":20.059000000000005},{"$f":"SUM(H45:H52)","v":20.669},{"$f":"SUM(I45:I52)","v":86.677},{"$f":"SUM(J45:J52)","v":616},null,92.76]
[{"$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":570},{"$f":"G53+G63","v":20.059000000000005},{"$f":"H53+H63","v":20.669},{"$f":"I53+I63","v":86.677},{"$f":"J53+J63","v":616},null,92.76]
[1,4,"Завтрак","гор.блюдо","плов с говядиной",190,13.604,15.543,35.965,338,"ттк2023",92.76]
[]
[{"$nulls":3},"гор.напиток","компот из свежих плодов (яблоки)",200,0.08,0.08,11.94,49,"ттк2021"]
[{"$nulls":3},"хлеб","хлеб пшеничный/ хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,338]
[{"$nulls":4},"печенье сдобное шоколадное",15,1.166,4.183,9.224,79]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F71)","v":545},{"$f":"SUM(G65:G71)","v":17.77},{"$f":"SUM(H65:H71)","v":20.566},{"$f":"SUM(I65:I71)","v":85.769},{"$f":"SUM(J65:J71)","v":604},null,92.76]
[{"$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":545},{"$f":"G72+G82","v":17.77},{"$f":"H72+H82","v":20.566},{"$f":"I72+I82","v":85.769},{"$f":"J72+J82","v":604},null,92.76]
[1,5,"Завтрак","гор.блюдо","пюре картофельное",150,3.282,4.657,22.027,146,"акт2020",92.76]
[{"$nulls":4},"котлеты аппетитные запеченные",90,9.069,6.869,8.996,134,"2144/2022"]
[{"$nulls":3},"гор.напиток","чай с сахаром",208,0.007,2E-3,7.986,32,"ттк2021"]
[{"$nulls":3},"хлеб","хлеб пшеничный/ хлеб ржано-пшеничный",40,2.52,0.36,18.84,91]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"вафли весовые ",21,2.75,2.5,13,86]
[{"$nulls":4},"салат из моркови",60,0.702,3.051,6.72,58,"49/2004"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F90)","v":569},{"$f":"SUM(G84:G90)","v":18.33},{"$f":"SUM(H84:H90)","v":17.439},{"$f":"SUM(I84:I90)","v":77.569},{"$f":"SUM(J84:J90)","v":547},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},{"$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":569},{"$f":"G91+G101","v":18.33},{"$f":"H91+H101","v":17.439},{"$f":"I91+I101","v":77.569},{"$f":"J91+J101","v":547},null,92.76]
[2,1,"Завтрак","гор.блюдо","каша вязкая молочная из рисовой крупы с маслом",155,7,4.06,32.551,195,"173/2015",92.76]
[]
[{"$nulls":3},"гор.напиток","напиток из шиповника",200,0.012,1E-3,10.178,41]
[{"$nulls":3},"хлеб","бутерброд с сыром, маслом",55,6.275,10.11,17.5,186,2015]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":4},"батончик (в ассортименте)",30,1.8,6.2,15.4,128]
[{"$nulls":3},"итого",null,{"$f":"SUM(F103:F109)","v":540},{"$f":"SUM(G103:G109)","v":15.487},20.771,85.429,597,null,{"$f":"SUM(L103:L109)","v":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},{"$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":540},{"$f":"G110+G120","v":15.487},{"$f":"H110+H120","v":20.771},{"$f":"I110+I120","v":85.429},{"$f":"J110+J120","v":597},null,92.76]
[2,2,"Завтрак","гор.блюдо","каша вязкая молочная из гречневой крупы с маслом",155,5.353,5.613,31.781,199,"173/2015",92.76]
[]
[{"$nulls":3},"гор.напиток","какао с молоком",200,3.972,2.3,6.168,61,"382/2015"]
[{"$nulls":3},"хлеб","батон",30,2.25,0.87,15.42,79]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"сыр порциями",15,3.945,3.99,0,53,"15/2015"]
[{"$nulls":4},"кисломолочный продукт ДМК",125,3.5,3.125,5.125,63]
[{"$nulls":4},"печенье сдобное шоколадное",15,1.166,4.183,9.224,79]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F129)","v":540},{"$f":"SUM(G122:G129)","v":20.186},20.081,67.718,534,null,{"$f":"SUM(L122:L129)","v":92.76}]
[{"$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(F131:F139)","v":0},{"$f":"SUM(G131:G139)","v":0},0,0,0,null,{"$f":"SUM(L131:L139)","v":0}]
[{"$f":"A122","v":2},{"$f":"B122","v":2},"Итого за день:",null,null,{"$f":"F130+F140","v":540},{"$f":"G130+G140","v":20.186},{"$f":"H130+H140","v":20.081},{"$f":"I130+I140","v":67.718},{"$f":"J130+J140","v":534},null,92.76]
[2,3,"Завтрак","гор.блюдо","макаронные изделия отварные",150,5.602,5.068,35.906,212,"309/2015",92.76]
[{"$nulls":4},"котлеты аппетитные запеченные ",90,9.069,6.869,8.996,134,"ттк2022"]
[{"$nulls":3},"гор.напиток","напиток из урюка",200,0.8,0.064,9.46,42,"ттк2023"]
[{"$nulls":3},"хлеб","батон",30,2.25,0.87,15.42,79]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"масло сливочное (порциями)",10,0.08,7.25,0.08,66,"14/2015"]
[{"$nulls":4},"маффин классический",30,2.068,4.341,14.864,107,"ттк2025"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F142:F148)","v":510},{"$f":"SUM(G142:G148)","v":19.869000000000003},24.462,84.726,640,null,{"$f":"SUM(L142:L148)","v":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},{"$f":"SUM(G150:G158)","v":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":510},{"$f":"G149+G159","v":19.869000000000003},{"$f":"H149+H159","v":24.462},{"$f":"I149+I159","v":84.726},{"$f":"J149+J159","v":640},null,92.76]
[2,4,"Завтрак","гор.блюдо","каша вязкая молочная из геркулесовой крупы с маслом",155,7.549,7.296,25.325,197,"173/2015",92.76]
[]
[{"$nulls":3},"гор.напиток","напиток из шиповника",200,0.012,1E-3,10.178,41,"ттк2021"]
[{"$nulls":3},"хлеб","бутерброд с сыром,маслом",55,6.275,10.11,17.5,186,2015]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"оладьи со сгущенным молоком",40,0.9,3.169,6.75,59,"ттк2025"]
[{"$nulls":4},"плоды и ягоды свежие (мандарины)",100,0.8,0.2,7.5,38]
[{"$nulls":3},"итого",null,{"$f":"SUM(F161:F167)","v":550},{"$f":"SUM(G161:G167)","v":15.536000000000001},20.776,67.253,521,null,{"$f":"SUM(L161:L167)","v":92.76}]
[{"$f":"A161","v":2},{"$f":"B161","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F169:F177)","v":0},{"$f":"SUM(G169:G177)","v":0},0,0,0,null,{"$f":"SUM(L169:L177)","v":0}]
[{"$f":"A161","v":2},{"$f":"B161","v":4},"Итого за день:",null,null,{"$f":"F168+F178","v":550},{"$f":"G168+G178","v":15.536000000000001},{"$f":"H168+H178","v":20.776},{"$f":"I168+I178","v":67.253},{"$f":"J168+J178","v":521},null,92.76]
[2,5,"Завтрак","гор.блюдо","каша вязкая молочная из рисовой и пшенной крупы с маслом",155,8.964,7.605,25.377,206,"175/2015",92.76]
[]
[{"$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},"масло сливочное (порциями)",10,0.08,7.25,0.08,66]
[{"$nulls":4},"творог детский в упаковке ДМК",50,4,5,1.95,69]
[{"$nulls":4},"фруктовое пюре",125,0,0,15,60]
[{"$nulls":3},"итого",null,{"$f":"SUM(F180:F187)","v":570},{"$f":"SUM(G180:G187)","v":15.414},20.755000000000003,69.397,528,null,{"$f":"SUM(L180:L187)","v":92.76}]
[{"$f":"A180","v":2},{"$f":"B180","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},{"$f":"SUM(G189:G197)","v":0},0,0,0,null,{"$f":"SUM(L189:L197)","v":0}]
[{"$f":"A180","v":2},{"$f":"B180","v":5},"Итого за день:",null,null,{"$f":"F188+F198","v":570},{"$f":"G188+G198","v":15.414},{"$f":"H188+H198","v":20.755000000000003},{"$f":"I188+I198","v":69.397},{"$f":"J188+J198","v":528},null,92.76]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F44+F64+F83+F102+F121+F141+F160+F179+F199)/(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(F141=0,0,1)+IF(F160=0,0,1)+IF(F179=0,0,1)+IF(F199=0,0,1))","v":561.9},{"$f":"(G25+G44+G64+G83+G102+G121+G141+G160+G179+G199)/(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(G141=0,0,1)+IF(G160=0,0,1)+IF(G179=0,0,1)+IF(G199=0,0,1))","v":18.006899999999998},20.1847,79.3799,575.4,null,{"$f":"(L25+L44+L64+L83+L102+L121+L141+L160+L179+L199)/(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(L141=0,0,1)+IF(L160=0,0,1)+IF(L179=0,0,1)+IF(L199=0,0,1))","v":92.76}]