Bureau of Reclamation, Acquisition Operations Group, Code D-7810, Denver Federal Center, PO Box 25007, Denver CO 80225

D -- ADP SYSTEMS DEVELOPMENT SERVICES SOL 99SQ810316 DUE 121599 POC Gilbert Olivas (303) 445-2437 WEB: AAMS Current Solicitation Listing, http://www.usbr.gov/aamsden/. E-MAIL: Gilbert Olivas, golivas@do.usbr.gov. The specifications contained herein are the minimum requirements for a computerized Laboratory Information Management System (LIMS), which is commercially available, for the analysis of environmental samples with water, soil, organic and other matrices. The LIMS must be compatible with a network server operating under Windows NT or Novell and with workstations on the network operating under Windows 95, Windows 98 or Windows NT. More detailed requirements are available on request. It must be capable of performing all of the normal functions required for managing an environmental laboratory. These include but are not limited to generating quotations, defining projects, logging in samples and tests under a work order scenario, printing laboratory backlog and holding time reports, entering data either manually or automatically by importing results from automated laboratory instrumentation, performing Quality Control (QC) functions according to the Environmental Protection Agency (EPA) and other regulatory agency guidelines, printing reports in a variety of user selectable formats and generating final invoices to clients for work performed. LIMS shall be able to establish and define Test information for commonly used tests for environmental analyses. Information stored and linked to individual Tests shall include all typical laboratory QC information. At the time of installation it shall be pre-loaded with default analyte lists, including Chemical Abstract Service (CAS) Registry Numbers, for all of the current EPA tests listed in Methods for Chemical Analysis of Water and Wastes (EPA-600/4-79-020), 40 CFR, Part 136 of the Federal Register, Test Methods for Evaluating Solid Waste, Physical/Chemical Methods (SW 846) and Standard Methods for the Examination of Water and Wastewater. Each test shall be linked to the appropriate analytes for each test in the above referenced methods. The user shall be able to add and delete analytes to customize the test methods for the laboratory's requirements. LIMS must also be capable of generating pricing and preparation factors for all tests, and the user must be able to override default information. It shall be able to correct the final result for the data entered during the sample preparation phase. LIMS must have the capabilities for generating Client Quotes. The quotation must include individual list prices for each Test or Test Group being quoted. The user must have the ability to modify the pricing in the quotation by applying a line by line discount or surcharge or by applying a discount or surcharge to the bottom line total. LIMS must also be able to track the status of each quotation as being Won, Lost or Pending. Once the quotation is won, they must be able to transfer all information into a project. Pricing from the quotation or project may be overridden at the time of login, and LIMS shall track the prices for each Test assigned to each sample. LIMS shall be able to track holding times for individual tests for each sample. Individual holding times for each phase of the analysis shall be tracked independently. It shall be capable of printing a holding time report for all incomplete tests assigned to all samples logged into LIMS. The holding time report shall clearly display the collection date, days allowed for the holding time, number of days remaining and shall flag any tests that are past the holding time or at a user-defined time prior to the end of the allowable holding time. Turn around times (TAT) shall be tracked by LIMS for each test logged in for a sample. The user shall be able to assign default turn around times for each quotation or, project and shall be able to assign turn around times for each sample or test at the time of logging in a sample. LIMS shall be capable of printing backlog reports for all samples logged in for any department in the lab or for any Test Code. LIMS shall be capable of implementing all quality control tracking required by the United States EPA programs. It should also be capable of generating reports complying with EPA Certified Laboratory Program (CLP) reporting requirements either through the basic system or as an add-on module. It shall also be able to print individual Quality Control Reports for the following types of QC samples: Method Blanks, Sample Duplicates, Laboratory Control Spikes and Spike Duplicates, Matrix Spikes and Spike Duplicates, Continuing Calibration Blanks, Continuing Calibration Verifications, Surrogate Spikes, Interference Check Standards (ISA/ISB), and Serial Dilutions. All reports shall be generated based upon either individual Work Orders, or a batch scenario. LIMS shall be able to track all of these quality control samples to their respective batches, Work Orders and Test Codes as appropriate. LIMS shall provide Control Charting Capabilities for the following QC sample types based upon individual tests and individual analytes as appropriate: Initial Calibration Verification (ICV), Sample Duplicates, Laboratory Control Spikes (LCS), Continuing Calibration Blanks (CCB), Continuing Calibration Verification (CCV), Field Blanks, Field Duplicates. It shall also include a validation procedure for each test, batch or analytical run sequence and shall be capable of importing data from multiple runs for the same Test and Sample and allowing the user to select which analyte results get validated from each run. LIMS shall include a chemical inventory as well as a spike/standard inventory. It shall track every chemical or standard logged into it by vendor, catalog number, lot number, and shall be able to generate purchase orders for any chemical or standard logged into the LIMS. LIMS shall also track shelf life for any chemical, standard or spike and warn an analyst when the expiration date has expired. LIMS shall be able to link solvents, chemicals, standards, and spikes to laboratory batches and analytical run sequences. This tracking shall be able to link any chemical, standard or spike by catalog number, lot number and vendor to the analyses and samples in which they were used. LIMS shall have a sample tracking capabilitiesto log samples in and out of sample storage locations within the laboratory. It shall be able to print a complete Chain of Custody History for each sample showing each location within the lab that a sample was logged to and each person who handled a sample. Such reports shall include date and time of each transfer. It shall include a sample scheduling capabilities for field collection of samples. The scheduling shall be assigned by projects with specified tests assigned to each project. Sampling frequency shall be assigned to each project and shall include user customizable frequencies. LIMS shall include user definable import specifications for automated import of data from computerized analytical instruments within the laboratory. These specifications shall allow the user to import results from instrumentation files on the network. File types shall include parsing of text file reports, CSV files and spreadsheet files. For non-automated data entry, the LIMS shall link to a spreadsheet file and generate a spreadsheet file with sample, test, and analyte information as well as other pertinent sample information from the LIMS. LIMS shall be able to create new spreadsheet files and export this information directly into the spreadsheet. Analysts shall also be able to type data results directly into the LIMS on a sample by sample basis. LIMS shall include a variety of report formats for reporting results. The laboratory shall be able to easily customize reports; modifications shall be capable of being performed by non-programmer personnel and the knowledge of writing code shall not be a requirement for customizing reports. The LIMS shall also include a custom data export module designed to export data from the LIMS to the following types of data files: Microsoft Access, Paradox, FoxPro, dBase, Microsoft Excel, Lotus, and Comma-Quote Delimited files. The user shall be able to select the fields to export, the sort order of export fields and be able to export to any of the above file types specifically by Clients, Projects or Work Orders. The LIMS vendor shall provide the Bureau of Reclamation with an uncompiled version of the software including all source code for the software. Providing such source code to the software shall allow the purchaser to customize and modify the software to meet the individual needs of the purchaser. The LIMS vendor may be called upon to provide programming support to customize the system for the user. Hourly costs for this support, plus any applicable travel costs, shall be identified. FOB point shall be destination, Bureau of Reclamation, P.O. Box 25007, Denver, CO. Required delivery date is January 15, 2000. All responsible sources may submit a quotation which will be considered by the agency. Posted 11/30/99 (W-SN404425). (0334)

Loren Data Corp. http://www.ld.com (SYN# 0015 19991202\D-0003.SOL)