The validation worksheet
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”.
<imagemap>Datei:EN-Excel Validierung Menüband Grundfunktionen.jpg|1200px|center| rect 2 86 215 197 Die_Basisfunktionen_von_firesys rect 224 88 323 199 Das_Validierungsblatt rect 333 88 785 197 Übersicht_Validierungen rect 791 90 886 198 Übersicht_Zentralwert-Manager rect 890 90 977 199 Arbeit_mit_Zentralwerten rect 979 90 1061 198 Arbeit_mit_Senderwerten rect 1072 90 1175 196 Die_Kontenmappe rect 1178 87 1382 115 Die_Kontenmappe#Kontenmappen_sortieren rect 1179 118 1382 144 Die_Kontenmappe#Zeilen_l.C3.B6schen rect 1178 149 1382 175 Die_Kontenmappe#Der_Kontowert-Verlauf
desc none </imagemap>
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.
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.
 |
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.
|
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.
|
Good to know
|
|---|---|
A validation comment can contain up to 255 characters. After the 256th character, all entries are truncated. |
See also
An overview of all validation functions in Excel
An overview of all validation basic functions
The firesys account workbook
The master value manager