{"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":191,"n_cols":12,"rows_kept":191,"cut":false,"hidden":false,"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],[78,2,78,3],[96,2,96,3],[114,2,114,3],[133,2,133,3],[152,2,152,3],[170,2,170,3],[189,2,189,3],[190,2,190,4]]}
["Школа",null,"МКОУ Лапшинская СШ",null,null,"Утвердил:","должность","директор ООО «СОЮЗ-К»"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Киселев Д.Г."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","каша молочная овсяная вязкая",200,7.13,9.2,34.4,210.2,302]
[null,null,null,"хлеб","хлеб пшеничный",50,3.95,0.5,21.15,116.33,6]
[null,null,null,"хлеб","бутерброд с маслом и сыром (35/5/10)",50,5.8,8,11.6,147,3]
[null,null,null,"гор.напиток","кофейный напиток с молоком",200,3.16,2.66,15.94,100.6,379,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F11)","v":500},{"$f":"SUM(G6:G11)","v":20.04},20.36,83.09,574.13,null,{"$f":"SUM(L6:L11)","v":136.37}]
[{"$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},0,0,0,null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":500},{"$f":"G12+G22","v":20.04},20.36,83.09,574.13,null,{"$f":"L12+L22","v":136.37}]
[1,2,"Завтрак","гор.блюдо","тефтели с рисом (говядина) с соусом томатным (90/30)",120,10.9,10.9,13.5,205.6,"307/363"]
[null,null,null,"гор.блюдо","каша гречневая вязкая ",150,3.99,4.5,17.72,125.9,303]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,58,685]
[null,null,null,"хлеб","хлеб ржано-пшеничный",50,3.13,0.5,20.63,99,7]
[null,null,null,"закуска","свекла отварная с раст.маслом (60/2)",62,0.9,0.1,5.1,24.4,2,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F24:F30)","v":582},{"$f":"SUM(G24:G30)","v":19.12},{"$f":"SUM(H24:H30)","v":16},{"$f":"SUM(I24:I30)","v":71.95},{"$f":"SUM(J24:J30)","v":512.9},null,136.37]
[{"$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,0]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":582},{"$f":"G31+G41","v":19.12},{"$f":"H31+H41","v":16},{"$f":"I31+I41","v":71.95},{"$f":"J31+J41","v":512.9},null,136.37]
[1,3,"Завтрак","гор.блюдо","плов из птицы",200,15.1,18,30.2,345.8,492]
[null,null,null,"гор.напиток","компот из сухофруктов",200,0.3,0,16,66.4,53]
[null,null,null,"хлеб","хлеб ржано-пшеничный",50,3.13,0.5,20.63,99,7]
[null,null,null,"закуска","овощи по сезону (помидор соленый или помидор свежий ) ",60,0.6,0,1.4,8,27,136.37]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F43:F49)","v":510},{"$f":"SUM(G43:G49)","v":19.13},{"$f":"SUM(H43:H49)","v":18.5},{"$f":"SUM(I43:I49)","v":68.23},{"$f":"SUM(J43:J49)","v":519.2},null,136.37]
[{"$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,0]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F50+F60","v":510},{"$f":"G50+G60","v":19.13},{"$f":"H50+H60","v":18.5},{"$f":"I50+I60","v":68.23},{"$f":"J50+J60","v":519.2},null,136.37]
[1,4,"Завтрак","гор.блюдо","котлеты рыбные в томатном соусе",90,11.6,11.8,13,159,106]
[null,null,null,"гор.блюдо","картофель отварной с маслом",160,3.04,4.5,24.55,151.4,310]
[null,null,null,"гор.напиток","чай с сахаром и лимоном",200,0.3,0,15.2,60,686]
[null,null,null,"хлеб","хлеб пшеничный",50,3.95,0.5,21.15,116.33,6,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F62:F67)","v":500},{"$f":"SUM(G62:G67)","v":18.89},{"$f":"SUM(H62:H67)","v":16.8},{"$f":"SUM(I62:I67)","v":73.9},{"$f":"SUM(J62:J67)","v":486.73},null,136.37]
[{"$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(F69:F77)","v":0},{"$f":"SUM(G69:G77)","v":0},{"$f":"SUM(H69:H77)","v":0},{"$f":"SUM(I69:I77)","v":0},{"$f":"SUM(J69:J77)","v":0},null,0]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Итого за день:",null,null,{"$f":"F68+F78","v":500},{"$f":"G68+G78","v":18.89},{"$f":"H68+H78","v":16.8},{"$f":"I68+I78","v":73.9},{"$f":"J68+J78","v":486.73},null,136.37]
[1,5,"Завтрак","гор.блюдо","каша молочная из риса и пшена \"Дружба\" с маслом",160,10.86,11.92,27.76,206,175]
[null,null,null,"гор.напиток","чай с сахаром",200,0.2,0,15,58,685]
[null,null,null,"хлеб","бутерброд с повидлом (30/20)",50,5,4.4,25.2,156,2]
[null,null,null,"фрукты","яблоко",120,0.6,0.6,14.3,68.4,338,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F80:F85)","v":530},{"$f":"SUM(G80:G85)","v":16.66},{"$f":"SUM(H80:H85)","v":16.92},{"$f":"SUM(I80:I85)","v":82.26},{"$f":"SUM(J80:J85)","v":488.4},null,136.37]
[{"$f":"A80","v":1},{"$f":"B80","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(F87:F95)","v":0},{"$f":"SUM(G87:G95)","v":0},{"$f":"SUM(H87:H95)","v":0},{"$f":"SUM(I87:I95)","v":0},{"$f":"SUM(J87:J95)","v":0},null,0]
[{"$f":"A80","v":1},{"$f":"B80","v":5},"Итого за день:",null,null,{"$f":"F86+F96","v":530},{"$f":"G86+G96","v":16.66},{"$f":"H86+H96","v":16.92},{"$f":"I86+I96","v":82.26},{"$f":"J86+J96","v":488.4},null,136.37]
[2,1,"Завтрак","гор.блюдо","каша молочная из манной крупы",160,7.2,8.7,33.81,211.64,181]
[null,null,null,"гор.напиток","кофейный напиток с молоком",200,3.16,2.66,15.94,100.6,379]
[null,null,null,"хлеб","бутерброд с маслом и сыром (35/5/10)",50,5.8,8,11.6,147,3]
[null,null,null,"фрукты","яблоко",120,0.6,0.6,14.3,68.4,338,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F98:F103)","v":530},{"$f":"SUM(G98:G103)","v":16.76},19.96,75.65,527.64,null,{"$f":"SUM(L98:L103)","v":136.37}]
[{"$f":"A98","v":2},{"$f":"B98","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(F105:F113)","v":0},{"$f":"SUM(G105:G113)","v":0},0,0,0,null,{"$f":"SUM(L105:L113)","v":0}]
[{"$f":"A98","v":2},{"$f":"B98","v":1},"Итого за день:",null,null,{"$f":"F104+F114","v":530},{"$f":"G104+G114","v":16.76},{"$f":"H104+H114","v":19.96},{"$f":"I104+I114","v":75.65},{"$f":"J104+J114","v":527.64},null,136.37]
[2,2,"Завтрак","гор.блюдо","котлета рубленая с белокочанной капустой (говядина) с соусом томатным 90/30",120,9,8.7,20.2,205.6,"455/363"]
[null,null,null,"гор.блюдо","каша гречневая вязкая",150,3.99,4.5,17.72,125.9,303]
[null,null,null,"гор.напиток","компот из сухофруктов",200,0.3,0,16,66.4,53]
[null,null,null,"хлеб","хлеб пшеничный",30,2.37,0.3,14.49,70.9,6]
[null,null,null,"закуска","капуста квашеная ",60,0.9,4.3,3.75,57.7,3,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F116:F122)","v":560},{"$f":"SUM(G116:G122)","v":16.56},17.8,72.16,526.5,null,{"$f":"SUM(L116:L122)","v":136.37}]
[{"$f":"A116","v":2},{"$f":"B116","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(F124:F132)","v":0},{"$f":"SUM(G124:G132)","v":0},0,0,0,null,{"$f":"SUM(L124:L132)","v":0}]
[{"$f":"A116","v":2},{"$f":"B116","v":2},"Итого за день:",null,null,{"$f":"F123+F133","v":560},{"$f":"G123+G133","v":16.56},{"$f":"H123+H133","v":17.8},{"$f":"I123+I133","v":72.16},{"$f":"J123+J133","v":526.5},null,136.37]
[2,3,"Завтрак","гор.блюдо","жаркое по-домашнему",200,11.92,18.1,45.3,305,259]
[null,null,null,"гор.напиток","чай с сахаром ",200,0.2,0,15,58,685]
[null,null,null,"хлеб","хлеб пшеничный",50,3.95,0.5,21.15,116.33,6]
[null,null,null,"закуска","овощи по сезону (огурец соленый или огурец свежий)",60,0.41,0.1,0.84,5,1,136.37]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F135:F141)","v":510},{"$f":"SUM(G135:G141)","v":16.48},18.7,82.29,484.33,null,{"$f":"SUM(L135:L141)","v":136.37}]
[{"$f":"A135","v":2},{"$f":"B135","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(F143:F151)","v":0},{"$f":"SUM(G143:G151)","v":0},0,0,0,null,{"$f":"SUM(L143:L151)","v":0}]
[{"$f":"A135","v":2},{"$f":"B135","v":3},"Итого за день:",null,null,{"$f":"F142+F152","v":510},{"$f":"G142+G152","v":16.48},{"$f":"H142+H152","v":18.7},{"$f":"I142+I152","v":82.29},{"$f":"J142+J152","v":484.33},null,136.37]
[2,4,"Завтрак","гор.блюдо","котлеты рубленые из птицы с соусом томатным (90/30)",120,11.3,12.1,14.6,205.6,"294/363"]
[null,null,null,"гор.блюдо","макаронные изделия отварные",150,3.7,5.7,28.2,195.7,203]
[null,null,null,"гор.напиток","чай с сахаром и лимоном",200,0.3,0,15.2,60,686]
[null,null,null,"хлеб","хлеб пшеничный",30,2.37,0.3,14.49,70.9,6,136.37]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F154:F159)","v":500},{"$f":"SUM(G154:G159)","v":17.67},18.1,72.49,532.2,null,{"$f":"SUM(L154:L159)","v":136.37}]
[{"$f":"A154","v":2},{"$f":"B154","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(F161:F169)","v":0},{"$f":"SUM(G161:G169)","v":0},0,0,0,null,{"$f":"SUM(L161:L169)","v":0}]
[{"$f":"A154","v":2},{"$f":"B154","v":4},"Итого за день:",null,null,{"$f":"F160+F170","v":500},{"$f":"G160+G170","v":17.67},{"$f":"H160+H170","v":18.1},{"$f":"I160+I170","v":72.49},{"$f":"J160+J170","v":532.2},null,136.37]
[2,5,"Завтрак","гор.блюдо","каша вязкая молочная кукурузная с творогом",200,7.8,9,30.2,225.8,653]
[null,null,null,"хлеб","бутерброд с маслом и сыром 35/5/10",50,6.7,6.3,17.1,149.85,3]
[null,null,null,"гор.напиток","чай с сахаром каркаде",200,0.2,0,9.2,42,"685К"]
[null,null,null,"хлеб","хлеб пшеничный",50,3.95,0.5,21.15,116.33,6,136.37]
[]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F172:F178)","v":500},{"$f":"SUM(G172:G178)","v":18.65},15.8,77.65,533.98,null,{"$f":"SUM(L172:L178)","v":136.37}]
[{"$f":"A172","v":2},{"$f":"B172","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(F180:F188)","v":0},{"$f":"SUM(G180:G188)","v":0},0,0,0,null,{"$f":"SUM(L180:L188)","v":0}]
[{"$f":"A172","v":2},{"$f":"B172","v":5},"Итого за день:",null,null,{"$f":"F179+F189","v":500},{"$f":"G179+G189","v":18.65},{"$f":"H179+H189","v":15.8},{"$f":"I179+I189","v":77.65},{"$f":"J179+J189","v":533.98},null,136.37]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F79+F97+F115+F134+F153+F171+F190)/(IF(F23=0,0,1)+IF(F42=0,0,1)+IF(F61=0,0,1)+IF(F79=0,0,1)+IF(F97=0,0,1)+IF(F115=0,0,1)+IF(F134=0,0,1)+IF(F153=0,0,1)+IF(F171=0,0,1)+IF(F190=0,0,1))","v":522.2},{"$f":"(G23+G42+G61+G79+G97+G115+G134+G153+G171+G190)/(IF(G23=0,0,1)+IF(G42=0,0,1)+IF(G61=0,0,1)+IF(G79=0,0,1)+IF(G97=0,0,1)+IF(G115=0,0,1)+IF(G134=0,0,1)+IF(G153=0,0,1)+IF(G171=0,0,1)+IF(G190=0,0,1))","v":17.996},{"$f":"(H23+H42+H61+H79+H97+H115+H134+H153+H171+H190)/(IF(H23=0,0,1)+IF(H42=0,0,1)+IF(H61=0,0,1)+IF(H79=0,0,1)+IF(H97=0,0,1)+IF(H115=0,0,1)+IF(H134=0,0,1)+IF(H153=0,0,1)+IF(H171=0,0,1)+IF(H190=0,0,1))","v":17.894},{"$f":"(I23+I42+I61+I79+I97+I115+I134+I153+I171+I190)/(IF(I23=0,0,1)+IF(I42=0,0,1)+IF(I61=0,0,1)+IF(I79=0,0,1)+IF(I97=0,0,1)+IF(I115=0,0,1)+IF(I134=0,0,1)+IF(I153=0,0,1)+IF(I171=0,0,1)+IF(I190=0,0,1))","v":75.967},{"$f":"(J23+J42+J61+J79+J97+J115+J134+J153+J171+J190)/(IF(J23=0,0,1)+IF(J42=0,0,1)+IF(J61=0,0,1)+IF(J79=0,0,1)+IF(J97=0,0,1)+IF(J115=0,0,1)+IF(J134=0,0,1)+IF(J153=0,0,1)+IF(J171=0,0,1)+IF(J190=0,0,1))","v":518.601},null,{"$f":"(L23+L42+L61+L79+L97+L115+L134+L153+L171+L190)/(IF(L23=0,0,1)+IF(L42=0,0,1)+IF(L61=0,0,1)+IF(L79=0,0,1)+IF(L97=0,0,1)+IF(L115=0,0,1)+IF(L134=0,0,1)+IF(L153=0,0,1)+IF(L171=0,0,1)+IF(L190=0,0,1))","v":136.37}]