Introduction to the Worksheet
OnWSH is a fully configurable software solution for creating instrument to LIMS interfaces that deliver the right level of automation to suit the instrument, the laboratory workflow and the analysts.
Laboratories that choose OnWSH to automate the transfer of data between their instruments and LIMS are able to improve laboratory performance by
- Reducing the cost of sample data management
- Reducing their analysts’ workload
- Delivering sample results to their LIMS faster
The OnWSH is a powerful data management tool designed to integrate the laboratory at the bench level and to standardize all analytical techniques. It handles all the complex raw data manipulations allowing only clean and formatted final results to be forwarded to the Database / LIMS system.
Using Online Worksheet to simplify the LIMS and standardize laboratory production
Companies with more than one laboratory and several branches often have very complex LIMS because the LIMS structure is often different in each laboratory or branch. However, a close look at the LIMS system reveals a common pattern at the lab bench level, reflecting the production of the laboratory (Figure 1).
Figure 1. Typical LIMS structure
At the lab bench level, every laboratory performs certain tasks (often using a LIMS), independent of the country it is located in or the product or service it provides:
- Register work requests & schedule work
- Print analytical worksheets
- Monitor and communicate sample/technique backlogs
- Acquire and store analytical data
- Monitor the quality for all analytical work
- Approve analytical data for client release
- Protect security of all data
- Track and locate samples in storage
All that is needed to simplify the LIMS structure is to separate business level information (LIMS) from the laboratory production level information (Online Worksheet) (Figure 2). Standardization then becomes easy to implement. The laboratory production is standardized regardless of the country where the laboratory is located or the type of laboratory (environmental, metal, food, etc).
Figure 2. Online Worksheet & LIMS
BENEFITS
The Online WorkSheet is an essential add-on tool to any LIMS system and will increase the LIMS value through enhanced functionality and flexibility.
- Simplifies the LIMS data model and structure by delivering only clean and formatted data
- Centralizes all QA/QC at the technique/method level
- Standardizes a diversified company by providing a common system at the techniques level
- Dramatically reduces LIMS implementation costs
- Reduces training time by focusing on user expertise
- Increases acceptability by staff because they can design and configure method-specific worksheet
- Reduces pressure on IT personnel
- Helps achieve '21 CFR Part 11' compliance
- Extremely fast data access and queries
- Very low maintenance cost, "off-the-shelf system"
Productivity benefits
Productivity is the key and main reason for incurring the cost and effort of acquiring an Electronic Lab Notebook (ELN). Online Worksheet offers more productivity benefits than any other system of its type.
- Rapid payback by decreasing operation expenses
- Eliminates manual data entry and calculation errors
- Increases laboratory revenue, high data throughput
- Increases manufacturing revenue by delivering data faster
- Provides Regulatory Compliances guidelines via an electronic system
- Data analysis and management tools for the QC officer
- Data validation against an integrated QA/QC system
- Reduces service & maintenance cost; of the shelf product
FEATURES
OnWSH ELN (Electronic Lab Notebook)
- Very easy to learn, Excel-like spreadsheet and formulas
- Automatic calculation and storage of significant figures
- Advanced number formatting system
- Stores analytical data without losing significant digits
- Technicians design their own technique templates
- Full cell formatting features (font type, colors, borders)
- Data validation against QC database
- Raw instrument data available on-screen
- Full auditing and traceability back to raw instrument data
- Configurable levels of Audit trail and user access
- Integrated Quality Control Module
Data Management and Statistics System
- Real-time work list generation for pending work
- Color coded real-time work status
- Advanced filtering and querying capability
- Sample tracking system
Instrument Interface System
- Simple, fast connection to many instruments
- Instrument database for service and calibration checks
- Stores all instrument data (inc. calibration) for traceability
- Supports uni- and bi-directional instrument interfaces
- On-line or manual input of instrument data
Database / LIMS Interfacing System
- Flexible interfaces through shared files and plug-ins
- Two-way LIMS communication and feedback
- Flexible data export formats (CSV, TXT, Excel, XML)
- Prioritized pending work lists and report updates
Specifications & Tech requirements
- True Object-Oriented WIN32 Application (MFC)
- MS SQL, MySQL or Oracle database support
- Client/Server 3th tier Win32 architecture
- Client PC Pentium III 350 MHZ and 128 MByte RAM
- Windows 9x, NT, 2000, XP
- Microsoft Excel is trademark of Microsoft Corporation.
|
