The validation worksheet: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(10 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
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”.  
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.
 
[[Datei:EN_Menüband_Excel_Inhalt_Validierungen_Aktualisieren.jpg|1200px|center]]


<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]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
desc none
</imagemap>




Zeile 50: Zeile 38:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = The information on the validation worksheet is sorted alphabetically using the group names that were assigned.
|Gutzuwissen = The information on the validation worksheet is sorted alphabetically using the group names that were assigned.
Zeile 66: Zeile 54:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = 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.
|Gutzuwissen = 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.
Zeile 87: Zeile 75:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = A validation comment can contain up to 255 characters. After the 256th character, all entries are truncated.  
|Gutzuwissen = A validation comment can contain up to 255 characters. After the 256th character, all entries are truncated.  
Zeile 94: Zeile 82:


== See also ==
== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[Validations_in_Excel|An overview of all validation functions in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Validations_in_Excel|Validations in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_validation_basic_functions|An overview of all validation basic functions]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_validation_basic_functions|The validation basic functions]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_account_workbook|The firesys account workbook]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_account_workbook|The account workbook]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_master_value_manager|The master value manager]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_master_value_manager|The master value manager]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]]
[[Kategorie:English-Excel Dokument-Validierungen-Contentebene]]

Aktuelle Version vom 19. November 2021, 13:17 Uhr

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