Pemanfaatan Platform Google Spreadsheet dalam Pengembangan Sistem Laporan Marker
Abstract
Manual marker reporting at PT Anugerah Guna Abadi causes delays and data redundancy, hindering operational efficiency. This study aims to implement a desktop-based marker reporting application integrated with Google Spreadsheet to improve data efficiency, accuracy, and collaboration. The Research and Development (R&D) method with the Waterfall model was used to develop the system using VB.NET and the Google Sheets API. Testing covered functionality (blackbox), usability (SUS), and performance comparison with the manual system. The results showed the system successfully reduced processing time by 88.3% (from 18 to 2.1 minutes/transaction), decreased data error rates by 96.4% (from 18.67% to 0.67%), and enabled real-time collaboration with an SUS score of 84.7 (excellent). This research introduces a novel hybrid desktop-cloud architecture for marker reporting in the garment industry.
Keywords: Marker reporting; Desktop application; Data synchronization; Real-time collaboration; garment industry
Abstrak
Pelaporan marker manual di PT Anugerah Guna Abadi menyebabkan keterlambatan dan redundansi data, sehingga menghambat efisiensi operasional. Penelitian ini bertujuan mengimplementasikan aplikasi laporan marker berbasis desktop terintegrasi Google Spreadsheet untuk meningkatkan efisiensi, akurasi, dan kolaborasi data. Metode Research and Development (R&D) dengan model Waterfall digunakan untuk pengembangan sistem menggunakan VB.NET dan Google Sheets API. Pengujian mencakup fungsionalitas (blackbox), usabilitas (SUS), dan perbandingan kinerja dengan sistem manual. Hasil penelitian menunjukkan sistem berhasil mengurangi waktu proses sebesar 88,3% (dari 18 menjadi 2,1 menit/transaksi), menurunkan tingkat kesalahan data sebesar 96,4% (dari 18,67% menjadi 0,67%), dan memungkinkan kolaborasi real-time dengan skor SUS 84,7 (excellent). Penelitian ini menghasilkan kebaruan berupa arsitektur hybrid desktop-cloud untuk pelaporan marker di industri garmen.
Keywords
References
K. C. Laudon dan J. P. Laudon, Management Information Systems: Managing the Digital Firm, 17th ed. London: Pearson Education, 2022.
T. W. Andrianto dan M. F. R. Hakim, "Implementasi API Google Sheets untuk Sistem Pelaporan Real-Time pada Industri Garmen," Jurnal Sistem Informasi, vol. 15, no. 2, pp. 89-102, 2022. DOI: 10.21609/jsi.v15i2.1054
M. Maimun, "Evaluation of the use of cloud computing technology in managing organizational information systems," Jurnal Ilmiah Ekonomi dan Manajemen, vol. 10, no. 1, pp. 15-25, 2023. [Online]. Tersedia:https://jurnal.stmikiba.ac.id/ index.php/jiem/article/view/72
D. Purwanto, "Pemanfaatan spreadsheet (Google Sheets) dalam pengembangan sistem informasi inventaris peralatan pada Gereja XYZ di Kota Salatiga," Jurnal Berdikari, vol. 2, no. 3, pp. 112-120, 2024.[Online]. Tersedia:https://journal.umy.ac.id/ index.php/berdikari/article/view/25430
A. Anwar, T. Rahman, dan M. Fadillah, "Development of a cloud computing-based collaboration information system," Jurnal AIEA, vol. 6, no. 2, pp. 45–53, 2024. [Online]. Tersedia: https://www.ioinformatic.org/index.php/JAIEA/article/view/692
H. Wang dan L. Wang, "Modern information systems characteristics for manufacturing industries," Journal of Manufacturing Technology Management, vol. 32, no. 4, pp. 512-525, 2021.
T. Subekti, H. Wijaya, dan A. Santoso, "Online spreadsheet for error reduction in manufacturing data entry," Industrial Data Systems Journal, vol. 9, no. 1, pp. 34-42, 2022.
A. Alwan dan R. Rahmadana, "Desktop application development for industrial operational systems: A case study in manufacturing," Journal of Industrial Informatics, vol. 8, no. 2, pp. 45-53, 2021.
R. A. Santoso, D. K. Sari, dan A. Wibowo, "Optimasi Sistem Kolaborasi Berbasis Cloud Computing pada Industri Manufaktur Skala Menengah," Jurnal Teknologi Informasi dan Ilmu Komputer, vol. 10, no. 3, pp. 521-532, 2023. DOI: 10.25126/jtiik.2023103521
A. B. Prasetio dan R. D. Wahyuni, "Arsitektur Hybrid Desktop-Cloud untuk Sistem Informasi Produksi: Studi Kasus Industri Tekstil," Jurnal Informatika, vol. 19, no. 1, pp. 23-36, 2023. DOI: 10.26555/jifo.v19i1.a25789
N. A. Sari dan F. Gunawan, "Digital Transformation in Garment Industry: Implementation of Information Systems for Production Reporting," International Journal of Emerging Technologies and Innovative Research, vol. 9, no. 5, pp. 234-245, 2022.
D. Hermawan dan S. Pratama, "Sistem Validasi Data Otomatis untuk Mengurangi Human Error pada Input Data Produksi," Jurnal Ilmu Komputer dan Teknologi, vol. 8, no. 2, pp. 67-78, 2023. DOI: 10.35134/jikt.v8i2.125
H. Nugroho dan R. Sari, "Hybrid desktop-cloud system design for manufacturing data management," International Journal of Information Systems, vol. 5, no. 3, pp. 112-120, 2022.
W. Witanti, "The role of cloud computing technology in increasing work flexibility in the hybrid era," Management Science Journal, vol. 5, no. 1, pp. 41–49, 2024. [Online]. Tersedia: https://jurnalhafasy.com/index.php/msj/article/view/443
Google Developers, Google Sheets API documentation, 2024. [Online]. Tersedia: https://developers.google.com/sheets/api
P. S. Amalia, A. F. Nugroho, dan R. Kusuma, "Optimizing data management in web applications through Google Drive API integration and synchronization," Journal of Information and Computing Organization (JICO), vol. 2, no. 1, pp. 30–38, 2024. [Online]. Tersedia: https://iaico.org/index.php/JICO/article/view/4
S. Rahmawati dan A. Putra, "Google Sheets API for real-time reporting systems," Journal of Computing Applications, vol. 4, no. 2, pp. 78-85, 2021.
R. S. Pressman, Software Engineering: A Practitioner's Approach, 9th ed. New York: McGraw-Hill Education, 2021.
J. Sauro, "10 Things to Know About the System Usability Scale," MeasuringU, 2021. [Online]. Tersedia: https://measuringu.com/10-things-sus/ [Diakses: 15 Jan. 2025].
J. Sauro, "5 Ways to Interpret a SUS Score," MeasuringU, 2021. [Online]. Tersedia: https://measuringu.com/interpret-sus-score/ [Diakses: 15 Jan. 2025].
T. T. Tran, D. T. Nguyen, dan H. L. Pham, "Research and Development Methodology for Software Engineering Projects: A Systematic Approach," International Journal of Software Engineering and Knowledge Engineering, vol. 31, no. 5, pp. 645-662, 2021.
How To Cite This :
Refbacks
- There are currently no refbacks.
