Teachware
Metrohm AG
CH-9100 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.
Documentation in additional languages can be found on
http://documents.metrohm.com.
■■■■■■■■■■■■■■■■■■■■■■
Table of contents
1Introduction 1
1.1Welcome to viva ................................................................... 1
viva is a control and database software for VA measuring instruments.
Overview of the main program features
■Easy-to-operate and easily configurable user interface
■Simple integration of devices and accessories
■Convenient method editor
■Database-based program with client/server functionality
■Wide range of import and export functions
■Conformity
■Comprehensive online help
■Program versions
■■■■■■■■
1
1.2 Operation
Overview of the most important information concerning process analysis instruments
■Process analysis instruments
■Process analysis - Commands
■Process analysis - Manual control
1.2 Operation
Introduction
The modern user interface makes it easy for you to find your way
around viva. All commands and control elements are located where you
would expect. The bar on the left edge of the screen gives you access to
the five basic elements of viva:
■■■■■■■■■■■■■■■■■■■■■■
– IO controller
– Stepping Motor Controller
Workplace
DatabaseMethodConfigura-
Manual
tion
Depending on the access permissions, 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 hidden, depending on the access permissions.
In the center of the screen, you can find the information windows with
the settings, sample entry masks, live curves or results. This view can be
set individually for each user with the aid of the layout manager. As a
result, users see only those windows or buttons they actually need for
their work. This reduces the introductory period for routine users to a minimum. Incorrect operation as a result of overcrowded screens is also a
thing of the past.
A wide range of tried-and-tested methods allow any user to create new
methods quickly and simply and to use them immediately.
■■■■■■■■
2
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
1.3 Device integration
Introduction
The following instruments can be operated with viva:
■894 Professional CVS
■846 Dosing Interface
■858 Professional Sample Processor
■919 IC Autosampler plus
■814/815 USB Sample Processor
■IO controller
■Stepping Motor controller
1.4 Method editor
Introduction
viva contains a graphical method editor, with which you can define
simple and complex analysis procedures. With the aid of the numerous
templates, methods can be created quickly and easily. For most routine
and automated tasks, there are tried-and-tested methods available. Just a
few clicks and they are adapted and ready to use.
1 Introduction
Overview of functions
■Method editor (see Chapter 5.2, page 378)
■Method manager (see Chapter 5.3, page 391)
■Separate management of access permissions for each method group
(see Chapter 5.4.2, page 397)
■Templates for method development and calculations (see Chapter
5.2.1, page 378)
■Plausibility check for methods (see Chapter 5.2.5, page 387)
viva 1.1
■■■■■■■■
3
1.5 Database
1.5 Database
Introduction
viva is based on an object-oriented database that has proven itself in
practice. All program settings, user administration, methods and templates
are stored in the configuration database, and the determination data is
stored in the determination databases defined by the user. These databases can be installed locally on the computer reserved for measurements
and represent a simple measurement system. viva is, however, scalable
and grows with increasing operational requirements. As soon as data
security and central data management make it necessary, viva is installed
as a client/server configuration. The viva 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 reprocessed
by all client PCs. In addition, all clients use the same method pool.
The new database has all the major tools necessary for managing, searching for and grouping results. Quick filters allow the user to browse
through thousands of determinations within seconds and to display the
result clearly. Chart plots provide a quick overview of the chronological
sequence of the results.
■■■■■■■■■■■■■■■■■■■■■■
All options for reprocessing are available to the user.
Overview of functions
■Object-oriented client/server database (see Chapter 6.2.3.1, page 747)
■Layout manager for database view (see Chapter 3.1.7, page 86)
■Quick filters (see Chapter 4.5.2.4, page 278)
■Efficient search functions (see Chapter 4.5.2.3, page 275)
■Access permissions control for every database (see Chapter 4.3.5.3,
page 212)
■Automatic database backup (see Chapter 4.3.5.4, page 213)
■Quick result overview or specially designed control charts (see Chapter
4.5.2.16, page 328)
■Reprocessing of determinations (see Chapter 4.5.2.5, page 283)
■■■■■■■■
4
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
1.6 Communication
Introduction
viva is communicative. Data generated in viva can be exported in XML
and CSV format. This therefore enables a simple connection to all customary LIMS. In addition, exporting to long-term archiving systems 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 templates. It is therefore possible to display one or more determinations in a layout of your choice as a PDF file or as a printout at any time.
A special feature is that viva can send messages, error messages or results
from the method run to the user by e-mail.
Overview of functions
■Various export formats, e.g. XML, CSV, TXT (see Chapter 4.4.3, page
261)
■Report templates (see Chapter 4.4.1.4.1, page 220)
■E-mail functions for status messages, error messages or results (see
Chapter 2.5, page 79)
1 Introduction
1.7 Conformity
Introduction
viva sets new standards with respect to the fulfilling of GMP and GLP
requirements. The latest quality standards and validation procedures
were implemented already at the development and programming stage of
the software. Access permissions for program functions and determinations are defined in a centralized user administration, in which you can
create as many users as you like with freely definable access profiles. The
system administrator can conveniently access the user administration from
any viva client. Access to the software is password-protected and the
viva or Windows login can be selected.
Data management is version-controlled, and all data is protected
against unauthorized access, modification or deletion in the database. The
database itself controls access to the data in network operation and provides archiving and restore functions.
Conformity-relevant properties of viva
■Completely developed and validated with conformity in mind
■Centralized user administration (see Chapter 6.2.1, page 734)
■Detailed access permissions (see Chapter 6.2.1.2, page 735)
viva 1.1
■■■■■■■■
5
1.8 Versions
1.8 Versions
■■■■■■■■■■■■■■■■■■■■■■
■Password protection under viva or Windows (see Chapter 6.2.2, page
741)
■Documentation of all method and result modifications (see Chapter
4.5.2.13, page 327)
Introduction
viva is available in two sales versions which differ with regard to the
scope of functions. An upgrade is possible at any time.
Product6.6065.1126.6065.113
Maximum number of instruments
per PC
User administration••
Security settings••
Client/server support•
Number of licenses13
Additional licenses as an option•
XML data export to LIMS••
Upgrade possible•
1.9 Online help
Introduction
Calling up the help
viva has a very extensive and detailed online help that can be accessed in
two ways:
viva 1.1 fullviva 1.1 multi
44
■■■■■■■■
6
■General access The Help ▶ viva Help menu item or the
icon is
used to open the online help with the topic Welcome to viva. From
there you can jump to the desired topic via Contents, Index, Search
or personal Favorites.
■Context-sensitive access You can jump directly to the topic which
contains information on the active element in viva (dialog window,
tab) with the [F1] function key on the keyboard.
Symbols and conventions
The following icons and formatting are used in this documentation:
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
1 Introduction
6.4.2Device
table
Link to another help topic that contains information
about the marked term.
MethodDialog text
Designation for names of parameters, menu items,
tabs and dialog windows in the software.
100Designation for parameter values in input fields.
File ▶ New...Menu or menu item; path needed to reach a certain
point in the program.
[Next]Button
Formula editor
Formulas can be entered in fields with this icon. The
formula editor opens when you click on the (seeChapter 2.3, page 21) icon.
Instruction step
Carry out these steps in the sequence shown.
CAUTION
This symbol draws attention to possible damage to
instruments or instrument parts.
Note
This symbol highlights additional information and
tips.
Formula field
Formulas can be entered directly or via the formula
editor. To open the formula editor, right-click in the
formula field with the blue margin.
viva 1.1
■■■■■■■■
7
1.10 What is new in viva?
1.10 What is new in viva?
Introduction
1.10.1 New features
General
■Sample type Intercept
New sample type for brightener determination with the LAT calibration method.
■Renaming of the HCR and LCR command variables
The command variables HCR and LCR of the voltammetry commands
have been renamed HR and LR.
■Creating new methods
Because of the functional expansions in viva 1.1, we recommend that
new methods should always be created based on the method templates from viva 1.1.
New calibration methods
■LAT
LAT (Linear Approximation Technique) is a calibration method for the
determination of the brightener concentration in electroplating baths.
LAT is a two-stage process. First, the intercept value is measured, and
then, after a solution exchange, the sample.
■RC
The response curve is a standardized calibration curve for electroplating
bath additives with a suppressing effect. It involves a two-stage process, in which a calibration curve is first recorded with a standard solution before the sample solution is measured.
■■■■■■■■■■■■■■■■■■■■■■
■■■■■■■■
8
New commands
■Voltammetry command CPVS
The CPVS (Cyclic Pulse Voltammetric Stripping) command is a
voltammetry command for the electroplating bath analysis with CPVS.
It is mainly used for the determination of various organic additives in
electroplating baths. The CPVS command can only be inserted in VA
tracks.
■Voltammetry command CP
The CP (chronopotentiometry) command is a voltammetry command for the electroplating bath analysis with CP. It is used for galvanostatic film deposition as well as for measuring the open-circuit
potential in electroplating baths. The CP command can only be
inserted in VA tracks.
■Measuring command MEAS T
Command for temperature measurements.
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
1 Introduction
■Call command CALL ELECTROLYTE
Command for calling a VA track. The data acquired in the called VA
track is used in the RC (Response Curve) calibration method for the
determination of additives with a suppressing effect (e.g. leveler).
■Dosing command SET TOTAL VOLUME
The SET TOTAL VOLUME command is a dosing command for the
manual entry of the current total volume in the measuring vessel, e.g.
after automatic rinsing or a manual exchange of solution.
Workplace program part
■Peak result display
The peak evaluation results (peak potential and area or height) are
shown in the live display directly after the evaluation.
Database program part
■Show "Reprocessing with history"
Status display in the Reprocessing dialog window indicating whether
Reprocessing with history is activated or deactivated.
■"Send with history"
Users can select whether they want to send all versions or only the first
and the last version of a determination.
■"Export with history"
Users can select whether they want to export all versions or only the
first and the last version of a determination. The export of several
determinations at the same time is now much faster.
■Report templates expanded
All report templates with measurement curve display have been expanded such that the measurement curves of all commands are displayed.
When updating from viva 1.0 to viva 1.1, an additional, revised report
template is installed for each report template installed in viva 1.0. All
old report templates with the date Saved = 2013 and Saved by =
Metrohm can be deleted.
viva 1.1
Method program part
■Fixed point evaluation
Fixed point evaluations allow users to obtain the measured value for
the current or the potential at a previously defined potential or time.
Configuration program part
■Setting the option Reprocessing with history
With the new option Reprocessing with history, users can select
whether all recalculated versions of a determination (option: on) or
only the last and the original determination (option: off) are to be
saved in the database. The default setting is off.
■■■■■■■■
9
1.10 What is new in viva?
■Templates for output lines
Various signal patterns for the output lines are predefined under
Tools ▶ Templates. Like custom-designed input lines, they can be
exported and imported.
■Calibration data subwindow
The Calibration data subwindow lists all calibration data sets. The
calibration data list can be output as a PDF file. Data sets that are no
longer required can be deleted.
Manual program part
■Temperature measurement
The temperature of a solution can be measured manually.
1.10.2 Improvements
General
■E-mails to several recipients
E-mails can be sent to several recipients.
■Special characters in user-defined results
Additional special characters (+, *, (, )) can be used in the names of
user-defined results.
■■■■■■■■■■■■■■■■■■■■■■
Workplace program part
■Curves subwindow / Measurement curve
In the curve window, a separate tab with the respective command
name (e.g. CVS 1) is displayed for each measuring command. The way
the tabs are arranged depends on how the commands are ordered in
the run.
■Curves subwindow / Calibration curve
The calibration curve window has been redesigned with a clearer
arrangement. The window partition now automatically adjusts to the
contents displayed when the window is enlarged or reduced.
■MEAS TMF
The determination of the transmission factor (MEAS TMF command)
has been optimized.
Database program part
■New example determinations (for import)
The example determinations have been re-recorded in viva 1.1 and
replace the existing viva 1.0 example determinations. In addition,
example determinations are available that include new commands and
calibration methods (see Chapter 9.1.2.6, page 1007).
■Faster recalculation
The recalculation is much faster when determinations are reprocessed.
■Faster display of measurement curves
Measurement curves for large determinations are displayed much
faster in the Curves subwindow.
■■■■■■■■
10
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
1 Introduction
■Curves subwindow / Calibration curve
The calibration curve window has been redesigned with a clearer
arrangement. The window partition now automatically adjusts to the
contents displayed when the window is enlarged or reduced.
■Database monitoring
The default value for the Maximum size during database monitoring
has been raised to 5,000 MB.
Method program part
■New method templates
Existing method templates have been adjusted for use in viva 1.1.
Additional method templates for the use of new commands and calibration methods are offered.
■New example methods (for import)
Existing example method templates have been adjusted for use in viva
1.1. Additional example methods for the use of new commands and
calibration methods are offered (see Chapter 9.1.5.7, page 1025).
■CALL COND
If Evaluation quantity is activated as stop criterion, then the CALL
COND command will now be executed in a method run also if no calibration is defined as calibration method.
■Expanded curve smoothing
The scale for curve smoothing applied during data processing has been
extended to 40. A value between 1 and 40 can now be set for
smoothing the measurement curves recorded with VA measuring commands.
■New evaluation parameter variables
The evaluation ratio for the calibration method DT is available as evaluation parameter variable ED from the Calibration section of the Eval-uation subwindow.
The concentration value and the concentration unit of the standards is
available as evaluation parameter variable ED from the Standards section of the Evaluation subwindow.
■New command variables for LOOP
The LOOP command has been completed by the command variables
run time (DBL), stop type (STY) and signal ratio (SRAT). If a loop is
canceled, then the stop criterion that was met is documented with a
command variable.
1.10.3 Fixed bugs and problems
Workplace program part
■Dosing is disabled after stop / emergency stop
If users cancel a determination by clicking on the [Stop] or [Emergency stop viva] button, then the dosing devices immediately stop
their ongoing actions.
viva 1.1
■■■■■■■■
11
1.10 What is new in viva?
■■■■■■■■■■■■■■■■■■■■■■
■Evaluation start
If calibration points for the calculation of a calibration curve's regression are selected automatically, then all points above the evaluation
start are excluded, regardless of the chronological sequence of data
acquisition. Below the evaluation start, all points located in the falling
segment of a calibration curve's regression are included in the calculation of the regression.
This change in the evaluation start also affects the reprocessing of
determinations in the Database program part.
■Time display
While a CVS command is run, the measured value display in the live
display shows the time for the parameter Time when a potential with
waiting time is applied.
■Report output improved
The simultaneous output of several reports as PDF and per e-mail has
been improved.
■Error message if the stirrer is not connected
If the stirrer specified in the method is not found when a STIR command is executed, then the user will be notified of this with an error
message.
■Error message in case of an invalid stirring rate
If an invalid value or a formula yielding an invalid value is entered for
Stirring rate, then the user will be notified of this with an error message when the command is executed.
■Canceling the live display
When a determination is run with a method consisting of several parallel tracks, a single one of these tracks can now be canceled in the context menu.
■Live modification of substance names
In the Evaluation subwindow in the workplace, substances can no
longer be renamed live.
■Jammed stirrer
If the stirrer jams during the electrode test or a determination, then the
ongoing method will be canceled.
■Method saving
The function Method/Save As... is disabled as long as no method has
been selected on a newly created workplace.
■Report definition
If all options are selected in the Report output section of a REPORT
command (Printer, PDF file and Send e-mail), then the printout, the
PDF file and the e-mail are correctly created.
■■■■■■■■
12
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
1 Introduction
Database program part
■Volume entry with formula
If the volume is entered by way of a formula in the commands ADD
AUX, ADD STD and ADD SAMPLE DT, then the volume will not be
recalculated during reprocessing but the actually dosed volume will be
used for the calculation of the volume record. For this reason, the volume can no longer be edited during reprocessing in the dialog window
of the respective ADD command.
■Several CALL COND type commands during reprocessing
If several commands of the type CALL COND are run through in the
same determination, then they will be properly calculated during reprocessing.
■Command variables during reprocessing
If user-defined results are entered that access command variables, then
these are calculated during reprocessing.
■The dialog window opens only once
In the case of actions requiring a user entry or a selection in quick succession, the respective dialog window opens only once.
Method program part
■CVS command with equilibration time = 0 s
If the equilibration time is set to 0 on the Pretreatment tab in a CVS
command, then the correct current measuring range is now also found
in the subsequent sweep.
■Maximum number of characters increased
The maximum number of characters has been increased for the Device
name field in the dialog window of the CTRL command.
■Creating a new method during reprocessing
New methods can now also be created while the Reprocessing window is open.
■Checking of the 'Sample type' sample data variable in the
method check
If the LAT, MLAT, DT or RC calibration method is applied, then the
software will check already in the method check whether the Sampletype sample data variable is present in the START command.
■Drag and drop improved
The drag-and-drop functionality has been improved in the Method run
window.
■RLS DOS
The RLS DOS command allows users to select and use all four dosing
device connectors of an 894 Professional CVS for releasing dosing devices.
■Report output
Reports are output with the correct contents as PDF file and/or printout.
viva 1.1
■■■■■■■■
13
1.10 What is new in viva?
■■■■■■■■■■■■■■■■■■■■■■
Configuration program part
■Sorting the"Colorimetric sensors" table
The rows within the table of colorimetric sensors can now be correctly
sorted in ascending or descending order in the Colorimetric sensors
subwindow.
Manual program part
■Dosing with a dosing unit not yet included in the configura-
tion
If, in manual control, a user tries to use a dosing unit that is not yet
included in the table of dosing units in the configuration, then a notification appears that the dosing unit has to be included in the table
before it can be used.
Herisau, May 16, 2014
P. Hunziker
Vice President,
Head of Development
U. Kürsteiner
Head of Quality Management
■■■■■■■■
14
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
2.1 Program parts
2.1.1 Program parts
General program functions
viva has five 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 symbols for the other program parts in black and white. The menus, toolbars and content of the
main window depend on the program part currently opened.
Workplace program part
■Opening/closing workplaces
■Starting single determinations and determination series
■Sample tables
Access to the individual program parts can be deactivated in the user
administration. In this case, the corresponding symbols are hidden.
2.1.2 Workplace - User interface
Program part: Workplace
Workplace symbol
■■■■■■■■■■■■■■■■■■■■■■
Clicking on the workplace symbol in the vertical bar on the left opens the
Workplace program part while at the same time the workplace symbol is
shown in color. The upper left corner of the symbol contains a black field
displaying the number of workplaces currently opened (see Chapter 3.2.3,page 90).
Elements
The user interface of the Workplace program part comprises the following elements:
■Workplace-specific menu bar.
■Workplace-specific toolbar.
■Main window, in which up to 6 subwindows can be displayed.
2.1.3 Database - User interface
Program part: Database
Database icon
■■■■■■■■
16
Clicking on the database symbol in the vertical bar on the left opens the
Database program part; the database symbol is shown in color at the
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
same time. The upper left corner of the symbol contains a black field displaying the number of databases currently opened (see Chapter 4.2, page
206).
Elements
The user interface of the Database program part comprises the following
elements:
■Database-specific menu bar.
■Database-specific toolbar.
■Main window, in which up to six subwindows can be displayed.
2.1.4 Method - User interface
Program part: Method
Method icon
2 General program functions
Clicking on the method symbol in the vertical bar on the left opens the
Method program part; the database symbol is shown in color at the
same time. The upper left corner of the symbol contains a black field displaying the number of methods currently opened (see Chapter 5.2.3,page 380).
Elements
The user interface of the Method program part comprises the following
elements:
■Method-specific menu bar.
■Method-specific toolbar.
■Main window in which several methods can be opened and a maxi-
mum of two can be displayed at the same time.
2.1.5 Configuration - User interface
Program part: Configuration
Configuration icon
viva 1.1
Clicking on the configuration symbol in the vertical bar at the left opens
the Configuration program part; the database symbol is shown in color
at the same time.
■■■■■■■■
17
2.2 Login / password protection
Elements
The user interface of the Configuration program part comprises the following elements:
■Configuration-specific menu bar.
■Configuration-specific toolbar.
■Main window, in which up to six subwindows can be displayed.
2.1.6 Manual control - User interface
Program part: Manual control
Manual control - Symbol
Clicking on the Manual symbol in the vertical bar on the left opens the
Manual control program part in a separate window; the Manual sym-
bol is displayed in color at the same time.
■■■■■■■■■■■■■■■■■■■■■■
Elements
The user interface of the Manual control program part comprises the
following elements:
2.2.1 General information on login / password protection
Program parts: Workplace / Database / Method / Configuration
Login into viva
viva can be configured so that all users have to log in with their user
name and password and this data is automatically checked. Thisrequires 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).
Recommended settings
In order to set the settings, the Password monitoring by viva check
box must be activated in the Security settings dialog window on the
Login/Password protection tab. The following conditions will then be
complied with:
■■■■■■■■
18
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.2.2 Logging in
2 General program functions
■A login with user name and password is required each time the
program is started.
■User names must be unique. Users entered once cannot be deleted.
■Passwords must be unique for each user. None of the expired pass-
words already used once by the user may be reused.
■Passwords must be changed after a defined validity period.
■The number of login attempts 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:
■Logging in at program start
■Logging out manually
■Logging out automatically
■Changing password
Program parts: Workplace / Database / Method / Configuration
If both of the options Enforce login with user name and Enforcelogin with password are activated in the Security settings, the Login
dialog window will appear each time the program is started and after
each time a user logs out.
User
Password
[Change password]
Entry of a short name for the user.
Entry24 characters
Entry of the password.
Entry24 characters
NOTE
Users who log in for the first time or users whose status has been reset
from disabled or removed back to enabled must log in with the
Start password(see Chapter 6.2.1.3, page 739) specified by the
administrator. Afterwards, the Change password window, in which a
new password needs to be entered, will open automatically.
Opens the Change password window, in which the new password
needs to be entered and confirmed.
viva 1.1
■■■■■■■■
19
2.2 Login / password protection
[Cancel]
The login is canceled and the program is terminated.
A logged-in user can log out at any time with the File ▶ Logout... menu
item. The logout options defined in the Security settings apply. After
the logout, the Login window appears, in which a new user can log in.
2.2.4 Logging out automatically
Program part: Configuration
If the automatic logout is activated in the Security settings, then the
user will be logged out automatically after a defined waiting time if no
operating functions have been performed in the meantime via 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 again.
NOTE
■■■■■■■■■■■■■■■■■■■■■■
Users with administrator rights can always log in; an emergency stop is
also possible.
In viva, the password can only be changed if the option Password
monitoring by viva is set in the Security settings.
[Change password]
This button in the Login dialog window opens the Change password
window, in which the new password needs to be entered and confirmed.
■■■■■■■■
20
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
Old password
New password
2 General program functions
NOTE
The password always needs to be changed before the Passwords
expire every period of the password expires. For users who are log-
ging in for the first time or whose status has been reset from disabled
or removed back to enabled, this window is automatically opened
after logging in with the Start password. Here you also need to enter
the Start password assigned by the administrator for Old password.
Entry of the previous password.
Entry24 characters
Entry of the new password. The password options are defined in the
Security settings on the Login/Password protection tab.
Entry24 characters
Confirm password
Confirmation of the new password.
Entry24 characters
2.3 Formula editor
The formula editor serves as a support when entering formulas for result
calculation. It has an automatic syntax check, which is activated when
the formula is applied. 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.3.1, page 22).
■Buttons
Buttons for the quick entry of operators, parentheses and brackets (see
Chapter 2.3.1, page 22).
■Variables
Selection of the variables available for the calculation formula (see
Chapter 2.3.3, page 24).
■Operators/functions
Selection of the operators and functions available for the calculation
formula (see Chapter 2.3.4, page 43).
viva 1.1
■■■■■■■■
21
2.3 Formula editor
2.3.1 Input field
■■■■■■■■■■■■■■■■■■■■■■
■Description
Description of the selected variables, operators or functions.
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 buttons
Mathematical operators and parentheses or brackets can simply be
inserted in the formula using the corresponding buttons. A space is automatically inserted before and after the character.
Addition
Equal toLogical AND
SubtractionGreater thanLogical OR
MultiplicationLess than
Round parentheses
DivisionNot equal to
Curly brackets: request values
of variables with index; the
index is in curly brackets
PotentiationLess than or equal
Molar mass calculator
to
Greater than or
Undo last action
equal to
Redo last action
■■■■■■■■
22
Entry via selection
The element selected in the Variables or Operators/Functions fields
can be added to the formula with a double-click or with [Add].
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.3.2 Calculation algorithms
Dialog window: Formula editor
Numerical format
The IEEE 754 (1985) standard 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). I.e., 1, 2, 3, 4 are always rounded down whereas 5, 6, 7, 8,
9 are 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 General program functions
-2.45 yields -2.5
Statistics
The mean value as well as the absolute and relative standard deviation of
results R are calculated using the following formulas:
Mean value
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.
viva 1.1
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
■■■■■■■■
23
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
the basis of the IEEE 754 standard means that the decimal numerals
resulting from this have 15 reliable 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 displayed result of 1,234.56789158763 mg/L has 15 reliable digits.
It should be rounded off to three decimal places according to the above
rounding-off process:
1,234.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".
2.3.3 Variables
2.3.3.1
Name
Variables - Overview
SyntaxDescription
NOTE
The above losses with respect to accuracy caused by rounding off in the
range of the maximum reliable places are only theoretically relevant.
Most of the time they are lower by several orders of magnitude than,
for example, the uncertainties resulting from sample size.
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 in reports as a
result.
Variable types
The following types of variables are differentiated:
Sample data variables
■■■■■■■■
24
SD.'Variable name'.'Variable identification'
Sample data variables contain all of the sample data of the
determination.
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
NameSyntaxDescription
2 General program functions
Command variables
Automatically
calculated result
variables
Evaluation parameter variables
User-defined
result variables
Determination
variables
System variablesSV.'Variable identification'System variables are general variables which are adopted in
DV.'Variable identification'Determination variables are general variables and cannot be
CV.'Variable name'.'Variable identification'
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.
Automatically calculated result variables are automatically generated by the program during the evaluation.
Evaluation parameter variables are generated automatically
during the evaluation.
User-defined result variables are generated from the results
defined by the user.
assigned to individual commands.
the determination at the start of the determination.
Common variables are client-specific variables, which are
adopted from the table of the Configuration program part at
the start of the determination and assigned to the determination.
Global variablesGV.'Variable name'.'Varia-
ble identification'
Entering variables
Variables must always be entered with an apostrophe ' at the beginning
and at the end (e.g., 'DV.DUR').
NOTE
When using variables, always observe their data type (Number, Text
or Date/Time).
Variations and replications
Because of the fact that in voltammetry all data is saved in a single data
set when working without solution exchanges, all of the result variables
belonging to one voltammogram are clearly distinguished by an index X
for the variations and another index Y for the replications.
Global variables apply to all clients and are adopted from the
table of the Configuration program part at the start of the
determination and assigned to the determination.
viva 1.1
■■■■■■■■
25
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Variation refers to a measurement after modification of the measuring
solution, e.g., after a standard solution has been added.
Replication refers to an identical repetition of a measurement.
The following rules apply for this:
■Variation index only after the measuring command has been
called up with CALL VA
A variation index is attributed only to those peak evaluation results for
which the measuring command has been called up by a CALL VA call
command.
■Increasing the variation index with ADD STD
The peak evaluation results of a measuring command are assigned a
variation index, which is increased with the corresponding ADD STD
or ADD SAMPLE DT command.
■Increasing the replication index with loops or several measur-
ing cycles
The peak evaluation results of a measuring command are assigned a
replication index, which is increased with repetitions because of loops
(LOOP command) around a measuring command or because of several measuring cycles within a CVS, CPVS or CP command.
■Both indices begin with 1
Variation index and replication index both start with 1.
■Increasing the variation index sets the replication index to 1
Increasing the variation index automatically causes the replication index
to be reset to 1.
■Increasing the variation index only if the previously added
solution contains at least one substance to be determined
When an ADD STD command is run through, the substances contained in the solution are identified on the basis of the name of the
standard solution in the standards table. The respective measuring
command is subsequently determined in the table of substances and
the variation index is increased by 1 when this measuring command is
run through.
■Increasing the variation index only once if two substances are
added to two separate solutions
If two substances are added to two different solutions with two different ADD STD-type commands and detected in the same measuring
command, then the variation index is increased only once for this measuring command.
■Increasing the variation index for all measuring commands
when the same substance is added
If a standard solution containing a substance that is to be determined
in different measuring commands is added using the ADD STD command, then the variation index for this substance is increased in all
measuring commands.
■■■■■■■■
26
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.3.3.2 Sample data variables
Dialog window: Formula editor ▶ Variables
Sample data variables are method-specific and are defined in the method's START command. The data type (Text, Number, Date/Time) of
the variables is defined there. Either sample data variables (e.g., Sampleamount, Sample amount unit, Sample position, ID1 - ID16) or fixed
values can be assigned to these variables. The Variables field of the formula editor lists all the Sample data variables that are available for the
current method.
The sample data variables can be selected directly in the formula editor
under Variables ▶ Sample data variables so as to avoid syntax errors.
Sample data variables
2 General program functions
Identification
VALValue of the sample data variable (optional, i.e., 'SD.Factor' = SD.Factor.VAL')
OVFExceeding limits for sample data variable (Number: 1 = limit exceeded, 0 =
In the following lines you will find the sample data variables present in the default settings which appear in the Workplace and which can be edited and deleted in the START command of the corresponding method.
ID1Value of ID1Text, Number
ID1.OVFExceeding limit for ID1Number
ID2Value of ID2Text, Number
ID2.OVFExceeding limit for ID2Number
ID3Value of ID3Text, Number
ID3.OVFExceeding limit for ID3Number
Sample typeValue of Sample typeText
DescriptionData type
Text, Number
(Text, Number or Date/Time)
limit not exceeded)
or Date/Time
Number
or Date/Time
or Date/Time
or Date/Time
Sample
type.OVF
Sample position
viva 1.1
Exceeding limit for Sample typeNumber
Value of Sample positionNumber
■■■■■■■■
27
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Identification
Sample position.OVF
Sample
amount
Sample
amount.OVF
Sample
amount unit
Sample
amount
unit.OVF
Analytical
volume
Analytical
volume.OVF
Dilution volume
DescriptionData type
Exceeding limit for Sample positionNumber
Value of Sample amountNumber
Exceeding limit for Sample amountNumber
Value of Sample amount unitText
Exceeding limit for Sample amount unitNumber
Value of Analytical volumeNumber
Exceeding limit for Analytical volumeNumber
Value of Dilution volumeNumber
Dilution volume.OVF
Exceeding limit for Dilution volumeNumber
2.3.3.3 Sample data variables of the next sample data line
Dialog window: Formula editor ▶ Variables
Sample data variables are method-specific and are defined in the method's START command. The data type (Text, Number, Date/Time) of
the variables is defined there. Either sample data variables (e.g., Sampleamount, Sample amount unit, Sample position, ID1 - ID16) or fixed
values can be assigned to these variables. The Variables field of the formula editor lists all the Sample data variables that are available for the
current method.
Syntax
'SD.NEXT.Variable name.Variable identification'
These variables contain the sample data of the next line of the sample
table of a determination series. These variables are distinguished in the
syntax from the sample data variables of the current sample data line by
means of the word NEXT. The data type (Text, Number or Date/Time)
depends on the variable.
■■■■■■■■
28
The sample data variables can be selected directly in the formula editor
under Variables ▶ Sample data variables ▶ NEXT in order to avoid
syntax errors.
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
Sample data variables
Identification
VALValue of the sample data variable (optional, i.e., 'SD.Factor' = SD.Factor.VAL')
OVFExceeding limits for sample data variable (Number: 1 = limit exceeded, 0 =
In the following lines you will find the sample data variables present in the default settings which appear in the Workplace and which can be edited and deleted in the START command of the corresponding method.
ID1Value of ID1Text, Number
ID1.OVFExceeding limit for ID1Number
ID2Value of ID2Text, Number
ID2.OVFExceeding limit for ID2Number
ID3Value of ID3Text, Number
ID3.OVFExceeding limit for ID3Number
Sample typeValue of Sample typeText
DescriptionData type
Text, Number
(Text, Number or Date/Time)
limit not exceeded)
or Date/Time
Number
or Date/Time
or Date/Time
or Date/Time
Sample
type.OVF
Sample position
Sample position.OVF
Sample
amount
Sample
amount.OVF
Sample
amount unit
Sample
amount
unit.OVF
Analytical
volume
Analytical
volume.OVF
Exceeding limit for Sample typeNumber
Value of Sample positionNumber
Exceeding limit for Sample positionNumber
Value of Sample amountNumber
Exceeding limit for Sample amountNumber
Value of Sample amount unitText
Exceeding limit for Sample amount unitNumber
Value of Analytical volumeNumber
Exceeding limit for Analytical volumeNumber
Dilution volume
viva 1.1
Value of Dilution volumeNumber
■■■■■■■■
29
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Identification
Dilution volume.OVF
2.3.3.4
DescriptionData type
Exceeding limit for Dilution volumeNumber
NOTE
The following rules apply for sample data variables of the next sample
data line:
■If a sample data variable of the next sample data line is used in a
determination, then the data type of these variables has to match
that of the current sample data line. If this is not the case, then the
value invalid will be assigned to the variable.
■Sample data variables of the next sample data line are always read
out of the sample table at the beginning of the determination.
■In the case of a single determination or if the current determination
is the last determination of a series, all the sample data variables of
the next sample data line contain the value invalid.
Command variables
Dialog window: Formula editor ▶ Variables
The command variables are method-specific and depend on which commands are used in the method. Included among the command variables
are also solution and sensor variables, which are applied automatically
from the corresponding tables in the Configuration for the instrumentdependent commands when the determination is started and which are
assigned to the individual commands. The Variables field of the formula
editor lists all command variables which are available for the current
method.
Syntax
'Command name.Variable identification'
Examples: 'Track 6.BSY', 'ADD STD 4.VOL'
Command variables can be selected directly in the formula editor under
Variables ▶ Command variables in order to avoid syntax errors.
Command variables
Unless marked otherwise, all the variables listed here in alphabetical order
are of the Number type.
■■■■■■■■
30
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
NOTE
In the case of variables with the index {x}, the required number 1 - 9
must be entered for x (e.g., RS.CVS 3.VAR{3}.VTOT for the total volume in the measuring vessel after the third addition).
If no index is specified, then the last index will be used automatically
(e.g., RS.CVS 3.VAR.VTOT for the total volume after the last addition).
Identification
ACOAddition counter = current number of completed runs of the commandADD SAMPLE
BP{x}.CNTIntensity for the break point x (1 - 9) in countsMEAS Opt
BP{x}.MEAMeasured value for the break point x (1 - 9) in the unit of the measured valueMEAS Opt
BP{x}.TEMTemperature for the break point x (1 - 9) in °CMEAS Opt
BP{x}.TIMTime for the break point x (1 - 9) in sMEAS Opt
BP{x}.TRNTransmission for the break point x (1 - 9) in %MEAS Opt
BSYCommand status:
C0Coefficient c0 of the calibration curveCAL LOOP
C1Coefficient c1 of the calibration curveCAL LOOP
DescriptionCommands
DT, ADD STD
All except
1 = BUSY, HOLD or ERROR
0 = READY
invalid (variable not available) = Command has never been started
START and
END
Opt, CAL Spec
Opt, CAL Spec
C2Coefficient c2 of the calibration curveCAL LOOP
Opt, CAL Spec
C3Coefficient c3 of the calibration curveCAL LOOP
Opt, CAL Spec
CALStatus of the calibration: 1 = calibrated normally, 0 = canceled, because ref-
erence wavelength was not found.
CODCoefficient of determination (R2), which is calculated on the basis of the calibra-
tion function and of the confidence interval.
CP{#}.MEAMeasured wavelength of the calibration point in nm. If no measured peak can be
assigned, then not found will be entered.
CP{#}.REFReference wavelength of the calibration point in nm.CAL Spec
viva 1.1
CAL Spec
CAL LOOP Opt
CAL Spec
■■■■■■■■
31
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Identification
CYLCylinder volume of the exchange or dosing unit used for the commandADD AUX,
DBLTotal duration for the processing of the command in sCAL MEAS
DEFDefault value which is defined in the configuration for an IO port; 1 = active, 0 =
PID/PWM: –100 to 100% (value of the analog output or the pulse frequency)
CONTROL
troller command status: 1 = active, 0 = inactive
PID/PWM: –100 to 100% (value of the analog output or the pulse frequency)
PK{x}.ABSAbsorbance of the peak x (1 - 9) in mAUMEAS Spec
PK{x}.TRNTransmission of the peak x (1 - 9) in %MEAS Spec
PK{x}.CNTIntensity of the peak x (1 - 9) in countsMEAS Spec
PK{x}.CNRIntensity of the peak x (1 - 9) in the reference spectrum in countsMEAS Spec
PK{x}.CNDIntensity of the peak x (1 - 9) in the dark spectrum in countsMEAS Spec
PK{x}.WVLWavelength of the peak x (1 - 9) in nmMEAS Spec
PK{x}.SATDetector with peak x (1 - 9) saturated: 1 = saturated;0 = not saturatedMEAS Spec
RPMStirring rate in min
RANCurrent absolute rotation angle of the rack in ° in relation to the axis of the
selected tower (entry when exiting the command)
RPOCurrent rack position (entry when exiting the command); 0 means 'not defined'MOVE
SANCurrent absolute swing angle of the robotic arm in ° (entry upon exiting the com-
mand)
SDVActual value of the standard deviation when the command is canceledCALL COND
SPOCurrent external position (entry when ending the command); 0 means invalid
position
SRATSignal ratio at the most recent command run.LOOP
–1
CVS, CPVS, CP
MOVE
MOVE, SWING
SWING
STC{x}Concentration of the standard x (1 - 50) used for the commandCAL LOOP Opt
viva 1.1
■■■■■■■■
35
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Identification
STYType of stop with which the command was stopped: 1 = finished normally, 0
STYStop type used for stopping the LOOP command: 0 = manual or after error; 1
TMFTransmission factor (dimensionless)MEAS TMF
TOLTolerance within which a measured peak can be assigned to a calibration wave-
TOUTimeout status: 1 = Max. waiting time expired; 0 = Max. waiting time not
DescriptionCommands
CAL MEAS
= stopped manually with [Quit] or [Stop]
= maximum number of runs; 2 = maximum run time; 3 = signal ratio; 4 =
condition
length.
expired
Opt, CAL
Spec, CVS,
CPVS, CP,
MEAS Opt,
MEAS Opt
Conc, MEAS
Ref, MEAS
Spec, MEAS
TMF, MEAS T
LOOP
CAL Spec
RECEIVE,
SCAN, TRANSFER
UNIMapping unit which is defined for an IO port in the configurationANALOG IN,
ANALOG OUT
VOLDosed volume increment in LADD STD,
ADD STD,
ADD SAMPLE
DT, ADD STD,
LQH
VOLTOTDosed total volume in LADD SAMPLE
DT, ADD STD
2.3.3.5 Evaluation parameter variables
Dialog window: Formula editor ▶ Variables
The automatically calculated evaluation parameter variables are automatically generated by the program for the VA measuring command contained in the method during the evaluation. The Variables field of the
formula editor lists all the variables which are available for the current
method.
You can select the method variables directly in the formula editor under
Variables ▶ Evaluation parameter variables in order to avoid syntax
errors.
Available evaluation parameter variables
IdentificationDescriptionData
type
EVRATIOEvaluation ratio of a substance for the calibration curve (DT).Number
2.3.3.6 Automatically calculated result variables
Dialog window: Formula editor ▶ Variables
The automatically calculated result variables are automatically generated
by the program for the VA measuring commands contained in the
method during the evaluation. In the formula editor, the Variables field
lists all variables which are available for the current method under Resultvariables.
You can select the method variables directly in the formula editor under
Variables ▶ Result variables in order to avoid syntax errors.
■■■■■■■■
37
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Available result variables
IdentificationDescriptionData
type
AMOUNTMass, amount or volume of a substance that has entered the measuring vessel via
the sample amount (see Chapter 5.6.7.7.19, page 723).
AREAPeak area (see Chapter 5.6.7.3.3, page 701).Number
AREA.ASDAbsolute standard deviation of the peak areas of all replications (see Chapter
5.6.7.3.5, page 702).
AREA.MNVMean value of the peak areas of all replications (see Chapter 5.6.7.3.4, page
701).
AREA.MNVDELTADifference between the mean value of the peak areas of all replications for the
variation {x} and the mean value of the peak areas of all replications for the variation {x-1}(see Chapter 5.6.7.3.7, page 703).
AREA.RSDRelative standard deviation of the peak areas of all replications (see Chapter
5.6.7.3.6, page 702).
AREANORMStandardized area of a peak (see Chapter 5.6.7.7.1, page 715).Number
CALC0Zero-order coefficient of the calibration curve or standard addition curve (see
Chapter 5.6.7.4.1, page 707).
CALC1First-order coefficient of the calibration curve or standard addition curve (see
Chapter 5.6.7.4.2, page 710).
CALC2Second-order coefficient of the calibration curve or standard addition curve (see
Chapter 5.6.7.4.3, page 710).
Number
Number
Number
Number
Number
Number
Number
Number
CALC4Fourth-order coefficient of the calibration curve or standard addition curve (see
Chapter 5.6.7.4.4, page 711).
CALFACTCalibration factor DT (see Chapter 5.6.7.7.11, page 720).Number
CALFACT.ASDAbsolute standard deviation of the calibration factor DT (see Chapter 5.6.7.7.13,
page 721).
CALFACT.RSDRelative standard deviation of the calibration factor DT (see Chapter 5.6.7.7.14,
page 722).
CALFACT.UNIUnit of the calibration factor DT (see Chapter 5.6.7.7.12, page 721).Text
CONCConcentration of the substance in the sample (see Chapter 5.6.7.6.1, page 713).Number
CONC.ASDAbsolute standard deviation of the concentration of the substance in the sample
(see Chapter 5.6.7.6.3, page 715).
CONC.RSDRelative standard deviation of the concentration of the substance in the sample
(see Chapter 5.6.7.6.4, page 715).
CONC.UNIUnit of the concentration of the substance in the sample (see Chapter 5.6.7.6.2,
page 714).
CONCMSubstance concentration in the measuring vessel (see Chapter 5.6.7.7.15, page
722).
Number
Number
Number
Number
Number
Text
Number
■■■■■■■■
38
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
IdentificationDescriptionData
2 General program functions
type
CONCM.ASDAbsolute standard deviation of the substance concentration in the measuring ves-
sel (see Chapter 5.6.7.7.17, page 722).
CONCM.RSDRelative standard deviation of the substance concentration in the measuring ves-
sel (see Chapter 5.6.7.7.18, page 723).
CONCM.UNIUnit of the substance concentration in the measuring vessel (see Chapter
5.6.7.7.16, page 722).
CURCurrent of the fixed point.Number
CUR.ASDAbsolute standard deviation of all replications of a variation for the current of the
selected fixed point.
CUR.MNVMean value of all replications of a variation for the current of the selected fixed
point.
CUR.RSDRelative standard deviation of all replications of a variation for the current of the
selected fixed point.
CUR.UNIUnit for the currentText
ENDEnd base point, where the peak evaluation base line ends (see Chapter
5.6.7.3.14, page 706).
HGTPeak height (see Chapter 5.6.7.3.8, page 703).Number
HGT.ASDAbsolute standard deviation of the peak heights of all replications (see Chapter
5.6.7.3.10, page 704).
Number
Number
Text
Number
Number
Number
Number
Number
HGT.MNVMean value of the peak heights of all replications (see Chapter 5.6.7.3.9, page
704).
HGT.MNVDELTADifference between the mean value of the peak heights of all replications for the
variation {x} and the mean value of the peak heights of all replications for the variation {x-1}(see Chapter 5.6.7.3.7, page 703).
HGT.RSDRelative standard deviation of the peak heights of all replications (see Chapter
5.6.7.3.11, page 705).
HGTNORMStandardized height of a peak (see Chapter 5.6.7.7.2, page 716).Number
POTPeak potential of a substance (see Chapter 5.6.7.3.2, page 700) or potential of a
fixed point (see Chapter 5.6.7.3.15, page 707).
POT.ASDAbsolute standard deviation of all replications of a variation for the potential of a
selected fixed point.
POT.MNVMean value of all replications of a variation for the potential of a selected fixed
point.
POT.RSDRelative standard deviation of all replications of a variation for the potential of a
selected fixed point.
POT.UNIUnit for the potential.Text
R2Coefficient of determination R2 (see Chapter 5.6.7.4.5, page 712).Number
Number
Number
Number
Number
Number
Number
Number
viva 1.1
■■■■■■■■
39
2.3 Formula editor
IdentificationDescriptionData
■■■■■■■■■■■■■■■■■■■■■■
type
STARTStart base point, where the baseline of the peak evaluation begins (see Chapter
5.6.7.3.13, page 706).
SUBSTSubstance name (see Chapter 5.6.7.3.1, page 700).Text
TIMTime until the fixed point is reached.Number
TIM.ASDAbsolute standard deviation of all replications of a variation for the time of the
selected fixed point.
TIM.MNVMean value of all replications of a variation for the time of the selected fixed
point.
TIM.RSDRelative standard deviation of all replications of a variation for the time of the
selected fixed point.
TIM.UNIUnit for the time.Text
VEFFSTDEffective addition volume of the added standard solution for the evaluation ratio
(see Chapter 5.6.7.7.3, page 717).
VEFFSTD.ASDAbsolute standard deviation of the effective addition volume of the added stan-
dard solution for the evaluation ratio (see Chapter 5.6.7.7.5, page 718).
VEFFSTD.RSDRelative standard deviation of the effective addition volume of the added stan-
dard solution for the evaluation ratio (see Chapter 5.6.7.7.6, page 718).
VEFFSTD.UNIUnit of the effective addition volume of the added standard solution for the eval-
uation ratio (see Chapter 5.6.7.7.4, page 718).
Number
Number
Number
Number
Number
Number
Number
Text
VEFFSMPLEffective addition volume of the added sample solution for the evaluation ratio
(see Chapter 5.6.7.7.7, page 718).
VEFFSMPL.ASDAbsolute standard deviation of the effective addition volume of the added sample
solution for the evaluation ratio (see Chapter 5.6.7.7.17, page 722).
VEFFSMPL.RSDRelative standard deviation of the effective addition volume of the added sample
solution for the evaluation ratio (see Chapter 5.6.7.7.10, page 720).
VEFFSMPL.UNIUnit of the effective addition volume of the added sample solution for the evalua-
tion ratio (see Chapter 5.6.7.7.8, page 719).
VTOTTotal volume in the measuring vessel (see Chapter 5.6.7.5.1, page 713).Number
Number
Number
Number
Text
2.3.3.7 User-defined result variables
Dialog window: Formula editor ▶ Variables
User-defined result variables are generated for the user-defined results
defined by the user in the method. A basic distinction is made between
single results and multiple results.
A single result is an individual numerical value which is calculated
according to a specified formula.
In the case of a multiple result, a formula is specified with which a result
is calculated in the same way for each substance.
■■■■■■■■
40
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
Syntax
Single result:
■'RS.Result name'
Multiple result:
■'RS.Command name.ASU.Result name', where ASU stands for "all
substances" and represents all substances as a wildcard.
■'RS.Command name.Substance name.Result name', where the
Substance name represents precisely one specific substance.
2.3.3.8 Determination variables
Dialog window: Formula editor ▶ Variables
Determination variables are general variables that are generated in the
method run. They are not assigned to individual commands. The Varia-bles field of the formula editor lists the Determination variables which
are available for the current method, sorted according to name.
Syntax
'DV.Variable identification'
2 General program functions
Examples: 'DV.DUR', 'DV.STT'
Determination variables can be selected directly in the formula editor
under Variables ▶ Determination variables so as to avoid syntax
errors.
Available determination variables
DesignationDescriptionData type
DURDuration of the determination in sNumber
STTMoment at which the determination has been startedDate/Time
2.3.3.9 System variables
Dialog window: Formula editor ▶ Variables
System variables are general variables which are adopted in the determination at the start of the determination. They are assigned neither to individual commands nor to determinations. The Determination variables
field of the formula editor lists all the System variables that are available
for the current method.
Syntax
'SV.Variable identification'
viva 1.1
Examples: 'SV.SIN', 'SV.SLI'
System variables can be selected directly in the formula editor under Vari-
ables ▶ System variables so as to avoid syntax errors.
■■■■■■■■
41
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Available system variables
DesignationDescriptionData type
ACCAutostart actual counterNumber
ACEAutostart setpoint counterNumber
DIDDetermination IDText
FUNFull name of the logged-in userText
ORGMethod run: 1 = original determination, 0 = reprocessingNumber
REMRemarksText
RUNSample numberNumber
SENIndication whether the end of the sample table has been reached; 1 = yes, 0 =
no
SINIndication whether the determination has been started as a single determination
or within a series; 1 = single determination, 0 = series determination
SLISample table actual line (number)Number
STCStart counterNumber
STOIndication whether the determination has been stopped (manual stop, stop via
Common variables apply to all methods and are adopted from the corresponding table in the Configuration program part where the common
variables can be defined and assigned to the determination at the time of
its start. The Variables field of the formula editor lists all of the CommonVariables which are available, sorted according to variable name.
Syntax
'CV.Variable name.Variable identification'
Examples: 'CV.TestDate', 'CV.AverageTemp.UNI'
You can select the common variables directly in the formula editor under
Variables ▶ Common Variables in order to avoid syntax errors.
Available common variables
Designation
'none'Value of the common variableNumber
UNIUnit of the common variableText
■■■■■■■■
42
DescriptionData type
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
2.3.3.11 Global variables
Dialog window: Formula editor ▶ Variables
Global variables apply to all clients and are adopted at the start of the
determination and assigned to it from the corresponding table in the
Configuration program part where global variables can be defined. The
Variables field of the formula editor lists all of the available Global Variables, sorted according to variable name.
Syntax
'GV.Variable name.Variable identification'
Examples: 'GV.TestDate', 'GV.AverageTemp.UNI'
You can select the global variables directly in the formula editor under
Variables ▶ Global Variables in order to avoid syntax errors.
Available global variables
DesignationDescriptionData type
'none'Value of the global variableNumber
UNIUnit of the global variableText
2.3.4 Operators/functions
2.3.4.1
Operators/functions - Overview
Dialog window: Formula editor ▶ Operators/Functions
The operators are evaluated in the order in which they are listed in the
table below. In order to attain the required order, it may be necessary to
place operands in parentheses.
Operators
Arithmetic^
Comparison<, <=, >, >=
LogicAND, OR
2.3.4.2 Arithmetical operators
2.3.4.2.1 Addition
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 + Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type.
Examples
Operand1
both operands of the same type:
Operand2ResultExampleRemark
*, /
+, -
NumberNumberNumber1.2 + 3 = 4.2–
■■■■■■■■
44
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
Operand1Operand2ResultExampleRemark
2 General program functions
TextTextText"Metrohm" + "AG" =
"Metrohm AG"
TimeTimeNumberTime(1998;04;06) +
Time(1964;02;03) = 59,300.875
(for UTC+1)
Operands of a different type: The operand which does not correspond to the result type is converted to the relevant result type before the operation.
NumberTextText1.2 + "Metrohm" = "1.2Metrohm"–
TextNumberText"Metrohm" + 1.2 = "Metrohm1.2"–
NumberTimeNumber2.0 + Time(1999;11;7) = 36,472.96
(for UTC+1)
TimeNumberNumberTime(1999;10;7) + 2.0 = 36,441.92
(for UTC+2)
TextTimeText"Metrohm" + Time(1999;10;7) =
"Metrohm1999-10-07 00:00:00
UTC+2"
If the maximum permissible length
(65,536 characters) of the character string is exceeded by addition
of the operands, the surplus characters will be removed from the
second operand.
Result: Number of days calculated
from December 1899, dependent
on the system time
Result: Number of days calculated
from December 1899, dependent
on the system time
Result: Number of days calculated
from December 1899, dependent
on the system time
Before the operation, the operand
of the Date/Time type is converted to Text.
TimeTextTextTime(1999;01;7) + "Metrohm" =
"1999-01-07 00:00:00 UTC
+1Metrohm"
The same rules apply here as for
the previous operation.
2.3.4.2.2 Subtraction
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 – Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type.
Examples
Operand1Operand2ResultExampleRemark
both operands of the same type:
NumberNumberNumber1.2 – 3 = –1.8–
TextTextText"Metrohm" – "AG" = invalidThis operation is not allowed.
TimeTimeNumberTime(1998;01;06) –
Time(1964;12;03) = 12,087.00 (for
UTC+1)
Result: Number of days calculated
from December 1899, dependent
on the system time
viva 1.1
■■■■■■■■
45
2.3 Formula editor
Operand1Operand2ResultExampleRemark
Operands of a different type: The operand which does not correspond to the result type is converted to the rele-
vant result type before the operation.
NumberTextText1.2 – "Metrohm" = invalidThis operation is not allowed.
TextNumberText"Metrohm" – 1.2 = invalidThis operation is not allowed.
■■■■■■■■■■■■■■■■■■■■■■
NumberTimeNumber2.0 – Time(1999;10;7) = –
36,437.917 (for UTC+2)
TimeNumberNumberTime(1999;10;7) – 2.5 =
36,437.917 (for UTC+2)
TextTimeText"Metrohm" – Time(1999;10;7) =
invalid
TimeTextTextTime(1999;10;7) – "Metrohm" =
invalid
2.3.4.2.3 Multiplication
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 * Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type.
Examples
Result: Number of days calculated
from December 1899, dependent
on the system time
Result: Number of days calculated
from December 1899, dependent
on the system time
This operation is not allowed.
This operation is not allowed.
Operand1Operand2ResultExampleRemark
Operands of the same type:
NumberNumberNumber1.2 * 3 = 3.6–
TextTextText"Metrohm" * "AG" = invalidThis operation is not allowed.
TimeTimeNumberTime(1998;05;06) *
Time(1902;02;03) = 27478004.545
(for UTC+1 or +2 in the summer time)
Operands of a different type: The operand which does not correspond to the result type is converted to the relevant result type before the operation.
of a combination of a real and
an imaginary part) are displayed as an error.
TextTextText"Metrohm" ^ "AG" = invalidThis operation is not allowed.
TimeTimeNumberTime(1900;01;05) ^
Time(1900;01;02) = 196.371 (for UTC
+1)
Operands of a different type: The operand which does not correspond to the result type is converted to the relevant result type before the operation.
NumberTextText1.2 ^ "Metrohm" = invalidThis operation is not allowed.
TextNumberText"Metrohm" ^ 1.2 = invalidThis operation is not allowed.
NumberTimeNumber1.2 ^ Time(1900;02;03) = 586.198
(for UTC+1)
TimeNumberNumberTime(1999;10;7) ^ 2.5 =
253,479,847,878.04 (for UTC+2)
TextTimeText"Metrohm" ^ Time(1999;10;7) = inva-
lid
TimeTextTextTime(1999;10;7) ^ "Metrohm" = inva-
lid
Result: Number of days calculated from December 1899,
dependent on the system time
–
–
This operation is not allowed.
This operation is not allowed.
2.3.4.3 Logical operators
2.3.4.3.1 AND
Dialog window: Formula editor ▶ Operators/Functions
■■■■■■■■
48
Syntax
Operand1 AND Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false). The following cases are possible:
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
Operand1Operand2Result
111
010
100
000
Examples
Operand1
Operands of the same type:
NumberNumberNumber5 AND 4 --> 1
TextTextNumber"Metrohm" AND "AG" --> 1
TimeTimeNumberTime(1999;10;07) AND
Operands of a different type:
NumberTextNumber1.2 AND "1.2" --> 1
Operand2
ResultExampleRemark
4 AND 0 --> 0
"" AND "AG" --> 0
Time(1999;10;07) --> 1
0 AND "1" --> 1
0 AND "0" --> 1
0 AND "" --> 0
Numbers greater than 0 are interpreted as
1 (true).
An empty character string ("") is interpreted as 0 (false), everything else as 1 (true).
The first operation therefore corresponds
to 1 AND 1 --> 1.
Time(): see Time(Date)
Before the operation, the operand of the
Number type is converted to the Text
type, as a conversion from Text to Num-ber is not useful. During the second operation, the 0 is therefore converted to "0",
which corresponds to the logical value 1
(true), as every character string that is not
empty is interpreted as 1.
TextNumberNumber"Metrohm" AND 1.2 --> 1The same rules apply here as for the previ-
ous operation.
NumberTimeNumber2.0 AND Time(1999;10;7) -->
1
0 AND Time(1999;10;07) --> 0
TimeNumberNumberTime(1999;10;7) AND 2.5 -->1The same rules apply here as for the previ-
TextTimeNumber"Metrohm" AND
Time(1999;10;7) --> 1
"" AND Time(1999;10;07) -->
0
TimeTextNumberTime(1999;10;7) AND
"Metrohm" --> 1
viva 1.1
Before the operation, the operand of the
Date/Time type is converted to Number
and all dates since December 30, 1899
are interpreted as 1 (true).
ous operation.
Before the operation is carried out, the
operand of the Date/Time type is converted to the Text type, and every nonempty character string is interpreted as 1
(true).
The same rules apply here as for the previous operation.
■■■■■■■■
49
2.3 Formula editor
2.3.4.3.2 OR
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 OR Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false). The following cases are possible:
Operand1Operand2Result
111
011
101
000
Examples
Operand1Operand2ResultExampleRemark
■■■■■■■■■■■■■■■■■■■■■■
Operands of the same type:
NumberNumberNumber5 OR 4 --> 1
4 OR 0 --> 1
TextTextNumber"Metrohm" OR "AG" --> 1
"" OR "Metrohm" --> 1
"" OR "" --> 0
TimeTimeNumberTime(1999;10;07) OR
Time(1964;02;03) --> 1
Operands of a different type: The operand which does not correspond to the result type is converted to the rele-
vant result type before the operation.
NumberTextNumber1.2 OR "1.2" --> 1
0 OR "" --> 1
TextNumberNumber"Metrohm" OR 1.2 --> 1The same rules apply here as for the pre-
Numbers greater than 1 are automatically interpreted as 1 (true)
An empty character string ("") is interpreted as 0 (false), everything else as 1
(true). The first operation therefore corresponds to 1 OR 1 --> 1
Time(): see Time(Date)
Before the operation, the operand of
the Number type is converted to the
Text type, as a conversion from Text to
Number is not useful. During the sec-
ond operation, the 0 is therefore converted to "0", which corresponds to the
logical value 1 (true), as every character
string that is not empty is interpreted as
1.
vious operation.
■■■■■■■■
50
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
Operand1Operand2ResultExampleRemark
2 General program functions
NumberTimeNumber2.0 OR Time(1999;10;7) --> 1
0 OR Time(1964;02;03) --> 1
TimeNumberNumberTime(1999;10;7) OR 2.5 --> 1The same rules apply here as for the pre-
TextTimeNumber"Metrohm" OR
Time(1999;10;7) --> 1
TimeTextNumberTime(1999;10;7) OR
"Metrohm" --> 1
Before the operation, the operand of
the Date/Time type is converted to
Number and all dates since December
30, 1899 are interpreted as 1 (true).
vious operation.
Before the operation is carried out, the
operand of the Date/Time type is converted to the Text type, and every nonempty character string is interpreted as
1 (true).
The same rules apply here as for the previous operation.
2.3.4.4 Relational operators
2.3.4.4.1 Equal to
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 = Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false).
Examples
Operand1
Operands of the same type:
NumberNumberNumber5 = 5 --> 1
TextTextNumber"Metrohm" = "AG" --> 0
TimeTimeNumberTime(1998;04;06) =
Operands of a different type:
NumberTextNumber1.2 = "1.2" --> 11.2 =
Operand2
ResultExampleRemark
4 = 5 --> 0
"aG" = "AG" --> 0
Time(1964;02;03) --> 0
"Metrohm" --> 0
–
When making a comparison between two
texts, the ASCII value of the character string
is compared (see Chapter 2.3.4.10, page
75). Attention: Uppercase and lowercase
letters have different values!
(see Chapter 2.3.4.6.2, page 63)
Before the relational operation, the Number
is converted to Text, afterwards the texts are
compared according to ASCII value(seeChapter 2.3.4.10, page 75).
viva 1.1
■■■■■■■■
51
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Operand1
TextNumberNumber"Metrohm" = 1.2 --> 0The same rules apply here as for the previous
NumberTimeNumber2.0 = Time(1999;10;07) -->0Before the relational operation, the operand
TimeNumberNumberTime(1999;10;7) = 2.0 --> 0The same rules apply here as for the previous
TextTimeNumber"Metrohm" =
TimeTextNumberTime(1999;10;07) =
Operand2
ResultExampleRemark
operation.
of the Date/Time type is converted to a
Number. During execution of the operation,
the exact value is always used after this conversion, even if maximum 5 places after the
comma can be displayed (see Chapter
2.3.4.7.5, page 68).
operation.
Before the operation, the operand is con-
Time(1999;10;07) --> 0
"Metrohm" --> 0
verted from Date/Time to Text (in this
example: "1999-10-07 00:00:00 UTC+2"), afterwards the texts are compared
according to ASCII value(see Chapter
2.3.4.10, page 75).
The same rules apply here as for the previous
operation.
2.3.4.4.2 Greater than
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 > Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false).
Examples
Operand1
Operands of the same type:
NumberNumberNumber5 > 4 --> 1
TextTextNumber"Metrohm" > "AG" --> 1
Operand2
ResultExampleRemark
4 > 5 --> 0
"Aarau" > "Zug" --> 0
–
When making a comparison between two
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,page 75). Attention: Uppercase and
lowercase letters have different values!
TimeTimeNumberTime(1998;04;06) >
Time(1964;02;03) --> 1
■■■■■■■■
52
(see Chapter 2.3.4.6.2, page 63)
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
Operand1
Operands of a different type:
NumberTextNumber1.2 > "Metrohm" --> 01.23 >
TextNumberNumber"Metrohm" > 1.2 --> 1The same rules apply here as for the previ-
NumberTimeNumber2.0 > Time(1999;10;07) --> 0Before the comparison, the operand is
TimeNumberNumberTime(1999;10;07) > 2.0 --> 1The same rules apply here as for the previ-
TextTimeNumber"Metrohm" >
TimeTextNumberTime(1999;10;7) >
Operand2
ResultExampleRemark
Before the relational operation, the Num-
"1.2" --> 1
Time(1999;10;07) --> 1
"Metrohm" --> 0
ber is converted to Text, afterwards thetexts are compared according to ASCII
value (see Chapter 2.3.4.10, page 75).
ous operation.
converted from Date/Time to a Number.
ous operation.
Before the operation, the operand is converted from Date/Time to Text (in this
example: "1999-10-07 00:00:00 UTC+2"), afterwards the texts are compared
according to ASCII value(see Chapter
2.3.4.10, page 75).
The same rules apply here as for the previous operation.
2.3.4.4.3 Greater than or equal to
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 >= Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false).
Examples
Operand1
Operands of the same type:
NumberNumberNumber5 >= 4 --> 1
TextTextNumber"Metrohm" >= "AG" --> 1When making a comparison between two
Operand2
ResultExampleRemark
–
4 >= 5 --> 0
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,page 75). Attention: Uppercase and
lowercase letters have different values!
viva 1.1
■■■■■■■■
53
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Operand1
TimeTimeNumberTime(1998;04;06) >=
Operands of a different type:
NumberTextNumber1.2 >= "1.2" --> 11.2 >=
TextNumberNumber"Metrohm" >= 1.2 --> 1The same rules apply here as for the previ-
NumberTimeNumber2.0 >= Time(1999;10;07) -->0Before the comparison, the operand is con-
TimeNumberNumberTime(1999;10;07) >= 2.0 -->1The same rules apply here as for the previ-
TextTimeNumber"Metrohm" >=
Operand2
ResultExampleRemark
(see Chapter 2.3.4.6.2, page 63)
Time(1964;02;03) --> 1
Before the relational operation, the Num-
"Metrohm" --> 0
Time(1999;10;07) --> 1
ber is converted to Text, afterwards thetexts are compared according to ASCII
value (see Chapter 2.3.4.10, page 75).
ous operation.
verted from Date/Time to a Number.
ous operation.
Before the operation, the operand is converted from Date/Time to Text (in this
example: "1999-10-07 00:00:00 UTC+2"), afterwards the texts are compared
according to ASCII value(see Chapter
2.3.4.10, page 75).
TimeTextNumberTime(1999;10;7) >=
"Metrohm" --> 0
2.3.4.4.4 Less than
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 < Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false).
Examples
Operand1
Operands of the same type:
NumberNumberNumber5 < 4 --> 0
Operand2
ResultExampleRemark
4 < 5 --> 1
The same rules apply here as for the previous operation.
–
■■■■■■■■
54
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
Operand1
TextTextNumber"Metrohm" < "AG" --> 0When making a comparison between two
TimeTimeNumberTime(1998;04;06) <
Operands of a different type:
NumberTextNumber1.2 < "Metrohm" --> 11.2 <
TextNumberNumber"Metrohm" < 1.2 --> 0The same rules apply here as for the previ-
NumberTimeNumber2.0 < Time(1999;10;07) -->1Before the comparison, the operand is con-
TimeNumberNumberTime(1999;10;07) < 2.0 -->0The same rules apply here as for the previ-
Operand2
ResultExampleRemark
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,page 75). Attention: Uppercase and
lowercase letters have different values!
(see Chapter 2.3.4.6.2, page 63)
Time(1964;02;03) --> 0
Before the relational operation, the Num-
"1" --> 0
ber is converted to Text, afterwards thetexts are compared according to ASCII
value (see Chapter 2.3.4.10, page 75).
ous operation.
verted from Date/Time to a Number.
ous operation.
TextTimeNumber"Metrohm" <
Time(1999;10;07) --> 0
TimeTextNumberTime(1999;10;7) <
"Metrohm" --> 1
2.3.4.4.5 Less than or equal to
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 <= Operand2
The operands can be entered either directly or as variables and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false).
Examples
Operand1
Operand2
ResultExampleRemark
Before the operation, the operand is converted from Date/Time to Text (in this
example: "1999-10-07 00:00:00 UTC+2"), afterwards the texts are compared
according to ASCII value(see Chapter
2.3.4.10, page 75).
The same rules apply here as for the previous operation.
Operands of the same type:
viva 1.1
■■■■■■■■
55
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
Operand1
NumberNumberNumber5 <= 4 --> 0
TextTextNumber"Metrohm" <= "AG" --> 0When making a comparison between two
TimeTimeNumberTime(1998;04;06) <=
Operands of a different type:
NumberTextNumber2 <= "1.2" --> 01.2 <=
TextNumberNumber"Metrohm" <= 1.2 --> 0The same rules apply here as for the previ-
NumberTimeNumber2.0 <= Time(1999;10;07) -->1Before the comparison, the operand is con-
Operand2
ResultExampleRemark
–
4 <= 5 --> 1
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,page 75). Attention: Uppercase and
lowercase letters have different values!
(see Chapter 2.3.4.6.2, page 63)
Time(1964;02;03) --> 0
Before the relational operation, the Num-
"Metrohm" --> 1
ber is converted to Text, afterwards thetexts are compared according to ASCII
value (see Chapter 2.3.4.10, page 75).
ous operation.
verted from Date/Time to a Number.
TimeNumberNumberTime(1999;10;07) <= 2.0 -->0The same rules apply here as for the previ-
ous operation.
TextTimeNumber"Metrohm" <=
Time(1999;10;07) --> 0
TimeTextNumberTime(1999;10;7) <=
"Metrohm" --> 1
Before the operation, the operand is converted from Date/Time to Text (in this
example: "1999.10.07"), afterwards the
texts are compared according to ASCIIvalue(see Chapter 2.3.4.10, page 75).
The same rules apply here as for the previous operation.
2.3.4.4.6 Not equal to
Dialog window: Formula editor ▶ Operators/Functions
Syntax
Operand1 <> Operand2
The operands can be entered either directly or as a variable and can be of
the Text, Number or Date/Time type. The result type is always a number (1 = true, 0 = false).
Examples
Operand1
Operand2
ResultExampleRemark
Operands of the same type:
■■■■■■■■
56
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
Operand1
NumberNumberNumber5 <> 4 --> 1
TextTextNumber"Metrohm" <> "AG" --> 1When making a comparison between two
TimeTimeNumberTime(1998;04;06) <>
Operands of a different type:
NumberTextNumber1.2 <> "1.2" --> 01.2 <>
TextNumberNumber"Metrohm" <> 1.2 --> 1The same rules apply here as for the previ-
NumberTimeNumber2.0 <> Time(1999;10;07) -->1Before the comparison, the operand is con-
Operand2
ResultExampleRemark
–
5 <> 5 --> 0
texts, the ASCII value of the character
string is compared (see Chapter 2.3.4.10,page 75). Attention: Uppercase and
lowercase letters have different values!
(see Chapter 2.3.4.6.2, page 63)
Time(1964;02;03) --> 1
Before the relational operation, the Num-
"Metrohm" --> 1
ber is converted to Text, afterwards thetexts are compared according to ASCII
value (see Chapter 2.3.4.10, page 75).
ous operation.
verted from Date/Time to a Number.
TimeNumberNumberTime(1999;10;07) <> 2.5 -->1The same rules apply here as for the previ-
ous operation.
TextTimeNumber"Metrohm" <>
Time(1999;10;07) --> 1
TimeTextNumberTime(1999;10;7) <>
"Metrohm" --> 1
Before the operation, the operand is converted from Date/Time to Text (in this
example: "1999-10-07 00:00:00 UTC+2"), afterwards the texts are compared
according to ASCII value(see Chapter
2.3.4.10, page 75).
The same rules apply here as for the previous operation.
2.3.4.5 Arithmetical functions
2.3.4.5.1 Exponential function
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Exp(number)
Calculates e ^ number. Other notation for y = e
(number)
, where e is the Euler
number (e = 2.71828…).
Parameters
Number Exponent
viva 1.1
■■■■■■■■
57
2.3 Formula editor
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
Examples
Exp(1.5) = 4.48169
Exp('CV.AverageTemp') = Power of the exponent (common variable
CV.AverageTemp) for base e
2.3.4.5.2 Natural logarithm
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Ln(number)
Returns the logarithm of the entered number for base e. Alternative notation for y = loge(number), where e is the Euler number (e = 2.71828…).
Parameters
Number > 0
■■■■■■■■■■■■■■■■■■■■■■
2.3.4.5.3
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
Examples
Ln(3) = 1.09861
Ln('CV.AverageTemp') = Natural logarithm of the value of the commonvariable CV.AverageTemp for base e
Common logarithm
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Log(number)
Returns the logarithm of the entered number for base 10. Alternative
notation for y = log10(number).
Parameters
Number > 0
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
■■■■■■■■
58
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
Examples
Log(10) = 1
Log('CV.AverageTemp') = Common logarithm of the value of the com-mon variable CV.AverageTemp
2.3.4.5.4 Square root
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Sqrt(number)
Returns the square root of the entered number. Alternative notation for y
= √ number or y = 2√ number.
Parameters
Number≥ 0
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
2 General program functions
2.3.4.5.5
Examples
Sqrt(33) = 5.745
Sqrt('CV.AverageTemp') = Square root of the value of the commonvariable CV.AverageTemp
Absolute value
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Abs(number)
Returns the absolute value of the entered number, i.e. the value of the
number irrespective of its sign.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
Examples
Abs(–55.3) = 55.3
viva 1.1
Abs('CV.AverageTemp') = Value of the common variables CV.AverageTemp without signs
■■■■■■■■
59
2.3 Formula editor
2.3.4.5.6 Fraction
■■■■■■■■■■■■■■■■■■■■■■
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Frac(number)
Returns the fraction of the entered number.
NOTE
In the results properties, the number of Decimal places of the result
must always be given, as otherwise the fraction cannot be displayed.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
2.3.4.5.7
Examples
Frac(–55.325) = 0.325
Frac('CV.AverageTemp') = Value of the common variable CV.AverageTemp without sign
Integer
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Int(number)
Returns the integer of the entered number.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
Examples
Int(–55.325) = –55
■■■■■■■■
60
Int('CV.AverageTemp') = Integer of the value of the common variable
CV.AverageTemp
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.3.4.5.8 Rounding integer
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Round(number)
Returns the rounded value of the entered number as a whole number.
If the first decimal place is 5 or greater, the number is rounded up to
the next whole number (commercial rounding).
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
2 General program functions
NOTE
2.3.4.5.9
Examples
Round(–55.5259) = –56
Round('CV.AverageTemp') = Rounded value of the common variable
CV.AverageTemp
Sign
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Sign(number)
Returns the sign of the entered number: 1 for a positive number, –1 for a
negative number.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
Examples
Sign(–55.3) = –1
viva 1.1
Sign(26.115) = 1
■■■■■■■■
61
2.3 Formula editor
Sign('CV.AverageTemp') = Sign of the value of the common variable
CV.AverageTemp
2.3.4.5.10 Quantiles of the Student's t-distribution
Dialog window: Formula editor ▶ Operators/Functions
Syntax
ts = Tinv(Probability, Degrees of freedom)
Calculates the quantiles of the Student's t-distribution for two-sided intervals.
The result describes the half interval length as a multiple of the standard
deviation of a sampling totality with given degrees of freedom within
which, with the indicated probability, the mean value of the distribution
lies, when the interval is centered on the mean value of the sampling
totality.
Parameters
Probability
■■■■■■■■■■■■■■■■■■■■■■
Number type, value range: 0 - 1. Direct entry as number or as formula
providing a number. If the type or value is non-permitted, then the result
will become invalid. This is to indicate the probability of the unknown
mean value of the t-distributed result falling within the two-sided interval.
Degrees of freedom
Number type, value range: 1 - n. Direct entry as number or as formula
providing a number. If the type of value is non-permitted, then the result
will become invalid. The number of independent samplings for calculating the standard deviation, reduced by the number of adjusted parameters for the model to which the standard deviation refers, must be specified as degrees of freedom (Degrees of freedom = Number of samplings –
Number of parameters).
Examples
Tinv(0.95; 9) = 2.26: With a 10-fold determination (e.g., of a titer) half
the interval length corresponds to 2.26 times the standard deviation.
Calculation of the confidence interval for a mean value of sampling: A variance-homogenous sampling with a range n for a normally
distributed quantity with an expected value µ has the mean value xm, the
standard deviation s and the degrees of freedom v = n – 1. The half interval length ts · s/√n then indicates how high, within the given probability,
the maximum absolute difference is between the mean value xm and the
expected value µ. Here the confidence interval is the full interval length,
centered to the mean value: µ = xm ± ts · s/√n.
Student's t-quantiles for a probability of 95% = 2.26
Confidence interval of the titer = 1.001 ± 0.008
2.3.4.6 Date/Time functions
2.3.4.6.1 Time()
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Time()
Returns the current date and the current time.
Parameters
none
Return value
Current date and current time in the yyyy-mm-dd hh:mm:ss UTC ±xx
format
2 General program functions
2.3.4.6.2
UTC = Coordinated Universal Time, from which the times in the various
time zones of the earth are derived. CET (Central European Time) is
equal to UTC plus 1 hour, in the summer time UTC plus 2 hours.
Time(Date)
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Time(year; month; day)
Returns the entered figures in the Date/Time format.
Parameters
year
month1 - 12
day1 - 31
A parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
NOTE
00 - 99 or 1,000 - 9,999
viva 1.1
■■■■■■■■
63
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
NOTE
Only the integral part is used for all parameters.
A variable of the Date/Time type cannot be transferred as a parameter
here.
Both for the automatic and explicit conversion of a Time to the Num-ber type, the number of days are counted since December 30, 1899
at 01 hours.
Attention: December 30, 1899 01 hours = 0.00000 days, this number
is rounded off to 5 decimal places, although a relational operation, for
example, is carried out using the exact value!
Return value
Date/Time in the yyyy-mm-dd hh:mm:ss UTC ±xx format
NOTE
2.3.4.6.3
UTC = Coordinated Universal Time, from which the times in the various
time zones of the earth are derived. CET (Central European Time) is
equal to UTC plus 1 hour, in the summer time UTC plus 2 hours.
Examples
Time(2004;02;02) = 2004-02-02 00:00:00 UTC +1 (dependent on
the system time)
Time('CV.TestYear';'CV.TestMonth';'CV.TestDay') = Date comprised
of the common variables
Time(Date + Time)
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Time(year; month; day; hour; minute; second)
Returns the entered figures in the Date/Time format.
Parameters
year
00 - 99 or 1,000 - 9,999
month1 - 12
■■■■■■■■
64
day1 - 31
hour0 - 23
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
minute0 - 59
second0 - 59
A parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If this is not possible, the result of this operation is returned as invalid.
NOTE
Only the integral part is used for all parameters.
A variable of the Date/Time type cannot be transferred as a parameter
here.
Both for the automatic and explicit conversion of a Time to the Num-ber type, the number of days are counted since December 30, 1899
at 01 hours.
Attention: December 30, 1899 01 hours = 0.00000 days, this number
is rounded off to 5 decimal places, although a relational operation, for
example, is carried out using the exact value!
Return value
Date/Time in the yyyy-mm-dd hh:mm:ss UTC ±xx format
NOTE
UTC = Coordinated Universal Time, from which the times in the various
time zones of the earth are derived. CET (Central European Time) is
equal to UTC plus 1 hour, in the summer time UTC plus 2 hours.
Examples
Time(2004;06;02;10;30;25) = 2004-06-02 10:30:25 UTC +2
(dependent on the system time)
Time('CV.TestYear';'CV.TestMonth';'CV.TestDay';'CV.TestHour';'CV.TestMin';'CV.TestSec') = Date comprised of the common
variables
viva 1.1
■■■■■■■■
65
2.3 Formula editor
2.3.4.7 Type conversion functions
2.3.4.7.1 NumberToText
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = NumberToText(number)
Returns the entered number as Text.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type.
Examples
NumberToText(–55.3) = –55.3
NumberToText('CV.AverageTemp') = Value of the common variable(AverageTemp) as Text
■■■■■■■■■■■■■■■■■■■■■■
2.3.4.7.2
NumberToTime
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = NumberToTime(number)
Returns the entered number as Date/Time, where the number is interpreted as the number of days since December 30, 1899 at 01 hours.
Parameters
Number
The parameter can be indicated either directly as a number or as a variable
of the Number type.
Examples
NumberToTime(35545.526) = 1997-04-25 14:37:26 UTC+2
(dependent on the system time)
NumberToTime(35780.55) = 1997-12-16 14:12:00 UTC+1 (dependent on the system time)
NumberToTime('CV.TestDate') = Value of the common variable (TestDate) as Date/Time
■■■■■■■■
66
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.3.4.7.3 TextToNumber
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TextToNumber(Text)
Returns the entered text as a number.
Parameters
Text
The parameter may only contain numerical characters or variables of
the Text type, as otherwise a type conversion is not possible. The result of
this conversion or the calculation would then be invalid. In addition, text
must be marked by quotation marks.
Examples
TextToNumber("–55.3") = –55.3
TextToNumber('CV.AverageTemp') = Value of the variables (Average-Temp) as Number
2 General program functions
2.3.4.7.4
TextToNumber('SD.ID1') = entered text of ID 1 as Number
TextToTime
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TextToTime(Text;Format)
Returns the entered text as Date/Time.
Parameters
Text
The parameter may only contain numerical characters or variables of
the Text type, as otherwise a type conversion is not possible (Result =
invalid). You can use the following characters as the separator between
year, month, etc.: slash (/), period (.), minus (-), semicolon (;), colon (:),
space and comma. You can determine the sequence of the individual
data yourself, but you must specify this in the Format parameter.
Format
Indicates in which format or order the text has been entered. This parameter must be highlighted by quotation marks and can comprise the
following code characters:
viva 1.1
Characters
yYear
Meaning
■■■■■■■■
67
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
CharactersMeaning
MMonth
dDay
HHour 0 - 23
hHour AM/PM
mMinute
sSecond
aAM/PM marking
NOTE
If you indicate the time in the AM/PM format, it is necessary (in addition to the formatting character h) to use the AM/PM marking a (see
first example below).
Examples
TextToTime("2004-12-3 5:22:01 PM";"yMdhmsa") = 2004-12-03
17:22:01 UTC+1 (dependent on the system time)
2.3.4.7.5
TextToTime("12-15-01 2001:3:5";"HmsyMd") = 2001-03-05
12:15:01 UTC+1 (dependent on the system time)
TextToTime('CV.TestDate';'CV.TestFormat') = Values of the com-
mon variables in the time format indicated
TextToTime('SD.ID1';'CV.TestFormat') = entered text of ID1 in the
time format indicated
TimeToNumber
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TimeToNumber(Time)
Returns the entered time as a Number.
■■■■■■■■
68
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
NOTE
Both for the automatic and explicit conversion of a Time to the Number type, the number of days are counted since December 30, 1899
at 01 hours.
Attention: December 30, 1899 01 hours = 0.00000 days, this number
is rounded off to 5 decimal places, although a relational operation, for
example, is carried out using the exact value.
Parameters
Time
This parameter can be indicated either in the form of a time function or as
a variable of the Time type.
Examples
TimeToNumber(Time()) = current date and current time represented as
Number (in days since December 1899)
TimeToNumber(Time('TestYear';'TestMonth';'TestDay')) = Value ofthe common variables as number of days as a Number
TimeToText
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TimeToText(Time)
Returns the time entered as Text.
y = TimeToText(Time;Format)
Returns the time entered as Text in the required format.
Parameters
Time
This parameter can be indicated either in the form of a time function or as
a variable of the Date/Time type.
Format
Indicates in which format or order the time is to be output as text. This
parameter can comprise the following code characters and must be
marked by quotation marks:
viva 1.1
■■■■■■■■
69
2.3 Formula editor
CharactersMeaningExample
ytwo-digit year number03
yyyyfour-digit year number1999
Mone- or two-digit month number4, 12
MMtwo-digit month number04, 12
MMMmonth name short formJul, Aug
MMMMmonth nameJuly, August
done- or two-digit day number2, 25
ddtwo-digit day number02, 25
■■■■■■■■■■■■■■■■■■■■■■
hone- or two-digit hour number (1 -
12 AM/PM)
hhtwo-digit hour number (1 - 12 AM/
PM)
Hone- or two-digit hour number (0 -
23)
HHtwo-digit hour number (0 - 23)08, 17
mone- or two-digit minute number2, 25
mmtwo-digit minute number02, 25
sone- or two-digit second number3, 55
sstwo-digit second number03, 55
Eweekday short formMon, Tue, Wed
EEEEweekdayMonday, Tuesday
Done-, two- or three-digit number of
the day in the year
DDtwo- or three-digit number of the
day in the year
DDDthree-digit number of the day in the
year
5, 11
05, 11
8, 17
2, 35, 142
02, 35, 142
002, 035, 142
Fone-digit number of the weekday in
the month, e.g., the 2nd Monday in
May
wone- or two-digit number of the
week in the year
wwtwo-digit number of the week in the
year
Wone-digit number of the week in the
month
aFormat AM/PMAM, PM
■■■■■■■■
70
2
5, 25
05, 25
3
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
CharactersMeaningExample
2 General program functions
'Quotation marks used for entering
any text
''Entry of ''
NOTE
If you wish to indicate the time in the AM/PM format, it is necessary,
in addition to the formatting character h, to use the AM/PM marking a
(see last example below).
Examples
TimeToText(Time()) = current date and current time (system) as Text
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = TextPosition(Text; sample text)
Returns the Index which indicates at which point the sample text
appears for the first time in the Text. The numbering of the index begins
at 1!
Parameters
Text
The parameter can be indicated either directly or as a variable of the Text,
Number or Date/Time type.
Sample text
The parameter can be indicated either directly or as a variable of the Text,
Number or Date/Time type. If the types of the two parameters do notcoincide, the type is converted from Sample text to Text. If the Sample
text is not included in the Text, the status invalid is returned.
viva 1.1
■■■■■■■■
71
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
NOTE
Entries of the Number type are always provided with a decimal place.
Example: TextPosition("12345";3) = invalid, as the 3 is converted to
3.0 before the operation and this is not included in the text.
Examples
TextPosition("Citric acid";"acid") = 8, the word "acid" occurs in the
text from index number 8 onwards
TextPosition("Citric acid";"Acid") = invalid, the word "Acid" (capitalized) does not occur in the text
TextPosition("Citric acid";"salt") = invalid, the word "salt" does not
occur in the text
TextPosition(Time(2004;05;05);"5") = 7
TextPosition(3362.14;"6") = 3
2.3.4.8.2
TextPosition('SD.ID2';"Carbonate") = Index in which the word part
"Carbonate" begins for the first time in the ID2
SubText
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = SubText(Text; Position; Length)
Returns that part of the text from Text which begins at the index Position and which has the length Length.
Parameters
Text
The parameter can be indicated either directly as text or as a variable of
the Text type. If the parameter does not correspond to the expected
type, it will automatically be converted to it. If this type conversion is not
possible, the result of this operation is returned as invalid.
Position
The numbering of the Position begins at 1. The parameter can be indicated either directly as a number or as a variable of the Number type. If
the parameter does not correspond to the expected type, it will automatically be converted to it. If a type conversion is not possible or the position
does not exist, the result of this operation is returned as invalid.
■■■■■■■■
72
Length
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2 General program functions
The parameter can be indicated either directly as a number or as a variable
of the Number type. If the parameter does not correspond to the
expected type, it will automatically be converted to it. If a type conversion
is not possible or the length indicated here is greater than the length of
the subtext, then invalid will be returned.
Examples
SubText("Citric acid";8;4) = acid
SubText("Citric acid";8;5) = invalid, only 4 characters exist from posi-
tion 8 onwards
SubText('MV.ID2';1;3) = the first three characters of the identification 2
2.3.4.8.3
Trim
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Trim(Text)
Returns the Text without spaces before and after.
y = Trim(Text; sample text)
Returns the Text without Sample text.
Parameters
Text
The parameter can be indicated either directly or as a variable of the Text,
Number or Date/Time type.
Sample text
The parameter can be indicated either directly or as a variable of the Text,
Number or Date/Time type. If the types of the two parameters do notcoincide, the type is converted from Sample text to the Text type.
NOTE
viva 1.1
Entries of the Number type are always provided with a decimal place.
Example: Trim("12345";3) = 12345, as the 3 is converted to 3.0
before the operation and this is not included in the text.
Examples
Trim(" Citric acid ") = "Citric acid"
Trim("Citric acid";"acid") = Citric
Trim("Citric acid";"salt") = Citric acid
■■■■■■■■
73
2.3 Formula editor
2.3.4.9 Miscellaneous functions
2.3.4.9.1 Case
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Case(Condition; value_true; value_false)
y = Case(Condition; value_true; value_false; value_error)
Returns value_true if the condition is true. Otherwise value_false is
given. If an error occurs in the condition (result invalid), value_error is
given.
Parameters
Condition Number
Any variable (Number type) can be entered here, or a relational or logic
operation can be performed whose operators can be transferred either
directly or as a variable. These can be of the Text, Number or Date/Time type.
■■■■■■■■■■■■■■■■■■■■■■
Value_true
If condition <> 0, this parameter is saved as a result of the function. This
parameter can be transferred either directly or as a variable and can be of
the Text, Number or Date/Time type. Entire operations can also be
transferred here.
Value_false
If condition = 0, this parameter is saved as a result of the function. This
parameter can be transferred either directly or as a variable and can be of
the Text, Number or Date/Time type. Entire operations can also be
transferred here.
Value_error
If condition = invalid, this parameter is saved as a result of the function.
This parameter can be transferred either directly or as a variable and can
be of the Text, Number or Date/Time type. Entire operations can also
be transferred here.
Examples
Case('SD.ID1' = "";"ID1 empty";"ID1 not empty") = if no entry has
been made for ID1 in the run window, the text ID1 empty, otherwise
ID1 not empty, will be saved in the result.
■■■■■■■■
74
Case('RS.IntermediateRes' > 5.5;"Intermediate result too
high";'RS.IntermediateRes' * 26.5;"Error occurred") = If the result
"IntermediateRes" is greater than 5.5, then the text "Intermediate
result too high" will be written into the result, otherwise the intermedi-
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.3.4.9.2 Error
2 General program functions
ate result will be multiplied by 26.5. If an error occurs during the comparison ('RS.IntermediateRes' > 5.5) then "Error occurred" will be saved
as a result of this operation.
Dialog window: Formula editor ▶ Operators/Functions
Syntax
y = Error(value)
Returns +1 if the value is invalid (error) or 0 if the value is valid. This
function can be used, §, to check variables for their existence or validity.
Parameters
Value
The variable to be tested.
Examples
Error('RS.IntermediateRes') = 0: The intermediate result was able to
be calculated.
2.3.4.10
ASCII value
Error('RS.IntermediateRes') = 1: The intermediate result is invalid.
ASCII table
Dialog window: Formula editor
Only printable characters are listed in the table below:
CharactersASCII value
(dec)
32Space64At sign (@)96Grave accent (`)
33Exclamation
mark (!)
34Quotation mark
(")
35Hash mark (#)67C99c
36Dollar ($)68D100d
37Percent (%)69E101e
38Ampersand (&)70F102f
39Apostrophe (')71G103g
(dec)
CharactersASCII value
(dec)
65A97a
66B98b
Characters
viva 1.1
40Opening paren-
theses (()
41Closing paren-
theses ())
72H104h
73I105i
■■■■■■■■
75
2.3 Formula editor
■■■■■■■■■■■■■■■■■■■■■■
ASCII value
(dec)
42Multiplication
43Addition sign (+)75K107k
44Comma (,)76L108l
45Minus sign (-)77M109m
46Period (.)78N110n
47Slash mark (/)79O111o
48080P112p
49181Q113q
50282R114r
51383S115s
52484T116t
53585U117u
54686V118v
CharactersASCII value
(dec)
74J106j
sign (*)
CharactersASCII value
(dec)
Characters
55787W119w
56888X120x
57989Y121y
58Colon (:)90Z122z
59Semicolon (;)91Square bracket
60Less than (<)92Backslash (\)124Vertical stroke (¦)
61Equals (=)93Square bracket
62Greater than (>)94Circumflex (^)126Tilde (~)
63Question mark
(?)
2.3.5 Molar mass calculator
Dialog window: Molar mass calculator
The Molar mass calculator dialog window is used for simple entry of
molar masses into the formula editor and is opened with the
123Curly bracket ({)
([)
125Curly bracket (})
(])
95Underscore (_)
button.
■■■■■■■■
76
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
Selects the month
Selects the year
Selects the day
Selected date
2 General program functions
Mode of operation
The molecular formula of any given chemical compound can be entered
into the Empirical formula field; if you click on [OK] the molar mass of
the compound is calculated and directly entered into the formula editor.
The molecular formula can be entered either directly or by clicking on the
symbols of the periodic table.
Examples
Molecular
formula
H2SO498.0734
Ca(OH)274.09268
AlCl3*6H2O238.43174
2.4 Editing
2.4.1 Selecting the date
Dialog window: Select date
The Select date dialog window serves for entering a date in a field and is
opened with the
Molar mass
button.
viva 1.1
■■■■■■■■
77
2.4 Editing
2.4.2 Text editor
Dialog window: Text editor
The text editor serves for entering formatted text in text fields and is
opened with the button.
The toolbar of the text editor includes the following functions:
Cut selected text and copy it to the clipboard.
Copy selected text to the clipboard.
Insert text from the clipboard.
Open editor for entering a hyperlink (see Chapter 2.4.3, page 79).
■■■■■■■■■■■■■■■■■■■■■■
Open formula editor for entering calculation formulas (see Chapter 2.3,
page 21).
NOTE
In order for results of formulas of the Date type to be output correctly,
for text windows they must be converted to Text using the function
TimeToText(see Chapter 2.3.4.7.6, page 69).
Font size in pt.
Select font color.
Bold.
■■■■■■■■
78
Italic.
Underlined.
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
2.4.3 Hyperlink
2 General program functions
Left-justified.
Centered.
Right-justified.
Dialog window: Hyperlink
The Hyperlink dialog window is used for entering a hyperlink in a field
and is opened with the
Displayed text
Designation of the hyperlink that is displayed.
Link target
Address of the link target to which the hyperlink refers (Web site, e-mail
address, file, …).
The button opens a selection dialog for linking a file as a link target.
2.5 E-mail
2.5.1 Sending an e-mail
Dialog window: [E-mail...] ▶ Send e-mail
E-mail template
Selection of the template for sending e-mails.
button.
Subject
viva 1.1
Subject to describe the message.
■■■■■■■■
79
3.1 Workplace - General
3 Workplace
3.1 Workplace - General
3.1.1 Workplace - Definition
Program part: Workplace
Workplace is defined in viva as the program part in which up to 4 work-
places can be opened next to one another for the simultaneous, independent running of determinations.
3.1.2 Workplace - User interface
Program part: Workplace
Workplace symbol
■■■■■■■■■■■■■■■■■■■■■■
Clicking on the workplace symbol in the vertical bar on the left opens the
Workplace program part while at the same time the workplace symbol is
shown in color. The upper left corner of the symbol contains a black field
displaying the number of workplaces currently opened (see Chapter 3.2.3,page 90).
Elements
The user interface of the Workplace program part comprises the following elements:
■Workplace-specific menu bar.
■Workplace-specific toolbar.
■Main window, in which up to 6 subwindows can be displayed.
3.1.3 Workplace - Menu bar
3.1.3.1
Workplace - Main menus
Program part: Workplace
The menu bar in the Workplace program part contains the following
main menu items:
Changing layout, loading views, saving views, editing properties of
subwindows.
■Tools
Run test, sample tables, sample assignment table, text templates.
■Help
Opening help, showing program info.
3.1.3.2 Workplace - File menu
Program part: Workplace
File
Workplace ▶
3 Workplace
New...
Properties...
Close
Method ▶
Save
Opens a new workplace (see Chapter 3.2.1, page 89).
Edit properties of the selected workplace (see Chapter 3.2.2, page 89).
Closes the selected workplace (see Chapter 3.2.4, page 91).
Saves the method with the modified live parameters (see Chapter 5.2.6, page
388).
Save as...
Save the method with the modified live parameters under a new name (see
Chapter 5.2.6, page 388).
Logout...
Exit
Logs out user (see Chapter 2.2.3, page 20).
Exits the program.
3.1.3.3 Workplace - View menu
Program part: Workplace
View
Change layout...Change the layout of the loaded workplace view (see Chapter 3.1.7.2, page
87).
Load view...
Save view...
Split verticallySplits the workplace window vertically and displays two workplaces side by side
Load a saved workplace view (see Chapter 3.1.7.3, page 88).
Saves the current workplace view (see Chapter 3.1.7.4, page 88).
(see Chapter 3.2.3.3, page 90).
viva 1.1
■■■■■■■■
81
3.1 Workplace - General
Split horizontallySplits the workplace window horizontally and displays two workplaces below
■■■■■■■■■■■■■■■■■■■■■■
each other (see Chapter 3.2.3.4, page 91).
Unsplit
Properties ▶
Properties Run
window
Properties live
display 1
Properties live
display 2
Properties
curves 1
Properties
curves 2
Toolbar
Undoes the splitting of the workplace window (see Chapter 3.2.3.2, page 90).
Sets the properties for the Single determination or Determination series
tabs in the Run subwindow.
Set the properties for the Live display 1 subwindow (see Chapter 3.8.5, page
162).
Set the properties for the Live display 2 subwindow (see Chapter 3.8.5, page
162).
Set the properties for the Curves 1 subwindow (see Chapter 3.9, page 168).
Set the properties for the Curves 2 subwindow (see Chapter 3.9, page 168).
Activates/deactivates the toolbar display.
3.1.3.4 Workplace - Tools menu
Program part: Workplace
Tools
Run test
Sample table ▶
New...
Open...
Manager...
Sample assignment
table...
Text templates...
Carries out start test for determinations (see Chapter 3.6.2, page 116).
Opens a new, empty sample table (see Chapter 3.3.1.1, page 91).
Open a saved sample table (see Chapter 3.3.1.2, page 91).
Manage saved sample tables (see Chapter 3.3.3.1, page 110).
Define sample identifications which can be assigned a certain method (seeChapter 3.4.1, page 113).
Create text templates for sample identification (see Chapter 3.5, page 115).
■■■■■■■■
82
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
3.1.3.5 Help menu
Program part: Workplace / Database / Method / Configuration
3 Workplace
viva Help
About
Opens viva Help.
Displays information about the program and the installation.
3.1.4 Workplace - Toolbar
Program part: Workplace
Opens a new, empty sample table (see Chapter 3.3.1.1, page 91).
Open a saved sample table (see Chapter 3.3.1.2, page 91).
Manage saved sample tables (see Chapter 3.3.3.1, page 110).
Change the layout of the loaded workplace view (see Chapter 3.1.7.2, page
87).
Load a saved workplace view (see Chapter 3.1.7.3, page 88).
Saves the current workplace view (see Chapter 3.1.7.4, page 88).
Carries out start test for determination(s) (see Chapter 3.6.2, page 116).
Splits the workplace window vertically and displays two workplaces side by side
(see Chapter 3.2.3.3, page 90).
Splits the workplace window horizontally and displays two workplaces below
each other (see Chapter 3.2.3.4, page 91).
Undoes the splitting of the workplace window (see Chapter 3.2.3.2, page 90).
Logs out user (see Chapter 2.2.3, page 20).
Opens viva Help.
3.1.5 Workplace - Subwindows
Program part: Workplace
Selection
The following subwindows can be displayed in the main window:
viva 1.1
■■■■■■■■
83
3.1 Workplace - General
■■■■■■■■■■■■■■■■■■■■■■
■Run
Window for controlling runs and entering sample data. This subwindow is permanently on display.
■Method
Displays the currently loaded method.
■Live display 1
Displays live curves, measured values and messages for the ongoing
determination.
■Live display 2
Displays live curves, measured values and messages for the ongoing
determination.
■Curves 1
Displays the voltammograms recorded for the ongoing determination.
■Curves 2
Displays the voltammograms recorded for the ongoing determination.
■Report
Displays reports of recorded determinations.
Display
The subwindows can be enlarged or made smaller to suit by dragging the
separating bar between the windows.
By clicking on the button above at the right, the subwindows can be
maximized so that only one subwindow is displayed in the main window.
The original view of all subwindows is restored when the button is
clicked again in the maximized subwindow.
3.1.6 Workplace - Functions
Program part: Workplace
The following functions can be carried out in the Workplace program
part:
■Creating a workplace
■Editing a workplace
■Selecting a workplace
■Closing a workplace
■■■■■■■■
84
Sample tables
■Creating a sample table
viva 1.1
■■■■■■■■■■■■■■■■■■■■■■
3 Workplace
■Opening a sample table
■Editing a sample table
■Editing sample data
■Saving a sample table
■Printing the sample table
■Defining the sample table properties
■Managing sample tables
Single determination
■Starting/stopping a single determination
■Interrupting/resuming a single determination
■Entering sample data
■Defining properties
Determination series
■Starting/stopping series
■Interrupting/resuming a determination
■Interrupting/resuming a series
■Loading a sample table
■Editing a sample table
■Entering sample data
■Defining properties
Method subwindow
■Zooming
■Modifying parameters live
■Canceling commands
Live display subwindow
■Defining properties
Curves subwindow
■Defining properties
Report subwindow
■Selecting a report
Tools
■Performing a run test
■Editing the sample assignment table
■Defining text templates
viva 1.1
■■■■■■■■
85
3.1 Workplace - General
3.1.7 Views
3.1.7.1 Views - General
Program part: Workplace / Database / Configuration
Definition
The contents and design of the main window in the Workplace, Database and Configuration program parts is called a View. The following
elements belong to a view:
■Number, arrangement, sequence and size of the subwindows.
■Representation within the individual subwindows, i.e. column
sequence, column width, sorting and filter.
Functions
The following functions are possible for views:
■Changing the layout
Defining the number, arrangement and sequence of the subwindows
for the current view.
■Saving a view
Saving the current view.
■Loading a view
Loading a saved view.
■Renaming a view
Renaming a saved view.
■Deleting a view
Deleting a saved view.
■■■■■■■■■■■■■■■■■■■■■■
Saving automatically
The current view will be saved automatically when the program is closed if
the corresponding option is activated under Save on closing in the Con-figuration program part under Tools ▶ Options... on the Save tab.
Loading automatically
By default, the view that is saved when the program is closed will be loaded automatically the next time that the program is opened. As an alternative, a default view that is loaded automatically the first time that the
program part is opened can be defined for each user group.
By default, views are opened with the following subwindows with the
very first program start:
To be able to rename a view, either open the Load view or the Save
view dialog window and click on the [Rename] button. The Rename
view window opens afterwards.
Rename view 'Name' to
■■■■■■■■
88
Entry of a new name for the view.
viva 1.1
Loading...
+ hidden pages
You need points to download manuals.
1 point = 1 manual.
You can buy points or you can get point for every manual you upload.