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

{"sheet":"Лист1","index":0,"n_rows":204,"n_cols":12,"rows_kept":204,"merged":[[0,2,0,4],[0,7,0,10],[1,7,1,10],[24,2,24,3],[44,2,44,3],[64,2,64,3],[84,2,84,3],[103,2,103,3],[123,2,123,3],[143,2,143,3],[163,2,163,3],[182,2,182,3],[202,2,202,3],[203,2,203,4]]}
["Школа",null,"МБОУ \"Лицей №188\"",null,null,"Утвердил:","должность","Директор Лицея №188"]
["Типовое примерное меню приготавливаемых блюд",{"$nulls":5},"фамилия","Расулова Э.Г."]
["Возрастная категория",{"$nulls":3},"7-11 лет",null,"дата",23,10,2023]
[{"$nulls":7},"день","месяц","год"]
["Неделя","День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,1,"Завтрак","гор.блюдо","Котлеты \"Столичные\"",90,{"v":8,"d":"8.00"},4,3,83,"ТТК июль 2023 г"]
[{"$nulls":4},"Макароны отварные с сыром",140,{"v":5.39,"d":"5"},{"v":6.65,"d":"7"},{"v":29.98,"d":"30"},201,"ТТК 2019 г"]
[{"$nulls":3},"гор.напиток","Напиток из замороженной черной смородины ",200,{"v":0.1,"d":"0"},{"v":0.04,"d":"0"},{"v":10.7,"d":"11"},44,"ТТК 2022г"]
[{"$nulls":4},"Чай с сахаром","200/8"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,{"v":1.25,"d":"1"},{"v":1.08,"d":"1"},{"v":9.42,"d":"9"},46,"ТТК"]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Салат-бар (помидоры свежие порциями, огурцы свежие порциями, фасоль консервированная, сухарики из пшеничного хлеба, масло растительное)",60,{"v":1.62,"d":"2"},{"v":6.1,"d":"6"},{"v":12.9,"d":"13"},113,"ТТК 2023 г."]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F6:F13)","v":500},{"$f":"SUM(G6:G13)","v":16.36},17.869999999999997,66.00000000000001,487,null,66.8]
[{"$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(F15:F23)","v":0},{"$f":"SUM(G15:G23)","v":0},0,0,0,null,{"$f":"SUM(L15:L23)","v":0}]
[{"$f":"A6","v":1},{"$f":"B6","v":1},"Итого за день:",null,null,{"$f":"F14+F24","v":500},{"$f":"G14+G24","v":16.36},17.869999999999997,66.00000000000001,487,null,{"$f":"L14+L24","v":66.8}]
[1,2,"Завтрак","гор.блюдо","Жаркое из птицы (грудки куриные)","40/120",13,11,29,262,"ТТК 2023г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",200,0,0,8,34,"ТТК 2021 г"]
[{"$nulls":4},"Напиток из вишни ",200,0,0,10,41,"ТТК 2022г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК"]
[{"$nulls":3},"фрукты","Плоды свежие (яблоки)",100,0,0,10,47,"№338/2015г"]
[{"$nulls":4},"Салат-бар (огурцы свежие порциями, капуста белокачанная, кукуруза консервированная, сухарики из пшеничного хлеба, масло растительное)",60,5,7,7,108,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F26:F33)","v":570},{"$f":"SUM(G26:G33)","v":19},{"$f":"SUM(H26:H33)","v":19},{"$f":"SUM(I26:I33)","v":73},{"$f":"SUM(J26:J33)","v":538},null,66.8]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F35:F43)","v":0},{"$f":"SUM(G35:G43)","v":0},{"$f":"SUM(H35:H43)","v":0},{"$f":"SUM(I35:I43)","v":0},{"$f":"SUM(J35:J43)","v":0},null,0]
[{"$f":"A26","v":1},{"$f":"B26","v":2},"Итого за день:",null,null,{"$f":"F34+F44","v":570},{"$f":"G34+G44","v":19},{"$f":"H34+H44","v":19},{"$f":"I34+I44","v":73},{"$f":"J34+J44","v":538},null,66.8]
[1,3,"Завтрак","гор.блюдо","Сосиски отварные ","2шт./100",8,4,12,125,"№243/2015г"]
[{"$nulls":4},"Каша гречневая вязкая с маслом ",140,3,7,21,167,"№303/215г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0,0,8,32,"№630/1996г"]
[{"$nulls":4},"Напиток яблочный ",200,0,0,12,52,"№701/2004"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК"]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Салат-бар (свекла отварная, морковь свежая порциями, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,3,6,15,125,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F46:F53)","v":610},{"$f":"SUM(G46:G53)","v":15},{"$f":"SUM(H46:H53)","v":18},{"$f":"SUM(I46:I53)","v":77},{"$f":"SUM(J46:J53)","v":547},null,66.8]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F55:F63)","v":0},{"$f":"SUM(G55:G63)","v":0},{"$f":"SUM(H55:H63)","v":0},{"$f":"SUM(I55:I63)","v":0},{"$f":"SUM(J55:J63)","v":0},null,0]
[{"$f":"A46","v":1},{"$f":"B46","v":3},"Итого за день:",null,null,{"$f":"F54+F64","v":610},{"$f":"G54+G64","v":15},{"$f":"H54+H64","v":18},{"$f":"I54+I64","v":77},{"$f":"J54+J64","v":547},null,66.8]
[1,4,"Завтрак","гор.блюдо","Плов с говядиной ","40/120",12,11,23,237,"ТТК 2021г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром, лимоном",200,0,0,8,34,"№630/1996г"]
[{"$nulls":4},"Напиток из замороженной черной смородины ",200,0,0,11,44,"ТТК 2021г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК  "]
[{"$nulls":3},"фрукты","Плоды свежие (яблоки) ",100,0,0,10,47,"№338/2015г"]
[{"$nulls":4},"Салат-бар (Помидоры свежие порциями, морковь свежая порциями, кукуруза консервированная, усхарики из пшеничного хлеба, масло растительное) ",60,2,6,12,112,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F66:F73)","v":570},{"$f":"SUM(G66:G73)","v":15},{"$f":"SUM(H66:H73)","v":18},{"$f":"SUM(I66:I73)","v":73},{"$f":"SUM(J66:J73)","v":520},null,66.8]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F75:F83)","v":0},{"$f":"SUM(G75:G83)","v":0},{"$f":"SUM(H75:H83)","v":0},{"$f":"SUM(I75:I83)","v":0},{"$f":"SUM(J75:J83)","v":0},null,0]
[{"$f":"A66","v":1},{"$f":"B66","v":4},"Итого за день:",null,null,{"$f":"F74+F84","v":570},{"$f":"G74+G84","v":15},{"$f":"H74+H84","v":18},{"$f":"I74+I84","v":73},{"$f":"J74+J84","v":520},null,66.8]
[1,5,"Завтрак","гор.блюдо","Ёжики с мясом и рисом в соусе томатном ",100,8,5,10,119,"ТТК 2020г"]
[{"$nulls":4},"Пюре картофельное",140,3,4,20,136,"№ 312/2015г"]
[{"$nulls":3},"гор.напиток","Сок",180,0,0,18,83,"ТТК 2022г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1,1,9,46,"ТТК"]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Салат-бар (морковь свежая порциями, капуста белокачанная, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,3,6,18,141,"ТТК 20223г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F86:F92)","v":500},{"$f":"SUM(G86:G92)","v":15},{"$f":"SUM(H86:H92)","v":16},{"$f":"SUM(I86:I92)","v":75},{"$f":"SUM(J86:J92)","v":525},null,66.8]
[{"$f":"A86","v":1},{"$f":"B86","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F94:F102)","v":0},{"$f":"SUM(G94:G102)","v":0},{"$f":"SUM(H94:H102)","v":0},{"$f":"SUM(I94:I102)","v":0},{"$f":"SUM(J94:J102)","v":0},null,0]
[{"$f":"A86","v":1},{"$f":"B86","v":5},"Итого за день:",null,null,{"$f":"F93+F103","v":500},{"$f":"G93+G103","v":15},{"$f":"H93+H103","v":16},{"$f":"I93+I103","v":75},{"$f":"J93+J103","v":525},null,66.8]
[2,1,"Завтрак","гор.блюдо","Грудка куриная в томатном соусе ","45/45",10,6,3,113,"ТТК 2021г"]
[{"$nulls":4},"Рис отварной ",140,3,5,37,209,"№304/2105"]
[{"$nulls":3},"гор.напиток","Чай с сахаром",200,0,0,8,44,"№630/1996г"]
[{"$nulls":4},"Напиток из замороженной черной смородины ",200,0,0,11,32,"ТТК 2022г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК"]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Салат-бар (помидоры свежие порциями, огурцы свежие порциями, фасоль консервированная, сухарики из пшеничного хлеба, масло растительное)",60,2,6,7,90,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F105:F112)","v":610},{"$f":"SUM(G105:G112)","v":16},18,75,534,null,66.8]
[{"$f":"A105","v":2},{"$f":"B105","v":1},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F114:F122)","v":0},{"$f":"SUM(G114:G122)","v":0},0,0,0,null,{"$f":"SUM(L114:L122)","v":0}]
[{"$f":"A105","v":2},{"$f":"B105","v":1},"Итого за день:",null,null,{"$f":"F113+F123","v":610},{"$f":"G113+G123","v":16},{"$f":"H113+H123","v":18},{"$f":"I113+I123","v":75},{"$f":"J113+J123","v":534},null,66.8]
[2,2,"Завтрак","гор.блюдо","Жаркое по-домашнему","40/120",9,7,22,189,"ТТК 2023г"]
[]
[{"$nulls":3},"гор.напиток","Чай с сахаром с лимоном ",200,0,0,8,44,"№630/1996г"]
[{"$nulls":4},"Напиток из вишни",200,0,1,30,83,"ТТК 2022г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК"]
[{"$nulls":3},"фрукты","Плоды свежие (яблоки)",100,0,0,10,47,"№338/2015г"]
[]
[{"$nulls":4},"Салат-бар (помидоры свежие порциями, огурцы свежие порциями, фасоль консервированная, сухарики из пшеничного хлеба, масло растительное)",60,5,7,7,108,"ТТК 2023г"]
[{"$nulls":3},"итого",null,{"$f":"SUM(F125:F132)","v":570},{"$f":"SUM(G125:G132)","v":15},16,86,517,null,66.8]
[{"$f":"A125","v":2},{"$f":"B125","v":2},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F134:F142)","v":0},{"$f":"SUM(G134:G142)","v":0},0,0,0,null,{"$f":"SUM(L134:L142)","v":0}]
[{"$f":"A125","v":2},{"$f":"B125","v":2},"Итого за день:",null,null,{"$f":"F133+F143","v":570},{"$f":"G133+G143","v":15},{"$f":"H133+H143","v":16},{"$f":"I133+I143","v":86},{"$f":"J133+J143","v":517},null,66.8]
[2,3,"Завтрак","гор.блюдо","Сосиски отварные ","2 шт./100",7,5,12,125,"№243/2015г"]
[{"$nulls":4},"Макароны отварные с сыром",140,5,7,30,201,"ТТК 2019г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0,0,8,32,"№630/1995г"]
[{"$nulls":4},"Напиток яблочный ",200,0,0,12,52,"№701/2004г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК  "]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Салат-бар (свекла отварная, морковь свежая порциями, зеленый горошек консервированный, сухарики из пшеничного хлеба, масло растительное)",60,3,6,15,125,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F145:F152)","v":610},{"$f":"SUM(G145:G152)","v":16},19,86,581,null,66.8]
[{"$f":"A145","v":2},{"$f":"B145","v":3},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F154:F162)","v":0},{"$f":"SUM(G154:G162)","v":0},0,0,0,null,{"$f":"SUM(L154:L162)","v":0}]
[{"$f":"A145","v":2},{"$f":"B145","v":3},"Итого за день:",null,null,{"$f":"F153+F163","v":610},{"$f":"G153+G163","v":16},{"$f":"H153+H163","v":19},{"$f":"I153+I163","v":86},{"$f":"J153+J163","v":581},null,66.8]
[2,4,"Завтрак","гор.блюдо","Плов с куриными грудками",160,13,12,34,297,"ТТК 2023г"]
[]
[{"$nulls":3},"гор.напиток","Сок ",180,0,0,18,83,"ТТК 2022г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",20,1,1,9,46,"ТТК"]
[{"$nulls":3},"фрукты","Плоды свежие (яблоки)",100,0,0,10,47,"№338/2015г"]
[{"$nulls":4},"Салат бар (помидоры свежие порциями, морковь свежая порциями, кукуруза консервированная, сухарики из пшеничного хлеба, масло растительное)",60,2,6,12,112,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F165:F171)","v":520},{"$f":"SUM(G165:G171)","v":16},19,83,585,null,66.8]
[{"$f":"A165","v":2},{"$f":"B165","v":4},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F173:F181)","v":0},{"$f":"SUM(G173:G181)","v":0},0,0,0,null,{"$f":"SUM(L173:L181)","v":0}]
[{"$f":"A165","v":2},{"$f":"B165","v":4},"Итого за день:",null,null,{"$f":"F172+F182","v":520},{"$f":"G172+G182","v":16},{"$f":"H172+H182","v":19},{"$f":"I172+I182","v":83},{"$f":"J172+J182","v":585},null,66.8]
[2,5,"Завтрак","гор.блюдо","Биточки рыбные из фарша минтая ",90,10,2,10,98,"ТТК 2021г"]
[{"$nulls":4},"Пюре картофельное с маслом сливочным  ","140/5",3,8,21,169,"№312/2015г"]
[{"$nulls":3},"гор.напиток","Чай с сахаром ",200,0,0,8,32,"№530/1995г"]
[{"$nulls":4},"Напиток из шиповника  ",200,0,0,10,40,"ТТК 2021г"]
[{"$nulls":3},"хлеб","Хлебная корзина (хлеб пшеничный/хлеб ржано-пшеничный)",10,1,1,9,46,"ТТК "]
[{"$nulls":3},"фрукты"]
[{"$nulls":4},"Салат-бар (морковь свеежая порциями, капуста белокачанная, зеленый  горошек консервированный, сухарики из пшениччного хлеба, масло растительное)",60,4,6,18,141,"ТТК 2023г"]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F184:F191)","v":560},{"$f":"SUM(G184:G191)","v":18},17,76,526,null,66.8]
[{"$f":"A184","v":2},{"$f":"B184","v":5},"Обед","закуска"]
[{"$nulls":3},"1 блюдо"]
[{"$nulls":3},"2 блюдо"]
[{"$nulls":3},"гарнир"]
[{"$nulls":3},"напиток"]
[{"$nulls":3},"хлеб бел."]
[{"$nulls":3},"хлеб черн."]
[]
[]
[{"$nulls":3},"итого",null,{"$f":"SUM(F193:F201)","v":0},{"$f":"SUM(G193:G201)","v":0},0,0,0,null,{"$f":"SUM(L193:L201)","v":0}]
[{"$f":"A184","v":2},{"$f":"B184","v":5},"Итого за день:",null,null,{"$f":"F192+F202","v":560},{"$f":"G192+G202","v":18},{"$f":"H192+H202","v":17},{"$f":"I192+I202","v":76},{"$f":"J192+J202","v":526},null,66.8]
[null,null,"Среднее значение за период:",null,null,{"$f":"(F25+F45+F65+F85+F104+F124+F144+F164+F183+F203)/(IF(F25=0,0,1)+IF(F45=0,0,1)+IF(F65=0,0,1)+IF(F85=0,0,1)+IF(F104=0,0,1)+IF(F124=0,0,1)+IF(F144=0,0,1)+IF(F164=0,0,1)+IF(F183=0,0,1)+IF(F203=0,0,1))","v":562},{"$f":"(G25+G45+G65+G85+G104+G124+G144+G164+G183+G203)/(IF(G25=0,0,1)+IF(G45=0,0,1)+IF(G65=0,0,1)+IF(G85=0,0,1)+IF(G104=0,0,1)+IF(G124=0,0,1)+IF(G144=0,0,1)+IF(G164=0,0,1)+IF(G183=0,0,1)+IF(G203=0,0,1))","v":16.136000000000003},{"$f":"(H25+H45+H65+H85+H104+H124+H144+H164+H183+H203)/(IF(H25=0,0,1)+IF(H45=0,0,1)+IF(H65=0,0,1)+IF(H85=0,0,1)+IF(H104=0,0,1)+IF(H124=0,0,1)+IF(H144=0,0,1)+IF(H164=0,0,1)+IF(H183=0,0,1)+IF(H203=0,0,1))","v":17.787},{"$f":"(I25+I45+I65+I85+I104+I124+I144+I164+I183+I203)/(IF(I25=0,0,1)+IF(I45=0,0,1)+IF(I65=0,0,1)+IF(I85=0,0,1)+IF(I104=0,0,1)+IF(I124=0,0,1)+IF(I144=0,0,1)+IF(I164=0,0,1)+IF(I183=0,0,1)+IF(I203=0,0,1))","v":77},{"$f":"(J25+J45+J65+J85+J104+J124+J144+J164+J183+J203)/(IF(J25=0,0,1)+IF(J45=0,0,1)+IF(J65=0,0,1)+IF(J85=0,0,1)+IF(J104=0,0,1)+IF(J124=0,0,1)+IF(J144=0,0,1)+IF(J164=0,0,1)+IF(J183=0,0,1)+IF(J203=0,0,1))","v":536},null,{"$f":"(L25+L45+L65+L85+L104+L124+L144+L164+L183+L203)/(IF(L25=0,0,1)+IF(L45=0,0,1)+IF(L65=0,0,1)+IF(L85=0,0,1)+IF(L104=0,0,1)+IF(L124=0,0,1)+IF(L144=0,0,1)+IF(L164=0,0,1)+IF(L183=0,0,1)+IF(L203=0,0,1))","v":66.79999999999998}]