============================================================
SKENARIO: Template SIAD lengkap (4 baris meta + header di baris 4)
============================================================
Total rows from toArray(): 5
Header row ditemukan di index: 3
rawHeaders: ["nomor kk","nik","nama lengkap","jenis kelamin","tempat lahir","tanggal lahir","agama","pendidikan","pekerjaan","status perkawinan","hubungan keluarga","kewarganegaraan","status penduduk","alamat lengkap","dusun","rt","rw"]
Data row[4] keys: [0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
Data row[4] values: ["1224030405210001","1271012345670001","Ahmad Dahlan","Laki-laki","Medan","1995-08-17","Islam","SMA\/SMK","Wiraswasta","Kawin","Kepala Keluarga","WNI","aktif","Jl. Merdeka No. 12","Dusun I","001","002"]

Mapped result:
  no_kk => '1224030405210001'
  nik => '1271012345670001'
  nama_lengkap => 'Ahmad Dahlan'
  jenis_kelamin => 'Laki-laki'
  tempat_lahir => 'Medan'
  tanggal_lahir => '1995-08-17'
  agama => 'Islam'
  pendidikan => 'SMA/SMK'
  pekerjaan => 'Wiraswasta'
  status_perkawinan => 'Kawin'
  hubungan_keluarga => 'Kepala Keluarga'
  kewarganegaraan => 'WNI'
  status_penduduk => 'aktif'
  alamat => 'Jl. Merdeka No. 12'
  dusun => 'Dusun I'
  rt => '001'
  rw => '002'

no_kk = '1224030405210001'


============================================================
SKENARIO: File Export KK (bukan template SIAD)
============================================================
Total rows from toArray(): 2
ERROR: Header row tidak ditemukan!
Semua rows:
  Row[0]: ["No KK","Kepala Keluarga","Alamat","Kecamatan","Kabupaten","RT","RW"]
  Row[1]: ["1224030405210001","SITIMINA ZEGA","Desa Siofa Banua","Kec. Tuhemberua","Kab. Nias Utara","1","1"]


============================================================
SKENARIO: Header langsung baris pertama (tanpa meta)
============================================================
Total rows from toArray(): 2
Header row ditemukan di index: 0
rawHeaders: ["nomor kk","nik","nama lengkap","jenis kelamin","tempat lahir","tanggal lahir","agama","pendidikan","pekerjaan","status perkawinan","hubungan keluarga","kewarganegaraan","status penduduk","alamat lengkap","dusun","rt","rw"]
Data row[1] keys: [0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
Data row[1] values: ["1224030405210001","1271012345670001","Ahmad Dahlan","Laki-laki","Medan","1995-08-17","Islam","SMA\/SMK","Wiraswasta","Kawin","Kepala Keluarga","WNI","aktif","Jl. Merdeka No. 12","Dusun I","001","002"]

Mapped result:
  no_kk => '1224030405210001'
  nik => '1271012345670001'
  nama_lengkap => 'Ahmad Dahlan'
  jenis_kelamin => 'Laki-laki'
  tempat_lahir => 'Medan'
  tanggal_lahir => '1995-08-17'
  agama => 'Islam'
  pendidikan => 'SMA/SMK'
  pekerjaan => 'Wiraswasta'
  status_perkawinan => 'Kawin'
  hubungan_keluarga => 'Kepala Keluarga'
  kewarganegaraan => 'WNI'
  status_penduduk => 'aktif'
  alamat => 'Jl. Merdeka No. 12'
  dusun => 'Dusun I'
  rt => '001'
  rw => '002'

no_kk = '1224030405210001'


============================================================
SKENARIO: File KK dengan header SIAD tapi data hanya 8 kolom
============================================================
Total rows from toArray(): 5
Header row ditemukan di index: 3
rawHeaders: ["nomor kk","nik","nama lengkap","jenis kelamin","tempat lahir","tanggal lahir","agama","pendidikan","pekerjaan","status perkawinan","hubungan keluarga","kewarganegaraan","status penduduk","alamat lengkap","dusun","rt","rw"]
Data row[4] keys: [0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16]
Data row[4] values: ["1224030405210001","SITIMINA ZEGA","Desa Siofa Banua","Kec. Tuhemberua","Kab. Nias Utara","1","1","1",null,null,null,null,null,null,null,null,null]

Mapped result:
  no_kk => '1224030405210001'
  nik => 'SITIMINA ZEGA'
  nama_lengkap => 'Desa Siofa Banua'
  jenis_kelamin => 'Kec. Tuhemberua'
  tempat_lahir => 'Kab. Nias Utara'
  tanggal_lahir => '1'
  agama => '1'
  pendidikan => '1'
  pekerjaan => NULL
  status_perkawinan => NULL
  hubungan_keluarga => NULL
  kewarganegaraan => NULL
  status_penduduk => NULL
  alamat => NULL
  dusun => NULL
  rt => NULL
  rw => NULL

no_kk = '1224030405210001'


============================================================
SKENARIO: Export DataTables KK (No, No KK, Kepala KK, ...)
============================================================
Total rows from toArray(): 2
ERROR: Header row tidak ditemukan!
Semua rows:
  Row[0]: ["No.","No KK","Kepala Keluarga","Alamat","Dusun","RT","RW"]
  Row[1]: ["1","1224030405210001","SITIMINA ZEGA","Desa Siofa Banua, Kec. Tuhemberua, Kab. Nias Utara","Dusun I","1","1"]


============================================================
SKENARIO: KRITIS: Header mengandung kata NIK dalam string gabungan
============================================================
Total rows from toArray(): 2
ERROR: Header row tidak ditemukan!
Semua rows:
  Row[0]: ["Nomor KK \/ NIK","Nama"]
  Row[1]: ["1224030405210001, SITIMINA ZEGA, Desa Siofa Banua, Kec. Tuhemberua, Kab. Nias Utara, 1, 1, 1",null]


Audit selesai.