{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Продукты","Клиенты"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":153,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Продукты","index":0,"n_rows":114,"n_cols":15,"rows_kept":114,"cut":false,"hidden":false,"merged":[[0,15,0,16],[108,1,108,2]]}
[null,"Содержание в 100 г. продукта.","https://health-diet.ru/table_calorie/"]
[null,"Продукт","Белки, гр.","Жиры, гр.","Углеводы, гр.","Ккал","Цена за 100г.","Значимость (>0):  меньше- выше, 10-запрет","Кол--во","Белки ","Жиры","Угле- вводы","Ккал","Реальная цена           (за 100г)","\"Цена\"             с учетом значимости "]
[1,"Абрикосы",0.9,0,10.5,45,17.399999999999999,1,0,{"$f":"C3*I3","v":0},{"$f":"D3*I3","v":0},{"$f":"E3*I3","v":0},{"$f":"F3*I3","v":0},{"$f":"G3*I3","v":0},{"$f":"N3*H3","v":0}]
[2,"Айва",0.6,0,8.9,38,18.5,1,0,0,0,0,0,0,{"$f":"N4*H4","v":0}]
[3,"Алыча",0.2,0,7.4,30,30,1,0,0,0,0,0,0,0]
[4,"Ананас",0.4,0,11.8,48,23.4,1,0,0,0,0,0,0,0]
[5,"Апельсин",0.9,0,8.4,37,7,1,0,0,0,0,0,0,0]
[6,"Арахис",26.3,45.2,9.6999999999999993,550,19,1,0,0,0,0,0,0,0]
[7,"Арбузы",0.5,0.2,6,27,2.2333333333333334,1,0,0,0,0,0,0,0]
[8,"Баклажаны",0.6,0.1,5.5,25,3.4,1,0,0,0,0,0,0,0]
[9,"Бананы",1.5,0,22,94,8.0333333333333332,1,0,0,0,0,0,0,0]
[10,"Баранина",16.3,15.3,0,202,34.75,1,0,0,0,0,0,0,0]
[11,"Баранки",10,2,69,334,16,1,0,0,0,0,0,0,0]
[12,"Бобы",6,0.1,8.3000000000000007,58,25.75,1,0,0,0,0,0,0,0]
[13,"Брынза",17.899999999999999,20.100000000000001,0,252,20.5,1,0,0,0,0,0,0,0]
[14,"Бычки",12.8,8.1,5.2,144,8.5,1,0,0,0,0,0,0,0]
[15,"Вафли со слив. начинкой",3,30,64,538,23,1,0,0,0,0,0,0,0]
[16,"Вафли с фрукт. начинкой",3,5,80,377,21.5,1,0,0,0,0,0,0,0]
[17,"Ветчина",22.6,20.9,0,278,24.333333333333332,1,0,0,0,0,0,0,0]
[18,"Виноград",1,1,18,85,16.666666666666668,1,0,0,0,0,0,0,0]
[19,"Вишня",1.5,0,73,298,19.666666666666668,1,0,0,0,0,0,0,0]
[20,"Геркулес",13.1,6.2,65.7,371,5.72,1,0,0,0,0,0,0,0]
[21,"Говядина",18.899999999999999,12.4,0,187,31.5,1,0,0,0,0,0,0,0]
[22,"Горбуша",21,7,0,147,24.966666666666669,1,0,0,0,0,0,0,0]
[23,"Гранат",0.9,0,11.8,50,30,1,0,0,0,0,0,0,0]
[24,"Грейпфрут",0.9,0,7.3,32,5.5,1,0,0,0,0,0,0,0]
[25,"Гусятина",16.100000000000001,33.299999999999997,0,364,21,1,0,0,0,0,0,0,0]
[26,"Изюм",2.2999999999999998,0,71.2,294,46,1,0,0,0,0,0,0,0]
[27,"Икра осетровая",36,10.199999999999999,0,235,2500,1,0,0,0,0,0,0,0]
[28,"Индейка",21.6,12,0.8,197,21.5,1,0,0,0,0,0,0,0]
[29,"Инжир",0.7,0,13.9,58,11,1,0,0,0,0,0,0,0]
[30,"Йогурт1,5% жирности",5,1.5,3.5,47,10.5,1,0,0,0,0,0,0,0]
[31,"Кабачки",0.6,0.3,5.7,27,4.6500000000000004,1,0,0,0,0,0,0,0]
[32,"Камбала",16.100000000000001,2.6,0,87,22,1,0,0,0,0,0,0,0]
[33,"Капуста цветная",2.5,0,4.9000000000000004,29,16.7,1,0,{"$f":"C35*I35","v":0},{"$f":"D35*I35","v":0},{"$f":"E35*I35","v":0},{"$f":"F35*I35","v":0},{"$f":"G35*I35","v":0},0]
[34,"Карп",16,3.6,0,96,20,1,0,0,0,0,0,0,0]
[35,"Картофель",2,0.1,19.7,87,1.78,0.5,1,2,0.1,19.7,87,1.78,0.89]
[36,"Кизил",1,0,9.6999999999999993,42,10,1,0,0,0,0,0,0,0]
[37,"Клубника, земляника",1.2,0,8,36,19,1,0,0,0,0,0,0,0]
[38,"Конина",20.2,7,0,143,24,1,0,0,0,0,0,0,0]
[39,"Конфеты шоколадные",3,20,67,460,18,1,0,0,0,0,0,0,0]
[40,"Корюшка",15.5,3.2,0,90,21,1,0,0,0,0,0,0,0]
[41,"Краб",16,0.5,0,68,185,1,0,0,0,0,0,0,0]
[42,"Креветки",22,1,0,97,54,1,0,0,0,0,0,0,0]
[43,"Крупа гречневая",12.6,2.6,68,345,5.95,1,0,0,0,0,0,0,0]
[44,"Крупа манная",11.3,0.7,73.3,344,6,1,0,0,0,0,0,0,0]
[45,"Крупа овсяная",12,6,67,370,3.5,1,1.3231259288550352,15.877511146260423,7.9387555731302113,88.649437233287358,489.55659367636304,4.6309407509926235,4.6309407509926235]
[46,"Крыжовник",0.7,0,9.9,42,26,1,0,0,0,0,0,0,0]
[47,"Куры",20.8,8.8000000000000007,0.6,164,10.15,1,0,0,0,0,0,0,0]
[48,"Лимон",0.9,0,3.6,18,8,1,0,0,0,0,0,0,0]
[49,"Майонез",3.1,67,2.6,625,10,1,0,0,0,0,0,0,0]
[50,"Макаронные изделия",11,0.9,74.2,348,6.1,1,0,0,0,0,0,0,0]
[51,"Мандарин",0.8,0,8.6,37,17.95,1,0,0,0,0,0,0,0]
[52,"Маргарин бутербродный",0.5,82,1.2,744,3.6,1,0.54213563892706729,0.27106781946353364,44.455122392019518,0.6505627667124807,403.34891536173808,1.9516883001374423,1.9516883001374423]
[53,"Маргарин молочный",0.3,82.3,1,745,7,1,0,0,0,0,0,0,0]
[54,"Мармелад",0,0.1,77.7,311,9,1,0,0,0,0,0,0,0]
[55,"Масло оливковое",null,null,null,null,30,1,0,0,0,0,0,0,0]
[56,"Масло растительное",0,99.9,0,899,6,1,0,0,0,0,0,0,0]
[57,"Масло сливочное",0.6,82.5,0.9,748,7,1,0,0,0,0,0,0,0]
[58,"Масло топленое",0.3,98,0.6,885,86.5,1,0,0,0,0,0,0,0]
[59,"Масса творожная",7.1,23,27.5,345,16,1,0,0,0,0,0,0,0]
[60,"Мед",0.8,0,80.3,324,100,1,0,0,0,0,0,0,0]
[61,"Миндаль",18.600000000000001,57.7,13.6,648,88.6,1,0,0,0,0,0,0,0]
[62,"Минога",14.7,11.9,0,165,32.5,1,0,0,0,0,0,0,0]
[63,"Минтай",15.9,0.7,0,69,22.833333333333332,1,0,0,0,0,0,0,0]
[64,"Мозги говяжьи",9.5,9.5,0,123,6.85,1,0,0,0,0,0,0,0]
[65,"Мойва",13.4,11.5,0,157,5.6,1,0,{"$f":"C67*I67","v":0},{"$f":"D67*I67","v":0},{"$f":"E67*I67","v":0},{"$f":"F67*I67","v":0},{"$f":"G67*I67","v":0},0]
[66,"Молоко",2.8,3.2,4.7,58,9.4,1,0,0,0,0,0,0,{"$f":"N68*H68","v":0}]
[67,"Молоко ацидофильное",2.8,3.2,10.8,83,7.5,1,0,0,0,0,0,0,0]
[68,"Молоко сгущеное",7,7.9,9.5,137,11.65,1,0,0,0,0,0,0,0]
[69,"Молоко сгущеное",7.2,8.5,56,329,7,1,0,0,0,0,0,0,0]
[70,"Молоко сухое цельное",25.6,25,39.4,485,4.4000000000000004,10,0,0,0,0,0,0,0]
[71,"Морковь",1.3,0.1,7,34,2.7749999999999999,1,0,0,0,0,0,0,0]
[72,"Морошка",0.8,0,6.8,30,40,1,0,0,0,0,0,0,0]
[73,"Морская капуста",0.9,0.2,3,17,41,1,0,0,0,0,0,0,0]
[74,"Навага",16.100000000000001,1,0,73,15,1,0,0,0,0,0,0,0]
[75,"Налим",18.8,0.6,0,80,8.1,1,0,0,0,0,0,0,0]
[76,"Облепиха",0.9,0,5.5,25,19.333333333333332,1,0,0,0,0,0,0,0]
[77,"Огурцы",0.8,0,3,15,14.25,1,0,0,0,0,0,0,0]
[78,"Оливки",5.2,51,10,519,27.666666666666668,1,0,0,0,0,0,0,0]
[79,"Пастила",0.5,0,80.400000000000006,323,20,1,0,0,0,0,0,0,0]
[80,"Персики",0.6,0,16,66,19.5,1,0,0,0,0,0,0,0]
[81,"Печень говяжья",17.399999999999999,3.1,0,97,5.6,1,2,34.799999999999997,6.2,0,194,11.2,11.2]
[82,"Помидоры (томаты)",1,0.2,3.7,20,7.9,1,0,0,0,0,0,0,0]
[83,"Редис",1.2,0,4.0999999999999996,21,25,1,0,0,0,0,0,0,0]
[84,"Рис",8,1,76,345,11.324999999999999,1,0,0,0,0,0,0,0]
[85,"Ряженка",3,6,4.0999999999999996,82,2.5,1,0,0,0,0,0,0,0]
[86,"Салат",1.5,0,2.2000000000000002,14,20,1,0,0,0,0,0,0,0]
[87,"Семга",20.8,15.1,0,219,70,1,0,0,0,0,0,0,0]
[88,"Смородина черная",1,0,8,36,2.6,1,0,0,0,0,0,0,0]
[89,"Сушки",11,1.3,73,347,14,1,0,0,0,0,0,0,0]
[90,"Сыр швейцарский",25,37,0,433,150,1,0,0,0,0,0,0,0]
[91,"Творог нежирный",18,2,1.5,96,5.5,1,0,0,0,0,0,0,0]
[92,"Творог обезжиренный",16.100000000000001,0.5,2.8,80,32,1,0,0,0,0,0,0,0]
[93,"Телятина жирная",19,8,0,148,60,1,0,0,0,0,0,0,0]
[94,"Тунец",23,1,0,101,90,1,0,0,0,0,0,0,0]
[95,"Фасоль",22.3,1.7,54.5,322,8.5,1,0,0,0,0,0,0,0]
[96,"Финики",2.5,0,72.099999999999994,298,7,1,0,0,0,0,0,0,0]
[97,"Хлеб ржаной",4.7,0.7,49.8,224,4.5,1,0,{"$f":"C99*I99","v":0},{"$f":"D99*I99","v":0},{"$f":"E99*I99","v":0},{"$f":"F99*I99","v":0},{"$f":"G99*I99","v":0},0]
[98,"Хлеб ржаной грубый",4.2,0.8,43,196,2.5,1,2.0000000000000004,8.4000000000000021,1.6000000000000005,86.000000000000014,392.00000000000011,5.0000000000000009,5.0000000000000009]
[99,"Хурма",0.5,0,15.9,65,7,1,0,0,0,0,0,0,0]
[100,"Черешня",1.1000000000000001,0,12.3,53,15,1,0,0,0,0,0,0,0]
[101,"Шоколад молочный",6.9,35.700000000000003,52.4,558,65,1,0,0,0,0,0,0,0]
[102,"Шоколад темный",5.4,35.299999999999997,52.6,549,25,1,0,0,0,0,0,0,0]
[103,"Яблоки",0.4,0,11.3,46,8.6666666666666661,1,0,0,0,0,0,0,0]
[104,"Язь",18.2,1,0,81,4.5,1,4.7061220348503161,85.651421034275756,4.7061220348503161,0,381.1958848228756,21.177549156826423,21.177549156826423]
[105,"Яйцо куриное",12.7,11.5,0.7,157,5.5750000000000002,1,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I3:I107)","v":11.571383602632419},{"$f":"SUM(J3:J107)","v":146.99999999999972},{"$f":"SUM(K3:K107)","v":65.000000000000043},194.99999999999986,1947.1013938609767,{"$f":"SUM(N3:N107)","v":45.74017820795649},{"$f":"SUM(O3:O107)","v":44.850178207956489}]
[null,"Базовые продукты (суммарно)"]
[null,"Хлеб",{"$f":"SUM($I$99,$I$100)","v":2.0000000000000004}]
[null,"Крупа",{"$f":"SUM($I$45,$I$47)","v":1.3231259288550352}]
[null,"Мясо",{"$f":"SUM($I$12,$I$23,$I$27,$I$83,$I$95)","v":2}]
[null,"Овощи",{"$f":"SUM($I$10,$I$35,$I$37,$I$74,$I$73,$I$97)","v":1}]
[null,"Фрукты",{"$f":"SUM($I$7,$I$20,$I$25,$I$26,$I$28,$I$98,$I$101,$I$105)","v":0}]

{"sheet":"Клиенты","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,0,5],[0,6,0,7]]}
["№","Клиент","Суточная потребность",null,null,null,"Всего записей:",null,7]
[null,null,"Белки","Жиры","Углеводы","Каллории"]
[1,"Иванов Ваня","123","123","123","1233"]
[2,"Иванов Ваня1","123","123","123","1954"]
[3,"Иванов Ваня","123","123","123","1986"]
[4,"Иванов Ваня","123","123","123","1720"]
[5,"Иванов Ваня","147","65","195","1954"]
[6,"Иванов Ваня","129","57","172","1720"]
[7,"Иванов Ваня","129","57","172","1720"]