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

{"sheet":"Лист1","index":0,"n_rows":200,"n_cols":12,"rows_kept":200,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[43,2,43,3],[62,2,62,3],[82,2,82,3],[101,2,101,3],[120,2,120,3],[140,2,140,3],[159,2,159,3],[179,2,179,3],[198,2,198,3],[199,2,199,4]]}
["Школа",null,"МБОУ \"Школа №65\" г.Казань",null,null,"Утвердил:","должность","Директор школы"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Соркина Ж.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,10,2023]
[{"$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},"Обед","закуска","Салат-бар (огурцы свежие порциями, помидоры свежие порциями,фасоль консервированная, сухарики из пшеничного хлеба, масло растительное)",60,2,6,7,90,"ТТК 2023"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Грудка куриная в томатном соусе",90,10,6,3,113,"Акт 2021"]
[{"$nulls":3},"гарнир","Рис отварной",140,4,5,37,209,"№ 304/2015"]
[{"$nulls":3},"напиток","Напиток из замороженной черной смородины",200,0,0,11,44,"ТТК 2022"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F14:F22)","v":510},{"$f":"SUM(G14:G22)","v":17},18,67,502,null,66.8]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":510},{"$f":"G13+G23","v":17},18,67,502,null,{"$f":"L13+L23","v":66.8}]
[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,5,7,7,108,"ТТК 2023"]
[{"$nulls":3},"фрукт","Плоды свежие (яблоки)",100,0,0,10,47]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Жаркое по-домашнему",160,9,8,22,189,"ТТК 2023"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Напиток из вишни",200,0,1,31,131,"ТТК 2023"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F33:F42)","v":540},{"$f":"SUM(G33:G42)","v":15},{"$f":"SUM(H33:H42)","v":17},{"$f":"SUM(I33:I42)","v":79},{"$f":"SUM(J33:J42)","v":521},null,66.8]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F43","v":540},{"$f":"G32+G43","v":15},{"$f":"H32+H43","v":17},{"$f":"I32+I43","v":79},{"$f":"J32+J43","v":521},null,{"$f":"L32+L43","v":66.8}]
[1,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F51)","v":0},{"$f":"SUM(G45:G51)","v":0},{"$f":"SUM(H45:H51)","v":0},{"$f":"SUM(I45:I51)","v":0},{"$f":"SUM(J45:J51)","v":0},null,0]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Обед","закуска","Салат-бар (свекла отварная, морковь свежая порциями, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,6,15,7,125,"ТТК 2023"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Сосиски отварные",200,9,5,12,125,"№243/2015"]
[{"$nulls":3},"гарнир","Макароны отварные с сыром",140,5,7,30,201,"ТТК 2019"]
[{"$nulls":3},"напиток","Напиток яблочный",200,0,0,12,52,"№701/2004"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F53:F61)","v":620},{"$f":"SUM(G53:G61)","v":21},{"$f":"SUM(H53:H61)","v":28},{"$f":"SUM(I53:I61)","v":70},{"$f":"SUM(J53:J61)","v":549},null,66.8]
[{"$f":"A45","v":1},{"$f":"B45","v":3},"Итого за день:",null,null,{"$f":"F52+F62","v":620},{"$f":"G52+G62","v":21},{"$f":"H52+H62","v":28},{"$f":"I52+I62","v":70},{"$f":"J52+J62","v":549},null,66.8]
[1,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F64:F70)","v":0},{"$f":"SUM(G64:G70)","v":0},{"$f":"SUM(H64:H70)","v":0},{"$f":"SUM(I64:I70)","v":0},{"$f":"SUM(J64:J70)","v":0},null,0]
[{"$f":"A64","v":1},{"$f":"B64","v":4},"Обед","закуска","Салат-бар (помидоры свежие порциями, морковь свежая порциями, кукуруза консервированная, сухарики из пшеничного хлеба, масло растительное)",60,2,6,12,112,"ТТК 2023"]
[{"$nulls":3},"фрукт","Плоды свежие (яблоки)",100,0,0,10,47,"№338/2015"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Плов с куриными грудками",160,13,12,34,297,"ТТК 2023"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Сок",200,1,0,18,83,"ТТК 2022"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[{"$nulls":11},66.8]
[{"$nulls":3},"итого",null,{"$f":"SUM(F72:F81)","v":540},{"$f":"SUM(G72:G81)","v":17},{"$f":"SUM(H72:H81)","v":19},{"$f":"SUM(I72:I81)","v":83},{"$f":"SUM(J72:J81)","v":585},null,66.8]
[{"$f":"A64","v":1},{"$f":"B64","v":4},"Итого за день:",null,null,{"$f":"F71+F82","v":540},{"$f":"G71+G82","v":17},{"$f":"H71+H82","v":19},{"$f":"I71+I82","v":83},{"$f":"J71+J82","v":585},null,66.8]
[1,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F84:F90)","v":0},{"$f":"SUM(G84:G90)","v":0},{"$f":"SUM(H84:H90)","v":0},{"$f":"SUM(I84:I90)","v":0},{"$f":"SUM(J84:J90)","v":0},null,0]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Обед","закуска","Салат-бар ( морковь свежая порциями, капуста белокачанная, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,4,6,18,141,"ТТК 2023"]
[{"$nulls":3},"1 блюдо","Напиток яиз шиповника",200,0,0,12,52,"ТТК 2021"]
[{"$nulls":3},"2 блюдо","Биточки рыбные из фарша минтая",90,10,2,10,98,"ТТК 2021"]
[{"$nulls":3},"гарнир","Пюре картофельное с маслом сливочным",145,3,8,21,169,"№312/2015"]
[{"$nulls":3},"напиток","Напиток яиз шиповника",200,0,0,12,52,"ТТК 2021"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[{"$nulls":11},66.8]
[{"$nulls":3},"итого",null,{"$f":"SUM(F92:F100)","v":715},{"$f":"SUM(G92:G100)","v":18},{"$f":"SUM(H92:H100)","v":17},{"$f":"SUM(I92:I100)","v":82},{"$f":"SUM(J92:J100)","v":558},null,66.8]
[{"$f":"A84","v":1},{"$f":"B84","v":5},"Итого за день:",null,null,{"$f":"F91+F101","v":715},{"$f":"G91+G101","v":18},{"$f":"H91+H101","v":17},{"$f":"I91+I101","v":82},{"$f":"J91+J101","v":558},null,66.8]
[2,1,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F103:F109)","v":0},{"$f":"SUM(G103:G109)","v":0},0,0,0,null,{"$f":"SUM(L103:L109)","v":0}]
[{"$f":"A103","v":2},{"$f":"B103","v":1},"Обед","закуска","Салат бар (помидоры свежие порциями, огурцы свежие порциями, фасоль консервированная, сухарики из пшеничного хлеба, масло растительное)",60,2,6,12,113,"ТТК 2023"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Котлеты \"Столичные\"",90,8,4,3,83,"ТТК 2023"]
[{"$nulls":3},"гарнир","Макароны отварные с сыром",140,5,7,30,201,"ТТК 2019"]
[{"$nulls":3},"напиток","Напиток из замороженной черной смородины",200,0,0,11,44,"ТТК 2022"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F111:F119)","v":510},{"$f":"SUM(G111:G119)","v":16},18,65,487,null,66.8]
[{"$f":"A103","v":2},{"$f":"B103","v":1},"Итого за день:",null,null,{"$f":"F110+F120","v":510},{"$f":"G110+G120","v":16},{"$f":"H110+H120","v":18},{"$f":"I110+I120","v":65},{"$f":"J110+J120","v":487},null,66.8]
[2,2,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F128)","v":0},{"$f":"SUM(G122:G128)","v":0},0,0,0,null,{"$f":"SUM(L122:L128)","v":0}]
[{"$f":"A122","v":2},{"$f":"B122","v":2},"Обед","закуска","Салат бар (огурцы свежие порциями, капуста белокачанная, кукуруза консервированная, сухарики из пшеничного хлеба, масло растительное)",60,5,7,7,108,"ТТК 2023"]
[{"$nulls":3},"фрукт","Плоды свежие (яблоки)",100,0,0,10,47,"№330/2015"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Жаркое из птицы (грудки куриные)",262,13,11,29,262,"ТТК 2023"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Напиток из замороженной черной смородины",200,0,1,31,131,"ТТК 2023"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F130:F139)","v":642},{"$f":"SUM(G130:G139)","v":19},20,86,594,null,66.8]
[{"$f":"A122","v":2},{"$f":"B122","v":2},"Итого за день:",null,null,{"$f":"F129+F140","v":642},{"$f":"G129+G140","v":19},{"$f":"H129+H140","v":20},{"$f":"I129+I140","v":86},{"$f":"J129+J140","v":594},null,66.8]
[2,3,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F142:F148)","v":0},{"$f":"SUM(G142:G148)","v":0},0,0,0,null,{"$f":"SUM(L142:L148)","v":0}]
[{"$f":"A142","v":2},{"$f":"B142","v":3},"Обед","закуска","Салат - бар (свекла отварная, морковь  свежая порциями, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,3,6,29,125,"ТТК 2023"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Сосиски отварные",200,9,5,12,125,"№243/2015"]
[{"$nulls":3},"гарнир","Каша гречневая вязкая с маслом",145,3,8,21,167,"№303/2015"]
[{"$nulls":3},"напиток","Напиток яблочный",200,0,0,12,52,"№701/2004"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F150:F158)","v":625},{"$f":"SUM(G150:G158)","v":16},20,83,515,null,66.8]
[{"$f":"A142","v":2},{"$f":"B142","v":3},"Итого за день:",null,null,{"$f":"F149+F159","v":625},{"$f":"G149+G159","v":16},{"$f":"H149+H159","v":20},{"$f":"I149+I159","v":83},{"$f":"J149+J159","v":515},null,66.8]
[2,4,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F161:F167)","v":0},{"$f":"SUM(G161:G167)","v":0},0,0,0,null,{"$f":"SUM(L161:L167)","v":0}]
[{"$f":"A161","v":2},{"$f":"B161","v":4},"Обед","закуска","Салат бар (помидоры свежие порциями, морковь свежая порциями,  кукуруза консервированная, сухарики из пшеничного хлеба, масло растительное)",60,2,6,12,112,"ТТК 2023"]
[{"$nulls":3},"фрукт","Плоды свежие (яблоки)",100,0,0,10,47,"№338/2015"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо","Плов с говядиной",160,12,11,23,237,"ТТК 2021"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток","Напиток из замороженной черной смородины",200,0,1,11,44,"ТТК 2023"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F169:F178)","v":540},{"$f":"SUM(G169:G178)","v":15},19,65,486,null,66.8]
[{"$f":"A161","v":2},{"$f":"B161","v":4},"Итого за день:",null,null,{"$f":"F168+F179","v":540},{"$f":"G168+G179","v":15},{"$f":"H168+H179","v":19},{"$f":"I168+I179","v":65},{"$f":"J168+J179","v":486},null,66.8]
[2,5,"Завтрак","гор.блюдо"]
[]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F181:F187)","v":0},{"$f":"SUM(G181:G187)","v":0},0,0,0,null,{"$f":"SUM(L181:L187)","v":0}]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Обед","закуска","Салат бар (морковь свежая порциями, капуста белокачанная, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,4,6,18,141,"ТТК 2023"]
[{"$nulls":3},"1 блюдо","Сок",180,1,0,18,83,"ТТК 2022"]
[{"$nulls":3},"2 блюдо","Ёжики с мясом и рисом в соусе томатном",90,8,5,10,119,"ТТК 2020"]
[{"$nulls":3},"гарнир","Пюре картофельное",140,3,4,21,136,"№312/2015"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел.","Хлебная корзина",20,1,1,9,46]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F189:F197)","v":490},{"$f":"SUM(G189:G197)","v":17},16,76,525,null,66.8]
[{"$f":"A181","v":2},{"$f":"B181","v":5},"Итого за день:",null,null,{"$f":"F188+F198","v":490},{"$f":"G188+G198","v":17},{"$f":"H188+H198","v":16},{"$f":"I188+I198","v":76},{"$f":"J188+J198","v":525},null,66.8]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F24+F44+F63+F83+F102+F121+F141+F160+F180+F199)/(IF(F24=0,0,1)+IF(F44=0,0,1)+IF(F63=0,0,1)+IF(F83=0,0,1)+IF(F102=0,0,1)+IF(F121=0,0,1)+IF(F141=0,0,1)+IF(F160=0,0,1)+IF(F180=0,0,1)+IF(F199=0,0,1))","v":573.2},{"$f":"(G24+G44+G63+G83+G102+G121+G141+G160+G180+G199)/(IF(G24=0,0,1)+IF(G44=0,0,1)+IF(G63=0,0,1)+IF(G83=0,0,1)+IF(G102=0,0,1)+IF(G121=0,0,1)+IF(G141=0,0,1)+IF(G160=0,0,1)+IF(G180=0,0,1)+IF(G199=0,0,1))","v":17.1},{"$f":"(H24+H44+H63+H83+H102+H121+H141+H160+H180+H199)/(IF(H24=0,0,1)+IF(H44=0,0,1)+IF(H63=0,0,1)+IF(H83=0,0,1)+IF(H102=0,0,1)+IF(H121=0,0,1)+IF(H141=0,0,1)+IF(H160=0,0,1)+IF(H180=0,0,1)+IF(H199=0,0,1))","v":19.2},{"$f":"(I24+I44+I63+I83+I102+I121+I141+I160+I180+I199)/(IF(I24=0,0,1)+IF(I44=0,0,1)+IF(I63=0,0,1)+IF(I83=0,0,1)+IF(I102=0,0,1)+IF(I121=0,0,1)+IF(I141=0,0,1)+IF(I160=0,0,1)+IF(I180=0,0,1)+IF(I199=0,0,1))","v":75.6},{"$f":"(J24+J44+J63+J83+J102+J121+J141+J160+J180+J199)/(IF(J24=0,0,1)+IF(J44=0,0,1)+IF(J63=0,0,1)+IF(J83=0,0,1)+IF(J102=0,0,1)+IF(J121=0,0,1)+IF(J141=0,0,1)+IF(J160=0,0,1)+IF(J180=0,0,1)+IF(J199=0,0,1))","v":532.2},null,{"$f":"(L24+L44+L63+L83+L102+L121+L141+L160+L180+L199)/(IF(L24=0,0,1)+IF(L44=0,0,1)+IF(L63=0,0,1)+IF(L83=0,0,1)+IF(L102=0,0,1)+IF(L121=0,0,1)+IF(L141=0,0,1)+IF(L160=0,0,1)+IF(L180=0,0,1)+IF(L199=0,0,1))","v":66.79999999999998}]