AUTOMATED AUGMENTATION PLAN OPERATION MODELS PROJECTS

Eldorado Artesian Springs, Inc. - Accounting Spreadsheet

The State Engineer requires accounting for approved substitute water supply plans and augmentation plans. Recording of all water uses and calculation of corresponding depletions are often more feasibly and economically done by the client than by Martin and Wood employees. To facilitate monthly client accounting and reporting, Martin and Wood creates customized programmed spreadsheets that keep track of diversions, consumptive use, depletions, out-of-priority depletions, replacements, requirements, and actual replacements. The client may then automatically enter data into monthly spreadsheet reports to be submitted to the State Engineer in accordance with its reporting policies.

Gravel Pit Substitute Water Supply Plans

Since 1989, the State Engineer requires substitute water supply plans (“SWSP's”) for gravel pits that expose ground water to the atmosphere to ensure replacement of all out-of-priority depletions of ground water.

These gravel pit substitute water supply plans offer their own unique challenges in reporting to the State, calculating monthly values for water losses due to water removed with the mined product, concrete production, dust suppression, evaporation from recharge ponds and other exposed water, and reclamation irrigation.

Monthly accounting reports are required by the State Engineer. For ease of reporting, Martin and Wood personnel create spreadsheets to automate calculation and tabulation of monthly consumptive use and corresponding stream depletions based on monthly production data that can be entered by the gravel pit operator. The reports generated comply with the substitute water supply plan approval conditions.