IMPLEMENTATION OF INTERNET OF THINGS (IoT) BASED ON GOOGLE SHEETS FOR WATER QUALITY MONITORING SYSTEM
DOI:
https://doi.org/10.22437/jop.v9i1.28689Keywords:
Google sheet, Internet of Things (IoT), pH, TDS, TemperatureAbstract
Temperature, pH, and TDS are important indicators of water quality that affect various aspects. This research aims to develop a water quality monitoring system by implementing Internet of Things (IoT) technology based on Google Sheets. Based on the tests for each sensor - temperature, pH, and TDS - the results show that the system has an excellent level of measurement precision, with an average precision value of above 95%. The findings also indicate that Google Sheets can be utilized in IoT technology and can operate on more than one distinct computer device at the same time. The use of Google Sheets in IoT technology is highly effective, flexible, and user-friendly. The measured data can be automatically stored and can be visualized effectively.".
Downloads
References
Amri, I., & Pebralia, J. (2022). A Simple of IoT Based Social Contact Tracking for Infectious Patient using Ultrasonic Sensor: A Preliminary Study. JOP (Journal Online of Physics), 7(2), 19-23.
Ayvaz, S., & Alpay, K. (2021). Predictive maintenance system for production lines in manufacturing: A machine learning approach using IoT data in real-time. Expert Systems with Applications, 173, 114598.
Banafa, A. (2016). IoT standardization and implementation challenges. IEEE internet of things newsletter, 2016, 1-10.
Chebet, E. B., Kibet, J. K., & Mbui, D. (2020). The assessment of water quality in river Molo water basin, Kenya. Applied Water Science, 10, 1-10.
Kulkarni, P. H., Kute, P. D., & More, V. N. (2016, January). IoT based data processing for automated industrial meter reader using Raspberry Pi. In 2016 International Conference on Internet of Things and Applications (IOTA) (pp. 107-111). IEEE.
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, 94-98.
Nurelmadina, N., Hasan, M. K., Memon, I., Saeed, R. A., Zainol Ariffin, K. A., Ali, E. S., ... & Hassan, M. A. (2021). A systematic review on cognitive radio in low power wide area network for industrial IoT applications. Sustainability, 13(1), 338.
Pebralia, J., Rustan, R., Bintana, R. R., & Amri, I. Sistem Monitoring Kebakaran Hutan Berbasis Internet of Things (IoT). Komunikasi Fisika Indonesia, 19(3), 183-189.
Sharma, R., Kumar, R., Satapathy, S. C., Al-Ansari, N., Singh, K. K., Mahapatra, R. P., ... & Pham, B. T. (2020). Analysis of water pollution using different physicochemical parameters: A study of Yamuna River. Frontiers in Environmental science, 8, 581591.
UstaoÄŸlu, F., Tepe, Y., & TaÅŸ, B. (2020). Assessment of stream quality and health risk in a subtropical Turkey river system: A combined approach using statistical analysis and water quality index. Ecological indicators, 113, 105815.
Yadav, E. P., Mittal, E. A., & Yadav, H. (2018, February). IoT: Challenges and issues in indian perspective. In 2018 3rd International Conference On Internet of Things: Smart Innovation and Usages (IoT-SIU) (pp. 1-5). IEEE.
Wilani, L., Peslinof, M., & Pebralia, J. (2023). Rancang Bangun Sistem Monitoring Kebisingan pada Ruangan dengan Sensor Suara GY-MAX4466 Berbasis Internet of Things (IoT). STRING (Satuan Tulisan Riset dan Inovasi Teknologi), 7(3), 319-328.
