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

{"sheet":"Лист1","index":0,"n_rows":246,"n_cols":12,"rows_kept":246,"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],[124,2,124,3],[144,2,144,3],[164,2,164,3],[184,2,184,3],[204,2,204,3],[224,2,224,3],[244,2,244,3],[245,2,245,4]]}
["Школа",null,"МБОУ \"Полянская  СОШ\"",null,null,"Утвердил:","должность","директор МБОУ \"Полянская  СОШ\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Мошков Е.М."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,9,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Макароны отварые со сливочным маслом",150,5.47,6.37,34.34,204,"№203"]
[{"$nulls":3},"гор.блюдо","Котлета из говядины с соусом","80\\20",11.15,13.48,14.06,236.9,"№268"]
[{"$nulls":3},"напиток","Чай с сахаром","190\\10",0.021,0.005,14.975,60,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный ",20,1.52,0.16,9.84,46.9]
[{"$nulls":3},"хлеб","Хлеб ржано-пшеничный",20,1,0.2,9,42.4]
[{"$nulls":3},"салат ","Салат из белокачанной капусты с огурцами",60,0.8,0.1,2.6,14.5,"№17"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":250},{"$f":"SUM(G6:G13)","v":19.961000000000002},20.315,84.815,604.6999999999999,null,53.6]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F14+F24","v":250},{"$f":"G14+G24","v":19.961000000000002},20.315,84.815,604.6999999999999,null,{"$f":"L14+L24","v":53.6}]
[1,2,"Завтрак","гор.блюдо","Жаркое из птицы",200,15.3,15.8,31.8,330.6,"ТТК №50"]
[]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном","185\\10\\5",0.045,0.005,15.12,60.7,"№377"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"салат","Салат из отварной свеклы",60,0.87,4.05,9.21,76.7,"№52"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F33)","v":310},{"$f":"SUM(G26:G33)","v":19.495},{"$f":"SUM(H26:H33)","v":20.295},{"$f":"SUM(I26:I33)","v":79.89000000000001},{"$f":"SUM(J26:J33)","v":583},null,53.6]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F34+F44","v":310},{"$f":"G34+G44","v":19.495},{"$f":"H34+H44","v":20.295},{"$f":"I34+I44","v":79.89000000000001},{"$f":"J34+J44","v":583},null,53.6]
[1,3,"Завтрак","гор.блюдо","Рис отварной",150,3.834,5.42,31.6,210,"№304"]
[{"$nulls":3},"гор.блюдо","Котлета из птицы с соусом","80\\20",10.6,12.11,6.58,177.71,"№294"]
[{"$nulls":3},"напиток","Чай с сахаром и яблоками","180\\10\\10",0.2,0.5,15.7,65.3,"№685\\2004"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Фрукт",100,0.4,0.4,7.35,46.6,"№338"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F46:F53)","v":300},{"$f":"SUM(G46:G53)","v":18.313999999999997},{"$f":"SUM(H46:H53)","v":18.869999999999997},{"$f":"SUM(I46:I53)","v":84.99},{"$f":"SUM(J46:J53)","v":614.61},null,53.6]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Итого за день:",null,null,{"$f":"F54+F64","v":300},{"$f":"G54+G64","v":18.313999999999997},{"$f":"H54+H64","v":18.869999999999997},{"$f":"I54+I64","v":84.99},{"$f":"J54+J64","v":614.61},null,53.6]
[1,4,"Завтрак","гор.блюдо","Каша молочная геркулесовая со сливочным маслом","200\\5\\10",7.3,10.39,16.43,188.4,"№173"]
[{"$nulls":3},"гор.блюдо","Перемяч печёный с мясом",60,8.11,8.95,24.53,192,"№406"]
[{"$nulls":3},"напиток","Чай с сахаром","190\\10",0.021,0.005,14.975,60,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Фрукт",100,0.4,0.4,7.35,46.6,"№338"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F66:F73)","v":210},{"$f":"SUM(G66:G73)","v":19.111},{"$f":"SUM(H66:H73)","v":20.184999999999995},{"$f":"SUM(I66:I73)","v":87.045},{"$f":"SUM(J66:J73)","v":602},null,53.6]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Итого за день:",null,null,{"$f":"F74+F84","v":210},{"$f":"G74+G84","v":19.111},{"$f":"H74+H84","v":20.184999999999995},{"$f":"I74+I84","v":87.045},{"$f":"J74+J84","v":602},null,53.6]
[1,5,"Завтрак","гор.блюдо","Плов из птицы",200,14.7,12.6,38.9,327.8,"№291"]
[]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном","185\\10\\5",0.045,0.005,15.12,60.7,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"салат","Салат картофельный с солеными огурцами ",60,1.9,6.8,5.2,87.7,"№42"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F86:F93)","v":310},{"$f":"SUM(G86:G93)","v":19.924999999999997},{"$f":"SUM(H86:H93)","v":19.845},{"$f":"SUM(I86:I93)","v":82.98},{"$f":"SUM(J86:J93)","v":591.2},null,53.6]
[{"$f":"A86","v":1},{"$f":"B86","v":5},"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A86","v":1},{"$f":"B86","v":5},"Итого за день:",null,null,{"$f":"F94+F104","v":310},{"$f":"G94+G104","v":19.924999999999997},{"$f":"H94+H104","v":19.845},{"$f":"I94+I104","v":82.98},{"$f":"J94+J104","v":591.2},null,53.6]
[1,6,"Завтрак","гор.блюдо","Картофельное пюре",150,3.8,6.5,34.8,212.9,"№312"]
[{"$nulls":3},"гор.блюдо","Рыба припущенная с овощами","90\\30",9.33,6.33,10.2,135.09,"№229"]
[{"$nulls":3},"напиток","Чай с сахаром и яблоками","180\\10\\10",0.2,0.5,15.7,65.3,"№685\\2004"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.8,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"салат","Огурцы свежие с маслом",60,2.142,5.09,2.47,64.2,"№20"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F113)","v":260},{"$f":"SUM(G106:G113)","v":18.752},19.42,86.93,592.49,null,53.6]
[1,6,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A106","v":1},6,"Итого за день:",null,null,{"$f":"F114+F124","v":260},{"$f":"G114+G124","v":18.752},{"$f":"H114+H124","v":19.42},{"$f":"I114+I124","v":86.93},{"$f":"J114+J124","v":592.49},null,53.6]
[2,1,"Завтрак","гор.блюдо","Каша молочная \"Дружба\" со сливочным маслом","200\\5\\10",7.8,6.6,28.36,204.04,"№173"]
[{"$nulls":3},"гор.блюдо","Пирожок с повидлом",60,5.2,7.9,20.31,173.14,"№418"]
[{"$nulls":3},"напиток","Чай с сахаром","190\\10",0.021,0.005,14.975,60,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"сыр","Сыр",15,3.9,3.97,0.52,54.75,"№15"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F126:F133)","v":125},{"$f":"SUM(G126:G133)","v":20.201},18.915,87.925,606.93,null,53.6]
[{"$f":"A126","v":2},1,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A126","v":2},1,"Итого за день:",null,null,{"$f":"F134+F144","v":125},{"$f":"G134+G144","v":20.201},{"$f":"H134+H144","v":18.915},{"$f":"I134+I144","v":87.925},{"$f":"J134+J144","v":606.93},null,53.6]
[2,2,"Завтрак","гор.блюдо","Плов из говядины ",200,15.7,18.9,35.5,374.74,"№265"]
[]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном","185\\10\\5",0.045,0.005,15.12,60.7,"№377"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Фрукт",100,0.4,0.4,7.35,46.6,"№338"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F146:F153)","v":350},{"$f":"SUM(G146:G153)","v":19.424999999999997},19.744999999999994,81.72999999999999,597.0400000000001,null,53.6]
[{"$f":"A146","v":2},2,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A146","v":2},2,"Итого за день:",null,null,{"$f":"F154+F164","v":350},{"$f":"G154+G164","v":19.424999999999997},{"$f":"H154+H164","v":19.744999999999994},{"$f":"I154+I164","v":81.72999999999999},{"$f":"J154+J164","v":597.0400000000001},null,53.6]
[2,3,"Завтрак","гор.блюдо","Каша гречневая рассыпчатая",150,5.2,4.3,24.3,156.7,"№302"]
[{"$nulls":3},"гор.блюдо","Куриная грудка тушеная в сметанном соусе","50\\50",10.2,12.36,17.3,221,"№290"]
[{"$nulls":3},"напиток","Чай с сахаром и яблоками","180\\10\\10",0.2,0.5,15.7,65.3,"№685\\2004"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"салат","Салат \"Витаминный\"",60,0.7,3.06,6.65,56.94,"№49"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F173)","v":260},{"$f":"SUM(G166:G173)","v":19.58},20.659999999999997,87.71000000000001,614.94,null,53.6]
[{"$f":"A166","v":2},3,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A166","v":2},{"$f":"B166","v":3},"Итого за день:",null,null,{"$f":"F174+F184","v":260},{"$f":"G174+G184","v":19.58},{"$f":"H174+H184","v":20.659999999999997},{"$f":"I174+I184","v":87.71000000000001},{"$f":"J174+J184","v":614.94},null,53.6]
[2,4,"Завтрак","гор.блюдо","Картофель тушеный",150,4.3,5.6,20.1,148,"№142"]
[{"$nulls":3},"гор.блюдо","Котлета из говядины",80,10.2,12.68,13.62,209.4,"№294"]
[{"$nulls":3},"напиток","Чай с сахаром и курагой","180\\10\\7",0.2,1.5,15.7,65.3,"№377"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Фрукт",100,1.69,0.47,14.7,69.8,"№338"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F186:F193)","v":380},{"$f":"SUM(G186:G193)","v":19.67},20.689999999999998,87.88000000000001,607.5,null,53.6]
[{"$f":"A186","v":2},4,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A186","v":2},{"$f":"B186","v":4},"Итого за день:",null,null,{"$f":"F194+F204","v":380},{"$f":"G194+G204","v":19.67},{"$f":"H194+H204","v":20.689999999999998},{"$f":"I194+I204","v":87.88000000000001},{"$f":"J194+J204","v":607.5},null,{"$f":"L194+L204","v":53.6}]
[2,5,"Завтрак","гор.блюдо","Плов из птицы",200,14.7,12.6,38.9,327.8,"№291"]
[]
[{"$nulls":3},"напиток","Чай с сахаром и лимоном","185\\10\\5",0.045,0.005,15.12,60.7,"№377"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,1.52,0.16,9.84,47.33]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.2,9,44]
[{"$nulls":3},"салат","Винегрет овощной",60,1.02,6.1,6.8,86.2,"№67"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F206:F213)","v":310},{"$f":"SUM(G206:G213)","v":18.285},19.064999999999998,79.66,566.03,null,53.6]
[{"$f":"A206","v":2},5,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A206","v":2},{"$f":"B206","v":5},"Итого за день:",null,null,{"$f":"F214+F224","v":310},{"$f":"G214+G224","v":18.285},{"$f":"H214+H224","v":19.064999999999998},{"$f":"I214+I224","v":79.66},{"$f":"J214+J224","v":566.03},null,{"$f":"L214+L224","v":53.6}]
[2,6,"Завтрак","гор.блюдо","Картофельное пюре",150,3.8,6.5,34.8,212.9,"№312"]
[{"$nulls":3},"гор.блюдо","Котлета из птицы ",80,10.6,12.11,6.58,177.71,"№294"]
[{"$nulls":3},"напиток","Чай с сахаром и яблоками","180\\10\\10",0.021,0.005,14.975,60,"№685\\2004"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",20,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб ржан-пшеничный",20,1,0.61,9,44]
[{"$nulls":3},"салат","Салат из белокачанной капусты с огурцами",60,0.8,0.1,2.6,14.5,"№45"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F226:F233)","v":330},{"$f":"SUM(G226:G233)","v":18.501},19.564999999999998,82.71499999999999,580.11,null,53.6]
[{"$f":"A226","v":2},6,"Обед"]
{"$rows_empty":8}
[{"$nulls":3},"итого"]
[{"$f":"A226","v":2},{"$f":"B226","v":6},"Итого за день:",null,null,{"$f":"F234+F244","v":330},{"$f":"G234+G244","v":18.501},{"$f":"H234+H244","v":19.564999999999998},{"$f":"I234+I244","v":82.71499999999999},{"$f":"J234+J244","v":580.11},null,{"$f":"L234+L244","v":53.6}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F45+F65+F85+F105+F125+F145+F165+F185+F205)/(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(F125=0,0,1)+IF(F145=0,0,1)+IF(F165=0,0,1)+IF(F185=0,0,1)+IF(F205=0,0,1))","v":275.5},{"$f":"(G25+G45+G65+G85+G105+G125+G145+G165+G185+G205)/(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(G125=0,0,1)+IF(G145=0,0,1)+IF(G165=0,0,1)+IF(G185=0,0,1)+IF(G205=0,0,1))","v":19.443399999999997},{"$f":"(H25+H45+H65+H85+H105+H125+H145+H165+H185+H205)/(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(H125=0,0,1)+IF(H145=0,0,1)+IF(H165=0,0,1)+IF(H185=0,0,1)+IF(H205=0,0,1))","v":19.894},{"$f":"(I25+I45+I65+I85+I105+I125+I145+I165+I185+I205)/(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(I125=0,0,1)+IF(I145=0,0,1)+IF(I165=0,0,1)+IF(I185=0,0,1)+IF(I205=0,0,1))","v":85.18950000000001},{"$f":"(J25+J45+J65+J85+J105+J125+J145+J165+J185+J205)/(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(J125=0,0,1)+IF(J145=0,0,1)+IF(J165=0,0,1)+IF(J185=0,0,1)+IF(J205=0,0,1))","v":601.441},null,{"$f":"(L25+L45+L65+L85+L105+L125+L145+L165+L185+L205)/(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(L125=0,0,1)+IF(L145=0,0,1)+IF(L165=0,0,1)+IF(L185=0,0,1)+IF(L205=0,0,1))","v":53.60000000000001}]