Metrohm tiBase 1.0 User Manual
tiBase 1.0
Online help
8.101.8025EN
Metrohm AG
CH-9101 Herisau
Switzerland
Phone +41 71 353 85 85
Fax +41 71 353 89 01
info@metrohm.com
www.metrohm.com
tiBase 1.0
Online help
8.101.8025EN 10.2009 doe /ek /fk /pkl
Teachware
Metrohm AG
CH-9101 Herisau
teachware@metrohm.com
This documentation is protected by copyright. All rights reserved.
Although all the information given in this documentation has been checked
with great care, errors cannot be entirely excluded. Should you notice any
mistakes please send us your comments using the address given above.
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Table of contents
1 Introduction 1
1.1 Welcome to tiBase ................................................................ 1
1.2 Application ............................................................................ 2
1.3 Operation ............................................................................ 2
1.4 Connecting devices ............................................................... 3
1.5 Database ............................................................................... 3
1.6 Communication ..................................................................... 4
1.7 Conformity ........................................................................... 4
1.8 Versions ................................................................................ 5
1.9 Online help ........................................................................... 6
2 General program functions 7
Table of contents
2.1 Program parts ....................................................................... 7
2.1.1 Program parts .......................................................................... 7
2.1.2 Database - Desktop ................................................................. 7
2.1.3 Configuration - Desktop .......................................................... 8
2.2 Login/password protection .................................................. 8
2.2.1 General information on Login/Password protection ................. 8
2.2.2 Login ....................................................................................... 9
2.2.3 Log out manually .................................................................. 10
2.2.4 Log out automatically ............................................................ 10
2.2.5 Changing password ............................................................... 10
2.3 Electronic signatures .......................................................... 11
2.3.1 Rules for electronic signatures ............................................... 11
2.3.2 Procedure for electronic signatures ........................................ 12
2.3.3 Signature Level 1 ................................................................... 13
2.3.4 Signature Level 2 ................................................................... 14
2.3.5 Delete Signature Level 2 ........................................................ 16
2.4 Formula editor .................................................................... 17
2.4.1 Input field .............................................................................. 17
2.4.2 Calculation algorithms ........................................................... 18
2.4.3 Variables ............................................................................... 20
2.4.4 Operators/functions ............................................................... 32
2.4.5 Molar mass calculator ............................................................ 66
tiBase 1.0
2.5 Editing ................................................................................. 67
2.5.1 Select date ............................................................................ 67
2.5.2 Text editor ............................................................................. 67
2.5.3 Hyperlink ............................................................................... 68
￭￭￭￭￭￭￭￭
III
Table of contents
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
3 Configuration 70
3.1 Configuration - General ..................................................... 70
3.1.1 Configuration - Definition ...................................................... 70
3.1.2 Configuration - Desktop ........................................................ 70
3.1.3 Configuration - Menu bar ...................................................... 71
3.1.4 Configuration - Toolbar ........................................................ 72
3.1.5 Configuration - Subwindows ............................................ 72
3.1.6 Configuration - Functions ...................................................... 73
3.1.7 View ...................................................................................... 74
3.2 Administration .................................................................... 74
3.2.1 User administration ............................................................... 74
3.2.2 Security settings .................................................................... 82
3.2.3 Program administration ......................................................... 91
3.3 Configuration data ............................................................. 95
3.3.1 Export/Import ........................................................................ 95
3.3.2 Backup/Restore ...................................................................... 97
3.3.3 Options ............................................................................... 100
3.4 Subwindow Import processes ......................................... 101
3.4.1 Import processes - General .................................................. 101
3.4.2 Import processes - Table ...................................................... 102
3.4.3 Import processes - Properties ............................................... 103
3.5 Subwindow Import protocol ........................................... 104
3.5.1 Import protocol - General .................................................... 104
3.5.2 Import protocol - Table ........................................................ 104
3.5.3 Import protocol - Properties ................................................. 106
4 Database 107
4.1 Database - General ........................................................... 107
4.1.1 Database - Definition ........................................................... 107
4.1.2 Database - Desktop ............................................................. 107
4.1.3 Database - Menu bar ........................................................... 108
4.1.4 Database - Toolbar ............................................................ 112
4.1.5 Database - Subwindows .................................................... 113
4.1.6 Database - Functions ........................................................... 114
4.1.7 Views .................................................................................. 115
4.2 Database display .............................................................. 118
4.2.1 Open database ................................................................... 118
4.2.2 Select database ................................................................... 119
4.2.3 Display single database ....................................................... 120
4.2.4 Display databases next to one another ................................. 120
4.2.5 Display databases one below the other ................................ 120
4.2.6 Close database ................................................................... 120
￭￭￭￭￭￭￭￭
IV
4.3 Manage databases ........................................................... 120
4.3.1 Manage databases ............................................................. 120
4.3.2 Create new database ........................................................... 122
4.3.3 Rename database ................................................................ 122
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Table of contents
4.3.4 Delete database ................................................................... 122
4.3.5 Database properties ............................................................. 123
4.3.6 Backup database manually ................................................... 126
4.3.7 Restore database ............................................................... 127
4.4 Templates .......................................................................... 128
4.4.1 Report templates ................................................................. 128
4.4.2 Curve overlay templates ....................................................... 164
4.4.3 Templates for control chart .................................................. 169
4.4.4 Export templates ................................................................. 173
4.5 Determination overview .................................................. 200
4.5.1 Determination overview - General ........................................ 200
4.5.2 Determination overview - Functions ..................................... 206
4.6 Subwindow Information .................................................. 251
4.6.1 Information - Overview ..................................................... 251
4.6.2 Information - Determination ........................................... 251
4.6.3 Information - Method ..................................................... 253
4.6.4 Information - Sample ........................................................... 255
4.6.5 Information - Configuration ......................................... 255
4.6.6 Information - Messages ..................................................... 259
4.6.7 Information - Determination comment .............................. 259
4.7 Subwindow Results .......................................................... 260
4.7.1 Results - General .................................................................. 260
4.7.2 Results - Results overview .................................................... 260
4.7.3 Results - Raw data ............................................................... 262
4.7.4 Results - Calculation # ......................................................... 269
4.7.5 Results - Properties .............................................................. 271
4.8 Subwindow curves ........................................................... 272
4.8.1 Curves - General .................................................................. 272
4.8.2 Curves - Measuring point list ................................................ 273
4.8.3 Properties ............................................................................ 273
5 How to proceed? 285
5.1 Backup ............................................................................... 285
5.1.1 Backing up database ........................................................... 285
5.1.2 Restoring database .............................................................. 287
5.1.3 Backing up configuration data ............................................. 287
5.1.4 Restoring configuration data ............................................... 289
5.2 Determinations ................................................................. 290
5.2.1 Search for determinations .................................................... 290
5.2.2 Filter determinations ............................................................ 291
5.2.3 Sign determination .............................................................. 292
5.2.4 Export determinations ......................................................... 294
5.2.5 Import determinations ....................................................... 295
5.2.6 Deleting determinations ..................................................... 296
5.2.7 Make the determination version current .............................. 297
5.2.8 Reprocessing determinations ............................................... 298
5.2.9 Printing determination report ............................................. 302
tiBase 1.0
￭￭￭￭￭￭￭￭
V
Table of contents
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
5.2.10 Printing determination overview ........................................ 303
5.3 Databases .......................................................................... 304
5.3.1 Database in general ............................................................. 304
5.3.2 Open database ................................................................... 305
5.3.3 Close database ................................................................... 305
5.3.4 Create database .................................................................. 306
5.3.5 Backing up database ........................................................... 307
5.3.6 Restoring database .............................................................. 308
5.3.7 Delete database ................................................................... 309
5.4 Configuration data ........................................................... 309
5.4.1 Configuration data in general .............................................. 309
5.4.2 Export configuration data .................................................... 310
5.4.3 Importing configuration data ............................................... 310
5.4.4 Backing up configuration data ............................................. 311
5.4.5 Restoring configuration data ............................................... 312
5.5 Import of PC/LIMS reports ............................................. 313
5.5.1 Import - automatically ......................................................... 313
5.5.2 Import - manually ................................................................ 314
5.5.3 Edit import .......................................................................... 315
5.5.4 Import - one USB stick ......................................................... 316
5.5.5 Import - several USB sticks ................................................... 317
5.5.6 Import protocol - Properties ................................................. 320
5.5.7 Delete import protocol ........................................................ 321
5.6 Reports .............................................................................. 321
5.6.1 Creating report template .................................................... 321
5.6.2 Edit report template ........................................................... 322
5.6.3 Printing determination report ............................................. 324
5.6.4 Printing determination overview ........................................ 325
5.7 No Help available ............................................................. 326
Index 327
￭￭￭￭￭￭￭￭
VI
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
1 Introduction
1.1 Welcome to tiBase
Introduction
1 Introduction
tiBase is a program for administrating analysis data on the basis of PC/LIMS
reports. These reports can be read from the corresponding Metrohm instruments.
Overview of the main program features
￭ User interface: easy to operate and configure
￭ Application
￭ Comprehensive online help
Program versions
￭
tiBase 1.0
￭￭￭￭￭￭￭￭
1
1.2 Application
1.2 Application
tiBase is a database program for administrating data on the basis of PC/
LIMS reports. The reports from Titrino plus, Compact Titrosampler, PC Control 6.0 and Touch Control 5.840.0150 can be read into tiBase .
1.3 Operation
Introduction
The modern user interface makes it simple for the user to find his/her way
around tiBase . The bar on the left edge of the screen gives you access to
the two basic elements of tiBase :
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Database Configura-
tion
Depending on the access rights, these buttons are either visible or invisible.
The menu bar is in the upper part of the screen. It is also possible for the
individual commands to be masked out, depending on the access rights.
In the center of the screen there are the subwindows with determination
overviews, curves information or results. This view can be set individually for
each user with the aid of the new Layout Manager. This means that the users
only see the buttons needed for their work. This reduces the introductory
period for routine users to a minimum; incorrect operation as a result of
overcrowded screens are also a thing of the past.
￭￭￭￭￭￭￭￭
2
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
1.4 Connecting devices
Introduction
PC/LIMS reports can be read into tiBase from:
￭ Titrino plus
848, 870, 877
￭ 862 Compact Titrosampler
￭ Titrando
808, 809, 835, 836, 841, 842, 855, 857, 888, 890, 901, 902, 904, 905,
906, 907
Control by Touch Control 5.840.0150 or PC Control 6.0
1.5 Database
Introduction
tiBase is based on an object-oriented database, that has proven itself
in practice. In the configuration database, all program settings, user
administration, methods and templates are stored and in the determina-
tion databases defined by the user, the determination data. These databases can be installed locally on the computer reserved for measurements
and make up a simple measurement system. tiBase is however scalable
and grows with operational requirements. As soon as data security and
central data management make it necessary, tiBase is installed as a Client/
Server configuration. The tiBase database is then installed on a server.
All measurement and office computers work as clients. All results are stored
centrally in this network and can be accessed and processed by all Client
PCs. All clients also access the same pool of methods.
1 Introduction
tiBase 1.0
The new database has all the major tools necessary for management of,
searching for and grouping of results. Quick filters allow the user to search
through thousands of determinations within seconds and to display the
result clearly. Chart plots give a fast overview of the sequence of results
based on time.
All options for reprocessing are available to the user.
Overview of functions
￭ Object-oriented Client/Server database (see Chapter 3.2.3.1, page
91).
￭ Layout manager for the database view (see Chapter 4.1.7, page 115).
￭ Quick filter (see Chapter 4.5.2.4.3, page 210).
￭ Efficient search functions (see Chapter 4.5.2.3, page 207).
￭ Access rights control for every database (see Chapter 4.3.5.3, page
124).
￭￭￭￭￭￭￭￭
3
1.6 Communication
￭ Automatic database backup (see Chapter 4.3.5.4, page 124).
￭ Control cards (see Chapter 4.5.2.16, page 248).
￭ Reprocess determinations (see Chapter 4.5.2.6, page 220).
1.6 Communication
Introduction
The decisive factor for acceptance is easy and economical integration in
existing laboratory information systems, central databases and long-term
archiving systems.
tiBase is communicative. Data generated in tiBase can be exported in
XML and CSV format. Connection to LIMS systems on the market is thus not
difficult. Export to long-term archiving systems such as NuGenesis SDMS or
Scientific Software Cyberlab is also supported.
The Report generator provides a simple and flexible solution for creating
analysis reports. The report generator allows you to freely define the report.
It is therefore possible at any time to display one or more determinations in
a choice of PDF layouts or as a printout.
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Overview of functions
￭ Import of PC/LIMS reports (see Chapter 3.4.3, page 103)
￭ Various export formats , e.g. XML, CSV, SLK (see Chapter 4.4.4.2.1, page
174).
￭ Report designer (see Chapter 4.4.1.4.1.1, page 131).
￭ E-mail functions for security settings (see Chapter 3.2.2.7, page 89).
￭ Sending determinations by E-mail (see Chapter 4.5.2.7, page 242).
1.7 Conformity
Introduction
With regard to GMP and GLP requirements, tiBase sets new standards.
The latest quality standards and validation procedures were implemented in
developing and programming the software. A centralized user administration defines the access rights for program functions and determinations,
whereby any number of users with freely definable access profiles are possible. The system administrator can conveniently access the user administration from any tiBase client. Access to the software is password-protected
and there is a choice of tiBase or Windows login.
The use of digital signatures makes it possible to sign determinations.
There are two signatures available with differing properties. With the first
signature (Level 1, Review) the user confirms that he has programmed the
method correctly or carried out the analysis correctly. With the second signature (Level 2, Release) the method or result is released and protected
￭￭￭￭￭￭￭￭
4
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
1 Introduction
against further modifications. It is thus possible to mirror customized workflows in tiBase .
All data is organized according to the version and protected against unauthorized access, modification or deleting in the database. The database itself
controls access to the data in network operation and provides archiving and
restore functions.
Conformity relevant properties of tiBase 1.0
￭ Conformity is priority in development and validation.
￭ Centralized user administration (see Chapter 3.2.1.1, page 74).
￭ Detailed access rights (see Chapter 3.2.1.2.2, page 77).
￭ Password protection under tiBase or Windows (see Chapter 3.2.2.2,
page 83).
￭ Digital signature on two levels (see Chapter 2.3, page 11).
￭ One signature each for methods and results.
￭ Documentation of all determination modifications (see Chapter
4.5.2.13, page 246)
1.8 Versions
Introduction
tiBase is available in the following sales versions, which differ with regard
to scope and functions. An upgrade is possible at any time.
tiBase 1.0
full
tiBase 1.0
multi
Upgrade
Product 6.6063.102 6.6063.103 6.6063.108
User administration • •
Security settings • •
Client/Server support •
Number of licenses 1 3
Additional licenses as
•
an option
XML data export to
• •
LIMS
Upgrade possible • •
tiBase 1.0
￭￭￭￭￭￭￭￭
5
1.9 Online help
1.9 Online help
Introduction
Calling up the Help
tiBase has an extensive and detailed online help that can be requested in
two ways:
￭ General request With the menu item Help ▶ tiBase Help, or the sym-
bol
there you can jump via Contents, Index, Search or personal Favor-
ites to the desired topic.
￭ Context-sensitive request With the function key [F1] on the keyboard
you can jump directly to the topic which will show information on the
active element in tiBase (dialog window, tab).
Symbols and conventions
The following symbols and styles are used in this documentation:
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
the online help with the topic Welcome to tiBase is opened. From
Configuration
Link to another help topic in which information is
shown for the marked term.
Database Dialog text
Designation for names of parameters, menu items,
tabs and dialog windows in the software.
100
File ▶ New
Designation for parameter values in input fields.
Menu or menu item; Path needed to reach a certain
point in the program.
[Continue] Button
Formula editor
Formulae can be entered in fields with this symbol, and
the formula editor opens when you click on the symbol
(see Chapter 2.4, page 17).
Instruction step
Carry out these steps in the sequence shown.
Caution
￭￭￭￭￭￭￭￭
6
This symbol draws attention to a possible risk of damage to instruments or instrument parts.
Note
This symbol marks additional information and tips.
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
2 General program functions
2.1 Program parts
2.1.1 Program parts
General program functions
tiBase has two different program parts which can be opened by clicking on
the corresponding symbol in the vertical bar on the left. The symbol for the
opened program part is shown in color, the symbol for the other program
part in black and white. The menus, symbol bars and content of the main
window depend on the program part currently opened.
Database program part
￭ Opening/closing databases
￭ Managing databases
￭ Reprocessing
￭ Creating report templates
2 General program functions
Configuration program part
￭ Configuration of data import, login, backup etc.
￭ Security settings
￭ User administration
￭ Program administration
Access to a program part can be deactivated in the user administration.
In this case the corresponding symbol is disabled.
2.1.2 Database - Desktop
Program part: Database
Database symbol
Note
tiBase 1.0
Clicking on the database symbol in the vertical bar on the left opens the
program part Database while, at the same time the database symbol is
￭￭￭￭￭￭￭￭
7
2.2 Login/password protection
shown in color. The upper left corner of the symbol contains a black field
displaying the number of databases currently opened (see Chapter 4.2.2,
page 119).
Elements
The desktop of the program part Database comprises the following elements:
￭ Database-specific menu bar.
￭ Database-specific toolbar.
￭ Main window in which up to 6 subwindows can be displayed.
2.1.3 Configuration - Desktop
Program part: Configuration
Configuration symbol
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
By clicking on on the configuration symbol in the vertical bar at the left-hand
margin the program part Configuration is opened, at the same time the
configuration symbol is shown in color.
Elements
The desktop of the program part Configuration comprises the following
elements:
￭ Configuration-specific menu bar.
￭ Configuration specific toolbar.
￭ Main window in which 2 subwindows are displayed.
2.2 Login/password protection
2.2.1 General information on Login/Password protection
Program part: Configuration / Database
Login into tiBase
tiBase can be configured so that all users have to log in with their user
name and password and this data is automatically checked. This requires
a user administration to be set up and the corresponding security settings to be made. This data is saved in the configuration database. In the
case of client/server systems, this is on the server and applies globally for all
clients (central user administration).
￭￭￭￭￭￭￭￭
8
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
2 General program functions
Recommended settings
On the tab Login/Password protection in the dialog window Security
settings the button [Set] has to be pressed in order to set the settings. The
following conditions are therefore complied with:
￭ A login with user name and password is required each time the
program is started.
￭ Depending on the setting the password administration is carried out
in tiBase or Windows.
￭ User names must be unique. Users entered once cannot be deleted.
￭ Passwords must be unique per user. None of the expired passwords
already used once by the user may be reused.
￭ Passwords must comprise a minimum number of characters.
￭ Passwords must be changed according to a defined validity period.
￭ The number of incorrect login attempts to enter the password is
limited. If this number is exceeded, the user will automatically be set to
the status inactive.
Actions
If the login is activated, the following actions can be performed:
2.2.2 Login
User
Password
￭ Log in at program start
￭ Manual logout
￭ Automatic logout
￭ Change password
Program parts: Configuration / Database
If both the options Enforce login with user name and Enforce login
with password are activated in the Security settings, the dialog window
Login will appear every time the program is started and after each time the
user logs out.
Entering a short name for the user.
Input
24 characters
Password entry.
Input
24 characters
tiBase 1.0
￭￭￭￭￭￭￭￭
9
2.2 Login/password protection
Users who log in for the first time or users whose status has been reset
from inactive or removed back to active, must log in with the Start
password(see Chapter 3.2.1.3.1, page 80) specified by the adminis-
trator. Afterwards, the window Change password will automatically be
opened, in which a new password has to be entered.
[Change password]
Opens the window Change password, in which the new password has to
be entered and confirmed.
[Cancel]
The login is canceled, the program is terminated.
2.2.3 Log out manually
Menu item: Configuration / Database ▶ File ▶ Logout
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Note
A logged in user can logout at any time with the menu item File ▶ Log-
out. The logout options defined in the Security settings apply. After the
logout the Login appears, allowing a new user to log in.
2.2.4 Log out automatically
Program part: Configuration
If the automatic logout is activated in the Security Settings, the user will
then automatically be logged out after a definite waiting time if he does not
perform any operating functions via the keyboard or mouse. Afterwards the
Login window opens, in which however only the same user or the members
of the same user group can log in.
Note
Users with administrator rights can always log in.
2.2.5 Changing password
Dialog window: Log in ▶ [Change password] ▶ Change password
Note
￭￭￭￭￭￭￭￭
10
In tiBase, the password can only be changed if the option Password
monitoring by tiBase is set in the security settings.
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
[Change password]
Old password
2 General program functions
This button in the dialog window Login opens the window Change pass-
word, in which the new password has to be entered and confirmed.
Note
The password always has to be changed before the Validity of the password expires. For users who are logging in for the first time or users whose
status has been reset from inactive or removed back to active, this
window is automatically opened after logging in with the Start Pass-
word. For Old Password you also need to enter the Start Password
specified by the Administrator.
Entry of the previous password.
Input
24 characters
New password
Entry of the new password. The password options are defined in the Security settings on the tab Login/Password protection.
Input
24 characters
Confirm password
Confirmation of the new password.
Input
24 characters
2.3 Electronic signatures
2.3.1 Rules for electronic signatures
Program part: Database
In tiBase determinations can be electronically signed at two levels. The
following rules apply for this:
￭ Signature levels
Signature levels for determinations can be signed at two levels (Signature
Level 1 and Signature Level 2) by entering the user name and password.
￭ Multiple signing
Determinations can be signed several times at each level.
￭ Sign at Level 1
If Level 2 has been signed then no more signatures are possible at Level
1.
tiBase 1.0
￭￭￭￭￭￭￭￭
11
2.3 Electronic signatures
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
￭ Sign at Level 2
Level 2 can only be signed if signatures already exist at Level 1.
￭ Different users
The same user may only sign on either Level 1 or Level 2.
￭ Reason and comment
Each signature must be accompanied by a reason selected from predefined default reasons. A further comment can also be entered.
￭ Saved data
The signature date, user name, full name, reason and comments are
saved for each signature.
￭ Deleting signatures 1
Signatures at Level 1 are automatically deleted again when compiling a
new version.
￭ Deleting signatures 2
Signatures at Level 2 can only be deleted by users who have the appropriate rights.
￭ Signature options
The options for electronic signatures are set in the Signatures tab in the
Security settings dialog window.
2.3.2 Procedure for electronic signatures
Program part: Database
Determinations exhibit one of the following three states in relation to signatures (see flow diagram):
￭ Not signed
Determinations which are not signed can be deleted and changed, a new
version being created at each change.
￭ Signed (1)
When signing determinations at Level 1, no new versions are generated.
If determinations signed at Level 1 are changed, a new version is generated, which no longer contains any signatures. Determinations signed at
Level 1 can be deleted.
￭ Signed (2)
When signing determinations at Level 2, no new versions are generated.
Determinations signed at Level 2 can neither be changed nor deleted.
However, it is possible to delete the signatures (2), whereby the signatures (1) are retained.
￭￭￭￭￭￭￭￭
12
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Modify
Modify
Not sigend
Sign (1)
Signed 1
Sign (2)
Sigend 2
Delete signatures 2
DeleteCreate
Delete
Modify
Delete
2 General program functions
2.3.3 Signature Level 1
Dialog window:Database ▶ Determinations ▶ Sign ▶ Signature
1... ▶ Signature Level 1
Determinations can be signed at Level 1 in the Signature Level 1 window.
Determinations which have been signed at Level 1 can be changed and
deleted. If the altered method or determination is saved as a new version
then all existing signatures will be deleted automatically, i.e. the method
or determination must be signed again.
Info
Information display for signing and deleting signatures. The following messages are possible:
Selection
Note
Signature possible | Signature 1 not possible
(signature 2 exists) | Signature not possible
(accessed by other client) | Signature not possible for multiple determinations
tiBase 1.0
Signature possible
The selected determination can be signed.
￭￭￭￭￭￭￭￭
13
2.3 Electronic signatures
User
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Signature 1 not possible (signature 2 exists)
The selected determination can no longer be signed at Level 1 as it has
already been signed at Level 2.
Signature not possible (accessed by other client)
The selected determination cannot be signed as it is already marked to
be signed on a different client.
Signature not possible for multiple determinations
Several determinations have been selected, they may however only be
signed individually.
Entry of the user name (short name).
Password
Reason
Comment
[Sign]
Input
24 characters
Password entry.
Input
24 characters
Selection from the Default reasons defined in the Security Settings dia-
log window for the category Signature level 1.
Selection
Selection from the Default reasons
Entry of comment on the signature.
Input
1000 characters
Sign determination. The window remains open.
Note
2.3.4 Signature Level 2
Dialog window:Database ▶ Determinations ▶ Sign ▶ Signature
2... ▶ Signature Level 2
Determinations can be signed at Level 2 in the Signature Level 2 window.
￭￭￭￭￭￭￭￭
14
Determinations can only be signed at level 1 if the user belongs to a user
group with the corresponding authorization .
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Info
2 General program functions
Note
Determinations that can be signed at level 2 are blocked, i.e. they can
neither be modified nor deleted. In order to be able to edit such determinations again the signatures at level 2 must first be deleted .
Information for signing and deleting signatures is displayed in this box. The
following messages are possible:
User
Password
Selection
Signature possible | Signature 2 not possible
(signature 1 missing) | Signature not possible
(accessed by other client)
Signature possible
The selected determination can be signed.
Signature 2 not possible (signature 1 missing)
The selected determination cannot be signed at Level 2 as it has not yet
been signed at Level 1.
Signature not possible (accessed by other client)
The selected determination cannot be signed as it is already marked to
be signed on a different client.
Entry of the user name (short name).
Input
24 characters
Password entry.
Input
24 characters
Reason
Comment
[Sign]
tiBase 1.0
Selection from the Default reasons defined in the Security Settings dia-
log window for the category Signature level 2.
Selection
Selection from the Default reasons
Entry of comment on the signature.
Input
1000 characters
Sign determination. The window remains open.
￭￭￭￭￭￭￭￭
15
2.3 Electronic signatures
Note
Determinations can only be signed at level 2 if the user belongs to a user
group with the corresponding authorization .
2.3.5 Delete Signature Level 2
Dialog window:Database ▶ Determinations ▶ Sign ▶ Delete signatures 2... ▶ Delete Signatures Level 2
The Delete Level 2 signatures window allows you to delete all signatures
on Level 2 for the selected methods or determination.
User
Entry of the user name (short name).
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Password
Reason
Comment
[Delete]
Input
24 characters
Password entry.
Input
24 characters
Selection from the Default reasons defined in the Security Settings dia-
log window for the category Signature level 2.
Selection
Selection from the Default reasons
Entry of comment on the signature.
Input
1000 characters
Delete Signatures 2.
Note
￭￭￭￭￭￭￭￭
16
Signatures 2 can only be deleted if the user belongs to a user group with
the corresponding authorization.
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
2.4 Formula editor
Dialog window: Formula editor
The Formula editor serves as a support when entering formulas for calculating results. It has an automatic Syntax check, which is activated when
applying the formula. The general rules of priority apply for the calculation
operations.
The Formula Editor dialog window contains the following elements:
￭ Input field
Entry of the calculation formula (see Chapter 2.4.1, page 17).
￭ Function buttons
Buttons for the rapid entry of operators and parentheses (see Chapter
2.4.1, page 17).
￭ Operators/functions
Selection of the operators and functions variables available for the calculation formula (see Chapter 2.4.4.1, page 32).
￭ Description
Description of the selected variables, operators or functions.
2 General program functions
2.4.1 Input field
Dialog window: Formula editor
The calculation formula is entered in the input field of the Formula Editor.
The following options are available for the entry:
Entry via keyboard
￭ Numbers
Numbers as well as mathematical functions can be entered directly via
the keyboard.
￭ Text
Text must be enclosed in quotation marks " (e.g. "my text").
￭ Variables
Variables must be entered and ended with an apostrophe ' (e.g. 'MV.my
variable').
￭ time
Time indications must always be made with the aid of the Time( ) function.
Entry using the function buttons
Mathematical operators and parentheses can simply be added to the formula using the corresponding buttons. A space is automatically added
before and after the sign.
tiBase 1.0
Addition Equal to Logic AND
￭￭￭￭￭￭￭￭
17
2.4 Formula editor
Subtraction Greater than Logic OR
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Multiplication Less than
Round parentheses
Division Not equal to
Potentiation Less than or equal to
Greater than or equal to
Molar mass calculator
Undo last action
Redo last action
Entry via selection
The element selected in the fields Variables or Operators can be added
to the formula by double clicking or [Insert].
2.4.2 Calculation algorithms
Dialog window: Formula editor
Numerical format
The standard IEEE 754 (1985) for binary floating point arithmetic is implemented in "double precision" (64 Bit) in the software.
Rounding off process
Measured values and results are rounded off symmetrically (commercial
rounding). In so doing, 1, 2, 3, 4 are always rounded down and 5, 6, 7,
8, 9 always rounded up.
Examples
2.33 yields 2.3
2.35 yields 2.4
2.47 yields 2.5
-2.38 yields -2.4
-2.45 yields -2.5
Statistics
The mean value, absolute and relative standard deviation of results R are
calculated using the following formula:
Mean value
￭￭￭￭￭￭￭￭
18
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
2 General program functions
Absolute standard
deviation
Relative standard deviation (in %)
The statistical calculations of the software have been implemented so that
they can be checked to as great a degree as possible by the user. The individual values are therefore incorporated in the statistics with full accuracy.
It is not the number of decimal places which is decisive for the accuracy of
the calculations, but rather the number of significant digits of the decimal
numbers displayed. The binary 64 bit numerical format implemented on the
basis of the IEEE 754 standard means that the decimal numerals resulting
from this have 15 certain significant decimal places.
You can influence the number of significant digits by selecting the unit and
the number of decimal places. As the result unit to be set sometimes contains
the prefix "Milli" as well as the actual physical unit, the number of significant
places changes accordingly by three places during such a conversion.
Example
The result displayed 1234.56789158763 mg/L has 15 certain places. It
should be rounded off to three decimal places according to the above
rounding procedure:
1234.568 mg/L (7 significant places, 3 of them decimal places)
The unit "g/L" means that the same result 1.23456789158763 g/L is also
rounded off to three decimal places:
1.235 g/L (4 significant places, 3 of them decimal places)
The number of significant digits has now been reduced by three to four digits
by omitting the prefix "milli".
Note
The above losses of accuracy by rounding off in the area of the maximum
certain places are only relevant theoretically. Most of the time they are
lower by several orders of magnitude than – as an example – the uncertainties resulting from weighing out the sample.
tiBase 1.0
￭￭￭￭￭￭￭￭
19
2.4 Formula editor
2.4.3 Variables
2.4.3.1 Variables - Overview
Dialog window: Formula editor
Variables are automatically generated by the program during or at the end
of the determination. You can use the formula editor to access these and
either use the values for further calculations or output them as a result.
Variable types
The following types of variables are differentiated:
Name Syntax Description
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
Method variables
Sample data
variables
Command
variables
Result variables
Determination variables
'MV.Variable
name'
'MV.Variable
name'
'Command
name.Variable
name'
'RS.Result
name.Variable
identification'
'DV.Variable
identification'
Method variables include the variables FCT and DIV
Sample data variables include the variables Sample size, Unit, Sample
position, ID1 and ID2.
Command variables are variables
which are generated by the individual
commands in the method run. The
command variables are displayed in
the order determined by the commands executed in the method run.
Result variables are special command
variables which are generated by
CALC commands and which are
available under a designation of their
own.
Determination variables are general
variables and cannot be assigned to
individual commands.
￭￭￭￭￭￭￭￭
20
System variables
'SV.Variable
identification'
System variables are general variables
which are adopted in the determination at the start of the determination.
Common
variables
'CV.Name'
Common variables are global variables. Depending on the device, the
names are set or can be defined by
the user.
Enter variables
Variables must always be entered and ended with an apostrophe ' (e.g.
'MV.myVariable').
tiBase 1.0
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
When using variables, always observe their data type (Number, Text or
Date/Time).
2.4.3.2 Method variables
Tab: Database ▶ Determinations ▶ Reprocessing ▶ Variables
Method variables include the variables FCT (factor) and DIV (divisor).
Syntax
'MV.Variable name'
Examples: 'MV.FCT' and 'MV.DIV'
Occurence
These two variables occur in the formula saved in the 870 KF Titrino plus.
By modifying these variables the result can be indicated as different concentration units (mg/mL, ppm etc.).
2 General program functions
Note
Method variables
Variable
Description Data type
name
FCT Conversion factor for the calculation for-
Number
mula
DIV Divisor for the calculation formula Number
Conversion table of the formula for KF titration
Result unit Sample size
Factor Divisor
in...
% g 0.1 1
% mg 100 1
% mL 0.1 Density of the
sample in g/
mL
ppm g 1000 1
ppm mL 1000 Density of the
sample in g/
mL
tiBase 1.0
￭￭￭￭￭￭￭￭
21
2.4 Formula editor
￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭￭
ppm
mg/mL g Density of the
mg/mL mL 1 1
mg 1 1 1
mL 1 1 Density of H
mg/piece Pieces 1 1
2.4.3.3 Sample data variables
Dialog window: Formula editor ▶ Sample data variables
Sample data variables include the variables Sample size, Unit, Sample
position, ID1 and ID2.
In the field Variables of the formula editor all sample data variables are
listed.
µ L
1 Density of the
sample in g/
mL
1
sample in g/
mL
O in g/mL
2
Syntax
'MV.Variable name'
Examples: 'MV.Sample Size' , 'MV.Sample Unit' , 'MV.ID1'
You can select the sample data variables directly in the formula editor under
Variables ▶ Sample data variables in order to avoid syntax errors.
Sample data variables
Variable
name
Variable name
( tiBase 1.0 )
Description Data type
(PC-Con-
trol)
CI1 ID1 Sample identification 1 Number
CI2 ID2 Sample identification 2 Number
C00 Sample Size Sample size Number
Sample Unit Sample unit Text
￭￭￭￭￭￭￭￭
22
tiBase 1.0
Loading...