Designing a Spreadsheet-Based Reverse Vending Machine (RVM) Database Using Arduino Mega 2560 and NodeMCU with App Script Integration

Main Article Content

Nerissa Arviana Putri
Arniel Ahmad Rivai
Rifki Athaya
Mohamad Ramdhani
Dien Rahmawati

Abstract

This research discusses the database design for a spreadsheet based payment system using Arduino Mega 2560 and NodeMCU ESP8266 with the help of an app script on a Reverse Vending Machine (RVM) with non-cash rewards. The payment process on the RVM requires admin assistance, so a platform is needed to store data, including the user's mobile phone number and the rewards the user has received. The database allows administrators to check this data to process reward payments to users. Spreadsheet is the platform the author chose for the database because it is easy to use and flexible. Designing a spreadsheet as a database using serial communication between Arduino Mega 2560 and NodeMCU ESP8266. Apart from this, the design also requires the help of the App Script feature to store the user's mobile phone number data and rewards received in a spreadsheet. The design results show that this database is effective and efficient in connecting the RVM with a spreadsheet to store data, thereby reducing the administrative workload in the payment process from the RVM.

Article Details

How to Cite
[1]
Nerissa Arviana Putri, Arniel Ahmad Rivai, Rifki Athaya, Mohamad Ramdhani, and Dien Rahmawati, “Designing a Spreadsheet-Based Reverse Vending Machine (RVM) Database Using Arduino Mega 2560 and NodeMCU with App Script Integration”, JSE, vol. 9, no. 3, Jul. 2024.
Section
Articles

References

R. Peraturan Pemerintah, “Undang Undang Republik Indonesia Nomor 18 Tahun 2008 Tentang Pengelolaan Sampah,” Lembaga Negara Republik Indonesia, no. 18. pp. 6–11, 2008.

D. Mariya, “Reverse Vending Machine for Plastic Bottle Recycling,” Int. J. Comput. Sci. Trends Technol., vol. 8, no. 2, pp. 65–70, 2020.

R. Tomari, A. A. Kadir, W. N. W. Zakaria, M. F. Zakaria, M. H. A. Wahab, and M. H. Jabbar, “Development of Reverse Vending Machine (RVM) Framework for Implementation to a Standard Recycle Bin,” Procedia Comput. Sci., vol. 105, pp. 75–80, 2016.

Juansah, M. Ramdhani, and D. Rahmawati, “Integration of a Reverse Vending Machine Sensing System in Sorting and Detecting Plastic Bottle Waste,” in Lecture Notes in Electrical Engineering, Singapore: Springer Nature Singapore, 2024, pp. 409–426.

M. W. Karim, A. Haque, M. A. Ulfy, M. A. Hossain, and M. Z. Anis, “Factors Influencing the Use of E-wallet as a Payment Method among Malaysian Young Adults,” J. Int. Bus. Manag., vol. 3, no. 2, pp. 1–11, 2020.

W. Alam, D. Sarma, R. J. Chakma, M. J. Alam, and S. Hossain, “Internet of things based smart vending machine using digital payment system,” Indones. J. Electr. Eng. Informatics, vol. 9, no. 3, pp. 719–731, 2021.

J. Tyszkiewicz, “Spreadsheet as a relational database engine,” Proc. ACM SIGMOD Int. Conf. Manag. Data, pp. 195–206, 2010.

A. Iskandar, M. Muhajirin, and L. Lisah, “Sistem Keamanan Pintu Berbasis Arduino Mega,” J. Inform. Upgris, vol. 3, no. 2, pp. 99–104, 2017.

S. Ginting, J. W. Simatupang, I. Bukhori, and E. R. Kaburuan, “Monitoring of Electrical Output Power-Based Internet of Things for Micro-Hydro Power Plant,” 2018 Int. Conf. Orange Technol. ICOT 2018, no. October, pp. 1–7, 2018.

M. R. Hidayat, C. Christiono, and B. S. Sapudin, “Perancangan Sistem Keamanan Rumah Berbasis IoT dengan NodeMCU ESP8266 Menggunakan Sensor PIR HC-SR501 dan Sensor Smoke Detetctor,” Kilat, vol. 7, no. 2, pp. 139–148, 2018.

S. Mahmood, S. Alani, F. Hasan, and M. Mustafa, “ESP 8266 Node MCU Based Weather Monitoring System,” no. January, 2020.

V. Itikala, “Arduino Weighing Machine Using Load Cell and HX711 Module,” SSRN Electron. J., 2021.

J. W. Simatupang and A. Aziz Ar-Rafif, “Prototype of A Smart Trash Bin for Trash Composting Based on Load Cell HX711 and Ultrasonic Sensors,” J. Serambi Eng., vol. IX, no. 1, pp. 8289–8301, Feb. 2024.

G. Hergika, Siswanto, and S. S, “Perancangan Internet of Things (Iot) Sebagai Kontrol Infrastuktur Dan Peralatan Toll Pada Pt. Astra Infratoll Road,” PROSISKO J. Pengemb. Ris. dan Obs. Sist. Komput., vol. 8, no. 2, pp. 86–98, 2021.

I. Adi Kuncara, J. Endro Suseno, S. Agus, and I. Gunadi, “Development of Ultrasonic Anemometer Using HC-SR04 with Kalman Filter Based on Microcontroller Integrated IoT,” E3S Web Conf., vol. 202, 2020.

D. Suprihanto, H. Nugroho, A. E. Burhandenny, A. Harjanto, and M. Akbar, “Prototype of the Internet of Things-Based Swallow Building Monitoring and Security System,” J. Tek. Inform., vol. 4, no. 1, pp. 131–141, 2023.

S. SOTYOHADI, “Rancangan dan Implementasi Sistem Absensi dengan Sensor Fingerprint dan Sensor Suhu Non–Contact Berbasis IoT Menggunakan Google Sheets,” ALINIER J. Artif. Intell. Appl., vol. 2, no. 1, pp. 28–35, 2021.

W. Tri Rahajoeningroem, “Sistem Keamanan Rumah Dengan Monitoring Menggunakan Jaringan Telepon Selular,” Telekontran, vol. 1, no. 1, 2013.

A. E. Widodo and S. Suleman, “Otomatisasi Pemilah Sampah Berbasis Arduino Uno,” Indones. J. Softw. Eng., vol. 6, no. 1, pp. 12–18, 2020.

J. Ferreira, Google Apps Script: Web Application Development Essentials, vol. 4. 2016. Accessed: May 21, 2024.

S. Saniman and A. Pranata, “Otomatisasi Tingkat Kecerah Layar (Screen Brightness) Pada Laptop Menggunakan Teknik Komunikasi Serial Berbasis Arduino,” J. Saintikom (Jurnal Sains Manaj. Inform. dan Komputer), vol. 19, no. 1, p. 128, 2020.

A. A. Sahifa, R. Setiawan, and M. Yazid, “Pengiriman Data Berbasis Internet of Things untuk Monitoring Sistem Hemodialisis Secara Jarak Jauh,” J. Tek. ITS, vol. 9, no. 2, pp. 4–9, 2021