The validation worksheet

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen

The validation worksheet is the central overview element of all firesys validations in Excel. You see all important information at a glance and can display the validation worksheet ay any time from any firesys menu ribbon by choosing the lilac-coloured arrow with the function “Switch to validation worksheet”. In addition, you can display the master value history for a number within a validation on the validation sheet.

EN Menüband Excel Inhalt Validierungen Aktualisieren.jpg


View of the validation worksheet

The validation worksheet is automatically created by firesys as soon as you create validations in your document. The worksheet is placed in the tab at the start of your document and you can access the validation worksheet at any time by using the purple arrow in the “*firesys” group in all firesys menu ribbons.

Excel Validierung Validierungsblatt.jpg


General information and statistics

In the header of the validation worksheet, you will find the following informations:

Update information on the validation

You see when the “Update validation worksheet” function was last executed and which user performed the update.

An overview of existing groups and comparison figures

You see at a glance how many (validation) groups and validations you are currently using in your document.

A list of all advanced validation information

You can see current validation errors and deviations at a glance. Should any errors and/or deviations occur, the indicative number is formatted in bold and red font. All approved deviations and missing values are also displayed.

An overview of validations

Detailed information on defined groups and comparison figures. By clicking on an entry in the information column you navigate to it and select it.

Group

All available groups are displayed in a column.


Glühbirne neu.png
Good to know

The information on the validation worksheet is sorted alphabetically using the group names that were assigned.


Name

If you specified a name when you created or edited a validation, it is displayed in this column.

Value & info

The validation value that was assigned is displayed here under “Value 1” and “Value 2”. “Info” displays the name of the worksheet and the cell containing the respective validation value.


Glühbirne neu.png
Good to know

If you have specified several validations for value 1 or value 2 (for example in a multiple validation), all values and info that were assigned to value 1 or value 2 are displayed here.


ABS

This abbreviation stands for “absolute values”. Here you see whether absolute values have been compared.

Deviation

If the available validations contain deviations, the deviation value is displayed here and in the next column you also see a graphical visualisation showing the deviation’s trend in arrow form.

Comment

If you have assigned a comment, the text is displayed here.


Glühbirne neu.png
Good to know

A validation comment can contain up to 255 characters. After the 256th character, all entries are truncated.

See also

Navigation hoch.svg Validations in Excel
Navigation rechts.svg The validation basic functions
Navigation rechts.svg The account workbook
Navigation rechts.svg The master value manager

Further contents

firesys website
Customer area
YouTube