Hollywood FL banner
File #: R-2017-045    Version: 1 Name: Laboratory Information Management System (LIMS) Upgrade
Type: Resolution Status: Passed
File created: 1/11/2017 In control: Department of Public Utilities
On agenda: 2/15/2017 Final action: 2/15/2017
Title: A Resolution Of The City Commission Of The City Of Hollywood, Florida, Authorizing The Appropriate City Officials To Issue A Purchase Order And Execute The Attached Software License Agreement Between Autoscribe Informatics And The City Of Hollywood To Furnish And Install An Upgrade To The Department Of Public Utilities Laboratory Information Management System (LIMS) Software In An Amount Of $47,062.00 And To Amend The Approved Fiscal Year 2017 Capital Improvement Program, As Set Forth In Exhibit A.
Attachments: 1. Reso Laboratory Information Management System (LIMS).pdf, 2. Exhibit A.pdf, 3. License Agreement - Laboratory Information Management System (LIMS).pdf, 4. Quote Laboratory Information Management System (LIMS).pdf, 5. COI Laboratory Information Management System (LIMS).pdf, 6. Term Sheet - Autoscribe Informatics.pdf, 7. BIS 17-105.pdf

Title

A Resolution Of The City Commission Of The City Of Hollywood, Florida, Authorizing The Appropriate City Officials To Issue A Purchase Order And Execute The Attached Software License Agreement Between Autoscribe Informatics And The City Of Hollywood To Furnish And Install An Upgrade To The Department Of Public Utilities Laboratory Information Management System (LIMS) Software In An Amount Of $47,062.00 And To Amend The Approved Fiscal Year 2017 Capital Improvement Program, As Set Forth In Exhibit A.

 

 

Body

 

Staff Recommends: Approval of the attached Resolution

 

 

Explanation:

The City of Hollywood, Florida owns and operates a National Environmental Laboratory Accreditation Conference (NELAC) certified laboratory which operates within the Department of Public Utilities.

 

The responsibility of the certified laboratory is to provide continuous testing and analytical support to the Water and Wastewater Treatment Plants by performing more than 70 tests every day to monitor water quality, and more than 160 additional tests each month on drinking water samples taken throughout the City, for an overall total of more than 28,000 tests each year.

 

The City’s certified laboratory also performs over 40 daily tests to monitor wastewater treatment plant processes and controls, and for regulatory sampling requirement, for an approximate total of over 14,600 tests annually.

 

In 2001 the City purchased and implemented Autoscribe Informatics System, a Laboratory Information Management System (LIMS), to manage analytical data from the certified laboratory and produce reports used by the Water and Wastewater Treatment Plants, and submitted to regulatory agencies.

 

After upgrades were offered to the Autoscribe Informatics System to the City in 2003 and again in 2009, and delayed due to technical system conflicts related to the City’s Windows platform, the system upgrade continued to be on hold while the Department of Public Utilities searched for a system or upgrade that would provide the certified laboratory with a more modern and expandable LIMS for future growth and continuity.

 

Extensive research on the part of the Department of Public Utilities that included presentations and webinars from a number of companies, such as Promium, Element, Ethosoft, Watertrax, and Autoscribe, and a trial test of Lab Cal - a module within the HACH Company’s Water Information Management Solutions (WIMS) - was unsuccessful in providing expandability and returning true information management of the certified laboratory’s analytical data.

 

In order to accurately manage large volumes of analytical data under strict standards, while providing greater flexibility and data security for a variety of laboratory workflow and report production, the decision to upgrade the existing Autoscribe Informatics software is the most effective approach.

 

Some of the benefits offered by Autoscribe for migrating from the current V3 Matrix LIMS to V5 Matrix Gemini LIMS include: web access, improved result import functionality, ability to maintain all current data (including archived data), reduced database size by upgrading to SQL, and seamless data delivery in the reports to the Water and Wastewater Treatment Plants.

 

The Director of Public Utilities and the Director of Procurement & Contract Compliance recommend that the City Commission issue a purchase order to Autoscribe Informatics to furnish and install the LIMS software upgrade in an amount of $47,062.00.

 

It is necessary to amend the approved FY 2017 Capital Improvements Program and allocate funding in the amount of $37,617.13 for the LIMS software upgrade as set forth in Exhibit A, attached.

 

Recommended for inclusion on the agenda by:

Dr. Wazir Ishmael, City Manager

George R. Keller, Jr., ACM for Finance & Administration

Gus Zambrano, ACM for Sustainable Development

Steve Joseph, Director, Public Utilities

Paul Bassar, Director, Procurement & Contract Compliance