Local Irrigation District that manages wells to provide well water to a specific geography for irrigation.
Client manages irrigation schedules for hundreds of customers and 6 wells and must publish sign-up sheets and schedules each week. Customers can establish automatic schedules as well as request one-off appointments via phone, email, and sign-up sheets.
Client's current system includes multiple Excel workbooks with VBA for automation and printed documents which the Client marks with multiple colored markers and pens.
The workbooks throw errors frequently and still require considerable manual manipulation for moving and formatting data. This weekly process occupies much of the Client's time.
Clear Data Incorporated created an Excel/VBA application that manages the customer property data and the schedule data for all wells in a single workbook. The entire process requires no paper, pens, or markers until producing the printed sign-up sheets (required).
The system employs a calendar interface for managing well schedules and supports automatic and one-off scheduling in an easy-to-use form.