{"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":387,"n_cols":12,"rows_kept":387,"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],[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],[214,2,214,3],[233,2,233,3],[252,2,252,3],[271,2,271,3],[290,2,290,3],[309,2,309,3],[328,2,328,3],[347,2,347,3],[366,2,366,3],[385,2,385,3],[386,2,386,4]]}
["Школа",null,"МАОУ Тисульская СОШ №1",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Рундау Н.Н."]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",22,12,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F6:F12)","v":0},{"$f":"SUM(G6:G12)","v":0},0,0,0,null,{"$f":"SUM(L6:L12)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","фрукт","Фрукт в ассортименте (яблоко)",150,0.6,0.6,14.7,70.5,24,31.5]
[null,null,null,"1 блюдо","Щи с мясом и сметаной",200,6,6.28,7.12,109.74,30,20]
[null,null,null,"2 блюдо","Плов с мясом и куркумой",250,25.58,32.45,37.43,544.85,350,64.03]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Компот из сухофруктов",200,0.37,0,14.85,59.48,98,3.64]
[null,null,null,"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47,119,1.35]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F14:F22)","v":840},{"$f":"SUM(G14:G22)","v":35.39},39.73,91.98,871.17,null,{"$f":"SUM(L14:L22)","v":122.19}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":840},{"$f":"G13+G23","v":35.39},39.73,91.98,871.17,null,{"$f":"L13+L23","v":122.19}]
[1,2,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F25:F31)","v":0},{"$f":"SUM(G25:G31)","v":0},{"$f":"SUM(H25:H31)","v":0},{"$f":"SUM(I25:I31)","v":0},{"$f":"SUM(J25:J31)","v":0},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска","Маринад из моркови",60,1.12,4.27,6.02,68.62,13,6.22]
[null,null,null,"1 блюдо","Суп рыбный с крупой",200,5,8.6,12.6,147.8,36,23.45]
[null,null,null,"2 блюдо","Чахохбили",90,21.52,19.57,2.45,270.77,150,53.02]
[null,null,null,"гарнир","Картофель отварной с маслом и зеленью",150,3.33,3.81,26.04,151.12,51,13.82]
[null,null,null,"напиток","Компот из смеси фруктов и ягод",200,0.25,0,12.73,51.3,216,10.1]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40,3.04,0.32,19.68,94,119,2.71]
[null,null,null,"хлеб черн.","Хлеб ржаной",30,1.98,0.36,12.06,59.4,120,2.5]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F33:F41)","v":770},{"$f":"SUM(G33:G41)","v":36.24},{"$f":"SUM(H33:H41)","v":36.93},{"$f":"SUM(I33:I41)","v":91.58},{"$f":"SUM(J33:J41)","v":843.01},null,111.82]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":770},{"$f":"G32+G42","v":36.24},{"$f":"H32+H42","v":36.93},{"$f":"I32+I42","v":91.58},{"$f":"J32+J42","v":843.01},null,111.82]
[1,3,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F44:F50)","v":0},{"$f":"SUM(G44:G50)","v":0},{"$f":"SUM(H44:H50)","v":0},{"$f":"SUM(I44:I50)","v":0},{"$f":"SUM(J44:J50)","v":0},null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","закуска","Горошек консервированный",60,1.86,0.12,4.26,24.6,172,22.73]
[null,null,null,"1 блюдо","Свекольник с мясом и сметаной",200,5.89,8.82,9.6,142.2,32,22.89]
[null,null,null,"2 блюдо","Филе птицы в кисло-сладком соусе",90,13.94,16.18,5.21,224.21,269,33.36]
[null,null,null,"гарнир","Макароны отварные с маслом",150,6.76,3.93,41.29,227.48,64,9.97]
[null,null,null,"напиток","Чай с сахаром",200,0,0,7.27,28.73,114,1.46]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F52:F60)","v":750},{"$f":"SUM(G52:G60)","v":32.05},{"$f":"SUM(H52:H60)","v":29.53},{"$f":"SUM(I52:I60)","v":90.43},{"$f":"SUM(J52:J60)","v":757.32},null,94.11]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":750},{"$f":"G51+G61","v":32.05},{"$f":"H51+H61","v":29.53},{"$f":"I51+I61","v":90.43},{"$f":"J51+J61","v":757.32},null,94.11]
[1,4,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F63:F69)","v":0},{"$f":"SUM(G63:G69)","v":0},{"$f":"SUM(H63:H69)","v":0},{"$f":"SUM(I63:I69)","v":0},{"$f":"SUM(J63:J69)","v":0},null,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","фрукт","Фрукт в ассортименте (мандарин)",100,0.8,0.2,7.5,38,137,32]
[null,null,null,"1 блюдо","Суп овощной с мясом и сметаной",200,6.03,6.38,11.17,126.47,138,18.24]
[null,null,null,"2 блюдо","Котлета мясная \"Лукоморье\"",90,17.25,14.98,7.87,235.78,152,49.95]
[null,null,null,"гарнир","Каша гречневая рассыпчатая с маслом",150,7.26,4.96,31.76,198.84,54,12.66]
[null,null,null,"напиток","Сок фруктовый",200,1,0.2,20.2,92,107,14.4]
[null,null,null,"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47,119,1.35]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F71:F79)","v":780},{"$f":"SUM(G71:G79)","v":35.18},{"$f":"SUM(H71:H79)","v":27.12},{"$f":"SUM(I71:I79)","v":96.38},{"$f":"SUM(J71:J79)","v":777.69},null,130.27]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":780},{"$f":"G70+G80","v":35.18},{"$f":"H70+H80","v":27.12},{"$f":"I70+I80","v":96.38},{"$f":"J70+J80","v":777.69},null,130.27]
[1,5,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F82:F88)","v":0},{"$f":"SUM(G82:G88)","v":0},{"$f":"SUM(H82:H88)","v":0},{"$f":"SUM(I82:I88)","v":0},{"$f":"SUM(J82:J88)","v":0},null,0]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","фрукт","Фрукт в ассортименте (груша)",150,0.6,0.6,14.7,70.5,25,48]
[null,null,null,"1 блюдо","Суп картофельный с мясом",200,5.78,5.5,10.8,115.7,37,15.22]
[null,null,null,"2 блюдо","Рыба тушенная с овощами",90,12.63,1.66,4.39,81.67,75,37.47]
[null,null,null,"гарнир","Рис отварной с маслом",150,3.34,4.91,33.93,191.49,53,15.02]
[null,null,null,"напиток","Напиток плодово-ягодный витаминизированный",200,0,0,14.16,55.48,104,9.1]
[null,null,null,"хлеб бел.","Хлеб пшеничный",45,3.42,0.36,22.14,105.75,119,3.05]
[null,null,null,"хлеб черн.","Хлеб ржаной",45,2.97,0.54,18.09,89.1,120,3.75]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F90:F98)","v":880},{"$f":"SUM(G90:G98)","v":28.74},{"$f":"SUM(H90:H98)","v":13.57},{"$f":"SUM(I90:I98)","v":118.21},{"$f":"SUM(J90:J98)","v":709.69},null,131.61]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":880},{"$f":"G89+G99","v":28.74},{"$f":"H89+H99","v":13.57},{"$f":"I89+I99","v":118.21},{"$f":"J89+J99","v":709.69},null,131.61]
[2,1,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F101:F107)","v":0},{"$f":"SUM(G101:G107)","v":0},0,0,0]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Обед","фрукт","Фрукт в ассортименте (яблоко)",150,0.6,0.6,14.7,70.5,24,31.5]
[null,null,null,"1 блюдо","Суп куриный с яичной лапшой",200,5.26,4.82,10.69,107.93,310,18.15]
[null,null,null,"2 блюдо","Гуляш",90,16.56,15.75,2.84,219.6,89,63.69]
[null,null,null,"гарнир","Булгур отварной с маслом",150,5.77,5.05,34.26,194,209,18.18]
[null,null,null,"напиток","Компот из смеси фруктов и ягод",200,0.25,0,12.73,51.3,216,10.1]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F109:F117)","v":840},{"$f":"SUM(G109:G117)","v":32.04},26.7,98.02,753.43,null,{"$f":"SUM(L109:L117)","v":145.32}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Итого за день:",null,null,{"$f":"F108+F118","v":840},{"$f":"G108+G118","v":32.04},{"$f":"H108+H118","v":26.7},{"$f":"I108+I118","v":98.02},{"$f":"J108+J118","v":753.43},null,145.32]
[2,2,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F120:F126)","v":0},{"$f":"SUM(G120:G126)","v":0},0,0,0,null,{"$f":"SUM(L120:L126)","v":0}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Обед","фрукт","Фрукт в ассортименте (мандарин)",100,0.8,0.2,7.5,38,137,32]
[null,null,null,"1 блюдо","Щи вегетарианские со сметаной",200,1.7,2.78,7.17,61.44,212,8.4]
[null,null,null,"2 блюдо","Печень по-строгановски",90,13.81,7.8,7.21,154.13,85,41.03]
[null,null,null,"гарнир","Макароны отварные с маслом",150,6.76,3.93,41.29,227.48,64,9.97]
[null,null,null,"напиток","Кисель витаминизированный плодово-ягодный",200,0,0,20.05,80.5,95,9.73]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40,3.04,0.32,19.68,94,119,2.71]
[null,null,null,"хлеб черн.","Хлеб ржаной",30,1.98,0.36,12.06,59.4,120,2.5]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F128:F136)","v":810},{"$f":"SUM(G128:G136)","v":28.09},15.39,114.96,714.95,null,{"$f":"SUM(L128:L136)","v":106.34}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Итого за день:",null,null,{"$f":"F127+F137","v":810},{"$f":"G127+G137","v":28.09},{"$f":"H127+H137","v":15.39},{"$f":"I127+I137","v":114.96},{"$f":"J127+J137","v":714.95},null,106.34]
[2,3,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F139:F145)","v":0},{"$f":"SUM(G139:G145)","v":0},0,0,0,null,{"$f":"SUM(L139:L145)","v":0}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Обед","закуска","Горошек консервированный",60,1.86,0.12,4.26,24.6,172,22.73]
[null,null,null,"1 блюдо","Свекольник с мясом и сметаной",200,7.2,6.4,8,117.6,32,22.9]
[null,null,null,"2 блюдо","Жаркое с мясом",240,16.23,16.41,24.59,313.35,86,61.56]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Сок фруктовый",200,0.8,0.2,23.2,94.4,107,14.4]
[null,null,null,"хлеб бел.","Хлеб пшеничный",35,2.48,0.24,15.47,84,119,2.37]
[null,null,null,"хлеб черн.","Хлеб ржаной",30,1.71,0.33,11.16,54.39,120,2.5]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F147:F155)","v":765},{"$f":"SUM(G147:G155)","v":30.28},23.7,86.68,688.34,null,{"$f":"SUM(L147:L155)","v":126.46}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Итого за день:",null,null,{"$f":"F146+F156","v":765},{"$f":"G146+G156","v":30.28},{"$f":"H146+H156","v":23.7},{"$f":"I146+I156","v":86.68},{"$f":"J146+J156","v":688.34},null,126.46]
[2,4,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F158:F164)","v":0},{"$f":"SUM(G158:G164)","v":0},0,0,0,null,{"$f":"SUM(L158:L164)","v":0}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Обед","закуска","Икра овощная",60,1.02,7.98,3.06,88.8,135,12.14]
[null,null,null,"1 блюдо","Суп гороховый с мясом",200,9.19,5.64,13.63,141.18,34,14.82]
[null,null,null,"2 блюдо","Биточек из птицы золотистый",90,20.98,20.44,4.61,289.63,337,54.94]
[null,null,null,"гарнир","Каша гречневая рассыпчатая с маслом",150,7.26,4.96,31.76,198.84,54,12.66]
[null,null,null,"напиток","Компот из сухофруктов",200,0.37,0,14.85,59.48,98,3.64]
[null,null,null,"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47,119,1.35]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F166:F174)","v":740},{"$f":"SUM(G166:G174)","v":41.66},39.42,85.79,864.53,null,{"$f":"SUM(L166:L174)","v":101.22}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Итого за день:",null,null,{"$f":"F165+F175","v":740},{"$f":"G165+G175","v":41.66},{"$f":"H165+H175","v":39.42},{"$f":"I165+I175","v":85.79},{"$f":"J165+J175","v":864.53},null,101.22]
[2,5,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F177:F183)","v":0},{"$f":"SUM(G177:G183)","v":0},0,0,0,null,{"$f":"SUM(L177:L183)","v":0}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Обед","фрукт","Фрукт в ассортименте (яблоко)",150,0.6,0.6,14.7,70.5,24,48]
[null,null,null,"1 блюдо","Борщ с мясом и сметаной",200,5.75,8.79,8.75,138.04,31,23.22]
[null,null,null,"2 блюдо","Рыба запеченная с сыром",90,18.5,3.73,2.51,116.1,146,54.66]
[null,null,null,"гарнир","Картофельное пюре с маслом",150,3.28,7.81,21.57,170.22,50,19.22]
[null,null,null,"напиток","Чай с сахаром",200,0,0,7.27,28.73,114,1.46]
[null,null,null,"хлеб бел.","Хлеб пшеничный",60,4.66,0.48,29.52,141,119,4.06]
[null,null,null,"хлеб черн.","Хлеб ржаной",50,3.3,0.6,20.1,99,120,4.17]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F185:F193)","v":900},{"$f":"SUM(G185:G193)","v":36.09},22.01,104.42,763.59,null,{"$f":"SUM(L185:L193)","v":154.79}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Итого за день:",null,null,{"$f":"F184+F194","v":900},{"$f":"G184+G194","v":36.09},{"$f":"H184+H194","v":22.01},{"$f":"I184+I194","v":104.42},{"$f":"J184+J194","v":763.59},null,154.79]
[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":807.5},{"$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":33.576},27.41,97.845,774.372,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":122.413}]
[3,1,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F197:F203)","v":0},{"$f":"SUM(G197:G203)","v":0},0,0,0,null,{"$f":"SUM(L197:L203)","v":0}]
[{"$f":"A197","v":3},{"$f":"B197","v":1},"Обед","фрукт","Фрукт в ассортименте (яблоко)",150,0.6,0.6,14.7,70.5,24,31.5]
[null,null,null,"1 блюдо","Суп картофельный с фасолью",200,6.66,5.51,8.75,111.57,41,15.87]
[null,null,null,"2 блюдо","Плов с курицей",250,26.38,24.6,39.97,485.84,79,63.27]
[null,null,null,"гарнир"]
[null,null,null,"напиток","Компот из сухофруктов",200,0.37,0,14.85,59.48,98,3.64]
[null,null,null,"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47,119,1.35]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F205:F213)","v":840},{"$f":"SUM(G205:G213)","v":36.85},31.11,96.15,813.99,null,{"$f":"SUM(L205:L213)","v":117.3}]
[{"$f":"A197","v":3},{"$f":"B197","v":1},"Итого за день:",null,null,{"$f":"F204+F214","v":840},{"$f":"G204+G214","v":36.85},31.11,96.15,813.99,null,{"$f":"L204+L214","v":117.3}]
[3,2,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F216:F222)","v":0},{"$f":"SUM(G216:G222)","v":0},0,0,0,null,{"$f":"SUM(L216:L222)","v":0}]
[{"$f":"A216","v":3},{"$f":"B216","v":2},"Обед","фрукт","Фрукт в ассортименте (мандарин)",100,0.8,0.2,7.5,38,137,32]
[null,null,null,"1 блюдо","Борщ с мясом и сметаной",200,5.75,8.79,8.75,138.04,31,23.22]
[null,null,null,"2 блюдо","Курица запеченная с соусом и зеленью",90,24.03,19.83,1.61,279.17,270,35.7]
[null,null,null,"гарнир","Макароны отварные с маслом",150,6.76,3.93,41.29,227.48,64,9.97]
[null,null,null,"напиток","Компот из смеси фруктов и ягод",200,0.25,0,12.73,51.3,216,10.1]
[null,null,null,"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47,119,1.35]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F224:F232)","v":780},{"$f":"SUM(G224:G232)","v":40.43},33.15,89.76,820.59,null,{"$f":"SUM(L224:L232)","v":114.01}]
[{"$f":"A216","v":3},{"$f":"B216","v":2},"Итого за день:",null,null,{"$f":"F223+F233","v":780},{"$f":"G223+G233","v":40.43},33.15,89.76,820.59,null,{"$f":"L223+L233","v":114.01}]
[3,3,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F235:F241)","v":0},{"$f":"SUM(G235:G241)","v":0},0,0,0,null,{"$f":"SUM(L235:L241)","v":0}]
[{"$f":"A235","v":3},{"$f":"B235","v":3},"Обед","закуска","Икра свекольная",60,1.29,4.27,6.97,72.75,9,6.22]
[null,null,null,"1 блюдо","Щи с мясом и сметаной",200,6,6.27,7.12,109.75,30,20.02]
[null,null,null,"2 блюдо","Рыба запеченная с помидорами и сыром",90,18.61,5.33,2.89,133.04,182,57.15]
[null,null,null,"гарнир","Картофельное пюре с маслом",150,3.28,7.81,21.57,170.22,50,19.22]
[null,null,null,"напиток","Сок фруктовый",200,0.6,0.2,23.6,104,107,14.4]
[null,null,null,"хлеб бел.","Хлеб пшеничный",45,3.42,0.36,22.14,105.75,119,3.05]
[null,null,null,"хлеб черн.","Хлеб ржаной",45,2.97,0.54,18.09,89.1,120,3.75]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F243:F251)","v":790},{"$f":"SUM(G243:G251)","v":36.17},24.78,102.38,784.61,null,{"$f":"SUM(L243:L251)","v":123.81}]
[{"$f":"A235","v":3},{"$f":"B235","v":3},"Итого за день:",null,null,{"$f":"F242+F252","v":790},{"$f":"G242+G252","v":36.17},24.78,102.38,784.61,null,{"$f":"L242+L252","v":123.81}]
[3,4,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F254:F260)","v":0},{"$f":"SUM(G254:G260)","v":0},0,0,0,null,{"$f":"SUM(L254:L260)","v":0}]
[{"$f":"A254","v":3},{"$f":"B254","v":4},"Обед","фрукт","Фрукт в ассортименте (груша)",150,0.6,0.6,14.7,70.5,25,48]
[null,null,null,"1 блюдо","Суп картофельный с макаронными изделиями",200,5.51,4.83,14.47,123.38,272,16.72]
[null,null,null,"2 блюдо","Биточек мясной под сырной шапкой",90,16.13,14.75,7.18,227.13,336,53.48]
[null,null,null,"гарнир","Рис отварной с маслом",150,3.34,4.91,33.93,191.49,53,15.02]
[null,null,null,"напиток","Отвар из шиповника",200,0.64,0.25,16.06,79.85,101,6.61]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F262:F270)","v":840},{"$f":"SUM(G262:G270)","v":29.82},25.82,109.14,802.45,null,{"$f":"SUM(L262:L270)","v":143.53}]
[{"$f":"A254","v":3},{"$f":"B254","v":4},"Итого за день:",null,null,{"$f":"F261+F271","v":840},{"$f":"G261+G271","v":29.82},25.82,109.14,802.45,null,{"$f":"L261+L271","v":143.53}]
[3,5,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F273:F279)","v":0},{"$f":"SUM(G273:G279)","v":0},0,0,0,null,{"$f":"SUM(L273:L279)","v":0}]
[{"$f":"A273","v":3},{"$f":"B273","v":5},"Обед","закуска","Маринад из моркови",60,1.12,4.27,6.02,68.62,13,6.22]
[null,null,null,"1 блюдо","Суп гороховый с мясом",200,9.19,5.64,13.63,141.18,34,14.82]
[null,null,null,"2 блюдо","Филе птицы ароматное",90,19.41,18.24,0.98,246.99,250,52.79]
[null,null,null,"гарнир","Картофель запеченный",150,3.31,5.56,25.99,167.07,52,13.55]
[null,null,null,"напиток","Чай с сахаром",200,0,0,7.27,28.73,114,1.46]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.3]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F281:F289)","v":750},{"$f":"SUM(G281:G289)","v":36.63},34.19,76.69,762.69,null,{"$f":"SUM(L281:L289)","v":92.81}]
[{"$f":"A273","v":3},{"$f":"B273","v":5},"Итого за день:",null,null,{"$f":"F280+F290","v":750},{"$f":"G280+G290","v":36.63},34.19,76.69,762.69,null,{"$f":"L280+L290","v":92.81}]
[4,1,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F292:F298)","v":0},{"$f":"SUM(G292:G298)","v":0},0,0,0,null,{"$f":"SUM(L292:L298)","v":0}]
[{"$f":"A292","v":4},{"$f":"B292","v":1},"Обед","фрукт","Фрукт в ассортименте (яблоко)",150,0.6,0.6,14.7,70.5,24,31.5]
[null,null,null,"1 блюдо","Суп овощной с мясом и сметаной",200,6.03,6.38,11.17,126.47,138,18.24]
[null,null,null,"2 блюдо","Филе птицы тушеное с овощами",90,15.77,13.36,1.61,190.47,177,39.33]
[null,null,null,"гарнир","Каша перловая рассыпчатая с маслом",150,3.55,4.85,24.29,155.04,55,10.31]
[null,null,null,"напиток","Напиток плодово-ягодный витаминизированный",200,0,0,14.16,55.48,104,9.1]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F300:F308)","v":840},{"$f":"SUM(G300:G308)","v":29.55},25.67,88.73,708.06,null,{"$f":"SUM(L300:L308)","v":112.18}]
[{"$f":"A292","v":4},{"$f":"B292","v":1},"Итого за день:",null,null,{"$f":"F299+F309","v":840},{"$f":"G299+G309","v":29.55},25.67,88.73,708.06,null,{"$f":"L299+L309","v":112.18}]
[4,2,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F311:F317)","v":0},{"$f":"SUM(G311:G317)","v":0},0,0,0,null,{"$f":"SUM(L311:L317)","v":0}]
[{"$f":"A311","v":4},{"$f":"B311","v":2},"Обед","закуска","Икра овощная",60,1.02,7.98,3.06,88.8,135,12.14]
[null,null,null,"1 блюдо","Суп томатный с курицей, фасолью и овощами",200,5.67,6.42,8.46,118.37,196,29.03]
[null,null,null,"2 блюдо","Гуляш",90,16.56,15.75,2.84,219.6,89,63.69]
[null,null,null,"гарнир","Каша гречневая рассыпчатая с маслом",150,7.26,4.96,31.76,198.84,54,12.66]
[null,null,null,"напиток","Компот из смеси фруктов и ягод",200,0.25,0,12.73,51.3,216,10.1]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F319:F327)","v":750},{"$f":"SUM(G319:G327)","v":34.36},35.59,81.65,787.01,null,{"$f":"SUM(L319:L327)","v":131.32}]
[{"$f":"A311","v":4},{"$f":"B311","v":2},"Итого за день:",null,null,{"$f":"F318+F328","v":750},{"$f":"G318+G328","v":34.36},35.59,81.65,787.01,null,{"$f":"L318+L328","v":131.32}]
[4,3,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F330:F336)","v":0},{"$f":"SUM(G330:G336)","v":0},0,0,0,null,{"$f":"SUM(L330:L336)","v":0}]
[{"$f":"A330","v":4},{"$f":"B330","v":3},"Обед","фрукт","Фрукт в ассортименте (мандарин)",100,0.8,0.2,7.5,38,137,32]
[null,null,null,"1 блюдо","Борщ с мясом и сметаной",200,5.75,8.79,8.75,138.04,31,23.22]
[null,null,null,"2 блюдо","Чахохбили",90,21.52,19.57,2.45,270.77,150,53.02]
[null,null,null,"гарнир","Картофельное пюре с маслом",150,3.28,7.81,21.57,170.22,50,19.22]
[null,null,null,"напиток","Сок фруктовый",200,0.6,0,33,136,107,14.4]
[null,null,null,"хлеб бел.","Хлеб пшеничный",20,1.52,0.16,9.84,47,119,1.35]
[null,null,null,"хлеб черн.","Хлеб ржаной",20,1.32,0.24,8.04,39.6,120,1.67]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F338:F346)","v":780},{"$f":"SUM(G338:G346)","v":34.79},36.77,91.15,839.63,null,{"$f":"SUM(L338:L346)","v":144.88}]
[{"$f":"A330","v":4},{"$f":"B330","v":3},"Итого за день:",null,null,{"$f":"F337+F347","v":780},{"$f":"G337+G347","v":34.79},36.77,91.15,839.63,null,{"$f":"L337+L347","v":144.88}]
[4,4,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F349:F355)","v":0},{"$f":"SUM(G349:G355)","v":0},0,0,0,null,{"$f":"SUM(L349:L355)","v":0}]
[{"$f":"A349","v":4},{"$f":"B349","v":4},"Обед","закуска","Икра свекольная",60,1.29,4.27,6.97,72.75,9,6.22]
[null,null,null,"1 блюдо","Суп овощной с цветной капустой",200,1.15,1.91,5.7,44.94,349,16.24]
[null,null,null,"2 блюдо","Мясо тушеное",90,16.41,15.33,1.91,211.4,88,39.03]
[null,null,null,"гарнир","Макароны отварные с маслом",150,6.76,3.93,41.29,227.48,64,9.97]
[null,null,null,"напиток","Компот из сухофруктов",200,0.37,0,14.85,59.48,98,3.64]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",30,1.98,0.36,12.06,59.4,120,2.5]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F357:F365)","v":760},{"$f":"SUM(G357:G365)","v":30.24},26.04,97.54,745.95,null,{"$f":"SUM(L357:L365)","v":79.63}]
[{"$f":"A349","v":4},{"$f":"B349","v":4},"Итого за день:",null,null,{"$f":"F356+F366","v":760},{"$f":"G356+G366","v":30.24},26.04,97.54,745.95,null,{"$f":"L356+L366","v":79.63}]
[4,5,"Завтрак","гор.блюдо"]
[]
[null,null,null,"гор.напиток"]
[null,null,null,"хлеб"]
[null,null,null,"фрукты"]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F368:F374)","v":0},{"$f":"SUM(G368:G374)","v":0},0,0,0,null,{"$f":"SUM(L368:L374)","v":0}]
[{"$f":"A368","v":4},{"$f":"B368","v":5},"Обед","фрукт","Фрукт в ассортименте (груша)",150,0.6,0.6,14.7,70.5,25,48]
[null,null,null,"1 блюдо","Суп куриный с булгуром, помидорами и болгарским перцем",200,4.66,7.31,7.08,112.51,144,21.18]
[null,null,null,"2 блюдо","Зраза мясная ленивая",90,18.89,19.34,7.73,281.58,296,55.5]
[null,null,null,"гарнир","Картофель отварной с маслом и зеленью",150,3.3,3.9,25.69,151.35,51,13.82]
[null,null,null,"напиток","Чай с сахаром",200,0.2,0,11,44.8,114,1.46]
[null,null,null,"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.5,119,2.03]
[null,null,null,"хлеб черн.","Хлеб ржаной",30,1.98,0.36,12.06,59.4,120,2.5]
[]
[]
[null,null,null,"итого",null,{"$f":"SUM(F376:F384)","v":850},{"$f":"SUM(G376:G384)","v":31.91},31.75,93.02,790.64,null,{"$f":"SUM(L376:L384)","v":144.49}]
[{"$f":"A368","v":4},{"$f":"B368","v":5},"Итого за день:",null,null,{"$f":"F375+F385","v":850},{"$f":"G375+G385","v":31.91},31.75,93.02,790.64,null,{"$f":"L375+L385","v":144.49}]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F215+F234+F253+F272+F291+F310+F329+F348+F367+F386)/(IF(F215=0,0,1)+IF(F234=0,0,1)+IF(F253=0,0,1)+IF(F272=0,0,1)+IF(F291=0,0,1)+IF(F310=0,0,1)+IF(F329=0,0,1)+IF(F348=0,0,1)+IF(F367=0,0,1)+IF(F386=0,0,1))","v":798},{"$f":"(G215+G234+G253+G272+G291+G310+G329+G348+G367+G386)/(IF(G215=0,0,1)+IF(G234=0,0,1)+IF(G253=0,0,1)+IF(G272=0,0,1)+IF(G291=0,0,1)+IF(G310=0,0,1)+IF(G329=0,0,1)+IF(G348=0,0,1)+IF(G367=0,0,1)+IF(G386=0,0,1))","v":34.075},30.487,92.621,785.562,null,{"$f":"(L215+L234+L253+L272+L291+L310+L329+L348+L367+L386)/(IF(L215=0,0,1)+IF(L234=0,0,1)+IF(L253=0,0,1)+IF(L272=0,0,1)+IF(L291=0,0,1)+IF(L310=0,0,1)+IF(L329=0,0,1)+IF(L348=0,0,1)+IF(L367=0,0,1)+IF(L386=0,0,1))","v":120.396}]