{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Pelacak Uang Pribadi","Ringkasan Bulanan","Data Bagan"],"not_rendered":{"charts":3,"external_links":2,"defined_names":9,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Pelacak Uang Pribadi","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[9,3,9,6],[19,1,20,1],[21,1,23,1]]}
[null,"Pelacak Uang Pribadi"]
[]
[{"$nulls":3},"Ringkasan Uang Tunai"]
[{"$nulls":3},"Rekening","Uang Tunai Awal","Total Pengeluaran","Sisa Uang Tunai"]
[{"$nulls":3},"Koran",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[Rekening],\"=\" &Tabel_Ringkasan_Uang_Tunai[[#This Row],[Rekening]],CashSpent[Jumlah])","v":{"v":428,"d":"428.00"}},{"$f":"Tabel_Ringkasan_Uang_Tunai[[#This Row],[Uang Tunai Awal]]-Tabel_Ringkasan_Uang_Tunai[[#This Row],[Total Pengeluaran]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Tabungan",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[Rekening],\"=\" &Tabel_Ringkasan_Uang_Tunai[[#This Row],[Rekening]],CashSpent[Jumlah])","v":{"v":450,"d":"450.00"}},{"$f":"Tabel_Ringkasan_Uang_Tunai[[#This Row],[Uang Tunai Awal]]-Tabel_Ringkasan_Uang_Tunai[[#This Row],[Total Pengeluaran]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Lainnya",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[Rekening],\"=\" &Tabel_Ringkasan_Uang_Tunai[[#This Row],[Rekening]],CashSpent[Jumlah])","v":{"v":30,"d":"30.00"}},{"$f":"Tabel_Ringkasan_Uang_Tunai[[#This Row],[Uang Tunai Awal]]-Tabel_Ringkasan_Uang_Tunai[[#This Row],[Total Pengeluaran]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Tabel_Ringkasan_Uang_Tunai[Uang Tunai Awal])","v":3700},{"$f":"SUBTOTAL(109,Tabel_Ringkasan_Uang_Tunai[Total Pengeluaran])","v":908},{"$f":"SUBTOTAL(109,Tabel_Ringkasan_Uang_Tunai[Sisa Uang Tunai])","v":2792}]
[]
[]
[{"$nulls":3},"Uang tunai yang telah saya belanjakan"]
[{"$nulls":3},"Tanggal","Deskripsi","Jumlah","Rekening"]
[{"$nulls":3},"2012-01-04","Penarikan ATM",{"v":40,"d":"40.00"},"Koran"]
[{"$nulls":3},"2012-01-05","Makan Siang",{"v":5,"d":"5.00"},"Koran"]
[{"$nulls":3},"2012-01-06","Pembayaran mobil",{"v":230,"d":"230.00"},"Tabungan"]
[{"$nulls":3},"2012-02-03","Pembayaran listrik",{"v":70,"d":"70.00"},"Koran"]
[{"$nulls":3},"2012-02-07","Makan malam",{"v":53,"d":"53.00"},"Koran"]
[{"$nulls":3},"2012-03-01","Penarikan Tunai",{"v":100,"d":"100.00"},"Tabungan"]
[{"$nulls":3},"2012-03-06","Pembayaran mobil",{"v":230,"d":"230.00"},"Koran"]
[null,"Sisa\nUang Tunai:",null,"2012-04-06","Pembayaran listrik",{"v":70,"d":"70.00"},"Tabungan"]
[{"$nulls":3},"2012-04-20","Penarikan ATM",{"v":30,"d":"30.00"},"Koran"]
[null,{"$f":"Tabel_Ringkasan_Uang_Tunai[[#Totals],[Sisa Uang Tunai]]/Tabel_Ringkasan_Uang_Tunai[[#Totals],[Uang Tunai Awal]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-03","Penarikan ATM",{"v":50,"d":"50.00"},"Tabungan"]
[{"$nulls":3},"2012-05-10","Penarikan ATM",{"v":30,"d":"30.00"},"Lainnya"]

{"sheet":"Ringkasan Bulanan","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Ringkasan Bulanan"]
[null,"Ringkasan Rekening"]
{"$rows_empty":13}
[null,"Ringkasan Pengeluaran"]
[null,"Details"]
[null,null,"Koran","Tabungan","Lainnya","Total Keseluruhan"]
[null,"Jan",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"Feb",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"Mar",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Pembayaran mobil",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Penarikan Tunai",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"Apr",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"Mei",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Total Keseluruhan",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]

{"sheet":"Data Bagan","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Data PivotChart"]
[null,"PivotTable ini merupakan sumber data untuk PivotChart Ringkasan Rekening di lembar Ringkasan Bulanan"]
[null,"Sum of Amount","Label Kolom"]
[null,"Label Baris","Koran","Tabungan","Lainnya","Total Keseluruhan"]
[null,"Jan",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"Feb",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"Mar",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Apr",{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},null,{"v":100,"d":"100.00"}]
[null,"Mei",null,{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Total Keseluruhan",{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]