{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Setoran","Penarikan"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Setoran","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,3,2]]}
[null,"rekening\nkoran\nbulanan",null,"BULAN","SALDO AWAL","TOTAL SETORAN"]
[{"$nulls":3},{"$f":"UPPER(TEXT(TODAY(),\"mmmm\"))","v":"MEI"},{"v":2525.54,"d":"Rp2,525.54"},{"$f":"Total_deposit","v":{"v":5400,"d":"Rp5,400.00"}}]
[{"$nulls":3},"TAHUN","SALDO AKHIR","TOTAL PENARIKAN"]
[{"$nulls":3},{"$f":"YEAR(TODAY())","v":2018},{"$f":"IFERROR(SaldoAkhir+Total_deposit-Total_penarikan, \"\")","v":{"v":6550.54,"d":"Rp6,550.54"}},{"$f":"Total_penarikan","v":{"v":1375,"d":"Rp1,375.00"}}]
[null,"setoran"]
[null,"no. setoran","tanggal","jumlah","deskripsi","direkonsiliasi"]
[null,{"$f":"ROW()-ROW(Setoran[[#Headers],[no. setoran]])","v":1},{"$f":"TODAY()-15","v":"2018-05-02"},{"v":1500,"d":"Rp1,500.00"},"pekerjaan 1, cek 1","ya"]
[null,{"$f":"ROW()-ROW(Setoran[[#Headers],[no. setoran]])","v":2},{"$f":"TODAY()-10","v":"2018-05-07"},{"v":1200,"d":"Rp1,200.00"},"pekerjaan 2, cek 1","ya"]
[null,{"$f":"ROW()-ROW(Setoran[[#Headers],[no. setoran]])","v":3},{"$f":"TODAY()-5","v":"2018-05-12"},{"v":1500,"d":"Rp1,500.00"},"pekerjaan 1, cek 2","ya"]
[null,{"$f":"ROW()-ROW(Setoran[[#Headers],[no. setoran]])","v":4},{"$f":"TODAY()","v":"2018-05-17"},{"v":1200,"d":"Rp1,200.00"},"pekerjaan 2, cek 2","ya"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Setoran[jumlah])","v":{"v":5400,"d":"Rp5,400.00"}}]

{"sheet":"Penarikan","index":1,"n_rows":8,"n_cols":6,"rows_kept":8}
[null,"penarikan"]
[null,"jenis","tanggal","jumlah","untuk","direkonsiliasi"]
[null,"cek 1001",{"$f":"TODAY()-8","v":"2018-05-09"},{"v":150,"d":"Rp150.00"},"listrik","ya"]
[null,"cek 1002",{"$f":"TODAY()-6","v":"2018-05-11"},{"v":150,"d":"Rp150.00"},"air/saluran pembuangan/sampah","ya"]
[null,"cek 1003",{"$f":"TODAY()-4","v":"2018-05-13"},{"v":850,"d":"Rp850.00"},"hipotek","ya"]
[null,"debit",{"$f":"TODAY()-2","v":"2018-05-15"},{"v":125,"d":"Rp125.00"},"bahan makanan","ya"]
[null,"ATM",{"$f":"TODAY()","v":"2018-05-17"},{"v":100,"d":"Rp100.00"},"kas","ya"]
[null,"TOTAL",null,{"$f":"SUBTOTAL(109,Cek[jumlah])","v":{"v":1375,"d":"Rp1,375.00"}}]