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

{"sheet":"Лист1","index":0,"n_rows":222,"n_cols":12,"rows_kept":222,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[41,2,41,3],[59,2,59,3],[78,2,78,3],[97,2,97,3],[115,2,115,3],[133,2,133,3],[150,2,150,3],[167,2,167,3],[185,2,185,3],[203,2,203,3],[220,2,220,3],[221,2,221,4]]}
["Школа",null,"МБОУ \"Потапово Тумбарлинская ООШ им.Г.П.Евсеева\" Бавлинского муниципального района РТ",null,null,"Утвердил:","должность"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Азабина Н.А."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Плов из птицы",200,12.25,15.37,40.05,361.3,291]
[{"$nulls":3},"салат","Салат из белокочанной капусты",60,2.99,3.82,4.7,"52.8",45]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром, лимоном",215,0.13,0.02,15.2,62,377]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":525},{"$f":"SUM(G6:G12)","v":19.250000000000004},19.749999999999996,82.73,587.5,null,77.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(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":525},{"$f":"G13+G23","v":19.250000000000004},19.749999999999996,82.73,587.5,null,{"$f":"L13+L23","v":77.76}]
[1,2,"Завтрак","гор.блюдо","Картофельное пюре, тефтели говяжьи с соусом",240,11.58,16.9,18.36,216.97,"312, 279"]
[{"$nulls":3},"гор.напиток","Компот из смеси сухофруктов",200,1.16,0.3,12.7,112.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[{"$nulls":3},"сладкое","Печенье",40,2.36,1.88,30,146.4,582]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F30)","v":530},{"$f":"SUM(G25:G30)","v":18.98},{"$f":"SUM(H25:H30)","v":19.619999999999997},{"$f":"SUM(I25:I30)","v":83.84},{"$f":"SUM(J25:J30)","v":587.5699999999999},null,77.76]
[{"$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(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},{"$f":"SUM(H32:H40)","v":0},{"$f":"SUM(I32:I40)","v":0},{"$f":"SUM(J32:J40)","v":0},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":530},{"$f":"G31+G41","v":18.98},{"$f":"H31+H41","v":19.619999999999997},{"$f":"I31+I41","v":83.84},{"$f":"J31+J41","v":587.5699999999999},null,77.76]
[1,3,"Завтрак","гор.блюдо","Макаронные изделия отварные с маслом, фрикадельки куриные в соусе",250,14.84,18.74,36.11,368.98,"203, 297"]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.07,0.02,15,60,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[{"$nulls":3},"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,338]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F43:F48)","v":608},{"$f":"SUM(G43:G48)","v":19.19},{"$f":"SUM(H43:H48)","v":19.699999999999996},{"$f":"SUM(I43:I48)","v":83.69},{"$f":"SUM(J43:J48)","v":587.38},null,77.76]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F50:F58)","v":0},{"$f":"SUM(G50:G58)","v":0},{"$f":"SUM(H50:H58)","v":0},{"$f":"SUM(I50:I58)","v":0},{"$f":"SUM(J50:J58)","v":0},null,0]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F49+F59","v":608},{"$f":"G49+G59","v":19.19},{"$f":"H49+H59","v":19.699999999999996},{"$f":"I49+I59","v":83.69},{"$f":"J49+J59","v":587.38},null,77.76]
[1,4,"Завтрак","гор.блюдо","Гречка с курицей по-купечески",200,12.02,15.2,40.28,361.3,370]
[{"$nulls":3},"салат","Салат из свеклы отварной",60,0.84,3.66,4.56,54.6,52]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.07,0.02,15,60,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F61:F67)","v":518},{"$f":"SUM(G61:G67)","v":16.81},{"$f":"SUM(H61:H67)","v":19.419999999999998},{"$f":"SUM(I61:I67)","v":82.62},{"$f":"SUM(J61:J67)","v":587.3000000000001},null,77.76]
[{"$f":"A61","v":1},{"$f":"B61","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F69:F77)","v":0},{"$f":"SUM(G69:G77)","v":0},{"$f":"SUM(H69:H77)","v":0},{"$f":"SUM(I69:I77)","v":0},{"$f":"SUM(J69:J77)","v":0},null,0]
[{"$f":"A61","v":1},{"$f":"B61","v":4},"Итого за день:",null,null,{"$f":"F68+F78","v":518},{"$f":"G68+G78","v":16.81},{"$f":"H68+H78","v":19.419999999999998},{"$f":"I68+I78","v":82.62},{"$f":"J68+J78","v":587.3000000000001},null,77.76]
[1,5,"Завтрак","гор.блюдо","Рагу из птицы",200,14.5,17.54,40.8,348.2,289]
[{"$nulls":3},"салат","Салат из моркови",60,"0.74",1.128,4.886,49.02,62]
[{"$nulls":3},"гор.напиток","Кисель",200,0,0,15,60,484]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F80:F86)","v":510},19.12,{"$f":"SUM(H80:H86)","v":19.208},{"$f":"SUM(I80:I86)","v":83.466},{"$f":"SUM(J80:J86)","v":568.62},null,77.76]
[{"$f":"A80","v":1},{"$f":"B80","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F88:F96)","v":0},{"$f":"SUM(G88:G96)","v":0},{"$f":"SUM(H88:H96)","v":0},{"$f":"SUM(I88:I96)","v":0},{"$f":"SUM(J88:J96)","v":0},null,0]
[{"$f":"A80","v":1},{"$f":"B80","v":5},"Итого за день:",null,null,{"$f":"F87+F97","v":510},{"$f":"G87+G97","v":19.12},{"$f":"H87+H97","v":19.208},{"$f":"I87+I97","v":83.466},{"$f":"J87+J97","v":568.62},null,77.76]
[1,6,"Завтрак","гор.блюдо","Макаронные изделия отварные с маслом, птица тушеная в соусе",250,15.25,17.27,34.27,349.93,"203, 290"]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.07,0.02,15,60,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F99:F104)","v":508},{"$f":"SUM(G99:G104)","v":19.200000000000003},{"$f":"SUM(H99:H104)","v":17.83},{"$f":"SUM(I99:I104)","v":72.05},{"$f":"SUM(J99:J104)","v":521.33},null,77.76]
[{"$f":"A99","v":1},{"$f":"B99","v":6},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F114)","v":0},{"$f":"SUM(G106:G114)","v":0},0,0,0,null,{"$f":"SUM(L106:L114)","v":0}]
[{"$f":"A99","v":1},{"$f":"B99","v":6},"Итого за день:",null,null,{"$f":"F105+F115","v":508},{"$f":"G105+G115","v":19.200000000000003},17.83,72.05,521.33,null,{"$f":"L105+L115","v":77.76}]
[2,1,"Завтрак","гор.блюдо","Каша вязкая молочная пшенная с маслом",205,13.7,17.51,38.14,314.25,173]
[{"$nulls":3},"гор.напиток","Компот из смеси сухофруктов",200,1.16,0.3,12.7,112.8,349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"фрукты","Фрукты свежие ",100,0.4,0.4,9.8,47,338]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F117:F122)","v":555},{"$f":"SUM(G117:G122)","v":19.14},{"$f":"SUM(H117:H122)","v":18.75},{"$f":"SUM(I117:I122)","v":83.42},{"$f":"SUM(J117:J122)","v":585.45},null,77.76]
[{"$f":"A117","v":2},{"$f":"B117","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F124:F132)","v":0},{"$f":"SUM(G124:G132)","v":0},0,0,0,null,{"$f":"SUM(L124:L132)","v":0}]
[{"$f":"A117","v":2},{"$f":"B117","v":1},"Итого за день:",null,null,{"$f":"F123+F133","v":555},{"$f":"G123+G133","v":19.14},{"$f":"H123+H133","v":18.75},{"$f":"I123+I133","v":83.42},{"$f":"J123+J133","v":585.45},null,77.76]
[2,2,"Завтрак","гор.блюдо","Макаронные изделия отварные с маслом, фрикадельки куриные в соусе",250,14.84,18.74,36.11,368.98,"203, 297"]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.07,0.02,15,60,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F135:F139)","v":508},{"$f":"SUM(G135:G139)","v":18.790000000000003},{"$f":"SUM(H135:H139)","v":19.299999999999997},{"$f":"SUM(I135:I139)","v":73.89},{"$f":"SUM(J135:J139)","v":540.38},null,77.76]
[{"$f":"A135","v":2},{"$f":"B135","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F141:F149)","v":0},{"$f":"SUM(G141:G149)","v":0},0,0,0,null,{"$f":"SUM(L141:L149)","v":0}]
[{"$f":"A135","v":2},{"$f":"B135","v":2},"Итого за день:",null,null,{"$f":"F140+F150","v":508},{"$f":"G140+G150","v":18.790000000000003},{"$f":"H140+H150","v":19.299999999999997},{"$f":"I140+I150","v":73.89},{"$f":"J140+J150","v":540.38},null,77.76]
[2,3,"Завтрак","гор.блюдо","Рыба, тушенная в томате с овощами, картофельное пюре",250,12.05,17.58,42.72,356.65,229.312]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром, лимоном",215,0.13,0.02,15.2,62,377]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F152:F156)","v":515},{"$f":"SUM(G152:G156)","v":16.060000000000002},{"$f":"SUM(H152:H156)","v":18.139999999999997},{"$f":"SUM(I152:I156)","v":80.7},{"$f":"SUM(J152:J156)","v":530.05},null,77.76]
[{"$f":"A152","v":2},{"$f":"B152","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F158:F166)","v":0},{"$f":"SUM(G158:G166)","v":0},0,0,0,null,{"$f":"SUM(L158:L166)","v":0}]
[{"$f":"A152","v":2},{"$f":"B152","v":3},"Итого за день:",null,null,{"$f":"F157+F167","v":515},{"$f":"G157+G167","v":16.060000000000002},{"$f":"H157+H167","v":18.139999999999997},{"$f":"I157+I167","v":80.7},{"$f":"J157+J167","v":530.05},null,77.76]
[2,4,"Завтрак","гор.блюдо","Гречка с курицей по-купечески",200,12.02,15.2,40.28,361.3,370]
[{"$nulls":3},"салат","Салат из белокочанной капусты",60,2.99,3.82,4.7,52.8,45]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.07,0.02,15,60,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F169:F174)","v":518},{"$f":"SUM(G169:G174)","v":18.96},{"$f":"SUM(H169:H174)","v":19.58},{"$f":"SUM(I169:I174)","v":82.76},{"$f":"SUM(J169:J174)","v":585.5000000000001},null,77.76]
[{"$f":"A169","v":2},{"$f":"B169","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F176:F184)","v":0},{"$f":"SUM(G176:G184)","v":0},0,0,0,null,{"$f":"SUM(L176:L184)","v":0}]
[{"$f":"A169","v":2},{"$f":"B169","v":4},"Итого за день:",null,null,{"$f":"F175+F185","v":518},{"$f":"G175+G185","v":18.96},{"$f":"H175+H185","v":19.58},{"$f":"I175+I185","v":82.76},{"$f":"J175+J185","v":585.5000000000001},null,77.76]
[2,5,"Завтрак","гор.блюдо","Рагу из птицы",200,14.5,17.54,40.8,348.2,289]
[{"$nulls":3},"салат","Салат из моркови",60,"0.74",1.128,4.886,49.02,62]
[{"$nulls":3},"гор.напиток","Кисель",200,0,0,15,60,484]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F187:F192)","v":510},19.12,{"$f":"SUM(H187:H192)","v":19.208},{"$f":"SUM(I187:I192)","v":83.466},{"$f":"SUM(J187:J192)","v":568.62},null,77.76]
[{"$f":"A187","v":2},{"$f":"B187","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F194:F202)","v":0},{"$f":"SUM(G194:G202)","v":0},0,0,0,null,{"$f":"SUM(L194:L202)","v":0}]
[{"$f":"A187","v":2},{"$f":"B187","v":5},"Итого за день:",null,null,{"$f":"F193+F203","v":510},{"$f":"G193+G203","v":19.12},19.208,83.466,568.62,null,{"$f":"L193+L203","v":77.76}]
[2,6,"Завтрак","гор.блюдо","Макаронные изделия отварные с маслом, птица тушеная в соусе",250,15.25,17.27,34.27,349.93,"203, 290"]
[{"$nulls":3},"гор.напиток","Чай черный с сахаром",208,0.07,0.02,15,60,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб","Хлеб дарницкий",20,1.6,0.3,8.02,41.2,574]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F205:F209)","v":508},{"$f":"SUM(G205:G209)","v":19.200000000000003},{"$f":"SUM(H205:H209)","v":17.83},{"$f":"SUM(I205:I209)","v":72.05},{"$f":"SUM(J205:J209)","v":521.33},null,77.76]
[{"$f":"A205","v":2},{"$f":"B205","v":6},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F211:F219)","v":0},{"$f":"SUM(G211:G219)","v":0},0,0,0,null,{"$f":"SUM(L211:L219)","v":0}]
[{"$f":"A205","v":2},{"$f":"B205","v":6},"Итого за день:",null,null,{"$f":"F210+F220","v":508},{"$f":"G210+G220","v":19.200000000000003},17.83,72.05,521.33,null,{"$f":"L210+L220","v":77.76}]
[null,null,"Среднее значение за период:",null,null,6313,223.82,228.336,{"$f":"(I24+I42+I60+I79+I98+I116+I134+I151+I168+I186+I204+I221)/(IF(I24=0,0,1)+IF(I42=0,0,1)+IF(I60=0,0,1)+IF(I79=0,0,1)+IF(I98=0,0,1)+IF(I116=0,0,1)+IF(I134=0,0,1)+IF(I151=0,0,1)+IF(I168=0,0,1)+IF(I186=0,0,1)+IF(I204=0,0,1)+IF(I221=0,0,1))","v":80.39016666666667},6771.03,null,{"$f":"SUM(L221)","v":77.76}]