{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["Cara menggunakan templat ini","Senarai Pelajar","September","Oktober","November","Disember","Januari","Februari","Mac","April","Mei","Jun","Julai","Ogos","Laporan Kehadiran Pelajar"],"not_rendered":{"defined_names":31},"read":"whole","date_system":"1900"}

{"sheet":"Cara menggunakan templat ini","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[3,2,3,12],[4,4,4,12],[5,4,5,12],[6,4,6,12],[7,4,7,12],[8,4,8,7],[11,2,11,12],[12,4,12,12],[13,4,13,12],[14,4,14,12],[17,2,17,12],[18,4,18,12],[19,4,19,12],[20,4,20,12],[21,4,21,12],[24,2,24,12]]}
["CARA UNTUK MENGGUNAKAN TEMPLAT INI"]
[]
[null,"DI MANA SAYA BERMULA?"]
[null,null,"Terdapat beberapa langkah yang anda perlu lakukan sebelum anda boleh mula menjejak kehadiran pelajar:"]
[{"$nulls":3},"1.","Tambah pelajar anda: Pada helaian Senarai Pelajar, masukkan setiap maklumat pelajar seperti nama penjaga dan data hubungan. ID Pelajar adalah entri yang penting kerana ia membekalkan pengecam unik bagi setiap pelajar dan digunakan di seluruh buku kerja untuk pelbagai senarai juntai bawah ID Pelajar untuk memudahkan entri data. Maklumat yang dimasukkan pada Senarai Pelajar juga digunakan pada helaian lain seperti Laporan Kehadiran Pelajar dan rekod kehadiran bulanan."]
[{"$nulls":3},"2.","Ubah tahun kalendar persekolahan: Pada helaian untuk kehadiran bulan September, klik kawalan pemutar di pinggir kanan atas pengepala untuk mengemas kini tahun kalendar persekolahan. Perubahan ini akan mengemas kini pengepala pada semua rekod kehadiran bulanan seluruh buku kerja ini. (Ingat butang pemutar tidak muncul dalam cetakan.)"]
[{"$nulls":3},"3.","(Pilihan) Ubah suai warna seluruh buku kerja:  Terlebih dahulu, menavigasi ke helaian terakhir, Laporan Kehadiran Pelajar dan pada tab Semak Semula, dalam kumpulan Perubahan, klik Nyahlindung Helaian. Kemudian, pada tab Tataletak Halaman, dalam kumpulan Tema, klik Warna dan pilih set warna tema lain daripada galeri warna. Selepas anda membuat perubahan warna anda dan sebarang perubahan warna lain, kembali ke helaian Laporan Kehadiran Pelajar dan pada tab Semak Semula, dalam kumpulan Perubahan, klik Lindung Helaian, kemudian klik OK."]
[{"$nulls":4},"Petua: Cipta set warna tema tersuai untuk memadankan warna sekolah anda! Untuk berbuat demikian, pada tab Tataletak Halaman, dalam kumpulan Tema, klik Warna kemudian, berhampiran bahagian bawah galeri warna, klik Cipta Warna Tema Baru. Untuk mengetahui cara lanjut untuk mencipta set warna tersuai, lihat topik Bantuan berikut:"]
[{"$nulls":4},"Suaikan tema dokumen."]
[]
[null,"SAYA TELAH MENAMBAH PELAJAR SAYA, APAKAH YANG SAYA HARUS LAKUKAN SETERUSNYA?"]
[null,null,"Selepas pelajar anda telah dimasukkan dalam helaian Senarai Pelajar, anda boleh mula menjejak kehadiran mereka bagi tahun persekolahan dengan langkah-langkah ini:"]
[{"$nulls":3},"1.","Untuk menambah pelajar dalam rekod kehadiran, klik dalam sel di bawah lajur ID Pelajar dan pilih ID daripada senarai. Nama pelajar akan dipaparkan secara automatik selepas ID dipilih."]
[{"$nulls":4},"Petua: Simpan langkah-langkah entri data! Selepas pelajar anda ditambah untuk satu bulan, pilih ID Pelajar yang dimasukkan, salin ia, kemudian tampal dalam lajur ID Pelajar bagi bulan-bulan seterusnya."]
[{"$nulls":3},"2.","Kemudian masukkan rekod kehadiran mereka untuk setiap hari bagi bulan tersebut dengan jenis kehadiran yang dibekalkan dalam Kunci Warna. Kehadiran pelajar dikira secara automatik oleh jenis kehadiran bagi setiap pelajar dalam lajur Jumlah. Jumlah ketidakhadiran bagi setiap hari dikira secara automatik di bawah jadual dalam baris Jumlah."]
[]
[null,"BAGAIMANA SAYA MENAMBAH LAGI PELAJAR KEPADA REKOD KEHADIRAN BULANAN?"]
[null,null,"Helaian rekod kehadiran bulanan dan Senarai Pelajar adalah jadual Excel. Untuk menambah baris baru kepada sebarang jadual Excel, lakukan salah satu daripada berikut:"]
[{"$nulls":3},"● ","Jika jadual tidak mempunyai baris Jumlah, mula menaip di bawah jadual dan ia akan mengembang secara automatik apabila anda menekan kunci Enter atau Tab."]
[{"$nulls":3},"● ","Letakkan penuding sel anda dalam sel terakhir di atas baris Jumlah, seperti sel Hari Tidak Hadir bagi pelajar terakhir kemudian tekan kunci Tab."]
[{"$nulls":3},"● ","Klik kanan dalam jadual dan pada menu timbul, tuding ke Selitkan, kemudian klik Baris Jadual Atas atau Baris Jadual Bawah."]
[{"$nulls":3},"● ","Di sudut bawah kanan jadual, letakkan tetikus anda pada pemegang pensaizan jadual dan seret turun untuk menambah bilangan baris jadual tersedia."]
[]
[null,"BOLEHKAH SAYA MELIHAT KEHADIRAN PELAJAR BAGI SELURUH TAHUN PERSEKOLAHAN?"]
[null,null,"Helaian terakhir dalam buku kerja ini, Laporan Kehadiran Pelajar, menjejak tahun untuk mentarikhkan kehadiran. Untuk melihat laporan bagi pelajar tertentu, klik dalam sel di bawah ID Pelajar kemudian pilih ID daripada senarai juntai bawah. Maklumat yang anda masukkan sebelumnya pada helaian Senarai Pelajar bagi pelajar terpilih akan dipaparkan secara automatik. Ingat kali pertama anda menggunakan Laporan Kehadiran Pelajar, anda perlu memasukkan Sekolah, Gred, Guru dan Kelas. Butiran maklumat ini tidak akan berubah jika anda memilih pelajar lain."]

{"sheet":"Senarai Pelajar","index":1,"n_rows":8,"n_cols":19,"rows_kept":8}
["SENARAI PELAJAR"]
[]
[null,"ID Pelajar","Nama Pertama Pelajar","Nama Terakhir Pelajar","Jantina","Tarikh Lahir","Ibu bapa atau Penjaga 1","Perhubungan Ibu bapa/Penjaga 1","Telefon Tempat Kerja Ibu bapa/Penjaga 1","Telefon Rumah Ibu bapa/Penjaga 1","Ibu bapa/Penjaga 2","Perhubungan Ibu bapa/Penjaga 2","Telefon Tempat Kerja Ibu bapa/Penjaga 2","Hubungan Kecemasan","Hubungan Kecemasan2","Perhubungan Hubungan Kecemasan","Telefon Tempat Kerja Hubungan Kecemasan","Telefon Rumah Hubungan Kecemasan","Nama Penuh Pelajar"]
[null,"S001","David","Alexander","M","1997-03-28","Michelle","Alexander",1235550134,2345550134,"Michael Alexander","Bapa",1235550134,2345550134,"Reed Koch","Datuk",7895550189,7895550134,"David Alexander"]
[null,"S002","Pelajar",2,{"$nulls":14},"Pelajar 2"]
[null,"S003","Pelajar",3,{"$nulls":14},"Pelajar 3"]
[null,"S004","Pelajar",4,{"$nulls":14},"Pelajar 4"]
[null,"S005","Pelajar",5,{"$nulls":14},"Pelajar 5"]

{"sheet":"September","index":2,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,"KUNCI WARNA","L","Lewat",null,null,"D","Dikecualikan",null,null,"TD","Tidak Dikecualikan",null,null,"H","Hadir",null,null,"TS","Tiada Sekolah"]
[]
[null,{"$f":"DATE(TahunKalendar,9,1)","v":"2012-09-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,1),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,2),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,3),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,4),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,5),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,6),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,7),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,8),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,9),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,10),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,11),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,12),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,13),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,14),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,15),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,16),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,17),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,18),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,19),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,20),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,21),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,22),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,23),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,24),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,25),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,26),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,27),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,28),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,29),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,9,30),1),\"[$-43E]aaa\")","v":"Ahad"},null,"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","TD","D","H","Hari Tidak Hadir"]
[null,"S001",{"$f":"IFERROR(VLOOKUP(KehadiranSeptember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":"David Alexander"},"H","H","L","L","H","TS","TS","H","H","D","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H",null,{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_1)","v":2},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_2)","v":1},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_4)","v":19},{"$f":"SUM(KehadiranSeptember[[#This Row],[TD]:[D]])","v":1}]
[null,"S002",{"$f":"IFERROR(VLOOKUP(KehadiranSeptember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":"Pelajar 2"},"H","TD","H","H","H","TS","TS","H","D","D","D","D","TS","TS","H","H","H","H","H","TS","TS","H","H","H","L","L","TS","TS","H","H",null,{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_1)","v":2},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_2)","v":4},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_3)","v":1},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_4)","v":15},{"$f":"SUM(KehadiranSeptember[[#This Row],[TD]:[D]])","v":5}]
[null,"S003",{"$f":"IFERROR(VLOOKUP(KehadiranSeptember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":"Pelajar 3"},"H","D","H","H","H","TS","TS","H","H","TD","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H","D","D","H","TS","TS","H","H",null,{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_2)","v":3},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_3)","v":1},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_4)","v":18},{"$f":"SUM(KehadiranSeptember[[#This Row],[TD]:[D]])","v":4}]
[null,"S004",{"$f":"IFERROR(VLOOKUP(KehadiranSeptember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":"Pelajar 4"},"H","H","H","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H","H","H","H","TS","TS","H","TD","H","H","D","TS","TS","H","D",null,{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_2)","v":2},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_3)","v":1},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_4)","v":19},{"$f":"SUM(KehadiranSeptember[[#This Row],[TD]:[D]])","v":3}]
[null,"S005",{"$f":"IFERROR(VLOOKUP(KehadiranSeptember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":"Pelajar 5"},"H","H","H","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H","H","H","H","TS","TS","H","H",null,{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranSeptember[[#This Row],[1]:[ ]],Kod_4)","v":22},{"$f":"SUM(KehadiranSeptember[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranSeptember[1],\"U\")+COUNTIF(KehadiranSeptember[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[2],\"U\")+COUNTIF(KehadiranSeptember[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[3],\"U\")+COUNTIF(KehadiranSeptember[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[4],\"U\")+COUNTIF(KehadiranSeptember[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[5],\"U\")+COUNTIF(KehadiranSeptember[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[6],\"U\")+COUNTIF(KehadiranSeptember[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[7],\"U\")+COUNTIF(KehadiranSeptember[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[8],\"U\")+COUNTIF(KehadiranSeptember[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[9],\"U\")+COUNTIF(KehadiranSeptember[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[10],\"U\")+COUNTIF(KehadiranSeptember[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[11],\"U\")+COUNTIF(KehadiranSeptember[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[12],\"U\")+COUNTIF(KehadiranSeptember[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[13],\"U\")+COUNTIF(KehadiranSeptember[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[14],\"U\")+COUNTIF(KehadiranSeptember[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[15],\"U\")+COUNTIF(KehadiranSeptember[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[16],\"U\")+COUNTIF(KehadiranSeptember[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[17],\"U\")+COUNTIF(KehadiranSeptember[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[18],\"U\")+COUNTIF(KehadiranSeptember[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[19],\"U\")+COUNTIF(KehadiranSeptember[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[20],\"U\")+COUNTIF(KehadiranSeptember[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[21],\"U\")+COUNTIF(KehadiranSeptember[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[22],\"U\")+COUNTIF(KehadiranSeptember[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[23],\"U\")+COUNTIF(KehadiranSeptember[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[24],\"U\")+COUNTIF(KehadiranSeptember[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[25],\"U\")+COUNTIF(KehadiranSeptember[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[26],\"U\")+COUNTIF(KehadiranSeptember[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[27],\"U\")+COUNTIF(KehadiranSeptember[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[28],\"U\")+COUNTIF(KehadiranSeptember[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[29],\"U\")+COUNTIF(KehadiranSeptember[29],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[30],\"U\")+COUNTIF(KehadiranSeptember[30],\"E\")","v":0},{"$f":"COUNTIF(KehadiranSeptember[[ ]],\"U\")+COUNTIF(KehadiranSeptember[[ ]],\"E\")","v":0},{"$f":"SUBTOTAL(109,KehadiranSeptember[T])","v":4},{"$f":"SUBTOTAL(109,KehadiranSeptember[TD])","v":10},{"$f":"SUBTOTAL(109,KehadiranSeptember[D])","v":3},{"$f":"SUBTOTAL(109,KehadiranSeptember[H])","v":93},{"$f":"SUBTOTAL(109,KehadiranSeptember[Hari Tidak Hadir])","v":13}]

{"sheet":"Oktober","index":3,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,10,1)","v":"2012-10-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,1),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,2),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,3),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,4),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,5),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,6),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,7),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,8),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,9),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,10),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,11),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,12),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,13),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,14),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,15),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,16),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,17),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,18),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,19),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,20),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,21),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,22),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,23),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,24),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,25),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,26),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,27),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,28),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,29),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,30),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,10,31),1),\"[$-43E]aaa\")","v":"Rabu"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOktober[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOktober[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOktober[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOktober[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOktober[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOktober[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOktober[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOktober[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOktober[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOktober[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOktober[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranOktober[1],\"U\")+COUNTIF(KehadiranOktober[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[2],\"U\")+COUNTIF(KehadiranOktober[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[3],\"U\")+COUNTIF(KehadiranOktober[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[4],\"U\")+COUNTIF(KehadiranOktober[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[5],\"U\")+COUNTIF(KehadiranOktober[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[6],\"U\")+COUNTIF(KehadiranOktober[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[7],\"U\")+COUNTIF(KehadiranOktober[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[8],\"U\")+COUNTIF(KehadiranOktober[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[9],\"U\")+COUNTIF(KehadiranOktober[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[10],\"U\")+COUNTIF(KehadiranOktober[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[11],\"U\")+COUNTIF(KehadiranOktober[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[12],\"U\")+COUNTIF(KehadiranOktober[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[13],\"U\")+COUNTIF(KehadiranOktober[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[14],\"U\")+COUNTIF(KehadiranOktober[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[15],\"U\")+COUNTIF(KehadiranOktober[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[16],\"U\")+COUNTIF(KehadiranOktober[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[17],\"U\")+COUNTIF(KehadiranOktober[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[18],\"U\")+COUNTIF(KehadiranOktober[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[19],\"U\")+COUNTIF(KehadiranOktober[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[20],\"U\")+COUNTIF(KehadiranOktober[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[21],\"U\")+COUNTIF(KehadiranOktober[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[22],\"U\")+COUNTIF(KehadiranOktober[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[23],\"U\")+COUNTIF(KehadiranOktober[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[24],\"U\")+COUNTIF(KehadiranOktober[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[25],\"U\")+COUNTIF(KehadiranOktober[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[26],\"U\")+COUNTIF(KehadiranOktober[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[27],\"U\")+COUNTIF(KehadiranOktober[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[28],\"U\")+COUNTIF(KehadiranOktober[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[29],\"U\")+COUNTIF(KehadiranOktober[29],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[30],\"U\")+COUNTIF(KehadiranOktober[30],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOktober[31],\"U\")+COUNTIF(KehadiranOktober[31],\"E\")","v":0},{"$f":"SUBTOTAL(109,KehadiranOktober[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranOktober[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranOktober[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranOktober[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranOktober[Hari Tidak Hadir])","v":0}]

{"sheet":"November","index":4,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,11,1)","v":"2012-11-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,1),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,2),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,3),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,4),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,5),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,6),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,7),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,8),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,9),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,10),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,11),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,12),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,13),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,14),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,15),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,16),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,17),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,18),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,19),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,20),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,21),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,22),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,23),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,24),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,25),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,26),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,27),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,28),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,29),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,11,30),1),\"[$-43E]aaa\")","v":"Jumaat"},null,"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranNovember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranNovember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranNovember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranNovember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranNovember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranNovember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranNovember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranNovember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranNovember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranNovember[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranNovember[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranNovember[1],\"U\")+COUNTIF(KehadiranNovember[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[2],\"U\")+COUNTIF(KehadiranNovember[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[3],\"U\")+COUNTIF(KehadiranNovember[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[4],\"U\")+COUNTIF(KehadiranNovember[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[5],\"U\")+COUNTIF(KehadiranNovember[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[6],\"U\")+COUNTIF(KehadiranNovember[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[7],\"U\")+COUNTIF(KehadiranNovember[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[8],\"U\")+COUNTIF(KehadiranNovember[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[9],\"U\")+COUNTIF(KehadiranNovember[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[10],\"U\")+COUNTIF(KehadiranNovember[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[11],\"U\")+COUNTIF(KehadiranNovember[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[12],\"U\")+COUNTIF(KehadiranNovember[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[13],\"U\")+COUNTIF(KehadiranNovember[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[14],\"U\")+COUNTIF(KehadiranNovember[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[15],\"U\")+COUNTIF(KehadiranNovember[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[16],\"U\")+COUNTIF(KehadiranNovember[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[17],\"U\")+COUNTIF(KehadiranNovember[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[18],\"U\")+COUNTIF(KehadiranNovember[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[19],\"U\")+COUNTIF(KehadiranNovember[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[20],\"U\")+COUNTIF(KehadiranNovember[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[21],\"U\")+COUNTIF(KehadiranNovember[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[22],\"U\")+COUNTIF(KehadiranNovember[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[23],\"U\")+COUNTIF(KehadiranNovember[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[24],\"U\")+COUNTIF(KehadiranNovember[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[25],\"U\")+COUNTIF(KehadiranNovember[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[26],\"U\")+COUNTIF(KehadiranNovember[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[27],\"U\")+COUNTIF(KehadiranNovember[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[28],\"U\")+COUNTIF(KehadiranNovember[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[29],\"U\")+COUNTIF(KehadiranNovember[29],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[30],\"U\")+COUNTIF(KehadiranNovember[30],\"E\")","v":0},{"$f":"COUNTIF(KehadiranNovember[[ ]],\"U\")+COUNTIF(KehadiranNovember[[ ]],\"E\")","v":0},{"$f":"SUBTOTAL(109,KehadiranNovember[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranNovember[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranNovember[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranNovember[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranNovember[Hari Tidak Hadir])","v":0}]

{"sheet":"Disember","index":5,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,12,1)","v":"2012-12-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,1),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,2),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,3),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,4),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,5),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,6),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,7),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,8),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,9),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,10),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,11),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,12),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,13),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,14),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,15),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,16),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,17),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,18),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,19),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,20),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,21),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,22),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,23),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,24),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,25),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,26),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,27),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,28),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,29),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,30),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar,12,31),1),\"[$-43E]aaa\")","v":"Isnin"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranDisember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranDisember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranDisember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranDisember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranDisember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranDisember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranDisember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranDisember[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranDisember[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranDisember[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranDisember[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranDisember[1],\"U\")+COUNTIF(KehadiranDisember[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[2],\"U\")+COUNTIF(KehadiranDisember[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[3],\"U\")+COUNTIF(KehadiranDisember[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[4],\"U\")+COUNTIF(KehadiranDisember[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[5],\"U\")+COUNTIF(KehadiranDisember[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[6],\"U\")+COUNTIF(KehadiranDisember[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[7],\"U\")+COUNTIF(KehadiranDisember[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[8],\"U\")+COUNTIF(KehadiranDisember[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[9],\"U\")+COUNTIF(KehadiranDisember[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[10],\"U\")+COUNTIF(KehadiranDisember[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[11],\"U\")+COUNTIF(KehadiranDisember[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[12],\"U\")+COUNTIF(KehadiranDisember[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[13],\"U\")+COUNTIF(KehadiranDisember[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[14],\"U\")+COUNTIF(KehadiranDisember[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[15],\"U\")+COUNTIF(KehadiranDisember[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[16],\"U\")+COUNTIF(KehadiranDisember[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[17],\"U\")+COUNTIF(KehadiranDisember[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[18],\"U\")+COUNTIF(KehadiranDisember[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[19],\"U\")+COUNTIF(KehadiranDisember[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[20],\"U\")+COUNTIF(KehadiranDisember[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[21],\"U\")+COUNTIF(KehadiranDisember[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[22],\"U\")+COUNTIF(KehadiranDisember[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[23],\"U\")+COUNTIF(KehadiranDisember[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[24],\"U\")+COUNTIF(KehadiranDisember[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[25],\"U\")+COUNTIF(KehadiranDisember[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[26],\"U\")+COUNTIF(KehadiranDisember[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[27],\"U\")+COUNTIF(KehadiranDisember[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[28],\"U\")+COUNTIF(KehadiranDisember[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[29],\"U\")+COUNTIF(KehadiranDisember[29],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[30],\"U\")+COUNTIF(KehadiranDisember[30],\"E\")","v":0},{"$f":"COUNTIF(KehadiranDisember[31],\"U\")+COUNTIF(KehadiranDisember[31],\"E\")","v":0},{"$f":"SUBTOTAL(109,KehadiranDisember[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranDisember[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranDisember[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranDisember[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranDisember[Hari Tidak Hadir])","v":0}]

{"sheet":"Januari","index":6,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,1,1)","v":"2012-01-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,1),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,2),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,3),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,4),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,5),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,6),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,7),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,8),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,9),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,10),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,11),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,12),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,13),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,14),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,15),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,16),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,17),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,18),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,19),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,20),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,21),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,22),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,23),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,24),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,25),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,26),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,27),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,28),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,29),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,30),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,1,31),1),\"[$-43E]aaa\")","v":"Khamis"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJanuari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJanuari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJanuari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJanuari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJanuari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJanuari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJanuari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJanuari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJanuari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJanuari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJanuari[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranJanuari[1],\"U\")+COUNTIF(KehadiranJanuari[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[2],\"U\")+COUNTIF(KehadiranJanuari[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[3],\"U\")+COUNTIF(KehadiranJanuari[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[4],\"U\")+COUNTIF(KehadiranJanuari[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[5],\"U\")+COUNTIF(KehadiranJanuari[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[6],\"U\")+COUNTIF(KehadiranJanuari[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[7],\"U\")+COUNTIF(KehadiranJanuari[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[8],\"U\")+COUNTIF(KehadiranJanuari[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[9],\"U\")+COUNTIF(KehadiranJanuari[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[10],\"U\")+COUNTIF(KehadiranJanuari[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[11],\"U\")+COUNTIF(KehadiranJanuari[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[12],\"U\")+COUNTIF(KehadiranJanuari[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[13],\"U\")+COUNTIF(KehadiranJanuari[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[14],\"U\")+COUNTIF(KehadiranJanuari[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[15],\"U\")+COUNTIF(KehadiranJanuari[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[16],\"U\")+COUNTIF(KehadiranJanuari[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[17],\"U\")+COUNTIF(KehadiranJanuari[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[18],\"U\")+COUNTIF(KehadiranJanuari[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[19],\"U\")+COUNTIF(KehadiranJanuari[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[20],\"U\")+COUNTIF(KehadiranJanuari[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[21],\"U\")+COUNTIF(KehadiranJanuari[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[22],\"U\")+COUNTIF(KehadiranJanuari[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[23],\"U\")+COUNTIF(KehadiranJanuari[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[24],\"U\")+COUNTIF(KehadiranJanuari[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[25],\"U\")+COUNTIF(KehadiranJanuari[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[26],\"U\")+COUNTIF(KehadiranJanuari[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[27],\"U\")+COUNTIF(KehadiranJanuari[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[28],\"U\")+COUNTIF(KehadiranJanuari[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJanuari[29],\"U\")+COUNTIF(KehadiranJanuari[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranJanuari[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranJanuari[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranJanuari[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranJanuari[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranJanuari[Hari Tidak Hadir])","v":0}]

{"sheet":"Februari","index":7,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,2,1)","v":"2012-02-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,1),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,2),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,3),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,4),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,5),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,6),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,7),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,8),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,9),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,10),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,11),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,12),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,13),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,14),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,15),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,16),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,17),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,18),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,19),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,20),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,21),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,22),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,23),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,24),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,25),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,26),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,27),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,28),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,2,29),1),\"[$-43E]aaa\")","v":"Jumaat"},null,null,"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranFebruari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranFebruari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranFebruari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranFebruari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranFebruari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranFebruari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranFebruari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranFebruari[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranFebruari[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranFebruari[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranFebruari[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranFebruari[1],\"U\")+COUNTIF(KehadiranFebruari[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[2],\"U\")+COUNTIF(KehadiranFebruari[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[3],\"U\")+COUNTIF(KehadiranFebruari[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[4],\"U\")+COUNTIF(KehadiranFebruari[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[5],\"U\")+COUNTIF(KehadiranFebruari[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[6],\"U\")+COUNTIF(KehadiranFebruari[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[7],\"U\")+COUNTIF(KehadiranFebruari[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[8],\"U\")+COUNTIF(KehadiranFebruari[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[9],\"U\")+COUNTIF(KehadiranFebruari[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[10],\"U\")+COUNTIF(KehadiranFebruari[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[11],\"U\")+COUNTIF(KehadiranFebruari[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[12],\"U\")+COUNTIF(KehadiranFebruari[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[13],\"U\")+COUNTIF(KehadiranFebruari[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[14],\"U\")+COUNTIF(KehadiranFebruari[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[15],\"U\")+COUNTIF(KehadiranFebruari[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[16],\"U\")+COUNTIF(KehadiranFebruari[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[17],\"U\")+COUNTIF(KehadiranFebruari[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[18],\"U\")+COUNTIF(KehadiranFebruari[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[19],\"U\")+COUNTIF(KehadiranFebruari[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[20],\"U\")+COUNTIF(KehadiranFebruari[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[21],\"U\")+COUNTIF(KehadiranFebruari[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[22],\"U\")+COUNTIF(KehadiranFebruari[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[23],\"U\")+COUNTIF(KehadiranFebruari[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[24],\"U\")+COUNTIF(KehadiranFebruari[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[25],\"U\")+COUNTIF(KehadiranFebruari[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[26],\"U\")+COUNTIF(KehadiranFebruari[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[27],\"U\")+COUNTIF(KehadiranFebruari[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[28],\"U\")+COUNTIF(KehadiranFebruari[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranFebruari[29],\"U\")+COUNTIF(KehadiranFebruari[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranFebruari[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranFebruari[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranFebruari[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranFebruari[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranFebruari[Hari Tidak Hadir])","v":0}]

{"sheet":"Mac","index":8,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,3,1)","v":"2012-03-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,1),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,2),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,3),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,4),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,5),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,6),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,7),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,8),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,9),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,10),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,11),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,12),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,13),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,14),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,15),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,16),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,17),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,18),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,19),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,20),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,21),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,22),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,23),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,24),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,25),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,26),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,27),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,28),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,29),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,30),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,3,31),1),\"[$-43E]aaa\")","v":"Ahad"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMac[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMac[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMac[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMac[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMac[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMac[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMac[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMac[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMac[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMac[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMac[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranMac[1],\"U\")+COUNTIF(KehadiranMac[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[2],\"U\")+COUNTIF(KehadiranMac[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[3],\"U\")+COUNTIF(KehadiranMac[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[4],\"U\")+COUNTIF(KehadiranMac[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[5],\"U\")+COUNTIF(KehadiranMac[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[6],\"U\")+COUNTIF(KehadiranMac[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[7],\"U\")+COUNTIF(KehadiranMac[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[8],\"U\")+COUNTIF(KehadiranMac[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[9],\"U\")+COUNTIF(KehadiranMac[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[10],\"U\")+COUNTIF(KehadiranMac[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[11],\"U\")+COUNTIF(KehadiranMac[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[12],\"U\")+COUNTIF(KehadiranMac[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[13],\"U\")+COUNTIF(KehadiranMac[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[14],\"U\")+COUNTIF(KehadiranMac[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[15],\"U\")+COUNTIF(KehadiranMac[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[16],\"U\")+COUNTIF(KehadiranMac[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[17],\"U\")+COUNTIF(KehadiranMac[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[18],\"U\")+COUNTIF(KehadiranMac[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[19],\"U\")+COUNTIF(KehadiranMac[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[20],\"U\")+COUNTIF(KehadiranMac[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[21],\"U\")+COUNTIF(KehadiranMac[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[22],\"U\")+COUNTIF(KehadiranMac[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[23],\"U\")+COUNTIF(KehadiranMac[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[24],\"U\")+COUNTIF(KehadiranMac[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[25],\"U\")+COUNTIF(KehadiranMac[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[26],\"U\")+COUNTIF(KehadiranMac[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[27],\"U\")+COUNTIF(KehadiranMac[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[28],\"U\")+COUNTIF(KehadiranMac[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMac[29],\"U\")+COUNTIF(KehadiranMac[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranMac[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranMac[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranMac[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranMac[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranMac[Hari Tidak Hadir])","v":0}]

{"sheet":"April","index":9,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,4,1)","v":"2012-04-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,1),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,2),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,3),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,4),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,5),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,6),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,7),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,8),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,9),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,10),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,11),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,12),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,13),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,14),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,15),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,16),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,17),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,18),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,19),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,20),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,21),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,22),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,23),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,24),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,25),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,26),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,27),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,28),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,29),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,4,30),1),\"[$-43E]aaa\")","v":"Sel"},null,"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranApril[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranApril[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranApril[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranApril[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranApril[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranApril[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranApril[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranApril[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranApril[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranApril[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranApril[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranApril[1],\"U\")+COUNTIF(KehadiranApril[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[2],\"U\")+COUNTIF(KehadiranApril[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[3],\"U\")+COUNTIF(KehadiranApril[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[4],\"U\")+COUNTIF(KehadiranApril[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[5],\"U\")+COUNTIF(KehadiranApril[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[6],\"U\")+COUNTIF(KehadiranApril[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[7],\"U\")+COUNTIF(KehadiranApril[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[8],\"U\")+COUNTIF(KehadiranApril[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[9],\"U\")+COUNTIF(KehadiranApril[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[10],\"U\")+COUNTIF(KehadiranApril[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[11],\"U\")+COUNTIF(KehadiranApril[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[12],\"U\")+COUNTIF(KehadiranApril[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[13],\"U\")+COUNTIF(KehadiranApril[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[14],\"U\")+COUNTIF(KehadiranApril[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[15],\"U\")+COUNTIF(KehadiranApril[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[16],\"U\")+COUNTIF(KehadiranApril[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[17],\"U\")+COUNTIF(KehadiranApril[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[18],\"U\")+COUNTIF(KehadiranApril[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[19],\"U\")+COUNTIF(KehadiranApril[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[20],\"U\")+COUNTIF(KehadiranApril[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[21],\"U\")+COUNTIF(KehadiranApril[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[22],\"U\")+COUNTIF(KehadiranApril[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[23],\"U\")+COUNTIF(KehadiranApril[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[24],\"U\")+COUNTIF(KehadiranApril[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[25],\"U\")+COUNTIF(KehadiranApril[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[26],\"U\")+COUNTIF(KehadiranApril[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[27],\"U\")+COUNTIF(KehadiranApril[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[28],\"U\")+COUNTIF(KehadiranApril[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranApril[29],\"U\")+COUNTIF(KehadiranApril[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranApril[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranApril[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranApril[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranApril[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranApril[Hari Tidak Hadir])","v":0}]

{"sheet":"Mei","index":10,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,5,1)","v":"2012-05-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,1),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,2),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,3),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,4),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,5),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,6),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,7),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,8),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,9),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,10),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,11),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,12),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,13),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,14),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,15),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,16),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,17),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,18),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,19),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,20),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,21),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,22),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,23),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,24),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,25),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,26),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,27),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,28),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,29),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,30),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,5,31),1),\"[$-43E]aaa\")","v":"Jumaat"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMei[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMei[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMei[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMei[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMei[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMei[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMei[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMei[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranMei[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranMei[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranMei[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranMei[1],\"U\")+COUNTIF(KehadiranMei[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[2],\"U\")+COUNTIF(KehadiranMei[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[3],\"U\")+COUNTIF(KehadiranMei[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[4],\"U\")+COUNTIF(KehadiranMei[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[5],\"U\")+COUNTIF(KehadiranMei[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[6],\"U\")+COUNTIF(KehadiranMei[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[7],\"U\")+COUNTIF(KehadiranMei[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[8],\"U\")+COUNTIF(KehadiranMei[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[9],\"U\")+COUNTIF(KehadiranMei[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[10],\"U\")+COUNTIF(KehadiranMei[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[11],\"U\")+COUNTIF(KehadiranMei[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[12],\"U\")+COUNTIF(KehadiranMei[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[13],\"U\")+COUNTIF(KehadiranMei[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[14],\"U\")+COUNTIF(KehadiranMei[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[15],\"U\")+COUNTIF(KehadiranMei[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[16],\"U\")+COUNTIF(KehadiranMei[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[17],\"U\")+COUNTIF(KehadiranMei[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[18],\"U\")+COUNTIF(KehadiranMei[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[19],\"U\")+COUNTIF(KehadiranMei[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[20],\"U\")+COUNTIF(KehadiranMei[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[21],\"U\")+COUNTIF(KehadiranMei[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[22],\"U\")+COUNTIF(KehadiranMei[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[23],\"U\")+COUNTIF(KehadiranMei[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[24],\"U\")+COUNTIF(KehadiranMei[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[25],\"U\")+COUNTIF(KehadiranMei[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[26],\"U\")+COUNTIF(KehadiranMei[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[27],\"U\")+COUNTIF(KehadiranMei[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[28],\"U\")+COUNTIF(KehadiranMei[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranMei[29],\"U\")+COUNTIF(KehadiranMei[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranMei[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranMei[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranMei[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranMei[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranMei[Hari Tidak Hadir])","v":0}]

{"sheet":"Jun","index":11,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,6,1)","v":"2012-06-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,1),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,2),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,3),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,4),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,5),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,6),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,7),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,8),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,9),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,10),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,11),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,12),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,13),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,14),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,15),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,16),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,17),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,18),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,19),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,20),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,21),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,22),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,23),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,24),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,25),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,26),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,27),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,28),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,29),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,6,30),1),\"[$-43E]aaa\")","v":"Ahad"},null,"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30"," ","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJun[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranJun[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJun[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranJun[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJun[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranJun[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJun[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranJun[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJun[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJun[[#This Row],[1]:[ ]],Kod_4)","v":0},{"$f":"SUM(KehadiranJun[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranJun[1],\"U\")+COUNTIF(KehadiranJun[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[2],\"U\")+COUNTIF(KehadiranJun[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[3],\"U\")+COUNTIF(KehadiranJun[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[4],\"U\")+COUNTIF(KehadiranJun[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[5],\"U\")+COUNTIF(KehadiranJun[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[6],\"U\")+COUNTIF(KehadiranJun[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[7],\"U\")+COUNTIF(KehadiranJun[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[8],\"U\")+COUNTIF(KehadiranJun[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[9],\"U\")+COUNTIF(KehadiranJun[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[10],\"U\")+COUNTIF(KehadiranJun[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[11],\"U\")+COUNTIF(KehadiranJun[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[12],\"U\")+COUNTIF(KehadiranJun[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[13],\"U\")+COUNTIF(KehadiranJun[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[14],\"U\")+COUNTIF(KehadiranJun[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[15],\"U\")+COUNTIF(KehadiranJun[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[16],\"U\")+COUNTIF(KehadiranJun[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[17],\"U\")+COUNTIF(KehadiranJun[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[18],\"U\")+COUNTIF(KehadiranJun[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[19],\"U\")+COUNTIF(KehadiranJun[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[20],\"U\")+COUNTIF(KehadiranJun[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[21],\"U\")+COUNTIF(KehadiranJun[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[22],\"U\")+COUNTIF(KehadiranJun[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[23],\"U\")+COUNTIF(KehadiranJun[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[24],\"U\")+COUNTIF(KehadiranJun[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[25],\"U\")+COUNTIF(KehadiranJun[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[26],\"U\")+COUNTIF(KehadiranJun[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[27],\"U\")+COUNTIF(KehadiranJun[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[28],\"U\")+COUNTIF(KehadiranJun[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJun[29],\"U\")+COUNTIF(KehadiranJun[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranJun[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranJun[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranJun[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranJun[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranJun[Hari Tidak Hadir])","v":0}]

{"sheet":"Julai","index":12,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",{"$f":"TahunKalendar","v":2012}]
[]
[null,null,{"$f":"TeksKunciWarna","v":"KUNCI WARNA"},{"$f":"Kod_1","v":"L"},{"$f":"TeksKod1","v":"Lewat"},null,null,{"$f":"Kod_2","v":"D"},{"$f":"TeksKod2","v":"Dikecualikan"},null,null,{"$f":"Kod_3","v":"TD"},{"$f":"TeksKod3","v":"Tidak Dikecualikan"},null,null,{"$f":"Kod_4","v":"H"},{"$f":"TeksKod4","v":"Hadir"},null,null,{"$f":"Kod_5","v":"TS"},{"$f":"TeksKod5","v":"Tiada Sekolah"}]
[]
[null,{"$f":"DATE(TahunKalendar,7,1)","v":"2012-07-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,1),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,2),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,3),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,4),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,5),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,6),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,7),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,8),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,9),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,10),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,11),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,12),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,13),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,14),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,15),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,16),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,17),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,18),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,19),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,20),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,21),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,22),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,23),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,24),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,25),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,26),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,27),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,28),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,29),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,30),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,7,31),1),\"[$-43E]aaa\")","v":"Rabu"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJulai[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJulai[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJulai[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJulai[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJulai[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJulai[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJulai[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJulai[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranJulai[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranJulai[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranJulai[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranJulai[1],\"U\")+COUNTIF(KehadiranJulai[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[2],\"U\")+COUNTIF(KehadiranJulai[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[3],\"U\")+COUNTIF(KehadiranJulai[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[4],\"U\")+COUNTIF(KehadiranJulai[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[5],\"U\")+COUNTIF(KehadiranJulai[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[6],\"U\")+COUNTIF(KehadiranJulai[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[7],\"U\")+COUNTIF(KehadiranJulai[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[8],\"U\")+COUNTIF(KehadiranJulai[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[9],\"U\")+COUNTIF(KehadiranJulai[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[10],\"U\")+COUNTIF(KehadiranJulai[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[11],\"U\")+COUNTIF(KehadiranJulai[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[12],\"U\")+COUNTIF(KehadiranJulai[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[13],\"U\")+COUNTIF(KehadiranJulai[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[14],\"U\")+COUNTIF(KehadiranJulai[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[15],\"U\")+COUNTIF(KehadiranJulai[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[16],\"U\")+COUNTIF(KehadiranJulai[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[17],\"U\")+COUNTIF(KehadiranJulai[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[18],\"U\")+COUNTIF(KehadiranJulai[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[19],\"U\")+COUNTIF(KehadiranJulai[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[20],\"U\")+COUNTIF(KehadiranJulai[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[21],\"U\")+COUNTIF(KehadiranJulai[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[22],\"U\")+COUNTIF(KehadiranJulai[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[23],\"U\")+COUNTIF(KehadiranJulai[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[24],\"U\")+COUNTIF(KehadiranJulai[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[25],\"U\")+COUNTIF(KehadiranJulai[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[26],\"U\")+COUNTIF(KehadiranJulai[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[27],\"U\")+COUNTIF(KehadiranJulai[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[28],\"U\")+COUNTIF(KehadiranJulai[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranJulai[29],\"U\")+COUNTIF(KehadiranJulai[29],\"E\")","v":0},null,null,{"$f":"SUBTOTAL(109,KehadiranJulai[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranJulai[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranJulai[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranJulai[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranJulai[Hari Tidak Hadir])","v":0}]

{"sheet":"Ogos","index":13,"n_rows":12,"n_cols":39,"rows_kept":12,"merged":[[4,34,4,38]]}
["REKOD KEHADIRAN PELAJAR",{"$nulls":36},"Tahun Persekolahan Bermula:",2012]
[]
[null,null,"KUNCI WARNA","L","Lewat",null,null,"D","Dikecualikan",null,null,"TD","Tidak Dikecualikan",null,null,"H","Hadir",null,null,"TS","Tiada Sekolah"]
[]
[null,{"$f":"DATE(TahunKalendar,8,1)","v":"2012-08-01"},null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,1),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,2),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,3),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,4),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,5),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,6),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,7),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,8),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,9),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,10),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,11),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,12),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,13),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,14),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,15),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,16),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,17),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,18),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,19),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,20),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,21),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,22),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,23),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,24),1),\"[$-43E]aaa\")","v":"Sabtu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,25),1),\"[$-43E]aaa\")","v":"Ahad"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,26),1),\"[$-43E]aaa\")","v":"Isnin"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,27),1),\"[$-43E]aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,28),1),\"[$-43E]aaa\")","v":"Rabu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,29),1),\"[$-43E]aaa\")","v":"Khamis"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,30),1),\"[$-43E]aaa\")","v":"Jumaat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalendar+1,8,31),1),\"[$-43E]aaa\")","v":"Sabtu"},"Jumlah"]
[null,"ID Pelajar","Nama Pelajar","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","T","TD","D","H","Hari Tidak Hadir"]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOgos[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOgos[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOgos[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOgos[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOgos[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOgos[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOgos[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOgos[[#This Row],[TD]:[D]])","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(KehadiranOgos[[#This Row],[ID Pelajar]],SenaraiPelajar[],18,FALSE),\"\")","v":""},{"$nulls":31},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_1)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_2)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_3)","v":0},{"$f":"COUNTIF(KehadiranOgos[[#This Row],[1]:[31]],Kod_4)","v":0},{"$f":"SUM(KehadiranOgos[[#This Row],[TD]:[D]])","v":0}]
[null,null,"Total Hari Tidak Hadir",{"$f":"COUNTIF(KehadiranOgos[1],\"U\")+COUNTIF(KehadiranOgos[1],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[2],\"U\")+COUNTIF(KehadiranOgos[2],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[3],\"U\")+COUNTIF(KehadiranOgos[3],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[4],\"U\")+COUNTIF(KehadiranOgos[4],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[5],\"U\")+COUNTIF(KehadiranOgos[5],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[6],\"U\")+COUNTIF(KehadiranOgos[6],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[7],\"U\")+COUNTIF(KehadiranOgos[7],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[8],\"U\")+COUNTIF(KehadiranOgos[8],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[9],\"U\")+COUNTIF(KehadiranOgos[9],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[10],\"U\")+COUNTIF(KehadiranOgos[10],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[11],\"U\")+COUNTIF(KehadiranOgos[11],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[12],\"U\")+COUNTIF(KehadiranOgos[12],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[13],\"U\")+COUNTIF(KehadiranOgos[13],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[14],\"U\")+COUNTIF(KehadiranOgos[14],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[15],\"U\")+COUNTIF(KehadiranOgos[15],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[16],\"U\")+COUNTIF(KehadiranOgos[16],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[17],\"U\")+COUNTIF(KehadiranOgos[17],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[18],\"U\")+COUNTIF(KehadiranOgos[18],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[19],\"U\")+COUNTIF(KehadiranOgos[19],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[20],\"U\")+COUNTIF(KehadiranOgos[20],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[21],\"U\")+COUNTIF(KehadiranOgos[21],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[22],\"U\")+COUNTIF(KehadiranOgos[22],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[23],\"U\")+COUNTIF(KehadiranOgos[23],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[24],\"U\")+COUNTIF(KehadiranOgos[24],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[25],\"U\")+COUNTIF(KehadiranOgos[25],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[26],\"U\")+COUNTIF(KehadiranOgos[26],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[27],\"U\")+COUNTIF(KehadiranOgos[27],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[28],\"U\")+COUNTIF(KehadiranOgos[28],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[29],\"U\")+COUNTIF(KehadiranOgos[29],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[30],\"U\")+COUNTIF(KehadiranOgos[30],\"E\")","v":0},{"$f":"COUNTIF(KehadiranOgos[31],\"U\")+COUNTIF(KehadiranOgos[31],\"E\")","v":0},{"$f":"SUBTOTAL(109,KehadiranOgos[T])","v":0},{"$f":"SUBTOTAL(109,KehadiranOgos[TD])","v":0},{"$f":"SUBTOTAL(109,KehadiranOgos[D])","v":0},{"$f":"SUBTOTAL(109,KehadiranOgos[H])","v":0},{"$f":"SUBTOTAL(109,KehadiranOgos[Hari Tidak Hadir])","v":0}]

{"sheet":"Laporan Kehadiran Pelajar","index":14,"n_rows":40,"n_cols":37,"rows_kept":40,"merged":[[2,3,2,14],[2,15,2,17],[2,18,2,21],[2,22,2,29],[2,30,2,31],[2,32,2,35],[3,1,3,2],[3,3,3,14],[3,15,3,17],[3,18,3,21],[3,22,3,29],[3,30,3,31],[3,32,3,35],[4,1,4,9],[4,10,4,21],[4,22,4,29],[4,30,4,36],[5,1,5,9],[5,10,5,21],[5,22,5,29],[5,30,5,36],[6,1,6,9],[6,10,6,21],[6,22,6,29],[6,30,6,36],[7,1,7,9],[7,10,7,21],[7,22,7,29],[7,30,7,36],[8,1,8,9],[8,10,8,21],[8,22,8,29],[8,30,8,36],[9,1,9,9],[9,10,9,21],[9,22,9,29],[9,30,9,36],[13,1,14,32],[13,33,13,36],[15,1,16,1],[15,33,16,33],[15,34,16,34],[15,35,16,35],[15,36,16,36],[17,1,18,1],[17,33,18,33],[17,34,18,34],[17,35,18,35],[17,36,18,36],[19,1,20,1],[19,33,20,33],[19,34,20,34],[19,35,20,35],[19,36,20,36],[21,1,22,1],[21,33,22,33],[21,34,22,34],[21,35,22,35],[21,36,22,36],[23,1,24,1],[23,33,24,33],[23,34,24,34],[23,35,24,35],[23,36,24,36],[25,1,26,1],[25,33,26,33],[25,34,26,34],[25,35,26,35],[25,36,26,36],[27,1,28,1],[27,33,28,33],[27,34,28,34],[27,35,28,35],[27,36,28,36],[29,1,30,1],[29,33,30,33],[29,34,30,34],[29,35,30,35],[29,36,30,36],[31,1,32,1],[31,33,32,33],[31,34,32,34],[31,35,32,35],[31,36,32,36],[33,1,34,1],[33,33,34,33],[33,34,34,34],[33,35,34,35],[33,36,34,36],[35,1,36,1],[35,33,36,33],[35,34,36,34],[35,35,36,35],[35,36,36,36],[37,1,38,1],[37,33,38,33],[37,34,38,34],[37,35,38,35],[37,36,38,36],[39,30,39,32]]}
[{"$f":"\"Rekod Kehadiran untuk \"","v":"Rekod Kehadiran untuk "},{"$nulls":7},{"$f":"D4","v":"David Alexander"}]
[]
[null,"ID Pelajar",null,"Nama Pelajar",{"$nulls":11},"Jantina",null,null,"Tarikh Lahir",{"$nulls":3},"Sekolah",{"$nulls":7},"Gred",null,"Guru",{"$nulls":3},"Kelas"]
[null,"S001",null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],18,FALSE),\"\")","v":"David Alexander"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],4,FALSE),\"\")","v":"M"},null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],5,FALSE),\"\")","v":"1997-03-28"},{"$nulls":3},"Pusat Pengajian Seni Halus",{"$nulls":7},7,null,"Luca Argentiero",{"$nulls":3},123]
[null,"Nama Ibu bapa atau Penjaga 1",{"$nulls":8},"Perhubungan",{"$nulls":11},"Telefon Kerja",{"$nulls":7},"Telefon Rumah"]
[null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],6,FALSE),\"\")","v":"Michelle"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],7,FALSE),\"\")","v":"Alexander"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],8,FALSE),\"\")","v":1235550134},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],9,FALSE),\"\")","v":2345550134}]
[null,"Nama Ibu bapa atau Penjaga 2",{"$nulls":8},"Perhubungan",{"$nulls":11},"Telefon Kerja",{"$nulls":7},"Telefon Rumah"]
[null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],10,FALSE),\"\")","v":"Michael Alexander"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],11,FALSE),\"\")","v":"Bapa"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],12,FALSE),\"\")","v":1235550134},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],13,FALSE),\"\")","v":2345550134}]
[null,"Hubungan Kecemasan",{"$nulls":8},"Perhubungan",{"$nulls":11},"Telefon Kerja",{"$nulls":7},"Telefon Rumah"]
[null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],14,FALSE),\"\")","v":"Reed Koch"},{"$nulls":8},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],15,FALSE),\"\")","v":"Datuk"},{"$nulls":11},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],16,FALSE),\"\")","v":7895550189},{"$nulls":7},{"$f":"IFERROR(VLOOKUP(CarianPelajar,SenaraiPelajar[],17,FALSE),\"\")","v":7895550134}]
[]
[null,{"$f":"Ogos!C3","v":"KUNCI WARNA"},{"$f":"Ogos!D3","v":"L"},{"$f":"Ogos!E3","v":"Lewat"},null,null,{"$f":"Ogos!H3","v":"D"},{"$f":"Ogos!I3","v":"Dikecualikan"},null,null,{"$f":"Ogos!L3","v":"TD"},{"$f":"Ogos!M3","v":"Tidak Dikecualikan"},{"$nulls":3},{"$f":"Ogos!P3","v":"H"},{"$f":"Ogos!Q3","v":"Hadir"},null,null,{"$f":"Ogos!T3","v":"TS"},{"$f":"Ogos!U3","v":"Tiada Sekolah"}]
[]
[null,"Kehadiran",{"$nulls":31},"Jumlah Kehadiran"]
[{"$nulls":33},"T","E","U","P"]
[null,"September",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D17:$AH17,Kod_1)","v":2},{"$f":"COUNTIF($D17:$AH17,Kod_2)","v":1},{"$f":"COUNTIF($D17:$AH17,Kod_3)","v":0},{"$f":"COUNTIF($D17:$AH17,Kod_4)","v":18}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],3,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],4,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],5,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],6,FALSE),\"\")","v":"L"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],7,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],8,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],9,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],10,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],11,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],12,FALSE),\"\")","v":"D"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],13,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],14,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],15,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],16,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],17,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],18,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],19,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],20,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],21,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],22,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],23,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],24,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],25,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],26,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],27,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],28,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],29,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],30,FALSE),\"\")","v":"TS"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],31,FALSE),\"\")","v":"H"},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranSeptember[],32,FALSE),\"\")","v":"H"}]
[null,"Oktober",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D19:$AH19,Kod_1)","v":0},{"$f":"COUNTIF($D19:$AH19,Kod_2)","v":0},{"$f":"COUNTIF($D19:$AH19,Kod_3)","v":0},{"$f":"COUNTIF($D19:$AH19,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOktober[],33,FALSE),\"\")","v":""}]
[null,"November",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D21:$AH21,Kod_1)","v":0},{"$f":"COUNTIF($D21:$AH21,Kod_2)","v":0},{"$f":"COUNTIF($D21:$AH21,Kod_3)","v":0},{"$f":"COUNTIF($D21:$AH21,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranNovember[],32,FALSE),\"\")","v":""}]
[null,"Disember",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D23:$AH23,Kod_1)","v":0},{"$f":"COUNTIF($D23:$AH23,Kod_2)","v":0},{"$f":"COUNTIF($D23:$AH23,Kod_3)","v":0},{"$f":"COUNTIF($D23:$AH23,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranDisember[],33,FALSE),\"\")","v":""}]
[null,"Januari",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D25:$AH25,Kod_1)","v":0},{"$f":"COUNTIF($D25:$AH25,Kod_2)","v":0},{"$f":"COUNTIF($D25:$AH25,Kod_3)","v":0},{"$f":"COUNTIF($D25:$AH25,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJanuari[],33,FALSE),\"\")","v":""}]
[null,"Februari",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,null,null,{"$f":"COUNTIF($D27:$AH27,Kod_1)","v":0},{"$f":"COUNTIF($D27:$AH27,Kod_2)","v":0},{"$f":"COUNTIF($D27:$AH27,Kod_3)","v":0},{"$f":"COUNTIF($D27:$AH27,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranFebruari[],31,FALSE),\"\")","v":""}]
[null,"Mac",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D29:$AH29,Kod_1)","v":0},{"$f":"COUNTIF($D29:$AH29,Kod_2)","v":0},{"$f":"COUNTIF($D29:$AH29,Kod_3)","v":0},{"$f":"COUNTIF($D29:$AH29,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMac[],33,FALSE),\"\")","v":""}]
[null,"April",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D31:$AH31,Kod_1)","v":0},{"$f":"COUNTIF($D31:$AH31,Kod_2)","v":0},{"$f":"COUNTIF($D31:$AH31,Kod_3)","v":0},{"$f":"COUNTIF($D31:$AH31,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranApril[],32,FALSE),\"\")","v":""}]
[null,"Mei",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D33:$AH33,Kod_1)","v":0},{"$f":"COUNTIF($D33:$AH33,Kod_2)","v":0},{"$f":"COUNTIF($D33:$AH33,Kod_3)","v":0},{"$f":"COUNTIF($D33:$AH33,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranMei[],33,FALSE),\"\")","v":""}]
[null,"Jun",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,{"$f":"COUNTIF($D35:$AH35,Kod_1)","v":0},{"$f":"COUNTIF($D35:$AH35,Kod_2)","v":0},{"$f":"COUNTIF($D35:$AH35,Kod_3)","v":0},{"$f":"COUNTIF($D35:$AH35,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJun[],32,FALSE),\"\")","v":""}]
[null,"Julai",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D37:$AH37,Kod_1)","v":0},{"$f":"COUNTIF($D37:$AH37,Kod_2)","v":0},{"$f":"COUNTIF($D37:$AH37,Kod_3)","v":0},{"$f":"COUNTIF($D37:$AH37,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranJulai[],33,FALSE),\"\")","v":""}]
[null,"Ogos",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,{"$f":"COUNTIF($D39:$AH39,Kod_1)","v":0},{"$f":"COUNTIF($D39:$AH39,Kod_2)","v":0},{"$f":"COUNTIF($D39:$AH39,Kod_3)","v":0},{"$f":"COUNTIF($D39:$AH39,Kod_4)","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],8,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],11,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],12,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],13,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],14,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],15,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],16,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],17,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],18,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],19,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],20,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],21,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],22,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],23,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],24,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],25,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],26,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],27,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],28,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],29,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],30,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],31,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],32,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(CarianPelajar,KehadiranOgos[],33,FALSE),\"\")","v":""}]
[{"$nulls":30},"Jumlah",null,null,{"$f":"SUM(AH16:AH37)","v":2},{"$f":"SUM(AI16:AI37)","v":1},{"$f":"SUM(AJ16:AJ37)","v":0},{"$f":"SUM(AK16:AK37)","v":18}]