Auto-validations in firesys: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(5 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Image:EN_Menüband_Excel_Inhalt_Validierungen_Erstellen.jpg|1200px|center
[[Datei:EN_Menüband_Excel_Inhalt_Validierungen_Erstellen.jpg|1200px|center]]


desc none
</imagemap>




Zeile 12: Zeile 10:




== Application Example: Creating an Auto Validation ==
 
 
 
 
== Video: Creating an Auto Validation ==




Zeile 23: Zeile 25:


=== Select value ===
=== Select value ===
[[Datei:EN-Excel Validierung AutoValidierung1.jpg|mini|upright=2.0|Create an auto-validation]]
[[Datei:EN Excel Validierung AutoValidierung Wert-auswählen.jpg|mini|upright=2.0|Create an auto-validation]]


Select the accuracy of the number range you want to search. You can also define whether you want to ignore the symbols and if you want to search the print area only. Select and click “Next”.  
Select the accuracy of the number range you want to search. You can also define whether you want to ignore the symbols and if you want to search the print area only. Select and click “Next”.  
Zeile 47: Zeile 49:
* Very low: A percentage deviation of 0.5% is defined as the deviation.
* Very low: A percentage deviation of 0.5% is defined as the deviation.
* Low: A percentage deviation of 1.0% is defined as the deviation.
* Low: A percentage deviation of 1.0% is defined as the deviation.
* Value: If this option is selected, a user-defined deviation value can be selected in the field below.
* Percent: If this option is selected, a percentage deviation can be specified in the field below.


<b> User-defined value </b>
<b> User-defined value </b>


For “Deviation”, if you selected the entry “Value”, you can define a user-defined deviation value here.  
For “Deviation”, if you selected the entry “Value” or "Percentage", you can define a user-defined deviation value here.  


<b> Absolute values </b>
<b> Absolute values </b>
Zeile 60: Zeile 64:
Here you see the result of the calculation of the values selected under “Operator” and “Factor”.  
Here you see the result of the calculation of the values selected under “Operator” and “Factor”.  


==== Value/result ====
<b> Value/result </b>


The result of the calculation that was performed with the previously selected values.  
The result of the calculation that was performed with the previously selected values.  
Zeile 69: Zeile 73:


== Target selection ==
== Target selection ==
[[Datei:EN-Excel Validierung AutoValidierung3.jpg|mini|upright=2.0|The view of the auto-validation work area]]
[[Datei:Excel Validierung AutoValidierung Validierungen-auswählen.jpg|mini|upright=2.0|The view of the auto-validation work area]]


Select the entries that you would like to search automatically for validations. You can select multiple objects by pressing and holding the control key. Select and click “Next”.  
Select the entries that you would like to search automatically for validations. You can select multiple objects by pressing and holding the control key. Select and click “Next”.  
Zeile 78: Zeile 82:


== Group ==
== Group ==
[[Datei:Excel Validierung AutoValidierung3.jpg|mini|upright=2.0|The view of the auto-validation work area]]
[[Datei:EN Excel Validierung AutoValidierung Gruppe.jpg|mini|upright=2.0|The view of the auto-validation work area]]


You can supplement your auto-validation with additional information:  
You can supplement your auto-validation with additional information:  

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

EN Menüband Excel Inhalt Validierungen Erstellen.jpg


Auto-validations help you search for one or several of the same values in the entire Excel document. The search result can then be validated (multiple selection is possible).

Create an auto-validation





Video: Creating an Auto Validation



A detailed explanation of the individual steps

To create an Auto Validation:

  1. To do this, open the Excel workbook in which you want to create an autovalidation.

  2. Select the desired cell.

  3. Click the "Create" button in the "Validation" group in the "*Content" ribbon.
    → A dialog opens

  4. Select "Autovalidation" in the dialog.
    → A dialog opens in which you can create an autovalidation and configure it according to your requirements.

  5. Make your adjustments.
    → Finally, you can inform yourself about all your validations on the validation sheet.



Create an auto-validation

Select one or more cells in your Excel file and in the “*Validation” menu ribbon, in the “Validation and consistency” group, click on the “Create validation” button and select the “Auto-validation” menu option.

Select value

Create an auto-validation

Select the accuracy of the number range you want to search. You can also define whether you want to ignore the symbols and if you want to search the print area only. Select and click “Next”.


Selection

The cell that is relevant for the auto-validation that was selected previously is displayed here.

Operator

The value of the cells in the auto-validation can be calculated by using a mathematical operator.

Factor

If an operator was selected, you can select the factor of the calculation here.

Deviation

The following predefined deviations exist:

  • None: No deviation of the validation values is defined.
  • Very low: A percentage deviation of 0.5% is defined as the deviation.
  • Low: A percentage deviation of 1.0% is defined as the deviation.
  • Value: If this option is selected, a user-defined deviation value can be selected in the field below.
  • Percent: If this option is selected, a percentage deviation can be specified in the field below.

User-defined value

For “Deviation”, if you selected the entry “Value” or "Percentage", you can define a user-defined deviation value here.

Absolute values

The value of the auto-validation is inserted as an absolute value without a sign.

Intermediate calculation

Here you see the result of the calculation of the values selected under “Operator” and “Factor”.

Value/result

The result of the calculation that was performed with the previously selected values.

Search area

Here you see the search area that was created by the deviation.

Target selection

The view of the auto-validation work area

Select the entries that you would like to search automatically for validations. You can select multiple objects by pressing and holding the control key. Select and click “Next”.

Source selection

You can select the validations you would like to create from the results. To edit multiple objects at once, select these by holding down the shift or control key. Select and click “Next”.

Group

The view of the auto-validation work area

You can supplement your auto-validation with additional information:

Group

You can use the drop-down menu consisting of previously created groups or define your own name for the group, or change an existing one.

Description

Explanatory description of the individual comparison figures.

Comment

Select and click “Next”. The selected validations are created.


Glühbirne neu.png
Good to know

With multiple validations and auto-validations, a maximum of 10 values per entry/search are permitted.


See also

Navigation hoch.svg The validation basic functions
Navigation rechts.svg Create validations
Navigation rechts.svg Create multiple validations
Navigation rechts.svg Edit validation
Navigation rechts.svg Delete validation
Navigation rechts.svg Approve deviations

Further contents

firesys website
Customer area
YouTube