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

{"sheet":"CARA MENGGUNAKAN BUKU KERJA INI","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[]
[null,"Gunakan buku nilai ini untuk menghitung nilai ketika semua tugas memiliki kontribusi yang sama pada nilai akhir."]
[null,"Instruksi: Pastikan untuk menyimpan salinan nilai cadangan guna mengantisipasi kondisi darurat."]
[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 (misalnya \"Kuis 1\") dan nilai mulai dari sel H7 dalam lembar kerja BUKU NILAI sejauh yang Anda inginkan ke sebelah kanan. Kolom \"Rata-rata\", \"Nilai Hrf\", \"IPK\", dan \"Kurang\" dihitung secara otomatis, tetapi Anda dapat menimpanya jika ingin. Kolom \"Kurang\" menunjukkan jumlah tugas yang nilainya belum didapatkan oleh siswa."]
[null,"Catatan: Area cetak bersifat dinamis dan tidak akan memperlihatkan area tugas atau tabel nilai. Gunakan perintah Area Cetak pada tab TATA LETAK HALAMAN jika ingin mengubah area pencetakan. "]

{"sheet":"BUKU NILAI","index":1,"n_rows":9,"n_cols":21,"rows_kept":9,"merged":[[1,1,3,3],[1,4,1,6],[2,4,2,6],[3,4,3,6]]}
[]
[null,"Nama Sekolah",null,null,"Tahun/Semester/Tengah Semester",null,null,"Rata-rata",{"v":0,"d":"0.00"},{"v":0.6,"d":"0.60"},0.63,0.67,{"v":0.7,"d":"0.70"},0.73,0.77,{"v":0.8,"d":"0.80"},0.83,0.87,{"v":0.9,"d":"0.90"},0.93,0.97]
[{"$nulls":4},"Kelas/Proyek",null,null,"Nilai Hrf","F","D-","D","D+","C-","C","C+","B-","B","B+","A-","A","A+"]
[{"$nulls":4},"Nama Guru",null,null,"IPK",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[null,"Nama Siswa","ID Siswa","Rata-rata","Nilai","IPK","Kurang","Tugas 1","Tugas 2","Kuis 1","Kuis 2","Ujian 1","Tugas 3","Tugas 4","Kuis 3","Ujian 2","Kolom10","Kolom11","Kolom12","Kolom13","Kolom14"]
[null,"Nama 1",1234,{"$f":"IFERROR(AVERAGE(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers]))),\"\")","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"LOOKUP(Data[[#This Row],[Rata-rata]],NilaiRataRata,NilaiHuruf)","v":"A-"},{"$f":"LOOKUP(Data[[#This Row],[Rata-rata]],NilaiRataRata,NilaiIPK)","v":3.67},{"$f":"IF(COUNTA(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers])))=0,\"\",COUNTA(Data[[#Headers],[Tugas 1]]:INDEX(Data[#Headers],1,COUNTA(Data[#Headers])))-COUNTA(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers]))))","v":11},0.88,0.95,0.92]
[null,"Nama 2",5678,{"$f":"IFERROR(AVERAGE(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers]))),\"\")","v":{"v":0.7133333333333334,"d":"0.71"}},{"$f":"LOOKUP(Data[[#This Row],[Rata-rata]],NilaiRataRata,NilaiHuruf)","v":"C-"},{"$f":"LOOKUP(Data[[#This Row],[Rata-rata]],NilaiRataRata,NilaiIPK)","v":1.67},{"$f":"IF(COUNTA(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers])))=0,\"\",COUNTA(Data[[#Headers],[Tugas 1]]:INDEX(Data[#Headers],1,COUNTA(Data[#Headers])))-COUNTA(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers]))))","v":11},0.75,0.71,0.68]
[null,"Nama 3",9876,{"$f":"IFERROR(AVERAGE(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers]))),\"\")","v":{"v":0.7933333333333333,"d":"0.79"}},{"$f":"LOOKUP(Data[[#This Row],[Rata-rata]],NilaiRataRata,NilaiHuruf)","v":"C+"},{"$f":"LOOKUP(Data[[#This Row],[Rata-rata]],NilaiRataRata,NilaiIPK)","v":2.33},{"$f":"IF(COUNTA(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers])))=0,\"\",COUNTA(Data[[#Headers],[Tugas 1]]:INDEX(Data[#Headers],1,COUNTA(Data[#Headers])))-COUNTA(Data[[#This Row],[Tugas 1]]:INDEX(Data[],ROW(Data[[#This Row],[Tugas 1]])-ROW(Data[[#Headers],[Rata-rata]]),COUNTA(Data[#Headers]))))","v":11},0.72,0.81,0.85]