The URL can be used to link to this page

CONTRACT TO SUPPLY AND INSTALL A LABORATORY INFORMATION MANAGEMENT SYSTEM (LIMS)CONTRACT This CONTRACT made and entered into this � day of , 2006 by and between the City of Clearwater, Florida, a municipal corporation, hereinafter esignated as the "City", and Accelerated Technology Laboratories Inc , of the City of West End, County of 1Vloore and State of North Carolina, hereinafter designated as the "Contractor". WITNESSETH: That the parties to this contract each in consideration of the undertakings, promises and agreements on the part of the other herein contained, do hereby undertake, promise and agree as follows: The Contractor, and his or its successors, assigns, executors or administrators, in consideration of the sums of money as herein after set forth to be paid by the City and to the Contractor, shall and will at their own cost and expense perform all labor, furnish all materials, tools and equipment for the following: Supply and install a Laboratory Information Management System (LIMS) iq accordance with the terms and conditions included in the City of Clearwater Request For Qualifications #31-05 for $104,483.75. This includes the base price items ($101,488.75) plus an optional item ($2,995.00). In accordance with such proposal and technical supplemental specifications and such other special provisions and drawings, if any, which will be submitted by the City, together with any advertisement, instructions to bidders, general conditions, proposal and bond, which may be hereto attached, and any drawings if any, which may be herein referred to, are hereby made a part of this contract, and all of said work to be performed and completed by the contractor and its successors and assigns shall be fully completed in a good and workmanlike manner to the satisfaction of the City. If the Contractor should fail to comply with any of the terms, conditions, provisions or stipulations as contained herein within the time specified for completion of the work to be performed by the Contractor, then the City, may at its option, avail itself of any or all remedies provided on its behalf and shall have the right to proceed to complete such work as Contractor is obligated to perform in accordance with the provisions as contained herein. THE CONTRACTOR AND HIS OR ITS SUCCESSORS AND ASSIGNS DOES HEREBY AGREE TO ASSUME THE DEFENSE OF ANY LEGAL ACTION WHICH MAY BE BROUGHT AGAINST THE CITY AS A RESULT OF THE CONTRACTOR'S ACTIVITIES ARISING OUT OF THIS CONTRACT AND FURTHERMORE, IN CONSIDERATION OF THE TERMS, STIPULATIONS AND CONDITIONS AS CONTAINED HEREIN, AGREES TO HOLD THE CITY FREE AND HARMLESS FROM ANY AND ALL CLAIMS FOR DAMAGES, COSTS OF SUITS, JUDGMENTS OR DECREES RESULTING FROM ANY CLAIMS MADE UNDER THIS CONTRACT AGAINST THE CITY OR THE CONTRACTOR OR THE CONTRACTOR'S SUB-CONTRACTORS, AGENTS, SERVANTS LIMSContract.doc Page 1 Revised: 12/OS/OS CONTRACT �2) OR EMPLOYEES RESULTING FROM ACTIVITIES BY THE AFOREMENTIONED CONTRACTOR, SUB-CONTRACTOR, AGENT SERVANTS OR.EMPLOYEES. In addition to the foregoing provisions, the Contractor agrees to conform to the following requirements: In connection with the performance of work under this contract, the Contractor agrees not to discriminate against any employee or applicant for employment because of race, sex, religion, color, or national origin. The aforesaid provision shall include, but not be limited to, the following: employment, upgrading, demotion, or transfer; recruitment or recruitment advertising; lay-off or termination; rates of pay or other forms of compensation; and selection for training, including apprenticeship. The Contractor agrees to post hereafter in conspicuous places, available for employees or applicants for employment, notices to be provided by the contracting officer setting forth the provisions of the non-discrimination clause. The Contractar further agrees to insert the foregoing provisions in all contracts hereunder, including contracts or agreements with labor unions and/or worker's representatives, except sub-contractors for standard commercial supplies or raw materials. It is mutually agreed between the parties hereto that time is of the essence of this contract, and in the event that the work to be performed by the Contractor is not completed within the time stipulated herein, it is then further agreed that the City may deduct from such sums or compensation as may be due to the Contractor the sum of $1,000.00 per dav for each day that the work to be performed by the Contractor remains incomplete beyond the time limit specified herein, which sum of $1,000.00 per d� shall only and solely represent damages which the City has sustained by reason of the failure of the Contractor to complete the work within the time stipulated, it being further agreed that this sum is not to be construed as a penalty but is only to be construed as liquidated damages for failure of the Contractor to complete and perform all work within the time period as specified in this contract. It is further mutually agreed between the City and the Contractor that if, any time after the execution of this contract and the surety bond which is attached hereto for the faithful performance of the terms and conditions as contained herein by the Contractor, that the City shall at any time deem the surety or sureties upon such performance bond to be unsatisfactory or if, far any reaso�, the said bond ceases to be adequate in amount to cover the performance of the work the Contractor shall, at his or its own expense, within ten (10) days after receipt of written notice from the City to do so, furnish an additional bond or bonds in such term and amounts and with such surety or sureties as shall be satisfactory to the City. If such an event occurs, no further payment shall be made to the Contractor under the terms and provisions of this contract until such new or additional security bond guaranteeing the faithful performance of the wark under the terms hereof shall be completed and fumished to the City in a form satisfactory to it. LIMSContract.doc Page 2 Revised: 12/OS/OS CONTRACT (3) IN WITNESS WHEREOF, the parties to the agreement have hereunto set their hands and seals and have executed this Agreement, in duplicate, the day and year first above written. CITY OF CLEARWATER IN PINELLAS COUNTY, FLORIDA By� ^ (Seal) William B. Horne, City Manager Attest: Countersigned: By: - Hibbard, Mayor-Councilmember (Contractor must indicate whether Corporation, Partnership, Company or Individual.) (The person signing shall, in his own handwriting, sign the Principal's name, his own name, and his title; where the person is signing for a Corporation, he must, by Affidavit, show his authority to bind the Corparation). ��_ C 'a E. t�eau, Cit Clerk Approved as to form � 'f��i��?I�: �� ,; ry . Ruff Assistant City Attorney (Contractor) By: (SEAL� LIMSContract.doc Page 3 Revised: 12/OS/OS fii� � ( ,i ! �� IT��S� �+J . �'� �', th� ��rt�e� �� h� �gree�er�t ��.v� �Zz�re�n�� se� �Y�e�r �a�� a�c� se�ls ��a:t� �ia�re ��t�d th�� .��;re�.�c�t, i� d�piic�te, ih� �a� a�d �rea.�• ��-st �.�avc writ�e�. ��"T""'Y �k' �'�ak� "��',�"I'� �� ,�� JP��"�� '�,CC� I �, ��: ��' � �.� ' "��` . �... �-t�3- ��. � VVikl�a� �. H�rnc, � �i�� a�ta��r �ar��ersi��t�. d'3.�. �1�3�3 ��:� � ,�� , h�� `� �t�� 4 �'�"�31� �1k3�7c1,4'i�, ��}'(D�`-�i� U�7.�11TI��I"1'9�3��" �C`c�r�t�a�tc�r tr��st �r�t�icat� tivh��h.�r C��cara��n> ��rtner�hip, C��npan;� �ar �nt�iv��ual.} �"C'1�� crsa� s��ni�� s��all, i� his �w� ha�c�v��t��;� �i� �h� �'��ip�l's �a�nc, h1� t�w� z��e, an�i h�s �i�lc; �vher� ��e pc�°s�n is s��nirag �+�g d �c��rat�e��, �� st, l�y .��.��i�vit, s�ir�ru ��s a��h��it� tc� bins� t�tc ��rp�rati€��. {�eal) Atkc;�t: � �� ,� , , � . , , `t�.�,�.�, F�,.�a. f'� ��''�� _�� - �}�a�kaia F, �'r�uiiE:d�a, �itj�'��e�� r''��i�T�7VCt� c"9S Li� �[7P�T1 � y"� - � � f � �� a ., �,.. : f� �,a...,�,,.�-" _ . �"` , __ . .-�*� .�....�...w _.. A ��-��i� �. �1��"�` t,m_ t�ssis�:�� C"<ity �.tic�r�e� ; F r�� ✓ � ,.:.�� ,y ,;;. ilti� r � :� J � � � � (C"santr�� r � , -- ; ��.,� r t.IMSG�rantract.dsac F7age 3 R�c�•ise�: 1'?I[�5�'()� CONTRACTOR'S AFFIDAVIT FOR FINAL PAYMENT (CORPORATION FOR1Vn STATE OF FLORIDA COUNTY OF On this day personally appeared before me, the undersigned authority, duly authorized to administer oaths and take acknowledgments, , who after being duly sworn, deposes and says: That he is the (TITLE) of , a Florida Corporation, with its principal place of business located at (herein, the "Contractor"). That the Contractar was the general contractor under a contract executed on the day of , 2006, with the CITY OF CLEARWATER, FLORIDA, a municipal corporation, as Owner, and that the Contractor was to perform the construction of: That said work has now been completed and the Contractor has paid and discharged all sub-contractors, laborers and material men in connection with said work and there are no liens outstanding of any nature nor any debts or obligations that might become a lien or encumbrance in connection with said work against the described property. That he is making this affidavit pursuant to the requirements of Chapter 713, Florida Statutes, and upon consideration of the payment of (Final Full Amount of Contract) in full satisfaction and discharge of said contract. That the Owner is hereby released from any claim which might arise out of said Contract. The ward "liens" as used in this affidavit shall mean any and all arising under the operation of the Florida Mechanic's Lien Law as set forth in Chapter 713, Florida Statutes. Sworn and subscribed to before me This day of , 2006 . BY: NOTARY PUBLIC My Commission Expires: AFFIANT PRESIDENT LIMSContract.doc Page 4 Revised: 12/OS/OS APPENDIX "A" AFFADAVIT NON-COLLUSION CLAUSE BID FORM LIMS-RFQ-7-13-OS.doc Page 28 Revised: 7/25/2005 NON-COLLUSION AFFIDAVIT �C STATE OF F3�A COUNTY OF IVjp� Q E, ) : Cl�hsi�'ne �aszko being, first duly sworn, deposes and says that he is V+ cE PREsiD�nll' of f}PLEt�ieiaTEt� 'rECNNOtAGy LA�0,2A�Rlts, Z�;//C. the party making the foregoing Proposal or Bid; that such Bid is genuine and not collusive or sham: that said bidder is not financially interested in or otherwise affiliated in a business way with any other bidder on the same contract; that said bidder has not colluded, conspired, connived, or agreed, directly or indirectly, with any bidders or person, to put in a sham bid or that such other person shall refrain from bidding, and has not in any manner, directly or indirectly, sought by agreement or collusion, or communication or conference, with any person, to fix the bid price or affiant or any other bidder, or to fix any overhead, profit or cost element of said bid price, or that of any other bidder, or to secure any advantage against the City of Clearwater, Florida, or any person or persons interested in the proposed contract; and that all statements contained in said proposal or bid are true; and further, that such bidder has not directly or indirectly submitted this bid, or the contents thereof, or divulged information or data relative thereto to any association or to any member or agent thereof. ,.��/�. � �. y Sworn to and subscribed before me this o a day of �.��/ �,n_� , 2005. .c f dl � _ vg �d /�_ . Notary Public LIMS-RFQ-7-13-OS.doc Revised: 7/25/2005 BID FORM PROPOSAL (�) � TO THE CITY OF CLEARWATER, FLORIDA, for SAMPLE MAS7FR� PKa LIMS �LA�3fl�►7aQY .�NFaf�/v1�4TlotiJ MANAGEWI��1T s�s7��y1�7 SNST72UMENT 2NTEG�eA7�oN �q ?nslr�en+�, RV66ED P/}111�1 uN IT W177�/ AN lNT�6?iFT�!'I $CANNEI2T IQESW.T �� WEB PoRn1l� CaN-S��l� ?JU,S7Wu,AT10�U, TRR�N/�116 �qND AT[.GOI.l� 5�►°R]�T: and doing such other work incidental thereto, all in accordance with the contract documents, marked S�MPL6 MASiE2� LA►3�KRibRY Tivr=�2MA'nCLv ►MANAGeMF�v7' SXJ'7�M Foa TrtE G�Y oF C�,2wA7�2 wArFe Poc_c.,��no,�1 L�oN�c. �esa�Pa�,� - R�uEsr Fr�R �u4��F�uqna�ls #3�-os Every bidder must take notice of the fact that even though his proposal be accepted and the documents signed by the bidder to whom an award is made and by those officials authorized to do so on behalf of the City of Clearwater, Florida, that no such award or signing shall be considered a binding contract without a certificate from the Finance Director that funds are available to cover the cost of the work to be done, or without the approval of the City Attorney as to the form and legality of the contract and all the pertinent documents relating thereto having been approved by said City Attorney; and such bidder is hereby charged with this notice. The signer of the Proposal, as bidder, also declares that the only person, persons, company or parties interested in this Proposal, are named in this Proposal, that he has carefully examined the Advertisement, Instructions to Bidders, Contract Specifications, Plans, Supplemental Specifications, General Conditions, Special Provisions, and Contract Bond, that he or his representative has made such investigation as is necessary to determine the character and extent of the work and he proposes and agrees that if the Proposal be accepted, he will contract with the City of Clearwater, Florida, in the form of contract; hereto annexed, to provide the necessary labor, materials, machinery, eyuipment, tools or apparatus, do all the work required to complete the contract within the time mentioned in the General Conditions and according to the requirements of the City of Clearwater, Florida, as herein and hereinafter set forth, and furnish the required surety bonds for the following prices to wit: LIMS-RFQ-7-13-OS.doc Page 31 Revised: 7/25/2005 PROPOSAL i2) . If the foregoing Proposal shall be accepted by the City of Clearwater, Florida, and the undersigned shall fail to execute a s3tisfactory contract as stated in the Advertisement herein attached, then the City may, at its option determine that the undersigned has abandoned the contract, and thereupon this Proposal shall be null and void, and the certified check or bond accompanying this Proposal, shall be forfeited to become the property of the City of Clearwater, Florida, and the full amount of said check shall be retained by the City, or if the Proposal Bond be given, the full amount of such bond shall be paid to the City as stipulated or liquidated damages; otherwise, the bond or certified check accompanying this Proposal, or the amount of said check, shall be returned to the undersigned as specified herein. Attached hereto is a bond or certified check on �,C�, ,s f Z 2 ZL�t�� -j �rsi- Bank, for the sum of /�ev► �'17av.fCtn J or�e. h�►�dre� cw�s (being a minimum of 10% of -e.'Stif deJla,�' �a�ov (�/o, �� a8 actor s total bid amount). The full names and residences of all persons and parties interested in the foregoing bid are as follows: (If corporation, give the names and addresses of the President and Secretary. If firm or partnership, the names and addresses of the members or �artners. The Bidder shall list not only his name but also the name of any person with whom bidder has any type of agreement whereby such person's improvements, enrichment, employment or possible benefit, whether sul�contractor, materialman, agent, supplier, or employer is contingent upon the award of the contract to the bidder). NAMES: ADDRESSES: Mr• L�,�ac.� Ko�v� PE, MCP �PREs�O�T) / 2�3 5'evt� �c�e� Or;�e , Seuu� Lake;, N� Z7.3�b /�•(r Tho►v�s �lc.(ean �S�r�al�y� Ilo Gra��S1+��F Se+,h„ (�.kcs� �lJc2�3�6 Signature of Bidder: � (The bidder must indicate whether orporatio Partnership, Company or Individual). LIMS-RFQ-7-13-OS.doc Page 32 Revised: 7/25/2005 PROPOSAL (3) The person signing shall, in his own handwriting, sign the Principal's name, his own name and his title. Where the person signing for a corporation is other than the President or Vice-President, he must, by affidavit, show his authority, to bind the corporation. By: � Cl�sn�/f �iEsz.ro Title: V�t.L� PRE.�aGVT Business Address of Bidder: �SF9(, hb�N 6Qo�E s�k�oa� RnAd City and State: W�sT En/ a� �I C- Zip Code 273 7(o Dated at ll� �� AM , this o2�"d day of AuyvSt , A.D., 2005 LIMS-RFQ-7-13-OS.doc Page 33 Revised: 7/25/2005 CITY OF CLEARWATER ADDENDUM SHEET PROJECT: Acknowledgment is hereby made of the following addenda received since issuance of Plans and Specifications. Addendum No. 1 Date: �.�,Ust N�1ooS Addendum No. Date: Addendum No. Addendum No. Addendum No. Addendum No. Addendum No. Addendum No. Addendum No. Addendum No. Addendum No. Date: Date: Date: Date: Date: Date: Date: Date: Date: IIICE 1��2C5�OF�clT (Title of Officer) �/� j�s (Date) LIMS-RFQ-7-13-OS.doc Revised: 7/25/2005 7nc . �. P�p�l �� fi. f�l'�ndix f3} BIDDER'S PROPOSAL PRO]ECT: Laboratorv Information Management System ILIMS� ITEM EST. UNIT NO. DESCRIPTION UNIT OTY PRICE TOTAL 001 LIMS DEVELOPMENT AND DELIVERY COMPLETE Sample Master° Pro LIMS Enterprise (SQL Server) Modules: 1. Sample Tracking 2. Data Entry 3. Sample Scheduling 4. QA/QC 5. Electronic Data Transfer 6. ChemicalInventory 7. Resource Management 8. Maintenance Module** 5-user concurrent user license discount $19,955.00* $19,955.00 $8,725.00 $12,415.00 $8,725.00 $8,725.00 $8,725.00 No Charge $19,955.00* ' $19,955.00 $8,7 25.00 $12,415.00 �' $8,725.00 `� $8,725.00 .- $8,725.00 -r No Charge $43,612.50 -$43,612.50 � (Section 1A, in the Scoue of Work — naae 1) �43 612 50 $43 612 50 LIMS Software cost with 5 concurrent user aualied• Sample Master� Pro LIMS Result Point (web portal) (Section 4.0, section F,4 (emergency response) in the Scope of Work — page 22) Please note that configuration of Result Point requires Microsoft IIS and it is strongly recommended that servers be configured with Secure Socket Layer with Electronic Server Certificates. Sample Master° Pro LIMS Rugged Palm Field Unit (Section 4.0, section E in the Scope of Work — page 22) ITEM EST. UNIT NO. DESCRIPTION UNIT OTY PRICE TOTAL LIMS Software (8) module $43,612.50 $43,612.50 Result Point (web portal) (1) module $1Z,497.50 $12,497.50 `: Rugged Palm (1) 1 unit $1,450.00 $1,450.00 s'� 002 PRODUCT SUPPORT (Section 5.0, section A2 in the Scope of Work — page 23) ATL Gold Support (1 year from Anniversary Date) - Includes LIMS account manager, Unlimited Technical Support via a toll-free number, Programming Support (2 hours included at no charge), Dial-in Remote Support (available at a reduced rate from Silver), Access to Web Site User Support Area, Software Service Packs, Product Upgrades, Migration Credit, and Sample Masterp Solutions Newsletter (ATL GOLD Support is 15% of the fist price of the software). ITEM EST. UNIT NO. DESCRIPTION UNIT OTY PRICE TOTAL ATL GOLD Support year (1 year) 01994-2005Accelerated Technology Laboratories, Inc. All rights reserved. SAM !E � MILSTER`y $13,083.75 $13,083.75 �. 003 TRAINING (Section 6.0, section A1 in the Scope of Work - page 24) On-site training on Sample Master° Pro LIMS Software: The LIMS training will be a minimum of three (3) days for each of two (2) groups of people plus two (2) additional days for managers, or sufficient additional time to assure that the staff is well trained in every aspect of the LIMS system. Total on-site training (5 days to be broken down as described in Scope of Work) ITEM EST. UNIT NO. DESCRIPTION UNIT QTY PRICE TOTAL LIMS Training (day) 5 days on-site $2,250.00 $11,250.00 iz. 004 INSTALLATION SERVICES On-site installation of Sample Master° Pro LIMS Software on City of Clearwater's Server and client computers for 5 concurrent users, however more than 5 computers can be installed with the LIMS software if desired. ITEM EST. UNIT NO. DESCRIPTION UNIT OTY PRICE TOTAL LIMS Software Installation (day) 1 day on-site $2,250.00 �-? $2,250.00 Instrument parser training (day) 4 days on-site $Z,250.00 $9,000.00 +�{ and installation (on-site) Reimbursement of Travel Expenses 10 total days on-site $2,745.00 $2,745.00 �' 005 INSTRUMENT INTEGRATION SOFTWARE (Section 3.0, section A1 in the Scope of Work - page 20) (ON-SITE INSTALLATION AND TRAINING OF INSTRUMENT PARSERS ARE INCLUDED UNDER INSTALATION '3 C05TS ABOVE) ITEM EST. UNIT NO. DESCRIPTION UNIT QTY PRICE TOTAL (1) PE Optima 2000 ICP-OES (1) (2) PE Aanalyst 600 , AA furnace (1) (3) Bran-Luebbe TRAACS 800 (1) (4) Dionex ICS 2000, (1) Ion Chromatograph (5) Man-Tech PC Titrator with Man-Tech BOD Assay Plus (1) (7) Varian Saturn 2000 GC/MS (1) (8) PE FIMS 100, Mercury Analyzer (1) (9) Any instrument with (1) an RS-232 port $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $750.00 $350.00 $750.00'�� $750.00 ;' .. $750.00 ;' ' $750.00 !, $750.00 $750.00 , ' $750.00 ' $350.00 Optiona/ Product Offerings: 006 Barcode Hardware and Software (Section E, #1 in the Scope of Work - page 8) (Optional product offering- as sample labels fed into a plain paper laser printer can also print out sheets of bar-coded labels on Avery label sheets; the 128 barcode font is included in the price of the LIMS. This special priced starter package is for laboratories that would like to begin utilizing barcodes on sample bottle labels generated from their LIMS. • Eltron 300 DPI label printer and any required software • 1 extra ribbon 01994-2005 Accelerated Technology Laboratories, Inc. All rights reserved. � SAN �i MI ER`� • 2 rolls of standard labels (quantity per roll 1000) • 2 hand-held CCD barcode scanners • All required cables • Installation and training included (when purchased with ATL's LIMS) ITEM EST. UNIT NO. DESCRIPTION UNIT OTY. PRICE TOTAL Barcode Starter Package (package) (1) $2,995.00 $2,995.00 *this is the price for an UNLIMITED site license, discounts apply for fewer licenses ** Included free of charge with the Sample Tracking Module. Sample Master° Pro LIMS Software utilizes Microsoft Access as the report writing tool and the LIMS software cost includes the LIMS report writing tool as specified in the City of Clearwater's Request for Proposal. (Other report writing tools can be utilized as well, including Microsoft Word, Microsoft Excel, Crystal reports, but since the canned reports in Sample Master are all Microsoft Access based those tools are included in the proposal. CONTRACTOR: Accelerated Technolo�v Laboratories, Inc. BIDDER'S GRAND TOTAL $101,488.75 (Numbers) BIDDER'S GRAND TOTAL One Hundred One Thousand Four Hundred Ei�htv-Ei�ht Dollars and Sevent� Five cents (Words) THE BIDDER'S TOTAL ABOVE IS HIS TOTAL BID BASED ON HIS UNIT PRICES AND LUMP SUM PRICES AND THE ESTIMATED QUANTITIES REQUIRED. THIS FIGURE IS FOR INFORMATION ONLY AT THE TIME OF OPENING BIDS. THE CITY WILL MAKE THE TABULATION FROM THE UNIT PRICES AND LUMP SUM PRICE BID. IF THERE IS AN ERROR IN THE TOTAL BY THE BIDDER, IT SHALL BE CHANGED AS ONLY THE UNIT PRICES AND LUMP SUM PRICE SHALL GOVERN. 019944005 Accelerated Technology Laboratories, Inc. All rights reserved. SAMPLE � MASTER" Accelerated �� C E R T 1 F I E D o� TQCIIIIOI�Ogy Partne� '�j,,,�__ c�,� <� LABORATOR1E51NC. Email: info�ailab.com • www.atlab.com 496 Holly Grove School Road • West End, North Carolina 17376 • Telephone 910-673-8165 • 1-800-565-LIMS (5467) • Fax: 910-673-8166 Name / Address City of Clearwater Attn: Maria De la Cantera 1605 Harbor Drive Clearwater, FL 33755 Description Sample MasterC� Pro Sample Tracking module Sample MasterC� Pro Data Entry module Sample MasterC� Pro Sample Scheduling module Sample Master� Pro QA/G1C module Sample MasterC� Pro Electronic Data Transfer module Sample MasterC� Pro Chemical Inventory module Sample Master0 Pro Resource Management module Sample MasterC� Pro Maintenance module (included at no charge) Special 5-user License Discount "(50% off software only) " Includes an additional 5-user license with participation in ATL's Customer Spotlight Program Sample MasterC� Result Point software (For Client Remote Web Access - allows clients to access order/results status, analytical data and PDF reports directly from the Sample Master� database) " Includes support for 1 year Special Sample MasterC� Result Point Discount (50% Off software only) Sample Master Rugged Palm Pilot with Laser Scanner (includes Palm Terminal, 2 MG ROM/2MB RAM, Slip Case, Stylus, and Software) Qty 1 1 1 1 1 1 1 1 ATL Gold Support (1 year from Anniversary Date) - Includes LIMS 1 account manager, Unlimited Technical Support via a toll-free number, Programming Support (2 hours included at no charge), Dial-in Remote Support (available at a reduced rate from Silver), Access to Web Site User Support Area, Software Service Packs, Product Upgrades, Migration Credit, and Sample MasterC� Solutions Newsletter On-Site Training of Sample MasterC� Pro LIMS software - 5 days This Quote shall be valid for 30 days * ATL Terms & Conditions Shall Apply 5 Tota I Quotation Date G�uotation # 8/22/2005 11491 Rate 19,955.00 19,955.00 5,725.00 12,415.00 8,725.00 8,725.00 8,725.00 0.00 -43,612.50 24,995.00 -12,497.50 1,450.00 13, 083.75 2,250.00 Total 19,955.00 � 19,955.00 '- 8,725.00 = 12,415,00 i 8,725.00 S 8,725.00 � 8,725.00 % 0.00 -43,612.50 S 24, 995.00 �� q ( -12,497.50 ;' 1,450.00 i�� 13,083.75 i! 11,250.00 i � Christine Paszko, Ph.D. Vice President, Sales & Marketing Accelerated Technology Laboratories, Inc. Leaders in Laboratory IntBr�oh Management Systems Accelerated Technology LABOAATORIES INC. Micr�solt° � C E R T I F 1 E D o Partner �,� Email: info�atlab.com • www.atlah.com 496 Holly Grove School Road • West End, North Carolina 27376 • Telephone 910-673-8165 • 1-800-565-LIMS (5467) • Fax: 910-673-8166 Name / Address Q u otat i o n City of Clearwater Attn: Maria De la Cantera 1605 Harbor Drive Date Quotation # Clearwater, FL 33755 8/22/2005 11491 Description On-Site Installation of Sample Masterfl Pro LIMS software - 1 day On-Site Instrument Parser Training and Installation - 4 days Instrument: PE Optima 2000 ICP-OES Instrument: PE Analyst 600 AA Furnace Instrument: Bran-Luebbe TRAACS 800 Instrument: Dionex ICS 2000 lon Chromatograph Instrument: Man-Tech PC Titrator with BOD Assay Plus Instrument: Varian Saturn 2000 GC/MS Instrument: PE FIMS 100 Mercury Analyzer Instrument: Any Instrument with an RS-232 port Reimbursement of travel expenses (airfare, hotel, rental car, meals, parking) Optional Item not included in this quotation: Barcode Starter Package (Includes 1 Eltron 300DPI Printer, 2 Hand-Held Scanners, 1 Ribbon, 1 Roll of Labels (1000), Barcode Software and all required cables: $2,995.00 Out of State Sale: Exempt from North Carolina Sales Tax This Quote shall be valid for 30 days ' ATL Terms & Conditions Shall Apply � 1 4 1 1 1 1 1 1 1 1 1 Total Rate Total 2,250.00 2,250.00 ' % 2,250.00 750.00 750.00 750.00 750.00 750.00 750.00 750.00 350.00 2,745.00 0.00% 9,000.00 ' �+� 750.00'�. 750.00 ;'' 750.00 " 750.00 � � 750.00 �, 750.00 ,` ,� 750.00 : � 350.00 ' 2,745.00 �� $101,488.75 Christine Paszko, Ph.D. Vice President, Sales & Marketing Accelerated Technology Laboratories, Inc. Leaders in Laboratory InIBYd�� Management Systems Accelerated Technotogy UBDMTORlESINL CERT�IFIEtD N � P2rtnftl a (�(�(� ��Ji!Q..�7li�71.. Email: info tlab.com • www.atlab.com 496 Holly Grove School Road � West End, North Cazolina 27376 � Telephone: 910.673.8165 � 1.800.565,LIMS (5467) � Fax 910.673.8166 TERMS AND CONDTTIONS Customer orders and ATL agrees to furnish the Equipment, Software and Services in accordance with the terms of this Agreement. This Agreement supersedes the terms and conditions of any purchase documents submitted by the Customer. 1. EQUIPMENT Customer agrees: (i) that any problem with the Equipment shall be the responsibility of its manufacturer; (ii) not to hold ATL or its representatives liable for any problem such problem with any Equipment; (iii) to provide reasonable access for installation of the Equipment, and use the Equipment in a manner consistent with the recommendations of the manufacturer; (iv) to execute all documents as may be reasonably requested by the manufacturer in connection with the purchase of Equipment; (v) not to relocate the Equipment to a different address, site or laboratory without the prior written consent of ATL. 2. SOFTWARE a) Provided Customer makes full and complete payment(s) to ATL as described in Section 5 below. ATL grants to customer a non-transferable, non-exclusive, limited license: (i) for its employees and agents to use the Software in a machine-readable form on the Equipment or other computer hazdware approved by ATL and at the site specified in this Agreement solely for the Customer's internal business purposes and (ii) to make up to two backup copies of machine readable code portions of the Software and printed listings thereof, for backup or archival purposes only, which copies shall be subject in all respects to the terms and conditions hereof. b) Customer agrees and understands: (i) that no title to the Software, its copies or to its intellectual property is transferred to Customer (ii) that the Software is derived in part and may contain portions of software code proprietary to others; (iii) that it shall not disassemble or decompile the Software; and (iv) that it shall not publish any results of benchmark tests run on the Software. c) Customer shall have no rights to any modifications, enhancements or extensions with respect to the Software. d) If the Equipment is not operative, Customer may transfer to and use the Software on other, approved equipment at the Designated Site, provided Customer informs ATL of such transfer in writing. e) The Software is not specifically developed, manufactured or licensed for use in the planning, construction, maintenance, operation or use in any nuclear capacity or for the flight, navigation, or communication of aircraft or ground support equipment. fl Upon any termination of the license granted under this Agreement, Customer shall immediately cease use of the Software, and either deliver to ATL the Software and all copies of the Software, and all documentation containing the Software and other proprietary information, or destroy such materials on the instruction of ATL. g) Customer shall display all proprietary and copyright notices and legends to the extent and in the manner specified by ATL. h) Customer is aware that in the event Customer fails to pay all amounts due to ATL in accordance with the terms and conditions of this Agreement, the software provided to the Customer by ATL will be disabled so as to prevent the automatic generation of reports. In the event that the Software is disabled in this manner, Customer should contact ATL immediately. CUSTOMER ACKNOWLEDGES AND AGREES THAT ATL SHALL NOT BE Signature Print Name Date Leaders in Laboratory Information Management Systems Revision Date Code: 37502 Acceterated Technology LAADAJITORIES INC CHR�iI�FIVfi,D �, PartneX �� +�+ j?OUi... r7L7.S_ Email: info atlab.com • www.atlab.com 496 Holly Grove School Road � West End, North Carolina 27376 � Telephone: 910.673.8165 � 1.800.565.LIMS (5467) � Fax 910.673.8166 LIABLE FOR ANY LOSSES OF TIME OR DATA, OR FOR ANY OTHER DAMAGES THAT MAY RESULT IN ANY WAY FROM THE DISABLING OF THE SOFTWARE PURSUANT TO THIS SECTION. 3. SERVICES In the performance of Services specified in this Agreement, ATL and any agent or employee of ATL, is acting as an independent contractor, and not as an employee, of Customer. 4. PROPRIETARY INFORMATION Customer shall hold in confidence, and make reasonable efforts to ensure that its employees and agents also hold in confidence all technical, business or financial information of ATL and shall not disclose such information except upon written authorization of ATL. 5. PAYMENT AND SHIPMENT Invoices shall be due and payable prior to the date of installation in accordance to the terms stated in this Agreement, unless otherwise specified by ATL. Amounts unpaid when due shall accrue late charges of 1.5% per month or, if lower, the ma�cimum rate allowed by law. All shipments shall be FOB ATL's place of business, and all shipping charges and insurance costs will be paid by the Customer. ATL shall have a security interest in any Equipment purchased hereunder until payment in full and Customer will cooperate fully in further evidencing and perfecting such interest. All delivery dates specified by ATL are estimates only and shall not be binding. Equipment modified by ATL to meet safety concerns or government standards shall be deemed conforming. 6. WARRANTIES AND LIABILITY (a) ATL warrants that the Software media and associated documentation shall be free from defects in materials and workmanship for a period of ninety (90) days following date of delivery of such items (the "Warranty Period"). ATL agrees to replace or repair any such media or documentation which is found defective during the Warranty Period provided Customer notifies ATL during the Warranty Period or within ten (10) days thereafter. (b) ATL does not, however, warrant that (i) operation of the software shall be uninterrupted or error-free, or (ii) Software functions shall operate in all combinations selected by Customer. (c) THERE ARE NO OTHER WARRANTIES, EXPRESS OR IMPLIED (INCLUDING, WITHOUT LIMITATION, WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE) FOR THE EQUIPMENT, SOFTWARE OR SERVICES, NO THIRD PARTY SUPPLIER OF SOFTWARE WARRANTS THE SOFTWARE OR ASSUME ANY LIABILITY FOR ANY DAMAGES SUFFERED OR INCURRED BY CUSTOMER. (d) IN NO EVENT WILL ATL BE LIABLE FOR ANY SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES OCCURRING OUT OF OR 1N CONNECTION WITH THIS AGREEMENT OR FOR DAMAGES IN EXCESS OF THE AMOUNT RECEIVED UNDER THIS AGREEMENT. 7. MISCELLANEOUS (a)ATL agrees to use reasonable commercial efforts to provide Equipment, Software and Services described in this Agreement, provided, however, ATL is not responsible for the success or failure of the application performed by, or Signature Print Name Leaders in Laboratory Information Management Systems 2 Revision Date Code: 37502 Acceterated Tethnology UIBOAATORIES AIC CERT�lFIErD � Partner � /� ��2tilri4...�11� _ Email: info atlab.com • www.atlab.com 496 Holly Grove School Road � West End, North Cazolina 27376 � Telephone: 910.673.8165 � 1.800.565.LIMS (5467) � Fax 910.673.8166 the conclusions drawn from, the use of the Equipment, Software, or Services by the Customer or any other party. Under no circumstances shall ATL be reyuired to provide any Equipment, Software or Services creating or having functionality not expressly described in writing(s) provided by Customer to ATL prior to the effective date of this Agreement or any relevant Amendment thereto. (b) ATL agrees to provide problem reporting procedures to Customer for reporting Software "bugs", malfunctions, programming errors and related problems. Upon notification of any "bug" in the Software pursuant to the procedures set forth by ATL, ATL will investigate and if able to verify and reproduce the bug, use reasonable commercial efforts to correct such "bug" or create a work around. (c) Subject to Section 6(b) above, ATL shall indemnify Customer against costs and damages arising from claims of infringement of any U.S. patent or copyright resulting from the use of Software within the scope of the license, provided ATL is (i) promptly notified of all such claims; (ii) given sole control of any litigation or settlement, and provided further that the Customer shall provide all available assistance to enable ATL to defend or settle any such claims or proceedings. The foregoing obligation of ATL does not apply with respect to Software: (A) not developed and produced by ATL; (B) made in whole or in part in accordance to Customer's specifications; (C) which was modified by a party other than ATL after shipment by ATL; (D) combined with other products where the alleged infringement relates to such combination or otherwise would not have occurred but for the combination; or (E) where Customer continues allegedly infringing activity after being notified thereof or after being informed of modifications that would avoid the alleged infringement. Customer will indemnify ATL for any liability, cost, expense and attorney's fees incurred in connection with a claim for infringement with respect to software, products or equipment: (F) not developed and produced by ATL; (G) made in whole or part in accordance to Customer's specifications; (H) which, if provided by ATL, was thereafter modified by a party other than ATL; (I) that combines ATL products with other products where the alleged infringement relates to such combination or otherwise would not have occurred but for the combination; or (J) where Customer continues allegedly infringing activity after being notified thereof or after being informed of modifications that would avoid the alleged infringement. (d) Customer agrees to comply with all applicable regulations of the U.S. Department of Commerce and the U.S. Export Administration with respect to the Equipment and Software. (e) The rights or obligations stated herein shall not be assignable or transferable in whole or in part by Customer without the prior written consent of ATL, and any attempt to do so shall be null and void. (� ATL may terminate this Agreement and all licenses and rights granted hereunder if Customer fails to comply with any term or condition stated herein. (g) In the event any legal action is initiated to enforce any provision of this Agreement, the prevailing party shall be entitled to collect its reasonable attorney's fees and costs incuned in connection with such action. North Carolina law shall govern in this Agreement and the sole venues for any action arising out of or relating to this agreement shall be in Moore County, North Carolina or Guilford County, North Carolina. (h) These terms may be waived or amended only by a writing signed by the parties. Failure or delay in asserting a claim hereunder shall not be deemed a waiver thereof and no waiver with respect to a particular instance shall be deemed to waive generally the applicable right. Section headings are for convenience only and shall not affect interpretation. Notices shall be in writing, and sent by registered or certified mail. Signature Print Name Date Leaders in Laboratory Information Management Systems 3 Revision Date Code: 37502 «......- laboratory_ Information Management System � �learwater U Water Pollution Control Laboratory Request for Qualifications #31-05 ��:� �;: �� F .� ,� �� Y ACcelerated Technology LABORATOWES INL Your Laboratory Data ManagBR�ent Solution Provider �� CERTIFIED Partner e 496 Holly Grove School Road. West End ■ North Carolina ■ 27376 � Phone: 800.565.LIMS (5467) ■ Fan: 910.673.8166 ■ Email: info(a2aUab.com ■ Internet: www.atlab.com s SCOPE OF WORK PART 1: LIMS TECHNICAL SPECIFICATIONS These specifications identify minimum and optimal functional and processing capabilities required for the computerized Laboratory Information Management System (LIMS). The LIMS system is required to support a minimum of 5 concurrent users without noticeable degradation in performance. For the purpose of this proposal and any ensuing contract, the term "user" is defined as laboratory personnel actively addressing the main LIMS application. It does not include instrument interfaces, or peripheral devices. If there are performance limits on other forms of access (i.e. instrument intertaces) these need to be clearly specified. Additionally, the delivered LIMS shall support users external to the laboratory via intranet access with appropriate security and encryption. Sample Master� Pro LIMS was designed for a multi-user environment. ATL will provide a 5-user license in the attached quote. Instrument interfaces or peripheral devices are not counted as "users" by ATL. Sample Master� Pro LIMS supports users external to the laboratory via a secure network and via the Internet. 1. A computerized LIMS shall provide water quality laboratory with management information tools to allow for efficient laboratory operations in producing timely and accurate analytical data and assessment reports, and to make validated data available to all required parties. Data entry, access and retrieval shall be provided, at a minimum, for the following: .•Manual data input by users ,•Direct data acquisition from laboratory instruments ,•Data storage .•Data processing and manipulation •Data retrieval and reporting The above are all standard features of Sample Master� Pro LIMS. . 2. The LIMS processing functions shall include the following: .•System management ,•Database management •Sample management and tracking .•Workload management .•Sample analysis and data acquisition .•Data validation and limit checking .•Quality control/assurance .•Statistical data analysis and graphics ,•Data import/export capability ,•Ad-hoc querying ,•Bar-coding .•Reporting The above processing functions are all standard features of Sample Master� Pro LIMS. 3. The LIMS shall perform data acquisition from laboratory instruments, while simultaneously supporting workstations on a standard Windows operating system such as Windows 2000 or XP performing other LIMS functions. Sample Master� Pro LIMS can perform data acquisition from laboratory instruments through the Electronic Data Entry Module while simultaneously supporting standard Windows operating system workstations perForming other LIMS functions. ATL has a library of over 250 instruments that ATL has previously intertaced with Sample Master� Pro LIMS. 4. The LIMS application software shall be comprised of proven packages. These packages shall permit onsite configuration and generation of all application related programs including displays, tables and reports. Sample Master� Pro LIMS is comprised of 10 proven modules that offer the laboratory a feature rich total solution for managing their analytical laboratory operations. Each module allows users DAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 1 to configure the field names, and users can modify existing reports in addition to integrating new screens into the LIMS. The database administrator (DBA) has permission to add new displays (forms), tables and reports and ATL engineers will train the DBA to make such modifications during on-site configuration and LIMS administrator training. 5. The LIMS application software shall be a standard product, which is fully developed, tested, and supported. It shall be compatible with the system hardware, and shall meet the functional requirements s�ecified. Sample Master Pro LIMS version 2.1 was first launched in 1994, today ATL has launched version 8.0. ATL has been providing LIMS and laboratory automation solutions for over a decade and offers superior technical support. Through the ATL metals plan, ATL GOLD support offers toll-free technical support, a dedicated account manager, LIMS solutions newsletters, user group meetings, user message board to exchange ideas and code with other users. ATL also offers annual user meetings at major conferences, such as Pittcon, AWWA and WEFTEC. 6. All system software shall be designed to allow growth. Sufficient space shall be recommended to allow for additional screen displays, and for additional, or expanded, reports. Sample Master� Pro LIMS enterprise edition based on SQL Server and Oracle is scalable and designed to grow with the laboratory. ATL engineers will work with the City of Clearwater IT team to determine the amount of sufficient space to allow for laboratory growth of additional screen displays and new reports. 7. The LIMS package must be well suited for the requirements of a laboratory system for a municipal water and wastewater facility. Sample Master� Pro LIMS was designed specifically for the water and wastewater facility. Many members of the development team of the LIMS have extensive backgrounds working as engineers, chemists and laboratory managers in the water and wastewater industry, 8. The software package shall be configurable to allow the presentation of laboratory results in a SQL table, which shall allow the City to use standard SQL queries to retrieve dated test results for any and/or all of the laboratory results as soon as those results are available and included in the LIMS, for import into external reports by others. Sample Master� Pro LIMS is configurable to allow the presentation and export of laboratory results in a SQL table, the laboratory IT team can write standard SQL queries to retrieve data test results and/or the entire laboratory results as soon results are validated and approved. B. System Configuration 1. Network The LIMS shall be installed on the Ethernet network, using TCPIP (Transfer Control Protocol/Internet Protocol). Sample Master� Pro LIMS will be installed on the Ethernet network, using TCPIP (Transfer Control Protocol/Internet Protocol). 2. Database Server The LIMS shall run as a true client/server network and support operation on a Microsoft SQL Server. The computer(s) and the SQL software are being provided separately by the City of Clearwater. Sample Master°� Pro LIMS shall run as a true clienUserver network and support operation on a Microsoft SOL Server. ATL understands that the city will supply the client and server as well as the SQL Server licenses. 3. Personal Computers The client workstations are Pentium 4 with 512 MB Ram. The operating system is Windows 2000. The clients will not be dedicated to the LIMS, but will also have other systems operating on them, such as MS Word.XP ATL supports Windows 2000 and XP, and the technical specifications (P4 with 512 RAM) are suitable for running Sample Master� Pro LIMS and other applications such as those included in the Microsoft O�ce Suite. OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 2 4. System Maturity The LIMS must be a mature system, which is neither at the beginning nor at the end of its life cycle. The system must have been installed and operating globally in at least 200 laboratories for at least of 10 years. The proponent must be a wholly owned US business; be ISO 9001:2000 Certified and be a Microsoft Certified Partner for a minimum of 8 years. Sample Master� Pro LIMS is a mature system, neither at the beginning nor at the end of its life cycle. ATL has been a leader in the LIMS industry for over a decade, automating laboratories one at a time. ATL has an installed base approaching 300 sites worldwide. ATL is also ISO 9001:2000 Certified and has been a Microsoft Certified Partner for 8 years and an Oracle Business alliance Partner. A. System Management 1. Licensed users The LIMS must be capable of supporting the minimum of 5 concurrent users. The system should allow an unlimited number of named users and restrict the number of active users or concurrent users to those on the license. Sample Master� Pro LIMS provides a license for 5 concurrent users and the system also allows an unlimited number of named users and will restrict the number of active users or concurrent users to those on the license. 2. Compatibility The LIMS shall run on a server platform and an operating system compatible with the existing standard Windows Operating System network. Sample Master� Pro LIMS was designed to operate on the standard Windows Operating System network. ATL is a Microsoft Certified Partner and is a beta site for many of the new Microsoft products including SQL Server 2005. 3. System Management Tools The LIMS shall provide system management tools to permit safe, secure management of the LIMS application. These tools shall include application security, data audit trail, database backup/recovery, data archival/restoration and interoperability with SQL-based applications. ATL provides system management tools to ensure safe, secure data management of the LIMS information. The tools include LIMS security, LIMS access and permissions, full data audit trail, database backup and recovery tools integrated in the database application and SQL Server as well as data archival and restoration. 4. Security The LIMS system shall provide security features to ensure that only authorized individuals enter, view and modify data. Access levels shall be definable to restrict use of system level functions (such as user authorization), and to provide data access levels to restrict the use of data entry, data approval, data retrieval, data modification, data base structure creation or modification functions. Sample Master� Pro LIMS has security features to ensure that only authorized individuals enter, view and modify data. Access levels are definable by the system administrator to restrict use of the system level functions (user authorization) and to provide data access levels to restrict the use of data entry, data approval, data retrieval, data modification and database structure creation or modification functions. 5. Data Archiving and Purging The LIMS shall provide a means to archive and purge (retire) data at the request of the system administrator, or automatically after a specified period of time. Sample Master� Pro LIMS provides a means of easily purging and archiving data from the active database to the archive database, either automatically or after a specified period of time. �OAccelerated Technology Laboratories, Inc. — City of Clearvuater LIMS Proposal Page 3 •Archiving is removing the data from the active database and storing it in a retrievable form elsewhere. Archiving must include user-selectable parameters. These parameters shall include collection and approval date ranges, sample types, location, and test. The end user shall have the capability to view archived data without restoring the data into the "active" location. Sample Master� Pro LIMS allows users to archive data using the "master query" function, which allows users to select various parameters including collection and approval date ranges, sample types, location, and test. The end user can view the archived data without restoring the data into the "active" location. .•The purge utility must also include user-selectable parameters. These parameters shall include user-selectable parameters. These parameters shall include collection and approval date ranges, sampling point and sample type. Because Sample Master� Pro LIMS is a relational database and has referential integrity; users can retire parameters that have data associated with them, it is a GALP violation to delete data. Parameters that can be retired include collection and approval date ranges, sampling point and sample type. 6. Static Information The LIMS shall maintain static administrative information such as, but not limited to, procedures, safety information, and project information. Authorized users shall be able to query, add, modify and delete this information. Sample Master� Pro LIMS allows the maintenance of static administration information such as on-line SOP (standard operating procedures), safely information, and project information. Users with the appropriative permissions will be able to query, add, modify and delete this information. B. Database Management System 1. The LIMS program shall utilized referential integrity to assure that data is well ordered and not lost. The LIMS shall provide a relational database management system (RDBMS) for information storage and retrieval. Sample Master� Pro LIMS utilizes referential integrity to ensure that data is well ordered and not lost. Sample Master� Pro LIMS is a relational database management system (RDBMS) for information storage and retrieval. •The LIMS RDBMS shall be available with a full use license, providing not only access to the LIMS application, but also application development tools, a data dictionary, a data query utility, and a �eport writer. The preferred database is SQL. The database development tools shall be licensed for two users. The report writer tools shall allow devetopment by 5 concurrent users. Sample Master� Pro LIMS will include development tools for the database and 5 concurrent users of Microsoft Access as the report writing tool. The enterprise edition of Sample Master� Pro LIMS based on Microsoft SQL Server will be quoted. ATL does not provide the SQL Server licenses, but can provide quotes if the ciry is interested in having ATL purchase those licenses. •The RDBMS shall support web architecture. Sample Master� Pro LIMS with Result Point supports web architecture •The RDBMS shall support parallel processing. Sample Master� Pro LIMS supports parallel processing on the SQl Server and Oracle versions. •The RDBMS shall be able to support data spanning multiple physical disks. Sample Master� Pro LfMS supports data spanning on multiple physical disks with both the SQL Server and Oracle versions. •The RDBMS shall run on multiple server operating systems, such as Windows 2000 or XP. Sample Master� Pro LIMS supports multiple server operating systems including Windows 2000 and Windows XP. •Must allow users to incorporate new screens without Supplier intervention, so as to allow the Laboratory to manage and maintain the LIMS. Sample Master� Pro LIMS meets the above criteria and ATL will include in the cost proposal a copy of Microsoft Access for the report writer. The on-site installation team will OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 4 provide database administrator training on the tools required to manage and maintain the system and to create and modify existing reports. (Over 3 dozen reports are included with the LIMS). 2. Transaction Journal Utility A transaction journal utility shall provide database reconstruction in case of system failure. This facility shall restrict the possible loss of data to the database transactions in progress when the system fails. Proponent must provide written instructions for reconstruction. ATL engineers will review back-up and recovery procedures during the on-site database administrator training session. There is a SQL transaction journal utility that users can utilize to reconstruct the database in case of system failure. ATL has a white paper on suggested back-up procedures. ATL will also provide written instructions for �estoring the LIMS database and will review this with the LIMS database administrator. 3. Graphical User Intertace The LIMS user intertace and all interactive database management tools shall be a simple-to-use Graphical User Interface (GUI). The laboratory database administrator MUST be able to incorporate new Screens without having to contact the LIMS vendor, in order to control costs and to maintain control over the LIMS. Sample Master� Pro LIMS provides a Graphical User Interface (GUI) and was the first commercially available LIMS to utiliae Microsoft Windows. Easy to use features include hot look- up on pull-down lists, context sensitive on-line help and the ability to integrate new screens, reports, tables and queries without loosing the ability to upgrade to future versions. The laboratory database administrator can make modifications to the LIMS including adding new reports, modifying existing reports and adding new tables without contacting ATL. 4. Data Export The Database System shall be able to extract and convert data elements into an ASCII format for use outside of the LIMS application environment. The following file formats are desired or required, as indicated: .•ASCII- Required .•EXCEL.xIs-Required .•ACCESS 97-Required ,•PowerPoint-Desired Sample Master� Pro LIMS is based on standard state of the art technology and has built-in exports to Microsoft Office applications including Word, Excel, Access, and PowerPoint. Users can also export to an ASCII (text) format, along with many other common export formats. Results data can easily be captured and exported from the Sample Master� Pro LIMS and the ATL engineers will cover data export during on-site user and database administrator training. The LIMS vendor shall provide a script for transferring data from the LIMS to the City of Clearwater WPC Laboratory in the event that the laboratory has any data to be migrated. ATL engineers can create scripts to import data from other databases, however this requires field matching and also requires that the engineers understand the database schema of the database and an understanding of the number of fields. ATL utilizes a FRS (Functional Requirements Specification) process in which the field names, lengths are clearly defined as the ATL engineers would need to create queries to field match the data from the database to be migrated to the LIMS. There is a built in export capability so that the LIMS result data can be exported to Excel, ATL will place a block of time in the quote to perform data migration as an optional item in the even that the City of Clearwater WPC Laboratory has any data to be migrated to the LIMS. 5. Data Import ,•The Database system shall be able to import an ASCII data file, convert it as needed, and store the data in the LIMS database management system. .•Historical data from an ACCESS database can be imported into the LIMS database. OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 5 Sample Master� Pro LIMS can import and export to ASCII (text) data file format, this feature will be reviewed during on-site training with the LIMS team. Historical data from Access can also be imported into the LIMS, this is a very straightforward procedure and required field matching is well defined, i.e. site table in LIMS would be matched to the site table in the Access database. 6. Interoperability The database system shall be ODBC (Open Database Connectivity) compliant. It will allow data exchange with other ANSI SQL ODBC compliant database systems, including Microsoft Access. Compliance will also enable the database to interface with ODBC compliant word processing, statistical analysis and spreadsheet software for producing reports, letters, memoranda and other documents. Sample Master� Pro LIMS is ODBC (Open Database Connectivity) compliant and will allow data exchange with ANSI SQL ODBC compliant database system including MS Access, SQL Server and Oracle. The ability to export will allow clients to export to Word Processing, statistical analysis packages, spreadsheets, such as MS Excel and MS Word. 7. Data Dictionary The data dictionary shall control the definition and manipulation of data, and facilitate changes to data structures. Sample Master� Pro LIMS provides a data dictionary that controls the definition and manipulation of data and manages changes to data structure. 8. Customizable The RDMS shall be user customizable to the extent that system administrators will be able to add functions to the program main menu and all othe� screens, add additional tables, queries and forms and design custom reports using SQL Server as the backend database engine. The design of Sample Master� Pro LIMS allows users to add items to the menus, pull down lists, and add new reports, tables, queries and much more using MS SQL Server as the backend database engine. C. Sample Management and Tracking 1. Sample Tracking Sample tracking shall begin with the sample �equest and track the sample through log-in, analysis scheduling, analysis, quality assurance, review and approval. An audit trail shall be maintained for each sample activity. Sample status will be readily retrieved. Sample Master� Pro LIMS allows samples to be tracked throughout the LIMS from sample request, login, analysis, scheduling, analysis and quality assurance, and review to final approval. An audit trail is maintained for each activity and department that the sample passes through. This allows laboratory staff and managers to rapidly view the sample status in the laboratory and to view any results if they have been entered. 2. Tracking Contract Lab Analysis The LIMS shall provide sample log-in and sample tracking capabilities capable of distinguishing in-house analyses from contract lab analyses. In-house analyses as well as analyses from different contract labs must be tracked separately. The proposed LIMS shall also enable the user to change the status of a sample from in-house to contractual. Sample Master� Pro LIMS has the ability to receive and track samples that were sent to outside contract laboratories for analysis. The LIMS can also track the in-house analyses separately from contract laboratory analyses and allows users to change the status of in-house to a contract analyses. If contract laboratories are providing the data electronically and if the desired client's database administrator can configure an Excel parser that recognizes the contract laboratories Excel format (in which data is returned to the laboratory) the data can be imported into the LIMS (following a supervisor review of the data) through the Electronic Data Transfer Module. OOAccelerated Technology Laboratories, Inc. — City of Cleanivater LIMS Proposal Page 6 3. Manual Sample Log-in A manual sample log-in function shall record data including sample collector, sample location, sample date and time, sample type, sample receiver, sample received date and time, priority assignment, test(s) assigned, and sample splitting and field test data. Fields shall be able to be made mandatory so that data is required before a sample can be committed to the database. Data shall be posted directly to the database. The log-in function shall be flexible enough to provide some degree of user customization, such as the addition of custom fields and custom sample identification formats, or to define sample types and categories. Sample Master� Pro LIMS Sample Tracking function includes the ability to manually record data including sample collector, sample location, sample date and time stamps, sample type, sample receiver, sample received date and time, priority, assignment, test(s) assigned and sample splitting and �eld tests data. The database administ�ator can make required fields mandatory before a sample is posted directly to the database. The login function is flexible enough to provide user customization, including the addition of custom fields and custom sample identification formats, or to define sample types and categories. 4. Multiple Sample Log-in A muttiple sample log-in function shall be provided. This function shall allow a batch of similar samples to be logged in one operation, assigning unique sample identifications to each sample, and duplicating common fields for each sample in the batch. Individual samples must then be modifiable at the user's discretion. Sample Master� Pro LIMS allows multiple sample log-in and this function is included in the Sample Tracking module. This function allows batch login (batch of similar samples can be logged in one operation), assigning a unique identifier to each sample and duplicating common fields for each sample in the batch. Users with appropriate permissions can then modify those samples as required, in terms of addition or deletion of tests. 5. Auto Log-in The LIMS shall be able to automatically log samples according to a stored schedule. Sample Master� Pro LIMS Sample Scheduling module allows the laboratory to automatically schedule collections and generate worklists and bar-coded labels for bottles to prepare for the sampling. There is a user friendly calendar function that allows users to select and store the dates of sampling. 6. Data Entry Data entry functions shall pertorm immediate database updates. Data shall be available for retrieval immediately after data entry. Historical data from an Access database can be imported into the LIMS database. Sample Master� Pro LIMS performs immediate database updates and data is available for retrieval immediately after data entry to users who have permissions to view the data. Historical Data from an Access Database can be imported. 7. Sampling Site Information Static information for sampling sites will be stored in the LIMS. The minimum data elements which will be stored are site ID, description, location, type, sample schedule and contact information. Sample Master� Pro LIMS does store static data related to the information for sampling sites, this includes site ID, description, location, type, GIS coordinates, sample schedule and contact information. 8. Electronic Import of Historical Results The LIMS shall provide the capability to import historical data that is stored in electronic format, particularly ACCESS. Yes, Sample Master� Pro LIMS can import data from Excel, Access and several other standard electronic formats. OOAccelerated Technology Laboratories, Inc. — City of Clearvvater LIMS Proposal Page 7 D. Sample Scheduling 1. Routine Samples The LIMS shall be able to store sample collection locations and the frequency that various routine sample types are to be collected from each location. The Sample Master� Pro LIMS Sample Scheduling module allows users to store sample collection locations as well as the frequency of sample collections from routine collection sites. Users have a variety of options to schedule the frequency, through a user friendly calendar function. 2. Automatic Login The LIMS shall be able to automatically log in routine samples including the following: .•daily routine samples .•samples for specified days of the week ,•monthly samples .•yearly samples Sample Master� Pro LIMS Sample Scheduling module can atomically login samples for daily routine collections, samples to be collected by user specified days of the week, monthly samples as well as yearly samples. 3. Automatic Test Scheduling For routine automatically logged samples, the LIMS shall be able to master schedule the test/analyses that will be required. The schedule shall include: .•daily routine samples ,•specified days of the week ,•monthly samples .•yearly samples .•quarterly .•semi-annually Sample Master� Pro LIMS can automatically schedule tests, log them into the LIMS, maintain the master schedule of test/analysis that will be required. The schedule includes the following; daily routine samples, specified days of the week, yearly samples, quarterly samples and semi-annual samples. 4. Sampling Site Information Static information for sampling sites will be stored in the LIMS. The minimum data elements which will be stored are site id., description, location, type, sample schedule and contact information. Sample Master� Pro LIMS stores the following static table information; site id., description, location, type, sample schedule and contact information, along with additional information such as GIS coordinates. E. Sample Collection 1. Bar-code Sample Labels The system shall permit printing sample identification labels with or without bar codes and reading/writing barcode labels style 128. Sample Master� Pro LIMS allows printing of labels with or without barcodes. It has integrated bar- coding and it supports the reading/writing of multiple barcode fonts including 128. ATL offers an introductory hardware barcode package, which includes a 300 DPI printer, 2 handheld CCD scanners, and printer software and all required cables. The cost of the barcode starter package will be included as an optional item. The barcode font for 128 is provided. OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 8 F. Sample Identification 1. Unique Sample Identification The LIMS shall automatically assign unique identification codes to each sample. In the case where a sample is split or subdivided, the LIMS shall assign and associate subsequent identification codes with the original sample. Sample Master� Pro LIMS assigns each sample a unique identifier, the format is user definable and in the even that a sample is split or an aliquot is removed, the per NELAC guidelines a subsequent code is generated which can be linked back to the "original" sample. 2. Priorities The LIMS shall allow user prioritizing of samples and their subsequent subparts and splits. Sample Master� Pro LIMS supports user definable priorities assigned to samples as well as splits, in addition to hold times for samples as well as prep batch hold times. 3. Sample Labels After uniquely identifying a sample, the LIMS shall be capable of providing labels for affixation to the sample container. The LIMS shall provide a standard format that can be duplicated and modified by an authorized user permitting various types of data to be retrieved from the database and incorporated on the label. The standard label format should include room for multiple fields besides the bar-code and be user configurable. Modifications shall allow including special handling or safety procedures. The system shall provide the ability to specify the number of copies of the labels to generate, and shall provide a reprint option for single or multiple additional labels. Sample Master� Pro LIMS has a standard sample label format that is a standard report in the LIMS that user can use as is or modify to meet any special requirements of their laboratory, such as handling procedures. The proposed 300 DPI label printer in the starter package supports multiple label sizes based on the amount of information that you would like to capture and users can print multiple sample labels if desired and also has a reprint option in the event that extra labels are needed. 4. Bar Codes The LIMS shall be able to generate and read bar code style 128 for identification, utilization on labels, chain of custody documents, and data entry purposes. Sample Master� Pro LIMS supports barcode style 128 along with many others and can be utilized on chain of custody labels, chain of custody documents, and data entry purposes. The 128 barcode font is an excellent selection as it contains an intemal check standard. G. Sample Receiving 1. Receiving Details When samples arrive at the laboratory, the LIMS shall capture, at a minimum the following receiving data items: •Date and time of receipt (mandatory field) Automatically captured in Sample Master� Pro LIMS .•Sample Receiver (mandatory field) This information is captured in Sample Master� Pro LIMS .•Location of sample (mandatory field) Users can enter this in Sample Master� Pro LIMS •Date and time of sample collection (mandatory field) Users can enter this in Sample Master� Pro LIMS ,•Sample collector (mandatory field) Users can enter this in Sample Master� Pro LIMS .•Sample identification code (mandatory field) Standard in Sample Master� Pro LIMS ,•Unusual sample conditions Users can enter this in Sample Master� Pro LIMS •Tests required (if not previously defined) Users can enter this in Sample Master� Pro LIMS ,•Tests requested Users can enter this in Sam�le Master� Pro LIMS ,•Field test results Captured in Sample Master Pro LIMS .•Comments or ability for Custom Fields Standard fields in Sample Master� Pro LIMS OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 9 Fields marked mandatory must be made mandatory in the LIMS so that a sample cannot be committed to the LIMS unless the required fields are completed. The system database administrator has the capability to make fields required, however if this is done and some information is NOT available at the time of login, the users will not be able to complete the login process and receive the samples, which may affect the ability to rapidly analyze the sample before the hold times expire. However, this is a laboratory decision on how to deploy the mandatory fields and the LIMS can support this requirement. 2. Multiple Entry Methods The LIMS shall permit entry of the receiving details in multiple ways: .•The LIMS shall be able to simultaneously log in and receive samples into the LIMS that are unexpected or non-routine. Sample Master� Pro LIMS is able to simultaneously log in and receive both regularly scheduled samples as well as unexpected or non-routine samples. .•Samples of a particular type that arrive in batch shall be received in batch. It shall not be necessary for the user to re-enter similar or repeat information for a series of samples. Sample Master� Pro LIMS can accommodate samples which arrive in batches and it is not necessary for users to re-enter similar or repeat (nformation for a series of samples. 3. Storage of Procedures and Tests The LIMS shall store information including tests required, lab sample preparation, sample holding time and/or storage requirements with each sample type, such that the LIMS or the user can associate these tests, procedures and time limits with an incoming sample. Sample Master� Pro LIMS stores information including tests required, lab sample preparation, sample holding times and/or storage requirements with each sample type, such that the LIMS or the user can associate these tests, procedures, and time limits with an incoming sample. 4. Associate Procedures and Tests with Samples Upon receipt of a sample, the LIMS shall associate appropriate preparation procedures and tests required for specific sample types. Users shall be able to add or delete assigned tests. Sample Master� Pro LIMS will associate the preparation procedure that has been configured and test required for a specific sample type upon receipt. Users have the ability to add or delete assigned tests. 5. Test Assignment Modifications Authorized users shall be able to modify tests or procedures assigned to logged in samples without modifying the standard procedures and test assignments. Sample Master� Pro LIMS allows authoriaed users to modify tests and/or procedures assigned to logged in samplss without modifying the standard procedures and test assignments. 6. Calculate Maximum Holding Time Based on sample types and tests required, the LIMS shall associate sample holding times with each sample based on its sampling time to produce maximum holding time/date(s). Sample Master� Pro LIMS can calculate maximum holding times based on sample types and tests required. The LIMS associates sample holding times with each sample based on its sampling time to produce maximum holding times and dates. H. TestlAnalyses Administration 1. Standard Tests/Analyses per Sample Type Each test or analysis/type shall be uniquely identified with a code by the LIMS. The test identification code shall permit the association of multiple test components with that test code. The LIMS shall store data about each component such that the user can indicate, upon initial entry of the data, which components require computer performed mathematical computations. Sample Master� Pro LIMS uniquely identifies each test or analysis by a unique identifier. The test ID code permits the association of multiple test components with that test code. The LIMS will OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 10 store data about each component such that the user can indicate, upon initial data entry those components that require calculations. 2. Associate Developed Calculations with Tests In order to automatically pertorm mathematical computations, the LIMS shall permit the development and association of mathematical routines developed by authorized users for designated test codes. Sample Master� Pro LIMS supports mathematical computations, which is a critical feature to the analyticat chemistry laboratory, as they routinely calculate many final results which are based on calculations, such as total nitrate, total chlorine and others such as percent moisture. 3. Test Data Modification Modifications and deletions of test data by authorized users shall be permitted. Modifications of test data can be made following entry and after validation and approval, however that action can only be done by an authorized user (one with the appropriate level of permissions) and a full audit trail is spawned that records the date and time, the user, the original result and the new result and a reason must be given as to why the change to the final result was made. 4. Test Result Entry Test results shall be entered in multiple formats. The LIMS shall provide the entry of test results in the following formats, at a minimum: .•All results from one test performed on many samples. Sample Master� Pro LIMS supports this. .•All results from many tests performed on one sample. Sample Master� Pro LIMS supports this. .•All results from one test pertormed on one sample. Sample Master� Pro LIMS supports this. 5. Special Result Values The LIMS shall be able to record special values such as Not Detected, Not Measured, <, or Null. The LIMS shall have the capability to correctly handle all special result values in mathematical computations. Users shall be able to define in advance how special result values will be handled in calculations. The LIMS should have the ability to enter text values into the result field. Sample Master� Pro LIMS supports special values such as ND for Not Detected, or NM for Not Measured, symbols <> Null, or TNTG Too Numerous to Count, etc.. 6. User ID The LIMS shall be able to identify and capture data concerning which laboratory analyst pertormed the test, which use� entered the results and which user approved the results. Sample Master� Pro LIMS does uniquely identify and capture data concerning which laboratory analyst pertormed the test, which users entered the results and which user approved the results. 7. Instrument InterFace The LIMS shall be capable of receiving results directly into its database from interfaced instruments. Sample Master� Pro LIMS Electronic Data Entry Module supports importing data directly from instruments into the LIMS. ATL has a instrument integration library which contains most common instruments used in environmental testing laboratories. Specific instruments and required processes are listed in section 3.0 —Intertace Requirements. ATL engineers have interfaced over 250 instruments and are familiar with the instruments listed in section 3.0. I. Bench Sheet/Work Assignment 1. Work Assignment Features The LIMS shall provide work assignment features for planning and scheduling the laboratory's workload. Sample Master� Pro LIMS Sample Scheduling module supports this feature. These features shall take into account such data as: .•Sample priority - included .•Maximum valid holding time — included .•Sample age - included OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 11 •Due date - included 2. Work Assignment Reports A work assignment report, selectable by the following criteria, shall be provided: .•Identical analysis type - included •Individual analyst — included (Worklist report by analyst) ,•Individual workstation - included •Instrument - included .•Date - included 3. Bench Sheets The generation of the bench sheet shall be available upon request by a user or in a batch process. Single and/or group selection for reprinting shall be available upon request. The LIMS shall provide the capability to create an additional bench sheet for samples received after the original bench sheets were prepared. The ability to delete a sample or an analysis after it has been scheduled shall also be provided. Sample Master� Pro LIMS generates bench sheets upon request by users and can be also be generated in batch mode. Single and/or group selection for reprinting is available upon demand. The LIMS has the ability to create additional bench sheets for samples that were received after the original bench sheets were prepared. The ability to delete a sample or an analysis after it has been scheduled is also provided. 4. Bench Sheet Flexibility Bench sheets shall be created for one type of test and associate all samples assigned to that test to a bench sheet, as well as a bench sheet for one sample and all assigned tests. Sample Master� Pro LIMS can create bench sheets for one type of test and associate all samples assigned to that test to a bench sheet as well as a bench sheet for one sample and all assigned tests. 5. Bench Sheet Contents Content of the bench sheet shall include, but not be limited to, the following characteristics: ,•Specific analysis format (e.g. description of analysis, sample name, location, identity, sample date, analysis date, and name of analyst). Sample Master� Pro LIMS bench sheets contain the following items; description of analysis, sample name, location, identity, sample date, analysis date, and name of analyst and are also left open so that the database administrator can add additional fields or make modifications as required. ,•Quality control samples: blanks, replicates and quality control spikes and standards. Sample Master� Pro LIMS bench sheets can also contain Quality Control sample information such as blanks, replicates, and Quality Control Spikes and Standards. J. Status Monitoring 1. Sample Status The LIMS shall provide methods for monitoring sample status throughout the sample life-cycle. Sample status codes shall automatically be assigned and updated by the system based on events or transactions occurring. Sample Master� Pro LIMS provides a view sample status function that allows users to view the status of their samples through the analysis process to final reporting. The status codes are automatically assigned and updated by the LIMS to allows users and managers to know exactly where the samples are in the laboratory. 2. Test Status The LIMS shall provide a method to monitor test and analysis status. The status of tests assigned to a specific sample identification code shall have a direct bearing on the status of the sample itself (e.g. a sample shall not be indicated as complete unless all assigned tests have a status of complete.) OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 12 Yes, Sample Master� Pro LIMS does provide a method to monitor test and analysis status. Samples are not designated completed until all tests have been completed and results have been entered into he LIMS and they have been validated and approved through the last department. The laboratory can also utilize the auto-reporting feature in the LIMS to automatically print the reports once the results entered for the last test in the batch have been validated and approved. 3. Sample Status Codes The LIMS shall provide codes to monitor sample status for the following conditions, at a minimum: .•Sample expected o� logged, but not received — included in Sam�le Master� Pro LIMS .•Sample received by the laboratory - included in Sample Master Pro LIMS .•Sample has tests assigned that are in progress - included in Sample Master� Pro LIMS .•Sample has all assigned tests completed - included in Sample Master� Pro LIMS ,•Sample results have been reviewed and verified - included in Sample Master� Pro LIMS •Sample data has received formal approval from lab management - included in Sample Master� Pro LIMS ,•A recollection of the sample has been ordered - included in Sample Master� Pro LIMS ,•Broken sample container - included in Sample Master� Pro LIMS under the comments field so that analysts can enter the details about the sample disposition. •Custom status codes defined by the laboratory — this would be through customization, as this is not a standard feature that customers can define their own codes as this would make product support (including documentation) difficult. 4. Test Status Codes The LIMS shall provide codes to monitor test and analysis status for the following conditions, at a minimum: •Test is assigned to a bench sheet, and is in progress —"Master Query" function •Test is complete and results have been entered into LIMS — View Sample Status function •Test results have been reviewed - View Sample Status function •Test results have failed quality control - View Sample Status function .•Test results have exceeded specified limits — Result Entry function and QA/QC •A re-test has been ordered for the same sample and test - Result Entry function ,•Test results have associated text or limits violations - Result Entry function and QA/QC 5. Sample Disposal The LIMS shall�rovide a means for users to know when samples may or should be disposed of. Sample Master Pro LIMS has an integrated disposal report that allows users to know which samples can be safely disposed. This is a standard report that is available in the LIMS. 6. Customer Access The LIMS should allow customers direct access (read only) to their data via the internet or customer call up. The clients should have a means to easily view their results, current and historical. Sample Master� Pro LIMS includes a customer call-up function in which clients can access LIMS data via a modem or other remote connection. ATL offers a module called Result Point designed specifically to allow customers to print reports, view sample status, and access LIMS data anywhere in the world where there is an Internet connection, securely utilizing SSL (Secure Socket Layer and electronic server certificates) with view only web access of results, permit limits and much more. This is a sophisticated web module and will be included in the cost proposal as an advanced option. K. Test Result Management 1. Comments The LIMS shall permit the entry of comments and/or coded comments, which may be inserted by users in place of, or in addition to analytical result data. The LIMS shall permit the user, at the user's option, to enter an explanation in textual format to describe unusual conditions or OAccelerated Technology Laboratories, �nc. — City of Clearwater LIMS Proposal Page 13 circumstances. When test has been added to explain a test result, the LIMS shail indicate that associated text exists. Sample Master� Pro LIMS allows users to insert comments in the LIMS and this can be entered in the result �eld or in addition to the result in a comment area to document any unusual results, or any other information that may be un(que to the sample. When an additional test has been added to explain a test result the LIMS will indicate that there is an associated test that exists. 2. Calculations The system shall support calculations based on the results of multiple analyses and pertorm reasonableness checks on the computed results. The number of significant digits for calculations shall be user definable. Sample Master� Pro LIMS supports calculations based on results of multiple analyses and perForms reasonableness QC checks on computed results. Sample Master� Pro LIMS also allows users to set the number of significant digits for calculations. 3. Results Limits Test data shall have associated results limits. The LIMS shall allow users to enter regulatory limits such as MDLs and MCLs and associate sets of limits with each sampling location. Each analyte in a limit set shall have associated effective dates. These limits shall be used by the LIMS transaction programs to check results being entered and flag the user, during result entry, regarding adherence to the limits. Sample Master� Pro LIMS links test data with result limits that the LIMS administrator has previously set up. The LIMS allows users to enter regulatory limits such as MDLs and MCLs and associate a set of limits with each sampling location. Each analyte limit can be configured to have an associated effective date, these limits are used by the LIMS to check results upon entry and flag the user (via color code) during result entry to let the user know if the value entered is within limits, outside of the limits (warning) but still acceptable or completely outside the limits and unacceptable. 4. Multiple Limits Sets per Location The LIMS shall include the ability to specify multiple sets of limits for each sampling location. Each location shall have an associated primary limit set. All other limit sets at a location shall be considered as secondary limits. Sample Master� Pro LIMS provides this functionality under project set up and each for project and associated site the LIMS administrator can set up an associated primary limit set. All other limit sets at a location can be configured as secondary limits. 5. Test Result Review The LIMS shall allow an authorized user to review test results. The review of test results shall be permitted in multiple fashions: by individual test code, by individual samples and a range of identification code(s), by analytical result date, sample collection date, result range and by bench sheet. Results that are out of limit shall be clearly illustrated. Sample Master� Pro LIMS is configured to allow the database administrator to utilize peer review, if desired. If peer review is selected then the person that entered results into the LIMS is not allowed to review and approve the results. The review of test results is permitted in multiple fashions, the result entry is a three step process, and first results must be entered, then validated and finally approved. Results can be retrieved by individual test code, by individual samples, and a range of identification code(s), by analytical result date, sample collection date, resu�t range, and by bench sheet. Results that are out of user definable ranges, such as 1 and 2 sigma, can be viewed in the QA/QC module. 6. Historical and Precision Level Comparisons For assistance in reviewing and approving test results, the LIMS shall allow the user to read historical results for sample locations and analyses. Precision levels of the analytical results based on Quality Control results shall also be available to the user. OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 14 Sample Master� Pro LIMS QA/QC module allows user to view historical trends from projects, historical results can also be read from sample locations and analyses. The LIMS allows users to define all QA/QC types and also performs accuracy and precision. 7. Review Actions The review function shall allow the following actions: ,•Reviewer indicates agreement or disagreement with the test result. - included ,•Reviewer requires a re-test, where a re-test is defined as a multiple of the original performance of the test. The results from a re-test shall be associated with the original sample identification and test code. - included .•Reviewer requests that the sample shall be collected from the same location again to rerun the test.- included This new sample will be associated with the original sample even if assigned a new sample number. - included 8. Review Actions Affect Status Actions by the reviewer shall automatically update the status of samples and tests. Sample Master� Pro LIMS automatically updates the status of the sample and tests, and the analyses are completed and samples move through the laboratory to final analysis and reporting. 9. Significant Figures The proposed LIMS shall automatically report numeric results to the number of significant figures and decimal places specified by the user. Sample Master� Pro LIMS automatically reports numeric �esults to the number of significant figures and decimal places specified by the users and follows EPA rules. L. Data Validation 1. Validation at Data Entry The validation of all data, including Quality Control (QC) data, shall be completed by the LIMS immediately after entry, so that warnings and reruns are indicated to the users as soon as possible. The LIMS shall prevent the entry of clearly invalid data in key data entry fields. Sample Master� Pro LIMS result entry and validation is a three step process, first results must be entered, then validated and approved, this configuration ensures that any warnings and reruns are indicated to the users as soon as possible. The LIMS database administrators can set upper and lower limits to ensure that clearly invalid data are not able to be entered into the LIMS. 2. On-�ine Help An on-line help facility shall be provided with the LIMS. Help shall be available for each functional portion of the system, such that a user can request help information and then return to their original position upon exiting the help function. Sample Master� Pro LIMS has context sensitive, on-line help. This help is available throughout the LIMS and users can also hit the F1 key anywhere in the application and receive information on the screen that the cursor is currently located on without leaving the current function or screen that they are currently working on. 3. Peer Review The LIMS must be able to force peer review and also have multiple levels of permissions. Sample Master� Pro LIMS contains a peer review function that the LIMS administrator can turn on or off and there are also multiple levels of permission. M. Chain of Custody/Audit Trail 1. Chain of Custody Documents OAccelerated Technology Laboratories, Inc. — City of Clearvvater LIMS Proposal Page 15 Chain of Custody (COC) documents shall be produced by the LIMS for each sample bottle collected. In general, the chain of custody may be printed in conjunction with the sample labels. An authorized user shall be ai�le to reprint chain of custody documents on request. Sample Master� Pro LIMS can generate a chain of custody form for each sample bottle collected. In general, the chain of custody form is printed in conjunction with bottle sample labels. Authorized users are able to reprint chain of custody documents upon request. 2. COC Appropriate to Sample Type The chain of custody documents appearance shall be tailored to the specific sample. Sample id. and barcode, location, sample type, preservatives required, special instructions, and tests requested shall be printed on the chain of custody. The chain of custody document shall include space for the sampler to write in date/time collected, collector's name, field test results, comments, and at least two signature/date lines for transferring sample custody. An authorized user may modif�r the format and content of the chain of custody document. Sample Master Pro LIMS database administrators have the ability to tailor the appearance to each specific sampte. Sample ID, barcode, location, sample type, presenratives required, special instructions, and tests requested can all be printed on the chain of custody. The Sample Master� Pro LIMS chain of custody form includes space for the sampler to write in date/time collected, coltector's name, fiefd test results, comments, and at least two signature/date lines for transferring sample custody, The authorized user or database administrator may modify the format and content of the chain of custody document. There are standard label formats included in the LIMS. 3. Audit Trail for Changes The LIMS shall provide a complete audit trail of data entry and modification to maintain and verify data integrity. Such fields as date, time, old data values, reason for modification, and responsible party shall be recorded when data updates are made. Sample Master� Pro LfMS has a full audit trail of data entry and any modifications to results that have been approved will require an audit trail to be spawned. The audit trail will record the date and time that the original result was entered, the date and time that the new result was entered, who (analyst) entered each result, the old result, the new result and finally they must include a reason for the change or a message box will appear reminding them to do so. N. Sample Approval 1. Final Approval The LIMS shall provide a function for an authorized user to approve all associated sample and test results data in order to complete the chain of custody requirements, and make the data available for use by other departments and in regulatory reports. Sample Master� Pro LIMS has a function in the Data Entry module that allows authonzed users to approve all associated sample and test result data in order to complete the chain of custody requirements and make the data available for use by other departments and in regulatory reports. Users (with appropriate permissions) can also export data directly to Excel for regulatory reporting purposes. 2. Multiple Approval Formats The approval of sample data shall be permitted by individual sample identification code, by test type, by collection Iocation, and by analytical result date. Sample Master� Pro LIMS altows users to approve sample data in multiple formats that can be retrieved via the "master query" function in the LIMS. Users can pul! up results requiring approval by sample identification code (sample ID number), test, department, collection location (site), and by analytical result date and by several other criteria to offer the user flexibility and ease of use. 3. Management - Approval or Disapproval This function shall allow a manger to indicate their approval or disapproval with the sample and test result information. The LIMS shall permit the authorized user to disapprove a sample and its associated data when it is discovered that some portion of the data requires a modification after the original approval. This action shall be recorded in the chain of custody audit trail. OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 16 Sample Master� Pro LIMS allows the laboratory administrators (with appropriate permissions) to approve or disapprove the test result information. The LIMS does permit the authorized user to disapprove a sample and its associated data when it is learned that some portion of the data requires a modification after the original approval and this is done through an audit trail if the result has already been approved so that all test data can be viewed along with any changes to that test data. All test results which are audited, store the chain of audit events in the audit log. If samples are moved around the laboratory the intemal chain of custody trail wi�l track those as well. 4. Protection of Final Management Approved Results Once the final approval function has been completed, LIMS shall provide the ability to prevent any further modifications to the sample and its associated data. Sample Master� Pro LIMS allows those with appropriate permissions only to validate and approve samples, once this is complete, then those which lack validation and approval permissions will not be able to alter those results or any associated data. O. Quality Control 1. Sample results with QC Sets The LIMS shall provide a means of calculating, storing and retrieving Quality Assurance (QA) data such as blanks, spikes, duplicates, % recovered and QC standards, and shall provide a method of associating sample analysis results with a set of quality control data for specific batches. Sample Master� Pro LIMS allows users to configure calculations in the LIMS and the QA/QC module allows users to set up user-configurable QA/QC tests, such as blanks, spikes, duplicates, % recovered and QC Standards and associates sample analysis results with the associated set of QC data for specific batches. Users can also generate control charts in this module. 2. QC Calculations and Graphical Reports The LIMS shall include the ability to generate precision and accuracy data by calculating standard deviation from repticate samples and QC standards. The LIMS shall construct and update QC charts using standard deviation, QC standard trending, data validation through predefined QC criteria, historical concentration ranges, and regulatory standards. Trending capabilities shall include the tracking of consistent bias. QC Cha�ts can be produced and printed automatically based on a predefined trigger. Sample Master� Pro LIMS includes the ability to generate precision and accuracy data by calculating standard deviation from replicate samples and QC standards. The QA/QC module contains integrated charting function using standard deviation, QC standard trending, data validation through pre-defined QC criteria, historical concentration ranges, and regulatory standards. The LIMS includes trending capabilities and includes the tracking of consistent bias. QC Charts and associated reports can be produced and printed, faxed or e-mailed automatically based on predefined logic in the task manager. P. Statistical Analysis 1. Analysis and Graphics The LIMS shall include or provide an easy interface to a standard product for statistical analysis capability for historical trending and examination of LIMS data. Graphics capabilities shall also be provided for display and reporting of statistical information. THIS MUST BE INTEGRATED INTO THE LIMS and CANNOT be from a 3ro party software provider. Sample Master� Pro LIMS contains an integrated QA/QC module that allows users to create control charts and view trends. Users can configure the QC that is used in their laboratory with matrix, spikes, duplicates, blanks, and several others. The QA/QC module is user friendly and contains context sensitive on-line help. No 3`' party software is required, so there is no additional cost or no additional software to learn, manage and maintain. �OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Pa e 17 9 2. Graphics The graphics component shall be able to produce a variety of charts, plots and maps. The charts should be label�ed with all required information such as sample location, dates and parameters. Sample Master Pro LIMS allows users to create charts in the QA/QC module, plots and can plot GIS coordinates with MapPoint (requires a copy of MapPoint version 2002). Users can also export to the Microsoft Office Suite (Word, Excel, Access, and PowerPoint) to create any type of custom graphs. 3. Intertace Requirements If the statistical analysis and/or graphics functionality are not part of the standard LIMS, a seamless intertace between a recommended product and the LIMS is preferred. If such an interface is not available, the Proponent shall detail the procedure that will need to be followed by the user to use the statistical or graphical software in order to meet this requirement. ATL provides an integrated QA/QC module which was designed for the water/wastewater industry and includes all the required charts, features and functions. The advantage is that users do not need to learn, manage or maintain another software package. For users that require more sophisticated statistical analysis (R&D scientists), such as liner regression analysis, ATL also offers NWA active X controls (North West Analytical Statistical Software) which is integrated into the LIMS and offered as an additional add-on module which is offered on a per-user basis. Q. On-Line Queries 1. Ad-Hoc Queries End-users shall be able to quickly and easily retrieve logically related data, in an interactive environment, without the need for a detailed understanding of data storage and programming techniques. A master query form is required that allows users to create and save reports with one click, from a choice of over 20 user defined fields that the user can select from. Sample Master� Pro LIMS provides a user friendly query builder that allows analysts and managers alike the ability to quickly retrieve just the information that they are interested in, and with the new "one-step" function, users can also save these queries. The major advantage is that users do not need any programming knowledge to utilize the query builder, all they need to do is check the box which represents the information that they wish to retrieve and the LIMS returns the requested information to the user and this query can be saved for future use, saving time and reducing the number of user clicks. The master query screen also allows users to define fietd names to their terminology to accelerate deployment and facilitate ease of use with over two dozen fields to query upon. 2. Multiple Query Criteria The LIMS data inquiry facility shall provide efficient retrieval of sample data based on sample identification code, location, analyst name, date received, workstation or device, test, analyte, result values, sample type, and sample status. Sample Master� Pro LIMS allows users with appropriate permissions to query the LIMS database by multiple criteria utilizing the "master query" screen. Users can rapidly access; sample identification code, location, analyst name, date received, workstation or device, test, analyte, result values, sample type, and sample status and much more. With the abiliry to save common queries, information retrieval is even faster. 3. Structured Query Language Tools End-user tools which use a SQL database (either Microsoft SQL Server or Oracle). The LIMS shall provide the user with a query facility which supports nested query, table joins, and outer join functionality. OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 1 S Sample Master� Pro LIMS is tightly integrated with SQL Senrer and the available tools extend the LIMS functions and supports nested queries, DTS packages, table joins, other joins and much more to ensure that our clients can leverage their LIMS functionality with the SQL components. 4. Standard Queries The LIMS shall provide standard queries for, at least, a specific sample's associated data, all results for a specific sample collection location, status of samples, status of tests being pertormed, and all administrative or static data. Sample Master� Pro LIMS provides queries for standard items such as sample associated data, all results for a specific sample collection location, sample status, status of tests that are under analysis as well as administrative and static data. These queries can all be generated from the "master query" function and common queries can be saved under the one-step feature. 5. Multiple Output Options The query function shall be capable of displaying query results on the user's workstation screen, sending them to a printer or saving them as an ASCII file. Saved queries shall be exportable through, or accessible from, ODBC drivers. Sample Master� Pro LIMS will display the query results on the user's workstation screen sending them to a printer or saving them as an ASCII file (text) file. Users with appropriate permissions can export queries through ODBC connections and can also access links the same way. R. Information Reporting 1. Report Development The CITY OF CLEARWATER WPC LABORATORY needs to generate State and Federal regulatory reports, trend analyses, QA/QC charts and graphically formatted reports for administrative planning purposes. The LIMS shall provide or recommend a third party report development tool that is capable of integrating a wide variery of data types from multiple sources. Information from the LIMS database shall be available for report generation. This reporting tool shall include the following minimal capabilities: Sample Master� Pro LIMS supports Word, Excel, Microsoft Access and Crystal as the report writing tool. Microsoft Access is the most popular and will be recommended to the City of Clearwater LIMS Administrator. .•ODBC compliant - yes ,•GUI development intertace- yes ,•Calculations such as total, subtotal, subtraction, addition, multiplication, division, average, maximum, minimum, standard deviation, mean, median, and mode- yes •Format options such as font size and type, page headers and footers, number of significant digits-- yes •Merging graphics, charts and text into a single report— yes .•Retrieve and integrate data from Microsoft Access databases as well as the LIMS database- - yes .•Create bar charts, trend lines, pie charts with retrieved data - yes. 2. Pre-programmed Repo�ts The following set of pre-programmed LIMS reports shall be provided: There are over 70 canned reports that are included in Sample Master� Pro LIMS, those listed below are a small subset of those reports. Clients can also import their own organization logo. •Samples received for a user-specified time frame - yes •Samples analyzed for a user-specified time frame - yes •Test Results report, including comments - yes •Work Backlog report by sample status - yes •Work Backlog report by due date (Sample Aging) - yes •Work Backlog report by priority - yes •Test results Out of Limits report - yes •Quality Control sample report - yes OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 19 ,•NPDES discharge monitoring report - yes ,•Management Reports - yes 3. Workload Management Reports Workload management reports shall be provided to assist with interpretation for work assignment, staff load balancing and laboratory performance. The following types of reports shall be provided as part of the standard LIMS software: There are over 70 canned reports that are included in Sample Master� Pro LIMS, those listed below are a small subset of those reports. Clients can also impo�t their own organization logo. •Sample Volume Report (number of samples processed) - yes .•Test Volume Report (number of tests performed) - yes ,•Turnaround Time Report from sample receipt to approval, summarized by analysis .•User definable reports - yes .•Ability to save report to disk for submission to the EPA. - yes 4. Reports should be generated for a sample automatically when: ,•All analyses for a sample are complete - yes .•Summary reports generated for predefined collection dates, analysis dates or customers. - yes 5. Reports should be able to be e-mailed or faxed from within the LIMS application. — yes (also includes auto-e-mailing and auto-faxing software built into the LIMS, no external Fax software is required to purchase). .. _. . � ,_ _ � : A. Electronic Instrument Interface ATL has a library of over 250 instruments previously interfaced with ATL's LIMS, all of the instruments listed below are included in ATL's library and are available at a reduced rate. ATL also offers 1. Provide data parsing files for the following instruments: (1) PE Optima 2000 ICP-OES — parsers in the ATL library (2) PE Aanalyst 600 , AA furnace - parsers in the ATL library (3) Bran-Luebbe TRAACS 800 — parsers in the ATL library (4) Dionex ICS 2000; lon Chromatograph — parsers in the ATL library (5) Man-Tech PC Titrate — parsers in the ATL library (6) Man-Tech BOD Assay Plus — parsers in the ATL library (7) Varian Saturn 2000 GC/MS — parsers in the ATL library (8) PE FIMS 100, Mercury Analyzer — parsers in the ATL library (9) Any instrument with an RS-232 port — parser partnership with TalTech quoted cost per RS- 232port or instrument (rypically utilized with balances). 2. Provide a method to uniquely identify each instrument — The ATL parsers do uniquely identify each instrument that will be importing data into Sample Master� Pro LIMS. 3. Able to receive and process analytica� and quality control sample results from instruments. ATL's instrument parsers do receive, import and process analytical and quality control sample data from instruments. The data is imported into the LIMS just as if it was hand-entered, so the results will still need to be validated and approved. B. Transferring Information 1. Unique Device ID In order for the LIMS to acquire test results from laboratory instruments, the LIMS shall provide a method to uniquely identify each device. �OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 20 Sample Master� Pro LIMS uniquely identifies each instrument that will be importing data into LIMS and provides a means to uniquely identify each device that is exporting data. 2. Direct Data Transfer The LIMS shall be able to receive and process analytical and quality control sample results directly from instruments which produce final results while the instrument is operational and without disrupting other LIMS users. Sample Master� Pro LIMS can receive and process analytical and quality control sample results directly from instruments which produce final results while the instruments are operational and without disrupting other LIMS users. 3. Data Processing After processing or data reduction, the LIMS shall be able to receive and process analytical and quality control sample results from the PCs. The selected vendor shall provide the software required to transfer the data to the LIMS. Sample Master� Pro LIMS, Electronic Data Transfer module works with the parsers to import (receive and process) analytical data and QC data from the PC's to the LIMS SQL database. All the software required to import data from (instruments listed above) into the LIMS is included in the cost proposal. A. Cost Accounting 1. CITY OF CLEARWATER WPC LABORATORY may wish to associate labor and/or material cost with specific samples and analysis types. The LIMS shall provide, at a minimum, the ability to associate appropriate accounting codes with the LIMS data. This function shall provide a means of tracking costs for analytical purposes regarding specific projects or cost centers. Project specific pricing is required. Sample Master� Pro LIMS allows users to associated labor and/or material cost with specific samples and analysis types. Sample Master� Pro LIMS allows users to associate either costs or accounting codes with LIMS test data. This function provides a means of tracking costs for analytical purposed regarding specific projects or cost centers. Sample Master� Pro LIMS supports project specific pricing. 2. The Proponent shall describe all accounting features available with their LIMS product. Sample Master� Pro LIMS has the ability to generate quotes and invoices, There is also a built-in export to QuickBooks Pro and Peachtree accounting packages. There is also a time tracking module that is typically utilized by laboratories that are working on multiple projects and that need to keep track of which projects they should charge their efforts to. 3. This should be an optional feature which can be turned on and off as required. It must not be necessary to invoice samples. These features can be hidden or made availabte in Sample Master� Pro LIMS and the administrator can determine which users have the ability to use these features and it is NOT necessary to invoice samples. B. Chemical Inventory Module 1. The LIMS shall include a chemical inventory module that can store the following information for chemicals: vendor, chemical name, received date, amount, lot number, catalog number, expiration date and disposal date. Sample Master� Pro LIMS has a chemical and reagent inventory module that stores information for chemicals, such as the vendor, chemical name, received data, amount, lot number, catalog number, expiration date and disposal date. 2. The inventory module should be able to estimate chemical usage based on predefined quantities used per sample analysis. OOAccelerated Technology Laboratories, Inc. — City of Clearvuater LIMS Proposal Page 21 Sample Master� Pro LIMS chemical and reagent inventory module can also let users know when they are running low on specific supplies and can perform a reconciliation based on usage and pre-defined quantities utilized per analysis. C. Personnel Module 1. The LIMS shall be able to track personnel certification and training. Sample Master� Pro LIMS Resource Management Module tracks employee certifications as well as training records and the LIMS administrator can control access to employees that can enter results into the system based on the successful completion of training on a particular test, method or on an instrument. 2. The LIMS should be able to provide notification that training is due. Sample Master� Pro LIMS Resource Management Module contains a canned report that provides notifications that training is due. D. Equipment Maintenance Module 1. The LIMS should provide the ability to track instrument calibrations. Sample Master� Pro LIMS Resource Management Module allows customers the ability to track instrument calibrations and warns users when instruments are out of calibration and can be configured not to accept data from out of calibration instrumentation. 2. The LIMS should provide the ability to track instrument repairs. Sample Master� Pro LIMS Resource Management Module provides the ability to track instrument repairs. E. Portable Data Entry Terminal 1. The LIMS shall be able to supply a portable data entry terminal hardware and software that can be used for sample collection and entry of field data such as chlorine residual and pH. Sample Master� Pro LIMS is integrated with Sample Master� Palm which allows �eld collectors to enter field data (such as turbidity, pH, chlorine residual, etc.) and upload that data upon return to the labora�ory. 2. Entries should contain a date/time stamp and be able to be downloaded into the LIMS. Sample Master� Palm software installed on the rugged Palm contains a date and time stamp that can be downloaded to the LIMS along with the field data. 3. The LIMS vendor should supply all necessary hardware and software. The cost proposal will include the Sample Master� Pro Palm Rugged unit with built in scanner and all necessary hardware and software and cables will be included in the cost proposal. F. LIMS Explore� for Web Access 1. The ability for remote users to retrieve data from a remote site via a secure link to a web page. Sample Master� Pro LIMS Explorer with Result Point allows users to access data via a secure web site and view sample status and print pdf read only reports. 2. Allow users to create queries "on the fly" to retrieve a variety of information using a"master query" concept Sample Master� Pro allows users to create XML reports on the fly pulling information from the LIMS so that the results are updated in real time. Users can also search by site or customer. OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 22 3. The LIMS explorer must be tightly integrated with the LIMS and have the same "look and feel' as the LIMS and be easy for n,on-LIMS users to navigate. Sample Master� Pro Result Point allows customers to integrate their logo and has a consistent look with the LIMS, online help documentation and is very easy for non-LIMS users to navigate and look up their data. 4. The LIMS should have web database architecture so that remote users can access sample status, manage wastewater permit limits, and generate reports. This is critical in the event of a state emergency to allow remote users to obtain sample data instantly. Sample Master� Pro Result Point has a web database architecture which allows remote users to view sample status, manage and view wastewater permit limits, generate XML reports on the fly and also linked pdf �nal analysis reports. _ ry, y�, ��, . , _ ,1� i `�i �� A. Technical Support 1. The Proponent shall provide support for all software products included under this contract. Prior to Final Acceptance, the Proponent's support staff shall respond within two to four hours to all support calls placed during normal business hours, 8:00 a.m. to 5:00 p.m. Eastern Standard Time, Monday through Friday. Support calls placed after normal business hours or on Saturday and Sunday shall be responded to within four hours on the first regular business day following notification. ATL will provide support for all software products inctuded under this contract. ATL engineers will respond to all support inquiries within two to four hours during normal business hours, 8:00 am to 5:00 pm EST, ATL also offers support until 8:00 pm EST at no additional cost. Any support calls that are placed on Saturday or Sunday, will be be responded to within four hours on the first regular business day. 2. One year of support shall be provided under this contract (from LIMS System Formal Acceptance date). The support agreement shall be renewable on an annual contract basis. One year of ATL GOLD support will be included in the cost proposal and the agreement is renewable on an annual basis. 3. The Proponent shall provide a toll-free telephone number for support calls. ATL provides toll-free support to clients with ATL GOLD support for Sample Master� Pro LIMS. 4. The Proponent shall have local and/or national user groups for each software product identified in their proposal. ATL holds user groups meeting in various locations throughout the United States and Europe. ATL also holds regular focus group meetings with industry leaders in the water and wastewater area. 5. Have remote diagnostics, bulletin board/internet support The secure ATL support site includes white papers, a knowledge base, a bulletin board where users can share reports and code, remote diagnostic and internet support. 6. The LIMS vendor shall provide an assigned LIMS account manager. ATL GOLD support includes a dedicated account manager so that clients have a single point of contact. 7. The LIMS vendor should be a Certified Microsoft Solution Provider for more than 5 years and be ISO 9001 certified. ATL was the first LIMS vendor to be certified to the new ISO 9001:2000 standard and is audited regularly to maintain certification. What this means to clients is that ATL has a audited Quality OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 23 Management System in place that is audited internally each month and externally on a regular basis to ensure that ATL delivers the highest quality software to it's clients. ATL is also a Microsoft Certified Partner (8 years) which means that ATL engineers pass Microsoft Certification Exams and that ATL receives priority support from Microsoft and a box of software each month from Microsoft of the latest software fixes. In addition, ATL serves as a beta site for many new Microsoft products. B. Upgrades/Fixes 1. Functional fixes to the software shall be provided as they are released at no extra cost. Supporting documentation for hardware and software reflecting modifications shall be supplied, when necessa at no extra cost. Sample Master� Pro ATL GOLD support includes free software service packs and supporting documentation for all supplied hardware and software. 2. For as long as CITY OF CLEARWATER WPC LABORATORY maintains an active support agreement, upgrades and enhancements to the software shall be provided automatically at no additional cost. Supporting documentation for software reflecting upgrades and enhancements shall be supplied at no extra cost. ATL shall p�ovide Sample Master� Pro LIMS upgrades and enhancements to the software automatically at no additional cost as long as the City of Clearwater maintains active support. Supporting documentation for sofiware reflecting upgrades and enhancements shall be supplied at no extra cost. 3. Software service packs should be available for download from the vendor's website. Upgrades should pull in any new features that were added by the laboratory, these should not be overwritten by updates. The ATL development team will place Sample Master� Pro LIMS service packs on a secure web site available for download from ATL's secure web site. Any new features that were added in by users will NOT be overwritten but will be pulled into the new ve�sion. Supporting documentation for software reflecting upgrades and enhancements shall be supplied at no extra cost. ATL will supply supporting documentation for software reflecting upgrades and enhancements to Sample Master� Pro LIMS at no additional cost. C. Documentation 1. The Proponent shall provide complete hard and soft documentation for the LIMS application and the instrument intertaces. This shall include installation instructions, system administration and maintenance, technical reference and users manuals and any other manuals relevant to the selected LIMS application. ATL will provide complete hard and soft documentation for the Sample Master� Pro LIMS application and the instrument intertaces. This will include installation instructions, system administration and maintenance, technical reference and users manuals and any other manuals relevant to the Sample Master� Pro LIMS application. 2. A simple step-by-step users manual shall be provided for the end users and administrators. ATL provides easy to follow end-user and database administrator training manuals written in plain English and ATL provides both hard copy and electronic pdf copies. .� �,� ;,�� # A. LIMS System 1. The LIMS Supplier shall provide the services of qualified LIMS start-up and training teams, who shall work closely with the staff of the City of Clearwater to accomplish the custom configuration OOAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 24 of every aspect of LIMS planning, configuration, database design, implementation, start-up, custom equipment interfaces, troubleshooting and training to assure the system is fully operational and complete. The LIMS training should be a minimum of three (3) days for each of two (2) groups of people plus two (2) additional days for managers, or su�cient additional time to assure that the staff is well trained in every aspect of the LIMS system. ATL will supply initial installation services and provide start up teams with ATL's certified trainers who will work closely with the staff of the City of Clearwater to accomplish the custom configuration of every aspect of LIMS planning, configuration, database design, implementation, and start up, custom instrumentation interfaces, troubleshooting and training to ensure the system is fully operational and complete. The LIMS training will consist of 3 days for each of 2 groups of people (up to 5 at no additional charge) and 2 additional days form database administrators/managers. Additional end-user and DBA training can be purchased from ATL, ATL offers, web-based training, a LIMS boot Camp (hands on training), in Pinehurst, NC and in Myrtle Beach, SC for LIMS end-users (3 day class) as well as LIMS administrators (2 day class). ATL also offers additional on-site custom training on clienYs site. 2. Initial training shall be conducted on-site at CITY OF CLEARWATER WPC LABORATORY. Follow-up training can be provided on-site or at regional training centers. ATL certified trainers will provide on-site training to the City of Clearwater WPC laboratory and ATL also offers follow-on training at the LIMS Boot Camp, held in Pinehurst, NC and Myrtle Beach, South Carolina. 3. The selected Proponent shall provide all instructors and instructional material including trainees' workbooks, instructor guides, training aids, equipment and technical manuals. ATL will provide all instructors (ATL Certlfied Trainers), instructlonal material, lncluding trainees' workbooks, instructor guides, laminated quick start guides, training aids and equipment and technical manuals. 4. The selected Proponent shall coordinate with CITY OF CLEARWATER WPC LABORATORY regarding use of facilities if courses are to be held on-site. Equipment and software that are provided as part of this contract may be utilized for training, provided they are not adversely affected. Any equipment or software modified for training by the Proponent shall be restored to its original condition. ATL engineers will coordinate with the City of Clearwater WPC Laboratory regarding the use of facilities if courses are held on-site (hands-on in the laboratory or a training room). ATL will utilize equipment and software that are provided as part of this contract may be used for training as long as they will not be adversely affected. Any equipment or software that is modified for training will be restored to its original condition following the training. 5. Courses that include general programming elements shall provide instruction such that the attending student will be capable of programming related software applications and/or modifications without guidance, or with only minimal supervision. This requirement applies only to the software supplied by the LIMS Proponent. ATL will provide instruction on any general programming elements that are part of the LIMS so that the student will be able to manage and maintain the system with minimum programming skill. This does not apply to the report writing soflware, only the LIMS software that is supplied by ATL. 6. At a minimum, required courses are as follows: ,•End-User Training- Provide training sessions on-site that instruct 10 end-users in the overall use and operation of the LIMS application software. Training is to be provided in three separate sessions. ATL Certified Trainers will provide on-site training sessions that include 10 end-users in the overall use and operation in Sample Master� Pro LIMS software. Training will be provided in three separate sessions. OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 25 •System Administrator Training-Provide training on-site for two (2) owner designated personnel who will act as system administrators for the LIMS computer configuration and applications. The training shall include LIMS administration tasks, software management functions and computer security. The training shall also include complete system back-up and reload procedures, file management utilities and system generator procedures. ATL Certified Trainers will provide training on-site for 2 owner designated personnel who will act as system administrators for the Sample Master� Pro LIMS computer configuration and applications. The training shall include LIMS administrator tasks, software management functions and LIMS and computer security. The training shall also include complete system back-up and reload procedures, file management utilities and system generator procedures. •Course outlines for end-user and administrator training is to be submitted. Please find at the end of this section Admin and End-User Training Guides Tables of Contents which provides an outline for what is covered during Admin and End-User Training. The Table of Contents from the User Manual is also included. These classes are taught by ATL Certified Trainers, engineers must pass a rigorous training program and an exam to achieve this status. 7.0 Installation Services A. Services The Proponent shall provide installation and startup services including loading required software on the LIMS server, client workstations, and instrument PCs, and creating all necessary custom command files to automatically activate the system upon startup. ATL will provide installation and startup services including loading required software on the LIMS server, client workstations, and instrument PCs, and creating all necessary custom command files to automatically activate the system upon startup. B. Documentation Complete hard and soft copy documentation of the LIMS application software and the instrument intertaces shall be provided to the users by the time of installation. This includes users and reference manuals. ATL will provide both hard and soft (electronic — pd� copy documentation for the Sample Master� Pro LIMS application software and the instrument intertaces shall be provided to the users by the time of installation. This will include the user and reference manuals. OAccelerated Technology Laboratories, Inc. — City of Clearwater LIMS Proposal Page 26 f�. �n org�n��atic�n �hart s�p�e�c,�in� t�e p�a��t t�� t ��ti p�e�farr�n t�� ca�c on th� �r�t�r� pr�� nd a brief des��p�� Q� th� qua��t�a�r�s e�c� �r��r�� t�f ��h t�m ��mt�r, th�ir t�t;le�= �e�� f �rvi�e r��t� th� ��rt� a�d � �sur��. Accelerated Technology Laboratories, Inc. prides itself on providing its clients with a total data management solution and a commitment to excellence in product quality, support and training. ATL hires experts in the fields of chemistry, laboratory information management, microbiology, project management, software design and development. ATL's staff has extensive experience in the LIMS setup, implementation, database conversions and system validation. No subcontractors will be used in this project. 01994-2005 Accelerated Technology Laboratories, Inc. All rights reserved. SAMPLE � MASTER` ATL LIMS Project Team for the City of Clearwater - Roles and Responsibilities Don Kolva I Project Manager/ I Seven Lakes, I Mr. Kolva has over 16 years in the automation NC and LIMS industry. Lead Implementation Specialist The LIMS project manager is responsible for managing all project activities and assigningresources. Mr. Kolva has participated in over 120 as Lead Implementation installations of Sample Master� products and Specialist, responsible for has over 10 years of Sample Master� LIMS overseeing installation and im lementation and su configuration of Sample p pport experience. Maste� Pro LIMS. Christine Account Manager West End, NC Dr. Paszko has over 17 years of laboratory Paszko; Ph.D. experience and has participated in over 60 installations of the Sample Master� LIMS product line. Steve Rayburn Dr. Paszko has a B.S. in Medical Technology with a minor in microbiology and a Ph.D. in molecular microbiology with a minor in biochemistry from the University of Maryland. She compfeted graduate coursework in business management, informatics and business management at Stanford University, Stanford, CA. Implementation West End, Mr. Rayburn has a B.S. in Chemistry from the Specialis�/ NC University Virginia. He has worked for 18 years as an analytical chemist at several Director of Training environmental testing laboratories while serving and Validation as Laboratory Supervisor/Manager for 14 of those years. He has also served as a laboratory auditor and trainer in the wastewater industry. Experienced in LIMS from the analytical chemist perspective with expertise in evaluating laboratory pertormance and providingtraining to achieve laboratory improvements. Understands the needs of the analytical chemistry laboratory first hand which is critical to a successful LIMS implementation. 01994-2005 Accelerated Technology Laboratories, Inc. All rights reserved. SAMPLE � MASTER' The LIMS account manger is responsible for all eontractual obligations, reviewing milestones, work plans, �leliverables and providing answers to any client questions. This individual is also responsible for serving as a single point of contact for any project issues and their suCcessful resolution. As Director of Training and Validation, Mr. Rayburn oversees training of both clients as well as ATL employees and develops customized training tools and programs. In addition, oversees and directs the validation and testing of ATL products and customized additions to those products. As implementation specialist, responsible for installation and configuration of Sample Master� Pro LIMS. Mike Kelly Director of Product Seven Mr. Kelly is an accomplished, solutions-focused Mr. Kelly is ATL's Director of Development Lakes, NC software engineer and developer with over 19 Product Development. His years experience in LIMS solutions and extensive experience in LIMS laboratory automation. Mr. Kelly was enables him to guide ATL's responsible for the integration with enterprise product development SCADA systems and DMR reporting. strategies. Anson Implementation Seven Ellstrom Specialist/ Lakes, NC Software Engineer Russ Vranken Instrument Integration Specialist/ Software Engineer Sparks, NV Mr. Kelly has extensive expertise in all aspects of LIMS IT support, networking, and custom programming. Mr. Ellstrom has a B.S. in Computer Science and has over 3 years of Sample Master� LIMS implementation and support experience. Mr. Ellstrom has participated in over 25 installations of the Sample Master� Pro LIMS products. Mr. Vranken has a B.S. Degree in Computer Information Systems and a Minor in Business Administration. Mr. Russell Vranken has over 6 years of Sample Master� LIMS implementation and support experience and has participated in over 37 installations of the Sample Master� products as well as ScreenlT'"" LIMS. 01994-2005Accelerated Technology Laboratories, Inc. All rights reserved. ��MASiERN As Implementation Specialist and Software Engineer, Mr. Ellstrom is responsible for installation and configuration ofSample Master� Pro LIMS. Also responsible for assisting in providingtechnical support, LIMS product upgrades, enhancements and customizations. As Instrument Integration Specialist and Software Engineer, Mr. Vranken is responsible for providing instrument integration, technical support. LIMS product upgrades, installations, enhancements and customizations. Fred Rider David Schlabach Senior Software Engineer Implementation Specialist/ Software Engineer Seven Lakes, NC Seven Lakes, NC Mr. Rider has over �1 years experience in computer science and automation. Mr. Rider has extensive computer expertise and has worked in numerous IT positions. His qualifications include a B.S. in Computer Science; he is a Cert'rfied Microsoft Professional, and a Certified Novell Netware Administrator (CNA). Mr. Fred Rider has participated in over 30 installations of the Sample Master� Products and has over 5 years of Sample Master� implementation and support experience. Mr. Schlabach has a B.S. in Computer Science and has over 8 years of computer soitware implementation and support experience. Mr. Schlabach has participated in over 15 installations of the Sample Master� LIMS products. Rebekah Software Engineer Seven Mrs. Johnson has over 6 years experience in the Johnson Lakes, NC LIMS industry. She graduated from Louisiana State University with a B.S. in Information Systems and Decision Sciences. Bill Ulma I Software Engineer I Newton, NJ I Mr. Ulma graduated from the Rochester Institute of Technology - Computer Engineering/Information Technology in 2001. Mr. Ulma has six years of extensive experience in Rapid Application Development (Delphi, VB), Multimedia Design (Flash, Photoshop, After Effects, Premiere, Illustrator & Freehand), Web Development (HTML, ASP/VBScript, DHTML/Javascript, XML/XSLT, CSS), Database Development (Paradox, Microsoft SQL Server, Microsoft Access, Oracle, FoxPro), and Misc (UNIX Shell Scripting, Eiffel). 01994-2005 Accelerated Technology Laboratories, Inc. All rights reserved. SAMPLE �MAS7ER As Senior Software Engeneer, Mr. Rider oversees the design and development of the Sample Master� LIMS product line, testing/quality assurance functions on ATL, Inc. LI MS softwa re, proced u res and practices. Provides customization to the Sample Master� LIMS product line and assists in installation, product support and training of end-users. As Implementation Specialist and Software Engineer, Mr. Schlabach is responsible for installation and configuration of Sample Master� Pro LIMS. Also responsible for assisting in providing technical support, LIMS product upgrades, enhancements and customizations. As an ATL Software Engineer, Mrs. Johnson is responsible for providingtechnical support, specification document management, LIMS product upgrades, enhancements and customizations. As an ATL Software Engineer, Mr. Ulma is responsible for providing technical support, product upgrades, enhancements and customizations on Sample Master�" Pro LIMS and Result Point. Donald J. Kolva, P.E., MCP Over 16 years in the automation and LIMS industry. He currently serves as the Background President of Accelerated Technology Laboratories, Inc. and has done so for the Summary past ten years while developing Advanced Laboratory Information Management Systems based on the best available technology. Mr. Kolva has extensive expertise in database design, data management and instrument integration. He served as the system/LAN administrator for four years at the largest water quality laboratory in the US which involved in installation, maintenance, and troubleshooting for an Oracle-based LIMS implementation, and managed, MS- DOS, Windows''"" and Macintosh systems. Six additional years were spent as a software engineer developing software applications, instrument interfacing and integration programs in research centers supporting of NASA and US NAVY ro'ects in Washin ton, DC. with a secret securit clearance. B.S. Mechanical Engineering, Computer Science Minor- State University of Education New York E n g i n ee r-i n-T ra i n i n g Professional Engineer, Califomia Graduate Coursework in Acoustics and Computer Science, Catholic University Microsoft Certified Professional MBA Course work at Laverne University, CA Sustained Superior Performance Award, December 1987, David Taylor Awards Research Center, USN NSI Employee Innovation Award, December, 1998 and January 1999. P�esident of Accelerated Technology Laboratories, Inc., West End, NC. Experience Mr. Kolva has extensive LIMS expertise and has been an invited speaker at several professional meetings in the water industry and has published over a half a dozen LIMS articles. He has previously worked as a Sr. Chemist/LIMS Manager in the Laboratory Automation Department at the Metropolitan Water District, LaVerne, CA. He has also worked extensively in laboratory and testing automation while employed as a Senior Software Engineer, Radix Systems, Inc., Washington, DC and as a Soflware Engineer, David Taylor Research Center, US Navy, Bethesda, MD. Broad Experience in: - Computer network design - Laboratory design/LIMS development - LIMS Software configuration and maintenance - Soflware and System Validation - Technical writing - Data migration - Data loggers, handhelds, and wireless technology - Creation of EDD's (Electronic Data Deliverables in XML) - NELAC, GALP, ISO regulations - Integration with enterprise systems (ERP, statistical, accounting, etc.) - End-user LIMS Training - DBA Training - Measurement techniques - Analytical method development - Vsual Basic, MS Access, C, C++, SQL Server, and ORACLE - Visual Basic.Net - Troubling shooting network issues - DEC Pathworks and Banyan Vines LAN software - UNIX and VAX systems - TCP/IP, Novell, Ethemet NOTE: Mr. Donald Kolva has participated in over 120 installations of the Sample Master° Products. Christine Paszko, MT (ASCP), Ph.D. Dr. Paszko cuRently serves as a Vice President of Sales and Marketing for Accelerated Background Technology Laboratories, Inc. and aids in the marketing intelligence for the development of Summary Advanced Laboratory Information Management Systems based on the best available technology. She also has extensive LIMS, proje�t management and implementation experience. She has over 17 years of laboratory experience and has used and implemented several LIMS and LIS systems in her career. She has extensive environmental laboratory experience, while attending the University of Maryland she was responsible for environmental monitoring and perForming several microbiological indoor air quality and water quality analyses. She also has extensive industry experience and was responsible for developing and bringing to market molecular based technologies for environmental pathogen monitoring. She has demonstrated project management skills, having managed a 2.3 million budget at ABI, numerous Grants and a CRADA with the USEPA. Dr. Paszko has authored over 3 dozen articles and book chapters, many on LIMS. She has co-authored a book entitled Laboratory Information Management Systems, second edition in Se�tember 2001. B.S. Medical Technology with a minor in Microbiology and a Ph.D. in molecular microbiology with a Education minor in biochemistry from the University of Maryland. Graduate coursework in business management, informatics and negotiation skills at Stanford University, Stanford, CA Dr. Paszko has been employed at Accelerated Technology Laboratories, Inc. since 1998 and was originally hired as the Director of Sales and Marketing to oversee the Sample Master� LIMS product line and manage the sales team. She was recently promoted to her current position where EX erience she is responsible for overseeing worldwide sales, marketing and business development functions. p She also oversees user meetings and focus groups held regularly to ensure that ATL products continue to meet and exceed our customer's expectations. Dr. Paszko has worked as a medicat technologist, molecular microbiologist and laboratory manager with over 17 years of laboratory experience. She was previously employed at Perkin Elmer Applied Biosystems Inc. and was the group leader for the food and environmental group and supervised 18 scientists and marketing professionals. Responsibilities included the development of PCR-based diagnostic kits for the rapid environmental detection of food and waterbome pathogens such as Salmonella, E. coli 0157:H7, Giardia and Cryptosporidium. Also secured 250K in funding from NASA to development portable PCR units for the space station utilizing the TaqMan technology developed at Roche. Also worked on informatics for high density oligo arrays and on BioLIMS. Broad Experience in: - Regulatory issues CFR 21 part 11, HL7, CLIA, CAP - NELAC, GALP, ISO 9001 regulations - Laboratory and Project Management - Microbiology (HPLC, PCR, LCR, Mab development) - Laboratory Safety - Bioterrorism Preparedness Training (information management) - Laboratory Standard Operating Procedures - Barcodes, scanners, label printers and biometric ID - Project and Account Management - Contrad Management - LIMS and LIMS implementation - End-user training - Qualiry planning - System and Software Validation - ATL's ISO 9001 Management representative - Microsoft Office 97, 2000 and XP NOTE: Dr. Paszko has participated in over 60 installations of the Sample Master� LIMS product line and NeoMateT"' LIMS. Steve Rayburn Over 18 years in the laboratory/ LIMS industry. Currently serves as Director of Background Training and Validation at Accelerated Technology Laboratories, Inc. and aids Summary in the development of Advanced Laboratory Information Management Systems based on the best available technology. Extremely fluent in most PC environments, including MS-DOS, Windows 95, 98, Windows NT 4.0, Windows 2000 and XP. Experienced in Laboratory Information Management Systems from the analytical chemist perspective with expertise in evaluating laboratory performance and providing training to achieve laboratory improvements. Understands the needs of the analytical chemistry laboratory first hand which is critical to a successful LIMS implementation. Bachelor of Science: Chemistry Education University of Virginia Postgraduate work in Science Education at University of Virginia Mr. Rayburn has extensive Chemistry and LIMS implementation experience. Experience He is currently responsible for maintaining and improving the current ISO certified Training and Software validation program at ATL, Inc. Prior to this he worked for 18 years as an analytical chemist at several environmental testing laboratories while serving as Laboratory SupervisodManager for 14 of those years. He has in-depth experience in the customization and implementation of LIMS in addition to his management responsibilities. Broad Experience in: - Environmental chemistry and analytical instrumentation - Laboratory design/LIMS development - LIMS SoRware setup and maintenance - NELAC, GALP, ISO, EPA regulations - LIMS and Laboratory Training - Measurement techniques - Analytical method development - Method validation - Laboratory Auditing - LIMS Implementation - Laboratory SOP writing - LfMS report customization - Review of various LIMS systems, design and research costs of computer network system, and development of business plan for expected expansion. Professional Affiliations: - Former chair of NC AWWA / WEA Laboratory Analyst Committee - Associate member Commercial Laboratory Association of North Carolina (CLANC) - Member of Guilford County Emergency Management Science Advisory Group - Instructor at North Carolina Annual Wastewater Operators School in Chapel Hill, NC. - Varian GC troubleshooting and repair certified - Quality Assurance / Quality Control training by US Environmental Protection Agency Michael Kelly Background Mr. Kelly is an accomplished, solutions-focused software developer with over 19 years Summary experience in LIMS solutions and laboratory automation. Previously, Mr. Kelly was the Director of Technical Development at Perkin Elmer Labworks, where as a major developer he designed and developed LIMS soflware. Mr. Kelly has extensive expertise in all aspects of LIMS IT support, networking, and custom programming. His extensive experience in LIMS enables him to guide ATL's product development strategies. • Associate of Applied Science, Texas State Technical Institute, Harlingten, Texas Education and • Basic Project Management Training • Technical Writing for Busy Professionals • John Maxwell Leadership Course • Microsoft Certified Systems Engineer Training — University of Phoenix/Baton Rouge • Microsoft Technical Conference • Visual Basic Insiders Technical Summit I Director of Product Development, Accelerated Technology Laboratories, Inc. Experience Seven Lakes, NC. Mr. Kelly guides ATL's product development strategies. Previously, Mr. Kelly was a software engineer for Innovative Emergency Management, Inc. where he served as a Project Manager and designed and developed custom software. As owner of Advantekx, Mr. Kelly displayed expertise in all aspects of IT support, networking, and custom programming. He configured new computer systems, installed soflware, and provided clear instn�dions to ensure client satisfaction. Created WAN of individual networks within 9 nursing home facilities located in Louisiana and Arkansas. In addition, Mr. Kelly spent fourteen years of progressive responsibility and achievement at PerkinElmer Labworks. As Director of Technical, Mr. Kelly was a major developer. He designed and developed software within a laboratory/LIMS environment. He maintained all information technology and trained new employees. At the Shell Development Westhollow Research Center, Mr. Kelly was a Laboratory Specialist and performed research and development in several laboratory surroundings including spectroscopy lab, x-ray fluorescence and neutron activation lab and organic elemental lab. He served as liaison between software support and testing groups. Broad Experience in: - Computer network design - Laboratory design/LIMS development - LIMS software configuration and maintenance - Software and system validation - Technical writing - Data migration - Data loggers, handhelds, and wireless technology - Creation of EDD's (Electronic Data Deliverables in XML) - NELAC, GALP, ISO regulations - Integration with enterprise systems (ERP, statistical, accounting, etc.) - End-user LIMS Training - DBA Training - Measurement techniques - Analytical method development - Visual Basic, MS Access, C, C++, SQL Server, and ORACLE - Visual Basic.Net - Troubling shooting network issues - DEC Pathworks and Banyan Vines LAN software - UNIX and VAX systems - TCP/IP, Novell, Ethemet Frederick T. Rider, MCP, CNA Over 32 years experience in computer science and automation. Currently Background serves as the Senior Software EngineeNQA for Accelerated Summary Technology Laboratories, Inc. while aiding in the development of Advanced Laboratory Information Management Systems based on the best available technology. Assists in the design and development of advanced data management systems and performs inspection and testing/quality assurance functions on ATL, Inc. LIMS soflware, procedures and practices. Provides customization to Sample Master� LIMS product line and assists in installation, product support and training of end-users. Provides input and assistance in writing technical manuals for version upgrades. B.,S. in Computer Science Education Chapman Universiry, Orange, Califomia Microsoft Certified Professional Certified Novell Netware Administrator (CNA) Awarded the Meritorious Service Medal for outstanding management of the Awards wng Weapons Maintenance Program. Senior Software Engineer, Accelerated Technology Laboratories, Inc. Experience West End, NC. Mr. Rider has e�ctensive computer expertise. He has worked in numerous IT positions induding the folbwing; Systems Resource Specialist, McMurray Fabrics, Inc., Aberdeen, NC , Microsoft Access Support Engineer, Software Management Consultants, Charlotte, NC (Contractor for Microsoft Corporation), Computer Systems Anatyst, DynCorp, Holloman Support Division, Holloman Air Force Base, New Mexico, Weapon Services Manager, Holloman Air Force Base, New Mexico and US Air Force, Various Units, Worldwide. Broad Experience in: - Computer networlc design - Laboratory design/LIMS development - LIMS Software setup and maintenance - NELAC, GALP, ISO regulations - LIMS end-user and database administrator Training - Measurement techniques - Analytical method development - Quality Assurance expertise - System Analysis & Design - Database Management Techniques - Microsoft Fundamental Support Training, Advanced Access, Access Upgrade, and Windows Courses, Microsoft Corporation, PSS East, Visual Basic for Programmers, Novell Netware Courses - SQL Server, Oracle and MS Access 97/2000/XP NOTE: Mr. Fred Rider has participated in over 35 installations of the Sample Master� Products. Russell S. Vranken Over 8 years experience in the computer and LIMS industry. Background Cunently serves as a Software Engineer for A�elerated Summary Technology Laboratories, Inc. and has done so for the past six years while aiding in the development of advanced Laboratory Information Management Systems based on the best available technology. Provides customer support, and assists in custom programming. Assists in maintaining a system for handling and tracking software development of current and existing product line. Assists in the timely development of new software, enhancements and service packs. Corrtribute to maintaining a database of modifications to LIMS software. Responsible for assisting the Sr. Software engineeds, providing programming support, training support, instrument integration and assisting mariceting and sales by providing technical assistance when needed. Contribute to the implementation of new software products and assist in the maintenance of cunent products. Extensive expertise in Windows 95, 98, NT, 2000 and XP. F�ctremely familiar with VB, SQL Server, Oracle and, C+, programming languages. Graduate of the University of Nevada, Reno, Nevada Education B.S. Degree in Computer Information Systems Minor in Business Administration Software Engineer Accelerated Technology Laboratories, Inc. Experience Reno, NV. Mr. Vranken has extensive hardware and software expertise and is an expert in instrument integration and programming handheld devices. Prior to joining ATL he has worked as a Product Sales Manager, MicroAge Computer Center, Reno, NV and a Hardware/Software Manager, COMPUSA, Sacramento, CA. Broad Experience in: - Computer network design - Laboratory database design/LIMS development - LIMS Software setup and maintenance - NELAC, GALP, ISO regulations - LIMS Training (end-user and database administrator) - Measurement techniques - Analytical Instrument Integration - System Analysis & Design - Database Management Techniques - Programming, Expert Systems, Operations - Knowledge of COBOL, Pascal, C+ and Visual Basic programming languages. - Knowledge in system trouble shooting, systems evaluations for upgrades building, and other computer capabilities. - Extensive knowledge in system configuration and intemal hardware in a nefinrork environment. - SQL Server/OracleNisual Basic/Microsoft Access Expertise NOTE: Mr. Russell Vranken has participated in over 37 installations of the Sample Master° Pro products as well as ScreenlT LIMS. Anson Ellstrom Currently serves as a Software Engineer for Accelerated Background Technology Laboratories, Inc. and aids in the development ofAdvanced Summary Laboratory Information Management Systems based on the best available technology. Assists development group in the design of new software development plan for the company's Sample Master� LIMS (Laboratory Information Management Systems) software product family, provide customer support, and assists in custom programming. Assists in maintaining a system for handling and tracking software development of current and existing product line. Assist in the timely development of new software, enhancements and service packs. Contributes to maintaining a database of modifications to LIMS software. Responsible for assisting the Sr. Software engineeNs, providing programming support, training support, instrument integration and assisting marketing and sales by providing technical assistance when needed. Contributes to the implementation of new software products and assists in the maintenance of current products. B.S. in Computer Science, University of North Carolina at Asheville, 2001 Education Software Engineer, Accelerated Technology Laboratories, Inc. Experience Seven Lakes, NC. Assists in customization to Sample Master� Product line, provides installation expertise, perForms instrument integration and trains end- users. Very knowledgeable in hardware and network configuration. Broad Experience in: - Computer network design - LIMS Software setup and maintenance - NELAC, GALP, ISO regulations - End-user Training - Microsoft Visual Basic - Computer Systems and network design - Systems Analysis and Design Methods - Linux Systems Administration - Databases: SQL Server, OraGe, MS Access - Operating Systems: �ndows 95/98, Windows NT/2000, DOS NOTE: Mr. Anson Ellstrom has participated in over 25 installations of the Sample Master� LIMS Products. David Schlabach Currently serves as a Software Engineer for Accelerated Background Technology Laboratories, Inc. and aids in the development ofAdvanced Summary Laboratory Information Management Systems based on the best available technology. Assists development group in the design of new software development plan for the company's Sample Master`� LIMS (Laboratory Information Management Systems) software product family, provide customer support, and assists in custom programming. Assists in maintaining a system for handling and tracking software development of current and existing produd line. Assist in the timely development of new software, enhancements and service packs. Contributes to maintaining a database of modifications to LIMS software. Responsible for assisting the Sr. Software engineer/s, providing programming support, training support, instrument integration and assisting marketing and sales by providing technical assistance when needed. Contributes to the implementation of new software products and assists in the maintenance of current products. Mr. Schlabach has over 8 years of IT experience. Education B.S. in Computer Science, University of North Carolina at Asheville, 2001 Software Engineer at Accelerated Technology Laboratories, Inc. assists in Experience installation, t�aining, customization and customer support to ATL's LIMS product line. Broad Experience in: - Development in VB 6, VB.NET, Microsoft Access, Microsoft Excel, SQL Server, Oracle 9i, ASP.NET. - Quality control - Write design specifications for customer customizations. - Onsite installation and training to new and existing clients - Computer neiwork design - LIMS software setup and maintenance - NELAC, GALP, ISO regulations - End-user training - Microsoft Visual Basic - Computer systems and network design - Systems analysis and design methods - Linux Systems Administration - Databases: SQL Server, Oracle, MS Access - Operating Systems: Windows 95/98, Windows NT/2000, DOS NOTE: Mr. Schlabach has participated in over 15 installations of the Sample Master° UMS products. Rebekah Johnson Background Rebekah Johnson is an experienced Quality Assurance/Control Professional with Summary demonstrated abilities in achieving immediate and long-term goals, and in meeting operational deadlines. Previously, Mrs. Johnson was the Soflware Quality Assurance Manager at Perkin Elmer Labworks for four years, where she was responsible for the daily testing activities of the Laboratory Information Management System (LIMS). As an ATL software engineer, Mrs. Johnson assists development group in the design of new software development plan for the company's Sample Master� LIMS (Laboratory Information Management Systems) software product family, NeoMateT"" and ScreenlTT"" LIMS provide customer support, and assists in custom programming. Assists in maintaining a system for handling and tracking software development of current and existing product line. Assists in the timely development of new software, enhancements and service packs. Contributes to maintaining a database of modifications to LIMS software. Responsible for assisting the Sr. Software engineer/s, providing programming support, training support, instrument integration and assisting marketing and sales by providing technical assistance when needed. Contributes to the implementation of new software products and assists in the maintenance of current products. Education and Bachelor of Science, Information Systems and Decision Sciences, Louisiana State University, 5/2001 Training Experience Broad Experience in: - Computer network design - Laboratory design/LIMS development - LIMS Implementation - LIMS software configuration and maintenance - Technical writing - Quality Process Re-Engineering - Software Testing - Quality Assurance/Quality Control - Requirement Analysis - National Environmental Laboratory Accreditation Conference (NELAC) - Good Automated Laboratory Practices (GALP) - ISO policies - Project Management - Database Processing for Management - Operations Management - Analysis and Design of Management Information Systems