IPTD-450
Water Monitoring, Standards and Pesticide Control (WMSPC) Laboratory Information Management System (LIMS) for BFBM Phase II
Description
Create web-based data management tool that handles all aspects of field and laboratory data management for BFBM. This shall include a station sample scheduling program to organize which monitoring locations are associated with which samplers, web forms to accommodate the various combinations of data entry required by each type of project, database storage solution that is flexible enough to handle all possible projects, simple to use query tools that can search, filter, and query data within the database to retrieve target data subsets of information, ability to export the data out as a .csv or .xlsx file to be used locally for analysis. For known reports and analyses, build a dashboard/switchboard function that automatically generate the canned reports and statistics. A mechanism for the program to easily add parameters and site locations as new projects arise or change from year to year. Customize an output routine of the data into pre-defined file structures that align with what the EPA requires when DEP submits data results annually.
Problem Statement
• Response Time: The response time in some cases make the application(s) un-usable. In what use to take milliseconds for customized code to run after hitting a button now may take upwards of 10 minutes.
• Vanishing Code: Underlying customized VBA code is disappearing with no explained reason. Not just chunks, all underlying VBA code. This has happened on several occasions.
• Lock Outs: Some staff are unable to access or use an application. There is no pattern. One staff member may be able to conduct work as expected while another is locked out temporarily. Since the MS Access application is split into a Front-End Graphical User Interface (GUI) and Back End database for storage, this should not be happening.
The BFBM LIMS went live for BFBM IT staff in April and will be available to all BFBM staff in May. The project has transitioned to a maintenance phase, with post-go-live enhancements and bug fixes managed through an existing maintenance contract with the Contractor. Significant refinements are expected throughout the first year as staff adapt and provide improvement suggestions. Ongoing efforts will also focus on understanding the new database structure and working with DOIT to optimize data querying and extraction.
Received Purchase Order on 7/9/25. Work to begin soon.
SOW has been approved by DOIT/Contractor/Program. It will now be sent out to Resellers to get price estimates.
A SOW has been agreed to by the Program and Carrollton. DOIT reviewed and requested a few minor edits which were accepted by Carrollton. A request to Grace and Reynaldo to get Reseller quotes was made on 1/10/25.