{"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":194,"n_cols":12,"rows_kept":194,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[173,2,173,3],[193,2,193,4],[41,2,41,3],[192,2,192,3],[60,2,60,3],[79,2,79,3],[97,2,97,3],[116,2,116,3],[135,2,135,3],[154,2,154,3]]}
["Школа",null,"МБОУ \"Паньшинская СШ\"",null,null,"Утвердил:","должность","Директор ООО \"Славиа\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Озрокова Ю М"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",1,9,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Каша вязкая молочная рисовая",200,5.6,10.6,40.7,274,174]
[null,null,null,"гор.напиток","Чай с сахаром",215,0.1,0,17.3,59.3,376]
[null,null,null,"хлеб","Батон",40,4.8,1.2,20.5,104.8]
[null,null,null,"фрукты","Фрукты свежие (яблоко)",100,0.4,0.4,9.5,45.6,338,105.71]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F11)","v":555},{"$f":"SUM(G6:G11)","v":10.9},9,{"$f":"SUM(I6:I11)","v":88},{"$f":"SUM(J6:J11)","v":483.70000000000005},null,{"$f":"SUM(L6:L11)","v":105.71}]
[{"$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(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},{"$f":"SUM(H13:H21)","v":0},{"$f":"SUM(I13:I21)","v":0},{"$f":"SUM(J13:J21)","v":0},null,{"$f":"SUM(L16:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":555},{"$f":"G12+G22","v":10.9},{"$f":"H12+H22","v":9},{"$f":"I12+I22","v":88},{"$f":"J12+J22","v":483.70000000000005},null,{"$f":"L12+L22","v":105.71}]
[1,2,"Завтрак","гор.блюдо","Котлета рубленая из птицы",90,14.6,18.7,13.6,223,294]
[null,null,null,"гор.блюдо","Макаронные изделия отварные",150,5.5,5.7,33.2,206.4,203]
[null,null,null,"гор.напиток","Чай с сахаром и лимоном",222,0.3,0,15.2,60,377]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,"ТТК №6",105.71]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F24:F30)","v":502},{"$f":"SUM(G24:G30)","v":23.400000000000002},{"$f":"SUM(H24:H30)","v":24.599999999999998},{"$f":"SUM(I24:I30)","v":81.5},{"$f":"SUM(J24:J30)","v":581.3},null,{"$f":"SUM(L25:L30)","v":105.71}]
[{"$f":"A24","v":1},{"$f":"B24","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":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":502},{"$f":"G31+G41","v":23.400000000000002},{"$f":"H31+H41","v":24.599999999999998},{"$f":"I31+I41","v":81.5},{"$f":"J31+J41","v":581.3},null,{"$f":"L31+L41","v":105.71}]
[1,3,"Завтрак","гор.блюдо","Тефтели с соусом 2-вариант",120,9.4,18.8,14.3,223.2,"462/593"]
[null,null,null,"гор.блюдо","Каша пшеничная вязкая",150,4.8,6.2,32,205,302]
[null,null,null,"гор.напиток","Чай с сахаром каркаде",215,0.2,0,15,60.5,685]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,"ТТК №6",105.71]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F43:F49)","v":525},{"$f":"SUM(G43:G49)","v":17.4},{"$f":"SUM(H43:H49)","v":25.2},{"$f":"SUM(I43:I49)","v":80.8},{"$f":"SUM(J43:J49)","v":580.6},null,{"$f":"SUM(L43:L49)","v":105.71}]
[{"$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":525},{"$f":"G50+G60","v":17.4},{"$f":"H50+H60","v":25.2},{"$f":"I50+I60","v":80.8},{"$f":"J50+J60","v":580.6},null,{"$f":"L50+L60","v":105.71}]
[1,4,"Завтрак","гор.блюдо","Плов из птицы",200,15.3,20.8,39.2,410.6,291]
[null,null,null,"закуска","Овощи по сезону (огурец свежий, помидор свежий, капуста квашеная, помидор соленый, огурец соленый, свекла отварная)",60,0.5,0.1,0.1,7.6,"ТТК № 1,2,3,4,5"]
[null,null,null,"гор.напиток","Чай с сахаром",215,0.1,0,17.3,59.3,376]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,"ТТК № 6",105.71]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F62:F68)","v":515},{"$f":"SUM(G62:G68)","v":18.9},{"$f":"SUM(H62:H68)","v":21.1},{"$f":"SUM(I62:I68)","v":76.10000000000001},{"$f":"SUM(J62:J68)","v":569.4000000000001},null,{"$f":"SUM(L62:L68)","v":105.71}]
[{"$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":515},{"$f":"G69+G79","v":18.9},{"$f":"H69+H79","v":21.1},{"$f":"I69+I79","v":76.10000000000001},{"$f":"J69+J79","v":569.4000000000001},null,{"$f":"L69+L79","v":105.71}]
[1,5,"Завтрак","гор.блюдо","Лапшевник с творогом соус молочный (сладкий)",260,18.3,14.2,45.8,374.4,208]
[null,null,null,"гор.блюдо"]
[null,null,null,"гор.напиток","Компот из смеси сухофруктов",200,0.4,0,30.8,116,349]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,"ТТК № 6",105.71]
[null,null,null,"фрукты"]
[]
[null,null,null,"итого",null,{"$f":"SUM(F81:F86)","v":500},{"$f":"SUM(G81:G86)","v":21.7},{"$f":"SUM(H81:H86)","v":14.399999999999999},{"$f":"SUM(I81:I86)","v":96.1},{"$f":"SUM(J81:J86)","v":582.3},null,{"$f":"SUM(L81:L86)","v":105.71}]
[{"$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(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,{"$f":"SUM(L88:L96)","v":0}]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F87+F97","v":500},{"$f":"G87+G97","v":21.7},{"$f":"H87+H97","v":14.399999999999999},{"$f":"I87+I97","v":96.1},{"$f":"J87+J97","v":582.3},null,{"$f":"L87+L97","v":105.71}]
[2,1,"Завтрак","гор.блюдо","Каша вязкая молочная из риса и пшена Дружба",200,5,10.1,30.5,260.8,175]
[]
[null,null,null,"гор.напиток","Чай с сахаром",215,0.1,0,17.3,59.3,376]
[null,null,null,"хлеб","Бутерброд с маслом и сыром",85,8.3,12.4,34.3,255,3,105.71]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F99:F105)","v":500},{"$f":"SUM(G99:G105)","v":13.4},{"$f":"SUM(H99:H105)","v":22.5},{"$f":"SUM(I99:I105)","v":82.1},{"$f":"SUM(J99:J105)","v":575.1},null,{"$f":"SUM(L99:L105)","v":105.71}]
[{"$f":"A99","v":2},{"$f":"B99","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(F107:F115)","v":0},{"$f":"SUM(G107:G115)","v":0},{"$f":"SUM(H107:H115)","v":0},{"$f":"SUM(I107:I115)","v":0},{"$f":"SUM(J107:J115)","v":0},null,{"$f":"SUM(L107:L115)","v":0}]
[{"$f":"A99","v":2},{"$f":"B99","v":1},"Итого за день:",null,null,{"$f":"F106+F116","v":500},{"$f":"G106+G116","v":13.4},{"$f":"H106+H116","v":22.5},{"$f":"I106+I116","v":82.1},{"$f":"J106+J116","v":575.1},null,{"$f":"L106+L116","v":105.71}]
[2,2,"Завтрак","гор.блюдо","Фрикадельки из птицы с соусом",120,16,12.8,8,191.4,"297/593"]
[null,null,null,"гор.блюдо","Макаронные изделия отварные",150,5.5,5.7,33.2,206.4,203]
[null,null,null,"гор.напиток","Чай с сахаром и лимоном",222,0.3,0,15.2,60,377]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,"ТТК №6",105.71]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F118:F124)","v":532},{"$f":"SUM(G118:G124)","v":24.8},{"$f":"SUM(H118:H124)","v":18.7},{"$f":"SUM(I118:I124)","v":75.9},{"$f":"SUM(J118:J124)","v":549.7},null,{"$f":"SUM(L118:L124)","v":105.71}]
[{"$f":"A118","v":2},{"$f":"B118","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(F126:F134)","v":0},{"$f":"SUM(G126:G134)","v":0},{"$f":"SUM(H126:H134)","v":0},{"$f":"SUM(I126:I134)","v":0},{"$f":"SUM(J126:J134)","v":0},null,{"$f":"SUM(L126:L134)","v":0}]
[{"$f":"A118","v":2},{"$f":"B118","v":2},"Итого за день:",null,null,{"$f":"F125+F135","v":532},{"$f":"G125+G135","v":24.8},{"$f":"H125+H135","v":18.7},{"$f":"I125+I135","v":75.9},{"$f":"J125+J135","v":549.7},null,{"$f":"L125+L135","v":105.71}]
[2,3,"Завтрак","гор.блюдо","Котлета рубленая из птицы Соус томатный",120,15.7,21.2,16.1,255,"294/593"]
[null,null,null,"гор.блюдо","Каша вязкая гречневая",150,6.1,4.8,27.8,178.2,302]
[null,null,null,"гор.напиток","Чай с сахаром каркаде",215,0.2,0,15,60.5,685]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,"ТТК №6",105.71]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F137:F143)","v":525},{"$f":"SUM(G137:G143)","v":24.999999999999996},{"$f":"SUM(H137:H143)","v":26.2},{"$f":"SUM(I137:I143)","v":78.4},{"$f":"SUM(J137:J143)","v":585.6},null,{"$f":"SUM(L137:L143)","v":105.71}]
[{"$f":"A137","v":2},{"$f":"B137","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(F145:F153)","v":0},{"$f":"SUM(G145:G153)","v":0},{"$f":"SUM(H145:H153)","v":0},{"$f":"SUM(I145:I153)","v":0},{"$f":"SUM(J145:J153)","v":0},null,{"$f":"SUM(L145:L153)","v":0}]
[{"$f":"A137","v":2},{"$f":"B137","v":3},"Итого за день:",null,null,{"$f":"F144+F154","v":525},{"$f":"G144+G154","v":24.999999999999996},{"$f":"H144+H154","v":26.2},{"$f":"I144+I154","v":78.4},{"$f":"J144+J154","v":585.6},null,{"$f":"L144+L154","v":105.71}]
[2,4,"Завтрак","гор.блюдо","Каша молочная манная жидкая",200,5.5,7.2,33.6,243,311]
[null,null,null,"гор.блюдо","Яйцо вареное вкрутую",45,5.1,4.6,0.3,63,337]
[null,null,null,"гор.напиток","Чай сахаром",215,0.1,0,17.3,59.3,376]
[null,null,null,"хлеб","Хлеб пшеничный",55,4.1,0.3,26.8,126.4,"ТТК №6",105.71]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F156:F162)","v":515},{"$f":"SUM(G156:G162)","v":14.799999999999999},{"$f":"SUM(H156:H162)","v":12.100000000000001},{"$f":"SUM(I156:I162)","v":78},{"$f":"SUM(J156:J162)","v":491.70000000000005},null,{"$f":"SUM(L156:L162)","v":105.71}]
[{"$f":"A156","v":2},{"$f":"B156","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(F164:F172)","v":0},{"$f":"SUM(G164:G172)","v":0},{"$f":"SUM(H164:H172)","v":0},{"$f":"SUM(I164:I172)","v":0},{"$f":"SUM(J164:J172)","v":0},null,{"$f":"SUM(L164:L172)","v":0}]
[{"$f":"A156","v":2},{"$f":"B156","v":4},"Итого за день:",null,null,{"$f":"F163+F173","v":515},{"$f":"G163+G173","v":14.799999999999999},{"$f":"H163+H173","v":12.100000000000001},{"$f":"I163+I173","v":78},{"$f":"J163+J173","v":491.70000000000005},null,{"$f":"L163+L173","v":105.71}]
[2,5,"Завтрак","гор.блюдо","Фрикадельки рыбные Соус томатный",120,13.4,12.9,12.3,158,"240/593"]
[null,null,null,"гор.блюдо","Картофельное пюре",150,3.9,8.9,39.8,232.5,128]
[null,null,null,"гор.напиток","Чай с сахаром и лимоном",222,0.3,0,14.8,60,377]
[null,null,null,"хлеб","Хлеб пшеничный ",40,3,0.2,19.5,91.9,null,105.71]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F175:F181)","v":532},{"$f":"SUM(G175:G181)","v":20.6},{"$f":"SUM(H175:H181)","v":22},{"$f":"SUM(I175:I181)","v":86.39999999999999},{"$f":"SUM(J175:J181)","v":542.4},null,{"$f":"SUM(L175:L181)","v":105.71}]
[{"$f":"A175","v":2},{"$f":"B175","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(F183:F191)","v":0},{"$f":"SUM(G183:G191)","v":0},{"$f":"SUM(H183:H191)","v":0},{"$f":"SUM(I183:I191)","v":0},{"$f":"SUM(J183:J191)","v":0},null,{"$f":"SUM(L183:L191)","v":0}]
[{"$f":"A175","v":2},{"$f":"B175","v":5},"Итого за день:",null,null,{"$f":"F182+F192","v":532},{"$f":"G182+G192","v":20.6},{"$f":"H182+H192","v":22},{"$f":"I182+I192","v":86.39999999999999},{"$f":"J182+J192","v":542.4},null,{"$f":"L182+L192","v":105.71}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F80+F98+F117+F136+F155+F174+F193)/(IF(F23=0, 0, 1)+IF(F42=0, 0, 1)+IF(F61=0, 0, 1)+IF(F80=0, 0, 1)+IF(F98=0, 0, 1)+IF(F117=0, 0, 1)+IF(F136=0, 0, 1)+IF(F155=0, 0, 1)+IF(F174=0, 0, 1)+IF(F193=0, 0, 1))","v":520.1},{"$f":"(G23+G42+G61+G80+G98+G117+G136+G155+G174+G193)/(IF(G23=0, 0, 1)+IF(G42=0, 0, 1)+IF(G61=0, 0, 1)+IF(G80=0, 0, 1)+IF(G98=0, 0, 1)+IF(G117=0, 0, 1)+IF(G136=0, 0, 1)+IF(G155=0, 0, 1)+IF(G174=0, 0, 1)+IF(G193=0, 0, 1))","v":19.09},{"$f":"(H23+H42+H61+H80+H98+H117+H136+H155+H174+H193)/(IF(H23=0, 0, 1)+IF(H42=0, 0, 1)+IF(H61=0, 0, 1)+IF(H80=0, 0, 1)+IF(H98=0, 0, 1)+IF(H117=0, 0, 1)+IF(H136=0, 0, 1)+IF(H155=0, 0, 1)+IF(H174=0, 0, 1)+IF(H193=0, 0, 1))","v":19.58},{"$f":"(I23+I42+I61+I80+I98+I117+I136+I155+I174+I193)/(IF(I23=0, 0, 1)+IF(I42=0, 0, 1)+IF(I61=0, 0, 1)+IF(I80=0, 0, 1)+IF(I98=0, 0, 1)+IF(I117=0, 0, 1)+IF(I136=0, 0, 1)+IF(I155=0, 0, 1)+IF(I174=0, 0, 1)+IF(I193=0, 0, 1))","v":82.33},{"$f":"(J23+J42+J61+J80+J98+J117+J136+J155+J174+J193)/(IF(J23=0, 0, 1)+IF(J42=0, 0, 1)+IF(J61=0, 0, 1)+IF(J80=0, 0, 1)+IF(J98=0, 0, 1)+IF(J117=0, 0, 1)+IF(J136=0, 0, 1)+IF(J155=0, 0, 1)+IF(J174=0, 0, 1)+IF(J193=0, 0, 1))","v":554.1800000000001},null,{"$f":"(L23+L42+L61+L80+L98+L117+L136+L155+L174+L193)/(IF(L23=0, 0, 1)+IF(L42=0, 0, 1)+IF(L61=0, 0, 1)+IF(L80=0, 0, 1)+IF(L98=0, 0, 1)+IF(L117=0, 0, 1)+IF(L136=0, 0, 1)+IF(L155=0, 0, 1)+IF(L174=0, 0, 1)+IF(L193=0, 0, 1))","v":105.71000000000001}]