{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["DATA SISWA","KKM","REKAP NILAI","RAPOR","olahan nilai","HITUNGAN UTS (ABAIKAN)","HITUNGAN UTS (ABAIKAN) (2)"],"not_rendered":{"charts":0,"images":3,"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,":","II (GENAP)",null,null,null,null,null,{"$f":"B6&\" \"&E6","v":"SEMESTER II (GENAP)"},{"$f":"E8&\" \"&E6","v":"UJIAN TENGAH SEMESTER II (GENAP)"},"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, 28 April 2018",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","FATIR","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":"Jangan malas belajar, lebih giat dalam belajar!"},"-",{"$f":"VALUE('REKAP NILAI'!AB7)","v":21},{"$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":"Jangan malas belajar, lebih giat dalam belajar!"},"-",{"$f":"VALUE('REKAP NILAI'!AB8)","v":30},{"$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":33},"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":6},"Lumajang, 12 Februari 2008","VI (ENAM) A"]
[5,"0075488897",4334,"AISYAH DWI ANDINI","ANDIN","Lumajang","2007-09-30","SAIFUL ANAM","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB11)","v":2},"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":7},"HANAU, 31 Juli 2007"]
[7,"0078831956",4336,"ALVIAN FAIZULHAQQI","VIAN","Lumajang","2007-05-20","MUKHAMAD FAUZI","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB13)","v":11},"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":5},"Lumajang, 31 Mei 2007"]
[9,"0089321127",4365,"AUFAN AZKAL ABRORI","OVAN","LUMAJANG","2008-05-16","AHMAD AJMAIN","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB15)","v":18},"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","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB17)","v":20},"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":19},"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","VIVI","Lumajang","2008-02-17","BINADI","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB21)","v":8},"Lumajang, 17 Februari 2008"]
[16,"0074569410",4368,"EKA AULIYA` PUTRI","EKA","LUMAJANG","2007-12-07","BASHORI ALWI","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB22)","v":16},"LUMAJANG, 07 Desember 2007"]
[17,"0083684457",4341,"ERSA PUSPITA EKA ROSA LINDA","ERSA","Lumajang","2008-03-01","SOLIKIN","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB23)","v":23},"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":24},"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":9},"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":27},"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":15},"Lumajang, 12 Juli 2007"]
[23,"0079870082",4371,"GALIH FAREL PRASETYO","GALIH","LUMAJANG","2007-07-03","MUHAMMAD ARIFIN","Pertahankan Nilaimu, jangan lengah belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB29)","v":10},"LUMAJANG, 03 Juli 2007"]
[24,"0087636520",4372,"GILANG AKBAR PRASETYO","AKBAR","LUMAJANG","2008-01-09","-","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB30)","v":31},"LUMAJANG, 09 Januari 2008"]
[25,"0081758949",4634,"INES ARIFANI MAULINA","INES","LUMAJANG","2008-04-04","MOHAMAD BADRI","Pacu Semangat Belajarmu,& Tingkatkan nilaimu!","-",{"$f":"VALUE('REKAP NILAI'!AB31)","v":17},"LUMAJANG, 04 April 2008"]
[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":14},"Lumajang, 19 Agustus 2007"]
[27,"0073409469",4374,"IYAAD  AFLAKHA RAMZII","AFLAH","LUMAJANG","2007-08-10","ATHO'ILLAH","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB33)","v":22},"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":25},"LUMAJANG, 11 Juli 2006"]
[29,null,4530,"M. RIZKY RIDWAN","RIZKY","Lumajang","2007-11-25","ACHMAD SYAIKHU","Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB35)","v":28},"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":29},"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":13},"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":26},"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":32},"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":34},", 00 Januari 1900"]
[35,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB41)","v":34},", 00 Januari 1900"]
[36,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB42)","v":34},", 00 Januari 1900"]
[37,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB43)","v":34},", 00 Januari 1900"]
[38,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB44)","v":34},", 00 Januari 1900"]
[39,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB45)","v":34},", 00 Januari 1900"]
[40,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB46)","v":34},", 00 Januari 1900"]
[41,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB47)","v":34},", 00 Januari 1900"]
[42,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB48)","v":34},", 00 Januari 1900"]
[43,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB49)","v":34},", 00 Januari 1900"]
[44,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB50)","v":34},", 00 Januari 1900"]
[45,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB51)","v":34},", 00 Januari 1900"]
[46,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB52)","v":34},", 00 Januari 1900"]
[47,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB53)","v":34},", 00 Januari 1900"]
[48,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB54)","v":34},", 00 Januari 1900"]
[49,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB55)","v":34},", 00 Januari 1900"]
[50,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB56)","v":34},", 00 Januari 1900"]
[51,null,null,null,null,null,null,null,"Jangan malas belajar, lebih giat dalam belajar!","-",{"$f":"VALUE('REKAP NILAI'!AB57)","v":34},", 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]
["Seni Budaya dan Prakarya",null,"=",75]
["Pend. Jasmani OR & Kesehatan",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":77,"n_cols":33,"rows_kept":77,"cut":false,"hidden":false,"merged":[[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[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 II (GENAP)"}]
[{"$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":"Seni Budaya dan Prakarya"},{"$f":"KKM!A14","v":"Pend. Jasmani OR & Kesehatan"},{"$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"},85,47,80,45,70,75,40,80,70,70,70,80,40,70,63,60,null,null,null,null,{"$f":"SUM(C7:T7)","v":1045},{"$f":"IF(ISERROR(AVERAGE(C7:T7)),\"\",AVERAGE(C7:T7))","v":65.3125},"1",null,null,{"$f":"RANK(W7,$W$7:$W$66)","v":21},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"},60,44,85,43,70,60,40,60,60,60,72.5,80,30,60,71,70,null,null,null,null,{"$f":"SUM(C8:T8)","v":965.5},{"$f":"IF(ISERROR(AVERAGE(C8:T8)),\"\",AVERAGE(C8:T8))","v":60.34375},"2",null,null,{"$f":"RANK(W8,$W$7:$W$66)","v":30},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"},60,25,70,32,70,60,40,55,60,60,80,80,30,70,63,60,null,null,null,null,{"$f":"SUM(C9:T9)","v":915},{"$f":"IF(ISERROR(AVERAGE(C9:T9)),\"\",AVERAGE(C9:T9))","v":57.1875},"5",null,null,{"$f":"RANK(W9,$W$7:$W$66)","v":33},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,65,85,54,70,80,45,86.666666666666671,75,78,80,80,60,70,75,70,null,null,null,null,{"$f":"SUM(C10:T10)","v":1158.6666666666665},{"$f":"IF(ISERROR(AVERAGE(C10:T10)),\"\",AVERAGE(C10:T10))","v":72.416666666666657},null,null,null,{"$f":"RANK(W10,$W$7:$W$66)","v":6},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,95,85,76,70,80,44,83.333333333333329,70,70,76.666666666666671,80,50,70,73,70,null,null,null,null,1178,73.625,"1","1","1",{"$f":"RANK(W11,$W$7:$W$66)","v":2},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"},85,64,85,37,70,80,48,83.333333333333329,75,78,76.666666666666671,80,70,70,83,70,null,null,null,null,1155,72.1875,"2",null,null,7,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"},85,65,85,23,70,75,45,82,70,70,80,80,65,60,77,60,null,null,null,null,1092,68.25,"3",null,"2",11,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"},80,67,85,45,70,75,59,80,75,78,70,80,65,70,90,70,null,null,null,null,1159,72.4375,"1",null,null,5,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"},80,44,85,43,70,70,50,81.666666666666671,70,70,77.333333333333329,80,50,70,63,60,null,null,null,null,1064,66.5,null,null,null,18,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"},85,79,85,50,70,70,55,80,75,78,84.5,83,55,70,88,70,null,null,null,null,1177.5,73.59375,"3",null,"1",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"},75,35,75,47,70,70,56,72.5,70,70,75,80,70,60,63,60,null,null,null,null,1048.5,65.53125,null,null,null,20,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,86,85,76,70,80,77,90,75,78,70,82,60,70,88,70,null,null,null,null,1242,77.625,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"},80,54,85,37,70,70,48,81.666666666666671,70,70,74.333333333333329,83,30,70,73,60,null,null,null,null,1056,66,"3",null,"1",19,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,85,44,70,80,49,80,75,78,75,80,65,70,83,65,null,null,null,null,1164,72.75,"1",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,74,85,48,70,80,50,86.666666666666671,75,78,75,80,30,70,85,65,null,null,null,null,1131.6666666666665,70.729166666666657,null,null,null,8,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"},85,67,75,51,70,60,50,65,70,70,73.5,80,35,70,77,70,null,null,null,null,1068.5,66.78125,null,null,null,16,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"},85,68,77.5,25,70,70,42,80,70,70,70,80,35,60,65,60,null,null,null,null,1027.5,64.21875,null,null,null,23,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"},85,45,77.5,49,70,70,40,62.5,70,70,76,81,20,70,63,70,null,null,null,null,1019,63.6875,null,null,null,24,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"},85,74,85,47,70,70,50,90,70,70,70,80,30,70,79,70,null,null,null,null,1110,69.375,null,null,null,9,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"},85,66,85,37,70,70,44,83.333333333333329,70,70,70,80,45,70,73,70,null,null,null,null,1088.3333333333335,68.020833333333343,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"},85,47,85,30,70,70,36,60,70,70,70,80,35,70,63,60,null,null,null,null,1001,62.5625,null,null,null,27,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"},80,52,80,41,70,70,51,80,70,70,85,80,45,70,67,60,null,null,null,null,1071,66.9375,null,null,null,15,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"},85,51,85,45,70,75,50,80,70,70,90,81,40,70,73,70,null,null,null,null,1105,69.0625,"2",null,"1",10,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"},70,39,75,22,70,70,35,70,70,70,70,80,25,70,63,60,null,null,null,null,959,59.9375,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":"INES ARIFANI MAULINA"},85,48,75,31,70,70,41,85,70,75,75,80,50,70,70,70,null,null,null,null,1065,66.5625,null,null,null,17,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"},85,59,82.5,51,70,75,48,76.666666666666671,70,73,73,80,45,70,64,60,null,null,null,null,1082.1666666666665,67.635416666666657,null,"2","1",14,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"},85,45,80,39,70,70,44,60,70,70,70,80,40,70,71,70,null,null,null,null,1034,64.625,"4",null,"1",22,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"},85,45,75,41,70,75,40,70,70,70,70,85,35,60,63,60,null,null,null,null,1014,63.375,null,null,"1",25,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"},85,44,75,36,70,70,40,60,65,65,70,80,40,60,63,70,null,null,null,null,993,62.0625,"2",null,null,28,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"},75,47,75,30,70,70,36,67.5,70,70,70,80,20,60,72,60,null,null,null,null,972.5,60.78125,"2","1","1",29]
[31,{"$f":"IF('DATA SISWA'!D43=0,\"\",'DATA SISWA'!D43)","v":"MUHAMMAD ALVIN RIDHO"},85,82,80,43,70,70,40,83.333333333333329,70,70,77.5,80,40,60,73,60,null,null,null,null,1083.8333333333335,67.739583333333343,null,null,"2",13]
[32,{"$f":"IF('DATA SISWA'!D44=0,\"\",'DATA SISWA'!D44)","v":"STANY RAFIDAH RAHMANIA"},80,44,80,40,70,70,44,60,70,70,75,80,30,70,63,60,null,null,null,null,1006,62.875,null,null,"4",26]
[33,{"$f":"IF('DATA SISWA'!D45=0,\"\",'DATA SISWA'!D45)","v":"USWATUN KHASANAH"},60,44,75,33,70,70,38,55,65,65,70,80,40,70,63,60,null,null,null,null,958,59.875,"1",null,"1",32]
[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,34]
[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,34,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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
[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,34]
["NILAI TERTINGGI",null,{"$f":"MAX(C7:C39)","v":85},{"$f":"MAX(D7:D39)","v":95},85,76,70,80,77,90,75,78,90,85,70,70,90,70,0,0,0,0,1242,77.625,0,0,0,33]
["NILAI TERENDAH",null,{"$f":"MIN(C7:C39)","v":60},{"$f":"MIN(D7:D39)","v":25},70,22,70,60,35,55,60,60,70,80,20,60,63,60,0,0,0,0,915,57.1875,0,0,0,1]
["JUMLAH",null,{"$f":"SUM(C7:C39)","v":2665},{"$f":"SUM(D7:D39)","v":1891},2667.5,1391,2310,2370,1515,2471.1666666666665,2315,2344,2462,2655,1420,2230,2363,2140,0,0,0,0,35209.666666666664,2200.6041666666665,0,0,0,561]
["RATA-RATA",null,{"$f":"AVERAGE(C7:C39)","v":80.757575757575751},{"$f":"AVERAGE(D7:D39)","v":57.303030303030305},80.833333333333329,42.151515151515149,70,71.818181818181813,45.909090909090907,74.883838383838381,70.151515151515156,71.030303030303031,74.606060606060609,80.454545454545453,43.030303030303031,67.575757575757578,71.606060606060609,64.848484848484844,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1066.9595959595958,66.68497474747474,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},17]
[]
[null,"Mengetahui,",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RAPOR!I49","v":"LABRUK KIDUL, 28 APRIL 2018"}]
[null,"Kepala madrasah",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Wali Kelas \"&'DATA SISWA'!E4","v":"Wali Kelas IV (EMPAT) A"}]
[]
[]
[]
[null,{"$f":"'DATA SISWA'!E3","v":"SAHRONI,S.Pd.I"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'DATA SISWA'!E5","v":"CHUSNI KURNIAWAN,S.Pd."}]

{"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 II (GENAP)"}]
[{"$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":"INES ARIFANI MAULINA"},null,null,null,null,null,25]
["Tempat,Tanggal Lahir",null,null,": ",{"$f":"PROPER(VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,12,0))","v":"Lumajang, 04 April 2008"}]
["Nama Orang Tua",null,null,": ",{"$f":"PROPER(VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,8,0))","v":"Mohamad Badri"}]
["Nomor Induk",null,null,": ",{"$f":"VLOOKUP($K$12,'DATA SISWA'!$A$13:$P$72,3,0)","v":4634}]
["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":"0081758949"}]
[]
["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":85},{"$f":"IF(KKM!D3=\"\",\"\",KKM!D3)","v":70},{"$f":"IF(F21<40,\"D\",IF(F21<G21,\"C\",IF(F21<80,\"B\",\"A\")))","v":"A"},{"$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 INES Sangat 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":75},{"$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 INES 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":75},{"$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 INES 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":31},{"$f":"IF(KKM!D6=\"\",\"\",KKM!D6)","v":70},"D",{"$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 INES Kurang 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":70},{"$f":"IF(KKM!D7=\"\",\"\",KKM!D7)","v":70},"B",{"$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 INES Baik 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 INES 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":41},{"$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 INES 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":85},{"$f":"IF(KKM!D10=\"\",\"\",KKM!D10)","v":70},"A",{"$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 INES Sangat Baik 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 INES 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 INES Baik dalam mengartikan dan memahami isi materi IPS"}]
[8,{"$f":"KKM!A13","v":"Seni Budaya dan Prakarya"},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":75},{"$f":"IF(KKM!D13=\"\",\"\",KKM!D13)","v":75},"B",{"$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 INES Baik dalam mengartikan dan memahami isi materi Seni Budaya dan Prakarya"}]
[9,{"$f":"KKM!A14","v":"Pend. Jasmani OR & Kesehatan"},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,14,0))","v":80},{"$f":"IF(KKM!D14=\"\",\"\",KKM!D14)","v":75},"A",{"$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 INES Sangat Baik dalam mengartikan dan memahami isi materi Pend. Jasmani OR & Kesehatan"}]
[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":50},{"$f":"IF(KKM!D16=\"\",\"\",KKM!D16)","v":70},{"$f":"IF(F34<40,\"D\",IF(F34<G34,\"C\",IF(F34<80,\"B\",\"A\")))","v":"C"},{"$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 INES Cukup 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":70},{"$f":"IF(KKM!D17=\"\",\"\",KKM!D17)","v":65},{"$f":"IF(F35<40,\"D\",IF(F35<G35,\"C\",IF(F35<80,\"B\",\"A\")))","v":"B"},{"$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 INES Baik 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":70},{"$f":"IF(KKM!D18=\"\",\"\",KKM!D18)","v":70},{"$f":"IF(F36<40,\"D\",IF(F36<G36,\"C\",IF(F36<80,\"B\",\"A\")))","v":"B"},{"$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 INES Baik 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":70},{"$f":"IF(KKM!D19=\"\",\"\",KKM!D19)","v":70},{"$f":"IF(F37<40,\"D\",IF(F37<G37,\"C\",IF(F37<80,\"B\",\"A\")))","v":"B"},{"$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 INES Baik 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 INES dalam mengartikan dan memahami isi materi 85"}]
[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 INES dalam mengartikan dan memahami isi materi 85"}]
[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 INES dalam mengartikan dan memahami isi materi 85"}]
[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 INES dalam mengartikan dan memahami isi materi 85"}]
[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 INES dalam mengartikan dan memahami isi materi 85"}]
[{"$f":"IFERROR([1]Server!B42,\"\")","v":"JUMLAH"},null,null,null,null,{"$f":"VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,23,0)","v":1065}]
[{"$f":"[1]Server!B43","v":"RATA-RATA"},null,null,null,null,{"$f":"VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,24,0)","v":66.5625},{"$f":"[1]Server!F43","v":"RANGKING :"},null,{"$f":"VLOOKUP($K$12,'REKAP NILAI'!$A$7:$AB$41,28,0)","v":17}]
[]
[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":"Pacu Semangat Belajarmu,& Tingkatkan nilaimu!"}]
[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, 28 APRIL 2018"}]
["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":"olahan nilai","index":4,"n_rows":65,"n_cols":42,"rows_kept":65,"cut":false,"hidden":false,"merged":[[3,22,3,25],[3,0,4,0],[3,1,4,1],[0,0,0,45],[1,0,1,45],[3,2,3,5],[3,26,3,29],[3,30,3,33],[3,34,3,37],[3,38,3,41],[3,42,3,45],[3,6,3,9],[3,10,3,13],[3,14,3,17],[3,18,3,21]]}
["OLAHAN NILAI"]
[]
[]
["NO","NAMA","QH",null,null,null,"FQ",null,null,null,"PKN",null,null,null,"BID",null,null,null,"MTK",null,null,null,"IPA",null,null,null,"IPS",null,null,null,"SBDP(KTK)",null,null,null,"BIG",null,null,null,"AW"]
[null,null,1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML",1,2,"PTS","JML"]
[1,"ACHMAD FATHIR IZUDDIN",90,null,null,{"$f":"AVERAGE(C6:E6)","v":90},70,90,null,{"$f":"AVERAGE(G6:I6)","v":80},65,null,null,{"$f":"AVERAGE(K6:M6)","v":65},70,80,null,75,80,80,null,80,65,null,null,{"$f":"AVERAGE(W6:Y6)","v":65},65,null,null,{"$f":"AVERAGE(AA6:AC6)","v":65},70,null,null,{"$f":"AVERAGE(AE6:AG6)","v":70},70,null,null,{"$f":"AVERAGE(AI6:AK6)","v":70},63,null,null,{"$f":"AVERAGE(AM6:AO6)","v":63}]
[2,"ACHMAD SEPTIAN HAMDANI",60,null,null,{"$f":"AVERAGE(C7:E7)","v":60},80,90,null,{"$f":"AVERAGE(G7:I7)","v":85},65,null,null,{"$f":"AVERAGE(K7:M7)","v":65},60,null,null,60,50,70,null,60,65,null,null,{"$f":"AVERAGE(W7:Y7)","v":65},65,null,null,{"$f":"AVERAGE(AA7:AC7)","v":65},70,null,75,{"$f":"AVERAGE(AE7:AG7)","v":72.5},60,null,null,{"$f":"AVERAGE(AI7:AK7)","v":60},71,null,null,{"$f":"AVERAGE(AM7:AO7)","v":71}]
[3,"ACHMAD SULAIMAN",60,null,null,60,50,90,null,70,65,null,null,65,60,null,null,60,50,60,null,55,65,null,null,65,65,null,null,65,80,null,80,80,70,null,null,70,63,null,null,63]
[4,"AININ NAFISA FEBRIYANTI",90,null,null,90,80,90,null,85,65,null,null,65,70,80,90,80,80,80,100,86.666666666666671,65,null,null,65,65,null,null,65,80,null,null,80,70,null,null,70,75,null,null,75]
[5,"AISYAH DWI ANDINI",90,null,null,90,80,90,null,85,65,null,null,65,70,80,90,80,80,70,100,83.333333333333329,65,null,null,65,65,null,null,65,70,80,80,76.666666666666671,70,null,null,70,73,null,null,73]
[6,"AJENG AGUSTINA KIRANA PUTRI",90,null,null,90,80,90,null,85,65,null,null,65,70,80,90,80,80,70,100,83.333333333333329,65,null,null,65,65,null,null,65,70,80,80,76.666666666666671,70,null,null,70,83,null,null,83]
[7,"ALVIAN FAIZULHAQQI",90,null,null,90,80,90,null,85,65,null,null,65,70,80,null,75,76,70,100,82,65,null,null,65,65,null,null,65,90,70,null,80,60,null,null,60,77,null,null,77]
[8,"ANGGITA RIZKY YUGA MEISYA",90,null,null,90,80,90,null,85,65,null,null,65,70,80,null,75,90,70,null,80,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,90,null,null,90]
[9,"AUFAN AZKAL ABRORI",90,null,null,90,80,90,null,85,65,null,null,65,70,null,null,70,75,70,100,81.666666666666671,65,null,null,65,65,null,null,65,80,80,72,77.333333333333329,70,null,null,70,63,null,null,63]
[10,"AURA SALSABILA WULAN SARI",90,null,null,90,80,90,null,85,65,null,null,65,70,null,null,70,80,80,null,80,65,null,null,65,65,null,null,65,90,null,79,84.5,70,null,null,70,88,null,null,88]
[11,"AZZA PRISHAL DWI PUTRA",90,null,null,90,60,90,null,75,65,null,null,65,70,null,null,70,75,70,null,72.5,65,null,null,65,65,null,null,65,70,80,75,75,60,null,null,60,63,null,null,63]
[12,"BALQIS NAILA AUDIA",90,null,null,90,80,90,null,85,65,null,null,65,70,80,90,80,90,80,100,90,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,88,null,null,88]
[13,"BIMA SATRIA DIRGANTARA",90,null,null,90,80,90,null,85,65,null,null,65,70,null,null,70,65,80,100,81.666666666666671,65,null,null,65,65,null,null,65,70,80,73,74.333333333333329,70,null,null,70,73,null,null,73]
[14,"DEVI KARUNIA RATNA PUTRI",90,null,null,90,80,90,null,85,65,null,null,65,70,80,90,80,80,80,null,80,65,null,null,65,65,null,null,65,70,80,null,75,70,null,null,70,83,null,null,83]
[15,"DEVITA FEBRIANI PUTRI",90,null,null,90,80,90,null,85,65,null,null,65,70,null,90,80,80,80,100,86.666666666666671,65,null,null,65,65,null,null,65,70,80,null,75,70,null,null,70,85,null,null,85]
[16,"EKA AULIYA` PUTRI",90,null,null,90,60,90,null,75,65,null,null,65,60,null,null,60,50,80,null,65,65,null,null,65,65,null,null,65,70,null,77,73.5,70,null,null,70,77,null,null,77]
[17,"ERSA PUSPITA EKA ROSA LINDA",90,null,null,90,65,90,null,77.5,65,null,null,65,70,null,null,70,80,80,null,80,65,null,null,65,65,null,null,65,70,null,null,70,60,null,null,60,65,null,null,65]
[18,"FABIYAN TRI BAKTI OKTAFIAN",90,null,null,90,65,90,null,77.5,65,null,null,65,70,null,null,70,60,65,null,62.5,65,null,null,65,65,null,null,65,80,null,72,76,70,null,null,70,63,null,null,63]
[19,"FAKHIS GABRIL LIA",90,null,null,90,80,90,null,85,65,null,null,65,70,null,null,70,90,80,100,90,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,79,null,null,79]
[20,"FELISITA APRILIA NUR NIHAYA",90,null,null,90,80,90,null,85,65,null,null,65,70,null,null,70,70,80,100,83.333333333333329,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,73,null,null,73]
[21,"FIRDA DWI ANDRIANI",90,null,null,90,80,90,null,85,65,null,null,65,70,null,null,70,60,60,null,60,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,63,null,null,63]
[22,"GALANG MARDHOTILLAH SATOTO",90,null,null,90,70,90,null,80,65,null,null,65,70,null,null,70,80,80,null,80,65,null,null,65,65,null,null,65,90,80,null,85,70,null,null,70,67,null,null,67]
[23,"GALIH FAREL PRASETYO",90,null,null,90,80,90,null,85,65,null,null,65,70,80,null,75,80,60,100,80,65,null,null,65,65,null,null,65,90,null,null,90,70,null,null,70,73,null,null,73]
[24,"GILANG AKBAR PRASETYO",70,null,null,70,60,90,null,75,65,null,null,65,70,null,null,70,70,70,null,70,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,63,null,null,63]
[25,"INES ARIFANI MAULINA",90,null,null,90,60,90,null,75,65,null,null,65,70,null,null,70,90,80,null,85,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,3,null,null,3]
[26,"IKA KURNIA WATI AGUSTINA",90,null,null,90,75,90,null,82.5,65,null,null,65,70,80,null,75,60,70,100,76.666666666666671,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,64,null,null,64]
[27,"IYAAD  AFLAKHA RAMZII",90,null,null,90,70,90,null,80,65,null,null,65,70,null,null,70,60,60,null,60,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,71,null,null,71]
[28,"JULI ANDRIYANTO",90,null,null,90,60,90,null,75,65,null,null,65,70,80,null,75,60,80,null,70,65,null,null,65,65,null,null,65,70,null,null,70,60,null,null,60,63,null,null,63]
[29,"M. RIZKY RIDWAN",90,null,null,90,60,90,null,75,65,null,null,65,70,null,null,70,60,60,null,60,65,null,null,65,65,null,null,65,70,null,null,70,60,null,null,60,63,null,null,63]
[30,"MOCHAMAD RAFLI DIAN SAPUTRA",75,null,null,75,60,90,null,75,65,null,null,65,70,null,null,70,75,60,null,67.5,65,null,null,65,65,null,null,65,70,null,null,70,60,null,null,60,72,null,null,72]
[31,"MUHAMMAD ALVIN RIDHO",90,null,null,90,70,90,null,80,65,null,null,65,60,80,null,70,80,70,100,83.333333333333329,65,null,null,65,65,null,null,65,80,null,75,77.5,60,null,null,60,73,null,null,73]
[32,"STANY RAFIDAH RAHMANIA",90,null,null,90,70,90,null,80,65,null,null,65,70,null,null,70,60,60,null,60,65,null,null,65,65,null,null,65,70,null,80,75,70,null,null,70,63,null,null,63]
[33,"USWATUN KHASANAH",60,null,null,60,60,90,null,75,65,null,null,65,70,null,null,70,50,60,null,55,65,null,null,65,65,null,null,65,70,null,null,70,70,null,null,70,63,null,null,63]
[null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PR"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"HITUNGAN UTS (ABAIKAN)","index":5,"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":6,"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]