{"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":195,"n_cols":12,"rows_kept":195,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[61,2,61,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],[193,2,193,3],[194,2,194,4]]}
["Школа",null,"МБОУ \"Заозерненская средняя школа\" город Евпатория",null,null,"Согласовал:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Ляшкова Г.Н."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша овсяная жидкая молочная с маслом",220,6,4,41,318,182,85.55]
[null,null,null,"гор.напиток","Чай с лимоном",207,1,0,10,42,377]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,10,28.7,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42.3,"Пр  "]
[null,null,null,"кисломол.","Масло сливочное",10,0,4,0,33,14]
[null,null,null,"кисломол.","Сыр твердый",20,2,3,0,35.8,15]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":512},{"$f":"SUM(G6:G12)","v":12.5},11.1,76,499.8,null,{"$f":"SUM(L6:L12)","v":85.55}]
[{"$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},0,0,0,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":512},{"$f":"G13+G23","v":12.5},11.1,76,499.8,null,{"$f":"L13+L23","v":85.55}]
[1,2,"Завтрак","2 блюдо","Омлет натуральный",100,21,15,6.08,206,210,{"$f":"SUM(L18:L24)","v":85.55}]
[null,null,null,"гор.напиток","Кофейный напиток с молоком",180,3,3,16,101,379]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,10,28.7,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"кисломол.","Йогурт",120,5,6,17,206,386]
[null,null,null,"кисломол.","Масло сливочное",10,0,4,0,33,14]
[null,null,null,"закуска","Капуста тушеная",70,0.5,0.1,1.9,11,139]
[null,null,null,"итого",null,{"$f":"SUM(F25:F31)","v":535},{"$f":"SUM(G25:G31)","v":33},{"$f":"SUM(H25:H31)","v":28.2},{"$f":"SUM(I25:I31)","v":65.98},{"$f":"SUM(J25:J31)","v":627.7},null,85.55]
[{"$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(F33:F41)","v":0},{"$f":"SUM(G33:G41)","v":0},{"$f":"SUM(H33:H41)","v":0},{"$f":"SUM(I33:I41)","v":0},{"$f":"SUM(J33:J41)","v":0},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":535},{"$f":"G32+G42","v":33},{"$f":"H32+H42","v":28.2},{"$f":"I32+I42","v":65.98},{"$f":"J32+J42","v":627.7},null,85.55]
[1,3,"Завтрак","гор.блюдо","Запеканка из творога со сгущ. молоком",160,9,7,27,221,223,{"$f":"SUM(L37:L43)","v":85.55}]
[null,null,null,"гор.напиток","Какао с молоком",200,5,6,7,106,282]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,10,29,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"фрукты","Фрукты свежие",100,1,0,14,65,338]
[null,null,null,"кисломол.","Масло сливочное",10,0,4,0,33,14]
[]
[null,null,null,"итого",null,{"$f":"SUM(F44:F50)","v":525},{"$f":"SUM(G44:G50)","v":18.5},{"$f":"SUM(H44:H50)","v":17.1},{"$f":"SUM(I44:I50)","v":73},{"$f":"SUM(J44:J50)","v":496},null,85.55]
[{"$f":"A44","v":1},{"$f":"B44","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(F52:F60)","v":0},{"$f":"SUM(G52:G60)","v":0},{"$f":"SUM(H52:H60)","v":0},{"$f":"SUM(I52:I60)","v":0},{"$f":"SUM(J52:J60)","v":0},null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":525},{"$f":"G51+G61","v":18.5},{"$f":"H51+H61","v":17.1},{"$f":"I51+I61","v":73},{"$f":"J51+J61","v":496},null,85.55]
[1,4,"Завтрак","гор.блюдо","Каша молочная жидкая гречневая с маслом",205,6,4,41,318,173,{"$f":"SUM(L56:L62)","v":85.55}]
[null,null,null,"гор.напиток","Чай с лимоном",187,1,0,10,42,377]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"хлеб","Горячий бутерброд с сыром",25,3,2,7,78,7]
[null,null,null,"фрукты","Фрукты свежие ",120,1,0,14,65,338]
[]
[null,null,null,"итого",null,{"$f":"SUM(F63:F68)","v":557},{"$f":"SUM(G63:G68)","v":13},{"$f":"SUM(H63:H68)","v":6},{"$f":"SUM(I63:I68)","v":87},{"$f":"SUM(J63:J68)","v":545},null,{"$f":"SUM(L63:L68)","v":85.55}]
[{"$f":"A63","v":1},{"$f":"B63","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,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F69+F79","v":557},{"$f":"G69+G79","v":13},{"$f":"H69+H79","v":6},{"$f":"I69+I79","v":87},{"$f":"J69+J79","v":545},null,85.55]
[1,5,"Завтрак","2 блюдо","Печень тушеная в соусе",90,9,11,10,145.5,261,{"$f":"SUM(L74:L80)","v":85.55}]
[null,null,null,"гор.напиток","Кофейный напиток ",180,3,3,16,101,379]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,10,28,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"закуска","Огурец консервированный",70,1,0,1.9,11,70]
[null,null,null,"кисломол.","Масло сливочное",10,0,4,0,33,14]
[null,null,null,"гарнир","Рагу овощное",150,2,7,15,136,143]
[null,null,null,"итого",null,{"$f":"SUM(F81:F87)","v":555},{"$f":"SUM(G81:G87)","v":18.5},{"$f":"SUM(H81:H87)","v":25.1},{"$f":"SUM(I81:I87)","v":67.9},{"$f":"SUM(J81:J87)","v":496.5},null,85.55]
[{"$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(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":555},{"$f":"G88+G98","v":18.5},{"$f":"H88+H98","v":25.1},{"$f":"I88+I98","v":67.9},{"$f":"J88+J98","v":496.5},null,85.55]
[2,1,"Завтрак","2 блюдо","Омлет с морковью",110,11,15,4,244,214,{"$f":"SUM(L93:L99)","v":85.55}]
[null,null,null,"гор.напиток","Какао с молоком",180,4,0.67,26,125,382]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,10,29,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"закуска","Капуста припущення с маслом",70,1,0,2,11,101]
[null,null,null,"кисломол.","Масло сливочное",10,0,4,0,33,14]
[null,null,null,"2 блюдо","Фрикадельки мясные с соусом",90,7,17,18,226,280]
[null,null,null,"итого",null,{"$f":"SUM(F100:F106)","v":515},{"$f":"SUM(G100:G106)","v":26.5},36.77,75,710,null,{"$f":"SUM(L100:L106)","v":85.55}]
[{"$f":"A100","v":2},{"$f":"B100","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(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":515},{"$f":"G107+G117","v":26.5},{"$f":"H107+H117","v":36.77},{"$f":"I107+I117","v":75},{"$f":"J107+J117","v":710},null,85.55]
[2,2,"Завтрак","гор.блюдо","Каша молочная жидкая пшеничная с маслом",220,6,11,43,294,182,{"$f":"SUM(L112:L118)","v":85.55}]
[null,null,null,"гор.напиток","Чай с лимоном",207,0.53,0,10,42,377]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,9.6,28.7,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0.3,15,42.3,"Пр  "]
[null,null,null,"кисломол.","Сыр твердый",15,2,3,0,36,15]
[null,null,null,"кисломол.","Масло сливочное  ",10,0.05,3.6,0.6,32.8,14]
[]
[null,null,null,"итого",null,{"$f":"SUM(F119:F125)","v":507},{"$f":"SUM(G119:G125)","v":12.08},18,78.2,475.8,null,{"$f":"SUM(L119:L125)","v":85.55}]
[{"$f":"A119","v":2},{"$f":"B119","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(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":507},{"$f":"G126+G136","v":12.08},{"$f":"H126+H136","v":18},{"$f":"I126+I136","v":78.2},{"$f":"J126+J136","v":475.8},null,85.55]
[2,3,"Завтрак","гор.блюдо","Пудинг из творога со сгущенным молоком",160,21.6,17.8,34.2,286,222,{"$f":"SUM(L131:L137)","v":85.55}]
[null,null,null,"гор.напиток","Чай с лимоном",187,0.53,null,9.8,42,377]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,9.6,28.7,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"фрукты","фрукты свежие",100,1.8,0,25.2,115.2,338]
[null,null,null,"кисломол.","Масло сливочное  ",10,0.05,3.6,0.6,32.8,14]
[]
[null,null,null,"итого",null,{"$f":"SUM(F138:F144)","v":512},{"$f":"SUM(G138:G144)","v":27.48},21.5,94.4,546.7,null,{"$f":"SUM(L138:L144)","v":85.55}]
[{"$f":"A138","v":2},{"$f":"B138","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(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":512},{"$f":"G145+G155","v":27.48},{"$f":"H145+H155","v":21.5},{"$f":"I145+I155","v":94.4},{"$f":"J145+J155","v":546.7},null,85.55]
[2,4,"Завтрак","2 блюдо","Суфле из кур",90,11,8.3,7.3,244,300,{"$f":"SUM(L150:L156)","v":85.55}]
[null,null,null,"гор.напиток","Кофейный напиток с молоком",180,3.6,3,26,125,378]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,9.6,28.7,"Пр  "]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"закуска","Икра морковная",70,1,0,2,11,75]
[null,null,null,"гарнир","Макароны  с маслом",150,4,8,17.7,95,128]
[null,null,null,"кисломол.","Масло сливочное  ",10,0.05,3.6,0.6,32.8,14]
[null,null,null,"итого",null,555,{"$f":"SUM(G157:G163)","v":23.15},23,78.2,578.5,null,{"$f":"SUM(L157:L163)","v":85.55}]
[{"$f":"A157","v":2},{"$f":"B157","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(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":555},{"$f":"G164+G174","v":23.15},{"$f":"H164+H174","v":23},{"$f":"I164+I174","v":78.2},{"$f":"J164+J174","v":578.5},null,85.55]
[2,5,"Завтрак","2 блюдо","Пудинг мясной",90,22,8.7,1,238.5,283,85.55]
[null,null,null,"гор.напиток","Чай с лимоном",187,1,0,10,42,377]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",35,1.5,0.1,9.6,28.7,"Пр  "]
[null,null,null,"фрукты","Фрукты свежие ",100,1,null,25,115,338]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,2,0,15,42,"Пр  "]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150,3,6,12,115.5,139]
[]
[null,null,null,"итого",null,{"$f":"SUM(F176:F182)","v":582},{"$f":"SUM(G176:G182)","v":30.5},14.8,72.6,581.7,null,{"$f":"SUM(L176:L182)","v":85.55}]
[{"$f":"A176","v":2},{"$f":"B176","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(F184:F192)","v":0},{"$f":"SUM(G184:G192)","v":0},0,0,0,null,{"$f":"SUM(L184:L192)","v":0}]
[{"$f":"A176","v":2},{"$f":"B176","v":5},"Итого за день:",null,null,{"$f":"F183+F193","v":582},{"$f":"G183+G193","v":30.5},{"$f":"H183+H193","v":14.8},{"$f":"I183+I193","v":72.6},{"$f":"J183+J193","v":581.7},null,85.55]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F80+F99+F118+F137+F156+F175+F194)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=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(F194=0,0,1))","v":535.5},{"$f":"(G24+G43+G62+G80+G99+G118+G137+G156+G175+G194)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=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(G194=0,0,1))","v":21.521},20.157,76.828,555.77,null,{"$f":"(L24+L43+L62+L80+L99+L118+L137+L156+L175+L194)/(IF(L24=0,0,1)+IF(L43=0,0,1)+IF(L62=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(L194=0,0,1))","v":85.55}]