{"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,"дата",null,null,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп с крупой гречка",250,2.68,2.8,17.14,104.5,101,7.95]
[{"$nulls":3},"2 блюдо","Пельмени по-домашнему",100,7.9,14.8,26.5,271,118,46.57]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из меси сухофруктов.",200,0.04,0,24.76,94.2,349,4.8]
[{"$nulls":3},"хлеб бел.","Хлеб йодированный ",50,2,0,12,66.25,0,3.7]
[{"$nulls":3},"хлеб черн."]
[{"$nulls":4},"чоко пай",30,4.5,16,64,410,null,15]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":630},{"$f":"SUM(G14:G22)","v":17.119999999999997},33.6,144.4,945.95,null,{"$f":"SUM(L14:L22)","v":78.02000000000001}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":630},{"$f":"G13+G23","v":17.119999999999997},33.6,144.4,945.95,null,{"$f":"L13+L23","v":78.02000000000001}]
[1,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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,0.85,3.05,5.19,51.54,45,6.8]
[{"$nulls":3},"1 блюдо","Суп с бобовыми(горох)",250,5.49,5.27,16.54,148.25,102,7.33]
[{"$nulls":3},"2 блюдо","Пюре картофельное",150,3.07,0.02,"20,44,",137.45,321,15.5]
[{"$nulls":3},"гарнир","Тефтель \"Ёжик\"",100,15.55,11.55,15.7,228.75,268,46]
[{"$nulls":3},"напиток","Чай черный с сахаром",200,0.2,0,14,28,943,2.45]
[{"$nulls":3},"хлеб бел.","Хлеб йодированный",25,4,0,24,132,0,1.85]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F41)","v":785},{"$f":"SUM(G33:G41)","v":29.16},{"$f":"SUM(H33:H41)","v":19.89},{"$f":"SUM(I33:I41)","v":75.43},{"$f":"SUM(J33:J41)","v":725.99},null,79.92999999999999]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":785},{"$f":"G32+G42","v":29.16},{"$f":"H32+H42","v":19.89},{"$f":"I32+I42","v":75.43},{"$f":"J32+J42","v":725.99},null,79.92999999999999]
[1,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп лапша",250,2.69,2.84,17.14,104.75,208,9.96]
[{"$nulls":3},"2 блюдо","капуста тушеная с мясом",200,3.7,8.64,46.03,284.7,336,48.85]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","сок фрутовый (яблочный)",200,1,0,18.2,76,445,13.5]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн.","Хлеб йодированный",50,4,0,24,132,0,3.7]
[{"$nulls":4},"конфета шоколадная",15,0.21,1.05,11.1,54.75,null,6.75]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":715},{"$f":"SUM(G52:G60)","v":11.600000000000001},12.530000000000001,116.47,652.2,null,{"$f":"SUM(L52:L60)","v":82.76}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":715},{"$f":"G51+G61","v":11.600000000000001},{"$f":"H51+H61","v":12.530000000000001},{"$f":"I51+I61","v":116.47},{"$f":"J51+J61","v":652.2},null,82.76]
[1,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска","Салат из зелёного горошка",0.04,1.19,2.08,2.5,33.44,10,"8,75*"]
[{"$nulls":3},"1 блюдо","Суп свекольный",250,1.6,4.86,8.56,91.25,81,10.25]
[{"$nulls":3},"2 блюдо","Плов из говядины",150,25.38,21.25,44.61,471.25,304,51.69]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Компот из смеси сухофруктов.",200,0.04,0,24.76,94.2,349,4.8]
[{"$nulls":3},"хлеб бел.","Хлеб Йодированный",50,4,0,24,132,0,3.7]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":650.04},{"$f":"SUM(G71:G79)","v":32.209999999999994},{"$f":"SUM(H71:H79)","v":28.19},{"$f":"SUM(I71:I79)","v":104.43},{"$f":"SUM(J71:J79)","v":822.1400000000001},null,79.19]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":650.04},{"$f":"G70+G80","v":32.209999999999994},{"$f":"H70+H80","v":28.19},{"$f":"I70+I80","v":104.43},{"$f":"J70+J80","v":822.1400000000001},null,79.19]
[1,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Суп с рыбными консервами",250,8.61,8.4,14.34,167.25,87,19.66]
[{"$nulls":3},"2 блюдо","каша гречневая",150,5.75,4.06,25.76,162.5,302,4.56]
[{"$nulls":3},"гарнир","Котлета мясная",100,15.55,11.55,15.7,228.75,608,46]
[{"$nulls":3},"напиток","компот из сухофруктов ",200,0.04,0,24.76,94.2,349,4.8]
[{"$nulls":3},"хлеб бел.","хлеб йодированный",50,4,0,24,132,0,3.7]
[{"$nulls":3},"хлеб черн."]
[{"$nulls":4},"соус томатный",50,0.32,1.1,2.08,19.68,null," "]
[]
[{"$nulls":3},"итого",null,null,{"$f":"G91+G92+G93+G94+G95","v":33.95},{"$f":"H91+H92+H93+H94","v":24.01},{"$f":"I91+I92+I93+I94","v":80.56},{"$f":"J91+J92+J93+J94+J95","v":784.7},null,79.95]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":0},{"$f":"G89+G99","v":33.95},{"$f":"H89+H99","v":24.01},{"$f":"I89+I99","v":80.56},{"$f":"J89+J99","v":784.7},null,79.95]
[2,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":0},{"$f":"SUM(G101:G107)","v":0},0,0,0,null,{"$f":"SUM(L101:L107)","v":0}]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Обед","закуска","нарезка овощная (огурец)",50,9.64,60.76,36.46,707,24,9]
[{"$nulls":3},"1 блюдо","суп с крупой (пшено)",250,6.39,19.42,34.25,365,81,7.95]
[{"$nulls":3},"2 блюдо","Макаронные изделия отварные",150,13.16,14,86.9,504,309,4.73]
[{"$nulls":3},"гарнир","тефтель \"Ёжик\"",100,15.55,11.55,15.7,228.75,268,46]
[{"$nulls":3},"напиток","чай черный с сахаром и лимоном",200,9,2.28,15.42,144.67,377,4.11]
[{"$nulls":3},"хлеб бел.","Хлеб йодироавнный",50,4,0,24,132,0,"3,70*"]
[{"$nulls":3},"хлеб черн."]
[{"$nulls":4},"соус томатный",50,0.32,1.1,2.08,19.68,null,1.23]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":850},{"$f":"SUM(G109:G117)","v":58.06},109.11,214.81,2101.1,null,76.72]
[{"$f":"A101","v":2},{"$f":"B101","v":1},"Итого за день:",null,null,{"$f":"F108+F118","v":850},{"$f":"G108+G118","v":58.06},{"$f":"H108+H118","v":109.11},{"$f":"I108+I118","v":214.81},{"$f":"J108+J118","v":2101.1},null,76.72]
[2,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска","Салат со свежей капусты",50,0.85,3.05,5.41,52.44,45,6.8]
[{"$nulls":3},"1 блюдо","Рассльник по-ленинградски",250,6.55,20.25,45.22,424,94,9.83]
[{"$nulls":3},"2 блюдо","жаркое по-домашнему",250,27.53,7.47,21.95,265,436,48.9]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","сок фруктовый персиковый",200,1,0,18.2,76,445,13.5]
[{"$nulls":3},"хлеб бел.","Хлеб йодированный",50,4,0,24,132,0,3.7]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":800},{"$f":"SUM(G128:G136)","v":39.93},30.77,114.78,949.44,null,{"$f":"SUM(L128:L136)","v":82.73}]
[{"$f":"A120","v":2},{"$f":"B120","v":2},"Итого за день:",null,null,{"$f":"F127+F137","v":800},{"$f":"G127+G137","v":39.93},{"$f":"H127+H137","v":30.77},{"$f":"I127+I137","v":114.78},{"$f":"J127+J137","v":949.44},null,82.73]
[2,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска","Салат луковый",100,0.86,5.11,2.61,59.8,17,5.5]
[{"$nulls":3},"1 блюдо","Щи со свежей капустой.",250,1.76,4.89,5.9,80,87,10.25]
[{"$nulls":3},"2 блюдо","Макаронник",150,14.38,14.87,"15,50*",249.51,285,44.59]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Сок фруктовый яблочный",200,1,0,18.2,76,445,13.5]
[{"$nulls":3},"хлеб бел.","Хлеб йодированный",50,4,0,24,132,0,3.7]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F155)","v":750},{"$f":"SUM(G147:G155)","v":22},{"$f":"SUM(H147:H155)","v":24.869999999999997},{"$f":"SUM(I147:I155)","v":50.71},{"$f":"SUM(J147:J155)","v":597.31},null,{"$f":"SUM(L147:L155)","v":77.54}]
[{"$f":"A139","v":2},{"$f":"B139","v":3},"Итого за день:",null,null,{"$f":"F146+F156","v":750},{"$f":"G146+G156","v":22},{"$f":"H146+H156","v":24.869999999999997},{"$f":"I146+I156","v":50.71},{"$f":"J146+J156","v":597.31},null,77.54]
[2,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска"]
[{"$nulls":3},"1 блюдо","Борщ со сметаной",250,1.81,4.91,125.25,102.5,82,11.6]
[{"$nulls":3},"2 блюдо","Каша перловая",150,2.32,4.29,20.5,122.15,84,2.9]
[{"$nulls":3},"гарнир","Биточек",100,15.55,11.55,15.7,228.75,608,46]
[{"$nulls":3},"напиток","Компот из смеси сухофруктов","200/20",0.04,0,24.76,94.2,349,4.8]
[{"$nulls":3},"хлеб бел.","Хлеб йодированный",25,4,0,24,132,0,1.85]
[{"$nulls":3},"хлеб черн."]
[{"$nulls":4},"соус томатный",50,0.32,1.1,2.08,19.68,null,1.23]
[{"$nulls":4},"чоко пай ",30,4.5,16,64,410,null,15]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F174)","v":605},{"$f":"SUM(G166:G174)","v":28.54},37.85,276.28999999999996,1109.28,null,{"$f":"SUM(L166:L174)","v":83.38}]
[{"$f":"A158","v":2},{"$f":"B158","v":4},"Итого за день:",null,null,{"$f":"F165+F175","v":605},{"$f":"G165+G175","v":28.54},{"$f":"H165+H175","v":37.85},{"$f":"I165+I175","v":276.28999999999996},{"$f":"J165+J175","v":1109.28},null,83.38]
[2,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",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},"Обед","закуска","Винегрет",70,0.82,3.71,5.06,56.88,67,8.9]
[{"$nulls":3},"1 блюдо","Суп картофельный с сухариками","250/5",2,2.5,9,90,89,7.95]
[{"$nulls":3},"2 блюдо","Рис отварной",150,2.4,2.88,25.02,162.5,302,6.02]
[{"$nulls":3},"гарнир","котлета мясная",100,15.55,11.55,15.7,228.75,608,46]
[{"$nulls":3},"напиток","чай черный с сахаром","200/15",0.2,0,14,28,943,2.45]
[{"$nulls":3},"хлеб бел.","Хлеб йодированный",50,4,0,24,132,0,3.7]
[{"$nulls":3},"хлеб черн."]
[{"$nulls":4},"соус томатный",50,0.32,1.1,2.08,19.68,null,1.23]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":420},{"$f":"SUM(G185:G193)","v":25.29},21.740000000000002,94.86,717.81,null,{"$f":"SUM(L185:L193)","v":76.25000000000001}]
[{"$f":"A177","v":2},{"$f":"B177","v":5},"Итого за день:",null,null,{"$f":"F184+F194","v":420},{"$f":"G184+G194","v":25.29},{"$f":"H184+H194","v":21.740000000000002},{"$f":"I184+I194","v":94.86},{"$f":"J184+J194","v":717.81},null,76.25000000000001]
[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":689.4488888888889},{"$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":29.78600000000001},34.25600000000001,127.27399999999997,940.592,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":79.64699999999999}]