{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":200,"n_cols":12,"rows_kept":200,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[24,2,24,3],[43,2,43,3],[63,2,63,3],[83,2,83,3],[103,2,103,3],[122,2,122,3],[141,2,141,3],[160,2,160,3],[179,2,179,3],[198,2,198,3],[199,2,199,4]]}
["Школа",null,"МБОУ \"Затонская СОШ им. В.П. Муравьева\"",null,null,"Согласовал","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Муратьязова Е.Ю,"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",15,10,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","закуска","Салат из моркови с яблоками",60,0.64,0.1,5.11,23.94,59,64.19]
[{"$nulls":3},"гор.блюдо","Котлета домашняя из говядины",90,8.15,10.5,8.1,199.57,271]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные с маслом сливочным",155,5.12,4.53,31.99,189.3,203]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов (75С)",200,0.66,0.09,22.03,92.9,349]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.54,17.82,89.1]
[{"$nulls":3},"сладкое","Печенье",40,3.7,4.7,2.85,21.5]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":565},{"$f":"SUM(G6:G13)","v":19.59},20.459999999999997,87.9,616.3100000000001,null,{"$f":"SUM(L6:L13)","v":64.19}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":565},{"$f":"G14+G24","v":19.59},20.459999999999997,87.9,616.3100000000001,null,{"$f":"L14+L24","v":64.19}]
[1,2,"Завтрак","гор.блюдо","Гуляш из говядины",100,10.45,10.71,22.89,221,260,64.19]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая с маслом сливочным",155,4.61,6.92,27.79,207,171]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с лимоном",200,0.13,0.02,10.2,42,377]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.54,0.2,12.3,58.75]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (апельсин)",100,0.8,0.2,8.1,43]
[{"$nulls":4},"Сыр порционно",10,2.63,2.66,0,34.33,15]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F32)","v":590},{"$f":"SUM(G26:G32)","v":20.16},{"$f":"SUM(H26:H32)","v":20.71},{"$f":"SUM(I26:I32)","v":81.27999999999999},{"$f":"SUM(J26:J32)","v":606.08},null,64.19]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F34:F42)","v":0},{"$f":"SUM(G34:G42)","v":0},{"$f":"SUM(H34:H42)","v":0},{"$f":"SUM(I34:I42)","v":0},{"$f":"SUM(J34:J42)","v":0},null,0]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F33+F43","v":590},{"$f":"G33+G43","v":20.16},{"$f":"H33+H43","v":20.71},{"$f":"I33+I43","v":81.27999999999999},{"$f":"J33+J43","v":606.08},null,64.19]
[1,3,"Завтрак","закуска","Салат из свеклы отварной",60,0.84,3.61,4.96,55.68,52,64.19]
[{"$nulls":3},"гор.блюдо","Птица запеченная с томатным соусом",110,12,10.04,8.6,195.1,293]
[{"$nulls":3},"гор.блюдо","Рис отварной рассыпчатый с маслом сливочным",155,3.74,4.75,39.23,209,304]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.07,0.02,10,40,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F52)","v":565},{"$f":"SUM(G45:G52)","v":19.49},{"$f":"SUM(H45:H52)","v":18.819999999999997},{"$f":"SUM(I45:I52)","v":80.55},{"$f":"SUM(J45:J52)","v":586.38},null,64.19]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":"A45","v":1},{"$f":"B45","v":3},"Итого за день:",null,null,{"$f":"F53+F63","v":565},{"$f":"G53+G63","v":19.49},{"$f":"H53+H63","v":18.819999999999997},{"$f":"I53+I63","v":80.55},{"$f":"J53+J63","v":586.38},null,64.19]
[1,4,"Завтрак","закуска","Салат из белокачанной капусты",60,0.79,1.95,3.88,36.24,45,64.19]
[{"$nulls":3},"гор.блюдо","Рыба тушеная в томате с овощами",100,9.15,5.62,7.8,105,229]
[{"$nulls":3},"гор.блюдо","Пюре картофельное с мслом сливочным",155,3.1,8.43,20.51,170.25,312]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок (75С)",200,0.16,0.16,13.91,58.74,342]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F65:F72)","v":555},{"$f":"SUM(G65:G72)","v":16.04},{"$f":"SUM(H65:H72)","v":16.56},{"$f":"SUM(I65:I72)","v":63.86},{"$f":"SUM(J65:J72)","v":456.83000000000004},null,64.19]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F74:F82)","v":0},{"$f":"SUM(G74:G82)","v":0},{"$f":"SUM(H74:H82)","v":0},{"$f":"SUM(I74:I82)","v":0},{"$f":"SUM(J74:J82)","v":0},null,0]
[{"$f":"A65","v":1},{"$f":"B65","v":4},"Итого за день:",null,null,{"$f":"F73+F83","v":555},{"$f":"G73+G83","v":16.04},{"$f":"H73+H83","v":16.56},{"$f":"I73+I83","v":63.86},{"$f":"J73+J83","v":456.83000000000004},null,64.19]
[1,5,"Завтрак","закуска","Салат из моркови с сахаром",60,0.74,0.06,6.58,49.02,62,64.19]
[{"$nulls":3},"гор.блюдо","Котлеты говяжьи",90,10.18,11.75,15.77,183.4,271]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая с маслом сливочным",155,4.61,6.92,27.79,207,171]
[{"$nulls":3},"гор.напиток","Чай с мармеладом",200,0.09,0.02,11.91,48.15,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F85:F92)","v":545},{"$f":"SUM(G85:G92)","v":18.46},{"$f":"SUM(H85:H92)","v":19.15},{"$f":"SUM(I85:I92)","v":79.81},{"$f":"SUM(J85:J92)","v":574.17},null,64.19]
[{"$f":"A85","v":1},{"$f":"B85","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F94:F102)","v":0},{"$f":"SUM(G94:G102)","v":0},{"$f":"SUM(H94:H102)","v":0},{"$f":"SUM(I94:I102)","v":0},{"$f":"SUM(J94:J102)","v":0},null,0]
[{"$f":"A85","v":1},{"$f":"B85","v":5},"Итого за день:",null,null,{"$f":"F93+F103","v":545},{"$f":"G93+G103","v":18.46},{"$f":"H93+H103","v":19.15},{"$f":"I93+I103","v":79.81},{"$f":"J93+J103","v":574.17},null,64.19]
[2,1,"Завтрак","гор.блюдо","Птица запеченная",90,9.82,15.964,0,202,293,64.19]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные с маслом сливочным",153,5.1,2.85,39.56,186.1,203]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с яблоком",200,0.11,0.06,12.69,45,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",40,3.04,0.32,19.68,94]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F105:F111)","v":503},{"$f":"SUM(G105:G111)","v":19.39},19.433999999999997,79.85000000000001,566.7,null,{"$f":"SUM(L105:L111)","v":64.19}]
[{"$f":"A105","v":2},{"$f":"B105","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F113:F121)","v":0},{"$f":"SUM(G113:G121)","v":0},0,0,0,null,{"$f":"SUM(L113:L121)","v":0}]
[{"$f":"A105","v":2},{"$f":"B105","v":1},"Итого за день:",null,null,{"$f":"F112+F122","v":503},{"$f":"G112+G122","v":19.39},{"$f":"H112+H122","v":19.433999999999997},{"$f":"I112+I122","v":79.85000000000001},{"$f":"J112+J122","v":566.7},null,64.19]
[2,2,"Завтрак",null,"Бутерброд с маслом сливочным и сыром",60,7.03,7.94,19.75,178.5,3,64.19]
[{"$nulls":3},"гор.блюдо","Овощи тушеные с мясом",200,5.1,5.38,22.34,191.35,"143, 231"]
[{"$nulls":3},"гор.напиток","Чай \"Витаминный\" с ягодами",200,0.24,0.09,12.42,54.2]
[{"$nulls":3},"сладкое","Печенье",30,2.22,2.82,1.71,12.9]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,39.6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F124:F130)","v":510},{"$f":"SUM(G124:G130)","v":15.91},16.47,64.14,476.55,null,{"$f":"SUM(L124:L130)","v":64.19}]
[{"$f":"A124","v":2},{"$f":"B124","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F132:F140)","v":0},{"$f":"SUM(G132:G140)","v":0},0,0,0,null,{"$f":"SUM(L132:L140)","v":0}]
[{"$f":"A124","v":2},{"$f":"B124","v":2},"Итого за день:",null,null,{"$f":"F131+F141","v":510},{"$f":"G131+G141","v":15.91},{"$f":"H131+H141","v":16.47},{"$f":"I131+I141","v":64.14},{"$f":"J131+J141","v":476.55},null,64.19]
[2,3,"Завтрак","закуска","Салат из свеклы отварной",60,0.84,3.61,4.96,55.68,52,64.19]
[{"$nulls":3},"гор.блюдо","Котлеты из мяса кур",90,11.85,8.06,18.53,198,294]
[{"$nulls":3},"гор.блюдо","Пюре картофельное с маслом сливочным",155,3.13,8.43,20.51,170.25,312]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.07,0.02,10,40,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",35,2.66,0.28,17.22,82]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,1.65,0.3,9.9,50]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F143:F149)","v":565},{"$f":"SUM(G143:G149)","v":20.2},20.700000000000003,81.12,595.9300000000001,null,{"$f":"SUM(L143:L149)","v":64.19}]
[{"$f":"A143","v":2},{"$f":"B143","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":565},{"$f":"G150+G160","v":20.2},{"$f":"H150+H160","v":20.700000000000003},{"$f":"I150+I160","v":81.12},{"$f":"J150+J160","v":595.9300000000001},null,64.19]
[2,4,"Завтрак","гор.блюдо","Тефтели мясные в сметанно-томатном соусе",100,7.284,11.79,6.738,133.99,"279, 331",64.19]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные с маслом сливочным",153,5.1,2.85,33.76,176.1,203]
[{"$nulls":3},"гор.напиток","Напиток из свежих фруктов (75С)",200,0.34,0.17,9.99,63.6,"ТТК"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47]
[{"$nulls":3},"фрукты","Плоды и ягоды свежие (апельсин)",100,0.8,0.2,8.05,43]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F162:F168)","v":573},{"$f":"SUM(G162:G168)","v":15.044},15.169999999999998,68.378,463.69000000000005,null,{"$f":"SUM(L162:L168)","v":64.19}]
[{"$f":"A162","v":2},{"$f":"B162","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",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":573},{"$f":"G169+G179","v":15.044},{"$f":"H169+H179","v":15.169999999999998},{"$f":"I169+I179","v":68.378},{"$f":"J169+J179","v":463.69000000000005},null,64.19]
[2,5,"Завтрак","закуска","Салат из свежей капусты с морковью",60,0.79,1.95,3.88,36.24,45,64.19]
[{"$nulls":3},"гор.блюдо","Плов из говядины с рисом",200,16.03,18.16,45.91,415.89,265]
[{"$nulls":3},"гор.напиток","Чай с сахаром, с яблоком",200,0.11,0.06,10.99,45,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",25,1.9,0.2,12.3,59]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,7.92,40]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F181:F187)","v":505},{"$f":"SUM(G181:G187)","v":20.15},20.609999999999996,81,596.13,null,{"$f":"SUM(L181:L187)","v":64.19}]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F189:F197)","v":0},{"$f":"SUM(G189:G197)","v":0},0,0,0,null,{"$f":"SUM(L189:L197)","v":0}]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Итого за день:",null,null,{"$f":"F188+F198","v":505},{"$f":"G188+G198","v":20.15},{"$f":"H188+H198","v":20.609999999999996},{"$f":"I188+I198","v":81},{"$f":"J188+J198","v":596.13},null,64.19]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F44+F64+F84+F104+F123+F142+F161+F180+F199)/(IF(F25=0,0,1)+IF(F44=0,0,1)+IF(F64=0,0,1)+IF(F84=0,0,1)+IF(F104=0,0,1)+IF(F123=0,0,1)+IF(F142=0,0,1)+IF(F161=0,0,1)+IF(F180=0,0,1)+IF(F199=0,0,1))","v":547.6},{"$f":"(G25+G44+G64+G84+G104+G123+G142+G161+G180+G199)/(IF(G25=0,0,1)+IF(G44=0,0,1)+IF(G64=0,0,1)+IF(G84=0,0,1)+IF(G104=0,0,1)+IF(G123=0,0,1)+IF(G142=0,0,1)+IF(G161=0,0,1)+IF(G180=0,0,1)+IF(G199=0,0,1))","v":18.443400000000004},18.808399999999995,76.78880000000001,553.8770000000002,null,{"$f":"(L25+L44+L64+L84+L104+L123+L142+L161+L180+L199)/(IF(L25=0,0,1)+IF(L44=0,0,1)+IF(L64=0,0,1)+IF(L84=0,0,1)+IF(L104=0,0,1)+IF(L123=0,0,1)+IF(L142=0,0,1)+IF(L161=0,0,1)+IF(L180=0,0,1)+IF(L199=0,0,1))","v":64.19000000000001}]