Auto-validations in firesys

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen

<imagemap>Image:EN_Excel Menüband Inhalt Validierungen Erstellen.jpg|1200px|center

desc none </imagemap>


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).



Application Example: 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

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.

User-defined value

For “Deviation”, if you selected the entry “Value”, 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

Datei:EN-Excel Validierung AutoValidierung3.jpg
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

Datei:Excel Validierung AutoValidierung3.jpg
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