{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["SEMESTER","SKS","ANGGARAN","PENGELUARAN BULANAN BERSIH","PENGELUARAN SEMESTER","BUKU"],"not_rendered":{"defined_names":21},"read":"whole","date_system":"1900"}

{"sheet":"SEMESTER","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[2,3,2,4]]}
[null,"JADWAL KELAS SAYA"]
[null,"SEMESTER MUSIM GUGUR"]
[null,null,"WAKTU MULAI","JANGKA WAKTU",null,"TAHUN"]
[null,null,"09:00:00",60,"(Dalam Menit)"]
[null,"WAKTU ","SEN","SEL","RAB","KAM","JUM","SAB","MIN"]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A1)-1)*IntervalWaktu,0)","v":"09:00:00"},"Sarapan","Sarapan","Sarapan","Sarapan","Sarapan"]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A2)-1)*IntervalWaktu,0)","v":"10:00:00"},"Bisnis: Kuliah Ged B, R 256"]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A3)-1)*IntervalWaktu,0)","v":"11:00:00"},{"$nulls":3},"Fisika: Lab \nGed J, R 309"]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A4)-1)*IntervalWaktu,0)","v":"12:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A5)-1)*IntervalWaktu,0)","v":"13:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A6)-1)*IntervalWaktu,0)","v":"14:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A7)-1)*IntervalWaktu,0)","v":"15:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A8)-1)*IntervalWaktu,0)","v":"16:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A9)-1)*IntervalWaktu,0)","v":"17:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A10)-1)*IntervalWaktu,0)","v":"18:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A11)-1)*IntervalWaktu,0)","v":"19:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A12)-1)*IntervalWaktu,0)","v":"20:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A13)-1)*IntervalWaktu,0)","v":"21:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A14)-1)*IntervalWaktu,0)","v":"22:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A15)-1)*IntervalWaktu,0)","v":"23:00:00"}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A16)-1)*IntervalWaktu,0)","v":1}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A17)-1)*IntervalWaktu,0)","v":1.0416666666666665}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A18)-1)*IntervalWaktu,0)","v":1.0833333333333335}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A19)-1)*IntervalWaktu,0)","v":1.125}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A20)-1)*IntervalWaktu,0)","v":1.1666666666666665}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A21)-1)*IntervalWaktu,0)","v":1.2083333333333335}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A22)-1)*IntervalWaktu,0)","v":1.25}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A23)-1)*IntervalWaktu,0)","v":1.2916666666666665}]
[null,{"$f":"WaktuMulai+TIME(0,(ROW(A24)-1)*IntervalWaktu,0)","v":1.3333333333333335}]

{"sheet":"SKS","index":1,"n_rows":17,"n_cols":8,"rows_kept":17}
[null,"PERGURUAN TINGGI"]
[null,"PERENCANA SKS"]
[null,"Nama Gelar",{"$f":"Tahun","v":"TAHUN"}]
[null,"KEMAJUAN KESELURUHAN",null,"KEMAJUAN KESELURUHAN"]
[null,{"$f":"AVERAGE(Mata_Kuliah[NILAI])","v":3.5},{"$f":"IFERROR(TEXT(AVERAGEIF(Mata_Kuliah[SELESAI],\"Ya\",Mata_Kuliah[NILAI]),\"0,00\"),\"0,00\")&\" IPK Saat Ini\"","v":"3,50 IPK Saat Ini"},{"$f":"COUNTIF(Mata_Kuliah[SELESAI],\"Ya\")/COUNTA(Mata_Kuliah[NAMA MATA KULIAH])","v":0.6666666666666666},{"$f":"TEXT(COUNTIF(Mata_Kuliah[SELESAI],\"Ya\")/COUNTA(Mata_Kuliah[NAMA MATA KULIAH]),\"0%\")&\" Completed\"","v":"67% Completed"}]
[null,"Catatan: Ringkasan SKS berikut dikumpulkan secara otomatis berdasarkan entri Anda dalam tabel Mata Kuliah di bawah ini"]
[null,"PERSYARATAN","TOTAL SKS","DIPEROLEH","DIPERLUKAN"]
[null,"Mayor Akademik",{"$f":"IF(SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B8,Mata_Kuliah[SKS])=0,\"0\",SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B8,Mata_Kuliah[SKS]))","v":4},{"$f":"SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B8,Mata_Kuliah[SELESAI],\"Ya\")","v":4},{"$f":"SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B8,Mata_Kuliah[SKS])-SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B8,Mata_Kuliah[SELESAI],\"Ya\")","v":0}]
[null,"Minor Akademik",{"$f":"IF(SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B9,Mata_Kuliah[SKS])=0,\"0\",SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B9,Mata_Kuliah[SKS]))","v":3},{"$f":"SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B9,Mata_Kuliah[SELESAI],\"Ya\")","v":0},{"$f":"SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B9,Mata_Kuliah[SKS])-SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B9,Mata_Kuliah[SELESAI],\"Ya\")","v":3}]
[null,"Mata Kuliah Pilihan",{"$f":"IF(SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B10,Mata_Kuliah[SKS])=0,\"0\",SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B10,Mata_Kuliah[SKS]))","v":2},{"$f":"SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B10,Mata_Kuliah[SELESAI],\"Ya\")","v":2},{"$f":"SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B10,Mata_Kuliah[SKS])-SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B10,Mata_Kuliah[SELESAI],\"Ya\")","v":0}]
[null,"Mata Kuliah Umum",{"$f":"IF(SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B11,Mata_Kuliah[SKS])=0,\"0\",SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B11,Mata_Kuliah[SKS]))","v":"0"},{"$f":"SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B11,Mata_Kuliah[SELESAI],\"Ya\")","v":0},{"$f":"SUMIF(Mata_Kuliah[PERSYARATAN],SKS!$B11,Mata_Kuliah[SKS])-SUMIFS(Mata_Kuliah[SKS],Mata_Kuliah[PERSYARATAN],SKS!$B11,Mata_Kuliah[SELESAI],\"Ya\")","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,SKS!$C$8:$C$11)","v":9},{"$f":"SUBTOTAL(109,SKS!$D$8:$D$11)","v":6},{"$f":"SUBTOTAL(109,SKS!$E$8:$E$11)","v":3}]
[null,"Mata Kuliah"]
[null,"NAMA MATA KULIAH","# MATA KULIAH","PERSYARATAN","SKS","SELESAI","NILAI","SEMESTER"]
[null,"Mata Kuliah 1","Jumlah","Mayor Akademik",4,"Ya",{"v":4,"d":"4.0"},"Semester 1"]
[null,"Mata Kuliah 2","Jumlah","Minor Akademik",3,"Tidak",null,"Semester 1"]
[null,"Mata Kuliah 3","Jumlah","Mata Kuliah Pilihan",2,"Ya",{"v":3,"d":"3.0"},"Semester 1"]

{"sheet":"ANGGARAN","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[5,1,5,2]]}
[null,{"$f":"KULIAH","v":"PERGURUAN TINGGI"}]
[null,"PENCATAT ANGGARAN"]
[null,"Anggaran Saya",{"$f":"Tahun","v":"TAHUN"}]
[null,"PERSENTASE PENDAPATAN YANG DIHABISKAN"]
[null,{"$f":"PENGELUARAN_BULANAN_BERSIH/PENDAPATAN_BULANAN_BERSIH","v":{"v":0.7454545454545455,"d":"75%"}}]
[null,{"$f":"B5","v":0.7454545454545455}]
[null,"PENDAPATAN BULANAN BERSIH","PENGELUARAN BULANAN BERSIH","SALDO"]
[null,{"$f":"C10","v":{"v":2750000,"d":"Rp2,750,000"}},{"$f":"'PENGELUARAN BULANAN BERSIH'!C4+'PENGELUARAN SEMESTER'!D4","v":{"v":2050000,"d":"Rp2,050,000"}},{"$f":"PENDAPATAN_BULANAN_BERSIH-PENGELUARAN_BULANAN_BERSIH","v":{"v":700000,"d":"Rp700,000"}}]
[null,"Bulan dalam semester",4]
[null,"PENDAPATAN BULANAN",{"$f":"SUM(PendapatanBulanan[JUMLAH])","v":{"v":2750000,"d":"Rp2,750,000"}}]
[null,"ITEM","JUMLAH"]
[null,"Pendapatan tetap",{"v":1500000,"d":"Rp1,500,000"}]
[null,"Bantuan keuangan",{"v":500000,"d":"Rp500,000"}]
[null,"Pinjaman",{"v":500000,"d":"Rp500,000"}]
[null,"Pendapatan lain",{"v":250000,"d":"Rp250,000"}]

{"sheet":"PENGELUARAN BULANAN BERSIH","index":3,"n_rows":15,"n_cols":3,"rows_kept":15}
[null,{"$f":"KULIAH","v":"PERGURUAN TINGGI"}]
[null,"PENCATAT ANGGARAN"]
[null,"Pengeluaran Bulanan",{"$f":"Tahun","v":"TAHUN"}]
[null,"PENGELUARAN BULANAN",{"$f":"SUM(PengeluaranBulanan[JUMLAH])","v":{"v":1675000,"d":"Rp1,675,000"}}]
[null,"ITEM","JUMLAH"]
[null,"Sewa",{"v":300000,"d":"Rp300,000"}]
[null,"Kebutuhan umum",{"v":50000,"d":"Rp50,000"}]
[null,"Ponsel",{"v":75000,"d":"Rp75,000"}]
[null,"Bahan makanan",{"v":250000,"d":"Rp250,000"}]
[null,"Pengeluaran otomatis",{"v":50000,"d":"Rp50,000"}]
[null,"Pinjaman kuliah",{"v":500000,"d":"Rp500,000"}]
[null,"Kartu kredit",{"v":275000,"d":"Rp275,000"}]
[null,"Asuransi",{"v":125000,"d":"Rp125,000"}]
[null,"Hiburan",{"v":50000,"d":"Rp50,000"}]
[null,"Lain-lain",{"v":0,"d":"Rp0"}]

{"sheet":"PENGELUARAN SEMESTER","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
[null,{"$f":"KULIAH","v":"PERGURUAN TINGGI"}]
[null,"PENCATAT ANGGARAN"]
[null,"Pengeluaran Semester",{"$f":"Tahun","v":"TAHUN"}]
[null,"PENGELUARAN SEMESTER (Total/Per bulan)",{"$f":"SUM(PengeluaranSemester[JUMLAH])","v":{"v":1500000,"d":"Rp1,500,000"}},{"$f":"SUM(PengeluaranSemester[PER BULAN])","v":{"v":375000,"d":"Rp375,000"}}]
[null,"ITEM","JUMLAH","PER BULAN"]
[null,"Biaya pendidikan",{"v":750000,"d":"Rp750,000"},{"$f":"PengeluaranSemester[[#This Row],[JUMLAH]]/Bulan_dalam_semester","v":{"v":187500,"d":"Rp187,500"}}]
[null,"Biaya laboratorium",{"v":250000,"d":"Rp250,000"},{"$f":"PengeluaranSemester[[#This Row],[JUMLAH]]/Bulan_dalam_semester","v":{"v":62500,"d":"Rp62,500"}}]
[null,"Buku",{"v":500000,"d":"Rp500,000"},{"$f":"PengeluaranSemester[[#This Row],[JUMLAH]]/Bulan_dalam_semester","v":{"v":125000,"d":"Rp125,000"}}]
[null,"Deposito",{"v":0,"d":"Rp0"},{"$f":"PengeluaranSemester[[#This Row],[JUMLAH]]/Bulan_dalam_semester","v":{"v":0,"d":"Rp0"}}]
[null,"Transportasi",{"v":0,"d":"Rp0"},{"$f":"PengeluaranSemester[[#This Row],[JUMLAH]]/Bulan_dalam_semester","v":{"v":0,"d":"Rp0"}}]
[null,"Biaya lainnya",{"v":0,"d":"Rp0"},{"$f":"PengeluaranSemester[[#This Row],[JUMLAH]]/Bulan_dalam_semester","v":{"v":0,"d":"Rp0"}}]

{"sheet":"BUKU","index":5,"n_rows":7,"n_cols":7,"rows_kept":7}
[null,{"$f":"KULIAH","v":"PERGURUAN TINGGI"}]
[null,"PENCATAT BUKU"]
[null,"Daftar Buku"]
[null,"JUDUL","PENULIS","MATA KULIAH","DIMANA MEMBELINYA?","ISBN","CATATAN"]
[null,"Judul Buku","Penulis","Mata Kuliah","Lokasi","Jumlah"]
[null,"Judul Buku","Penulis","Mata Kuliah","Lokasi","Jumlah"]
[null,"Judul Buku","Penulis","Mata Kuliah","Lokasi","Jumlah"]