Smart Water Meter with Cloud Database and Water Bill Consumption Monitoring via SMS and Mobile Application

This study delves upon the design and development of a smart water meter system that provides an IoT-based platform which provides consumption and billing reports in real time. The system is capable of automated data collection and upload phases in times of meter inactivity. Google Apps Scripting (GAS) was used to provide interfacing between the physical prototype, Google Sheets, and a mobile application. A calibrated equation for the determination of water consumption and flow rate is generated using MATLAB Curve Fitting Tool. Having undergone statistical analysis, the volume measurement methods deployed were of no significant difference with each other. Overall, the system was verified to be functional in all aspects of its operation.