Laboratory Informatics Company Making Labs Digital - Electronic Lab Notebook

1. A Global Laboratory Informatics Company Making Labs Digital

2. Product Overview

3. Logilab Designed for Integrity & Compliance Our solutions are Designedto meet global regulatory compliance & Data Integrity

4. Logilab ELN Introduction AMature & ProvenELN Project/ Test/ Task Database Backend Test /Experiment/Task execution Researcher study recording Inventory usage Stores data in a central SQL-Server database Instrument Interface Integration (LIMS/ERP) Capture any instrument data into ELN from SDMS Integrates with LIMS & other systems

5. Logilab Functional capabilities Mature & ProvenELN Web Architecture Database Backend Logilab ELN is a web based application. Runs on browser Data is stored securely in a secured server database. There is non need to maintain files Template based data capture Structured & Unstructured Data Has built-in template creation tools for data capture in a use friendly manner ELN has both structured data storage using the spreadsheet & and unstructured document based data capture and storage Instrument Data Capture Integrates with any LIMS/ERP/Database Data from instruments can be captured via SDMS Logilab has been designed to integrated with external systems like LIMS/ERP or any database

6. Re-Test PUSH Capture Review Logilab ELN Data Flow Approve Login

7. ELN Functional Highlights Making Labs Paperless Sample Management Excel Management Task Management LIMS Integration Project & Workflow Labsheet Templates Data Identifiers for integration & reporting Instrument Integration Template Evaluation & Validation Document editor based reporting Metalink® Android App Labsheet Data Capture

8. Powerful Dashboard Knowledge is Power • Dashboard for quick overview • Role based dashboards • Configurable dashboard • Download as report • Link to records • Alerts

9. ELN Configuration An End-User configurable ELN 01 02 03 04 Template Sheet/Form/Doc Test Login Validate Use Release Refine 05 06 07 08

10. ELN Configuration An End-User configurable ELN Administrator Effort • Setup Labsheets • Use Instrument data fields from SDMS • Use general & other data fields within sheet • Setup sheet and Test relationship • Map sheet fields with LIMS Test/Parameters

11. ELN Labsheet Configuration A User configurable ELN Tool bar General & Instrument parsed fields

12. ELN Data Capture End-User Interaction Lab User Day-to-Day Activity • LIMS order sync • ELN task ordering • Researcher task ordering • Open Task sheets based on Order ID & Test / Task • Capture data in sheets (Manual entry & Instrument data) • Send results to LIMS

13. Test/Task Ordering End-User Interaction LIMS Orders ELN Orders Excel Orders Pending Task Test Sheet

14. ELN Data Capture • Enter Data any time • Formula auto calculated • Instrument data auto populated • Signature Fields • Data is Date/time stamped • Multiple-users can work on templates • Data collected is versioned (data integrity) • Mark activity completion • Send results to LIMS any time

15. Captured Data End-User Interaction Instrument Data Manual Data Entry Calculations Performed

16. LIMS Mapping One time configuration Mapping sheet cells and LIMS Test Parameters Bookmarking cells in sheet for parameter mapping

17. ELN Data Capture Simple document editor • Document type data input • Insert instrument fields • Insert tables • Insert Images • Insert Charts • Insert tag fields automatically • Store documents in a meaningful manner

18. User Access, Roles & Rights management Access Controls for better compliance • User authentication • Logilab ELN built-in • Windows ADS • User Groups • User rights • Retire/Activate users • Import ADS users • Password Policy

19. Audit Trail 21 CFR Part 11 ready Audit Trail • 100% audit trail • User Login/Logoff • Template creation/editing • Versioning of templates • Data Capture • Who captured, When • Versioning of data • Audi Trail Review • Export of audit trail

20. Cross Link Sheet Future proof data management Link from Laboratory Map Sheet Opens “Daily Lab Inspection” Sheet Create cross links from one sheet to another Open cross linked sheet from any sheet

21. Data Analytics & Report Creation Future proof data management Design time • Create data link inside any sheet • Data link fields can be mapped to any other sheet Run time • Click on data link cells • Select sheet/orders to be opened • Select cell/area to copy • See that data is copied to data link cells

22. ELN Reporting – via Document Editor Office like document editor • Create MS- Office Documents • Browser based editing (protect IP and data integrity) • Collaborative working on same document by multiple users • Automated insertion of data from ELN sheets • Protection of non-editable text • Secure server storage • Authorised user can download as office documents • Integration with email

23. Logilab SDMS-ELN-LIMS Seamless Integration

24. Logilab SDMS-ELN- LIMS Integration Data Flow Architecture Raw File Data Serial Data SDMS Explorer Tablet UI Yes Middleware & Integration Engine RA, Sample, Test ID No Serial Device Y/N? Instrument Data Instrument sends data Parsing Engine LogiLab SDMS Parsed Data Instrument Data Orders (Batch ID, Test, Parameter) Orders Generated by LIMS SDMS SQL Database ELN SQL Database Middleware & Integration Engine LIMS Results Orders/Results FTP File Server REST Call Result for orders File Results mapped to orders ELN Web User Interface WYSIWYG Template SDMS Explorer Web User Interface

25. Thank You