{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DATA SISWA","KKM","REKAP NILAI","RAPOR","HITUNGAN UTS (ABAIKAN)","HITUNGAN UTS (ABAIKAN) (2)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATA SISWA","index":0,"n_rows":72,"n_cols":16,"rows_kept":72,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["PROFIL SEKOLAH",null,null,null,null,null,null,null,null,"made by Chusni Kurniawan"]
[null,"NAMA SATUAN PENDIDIKAN",null,":","MI NURUL ISLAM LABRUK KIDUL",null,null,null,null,"(c.kurniawan@ymail.com)"]
[null,"KEPALA MADRASAH",null,":","SAHRONI,S.Pd.I"]
[null,"KELAS",null,":","IV (EMPAT) A",null,null,null,null,null,null,{"$f":"B4&\" \"&E4","v":"KELAS IV (EMPAT) A"}]
[null,"WALI KELAS",null,":","CHUSNI KURNIAWAN,S.Pd.",null,null,null,null,null,null,{"$f":"B5&\" \"&E4","v":"WALI KELAS IV (EMPAT) A"}]
[null,"SEMESTER",null,":","I (GANJIL)",null,null,null,null,null,{"$f":"B6&\" \"&E6","v":"SEMESTER I (GANJIL)"},{"$f":"E8&\" \"&E6","v":"UJIAN TENGAH SEMESTER I (GANJIL)"},"I (SATU) A","UJIAN SEMESTER","2014/2015","I (GANJIL)"]
[null,"TAHUN PELAJARAN",null,":","2017/2018",null,null,null,null,null,null,{"$f":"B7&\" \"&E7","v":"TAHUN PELAJARAN 2017/2018"},"I (SATU) B","UJIAN TENGAH SEMESTER","2015/2016","II (GENAP)"]
[null,"JUDUL RAPORT",null,":","UJIAN TENGAH SEMESTER",null,null,null,null,null,null,null,"II (DUA) A",null,"2016/2017"]
[null,"Tempat&Tgl PENERIMAAN RAPOR",null,":","Labruk kidul, 31 Oktober 2017",null,null,null,null,null,null,null,"II (DUA) B",null,"2017/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,"III (TIGA) A",null,"2018/2019"]
["NO","NISN","NO.INDUK","NAMA SISWA","NAMA PANGGILAN","TEMPAT LAHIR","TANGGAL LAHIR","NAMA ORTU","PESAN WALI KELAS TERHADAP NILAI (BARIS 1)","PESAN WALI KELAS TERHADAP NILAI (BARIS 2)","rank",null,"III (TIGA) B",null,"2019/2020"]
[1,2,3,4,5,6,7,8,9,10,11,12,"IV (EMPAT) A"]
[1,"0078140536",4331,"ACHMAD FATHIR IZUDDIN","FATHIR","Lumajang","2007-11-09","NURUDDIN",{"$f":"IF(K13>20,\"Jangan malas belajar, lebih giat dalam belajar!\",IF(K13>10,\"Pacu Semangat Belajarmu,& Tingkatkan nilaimu!\",IF(K13>1,\"Pertahankan Nilaimu, jangan lengah belajar!\",\"Jangan Lengah, terus semangat belajar\")))","v":"Pacu Semangat Belajarmu,& Tingkatkan nilaimu!"},"-",{"$f":"VALUE('REKAP NILAI'!AB7)","v":14},{"$f":"F13&\", \"&TEXT(G13,\"dd mmmm yyyy\")","v":"Lumajang, 09 November 2007"},"IV (EMPAT) B"]
[2,"0075656390",4361,"ACHMAD SEPTIAN HAMDANI","DANI","LUMAJANG","2007-09-10","SYAIFUL ARIS",{"$f":"IF(K14>20,\"Jangan malas belajar, lebih giat dalam belajar!\",IF(K14>10,\"Pacu Semangat Belajarmu,& Tingkatkan nilaimu!\",IF(K14>1,\"Pertahankan Nilaimu, jangan lengah belajar!\",\"Jangan Lengah, terus semangat belajar\")))","v":"Pacu Semangat Belajarmu,& Tingkatkan nilaimu!"},"-",{"$f":"VALUE('REKAP NILAI'!AB8)","v":13},{"$f":"F14&\", \"&TEXT(G14,\"dd mmmm yyyy\")","v":"LUMAJANG, 10 September 2007"},"V (LIMA) A"]
[3,"0071796138",4362,"ACHMAD SULAIMAN","SULAIMAN","LUMAJANG","2007-07-26","AGUS SULAIMAN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB9)","v":32},"LUMAJANG, 26 Juli 2007","V (LIMA) B"]
[4,"0084691896",4333,"AININ NAFISA FEBRIYANTI","AININ","Lumajang","2008-02-12","SUBOWO","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB10)","v":9},"Lumajang, 12 Februari 2008","VI (ENAM) A"]
[5,"0075488897",4334,"AISYAH DWI ANDINI","AISYAH","Lumajang","2007-09-30","SAIFUL ANAM","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB11)","v":6},"Lumajang, 30 September 2007","VI (ENAM) B"]
[6,null,4335,"AJENG AGUSTINA KIRANA PUTRI","AJENG","HANAU","2007-07-31","SUKIRNO","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB12)","v":4},"HANAU, 31 Juli 2007"]
[7,"0078831956",4336,"ALVIAN FAIZULHAQQI","VIAN","Lumajang","2007-05-20","MUKHAMAD FAUZI","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB13)","v":21},"Lumajang, 20 Mei 2007"]
[8,"0073667130",4337,"ANGGITA RIZKY YUGA MEISYA","ANGGI","Lumajang","2007-05-31","GALIH DWI APRIYANTO","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB14)","v":2},"Lumajang, 31 Mei 2007"]
[9,"0089321127",4365,"AUFAN AZKAL ABRORI","OVAN","LUMAJANG","2008-05-16","AHMAD AJMAIN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB15)","v":29},"LUMAJANG, 16 Mei 2008"]
[10,"0074492973",4338,"AURA SALSABILA WULAN SARI","RARA","Lumajang","2007-05-18","SAIFUL","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB16)","v":3},"Lumajang, 18 Mei 2007"]
[11,"0071776593",4465,"AZZA PRISHAL DWI PUTRA","AZZA","LUMAJANG","2007-08-14","MOHAMMAD SHOLEH","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB17)","v":28},"LUMAJANG, 14 Agustus 2007"]
[12,"0078989673 ",4366,"BALQIS NAILA AUDIA","BALQIS","LUMAJANG","2007-10-16","SAMSUL HUDA","Jangan Lengah, terus semangat belajar","-",{"$f":"VALUE('REKAP NILAI'!AB18)","v":1},"LUMAJANG, 16 Oktober 2007"]
[13,"0078400392",4367,"BIMA SATRIA DIRGANTARA","BIMA","LUMAJANG","2007-10-18","JOKO SAMBANG","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB19)","v":18},"LUMAJANG, 18 Oktober 2007"]
[14,"0086652599",4339,"DEVI KARUNIA RATNA PUTRI","DEVI","Lumajang","2008-01-28","MUKHAMMAD KHOZIN AS'ARI","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB20)","v":4},"Lumajang, 28 Januari 2008"]
[15,"0089906682",4340,"DEVITA FEBRIANI PUTRI","DEVITA","Lumajang","2008-02-17","BINADI","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB21)","v":7},"Lumajang, 17 Februari 2008"]
[16,"0074569410",4368,"EKA AULIYA` PUTRI","EKA","LUMAJANG","2007-12-07","BASHORI ALWI","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB22)","v":10},"LUMAJANG, 07 Desember 2007"]
[17,"0083684457",4341,"ERSA PUSPITA EKA ROSA LINDA","ERSA","Lumajang","2008-03-01","SOLIKIN","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB23)","v":16},"Lumajang, 01 Maret 2008"]
[18,"0078481731",4369,"FABIYAN TRI BAKTI OKTAFIAN","FABIYAN","LUMAJANG","2007-10-26","FADLOLI","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB24)","v":23},"LUMAJANG, 26 Oktober 2007"]
[19,"0074514146",4370,"FAKHIS GABRIL LIA","FAKHIS","LUMAJANG","2007-05-04","DONI HARIADI","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB25)","v":8},"LUMAJANG, 04 Mei 2007"]
[20,null,4343,"FELISITA APRILIA NUR NIHAYA","FELI","Lumajang","2007-04-24","EDI SISWANTO","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB26)","v":12},"Lumajang, 24 April 2007"]
[21,null,4344,"FIRDA DWI ANDRIANI","FIRDA","LUMAJANG","2007-11-23","MISNATUN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB27)","v":26},"LUMAJANG, 23 November 2007"]
[22,"0073420487",4345,"GALANG MARDHOTILLAH SATOTO","GALANG","Lumajang","2007-07-12","AGUNG SUJUD SATOTO","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB28)","v":19},"Lumajang, 12 Juli 2007"]
[23,"0079870082",4371,"GALIH FAREL PRASETYO","GALIH","LUMAJANG","2007-07-03","MUHAMMAD ARIFIN","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB29)","v":14},"LUMAJANG, 03 Juli 2007"]
[24,"0087636520",4372,"GILANG AKBAR PRASETYO","AKBAR","LUMAJANG","2008-01-09","di akte tidak tercantum","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB30)","v":31},"LUMAJANG, 09 Januari 2008"]
[25,"0054680814",4304,"HADI GUNAWAN","GUNAWAN","LUMAJANG","2005-12-21","LULUT SUPENO","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB31)","v":33},"LUMAJANG, 21 Desember 2005"]
[26,"0073608418 ",4346,"IKA KURNIA WATI AGUSTINA","SENA","Lumajang","2007-08-19","SUPANDI ARIS SUMARGIONO","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB32)","v":20},"Lumajang, 19 Agustus 2007"]
[27,"0073409469",4374,"IYAAD  AFLAKHA RAMZII","AFLAH","LUMAJANG","2007-08-10","ATHO'ILLAH","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB33)","v":17},"LUMAJANG, 10 Agustus 2007"]
[28,"0068258891",4305,"JULI ANDRIYANTO","JULI","LUMAJANG","2006-07-11","SIAMAN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB34)","v":26},"LUMAJANG, 11 Juli 2006"]
[29,null,4530,"M. RIZKY RIDWAN","RIZKI","Lumajang","2007-11-25","ACHMAD SYAIKHU","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB35)","v":30},"Lumajang, 25 November 2007"]
[30,"0076361559",4351,"MOCHAMAD RAFLI DIAN SAPUTRA","RAFLI","Lumajang","2007-07-28","SAMSUL ARIFIN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB36)","v":21},"Lumajang, 28 Juli 2007"]
[31,"0075055640",4354,"MUHAMMAD ALVIN RIDHO","ALVIN","Lumajang","2007-08-13","MACHMUD ALI RIDHO","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB37)","v":11},"Lumajang, 13 Agustus 2007"]
[32,"0073137310",4385,"STANY RAFIDAH RAHMANIA","STANI","LUMAJANG","2007-07-26","SUNARIYADI","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB38)","v":25},"LUMAJANG, 26 Juli 2007"]
[33,"0077336427",4387,"USWATUN KHASANAH","UUS","LUMAJANG","2007-07-17","SATUKAN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB39)","v":24},"LUMAJANG, 17 Juli 2007"]
[34,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB40)","v":33},", 00 Januari 1900"]
[35,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB41)","v":33},", 00 Januari 1900"]
[36,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB42)","v":33},", 00 Januari 1900"]
[37,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB43)","v":33},", 00 Januari 1900"]
[38,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB44)","v":33},", 00 Januari 1900"]
[39,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB45)","v":33},", 00 Januari 1900"]
[40,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB46)","v":33},", 00 Januari 1900"]
[41,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB47)","v":33},", 00 Januari 1900"]
[42,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB48)","v":33},", 00 Januari 1900"]
[43,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB49)","v":33},", 00 Januari 1900"]
[44,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB50)","v":33},", 00 Januari 1900"]
[45,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB51)","v":33},", 00 Januari 1900"]
[46,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB52)","v":33},", 00 Januari 1900"]
[47,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB53)","v":33},", 00 Januari 1900"]
[48,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB54)","v":33},", 00 Januari 1900"]
[49,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB55)","v":33},", 00 Januari 1900"]
[50,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB56)","v":33},", 00 Januari 1900"]
[51,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB57)","v":33},", 00 Januari 1900"]
[52,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[53,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[54,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[55,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[56,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[57,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[58,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[59,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]
[60,null,null,null,null,null,null,null,"Jangan Lengah, terus semangat belajar","-"]

{"sheet":"KKM","index":1,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Pendidikan Agama"]
["a","Alquran Hadits","=",70]
["b","Aqidah Akhlak","=",70]
["c","Fiqih","=",70]
["d","Sejarah Kebudayaan Islam","=",70]
["PPKn",null,"=",70]
["B.Indonesia",null,"=",70]
["B. Arab",null,"=",70]
["Matematika",null,"=",70]
["IPA",null,"=",70]
["IPS",null,"=",70]
["Kertakes",null,"=",75]
["Penjaskes",null,"=",75]
["Muatan Lokal :"]
["a","B. Daerah","=",70]
["b","B. Inggris","=",65]
["c","Aswaja","=",70]
["d","Nahwu-Shorof","=",70]
[]
["Ektrakurikuler"]
["a.","TIK","="]
["b.","Ulangan","="]
["c.",null,"="]
["d.",null,"="]

{"sheet":"REKAP NILAI","index":2,"n_rows":66,"n_cols":33,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,27],[1,0,1,27],[4,0,5,0],[4,1,5,1],[4,27,5,27],[2,15,2,20],[2,21,2,27],[4,24,4,26]]}
[{"$f":"'DATA SISWA'!L6","v":"UJIAN TENGAH SEMESTER I (GANJIL)"}]
[{"$f":"'DATA SISWA'!L7","v":"TAHUN PELAJARAN 2017/2018"}]
["NAMA MADRASAH",null,":",{"$f":"'DATA SISWA'!E2","v":"MI NURUL ISLAM LABRUK KIDUL"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA SISWA'!L4","v":"KELAS IV (EMPAT) A"},null,null,null,null,null,null,null,null,null,null,null,null,null,"TEMPAT LAHIR","TANGGAL LAHIR","ORANG TUA","NO. INDUK"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,null,null,null,25]
["No. Absen","Nama Siswa",{"$f":"KKM!B3","v":"Alquran Hadits"},{"$f":"KKM!B4","v":"Aqidah Akhlak"},{"$f":"KKM!B5","v":"Fiqih"},{"$f":"KKM!B6","v":"Sejarah Kebudayaan Islam"},{"$f":"KKM!A7","v":"PPKn"},{"$f":"KKM!A8","v":"B.Indonesia"},{"$f":"KKM!A9","v":"B. Arab"},{"$f":"KKM!A10","v":"Matematika"},{"$f":"KKM!A11","v":"IPA"},{"$f":"KKM!A12","v":"IPS"},{"$f":"KKM!A13","v":"Kertakes"},{"$f":"KKM!A14","v":"Penjaskes"},{"$f":"KKM!B16","v":"B. Daerah"},{"$f":"KKM!B17","v":"B. Inggris"},{"$f":"KKM!B18","v":"Aswaja"},{"$f":"KKM!B19","v":"Nahwu-Shorof"},{"$f":"KKM!B22","v":"TIK"},{"$f":"KKM!B23","v":"Ulangan"},{"$f":"KKM!B24","v":0},{"$f":"KKM!B25","v":0},"JUMLAH","Rata-rata","ABSENSI",null,null,"Peringkat"]
[null,null,"UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","UTS","S","I","A"]
[1,{"$f":"IF('DATA SISWA'!D13=0,\"\",'DATA SISWA'!D13)","v":"ACHMAD FATHIR IZUDDIN"},65,60,60,55,65,75,65,57,75,70,70,75,36,57,60,60,null,null,null,null,{"$f":"SUM(C7:T7)","v":1005},{"$f":"IF(ISERROR(AVERAGE(C7:T7)),\"\",AVERAGE(C7:T7))","v":62.8125},null,null,null,{"$f":"RANK(W7,$W$7:$W$66)","v":14},null,{"$f":"'[1]DATA SISWA'!D10","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E10","v":"2004-07-14"},{"$f":"'[1]DATA SISWA'!F10","v":"Achmad Kamali Alfan"},{"$f":"'[1]DATA SISWA'!B10","v":4121}]
[2,{"$f":"IF('DATA SISWA'!D14=0,\"\",'DATA SISWA'!D14)","v":"ACHMAD SEPTIAN HAMDANI"},65,68,70,78,65,60,65,46,65,70,70,75,36,36,68,70,null,null,null,null,{"$f":"SUM(C8:T8)","v":1007},{"$f":"IF(ISERROR(AVERAGE(C8:T8)),\"\",AVERAGE(C8:T8))","v":62.9375},null,null,null,{"$f":"RANK(W8,$W$7:$W$66)","v":13},null,{"$f":"'[1]DATA SISWA'!D11","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E11","v":"2003-07-16"},{"$f":"'[1]DATA SISWA'!F11","v":"Imam Nawawi"},{"$f":"'[1]DATA SISWA'!B11","v":4090}]
[3,{"$f":"IF('DATA SISWA'!D15=0,\"\",'DATA SISWA'!D15)","v":"ACHMAD SULAIMAN"},65,30,60,36,65,60,65,35,55,70,70,75,19,15,60,60,null,null,null,null,{"$f":"SUM(C9:T9)","v":840},{"$f":"IF(ISERROR(AVERAGE(C9:T9)),\"\",AVERAGE(C9:T9))","v":52.5},null,null,null,{"$f":"RANK(W9,$W$7:$W$66)","v":32},null,{"$f":"'[1]DATA SISWA'!D12","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E12","v":"2002-07-21"},{"$f":"'[1]DATA SISWA'!F12","v":"Moch. Basuni"},{"$f":"'[1]DATA SISWA'!B12","v":4124}]
[4,{"$f":"IF('DATA SISWA'!D16=0,\"\",'DATA SISWA'!D16)","v":"AININ NAFISA FEBRIYANTI"},85,72,60,56,65,75,70,70,75,70,70,75,36,59,72,70,null,null,null,null,{"$f":"SUM(C10:T10)","v":1080},{"$f":"IF(ISERROR(AVERAGE(C10:T10)),\"\",AVERAGE(C10:T10))","v":67.5},null,null,null,{"$f":"RANK(W10,$W$7:$W$66)","v":9},null,{"$f":"'[1]DATA SISWA'!D13","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E13","v":"2003-04-04"},{"$f":"'[1]DATA SISWA'!F13","v":"Zainul Atim Slamet"},{"$f":"'[1]DATA SISWA'!B13","v":4091}]
[5,{"$f":"IF('DATA SISWA'!D17=0,\"\",'DATA SISWA'!D17)","v":"AISYAH DWI ANDINI"},85,70,70,50,65,75,70,70,75,70,70,75,39,86,70,70,null,null,null,null,1110,69.375,null,null,null,{"$f":"RANK(W11,$W$7:$W$66)","v":6},null,{"$f":"'[1]DATA SISWA'!D14","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E14","v":"2003-07-06"},{"$f":"'[1]DATA SISWA'!F14","v":"Slamet Riyadi"},{"$f":"'[1]DATA SISWA'!B14","v":4092}]
[6,{"$f":"IF('DATA SISWA'!D18=0,\"\",'DATA SISWA'!D18)","v":"AJENG AGUSTINA KIRANA PUTRI"},80,80,70,60,65,75,70,70,75,70,70,75,48,72,80,70,null,null,null,null,1130,70.625,null,null,null,4,null,{"$f":"'[1]DATA SISWA'!D15","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E15","v":"2003-08-12"},{"$f":"'[1]DATA SISWA'!F15","v":"Mochamad Amin"},{"$f":"'[1]DATA SISWA'!B15","v":4093}]
[7,{"$f":"IF('DATA SISWA'!D19=0,\"\",'DATA SISWA'!D19)","v":"ALVIAN FAIZULHAQQI"},65,74,60,58,65,75,65,43,75,70,70,75,26,23,74,60,null,null,null,null,978,61.125,null,null,null,21,null,{"$f":"'[1]DATA SISWA'!D16","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E16","v":"2003-11-13"},{"$f":"'[1]DATA SISWA'!F16","v":"Mukhamad Fauzi"},{"$f":"'[1]DATA SISWA'!B16","v":4136}]
[8,{"$f":"IF('DATA SISWA'!D20=0,\"\",'DATA SISWA'!D20)","v":"ANGGITA RIZKY YUGA MEISYA"},85,90,70,68,65,75,70,70,85,70,70,75,42,56,90,70,null,null,null,null,1151,71.9375,null,null,null,2,null,{"$f":"'[1]DATA SISWA'!D17","v":"Sidoarjo,"},{"$f":"'[1]DATA SISWA'!E17","v":"2003-10-29"},{"$f":"'[1]DATA SISWA'!F17","v":0},{"$f":"'[1]DATA SISWA'!B17","v":4094}]
[9,{"$f":"IF('DATA SISWA'!D21=0,\"\",'DATA SISWA'!D21)","v":"AUFAN AZKAL ABRORI"},65,59,70,50,65,70,65,42,65,65,70,75,10,22,60,60,null,null,null,null,913,57.0625,null,null,null,29,null,{"$f":"'[1]DATA SISWA'!D18","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E18","v":"2003-09-11"},{"$f":"'[1]DATA SISWA'!F18","v":"Samsuhar"},{"$f":"'[1]DATA SISWA'!B18","v":4095}]
[10,{"$f":"IF('DATA SISWA'!D22=0,\"\",'DATA SISWA'!D22)","v":"AURA SALSABILA WULAN SARI"},65,92,70,85,65,70,65,70,85,65,70,75,37,70,85,70,null,null,null,null,1139,71.1875,null,null,null,3,null,{"$f":"'[1]DATA SISWA'!D19","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E19","v":"2003-06-15"},{"$f":"'[1]DATA SISWA'!F19","v":"Wahyudi"},{"$f":"'[1]DATA SISWA'!B19","v":4135}]
[11,{"$f":"IF('DATA SISWA'!D23=0,\"\",'DATA SISWA'!D23)","v":"AZZA PRISHAL DWI PUTRA"},65,53,70,43,65,70,65,44,65,70,75,75,27,24,60,60,null,null,null,null,931,58.1875,null,null,null,28,null,{"$f":"'[1]DATA SISWA'!D20","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E20","v":"2003-10-23"},{"$f":"'[1]DATA SISWA'!F20","v":"Sukadi"},{"$f":"'[1]DATA SISWA'!B20","v":4096}]
[12,{"$f":"IF('DATA SISWA'!D24=0,\"\",'DATA SISWA'!D24)","v":"BALQIS NAILA AUDIA"},85,94,70,82,65,75,70,75,85,70,70,75,52,73,85,70,null,null,null,null,1196,74.75,null,null,null,1,null,{"$f":"'[1]DATA SISWA'!D21","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E21","v":"2003-11-04"},{"$f":"'[1]DATA SISWA'!F21","v":"Zainul Muttaqin"},{"$f":"'[1]DATA SISWA'!B21","v":4097}]
[13,{"$f":"IF('DATA SISWA'!D25=0,\"\",'DATA SISWA'!D25)","v":"BIMA SATRIA DIRGANTARA"},70,70,70,58,65,70,65,50,75,65,75,75,23,30,70,60,null,null,null,null,991,61.9375,null,null,null,18,null,{"$f":"'[1]DATA SISWA'!D22","v":"Kampar"},{"$f":"'[1]DATA SISWA'!E22","v":"2002-11-09"},{"$f":"'[1]DATA SISWA'!F22","v":"Kastin"},{"$f":"'[1]DATA SISWA'!B22","v":4061}]
[14,{"$f":"IF('DATA SISWA'!D26=0,\"\",'DATA SISWA'!D26)","v":"DEVI KARUNIA RATNA PUTRI"},85,80,70,72,65,75,70,70,85,70,70,75,35,63,80,65,null,null,null,null,1130,70.625,null,null,null,4,null,{"$f":"'[1]DATA SISWA'!D23","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E23","v":"2003-05-18"},{"$f":"'[1]DATA SISWA'!F23","v":"Kholiqul Sulton"},{"$f":"'[1]DATA SISWA'!B23","v":4099}]
[15,{"$f":"IF('DATA SISWA'!D27=0,\"\",'DATA SISWA'!D27)","v":"DEVITA FEBRIANI PUTRI"},80,82,70,49,65,70,70,70,85,70,70,75,30,68,82,65,null,null,null,null,1101,68.8125,null,null,null,7,null,{"$f":"'[1]DATA SISWA'!D24","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E24","v":"2003-11-20"},{"$f":"'[1]DATA SISWA'!F24","v":"Ngateno"},{"$f":"'[1]DATA SISWA'!B24","v":4101}]
[16,{"$f":"IF('DATA SISWA'!D28=0,\"\",'DATA SISWA'!D28)","v":"EKA AULIYA` PUTRI"},80,74,70,64,65,60,70,60,65,70,70,75,54,27,74,70,null,null,null,null,1048,65.5,null,null,null,10,null,{"$f":"'[1]DATA SISWA'!D25","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E25","v":"2003-12-02"},{"$f":"'[1]DATA SISWA'!F25","v":"Rahmad Hidayat (Tr)"},{"$f":"'[1]DATA SISWA'!B25","v":4142}]
[17,{"$f":"IF('DATA SISWA'!D29=0,\"\",'DATA SISWA'!D29)","v":"ERSA PUSPITA EKA ROSA LINDA"},80,62,70,61,65,65,70,55,75,70,70,75,35,27,62,60,null,null,null,null,1002,62.625,null,null,null,16,null,{"$f":"'[1]DATA SISWA'!D26","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E26","v":"2003-05-09"},{"$f":"'[1]DATA SISWA'!F26","v":"Nadim"},{"$f":"'[1]DATA SISWA'!B26","v":4102}]
[18,{"$f":"IF('DATA SISWA'!D30=0,\"\",'DATA SISWA'!D30)","v":"FABIYAN TRI BAKTI OKTAFIAN"},65,58,70,40,65,70,65,55,75,65,70,75,27,27,60,70,null,null,null,null,957,59.8125,null,null,null,23,null,{"$f":"'[1]DATA SISWA'!D27","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E27","v":"2003-04-28"},{"$f":"'[1]DATA SISWA'!F27","v":"Abdul Ghofur"},{"$f":"'[1]DATA SISWA'!B27","v":4103}]
[19,{"$f":"IF('DATA SISWA'!D31=0,\"\",'DATA SISWA'!D31)","v":"FAKHIS GABRIL LIA"},70,76,70,78,65,70,75,60,85,70,70,75,35,50,76,70,null,null,null,null,1095,68.4375,null,null,null,8,null,{"$f":"'[1]DATA SISWA'!D28","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E28","v":"2004-03-20"},{"$f":"'[1]DATA SISWA'!F28","v":"Sugiarto"},{"$f":"'[1]DATA SISWA'!B28","v":4125}]
[20,{"$f":"IF('DATA SISWA'!D32=0,\"\",'DATA SISWA'!D32)","v":"FELISITA APRILIA NUR NIHAYA"},65,70,70,40,65,70,70,50,75,70,70,75,35,50,70,70,null,null,null,null,1015,63.4375,null,null,null,12,null,{"$f":"'[1]DATA SISWA'!D29","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E29","v":"2004-02-22"},{"$f":"'[1]DATA SISWA'!F29","v":"Zainul Arifin"},{"$f":"'[1]DATA SISWA'!B29","v":4105}]
[21,{"$f":"IF('DATA SISWA'!D33=0,\"\",'DATA SISWA'!D33)","v":"FIRDA DWI ANDRIANI"},70,50,70,44,65,60,60,45,75,65,70,75,23,44,60,60,null,null,null,null,936,58.5,null,null,null,26,null,{"$f":"'[1]DATA SISWA'!D30","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E30","v":"2003-08-06"},{"$f":"'[1]DATA SISWA'!F30","v":"Amirudin"},{"$f":"'[1]DATA SISWA'!B30","v":4108}]
[22,{"$f":"IF('DATA SISWA'!D34=0,\"\",'DATA SISWA'!D34)","v":"GALANG MARDHOTILLAH SATOTO"},70,64,70,68,65,70,60,43,75,70,70,75,23,43,64,60,null,null,null,null,990,61.875,null,null,null,19,null,{"$f":"'[1]DATA SISWA'!D31","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E31","v":"2002-08-24"},{"$f":"'[1]DATA SISWA'!F31","v":"Sumarno"},{"$f":"'[1]DATA SISWA'!B31","v":4140}]
[23,{"$f":"IF('DATA SISWA'!D35=0,\"\",'DATA SISWA'!D35)","v":"GALIH FAREL PRASETYO"},65,70,70,64,65,75,70,43,70,70,70,75,15,43,70,70,null,null,null,null,1005,62.8125,null,null,null,14,null,{"$f":"'[1]DATA SISWA'!D32","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E32","v":"2002-12-02"},{"$f":"'[1]DATA SISWA'!F32","v":"Mahmud"},{"$f":"'[1]DATA SISWA'!B32","v":4130}]
[24,{"$f":"IF('DATA SISWA'!D36=0,\"\",'DATA SISWA'!D36)","v":"GILANG AKBAR PRASETYO"},65,50,60,43,65,70,60,39,65,70,70,75,19,19,60,60,null,null,null,null,890,55.625,null,null,null,31,null,{"$f":"'[1]DATA SISWA'!D33","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E33","v":"2003-04-29"},{"$f":"'[1]DATA SISWA'!F33","v":"Miftahul Hadi"},{"$f":"'[1]DATA SISWA'!B33","v":4112}]
[25,{"$f":"IF('DATA SISWA'!D37=0,\"\",'DATA SISWA'!D37)","v":"HADI GUNAWAN"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33,null,{"$f":"'[1]DATA SISWA'!D34","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E34","v":"2003-11-16"},{"$f":"'[1]DATA SISWA'!F34","v":"Mohamad Yusuf"},{"$f":"'[1]DATA SISWA'!B34","v":4113}]
[26,{"$f":"IF('DATA SISWA'!D38=0,\"\",'DATA SISWA'!D38)","v":"IKA KURNIA WATI AGUSTINA"},70,61,60,6,65,75,70,70,70,75,70,75,26,66,61,60,null,null,null,null,980,61.25,null,null,null,20,null,{"$f":"'[1]DATA SISWA'!D35","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E35","v":"2004-06-07"},{"$f":"'[1]DATA SISWA'!F35","v":"Timbul"},{"$f":"'[1]DATA SISWA'!B35","v":4114}]
[27,{"$f":"IF('DATA SISWA'!D39=0,\"\",'DATA SISWA'!D39)","v":"IYAAD  AFLAKHA RAMZII"},65,68,60,60,65,70,75,60,70,75,75,75,15,28,68,70,null,null,null,null,999,62.4375,null,null,null,17,null,{"$f":"'[1]DATA SISWA'!D36","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E36","v":"2003-10-08"},{"$f":"'[1]DATA SISWA'!F36","v":"Masduki"},{"$f":"'[1]DATA SISWA'!B36","v":4115}]
[28,{"$f":"IF('DATA SISWA'!D40=0,\"\",'DATA SISWA'!D40)","v":"JULI ANDRIYANTO"},65,53,60,54,65,75,65,37,70,75,70,75,35,17,60,60,null,null,null,null,936,58.5,null,null,null,26,null,{"$f":"'[1]DATA SISWA'!D37","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E37","v":"2004-01-21"},{"$f":"'[1]DATA SISWA'!F37","v":"M. Khamdani Syaifullah"},{"$f":"'[1]DATA SISWA'!B37","v":4116}]
[29,{"$f":"IF('DATA SISWA'!D41=0,\"\",'DATA SISWA'!D41)","v":"M. RIZKY RIDWAN"},65,44,70,26,65,70,70,30,70,65,70,75,29,20,60,70,null,null,null,null,899,56.1875,null,null,null,30,null,{"$f":"'[1]DATA SISWA'!D38","v":"Lumajang"},{"$f":"'[1]DATA SISWA'!E38","v":"2003-09-24"},{"$f":"'[1]DATA SISWA'!F38","v":"Suyanto"},{"$f":"'[1]DATA SISWA'!B38","v":4117}]
[30,{"$f":"IF('DATA SISWA'!D42=0,\"\",'DATA SISWA'!D42)","v":"MOCHAMAD RAFLI DIAN SAPUTRA"},70,69,70,54,65,70,65,43,70,75,70,75,30,23,69,60,null,null,null,null,978,61.125,null,null,null,21]
[31,{"$f":"IF('DATA SISWA'!D43=0,\"\",'DATA SISWA'!D43)","v":"MUHAMMAD ALVIN RIDHO"},85,70,70,68,65,70,65,55,70,70,75,75,35,25,70,60,null,null,null,null,1028,64.25,null,null,null,11]
[32,{"$f":"IF('DATA SISWA'!D44=0,\"\",'DATA SISWA'!D44)","v":"STANY RAFIDAH RAHMANIA"},80,46,60,38,65,70,65,50,70,75,70,75,19,37,60,60,null,null,null,null,940,58.75,null,null,null,25]
[33,{"$f":"IF('DATA SISWA'!D45=0,\"\",'DATA SISWA'!D45)","v":"USWATUN KHASANAH"},65,56,60,52,65,60,70,30,70,65,70,75,26,60,60,60,null,null,null,null,944,59,null,null,null,24]
[34,{"$f":"IF('DATA SISWA'!D46=0,\"\",'DATA SISWA'!D46)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[35,{"$f":"IF('DATA SISWA'!D47=0,\"\",'DATA SISWA'!D47)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33,null,{"$f":"'[1]DATA SISWA'!D39","v":0},{"$f":"'[1]DATA SISWA'!E39","v":"00:00:00"},{"$f":"'[1]DATA SISWA'!F39","v":0},{"$f":"'[1]DATA SISWA'!B39","v":0}]
[36,{"$f":"IF('DATA SISWA'!D48=0,\"\",'DATA SISWA'!D48)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[37,{"$f":"IF('DATA SISWA'!D49=0,\"\",'DATA SISWA'!D49)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[38,{"$f":"IF('DATA SISWA'!D50=0,\"\",'DATA SISWA'!D50)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[39,{"$f":"IF('DATA SISWA'!D51=0,\"\",'DATA SISWA'!D51)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[40,{"$f":"IF('DATA SISWA'!D52=0,\"\",'DATA SISWA'!D52)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[41,{"$f":"IF('DATA SISWA'!D53=0,\"\",'DATA SISWA'!D53)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[42,{"$f":"IF('DATA SISWA'!D54=0,\"\",'DATA SISWA'!D54)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[43,{"$f":"IF('DATA SISWA'!D55=0,\"\",'DATA SISWA'!D55)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C49:T49)","v":0},{"$f":"IF(ISERROR(AVERAGE(C49:T49)),\"\",AVERAGE(C49:T49))","v":""},null,null,null,33]
[44,{"$f":"IF('DATA SISWA'!D56=0,\"\",'DATA SISWA'!D56)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C50:T50)","v":0},{"$f":"IF(ISERROR(AVERAGE(C50:T50)),\"\",AVERAGE(C50:T50))","v":""},null,null,null,33]
[45,{"$f":"IF('DATA SISWA'!D57=0,\"\",'DATA SISWA'!D57)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C51:T51)","v":0},{"$f":"IF(ISERROR(AVERAGE(C51:T51)),\"\",AVERAGE(C51:T51))","v":""},null,null,null,33]
[46,{"$f":"IF('DATA SISWA'!D58=0,\"\",'DATA SISWA'!D58)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[47,{"$f":"IF('DATA SISWA'!D59=0,\"\",'DATA SISWA'!D59)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[48,{"$f":"IF('DATA SISWA'!D60=0,\"\",'DATA SISWA'!D60)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[49,{"$f":"IF('DATA SISWA'!D61=0,\"\",'DATA SISWA'!D61)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[50,{"$f":"IF('DATA SISWA'!D62=0,\"\",'DATA SISWA'!D62)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[51,{"$f":"IF('DATA SISWA'!D63=0,\"\",'DATA SISWA'!D63)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C57:T57)","v":0},{"$f":"IF(ISERROR(AVERAGE(C57:T57)),\"\",AVERAGE(C57:T57))","v":""},null,null,null,33]
[52,{"$f":"IF('DATA SISWA'!D64=0,\"\",'DATA SISWA'!D64)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C58:T58)","v":0},{"$f":"IF(ISERROR(AVERAGE(C58:T58)),\"\",AVERAGE(C58:T58))","v":""},null,null,null,33]
[53,{"$f":"IF('DATA SISWA'!D65=0,\"\",'DATA SISWA'!D65)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C59:T59)","v":0},{"$f":"IF(ISERROR(AVERAGE(C59:T59)),\"\",AVERAGE(C59:T59))","v":""},null,null,null,33]
[54,{"$f":"IF('DATA SISWA'!D66=0,\"\",'DATA SISWA'!D66)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"",null,null,null,33]
[55,{"$f":"IF('DATA SISWA'!D67=0,\"\",'DATA SISWA'!D67)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C61:T61)","v":0},{"$f":"IF(ISERROR(AVERAGE(C61:T61)),\"\",AVERAGE(C61:T61))","v":""},null,null,null,33]
[56,{"$f":"IF('DATA SISWA'!D68=0,\"\",'DATA SISWA'!D68)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C62:T62)","v":0},{"$f":"IF(ISERROR(AVERAGE(C62:T62)),\"\",AVERAGE(C62:T62))","v":""},null,null,null,33]
[57,{"$f":"IF('DATA SISWA'!D69=0,\"\",'DATA SISWA'!D69)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C63:T63)","v":0},{"$f":"IF(ISERROR(AVERAGE(C63:T63)),\"\",AVERAGE(C63:T63))","v":""},null,null,null,33]
[58,{"$f":"IF('DATA SISWA'!D70=0,\"\",'DATA SISWA'!D70)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C64:T64)","v":0},{"$f":"IF(ISERROR(AVERAGE(C64:T64)),\"\",AVERAGE(C64:T64))","v":""},null,null,null,33]
[59,{"$f":"IF('DATA SISWA'!D71=0,\"\",'DATA SISWA'!D71)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C65:T65)","v":0},{"$f":"IF(ISERROR(AVERAGE(C65:T65)),\"\",AVERAGE(C65:T65))","v":""},null,null,null,33]
[60,{"$f":"IF('DATA SISWA'!D72=0,\"\",'DATA SISWA'!D72)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C66:T66)","v":0},{"$f":"IF(ISERROR(AVERAGE(C66:T66)),\"\",AVERAGE(C66:T66))","v":""},null,null,null,33]

{"sheet":"RAPOR","index":3,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[17,6,18,6],[17,8,18,8],[11,4,11,8],[12,4,12,8],[13,4,13,8],[15,4,15,8],[17,7,18,7],[14,4,14,8],[42,5,42,7],[42,0,42,4],[7,0,7,8],[8,0,8,8],[9,0,9,8],[19,1,19,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[17,0,18,0],[17,1,18,4],[46,7,46,8],[47,7,47,8],[43,0,43,4],[43,6,43,7],[9,10,10,10],[20,2,20,4],[21,2,21,4],[22,2,22,4],[38,2,38,4],[32,1,32,4],[37,1,37,4],[11,10,13,10],[23,2,23,4],[39,2,39,4],[40,2,40,4],[41,2,41,4]]}
[]
[]
[]
[]
[]
[]
[]
["DAFTAR NILAI"]
[{"$f":"'DATA SISWA'!L6","v":"UJIAN TENGAH SEMESTER I (GANJIL)"}]
[{"$f":"'DATA SISWA'!L7","v":"TAHUN PELAJARAN 2017/2018"}]
[]
["N a m a",null,null,": ",{"$f":"UPPER(VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,4,0))","v":"MOCHAMAD RAFLI DIAN SAPUTRA"},null,null,null,null,null,30]
["Tempat,Tanggal Lahir",null,null,": ",{"$f":"PROPER(VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,12,0))","v":"Lumajang, 28 Juli 2007"}]
["Nama Orang Tua",null,null,": ",{"$f":"PROPER(VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,8,0))","v":"Samsul Arifin"}]
["Nomor Induk",null,null,": ",{"$f":"VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,3,0)","v":4351}]
["NISN",null,null,": ",{"$f":"IF(VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,2,0)=0,\"-\",VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,2,0))","v":"0076361559"}]
[]
["NO","Mata Pelajaran",null,null,null,"NILAI ","KKM","Predikat","DESKRIPSI"]
[null,null,null,null,null,"UTS"]
["1.","Pendidikan Agama",null,null,null,null,null,{"$f":"IF(F20<G20,\"C\",IF(F20>G20,\"B\",\"\"))","v":""}]
[null,"a.",{"$f":"IF(KKM!B3=0,\"\",KKM!B3)","v":"Alquran Hadits"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,3,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,3,0))","v":70},{"$f":"IF(KKM!D3=\"\",\"\",KKM!D3)","v":70},{"$f":"IF(F21<40,\"D\",IF(F21<G21,\"C\",IF(F21<80,\"B\",\"A\")))","v":"B"},{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H21=\"D\",\"Kurang\",IF(RAPOR!H21=\"C\",\"Cukup\",IF(RAPOR!H21=\"B\",\"Baik\",IF(RAPOR!H21=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C21","v":"ananda RAFLI Baik dalam mengartikan dan memahami isi materi Alquran Hadits"}]
[null,"b.",{"$f":"IF(KKM!B4=0,\"\",KKM!B4)","v":"Aqidah Akhlak"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,5,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,5,0))","v":70},{"$f":"IF(KKM!D4=\"\",\"\",KKM!D4)","v":70},"B",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H22=\"D\",\"Kurang\",IF(RAPOR!H22=\"C\",\"Cukup\",IF(RAPOR!H22=\"B\",\"Baik\",IF(RAPOR!H22=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C22","v":"ananda RAFLI Baik dalam mengartikan dan memahami isi materi Aqidah Akhlak"}]
[null,"c.",{"$f":"IF(KKM!B5=0,\"\",KKM!B5)","v":"Fiqih"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,5,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,5,0))","v":70},{"$f":"IF(KKM!D5=\"\",\"\",KKM!D5)","v":70},"B",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H23=\"D\",\"Kurang\",IF(RAPOR!H23=\"C\",\"Cukup\",IF(RAPOR!H23=\"B\",\"Baik\",IF(RAPOR!H23=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C23","v":"ananda RAFLI Baik dalam mengartikan dan memahami isi materi Fiqih"}]
[null,"d.",{"$f":"IF(KKM!B6=0,\"\",KKM!B6)","v":"Sejarah Kebudayaan Islam"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,6,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,6,0))","v":54},{"$f":"IF(KKM!D6=\"\",\"\",KKM!D6)","v":70},"C",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H24=\"D\",\"Kurang\",IF(RAPOR!H24=\"C\",\"Cukup\",IF(RAPOR!H24=\"B\",\"Baik\",IF(RAPOR!H24=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C24","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi Sejarah Kebudayaan Islam"}]
[2,{"$f":"KKM!A7","v":"PPKn"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,7,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,7,0))","v":65},{"$f":"IF(KKM!D7=\"\",\"\",KKM!D7)","v":70},"C",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H25=\"D\",\"Kurang\",IF(RAPOR!H25=\"C\",\"Cukup\",IF(RAPOR!H25=\"B\",\"Baik\",IF(RAPOR!H25=\"A\",\"Sangat Baik\",\"\")))&\" dalam mengartikan dan memahami isi materi \"&B25)","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi PPKn"}]
[3,{"$f":"KKM!A8","v":"B.Indonesia"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,8,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,8,0))","v":70},{"$f":"IF(KKM!D8=\"\",\"\",KKM!D8)","v":70},"B",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H26=\"D\",\"Kurang\",IF(RAPOR!H26=\"C\",\"Cukup\",IF(RAPOR!H26=\"B\",\"Baik\",IF(RAPOR!H26=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B26","v":"ananda RAFLI Baik dalam mengartikan dan memahami isi materi B.Indonesia"}]
[4,{"$f":"KKM!A9","v":"B. Arab"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,9,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,9,0))","v":65},{"$f":"IF(KKM!D9=\"\",\"\",KKM!D9)","v":70},"C",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H27=\"D\",\"Kurang\",IF(RAPOR!H27=\"C\",\"Cukup\",IF(RAPOR!H27=\"B\",\"Baik\",IF(RAPOR!H27=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B27","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi B. Arab"}]
[5,{"$f":"KKM!A10","v":"Matematika"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,10,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,10,0))","v":43},{"$f":"IF(KKM!D10=\"\",\"\",KKM!D10)","v":70},"C",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H28=\"D\",\"Kurang\",IF(RAPOR!H28=\"C\",\"Cukup\",IF(RAPOR!H28=\"B\",\"Baik\",IF(RAPOR!H28=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B28","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi Matematika"}]
[6,{"$f":"KKM!A11","v":"IPA"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,11,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,11,0))","v":70},{"$f":"IF(KKM!D11=\"\",\"\",KKM!D11)","v":70},"B",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H29=\"D\",\"Kurang\",IF(RAPOR!H29=\"C\",\"Cukup\",IF(RAPOR!H29=\"B\",\"Baik\",IF(RAPOR!H29=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B29","v":"ananda RAFLI Baik dalam mengartikan dan memahami isi materi IPA"}]
[7,{"$f":"KKM!A12","v":"IPS"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,12,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,12,0))","v":75},{"$f":"IF(KKM!D12=\"\",\"\",KKM!D12)","v":70},"B",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H30=\"D\",\"Kurang\",IF(RAPOR!H30=\"C\",\"Cukup\",IF(RAPOR!H30=\"B\",\"Baik\",IF(RAPOR!H30=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B30","v":"ananda RAFLI Baik dalam mengartikan dan memahami isi materi IPS"}]
[8,{"$f":"KKM!A13","v":"Kertakes"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,13,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,13,0))","v":70},{"$f":"IF(KKM!D13=\"\",\"\",KKM!D13)","v":75},"C",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H31=\"D\",\"Kurang\",IF(RAPOR!H31=\"C\",\"Cukup\",IF(RAPOR!H31=\"B\",\"Baik\",IF(RAPOR!H31=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B31","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi Kertakes"}]
[9,{"$f":"KKM!A14","v":"Penjaskes"},null,null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,15,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,15,0))","v":30},{"$f":"IF(KKM!D14=\"\",\"\",KKM!D14)","v":75},"D",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H32=\"D\",\"Kurang\",IF(RAPOR!H32=\"C\",\"Cukup\",IF(RAPOR!H32=\"B\",\"Baik\",IF(RAPOR!H32=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&B32","v":"ananda RAFLI Kurang dalam mengartikan dan memahami isi materi Penjaskes"}]
[10,{"$f":"KKM!A15","v":"Muatan Lokal :"}]
[null,"a.",{"$f":"KKM!B16","v":"B. Daerah"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,15,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,15,0))","v":30},{"$f":"IF(KKM!D16=\"\",\"\",KKM!D16)","v":70},{"$f":"IF(F34<40,\"D\",IF(F34<G34,\"C\",IF(F34<80,\"B\",\"A\")))","v":"D"},{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H34=\"D\",\"Kurang\",IF(RAPOR!H34=\"C\",\"Cukup\",IF(RAPOR!H34=\"B\",\"Baik\",IF(RAPOR!H34=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C34","v":"ananda RAFLI Kurang dalam mengartikan dan memahami isi materi B. Daerah"}]
[null,"b.",{"$f":"KKM!B17","v":"B. Inggris"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,16,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,16,0))","v":23},{"$f":"IF(KKM!D17=\"\",\"\",KKM!D17)","v":65},{"$f":"IF(F35<40,\"D\",IF(F35<G35,\"C\",IF(F35<80,\"B\",\"A\")))","v":"D"},{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H35=\"D\",\"Kurang\",IF(RAPOR!H35=\"C\",\"Cukup\",IF(RAPOR!H35=\"B\",\"Baik\",IF(RAPOR!H35=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C35","v":"ananda RAFLI Kurang dalam mengartikan dan memahami isi materi B. Inggris"}]
[null,"c.",{"$f":"KKM!B18","v":"Aswaja"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,17,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,17,0))","v":69},{"$f":"IF(KKM!D18=\"\",\"\",KKM!D18)","v":70},{"$f":"IF(F36<40,\"D\",IF(F36<G36,\"C\",IF(F36<80,\"B\",\"A\")))","v":"C"},{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H36=\"D\",\"Kurang\",IF(RAPOR!H36=\"C\",\"Cukup\",IF(RAPOR!H36=\"B\",\"Baik\",IF(RAPOR!H36=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C36","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi Aswaja"}]
[null,"d.",{"$f":"KKM!B19","v":"Nahwu-Shorof"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,18,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,18,0))","v":60},{"$f":"IF(KKM!D19=\"\",\"\",KKM!D19)","v":70},{"$f":"IF(F37<40,\"D\",IF(F37<G37,\"C\",IF(F37<80,\"B\",\"A\")))","v":"C"},{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&\" \"&IF(RAPOR!H37=\"D\",\"Kurang\",IF(RAPOR!H37=\"C\",\"Cukup\",IF(RAPOR!H37=\"B\",\"Baik\",IF(RAPOR!H37=\"A\",\"Sangat Baik\",\"\"))))&\" dalam mengartikan dan memahami isi materi \"&C37","v":"ananda RAFLI Cukup dalam mengartikan dan memahami isi materi Nahwu-Shorof"}]
[11,{"$f":"IFERROR([1]Server!B37,\"\")","v":"Ektrakurikuler"},null,null,null,null,null,null,{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&IF(RAPOR!H38=\"D\",\"Kurang\",IF(RAPOR!H38=\"C\",\"Cukup\",IF(RAPOR!H38=\"B\",\"Baik\",IF(RAPOR!H38=\"A\",\"Sangat Baik\",\"\")&\" dalam mengartikan dan memahami isi materi \"&'REKAP NILAI'!C22)))","v":"ananda RAFLI dalam mengartikan dan memahami isi materi 80"}]
[null,{"$f":"IFERROR([1]Server!B38,\"\")","v":"a."},{"$f":"IF(KKM!B22=0,\"\",KKM!B22)","v":"TIK"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,19,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,19,0))","v":""},{"$f":"IF(KKM!D22=\"\",\"\",KKM!D22)","v":""},{"$f":"IF(F39<40,\"D\",IF(F39<G39,\"C\",IF(F39<80,\"B\",\"\")))","v":""},{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&IF(RAPOR!H39=\"D\",\"Kurang\",IF(RAPOR!H39=\"C\",\"Cukup\",IF(RAPOR!H39=\"B\",\"Baik\",IF(RAPOR!H39=\"A\",\"Sangat Baik\",\"\")&\" dalam mengartikan dan memahami isi materi \"&'REKAP NILAI'!C23)))","v":"ananda RAFLI dalam mengartikan dan memahami isi materi 80"}]
[null,{"$f":"IFERROR([1]Server!B39,\"\")","v":"b."},{"$f":"IF(KKM!B23=0,\"\",KKM!B23)","v":"Ulangan"},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,20,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,20,0))","v":""},{"$f":"IF(KKM!D23=\"\",\"\",KKM!D23)","v":""},"",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&IF(RAPOR!H40=\"D\",\"Kurang\",IF(RAPOR!H40=\"C\",\"Cukup\",IF(RAPOR!H40=\"B\",\"Baik\",IF(RAPOR!H40=\"A\",\"Sangat Baik\",\"\")&\" dalam mengartikan dan memahami isi materi \"&'REKAP NILAI'!C24)))","v":"ananda RAFLI dalam mengartikan dan memahami isi materi 65"}]
[null,{"$f":"IFERROR([1]Server!B40,\"\")","v":"c."},{"$f":"IF(KKM!B24=0,\"\",KKM!B24)","v":""},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,21,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,21,0))","v":""},{"$f":"IF(KKM!D24=\"\",\"\",KKM!D24)","v":""},"",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&IF(RAPOR!H41=\"D\",\"Kurang\",IF(RAPOR!H41=\"C\",\"Cukup\",IF(RAPOR!H41=\"B\",\"Baik\",IF(RAPOR!H41=\"A\",\"Sangat Baik\",\"\")&\" dalam mengartikan dan memahami isi materi \"&'REKAP NILAI'!C25)))","v":"ananda RAFLI dalam mengartikan dan memahami isi materi 70"}]
[null,{"$f":"IFERROR([1]Server!B41,\"\")","v":"d."},{"$f":"IF(KKM!B25=0,\"\",KKM!B25)","v":""},null,null,{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,22,0)=0,\"\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,22,0))","v":""},{"$f":"IF(KKM!D25=\"\",\"\",KKM!D25)","v":""},"",{"$f":"\"ananda \"&VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,5,0)&IF(RAPOR!H42=\"D\",\"Kurang\",IF(RAPOR!H42=\"C\",\"Cukup\",IF(RAPOR!H42=\"B\",\"Baik\",IF(RAPOR!H42=\"A\",\"Sangat Baik\",\"\")&\" dalam mengartikan dan memahami isi materi \"&'REKAP NILAI'!C26)))","v":"ananda RAFLI dalam mengartikan dan memahami isi materi 65"}]
[{"$f":"IFERROR([1]Server!B42,\"\")","v":"JUMLAH"},null,null,null,null,{"$f":"VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,23,0)","v":978}]
[{"$f":"[1]Server!B43","v":"RATA-RATA"},null,null,null,null,{"$f":"VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,24,0)","v":61.125},{"$f":"[1]Server!F43","v":"RANGKING :"},null,{"$f":"VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,28,0)","v":21}]
[]
[null,null,"SAKIT",":",{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,25,0)=0,\"-\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,25,0))","v":"-"},null,null,"PESAN WALI KELAS :"]
[null,null,"IJIN",":",{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,26,0)=0,\"-\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,26,0))","v":"-"},null,null,{"$f":"VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,9,0)","v":"Jangan malas belajar, lebih giat dalam belajar!"}]
[null,null,"ALPA",":",{"$f":"IF(VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,27,0)=0,\"-\",VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,27,0))","v":"-"},null,null,{"$f":"VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,10,0)","v":"-"}]
[null,null,null,null,null,null,null,null,{"$f":"UPPER('DATA SISWA'!E9)","v":"LABRUK KIDUL, 31 OKTOBER 2017"}]
["WALI MURID",null,null,null,null,"KEPALA MADRASAH",null,null,{"$f":"'DATA SISWA'!L5","v":"WALI KELAS IV (EMPAT) A"}]
[]
[]
[]
["_______________",null,null,null,null,{"$f":"'DATA SISWA'!E3","v":"SAHRONI,S.Pd.I"},null,null,{"$f":"'DATA SISWA'!E5","v":"CHUSNI KURNIAWAN,S.Pd."}]
["(ttd dan nama terang)"]

{"sheet":"HITUNGAN UTS (ABAIKAN)","index":4,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ROM1",5,{"$f":"D1*B1","v":25},5]
["ROM2",10,{"$f":"D2/10*B2","v":14},14]
[null,null,null,{"$f":"SUM(C1:C2)","v":39}]

{"sheet":"HITUNGAN UTS (ABAIKAN) (2)","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"JML SOAL","JML POIN","POIN SEIMPURNA","MASUKKAN SKOR","MASUKKAN NILAINYA"]
["ROM1",15,1,{"$f":"B2*C2","v":15},5,"UNTUK ROM2"]
["ROM2",5,5,{"$f":"B3*C3","v":25},5]
["ROM3",5,10,50,5,14,1]
[null,null,null,"NILAI",{"$f":"SUM(E2:E4)/SUM(D2:D4)*100","v":16.666666666666664},1,2]
[null,null,null,null,null,7,3]
[null,null,null,null,null,3,4]
[null,null,null,null,null,{"$f":"AVERAGE(H8:H10)","v":13.333333333333334},5,14]
[null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,12]