{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Ringkasan Anggaran","Penghasilan Bulanan","Pengeluaran Bulanan","Pengeluaran Semester"],"not_rendered":{"charts":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Ringkasan Anggaran","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,4,9,4],[3,1,3,2]]}
[null,"anggaran kuliah saya"]
[null,"persentase penghasilan yang dikeluarkan",null,null,"Bagan kolom tergugus yang membandingkan Penghasilan dan Pengeluaran Bulanan ada dalam sel ini."]
[null,{"$f":"PengeluaranBersihBulanan/PenghasilanBersihBulanan","v":{"v":0.6436363636363637,"d":"64%"}}]
[null,{"$f":"PengeluaranBersihBulanan","v":1770}]
[null,"penghasilan bulanan bersih"]
[null,{"$f":"Total_PenghasilanBulanan","v":{"v":2750,"d":"Rp2,750"}}]
[null,"pengeluaran bulanan bersih"]
[null,{"$f":"Total_PengeluaranBulanan+Total_PengeluaranSemester","v":{"v":1770,"d":"Rp1,770"}}]
[null,"saldo"]
[null,{"$f":"PenghasilanBersihBulanan-PengeluaranBersihBulanan","v":{"v":980,"d":"Rp980"}}]

{"sheet":"Penghasilan Bulanan","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[0,1,0,4]]}
[null,{"$f":"Judul_Buku_Kerja","v":"anggaran kuliah saya"}]
[null,"penghasilan bulanan"]
[null,"Item","Jumlah"]
[null,"Penghasilan tetap",{"v":1500,"d":"Rp1,500"}]
[null,"Bantuan keuangan",{"v":500,"d":"Rp500"}]
[null,"Pinjaman",{"v":500,"d":"Rp500"}]
[null,"Penghasilan lain",{"v":250,"d":"Rp250"}]
[null,"Total",{"$f":"SUBTOTAL(109,PenghasilanBulanan[Jumlah])","v":{"v":2750,"d":"Rp2,750"}}]

{"sheet":"Pengeluaran Bulanan","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,{"$f":"Judul_Buku_Kerja","v":"anggaran kuliah saya"}]
[null,"pengeluaran bulanan"]
[null,"Item","Jumlah"]
[null,"Sewa",{"v":20,"d":"Rp20"}]
[null,"Kebutuhan Umum",{"v":50,"d":"Rp50"}]
[null,"Ponsel",{"v":75,"d":"Rp75"}]
[null,"Bahan Makanan",{"v":250,"d":"Rp250"}]
[null,"Pengeluaran otomatis",{"v":50,"d":"Rp50"}]
[null,"Pinjaman kuliah",{"v":500,"d":"Rp500"}]
[null,"Kartu kredit",{"v":275,"d":"Rp275"}]
[null,"Asuransi",{"v":125,"d":"Rp125"}]
[null,"Potong rambut",{"v":50,"d":"Rp50"}]
[null,"Hiburan",{"v":0,"d":"Rp0"}]
[null,"Lain-lain",{"v":0,"d":"Rp0"}]
[null,"Total",{"$f":"SUBTOTAL(109,PengeluaranBulanan[Jumlah])","v":{"v":1395,"d":"Rp1,395"}}]

{"sheet":"Pengeluaran Semester","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"merged":[[0,1,0,5],[10,1,10,2]]}
[null,{"$f":"Judul_Buku_Kerja","v":"anggaran kuliah saya"}]
[null,"pengeluaran semester *"]
[null,"Item","Jumlah","Per Bulan"]
[null,"Biaya Kuliah",{"v":750,"d":"Rp750"},{"$f":"IFERROR(PengeluaranSemester[[#This Row],[Jumlah]]/4, \"\")","v":{"v":187.5,"d":"Rp188"}}]
[null,"Biaya laboratorium",{"v":250,"d":"Rp250"},{"$f":"IFERROR(PengeluaranSemester[[#This Row],[Jumlah]]/4, \"\")","v":{"v":62.5,"d":"Rp63"}}]
[null,"Buku",{"v":500,"d":"Rp500"},{"$f":"IFERROR(PengeluaranSemester[[#This Row],[Jumlah]]/4, \"\")","v":{"v":125,"d":"Rp125"}}]
[null,"Deposito",{"v":0,"d":"Rp0"},{"$f":"IFERROR(PengeluaranSemester[[#This Row],[Jumlah]]/4, \"\")","v":{"v":0,"d":"Rp0"}}]
[null,"Transportasi",{"v":0,"d":"Rp0"},{"$f":"IFERROR(PengeluaranSemester[[#This Row],[Jumlah]]/4, \"\")","v":{"v":0,"d":"Rp0"}}]
[null,"Biaya lainnya",{"v":0,"d":"Rp0"},{"$f":"IFERROR(PengeluaranSemester[[#This Row],[Jumlah]]/4, \"\")","v":{"v":0,"d":"Rp0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,PengeluaranSemester[Jumlah])","v":{"v":1500,"d":"Rp1,500"}},{"$f":"SUBTOTAL(109,PengeluaranSemester[Per Bulan])","v":{"v":375,"d":"Rp375"}}]
[null,"* berdasarkan semester 4 bulanan"]