{"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":202,"n_cols":12,"rows_kept":202,"cut":false,"hidden":false,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[24,2,24,3],[44,2,44,3],[63,2,63,3],[82,2,82,3],[102,2,102,3],[121,2,121,3],[141,2,141,3],[160,2,160,3],[179,2,179,3],[200,2,200,3],[201,2,201,4]]}
["Школа",{"$nulls":4},"Утвердил:","должность","директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","О.Ю. Коренева"]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",1,4,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Пюре картофельное",150,3.1,6.4,31,138.19,312,7.14]
[{"$nulls":4},"Курица запеченная",90,15.7,12.1,0.1,165.94,297,30.56]
[{"$nulls":4},"Салат из белокочанной капусты",60,0.6,2.05,3,41.22,43,5.65]
[null,null,null,"гор.напиток","Компот из сухофруктов",200,0.7,0,23.1,96.72,868,6.1]
[null,null,null,"хлеб","Хлеб пшеничный",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты","Яблоко",100,0.5,0.2,7.5,38,338,37.5]
[{"$nulls":4},"Печенье песочное",50,3.5,7.1,69.1,2.3,null,46.95]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F13)","v":680},{"$f":"SUM(G6:G13)","v":26.47},{"$f":"SUM(H6:H13)","v":28.15},{"$f":"SUM(I6:I13)","v":148.29},{"$f":"SUM(J6:J13)","v":576.37},null,{"$f":"SUM(L6:L13)","v":135.1}]
[{"$f":"A6","v":1},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(F15:F23)","v":0},{"$f":"SUM(G15:G23)","v":0},0,0,0,null,{"$f":"SUM(L15:L23)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F14+F24","v":680},{"$f":"G14+G24","v":26.47},28.15,148.29,576.37,null,{"$f":"L14+L24","v":135.1}]
[1,2,"Завтрак","гор.блюдо","Каша гречневая рассыпчатая",150,4.755,5.56,38.34,246.01,679,9.6]
[{"$nulls":4},"рыба припущенная",90,9.9,8.95,0.8,104,244,31.89]
[{"$nulls":4},"Салат витаминный.",60,0.65,2.08,4.25,63.11,null,9.97]
[null,null,null,"гор.напиток","Чай с лимоном",200,0.1,0,15,63.6,377,2.34]
[null,null,null,"хлеб","Хлеб пшеничный",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты"]
[{"$nulls":4},"Масло сливочное",10,0.5,82.5,1,737,null,2.1]
[{"$nulls":4},"Йогурт ",100,2.1,3.1,4,58,null,78]
[null,null,null,"итого",null,{"$f":"SUM(F26:F33)","v":640},{"$f":"SUM(G26:G33)","v":20.375},{"$f":"SUM(H26:H33)","v":102.49},{"$f":"SUM(I26:I33)","v":77.88},{"$f":"SUM(J26:J33)","v":1365.72},null,135.1]
[{"$f":"A26","v":1},{"$f":"B26","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(F35:F43)","v":0},{"$f":"SUM(G35:G43)","v":0},{"$f":"SUM(H35:H43)","v":0},{"$f":"SUM(I35:I43)","v":0},{"$f":"SUM(J35:J43)","v":0},null,0]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F34+F44","v":640},{"$f":"G34+G44","v":20.375},{"$f":"H34+H44","v":102.49},{"$f":"I34+I44","v":77.88},{"$f":"J34+J44","v":1365.72},null,135.1]
[1,3,"Завтрак","гор.блюдо","Каша рисовая на молоке с маслом",200,8.7,13.5,36,332.1,168,19.97]
[{"$nulls":4},"Сыр порционный",15,3.07,3.45,4.99,45,42,21.82]
[null,null,null,"гор.напиток","Какао на молоке",200,3.9,2.85,17.2,104.05,382,2.01]
[null,null,null,"хлеб","Хлеб пшеничный",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты","Яблоко",100,1.3,0.2,9.8,86,null,38.5]
[{"$nulls":4},"Печенье песочное",50,2.3,3.5,7.1,69.1,null,51.6]
[]
[null,null,null,"итого",null,{"$f":"SUM(F46:F52)","v":595},{"$f":"SUM(G46:G52)","v":21.64},{"$f":"SUM(H46:H52)","v":23.8},{"$f":"SUM(I46:I52)","v":89.58},{"$f":"SUM(J46:J52)","v":730.25},null,135.1]
[{"$f":"A46","v":1},{"$f":"B46","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(F54:F62)","v":0},{"$f":"SUM(G54:G62)","v":0},{"$f":"SUM(H54:H62)","v":0},{"$f":"SUM(I54:I62)","v":0},{"$f":"SUM(J54:J62)","v":0},null,0]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Итого за день:",null,null,{"$f":"F53+F63","v":595},{"$f":"G53+G63","v":21.64},{"$f":"H53+H63","v":23.8},{"$f":"I53+I63","v":89.58},{"$f":"J53+J63","v":730.25},null,135.1]
[1,4,"Завтрак","гор.блюдо","Плов из мяса птицы",240,16.2,16.27,40.96,476.3,304,20.75]
[{"$nulls":4},"Помидоры св. порционные",60,0.66,0.12,2.28,4.8,71,3.6]
[null,null,null,"гор.напиток","Чай из шиповника",200,0.17,0.07,13.39,58.09,338,2.1]
[null,null,null,"хлеб","Хлеб",30,2.37,0.3,19.32,94,null,1.2]
[null,null,null,"фрукты","Груша",100,1.3,0.2,9.8,86,null,49.3]
[{"$nulls":4},"Йогурт ",100,3.1,4,58,2.1,null,58.15]
[]
[null,null,null,"итого",null,{"$f":"SUM(F65:F71)","v":730},{"$f":"SUM(G65:G71)","v":23.8},{"$f":"SUM(H65:H71)","v":20.96},{"$f":"SUM(I65:I71)","v":143.75},721.29,null,{"$f":"SUM(L65:L71)","v":135.1}]
[{"$f":"A65","v":1},{"$f":"B65","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(F73:F81)","v":0},{"$f":"SUM(G73:G81)","v":0},{"$f":"SUM(H73:H81)","v":0},{"$f":"SUM(I73:I81)","v":0},{"$f":"SUM(J73:J81)","v":0},null,0]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Итого за день:",null,null,{"$f":"F72+F82","v":730},{"$f":"G72+G82","v":23.8},{"$f":"H72+H82","v":20.96},{"$f":"I72+I82","v":143.75},{"$f":"J72+J82","v":721.29},null,135.1]
[1,5,"Завтрак","гор.блюдо","Макароны отварные",150,5.85,3.86,32,198.97,309,13.2]
[{"$nulls":4},"Котлета из мяса говядины",90,14.7,10.7,9.2,102.7,608,23.57]
[{"$nulls":4},"Салат свекольник",60,0.6,3.89,4.7,5.8,33,5.5]
[null,null,null,"гор.напиток","кисель",200,0.19,0.04,22.3,87.74,332,1.53]
[null,null,null,"хлеб","Хлеб пшеничный",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты","Яблоко",100,0.2,7.5,38,0.5,null,38.5]
[{"$nulls":4},"Печенье песочное",50,2.3,3.5,7.1,69.1,null,51.6]
[]
[null,null,null,"итого",null,{"$f":"SUM(F84:F91)","v":680},{"$f":"SUM(G84:G91)","v":26.21},{"$f":"SUM(H84:H91)","v":29.79},{"$f":"SUM(I84:I91)","v":127.79},{"$f":"SUM(J84:J91)","v":558.81},null,135.1]
[{"$f":"A84","v":1},{"$f":"B84","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(F93:F101)","v":0},{"$f":"SUM(G93:G101)","v":0},{"$f":"SUM(H93:H101)","v":0},{"$f":"SUM(I93:I101)","v":0},{"$f":"SUM(J93:J101)","v":0},null,0]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Итого за день:",null,null,{"$f":"F92+F102","v":680},{"$f":"G92+G102","v":26.21},{"$f":"H92+H102","v":29.79},{"$f":"I92+I102","v":127.79},{"$f":"J92+J102","v":558.81},null,135.1]
[2,1,"Завтрак","гор.блюдо","Жаркое с мясом",240,14.78,15.7,26.85,343.63,31,41.8]
[{"$nulls":4},"Салат из помидоров и лука",60,0.6,1.38,4.7,21.03,14,12.04]
[null,null,null,"гор.напиток","Сок фруктовый",200,1,0,23.4,94,null,2]
[null,null,null,"хлеб","Хлеб пшеничный",40,2.37,0.3,19.32,94,null,1.2]
[null,null,null,"фрукты"]
[{"$nulls":4},"Йогурт ",100,2.1,2.5,9.39,58,null,78.06]
[]
[null,null,null,"итого",null,{"$f":"SUM(F104:F110)","v":640},{"$f":"SUM(G104:G110)","v":20.85},19.88,83.66,610.66,null,{"$f":"SUM(L104:L110)","v":135.1}]
[{"$f":"A104","v":2},{"$f":"B104","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(F112:F120)","v":0},{"$f":"SUM(G112:G120)","v":0},0,0,0,null,{"$f":"SUM(L112:L120)","v":0}]
[{"$f":"A104","v":2},{"$f":"B104","v":1},"Итого за день:",null,null,{"$f":"F111+F121","v":640},{"$f":"G111+G121","v":20.85},{"$f":"H111+H121","v":19.88},{"$f":"I111+I121","v":83.66},{"$f":"J111+J121","v":610.66},null,135.1]
[2,2,"Завтрак","гор.блюдо","Рис отварной",150,3.11,1.09,42.36,202.95,302,12.71]
[{"$nulls":4},"Гуляш из говядины",90,12.77,13.9,3.47,203.76,591,23]
[{"$nulls":4},"Салат из свежих огурцов и помидоров",60,0.6,1.38,4.7,2.4,15,5.75]
[null,null,null,"гор.напиток","Чай с лимоном",200,0.05,0.01,9.17,37.96,377,2.34]
[null,null,null,"хлеб","Хлеб пшеничный",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты","Груша",100,1.3,0.2,9.8,86,338,38.5]
[{"$nulls":4},"Печенье песочное",50,3.5,7.1,69.1,2.3,null,51.6]
[]
[null,null,null,"итого",null,{"$f":"SUM(F123:F130)","v":680},{"$f":"SUM(G123:G130)","v":23.7},23.98,153.09,629.37,null,{"$f":"SUM(L123:L130)","v":135.1}]
[{"$f":"A123","v":2},{"$f":"B123","v":2},"Обед","закуска"]
[null,null,null,"1 блюдо"]
[null,null,null,"2 блюдо"]
[null,null,null,"гарнир"]
[1,1,null,"напиток"]
[null,null,null,"хлеб бел."]
[null,null,null,"хлеб черн."]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F132:F140)","v":0},{"$f":"SUM(G132:G140)","v":0},0,0,0,null,{"$f":"SUM(L132:L140)","v":0}]
[{"$f":"A123","v":2},{"$f":"B123","v":2},"Итого за день:",null,null,{"$f":"F131+F141","v":680},{"$f":"G131+G141","v":23.7},{"$f":"H131+H141","v":23.98},{"$f":"I131+I141","v":153.09},{"$f":"J131+J141","v":629.37},null,135.1]
[2,3,"Завтрак","гор.блюдо","Солянка с говядин.",240,12.81,11.5,21.99,272.68,null,12]
[{"$nulls":4},"Булка с творогом",50,2.92,4.45,12.37,102.5,null,27.79]
[null,null,null,"гор.напиток","Какао на молоке",200,2.9,2.85,17.2,86.25,382,2.01]
[null,null,null,"хлеб","Хлеб пшеничн.",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты","Апельсин",100,0.6,0.6,14.7,70.5,338,14.04]
[{"$nulls":4},"Йогурт ",100,2.5,9.39,58,2.1,null,78.06]
[]
[null,null,null,"итого",null,{"$f":"SUM(F143:F149)","v":720},{"$f":"SUM(G143:G149)","v":24.1},29.09,138.75,628.03,null,{"$f":"SUM(L143:L149)","v":135.1}]
[{"$f":"A143","v":2},{"$f":"B143","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(F151:F159)","v":0},{"$f":"SUM(G151:G159)","v":0},0,0,0,null,{"$f":"SUM(L151:L159)","v":0}]
[{"$f":"A143","v":2},{"$f":"B143","v":3},"Итого за день:",null,null,{"$f":"F150+F160","v":720},{"$f":"G150+G160","v":24.1},{"$f":"H150+H160","v":29.09},{"$f":"I150+I160","v":138.75},{"$f":"J150+J160","v":628.03},null,135.1]
[2,4,"Завтрак","гор.блюдо","Каша дружба с маслом",200,7.98,10.19,42.41,280.48,190,21.97]
[{"$nulls":4},"Сыр порционный",15,3.07,3.45,0.37,45,42,19.82]
[null,null,null,"гор.напиток","Какао с молоком",200,3.59,2.85,15.71,104.05,382,2.01]
[null,null,null,"хлеб","Хлеб пшеничный",40,3.16,0.4,14.49,94,null,1.2]
[null,null,null,"фрукты","Банан",100,1.5,0.2,7.5,38,null,39.04]
[{"$nulls":4},"Печенье песочное",50,2.3,3.5,7.1,69.1,null,51.06]
[]
[null,null,null,"итого",null,{"$f":"SUM(F162:F168)","v":605},{"$f":"SUM(G162:G168)","v":21.6},20.59,87.58,630.63,null,{"$f":"SUM(L162:L168)","v":135.1}]
[{"$f":"A162","v":2},{"$f":"B162","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(F170:F178)","v":0},{"$f":"SUM(G170:G178)","v":0},0,0,0,null,{"$f":"SUM(L170:L178)","v":0}]
[{"$f":"A162","v":2},{"$f":"B162","v":4},"Итого за день:",null,null,{"$f":"F169+F179","v":605},{"$f":"G169+G179","v":21.6},{"$f":"H169+H179","v":20.59},{"$f":"I169+I179","v":87.58},{"$f":"J169+J179","v":630.63},null,135.1]
[2,5,"Завтрак","гор.блюдо","Макароны отварные",150,5.85,2.86,36,202.95,309,13.2]
[{"$nulls":4},"Тефтели  рыбные",90,10.4,8.28,4.8,159.92,48,29.98]
[]
[{"$nulls":4},"Салат из свежих огурцов",60,0.6,3.05,1.14,65.5,13,6.62]
[null,null,null,"гор.напиток","Компот из сухофруктов",200,0.7,0.15,15.37,96.72,868,6.1]
[null,null,null,"хлеб","Хлеб пшеничный",30,2.37,0.3,14.49,94,null,1.2]
[null,null,null,"фрукты"]
[{"$nulls":4},"Булка с творогом",50,4.45,12.37,102.5,2.92,null,78]
[]
[null,null,null,"итого",null,{"$f":"SUM(F181:F189)","v":580},{"$f":"SUM(G181:G189)","v":24.37},27.01,174.3,622.01,null,{"$f":"SUM(L181:L189)","v":135.1}]
[{"$f":"A181","v":2},{"$f":"B181","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(F191:F199)","v":0},{"$f":"SUM(G191:G199)","v":0},0,0,0,null,{"$f":"SUM(L191:L199)","v":0}]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Итого за день:",null,null,{"$f":"F190+F200","v":580},{"$f":"G190+G200","v":24.37},{"$f":"H190+H200","v":27.01},{"$f":"I190+I200","v":174.3},{"$f":"J190+J200","v":622.01},null,135.1]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F45+F64+F83+F103+F122+F142+F161+F180+F201)/(IF(F25=0,0,1)+IF(F45=0,0,1)+IF(F64=0,0,1)+IF(F83=0,0,1)+IF(F103=0,0,1)+IF(F122=0,0,1)+IF(F142=0,0,1)+IF(F161=0,0,1)+IF(F180=0,0,1)+IF(F201=0,0,1))","v":655},{"$f":"(G25+G45+G64+G83+G103+G122+G142+G161+G180+G201)/(IF(G25=0,0,1)+IF(G45=0,0,1)+IF(G64=0,0,1)+IF(G83=0,0,1)+IF(G103=0,0,1)+IF(G122=0,0,1)+IF(G142=0,0,1)+IF(G161=0,0,1)+IF(G180=0,0,1)+IF(G201=0,0,1))","v":23.3115},32.574,122.467,707.314,null,{"$f":"(L25+L45+L64+L83+L103+L122+L142+L161+L180+L201)/(IF(L25=0,0,1)+IF(L45=0,0,1)+IF(L64=0,0,1)+IF(L83=0,0,1)+IF(L103=0,0,1)+IF(L122=0,0,1)+IF(L142=0,0,1)+IF(L161=0,0,1)+IF(L180=0,0,1)+IF(L201=0,0,1))","v":135.1}]