Electric Power Monitoring And Management Control System With Google Sheets As Data Storage
Sistem Monitoring dan Manajemen Kontrol Daya Listrik Dengan Google Sheet Sebagai Penyimpan Data
DOI:
https://doi.org/10.21070/ups.7902Keywords:
ESP32, PZEM-004T, Google Sheet, kwh MeterAbstract
As Indonesia's electricity consumption increases, the need for efficient energy management increases. The purpose of this research is to create a system to track and manage electric power control based on ESP32 and PZEM-004T sensors. Google Sheets is used as data storage. The system has the ability to measure voltage, current, and electrical power in real-time and transmit the data via WiFi connection. In addition, the system has a buzzer feature that will notify you when the amount of available power is running low. Test results show that the system can record data with a high degree of accuracy, transmit data with a delay of less than five seconds, and help manage electricity consumption clearly and effectively. Based on Internet of Things (IoT) technology, the system offers a practical solution for monitoring and managing electricity usage in boarding houses and households.
Downloads
References
M. Zaini and M. Bachrudin, “Perancangan Sistem Monitoring Tegangan, Arus Dan Frekuensi Pada Pembangkit Listrik Tenaga Mikrohidro Berbasis Iot.”
A. Wisaksono and C. A. Ragil, “Design and Development of Parking Motor Parking Information System at Muhammadiyah University, Sidoarjo,” in IOP Conference Series: Materials Science and Engineering, Institute of Physics Publishing, Jul. 2020. doi: 10.1088/1757-899X/874/1/012015.
A. Wisaksono, Y. Purwanti, N. Ariyanti, and M. Masruchin, “Design of Monitoring and Control of Energy Use in Multi-storey Buildings based on IoT,” JEEE-U (Journal of Electrical and Electronic Engineering-UMSIDA), vol. 4, no. 2, pp. 128–135, Jun. 2020, doi: 10.21070/jeeeu.v4i2.539.
A. Furqon, A. B. Prasetijo, and E. D. Widianto, “Rancang Bangun Sistem Monitoring dan Kendali Daya Listrik pada Rumah Kos Menggunakan NodeMCU dan Firebase Berbasis Android.”
P. Alat Perbaikan Faktor, I. Sulistiyowati, and A. Wisaksono, “Perancangan Alat Perbaikan Faktor Listrik Rumah Tangga Dengan Monitoring Telegram,” JEECOM, vol. 5, no. 1, 2023.
A. Wisaksono and M. N. Novian, “Earthquake monitoring system based on Wemos D1 Mini with notification via WhatsApp,” in IOP Conference Series: Earth and Environmental Science, Institute of Physics, 2022. doi: 10.1088/1755-1315/1104/1/012029.
A. Mubarak ’aafi, J. Jamaaluddin, I. Anshory, and U. M. Sidoarjo, “SNESTIK Seminar Nasional Teknik Elektro, Sistem Informasi, dan Teknik Informatika Implementasi Sensor Pzem-017 Untuk Monitoring Arus, Tegangan dan Daya Pada Instalasi Panel Surya dengan Sistem Data Logger Menggunakan Google Spreadsheet dan Smartphone,” p. 191, doi: 10.31284/p.snestik.2022.2718.
“Sistem Monitoring Meteran Listrik Berbasis Iot Untuk Listrik Prabayar,” 2022.
A. ’ Ari, F. Ahmad, and M. F. Amrullah, “Implementasi Perancangan Sistem Kontrol Dan Monitoring Instalasi Otomasi Panel Listrik Industri Menggunakan IOT Berbasis Mobile.” [Online]. Available: https://ejournal.catuspata.com/index.php/jkdn/index
A. Mubarak ’aafi, J. Jamaaluddin, I. Anshory, and U. M. Sidoarjo, “SNESTIK Seminar Nasional Teknik Elektro, Sistem Informasi, dan Teknik Informatika Implementasi Sensor Pzem-017 Untuk Monitoring Arus, Tegangan dan Daya Pada Instalasi Panel Surya dengan Sistem Data Logger Menggunakan Google Spreadsheet dan Smartphone,” p. 191, doi: 10.31284/p.snestik.2022.2718.
R. Arief, W. Aribowo, R. Rahmadian, and A. Chandra Hermawan, “Monitoring Arus dan Tegangan Pada Pembangkit Listrik Tenaga Angin Menggunakan ESP8266 Berbasis Node-Red.”
A. Wiesesha and A. Ridhoi, “Rancang Bangun Monitoring Listrik Pada Rumah Berbasis Iot Menggunakan Esp32.”
A. R. C. Baswara and R. Alfaqi, “Rancang Bangun Sistem Monitoring Pembangkit Listrik Tenaga Mikro Hidro Berbasis Internet Of Things (IoT),” Jurnal Teknologi Elektro, vol. 14, no. 1, p. 39, Feb. 2023, doi: 10.22441/jte.2023.v14i1.008.
K. A. Yasa, I. M. Purbhawa, I. M. Sumerta Yasa, I. W. Teresna, A. Nugroho, and S. Winardi, “Prototype Pemantauan Konsumsi Energi Listrik pada Firebase Menggunakan PZEM-004T,” Jurnal Eksplora Informatika, vol. 12, no. 2, pp. 104–112, Dec. 2023, doi: 10.30864/eksplora.v12i2.993.
Y. Prabowo, A. Narendro, T. Wisjhnuadji, and F. Teknologi Informasi, “Uji Akurasi Modul KWH Meter Digital PZEM-004T Berbasis Pengendali Digital ESP32,” SKANIKA: Sistem Komputer dan Teknik Informatika, vol. 6, no. 1, pp. 85–96, 2023.
I. Made et al., “Rancang Bangun Sistem Monitoring Panel Listrik Dan Kontrol Listrik Kos Berbasis Iot,” vol. 2, no. 1, 2022, [Online]. Available: https://ejournal.catuspata.com/index.php/jkdn/index
Downloads
Additional Files
Posted
License
Copyright (c) 2025 UMSIDA Preprints Server
This work is licensed under a Creative Commons Attribution 4.0 International License.
