Water Conservation Company
A water conservation company in Los Angeles had a problem: They had a team of installers who were servicing dozens of buildings and hundreds of apartments a month, in order to measure the current water flow and install flow regulators on the showers and bathroom sinks, identify all the non-efficient toilets for replacement, and quickly create detailed tickets for immediate leak repairs.
Until that point, the entire system was paper-based, and reports often were incomplete or missing. They needed a way to manage their entire process, while ensuring they maintained enough inventory, and creating a baseline flow rate to compare to on follow-up yearly inspections.
I customized Airtable, an off-the-shelf database/spreadsheet SaaS solution, to require installers to follow the installation process. The water conservation company was able to quickly on-board new installers, create baselines for all the apartments, repair leaks, quickly generate reports for their clients about their savings, and maintain high enough stores of inventory at any given time. Additionally, we were able to better manage the speed and efficiency of the installations.
With this solution in place, the water conservation company was able to surpass more than 1 billion gallons of water conserved during the drought. The time to fix leaks dropped to days instead of weeks.