Rancang Bangun Aplikasi Desktop Pendeteksi Duplikat Data NIK dan NKK pada File Excel Menggunakan Metode Exact Matching Berbasis Flutter
DOI:
https://doi.org/10.59024/jiti.v4i3.2285Keywords:
Duplicate Data, Exact Matching, Flutter, NIK, NKKAbstract
The management of UMKM assistance recipient data at the Cooperatives and Micro Enterprises Office of Kediri Regency is still carried out manually using Microsoft Excel, resulting in frequent data duplication in the NIK and NKK columns. Excel's limitation of accurately processing only up to 15 digits is a serious obstacle because NIK consists of 16 digits, risking digit truncation that causes data inaccuracy and inaccurate aid distribution. This study aims to design and build a Flutter-based desktop application capable of detecting duplicate NIK or NKK data automatically, accurately, and informatively. The method used is Research and Development (R&D) with the Sugiyono development model simplified into eight stages, along with the Exact Matching algorithm based on HashMap which has O(n) time complexity. System testing was conducted using the Black Box Testing method through ten test scenarios covering file validation, NIK/NKK duplicate detection, result export, and application reset. The results showed that the application successfully detected all duplicate data with 100% accuracy and was able to process Excel files containing 5,000 rows of data in less than 1 second, much faster than the manual method which takes 2 to 3 hours. All ten Black Box Testing scenarios were declared successful (100% pass rate). The implication of this research is the availability of an appropriate technical solution that can be directly used by staff to accelerate data validation, and can serve as a reference for developing similar systems in other government institutions facing similar data duplication problems.
References
Andrea Liui, F., & Putra Priyanto, G. (2025). GOOGLE DORKING DAN RISIKO KEBOCORAN DATA: STUDI KEAMANAN WEBSITE PENDIDIKAN DI INDONESIA. In Etika Teknologi Informasi (Vol. 1).
Anggia Utami, & A. Saehan. (2022). Penerapan Algoritma Turbo Boyer Moore Pada Aplikasi Perbandingan Harga Laptop Menggunakan Web. https://ejurnal.amikstiekomsu.ac.id/index.php/BIIT
Arif Sidik., Rini Indriati., & M. Najibulloh. (2022). Sistem Informasi Validasi Data Kependuduk. SEMNASINOTEK. https://repository.unpkediri.ac.id/8314/
Debiyanti, D., Sutrisna, S., Budrio, B., Kamal, A. K., & Yulianti, Y. (2020). Pengujian Black Box pada Perangkat Lunak Sistem Penilaian Mahasiswa Menggunakan Teknik Boundary Value Analysis. Jurnal Informatika Universitas Pamulang, 5(2), 162. https://doi.org/10.32493/informatika.v5i2.5446
Efriani, L., Rama Sanjaya, M., Paradina, S., Pronika, G., Angraini, L., & Farhan Ghifari, M. (2025). Pengembangan Aplikasi Mobile Untuk Meningkatkan Minat Belajar Matematika Anak Berbasis Research and Development. https://doi.org/10.59818/jpi.v5i4.1909
Fahmi, Y., & Sutaji, D. (2025). RANCANG BANGUN DATA FLOW DIAGRAM (DFD) UNTUK SISTEM PELAYANAN MASYARAKAT BERBASIS WHATSAPP. Jurnal Informatika Dan Teknik Elektro Terapan, 13(3S1). https://doi.org/10.23960/jitet.v13i3S1.8083
Fauziah, N. (2025). Implementasi Microsoft Excel dalam Mendukung Sistem Informasi Akuntansi pada Era Digital: Studi Literatur. 1, 2026.
Gunawan, & Aji Sudarsono. (2022). Penerapan Exact String Matching Pencarian Data Pada Sistem Informasi Akademik Berbasis Web. Volume, 5, 214–218. https://doi.org/https://doi.org/10.53513/jsk.v5i2.5793
Hanifah, N., Irwan, M., & Nasution, P. (2025). Manajemen Data Yang Efektif: Solusi Untuk Mencegah dan Mengatasi Duplikasi Data Dalam Perusahaan. Epsilon : Journal of Management (EJoM), 3(1). https://doi.org/10.62951
Ismail Setiawan, & Aisyah Mutia Dawis. (2023). DATA SCIENCE: PENDEKATAN DAN LANGKAH PRAKTIS DENGAN EXCEL. Journal of Innovation And Future Technology (IFTECH), 5(1), 11-22. Ejournal.Lppm-Unbaja.Ac.Id.
Machfud, S. (2024). Perancangan Sistem Informasi Penduduk Berbasis Desktop. Spectrum: Multidisciplinary Journal, 1(3).
Maulidah, N., Nalatissifa, H., Suseno, K. A., Aqilah, S. R., & Winasti, T. (2025). Deteksi Dini Penyakit Ginjal Kronis Dengan Menggunakan Algoritma Deep Learning. Indonesian Journal on Software Engineering (IJSE), 11(2), 54–63. https://jurnal.bsi.ac.id/index.php/ijse
Mayola, L., Hafizh, M., & Putra, D. M. (2024). Perancangan Aplikasi Similarity Deteksi Kemiripan Judul Disertasi Berbasis Web. Jurnal Teknologi Dan Sistem Informasi Bisnis, 6(2), 452–257. https://doi.org/10.47233/jteksis.v6i2.1164
Microsoft. (2024). Floating-point arithmetic may give inaccurate results in Excel. https://learn.microsoft.com/en-us/troubleshoot/microsoft-365-apps/excel/floating-point-arithmetic-inaccurate-result
Mita, K. R., Dewi, R., Indah, P., & Putri, D. (2024). Peningkatan Akurasi Data Wajib Pajak Melalui Implementasi Double Checking Portal NIK pada UPTD Kuta Selatan Increasing the Accuracy of Taxpayer Data Through the Implementation of Double Checking NIK Portal at UPTD South Kuta. In Abdimas Galuh (Vol. 6, Number 2).
Muhammad, M., Sucipto, S., Muzaki, M. N., & Andriyanto, S. (2024). Implementasi Sistem Informasi Berbasis Web untuk Pengelolaan Kedisiplinan Santri di Pondok Pesantren. JSITIK: Jurnal Sistem Informasi Dan Teknologi Informasi Komputer, 3(1), 39–52. https://doi.org/10.53624/jsitik.v3i1.529
Nurdiansyah, F., Daniati, E., & Ristyawan, A. (2022). PENGEMBANGAN SISTEM INFORMASI KASIR APOTEK DENGAN METODE WATERFALL. EDUSAINTEK: Jurnal Pendidikan, Sains Dan Teknologi, 9(3), 752–773. https://doi.org/10.47668/edusaintek.v9i3.550
Okpatrioka. (2023). Research And Development (R&D) Penelitian Yang Inovatif Dalam Pendidikan. https://doi.org/https://doi.org/10.47861/jdan.v1i1.154
Olivia Odja, M., Likadja, F. J., Ina, W. T., & Pella, S. I. (2021). Penggunaan Microsoft Excel untuk Kemudahan Pengolahan Data Nilai Hasil Belajar Siswa. In ABDIMAS |Jurnal LPPM UNDANA: XV (Number 2).
Pratama, E. B., & Saparingga, U. (2021). Pemodelan UML Sistem Informasi Administrasi Kependudukan Untuk Kantor Desa. Jurnal Ilmiah Media Sisfo, 15(2), 107–118. https://doi.org/10.33998/mediasisfo.2021.15.2.1085
Purwoko, H., Jaya Tama, B., & Arif, S. M. (2025). Kapas : Kumpulan Artikel Pengabdian Masyarakat Menggali Potensi Flutter: Pelatihan Intensif Pengembangan Aplikasi Multiplatform untuk Komunitas Belajar Bareng (Vol. 3, Number 3).
Risal, Z. , H. R. , & A. A. R. (2023). Metode Penelitian dan Pengembangan Research and Development (R&D)–Konsep, Teori-Teori, dan Desain Penelitian.
RIVAL FAKHRI AMRULLAH. (2023). STRATEGI ALGORITMA ALGORITMA PENCARIAN IF-3A.
Setiawan, P. R., Ramadhan, R. A., Labellapansa, D. A., Koresponden, P., Panji, :, & Setiawan, R. (2022). Jurnal Pengabdian Masyarakat dan Penerapan Ilmu Pengetahuan Pelatihan Pemrograman Flutter.
Valerian, A., Bernady, D., Wahyudi, F., Dinatha, J. P., & Barletyano, D. (2025). IMPLEMENTASI UNIT TESTING, INTEGRATION TESTING, SYSTEM TESTING, DAN VALIDATION TESTING PADA APLIKASI BERBASIS WEBSITE (STUDI KASUS: KAFE SATURDAYS). In Jurnal Mahasiswa Teknik Informatika) (Vol. 9, Number 4).
Wijaya, D. K. (2025). MANAJEMEN PENGELOLAAN REKAM MEDIS DALAM MENGATASI MASALAH DATA GANDA PASIEN DI PUSKESMAS GENUK KOTA SEMARANG (Doctoral dissertation, Universitas Ivet). https://eprint.ivet.ac.id/id/eprint/1206
Downloads
Published
Issue
Section
License
Copyright (c) 2026 JURNAL ILMIAH SAINS TEKNOLOGI DAN INFORMASI
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
