{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Календарь","Дневник питания","База данных"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Календарь"]
[]
["Дата","К_К","Б_К","Ж_К","У_К","ККАЛ_К","К_Т","Б_Т","Ж_Т","У_Т","ККАЛ_Т",null,"График К"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"График Т"]

{"sheet":"Дневник питания","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Дата",null,null,null,"Кнопка: Новый день (по нажатию суммарные данные переносятся в календарь, таблица учета отчищается)"]
[]
["Сводный результат",null,null,null,null,null,null,null,null,"Сумма","Сумма","Сумма"]
[null,null,null,null,null,null,null,null,null,"Процент","Процент","Процент"]
[null,null,null,null,null,null,null,null,null,"Остаток","Остаток","Остаток"]
[]
[]
["Чиабата",{"$f":"VLOOKUP($A8,БазаДанных,2,FALSE)","v":43.5},{"$f":"VLOOKUP($A8,БазаДанных,3,FALSE)","v":7.72},{"$f":"VLOOKUP($A8,БазаДанных,4,FALSE)","v":3.75},{"$f":"VLOOKUP($A8,БазаДанных,5,FALSE)","v":229}]
[]
[]
[]
["Таблица учета"]
[]
["Наименование продукта","К","Б","Ж","У"]

{"sheet":"База данных","index":2,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Название продукта","Ккал","Белки","Жиры","Углеводы","Вес порции","Статус","Индекс","Фильтр"]
["Куриное филе",0.4,23.6,2,113,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A2)))","v":false},{"$f":"IF($G2,COUNTIF($G$2:$G2,TRUE),\"\")","v":""},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H2),стлИндекс,0)),\"\")","v":"Чиабата"}]
["Чиабата",43.5,7.72,3.75,229,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A3)))","v":true},{"$f":"IF($G3,COUNTIF($G$2:$G3,TRUE),\"\")","v":1},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H3),стлИндекс,0)),\"\")","v":""}]
["Масло сливочное",0.8,0.5,82.5,748,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A4)))","v":false},{"$f":"IF($G4,COUNTIF($G$2:$G4,TRUE),\"\")","v":""},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H4),стлИндекс,0)),\"\")","v":""}]
["Мандарин",7.5,0.8,0.2,33,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A5)))","v":false},{"$f":"IF($G5,COUNTIF($G$2:$G5,TRUE),\"\")","v":""},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H5),стлИндекс,0)),\"\")","v":""}]
["Яблоко",9.8000000000000007,0.4,0.4,47,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A6)))","v":false},{"$f":"IF($G6,COUNTIF($G$2:$G6,TRUE),\"\")","v":""},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H6),стлИндекс,0)),\"\")","v":""}]
["Сахар",99.7,null,null,398,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A7)))","v":false},{"$f":"IF($G7,COUNTIF($G$2:$G7,TRUE),\"\")","v":""},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H7),стлИндекс,0)),\"\")","v":""}]
["Молоко",4.7,2.9,2.5,53,null,{"$f":"NOT(ISERROR(SEARCH('Дневник питания'!$A$8,$A8)))","v":false},{"$f":"IF($G8,COUNTIF($G$2:$G8,TRUE),\"\")","v":""},{"$f":"IFERROR(INDEX(стлПродукт,MATCH(ROWS($H$2:$H8),стлИндекс,0)),\"\")","v":""}]