how to automate calculations in empower (using custom fields) · ©2017 waters corporation ....

©2017 Waters Corporation 1 COMPANY CONFIDENTIAL

How to Automate Calculations in Empower

(Using Custom Fields)

Arjan Timmerman


A field is a column of information in a table.

A custom field is a user-defined field in a table.

Custom fields can be descriptors and formulas.

It is not excel!

All information of a Custom Field is captured in the Database and can be

re-used

What are Custom Fields


Custom Field

Build-in functionality – 6 Field Types, 6 Data Types


Custom Field – Types explained

6 Field Types

– Sample - Describes samples, vials, custom samples, and sample parameters

– Sample Set - Identifies a sample set

– Component - Identifies the analyte

– Result - Performs result-level calculations based on a specified formula

– Peak - Performs result-level calculations based on a specified formula

– Distribution - Serves as slice-level parameter for GPC/V data; calc. according to a specified formula

6 Data Types

– Integer (0) - Whole number entry (without fractional parts).

– Real (0.0) - Floating-point number entry (can contain a fraction).

– Text - Alphanumeric entry.

– Date - Date entry entered by the user or from an external source (for example, a peak field).

– Boolean - Boolean fields allow you to translate a mathematical formula into a specific value, or

answer upon processing. If then else…

– Enumerated - Enumerated fields provide the user with a list of multiple possible answers, for example

Vial 1, Vial 2, Vial 3.


Custom Field – Location and Privilege

Custom fields are created in a Project.

You must have the Alter Any Project and Create Custom Fields

privileges to create a custom field.

And there are 5 privileges specific to custom fields

– Alter, Create, Delete, Lock and Unlock.


During creation of new project Empower delivers 7 Standard Fields

All CField ID’s are < 100

Any user created Custom Field has an CField ID > 100

During Filtering, 7 more columns can be shown

What standard fields are available?


In Empower

– Value = Component Weight

– Purity = Component Purity (0.001 - 150.000 %)

– Sample Weight = 1 (not normally used)

– Dilution = Dilution of Standard

Correct for Sample Weight and Dilution

– X-Value = Calculated on Responses (e.g. Area or Height) and Amount

– Sample Weight = Weighing of the Sample

– Dilution = Dilution of Sample

Empower

Quantitation Theory – Amount Calculation

Standard

Standard

StandardDilution

Wt Sample x

100

Purity x Value Amount

Sample

Sample

Sample

Standard

Standard

SampleWt Sample

Dilution x Response x

Response

AmountAmount

X-Value


Create a Custom Field to enter additional Sample Comment

Example 1a

Sample, Text – Sample Comment

After creation… Sample Information then can be filled


Create a Custom Field to enter Number of Tab

Example 1b

Sample, Integer (0) – NumOfForm



Create a Custom Field to enter Density of the Sample

Example 1c

Sample, Real (0,0) – Density



Create a Custom Field to enter the Notebook / Page

Example 2a

Sample Set, Text Field - NoteBook

After creation… Sample Set Information then can be filled


Create a Custom Field to select the Department Name

Example 2b

Sample Set, Enum Field - DepartmentName

After creation… Sample Set Information then can be filled

- Free entry or select QC / R&D


Create a Custom Field to enter the Label Claim

Example 3

Component, Real (0,0) Field – LabelClaim

After creation… Amount Information then can be filled


Create a Custom Field to calculate % Relative to the Label Claim!

Example 4a

Peak, Real (0,0) Field – % Relative Label Claim

After creation… Formula is Calculated

- Using the Component Custom Field for the Label Claim, different Label Claims are supported


Create a Custom Field to check % Relative to the Label Claim to Spec.

Example 4b

Peak, Real (0,0) Field – Check Specification

After creation… The Label Claim is Checked

And also Above and Below will work!


Create a Custom Field to be filled by External System

Returns a Yes at the moment a

result is sent to SAP (using the

SAP interface)

Example 5

Result, Boolean Field – Fill external SAP


Create a Custom Field to calculate a Distribution

Example 6

Distribute, Real (0,0) – Calculate Distribution

After creation… The Distribution is Calculated


All CField > 100 are newly created

Overview of the created Custom Fields

Remember: In case of regulated / controlled work environment, the Custom Fields as shown in this example, do need structural testing and validation prior to its usage


When using Custom Fields in reports, remember there can be an effect on

changing a Custom Field!

– Example; Sample, Text Custom Field changes length from 20 to 32 characters.

– Result; the data entered in the updated Custom Field will be filled, but over 20

characters, there might be a cut-off

– Example; Sample, Text Custom Field is renamed from Department to Dept

– Result; The Custom Field is not recognized in the report anymore (error)

– Also if the Custom Field is part of another Custom Field, renaming can be tricky

– Example; Dilution and Sample Weight Custom Fields – Do not change them

– Result; Waters strongly advices not to change the standard Custom Fields

Remarks to using Custom Fields


Questions?


Custom Field to check

for Manual Integration

The proposed formula:

EQ(EQ(Int Type,"BB")+EQ(Int Type,"BV")+EQ(Int Type,"VB") +EQ(Int

Type,"VV")+EQ(Int Type,"EE")+EQ(Int Type,"VE") +EQ(Int

Type,"EV")+EQ(Int Type,"TV")+EQ(Int Type,"VT") +EQ(Int

Type,"TT")+EQ(Int Type,"BS")+EQ(Int Type,"SB") +EQ(Int

Type,"VR")+EQ(Int Type,"RV")+EQ(Int Type,"BG") +EQ(Int

Type,"GB")+EQ(Int Type,"VX")+EQ(Int Type,"XV")

+EQ(Int Type,"Group"),0)

Remember: In case of regulated / controlled work environment, the Custom Fields as shown in this example, do need structural testing and validation prior to its usage




Result in Review

Slight adjustment would

immediate flag the peak

for change in Integration

Type, or addition of peaks




This can be taken a step further by creating a Result Type Custom Field

using the previous Calculation as a Use As ‘Value’

See proposed formula EQ(SUM(IntVal),0)




These Custom Fields can also be brought into Preview

how to automate calculations in empower (using custom fields) · ©2017 waters corporation ....

Documents