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

{"sheet":"Лист1","index":0,"n_rows":194,"n_cols":12,"rows_kept":194,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[41,2,41,3],[60,2,60,3],[79,2,79,3],[98,2,98,3],[117,2,117,3],[136,2,136,3],[155,2,155,3],[174,2,174,3],[192,2,192,3],[193,2,193,4]]}
["Школа",null,"МБОУ г.Астрахани \"СОШ № 33 им. Н.А. Мордовиной\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Зубков А.Н."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",30,8,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша вязкая молочная из пшена с маслом сливочным",240,9.48,12.09,{"v":55.8,"d":"55.80"},{"v":384,"d":"384.00"},173,{"v":36.1,"d":"36.10"}]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",200,8.89,6.96,23.95,{"v":197.2,"d":"197.20"},"н/15",5.86]
[{"$nulls":3},"хлеб","Хлеб пшеничный с Российским сыром",70,0.13,0.02,15.21,{"v":62,"d":"62.00"},377,26.58]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":510},{"$f":"SUM(G6:G11)","v":18.5},{"$f":"SUM(H6:H11)","v":19.07},{"$f":"SUM(I6:I11)","v":94.96000000000001},{"$f":"SUM(J6:J11)","v":643.2},null,{"$f":"SUM(L6:L11)","v":68.53999999999999}]
[{"$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},{"$f":"SUM(G13:G21)","v":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":510},{"$f":"G12+G22","v":18.5},19.07,94.96000000000001,643.2,null,{"$f":"L12+L22","v":68.53999999999999}]
[1,2,"Завтрак","гор.блюдо","Тефтели  мясные с томатным соусом",100,{"v":12,"d":"12.00"},17.62,10.41,{"v":172,"d":"172.00"},540.416,29.97]
[{"$nulls":3},"гор.блюдо","Каша рассыпчатая гречневая с маслом сливочным",150,6.45,4.56,28.98,182.82,302,12.87]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.13,0.07,13.64,{"v":50.9,"d":"50.90"},377,4.05]
[{"$nulls":3},"хлеб","Хлеб пшеничный ",50,3.79,0.47,23.95,{"v":118,"d":"118.00"},"н",2.65]
[{"$nulls":3},"фрукты","Яблоки свежие",100,{"v":0.6,"d":"0.60"},{"v":0.6,"d":"0.60"},{"v":14.7,"d":"14.70"},{"v":70.5,"d":"70.50"},"н",{"v":19,"d":"19.00"}]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F24:F30)","v":600},{"$f":"SUM(G24:G30)","v":22.97},{"$f":"SUM(H24:H30)","v":23.32},{"$f":"SUM(I24:I30)","v":91.68},{"$f":"SUM(J24:J30)","v":594.22},null,68.53999999999999]
[{"$f":"A24","v":1},{"$f":"B24","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":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":600},{"$f":"G31+G41","v":22.97},{"$f":"H31+H41","v":23.32},{"$f":"I31+I41","v":91.68},{"$f":"J31+J41","v":594.22},null,68.53999999999999]
[1,3,"Завтрак","гор.блюдо","Каша  молочная из манной крупы (с маслом и сахаром)",240,6.68,11.68,{"v":46.2,"d":"46.20"},{"v":357,"d":"357.00"},181,37.91]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.13,0.07,13.64,{"v":50.9,"d":"50.90"},627,4.05]
[{"$nulls":3},"хлеб","Хлеб пшеничный с Российским сыром",70,8.89,6.96,23.95,{"v":197.2,"d":"197.20"},"н/15",26.58]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F43:F49)","v":510},{"$f":"SUM(G43:G49)","v":15.7},{"$f":"SUM(H43:H49)","v":18.71},{"$f":"SUM(I43:I49)","v":83.79},{"$f":"SUM(J43:J49)","v":605.0999999999999},null,68.53999999999999]
[{"$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(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,0]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F50+F60","v":510},{"$f":"G50+G60","v":15.7},{"$f":"H50+H60","v":18.71},{"$f":"I50+I60","v":83.79},{"$f":"J50+J60","v":605.0999999999999},null,68.53999999999999]
[1,4,"Завтрак","гор.блюдо","Запеканка из творога (с молоком сгущенным)",150,21.92,16.59,{"v":42,"d":"42.00"},{"v":406,"d":"406.00"},223,43.84]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.13,0.07,13.64,{"v":50.9,"d":"50.90"},627,4.05]
[{"$nulls":3},"хлеб","хлеб пшеничный ",50,3.79,0.47,23.95,{"v":118,"d":"118.00"},"н",2.65]
[{"$nulls":3},"фрукты","Яблоко свежее",100,{"v":0.6,"d":"0.60"},{"v":0.6,"d":"0.60"},{"v":14.7,"d":"14.70"},{"v":70.5,"d":"70.50"},"н",{"v":18,"d":"18.00"}]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F68)","v":500},{"$f":"SUM(G62:G68)","v":26.44},{"$f":"SUM(H62:H68)","v":17.73},{"$f":"SUM(I62:I68)","v":94.29},{"$f":"SUM(J62:J68)","v":645.4},null,68.53999999999999]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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,0]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Итого за день:",null,null,{"$f":"F69+F79","v":500},{"$f":"G69+G79","v":26.44},{"$f":"H69+H79","v":17.73},{"$f":"I69+I79","v":94.29},{"$f":"J69+J79","v":645.4},null,68.53999999999999]
[1,5,"Завтрак","гор.блюдо","Плов из филе курицы",200,15.84,20.64,27.18,357.58,291,52.79]
[{"$nulls":3},"закуска","Овощи натуральные свежие/соленые помидоры",60,0.66,0.12,2.28,{"v":13.2,"d":"13.20"},"71/70",5.65]
[{"$nulls":3},"гор.напиток","Чай с сахаром,лимоном",200,0.13,0.02,15.21,{"v":62,"d":"62.00"},627,5.86]
[{"$nulls":3},"хлеб","Хлеб пшеничный 1-ый сорт",80,6.06,0.75,38.32,{"v":188.8,"d":"188.80"},"н",4.24]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F81:F87)","v":540},{"$f":"SUM(G81:G87)","v":22.689999999999998},{"$f":"SUM(H81:H87)","v":21.53},{"$f":"SUM(I81:I87)","v":82.99000000000001},{"$f":"SUM(J81:J87)","v":621.5799999999999},null,68.53999999999999]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F89:F97)","v":0},{"$f":"SUM(G89:G97)","v":0},{"$f":"SUM(H89:H97)","v":0},{"$f":"SUM(I89:I97)","v":0},{"$f":"SUM(J89:J97)","v":0},null,0]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F88+F98","v":540},{"$f":"G88+G98","v":22.689999999999998},{"$f":"H88+H98","v":21.53},{"$f":"I88+I98","v":82.99000000000001},{"$f":"J88+J98","v":621.5799999999999},null,68.53999999999999]
[2,1,"Завтрак","гор.блюдо","Каша вязкая молочная из риса и пшена \"Дружба\"",240,6.62,{"v":12.2,"d":"12.20"},{"v":47.4,"d":"47.40"},{"v":341,"d":"341.00"},175,{"v":36.1,"d":"36.10"}]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",200,0.13,0.02,15.21,{"v":62,"d":"62.00"},377,5.86]
[{"$nulls":3},"хлеб","Хлеб пшеничный с сыром",70,8.89,6.96,23.95,{"v":197.2,"d":"197.20"},"н/15",26.58]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F100:F106)","v":510},{"$f":"SUM(G100:G106)","v":15.64},19.18,86.56,600.2,null,{"$f":"SUM(L100:L106)","v":68.53999999999999}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F108:F116)","v":0},{"$f":"SUM(G108:G116)","v":0},0,0,0,null,{"$f":"SUM(L108:L116)","v":0}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Итого за день:",null,null,{"$f":"F107+F117","v":510},{"$f":"G107+G117","v":15.64},{"$f":"H107+H117","v":19.18},{"$f":"I107+I117","v":86.56},{"$f":"J107+J117","v":600.2},null,68.53999999999999]
[2,2,"Завтрак","гор.блюдо","Макаронные изделия отварные",{"v":150,"d":"150.00"},4.74,4.56,28.82,175.03,202,{"v":8.9,"d":"8.90"}]
[{"$nulls":3},"гор.блюдо","Фарш мясной с овощами",{"v":130,"d":"130.00"},8.25,{"v":12.1,"d":"12.10"},7.16,{"v":172,"d":"172.00"},272,48.01]
[{"$nulls":3},"закуска","Овощи натуральные свежие/соленые помидоры",60,0.66,0.12,2.28,{"v":13.2,"d":"13.20"},"71/70",4.93]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.13,0.07,13.64,{"v":50.9,"d":"50.90"},377,4.05]
[{"$nulls":3},"хлеб","Хлеб пшеничный ",50,3.79,0.47,23.95,{"v":118,"d":"118.00"},"н",2.65]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F119:F125)","v":590},{"$f":"SUM(G119:G125)","v":17.57},17.32,75.85000000000001,529.1299999999999,null,{"$f":"SUM(L119:L125)","v":68.54}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F127:F135)","v":0},{"$f":"SUM(G127:G135)","v":0},0,0,0,null,{"$f":"SUM(L127:L135)","v":0}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Итого за день:",null,null,{"$f":"F126+F136","v":590},{"$f":"G126+G136","v":17.57},{"$f":"H126+H136","v":17.32},{"$f":"I126+I136","v":75.85000000000001},{"$f":"J126+J136","v":529.1299999999999},null,68.54]
[2,3,"Завтрак","гор.блюдо","Омлет натуральный",150,13.99,18.83,2.74,236.63,210,35.65]
[{"$nulls":3},"хлеб","Хлеб пшеничный с маслом сливочным",60,3.79,7.72,24.08,{"v":184,"d":"184.00"},"н/14",10.84]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9.8,"d":"9.80"},{"v":47,"d":"47.00"},627,4.05]
[{"$nulls":3},"фрукты","Яблоко свежее",100,0.13,0.07,13.64,{"v":50.9,"d":"50.90"},"н",{"v":18,"d":"18.00"}]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F138:F144)","v":510},{"$f":"SUM(G138:G144)","v":18.31},27.019999999999996,50.260000000000005,518.53,null,{"$f":"SUM(L138:L144)","v":68.53999999999999}]
[{"$f":"A138","v":2},{"$f":"B138","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F146:F154)","v":0},{"$f":"SUM(G146:G154)","v":0},0,0,0,null,{"$f":"SUM(L146:L154)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":3},"Итого за день:",null,null,{"$f":"F145+F155","v":510},{"$f":"G145+G155","v":18.31},{"$f":"H145+H155","v":27.019999999999996},{"$f":"I145+I155","v":50.260000000000005},{"$f":"J145+J155","v":518.53},null,68.53999999999999]
[2,4,"Завтрак","гор.блюдо","Каша вязкая молочная из риса (с маслом и сахаром)",240,6.55,11.85,46.86,{"v":320.7,"d":"320.70"},174,37.91]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.13,0.07,13.64,{"v":50.9,"d":"50.90"},377,4.05]
[{"$nulls":3},"хлеб","Хлеб пшеничный с сыром",70,8.89,6.96,23.95,{"v":197.2,"d":"197.20"},"н/15",26.58]
[]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F157:F163)","v":510},{"$f":"SUM(G157:G163)","v":15.57},18.88,84.45,568.8,null,{"$f":"SUM(L157:L163)","v":68.53999999999999}]
[{"$f":"A157","v":2},{"$f":"B157","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F173)","v":0},{"$f":"SUM(G165:G173)","v":0},0,0,0,null,{"$f":"SUM(L165:L173)","v":0}]
[{"$f":"A157","v":2},{"$f":"B157","v":4},"Итого за день:",null,null,{"$f":"F164+F174","v":510},{"$f":"G164+G174","v":15.57},{"$f":"H164+H174","v":18.88},{"$f":"I164+I174","v":84.45},{"$f":"J164+J174","v":568.8},null,68.53999999999999]
[2,5,"Завтрак","гор.блюдо","Макароны отварные  с сыром Российским",230,10.11,5.34,{"v":30.7,"d":"30.70"},{"v":386,"d":"386.00"},161,30.78]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",200,0.13,0.02,15.21,{"v":62,"d":"62.00"},377,5.86]
[{"$nulls":3},"сладкое","Кондитерское изделие",50,1.15,4.49,{"v":54,"d":"54.00"},{"v":200,"d":"200.00"},"н",29.25]
[{"$nulls":3},"хлеб","Хлеб пшеничный",50,3.79,0.47,23.95,{"v":118,"d":"118.00"},"н",2.65]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F176:F181)","v":530},{"$f":"SUM(G176:G181)","v":15.18},{"$f":"SUM(H176:H181)","v":10.32},{"$f":"SUM(I176:I181)","v":123.86},{"$f":"SUM(J176:J181)","v":766},null,{"$f":"SUM(L176:L181)","v":68.54}]
[{"$f":"A176","v":2},{"$f":"B176","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F183:F191)","v":0},{"$f":"SUM(G183:G191)","v":0},0,0,0,null,{"$f":"SUM(L183:L191)","v":0}]
[{"$f":"A176","v":2},{"$f":"B176","v":5},"Итого за день:",null,null,{"$f":"F182+F192","v":530},{"$f":"G182+G192","v":15.18},{"$f":"H182+H192","v":10.32},{"$f":"I182+I192","v":123.86},{"$f":"J182+J192","v":766},null,68.54]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F80+F99+F118+F137+F156+F175+F193)/(IF(F23=0,0,1)+IF(F42=0,0,1)+IF(F61=0,0,1)+IF(F80=0,0,1)+IF(F99=0,0,1)+IF(F118=0,0,1)+IF(F137=0,0,1)+IF(F156=0,0,1)+IF(F175=0,0,1)+IF(F193=0,0,1))","v":531},{"$f":"(G23+G42+G61+G80+G99+G118+G137+G156+G175+G193)/(IF(G23=0,0,1)+IF(G42=0,0,1)+IF(G61=0,0,1)+IF(G80=0,0,1)+IF(G99=0,0,1)+IF(G118=0,0,1)+IF(G137=0,0,1)+IF(G156=0,0,1)+IF(G175=0,0,1)+IF(G193=0,0,1))","v":18.857},{"$f":"(H23+H42+H61+H80+H99+H118+H137+H156+H175+H193)/(IF(H23=0,0,1)+IF(H42=0,0,1)+IF(H61=0,0,1)+IF(H80=0,0,1)+IF(H99=0,0,1)+IF(H118=0,0,1)+IF(H137=0,0,1)+IF(H156=0,0,1)+IF(H175=0,0,1)+IF(H193=0,0,1))","v":19.308},{"$f":"(I23+I42+I61+I80+I99+I118+I137+I156+I175+I193)/(IF(I23=0,0,1)+IF(I42=0,0,1)+IF(I61=0,0,1)+IF(I80=0,0,1)+IF(I99=0,0,1)+IF(I118=0,0,1)+IF(I137=0,0,1)+IF(I156=0,0,1)+IF(I175=0,0,1)+IF(I193=0,0,1))","v":86.869},{"$f":"(J23+J42+J61+J80+J99+J118+J137+J156+J175+J193)/(IF(J23=0,0,1)+IF(J42=0,0,1)+IF(J61=0,0,1)+IF(J80=0,0,1)+IF(J99=0,0,1)+IF(J118=0,0,1)+IF(J137=0,0,1)+IF(J156=0,0,1)+IF(J175=0,0,1)+IF(J193=0,0,1))","v":609.216},null,{"$f":"(L23+L42+L61+L80+L99+L118+L137+L156+L175+L193)/(IF(L23=0,0,1)+IF(L42=0,0,1)+IF(L61=0,0,1)+IF(L80=0,0,1)+IF(L99=0,0,1)+IF(L118=0,0,1)+IF(L137=0,0,1)+IF(L156=0,0,1)+IF(L175=0,0,1)+IF(L193=0,0,1))","v":68.53999999999999}]