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

{"sheet":"Лист1","index":0,"n_rows":212,"n_cols":12,"rows_kept":212,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[25,2,25,3],[46,2,46,3],[66,2,66,3],[87,2,87,3],[107,2,107,3],[127,2,127,3],[147,2,147,3],[168,2,168,3],[189,2,189,3],[210,2,210,3],[211,2,211,4]]}
["Школа",null,"МБОУ \" Абсалямовская ООШ\"",null,null,"Утвердил:","должность","Директор"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Ахметзянова Л.Р."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",3,9,2024]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты \"Школьные\" с соусом сметанным и томатом 70/30",100,5.8,9.8,9.01,130.2,347]
[{"$nulls":4},"Пюре гороховое с маслом 150/5",155,8.8,5.64,32.56,259.9,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0.2,0,{"v":9.1,"d":"9.10"},{"v":36,"d":"36.00"},300]
[{"$nulls":3},"закуска","Салат Витаминный",60,0.72,3.72,3.6,51,21]
[{"$nulls":3},"хлеб бел","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий",20,1.36,0.26,7.96,39.6,574]
[]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F14)","v":565},{"$f":"SUM(G6:G14)","v":19.16},{"$f":"SUM(H6:H14)","v":19.66},{"$f":"SUM(I6:I14)","v":76.99},{"$f":"SUM(J6:J14)","v":586.9},null,{"$f":"SUM(L6:L14)","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(F16:F24)","v":0},{"$f":"SUM(G16:G24)","v":0},0,0,0,null,{"$f":"SUM(L16:L24)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F15+F25","v":565},{"$f":"G15+G25","v":19.16},19.66,76.99,586.9,null,{"$f":"L15+L25","v":0}]
[1,2,"Завтрак","гор.блюдо","Биточки рыбные с соусом 70/30",100,9.8,10.55,8.47,134.6,83]
[{"$nulls":4},"Картофельное пюре",150,3.08,4.73,10.03,120.25,146]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,0.5,0.1,30.9,123,310]
[{"$nulls":3},"закуска","Салат \"Пестрый\"",60,0.7,2.7,6.4,55,33]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F27:F35)","v":560},{"$f":"SUM(G27:G35)","v":17.72},{"$f":"SUM(H27:H35)","v":18.580000000000002},{"$f":"SUM(I27:I35)","v":78.52},{"$f":"SUM(J27:J35)","v":542.65},null,0]
[{"$f":"A27","v":1},{"$f":"B27","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F37:F45)","v":0},{"$f":"SUM(G37:G45)","v":0},{"$f":"SUM(H37:H45)","v":0},{"$f":"SUM(I37:I45)","v":0},{"$f":"SUM(J37:J45)","v":0},null,0]
[{"$f":"A27","v":1},{"$f":"B27","v":2},"Итого за день:",null,null,{"$f":"F36+F46","v":560},{"$f":"G36+G46","v":17.72},{"$f":"H36+H46","v":18.580000000000002},{"$f":"I36+I46","v":78.52},{"$f":"J36+J46","v":542.65},null,0]
[1,3,"Завтрак","гор.блюдо","Жаркое по-домашнему с куриными грудками",200,9.8,15.1,25.8,301.25,98]
[]
[{"$nulls":3},"гор.напиток","Какао с молоком",200,3.3,3.1,13.6,95,306]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,338]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F48:F55)","v":550},{"$f":"SUM(G48:G55)","v":17.14},{"$f":"SUM(H48:H55)","v":19.099999999999998},{"$f":"SUM(I48:I55)","v":71.92},{"$f":"SUM(J48:J55)","v":553.05},null,{"$f":"SUM(L48:L55)","v":0}]
[{"$f":"A48","v":1},{"$f":"B48","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F57:F65)","v":0},{"$f":"SUM(G57:G65)","v":0},{"$f":"SUM(H57:H65)","v":0},{"$f":"SUM(I57:I65)","v":0},{"$f":"SUM(J57:J65)","v":0},null,0]
[{"$f":"A48","v":1},{"$f":"B48","v":3},"Итого за день:",null,null,{"$f":"F56+F66","v":550},{"$f":"G56+G66","v":17.14},{"$f":"H56+H66","v":19.099999999999998},{"$f":"I56+I66","v":71.92},{"$f":"J56+J66","v":553.05},null,0]
[1,4,"Завтрак","гор.блюдо","Фрикадельки куриные тушенные в соусе 60/30",90,4.5,8.8,5.7,77.7,134]
[{"$nulls":4},"Каша гречневая рассыпчатая с маслом 150/5",155,8.83,5.67,32.58,260,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,9.1,36,300]
[{"$nulls":3},"закуска","Салат из свеклы с растительным маслом",60,1,4.8,5,69,25]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F68:F76)","v":555},{"$f":"SUM(G68:G76)","v":18.169999999999998},{"$f":"SUM(H68:H76)","v":19.77},{"$f":"SUM(I68:I76)","v":75.1},{"$f":"SUM(J68:J76)","v":552.5},null,0]
[{"$f":"A68","v":1},{"$f":"B68","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F78:F86)","v":0},{"$f":"SUM(G78:G86)","v":0},{"$f":"SUM(H78:H86)","v":0},{"$f":"SUM(I78:I86)","v":0},{"$f":"SUM(J78:J86)","v":0},null,0]
[{"$f":"A68","v":1},{"$f":"B68","v":4},"Итого за день:",null,null,{"$f":"F77+F87","v":555},{"$f":"G77+G87","v":18.169999999999998},{"$f":"H77+H87","v":19.77},{"$f":"I77+I87","v":75.1},{"$f":"J77+J87","v":552.5},null,0]
[1,5,"Завтрак","гор.блюдо","Сосиски говяжьи халяль отварные с соусом 80/20",100,8.7,14.9,7.57,177.18,243]
[{"$nulls":4},"Макаронные изделия отварные с маслом 150/5",155,5.42,3.67,33.3,194.2,227]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,9.1,36,300]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F89:F96)","v":505},{"$f":"SUM(G89:G96)","v":17.959999999999997},{"$f":"SUM(H89:H96)","v":19.07},{"$f":"SUM(I89:I96)","v":72.69},{"$f":"SUM(J89:J96)","v":517.18},null,{"$f":"SUM(L89:L96)","v":0}]
[{"$f":"A89","v":1},{"$f":"B89","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F98:F106)","v":0},{"$f":"SUM(G98:G106)","v":0},{"$f":"SUM(H98:H106)","v":0},{"$f":"SUM(I98:I106)","v":0},{"$f":"SUM(J98:J106)","v":0},null,0]
[{"$f":"A89","v":1},{"$f":"B89","v":5},"Итого за день:",null,null,{"$f":"F97+F107","v":505},{"$f":"G97+G107","v":17.959999999999997},{"$f":"H97+H107","v":19.07},{"$f":"I97+I107","v":72.69},{"$f":"J97+J107","v":517.18},null,0]
[2,1,"Завтрак","гор.блюдо","Сосиски говяжьи халяль отварные с соусом 80/20",100,8.7,14.9,7.57,177.18,243]
[{"$nulls":4},"Макаронные изделия отварные с маслом 150/5",155,5.42,3.67,33.3,194.2,227]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,9.1,36,300]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,338]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F109:F116)","v":605},{"$f":"SUM(G109:G116)","v":18.359999999999996},19.47,82.49,564.18,null,{"$f":"SUM(L109:L116)","v":0}]
[{"$f":"A109","v":2},{"$f":"B109","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F118:F126)","v":0},{"$f":"SUM(G118:G126)","v":0},0,0,0,null,{"$f":"SUM(L118:L126)","v":0}]
[{"$f":"A109","v":2},{"$f":"B109","v":1},"Итого за день:",null,null,{"$f":"F117+F127","v":605},{"$f":"G117+G127","v":18.359999999999996},{"$f":"H117+H127","v":19.47},{"$f":"I117+I127","v":82.49},{"$f":"J117+J127","v":564.18},null,0]
[2,2,"Завтрак","гор.блюдо","Котлеты \"Школьные\" с соусом сметанным и томатом 70/30",100,5.8,9.8,9.01,130.2,347]
[{"$nulls":4},"Каша гречневая рассыпчатая с маслом 150/5",155,8.83,5.67,32.58,260,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,9.1,36,300]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F129:F136)","v":505},{"$f":"SUM(G129:G136)","v":18.47},15.97,73.41,536,null,{"$f":"SUM(L129:L136)","v":0}]
[{"$f":"A129","v":2},{"$f":"B129","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F138:F146)","v":0},{"$f":"SUM(G138:G146)","v":0},0,0,0,null,{"$f":"SUM(L138:L146)","v":0}]
[{"$f":"A129","v":2},{"$f":"B129","v":2},"Итого за день:",null,null,{"$f":"F137+F147","v":505},{"$f":"G137+G147","v":18.47},{"$f":"H137+H147","v":15.97},{"$f":"I137+I147","v":73.41},{"$f":"J137+J147","v":536},null,0]
[2,3,"Завтрак","гор.блюдо","Биточки рыбные с соусом 70/30",100,9.8,10.55,20.5,134.6,83]
[{"$nulls":4},"Картофельное пюре",150,3.08,4.73,10.03,120.25,146]
[{"$nulls":3},"гор.напиток","Чай с молоком",200,1.6,1.5,11.3,62,301]
[{"$nulls":3},"закуска","Салат из моркови ",60,0.6,2.3,5,72,17]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F149:F157)","v":560},{"$f":"SUM(G149:G157)","v":18.72},19.580000000000002,69.55,498.65000000000003,null,{"$f":"SUM(L149:L157)","v":0}]
[{"$f":"A149","v":2},{"$f":"B149","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F159:F167)","v":0},{"$f":"SUM(G159:G167)","v":0},0,0,0,null,{"$f":"SUM(L159:L167)","v":0}]
[{"$f":"A149","v":2},{"$f":"B149","v":3},"Итого за день:",null,null,{"$f":"F158+F168","v":560},{"$f":"G158+G168","v":18.72},{"$f":"H158+H168","v":19.580000000000002},{"$f":"I158+I168","v":69.55},{"$f":"J158+J168","v":498.65000000000003},null,0]
[2,4,"Завтрак","гор.блюдо","Плов из птицы ",200,12.2,13.2,22.2,267,138]
[]
[{"$nulls":3},"гор.напиток","Компот из сухофруктов",200,0.5,0.1,30.9,123,310]
[{"$nulls":3},"закуска","Салат из свеклы с растительным маслом",60,1,4.8,5,69,25]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты"]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F170:F178)","v":510},{"$f":"SUM(G170:G178)","v":17.34},18.599999999999998,80.82,568.8000000000001,null,{"$f":"SUM(L170:L178)","v":0}]
[{"$f":"A170","v":2},{"$f":"B170","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F180:F188)","v":0},{"$f":"SUM(G180:G188)","v":0},0,0,0,null,{"$f":"SUM(L180:L188)","v":0}]
[{"$f":"A170","v":2},{"$f":"B170","v":4},"Итого за день:",null,null,{"$f":"F179+F189","v":510},{"$f":"G179+G189","v":17.34},{"$f":"H179+H189","v":18.599999999999998},{"$f":"I179+I189","v":80.82},{"$f":"J179+J189","v":568.8000000000001},null,0]
[2,5,"Завтрак","гор.блюдо","Фрикадельки куриные тушенные в соусе 60/30",90,4.5,8.8,1.7,77.7,134]
[{"$nulls":4},"Каша гречневая рассыпчатая с маслом 150/5",155,8.83,5.67,32.58,260,183]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0.2,0,9.1,36,300]
[{"$nulls":3},"закуска","Салат из белокочанной капусты",60,1.3,2.7,6.2,57,6]
[{"$nulls":3},"хлеб бел.","Хлеб пшеничный",30,2.28,0.24,14.76,70.2,573]
[{"$nulls":3},"хлеб черн.","Хлеб Дарницкий ",20,1.36,0.26,7.96,39.6,574]
[{"$nulls":3},"фрукты","Фрукты свежие",100,0.4,0.4,9.8,47,338]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F191:F199)","v":655},{"$f":"SUM(G191:G199)","v":18.869999999999997},18.07,82.1,587.5,null,{"$f":"SUM(L191:L199)","v":0}]
[{"$f":"A191","v":2},{"$f":"B191","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F201:F209)","v":0},{"$f":"SUM(G201:G209)","v":0},0,0,0,null,{"$f":"SUM(L201:L209)","v":0}]
[{"$f":"A191","v":2},{"$f":"B191","v":5},"Итого за день:",null,null,{"$f":"F200+F210","v":655},{"$f":"G200+G210","v":18.869999999999997},{"$f":"H200+H210","v":18.07},{"$f":"I200+I210","v":82.1},{"$f":"J200+J210","v":587.5},null,0]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F26+F47+F67+F88+F108+F128+F148+F169+F190+F211)/(IF(F26=0,0,1)+IF(F47=0,0,1)+IF(F67=0,0,1)+IF(F88=0,0,1)+IF(F108=0,0,1)+IF(F128=0,0,1)+IF(F148=0,0,1)+IF(F169=0,0,1)+IF(F190=0,0,1)+IF(F211=0,0,1))","v":557},{"$f":"(G26+G47+G67+G88+G108+G128+G148+G169+G190+G211)/(IF(G26=0,0,1)+IF(G47=0,0,1)+IF(G67=0,0,1)+IF(G88=0,0,1)+IF(G108=0,0,1)+IF(G128=0,0,1)+IF(G148=0,0,1)+IF(G169=0,0,1)+IF(G190=0,0,1)+IF(G211=0,0,1))","v":18.191},{"$f":"(H26+H47+H67+H88+H108+H128+H148+H169+H190+H211)/(IF(H26=0,0,1)+IF(H47=0,0,1)+IF(H67=0,0,1)+IF(H88=0,0,1)+IF(H108=0,0,1)+IF(H128=0,0,1)+IF(H148=0,0,1)+IF(H169=0,0,1)+IF(H190=0,0,1)+IF(H211=0,0,1))","v":18.787},{"$f":"(I26+I47+I67+I88+I108+I128+I148+I169+I190+I211)/(IF(I26=0,0,1)+IF(I47=0,0,1)+IF(I67=0,0,1)+IF(I88=0,0,1)+IF(I108=0,0,1)+IF(I128=0,0,1)+IF(I148=0,0,1)+IF(I169=0,0,1)+IF(I190=0,0,1)+IF(I211=0,0,1))","v":76.35900000000001},{"$f":"(J26+J47+J67+J88+J108+J128+J148+J169+J190+J211)/(IF(J26=0,0,1)+IF(J47=0,0,1)+IF(J67=0,0,1)+IF(J88=0,0,1)+IF(J108=0,0,1)+IF(J128=0,0,1)+IF(J148=0,0,1)+IF(J169=0,0,1)+IF(J190=0,0,1)+IF(J211=0,0,1))","v":550.741},null,{"$f":"(L26+L47+L67+L88+L108+L128+L148+L169+L190+L211)/(IF(L26=0,0,1)+IF(L47=0,0,1)+IF(L67=0,0,1)+IF(L88=0,0,1)+IF(L108=0,0,1)+IF(L128=0,0,1)+IF(L148=0,0,1)+IF(L169=0,0,1)+IF(L190=0,0,1)+IF(L211=0,0,1))","v":{"$error":"#DIV/0!"}}]