2 INDEX Introduction –LIMS Benefits –System architecture –LIMS Modules LIMS Presentation A...
-
date post
18-Dec-2015 -
Category
Documents
-
view
230 -
download
5
Transcript of 2 INDEX Introduction –LIMS Benefits –System architecture –LIMS Modules LIMS Presentation A...
www.online-lims.com
2
INDEX
• Introduction– LIMS Benefits– System architecture– LIMS Modules
• LIMS PresentationA guide through LIMS based on a lab workflow: – sample login– worksheet– QA/QC– reporting– Management
• Closing
Online LIMSWhat is Online LIMS ?
•A ready to go, “off the shelf” system .
•A very fast, efficient and easy to use LIMS.
•Developed using “state of the art” technology
Who is Online LIMS ?Online LIMS started as a UNIX based LIMS at the end of the 80's. The team is composed of experienced chemists, hardware and software engineers and IS support personnel.
"We are specialized in the mining and commercial laboratories supporting Geochemical, Mineralogy and Environmental labs"
Features and Benefits
Very fast report access & queries
On-line, work group based, Excel like spreadsheet files
Automatic calculation and storage with significant figures
Simple to use Excel-like formulas
Color coded “real time” work status
Integrated with advanced QA/QC system
Simple to use and easy to learn: “Standard Windows look and feel”
Audit trail logs and data validation
LIMS ModulesOnline LIMS is structured in modules (Applications). Each module represents one of the major activities in the lab. This simplifies the use and learning of the LIMS. A technician does not necessary need to learn about administrative modules.
1. OnSETUP – Static data management and configuration
2. OnREPO – Login, Reporting, Statistics and Management
3. OnWSH – Instruments and worksheets
4. OnLQC – Interactive QA/QC
5. OnSAMPLE – Sample management system
6. iOnView – Internet LIMS browser
iOnView
Worksheetfile
OnREPOOnLQCOnWSH
LIMS DATABASE
OtherDATABASE
or LIMS
InstrumentInterfacing
PRODUCTION
LABORATORY
Online LIMS is based on the standard SQL database interfaced through ODBC (Open Database Connectivity). ODBC is a software interface that allows Online LIMS to talk to any SQL (Structured Query Language) database.
Online LIMS Architecture
7
LIMS PRESENTATION
A Guide through
Online LIMS
sample loginworksheetsQA/QCreportingmanagement
Hmmmm...
** Sample Login **
Online LIMS Online LIMS ccoolloorr code status code status
Online LIMS provides color coded information:
•RED for pending work•GREEN for completed work•BLUE for invoiced work
Each of those colors is highlighted (bright color) when a report is locked or approved.
Color Codes
Sample loginThe report has a special sample editor that can easily copy incremental
sample id’s. This unique feature saves time. Many customizable pick lists
are available for fast data entry.
Samples can be logged in many ways:•By predefined report templates•By automated job creation (option)•By client tools (OnSAMPLE)•Data logger
Sample Tracking
Samples can be easily tracked through the system. Each time the bar code label is scanned, or the sample is handled, the LIMS tracks the position
and chain of custody.
Sample Storage
Sample Labels
Sample labels can be customized to the identification and safety requirements of any lab.
Customized labels
through Crystal Reports
Work ordersWork ordersAfter sample login, an internal work order can be printed by request. Many work orders formats are available trough Crystal Reports
Sample type iscolor coded
Full cell formatting
Method
Online LIMS’s impressive speed is made possible by a unique architecture that allows complex Excel-like formulas as well as cell
attributes to be stored along with the Raw data in the database.
Pop up screen for Dup’s
Online LIMS spreadsheetOnline LIMS spreadsheet
Any test information can be picked up from the analysis method library. This information is copied to the report and can be modified without altering the main library.
Method selection
sample loginworksheetsQA/QCreportingmanagement
** WSH
**
Online LIMS Worksheet …Online LIMS Worksheet …
The Online LIMS instrument interface is much more than a simple link between the database and instruments. It provides an analytical
instrument environment which allows the analyst to structure customized worksheets at the bench. The same worksheet accepts multiple
instrument links for direct on-line reading.
True electronic equivalent of a technician’s log book
Automatic Dup’s popup
Excel-like formulas
Type your comments
“a true worksheet”
Instrument Interface System
Direct transfer of instrument data to the LIMS database Simple, fast connection to any electronic instrument On-line, instrument specific worksheet structures
For auditing, all instrument information, including calibration, are recorded with the work sheet log file.
Instrument log book
sample loginworksheetsQA/QCreportingmanagement
** QA/QC **
Online LIMS Quality Management
The LIMS QA/QC module plots a Shewhart Control Chart with control values by report and provides the analyst with the data required to make informed
decisions. This module provides “real time” QC data by automatically extracting the QC samples from the reports and updating the QC database
OnLQC (Online LIMS Quality Control) is an interactive statistical module. The two graphic cursors allow the user to select any outlier(s) for special
statistic analysis. Each data point can be hidden or unhidden.
Interactive QC Chart
The distribution curve graphically displays standard data and lists the range, average, standard deviation, and number of QC data points collected for the control. All QA/QC libraries can be exported to EXCEL for further analysis and reporting.
Distribution plotting
sample loginworksheetsQA/QCreportingmanagement
** Reporting **
Online LIMS Reporting
In any laboratory, the analysis report is the final product that goes to the customer. Online LIMS has several modules that make reporting an easy task.
Online LIMS script design
or Crystal Reports
Online LIMS includes an intelligent report-printing utility that allows the user to define a customizable report format. A variety of options can be selected to determine the size of the print, the orientation of the printing, the number of copies, and so on.
The intelligent report print module will generate the best print format for you. Landscape, portrait character size, split lines, etc., every setting is done for you. Even avoid printing only one line on the last page ! Of course, you do the final touches ...
Intelligent report formatting
Many export formats are available. Exporting formats and export paths can be predefined for each customer, to avoid lost files and make the work easier.
Online LIMS ExportingOnline LIMS Exporting
Many export formats:
Excel, Text, XML, etc
You can send data automatically from Online LIMS to any process or your production database.
A B C D E F G H I1 REP No. JUL2213.R952 Customer Mine d'Or3 Attention D. Smith4 Reference Hydromet5 Project 4704-T 31B6 Samples Routine Pulp7 Chemist I. M. Lewis89 Title ---10 Date 19.07.951112 Type Sample ID Cu Fe Ni Au Pd Pt Cl13 % % % g/t g/t g/t %14 31B pH 1.7 Precip. 0.33 17.60 0.13 0.52 0.38 0.13 5.1315 32B pH 1.7 Precip. 0.38 17.65 0.18 0.57 0.43 0.18 5.1816 33B pH 1.7 Precip. 0.36 17.63 0.16 0.55 0.41 0.16 5.1617 34B pH 1.7 Precip. 0.41 17.68 0.21 0.60 0.46 0.21 5.2118 35B pH 1.7 Precip. 0.21 17.48 0.01 0.40 0.26 0.01 5.0119 31A pH 1.7 Precip. 0.26 17.53 0.06 0.45 0.31 0.06 5.0620 32A pH 1.7 Precip. 0.24 17.51 0.04 0.43 0.29 0.04 5.0421 33A pH 1.7 Precip. 0.29 17.56 0.09 0.48 0.34 0.09 5.0922 34A pH 1.7 Precip. 0.49 17.76 0.29 0.68 0.54 0.29 5.2923 35A pH 1.7 Precip. 0.54 17.81 0.34 0.73 0.59 0.34 5.3424 DUP 35B pH 1.7 Precip. 0.19 17.46 <0.01 0.38 0.24 <0.01 4.9925 35A pH 1.7 Precip. 0.55 17.82 0.35 0.74 0.60 0.35 5.35
A B C D E F G H I1 REP No. JUL2213.R952 Customer Mine d'Or3 Attention D. Smith4 Reference Hydromet5 Project 4704-T 31B6 Samples Routine Pulp7 Chemist I. M. Lewis89 Title ---10 Date 19.07.951112 Type Sample ID Cu Fe Ni Au Pd Pt Cl13 % % % g/t g/t g/t %14 31B pH 1.7 Precip. 0.33 17.60 0.13 0.52 0.38 0.13 5.1315 32B pH 1.7 Precip. 0.38 17.65 0.18 0.57 0.43 0.18 5.1816 33B pH 1.7 Precip. 0.36 17.63 0.16 0.55 0.41 0.16 5.1617 34B pH 1.7 Precip. 0.41 17.68 0.21 0.60 0.46 0.21 5.2118 35B pH 1.7 Precip. 0.21 17.48 0.01 0.40 0.26 0.01 5.0119 31A pH 1.7 Precip. 0.26 17.53 0.06 0.45 0.31 0.06 5.0620 32A pH 1.7 Precip. 0.24 17.51 0.04 0.43 0.29 0.04 5.0421 33A pH 1.7 Precip. 0.29 17.56 0.09 0.48 0.34 0.09 5.0922 34A pH 1.7 Precip. 0.49 17.76 0.29 0.68 0.54 0.29 5.2923 35A pH 1.7 Precip. 0.54 17.81 0.34 0.73 0.59 0.34 5.3424 DUP 35B pH 1.7 Precip. 0.19 17.46 <0.01 0.38 0.24 <0.01 4.9925 35A pH 1.7 Precip. 0.55 17.82 0.35 0.74 0.60 0.35 5.35
Link Link Online LIMS Online LIMS
to your to your processprocess
sample loginworksheetQA/QCreportingmanagement
**Management
Online LIMS ManagementOnline LIMS arranges samples by Reports (jobs). This is a query concept that makes the searching for data very fast.
Reports can be listed by customer, project, work status (i.e. pending work) or any other desired grouping.
The report browser is Online LIMS’s main menu, all jobs are run from here.
Samples by Day Graphic generated online. The GREEN color shows standards and the RED color Duplicates. This graphic presentation
helps a manager track the volume of work in the laboratory.
Charts
Provides an immediate overview of the status of each report and analysis. Filters can be used to specify certain criteria (i.e. view only pending reports for a certain client, project, service group, date, and/or analysis).
The Pending Work Utility
Fully automated costing / invoicing Price library including package pricing and client-specific discounts/packages Full client addresses, FAX numbers, and phone numbers Management statistics EXCEL-exportable data and statistics
( Nr. C3194 )
January 18, 1995
Gold Mining Ltd ( 6 )Por la Quebrada del fondoCOPIAPO
Attn : Mr. Dagobert Duck Project : WERTUIOReport # : JAN0049.C95
Ref.: Fax from January 1810
Qty Description US$ unit US$ total --------------------------------------------------------------- 43 Primary Crunched 1.93 82.99 43 Secondary Crunched 1.93 82.99 43 Pulverized 5.79 248.97 43 Sample dry 0.77 33.11 43 Au by A.A. (10 g sample) 19.31 830.33 43 Ag in solution 7.72 331.96 43 Bar Metal Dore (Cu) 19.31 830.33 43 Det. of Mo by A.A. (5§ Elem.) 1.93 82.99 43 Det. of As > 31 sample 12.74 547.82 43 Barra Metal Dor‚ (Pb) 19.31 830.33 43 Det. of Zn by A.A. (2§ Elem.) 3.86 165.98 43 Det. of Mn by A.A. (Menas) 9.66 415.38 ------------------------- SUB TOTAL US$ 4483.18 Disc 5% US$ 224.16 SUB TOTAL US$ 4259.02
Analysis 4,259.02 4,259.02 TAX 7 % 298.13 4,557.15 - Advance 500.00 4,057.15 ---------------------- TOTAL US$ 4,057.15
Online LIMSCustomized Invoice Copy
get exact analysis qtyfrom the report
all type of calculationsfor routinely work
Load customer information fromLIMS Customer Database ( Nr. C3194 )
January 18, 1995
Gold Mining Ltd ( 6 )Por la Quebrada del fondoCOPIAPO
Attn : Mr. Dagobert Duck Project : WERTUIOReport # : JAN0049.C95
Ref.: Fax from January 1810
Qty Description US$ unit US$ total --------------------------------------------------------------- 43 Primary Crunched 1.93 82.99 43 Secondary Crunched 1.93 82.99 43 Pulverized 5.79 248.97 43 Sample dry 0.77 33.11 43 Au by A.A. (10 g sample) 19.31 830.33 43 Ag in solution 7.72 331.96 43 Bar Metal Dore (Cu) 19.31 830.33 43 Det. of Mo by A.A. (5§ Elem.) 1.93 82.99 43 Det. of As > 31 sample 12.74 547.82 43 Barra Metal Dor‚ (Pb) 19.31 830.33 43 Det. of Zn by A.A. (2§ Elem.) 3.86 165.98 43 Det. of Mn by A.A. (Menas) 9.66 415.38 ------------------------- SUB TOTAL US$ 4483.18 Disc 5% US$ 224.16 SUB TOTAL US$ 4259.02
Analysis 4,259.02 4,259.02 TAX 7 % 298.13 4,557.15 - Advance 500.00 4,057.15 ---------------------- TOTAL US$ 4,057.15
Online LIMSCustomized Invoice Copy
get exact analysis qtyfrom the report
all type of calculationsfor routinely work
Load customer information fromLIMS Customer Database
Costing Module
1995 Financial and Analysis Statistic
0
10000
20000
30000
40000
50000
60000
70000
JAN
FEB
MA
R
AP
R
MAY JU
N
JUL
AU
G
SE
P
OC
T
NO
V
DE
C
0
100000
200000
300000
400000
500000
600000
$
Tot Sample
Tot Test
Tot Analysis
Tot Pending
$ Total
ONLINE LIMS has a financial management statistics module which provides senior laboratory personnel with the ability to create
customized monthly financial and workload statistics. This information can also be exported to EXCEL to allow the user to custom chart this
data.
Statistics
LIMS Configuration
Online LIMS manages all static data centralized in one tool called OnSETUP.
The analysis library is a real method libraryPrice list for automated invoicingUser management and access rightsSOP File managementClient databaseConfiguration table for LIMS customization QC Sample managementInstrument databaseAudit logsError Logs … and more …
Online LIMS manages all static data centralized in one tool called OnSETUP.
The analysis library is a real method libraryPrice list for automated invoicingUser management and access rightsSOP File managementClient databaseConfiguration table for LIMS customization QC Sample managementInstrument databaseAudit logsError Logs … and more …
iOnView – Internet Tools
© 2001 by Online LIMS
www.online-lims.com
Thank you for your time !
**closing**