Create validations: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(15 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
[[Datei:EN_Menüband_Excel_Inhalt_Validierungen_Erstellen.jpg|1200px|center]]
You can compare two numbers from one Excel document. You can allocate these to a group and display them in the comparison sheet in a clear overview.  
You can compare two numbers from one Excel document. You can allocate these to a group and display them in the comparison sheet in a clear overview.  


Zeile 4: Zeile 9:


=== Selection of validation values ===
=== Selection of validation values ===
[[Datei:Excel_Validierung-Einzel-Validierung.jpg|mini|upright=2.0|The work area of the validations]]
[[Datei:EN Excel Validierung Einzel-Validierung.jpg|mini|upright=2.0|The work area of the validations]]


==== Select a value ====
<b>Select a value </b>


[[Datei:Image.Cell.SelectCell.16.png|16px|link=]] Transfer value from cell: The value from the currently selected Excel cell is transferred as the validation value if it is a numerical value.  
[[Datei:Image.Cell.SelectCell.16.png|16px|link=]] Transfer value from cell: The value from the currently selected Excel cell is transferred as the validation value if it is a numerical value.  


[[Datei:Image.Cell.SelectMasterCell.16.png|16px|link=]] Use value from MeetingPoint: This opens a dialog with which you can transfer an existing master value as the validation value. 


[[Datei:Image.Cell.AccountValue.16.png|16px|link=]] Select account value: This opens a dialog with which you can transfer an account value from the master value manager as the validation value.
<b> Options </b>
 
 
[[Datei:Image.Cell.SelectMasterCell.16.png|16px|link=]] Select the transmitter value or manual value: this opens a dialog with which you can transfer an existing master value as the validation value. 
 
==== Options ====


The underlying data source of the respective validation value is displayed in the “Selection” field. You will be informed if you have not yet selected anything.  
The underlying data source of the respective validation value is displayed in the “Selection” field. You will be informed if you have not yet selected anything.  


==== Operator ====
<b> Operator </b>


You can define the mathematical operator multiplication or division for your validation value.  
You can define the mathematical operator multiplication or division for your validation value.  


==== Factor ====
<b> Factor </b>


If you have selected an operator, you can select the decimal powers 1,000/1,000,000 or 1,000,000,000 as the factor for calculating your validation of firesys.  
If you have selected an operator, you can select the decimal powers 1,000/1,000,000 or 1,000,000,000 as the factor for calculating your validation of firesys.  


==== Intermediate calculation ====
<b> Intermediate calculation </b>


The previously configured calculation of the validation value is displayed written out in an intermediate calculation.  
The previously configured calculation of the validation value is displayed written out in an intermediate calculation.  


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


Here you always see the current calculation of the previously selected validation and the corresponding operator and factor.  
Here you always see the current calculation of the previously selected validation and the corresponding operator and factor.  
Zeile 38: Zeile 39:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = With an individual calculation, you cannot select an identical cell for “Value 1” and “Value 2”.
|Gutzuwissen = With an individual calculation, you cannot select an identical cell for “Value 1” and “Value 2”.
Zeile 45: Zeile 46:
}}
}}


=== Operator/factor ===
The operator/factor enables values of different units to be validated.
The division or multiplication with the factor thousand, millions and billions is available for selection. To improve transparency, the intermediate calculation is also displayed in the dialogue.


=== Absolute values ===
=== Absolute values ===
Zeile 60: Zeile 55:
Supplement your validation with additional valuable information:  
Supplement your validation with additional valuable information:  


====  Group ====
<b>Group</b>


Validations in firesys must always be assigned to a group. The groups serve to assign the various validations precisely and are the central sorting key on the validation worksheet. You can add new groups or edit and delete existing ones at any time.  
Validations in firesys must always be assigned to a group. The groups serve to assign the various validations precisely and are the central sorting key on the validation worksheet. You can add new groups or edit and delete existing ones at any time.  
Zeile 66: Zeile 61:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen =  When you create or edit a validation, if you enter and confirm a group name that is already being used, both validation groups can be combined into a group. However, this step cannot be reversed.   
|Gutzuwissen =  When you create or edit a validation, if you enter and confirm a group name that is already being used, both validation groups can be combined into a group. However, this step cannot be reversed.   
Zeile 72: Zeile 67:
}}
}}


==== Description ====
 
<b>Description</b>


Here you can provide a description containing explanatory, additional information about the validation.  
Here you can provide a description containing explanatory, additional information about the validation.  
Zeile 78: Zeile 74:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = Starting from the selected cell, firesys automatically searches for a description and proposes this in the corresponding field.
|Gutzuwissen = Starting from the selected cell, firesys automatically searches for a description and proposes this in the corresponding field.
Zeile 84: Zeile 80:
    
    


====  Comment ====
<b>Comment</b>


You can add a comment on the current validation here.  
You can add a comment on the current validation here.  
Zeile 98: Zeile 94:
[[Datei:Image-Common-ArrowRight.png|16px|link=]] Next hit: Use the arrows to start the search and navigate through the individual hits and to the next hit.  
[[Datei:Image-Common-ArrowRight.png|16px|link=]] Next hit: Use the arrows to start the search and navigate through the individual hits and to the next hit.  


== Case study: create a validation ==
== Video: Create a validation ==


{{Vorlage:Video-Validierung erstellen}}
{{Vorlage:Video-Validierung erstellen-English}}


== See also ==
== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[The_validation_basic_functions|An overview of the validation functions]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[The_validation_basic_functions|The validation basic functions]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Create_multiple_validations|Create multiple validations]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Create_multiple_validations|Create multiple validations]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Auto-validations_in_firesys|Create auto-validations]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Auto-validations_in_firesys|Auto-validations in firesys]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Edit_validations|Edit validation]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Edit_validations|Edit validation]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Delete_validations|Delete validation]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Delete_validations|Delete validation]]  <br>

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

EN Menüband Excel Inhalt Validierungen Erstellen.jpg



You can compare two numbers from one Excel document. You can allocate these to a group and display them in the comparison sheet in a clear overview.

Create a validation

Selection of validation values

The work area of the validations

Select a value

Image.Cell.SelectCell.16.png Transfer value from cell: The value from the currently selected Excel cell is transferred as the validation value if it is a numerical value.

Image.Cell.SelectMasterCell.16.png Use value from MeetingPoint: This opens a dialog with which you can transfer an existing master value as the validation value.

Options

The underlying data source of the respective validation value is displayed in the “Selection” field. You will be informed if you have not yet selected anything.

Operator

You can define the mathematical operator multiplication or division for your validation value.

Factor

If you have selected an operator, you can select the decimal powers 1,000/1,000,000 or 1,000,000,000 as the factor for calculating your validation of firesys.

Intermediate calculation

The previously configured calculation of the validation value is displayed written out in an intermediate calculation.

Value/result

Here you always see the current calculation of the previously selected validation and the corresponding operator and factor.


Glühbirne neu.png
Good to know

With an individual calculation, you cannot select an identical cell for “Value 1” and “Value 2”.


Absolute values

Create validations without taking the sign of the selected values into account.

Additional information

Supplement your validation with additional valuable information:

Group

Validations in firesys must always be assigned to a group. The groups serve to assign the various validations precisely and are the central sorting key on the validation worksheet. You can add new groups or edit and delete existing ones at any time.


Glühbirne neu.png
Good to know

When you create or edit a validation, if you enter and confirm a group name that is already being used, both validation groups can be combined into a group. However, this step cannot be reversed.


Description

Here you can provide a description containing explanatory, additional information about the validation.


Glühbirne neu.png
Good to know

Starting from the selected cell, firesys automatically searches for a description and proposes this in the corresponding field.


Comment

You can add a comment on the current validation here.

Search for terms

Here you can search all worksheets for a term with the following options:

Image.Cell.MatchAll.16.png Compare entire content of cells: The option “Compare entire content of cells” enables you to limit the search further. Example: When searching for the term “EBITDA”, firesys finds all cells in which the term “EBITDA” is used. The term “EBITDA” + the option (“Compare entire content of cells”) only finds cells containing exclusively “EBITDA”.

Image-Common-ArrowLeft.png Previous hit: Use the arrows to start the search and navigate through the individual hits and to the previous hit.

Image-Common-ArrowRight.png Next hit: Use the arrows to start the search and navigate through the individual hits and to the next hit.

Video: Create a validation


A detailed explanation of the individual steps

This is how you insert a new validation in Excel:

  1. Click on the “Create validation” button in the “*Validation” menu ribbon in the “Validation and consistency” group
    → A selection dialog opens, displaying the various validation types.

  2. Select the “Single validation” function here.
    → Your Excel worksheet is extended with the validation work area.

  3. Use the mouse cursor to select the cell for which the validation should be created and in the “Value 1” range, click on “Transfer value from cell”.

  4. Now select the cell in your Excel workbook that contains the second value of the validation and in the “Select value 2” range, click on “Transfer value from cell”.

  5. Click “OK” to confirm the prompt.
    → An information dialog confirms that the validation was created.

  6. You can then use the “Go to validation worksheet” function to open the validation worksheet.
    → your validation is displayed.

See also

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

Further contents

firesys website
Customer area
YouTube