header-left
File #: 1738-2008    Version: 1
Type: Ordinance Status: Passed
File created: 10/27/2008 In control: Utilities Committee
On agenda: 11/24/2008 Final action: 11/25/2008
Title: To authorize the Director of Public Utilities to enter into an agreement with PerkinElmer for the purchase of a Laboratory Information Management System (LIMS); to authorize the appropriation and transfer of $259,926.00 from the Water System Reserve Fund to the Water Works Enlargement Voted Bonds Fund; to authorize the expenditure of $259,926.00 from the Water Works Enlargement Voted Bonds Fund; to authorize the transfer and expenditure of $259,926.00 from within the Sanitary Sewer Revenue Bonds Fund; to amend the 2008 Capital Improvements Budget; for the Department of Public Utilities, and to declare an emergency. ($519,852.00)
Attachments: 1. ORD1738-2008 Legis. Info. Form.pdf
Date Ver.Action ByActionResultAction DetailsMeeting Details
11/25/20081 ACTING MAYOR Signed  Action details Meeting details
11/25/20081 CITY CLERK Attest  Action details Meeting details
11/24/20081 Columbus City Council ApprovedPass Action details Meeting details
11/24/20081 COUNCIL PRESIDENT Signed  Action details Meeting details
11/12/20081 CITY ATTORNEY Reviewed and Approved  Action details Meeting details
11/12/20081 Utilities Drafter Sent to Clerk's Office for Council  Action details Meeting details
11/10/20081 Auditor Reviewer Reviewed and Approved  Action details Meeting details
11/10/20081 CITY AUDITOR Reviewed and Approved  Action details Meeting details
11/10/20081 Utilities Drafter Sent for Approval  Action details Meeting details
11/7/20081 FINANCE DIRECTOR Reviewed and Approved  Action details Meeting details
11/7/20081 Utilities Drafter Sent for Approval  Action details Meeting details
11/6/20081 EBOCO Reviewer Sent for Approval  Action details Meeting details
11/6/20081 ODI DIRECTOR Reviewed and Approved  Action details Meeting details
11/6/20081 Utilities Drafter Sent for Approval  Action details Meeting details
11/6/20081 Finance Reviewer Reviewed and Approved  Action details Meeting details
11/6/20081 Finance Reviewer Reviewed and Approved  Action details Meeting details
11/5/20081 Utilities Reviewer Sent for Approval  Action details Meeting details
11/5/20081 UTILITIES DIRECTOR Reviewed and Approved  Action details Meeting details
11/5/20081 Utilities Drafter Sent for Approval  Action details Meeting details
11/4/20081 Utilities Reviewer Reviewed and Approved  Action details Meeting details
11/4/20081 Utilities Drafter Sent for Approval  Action details Meeting details
11/3/20081 Utilities Reviewer Reviewed and Approved  Action details Meeting details
11/3/20081 Utilities Drafter Sent for Approval  Action details Meeting details
10/31/20081 Utilities Drafter Sent for Approval  Action details Meeting details
10/30/20081 Utilities Drafter Sent for Approval  Action details Meeting details
10/29/20081 Utilities Reviewer Reviewed and Approved  Action details Meeting details
10/28/20081 Utilities Drafter Sent for Approval  Action details Meeting details
Explanation

1. BACKGROUND: This legislation authorizes the Director of Public Utilities to enter into an agreement with PerkinElmer in the amount of $519,852.00, for the design, purchase and implementation of a Laboratory Information Management System (LIMS) with accompanying treatment plant Operations Data System (ODS). LIMS software is to be configured to meet the needs of the individual lab(s) and ODS software is to be configured to meet the operational data collection needs of the individual plants, to combine SCADA data with LIMS data, and to produce Monthly Operating Reports (MORs) as required by regulatory agencies. Training will be provided to users of this system.

The current legacy LIMS being used by Division of Sewerage and Drainage's (DOSD) Surveillance Lab is being phased out by the manufacturer and will not be supported past 2010. This LIMS currently tracks 36,000 tests on 7,000 different samples annually within the Surveillance Lab. This LIMS then transfers approved results to various end users (treatment plants and Pretreatment) automatically.

The Department would need to add staff to the Surveillance Lab if their LIMS is not replaced. Current staffing at their main lab cannot do their job in the area of regulatory reporting without the aid of this type of software. Therefore, the Department needs to replace the DOSD system, as well as purchase a new system for the Division of Power and Water (DOPW) to unify the whole.

The new departmental level LIMS will manage water quality sample information from all the labs as well as incorporating input from plant operations data sources, SCADA and the DOSD industrial Pre-Treatment Information Management System (PIMS). Another 43,000 tests and 9,000 samples would be added by the Division of Power & Water's Water Quality Assurance Lab (WQAL). A key part of the new LIMS is the ODS, which gathers plant data to combine with the LIMS to publish all the department's regulatory MORs.

Currently,...

Click here for full text