{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Внесение средств","Снятие средств"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Внесение средств","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"Ежемесячная\nбанковская\nвыписка",null,"МЕСЯЦ","ПРЕДЫДУЩИЙ БАЛАНС","ОБЩАЯ СУММА ВНЕСЕНИЯ"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"ММММ\"))","v":"МАЙ"},{"v":2525.54,"d":"2,525.54 ₽"},{"$f":"Общая_сумма_внесения","v":{"v":5400,"d":"5,400.00 ₽"}}]
[{"$nulls":3},"ГОД","КОНЕЧНЫЙ БАЛАНС","ОБЩАЯ СУММА СНЯТИЯ"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(КонечныйБаланс+Общая_сумма_внесения-Общая_сумма_снятия, \"\")","v":{"v":6550.54,"d":"6,550.54 ₽"}},{"$f":"Общая_сумма_снятия","v":{"v":1375,"d":"1,375.00 ₽"}}]
[null,"Внесение средств"]
[null,"№ депозита","Дата","Сумма","Описание","Выверено"]
[null,{"$f":"ROW()-ROW(Внесение_средств[[#Headers],[№ депозита]])","v":1},{"$f":"TODAY()-15","v":"2018-05-02"},{"v":1500,"d":"1,500.00 ₽"},"Задание 1, чек 1","Да"]
[null,{"$f":"ROW()-ROW(Внесение_средств[[#Headers],[№ депозита]])","v":2},{"$f":"TODAY()-10","v":"2018-05-07"},{"v":1200,"d":"1,200.00 ₽"},"Задание 2, чек 1","Да"]
[null,{"$f":"ROW()-ROW(Внесение_средств[[#Headers],[№ депозита]])","v":3},{"$f":"TODAY()-5","v":"2018-05-12"},{"v":1500,"d":"1,500.00 ₽"},"Задание 1, чек 2","Да"]
[null,{"$f":"ROW()-ROW(Внесение_средств[[#Headers],[№ депозита]])","v":4},{"$f":"TODAY()","v":"2018-05-17"},{"v":1200,"d":"1,200.00 ₽"},"Задание 2, чек 2","Да"]
[null,"ИТОГ",null,{"$f":"SUBTOTAL(109,Внесение_средств[Сумма])","v":{"v":5400,"d":"5,400.00 ₽"}}]

{"sheet":"Снятие средств","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"Снятие средств"]
[null,"Тип","Дата","Сумма","Цели","Выверено"]
[null,"Чек 1001",{"$f":"TODAY()-8","v":"2018-05-09"},{"v":150,"d":"150.00 ₽"},"Электричество","Да"]
[null,"Чек 1002",{"$f":"TODAY()-6","v":"2018-05-11"},{"v":150,"d":"150.00 ₽"},"Водоснабжение, водоотведение, вывоз мусора","Да"]
[null,"Чек 1003",{"$f":"TODAY()-4","v":"2018-05-13"},{"v":850,"d":"850.00 ₽"},"Ипотека","Да"]
[null,"Дебет",{"$f":"TODAY()-2","v":"2018-05-15"},{"v":125,"d":"125.00 ₽"},"Продукты","Да"]
[null,"Банкомат",{"$f":"TODAY()","v":"2018-05-17"},{"v":100,"d":"100.00 ₽"},"Наличные","Да"]
[null,"ИТОГ",null,{"$f":"SUBTOTAL(109,Чеки[Сумма])","v":{"v":1375,"d":"1,375.00 ₽"}}]