One of the primary goals of the project was to make the model flexible and easily customizable. As new data becomes available or changes are needed, the model needed to be able to adapt and change its own parameters. By utilizing VBA in the ArcGIS environment, the model was able to perform the sub-basin analysis, created maps showing impact, and summarized the results by table with only a click of a few buttons.
ESS developed generic report templates for the towns and watersheds of Massachusetts. After the analysis and water budgets model compiled its results, the automation process inserted the results into the report template based on the town or watershed. The final goal of the project was to be 350 town and 74 watershed customized reports.