{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["12-31янв"],"read":"whole","date_system":"1900"}

{"sheet":"12-31янв","index":0,"n_rows":233,"n_cols":12,"rows_kept":233,"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],[79,2,79,3],[98,2,98,3],[117,2,117,3],[136,2,136,3],[155,2,155,3],[174,2,174,3],[193,2,193,3],[212,2,212,3],[231,2,231,3],[232,2,232,4]]}
["Школа",{"$nulls":4},"Утвердил:","должность","директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Коновалова И.А."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","прочее","Печенье сахарное",60,4.5,7.2,44.6,259,"ТК"]
[{"$nulls":3},"гор.блюдо","Каша пшеничная молочная с маслом",210,7.36,8.48,36.18,247,"311,сб.шк.2004г."]
[{"$nulls":3},"гор.напиток","Чай с лимоном и сахаром",200,0.2,0,9.3,38,"686.сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":530},{"$f":"SUM(G6:G12)","v":16.29},16.88,117.38,681,null,77.76]
[{"$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(F14:F22)","v":0},{"$f":"SUM(G14:G22)","v":0},0,0,0,null,0]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":530},{"$f":"G13+G23","v":16.29},16.88,117.38,681,null,77.76]
[1,2,"Завтрак","гор.блюдо","Котлеты из мяса говядины с томатным соусом",110,12.8,13.12,16.96,242,"451,сб.шк.2004г."]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",155,5.25,3.67,33.3,194,"332.сб.2004г."]
[{"$nulls":3},"напиток","Компот из компотной смеси (быст.замор.)",200,0.21,0.04,18.01,73,"123.орг.пит.шк"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":525},{"$f":"SUM(G25:G31)","v":22.490000000000002},18.029999999999998,95.57,646,null,77.76]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":0},{"$f":"SUM(G33:G41)","v":0},0,0,0,null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":525},{"$f":"G32+G42","v":22.490000000000002},18.029999999999998,95.57,646,null,77.76]
[1,3,"Завтрак","гор.блюдо","Грудка куриная в сливочном соусе",120,20,16.8,0.3,232,"290.ДеЛи2015г."]
[{"$nulls":3},"гор.блюдо","Каша рисовая рассыпчатая",155,3.67,3.92,37.5,207,"297.сб.шк.2004г."]
[{"$nulls":3},"напиток","Компот из смеси сухофруктов",200,0.5,0.1,30.9,123,"639(3).сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":535},{"$f":"SUM(G44:G50)","v":28.400000000000002},22.02,95.99999999999999,699,null,77.76]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":0},{"$f":"SUM(G52:G60)","v":0},0,0,0,null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":535},{"$f":"G51+G61","v":28.400000000000002},22.02,95.99999999999999,699,null,77.76]
[1,4,"Завтрак","прочее","Сыр порциями",30,7.4,8,0,105,"336.сб.Пермь2008г."]
[{"$nulls":3},"прочее","Яйцо вареное",50,6.3,5.3,0.5,78,"ТТК"]
[{"$nulls":3},"гор.блюдо","Каша пшенная  молочная с маслом",160,5.52,6.36,27.14,185,"311.сб.шк.2004г."]
[{"$nulls":3},"напиток","Напиток из плодов шиповника",200,0.7,0.3,29,127,"705,сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F68)","v":500},{"$f":"SUM(G63:G68)","v":24.15},{"$f":"SUM(H63:H68)","v":21.16},{"$f":"SUM(I63:I68)","v":83.94},{"$f":"SUM(J63:J68)","v":632},null,77.76]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F70:F78)","v":0},{"$f":"SUM(G70:G78)","v":0},0,0,0,null,{"$f":"SUM(L70:L78)","v":0}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F69+F79","v":500},{"$f":"G69+G79","v":24.15},21.16,83.94,632,null,{"$f":"L69+L79","v":77.76}]
[1,5,"Завтрак","гор.блюдо","Сосиски отварные с маслом сливочным",110,9.8,24.9,0.8,267,"413.сб.шк.2004г."]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая",155,8.83,5.67,38.6,260,"297,сб.шк.2004г."]
[{"$nulls":3},"напиток","Компот из компотной смеси (быст.замор.)",200,0.21,0.04,18.01,73,"123.орг.пит.шк"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F81:F87)","v":525},{"$f":"SUM(G81:G87)","v":23.070000000000004},31.81,84.71,737,null,77.76]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F89:F97)","v":0},{"$f":"SUM(G89:G97)","v":0},0,0,0,null,{"$f":"SUM(L89:L97)","v":0}]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F88+F98","v":525},{"$f":"G88+G98","v":23.070000000000004},31.81,84.71,737,null,77.76]
[1,6,"Завтрак","гор.блюдо","Плов из курицы",250,22.8,29,40.2,521,"492.сб.шк.2004г."]
[{"$nulls":3},"напиток","Компот из кураги",200,1.2,0.1,29.5,127,"638.сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F100:F106)","v":510},{"$f":"SUM(G100:G106)","v":28.23},30.3,97,785,null,77.76]
[{"$f":"A100","v":1},{"$f":"B100","v":6},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F108:F116)","v":0},{"$f":"SUM(G108:G116)","v":0},0,0,0,null,{"$f":"SUM(L108:L116)","v":0}]
[{"$f":"A100","v":1},{"$f":"B100","v":6},"Итого за день:",null,null,{"$f":"F107+F117","v":510},{"$f":"G107+G117","v":28.23},30.3,97,785,null,77.76]
[2,7,"Завтрак","прочее","Ветчина из курицы",30,4.1,2.7,0,41,"363,сб.Пермь.2008г"]
[{"$nulls":3},"прочее","Печенье сахарное",60,4.5,7.2,44.6,259,"ТК"]
[{"$nulls":3},"гор.блюдо","Каша молочная \"Дружба\" с маслом",160,6.32,8.64,33.52,240,"311сб.шк.2004г."]
[{"$nulls":3},"гор.напиток","Чай с лимоном и сахаром",200,0.2,0,9.3,38,"686.сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F119:F125)","v":510},{"$f":"SUM(G119:G125)","v":19.349999999999998},19.74,114.72,715,null,77.76]
[{"$f":"A119","v":2},{"$f":"B119","v":7},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F127:F135)","v":0},{"$f":"SUM(G127:G135)","v":0},0,0,0,null,{"$f":"SUM(L127:L135)","v":0}]
[{"$f":"A119","v":2},{"$f":"B119","v":7},"Итого за день:",null,null,{"$f":"F126+F136","v":510},{"$f":"G126+G136","v":19.349999999999998},19.74,114.72,715,null,77.76]
[2,8,"Завтрак","гор.блюдо","Ёжики из говядины с рисом в соусе томатном",110,9.2,13.5,11.6,207,"462.сб.шк.2004"]
[{"$nulls":3},"гор.блюдо","Картофельное пюре",150,3.08,4.73,20,140,"520(3).сб.шк.2004г."]
[{"$nulls":3},"напиток","Компот из компотной смеси (быст.замор.)",200,0.21,0.04,18.01,73,"123.орг.пит.шк"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F138:F144)","v":520},{"$f":"SUM(G138:G144)","v":16.72},19.47,76.91,557,null,77.76]
[{"$f":"A138","v":2},{"$f":"B138","v":8},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F146:F154)","v":0},{"$f":"SUM(G146:G154)","v":0},0,0,0,null,{"$f":"SUM(L146:L154)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":8},"Итого за день:",null,null,{"$f":"F145+F155","v":520},{"$f":"G145+G155","v":16.72},19.47,76.91,557,null,77.76]
[2,9,"Завтрак","гор.блюдо","Рыба (горбуша), тушенная в томате с овощами",120,14.24,7.04,7.52,150,"374,сб.шк.2004г."]
[{"$nulls":3},"гор.блюдо","Каша рисовая рассыпчатая",155,3.67,3.92,37.5,207,"297.сб.шк.2004г."]
[{"$nulls":3},"напиток","Компот из смеси сухофруктов",200,0.5,0.1,30.9,123,"639(3).сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F157:F163)","v":535},{"$f":"SUM(G157:G163)","v":22.64},12.26,103.21999999999998,617,null,77.76]
[{"$f":"A157","v":2},{"$f":"B157","v":9},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F173)","v":0},{"$f":"SUM(G165:G173)","v":0},0,0,0,null,{"$f":"SUM(L165:L173)","v":0}]
[{"$f":"A157","v":2},{"$f":"B157","v":9},"Итого за день:",null,null,{"$f":"F164+F174","v":535},{"$f":"G164+G174","v":22.64},12.26,103.21999999999998,617,null,{"$f":"L164+L174","v":77.76}]
[2,10,"Завтрак","прочее","Сыр порциями",30,7.4,8,0,105,"336.сб.Пермь2008г."]
[{"$nulls":3},"прочее","Яйцо вареное",50,6.3,5.3,0.5,78,"ТТК"]
[{"$nulls":3},"гор.блюдо","Каша ячневая молочная с маслом",160,5.22,6,26.8,188,"302,сб.шк.2004г."]
[{"$nulls":3},"напиток","Компот из кураги",200,1.2,0.1,29.5,127,"638.сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F176:F182)","v":500},{"$f":"SUM(G176:G182)","v":24.349999999999998},20.6,84.1,635,null,77.76]
[{"$f":"A176","v":2},{"$f":"B176","v":10},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F184:F192)","v":0},{"$f":"SUM(G184:G192)","v":0},0,0,0,null,{"$f":"SUM(L184:L192)","v":0}]
[{"$f":"A176","v":2},{"$f":"B176","v":10},"Итого за день:",null,null,{"$f":"F183+F193","v":500},{"$f":"G183+G193","v":24.349999999999998},20.6,84.1,635,null,{"$f":"L183+L193","v":77.76}]
[2,11,"Завтрак","гор.блюдо","Сосиски отварные с маслом сливочным",110,9.8,24.9,0.8,267,"413.сб.шк.2004г."]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",155,5.25,3.67,33.3,194,"332.сб.2004г."]
[{"$nulls":3},"напиток","Напиток из плодов шиповника",200,0.7,0.3,29,127,"705,сб.шк.2004г."]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F195:F201)","v":525},{"$f":"SUM(G195:G201)","v":19.98},30.07,90.39999999999999,725,null,77.76]
[{"$f":"A195","v":2},{"$f":"B195","v":11},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F203:F211)","v":0},{"$f":"SUM(G203:G211)","v":0},0,0,0,null,{"$f":"SUM(L203:L211)","v":0}]
[{"$f":"A195","v":2},{"$f":"B195","v":11},"Итого за день:",null,null,{"$f":"F202+F212","v":525},{"$f":"G202+G212","v":19.98},30.07,90.39999999999999,725,null,{"$f":"L202+L212","v":77.76}]
[2,12,"Завтрак","гор.блюдо","Каша гречневая с овощами, мясным фаршем",250,26.1,25.3,38.6,490,"443,сб.шк.2004г."]
[]
[]
[{"$nulls":3},"напиток","Компот из компотной смеси (быст.замор.)",200,0.21,0.04,18.01,73,"123.орг.пит.шк"]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,2.25,0.87,15,75,"ДеЛи принт №1050"]
[{"$nulls":3},"хлеб","Хлеб ржаной (дарницкий формовой)",30,1.98,0.33,12.3,62,"366,сб.Пермь.2008г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F214:F220)","v":510},{"$f":"SUM(G214:G220)","v":30.540000000000003},26.54,83.91,700,null,77.76]
[{"$f":"A214","v":2},{"$f":"B214","v":12},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F222:F230)","v":0},{"$f":"SUM(G222:G230)","v":0},0,0,0,null,{"$f":"SUM(L222:L230)","v":0}]
[{"$f":"A214","v":2},{"$f":"B214","v":12},"Итого за день:",null,null,{"$f":"F221+F231","v":510},{"$f":"G221+G231","v":30.540000000000003},26.54,83.91,700,null,{"$f":"L221+L231","v":77.76}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F80+F99+F118+F137+F156+F175+F194+F213+F232)/(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)+IF(F213=0,0,1)+IF(F232=0,0,1))","v":515},{"$f":"(G23+G42+G61+G80+G99+G118+G137+G156+G175+G194+G213+G232)/(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)+IF(G213=0,0,1)+IF(G232=0,0,1))","v":23.22555555555555},23.549999999999997,{"$f":"(I23+I42+I61+I80+I99+I118+I137+I156+I175+I194+I213+I232)/(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)+IF(I213=0,0,1)+IF(I232=0,0,1))","v":90.99},678.1111111111111,null,77.76]