{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":196,"n_cols":11,"rows_kept":196,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,6,0,9],[1,6,1,9],[23,1,23,2],[42,1,42,2],[61,1,61,2],[80,1,80,2],[99,1,99,2],[118,1,118,2],[137,1,137,2],[156,1,156,2],[175,1,175,2],[194,1,194,2],[195,1,195,3]]}
[null,"МАОУ \"Троельжанская СОШ\"",null,null,"Утвердил:","должность","директор"]
[{"$nulls":5},"фамилия","Мясникова Т.А."]
[null,null,null,"7-11 лет",null,"дата",12,10,2023]
[{"$nulls":6},"день","месяц","год"]
["День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,"Завтрак","гор.блюдо","Тефтели рыб.с соусом /кар.пюре/капус.туш/булочка",310,88.76,443,17.35,16.3,56.35,{"$f":"SUM(E6:J6)","v":931.76}]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,4.5,60,0.1,null,15,{"$f":"SUM(E8:J8)","v":279.6}]
[null,null,"хлеб","Хлеб пшеничный ",30,3,71,2.28,0.24,14.76,{"$f":"SUM(E9:J9)","v":121.28}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E6:E12)","v":540},96.26,574,19.73,16.54,null,{"$f":"SUM(K6:K12)","v":1332.64}]
[{"$f":"A6","v":1},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E14:E22)","v":0},0,0,0,0,null,{"$f":"SUM(K14:K22)","v":0}]
[{"$f":"A6","v":1},"Итого за день:",null,null,{"$f":"E13+E23","v":540},96.26,574,19.73,16.54,null,{"$f":"K13+K23","v":1332.64}]
[2,"Завтрак","гор.блюдо","Фрикадельки из кур с соусом/каша гречневкая/огурец/сыр",305,83.06,440,21.8,25.21,33.81,{"$f":"SUM(E25:J25)","v":908.88}]
[]
[null,null,"гор.напиток","Напиток из шиповника",200,9.2,97,0.7,0.3,22.8,{"$f":"SUM(E27:J27)","v":330}]
[null,null,"хлеб","Хлеб пшеничный ",40,4,94,3.04,0.32,19.68,{"$f":"SUM(E28:J28)","v":161.04}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E25:E31)","v":545},96.26,631,25.54,25.83,null,{"$f":"SUM(K25:K31)","v":1399.92}]
[{"$f":"A25","v":2},"Обед","закуска","Вафли",60,0.84,0.99,23.19,105,null,8.96]
[null,null,"1 блюдо"]
[null,null,"2 блюдо","Тефтели из говядины в молочном соусе ",100,10.3,10.7,8,170,null,51.2]
[null,null,"гарнир","Картофельное пюре ",150,3.15,6.6,16.35,138,null,19.4]
[null,null,"напиток","Напиток из шиповника ",200,0.7,0.3,22.8,97,null,9.2]
[null,null,"хлеб бел."]
[null,null,"хлеб черн.","Хлеб ржаной ",30,1.98,0.36,10.02,52.2,null,3]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E33:E41)","v":540},16.97,18.95,80.36,562.2,null,{"$f":"SUM(K33:K41)","v":91.76}]
[{"$f":"A25","v":2},"Итого за день:",null,null,{"$f":"E32+E42","v":1085},113.23,649.95,105.9,588.03,null,{"$f":"K32+K42","v":1491.68}]
[3,"Завтрак","гор.блюдо","Тефтели из гов.в мол.соусе/рагу овощное/печенье ",310,78.23,576,17.66,26.81,65.79,{"$f":"SUM(E44:J44)","v":1074.49}]
[]
[null,null,"гор.напиток","Кофейный напиток с молоком ",200,15.03,79,3.2,2.7,15.9,{"$f":"SUM(E46:J46)","v":315.83}]
[null,null,"хлеб","Хлеб пшеничный ",30,3,71,2.28,0.24,14.76,{"$f":"SUM(E47:J47)","v":121.28}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E44:E50)","v":540},96.26,726,23.14,29.75,null,{"$f":"SUM(K44:K50)","v":1511.6}]
[{"$f":"A44","v":3},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E52:E60)","v":0},0,0,0,0,null,{"$f":"SUM(K52:K60)","v":0}]
[{"$f":"A44","v":3},"Итого за день:",null,null,{"$f":"E51+E61","v":540},96.26,726,23.14,29.75,null,{"$f":"K51+K61","v":1511.6}]
[4,"Завтрак","гор.блюдо","Биточки рыб.с соусом/рис отв./булочка ",310,77.29,488,18.12,11.93,76.76,{"$f":"SUM(E63:J63)","v":982.1}]
[]
[null,null,"гор.напиток","Какао с молоком ",200,15.97,144,3.6,3.3,25,{"$f":"SUM(E65:J65)","v":391.87}]
[null,null,"хлеб","Хлеб пшеничный ",30,3,71,2.28,0.24,14.76,{"$f":"SUM(E66:J66)","v":121.28}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E63:E69)","v":540},96.26,703,24,15.47,null,{"$f":"SUM(K63:K69)","v":1495.25}]
[{"$f":"A63","v":4},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E71:E79)","v":0},0,0,0,0,null,{"$f":"SUM(K71:K79)","v":0}]
[{"$f":"A63","v":4},"Итого за день:",null,null,{"$f":"E70+E80","v":540},96.26,703,24,15.47,null,{"$f":"K70+K80","v":1495.25}]
[5,"Завтрак","гор.блюдо","Фрикадельки из кур с соусом/мак.изд.отв/каб.икра/сыр",275,83.06,376,19.78,18.73,34.15,{"$f":"SUM(E82:J82)","v":806.72}]
[]
[null,null,"гор.напиток","Напиток из шиповника",200,9.2,97,1,0,23,{"$f":"SUM(E84:J84)","v":330.2}]
[null,null,"хлеб","Хлеб пшеничный ",40,4,94,3.04,0.32,19.68,{"$f":"SUM(E85:J85)","v":161.04}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E82:E88)","v":515},96.26,567,23.82,19.05,null,{"$f":"SUM(K82:K88)","v":1297.96}]
[{"$f":"A82","v":5},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E90:E98)","v":0},0,0,0,0,null,{"$f":"SUM(K90:K98)","v":0}]
[{"$f":"A82","v":5},"Итого за день:",null,null,{"$f":"E89+E99","v":515},96.26,567,23.82,19.05,null,{"$f":"K89+K99","v":1297.96}]
[1,"Завтрак","гор.блюдо","Тефтели из гов.с соусом/каша греч/булочка",310,78.39,585,21.47,25.36,67.75,{"$f":"SUM(E101:J101)","v":1087.97}]
[]
[null,null,"гор.напиток","Компот из смеси сухофруктов ",200,14.87,110,0.5,null,27,{"$f":"SUM(E103:J103)","v":352.37}]
[null,null,"хлеб","Хлеб пшеничный ",30,3,71,2,0,15,{"$f":"SUM(E104:J104)","v":121}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E101:E107)","v":540},96.26,766,23.97,25.36,null,{"$f":"SUM(K101:K107)","v":1561.34}]
[{"$f":"A101","v":1},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E109:E117)","v":0},0,0,0,0,null,{"$f":"SUM(K109:K117)","v":0}]
[{"$f":"A101","v":1},"Итого за день:",null,null,{"$f":"E108+E118","v":540},96.26,766,23.97,25.36,null,{"$f":"K108+K118","v":1561.34}]
[2,"Завтрак","гор.блюдо","Рыба.туш.с овощами/карт.пюре/кап.туш./вафли ",310,84.06,436,14.5,13.32,63.43,{"$f":"SUM(E120:J120)","v":921.31}]
[]
[null,null,"гор.напиток","Напиток из шиповника",200,9.2,97,1,0,23,{"$f":"SUM(E122:J122)","v":330.2}]
[null,null,"хлеб","Хлеб пшеничный ",30,3,71,2,0,15,{"$f":"SUM(E123:J123)","v":121}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E120:E126)","v":540},96.26,604,17.5,13.32,null,{"$f":"SUM(K120:K126)","v":1372.51}]
[{"$f":"A120","v":2},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E128:E136)","v":0},0,0,0,0,null,{"$f":"SUM(K128:K136)","v":0}]
[{"$f":"A120","v":2},"Итого за день:",null,null,{"$f":"E127+E137","v":540},96.26,604,17.5,13.32,null,{"$f":"K127+K137","v":1372.51}]
[3,"Завтрак","гор.блюдо","Фрикадельки из кур с соусом/мак.изд.отв/каб.икра /сгущ.мол.вар",275,77.23,373,16.1,15.21,45.25,{"$f":"SUM(E139:J139)","v":801.79}]
[]
[null,null,"гор.напиток","Кофейный напиток с молоком ",200,15.03,79,3,3,16,{"$f":"SUM(E141:J141)","v":316.03}]
[null,null,"хлеб","Хлеб пшеничный ",40,4,94,3,0,20,{"$f":"SUM(E142:J142)","v":161}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E139:E145)","v":515},96.26,546,22.1,18.21,null,{"$f":"SUM(K139:K145)","v":1278.82}]
[{"$f":"A139","v":3},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E147:E155)","v":0},0,0,0,0,null,{"$f":"SUM(K147:K155)","v":0}]
[{"$f":"A139","v":3},"Итого за день:",null,null,{"$f":"E146+E156","v":515},96.26,546,22.1,18.21,null,{"$f":"K146+K156","v":1278.82}]
[4,"Завтрак","гор.блюдо","Тефтели из гов.в мол.соусе/каша гречневая/Яблоко ",350,84.07,429,17.57,20.76,42.25,{"$f":"SUM(E158:J158)","v":943.65}]
[]
[null,null,"гор.напиток","Компот из свежих фруктов ",200,9.19,96,0.5,0.2,23.1,{"$f":"SUM(E160:J160)","v":328.99}]
[null,null,"хлеб","Хлеб пшеничный ",30,3,71,2,0,15,{"$f":"SUM(E161:J161)","v":121}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E158:E164)","v":580},96.26,596,20.07,20.96,null,{"$f":"SUM(K158:K164)","v":1393.64}]
[{"$f":"A158","v":4},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E166:E174)","v":0},0,0,0,0,null,{"$f":"SUM(K166:K174)","v":0}]
[{"$f":"A158","v":4},"Итого за день:",null,null,{"$f":"E165+E175","v":580},96.26,596,20.07,20.96,null,{"$f":"K165+K175","v":1393.64}]
[5,"Завтрак","гор.блюдо","Кнели из кур с соусом /рис отв/Яблоко ",350,77.23,436,14.45,18.75,51.75,{"$f":"SUM(E177:J177)","v":948.18}]
[]
[null,null,"гор.напиток","Кофейный напиток с молоком ",200,15.03,79,3.2,2.7,15.9,{"$f":"SUM(E179:J179)","v":315.83}]
[null,null,"хлеб","Хлеб пшеничный ",40,4,94,3,0,20,{"$f":"SUM(E180:J180)","v":161}]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E177:E183)","v":590},96.26,609,20.65,21.45,null,{"$f":"SUM(K177:K183)","v":1425.01}]
[{"$f":"A177","v":5},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E185:E193)","v":0},0,0,0,0,null,{"$f":"SUM(K185:K193)","v":0}]
[{"$f":"A177","v":5},"Итого за день:",null,null,{"$f":"E184+E194","v":590},96.26,609,20.65,21.45,null,{"$f":"K184+K194","v":1425.01}]
[null,"Среднее значение за период:",null,null,{"$f":"(E24+E43+E62+E81+E100+E119+E138+E157+E176+E195)/(IF(E24=0,0,1)+IF(E43=0,0,1)+IF(E62=0,0,1)+IF(E81=0,0,1)+IF(E100=0,0,1)+IF(E119=0,0,1)+IF(E138=0,0,1)+IF(E157=0,0,1)+IF(E176=0,0,1)+IF(E195=0,0,1))","v":598.5},97.957,634.095,30.088,76.814,null,{"$f":"(K24+K43+K62+K81+K100+K119+K138+K157+K176+K195)/(IF(K24=0,0,1)+IF(K43=0,0,1)+IF(K62=0,0,1)+IF(K81=0,0,1)+IF(K100=0,0,1)+IF(K119=0,0,1)+IF(K138=0,0,1)+IF(K157=0,0,1)+IF(K176=0,0,1)+IF(K195=0,0,1))","v":1416.045}]