{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["CARA MENGGUNAKAN BUKU KERJA INI","BUKU NILAI"],"not_rendered":{"defined_names":5},"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 atau tes yang dimulai dari sel G7, beserta persentase bobot masing-masing (misalnya \"Final\" dan \"50%\"). "]
[null,"4. Isi skor untuk setiap mahasiswa pada setiap tugas atau tes. Kolom \"Skor\", \"Nilai Huruf\", dan \"IPK\" dihitung secara otomatis, tetapi Anda dapat menggantinya jika menginginkannya. Cara nilai dihitung, rata-rata, dan nilai akhir belum lengkap hingga semua skor dimasukkan."]
[null,"Gunakan perintah \"Area Cetak\" pada menu Tata Letak Halaman jika Anda ingin mengubah area yang dicetak."]
[null,"Skor, Nilai Huruf, dan IPK belum valid hingga tes & tugas dimasukkan. "]
[null,"Masukkan setiap tugas atau tes dan persentase nilai total dalam sel G7 HINGGA W8."]

{"sheet":"BUKU NILAI","index":1,"n_rows":20,"n_cols":23,"rows_kept":20,"merged":[[5,1,5,5],[6,1,6,3],[6,4,6,5],[7,1,8,3],[7,4,7,5],[8,4,8,5],[15,1,15,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"NAMA UNIVERSITAS ANDA"]
[]
[{"$nulls":6},"Skor",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"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%"}]
[{"$nulls":6},"Nilai Huruf","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":6},"IPK",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Nama Dosen"]
[null,"Kelas/Proyek",null,null,"Nama Tugas atau Tes"]
[null,"Tahun/Semester/Tengah Semester",null,null,"Persentase (total harus 100%)"]
[{"$nulls":4},{"$f":"\"Persentase total: \"&SUM(G8:W8)*100&\"%\"","v":"Persentase total: 0%"}]
[null,"Nama Mahasiswa","ID Mahasiswa","Skor","Nilai Huruf","IPK","Kolom6","Kolom7","Kolom8","Kolom9","Kolom10","Kolom11","Kolom12","Kolom13","Kolom14","Kolom15","Kolom16","Kolom17","Kolom18","Kolom19","Kolom20","Kolom21","Kolom22"]
[{"$nulls":3},{"$f":"(IF(SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Nilai[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,2),\"\")","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Nilai[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,2),\"\")","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Nilai[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,2),\"\")","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Nilai[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,2),\"\")","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Nilai[[#This Row],[Kolom6]:[Kolom22]]),ROUND(SUMPRODUCT($G$8:$W$8,Nilai[[#This Row],[Kolom6]:[Kolom22]]),2),\"\"))","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,2),\"\")","v":""},{"$f":"IF(Nilai[[#This Row],[Skor]]<>\"\",HLOOKUP(Nilai[[#This Row],[Skor]],TabelNilai,3),\"\")","v":""}]
[]
[null,"Ringkasan Kelas",null,"Skor","Nilai Huruf","IPK","","","","","","","","","","",""]
[null," Rata-rata",null,{"$f":"IFERROR(AVERAGE(Nilai[[#All],[Skor]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,TabelNilai,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(Nilai[[#All],[IPK]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Skor Tertinggi",null,{"$f":"IFERROR(MAX(Nilai[[#All],[Skor]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,TabelNilai,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(Nilai[[#All],[IPK]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Skor Terendah",null,{"$f":"IFERROR(MIN(Nilai[[#All],[Skor]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,TabelNilai,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(Nilai[[#All],[IPK]]),0)","v":0},"","","","","","","","","","","","","","","","",""]