{"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],[83,2,83,3],[102,2,102,3],[122,2,122,3],[141,2,141,3],[161,2,161,3],[180,2,180,3],[199,2,199,3],[200,2,200,4]]}
["Школа",null,"МБОУ Кагальницкая СОШ",null,null,"Утвердил:","должность","Директор школы "]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Н.И.Демидова"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,9,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша пшеничная рассыпчатая  со сливочным маслом",185,10.6,6.8,43.3,312,"№ 183","13-00"]
[{"$nulls":3},"2 блюдо","Бефстрогонов из отварного мяса",100,20.8,16.3,3.2,244,"№ 94","46-00"]
[{"$nulls":3},"закуска","Овощи в нарезке",60,0.5,2.8,2.2,38,"№ 14","10-00"]
[{"$nulls":3},"хлеб"," Хлеб ",80,4.5,1.2,29.2,140,"№1.5","6-00"]
[{"$nulls":3},"гор.напиток","Чай  с сахаром ",200,0.2,0,9.1,36,"№ 300","3-00"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":625},36.6,27.1,87,{"$f":"SUM(J6:J13)","v":770},null,87]
[{"$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":625},{"$f":"G14+G24","v":36.6},27.1,87,770,null,{"$f":"L14+L24","v":87}]
[1,2,"Завтрак","гор.блюдо","Каша гречневая рассыпчатая  со сливочным маслом",185,8,6.4,45.4,281,"№ 185","51-00"]
[{"$nulls":3},"2 блюдо","Куры отварные",90,22.5,18.9,0.3,295,"№ 132"]
[{"$nulls":3},"закуска","Горошек зеленый консервированный отварной",100,3.3,0.2,6.8,53,"№7.13","17-00"]
[{"$nulls":3},"хлеб","Хлеб ",80,4.5,1.2,29.2,140,"№1.5","6-00"]
[{"$nulls":3},"гор.напиток","Чай с лимоном и сахаром",200,0.2,0,9.3,38,"№ 302","3р50"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F33)","v":655},{"$f":"SUM(G26:G33)","v":38.5},{"$f":"SUM(H26:H33)","v":26.699999999999996},{"$f":"SUM(I26:I33)","v":90.99999999999999},{"$f":"SUM(J26:J33)","v":807},null,78]
[{"$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":655},{"$f":"G34+G44","v":38.5},{"$f":"H34+H44","v":26.699999999999996},{"$f":"I34+I44","v":90.99999999999999},{"$f":"J34+J44","v":807},null,78]
[1,3,"Завтрак","гор.блюдо","Макаронные изделия отварные, со сливочным маслом",185,6.5,4.4,40,233,"№ 227 № 100","51-00"]
[{"$nulls":3},"2 блюдо","Котлета \"Здоровье\"",90,13.7,11.9,7.9,196]
[{"$nulls":3},"закуска","Салат витаминный",60,0.9,2.7,6.5,56,"№21","6-00"]
[{"$nulls":3},"хлеб","Хлеб ",80,4.5,1.2,29.2,140,"№1.5.","6-00"]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,3.3,3.1,13.6,95,"№ 306","15-00"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F46:F53)","v":615},{"$f":"SUM(G46:G53)","v":28.9},{"$f":"SUM(H46:H53)","v":23.3},{"$f":"SUM(I46:I53)","v":97.19999999999999},{"$f":"SUM(J46:J53)","v":720},null,78]
[{"$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":615},{"$f":"G54+G64","v":28.9},{"$f":"H54+H64","v":23.3},{"$f":"I54+I64","v":97.19999999999999},{"$f":"J54+J64","v":720},null,78]
[1,4,"Завтрак","гор.блюдо","Каша манная молочная жидкая со сливочным маслом",255,5.5,7.4,27.3,350,"№ 205","34-00"]
[{"$nulls":3},"хлеб","Хлеб с маслом и сыром ","180г",4.1,2.8,9.5,82,"№2","23-00"]
[{"$nulls":4},"Яйца варенные",80,4.8,4.4,0.2,59,"№ 10.1","18-00"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,9.1,36,"№ 300","3-00"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,715,{"$f":"SUM(G66:G72)","v":14.599999999999998},{"$f":"SUM(H66:H72)","v":14.6},{"$f":"SUM(I66:I72)","v":46.1},{"$f":"SUM(J66:J72)","v":527},null,78]
[{"$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(F74:F82)","v":0},{"$f":"SUM(G74:G82)","v":0},{"$f":"SUM(H74:H82)","v":0},{"$f":"SUM(I74:I82)","v":0},{"$f":"SUM(J74:J82)","v":0},null,0]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Итого за день:",null,null,{"$f":"F73+F83","v":715},{"$f":"G73+G83","v":14.599999999999998},{"$f":"H73+H83","v":14.6},{"$f":"I73+I83","v":46.1},{"$f":"J73+J83","v":527},null,78]
[1,5,"Завтрак","гор.блюдо","Запеканка рисовая с творогом и вареньем",200,11,5.1,65.8,357,"№ 217","38-00"]
[{"$nulls":3},"фрукты","Фрукты свежие",100,0.3,0,78,52,null,"20-00"]
[{"$nulls":3},"гор.напиток","Напиток яблочно-лимонный",200,0.2,0.2,22.8,94,"№312","20-00"]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F85:F91)","v":500},{"$f":"SUM(G85:G91)","v":11.5},{"$f":"SUM(H85:H91)","v":5.3},{"$f":"SUM(I85:I91)","v":166.60000000000002},{"$f":"SUM(J85:J91)","v":503},null,78]
[{"$f":"A85","v":1},{"$f":"B85","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F93:F101)","v":0},{"$f":"SUM(G93:G101)","v":0},{"$f":"SUM(H93:H101)","v":0},{"$f":"SUM(I93:I101)","v":0},{"$f":"SUM(J93:J101)","v":0},null,0]
[{"$f":"A85","v":1},{"$f":"B85","v":5},"Итого за день:",null,null,{"$f":"F92+F102","v":500},{"$f":"G92+G102","v":11.5},{"$f":"H92+H102","v":5.3},{"$f":"I92+I102","v":166.60000000000002},{"$f":"J92+J102","v":503},null,78]
[2,1,"Завтрак","гор.блюдо","Каша пшеничная со сливочный маслом рассыпчатая",185,8,4.9,47,261,"№ 185","13-00"]
[{"$nulls":3},"2 блюдо","Гуляш",100,13.8,14.3,3.1,197,"№ 96","46-00"]
[{"$nulls":3},"закуска","Овощи в нарезке",60,0.5,2.8,2.2,38,"№ 15","10-00"]
[{"$nulls":3},"хлеб","Хлеб ",80,4.5,1.2,29.2,140,"№2","6-00"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.2,0,9.1,36,"№ 300","3-00"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F104:F111)","v":625},{"$f":"SUM(G104:G111)","v":27},23.200000000000003,90.6,672,null,78]
[{"$f":"A104","v":2},{"$f":"B104","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F113:F121)","v":0},{"$f":"SUM(G113:G121)","v":0},0,0,0,null,{"$f":"SUM(L113:L121)","v":0}]
[{"$f":"A104","v":2},{"$f":"B104","v":1},"Итого за день:",null,null,{"$f":"F112+F122","v":625},{"$f":"G112+G122","v":27},{"$f":"H112+H122","v":23.200000000000003},{"$f":"I112+I122","v":90.6},{"$f":"J112+J122","v":672},null,78]
[2,2,"Завтрак","гор.блюдо","Плов из курицы",240,18.2,23.2,32.2,417,"№ 139","46-50"]
[{"$nulls":3},"закуска","Винегрет овощной",60,0.9,1.5,4.9,40,"№ 42","22-00"]
[{"$nulls":3},"хлеб","Хлеб",80,4.5,1.2,29.2,140,"№2","6-00"]
[{"$nulls":3},"гор.напиток","Чай с лимоном и сахаром",200,0.2,0,19.3,38,"№ 302","3р50"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F124:F130)","v":580},{"$f":"SUM(G124:G130)","v":23.799999999999997},25.9,85.6,635,null,78]
[{"$f":"A124","v":2},{"$f":"B124","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F132:F140)","v":0},{"$f":"SUM(G132:G140)","v":0},0,0,0,null,{"$f":"SUM(L132:L140)","v":0}]
[{"$f":"A124","v":2},{"$f":"B124","v":2},"Итого за день:",null,null,{"$f":"F131+F141","v":580},{"$f":"G131+G141","v":23.799999999999997},{"$f":"H131+H141","v":25.9},{"$f":"I131+I141","v":85.6},{"$f":"J131+J141","v":635},null,78]
[2,3,"Завтрак","гор.блюдо","Картофельное пюре со сливочным маслом",205,4.1,6.3,26.7,187,"№ 146 ","15-00"]
[{"$nulls":3},"2 блюдо","Котлета рыбная",90,21.6,10.5,12.4,233,"№ 83","30-00"]
[{"$nulls":3},"закуска","Овощи в нарезке",60,0.5,2.8,2.2,38,"№15","7-00"]
[{"$nulls":3},"хлеб","Хлеб ",80,4.5,1.2,29.2,140,"№ 1.5","6-00"]
[{"$nulls":3},"гор.напиток","Напиток яблочный",200,0.1,0.1,24,94,"№ 320","20-00"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F143:F150)","v":635},{"$f":"SUM(G143:G150)","v":30.800000000000004},20.900000000000002,94.5,692,null,78]
[{"$f":"A143","v":2},{"$f":"B143","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":"A143","v":2},{"$f":"B143","v":3},"Итого за день:",null,null,{"$f":"F151+F161","v":635},{"$f":"G151+G161","v":30.800000000000004},{"$f":"H151+H161","v":20.900000000000002},{"$f":"I151+I161","v":94.5},{"$f":"J151+J161","v":692},null,78]
[2,4,"Завтрак","гор.блюдо","Каша гречневая с молоком",200,8.5,4.6,33.1,218,"№ 186","32-00"]
[{"$nulls":3},"хлеб","Хлеб с маслом и сыром ",180,3.3,2.8,33.7,174,"№ 2","25-00"]
[{"$nulls":4},"Яйца варенные",80,4.8,4.4,0.2,59,"№ 10.1","18-00"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.2,0,9.1,36,"№ 300","3-00"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F163:F169)","v":660},{"$f":"SUM(G163:G169)","v":16.8},11.8,76.10000000000001,487,null,78]
[{"$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":660},{"$f":"G170+G180","v":16.8},{"$f":"H170+H180","v":11.8},{"$f":"I170+I180","v":76.10000000000001},{"$f":"J170+J180","v":487},null,78]
[2,5,"Завтрак","гор.блюдо","Лапшевник с творогом",240,"15,,4",12.3,35.7,322,"№ 231","38-00"]
[{"$nulls":3},"фрукты","Фрукты свежие",100,0.3,0,78,52,null,"20-00"]
[{"$nulls":3},"гор.напиток","Кофейный напиток на молоке",200,2.9,2.8,14.9,109,"№ 304","20-00"]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F182:F188)","v":540},{"$f":"SUM(G182:G188)","v":3.1999999999999997},15.100000000000001,128.6,483,null,{"$f":"SUM(L182:L188)","v":0}]
[{"$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":540},{"$f":"G189+G199","v":3.1999999999999997},{"$f":"H189+H199","v":15.100000000000001},{"$f":"I189+I199","v":128.6},{"$f":"J189+J199","v":483},null,0]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F45+F65+F84+F103+F123+F142+F162+F181+F200)/(IF(F25=0,0,1)+IF(F45=0,0,1)+IF(F65=0,0,1)+IF(F84=0,0,1)+IF(F103=0,0,1)+IF(F123=0,0,1)+IF(F142=0,0,1)+IF(F162=0,0,1)+IF(F181=0,0,1)+IF(F200=0,0,1))","v":615},{"$f":"(G25+G45+G65+G84+G103+G123+G142+G162+G181+G200)/(IF(G25=0,0,1)+IF(G45=0,0,1)+IF(G65=0,0,1)+IF(G84=0,0,1)+IF(G103=0,0,1)+IF(G123=0,0,1)+IF(G142=0,0,1)+IF(G162=0,0,1)+IF(G181=0,0,1)+IF(G200=0,0,1))","v":23.169999999999998},19.39,96.33000000000001,629.6,null,{"$f":"(L25+L45+L65+L84+L103+L123+L142+L162+L181+L200)/(IF(L25=0,0,1)+IF(L45=0,0,1)+IF(L65=0,0,1)+IF(L84=0,0,1)+IF(L103=0,0,1)+IF(L123=0,0,1)+IF(L142=0,0,1)+IF(L162=0,0,1)+IF(L181=0,0,1)+IF(L200=0,0,1))","v":79}]