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

{"sheet":"Лист1","index":0,"n_rows":172,"n_cols":12,"rows_kept":172,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[21,2,21,3],[37,2,37,3],[54,2,54,3],[70,2,70,3],[87,2,87,3],[104,2,104,3],[120,2,120,3],[137,2,137,3],[153,2,153,3],[170,2,170,3],[171,2,171,4]]}
["Школа",null,"МБОУ \"Школа №65\"г.Казань",null,null,"Утвердил:","должность","директор школы №65"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Соркина Ж.В."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",1,4,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты \"Аппетитные\" мясо-куриные",90,13.79,13.05,7.99,205,"ТТК 2022"]
[{"$nulls":3},"гор.блюдо","Рис отварной",150,2.3,1.6,38.6,178,"№303/2015"]
[{"$nulls":3},"закуска","Овощи натуральные свежие (огурцы)",15,0.01,0.01,0.28,2,"№71/2015"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,0,7.99,32,"№630/1996г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F10)","v":503},{"$f":"SUM(G6:G10)","v":18.64},{"$f":"SUM(H6:H10)","v":15.02},{"$f":"SUM(I6:I10)","v":73.7},{"$f":"SUM(J6:J10)","v":506},null,66.8]
[{"$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(F12:F20)","v":0},{"$f":"SUM(G12:G20)","v":0},0,0,0,null,{"$f":"SUM(L12:L20)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F11+F21","v":503},{"$f":"G11+G21","v":18.64},15.02,73.7,506,null,{"$f":"L11+L21","v":66.8}]
[1,2,"Завтрак","фрукты","Десерт фруктовый (яблоки)",60,0.24,0.24,5.88,27,"№532/2013г"]
[{"$nulls":3},"гор.блюдо","Жаркое по-домашнему",200,15.58,17.16,31.02,341,"ТТК 2023 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,0,7.99,32,"№630/1996 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F23:F26)","v":508},{"$f":"SUM(G23:G26)","v":18.36},{"$f":"SUM(H23:H26)","v":17.759999999999998},{"$f":"SUM(I23:I26)","v":63.730000000000004},{"$f":"SUM(J23:J26)","v":489},null,66.8]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F28:F36)","v":0},{"$f":"SUM(G28:G36)","v":0},{"$f":"SUM(H28:H36)","v":0},{"$f":"SUM(I28:I36)","v":0},{"$f":"SUM(J28:J36)","v":0},null,0]
[{"$f":"A23","v":1},{"$f":"B23","v":2},"Итого за день:",null,null,{"$f":"F27+F37","v":508},{"$f":"G27+G37","v":18.36},{"$f":"H27+H37","v":17.759999999999998},{"$f":"I27+I37","v":63.730000000000004},{"$f":"J27+J37","v":489},null,66.8]
[1,3,"Завтрак","гор.блюдо","Гуляш из птицы",90,11.85,13.79,2.95,183,"ТТК 2021 г"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.64,4.46,35.94,206,"№202/2015 г"]
[{"$nulls":3},"закуска","Овощи натуральные свежие (помидоры)",15,0.16,0.03,0.57,3,"№71/2015 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",208,0.02,0,7.99,32,"№630/1996г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F39:F43)","v":503},{"$f":"SUM(G39:G43)","v":20.189999999999998},{"$f":"SUM(H39:H43)","v":18.64},{"$f":"SUM(I39:I43)","v":66.29},{"$f":"SUM(J39:J43)","v":513},null,66.8]
[{"$f":"A39","v":1},{"$f":"B39","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F45:F53)","v":0},{"$f":"SUM(G45:G53)","v":0},{"$f":"SUM(H45:H53)","v":0},{"$f":"SUM(I45:I53)","v":0},{"$f":"SUM(J45:J53)","v":0},null,0]
[{"$f":"A39","v":1},{"$f":"B39","v":3},"Итого за день:",null,null,{"$f":"F44+F54","v":503},{"$f":"G44+G54","v":20.189999999999998},{"$f":"H44+H54","v":18.64},{"$f":"I44+I54","v":66.29},{"$f":"J44+J54","v":513},null,66.8]
[1,4,"Завтрак","фрукты","Десерт фруктовый (яблоки)",60,0.24,0.24,5.88,27,"№532/2013 г"]
[{"$nulls":3},"гор.блюдо","Плов с птицей",200,15.44,19.29,45.88,419,"ТТК 2021 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",213,0.06,0.01,8.14,33,"ТТК 2021 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F56:F59)","v":513},{"$f":"SUM(G56:G59)","v":18.26},{"$f":"SUM(H56:H59)","v":19.9},{"$f":"SUM(I56:I59)","v":78.74000000000001},{"$f":"SUM(J56:J59)","v":568},null,66.8]
[{"$f":"A56","v":1},{"$f":"B56","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F61:F69)","v":0},{"$f":"SUM(G61:G69)","v":0},{"$f":"SUM(H61:H69)","v":0},{"$f":"SUM(I61:I69)","v":0},{"$f":"SUM(J61:J69)","v":0},null,0]
[{"$f":"A56","v":1},{"$f":"B56","v":4},"Итого за день:",null,null,{"$f":"F60+F70","v":513},{"$f":"G60+G70","v":18.26},{"$f":"H60+H70","v":19.9},{"$f":"I60+I70","v":78.74000000000001},{"$f":"J60+J70","v":568},null,66.8]
[1,5,"Завтрак","гор.блюдо","Ёжики рыбные с рисом и овощами",90,11.4,8.6,15.04,183,"ТТК 2023 г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.28,6.1,26.1,172,"№312/2015 г"]
[{"$nulls":3},"закуска","Овощи натуральные свежие (огурцы)",15,0.1,0.01,0.28,2,"№71/2015 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",208,0.02,0,7.99,32,"№630/1996г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F72:F76)","v":503},{"$f":"SUM(G72:G76)","v":17.32},{"$f":"SUM(H72:H76)","v":15.069999999999999},{"$f":"SUM(I72:I76)","v":68.25},{"$f":"SUM(J72:J76)","v":478},null,66.8]
[{"$f":"A72","v":1},{"$f":"B72","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F78:F86)","v":0},{"$f":"SUM(G78:G86)","v":0},{"$f":"SUM(H78:H86)","v":0},{"$f":"SUM(I78:I86)","v":0},{"$f":"SUM(J78:J86)","v":0},null,0]
[{"$f":"A72","v":1},{"$f":"B72","v":5},"Итого за день:",null,null,{"$f":"F77+F87","v":503},{"$f":"G77+G87","v":17.32},{"$f":"H77+H87","v":15.069999999999999},{"$f":"I77+I87","v":68.25},{"$f":"J77+J87","v":478},null,66.8]
[2,1,"Завтрак","гор.блюдо","Ёжики с мясом и рисом в соусе томатном",100,9.56,10.19,7.23,167,"ТТК 2020"]
[{"$nulls":3},"гор.блюдо","Макаронные изделия отварные",150,5.64,4.47,35.94,207,"№202/2015"]
[{"$nulls":3},"закуска","Овощи натуральные свежие (огурцы)",15,0.01,0.01,0.28,2,"№71/2015"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,0,7.99,32,"№630/1996г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F89:F93)","v":513},{"$f":"SUM(G89:G93)","v":17.75},{"$f":"SUM(H89:H93)","v":15.03},{"$f":"SUM(I89:I93)","v":70.28},{"$f":"SUM(J89:J93)","v":497},null,66.8]
[{"$f":"A89","v":2},{"$f":"B89","v":1},"Обед","закуска"]
[{"$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},0,0,0,null,{"$f":"SUM(L95:L103)","v":0}]
[{"$f":"A89","v":2},{"$f":"B89","v":1},"Итого за день:",null,null,{"$f":"F94+F104","v":513},{"$f":"G94+G104","v":17.75},{"$f":"H94+H104","v":15.03},{"$f":"I94+I104","v":70.28},{"$f":"J94+J104","v":497},null,66.8]
[2,2,"Завтрак","фрукты","Десерт фруктовый (яблоки)",60,0.24,0.24,5.88,27,"№532/2013г"]
[{"$nulls":3},"гор.блюдо","Жаркое из птицы",200,11.39,16.75,29.09,313,"ТТК 2023 г"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.06,18.46,78,"ТТК 2023 г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F106:F109)","v":500},{"$f":"SUM(G106:G109)","v":14.950000000000001},{"$f":"SUM(H106:H109)","v":17.409999999999997},{"$f":"SUM(I106:I109)","v":72.27},{"$f":"SUM(J106:J109)","v":507},null,66.8]
[{"$f":"A106","v":2},{"$f":"B106","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F111:F119)","v":0},{"$f":"SUM(G111:G119)","v":0},0,0,0,null,{"$f":"SUM(L111:L119)","v":0}]
[{"$f":"A106","v":2},{"$f":"B106","v":2},"Итого за день:",null,null,{"$f":"F110+F120","v":500},{"$f":"G110+G120","v":14.950000000000001},{"$f":"H110+H120","v":17.409999999999997},{"$f":"I110+I120","v":72.27},{"$f":"J110+J120","v":507},null,66.8]
[2,3,"Завтрак","гор.блюдо","Котлеты \"Аппетитные\" мясщ-куриные",90,205,13.79,13.05,7.99,"ТТК 2022 г"]
[{"$nulls":3},"гор.блюдо","Каша гречневая вязкая",150,165,2.89,4.03,29.13,"№303/2015 г"]
[{"$nulls":3},"закуска","Овощи натуральные свежие (помидоры)",15,3,0.16,0.03,0.57,"№71/2015 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",213,33,0.06,0.01,8.14,"№630/1996г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,89,2.52,0.36,18.84]
[{"$nulls":3},"итого",null,{"$f":"SUM(F122:F126)","v":508},{"$f":"SUM(G122:G126)","v":495},{"$f":"SUM(H122:H126)","v":19.419999999999998},{"$f":"SUM(I122:I126)","v":17.480000000000004},{"$f":"SUM(J122:J126)","v":64.67},null,66.8]
[{"$f":"A122","v":2},{"$f":"B122","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F128:F136)","v":0},{"$f":"SUM(G128:G136)","v":0},0,0,0,null,{"$f":"SUM(L128:L136)","v":0}]
[{"$f":"A122","v":2},{"$f":"B122","v":3},"Итого за день:",null,null,{"$f":"F127+F137","v":508},{"$f":"G127+G137","v":495},{"$f":"H127+H137","v":19.419999999999998},{"$f":"I127+I137","v":17.480000000000004},{"$f":"J127+J137","v":64.67},null,66.8]
[2,4,"Завтрак","фрукты","Десерт фруктовый (яблоки)",60,0.24,0.24,5.88,27,"№532/2013 г"]
[{"$nulls":3},"гор.блюдо","Плов с говядиной",200,12.22,15.61,46.03,373,"ТТК 2021 г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",208,0.02,0,7.99,32,"№630/2015"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F142)","v":508},{"$f":"SUM(G139:G142)","v":15},{"$f":"SUM(H139:H142)","v":16.21},{"$f":"SUM(I139:I142)","v":78.74000000000001},{"$f":"SUM(J139:J142)","v":521},null,66.8]
[{"$f":"A139","v":2},{"$f":"B139","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F144:F152)","v":0},{"$f":"SUM(G144:G152)","v":0},0,0,0,null,{"$f":"SUM(L144:L152)","v":0}]
[{"$f":"A139","v":2},{"$f":"B139","v":4},"Итого за день:",null,null,{"$f":"F143+F153","v":508},{"$f":"G143+G153","v":15},{"$f":"H143+H153","v":16.21},{"$f":"I143+I153","v":78.74000000000001},{"$f":"J143+J153","v":521},null,66.8]
[2,5,"Завтрак","гор.блюдо","Биточки рыбные из фарша минтая",90,11.01,8.5,6.03,145,"ТТК 2021 г"]
[{"$nulls":3},"гор.блюдо","Пюре картофельное",150,3.28,6.1,26.1,172,"№312/2015 г"]
[{"$nulls":3},"закуска","Овощи натуральные свежие (огурцы)",20,0.14,0.02,0.38,2,"№71/2015 г"]
[{"$nulls":3},"гор.напиток","Напиток из урюка",200,0.8,0.06,18.46,78,"ТТК 2023 г."]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",40,2.52,0.36,18.84,89]
[{"$nulls":3},"итого",null,{"$f":"SUM(F155:F159)","v":500},{"$f":"SUM(G155:G159)","v":17.75},{"$f":"SUM(H155:H159)","v":15.04},{"$f":"SUM(I155:I159)","v":69.81},{"$f":"SUM(J155:J159)","v":486},null,66.8]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F161:F169)","v":0},{"$f":"SUM(G161:G169)","v":0},0,0,0,null,{"$f":"SUM(L161:L169)","v":0}]
[{"$f":"A155","v":2},{"$f":"B155","v":5},"Итого за день:",null,null,{"$f":"F160+F170","v":500},{"$f":"G160+G170","v":17.75},{"$f":"H160+H170","v":15.04},{"$f":"I160+I170","v":69.81},{"$f":"J160+J170","v":486},null,66.8]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F22+F38+F55+F71+F88+F105+F121+F138+F154+F171)/(IF(F22=0,0,1)+IF(F38=0,0,1)+IF(F55=0,0,1)+IF(F71=0,0,1)+IF(F88=0,0,1)+IF(F105=0,0,1)+IF(F121=0,0,1)+IF(F138=0,0,1)+IF(F154=0,0,1)+IF(F171=0,0,1))","v":505.9},{"$f":"(G22+G38+G55+G71+G88+G105+G121+G138+G154+G171)/(IF(G22=0,0,1)+IF(G38=0,0,1)+IF(G55=0,0,1)+IF(G71=0,0,1)+IF(G88=0,0,1)+IF(G105=0,0,1)+IF(G121=0,0,1)+IF(G138=0,0,1)+IF(G154=0,0,1)+IF(G171=0,0,1))","v":65.322},{"$f":"(H22+H38+H55+H71+H88+H105+H121+H138+H154+H171)/(IF(H22=0,0,1)+IF(H38=0,0,1)+IF(H55=0,0,1)+IF(H71=0,0,1)+IF(H88=0,0,1)+IF(H105=0,0,1)+IF(H121=0,0,1)+IF(H138=0,0,1)+IF(H154=0,0,1)+IF(H171=0,0,1))","v":16.949999999999996},{"$f":"(I22+I38+I55+I71+I88+I105+I121+I138+I154+I171)/(IF(I22=0,0,1)+IF(I38=0,0,1)+IF(I55=0,0,1)+IF(I71=0,0,1)+IF(I88=0,0,1)+IF(I105=0,0,1)+IF(I121=0,0,1)+IF(I138=0,0,1)+IF(I154=0,0,1)+IF(I171=0,0,1))","v":65.929},{"$f":"(J22+J38+J55+J71+J88+J105+J121+J138+J154+J171)/(IF(J22=0,0,1)+IF(J38=0,0,1)+IF(J55=0,0,1)+IF(J71=0,0,1)+IF(J88=0,0,1)+IF(J105=0,0,1)+IF(J121=0,0,1)+IF(J138=0,0,1)+IF(J154=0,0,1)+IF(J171=0,0,1))","v":462.967},null,{"$f":"(L22+L38+L55+L71+L88+L105+L121+L138+L154+L171)/(IF(L22=0,0,1)+IF(L38=0,0,1)+IF(L55=0,0,1)+IF(L71=0,0,1)+IF(L88=0,0,1)+IF(L105=0,0,1)+IF(L121=0,0,1)+IF(L138=0,0,1)+IF(L154=0,0,1)+IF(L171=0,0,1))","v":66.79999999999998}]