{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["CARA MENGGUNAKAN BUKU KERJA INI","BUKU NILAI"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"CARA MENGGUNAKAN BUKU KERJA INI","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"INSTRUKSI"]
[null,"Gunakan lembar kerja BUKU NILAI untuk menghitung nilai yang setiap tugasnya bernilai sejumlah poin. "]
[null,"Instruksi: Pastikan untuk menyimpan salinan cadangan nilai."]
[null,"1. Isi nama universitas, info kelas, nama mahasiswa, dan ID mahasiswa (opsional).   "]
[null,"2. Sesuaikan tabel Nilai & IPK untuk mencocokkan sistem penilaian umum yang Anda gunakan."]
[null,"3. Isi nama tugas, kuis, atau tes (misalnya, \"Kuis 1\") yang dimulai dari sel H8, beserta bobot poin setiap tugas. "]
[null,"4. Isi skor untuk setiap mahasiswa pada setiap tugas atau tes. Kolom \"Rata-rata\", \"Skor,\" \"Nilai Huruf,\" dan \"IPK\" dihitung secara otomatis, tetapi Anda dapat menggantinya jika ingin. Untuk memberikan poin kredit tambahan, cukup beri lebih banyak poin pada tugas dari poin total yang dimungkinkan untuk tugas tersebut."]
[null,"Gunakan perintah \"Area Cetak\" pada menu Tata Letak Halaman jika Anda ingin mengubah area yang akan dicetak."]
[null,"Skor untuk nilai didasarkan pada skala persentase standar berdasarkan pada total jumlah poin yang ditetapkan di baris 8 dan 9. Sesuaikan setiap tugas atau tes ke poin yang diinginkan, kemudian sesuaikan persen untuk nilai yang sesuai. Ganti sel Skor untuk membuat perubahan secara manual."]
[null,"Masukkan setiap tugas, kuis, atau tes serta bobot poin dalam sel H8 hingga X9."]

{"sheet":"BUKU NILAI","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[1,1,2,6],[3,1,3,6],[4,1,6,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[11,4,11,6],[19,1,19,6],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4]]}
[null,"NAMA UNIVERSITAS ANDA"]
[null,"Nama Dosen"]
[{"$nulls":7},"Skor",{"$f":"I4*TotalPoin","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"Kelas/Proyek",{"$nulls":5},"%",{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.728333333333333,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[null,"Tahun/Semester/Tengah Semester",{"$nulls":5},"Nilai Huruf","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":7},"IPK",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"Nama Tugas atau Tes",null,null,"PR1","PR2","K1"]
[{"$nulls":4},"Total Poin Tersedia",null,null,50,50,100]
[]
[{"$nulls":4},"Total jumlah tugas dan tes:",null,null,{"$f":"COUNTA(H8:X8)","v":3}]
[{"$nulls":4},"Total poin yang mungkin:",null,null,{"$f":"SUM(H9:X9)","v":200}]
[]
[null,"Nama Mahasiswa","ID Mahasiswa","Rata-rata","Skor","Nilai Huruf","IPK","Kolom6","Kolom7","Kolom8","Kolom9","Kolom10","Kolom11","Kolom12","Kolom13","Kolom14","Kolom15","Kolom16","Kolom17","Kolom18","Kolom19","Kolom20","Kolom21","Kolom22"]
[null,"Mahasiswa 1",null,{"$f":"IFERROR(IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]])/TotalPoin),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]))","v":182},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,3),\"\"),0)","v":"A-"},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,4),\"\"),0)","v":3.67},45,45,92]
[null,"Mahasiswa 2",null,{"$f":"IFERROR(IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]])/TotalPoin),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]))","v":200},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,3),\"\"),0)","v":"A+"},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]])/TotalPoin),\"\")","v":""},{"$f":"IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]))","v":""},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]])/TotalPoin),\"\")","v":""},{"$f":"IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]))","v":""},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]])/TotalPoin),\"\")","v":""},{"$f":"IF(COUNT(Nilai[[#This Row],[Kolom6]:[Kolom22]])=0,\"\",SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]))","v":""},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Nilai[[#This Row],[Rata-rata]]<>\"\",HLOOKUP(Nilai[[#This Row],[Rata-rata]]*TotalPoin,TabelNilai,4),\"\"),0)","v":""}]
[]
[null,"Ringkasan Kelas",null,"Rata-rata",null,"Nilai Huruf","IPK","","","","","","","","","","",""]
[null," Rata-rata",null,{"$f":"IFERROR(AVERAGE(Nilai[[#All],[Rata-rata]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*TotalPoin,TabelNilai,3),\"\")","v":"A"},{"$f":"IFERROR(AVERAGE(Nilai[[#All],[IPK]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," Skor Tertinggi",null,{"$f":"IFERROR(MAX(Nilai[[#All],[Rata-rata]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*TotalPoin,TabelNilai,3),\"\")","v":"A+"},{"$f":"IFERROR(MAX(Nilai[[#All],[IPK]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," Skor Terendah",null,{"$f":"IFERROR(MIN(Nilai[[#All],[Rata-rata]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*TotalPoin,TabelNilai,3),\"\")","v":"A-"},{"$f":"IFERROR(MIN(Nilai[[#All],[IPK]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]