Sistem Monitoring Stok dan Penjualan Minuman pada Vending Machine berbasis Internet of Things (IoT) Menggunakan Google Sheets dan Kodular

Authors

  • Vicky Andria Kusuma Institut Teknologi Kalimantan
  • M. Ihsan Alfani Putra Institut Teknologi Kalimantan
  • Sena Sukmananda Suprapto Institut Teknologi Kalimantan

DOI:

https://doi.org/10.37034/jsisfotek.v4i3.136

Keywords:

Google, Sheets, Monitoring, Vending Machine, Internet of Things (IoT)

Abstract

Perkembangan teknologi membawa kemudahan dalam bertransaksi. Salah satunya adalah pembayaran digital dengan dompet elektronik. Untuk mengatasi masalah ini, Bank Indonesia (BI) pada tahun 2019 menciptakan standar pembayaran digital yang disebut QRIS. QRIS akan mulai banyak digunakan pada tahun 2020 saat melakukan pembayaran antara e-wallet dan bank  menggunakan kode QR. Dalam QR Code ini terdapat informasi mengenai pengenal dan penunjukan transaksi. Sayangnya, hanya sedikit orang yang menggunakan QRIS API untuk sistem pembayaran otomatis. Pada penelitian ini, monitoring system pada mesin penjual minuman otomatis akan termonitoring secara realtime dengan Internet of Things. Keamanan  sistem transaksi pembayaran digital dalam penelitian ini juga dipastikan seaman mungkin dengan menggunakan fitur QRIS yang selalu update setiap pembayaran dan menghindari kesalahan dalam tracking. Proses melakukan penelitian ini dimulai dengan pembuatan coding berbasis Google Sheets yang mana sistem akan berintegrasi dengan sistem perangkat keras.

References

Suprapto, SS, & Kusuma, VA (2022). Pengukuran Waktu Tunggu Verifikasi Transaksi Digital Otomatis Berbasis Quick Response Code Indonesian Standard (QRIS) Dynamic pada Rancang Bangun Vending Machine. SPECTA Journal of Technology, journal.itk.ac.id. https://journal.itk.ac.id/index.php/sjt/article/view/330

Wibowo, D, & Fahmi, F (2021). Contactless and Cashless Smart Vending Machine Integrated with Mobile Device. 2021 5th International Conference on Electrical, Telecommunication and Computer Engineering (ELTICOM), ieeexplore.ieee.org, https://doi.org/10.1109/ELTICOM53303.2021.9590103

Saputri, OB (2020). Preferensi konsumen dalam menggunakan quick response code indonesia standard (qris) sebagai alat pembayaran digital. KINERJA, journal.feb.unmul.ac.id, https://journal.feb.unmul.ac.id/index.php/KINERJA/article/view/7355

Buchta, K, Wójcik, P, Pelc, M, & Górowska, A. (2022). NUX IVE-a research tool for comparing voice user interface and graphical user interface in VR. 2022 IEEE Conference on Virtual Reality and 3D User Interfaces Abstracts and Workshops (VRW), ieeexplore.ieee.org, https://doi.org/10.1109/VRW55335.2022.00342

Karvelis, P, Salmas, D, & Stylios, C (2020). Monitoring real time the Arachthos River (Greece) using a Web GIS platform. 2020 International Conference on Information Technologies (InfoTech), ieeexplore.ieee.org, https://doi.org/10.1109/InfoTech49733.2020.9211016

Alejandrino, RS, Diomampo, MCG, & Balbin, JR. (2022). Smart Water Meter with Cloud Database and Water Bill Consumption Monitoring via SMS and Mobile Application. 2022 IEEE International Conference on Automatic Control and Intelligent Systems (I2CACIS), ieeexplore.ieee.org. https://doi.org/10.1109/I2CACIS54679.2022.9815483

Vijayalakshmi, VJ (2020). Centralized attendance monitoring system. 2020 6th International Conference on Advanced Computing and Communication Systems (ICACCS), ieeexplore.ieee.org. https://doi.org/10.1109/ICACCS48705.2020.9074162

Srilatha, M, Abhinav, C, Balaram, M, & Sanjana, A. (2021). Smart Monitoring and Collection of Garbage System Using Internet of Things. 2021 Third International Conference on Intelligent Communication Technologies and Virtual Mobile Networks (ICICV), ieeexplore.ieee.org. https://doi.org/10.1109/ICICV50876.2021.9388438

Asyhari, MW, Sigit, R, & Sukaridhoto, S. (2019). Vending Machine Monitoring System Integrated with Webserver. 2019 International Electronics Symposium (IES), ieeexplore.ieee.org. https://doi.org/10.1109/ELECSYM.2019.8901588

itzkal, R, Aziz, AA, Kusumah, FSF, & Kodarsyah, K (2022). Web and Arduino Automatic Selling Machine Monitoring Prototype. Jurnal Mantik, iocscience.org. https://iocscience.org/ejournal/index.php/mantik/article/view/2053

Anupindi, R, Dada, M, & Gupta, S (1998). Estimation of consumer demand with stock-out based substitution: An application to vending machine products. Marketing Science, pubsonline.informs.org. https://doi.org/10.1287/mksc.17.4.406

Thompson, OM, Yaroch, AL, & Moser, RP. (2010). School vending machine purchasing behavior: results from the 2005 YouthStyles survey. Journal of School Health, Wiley Online Library. https://doi.org/10.1111/j.1746-1561.2010.00494.x

Utter, J, & McCray, S (2021). Vending Machines in Australian Hospitals: Are They Meeting the Needs of the Consumer?. Journal of Nutrition Education and Behavior, Elsevier. https://doi.org/10.1016/j.jneb.2020.11.013

Garg, H, & Dave, M (2019). Securing iot devices and securely connecting the dots using rest api and middleware. 2019 4th International Conference on Internet of Things: Smart Innovation and Usages (IoT-SIU), ieeexplore.ieee.org, https://doi.org/10.1109/IoT-SIU.2019.8777334

Rahmah, A, & Sukmasetya, P. (2020). Developing distance learning monitoring dashboard with Google sheet: An approach for flexible and low-price solution in pandemic era. 2020 International Conference on ICT for Smart Society (ICISS), ieeexplore.ieee.org, https://doi.org/10.1109/ICISS50791.2020.9307558

Arunyagool, D, Chamnongthai, K, & Khawparisuth, D. (2021). Monitoring and Energy Control Inside Home Using Google Sheets with Line Notification. 2021 International Conference on Power, Energy and Innovations (ICPEI), ieeexplore.ieee.org. https://doi.org/10.1109/ICPEI52436.2021.9690648

Handayani, I, Kusumahati, H,(2017). Pemanfaatan Google Spreadsheet Sebagai Media Pembuatan Dashboard pada Official Site iFacility di Perguruan Tinggi. Sisfotenika, sisfotenika.stmikpontianak.ac.id. http://dx.doi.org/10.30700/jst.v7i2.155

Purnadi, H (2021). PEMANFAATAN GOOGLE SPREADSHEET DAN GOOGLE DATA STUDIO SEBAGAI DASHBOARD SUHU DAN KELEMBABAN DI LABORATORIUM. Insan Metrologi PPSDK, jurnal.kemendag.go.id. https://doi.org/10.55101/ppsdk.v1i1.639

Mubarak'Aafi, A, Jamaaluddin, J, & Anshory, I. (2022). Implementasi Sensor Pzem-017 Untuk Monitoring Arus, Tegangan dan Daya Pada Instalasi Panel Surya dengan Sistem Data Logger Menggunakan Google Spreadsheet dan Smartphone. Seminar Nasional Teknik Elektro, Sistem Informasi, dan Teknik Informatika, ejournal.itats.ac.id. https://doi.org/10.31284/p.snestik.2022.2718

Putera, MIAP, Azhar, NF, & Mujahidin, S. (2021). PENGEMBANGAN SMART SERVICE VILLAGE SYSTEM (SSVS) DALAM MENDUKUNG SMART GOVERNANCE MENGGUNAKAN METODE PERSONAL EXTREME PROGRAMMING METHOD. Antivirus: Jurnal Ilmiah Teknik Informatika, ejournal.unisbablitar.ac.id, https://doi.org/10.35457/antivirus.v15i2.1824

Downloads

Published

03-08-2022

How to Cite

Kusuma, V. A., Putra, M. I. A. ., & Suprapto, . S. S. (2022). Sistem Monitoring Stok dan Penjualan Minuman pada Vending Machine berbasis Internet of Things (IoT) Menggunakan Google Sheets dan Kodular. Jurnal Sistim Informasi Dan Teknologi, 4(3), 94–98. https://doi.org/10.37034/jsisfotek.v4i3.136

Issue

Section

Articles