{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Pendapatan Bulanan","Tabungan Bulanan","Pengeluaran Bulanan","Data Bagan"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Pendapatan Bulanan","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"merged":[[2,1,9,1],[11,1,11,2]]}
[null,"Anggaran"]
[null,"% Pendapatan yang Dihabiskan","Ringkasan"]
[null,"Bagan pai % pendapatan yang dihabiskan. Nilai persen tersedia di sel di bawah ini","Total Pendapatan Bulanan"]
[null,null,{"$f":"SUM(Penghasilan[Jumlah])","v":{"v":3750,"d":"Rp3,750"}}]
[null,null,"Total Pengeluaran Bulanan"]
[null,null,{"$f":"SUM(Pengeluaran[[#All],[Jumlah]])","v":{"v":2058,"d":"Rp2,058"}}]
[null,null,"Total Tabungan Bulanan"]
[null,null,{"$f":"SUM(Tabungan[[#All],[Jumlah]])","v":{"v":550,"d":"Rp550"}}]
[null,null,"Saldo Kas"]
[null,null,{"$f":"Total_Pendapatan_Bulanan-Total_Pengeluaran_Bulanan-Total_Tabungan_Bulanan","v":{"v":1142,"d":"Rp1,142"}}]
[null,{"$f":"MIN(Total_Pengeluaran_Bulanan/Total_Pendapatan_Bulanan,1)","v":{"v":0.5488,"d":"55%"}}]
[null,"Pendapatan Bulanan"]
[null,"Item","Jumlah"]
[null,"Sumber Pendapatan 1",{"v":2500,"d":"Rp2,500.00"}]
[null,"Sumber Pendapatan 2",{"v":1000,"d":"Rp1,000.00"}]
[null,"Lainnya",{"v":250,"d":"Rp250.00"}]

{"sheet":"Tabungan Bulanan","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"JudulAnggaran","v":"Anggaran"}]
[null,"Tabungan Bulanan"]
[null,"Tanggal","Jumlah"]
[null,"Tanggal",{"v":200,"d":"Rp200.00"}]
[null,"Tanggal",{"v":250,"d":"Rp250.00"}]
[null,"Tanggal",{"v":100,"d":"Rp100.00"}]

{"sheet":"Pengeluaran Bulanan","index":2,"n_rows":12,"n_cols":3,"rows_kept":12}
[null,{"$f":"JudulAnggaran","v":"Anggaran"}]
[null,"Pengeluaran Bulanan"]
[null,"Item","Jumlah"]
[null,"Sewa/hipotek",{"v":800,"d":"Rp800.00"}]
[null,"Listrik",{"v":120,"d":"Rp120.00"}]
[null,"Gas",{"v":50,"d":"Rp50.00"}]
[null,"Ponsel",{"v":45,"d":"Rp45.00"}]
[null,"Bahan Makanan",{"v":500,"d":"Rp500.00"}]
[null,"Pembayaran mobil",{"v":273,"d":"Rp273.00"}]
[null,"Kartu kredit",{"v":120,"d":"Rp120.00"}]
[null,"Asuransi kendaraan",{"v":50,"d":"Rp50.00"}]
[null,"Lain-lain",{"v":100,"d":"Rp100.00"}]

{"sheet":"Data Bagan","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[null,"DATA BAGAN"]
[null,{"$f":"MIN(1-B3,1)","v":{"v":0.45120000000000005,"d":"45%"}}]
[null,{"$f":"MIN(Total_Pengeluaran_Bulanan/Total_Pendapatan_Bulanan,1)","v":{"v":0.5488,"d":"55%"}}]
[null,{"$f":"(Total_Pengeluaran_Bulanan/Total_Pendapatan_Bulanan)>1","v":false}]