{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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],[80,2,80,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,"МБОУ СОШ №20",null,null,"Утвердил:","должность","директор МБОУ СОШ №20"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Трусова О.Б."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",1,3,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Гуляш из свинины с соусом",100,14,17,4,225,591,33.41]
[null,null,null,"гарнир","Макаронные изделия отварные",150,6,2,36,177,273,8.88]
[null,null,null,"гор.напиток","Чай с сахаром",200,0,0,15,58,628,1.63]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты"]
[null,null,null,"закуска","Салат из кукурузы консервированной",60,2,4,5,60,12,30.2]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":540},{"$f":"SUM(G6:G12)","v":24},{"$f":"SUM(H6:H12)","v":23},{"$f":"SUM(I6:I12)","v":74},{"$f":"SUM(J6:J12)","v":591},null,{"$f":"SUM(L6:L12)","v":76.56}]
[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},{"$f":"SUM(H14:H22)","v":0},{"$f":"SUM(I14:I22)","v":0},{"$f":"SUM(J14:J22)","v":0},null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":540},{"$f":"G13+G23","v":24},{"$f":"H13+H23","v":23},{"$f":"I13+I23","v":74},{"$f":"J13+J23","v":591},null,{"$f":"L13+L23","v":76.56}]
[1,2,"Завтрак","гор.блюдо","Курица тушеная с соусом",150,27,19,0,285,444,47.77]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150,9,11,42,300,"Табл№4",10.07]
[null,null,null,"гор.напиток","Кофейный напиток",200,3,4,29,152,637,6.77]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты","Клементины",100,0,0,10,47,null,21.57]
[null,null,null,"сладкое","Запеканка творожная со сгущенным молоком",80,9,8,20,194,297,35.07]
[]
[null,null,null,"итого",null,{"$f":"SUM(F25:F31)","v":710},{"$f":"SUM(G25:G31)","v":50},{"$f":"SUM(H25:H31)","v":42},{"$f":"SUM(I25:I31)","v":115},{"$f":"SUM(J25:J31)","v":1049},null,{"$f":"SUM(L25:L31)","v":123.69}]
[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,{"$f":"SUM(L33:L41)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":710},{"$f":"G32+G42","v":50},{"$f":"H32+H42","v":42},{"$f":"I32+I42","v":115},{"$f":"J32+J42","v":1049},null,{"$f":"L32+L42","v":123.69}]
[1,3,"Завтрак","гор.блюдо","Плов из свинины",260,15,33,45,540,601,55.87]
[null,null,null,"гарнир"]
[null,null,null,"гор.напиток","Напиток «Витошка»",200,1,0,34,116,"медицина",7]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[null,null,null,"булочное","Бутерброд  с сыром",45,6,5,14,125,1,14.1]
[null,null,null,"закуска","Нарезка из свежих огурцов",60,0,0,2,9,57,22.6]
[null,null,null,"итого",null,{"$f":"SUM(F44:F50)","v":565},{"$f":"SUM(G44:G50)","v":22},{"$f":"SUM(H44:H50)","v":38},{"$f":"SUM(I44:I50)","v":95},{"$f":"SUM(J44:J50)","v":790},null,{"$f":"SUM(L44:L50)","v":99.57}]
[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,{"$f":"SUM(L52:L60)","v":0}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":565},{"$f":"G51+G61","v":22},{"$f":"H51+H61","v":38},{"$f":"I51+I61","v":95},{"$f":"J51+J61","v":790},null,{"$f":"L51+L61","v":99.57}]
[1,4,"Завтрак","гор.блюдо","Котлета рыбная",100,23,8,7,189,83,51.46]
[null,null,null,"гарнир","Пюре картофельное",150,3,5,20,137,472,19.31]
[null,null,null,"гор.напиток","Компот из кураги",200,1,0,8,34,867,7.34]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты"]
[null,null,null,"закуска","Нарезка из соленых огурцов",60,0,0,1,8,56,19.44]
[null,null,null,"булочное","Пирожное Чоко-пай",28,1,5,18,125,null,12.5]
[null,null,null,"итого",null,{"$f":"SUM(F63:F69)","v":568},{"$f":"SUM(G63:G69)","v":30},{"$f":"SUM(H63:H69)","v":18},{"$f":"SUM(I63:I69)","v":68},{"$f":"SUM(J63:J69)","v":564},null,{"$f":"SUM(L63:L69)","v":112.49}]
[{"$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(F71:F79)","v":0},{"$f":"SUM(G71:G79)","v":0},{"$f":"SUM(H71:H79)","v":0},{"$f":"SUM(I71:I79)","v":0},{"$f":"SUM(J71:J79)","v":0},null,{"$f":"SUM(L71:L79)","v":0}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":568},{"$f":"G70+G80","v":30},{"$f":"H70+H80","v":18},{"$f":"I70+I80","v":68},{"$f":"J70+J80","v":564},null,{"$f":"L70+L80","v":112.49}]
[1,5,"Завтрак","гор.блюдо","Котлета домашняя",100,15,19,6,260,611,68.88]
[null,null,null,"гарнир","Овощное рагу",150,5,8,19,177,716,10.29]
[null,null,null,"гор.напиток","Сок фруктовый",200,1,0,21,94,null,22]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты","Яблоко",135,0,0,19,65,null,18.77]
[null,null,null,"булочное","Бутерброд  с повидлом",33,1,0,13,64,2,4.63]
[]
[null,null,null,"итого",null,{"$f":"SUM(F82:F88)","v":648},{"$f":"SUM(G82:G88)","v":24},{"$f":"SUM(H82:H88)","v":27},{"$f":"SUM(I82:I88)","v":92},{"$f":"SUM(J82:J88)","v":731},null,{"$f":"SUM(L82:L88)","v":127.00999999999998}]
[{"$f":"A82","v":1},{"$f":"B82","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(F90:F98)","v":0},{"$f":"SUM(G90:G98)","v":0},{"$f":"SUM(H90:H98)","v":0},{"$f":"SUM(I90:I98)","v":0},{"$f":"SUM(J90:J98)","v":0},null,{"$f":"SUM(L90:L98)","v":0}]
[2,1,"Завтрак","гор.блюдо","Тефтели мясные с томатным соусом",150,23,15,6,247,618,69.48]
[null,null,null,"гарнир","Макаронные изделия отварные",150,6,2,36,177,273,8.88]
[null,null,null,"гор.напиток","Кисель «Витошка»",200,0,0,18,74,"медицина",9.5]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты"]
[null,null,null,"булочное"]
[null,null,null,"закуска","Салат из зеленого горошка",60,2,3,3,50,10,33.35]
[null,null,null,"итого",null,{"$f":"SUM(F100:F106)","v":590},{"$f":"SUM(G100:G106)","v":33},{"$f":"SUM(H100:H106)","v":20},{"$f":"SUM(I100:I106)","v":77},{"$f":"SUM(J100:J106)","v":619},null,{"$f":"SUM(L100:L106)","v":123.65}]
[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},{"$f":"SUM(H108:H116)","v":0},{"$f":"SUM(I108:I116)","v":0},{"$f":"SUM(J108:J116)","v":0},null,{"$f":"SUM(L108:L116)","v":0}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Итого за день:",null,null,{"$f":"F107+F117","v":590},{"$f":"G107+G117","v":33},{"$f":"H107+H117","v":20},{"$f":"I107+I117","v":77},{"$f":"J107+J117","v":619},null,{"$f":"L107+L117","v":123.65}]
[2,2,"Завтрак","гор.блюдо","Кура запеченная ",100,26,11,0,204,450,45.75]
[null,null,null,"гарнир","Пюре картофельное",150,3,4,20,137,472,19.31]
[null,null,null,"гор.напиток","Чай с сахаром",200,0,0,15,58,628,1.63]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты","Яблоко",100,0,0,10,47,null,19.32]
[null,null,null,"сладкое","Запеканка творожная со сгущенным молоком",80,9,8,20,194,297,35.07]
[]
[null,null,null,"итого",null,{"$f":"SUM(F119:F125)","v":660},{"$f":"SUM(G119:G125)","v":40},{"$f":"SUM(H119:H125)","v":23},{"$f":"SUM(I119:I125)","v":79},{"$f":"SUM(J119:J125)","v":711},null,{"$f":"SUM(L119:L125)","v":123.51999999999998}]
[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},{"$f":"SUM(H127:H135)","v":0},{"$f":"SUM(I127:I135)","v":0},{"$f":"SUM(J127:J135)","v":0},null,{"$f":"SUM(L127:L135)","v":0}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Итого за день:",null,null,{"$f":"F126+F136","v":660},{"$f":"G126+G136","v":40},{"$f":"H126+H136","v":23},{"$f":"I126+I136","v":79},{"$f":"J126+J136","v":711},null,{"$f":"L126+L136","v":123.51999999999998}]
[2,3,"Завтрак","гор.блюдо","Котлета рубленная из курицы с томатным соусом",150,17,20,15,307,307,44.38]
[null,null,null,"гарнир","Каша гречневая рассыпчатая",150,9,11,42,300,"Табл№4",10.07]
[null,null,null,"гор.напиток","Кофейный напиток",200,3,4,29,152,637,6.77]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"булочное","Булка «Венская»",80,0,0,10,47,null,27.28]
[null,null,null,"закуска"]
[]
[null,null,null,"итого",null,{"$f":"SUM(F138:F144)","v":610},{"$f":"SUM(G138:G144)","v":31},{"$f":"SUM(H138:H144)","v":35},{"$f":"SUM(I138:I144)","v":110},{"$f":"SUM(J138:J144)","v":877},null,{"$f":"SUM(L138:L144)","v":90.94}]
[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},{"$f":"SUM(H146:H154)","v":0},{"$f":"SUM(I146:I154)","v":0},{"$f":"SUM(J146:J154)","v":0},null,{"$f":"SUM(L146:L154)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":3},"Итого за день:",null,null,{"$f":"F145+F155","v":610},{"$f":"G145+G155","v":31},{"$f":"H145+H155","v":35},{"$f":"I145+I155","v":110},{"$f":"J145+J155","v":877},null,{"$f":"L145+L155","v":90.94}]
[2,4,"Завтрак","гор.блюдо","Гуляш из свинины с соусом",100,14,17,4,225,591,33.41]
[null,null,null,"гарнир","Рис припущенный ",150,3,9,36,241,466,11.06]
[null,null,null,"гор.напиток","Компот из сухофруктов",200,1,0,32,124,588,3.15]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты"]
[null,null,null,"закуска","Салат из вареной свеклы",60,1,4,5,56,24,3.27]
[null,null,null,"булочное","Бутерброд  с сыром",45,6,5,14,125,1,14.1]
[null,null,null,"итого",null,{"$f":"SUM(F157:F163)","v":585},{"$f":"SUM(G157:G163)","v":27},{"$f":"SUM(H157:H163)","v":35},{"$f":"SUM(I157:I163)","v":105},{"$f":"SUM(J157:J163)","v":842},null,{"$f":"SUM(L157:L163)","v":67.42999999999999}]
[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},{"$f":"SUM(H165:H173)","v":0},{"$f":"SUM(I165:I173)","v":0},{"$f":"SUM(J165:J173)","v":0},null,{"$f":"SUM(L165:L173)","v":0}]
[{"$f":"A157","v":2},{"$f":"B157","v":4},"Итого за день:",null,null,{"$f":"F164+F174","v":585},{"$f":"G164+G174","v":27},{"$f":"H164+H174","v":35},{"$f":"I164+I174","v":105},{"$f":"J164+J174","v":842},null,{"$f":"L164+L174","v":67.42999999999999}]
[2,5,"Завтрак","гор.блюдо","Жаркое по домашнему",300,16,28,40,479,590,44.89]
[null,null,null,"булочное"]
[null,null,null,"гор.напиток","Сок фруктовый",200,1,0,21,94,null,22]
[null,null,null,"хлеб","Пшеничный 1 сорт",30,2,0,14,71,null,2.44]
[null,null,null,"фрукты","Яблоко",150,1,1,25,86,null,17.7]
[null,null,null,"закуска","Нарезка из свежих помидор",60,1,0,0,2,58,22.06]
[]
[null,null,null,"итого",null,{"$f":"SUM(F176:F182)","v":740},{"$f":"SUM(G176:G182)","v":21},{"$f":"SUM(H176:H182)","v":29},{"$f":"SUM(I176:I182)","v":100},{"$f":"SUM(J176:J182)","v":732},null,{"$f":"SUM(L176:L182)","v":109.09}]
[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},{"$f":"SUM(H184:H192)","v":0},{"$f":"SUM(I184:I192)","v":0},{"$f":"SUM(J184:J192)","v":0},null,{"$f":"SUM(L184:L192)","v":0}]
[{"$f":"A176","v":2},{"$f":"B176","v":5},"Итого за день:",null,null,{"$f":"F183+F193","v":740},{"$f":"G183+G193","v":21},{"$f":"H183+H193","v":29},{"$f":"I183+I193","v":100},{"$f":"J183+J193","v":732},null,{"$f":"L183+L193","v":109.09}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F80+F99+F118+F137+F156+F175+F194)/(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(F194=0, 0, 1))","v":637},{"$f":"(G23+G42+G61+G80+G99+G118+G137+G156+G175+G194)/(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(G194=0, 0, 1))","v":30.4},{"$f":"(H23+H42+H61+H80+H99+H118+H137+H156+H175+H194)/(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(H194=0, 0, 1))","v":28.4},{"$f":"(I23+I42+I61+I80+I99+I118+I137+I156+I175+I194)/(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(I194=0, 0, 1))","v":94.2},{"$f":"(J23+J42+J61+J80+J99+J118+J137+J156+J175+J194)/(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(J194=0, 0, 1))","v":756.2},null,{"$f":"(L23+L42+L61+L80+L99+L118+L137+L156+L175+L194)/(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(L194=0, 0, 1))","v":102.926}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}