Based upon initial conversations with DOIT it appears that the Tableau chart updates can be automated if the data are stored in a single structured database (rather than the current excel files). NJGWS is proposing the following …

(1)    BWRG develops a draft database structure (tables, columns, data types, and table relationships) in MS Access.

(2)    BWRG and BWAWP will confirm that the database structure can hold the appropriate data based on the program’s needs.

(3)    DOIT will use the MS Access database as a template to replicate the same setup in SQL Server.

(4)    BWRG will attempt to design MS Access forms for data entry and management on top of the MS Access database. 

NOTE: If program is unsuccessful at developing the front-end forms internally, program will request assistance from DOIT on suggested path forward.

(5)    Once forms are verified working for MS Access, DOIT will assist BWRG on linking the MS Access forms (Front-End) to the SQL Server database (Back-End). 

NOTE: NJGWS is not locked in on a specific database and data entry form solution.  The program is flexible in the approach used if the end result is a data entry and storage platform that can be accessed by Tableau and additional software such as R.

BWRG would like to receive confirmation form DOIT that this is a reasonable path forward before staff begin any work.

The ultimate goal is to develop a process for BWAWP staff person(s) who receive the weekly information to be able to enter it into some sort of form where the data is automatically transferred to the underlying database. That database could then be accessed directly by Tableau or similar software to update the drought charts.