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

{"sheet":"Реестр чеков","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Реестр чеков"]
[null,"УСЛОВНЫЕ ОБОЗНАЧЕНИЯ",{"$nulls":5},"ТЕКУЩИЙ ОСТАТОК"]
[null,"ПК = Платежная карта",null,"АП = Автоматический платеж ",{"$nulls":3},{"$f":"ТЕКУЩИЙ_БАЛАНС","v":{"v":3311,"d":"3,311.00 ₽"}}]
[null,"ATM = Банкомат",null,"ОС = Оплата счета в Интернете"]
[null,"АД = Автоматический депозит ",null,"ПЕ = Перевод по Интернету или телефону"]
[null,"ЧЕК/КОД","ДАТА","ТРАНЗАКЦИЯ","ОПИСАНИЕ","СНЯТИЕ","ВНЕСЕНИЕ","ОСТАТОК"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-22"},"Городской банк","Остаток на начало периода",null,{"v":2000,"d":"2,000.00 ₽"},{"$f":"IFERROR(РеестрЧеков[[#This Row],[ВНЕСЕНИЕ]], \"\")","v":{"v":2000,"d":"2,000.00 ₽"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-30"},"Художественная школа","Занятия рисованием Ольги — 6 недель",{"v":100,"d":"100.00 ₽"},null,{"$f":"IFERROR(IF(ISBLANK(РеестрЧеков[[#This Row],[СНЯТИЕ]]),H7+РеестрЧеков[[#This Row],[ВНЕСЕНИЕ]],H7-РеестрЧеков[[#This Row],[СНЯТИЕ]]), \"\")","v":{"v":1900,"d":"1,900.00 ₽"}}]
[null,"АД",{"$f":"TODAY()-11","v":"2022-03-30"},"Зарплата",null,null,{"v":1500,"d":"1,500.00 ₽"},{"$f":"IFERROR(IF(ISBLANK(РеестрЧеков[[#This Row],[СНЯТИЕ]]),H8+РеестрЧеков[[#This Row],[ВНЕСЕНИЕ]],H8-РеестрЧеков[[#This Row],[СНЯТИЕ]]), \"\")","v":{"v":3400,"d":"3,400.00 ₽"}}]
[null,"ПК",{"$f":"TODAY()-8","v":"2022-04-02"},"Southridge Video","Прокат фильмов + 100 ₽ возврат",{"v":16,"d":"16.00 ₽"},null,{"$f":"IFERROR(IF(ISBLANK(РеестрЧеков[[#This Row],[СНЯТИЕ]]),H9+РеестрЧеков[[#This Row],[ВНЕСЕНИЕ]],H9-РеестрЧеков[[#This Row],[СНЯТИЕ]]), \"\")","v":{"v":3384,"d":"3,384.00 ₽"}}]
[null,"ATM",{"$f":"TODAY()-5","v":"2022-04-05"},null,"Наличные на ресторан",{"v":50,"d":"50.00 ₽"},null,{"$f":"IFERROR(IF(ISBLANK(РеестрЧеков[[#This Row],[СНЯТИЕ]]),H10+РеестрЧеков[[#This Row],[ВНЕСЕНИЕ]],H10-РеестрЧеков[[#This Row],[СНЯТИЕ]]), \"\")","v":{"v":3334,"d":"3,334.00 ₽"}}]
[null,"ОС",{"$f":"TODAY()","v":"2022-04-10"},"Телефонная компания",null,{"v":23,"d":"23.00 ₽"},null,{"$f":"IFERROR(IF(ISBLANK(РеестрЧеков[[#This Row],[СНЯТИЕ]]),H11+РеестрЧеков[[#This Row],[ВНЕСЕНИЕ]],H11-РеестрЧеков[[#This Row],[СНЯТИЕ]]), \"\")","v":{"v":3311,"d":"3,311.00 ₽"}}]
[null,"Итог",null,{"$f":"CONCATENATE(\"Количество транзакций: \",SUBTOTAL(103,РеестрЧеков[ТРАНЗАКЦИЯ]))","v":"Количество транзакций: 5"},null,{"$f":"SUBTOTAL(109,РеестрЧеков[СНЯТИЕ])","v":{"v":189,"d":"189.00 ₽"}},{"$f":"SUBTOTAL(109,РеестрЧеков[ВНЕСЕНИЕ])","v":{"v":3500,"d":"3,500.00 ₽"}},{"$f":"РеестрЧеков[[#Totals],[ВНЕСЕНИЕ]]-РеестрЧеков[[#Totals],[СНЯТИЕ]]","v":{"v":3311,"d":"3,311.00 ₽"}}]