{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Ringkasan Pembayaran","Jurnal Pembayaran"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan Pembayaran","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,1,0,3],[0,4,0,10]]}
[null,"Ringkasan Pembayaran",null,null,"Ubah nama Kategori di judul tabel Ringkasan Pembayaran di bawah ini untuk mengustomisasi templat ini agar sesuai dengan kebutuhan Anda.  Jika perlu menambahkan kategori tambahan, salin kolom terakhir di tabel dan tempelkan ke sebelah kanan kolom yang disalin. Saat Anda mengubah nama kategori, rumus akan diperbarui secara otomatis. Pastikan tabel ini memiliki jumlah baris yang sama seperti jumlah baris di lembar kerja Jurnal Pembayaran."]
[null,"Tanggal","Asuransi Kendaraan","Perlengkapan Kantor","Listrik","Hipotek","Telepon","Kosong 1","Kosong 2","Kosong 3","Kosong 4"]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A1),1),\"\")","v":"2018-04-05"},{"$f":"IFERROR(INDIRECT(\"Register[@Jumlah]\")*(INDIRECT(\"Register[@Kategori]\")=NamaKategori),\"\")","v":0},0,0,{"v":1200,"d":"Rp1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A2),1),\"\")","v":"2018-04-10"},0,0,{"v":85,"d":"Rp85.00"},0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A3),1),\"\")","v":"2018-04-15"},{"v":100,"d":"Rp100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A4),1),\"\")","v":"2018-04-20"},0,0,0,{"v":1200,"d":"Rp1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A5),1),\"\")","v":"2018-04-25"},0,0,0,{"v":99,"d":"Rp99.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A6),1),\"\")","v":"2018-04-30"},0,0,0,0,{"v":68,"d":"Rp68.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A7),1),\"\")","v":"2018-05-05"},{"v":100,"d":"Rp100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A8),1),\"\")","v":"2018-05-10"},0,{"v":345,"d":"Rp345.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A9),1),\"\")","v":"2018-05-15"},0,0,0,{"v":1200,"d":"Rp1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A10),1),\"\")","v":"2018-05-20"},0,0,{"v":74,"d":"Rp74.00"},0,0,0,0,0,{"$f":"IFERROR(INDIRECT(\"Register[@Jumlah]\")*(INDIRECT(\"Register[@Kategori]\")=NamaKategori),\"\")","v":0}]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A11),1),\"\")","v":"2018-05-25"},0,0,0,0,{"v":123,"d":"Rp123.00"},0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A12),1),\"\")","v":"2018-05-30"},0,{"v":99,"d":"Rp99.00"},0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A13),1),\"\")","v":"2018-06-04"},{"v":100,"d":"Rp100.00"},0,0,0,0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A14),1),\"\")","v":"2018-06-09"},0,0,0,{"v":1200,"d":"Rp1,200.00"},0,0,0,0,0]
[null,{"$f":"IFERROR(INDEX(Register[],ROW(A15),1),\"\")","v":"2018-06-14"},0,{"v":128,"d":"Rp128.00"},0,0,0,0,0,0,0]
[null,null,{"$f":"SUBTOTAL(109,RingkasanPembayaran[Asuransi Kendaraan])","v":{"v":300,"d":"Rp300.00"}},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Perlengkapan Kantor])","v":{"v":572,"d":"Rp572.00"}},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Listrik])","v":{"v":159,"d":"Rp159.00"}},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Hipotek])","v":{"v":4899,"d":"Rp4,899.00"}},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Telepon])","v":{"v":191,"d":"Rp191.00"}},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Kosong 1])","v":0},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Kosong 2])","v":0},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Kosong 3])","v":0},{"$f":"SUBTOTAL(109,RingkasanPembayaran[Kosong 4])","v":0}]

{"sheet":"Jurnal Pembayaran","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[0,1,0,3]]}
[null,"Jurnal Pembayaran"]
[null,"Tanggal","Nomor","Deskripsi","Kategori","Jumlah"]
[null,{"$f":"TODAY()-70","v":"2018-04-05"},"100","Woodgrove Bank","Hipotek",{"v":1200,"d":"Rp1,200.00"}]
[null,{"$f":"TODAY()-65","v":"2018-04-10"},101,"City Power & Light","Listrik",{"v":85,"d":"Rp85.00"}]
[null,{"$f":"TODAY()-60","v":"2018-04-15"},102,"Humongous Insurance","Asuransi Kendaraan",{"v":100,"d":"Rp100.00"}]
[null,{"$f":"TODAY()-55","v":"2018-04-20"},103,"Woodgrove Bank","Hipotek",{"v":1200,"d":"Rp1,200.00"}]
[null,{"$f":"TODAY()-50","v":"2018-04-25"},104,"City Power & Light","Hipotek",{"v":99,"d":"Rp99.00"}]
[null,{"$f":"TODAY()-45","v":"2018-04-30"},105,"The Phone Company","Telepon",{"v":68,"d":"Rp68.00"}]
[null,{"$f":"TODAY()-40","v":"2018-05-05"},106,"Humongous Insurance","Asuransi Kendaraan",{"v":100,"d":"Rp100.00"}]
[null,{"$f":"TODAY()-35","v":"2018-05-10"},107,"Litware, Inc.","Perlengkapan Kantor",{"v":345,"d":"Rp345.00"}]
[null,{"$f":"TODAY()-30","v":"2018-05-15"},110,"Woodgrove Bank","Hipotek",{"v":1200,"d":"Rp1,200.00"}]
[null,{"$f":"TODAY()-25","v":"2018-05-20"},111,"City Power & Light","Listrik",{"v":74,"d":"Rp74.00"}]
[null,{"$f":"TODAY()-20","v":"2018-05-25"},108,"The Phone Company","Telepon",{"v":123,"d":"Rp123.00"}]
[null,{"$f":"TODAY()-15","v":"2018-05-30"},109,"Litware, Inc.","Perlengkapan Kantor",{"v":99,"d":"Rp99.00"}]
[null,{"$f":"TODAY()-10","v":"2018-06-04"},112,"Humongous Insurance","Asuransi Kendaraan",{"v":100,"d":"Rp100.00"}]
[null,{"$f":"TODAY()-5","v":"2018-06-09"},113,"Woodgrove Bank","Hipotek",{"v":1200,"d":"Rp1,200.00"}]
[null,{"$f":"TODAY()","v":"2018-06-14"},114,"Litware, Inc.","Perlengkapan Kantor",{"v":128,"d":"Rp128.00"}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Register[Jumlah])","v":{"v":6121,"d":"Rp6,121.00"}}]