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

{"sheet":"Лист1","index":0,"n_rows":207,"n_cols":12,"rows_kept":207,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[43,2,43,3],[63,2,63,3],[82,2,82,3],[101,2,101,3],[122,2,122,3],[142,2,142,3],[163,2,163,3],[184,2,184,3],[205,2,205,3],[206,2,206,4]]}
["Школа",null,"МБОУ \"Малошильнинская СОШ\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Сафин Р,И."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",25,8,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Плов из птицы",200,16.01,18.95,35.414,357.67,291]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,0.66,1.5,22.6,132.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,338]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,0.79,1.95,3.88,36.24,45]
[{"$nulls":4},"Масло сливочное",10,0.08,7.25,0.13,66,14]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":620},{"$f":"SUM(G6:G12)","v":21.22},{"$f":"SUM(H6:H12)","v":30.489999999999995},{"$f":"SUM(I6:I12)","v":92.58399999999999},{"$f":"SUM(J6:J12)","v":754.71},null,{"$f":"SUM(L6:L12)","v":0}]
[{"$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(F14:F22)","v":0},{"$f":"SUM(G14:G22)","v":0},0,0,0,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":620},{"$f":"G13+G23","v":21.22},30.489999999999995,92.58399999999999,754.71,null,{"$f":"L13+L23","v":0}]
[1,2,"Завтрак","гор.блюдо","Тефтели говяжьи с соусом",90,10.571,11.41,8.1,154.716,279]
[{"$nulls":3},"гарнир","Макаронные изделия отварные с маслом",155,5.55,8.95,29.55,184.5,203]
[{"$nulls":3},"закуска","Салат из свеклы отварной",60,0.84,1.66,4.56,54.6,52]
[{"$nulls":3},"гор.напиток","Кисель",200,0,0,15,60,484]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Печенье",40,3,3.92,29.76,166]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F32)","v":595},{"$f":"SUM(G25:G32)","v":23.241},{"$f":"SUM(H25:H32)","v":26.379999999999995},{"$f":"SUM(I25:I32)","v":107.73},{"$f":"SUM(J25:J32)","v":734.816},null,{"$f":"SUM(L25:L32)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","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":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F33+F43","v":595},{"$f":"G33+G43","v":23.241},{"$f":"H33+H43","v":26.379999999999995},{"$f":"I33+I43","v":107.73},{"$f":"J33+J43","v":734.816},null,0]
[1,3,"Завтрак","гарнир","Пюре картофельное",150,4.77,5.43,38.85,219.3,312]
[{"$nulls":3},"гор.блюдо","Рыба тушеная с соусом",90,9.045,10.88,19.6,176,229]
[{"$nulls":3},"закуска","Салат витаминный",60,0.72,3.06,3.3,43.8,2]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.321,0.005,21.725,88,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,338]
[{"$nulls":4},"Сыр порциями",10,2.32,2.7,0,20.8,15]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F52)","v":668},{"$f":"SUM(G45:G52)","v":20.855999999999998},{"$f":"SUM(H45:H52)","v":22.914999999999996},{"$f":"SUM(I45:I52)","v":114.035},{"$f":"SUM(J45:J52)","v":709.9},null,{"$f":"SUM(L45:L52)","v":0}]
[{"$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":668},{"$f":"G53+G63","v":20.855999999999998},{"$f":"H53+H63","v":22.914999999999996},{"$f":"I53+I63","v":114.035},{"$f":"J53+J63","v":709.9},null,0]
[1,4,"Завтрак","гор.блюдо","Рагу из птицы",200,16.01,19.3,35.414,357.67,289]
[{"$nulls":3},"закуска","Салат из моркови",60,0.74,0.056,6.89,49.02,62]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром с лимоном",215,0.13,0.02,15.2,62,377]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Масло сливочное",10,0.08,7.25,0.13,66,14]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F71)","v":535},{"$f":"SUM(G65:G71)","v":20.24},{"$f":"SUM(H65:H71)","v":27.066},{"$f":"SUM(I65:I71)","v":78.394},{"$f":"SUM(J65:J71)","v":649.69},null,{"$f":"SUM(L65:L71)","v":0}]
[{"$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":535},{"$f":"G72+G82","v":20.24},{"$f":"H72+H82","v":27.066},{"$f":"I72+I82","v":78.394},{"$f":"J72+J82","v":649.69},null,0]
[1,5,"Завтрак","гарнир","Каша пшеничная рассыпчатая с маслом",155,6.84,8.01,40.06,260,171]
[{"$nulls":3},"гор.блюдо","Сосиски отварные с соусом",90,5.92,13.4,3.8,145.6,243]
[{"$nulls":3},"закуска","Винегрет овощной",60,0.84,6.02,4.37,75.06,67]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,0.66,1.5,22.6,132.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F90)","v":555},{"$f":"SUM(G84:G90)","v":17.54},{"$f":"SUM(H84:H90)","v":29.369999999999997},{"$f":"SUM(I84:I90)","v":91.59},{"$f":"SUM(J84:J90)","v":728.46},null,{"$f":"SUM(L84:L90)","v":0}]
[{"$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":555},{"$f":"G91+G101","v":17.54},{"$f":"H91+H101","v":29.369999999999997},{"$f":"I91+I101","v":91.59},{"$f":"J91+J101","v":728.46},null,0]
[2,1,"Завтрак","гор.блюдо","Птица тушеная в соусе",100,10.44,14.25,10.59,197.25,290]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая",150,8.3,8.95,37.37,262.5,171]
[{"$nulls":3},"закуска","Салат из моркови",60,0.74,0.056,6.89,49.02,62]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,0.66,1.5,22.6,132.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Банан",100,0.4,0.4,9.8,47,338]
[{"$nulls":4},"Масло сливочное",10,0.08,7.25,0.13,66]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F103:F111)","v":670},{"$f":"SUM(G103:G111)","v":23.9},32.846,108.13999999999999,869.5699999999999,null,{"$f":"SUM(L103:L111)","v":0}]
[{"$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(F113:F121)","v":0},{"$f":"SUM(G113:G121)","v":0},0,0,0,null,{"$f":"SUM(L113:L121)","v":0}]
[{"$f":"A103","v":2},{"$f":"B103","v":1},"Итого за день:",null,null,{"$f":"F112+F122","v":670},{"$f":"G112+G122","v":23.9},{"$f":"H112+H122","v":32.846},{"$f":"I112+I122","v":108.13999999999999},{"$f":"J112+J122","v":869.5699999999999},null,0]
[2,2,"Завтрак","гор.блюдо","Плов из птицы",200,16.01,18.95,35.414,357.67,291]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,0.79,1.95,3.88,36.24,45]
[{"$nulls":3},"гор.напиток","Кисель",200,0,0,15,60,484]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Печенье",40,3,3.92,29.76,166]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F124:F131)","v":550},{"$f":"SUM(G124:G131)","v":23.080000000000002},25.259999999999998,104.81400000000001,734.9100000000001,null,{"$f":"SUM(L124:L131)","v":0}]
[{"$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(F133:F141)","v":0},{"$f":"SUM(G133:G141)","v":0},0,0,0,null,{"$f":"SUM(L133:L141)","v":0}]
[{"$f":"A124","v":2},{"$f":"B124","v":2},"Итого за день:",null,null,{"$f":"F132+F142","v":550},{"$f":"G132+G142","v":23.080000000000002},{"$f":"H132+H142","v":25.259999999999998},{"$f":"I132+I142","v":104.81400000000001},{"$f":"J132+J142","v":734.9100000000001},null,0]
[2,3,"Завтрак","гор.блюдо","Рыба тушеная в томате с овощами",90,8.38,1.41,4.1,63.06,299]
[{"$nulls":4},"Макаронные изделия отварные с маслом",155,5.55,8.95,29.55,184.5,203]
[{"$nulls":4},"Салат из свеклы отварной",60,0.84,1.66,4.56,54.6,52]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.321,0.005,21.725,88,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Сыр порциями",10,2.32,2.7,0,20.8,15]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F152)","v":573},{"$f":"SUM(G144:G152)","v":20.691},15.165,80.69500000000001,525.96,null,{"$f":"SUM(L144:L152)","v":0}]
[{"$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(F154:F162)","v":0},{"$f":"SUM(G154:G162)","v":0},0,0,0,null,{"$f":"SUM(L154:L162)","v":0}]
[{"$f":"A144","v":2},{"$f":"B144","v":3},"Итого за день:",null,null,{"$f":"F153+F163","v":573},{"$f":"G153+G163","v":20.691},{"$f":"H153+H163","v":15.165},{"$f":"I153+I163","v":80.69500000000001},{"$f":"J153+J163","v":525.96},null,0]
[2,4,"Завтрак","гор.блюдо","Пюре картофельное",150,4.77,5.43,38.85,219.3,312]
[{"$nulls":4},"Котлеты \"Школьное\" с соусом",90,13.77,9.9,11.97,191.7,347]
[{"$nulls":4},"Салат из моркови",60,0.74,0.056,6.89,49.02,62]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром с лимоном",215,0.13,0.02,15.2,62,377]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,11.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты","Яблоко",100,0.4,0.4,9.8,47,338]
[{"$nulls":4},"Масло сливочное",10,0.08,7.25,0.13,66,14]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F173)","v":675},{"$f":"SUM(G165:G173)","v":23.169999999999995},23.496,103.6,750.02,null,{"$f":"SUM(L165:L173)","v":0}]
[{"$f":"A165","v":2},{"$f":"B165","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F175:F183)","v":0},{"$f":"SUM(G175:G183)","v":0},0,0,0,null,{"$f":"SUM(L175:L183)","v":0}]
[{"$f":"A165","v":2},{"$f":"B165","v":4},"Итого за день:",null,null,{"$f":"F174+F184","v":675},{"$f":"G174+G184","v":23.169999999999995},{"$f":"H174+H184","v":23.496},{"$f":"I174+I184","v":103.6},{"$f":"J174+J184","v":750.02},null,0]
[2,5,"Завтрак","гор.блюдо","Сосиски отварные с соусом",90,5.92,13.4,3.8,145.6,243]
[{"$nulls":4},"Макаронные изделия отварные с маслом",155,5.55,8.95,29.55,184.5,203]
[{"$nulls":4},"Салат из белокочанной капусты",60,0.79,1.95,3.88,36.24,45]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,0.66,1.5,22.6,132.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,71]
[{"$nulls":3},"хлеб","Хлеб сельский",20,1,0.2,9,44]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F186:F194)","v":555},{"$f":"SUM(G186:G194)","v":16.199999999999996},26.24,83.59,614.1400000000001,null,{"$f":"SUM(L186:L194)","v":0}]
[{"$f":"A186","v":2},{"$f":"B186","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F196:F204)","v":0},{"$f":"SUM(G196:G204)","v":0},0,0,0,null,{"$f":"SUM(L196:L204)","v":0}]
[{"$f":"A186","v":2},{"$f":"B186","v":5},"Итого за день:",null,null,{"$f":"F195+F205","v":555},{"$f":"G195+G205","v":16.199999999999996},{"$f":"H195+H205","v":26.24},{"$f":"I195+I205","v":83.59},{"$f":"J195+J205","v":614.1400000000001},null,0]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F44+F64+F83+F102+F123+F143+F164+F185+F206)/(IF(F24=0,0,1)+IF(F44=0,0,1)+IF(F64=0,0,1)+IF(F83=0,0,1)+IF(F102=0,0,1)+IF(F123=0,0,1)+IF(F143=0,0,1)+IF(F164=0,0,1)+IF(F185=0,0,1)+IF(F206=0,0,1))","v":599.6},{"$f":"(G24+G44+G64+G83+G102+G123+G143+G164+G185+G206)/(IF(G24=0,0,1)+IF(G44=0,0,1)+IF(G64=0,0,1)+IF(G83=0,0,1)+IF(G102=0,0,1)+IF(G123=0,0,1)+IF(G143=0,0,1)+IF(G164=0,0,1)+IF(G185=0,0,1)+IF(G206=0,0,1))","v":21.013799999999996},{"$f":"(H24+H44+H64+H83+H102+H123+H143+H164+H185+H206)/(IF(H24=0,0,1)+IF(H44=0,0,1)+IF(H64=0,0,1)+IF(H83=0,0,1)+IF(H102=0,0,1)+IF(H123=0,0,1)+IF(H143=0,0,1)+IF(H164=0,0,1)+IF(H185=0,0,1)+IF(H206=0,0,1))","v":25.922799999999995},{"$f":"(I24+I44+I64+I83+I102+I123+I143+I164+I185+I206)/(IF(I24=0,0,1)+IF(I44=0,0,1)+IF(I64=0,0,1)+IF(I83=0,0,1)+IF(I102=0,0,1)+IF(I123=0,0,1)+IF(I143=0,0,1)+IF(I164=0,0,1)+IF(I185=0,0,1)+IF(I206=0,0,1))","v":96.5172},{"$f":"(J24+J44+J64+J83+J102+J123+J143+J164+J185+J206)/(IF(J24=0,0,1)+IF(J44=0,0,1)+IF(J64=0,0,1)+IF(J83=0,0,1)+IF(J102=0,0,1)+IF(J123=0,0,1)+IF(J143=0,0,1)+IF(J164=0,0,1)+IF(J185=0,0,1)+IF(J206=0,0,1))","v":707.2176000000001},null,{"$f":"(L24+L44+L64+L83+L102+L123+L143+L164+L185+L206)/(IF(L24=0,0,1)+IF(L44=0,0,1)+IF(L64=0,0,1)+IF(L83=0,0,1)+IF(L102=0,0,1)+IF(L123=0,0,1)+IF(L143=0,0,1)+IF(L164=0,0,1)+IF(L185=0,0,1)+IF(L206=0,0,1))","v":{"$error":"#DIV/0!"}}]