Monitoring Konsumsi Daya Listrik Menggunakan Google Spreadsheet
Abstract views: 0
,
Abstract
The lack of detailed information on the daily electricity consumption of each electronic device can hinder the accurate calculation of electricity consumption costs. This can affect the accuracy and ease of access to electricity consumption data. This research aims to develop an electric power reading system using the PZEM-004T sensor, an electricity power monitoring system, and the cost of electricity usage through Google Sheets. The system is designed to measure current, voltage, power, and electricity costs with high accuracy. The test results show that the KWH meter reading system can measure electricity consumption using the PZEM-004T sensor with accuracy values of 99.805% for voltage (volts), 89.71% for current (amperes), and 99.98% for power (watts) in each test. The data from the sensor monitoring system and cost calculations can be effectively displayed on Google Sheets, which functions well for measuring and displaying data for current, voltage, power, and electricity billing.
References
R. N. Kurniawan, R. Munadi, and I. H. Santoso, “Sistem Monitoring KWh Meter Dengan Media Komunikasi Instan Messaging Whatsapp Berbasis Internet of Things -KWh Meter Monitoring System Using Messaging Whatsapp Communication Media Based on Internet of Things,” e-Proceeding Eng., vol. Vol.8, No., no. 5, pp. 5505–5511, 2021.
M. S. Ummah, “Analisa Perbandingan Pengukuran Energi Pada Kwh Meter Pascabayar Dan Kwh Meter Prabayar,” Sustain., Vol. 11, No. 1, Pp. 1–14, 2019.
R. H. Wirasasmita, D. Prihatmoko, and M. Supriyadi, “Sistem Monitoring Pemakaian Daya Listrik Pada KWh Meter Menggunakan Sms Gateway,” Jurnal DISPROTEK. Accessed: Nov. 01, 2024.
J. Fifadhlillah, “Prototype KWH Meter Dengan Transmisi Nirkabel Berbasis Arduino Uno (Jihad Fifadhlillah) 1,” no. 12507134017, pp. 1–11.
Sinaga Joslen, “Perancangan Instalasi Listrik Pada Rumah Toko Tiga Lantai Dengan Daya 12 Kw,” J. Tek. Elektro, vol. VIII, no. 2, pp. 102–112, 2019.
T. Bini, Marwan, A. W. Indrawan, and Dasmawati, “Rancang Bangun Sistem Monitoring KWh Meter Berbasis Android,” Pros. Semin. Has. Penelit., vol. 2018, pp. 144–148, 2018.
H. N. Isnianto, M. Arrofiq, R. Rahmawati, and B. M. Tyoso, “Sistem Telemonitoring KWH Meter Menggunakan Modul Wi-Fi ESP8266 Berbasis Arduino Uno,” J. Rekayasa Elektr., vol. 15, no. 1, 2019, doi: 10.17529/jre.v15i1.12968.
M. Ruinaldi Pratama, A. Bachri, and U. Ilmi, “Rancang Bangun Alat Pembaca KWh Meter Berbasis Arduino Uno Dan Kirim Data Via Internet Of Things,” Semin. Nas. Fortei Reg., pp. 1–7, 2020.
M. P. Panuntun, “Pengujian Ketelitian KWh Meter Analog dan KWh Meter Digital Menggunakan Beban Induktif,” J. Fak. Tek. Univ. Muhammadiyah Surakarta, 2018.
S. N. Zahroh, “Rancang bangun alat monitoring pembebanan daya dan biaya listrik pln beserta waktu pemakaiannya menggunakan aplikasi smartphone,” Skripsi, pp. i–17, 2021.
- Andriana, - Zuklarnain, and H. Baehaqi, “Sistem kWh Meter Digital Menggunakan Modul PZEM-004T,” J. TIARSIE, vol. 16, no. 1, p. 29, 2019, doi: 10.32816/tiarsie.v16i1.43.
A. M. Saad, M. A. Masa, T. S. D. Abdurrahman, and A. Syarifuddin, “Design of IoT-Based Analog kWh Meter Monitoring,” PROtek J. Ilm. Tek. Elektro, vol. 10, no. 1, p. 52, 2023, doi: 10.33387/protk.v10i1.5571.
M. I. Suga and H. Nurwarsito, “Sistem Monitoring KWH Meter berbasis Modul Komunikasi LoRa,” J. Pengemb. Teknol. Inf. dan Ilmu Komput., vol. 5, no. 4, pp. 1257–1266, 2021.
M. N. Arifin and R. H. Rahwanto Fora, “Sistem Monitoring KWh Meter Berbasis Pc Dilengkapi Dengan Program Penghitung Biaya Listrik,” WAKTU J. Tek. UNIPA, vol. 12, no. 2, pp. 39–42, 2014, doi: 10.36456/waktu.v12i2.909.
M. Z. Utama, Nurvia. Sutedjo. Efendi, “Sistem Monitoring KWh Meter 3 Phase Dan Kalkulasi Biaya Pemakaian,” Elektro, PENS-ITS Surabaya, vol. 1, pp. 2–6, 2009.
Copyright (c) 2025 Zarah Zealita, Vicky Prasetia, Zaenurrohman
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
