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

{"sheet":"Лист1","index":0,"n_rows":194,"n_cols":12,"rows_kept":194,"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],[98,2,98,3],[116,2,116,3],[135,2,135,3],[154,2,154,3],[173,2,173,3],[192,2,192,3],[193,2,193,4]]}
["Школа",null,"МБОУ \"Старокуваская СОШ\"",null,null,"Утвердил:","должность","Директор ООО \"ГРАНД\""]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Васянина Ю.С."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,1,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","котлеты из мяса птицы","90","10,2","12,93","13,79",198]
[{"$nulls":3},"салат","из моркиви с яблоками",60,"0,64","3,01","5,11","50,91"]
[{"$nulls":3},"гор.напиток","компот из сухофруктов","200","0,66","0,09","22,03","92,8"]
[{"$nulls":3},"хлеб черн.","Хлеб дарницкий","30","1,98","0,36","11,88","59,4"]
[{"$nulls":3},"фрукты"]
[{"$nulls":3},"гор.блюдо","макаронные изделия отварные с маслом","150/5","5,7","4,3","31,99","189,3",203]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F12)","v":60},{"$f":"SUM(G6:G12)","v":0},{"$f":"SUM(H6:H12)","v":0},{"$f":"SUM(I6:I12)","v":0},{"$f":"SUM(J6:J12)","v":198},null,{"$f":"SUM(L6:L12)","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(F14:F22)","v":0},{"$f":"SUM(G14:G22)","v":0},0,0,0,null,{"$f":"SUM(L14:L22)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":60},{"$f":"G13+G23","v":0},0,0,198,null,{"$f":"L13+L23","v":0}]
[1,2,"Завтрак","гор.блюдо","сырники из творога с молочной кашей \"Дружба\"","60/150/5","13,65","15,29","32,32","130,90","ТТК"]
[]
[{"$nulls":3},"гор.напиток","чай с сахаром","190/10","0,07","0,02","10,01",40,376]
[]
[{"$nulls":3},"фрукты","яблоко","100","0,4","0,4","9,8",47]
[{"$nulls":3},"хлеб черн.","Хлеб дарницкий","30","1,98","0,36","11,88","59,40"]
[]
[{"$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":87},null,0]
[{"$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},{"$f":"SUM(H33:H41)","v":0},{"$f":"SUM(I33:I41)","v":0},{"$f":"SUM(J33:J41)","v":0},null,0]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":0},{"$f":"G32+G42","v":0},{"$f":"H32+H42","v":0},{"$f":"I32+I42","v":0},{"$f":"J32+J42","v":87},null,{"$f":"L32+L42","v":0}]
[1,3,"Завтрак","гор.блюдо","каша гречневая рассыпчатая","150","3,77","2,29","39,72",214,171]
[{"$nulls":3},"закуска","сыр порционно","10",2.63,2.66,"0,0",34,15]
[{"$nulls":3},"гор.напиток","чай с сахаром и лимоном","185/10/5","0,11","0,02","10,15",41,377]
[]
[]
[{"$nulls":3},"хлеб черн.","хлеб сельский Дарницкий","50","3,3","0,6","19,8",99]
[{"$nulls":3},"гор.блюдо","гуляш из говядины","50/50","10,39","14,79","10,30",221,260]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":0},{"$f":"SUM(G44:G50)","v":2.63},{"$f":"SUM(H44:H50)","v":2.66},{"$f":"SUM(I44:I50)","v":0},{"$f":"SUM(J44:J50)","v":609},null,0]
[{"$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},{"$f":"SUM(H52:H60)","v":0},{"$f":"SUM(I52:I60)","v":0},{"$f":"SUM(J52:J60)","v":0},null,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":0},{"$f":"G51+G61","v":2.63},{"$f":"H51+H61","v":2.66},{"$f":"I51+I61","v":0},{"$f":"J51+J61","v":609},null,0]
[1,4,"Завтрак","гор.блюдо","пюре картофельное с маслом сливочным","150/3","4,11","3,55","30,79",202.8,312]
[{"$nulls":3},"салат","свекла отварная дольками",60,"1,08","0,06","5,88",28.8]
[{"$nulls":3},"гор.напиток","чай с сахаром с яблоком","180/10/10","0,11","0,06","10,98",44.7,376]
[{"$nulls":3},"хлеб","хлеб пшеничный ","30","2,28","0,24","14,76",70.5]
[]
[{"$nulls":3},"хлеб черн.","хлеб дарницкий","40","2,64","0,48","15,84",79.2]
[{"$nulls":3},"гор.блюдо","котлета из мяса птицы",90,"10,2","12,93","13,79",198]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":150},{"$f":"SUM(G63:G69)","v":0},{"$f":"SUM(H63:H69)","v":0},{"$f":"SUM(I63:I69)","v":0},{"$f":"SUM(J63:J69)","v":624},null,0]
[{"$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(F71:F79)","v":0},{"$f":"SUM(G71:G79)","v":0},{"$f":"SUM(H71:H79)","v":0},{"$f":"SUM(I71:I79)","v":0},{"$f":"SUM(J71:J79)","v":0},null,0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":150},{"$f":"G70+G80","v":0},{"$f":"H70+H80","v":0},{"$f":"I70+I80","v":0},{"$f":"J70+J80","v":624},null,0]
[1,5,"Завтрак","гор.блюдо","тефтели мясные в сметанно - томатом соусе","60/40","7, 284","11,94","8,36","123,99","390,391,392"]
[{"$nulls":3},"закуска","сыр порционно","15","3,95","3,99","0,0","51,50",15]
[{"$nulls":3},"гор.напиток","напиток из свежих фруктов (75С)","200","0,34","0,17","21,46",103.5,"ТТК"]
[{"$nulls":3},"хлеб","Хлеб пшеничный ","45","3,42","0,36","22,14",105.75]
[{"$nulls":3},"гор.блюдо","макаронные изделия отварные","180/5","5,10","3,62","31,96","176,10"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F87)","v":0},{"$f":"SUM(G82:G87)","v":0},{"$f":"SUM(H82:H87)","v":0},{"$f":"SUM(I82:I87)","v":0},{"$f":"SUM(J82:J87)","v":209.25},null,{"$f":"SUM(L82:L87)","v":0}]
[{"$f":"A82","v":1},{"$f":"B82","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},{"$f":"SUM(H89:H97)","v":0},{"$f":"SUM(I89:I97)","v":0},{"$f":"SUM(J89:J97)","v":0},null,{"$f":"SUM(L89:L97)","v":0}]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F88+F98","v":0},{"$f":"G88+G98","v":0},{"$f":"H88+H98","v":0},{"$f":"I88+I98","v":0},{"$f":"J88+J98","v":209.25},null,{"$f":"L88+L98","v":0}]
[2,1,"Завтрак","гор.блюдо","Сырники из творога с кашей пшенной молочная с маслом сливочным","60/180/5",16.02,"18,13","42,98","386,40","ТТК"]
[{"$nulls":3},"гор.напиток","Чай \"витаминный\" с шиповником","185/10/5","0,24","0,09","12,43","54,2",376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,"1,9","0,2","12,3","58,75"]
[]
[]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной",30,"1,98","0,36","11,88",59.4]
[{"$nulls":3},"итого",null,{"$f":"SUM(F100:F105)","v":55},{"$f":"SUM(G100:G105)","v":16.02},{"$f":"SUM(H100:H105)","v":0},{"$f":"SUM(I100:I105)","v":0},{"$f":"SUM(J100:J105)","v":59.4},null,{"$f":"SUM(L100:L105)","v":0}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F107:F115)","v":0},{"$f":"SUM(G107:G115)","v":0},0,0,0,null,{"$f":"SUM(L107:L115)","v":0}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Итого за день:",null,null,{"$f":"F106+F116","v":55},{"$f":"G106+G116","v":16.02},{"$f":"H106+H116","v":0},{"$f":"I106+I116","v":0},{"$f":"J106+J116","v":59.4},null,0]
[2,2,"Завтрак","гор.блюдо","Плов из говядины с рисовой крупой","50/150","15,95","19,55","39,75",408.42,265]
[{"$nulls":3},"фрукты","Яблоки",100,0.4,"0,4","9,8",47]
[{"$nulls":3},"гор.напиток","Чай с сахаром","190/10","0,07","0,02","10,01",40,376]
[{"$nulls":3},"хлеб","Хлеб пшеничный",25,"1,9","0,2","12,3","58,75"]
[]
[{"$nulls":3},"хлеб черн.","Хлеб ржаной ",20,"1,32","0,24","7,92",39.6]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F118:F124)","v":145},{"$f":"SUM(G118:G124)","v":0.4},0,0,535.02,null,{"$f":"SUM(L118:L124)","v":0}]
[{"$f":"A118","v":2},{"$f":"B118","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F126:F134)","v":0},{"$f":"SUM(G126:G134)","v":0},0,0,0,null,{"$f":"SUM(L126:L134)","v":0}]
[{"$f":"A118","v":2},{"$f":"B118","v":2},"Итого за день:",null,null,{"$f":"F125+F135","v":145},{"$f":"G125+G135","v":0.4},{"$f":"H125+H135","v":0},{"$f":"I125+I135","v":0},{"$f":"J125+J135","v":535.02},null,0]
[2,3,"Завтрак","гор.блюдо","Пюре картофельное","150/3","3,08","6,25","20,47","150,45",312]
[]
[{"$nulls":3},"гор.напиток","Компот из свежих яблок",200,"0,16","0,16","17,9",200,342]
[{"$nulls":3},"хлеб","Хлеб пшеничный",35,"2,66","0,28","17,22","82,25"]
[{"$nulls":3},"доп.гарнир","салат из отварной свеклы",60,"0,84","3,61","4,96","55,68",52]
[{"$nulls":3},"гор.блюдо","Рыба, тушеная в томате с овощами","50/50","9,05","6,09","3,8",105,229]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F137:F143)","v":295},{"$f":"SUM(G137:G143)","v":0},0,0,305,null,{"$f":"SUM(L137:L143)","v":0}]
[{"$f":"A137","v":2},{"$f":"B137","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F145:F153)","v":0},{"$f":"SUM(G145:G153)","v":0},0,0,0,null,{"$f":"SUM(L145:L153)","v":0}]
[{"$f":"A137","v":2},{"$f":"B137","v":3},"Итого за день:",null,null,{"$f":"F144+F154","v":295},{"$f":"G144+G154","v":0},{"$f":"H144+H154","v":0},{"$f":"I144+I154","v":0},{"$f":"J144+J154","v":305},null,0]
[2,4,"Завтрак","гор.блюдо","Тефтели куриные с гречневой крупой в сметанно-томатном соусе","60/40","3,17","5,19","9,85","118,01"]
[]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,"4,08","3,54","7,6","78,6",382]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,"2,28","0,24","14,76","70,5"]
[]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные с маслом сливочным","180/3","6,64","7,6","31,78","221,94",203]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F156:F162)","v":230},{"$f":"SUM(G156:G162)","v":0},0,0,0,null,{"$f":"SUM(L156:L162)","v":0}]
[{"$f":"A156","v":2},{"$f":"B156","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F164:F172)","v":0},{"$f":"SUM(G164:G172)","v":0},0,0,0,null,{"$f":"SUM(L164:L172)","v":0}]
[{"$f":"A156","v":2},{"$f":"B156","v":4},"Итого за день:",null,null,{"$f":"F163+F173","v":230},{"$f":"G163+G173","v":0},{"$f":"H163+H173","v":0},{"$f":"I163+I173","v":0},{"$f":"J163+J173","v":0},null,0]
[2,5,"Завтрак","гор.блюдо","Овощи тушеные с мясом","50/150","12,48","15,68","19,34","271,5",143.241]
[]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,"0,66","0,09","22,03","92,8",349]
[{"$nulls":3},"хлеб","Хлеб пшеничный",30,"2,28","0,24","14,76","70,5"]
[{"$nulls":3},"фрукты","Яблоки",100,0.4,0.4,"9,8",47]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F175:F181)","v":330},{"$f":"SUM(G175:G181)","v":0.4},0.4,0,47,null,{"$f":"SUM(L175:L181)","v":0}]
[{"$f":"A175","v":2},{"$f":"B175","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F183:F191)","v":0},{"$f":"SUM(G183:G191)","v":0},0,0,0,null,{"$f":"SUM(L183:L191)","v":0}]
[{"$f":"A175","v":2},{"$f":"B175","v":5},"Итого за день:",null,null,{"$f":"F182+F192","v":330},{"$f":"G182+G192","v":0.4},{"$f":"H182+H192","v":0.4},{"$f":"I182+I192","v":0},{"$f":"J182+J192","v":47},null,0]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F43+F62+F81+F99+F117+F136+F155+F174+F193)/(IF(F24=0,0,1)+IF(F43=0,0,1)+IF(F62=0,0,1)+IF(F81=0,0,1)+IF(F99=0,0,1)+IF(F117=0,0,1)+IF(F136=0,0,1)+IF(F155=0,0,1)+IF(F174=0,0,1)+IF(F193=0,0,1))","v":180.71428571428572},{"$f":"(G24+G43+G62+G81+G99+G117+G136+G155+G174+G193)/(IF(G24=0,0,1)+IF(G43=0,0,1)+IF(G62=0,0,1)+IF(G81=0,0,1)+IF(G99=0,0,1)+IF(G117=0,0,1)+IF(G136=0,0,1)+IF(G155=0,0,1)+IF(G174=0,0,1)+IF(G193=0,0,1))","v":4.862499999999999},{"$f":"(H24+H43+H62+H81+H99+H117+H136+H155+H174+H193)/(IF(H24=0,0,1)+IF(H43=0,0,1)+IF(H62=0,0,1)+IF(H81=0,0,1)+IF(H99=0,0,1)+IF(H117=0,0,1)+IF(H136=0,0,1)+IF(H155=0,0,1)+IF(H174=0,0,1)+IF(H193=0,0,1))","v":1.53},{"$f":"(I24+I43+I62+I81+I99+I117+I136+I155+I174+I193)/(IF(I24=0,0,1)+IF(I43=0,0,1)+IF(I62=0,0,1)+IF(I81=0,0,1)+IF(I99=0,0,1)+IF(I117=0,0,1)+IF(I136=0,0,1)+IF(I155=0,0,1)+IF(I174=0,0,1)+IF(I193=0,0,1))","v":{"$error":"#DIV/0!"}},{"$f":"(J24+J43+J62+J81+J99+J117+J136+J155+J174+J193)/(IF(J24=0,0,1)+IF(J43=0,0,1)+IF(J62=0,0,1)+IF(J81=0,0,1)+IF(J99=0,0,1)+IF(J117=0,0,1)+IF(J136=0,0,1)+IF(J155=0,0,1)+IF(J174=0,0,1)+IF(J193=0,0,1))","v":297.07444444444445},null,{"$f":"(L24+L43+L62+L81+L99+L117+L136+L155+L174+L193)/(IF(L24=0,0,1)+IF(L43=0,0,1)+IF(L62=0,0,1)+IF(L81=0,0,1)+IF(L99=0,0,1)+IF(L117=0,0,1)+IF(L136=0,0,1)+IF(L155=0,0,1)+IF(L174=0,0,1)+IF(L193=0,0,1))","v":{"$error":"#DIV/0!"}}]