{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":187,"n_cols":12,"rows_kept":187,"cut":false,"hidden":false,"merged":[[186,2,186,4],[76,2,76,3],[0,2,0,4],[0,7,0,10],[1,7,1,10],[41,2,41,3],[24,2,24,3],[59,2,59,3],[185,2,185,3],[95,2,95,3],[168,2,168,3],[150,2,150,3],[131,2,131,3],[113,2,113,3]]}
["Школа",null,"МКОУ \"Косякинская СОШ\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Алиев Ахмед Наннаевич "]
["Возрастная категория",null,null,null,"7-11 лет",null,"дата",1.0,10.0,2023.0]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1.0,1.0]
{"$rows_empty":8}
[{"$f":"A6","v":1.0},{"$f":"B6","v":1.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Борщ с капустой и картофелем ",200.0,1.45,12.85,21.2,184.3,27.0,16.383]
[null,null,null,"2 блюдо","Каша ячневая рассыпчатая",120.0,6.03,4.53,28.94,186.29,9.0,38.617]
[null,null,null,"гарнир","Люля",45.0,7.0,6.55,7.07,102.94,2.0,1.71]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,20.0,2.32]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,9.0]
[{"$nulls":4},"Яблоки",100.0,0.55,0.55,13.64,40.92,50.0,3.68]
[]
[{"$nulls":4},"Печенье",16.0,1.1,0.75,10.0,20.65]
[null,null,null,"итого",null,{"$f":"SUM(F15:F23)","v":721.0},{"$f":"SUM(G15:G23)","v":20.05},{"$f":"SUM(H15:H23)","v":25.71},{"$f":"SUM(I15:I23)","v":114.17999999999999},{"$f":"SUM(J15:J23)","v":715.42},null,{"$f":"SUM(L15:L23)","v":71.71000000000001}]
[{"$f":"A6","v":1.0},{"$f":"B6","v":1.0},"Итого за день:",null,null,{"$f":"F14+F24","v":721.0},{"$f":"G14+G24","v":20.05},{"$f":"H14+H24","v":25.71},{"$f":"I14+I24","v":114.18},{"$f":"J14+J24","v":715.42},null,{"$f":"L14+L24","v":71.71}]
[1.0,2.0]
[]
[]
[]
[]
[]
[]
[{"$f":"A26","v":1.0},{"$f":"B26","v":2.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп гороховый вегит.",200.0,2.9,2.95,8.06,109.66,56.0,3.9874]
[null,null,null,"2 блюдо","Пюре картофельное ",140.0,6.43,11.85,56.19,233.35,39.0,41.594]
[null,null,null,"гарнир","Люля",45.0,7.0,6.55,7.07,102.94,2.0]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,null,1.71]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Яблоки",90.0,0.5,0.5,12.28,36.83,50.0,8.1]
[{"$nulls":4},"Кексы",33.33,0.1,0.38,6.01,8.4,null,13.998599999999998]
[null,null,null,"итого",null,{"$f":"SUM(F33:F40)","v":748.33},{"$f":"SUM(G33:G40)","v":20.85},{"$f":"SUM(H33:H40)","v":22.71},{"$f":"SUM(I33:I40)","v":122.94},{"$f":"SUM(J33:J40)","v":671.5},null,{"$f":"SUM(L33:L40)","v":71.71000000000001}]
[{"$f":"A26","v":1.0},{"$f":"B26","v":2.0},"Итого за день:",null,null,{"$f":"F32+F41","v":748.33},{"$f":"G32+G41","v":20.85},{"$f":"H32+H41","v":22.71},{"$f":"I32+I41","v":122.94},{"$f":"J32+J41","v":671.5},null,{"$f":"L32+L41","v":71.71}]
[1.0,3.0]
{"$rows_empty":7}
[{"$f":"A43","v":1.0},{"$f":"B43","v":3.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Щи из капусты с курицей",250.0,2.0,5.0,11.0,100.0,54.0,16.497]
[null,null,null,"2 блюдо","Макароны отварные",125.0,5.52,4.52,26.45,132.5,10.0,38.351]
[null,null,null,"гарнир","Тефтели",45.0,7.78,7.21,7.85,114.38,7.0]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,20.0,1.862]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Печенье",16.0,1.1,0.75,10.0,20.65,null,3.68]
[{"$nulls":4},"Яблоки",100.0,0.55,0.55,13.64,40.92,50.0,9.0]
[null,null,null,"итого",null,{"$f":"SUM(F51:F58)","v":776.0},{"$f":"SUM(G51:G58)","v":20.87},{"$f":"SUM(H51:H58)","v":18.51},{"$f":"SUM(I51:I58)","v":102.27},{"$f":"SUM(J51:J58)","v":588.77},null,{"$f":"SUM(L51:L58)","v":71.71000000000001}]
[{"$f":"A43","v":1.0},{"$f":"B43","v":3.0},"Итого за день:",null,null,{"$f":"F50+F59","v":776.0},{"$f":"G50+G59","v":20.87},{"$f":"H50+H59","v":18.51},{"$f":"I50+I59","v":102.27},{"$f":"J50+J59","v":588.77},null,{"$f":"L50+L59","v":71.71}]
[1.0,4.0]
{"$rows_empty":7}
[{"$f":"A61","v":1.0},{"$f":"B61","v":4.0},"Обед","закуска","Йогурт",115.0,4.33,2.01,11.98,60.5,null,32.2]
[null,null,null,"1 блюдо","Вареник со сметаной",100.0,9.41,8.93,14.48,237.25,42.0,21.66]
[{"$nulls":4},"Сметана",5.0,0.25,1.88,0.3,19.36]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,null,1.71]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Яблоки",98.0,0.54,0.54,13.37,40.1,50.0,8.82]
[{"$nulls":4},"Вафли",20.0,0.82,5.4,12.0,61.25,null,5.0]
[null,null,null,"итого",null,{"$f":"SUM(F69:F75)","v":578.0},{"$f":"SUM(G69:G75)","v":19.27},{"$f":"SUM(H69:H75)","v":19.240000000000002},{"$f":"SUM(I69:I75)","v":85.46000000000001},{"$f":"SUM(J69:J75)","v":598.78},null,{"$f":"SUM(L69:L75)","v":71.71000000000001}]
[{"$f":"A61","v":1.0},{"$f":"B61","v":4.0},"Итого за день:",null,null,{"$f":"F68+F76","v":578.0},{"$f":"G68+G76","v":19.27},{"$f":"H68+H76","v":19.24},{"$f":"I68+I76","v":85.46},{"$f":"J68+J76","v":598.78},null,{"$f":"L68+L76","v":71.71}]
[1.0,5.0]
{"$rows_empty":8}
[{"$f":"A78","v":1.0},{"$f":"B78","v":5.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп харчо с курицей",200.0,6.89,1.9,6.58,85.79,36.0,13.48]
[null,null,null,"2 блюдо","Макароны отварные",125.0,5.52,4.52,26.45,132.5,10.0,31.201400000000003]
[null,null,null,"гарнир","Котлета куриная",45.0,12.15,10.15,10.44,108.0,44.0]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,20.0,1.71]
[null,null,null,"хлеб бел.","Хлеб пшеничный ",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Яблоки",100.0,0.55,0.55,13.64,40.92,50.0,9.0]
[{"$nulls":4},"Кексы",33.33,0.1,0.38,6.01,8.4,null,13.998599999999998]
[null,null,null,"итого",null,{"$f":"SUM(F87:F94)","v":743.33},{"$f":"SUM(G87:G94)","v":29.130000000000006},{"$f":"SUM(H87:H94)","v":17.98},{"$f":"SUM(I87:I94)","v":96.45},{"$f":"SUM(J87:J94)","v":555.93},null,{"$f":"SUM(L87:L94)","v":71.71000000000001}]
[{"$f":"A61","v":1.0},5.0,"Итого за день:",null,null,{"$f":"F68+F76","v":578.0},{"$f":"G68+G76","v":19.27},{"$f":"H68+H76","v":19.24},{"$f":"I68+I76","v":85.46},{"$f":"J68+J76","v":598.78},null,{"$f":"L68+L76","v":71.71}]
[1.0,6.0]
{"$rows_empty":7}
[1.0,{"$f":"B97","v":6.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп молочный с рисом",200.0,4.82,3.21,30.11,132.4,35.0,11.793]
[null,null,null,"2 блюдо","Каша пшеничная рассыпчатая",120.0,5.38,4.67,8.05,174.3,9.0,32.888400000000004]
[null,null,null,"гарнир","Котлета куриная",45.0,7.0,5.2,7.07,102.94,2.0]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,20.0,1.71]
[null,null,null,"хлеб бел.","Хлеб  пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Кексы",33.33,0.1,0.38,6.01,8.4,null,13.998599999999998]
[{"$nulls":4},"Яблоки",100.0,0.55,0.55,13.64,40.92,50.0,9.0]
[null,null,null,"итого",null,{"$f":"SUM(F105:F112)","v":738.33},{"$f":"SUM(G105:G112)","v":21.77},{"$f":"SUM(H105:H112)","v":14.490000000000002},{"$f":"SUM(I105:I112)","v":98.21},{"$f":"SUM(J105:J112)","v":639.28},null,{"$f":"SUM(L105:L112)","v":71.71000000000001}]
[{"$f":"A78","v":1.0},6.0,"Итого за день:",null,null,{"$f":"F86+F95","v":743.33},{"$f":"G86+G95","v":29.13},{"$f":"H86+H95","v":17.98},{"$f":"I86+I95","v":96.45},{"$f":"J86+J95","v":555.93},null,{"$f":"L86+L95","v":71.71}]
[2.0,7.0]
[]
[]
[]
[]
[]
[]
[{"$f":"A115","v":2.0},{"$f":"B115","v":7.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Борщ с капустой и картофелем ",200.0,1.45,12.85,21.2,184.3,27.0,6.0505]
[null,null,null,"2 блюдо","Каша ячневая рассыпчатая",120.0,6.03,4.53,28.94,186.29,9.0,38.5795]
[null,null,null,"гарнир","Котлета говяжья",45.0,7.0,6.55,7.07,102.94,2.0]
[null,null,null,"напиток","Сок осветленный ",196.0,1.04,0.0,12.57,83.41,49.0,16.66]
[null,null,null,"хлеб бел.","Хлеб  пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Яблоки",90.0,0.5,0.5,12.28,36.83,50.0,8.1]
[{"$nulls":4},"Масло сливочное",3.5,0.05,4.11,0.58,0.0]
[{"$nulls":4},"Сметана",2.0,0.06,0.46,0.07,4.79]
[null,null,null,"итого",null,{"$f":"SUM(F122:F130)","v":696.5},{"$f":"SUM(G122:G130)","v":20.049999999999997},29.48,102.58999999999999,750.88,null,{"$f":"SUM(L122:L130)","v":71.71000000000001}]
[{"$f":"A115","v":2.0},7.0,"Итого за день:",null,null,{"$f":"F121+F131","v":696.5},{"$f":"G121+G131","v":20.05},{"$f":"H121+H131","v":29.48},{"$f":"I121+I131","v":102.59},{"$f":"J121+J131","v":750.88},null,{"$f":"L121+L131","v":71.71}]
[2.0,8.0]
{"$rows_empty":7}
[{"$f":"A133","v":2.0},{"$f":"B133","v":8.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп молочный с рисом",200.0,4.82,3.21,30.11,132.4,35.0,14.449]
[null,null,null,"2 блюдо","Каша пшеничная рассыпчатая",120.0,5.38,4.67,8.05,174.3,9.0,39.231]
[null,null,null,"гарнир","Тефтели",45.0,7.78,7.21,7.85,114.38,7.0]
[null,null,null,"напиток","Чай с сахаром",200.0,0.0,0.0,13.45,28.0,20.0,1.71]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Мини рулеты (бисквитные)",35.0,1.4,6.65,19.95,147.0,null,5.0]
[{"$nulls":4},"Яблоки",100.0,0.55,0.55,13.64,40.92,null,9.0]
[]
[null,null,null,"итого",null,{"$f":"SUM(F141:F149)","v":740.0},{"$f":"SUM(G141:G149)","v":23.849999999999998},22.77,112.92999999999999,789.32,null,{"$f":"SUM(L141:L149)","v":71.71000000000001}]
[{"$f":"A133","v":2.0},8.0,"Итого за день:",null,null,{"$f":"F140+F150","v":740.0},{"$f":"G140+G150","v":23.85},{"$f":"H140+H150","v":22.77},{"$f":"I140+I150","v":112.93},{"$f":"J140+J150","v":789.32},null,71.71]
[2.0,9.0]
{"$rows_empty":7}
[{"$f":"A152","v":2.0},{"$f":"B152","v":9.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп картофельный с курицей",200.0,2.42,1.9,5.21,96.95,33.0,14.087]
[null,null,null,"2 блюдо","Гуляш из грудки курицы ",79.0,9.23,8.77,14.21,232.85,46.0,18.383]
[null,null,null,"гарнир","Каша гречневая расыпчатая",126.0,11.44,2.66,8.98,168.35,9.0,5.92]
[null,null,null,"напиток","Сок осветленный ",200.0,1.06,0.0,12.83,85.11,49.0,17.0]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Яблоки",100.0,0.55,0.55,13.64,40.92,50.0,9.0]
[{"$nulls":4},"Вафли",20.0,0.82,5.4,12.0,61.25,null,5.0]
[null,null,null,"итого",null,{"$f":"SUM(F160:F167)","v":765.0},{"$f":"SUM(G160:G167)","v":29.44},{"$f":"SUM(H160:H167)","v":19.76},{"$f":"SUM(I160:I167)","v":86.75},{"$f":"SUM(J160:J167)","v":837.7499999999999},null,{"$f":"SUM(L160:L167)","v":71.71000000000001}]
[{"$f":"A152","v":2.0},9.0,"Итого за день:",null,null,{"$f":"F159+F168","v":765.0},{"$f":"G159+G168","v":29.44},{"$f":"H159+H168","v":19.76},{"$f":"I159+I168","v":86.75},{"$f":"J159+J168","v":837.75},null,{"$f":"L159+L168","v":71.71}]
{"$rows_empty":7}
[{"$f":"A170","v":0.0},{"$f":"B170","v":0.0},"Обед","закуска"]
[null,null,null,"1 блюдо","Суп гороховый с курицей",200.0,5.06,0.64,22.06,108.68,40.0,5.116]
[null,null,null,"2 блюдо","Вареники",100.0,9.23,8.77,14.21,232.85,42.0,21.749]
[null,null,null,"гарнир","Сметана",6.0,0.26,1.88,0.3,19.39]
[null,null,null,"напиток","Сок осветленный ",195.0,1.03,0.0,12.51,82.98,49.0,16.575]
[null,null,null,"хлеб бел.","Хлеб пшеничный",40.0,3.92,0.48,19.88,152.32,null,2.32]
[{"$nulls":4},"Мини рулеты (бисквитные)",35.0,1.4,6.65,19.95,147.0,null,17.85]
[{"$nulls":4},"Яблоки",90.0,0.5,0.5,12.28,36.83,50.0,8.1]
[null,null,null,"итого",null,{"$f":"SUM(F177:F184)","v":666.0},{"$f":"SUM(G177:G184)","v":21.4},{"$f":"SUM(H177:H184)","v":18.92},{"$f":"SUM(I177:I184)","v":101.19},{"$f":"SUM(J177:J184)","v":780.0500000000001},null,{"$f":"SUM(L177:L184)","v":71.71}]
[{"$f":"A170","v":0.0},10.0,"Итого за день:",null,null,{"$f":"F176+F185","v":666.0},{"$f":"G176+G185","v":21.4},{"$f":"H176+H185","v":18.92},{"$f":"I176+I185","v":101.19},{"$f":"J176+J185","v":780.05},null,{"$f":"L176+L185","v":71.71}]
[2.0,null,"Среднее значение за период:",null,null,{"$f":"F16+F34+F52+F70+F88+F106+F123+F142+F161+F178","v":1950.0},{"$f":"(G43+G61+G78+G97+G133+G152+G170)/(IF(G43=0,0,1)+IF(G61=0,0,1)+IF(G78=0,0,1)+IF(G97=0,0,1)+IF(G133=0,0,1)+IF(G152=0,0,1)+IF(G170=0,0,1))","v":{"$error":"#DIV/0!"}},{"$f":"(H43+H61+H78+H97+H133+H152+H170)/(IF(H43=0,0,1)+IF(H61=0,0,1)+IF(H78=0,0,1)+IF(H97=0,0,1)+IF(H133=0,0,1)+IF(H152=0,0,1)+IF(H170=0,0,1))","v":{"$error":"#DIV/0!"}},{"$f":"(I43+I61+I78+I97+I133+I152+I170)/(IF(I43=0,0,1)+IF(I61=0,0,1)+IF(I78=0,0,1)+IF(I97=0,0,1)+IF(I133=0,0,1)+IF(I152=0,0,1)+IF(I170=0,0,1))","v":{"$error":"#DIV/0!"}},{"$f":"(J43+J61+J78+J97+J133+J152+J170)/(IF(J43=0,0,1)+IF(J61=0,0,1)+IF(J78=0,0,1)+IF(J97=0,0,1)+IF(J133=0,0,1)+IF(J152=0,0,1)+IF(J170=0,0,1))","v":{"$error":"#DIV/0!"}},null,{"$f":"(L43+L61+L78+L97+L133+L152+L170)/(IF(L43=0,0,1)+IF(L61=0,0,1)+IF(L78=0,0,1)+IF(L97=0,0,1)+IF(L133=0,0,1)+IF(L152=0,0,1)+IF(L170=0,0,1))","v":{"$error":"#DIV/0!"}}]