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

{"sheet":"Лист1","index":0,"n_rows":201,"n_cols":12,"rows_kept":201,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[24,2,24,3],[44,2,44,3],[64,2,64,3],[84,2,84,3],[104,2,104,3],[123,2,123,3],[142,2,142,3],[161,2,161,3],[180,2,180,3],[199,2,199,3],[200,2,200,4]]}
["Школа",null,"МБОУ \"Средняя школа 151\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Макерова С.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",22,12,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","каша вязкая молочная из рисовой крупы с маслом",155,4.2,5.08,32.551,193,"173/2015",89.77]
[]
[{"$nulls":3},"гор.напиток","напиток из урюка",200,0.8,0.064,9.46,42,"ттк2023"]
[{"$nulls":3},"хлеб","бутерброд с сыром",60,7.65,9.025,18.07,184]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"батончик (в ассортименте)",30,1.8,6.2,15.4,128]
[{"$nulls":4},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,2015]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":545},{"$f":"SUM(G6:G13)","v":14.850000000000001},20.769,85.281,594,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":545},{"$f":"G14+G24","v":14.850000000000001},20.769,85.281,594,null,{"$f":"L14+L24","v":89.77}]
[1,2,"Завтрак","гор.блюдо","каша молочная из гречневой крупы с маслом",155,5.053,5.613,29.781,190,"173/2015",89.77]
[]
[{"$nulls":3},"гор.напиток","какао с молоком",200,3.972,2.1,25.168,145,"338/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},"печенье весовое",16,1.104,2.208,11.856,71]
[{"$nulls":4},"кисломолочный продукт ДМК",125,3.5,3.125,5.125,63]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F33)","v":541},{"$f":"SUM(G26:G33)","v":19.824},{"$f":"SUM(H26:H33)","v":17.906},{"$f":"SUM(I26:I33)","v":87.35},{"$f":"SUM(J26:J33)","v":601},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(F35:F43)","v":0},{"$f":"SUM(G35:G43)","v":0},{"$f":"SUM(H35:H43)","v":0},{"$f":"SUM(I35:I43)","v":0},{"$f":"SUM(J35:J43)","v":0},null,0]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F34+F44","v":541},{"$f":"G34+G44","v":19.824},{"$f":"H34+H44","v":17.906},{"$f":"I34+I44","v":87.35},{"$f":"J34+J44","v":601},null,89.77]
[1,3,"Завтрак","гор.блюдо","макаронные изделия отварные",150,5.602,5.068,35.906,212,"309/2015",89.77]
[{"$nulls":4},"котлеты аппетитные запеченные",90,10.769,9.869,8.996,168,"ттк2022"]
[{"$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},"маффин классический",30,2.068,4.341,14.864,107,"ттк2025"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F46:F53)","v":500},{"$f":"SUM(G46:G53)","v":20.809000000000005},{"$f":"SUM(H46:H53)","v":20.177999999999997},{"$f":"SUM(I46:I53)","v":86.756},{"$f":"SUM(J46:J53)","v":614},null,89.77]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F55:F63)","v":0},{"$f":"SUM(G55:G63)","v":0},{"$f":"SUM(H55:H63)","v":0},{"$f":"SUM(I55:I63)","v":0},{"$f":"SUM(J55:J63)","v":0},null,0]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Итого за день:",null,null,{"$f":"F54+F64","v":500},{"$f":"G54+G64","v":20.809000000000005},{"$f":"H54+H64","v":20.177999999999997},{"$f":"I54+I64","v":86.756},{"$f":"J54+J64","v":614},null,89.77]
[1,4,"Завтрак","гор.блюдо","каша вязкая молочная из геркулесовой крупы с маслом",155,6.049,0.796,25.525,196,null,89.77]
[]
[{"$nulls":3},"гор.напиток","компот из заморженной компотной смеси",200,0.135,0.023,11.15,46]
[{"$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},"плоды и ягоды свежие (мандарины)",100,0.8,0.2,7.5,38,2015]
[{"$nulls":4},"оладьи со сгущенным молоком",45,1.26,2.394,9.525,65]
[{"$nulls":3},"итого",null,{"$f":"SUM(F66:F73)","v":545},{"$f":"SUM(G66:G73)","v":14.439000000000002},{"$f":"SUM(H66:H73)","v":8.273},{"$f":"SUM(I66:I73)","v":69.12},{"$f":"SUM(J66:J73)","v":477},null,89.77]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F75:F83)","v":0},{"$f":"SUM(G75:G83)","v":0},{"$f":"SUM(H75:H83)","v":0},{"$f":"SUM(I75:I83)","v":0},{"$f":"SUM(J75:J83)","v":0},null,0]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Итого за день:",null,null,{"$f":"F74+F84","v":545},{"$f":"G74+G84","v":14.439000000000002},{"$f":"H74+H84","v":8.273},{"$f":"I74+I84","v":69.12},{"$f":"J74+J84","v":477},null,89.77]
[1,5,"Завтрак","гор.блюдо","каша вязкая молочная из рисовой и пшенной крупы с маслом",155,10.064,5.325,25.377,190,"175/2015",89.77]
[]
[{"$nulls":3},"гор.напиток","кофейный напиток с молоком",200,3.3,1.51,21.076,120,"379/2015"]
[{"$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},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,2015]
[{"$nulls":3},"итого",null,{"$f":"SUM(F86:F93)","v":545},{"$f":"SUM(G86:G93)","v":20.094},{"$f":"SUM(H86:H93)","v":20.354999999999997},{"$f":"SUM(I86:I93)","v":73.703},{"$f":"SUM(J86:J93)","v":571},null,{"$f":"SUM(L86:L93)","v":89.77}]
[{"$f":"A86","v":1},{"$f":"B86","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F95:F103)","v":0},{"$f":"SUM(G95:G103)","v":0},{"$f":"SUM(H95:H103)","v":0},{"$f":"SUM(I95:I103)","v":0},{"$f":"SUM(J95:J103)","v":0},null,0]
[{"$f":"A86","v":1},{"$f":"B86","v":5},"Итого за день:",null,null,{"$f":"F94+F104","v":545},{"$f":"G94+G104","v":20.094},{"$f":"H94+H104","v":20.354999999999997},{"$f":"I94+I104","v":73.703},{"$f":"J94+J104","v":571},null,89.77]
[2,1,"Завтрак","гор.блюдо","каша гречневая рассыпчатая",150,6.622,5.399,25.875,179,"302/2015",89.77]
[{"$nulls":4},"котлеты из птицы запеченные",90,8.093,9.93,7.071,150,"ттк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},"плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47]
[{"$nulls":4},"фруктовое пюре",125,0,0,15,60]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F112)","v":705},{"$f":"SUM(G106:G112)","v":17.77},16.112,87.73599999999999,573,null,{"$f":"SUM(L106:L112)","v":89.77}]
[{"$f":"A106","v":2},{"$f":"B106","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F114:F122)","v":0},{"$f":"SUM(G114:G122)","v":0},0,0,0,null,{"$f":"SUM(L114:L122)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":1},"Итого за день:",null,null,{"$f":"F113+F123","v":705},{"$f":"G113+G123","v":17.77},{"$f":"H113+H123","v":16.112},{"$f":"I113+I123","v":87.73599999999999},{"$f":"J113+J123","v":573},null,89.77]
[2,2,"Завтрак","гор.блюдо","жаркое из филе куриных грудок",190,12.912,10.698,33.99,284,"ттк2021",89.77]
[]
[{"$nulls":3},"гор.напиток","напиток из урюка",200,0.8,0.064,9.46,42,"ттк 2023"]
[{"$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(F125:F131)","v":520},{"$f":"SUM(G125:G131)","v":18.963000000000005},20.373,83.33500000000001,599,null,{"$f":"SUM(L125:L131)","v":89.77}]
[{"$f":"A125","v":2},{"$f":"B125","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F133:F141)","v":0},{"$f":"SUM(G133:G141)","v":0},0,0,0,null,{"$f":"SUM(L133:L141)","v":0}]
[{"$f":"A125","v":2},{"$f":"B125","v":2},"Итого за день:",null,null,{"$f":"F132+F142","v":520},{"$f":"G132+G142","v":18.963000000000005},{"$f":"H132+H142","v":20.373},{"$f":"I132+I142","v":83.33500000000001},{"$f":"J132+J142","v":599},null,89.77]
[2,3,"Завтрак","гор.блюдо","макаронные изделия отварные",150,5.602,5.068,35.906,212,"309/2015",89.77]
[{"$nulls":4},"гуляш из филе грудок индейки",90,9.102,7.346,1.893,110,"ттк2021"]
[{"$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},"салат из свеклы отварной ",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(F144:F150)","v":578},{"$f":"SUM(G144:G150)","v":20.154000000000003},20.77,84.50500000000001,608,null,{"$f":"SUM(L144:L150)","v":89.77}]
[{"$f":"A144","v":2},{"$f":"B144","v":3},"Обед","закуска"]
[{"$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":"A144","v":2},{"$f":"B144","v":3},"Итого за день:",null,null,{"$f":"F151+F161","v":578},{"$f":"G151+G161","v":20.154000000000003},{"$f":"H151+H161","v":20.77},{"$f":"I151+I161","v":84.50500000000001},{"$f":"J151+J161","v":608},null,89.77]
[2,4,"Завтрак","гор.блюдо","плов с говядиной",190,13.604,15.543,35.965,338,"ттк2023",89.77]
[]
[{"$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(F163:F169)","v":545},{"$f":"SUM(G163:G169)","v":17.77},20.566,85.769,604,null,{"$f":"SUM(L163:L169)","v":89.77}]
[{"$f":"A163","v":2},{"$f":"B163","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F171:F179)","v":0},{"$f":"SUM(G171:G179)","v":0},0,0,0,null,{"$f":"SUM(L171:L179)","v":0}]
[{"$f":"A163","v":2},{"$f":"B163","v":4},"Итого за день:",null,null,{"$f":"F170+F180","v":545},{"$f":"G170+G180","v":17.77},{"$f":"H170+H180","v":20.566},{"$f":"I170+I180","v":85.769},{"$f":"J170+J180","v":604},null,89.77]
[2,5,"Завтрак","гор.блюдо","пюре картофельное",150,3.282,4.556,21.451,144,"акт2020",89.77]
[{"$nulls":4},"котлеты аппетитные запеченные",90,10.769,9.869,8.996,168,"2144/2022"]
[{"$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},"вафли весовые ",21,2.75,2.5,13,86]
[{"$nulls":4},"салат из моркови",60,0.709,3.052,6.759,58,"49/2004"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F182:F188)","v":569},{"$f":"SUM(G182:G188)","v":20.051000000000002},20.342,77.035,579,null,{"$f":"SUM(L182:L188)","v":89.77}]
[{"$f":"A182","v":2},{"$f":"B182","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F190:F198)","v":0},{"$f":"SUM(G190:G198)","v":0},0,0,0,null,{"$f":"SUM(L190:L198)","v":0}]
[{"$f":"A182","v":2},{"$f":"B182","v":5},"Итого за день:",null,null,{"$f":"F189+F199","v":569},{"$f":"G189+G199","v":20.051000000000002},{"$f":"H189+H199","v":20.342},{"$f":"I189+I199","v":77.035},{"$f":"J189+J199","v":579},null,89.77]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F45+F65+F85+F105+F124+F143+F162+F181+F200)/(IF(F25=0,0,1)+IF(F45=0,0,1)+IF(F65=0,0,1)+IF(F85=0,0,1)+IF(F105=0,0,1)+IF(F124=0,0,1)+IF(F143=0,0,1)+IF(F162=0,0,1)+IF(F181=0,0,1)+IF(F200=0,0,1))","v":559.3},{"$f":"(G25+G45+G65+G85+G105+G124+G143+G162+G181+G200)/(IF(G25=0,0,1)+IF(G45=0,0,1)+IF(G65=0,0,1)+IF(G85=0,0,1)+IF(G105=0,0,1)+IF(G124=0,0,1)+IF(G143=0,0,1)+IF(G162=0,0,1)+IF(G181=0,0,1)+IF(G200=0,0,1))","v":18.472400000000004},{"$f":"(H25+H45+H65+H85+H105+H124+H143+H162+H181+H200)/(IF(H25=0,0,1)+IF(H45=0,0,1)+IF(H65=0,0,1)+IF(H85=0,0,1)+IF(H105=0,0,1)+IF(H124=0,0,1)+IF(H143=0,0,1)+IF(H162=0,0,1)+IF(H181=0,0,1)+IF(H200=0,0,1))","v":18.5644},{"$f":"(I25+I45+I65+I85+I105+I124+I143+I162+I181+I200)/(IF(I25=0,0,1)+IF(I45=0,0,1)+IF(I65=0,0,1)+IF(I85=0,0,1)+IF(I105=0,0,1)+IF(I124=0,0,1)+IF(I143=0,0,1)+IF(I162=0,0,1)+IF(I181=0,0,1)+IF(I200=0,0,1))","v":82.059},{"$f":"(J25+J45+J65+J85+J105+J124+J143+J162+J181+J200)/(IF(J25=0,0,1)+IF(J45=0,0,1)+IF(J65=0,0,1)+IF(J85=0,0,1)+IF(J105=0,0,1)+IF(J124=0,0,1)+IF(J143=0,0,1)+IF(J162=0,0,1)+IF(J181=0,0,1)+IF(J200=0,0,1))","v":582},null,{"$f":"(L25+L45+L65+L85+L105+L124+L143+L162+L181+L200)/(IF(L25=0,0,1)+IF(L45=0,0,1)+IF(L65=0,0,1)+IF(L85=0,0,1)+IF(L105=0,0,1)+IF(L124=0,0,1)+IF(L143=0,0,1)+IF(L162=0,0,1)+IF(L181=0,0,1)+IF(L200=0,0,1))","v":89.77}]