Laboratory Information Management System

The vendor is required to provide laboratory information management system (LIMS) solution will enhance the county’s water resources laboratory (WRL) management capabilities and grow with its needs.
- Water resources laboratory system requirements
1. Laboratory operations
•    Processing sample requests
•    Sample collection
•    Sample receipt
•    Unique sample identification
•    Solution creation and control
•    Sample tracking and related information
•    Sample analysis
•    Chemical and equipment maintenance and calibration
2. Offsite and field operations
•    Secured off-site sample data entry
•    Geofencing within 15 meters of site locations
•    Integration with mapping applications
•    Configurable bench sheet creation
3. Quality control
•    Legally defensible data
•    Control chart creation
•    Data qualifiers
•    Method detection limit monitoring
•    Corrective action creation and documentation
•    Standard operating procedures
•    Branded bench sheet creation
4. Laboratory management
•    Sample scheduling
•    Labels for samples and solutions
•    Chain of custody- creation and storage
•    Personnel scheduling and resource planning
•    Assessing productivity
•    Instrument data entry
•    Electronic bench sheet (upload and print)
•    Batch data upload
•    Completeness of results
•    Supply inventory
•    Personnel training and certification
5. Monitoring and control
•    Sample tracking and status
•    Data validation and approval
•    Analytical batch requirements
•    Result parameters defined by site and test
•    Data archival
6. Reporting and communication
•    The service provider should provide report configuration and report training for the WRL via crystal reports and power bi or a similar application.
•    Outsourced analyses will require batch uploading.
•    Optional: email of report to clients posts final data approval.
•    The software must have the ability to hold historical or archive information and allow users to retrieve within a certain timeline.
7. Data capture
•    Manual data entry
•    Batch upload entry
•    Automated instrument entry
•    Electronic data imported from external systems
•    Contract laboratory data
•    Excel spreadsheets
•    Barcode scanners and barcodes
•    Optical scanner
•    QR code scanner
8. Data export
•    A means for exporting data into an SQL database
•    A means for exporting data into microsoft excel
•    Provisions for fixed format exporting of laboratory analytical results
•    Provide the ability to export data in standard file formats (i.e., pdf, csv, MS excel, etc.)
9. Calculations
•    Provide a library of mathematical functions, including advanced functions
•    Provide an advanced statistical tool
•    Allow user-defined functions and calculations
•    Allow the manipulation of computations through event triggers
•    Provide for trigger for data below the detection level
10. Data verification
•    Multiple verification statuses 
•    Statuses may be combined for differing scenarios and may be automatically assigned upon data entry
•    Multiple limits checking up to ten classifications or ranges
•    Changeable limits with maintenance of historical values
•    Compliance with laboratory procedures
•    Manual annotation and flagging of questioned data and subsequent resolution by analyst or laboratory management
•    Automated sample rescheduling
•    Communication of verification status to external systems (e.g., automated exception reports)
•    Provide the ability to review data before it downloads
11. Data population
•    The service provider should assist in data population by analyzing the WRL’s historical data, identifying LIMS data formats, and providing direction in reformatting or additional data population.

- Questions/Inquires Deadline: November 7, 2025