{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Catatan Kartu Kredit"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Catatan Kartu Kredit","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
[null,"Nama Kartu Kredit"]
[null,"Masukkan pembayaran sebagai jumlah negatif dalam tabel di bawah ini."]
[null,"Tanggal","Deskripsi","Jumlah","Nama penjual","Biaya transaksi","Saldo\n(tidak termasuk bunga)"]
[null,{"$f":"TODAY()-5","v":"2018-06-24"},"Saldo saat ini",{"v":45,"d":"Rp45.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(tidak termasuk bunga)]])=1,Data[[#This Row],[Biaya transaksi]]+Data[[#This Row],[Jumlah]],SUM(INDEX(Data[Jumlah],1,1):Data[[#This Row],[Jumlah]],INDEX(Data[Biaya transaksi],1,1):Data[[#This Row],[Biaya transaksi]])), \"\")","v":{"v":45,"d":"Rp45.00"}}]
[null,{"$f":"TODAY()-4","v":"2018-06-25"},"Pembayaran bulan Juni",{"v":-34,"d":"-Rp34.00"},"Woodgrove Bank",{"v":2,"d":"Rp2.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(tidak termasuk bunga)]])=1,Data[[#This Row],[Biaya transaksi]]+Data[[#This Row],[Jumlah]],SUM(INDEX(Data[Jumlah],1,1):Data[[#This Row],[Jumlah]],INDEX(Data[Biaya transaksi],1,1):Data[[#This Row],[Biaya transaksi]])), \"\")","v":{"v":13,"d":"Rp13.00"}}]
[null,{"$f":"TODAY()-3","v":"2018-06-26"},"Bingkai foto",{"v":45,"d":"Rp45.00"},"Northwind Traders",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(tidak termasuk bunga)]])=1,Data[[#This Row],[Biaya transaksi]]+Data[[#This Row],[Jumlah]],SUM(INDEX(Data[Jumlah],1,1):Data[[#This Row],[Jumlah]],INDEX(Data[Biaya transaksi],1,1):Data[[#This Row],[Biaya transaksi]])), \"\")","v":{"v":58,"d":"Rp58.00"}}]
[null,{"$f":"TODAY()-2","v":"2018-06-27"},"Anggur",{"v":600,"d":"Rp600.00"},"Coho Winery",{"v":20,"d":"Rp20.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(tidak termasuk bunga)]])=1,Data[[#This Row],[Biaya transaksi]]+Data[[#This Row],[Jumlah]],SUM(INDEX(Data[Jumlah],1,1):Data[[#This Row],[Jumlah]],INDEX(Data[Biaya transaksi],1,1):Data[[#This Row],[Biaya transaksi]])), \"\")","v":{"v":678,"d":"Rp678.00"}}]
[null,{"$f":"TODAY()-1","v":"2018-06-28"},"Tiket ke Maui",{"v":469,"d":"Rp469.00"},"Blue Yonder Airlines",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(tidak termasuk bunga)]])=1,Data[[#This Row],[Biaya transaksi]]+Data[[#This Row],[Jumlah]],SUM(INDEX(Data[Jumlah],1,1):Data[[#This Row],[Jumlah]],INDEX(Data[Biaya transaksi],1,1):Data[[#This Row],[Biaya transaksi]])), \"\")","v":{"v":1147,"d":"Rp1,147.00"}}]
[null,{"$f":"TODAY()","v":"2018-06-29"},"Penarikan",{"v":654,"d":"Rp654.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(tidak termasuk bunga)]])=1,Data[[#This Row],[Biaya transaksi]]+Data[[#This Row],[Jumlah]],SUM(INDEX(Data[Jumlah],1,1):Data[[#This Row],[Jumlah]],INDEX(Data[Biaya transaksi],1,1):Data[[#This Row],[Biaya transaksi]])), \"\")","v":{"v":1801,"d":"Rp1,801.00"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Data[Jumlah])","v":{"v":1779,"d":"Rp1,779.00"}},null,{"$f":"SUBTOTAL(109,Data[Biaya transaksi])","v":{"v":22,"d":"Rp22.00"}}]