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

{"sheet":"Лист1","index":0,"n_rows":206,"n_cols":12,"rows_kept":206,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[25,2,25,3],[45,2,45,3],[64,2,64,3],[85,2,85,3],[104,2,104,3],[124,2,124,3],[143,2,143,3],[163,2,163,3],[183,2,183,3],[204,2,204,3],[205,2,205,4]]}
["Школа",null,"МБОУ \" Уруссинская СОШ №2\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Якимова Н.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",21,9,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты школьные с соусом сметанным с томатом",100,5.8,9.8,9.01,130.2,347]
[{"$nulls":3},"гор.блюдо","Пюре гороховое с маслом ","150/5",8.8,5.64,32.56,259.9,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.2,0,9.1,36,300]
[{"$nulls":3},"салат","Салат из белокачанной капусты",60,1.3,2.7,"6,2","57",6]
[{"$nulls":3},"хлеб бел","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб дарницкий",20,1.36,0.26,7.96,39.6,574]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F14)","v":410},{"$f":"SUM(G6:G14)","v":19.740000000000002},{"$f":"SUM(H6:H14)","v":18.64},{"$f":"SUM(I6:I14)","v":73.39},{"$f":"SUM(J6:J14)","v":535.9},null,{"$f":"SUM(L6:L14)","v":0}]
[{"$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(F16:F24)","v":0},{"$f":"SUM(G16:G24)","v":0},0,0,0,null,{"$f":"SUM(L16:L24)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F15+F25","v":410},{"$f":"G15+G25","v":19.740000000000002},18.64,73.39,535.9,null,{"$f":"L15+L25","v":0}]
[1,2,"Завтрак","гор.блюдо","Биточки рыбные с соусом",100,8.8,12.55,8.47,134.6,83]
[{"$nulls":3},"гор.блюдо","макаронные изделия отварные с маслом","150/5",5.42,3.67,20.1,194.2,227]
[{"$nulls":3},"напиток","компот из сухофруктов",200,0.5,0.1,30.9,{"v":123,"d":"123.00"},310]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,1.36,0.26,7.96,39.6,574]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F27:F34)","v":350},{"$f":"SUM(G27:G34)","v":18.36},{"$f":"SUM(H27:H34)","v":16.82},{"$f":"SUM(I27:I34)","v":82.19},{"$f":"SUM(J27:J34)","v":561.6},null,{"$f":"SUM(L27:L34)","v":0}]
[{"$f":"A27","v":1},{"$f":"B27","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F36:F44)","v":0},{"$f":"SUM(G36:G44)","v":0},{"$f":"SUM(H36:H44)","v":0},{"$f":"SUM(I36:I44)","v":0},{"$f":"SUM(J36:J44)","v":0},null,0]
[{"$f":"A27","v":1},{"$f":"B27","v":2},"Итого за день:",null,null,{"$f":"F35+F45","v":350},{"$f":"G35+G45","v":18.36},{"$f":"H35+H45","v":16.82},{"$f":"I35+I45","v":82.19},{"$f":"J35+J45","v":561.6},null,0]
[1,3,"Завтрак","гор.блюдо","жаркое по домашнему с куриными грудками",200,"11,8",15.1,25.8,301.25,98]
[{"$nulls":3},"гор.напиток","чай с молоком",200,"1,6","1,5","11,3","62","301"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,"1,36","0,26","7,96","39,6","574"]
[{"$nulls":3},"фрукты","фрукты свежие",100,0.4,0.4,9.8,47,338]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F47:F53)","v":550},{"$f":"SUM(G47:G53)","v":0.4},{"$f":"SUM(H47:H53)","v":15.5},{"$f":"SUM(I47:I53)","v":35.6},{"$f":"SUM(J47:J53)","v":348.25},null,{"$f":"SUM(L47:L53)","v":0}]
[{"$f":"A47","v":1},{"$f":"B47","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F55:F63)","v":0},{"$f":"SUM(G55:G63)","v":0},{"$f":"SUM(H55:H63)","v":0},{"$f":"SUM(I55:I63)","v":0},{"$f":"SUM(J55:J63)","v":0},null,0]
[{"$f":"A47","v":1},{"$f":"B47","v":3},"Итого за день:",null,null,{"$f":"F54+F64","v":550},{"$f":"G54+G64","v":0.4},{"$f":"H54+H64","v":15.5},{"$f":"I54+I64","v":35.6},{"$f":"J54+J64","v":348.25},null,0]
[1,4,"Завтрак","гор.блюдо","Фрикадельки куринные тушеные в соусе  ","90",4.5,8.8,5.7,77.7,134]
[{"$nulls":3},"гор.блюдо","Каша пшенная рассыпчатая с маслом",155,"6,7","4,11","39,4","218,67","188"]
[{"$nulls":3},"гор.напиток","чай с сахаром","200","0,2","0","9,1","36","300"]
[{"$nulls":3},"закуска","Салат из свеклы с растительным маслом",60,"1","4,8","5","69","25"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,"1,36","0,26","7,96","39,6","574"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F66:F74)","v":265},{"$f":"SUM(G66:G74)","v":4.5},{"$f":"SUM(H66:H74)","v":8.8},{"$f":"SUM(I66:I74)","v":5.7},{"$f":"SUM(J66:J74)","v":77.7},null,0]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F76:F84)","v":0},{"$f":"SUM(G76:G84)","v":0},{"$f":"SUM(H76:H84)","v":0},{"$f":"SUM(I76:I84)","v":0},{"$f":"SUM(J76:J84)","v":0},null,0]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Итого за день:",null,null,{"$f":"F75+F85","v":265},{"$f":"G75+G85","v":4.5},{"$f":"H75+H85","v":8.8},{"$f":"I75+I85","v":5.7},{"$f":"J75+J85","v":77.7},null,0]
[{"$nulls":3},"гор.блюдо","гречка с курицей по-купески","200","13,42","13,67","33,3","294,2","139"]
[{"$nulls":3},"гор.напиток","Чай с сахаром","200","0,2","0","9,1","36","300"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,"1,36","0,26","7,96","39,6","574"]
[{"$nulls":3},"салат","салат из моркови",60,0.6,2.3,5,72,17]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F87:F93)","v":110},{"$f":"SUM(G87:G93)","v":0.6},{"$f":"SUM(H87:H93)","v":2.3},{"$f":"SUM(I87:I93)","v":5},{"$f":"SUM(J87:J93)","v":72},null,{"$f":"SUM(L87:L93)","v":0}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F95:F103)","v":0},{"$f":"SUM(G95:G103)","v":0},{"$f":"SUM(H95:H103)","v":0},{"$f":"SUM(I95:I103)","v":0},{"$f":"SUM(J95:J103)","v":0},null,0]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},"Итого за день:",null,null,{"$f":"F94+F104","v":110},{"$f":"G94+G104","v":0.6},{"$f":"H94+H104","v":2.3},{"$f":"I94+I104","v":5},{"$f":"J94+J104","v":72},null,0]
[2,1,"Завтрак","гор.блюдо","тефтели говяжьи с соусом","90","8,6","14,3","10,3","177,1","110"]
[{"$nulls":3},"гор.блюдо","макаронные изделия отварные с маслом","150/5",5.42,3.67,"20,1",194.2,227]
[{"$nulls":3},"гор.напиток","Чай с сахаром ","200","0,2","0","9,1","36","300"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,"1,36","0,26","7,96","39,6","574"]
[{"$nulls":3},"салат","фрукты свежие",100,0.4,0.4,9.8,47,338]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F113)","v":150},{"$f":"SUM(G106:G113)","v":5.82},4.07,9.8,241.2,null,{"$f":"SUM(L106:L113)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F115:F123)","v":0},{"$f":"SUM(G115:G123)","v":0},0,0,0,null,{"$f":"SUM(L115:L123)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":1},"Итого за день:",null,null,{"$f":"F114+F124","v":150},{"$f":"G114+G124","v":5.82},{"$f":"H114+H124","v":4.07},{"$f":"I114+I124","v":9.8},{"$f":"J114+J124","v":241.2},null,0]
[2,2,"Завтрак","гор.блюдо","котлеты школьные с соусом сметанным с томатом",100,5.8,9.8,9.01,130.2,347]
[{"$nulls":3},"гор.блюдо","каша гречневая рассыпчатая с маслом","150/5",8.83,5.67,32.58,260,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.2,0,9.1,36,300]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,{"v":70.2,"d":"70.20"},573]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,1.36,0.26,7.96,39.6,574]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F126:F132)","v":350},{"$f":"SUM(G126:G132)","v":18.47},{"$f":"SUM(H126:H132)","v":15.97},{"$f":"SUM(I126:I132)","v":73.41},{"$f":"SUM(J126:J132)","v":536},null,{"$f":"SUM(L126:L132)","v":0}]
[{"$f":"A126","v":2},{"$f":"B126","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F134:F142)","v":0},{"$f":"SUM(G134:G142)","v":0},0,0,0,null,{"$f":"SUM(L134:L142)","v":0}]
[{"$f":"A126","v":2},{"$f":"B126","v":2},"Итого за день:",null,null,{"$f":"F133+F143","v":350},{"$f":"G133+G143","v":18.47},{"$f":"H133+H143","v":15.97},{"$f":"I133+I143","v":73.41},{"$f":"J133+J143","v":536},null,0]
[2,3,"Завтрак","гор.блюдо","картофельное пюре",150,3.08,"3,7","32,03","190,25","146"]
[{"$nulls":3},"гор.блюдо","биточки рыбные с соусом",100,"8,8","12,55","8,47","134,6",83]
[{"$nulls":3},"гор.напиток","Чай с лимоном с сахаром",200,"0,2","0","9,3","38","302"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,"1,36","0,26","7,96","39,6","574"]
[{"$nulls":3},"салат","салат из моркови",60,0.6,2.3,5,72,17]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F145:F152)","v":560},{"$f":"SUM(G145:G152)","v":3.68},{"$f":"SUM(H145:H152)","v":2.3},{"$f":"SUM(I145:I152)","v":5},{"$f":"SUM(J145:J152)","v":72},null,{"$f":"SUM(L145:L152)","v":0}]
[{"$f":"A145","v":2},{"$f":"B145","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F154:F162)","v":0},{"$f":"SUM(G154:G162)","v":0},0,0,0,null,{"$f":"SUM(L154:L162)","v":0}]
[{"$f":"A145","v":2},{"$f":"B145","v":3},"Итого за день:",null,null,{"$f":"F153+F163","v":560},{"$f":"G153+G163","v":3.68},{"$f":"H153+H163","v":2.3},{"$f":"I153+I163","v":5},{"$f":"J153+J163","v":72},null,0]
[2,4,"Завтрак","гор.блюдо","Плов из птицы ",200,12.2,13.2,22.2,267,138]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,"0,5","0,1","30,9","123","310"]
[{"$nulls":3},"закуска","Салат из свеклы с растительным маслом",60,"1","4,8","5","69","25"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F172)","v":510},{"$f":"SUM(G165:G172)","v":13.559999999999999},{"$f":"SUM(H165:H172)","v":13.459999999999999},{"$f":"SUM(I165:I172)","v":30.16},{"$f":"SUM(J165:J172)","v":306.6},null,{"$f":"SUM(L165:L172)","v":0}]
[{"$f":"A165","v":2},{"$f":"B165","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F174:F182)","v":0},{"$f":"SUM(G174:G182)","v":0},0,0,0,null,{"$f":"SUM(L174:L182)","v":0}]
[{"$f":"A165","v":2},{"$f":"B165","v":4},"Итого за день:",null,null,{"$f":"F173+F183","v":510},{"$f":"G173+G183","v":13.559999999999999},{"$f":"H173+H183","v":13.459999999999999},{"$f":"I173+I183","v":30.16},{"$f":"J173+J183","v":306.6},null,0]
[2,5,"Завтрак","гор.блюдо","Фрикадельки куриные тушеные в соусе ","90","4,5","8,8","1,7","77,7","134"]
[{"$nulls":3},"гор.блюдо","Каша гречневая рассыпчатая с маслом","150/5",8.83,5.67,32.58,260,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром ","200","0,2","0","9,1","36","300"]
[{"$nulls":3},"закуска","фрукты свежие","100","0,4","0,4","9,8","47","338"]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,"2,28","0,24","14,76","70,2","573"]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий",20,"1,36","0,26","7,96","39,6","574"]
[{"$nulls":3},"салат","салат из белокачанной капусты",60,1.3,2.7,6.2,57,6]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":110},{"$f":"SUM(G185:G193)","v":10.13},8.370000000000001,38.78,317,null,{"$f":"SUM(L185:L193)","v":0}]
[{"$f":"A185","v":2},{"$f":"B185","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F195:F203)","v":0},{"$f":"SUM(G195:G203)","v":0},0,0,0,null,{"$f":"SUM(L195:L203)","v":0}]
[{"$f":"A185","v":2},{"$f":"B185","v":5},"Итого за день:",null,null,{"$f":"F194+F204","v":110},{"$f":"G194+G204","v":10.13},{"$f":"H194+H204","v":8.370000000000001},{"$f":"I194+I204","v":38.78},{"$f":"J194+J204","v":317},null,0]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F26+F46+F65+F86+F105+F125+F144+F164+F184+F205)/(IF(F26=0,0,1)+IF(F46=0,0,1)+IF(F65=0,0,1)+IF(F86=0,0,1)+IF(F105=0,0,1)+IF(F125=0,0,1)+IF(F144=0,0,1)+IF(F164=0,0,1)+IF(F184=0,0,1)+IF(F205=0,0,1))","v":336.5},{"$f":"(G26+G46+G65+G86+G105+G125+G144+G164+G184+G205)/(IF(G26=0,0,1)+IF(G46=0,0,1)+IF(G65=0,0,1)+IF(G86=0,0,1)+IF(G105=0,0,1)+IF(G125=0,0,1)+IF(G144=0,0,1)+IF(G164=0,0,1)+IF(G184=0,0,1)+IF(G205=0,0,1))","v":9.526},{"$f":"(H26+H46+H65+H86+H105+H125+H144+H164+H184+H205)/(IF(H26=0,0,1)+IF(H46=0,0,1)+IF(H65=0,0,1)+IF(H86=0,0,1)+IF(H105=0,0,1)+IF(H125=0,0,1)+IF(H144=0,0,1)+IF(H164=0,0,1)+IF(H184=0,0,1)+IF(H205=0,0,1))","v":10.623},{"$f":"(I26+I46+I65+I86+I105+I125+I144+I164+I184+I205)/(IF(I26=0,0,1)+IF(I46=0,0,1)+IF(I65=0,0,1)+IF(I86=0,0,1)+IF(I105=0,0,1)+IF(I125=0,0,1)+IF(I144=0,0,1)+IF(I164=0,0,1)+IF(I184=0,0,1)+IF(I205=0,0,1))","v":35.903},{"$f":"(J26+J46+J65+J86+J105+J125+J144+J164+J184+J205)/(IF(J26=0,0,1)+IF(J46=0,0,1)+IF(J65=0,0,1)+IF(J86=0,0,1)+IF(J105=0,0,1)+IF(J125=0,0,1)+IF(J144=0,0,1)+IF(J164=0,0,1)+IF(J184=0,0,1)+IF(J205=0,0,1))","v":306.825},null,{"$f":"(L26+L46+L65+L86+L105+L125+L144+L164+L184+L205)/(IF(L26=0,0,1)+IF(L46=0,0,1)+IF(L65=0,0,1)+IF(L86=0,0,1)+IF(L105=0,0,1)+IF(L125=0,0,1)+IF(L144=0,0,1)+IF(L164=0,0,1)+IF(L184=0,0,1)+IF(L205=0,0,1))","v":{"$error":"#DIV/0!"}}]