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

{"sheet":"Лист1","index":0,"n_rows":233,"n_cols":12,"rows_kept":233,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[23,2,23,3],[42,2,42,3],[61,2,61,3],[80,2,80,3],[99,2,99,3],[118,2,118,3],[137,2,137,3],[156,2,156,3],[175,2,175,3],[194,2,194,3],[213,2,213,3],[232,2,232,4]]}
["Школа",null,"МБОУ \"Мало-Уруссинская ООШ\"",null,null,"Утвердил:","должность","Директор школы"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Галиева А.Ф."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",9,1,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Выход, г","Цена","Калорийность","Белки","Жиры","Углеводы"]
[1,1,"Завтрак","гор.блюдо","котлеты гавяжьи с соусом",140,null,302,16,16.4,21.1]
[{"$nulls":4},"пюре гороховое с маслом сливочным",155,null,265,15.09,4.92,34.42]
[{"$nulls":3},"гор.напиток","чай с сахаром ",200,null,36,0.2,0,9.1]
[{"$nulls":3},"хлеб","хлеб пшеничный ",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"салат","салат из моркови",60,null,72,0.6,5.3,5]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F11)","v":605},null,{"$f":"SUM(H6:H11)","v":791.12},{"$f":"SUM(I6:I11)","v":35.379999999999995},{"$f":"SUM(J6:J11)","v":27.14},{"$f":"SUM(K6:K11)","v":93.99}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо",{"$nulls":6},"е"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого"]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F13+F23","v":605},{"$f":"G13+G23","v":0},791.12,35.379999999999995,27.14,null,66.76]
[1,2,"Завтрак","каша","картофельное пюре",150,null,{"v":140.25,"d":"140"},{"v":3.08,"d":"3"},{"v":4.73,"d":"5"},20.03]
[{"$nulls":3},"напиток","компот из сухофруктов",200,null,123,{"v":0.5,"d":"1"},{"v":0.1,"d":"0"},{"v":30.9,"d":"30.90"}]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":4},"хлеб пшеничный",30,null,{"v":70.14,"d":"70"},{"v":2.37,"d":"2"},{"v":0.3,"d":"0"},14.49]
[{"$nulls":3},"салат","салат из капусты белокачанной",60,null,57,{"v":1.3,"d":"1"},{"v":2.7,"d":"3"},{"v":6.2,"d":"6.20"}]
[{"$nulls":3},"гор.блюдо","биточки рыбные",90,null,233,{"v":21.6,"d":"22"},{"v":10.5,"d":"11"},{"v":12.4,"d":"12.40"}]
[]
[{"$nulls":3},"итого",null,496,{"$f":"SUM(G25:G31)","v":0},{"$f":"SUM(H25:H31)","v":669.37},{"$f":"SUM(I25:I31)","v":29.970000000000002},{"$f":"SUM(J25:J31)","v":18.55},{"$f":"SUM(K25:K31)","v":{"v":93.9,"d":"93.90"}},{"$f":"SUM(L25:L31)","v":0}]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого"]
[{"$f":"A25","v":1},{"$f":"B25","v":2},"Итого за день:",null,null,{"$f":"F32+F42","v":496},{"$f":"G32+G42","v":0},{"$f":"H32+H42","v":669.37},{"$f":"I32+I42","v":29.970000000000002},{"$f":"J32+J42","v":18.55},{"$f":"SUM(K32)","v":{"v":93.9,"d":"93.90"}},0]
[1,3,"Завтрак","гор.блюдо","Жаркое по-домашнему",180,null,312,18.2,18.2,{"v":17.6,"d":"17.60"}]
[{"$nulls":3},"гор.напиток","чай с молоком",200,null,62,1.6,1.5,{"v":11.3,"d":"11.30"}]
[{"$nulls":3},"фрукты","плоды и ягоды свежие",100,null,47,0.4,0.4,{"v":9.8,"d":"9.80"}]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F44:F50)","v":530},{"$f":"SUM(G44:G50)","v":0},{"$f":"SUM(H44:H50)","v":537.12},{"$f":"SUM(I44:I50)","v":23.69},{"$f":"SUM(J44:J50)","v":20.619999999999997},83.69,0]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Обед","фрукты"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F52:F60)","v":0},{"$f":"SUM(G52:G60)","v":0},{"$f":"SUM(H52:H60)","v":0},{"$f":"SUM(I52:I60)","v":0},{"$f":"SUM(J52:J60)","v":0}]
[{"$f":"A44","v":1},{"$f":"B44","v":3},"Итого за день:",null,null,{"$f":"F51+F61","v":530},{"$f":"G51+G61","v":0},{"$f":"H51+H61","v":537.12},{"$f":"I51+I61","v":23.69},{"$f":"J51+J61","v":20.619999999999997},83.69,66.76]
[1,4,"Завтрак","салат","салат из свеклы отварной с раст.маслом",60,null,69,1,4.8,5]
[{"$nulls":3},"гор.блюдо","фрикадельки говядина в соусе сметанном",90,null,123,8,7.2,6.3]
[{"$nulls":3},"гарнир","каша пшеничная молочная жидкая",185,null,222,6.7,7.6,32.6]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"гор.напиток","чай с сахаром",200,null,36,0.2,0,9.1]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F63:F69)","v":585},{"$f":"SUM(G63:G69)","v":0},{"$f":"SUM(H63:H69)","v":566.12},{"$f":"SUM(I63:I69)","v":19.39},{"$f":"SUM(J63:J69)","v":20.12},{"$f":"SUM(K63:K68)","v":77.37},0]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F71:F79)","v":0},{"$f":"SUM(G71:G79)","v":0},{"$f":"SUM(H71:H79)","v":0},{"$f":"SUM(I71:I79)","v":0},{"$f":"SUM(J71:J79)","v":0}]
[{"$f":"A63","v":1},{"$f":"B63","v":4},"Итого за день:",null,null,{"$f":"F70+F80","v":585},{"$f":"G70+G80","v":0},{"$f":"H70+H80","v":566.12},{"$f":"I70+I80","v":19.39},{"$f":"J70+J80","v":20.12},null,66.76]
[1,5,"Завтрак","гор.блюдо","сосиски говяжьи халяль",100,298.18,10.09,28.27,0.45]
[{"$nulls":3},"гарнир","каша пшенная молочная жидкая",185,222,6.7,7.6,32.6]
[{"$nulls":3},"гор.напиток","чай с курагой",208,62,0.13,0.02,15.2]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано -пшеничный",20,45.98,1.12,0.22,9.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F82:F88)","v":543},{"$f":"SUM(G82:G88)","v":698.3000000000001},{"$f":"SUM(H82:H88)","v":20.41},{"$f":"SUM(I82:I88)","v":36.41},{"$f":"SUM(J82:J88)","v":72.62},null,0]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F90:F98)","v":0},{"$f":"SUM(G90:G98)","v":0},{"$f":"SUM(H90:H98)","v":0},{"$f":"SUM(I90:I98)","v":0},{"$f":"SUM(J90:J98)","v":0}]
[{"$f":"A82","v":1},{"$f":"B82","v":5},"Итого за день:",null,null,{"$f":"F89+F99","v":543},{"$f":"G89+G99","v":698.3000000000001},{"$f":"H89+H99","v":20.41},{"$f":"I89+I99","v":36.41},{"$f":"J89+J99","v":72.62},null,66.76]
[1,6,"Завтрак","гор.блюдо"]
[{"$nulls":3},"закуска","салат из капусты белокачанной",60,null,57,1.3,2.7,6.2]
[{"$nulls":3},"гор.напиток","чай с сахаром",200,null,36,0.2,0,9.1]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"гарнир","каша ячневая рассыпчатая",185,null,272,8.2,7.4,40.2]
[{"$nulls":3},"гор.блюдо","птица тушенная в соусе",100,null,162,13.28,10.84,2.9]
[{"$nulls":3},"итого",null,{"$f":"SUM(F101:F107)","v":595},{"$f":"SUM(G101:G107)","v":0},643.12,26.47,21.46,{"$f":"SUM(K102:K107)","v":82.77000000000001}]
[{"$f":"A101","v":1},6,"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F117)","v":0},{"$f":"SUM(G109:G117)","v":0},0,0,0]
[{"$f":"A101","v":1},{"$f":"B101","v":6},"Итого за день:",null,null,{"$f":"F108+F118","v":595},{"$f":"G108+G118","v":0},643.12,26.47,21.46,{"$f":"SUM(K108)","v":82.77000000000001},66.76]
[2,1,"Завтрак","гор.блюдо","сосиски говяжьи халяль отварные",100,null,298.18,10.09,28.27,0.45]
[{"$nulls":3},"фрукты","плоды и ягоды свежие",100,null,47,0.4,0.4,9.8]
[{"$nulls":3},"гор.напиток","чай с сахаром ",200,null,36,0.2,0,9.1]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"гарнир","макаронные изделия отварные с маслом",185,null,233,6.5,4.4,40]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F120:F126)","v":635},{"$f":"SUM(G120:G126)","v":0},730.3,20.68,33.589999999999996,{"$f":"SUM(K120:K125)","v":83.72},{"$f":"SUM(L120:L126)","v":0}]
[{"$f":"A120","v":2},{"$f":"B120","v":1},"Обед","фрукты"]
[{"$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]
[{"$f":"A120","v":2},{"$f":"B120","v":1},"Итого за день:",null,null,{"$f":"F127+F137","v":635},{"$f":"G127+G137","v":0},{"$f":"H127+H137","v":730.3},{"$f":"I127+I137","v":20.68},{"$f":"J127+J137","v":33.589999999999996},null,66.76]
[2,2,"Завтрак","гор.блюдо","котлеты говяжьи с соусом сметанный с томатом",140,null,302,16,16.4,21.1]
[{"$nulls":3},"гарнир","каша гречневая рассыпчатая",185,null,312,10.6,6.8,46.3]
[{"$nulls":3},"гор.напиток","чай с сахаром",200,null,36,0.2,0,9.1]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F139:F145)","v":575},{"$f":"SUM(G139:G145)","v":0},766.12,30.290000000000003,23.72,{"$f":"SUM(K139:K143)","v":100.86999999999999},{"$f":"SUM(L139:L145)","v":0}]
[{"$f":"A139","v":2},{"$f":"B139","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F147:F155)","v":0},{"$f":"SUM(G147:G155)","v":0},0,0,0]
[{"$f":"A139","v":2},{"$f":"B139","v":2},"Итого за день:",null,null,{"$f":"F146+F156","v":575},{"$f":"G146+G156","v":0},{"$f":"H146+H156","v":766.12},{"$f":"I146+I156","v":30.290000000000003},{"$f":"J146+J156","v":23.72},null,66.76]
[2,3,"Завтрак","гор.блюдо","биточки рыбные",90,null,233,21.6,10.05,12.4]
[{"$nulls":3},"закуска","салат из капусты белокачанной",60,null,57,1.3,2.7,6.2]
[{"$nulls":3},"гор.напиток","чай с молоком",200,null,62,1.6,1.5,11.3]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"гарнир","картофельное пюре",150,null,140.25,3.08,4.73,20.03]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F158:F164)","v":550},{"$f":"SUM(G158:G164)","v":0},{"$f":"SUM(H158:H163)","v":608.37},31.070000000000007,19.5,{"$f":"SUM(K158:K163)","v":74.30000000000001},{"$f":"SUM(L158:L164)","v":0}]
[{"$f":"A158","v":2},{"$f":"B158","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F166:F174)","v":0},{"$f":"SUM(G166:G174)","v":0},0,0,0]
[{"$f":"A158","v":2},{"$f":"B158","v":3},"Итого за день:",null,null,{"$f":"F165+F175","v":550},{"$f":"G165+G175","v":0},{"$f":"H165+H175","v":608.37},{"$f":"I165+I175","v":31.070000000000007},{"$f":"J165+J175","v":19.5},null,66.76]
[2,4,"Завтрак","гор.блюдо"]
[{"$nulls":3},"закуска","салат из свеклы отварной с раст.маслом",60,null,69,1,4.8,5]
[{"$nulls":3},"гор.напиток","компот из сухоруктов",200,null,123,0.5,0.1,30.9]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"гор.блюдо","плов из птицы",200,null,417,18.2,23.2,32.2]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F177:F183)","v":510},{"$f":"SUM(G177:G183)","v":0},{"$f":"SUM(H178:H182)","v":725.12},23.189999999999998,28.619999999999997,{"$f":"SUM(K178:K182)","v":92.47},{"$f":"SUM(L177:L183)","v":0}]
[{"$f":"A177","v":2},{"$f":"B177","v":4},"Обед","закуска"]
[{"$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]
[{"$f":"A177","v":2},{"$f":"B177","v":4},"Итого за день:",null,null,{"$f":"F184+F194","v":510},{"$f":"G184+G194","v":0},{"$f":"H184+H194","v":725.12},{"$f":"I184+I194","v":23.189999999999998},{"$f":"J184+J194","v":28.619999999999997},null,66.76]
[2,5,"Завтрак","закуска","салат из свежей капусты",60,null,57,1.3,2.7,6.2]
[{"$nulls":3},"гор.блюдо","фрикадельки говядина в соусе ",90,null,123,8,7.2,6.3]
[{"$nulls":3},"фрукты","плоды и ягоды свежие",100,null,47,0.4,0.4,9.8]
[{"$nulls":3},"гарнир","каша гречневая вязкая",185,null,247,8,8.2,32.7]
[{"$nulls":3},"гор.напиток","чай с сахаром ",200,null,36,0.2,0,9.1]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[{"$nulls":3},"итого",null,{"$f":"SUM(F196:F202)","v":685},{"$f":"SUM(G196:G202)","v":0},626.12,21.390000000000004,19.02,{"$f":"SUM(K196:K202)","v":88.46999999999998},{"$f":"SUM(L196:L202)","v":0}]
[{"$f":"A196","v":2},{"$f":"B196","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F204:F212)","v":0},{"$f":"SUM(G204:G212)","v":0},0,0,0]
[{"$f":"A196","v":2},{"$f":"B196","v":5},"Итого за день:",null,null,{"$f":"F203+F213","v":685},{"$f":"G203+G213","v":0},{"$f":"H203+H213","v":626.12},{"$f":"I203+I213","v":21.390000000000004},{"$f":"J203+J213","v":19.02},null,66.76]
[2,6,"Завтрак","закуска","салат из моркови с сахаром",60,null,72,0.6,5.3,5]
[{"$nulls":3},"гор.блюдо","птица тушенная в соусе",100,null,164,13.28,10.84,29]
[{"$nulls":3},"гарнир","картофельное пюре",150,null,140.25,3.08,4.73,20.03]
[{"$nulls":3},"гор.напиток","чай с сахаром с лимоном",200,null,38,0.2,0,9.3]
[{"$nulls":3},"хлеб","хлеб пшеничный",30,null,70.14,2.37,0.3,14.49]
[{"$nulls":3},"хлеб","хлеб ржано-пшеничный",20,null,45.98,1.12,0.22,9.88]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F215:F222)","v":560},{"$f":"SUM(G215:G222)","v":0},530.37,20.650000000000002,{"$f":"SUM(J215:J220)","v":21.39},{"$f":"SUM(K215:K220)","v":87.69999999999999},{"$f":"SUM(L215:L222)","v":0}]
[{"$f":"A215","v":2},{"$f":"B215","v":6},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого"]
[null,null,"Среднее значение за период:",null,null,560,560,530.37,20.65,21.39,87.7,{"$f":"(L24+L43+L62+L81+L100+L138+L157+L176+L195+L214)/(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(L138=0,0,1)+IF(L157=0,0,1)+IF(L176=0,0,1)+IF(L195=0,0,1)+IF(L214=0,0,1))","v":66.76}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}