This project developed a web-based tracking system for the Gujarat Water Supply & Sewerage Board to replace their existing Excel spreadsheet-based system. The new system centralized data storage, provided customized reporting capabilities, and added security and user permissions. It utilized tools like ASP.NET, SQL Server, and incorporated features like cascading stylesheets and custom date controls. Over 115,000 records were transferred from the old system to the new database.