{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Реестр чеков"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Реестр чеков","index":0,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,1,11,2],[12,1,12,2]]}
[null,"Реестр чеков"]
[null,"Введите в этой ячейке номер банковского счета"]
[null,{"$f":"CONCATENATE(\"Текущий остаток : \"&TEXT(РеестрЧеков[[#Totals],[Остаток]],\"# ##0,00 ₽\"))","v":"Текущий остаток : 2 730,84 ₽"}]
[]
[{"$nulls":4},"Номер чека","Дата","Описание","Категория","Снято средств со счета","Внесено средств на счет","Остаток"]
[{"$nulls":5},{"$f":"TODAY()-60","v":"2018-03-12"},"Остаток на начало периода","Внесено средств на счет",null,{"v":2916.73,"d":"2,916.73 ₽"},{"$f":"ПервоначальныйОстаток","v":{"v":2916.73,"d":"2,916.73 ₽"}}]
[{"$nulls":4},2251,{"$f":"TODAY()-59","v":"2018-03-13"},"Продовольственные продукты","Продовольственные товары",{"v":205.61,"d":"205.61 ₽"},null,{"$f":"Остаток","v":{"v":2711.12,"d":"2,711.12 ₽"}}]
[{"$nulls":4},67112449,{"$f":"TODAY()-45","v":"2018-03-27"},"Ипотека","Ипотека",{"v":961.77,"d":"961.77 ₽"},null,{"$f":"Остаток","v":{"v":1749.35,"d":"1,749.35 ₽"}}]
[{"$nulls":4},"Дебет",{"$f":"TODAY()-40","v":"2018-04-01"},"Кафе","Другое",{"v":3.65,"d":"3.65 ₽"},null,{"$f":"Остаток","v":{"v":1745.6999999999998,"d":"1,745.70 ₽"}}]
[{"$nulls":4},2252,{"$f":"TODAY()-35","v":"2018-04-06"},"Компания по газо- и электроснабжению","Коммунальные услуги",{"v":145.33,"d":"145.33 ₽"},null,{"$f":"Остаток","v":{"v":1600.37,"d":"1,600.37 ₽"}}]
[{"$nulls":4},"Банкомат",{"$f":"TODAY()-30","v":"2018-04-11"},"Наличные","Другое",{"v":50,"d":"50.00 ₽"},null,{"$f":"Остаток","v":{"v":1550.37,"d":"1,550.37 ₽"}}]
[{"$nulls":4},68240158,{"$f":"TODAY()-25","v":"2018-04-16"},"Кредитная карта","Кредитная карта",{"v":936.48,"d":"936.48 ₽"},null,{"$f":"Остаток","v":{"v":613.8899999999999,"d":"613.89 ₽"}}]
[null,"Сводка",{"$nulls":3},{"$f":"TODAY()-20","v":"2018-04-21"},"Зарплата","Внесено средств на счет",null,{"v":2365.82,"d":"2,365.82 ₽"},{"$f":"Остаток","v":{"v":2979.71,"d":"2,979.71 ₽"}}]
[null,"Категория","Итого",null,null,{"$f":"TODAY()-15","v":"2018-04-26"},"Инвестиции взаимного фонда","Инвестиции",{"v":200,"d":"200.00 ₽"},null,{"$f":"Остаток","v":{"v":2779.71,"d":"2,779.71 ₽"}}]
[null,"Внесено средств на счет",{"$f":"ИтогКатегории","v":{"v":5282.55,"d":"5,282.55 ₽"}},null,2253,{"$f":"TODAY()","v":"2018-05-11"},"Телефонная компания","Коммунальные услуги",{"v":48.87,"d":"48.87 ₽"},null,{"$f":"Остаток","v":{"v":2730.84,"d":"2,730.84 ₽"}}]
[null,"Кредитная карта",{"$f":"ИтогКатегории","v":{"v":936.48,"d":"936.48 ₽"}},null,"Итого",{"$nulls":3},{"$f":"SUBTOTAL(109,РеестрЧеков[Снято средств со счета])","v":{"v":2551.71,"d":"2,551.71 ₽"}},{"$f":"SUBTOTAL(109,РеестрЧеков[Внесено средств на счет])","v":{"v":5282.55,"d":"5,282.55 ₽"}},{"$f":"РеестрЧеков[[#Totals],[Внесено средств на счет]]-РеестрЧеков[[#Totals],[Снято средств со счета]]","v":{"v":2730.84,"d":"2,730.84 ₽"}}]
[null,"Инвестиции",{"$f":"ИтогКатегории","v":{"v":200,"d":"200.00 ₽"}}]
[null,"Продовольственные товары",{"$f":"ИтогКатегории","v":{"v":205.61,"d":"205.61 ₽"}}]
[null,"Коммунальные услуги",{"$f":"ИтогКатегории","v":{"v":194.20000000000002,"d":"194.20 ₽"}}]
[null,"Страхование",{"$f":"ИтогКатегории","v":{"v":0,"d":"0.00 ₽"}}]
[null,"Ипотека",{"$f":"ИтогКатегории","v":{"v":961.77,"d":"961.77 ₽"}}]
[null,"Другое",{"$f":"ИтогКатегории","v":{"v":53.65,"d":"53.65 ₽"}}]