Article Per Year (5 Year)
p-Index From 2020 - 2025
0.23
P-Index
This Author published in this journals
All Journal Serambi Engineering
Nerissa Arviana Putri
Electrical Engineering Study Program, Faculty of Electrical Engineering, Telkom University, Bandung – West Java, Indonesia
Earth & Planetary Sciences Energy Engineering Environmental Science Industrial & Manufacturing Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Designing a Spreadsheet-Based Reverse Vending Machine (RVM) Database Using Arduino Mega 2560 and NodeMCU with App Script Integration Nerissa Arviana Putri; Arniel Ahmad Rivai; Rifki Athaya; Mohamad Ramdhani; Dien Rahmawati
Jurnal Serambi Engineering Vol. 9 No. 3 (2024): Juli 2024
Publisher : Faculty of Engineering, Universitas Serambi Mekkah

Show Abstract | Download Original | Original Source | Check in Google Scholar

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
Co-Authors Arniel Ahmad Rivai Dien Rahmawati Mohamad Ramdhani Rifki Athaya