Pembuatan Aplikasi Peyimpanan Peraturan Perusahaan Berbasis Visual Basic di PT XYZ Divisi HCGS
DOI:
https://doi.org/10.56910/sewagati.v4i2.2160Keywords:
Data Management, Excel VBA, Information System, Regulatory Archives.Abstract
The utilization of information technology in the digital era is an important factor in supporting company operational activities, including in managing regulatory data. PT XYZ Human Capital General Support (HCGS) Division currently still uses an ordinary excel-based regulatory data storage system that only contains links to external websites and for internal regulations originating from within the company. This system has several disadvantages, such as dependence on internet connection, risk of unavailability of documents when needed, and lack of effectiveness in searching data and documents. Regulations fall into the category of vital archives, thus requiring a structured and reliable management system. This project aims to design an excel VBA-based company regulation data storage and management application to increase the effectiveness and ease of access to documents. Tests were carried out using the black box testing method and distributing questionnaires with evaluation indicators, referring to the five aspects of usability testing, namely learnability, efficiency, memorability, errors, satisfaction. The evaluation results show that this application has met user needs and functions as expected. The results of this project are expected to provide benefits for both the author, company, and academic parties as an applicable and sustainable digital solution.
References
Alvionita, C. V., Zein, E. R., & Gunawan, G. (2024). Perancangan aplikasi retensi dokumen rekam medis berbasis VBA Excel di RSUD Nganjuk. Jurnal Pendidikan Teknologi Informasi (JUKANTI), 7(1), 137–146. https://doi.org/10.37792/jukanti.v7i1.1266
Danuri, M. (2019). Perkembangan dan transformasi teknologi digital. Jakarta: Manajemen Informatika, Teknologi Cipta Semarang.
Grayson, M., Nagle-Pinkham, D., Gokhman, D., & Ruparel, S. (2021). Automated analyses for single-fiber electrophysiological recordings using a newly developed Microsoft Excel application and graphical user interface. Journal of Neuroscience Methods, 362(August), 109312. https://doi.org/10.1016/j.jneumeth.2021.109312
KBBI. (n.d.). Peraturan - Kamus Besar Bahasa Indonesia (KBBI) Online. Retrieved January 20, 2025, from https://kbbi.kemdikbud.go.id/entri/Peraturan
Murdiani, D., & Sobirin, M. (2022). Perbandingan metodologi waterfall dan RAD dalam pengembangan sistem informasi. JINTEKS (Jurnal Informatika Teknologi dan Sains), 4(4), 302–306.
Purnama, M. R. T., Gaffar, M. R., Pramono, T. D., & Firmansyah, Y. (2022). Pembuatan aplikasi pengarsipan elektronik berbasis macro VBA Excel pada Bank Woori Saudara Kantor Cabang Diponegoro. Applied Business and Administration Journal, 1(3), 31.
Rohman, M., & Darmaningrum, K. T. (2024). Pemanfaatan teknologi digital dalam meningkatkan kesejahteraan masyarakat pesisir. Jurnal, 4(1), 30–40.
Romeo, G. (2020). Excel VBA, Solver, and other advanced worksheet tools. In Elements of numerical mathematical economics with Excel (pp. 3–44). Elsevier.
Sazaki, Y., Putra, P., Putera, A., Kurnia, R. D., Zarkasih, Z., & Yunita, Y. (2023). Aplikasi pembayaran kuota siswa berbasis VBA Macro Excel pada SMA Negeri 3 Banyuasin III Sumatera Selatan. Jurnal Pendidikan Sains dan Komputer, 3(1), 130–144. https://doi.org/10.47709/jpsk.v3i01.2582
Takayanagi, T. (2023). Estimating parameter values and initial states of variables in a mathematical model of Coronavirus Disease 2019 epidemic wave using the least squares method, Visual Basic for Applications, and Solver in Microsoft Excel. Computer Methods and Programs in Biomedicine Update, 4(January), 100111. https://doi.org/10.1016/j.cmpbup.2023.100111
Weichbroth, P. (2020). Usability of mobile applications: A systematic literature study. IEEE Access, 8, 55563–55577. https://doi.org/10.1109/ACCESS.2020.2981892
Wicaksono, Y. (2021). Membuat aplikasi kasir dengan VBA Macro Excel (1st ed.). Jakarta: PT Elex Media Komputindo.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2025 SEWAGATI: Jurnal Pengabdian Masyarakat Indonesia
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
