Please enable JavaScript.
Coggle requires JavaScript to display documents.
ELN EXERCISES, Steps to Configure The Experiment Template - Coggle Diagram
ELN EXERCISES
EX 1: OPEN EXPERIMENT
File>Open Experiment Window
Click on menu left side
On exp. Window:
File>Open
EX 2: FAMILIARIZATION W/ EXPERIMENT WINDOW
Create new:
File>New
Click On glass to browse template
Example1 > OK
Descrip: Training
File>Save
EX3: VIEW EXPERIMENT AUDIT HISTORY
File>Open and browse
EX4: LOGGING SAMPLES TO THE EXPERIMENT
Samples>Grid Log Samples
increase # of samples
Tests Tab >
Tests From List Button>Choose Test List
Check box to assign each of the analyses
Log>Log Samples and Save
Why?
EX5: ADDING SAMPLES TO THE EXPER.
Select pH
Samples>Add Sample
Browse or select one of the samples
Save
Click Samples Tab >pH sub tab
Why Only has PH_DAY3?
EX6: ADDING TESTS TO THE EXPERIMENT
select pH Tab
Samples>Add Tests
Browse or select and save
Click Samples Tab and pH sub tab
Only the PH_DAY3 Analisis!
EX7: DRAG AND DROP SAMPLES INTO EXPERIMENT
pH tab and minimize
Samples tab and pH sub tab
Leave window open. From LabWare Home Visual Workflow, select Open under Folders
Browse for SAMPLES_LOGGED folder
Aceept default date range and OK
See all samples logged today
Select remaining samples
Click and hold>drag into Samples tab Exp Window
1 more item...
EX8: DATA ENTRY IN AN EXPERIMENT
From Exp Window, open
Clock Toxin A
Click HPLC(Browse) :select HPLC
In cell E10 to E14, enter values; limits are 1.0 to 1.5 (turn red when ouside range)
Save
Modify values and save. You'll be prompted for an audit reason.
Select Run>Get Files Instrument Data >Selct HPLC>OK
Browse and select HPLC....DAY5.txt in C:... and save
1 more item...
E9: CHARTING AND ATTACHMENTS
From EXP windows - File>New
Browse and select Exp. Temp. CHART1
Click on the charting Example 1 tab
HIghlight C4 to E13. Run>Creat Chart - name training
Add title to the chart an labels fot x an y axis
Change the series names to match column headers
Change the count on the bottom of X to display actual sample #.
Continue exploring options
1 more item...
EX10: CHARTING IN AN EXPERIMENT W/ MACROS
From Exp Win, create new File>New
Browse and select CHART2. Save. Click Chartin Example 2
Click on the DATA BUTTON ON GRAPHIC. Browse for ......txt in c:
Save. sample data populated
Click Samples Tab. New samples were logged
The data button called a macro that trigged code thar log samples.....
EX11: REVIEWING DATA IN AN EXPERIMENT
Logout of LIMS an enter sys manager
From Exp Window, File>Open and browse ex...03. Click WB tab
Slc Data>Highlight Data. Review in the exp by selecting Need Review under Highlight.
Click Highlight button. Under Action, select Review and click Action.
Authorize the data
Save
Check Compliance tab
EX13: CREATE AN EXPERIMENT TEMPLATE
CREATING EXPERIMENT OBJECTS
CREATE SPREADSHEET
CREATE EXPERIMENT WB TEMPLATE
CREATE EXP ID CONFIGURAITION
CREATE EXPERIMENT TEMPLATE
Create a new Experiment Template record and define the Experiment Template settings.
Configure the Experiment Template fields.
Link Workbook Templates to the Experiment Template.
Configuration of the Experiment Template defines settings, views, and rules that apply to the experiment.
Format of Experiment Name
Review Rules
Auto Save Frequency
Display of Compliance Tab
Summary Report
Workbook Version control
Etc.
DEFINED PER EXPERIMENT TEMPLATE
ID CONFIG
Experiment ID can be different for each experiment type.
Defined and configured for your business.
DEFINED PER EXPERIMENT TEMPLATE
EXP WB Template
Created in the Experiment Workbook Template table.
From the Main Menu, select Configure >Explore Tables
Select File >New
Workbook >Set and Edit Workbook Template File
Modify Spreadsheet as needed in Experiment Designer
ONE WITH NO DATA TO USE IN OBJECT
ONE COMPLETED TO TEST CONFIGURATION
Spreadsheet Files
Excel base or Excel compatible
All VB macros removed
Name ranges must use 4+ carach
No special char or WS names
EX12: REVIEWING AN EXPERIMENT
Exercise 14: Creating a Workbook Template File
Exercise 15: Formatting a Workbook File
Exercise 16: Create Name Ranges
Exercise 17: Adding Lists to Workbook
Exercise 18: Adding Buttons to the Workbook
Exercise 19: Create an Experiment ID Configuration
Exercise 20: Create an Experiment Template
Exercise 21: Creating a Macro
Exercise 22: Open an Existing Experiment Workbook Template with Mapping
Steps to Configure The Experiment Template
Configure Experiment ID Configuration
Use the Experiment Template record to define configuration settings
Set the experiment template assigned fields
Set the experiment template assigned experiment workbooks
Create a new Experiment Template record and define the Experiment Template settings.
Configure the Experiment Template fields.
Link Workbook Templates to the Experiment Template.
Configuration of the Experiment Template defines settings, views, and rules that apply to the experiment.
Format of Experiment Name
Review Rules
Auto Save Frequency
Display of Compliance Tab
Summary Report
Workbook Version control
Etc.
DEFINED PER EXPERIMENT TEMPLATE
ID CONFIG
Experiment ID can be different for each experiment type.
Defined and configured for your business.
DEFINED PER EXPERIMENT TEMPLATE
EXP WB Template
Created in the Experiment Workbook Template table.
From the Main Menu, select Configure >Explore Tables
Select File >New
Workbook >Set and Edit Workbook Template File
Modify Spreadsheet as needed in Experiment Designer
ONE WITH NO DATA TO USE IN OBJECT
ONE COMPLETED TO TEST CONFIGURATION
Spreadsheet Files
Excel base or Excel compatible
All VB macros removed
Name ranges must use 4+ carach
No special char or WS names