{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Daftar Siswa","Daftar Anggota Kelas","Detail Siswa"],"not_rendered":{"images":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Daftar Siswa","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[1,2,2,3],[1,4,1,11],[2,4,2,11],[6,12,8,16]]}
[]
[null,null,"Daftar Siswa",null,"KE DAFTAR ANGGOTA"]
[{"$nulls":4},"KE DETAIL SISWA"]
[null,null,"NAMA SISWA","EMAIL","TELEPON RUMAH","PONSEL","TANGGAL LAHIR","KONTAK DARURAT","NOMOR TELEPON DARURAT","DOKTER","NOMOR TELEPON DOKTER","  "]
[null,null,"Nama 1","Alamat email","Telepon rumah","Ponsel","Tanggal","Kontak 1","Nomor telepon darurat","Dokter 1","Nomor telepon dokter"]
[null,null,"Nama 2","Alamat email","Telepon rumah","Ponsel","Tanggal","Kontak 2","Nomor telepon darurat","Dokter 2","Nomor telepon dokter"]
[null,null,"Nama 3","Alamat email","Telepon rumah","Ponsel","Tanggal","Kontak 3","Nomor telepon darurat","Dokter 3","Nomor telepon dokter",null,"Tips:Untuk menambahkan lebih banyak siswa, pada sel terakhir dalam tabel, tekan tombol tab."]
[null,null,"Nama 4","Alamat email","Telepon rumah","Ponsel","Tanggal","Kontak 4","Nomor telepon darurat","Dokter 4","Nomor telepon dokter"]

{"sheet":"Daftar Anggota Kelas","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[1,2,2,2],[1,3,2,3],[1,4,1,6],[2,4,2,6]]}
[]
[null,null,"Daftar Anggota Kelas","Institut Desain Grafis","KE DAFTAR SISWA"]
[{"$nulls":4},"KE DETAIL SISWA"]
[null,null,"MATA KULIAH","Nama mata kuliah","TANGGAL MULAI","Tanggal"]
[null,null,"PENGAJAR","Pengajar 1","TANGGAL BERAKHIR","Tanggal"]
[null,null,"SISWA YANG MENDAFTAR",{"$f":"COUNTA(DaftarAnggotaSiswa[NAMA SISWA])","v":4}]
[]
[null,null,"NAMA SISWA","EMAIL","TELEPON RUMAH","PONSEL","  "]
[null,null,"Nama 1",{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],2),\"\")","v":"Alamat email"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],3),\"\")","v":"Telepon rumah"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],4),\"\")","v":"Ponsel"}]
[null,null,"Nama 2",{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],2),\"\")","v":"Alamat email"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],3),\"\")","v":"Telepon rumah"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],4),\"\")","v":"Ponsel"}]
[null,null,"Nama 3",{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],2),\"\")","v":"Alamat email"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],3),\"\")","v":"Telepon rumah"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],4),\"\")","v":"Ponsel"}]
[null,null,"Nama 4",{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],2),\"\")","v":"Alamat email"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],3),\"\")","v":"Telepon rumah"},{"$f":"IFERROR(VLOOKUP(DaftarAnggotaSiswa[[#This Row],[NAMA SISWA]],Siswa[],4),\"\")","v":"Ponsel"}]

{"sheet":"Detail Siswa","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[1,2,2,2],[1,3,1,4],[2,3,2,4],[3,2,3,3]]}
[]
[null,null,"Detail Siswa","KE DAFTAR SISWA"]
[{"$nulls":3},"KE DAFTAR ANGGOTA"]
[null,null,"TIPS: PILIH SISWA DARI DAFTAR MENURUN DALAM SEL D5 UNTUK MEMPERBARUI DETAIL SISWA"]
[null,null,"NAMA SISWA","Nama 1"]
[null,null,"EMAIL",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],2,FALSE),\"\")","v":"Alamat email"}]
[null,null,"TELEPON RUMAH",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],3,FALSE),\"\")","v":"Telepon rumah"}]
[null,null,"PONSEL",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],4,FALSE),\"\")","v":"Ponsel"}]
[null,null,"TANGGAL LAHIR",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],5,FALSE),\"\")","v":"Tanggal"}]
[null,null,"KONTAK DARURAT",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],6,FALSE),\"\")","v":"Kontak 1"}]
[null,null,"NOMOR TELEPON DARURAT",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],7,FALSE),\"\")","v":"Nomor telepon darurat"}]
[null,null,"DOKTER",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],8,FALSE),\"\")","v":"Dokter 1"}]
[null,null,"NOMOR TELEPON DOKTER",{"$f":"IFERROR(VLOOKUP(NamaSiswa,Siswa[],9,FALSE),\"\")","v":"Nomor telepon dokter"}]