{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["menu","data","rapot","grafik"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"menu","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"CETAK RAPOT KELAS X"]
[null,null,null,"SMA NEGERI 1 KOTA SERANG"]
[null,null,null,"TAHUN AJARAN 2016-2017"]

{"sheet":"data","index":1,"n_rows":19,"n_cols":26,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[2,0,2,13],[16,0,16,2],[18,0,18,2],[17,0,17,2],[4,11,6,11],[4,12,6,12],[4,13,6,13],[4,0,6,0],[4,1,6,1],[4,2,6,2],[13,0,13,2],[4,3,4,10],[14,0,14,2],[15,0,15,2]]}
["DAFTAR NILAI MID SEMESTER GENAP"]
["SMP NEGERI 1 KOTA SERANG"]
["TAHUN PELAJARAN 2016/2017"]
[]
["NO","NAMA SISWA","KELAS","MATA PELAJARAN",null,null,null,null,null,null,null,"Jumlah","Rata-Rata","Rank. Kelas"]
[null,null,null,"Agama","PKn","Indonesia","IPS","IPA","Inggris","Math","Senbud"]
[null,null,null,76,75,75,75,72,80,71,75]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[1,"ACHMAD FACHRAN RAFLY","7A",90,77.5,100,92.5,96.669998168945313,90,93.330001831054688,80,{"$f":"SUM(D9:K9)","v":720},{"$f":"AVERAGE(D9:K9)","v":90},{"$f":"RANK(L9,$L$9:$L$13,0)","v":1},"NIA KURNIAWATI","NIP. 19640426 198903 2 006",null,{"$f":"IF(D9<D$7,\"TL\",\"L\")","v":"L"},"L","L","L","L","L","L","L",{"$f":"IF(#REF!<#REF!,\"TL\",\"L\")","v":{"$error":"#REF!"}}]
[2,"AIZZI SYAHNEZA ARI","7A",82.5,57.5,82.5,80,56.669998168945313,82.5,76.669998168945313,55,{"$f":"SUM(D10:K10)","v":573.33999633789062},{"$f":"AVERAGE(D10:K10)","v":71.667499542236328},3,"NIA KURNIAWATI","NIP. 19640426 198903 2 006",null,"L","TL","L","L","TL","L","L","TL",{"$f":"IF(#REF!<#REF!,\"TL\",\"L\")","v":{"$error":"#REF!"}}]
[3,"ALYA MAULIDYA JUNITA","7A",100,57.5,82.5,65,70,92.5,76.669998168945313,65,{"$f":"SUM(D11:K11)","v":609.16999816894531},{"$f":"AVERAGE(D11:K11)","v":76.146249771118164},2,"NIA KURNIAWATI","NIP. 19640426 198903 2 006",null,"L","TL","L","TL","TL","L","L","TL",{"$f":"IF(#REF!<#REF!,\"TL\",\"L\")","v":{"$error":"#REF!"}}]
[4,"ANNISYA AULIA FITRI","7A",80,65,72.5,70,70,85,60,65,{"$f":"SUM(D12:K12)","v":567.5},{"$f":"AVERAGE(D12:K12)","v":70.9375},5,"NIA KURNIAWATI","NIP. 19640426 198903 2 006",null,"L","TL","TL","TL","TL","L","TL","TL",{"$f":"IF(#REF!<#REF!,\"TL\",\"L\")","v":{"$error":"#REF!"}}]
[5,"BAGUS ANUGRAH","7B",80,65,70,80,60,77.5,70,67.5,{"$f":"SUM(D13:K13)","v":570},{"$f":"AVERAGE(D13:K13)","v":71.25},4,"NIA KURNIAWATI","NIP. 19640426 198903 2 006",null,"L","TL","TL","L","TL","TL","TL","TL",{"$f":"IF(#REF!<#REF!,\"TL\",\"L\")","v":{"$error":"#REF!"}}]
["NILAI RATA-RATA",null,null,{"$f":"AVERAGE(D9:D13)","v":86.5},64.5,81.5,77.5,70.667999267578125,85.5,75.333999633789063,66.5,608.00199890136719,76.000249862670898,{"$error":"#N/A"}]
["NILAI TERTINGGI",null,null,{"$f":"MAX(D9:D13)","v":100},77.5,100,92.5,96.669998168945313,92.5,93.330001831054688,80,720,90,1]
["NILAI TERENDAH",null,null,{"$f":"MIN(D9:D13)","v":80},57.5,70,65,56.669998168945313,77.5,60,55,567.5,70.9375,5]
["JUMLAH LULUS",null,null,{"$f":"COUNTIF(R9:R13,\"L\")","v":5},1,3,3,1,4,3,1,null,null,{"$error":"#N/A"}]
["JUMLAH TIDAK LULUS",null,null,{"$f":"COUNTIF(R9:R13,\"TL\")","v":0},4,2,2,4,1,2,4,null,null,{"$error":"#N/A"}]
["NILAI RATA-RATA",null,null,{"$f":"AVERAGE(D9:D13)","v":86.5},{"$f":"AVERAGE(E9:E13)","v":64.5},81.5,77.5,70.667999267578125,85.5,75.333999633789063,66.5]

{"sheet":"rapot","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,2,4],[15,0,15,3],[16,0,16,3],[0,0,0,4],[1,0,1,4]]}
["LAPORAN HASIL BELAJAR",null,null,null,null,5]
["MID SEMESTER GENAP"]
["TAHUN AJARAN 2016/2017"]
[]
[{"$f":"\"NAMA : \"&VLOOKUP(F1,SISWA,2,TRUE)","v":"NAMA : BAGUS ANUGRAH"},null,null,null,{"$f":"\"KELAS : \"&VLOOKUP(F1,SISWA,3,TRUE)","v":"KELAS : 7B"}]
[]
["NO","MATA PELAJARAN","KKM","NILAI","CATATAN"]
[1,"Pendidikan Agama",76,{"$f":"VLOOKUP(F1,SISWA,4,TRUE)","v":80},{"$f":"IF(D8=C8,\"TUNTAS\",IF(D8>C8,\"TERLAMPAUI\",\"BELUM TUNTAS\"))","v":"TERLAMPAUI"}]
[2,"PKn",75,{"$f":"VLOOKUP(F1,SISWA,5,TRUE)","v":65},{"$f":"IF(D9=C9,\"TUNTAS\",IF(D9>C9,\"TERLAMPAUI\",\"BELUM TUNTAS\"))","v":"BELUM TUNTAS"}]
[3,"Bahasa Indonesia",75,{"$f":"VLOOKUP(F1,SISWA,6,TRUE)","v":70},"BELUM TUNTAS",null,"MULAI","AKHIR"]
[4,"IPS",75,{"$f":"VLOOKUP(F1,SISWA,7,TRUE)","v":80},"TERLAMPAUI",null,1,20]
[5,"IPA",72,{"$f":"VLOOKUP(F1,SISWA,8,TRUE)","v":60},"BELUM TUNTAS"]
[6,"Bahas Inggris",80,{"$f":"VLOOKUP(F1,SISWA,9,TRUE)","v":77.5},"BELUM TUNTAS"]
[7,"Matematika",71,{"$f":"VLOOKUP(F1,SISWA,10,TRUE)","v":70},"BELUM TUNTAS"]
[8,"Seni Budaya",75,{"$f":"VLOOKUP(F1,SISWA,11,TRUE)","v":67.5},"BELUM TUNTAS"]
["JUMLAH",null,null,null,{"$f":"SUM(D8:D15)","v":570}]
["RATA-RATA",null,null,null,{"$f":"AVERAGE(D8:D15)","v":71.25}]
[]
[null,"Mengetahui,",null,null,"Serang, 21 Maret 2016"]
[null,"Orang Tua / Wali Murid",null,null,"Wali Kelas"]
[]
[null,".........................................",null,null,"Siti Daryanti, M. Kom."]
[null,"(Tanda Tangan & Nama Jelas)",null,null,"NIP. 19751106 201001 2 005"]

{"sheet":"grafik","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["DATA NILAI RATA-RATA"]
["UTS 2016"]
[]
["NO.","MAPEL","NILAI"]
[1,"Agama",86.5]
[2,"PKn",64.5]
[3,"Indonesia",81.5]
[4,"IPS",77.5]
[5,"IPA",70.667999267578125]
[6,"Inggris",85.5]
[7,"Math",75.333999633789063]
[8,"Senbud",66.5]