{"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],[6,2,6,3],[23,2,23,3],[40,2,40,3],[56,2,56,3],[73,2,73,3],[90,2,90,3],[92,2,92,3],[109,2,109,3],[126,2,126,3],[142,2,142,3],[159,2,159,3],[176,2,176,3],[177,2,177,4],[194,2,194,3],[195,2,195,4]]}
["Школа",{"$nulls":4},"Утвердил:","должность"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",5,{"v":4,"d":"04"},2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[{"$nulls":3},"итого"]
[1,1,"Итого за день:"]
[1,2,"Завтрак","Салат","Салат \"Капуста квашеная\" (б/лука)",{"v":60,"d":"60.00"},1.08,3.33,5.13,{"v":54.8,"d":"54.80"},"ТТК-357н",8.14]
[{"$nulls":4},"Колбасные изд. отварные (сосиски) с овощ.(кукур.)",{"v":90,"d":"90.00"},9.32,12.32,2.69,158.91,"ттк №358н",38.14]
[{"$nulls":3},"Гарнир","Каша рисовая вязкая",{"v":150,"d":"150.00"},2.31,4.13,22.97,138.28,"510/04",8.77]
[{"$nulls":3},"Напиток","Компот \"Плодово-ягодный\" ассорти",{"v":200,"d":"200.00"},0.01,0.01,16.66,66.73,"ТТК-356н",7.02]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":530,"d":"530.00"},{"v":15,"d":"15.00"},20.06,62.36,489.91,null,65.16]
[1,2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[1,2,"Итого за день:",null,null,{"v":530,"d":"530.00"},{"v":15,"d":"15.00"},20.06,62.36,489.91,null,65.16]
[1,3,"Завтрак","Закуска","Маринад овощной с томатом",{"v":60,"d":"60.00"},0.77,6.05,{"v":5.4,"d":"5.40"},{"v":79.1,"d":"79.10"},"612/04",6.55]
[{"$nulls":4},"Котлеты \"Челнинские\" с овощами (зел.горош)",{"v":90,"d":"90.00"},12.14,17.08,12.84,253.67,"ТТК-490н",{"v":39.6,"d":"39.60"}]
[{"$nulls":3},"Гарнир","Пюре картофельное",{"v":150,"d":"150.00"},3.31,4.91,22.12,145.93,"520/04",21.54]
[{"$nulls":3},"Напиток","Напиток \"Плодово-ягодный\" из урюка",{"v":200,"d":"200.00"},0.51,0.08,19.38,80.23,"ТТК-258к",3.88]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":530,"d":"530.00"},19.01,28.39,74.65,630.12,null,74.66]
[1,3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[1,3,"Итого за день:",null,null,{"v":530,"d":"530.00"},19.01,28.39,74.65,630.12,null,74.66]
[1,4,"Завтрак","Фрукты","Десерт фруктовый Яблоко",{"v":100,"d":"100.00"},{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9,"d":"9.00"},{"v":41.2,"d":"41.20"},"ТТК-495н",12.55]
[{"$nulls":3},"Гор.блюдо","Творожник \"Зебра\" со сгущённым молоком",{"v":170,"d":"170.00"},28.96,12.85,36.74,378.45,"ТТК - 341к",75.15]
[{"$nulls":3},"Напиток","Чай с лимоном с пряником в ассортименте",{"v":237,"d":"237.00"},2.01,1.35,37.27,169.26,"686/04",9.19]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":537,"d":"537.00"},33.65,14.87,97.92,{"v":660.1,"d":"660.10"},null,99.98]
[1,4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[1,4,"Итого за день:",null,null,{"v":537,"d":"537.00"},33.65,14.87,97.92,{"v":660.1,"d":"660.10"},null,99.98]
[1,5,"Завтрак","Закуска","Салат из свеклы отварной",{"v":60,"d":"60.00"},1.16,3.67,6.82,{"v":65,"d":"65.00"},"52/11",3.97]
[{"$nulls":4},"Фрикадельки \"Особые\" с соусом томатным",{"v":100,"d":"100.00"},5.35,{"v":14.3,"d":"14.30"},8.75,185.09,"ТТК-652к",{"v":28.3,"d":"28.30"}]
[{"$nulls":3},"Гарнир","(А) Каша гречневая вязкая",{"v":150,"d":"150.00"},4.59,5.35,24.79,165.69,"ТТК-187а",{"v":2.6,"d":"2.60"}]
[{"$nulls":3},"Гор. напиток","Кофейный напиток полусладкий",{"v":200,"d":"200.00"},3.02,5.22,{"v":15.9,"d":"15.90"},122.65,"ТТК-343н",{"v":8.9,"d":"8.90"}]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":540,"d":"540.00"},{"v":16.4,"d":"16.40"},28.81,71.17,609.62,null,46.86]
[1,5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[1,5,"Итого за день:",null,null,{"v":540,"d":"540.00"},{"v":16.4,"d":"16.40"},28.81,71.17,609.62,null,46.86]
[1,6,"Завтрак","Фрукты","Десерт фруктовый Яблоко",{"v":100,"d":"100.00"},{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9,"d":"9.00"},{"v":41.2,"d":"41.20"},"ТТК-495н",12.55]
[{"$nulls":4},"Биточки \"Рябушка\" с овощами (кукур. зам.)",{"v":90,"d":"90.00"},10.63,16.52,15.58,253.52,"ТТК-84н",26.07]
[{"$nulls":3},"Гарнир","Пюре из бобовых \"Янтарное\"",{"v":150,"d":"150.00"},16.96,4.98,37.41,262.32,"ТТК-446",9.35]
[{"$nulls":3},"Гор. напиток","Чай полусладкий",{"v":200,"d":"200.00"},{"v":0.2,"d":"0.20"},0.05,5.06,{"v":21.5,"d":"21.50"},"ТТК-475",{"v":1.1,"d":"1.10"}]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":570,"d":"570.00"},30.47,22.22,81.96,649.73,null,52.16]
[1,6,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[1,6,"Итого за день:",null,null,{"v":570,"d":"570.00"},30.47,22.22,81.96,649.73,null,52.16]
[{"$nulls":3},"итого"]
[2,1,"Итого за день:"]
[2,2,"Завтрак","Салат","Салат \"Капуста квашеная\" (б/лука)",{"v":60,"d":"60.00"},1.08,3.33,5.13,{"v":54.8,"d":"54.80"},"ТТК-357н",8.14]
[{"$nulls":4},"Колбасные изд. отварные (сосиски) с овощ.(кукур.)",{"v":90,"d":"90.00"},9.32,12.32,2.69,158.91,"ттк №358н",38.14]
[{"$nulls":3},"Гарнир","Каша рисовая вязкая",{"v":150,"d":"150.00"},2.31,4.13,22.97,138.28,"510/04",8.77]
[{"$nulls":3},"Напиток","Компот \"Плодово-ягодный\" ассорти",{"v":200,"d":"200.00"},0.01,0.01,16.66,66.73,"ТТК-356н",7.02]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":530,"d":"530.00"},{"v":15,"d":"15.00"},20.06,62.36,489.91,null,65.16]
[2,2,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[2,2,"Итого за день:",null,null,{"v":530,"d":"530.00"},{"v":15,"d":"15.00"},20.06,62.36,489.91,null,65.16]
[2,3,"Завтрак","Закуска","Маринад овощной с томатом",{"v":60,"d":"60.00"},0.77,6.05,{"v":5.4,"d":"5.40"},{"v":79.1,"d":"79.10"},"612/04",6.55]
[{"$nulls":4},"Котлеты \"Челнинские\" с овощами (зел.горош)",{"v":90,"d":"90.00"},12.14,17.08,12.84,253.67,"ТТК-490н",{"v":39.6,"d":"39.60"}]
[{"$nulls":3},"Гарнир","Пюре картофельное",{"v":150,"d":"150.00"},3.31,4.91,22.12,145.93,"520/04",21.54]
[{"$nulls":3},"Напиток","Напиток \"Плодово-ягодный\" из урюка",{"v":200,"d":"200.00"},0.51,0.08,19.38,80.23,"ТТК-258к",3.88]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":530,"d":"530.00"},19.01,28.39,74.65,630.12,null,74.66]
[2,3,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[2,3,"Итого за день:",null,null,{"v":530,"d":"530.00"},19.01,28.39,74.65,630.12,null,74.66]
[2,4,"Завтрак","Фрукты","Десерт фруктовый Яблоко",{"v":100,"d":"100.00"},{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9,"d":"9.00"},{"v":41.2,"d":"41.20"},"ТТК-495н",12.55]
[{"$nulls":3},"Гор.блюдо","Творожник \"Зебра\" со сгущённым молоком",{"v":170,"d":"170.00"},28.96,12.85,36.74,378.45,"ТТК - 341к",75.15]
[{"$nulls":3},"Напиток","Чай с лимоном с пряником в ассортименте",{"v":237,"d":"237.00"},2.01,1.35,37.27,169.26,"686/04",9.19]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":537,"d":"537.00"},33.65,14.87,97.92,{"v":660.1,"d":"660.10"},null,99.98]
[2,4,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[2,4,"Итого за день:",null,null,{"v":537,"d":"537.00"},33.65,14.87,97.92,{"v":660.1,"d":"660.10"},null,99.98]
[2,5,"Завтрак","Закуска","Салат из свеклы отварной",{"v":60,"d":"60.00"},1.16,3.67,6.82,{"v":65,"d":"65.00"},"52/11",3.97]
[{"$nulls":4},"Фрикадельки \"Особые\" с соусом томатным",{"v":100,"d":"100.00"},5.35,{"v":14.3,"d":"14.30"},8.75,185.09,"ТТК-652к",{"v":28.3,"d":"28.30"}]
[{"$nulls":3},"Гарнир","(А) Каша гречневая вязкая",{"v":150,"d":"150.00"},4.59,5.35,24.79,165.69,"ТТК-187а",{"v":2.6,"d":"2.60"}]
[{"$nulls":3},"Гор. напиток","Кофейный напиток полусладкий",{"v":200,"d":"200.00"},3.02,5.22,{"v":15.9,"d":"15.90"},122.65,"ТТК-343н",{"v":8.9,"d":"8.90"}]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":540,"d":"540.00"},{"v":16.4,"d":"16.40"},28.81,71.17,609.62,null,46.86]
[2,5,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[2,5,"Итого за день:",null,null,{"v":540,"d":"540.00"},{"v":16.4,"d":"16.40"},28.81,71.17,609.62,null,46.86]
[2,6,"Завтрак","Фрукты","Десерт фруктовый Яблоко",{"v":100,"d":"100.00"},{"v":0.4,"d":"0.40"},{"v":0.4,"d":"0.40"},{"v":9,"d":"9.00"},{"v":41.2,"d":"41.20"},"ТТК-495н",12.55]
[{"$nulls":4},"Биточки \"Рябушка\" с овощами (кукур. зам.)",{"v":90,"d":"90.00"},10.63,16.52,15.58,253.52,"ТТК-84н",26.07]
[{"$nulls":3},"Гарнир","Пюре из бобовых \"Янтарное\"",{"v":150,"d":"150.00"},16.96,4.98,37.41,262.32,"ТТК-446",9.35]
[{"$nulls":3},"Гор. напиток","Чай полусладкий",{"v":200,"d":"200.00"},{"v":0.2,"d":"0.20"},0.05,5.06,{"v":21.5,"d":"21.50"},"ТТК-475",{"v":1.1,"d":"1.10"}]
[{"$nulls":3},"Хлеб","Хлеб \"Рябинушка\"",{"v":30,"d":"30.00"},2.28,0.27,14.91,71.19,null,3.09]
[{"$nulls":3},"итого",null,{"v":570,"d":"570.00"},30.47,22.22,81.96,649.73,null,52.16]
[2,6,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,0,0,0,0,0,null,0]
[2,6,"Итого за день:",null,null,{"v":570,"d":"570.00"},30.47,22.22,81.96,649.73,null,52.16]
[null,null,"Среднее значение за период:",null,null,{"v":541.4,"d":"541.40"},22.91,22.87,77.61,{"v":607.9,"d":"607.90"},null,67.76]
[{"$nulls":3},"гор.напиток"]
[{"$nulls":3},"хлеб"]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F177:F183)","v":1111.4},{"$f":"SUM(G177:G183)","v":53.379999999999995},45.09,159.57,1257.63,null,{"$f":"SUM(L177:L183)","v":119.92}]
[{"$f":"A177","v":2},{"$f":"B177","v":6},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F185:F193)","v":0},{"$f":"SUM(G185:G193)","v":0},0,0,0,null,{"$f":"SUM(L185:L193)","v":0}]
[{"$f":"A177","v":2},{"$f":"B177","v":6},"Итого за день:",null,null,{"$f":"F184+F194","v":1111.4},{"$f":"G184+G194","v":53.379999999999995},{"$f":"H184+H194","v":45.09},{"$f":"I184+I194","v":159.57},{"$f":"J184+J194","v":1257.63},null,119.92]
[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":460.35},{"$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":24.905},19.567500000000003,68.395,549.2950000000001,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":65.83}]