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

{"sheet":"Лист1","index":0,"n_rows":180,"n_cols":12,"rows_kept":180,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[40,2,40,3],[58,2,58,3],[74,2,74,3],[91,2,91,3],[108,2,108,3],[126,2,126,3],[143,2,143,3],[161,2,161,3],[178,2,178,3],[179,2,179,4]]}
["Школа",null,"МБОУ \"СОШ №4\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Хасанов Р.Р."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",2,3,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Сырники из творога с кашей молочной \"Дружба\" с маслом сливочным",215,10.55,11.85,39.4,324.45,"ТТК"]
[{"$nulls":3},"гор.напиток","Кофейный напиток с молоком",200,3.1660000000000004,2.6780000000000004,6,60.7,"№379"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл№6"]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"табл №9"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":545},{"$f":"SUM(G6:G11)","v":16.096},{"$f":"SUM(H6:H11)","v":15.288},{"$f":"SUM(I6:I11)","v":67.08},{"$f":"SUM(J6:J11)","v":491.54999999999995},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(F13:F21)","v":0},0,0,0,0,null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":545},16.096,15.288,67.08,491.54999999999995,null,{"$f":"L12+L22","v":77.76}]
[1,2,"Завтрак","гор.блюдо","Птица запеченная",100,10.42,12.43,8.65,192,"ТТК"]
[{"$nulls":3},"гарнир","Пюре картофельное с маслом сливочным",153,3.0765,6.2535,20.466999999999995,150.45,"№312"]
[{"$nulls":3},"гор.напиток","Напиток из свежих фруктов ",200,0.34,0.17,21.46,103.5,"ТТК"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,"табл №6"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл №6"]
[{"$nulls":3},"закуска","Свекла отварная дольками",60,1.08,0.06,5.88,28.8,"ТТК"]
[{"$nulls":3},"итого",null,573,19.176499999999997,19.513499999999997,83.097,604.65,null,77.76]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого"]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F30+F40","v":573},19.176499999999997,19.513499999999997,83.097,604.65,null,{"$f":"L30+L40","v":77.76}]
[1,3,"Завтрак","гор.блюдо","Гуляш из говядины",100,10.39,14.79,10.3,221,"№260"]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая",150,3.77,2.290000000000001,39.72,214,"№171"]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с лимоном ",200,0.112,0.018000000000000002,10.149999999999999,41.32,"№377"]
[{"$nulls":3},"хлеб","Хлеб ржаной",50,3.3,0.6000000000000001,19.800000000000004,99.00000000000003,"табл №6"]
[{"$nulls":3},"кисломол","Сыр порционно",10,2.63,2.66,0,34.333333333333336,"№15"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F42:F47)","v":510},{"$f":"SUM(G42:G47)","v":20.201999999999998},{"$f":"SUM(H42:H47)","v":20.358},{"$f":"SUM(I42:I47)","v":79.97},{"$f":"SUM(J42:J47)","v":609.6533333333334},null,77.76]
[{"$f":"A42","v":1},{"$f":"B42","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F49:F57)","v":0},0,0,0,0,null,{"$f":"SUM(L49:L57)","v":0}]
[{"$f":"A42","v":1},{"$f":"B42","v":3},"Итого за день:",null,null,{"$f":"F48+F58","v":510},20.201999999999998,20.358,79.97,609.6533333333334,null,{"$f":"L48+L58","v":77.76}]
[1,4,"Завтрак","гор.блюдо","Жаркое по домашнему с индейкой",200,15.33,16.99,34.77,335.2,"ТТК"]
[{"$nulls":3},"гор.напиток","Напиток из шиповника",200,0.68,0.28,20.76,88.2,"ТТК"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",40,2.28,0.24,14.76,70.5,"табл №6"]
[{"$nulls":3},"закуска","Салат из квашенной капусты",60,1.02,3,5.07,51.42,"ТТК"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F60:F63)","v":500},{"$f":"SUM(G60:G63)","v":19.310000000000002},{"$f":"SUM(H60:H63)","v":20.509999999999998},{"$f":"SUM(I60:I63)","v":75.36000000000001},{"$f":"SUM(J60:J63)","v":545.3199999999999},null,77.76]
[{"$f":"A60","v":1},{"$f":"B60","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F73)","v":0},0,0,0,0,null,{"$f":"SUM(L65:L73)","v":0}]
[{"$f":"A60","v":1},{"$f":"B60","v":4},"Итого за день:",null,null,{"$f":"F64+F74","v":500},19.310000000000002,20.509999999999998,75.36000000000001,545.3199999999999,null,{"$f":"L64+L74","v":77.76}]
[1,5,"Завтрак","гор.блюдо","Котлета из мяса птицы с макаронными изделиями отварными, с маслом сливочным",230,11.45,12.46,31.32,289.95,"ТТК"]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов ",200,0.662,0.09000000000000001,22.034000000000002,92.80000000000001,"№349"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл №6"]
[{"$nulls":3},"закуска","Икра кабачковая",60,0.64,3.31,5.03,50.28,"ТТК"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F76:F80)","v":520},{"$f":"SUM(G76:G80)","v":14.732000000000001},{"$f":"SUM(H76:H80)","v":16.22},{"$f":"SUM(I76:I80)","v":70.264},{"$f":"SUM(J76:J80)","v":492.42999999999995},null,77.76]
[{"$f":"A76","v":1},{"$f":"B76","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F90)","v":0},0,0,0,0,null,{"$f":"SUM(L82:L90)","v":0}]
[{"$f":"A76","v":1},{"$f":"B76","v":5},"Итого за день:",null,null,{"$f":"F81+F91","v":520},14.732000000000001,16.22,70.264,492.42999999999995,null,{"$f":"L81+L91","v":77.76}]
[2,1,"Завтрак","гор.блюдо","Сырники из творога с кашей пшенной молочной с маслом сливочным",245,16.02,18.13,42.98,386.4,"ТТК"]
[{"$nulls":3},"гор.напиток","Чай \"Витаминный\" с шиповником",200,0.235,0.09,12.424999999999999,54.2,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75,"табл №6"]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.9799999999999998,0.36,11.88,59.4,"табл №6"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F93:F97)","v":500},{"$f":"SUM(G93:G97)","v":20.134999999999998},{"$f":"SUM(H93:H97)","v":18.779999999999998},{"$f":"SUM(I93:I97)","v":79.585},{"$f":"SUM(J93:J97)","v":558.75},null,77.76]
[{"$f":"A93","v":2},{"$f":"B93","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F99:F107)","v":0},0,0,0,0,null,{"$f":"SUM(L99:L107)","v":0}]
[{"$f":"A93","v":2},{"$f":"B93","v":1},"Итого за день:",null,null,{"$f":"F98+F108","v":500},20.134999999999998,18.779999999999998,79.585,558.75,null,{"$f":"L98+L108","v":77.76}]
[2,2,"Завтрак","гор.блюдо","Овощи тушеные с мясом",200,12.475,15.68,19.334999999999997,271.5,"№143"]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов ",200,0.662,0.09000000000000001,22.034000000000002,92.80000000000001,"№349"]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24000000000000002,7.920000000000002,39.60000000000001,"табл №6"]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (апельсины)",180,1.62,0.36,14.58,77.4,"табл №9"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F110:F115)","v":600},{"$f":"SUM(G110:G115)","v":16.077},{"$f":"SUM(H110:H115)","v":16.369999999999997},{"$f":"SUM(I110:I115)","v":63.869},{"$f":"SUM(J110:J115)","v":481.30000000000007},null,77.76]
[{"$f":"A110","v":2},{"$f":"B110","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F117:F125)","v":0},0,0,0,0,null,{"$f":"SUM(L117:L125)","v":0}]
[{"$f":"A110","v":2},{"$f":"B110","v":2},"Итого за день:",null,null,{"$f":"F116+F126","v":600},16.077,16.369999999999997,63.869,481.30000000000007,null,{"$f":"L116+L126","v":77.76}]
[2,3,"Завтрак","гор.блюдо","Котлета из мяса птицы с макаронными изделиями отварными, с маслом сливочным",230,11.45,12.46,31.32,289.95,"ТТК"]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,1.58,3.544,7.597999999999999,78.60000000000001,"№382"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75,"табл №6"]
[{"$nulls":3},"закуска","Салат из зеленого горошка к/с",60,1.09,1.31,16.95,60.16,"ТТК"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F132)","v":515},{"$f":"SUM(G128:G132)","v":16.02},{"$f":"SUM(H128:H132)","v":17.514},{"$f":"SUM(I128:I132)","v":68.168},{"$f":"SUM(J128:J132)","v":487.46000000000004},null,77.76]
[{"$f":"A128","v":2},{"$f":"B128","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо",{"$nulls":3}," "]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F134:F142)","v":0},0,0,0,0,null,{"$f":"SUM(L134:L142)","v":0}]
[{"$f":"A128","v":2},{"$f":"B128","v":3},"Итого за день:",null,null,{"$f":"F133+F143","v":515},16.02,17.514,68.168,487.46000000000004,null,{"$f":"L133+L143","v":77.76}]
[2,4,"Завтрак","гор.блюдо","Плов из говядины с рисовой крупой",200,15.945833333333336,19.55,39.745,408.4166666666667,"№265"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.07,0.02,10.01,40,"№376"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,1.9,0.2,12.3,58.75,"табл №6"]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (яблоки)",100,0.4,0.4,9.8,47,"табл №9"]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24000000000000002,7.920000000000002,39.60000000000001,"табл №6"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F145:F150)","v":545},{"$f":"SUM(G145:G150)","v":19.635833333333334},{"$f":"SUM(H145:H150)","v":20.409999999999997},{"$f":"SUM(I145:I150)","v":79.77499999999999},{"$f":"SUM(J145:J150)","v":593.7666666666668},null,77.76]
[{"$f":"A145","v":2},{"$f":"B145","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F152:F160)","v":0},0,0,0,0,null,{"$f":"SUM(L152:L160)","v":0}]
[{"$f":"A145","v":2},{"$f":"B145","v":4},"Итого за день:",null,null,{"$f":"F151+F161","v":545},19.635833333333334,20.409999999999997,79.77499999999999,593.7666666666668,null,{"$f":"L151+L161","v":77.76}]
[2,5,"Завтрак","гор.блюдо","Биточки рыбные с картофельным пюре,  с маслом сливочным",228,12.238499999999997,12.49,31.491,290.55,"ТТК"]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок (75С)",200,0.16000000000000003,0.16000000000000003,17.900000000000002,74.60000000000001,"№342"]
[{"$nulls":3},"хлеб","Хлеб ржаной",20,1.32,0.24,7.92,39.6,"табл №6"]
[{"$nulls":3},"закуска","Салат из отварной свеклы с сыром",60,1.84,3.7,9.78,78.42,"ТТК",77.76]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F163:F167)","v":508},{"$f":"SUM(G163:G167)","v":15.558499999999997},{"$f":"SUM(H163:H167)","v":16.59},{"$f":"SUM(I163:I167)","v":67.09100000000001},{"$f":"SUM(J163:J167)","v":483.1700000000001},null,{"$f":"SUM(L163:L167)","v":77.76}]
[{"$f":"A163","v":2},{"$f":"B163","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F169:F177)","v":0},0,0,0,0,null,{"$f":"SUM(L169:L177)","v":0}]
[{"$f":"A163","v":2},{"$f":"B163","v":5},"Итого за день:",null,null,{"$f":"F168+F178","v":508},15.558499999999997,16.59,67.09100000000001,483.1700000000001,null,{"$f":"L168+L178","v":77.76}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F41+F59+F75+F92+F109+F127+F144+F162+F179)/(IF(F23=0,0,1)+IF(F41=0,0,1)+IF(F59=0,0,1)+IF(F75=0,0,1)+IF(F92=0,0,1)+IF(F109=0,0,1)+IF(F127=0,0,1)+IF(F144=0,0,1)+IF(F162=0,0,1)+IF(F179=0,0,1))","v":531.6},{"$f":"(G23+G41+G59+G75+G92+G109+G127+G144+G162+G179)/(IF(G23=0,0,1)+IF(G41=0,0,1)+IF(G59=0,0,1)+IF(G75=0,0,1)+IF(G92=0,0,1)+IF(G109=0,0,1)+IF(G127=0,0,1)+IF(G144=0,0,1)+IF(G162=0,0,1)+IF(G179=0,0,1))","v":17.694283333333335},{"$f":"(H23+H41+H59+H75+H92+H109+H127+H144+H162+H179)/(IF(H23=0,0,1)+IF(H41=0,0,1)+IF(H59=0,0,1)+IF(H75=0,0,1)+IF(H92=0,0,1)+IF(H109=0,0,1)+IF(H127=0,0,1)+IF(H144=0,0,1)+IF(H162=0,0,1)+IF(H179=0,0,1))","v":18.155350000000002},{"$f":"(I23+I41+I59+I75+I92+I109+I127+I144+I162+I179)/(IF(I23=0,0,1)+IF(I41=0,0,1)+IF(I59=0,0,1)+IF(I75=0,0,1)+IF(I92=0,0,1)+IF(I109=0,0,1)+IF(I127=0,0,1)+IF(I144=0,0,1)+IF(I162=0,0,1)+IF(I179=0,0,1))","v":73.4259},{"$f":"(J23+J41+J59+J75+J92+J109+J127+J144+J162+J179)/(IF(J23=0,0,1)+IF(J41=0,0,1)+IF(J59=0,0,1)+IF(J75=0,0,1)+IF(J92=0,0,1)+IF(J109=0,0,1)+IF(J127=0,0,1)+IF(J144=0,0,1)+IF(J162=0,0,1)+IF(J179=0,0,1))","v":534.805},null,{"$f":"(L23+L41+L59+L75+L92+L109+L127+L144+L162+L179)/(IF(L23=0,0,1)+IF(L41=0,0,1)+IF(L59=0,0,1)+IF(L75=0,0,1)+IF(L92=0,0,1)+IF(L109=0,0,1)+IF(L127=0,0,1)+IF(L144=0,0,1)+IF(L162=0,0,1)+IF(L179=0,0,1))","v":77.76}]