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

{"sheet":"Лист1","index":0,"n_rows":196,"n_cols":12,"rows_kept":196,"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],[99,2,99,3],[118,2,118,3],[137,2,137,3],[156,2,156,3],[175,2,175,3],[194,2,194,3],[195,2,195,4]]}
["Школа",null,"МБОУ СОШ \"с. Урманаево\"",null,null,"Утвердил:","должность","директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Хайбуллина Г.А."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,9,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Борщ из св.капусты с картофелем, с мясными фрикадельками,со сметаной",266,{"v":4.12667,"d":"4.13"},{"v":6.95953,"d":"6.96"},{"v":11.19445,"d":"11.19"},{"v":133.421,"d":"133.42"},82]
[]
[{"$nulls":3},"гор.напиток","Кисель",200,0.6,0.1,30.2,123.6]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"напиток",{"$nulls":7},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":496},{"$f":"SUM(G6:G12)","v":6.706669999999999},7.41953,53.27445,316.42099999999994,null,{"$f":"SUM(L6:L12)","v":22.5}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска","салат из моркови с яблоком",60,0.64,0.1,5.11,23.94,59]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","котлетадомашняя из говядины",90,8.15,10.5,8.1,199.57,271]
[{"$nulls":3},"гарнир","макароны отварные с сливочным маслом",155,5.12,4.53,31.99,189.3,203]
[{"$nulls":3},"напиток","компт из сухофруктов",200,0.66,0.09,22.03,92.9,349]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","хлеб ржаной",20,1.32,0.54,17.82,89.1]
[{"$nulls":4},"печенье",40,3.7,3.7,2.85,21.5]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":565},{"$f":"SUM(G14:G22)","v":19.59},19.459999999999997,87.9,616.3100000000001,null,{"$f":"SUM(L14:L22)","v":64.19}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":1061},{"$f":"G13+G23","v":26.29667},26.879529999999995,141.17445,932.731,null,{"$f":"L13+L23","v":86.69}]
[1,2,"Завтрак","гор.блюдо","Рассольник Ленинградский с мясом птицы, со сметаной ",265,{"v":2.4074999999999998,"d":"2.41"},7.34,12.52,131.55]
[]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок",200,{"v":0.16000000000000003,"d":"0.16"},{"v":0.16000000000000003,"d":"0.16"},13.91,58.74,342]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F25:F31)","v":495},{"$f":"SUM(G25:G31)","v":4.547499999999999},{"$f":"SUM(H25:H31)","v":7.86},{"$f":"SUM(I25:I31)","v":38.31},{"$f":"SUM(J25:J31)","v":249.69000000000003},null,22.5]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска","Плоды и ягоды свежие (апельсин)",100,0.8,{"v":0.2,"d":"0.20"},{"v":8.05,"d":"8.1"},{"v":43,"d":"43.0"}]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Гуляш из говядины","100",10.45,10.71,9.83,144.26,260]
[{"$nulls":3},"гарнир","Каша гречневая рассыпчатая с маслом сливочным",153,4.59,5.47,27.76,{"v":193.8,"d":"193.80"},171]
[{"$nulls":3},"напиток","Чай с сахаром, с лимоном ",200,0.13,0.02,{"v":10.2,"d":"10.20"},{"v":42,"d":"42.00"},377]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,{"v":0.5399999999999999,"d":"0.54"},17.82,{"v":89.09999999999998,"d":"89.10"}]
[{"$nulls":4},"Пряник",35,2.07,1.85,14.25,104.1]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":508},{"$f":"SUM(G33:G41)","v":19.36},{"$f":"SUM(H33:H41)","v":18.79},{"$f":"SUM(I33:I41)","v":87.91},{"$f":"SUM(J33:J41)","v":616.26},null,64.19]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":1003},{"$f":"G32+G42","v":23.9075},{"$f":"H32+H42","v":26.65},{"$f":"I32+I42","v":126.22},{"$f":"J32+J42","v":865.95},null,86.69]
[1,3,"Завтрак","гор.блюдо","Суп картофельный с горохом с мясными фрикадельками",261,{"v":7.68417,"d":"7.68"},{"v":6.55953,"d":"6.56"},{"v":16.61695,"d":"16.62"},{"v":169.821,"d":"169.82"},119]
[]
[{"$nulls":3},"гор.напиток","Напиток из сухофруктов",200,{"v":0.662,"d":"0.66"},{"v":0.09000000000000001,"d":"0.09"},22.03,{"v":92.9,"d":"92.90"},348]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":491},{"$f":"SUM(G44:G50)","v":10.326170000000001},{"$f":"SUM(H44:H50)","v":7.00953},{"$f":"SUM(I44:I50)","v":50.52695000000001},{"$f":"SUM(J44:J50)","v":322.121},null,22.5]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска","Салат из отварной свеклы",60,{"v":0.8448,"d":"0.84"},{"v":3.6071999999999997,"d":"3.61"},{"v":4.9559999999999995,"d":"4.96"},55.68]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Птица запеченная с томатным соусом",110,{"v":12.0024,"d":"12.00"},{"v":10.6406,"d":"10.64"},{"v":8.6036,"d":"8.60"},{"v":195.1,"d":"195.10"},293]
[{"$nulls":3},"гарнир","Рис отварной рассыпчатый с маслом сливочным",155,3.74,4.15,39.23,{"v":209,"d":"209.00"}]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,{"v":10,"d":"10.00"},{"v":40,"d":"40.00"},376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":1.5199999999999998,"d":"1.520"},{"v":0.15999999999999998,"d":"0.160"},{"v":9.839999999999998,"d":"9.840"},47]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,{"v":7.920000000000001,"d":"7.92"},{"v":39.6,"d":"39.60"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":565},{"$f":"SUM(G52:G60)","v":19.4972},{"$f":"SUM(H52:H60)","v":18.817799999999995},{"$f":"SUM(I52:I60)","v":80.5496},{"$f":"SUM(J52:J60)","v":586.38},null,64.19]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":1056},{"$f":"G51+G61","v":29.82337},{"$f":"H51+H61","v":25.827329999999996},{"$f":"I51+I61","v":131.07655},{"$f":"J51+J61","v":908.501},null,86.69]
[1,4,"Завтрак","гор.блюдо","Суп из овощей с мясными фрикадельками, со сметаной",266,4.65,7.61,{"v":9.3,"d":"9.30"},132.98,99]
[]
[{"$nulls":3},"гор.напиток","Компот из цитрусов",200,0.45,{"v":0.1,"d":"0.10"},33.99,{"v":141.2,"d":"141.20"},346]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":496},{"$f":"SUM(G63:G69)","v":7.08},{"$f":"SUM(H63:H69)","v":8.07},{"$f":"SUM(I63:I69)","v":55.17000000000001},{"$f":"SUM(J63:J69)","v":333.5799999999999},null,22.5]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска","Салат из белокочанной капусты",60,{"v":0.7872,"d":"0.79"},{"v":1.9494,"d":"1.95"},{"v":3.8795999999999995,"d":"3.88"},36.24,45]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Рыба, тушеная в томате с овощами","100",9.15,5.62,{"v":7.8,"d":"7.80"},{"v":105,"d":"105.00"},229]
[{"$nulls":3},"гарнир","Пюре картофельное  ",180,{"$f":"G73*180/155","v":{"v":10.625806451612902,"d":"10.63"}},{"$f":"H73*180/155","v":{"v":6.526451612903226,"d":"6.53"}},{"v":9.058064516129033,"d":"9.06"},{"v":121.93548387096774,"d":"121.94"},312]
[{"$nulls":3},"напиток","Компот из свежих яблок ",200,{"v":0.16000000000000003,"d":"0.16"},{"v":0.16000000000000003,"d":"0.16"},13.91,58.74,342]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":1.5199999999999998,"d":"1.52"},{"v":0.15999999999999998,"d":"0.16"},{"v":9.839999999999998,"d":"9.84"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,{"v":7.920000000000001,"d":"7.92"},{"v":39.6,"d":"39.60"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":480},{"$f":"SUM(G71:G79)","v":23.563006451612903},{"$f":"SUM(H71:H79)","v":14.655851612903225},{"$f":"SUM(I71:I79)","v":52.407664516129024},{"$f":"SUM(J71:J79)","v":408.5154838709678},null,64.19]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":976},{"$f":"G70+G80","v":30.643006451612905},{"$f":"H70+H80","v":22.725851612903227},{"$f":"I70+I80","v":107.57766451612903},{"$f":"J70+J80","v":742.0954838709677},null,86.69]
[1,5,"Завтрак","гор.блюдо","Суп картофельный с мясом птицы",260,{"v":5.422499999999999,"d":"5.42"},{"v":3.3875,"d":"3.39"},16.87,{"v":130.8,"d":"130.80"},97]
[]
[{"$nulls":3},"гор.напиток","Кисель",200,{"v":0.6,"d":"0.60"},{"v":0.1,"d":"0.10"},{"v":30.2,"d":"30.20"},{"v":123.6,"d":"123.60"}]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":490},{"$f":"SUM(G82:G88)","v":8.0025},{"$f":"SUM(H82:H88)","v":3.8475},{"$f":"SUM(I82:I88)","v":58.95},{"$f":"SUM(J82:J88)","v":313.8},null,22.5]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска","Салат из моркови с сахаром",60,{"v":0.7398,"d":"0.74"},{"v":0.05639999999999999,"d":"0.06"},6.58,{"v":49.019999999999996,"d":"49.02"},62]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Котлеты говяжьи в томатном соусе",100,9.54,{"v":12.9,"d":"12.90"},8.75,{"v":189,"d":"189.00"},271]
[{"$nulls":3},"гарнир","Гороховое пюре ",180,{"$f":"G92*180/153","v":{"v":11.223529411764705,"d":"11.22"}},{"$f":"H92*180/153","v":{"v":15.176470588235293,"d":"15.18"}},{"v":10.294117647058824,"d":"10.29"},{"v":222.35294117647058,"d":"222.35"},199]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,{"v":10,"d":"10.00"},{"v":40,"d":"40.00"},376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":1.5199999999999998,"d":"1.52"},{"v":0.15999999999999998,"d":"0.16"},{"v":9.839999999999998,"d":"9.84"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,{"v":7.920000000000001,"d":"7.92"},{"v":39.6,"d":"39.60"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F98)","v":580},{"$f":"SUM(G90:G98)","v":24.413329411764703},{"$f":"SUM(H90:H98)","v":28.55287058823529},{"$f":"SUM(I90:I98)","v":53.38411764705882},{"$f":"SUM(J90:J98)","v":586.9729411764706},null,64.19]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":1070},{"$f":"G89+G99","v":32.415829411764705},{"$f":"H89+H99","v":32.40037058823529},{"$f":"I89+I99","v":112.33411764705883},{"$f":"J89+J99","v":900.7729411764706},null,86.69]
[2,1,"Завтрак","гор.блюдо","Щи из свежей капусты с картофелем с мясными фрикадельками сметаной",266,{"v":4.08917,"d":"4.09"},{"v":6.98953,"d":"6.99"},{"v":8.16445,"d":"8.16"},{"v":119.42099999999999,"d":"119.42"},88]
[]
[{"$nulls":3},"гор.напиток","Напиток из изюма",200,0.44,0.02,27.76,{"v":113,"d":"113.00"},394]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":496},{"$f":"SUM(G101:G107)","v":6.509170000000001},7.36953,47.80445,291.82099999999997,null,{"$f":"SUM(L101:L107)","v":22.5}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Обед","закуска","Плоды и ягоды свежие (яблоки)",100,0.4,{"v":0.4,"d":"0.40"},9.8,{"v":47,"d":"47.0"}]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Птица запеченная","100",9.87,17.72,{"v":0,"d":"0.00"},{"v":210.4,"d":"210.40"},293]
[{"$nulls":3},"гарнир","Макаронные изделия отварные с маслом сливочным","183",{"v":6.1,"d":"6.10"},{"v":3.4,"d":"3.40"},38.22,{"v":222.6,"d":"222.60"},203]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,{"v":10,"d":"10.00"},{"v":40,"d":"40.00"},376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":1.5199999999999998,"d":"1.52"},{"v":0.15999999999999998,"d":"0.16"},{"v":9.839999999999998,"d":"9.84"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,{"v":7.920000000000001,"d":"7.92"},{"v":39.6,"d":"39.60"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":340},{"$f":"SUM(G109:G117)","v":19.279999999999998},21.939999999999994,75.78,606.6,null,{"$f":"SUM(L109:L117)","v":64.19}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Итого за день:",null,null,{"$f":"F108+F118","v":836},{"$f":"G108+G118","v":25.78917},{"$f":"H108+H118","v":29.309529999999995},{"$f":"I108+I118","v":123.58445},{"$f":"J108+J118","v":898.421},null,86.69]
[2,2,"Завтрак","гор.блюдо","Суп картофельный с вермишелью с мясом птицы",260,5.59,7.86,16.71,159.32,117]
[]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок",200,{"v":0.16000000000000003,"d":"0.16"},{"v":0.16000000000000003,"d":"0.16"},13.91,58.74,342]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":490},{"$f":"SUM(G120:G126)","v":7.73},8.379999999999999,42.5,277.46,null,{"$f":"SUM(L120:L126)","v":22.5}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Обед","закуска","Салат из свежей капусты с морковью",60,{"v":0.7871999999999999,"d":"0.79"},{"v":1.9494,"d":"1.95"},{"v":3.8795999999999995,"d":"3.88"},36.24,45]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Плов из говядины с рисом",250,{"v":18.971666666666664,"d":"18.97"},20.36,54.79,509.83,265]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Чай с сахаром,с яблоком",200,0.11,0.06,10.99,45.05,376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":1.5199999999999998,"d":"1.52"},{"v":0.15999999999999998,"d":"0.16"},{"v":9.839999999999998,"d":"9.84"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",25,{"v":1.6500000000000001,"d":"1.65"},{"v":0.3,"d":"0.30"},{"v":9.9,"d":"9.90"},{"v":49.5,"d":"49.50"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":555},{"$f":"SUM(G128:G136)","v":23.03886666666666},22.8294,89.3996,687.6199999999999,null,{"$f":"SUM(L128:L136)","v":64.19}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Итого за день:",null,null,{"$f":"F127+F137","v":1045},{"$f":"G127+G137","v":30.76886666666666},{"$f":"H127+H137","v":31.2094},{"$f":"I127+I137","v":131.89960000000002},{"$f":"J127+J137","v":965.0799999999999},null,86.69]
[2,3,"Завтрак","гор.блюдо","Рассольник Ленинградский с мясом птицы, со сметаной ",265,{"v":5.6,"d":"5.60"},9.06,11.98,157.42,96]
[]
[{"$nulls":3},"гор.напиток","Напиток из сухофруктов",200,{"v":0.662,"d":"0.66"},{"v":0.09000000000000001,"d":"0.09"},22.03,{"v":92.9,"d":"92.90"}]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F145)","v":495},{"$f":"SUM(G139:G145)","v":8.241999999999999},9.51,45.89000000000001,309.71999999999997,null,{"$f":"SUM(L139:L145)","v":22.5}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Обед","закуска","Салат из свеклы отварной",60,{"v":0.8448,"d":"0.84"},{"v":3.6071999999999997,"d":"3.61"},{"v":4.9559999999999995,"d":"4.96"},55.68,52]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Котлеты из мяса кур в томатном соусе с овощами","100",10.52,6.75,{"v":21.9,"d":"21.90"},{"v":182.9,"d":"182.90"},295]
[{"$nulls":3},"гарнир","Пюре картофельное",180,{"v":3.6774,"d":"3.68"},{"v":5.761799999999999,"d":"5.76"},{"v":20.5268,"d":"20.53"},{"v":154.7,"d":"154.70"},312]
[{"$nulls":3},"напиток","Чай с сахаром",200,0.07,0.02,{"v":10,"d":"10.00"},{"v":40,"d":"40.00"},376]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":1.5199999999999998,"d":"1.52"},{"v":0.15999999999999998,"d":"0.16"},{"v":9.839999999999998,"d":"9.84"},{"v":47,"d":"47.00"}]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,{"v":7.920000000000001,"d":"7.92"},{"v":39.6,"d":"39.60"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F155)","v":480},{"$f":"SUM(G147:G155)","v":17.9522},16.538999999999998,75.14280000000001,519.88,null,{"$f":"SUM(L147:L155)","v":64.19}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Итого за день:",null,null,{"$f":"F146+F156","v":975},{"$f":"G146+G156","v":26.194200000000002},{"$f":"H146+H156","v":26.049},{"$f":"I146+I156","v":121.03280000000001},{"$f":"J146+J156","v":829.5999999999999},null,86.69]
[2,4,"Завтрак","гор.блюдо","Суп картофельный с мясными фрикадельками",261,{"v":4.53667,"d":"4.54"},{"v":4.11703,"d":"4.12"},{"v":16.95195,"d":"16.95"},{"v":135.571,"d":"135.57"},105]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром и лимоном",200,0.13,0.02,10.2,{"v":42,"d":"42.00"},377]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F158:F164)","v":491},{"$f":"SUM(G158:G164)","v":6.64667},4.49703,39.03195,236.971,null,{"$f":"SUM(L158:L164)","v":22.5}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Обед","закуска","Плоды и ягоды свежие (яблоки)",100,0.4,{"v":0.4,"d":"0.40"},9.8,{"v":47,"d":"47.0"}]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Тефтели мясные в сметанно-томатном соусе",100,{"v":7.2838,"d":"7.28"},{"v":11.7904,"d":"11.79"},{"v":8.7376,"d":"8.74"},123.99,279]
[{"$nulls":3},"гарнир","Макаронные изделия отварные ","180",{"$f":"G168*180/183","v":{"v":7.164393442622951,"d":"7.16"}},{"$f":"H168*180/183","v":{"v":11.59711475409836,"d":"11.60"}},{"v":8.594360655737706,"d":"8.59"},{"v":121.95737704918034,"d":"121.96"},203]
[{"$nulls":3},"напиток","Напиток из шиповника",200,{"v":0.678,"d":"0.68"},{"v":0.27799999999999997,"d":"0.28"},{"v":10.780000000000001,"d":"10.78"},{"v":48.2,"d":"48.20"},388]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",20,{"v":2.6599999999999997,"d":"2.66"},{"v":0.27999999999999997,"d":"0.28"},{"v":17.219999999999995,"d":"17.22"},82.25]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,{"v":2.3100000000000005,"d":"2.31"},0.42,{"v":13.860000000000001,"d":"13.86"},{"v":69.3,"d":"69.30"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F174)","v":440},{"$f":"SUM(G166:G174)","v":20.496193442622953},24.765514754098362,68.9919606557377,492.6973770491803,null,{"$f":"SUM(L166:L174)","v":64.19}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Итого за день:",null,null,{"$f":"F165+F175","v":931},{"$f":"G165+G175","v":27.142863442622954},{"$f":"H165+H175","v":29.26254475409836},{"$f":"I165+I175","v":108.0239106557377},{"$f":"J165+J175","v":729.6683770491803},null,86.69]
[2,5,"Завтрак","гор.блюдо","Суп-лапша домашняя с мясом птицы",260,{"v":5.645,"d":"5.65"},{"v":6.102500000000001,"d":"6.10"},11.62,132.55]
[]
[{"$nulls":3},"гор.напиток","Сок (нектар) разливной",200,{"v":1,"d":"1.00"},{"v":0,"d":"0.00"},{"v":20.2,"d":"20.20"},{"v":84.8,"d":"84.80"}]
[{"$nulls":3},"хлеб","Хлеб ржаной",30,1.98,0.36,11.88,{"v":59.4,"d":"59.40"}]
[{"$nulls":3},"фрукты"]
[]
[{"$nulls":11},22.5]
[{"$nulls":3},"итого",null,{"$f":"SUM(F177:F183)","v":490},{"$f":"SUM(G177:G183)","v":8.625},6.462500000000001,43.7,276.75,null,{"$f":"SUM(L177:L183)","v":22.5}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Обед","закуска","Бутерброд с маслом сливочным и сыром",60,{"v":7.029999999999999,"d":"7.03"},7.94,19.75,{"v":178.5,"d":"178.50"},3]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир","Овощи тушеные с мясным фаршем","250",12.33,{"v":13.275,"d":"13.28"},46.58,346.67]
[{"$nulls":3},"напиток","Чай \"Витаминный\" ",200,0.24000000000000002,0.09000000000000001,{"v":12,"d":"12.000"},{"v":54.2,"d":"54"}]
[{"$nulls":3},"хлеб бел.","Печенье",40,1.7,3.7,2.85,21.5]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",20,1.32,0.24,{"v":7.920000000000001,"d":"7.92"},{"v":39.6,"d":"39.60"}]
[]
[{"$nulls":11},64.19]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":320},{"$f":"SUM(G185:G193)","v":22.619999999999997},25.244999999999997,89.1,640.4700000000001,null,{"$f":"SUM(L185:L193)","v":64.19}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Итого за день:",null,null,{"$f":"F184+F194","v":810},{"$f":"G184+G194","v":31.244999999999997},{"$f":"H184+H194","v":31.7075},{"$f":"I184+I194","v":132.8},{"$f":"J184+J194","v":917.2200000000001},null,86.69]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F100+F119+F138+F157+F176+F195)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F81=0,0,1)+IF(F100=0,0,1)+IF(F119=0,0,1)+IF(F138=0,0,1)+IF(F157=0,0,1)+IF(F176=0,0,1)+IF(F195=0,0,1))","v":976.3},{"$f":"(G24+G43+G62+G81+G100+G119+G138+G157+G176+G195)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G81=0,0,1)+IF(G100=0,0,1)+IF(G119=0,0,1)+IF(G138=0,0,1)+IF(G157=0,0,1)+IF(G176=0,0,1)+IF(G195=0,0,1))","v":28.422647597266725},28.202105695523688,123.57235428189253,869.0039802096617,null,{"$f":"(L24+L43+L62+L81+L100+L119+L138+L157+L176+L195)/(IF(L24=0,0,1)+IF(L43=0,0,1)+IF(L62=0,0,1)+IF(L81=0,0,1)+IF(L100=0,0,1)+IF(L119=0,0,1)+IF(L138=0,0,1)+IF(L157=0,0,1)+IF(L176=0,0,1)+IF(L195=0,0,1))","v":86.69000000000001}]