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

{"sheet":"Лист1","index":0,"n_rows":195,"n_cols":12,"rows_kept":195,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[22,2,22,3],[41,2,41,3],[60,2,60,3],[79,2,79,3],[98,2,98,3],[117,2,117,3],[136,2,136,3],[155,2,155,3],[174,2,174,3],[193,2,193,3],[194,2,194,4]]}
["Школа",null,"МБОУ Лестранхозовская СОШ",null,null,"Утвердил:","должность","директор МБОУ Лестранхозовской СОШ"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","А.А. Щекочихина"]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",20,8,2025]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","каша вязкая молочная пшенная с изюмом",200,8.1,9.7,41.5,285.8,"54-7к"]
[{"$nulls":3},"гор.напиток","чай с сахаром",200,0.2,0,6.5,26.8,"54-2гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"сыр твердых сортов в нарезке",30,7,8.8,0,107.5,"54-1з"]
[{"$nulls":3},"фрукты","мандарин",100,1,0.2,7.5,35]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":560},{"$f":"SUM(G6:G11)","v":18.599999999999998},{"$f":"SUM(H6:H11)","v":18.9},{"$f":"SUM(I6:I11)","v":70.3},{"$f":"SUM(J6:J11)","v":525.4000000000001},null,{"$f":"SUM(L6:L11)","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(F13:F21)","v":0},{"$f":"SUM(G13:G21)","v":0},0,0,0,null,{"$f":"SUM(L13:L21)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F12+F22","v":560},{"$f":"G12+G22","v":18.599999999999998},18.9,70.3,525.4000000000001,null,{"$f":"L12+L22","v":0}]
[1,2,"Завтрак","гор.блюдо","картофельное пюре",150,3.2,5.2,19.8,139.4,"54-11г"]
[{"$nulls":3},"гор.напиток","чай с молоком и сахаром",200,1.6,1.1,8.7,65.9,"54-4гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"курица тушеная с морковью",100,14.1,5.7,4.4,152.4,"54-25м"]
[{"$nulls":3},"фрукты","яблоко",100,0.4,0.4,9.8,44.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F24:F30)","v":580},{"$f":"SUM(G24:G30)","v":21.599999999999998},{"$f":"SUM(H24:H30)","v":12.600000000000001},{"$f":"SUM(I24:I30)","v":57.5},{"$f":"SUM(J24:J30)","v":472.4},null,{"$f":"SUM(L24:L30)","v":0}]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},0,0,0,null,0]
[{"$f":"A24","v":1},{"$f":"B24","v":2},"Итого за день:",null,null,{"$f":"F31+F41","v":580},{"$f":"G31+G41","v":21.599999999999998},12.600000000000001,57.5,472.4,null,0]
[1,3,"Завтрак","гор.блюдо","каша жидкая молочная рисовая ",200,5.3,5.4,28.7,184.5,"54-25к"]
[{"$nulls":3},"гор.напиток","чай с лимоном и сахаром",200,0.3,0,6.7,27.9,"54-3гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"сыр (нарезка)",30,7,8.8,0,107.5,"54-1з"]
[{"$nulls":4},"ватрушка творожная",50,8.3,10.4,15,185.7,"54-1в"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F43:F49)","v":510},{"$f":"SUM(G43:G49)","v":23.2},{"$f":"SUM(H43:H49)","v":24.800000000000004},{"$f":"SUM(I43:I49)","v":65.2},{"$f":"SUM(J43:J49)","v":575.9},null,{"$f":"SUM(L43:L49)","v":0}]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F51:F59)","v":0},{"$f":"SUM(G51:G59)","v":0},0,0,0,null,0]
[{"$f":"A43","v":1},{"$f":"B43","v":3},"Итого за день:",null,null,{"$f":"F50+F60","v":510},{"$f":"G50+G60","v":23.2},24.800000000000004,65.2,575.9,null,0]
[1,4,"Завтрак","гор.блюдо","суп молочный с макаронными изделиями",200,5.5,4.5,17.9,134.2,"54-19к"]
[{"$nulls":3},"гор.напиток","какао с молоком сгущенным",200,3.5,3.3,22.3,133.4,"54-22гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"сыр (нарезка)",30,7,8.8,0,107.5,"54-1з"]
[{"$nulls":3},"фрукты","яблоко",100,0.4,0.4,9.8,44.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F62:F68)","v":560},{"$f":"SUM(G62:G68)","v":18.7},{"$f":"SUM(H62:H68)","v":17.2},{"$f":"SUM(I62:I68)","v":64.8},{"$f":"SUM(J62:J68)","v":489.8},null,{"$f":"SUM(L62:L68)","v":0}]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F70:F78)","v":0},{"$f":"SUM(G70:G78)","v":0},0,0,0,null,0]
[{"$f":"A62","v":1},{"$f":"B62","v":4},"Итого за день:",null,null,{"$f":"F69+F79","v":560},{"$f":"G69+G79","v":18.7},17.2,64.8,489.8,null,0]
[1,5,"Завтрак","гор.блюдо","пудинг из творога с яблоком",150,22.9,10.8,15.4,250.3,"54-4т"]
[{"$nulls":3},"гор.напиток","кофейный напиток с молоком",200,3.8,2.9,11.3,86,"54-23гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"повидло",30,0.1,0,19.5,78.5]
[{"$nulls":3},"фрукты","мандарин",100,0.8,0.2,7.5,35]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F81:F87)","v":510},{"$f":"SUM(G81:G87)","v":29.900000000000002},{"$f":"SUM(H81:H87)","v":14.1},{"$f":"SUM(I81:I87)","v":68.5},{"$f":"SUM(J81:J87)","v":520.1},null,{"$f":"SUM(L81:L87)","v":0}]
[{"$f":"A81","v":1},{"$f":"B81","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},0,0,0,null,0]
[{"$f":"A81","v":1},{"$f":"B81","v":5},"Итого за день:",null,null,{"$f":"F88+F98","v":510},{"$f":"G88+G98","v":29.900000000000002},14.1,68.5,520.1,null,0]
[2,1,"Завтрак","гор.блюдо","каша жидкая молочная кукурузная",200,5.8,5.8,33,207.9,"54-1к"]
[{"$nulls":3},"гор.напиток","какао с молоком сгущенным",200,3.5,3.3,22.3,133.4,"54-22гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"масло сливочное (порциями)",10,0.1,7.2,0.1,66.1,"53-19з"]
[{"$nulls":3},"фрукты","мандарин",100,0.8,0.2,7.5,35]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F100:F106)","v":540},{"$f":"SUM(G100:G106)","v":12.500000000000002},{"$f":"SUM(H100:H106)","v":16.7},{"$f":"SUM(I100:I106)","v":77.69999999999999},{"$f":"SUM(J100:J106)","v":512.7},null,{"$f":"SUM(L100:L106)","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(F108:F116)","v":0},{"$f":"SUM(G108:G116)","v":0},0,0,0,null,{"$f":"SUM(L108:L116)","v":0}]
[{"$f":"A100","v":2},{"$f":"B100","v":1},"Итого за день:",null,null,{"$f":"F107+F117","v":540},{"$f":"G107+G117","v":12.500000000000002},16.7,77.69999999999999,512.7,null,0]
[2,2,"Завтрак","гор.блюдо","сырники",150,29.4,8.6,31,319.1,"54-6т"]
[{"$nulls":3},"гор.напиток","чай с сахаром",200,0.2,0.4,6.5,26.8,"54-2гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"соус шоколадный",50,2.7,2.4,21.1,116.2,"54-7соус"]
[{"$nulls":3},"фрукты","яблоко",100,0.4,0,9.8,44.4]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F119:F125)","v":530},{"$f":"SUM(G119:G125)","v":35},{"$f":"SUM(H119:H125)","v":11.6},{"$f":"SUM(I119:I125)","v":83.2},576.8000000000001,null,{"$f":"SUM(L119:L125)","v":0}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F127:F135)","v":0},{"$f":"SUM(G127:G135)","v":0},0,0,0,null,{"$f":"SUM(L127:L135)","v":0}]
[{"$f":"A119","v":2},{"$f":"B119","v":2},"Итого за день:",null,null,{"$f":"F126+F136","v":530},{"$f":"G126+G136","v":35},11.6,83.2,576.8000000000001,null,0]
[2,3,"Завтрак","гор.блюдо","каша Дружба",200,5,5.8,24.1,168.9,"54-16к"]
[{"$nulls":3},"гор.напиток","чай с молоком и сахаром",200,1.6,1.1,8.7,65.9,"54-4гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"сыр твердых сортов в нарезке",30,7,8.8,0,108,"54-1з"]
[{"$nulls":4},"кекс столичный",50,2.7,8.3,23.9,181.8,"54-4в"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F138:F144)","v":510},{"$f":"SUM(G138:G144)","v":18.599999999999998},24.200000000000003,71.5,594.9000000000001,null,{"$f":"SUM(L138:L144)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F146:F154)","v":0},{"$f":"SUM(G146:G154)","v":0},0,0,0,null,{"$f":"SUM(L146:L154)","v":0}]
[{"$f":"A138","v":2},{"$f":"B138","v":3},"Итого за день:",null,null,{"$f":"F145+F155","v":510},{"$f":"G145+G155","v":18.599999999999998},24.200000000000003,71.5,594.9000000000001,null,0]
[2,4,"Завтрак","гор.блюдо","макароны отварные",150,{"v":5.4,"d":"5.40"},4.9,32.8,{"v":196.8,"d":"196.80"},"54-1г"]
[{"$nulls":3},"гор.напиток","кофейный напиток с молоком",200,3.8,2.9,11.3,{"v":86,"d":"86.00"},"54-23гн"]
[{"$nulls":3},"хлеб","хлеб",30,{"v":2.3,"d":"2"},0.2,14.8,{"v":70.3,"d":"70.30"}]
[{"$nulls":4},"тефтели из говядины с рисом",90,13.1,13.2,7.2,{"v":199.7,"d":"200"},"54-16м"]
[{"$nulls":4},"соус красный основной",50,1.7,1.2,4.5,35.4,"54-3соус"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F157:F163)","v":520},{"$f":"SUM(G157:G163)","v":26.3},22.4,70.6,588.1999999999999,null,{"$f":"SUM(L157:L163)","v":0}]
[{"$f":"A157","v":2},{"$f":"B157","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F173)","v":0},{"$f":"SUM(G165:G173)","v":0},0,0,0,null,{"$f":"SUM(L165:L173)","v":0}]
[{"$f":"A157","v":2},{"$f":"B157","v":4},"Итого за день:",null,null,{"$f":"F164+F174","v":520},{"$f":"G164+G174","v":26.3},22.4,70.6,588.1999999999999,null,0]
[2,5,"Завтрак","гор.блюдо","каша вязкая молочная овсянная",200,8.6,11.3,34.3,272.9,"54-9к"]
[{"$nulls":3},"гор.напиток","чай с сахаром",200,0.2,0,6.5,26.8,"54-2гн"]
[{"$nulls":3},"хлеб","хлеб",30,2.3,0.2,14.8,70.3]
[{"$nulls":4},"булочка школьная",70,6.1,2.1,39.7,201.4,"54-9в"]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F176:F181)","v":500},{"$f":"SUM(G176:G181)","v":17.199999999999996},{"$f":"SUM(H176:H181)","v":13.6},{"$f":"SUM(I176:I181)","v":95.3},{"$f":"SUM(J176:J181)","v":571.4},null,{"$f":"SUM(L176:L181)","v":0}]
[{"$f":"A176","v":2},{"$f":"B176","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F184:F192)","v":0},{"$f":"SUM(G184:G192)","v":0},0,0,0,null,{"$f":"SUM(L184:L192)","v":0}]
[{"$f":"A176","v":2},{"$f":"B176","v":5},"Итого за день:",null,null,{"$f":"F183+F193","v":500},{"$f":"G183+G193","v":17.199999999999996},13.6,95.3,571.4,null,0]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F23+F42+F61+F80+F99+F118+F137+F156+F175+F194)/(IF(F23=0,0,1)+IF(F42=0,0,1)+IF(F61=0,0,1)+IF(F80=0,0,1)+IF(F99=0,0,1)+IF(F118=0,0,1)+IF(F137=0,0,1)+IF(F156=0,0,1)+IF(F175=0,0,1)+IF(F194=0,0,1))","v":532},{"$f":"(G23+G42+G61+G80+G99+G118+G137+G156+G175+G194)/(IF(G23=0,0,1)+IF(G42=0,0,1)+IF(G61=0,0,1)+IF(G80=0,0,1)+IF(G99=0,0,1)+IF(G118=0,0,1)+IF(G137=0,0,1)+IF(G156=0,0,1)+IF(G175=0,0,1)+IF(G194=0,0,1))","v":22.16},17.61,72.46000000000001,542.76,null,{"$f":"(L23+L42+L61+L80+L99+L118+L137+L156+L175+L194)/(IF(L23=0,0,1)+IF(L42=0,0,1)+IF(L61=0,0,1)+IF(L80=0,0,1)+IF(L99=0,0,1)+IF(L118=0,0,1)+IF(L137=0,0,1)+IF(L156=0,0,1)+IF(L175=0,0,1)+IF(L194=0,0,1))","v":{"$error":"#DIV/0!"}}]