{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":198,"n_cols":12,"rows_kept":198,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[41,2,41,3],[60,2,60,3],[79,2,79,3],[100,2,100,3],[120,2,120,3],[139,2,139,3],[158,2,158,3],[177,2,177,3],[196,2,196,3],[197,2,197,4]]}
["Школа",null,"МБОУ \"Красногвардейская школа № 2\"",null,null,"Утвердил:","должность","ИП"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Рыбаченко"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",13,1,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор. блюдо","Каша молочная рисовая с изюмом",220,6.4,11.4,50.3,330,177,78.05]
[null,null,null,"кисломол","Сыр (порциями)",15,3.48,4.43,0,54,11]
[null,null,null,"гор. напиток","Чай с сахаром",210,0.07,0.02,10,40,261]
[null,null,null,"хлеб","Хлеб пшеничный",35,2.7,0.3,17.2,81.9,573]
[null,null,null,"хлеб","Хлеб ржаной",25,2,0.4,10,51.5,574]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":505},{"$f":"SUM(G6:G12)","v":14.65},{"$f":"SUM(H6:H12)","v":16.55},{"$f":"SUM(I6:I12)","v":87.5},{"$f":"SUM(J6:J12)","v":557.4},null,78.05]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F14:F22)","v":0},{"$f":"SUM(G14:G22)","v":0},{"$f":"SUM(H14:H22)","v":0},{"$f":"SUM(I14:I22)","v":0},{"$f":"SUM(J14:J22)","v":0},null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":505},{"$f":"G13+G23","v":14.65},{"$f":"H13+H23","v":16.55},{"$f":"I13+I23","v":87.5},{"$f":"J13+J23","v":557.4},null,{"$f":"L13+L23","v":78.05}]
[1,2,"Завтрак","гор. блюдо","Запеканка из творога с йогуртом",165,25.9,19,20.3,350.1,154,78.05]
[null,null,null,"гор. напиток","Какао с молоком",200,4.1,3.5,17.6,118,266]
[null,null,null,"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,231]
[null,null,null,"хлеб","Бутерброд  с повидлом",55,2.4,3.87,27.83,156,2]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F25:F30)","v":520},{"$f":"SUM(G25:G30)","v":32.8},{"$f":"SUM(H25:H30)","v":26.77},{"$f":"SUM(I25:I30)","v":75.53},{"$f":"SUM(J25:J30)","v":671.1},null,78.05]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",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,{"$f":"SUM(L32:L40)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":520},{"$f":"G31+G41","v":32.8},{"$f":"H31+H41","v":26.77},{"$f":"I31+I41","v":75.53},{"$f":"J31+J41","v":671.1},null,{"$f":"L31+L41","v":78.05}]
[1,3,"Завтрак","закуска","Салат из свежей белокочанной капусты",80,1.05,2.6,5.17,48.3,45,78.05]
[null,null,null,"гор. блюдо","Пюре картофельное",150,3.1,4.8,20.4,136.5,210]
[null,null,null,"2 блюдо","Тефтели мясные в соусе",140,9.21,9.65,9.97,164,"187/223"]
[null,null,null,"напиток","Кофейный напиток с молоком",200,3.2,2.7,15.9,100,264]
[null,null,null,"хлеб","Хлеб пшеничный",40,3,0.3,19.7,93.6,573]
[null,null,null,"хлеб","Хлеб ржаной",20,1.6,0.3,8,41.2,574]
[]
[null,null,null,"итого",null,{"$f":"SUM(F43:F49)","v":630},{"$f":"SUM(G43:G49)","v":21.16},{"$f":"SUM(H43:H49)","v":20.35},{"$f":"SUM(I43:I49)","v":79.14},{"$f":"SUM(J43:J49)","v":583.6},null,78.05]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F51:F59)","v":0},{"$f":"SUM(G51:G59)","v":0},{"$f":"SUM(H51:H59)","v":0},{"$f":"SUM(I51:I59)","v":0},{"$f":"SUM(J51:J59)","v":0},null,{"$f":"SUM(L51:L59)","v":0}]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F50+F60","v":630},{"$f":"G50+G60","v":21.16},{"$f":"H50+H60","v":20.35},{"$f":"I50+I60","v":79.14},{"$f":"J50+J60","v":583.6},null,{"$f":"L50+L60","v":78.05}]
[1,4,"Завтрак","закуска","Овощи натуральные по сезону",80,0.64,0.08,1.36,8,53,78.05]
[null,null,null,"2 блюдо","Омлет натуральный",116,11.2,21.2,2.1,241.6,144]
[null,null,null,"гор. напиток","Сок фруктовый",200,1,0,20.2,84,271]
[null,null,null,"фрукты","Фрукты свежие ",100,0.4,0.4,9.8,47,231]
[null,null,null,"хлеб","Хлеб пшеничный",35,2.7,0.3,17.2,81.9,573]
[null,null,null,"хлеб","Хлеб ржаной",20,1.6,0.3,8,41.2,574]
[]
[null,null,null,"итого",null,{"$f":"SUM(F62:F68)","v":551},{"$f":"SUM(G62:G68)","v":17.54},{"$f":"SUM(H62:H68)","v":22.28},{"$f":"SUM(I62:I68)","v":58.66},{"$f":"SUM(J62:J68)","v":503.7},null,78.05]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F70:F78)","v":0},{"$f":"SUM(G70:G78)","v":0},{"$f":"SUM(H70:H78)","v":0},{"$f":"SUM(I70:I78)","v":0},{"$f":"SUM(J70:J78)","v":0},null,{"$f":"SUM(L70:L78)","v":0}]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Итого за день:",null,null,{"$f":"F69+F79","v":551},{"$f":"G69+G79","v":17.54},{"$f":"H69+H79","v":22.28},{"$f":"I69+I79","v":58.66},{"$f":"J69+J79","v":503.7},null,{"$f":"L69+L79","v":78.05}]
[1,5,"Завтрак","закуска","Овощи натуральные по сезону",80,0.64,0.08,1.36,8,53,78.05]
[null,null,null,"2 блюдо","Рыба, тушенная в томате с овощами",100,10.3,3.6,3.9,89,158]
[null,null,null,"гор. блюдо","Каша рассыпчатая рисовая",150,3.6,4.2,38.4,205.5,114]
[null,null,null,"гор. напиток","Чай с сахаром ",210,0.07,0.02,10,40,261]
[null,null,null,"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,231]
[null,null,null,"хлеб","Хлеб пшеничный",40,3,0.3,19.7,93.6,573]
[null,null,null,"хлеб","Хлеб ржаной",20,1.6,0.3,8,41.2,574]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F81:F89)","v":700},{"$f":"SUM(G81:G89)","v":19.61},{"$f":"SUM(H81:H89)","v":8.9},{"$f":"SUM(I81:I89)","v":91.16},{"$f":"SUM(J81:J89)","v":524.3},null,78.05]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F91:F99)","v":0},{"$f":"SUM(G91:G99)","v":0},{"$f":"SUM(H91:H99)","v":0},{"$f":"SUM(I91:I99)","v":0},{"$f":"SUM(J91:J99)","v":0},null,{"$f":"SUM(L91:L99)","v":0}]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F90+F100","v":700},{"$f":"G90+G100","v":19.61},{"$f":"H90+H100","v":8.9},{"$f":"I90+I100","v":91.16},{"$f":"J90+J100","v":524.3},null,{"$f":"L90+L100","v":78.05}]
[2,6,"Завтрак","гор. блюдо","Каша молочная пшённая с изюмом",220,8.6,12.5,48.4,341.5,177,78.05]
[null,null,null,"гор. напиток","Кофейный напиток с молоком",200,3.2,2.7,15.9,100,264]
[null,null,null,"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,231]
[null,null,null,"булочное","Кондитерские изделия",20,1.5,2,16.9,93,582]
[null,null,null,"хлеб","Хлеб пшеничный",35,2.7,0.3,17.2,81.9,573]
[null,null,null,"хлеб","Хлеб ржаной",20,1.6,0.3,8,41.2,574]
[]
[]
[null,null,null,"итого",null,595,{"$f":"SUM(G102:G109)","v":18},{"$f":"SUM(H102:H109)","v":18.2},{"$f":"SUM(I102:I109)","v":116.2},{"$f":"SUM(J102:J109)","v":704.6},null,78.05]
[{"$f":"A102","v":2},6,"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F111:F119)","v":0},{"$f":"SUM(G111:G119)","v":0},{"$f":"SUM(H111:H119)","v":0},{"$f":"SUM(I111:I119)","v":0},{"$f":"SUM(J111:J119)","v":0},null,{"$f":"SUM(L111:L119)","v":0}]
[{"$f":"A102","v":2},{"$f":"B102","v":6},"Итого за день:",null,null,{"$f":"F110+F120","v":595},{"$f":"G110+G120","v":18},{"$f":"H110+H120","v":18.2},{"$f":"I110+I120","v":116.2},{"$f":"J110+J120","v":704.6},null,{"$f":"L110+L120","v":78.05}]
[2,7,"Завтрак","гор. блюдо","Рагу из овощей",150,2.6,8,14.7,141,"102/222",78.05]
[null,null,null,"2 блюдо","Котлета говяжья",95,14.6,21.1,14.4,306.6,182]
[null,null,null,"гор. напиток","Чай с сахаром ",210,0.07,0.02,10,40,261]
[null,null,null,"хлеб","Хлеб пшеничный",40,3,0.3,19.7,93.6,573]
[null,null,null,"хлеб","Хлеб ржаной",25,2,0.4,10,51.5,574]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F122:F128)","v":520},{"$f":"SUM(G122:G128)","v":22.27},{"$f":"SUM(H122:H128)","v":29.82},{"$f":"SUM(I122:I128)","v":68.8},{"$f":"SUM(J122:J128)","v":632.7},null,78.05]
[{"$f":"A122","v":2},7,"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F130:F138)","v":0},{"$f":"SUM(G130:G138)","v":0},{"$f":"SUM(H130:H138)","v":0},{"$f":"SUM(I130:I138)","v":0},{"$f":"SUM(J130:J138)","v":0},null,{"$f":"SUM(L130:L138)","v":0}]
[{"$f":"A122","v":2},{"$f":"B122","v":7},"Итого за день:",null,null,{"$f":"F129+F139","v":520},{"$f":"G129+G139","v":22.27},{"$f":"H129+H139","v":29.82},{"$f":"I129+I139","v":68.8},{"$f":"J129+J139","v":632.7},null,{"$f":"L129+L139","v":78.05}]
[2,8,"Завтрак","закуска","Икра кабачковая",60,0.96,3.78,4.44,54.5,"СРБ",78.05]
[null,null,null,"2 блюдо","Птица, тушенная в соусе",100,11.94,10.12,3.51,153,"198/223"]
[null,null,null,"гор. блюдо","Каша рассыпчатая рисовая",150,3.6,4.2,38.4,205.5,114]
[null,null,null,"гор. напиток","Чай с сахаром",210,0.07,0.02,10,40,261]
[null,null,null,"хлеб","Хлеб пшеничный",40,3,0.3,19.7,93.6,573]
[null,null,null,"хлеб","Хлеб ржаной",25,2,0.4,10,51.5,574]
[]
[null,null,null,"итого",null,{"$f":"SUM(F141:F147)","v":585},{"$f":"SUM(G141:G147)","v":21.57},{"$f":"SUM(H141:H147)","v":18.82},{"$f":"SUM(I141:I147)","v":86.05},{"$f":"SUM(J141:J147)","v":598.1},null,78.05]
[{"$f":"A141","v":2},8,"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F149:F157)","v":0},{"$f":"SUM(G149:G157)","v":0},{"$f":"SUM(H149:H157)","v":0},{"$f":"SUM(I149:I157)","v":0},{"$f":"SUM(J149:J157)","v":0},null,{"$f":"SUM(L149:L157)","v":0}]
[{"$f":"A141","v":2},{"$f":"B141","v":8},"Итого за день:",null,null,{"$f":"F148+F158","v":585},{"$f":"G148+G158","v":21.57},{"$f":"H148+H158","v":18.82},{"$f":"I148+I158","v":86.05},{"$f":"J148+J158","v":598.1},null,{"$f":"L148+L158","v":78.05}]
[2,9,"Завтрак","2 блюдо","Печень по- строгановски",100,14.06,8.34,7.57,162,"172/224",78.05]
[null,null,null,"гор. блюдо","Каша рассыпчатая гречневая",150,8.7,6,39.6,246,114]
[null,null,null,"кисломолочн","Кефир",200,5.8,5,8,100,268]
[null,null,null,"хлеб","Хлеб пшеничный",40,3,0.3,19.7,93.6,573]
[null,null,null,"хлеб","Хлеб ржаной",25,2,0.4,10,51.5,574]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F160:F166)","v":515},{"$f":"SUM(G160:G166)","v":33.56},{"$f":"SUM(H160:H166)","v":20.04},{"$f":"SUM(I160:I166)","v":84.87},{"$f":"SUM(J160:J166)","v":653.1},null,78.05]
[{"$f":"A160","v":2},9,"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F168:F176)","v":0},{"$f":"SUM(G168:G176)","v":0},{"$f":"SUM(H168:H176)","v":0},{"$f":"SUM(I168:I176)","v":0},{"$f":"SUM(J168:J176)","v":0},null,{"$f":"SUM(L168:L176)","v":0}]
[{"$f":"A160","v":2},{"$f":"B160","v":9},"Итого за день:",null,null,{"$f":"F167+F177","v":515},{"$f":"G167+G177","v":33.56},{"$f":"H167+H177","v":20.04},{"$f":"I167+I177","v":84.87},{"$f":"J167+J177","v":653.1},null,{"$f":"L167+L177","v":78.05}]
[2,10,"Завтрак","закуска","Овощи натуральные по сезону",80,0.64,0.08,1.36,8,53,78.05]
[null,null,null,"гор. блюдо","Макароны отварные с сыром",170,9.2,6.5,32,243.3,204]
[null,null,null,"булочное","Кондитерские изделия",20,1.5,2,16.9,93,582]
[null,null,null,"напиток","Сок фруктовый",200,1,0,20.2,84,271]
[null,null,null,"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,231]
[null,null,null,"хлеб","Хлеб ржаной",20,1.6,0.3,8,41.2,574]
[]
[null,null,null,"итого",null,{"$f":"SUM(F179:F185)","v":590},{"$f":"SUM(G179:G185)","v":14.34},{"$f":"SUM(H179:H185)","v":9.28},{"$f":"SUM(I179:I185)","v":88.26},{"$f":"SUM(J179:J185)","v":516.5},null,78.05]
[{"$f":"A179","v":2},10,"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[null,null,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F187:F195)","v":0},{"$f":"SUM(G187:G195)","v":0},{"$f":"SUM(H187:H195)","v":0},{"$f":"SUM(I187:I195)","v":0},{"$f":"SUM(J187:J195)","v":0},null,{"$f":"SUM(L187:L195)","v":0}]
[{"$f":"A179","v":2},{"$f":"B179","v":10},"Итого за день:",null,null,{"$f":"F186+F196","v":590},{"$f":"G186+G196","v":14.34},{"$f":"H186+H196","v":9.28},{"$f":"I186+I196","v":88.26},{"$f":"J186+J196","v":516.5},null,{"$f":"L186+L196","v":78.05}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F42+F61+F80+F101+F121+F140+F159+F178+F197)/(IF(F24=0,0,1)+IF(F42=0,0,1)+IF(F61=0,0,1)+IF(F80=0,0,1)+IF(F101=0,0,1)+IF(F121=0,0,1)+IF(F140=0,0,1)+IF(F159=0,0,1)+IF(F178=0,0,1)+IF(F197=0,0,1))","v":571.1},{"$f":"(G24+G42+G61+G80+G101+G121+G140+G159+G178+G197)/(IF(G24=0,0,1)+IF(G42=0,0,1)+IF(G61=0,0,1)+IF(G80=0,0,1)+IF(G101=0,0,1)+IF(G121=0,0,1)+IF(G140=0,0,1)+IF(G159=0,0,1)+IF(G178=0,0,1)+IF(G197=0,0,1))","v":21.55},{"$f":"(H24+H42+H61+H80+H101+H121+H140+H159+H178+H197)/(IF(H24=0,0,1)+IF(H42=0,0,1)+IF(H61=0,0,1)+IF(H80=0,0,1)+IF(H101=0,0,1)+IF(H121=0,0,1)+IF(H140=0,0,1)+IF(H159=0,0,1)+IF(H178=0,0,1)+IF(H197=0,0,1))","v":19.101},{"$f":"(I24+I42+I61+I80+I101+I121+I140+I159+I178+I197)/(IF(I24=0,0,1)+IF(I42=0,0,1)+IF(I61=0,0,1)+IF(I80=0,0,1)+IF(I101=0,0,1)+IF(I121=0,0,1)+IF(I140=0,0,1)+IF(I159=0,0,1)+IF(I178=0,0,1)+IF(I197=0,0,1))","v":83.617},{"$f":"(J24+J42+J61+J80+J101+J121+J140+J159+J178+J197)/(IF(J24=0,0,1)+IF(J42=0,0,1)+IF(J61=0,0,1)+IF(J80=0,0,1)+IF(J101=0,0,1)+IF(J121=0,0,1)+IF(J140=0,0,1)+IF(J159=0,0,1)+IF(J178=0,0,1)+IF(J197=0,0,1))","v":594.51},null,{"$f":"(L24+L42+L61+L80+L101+L121+L140+L159+L178+L197)/(IF(L24=0,0,1)+IF(L42=0,0,1)+IF(L61=0,0,1)+IF(L80=0,0,1)+IF(L101=0,0,1)+IF(L121=0,0,1)+IF(L140=0,0,1)+IF(L159=0,0,1)+IF(L178=0,0,1)+IF(L197=0,0,1))","v":78.05}]