Approve deviation: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 11: Zeile 11:




[[Datei:EN-Excel Validierung Abweichung-freigeben.jpg|center]]
[[Datei:EN Excel Validierung Abweichung-freigeben.jpg|center]]





Version vom 20. April 2021, 06:54 Uhr

Use this function to approve non-relevant deviations of validations (e.g. in the area after the decimal point which is not displayed). Approved deviations are no longer listed as errors in the vali-dation sheet nor are they marked as errors in the Word tables.

Approve deviation

In order to approve deviations, please do the following:

  • Change to the validation sheet and highlight the validation with a deviation you wish to approve.
  • Select “Approve deviation” in the “Validation and consistency” group on the “*Validation” tab.


In the following dialogue, you can select the following two approval types:


EN Excel Validierung Abweichung-freigeben.jpg


Firesys Icons BubbleTransparent 1 white background.png Approve delta

Use this function if you would like to release a specific number range. The current deviation will then be directly recommended as delta. All values within this range automatically receive ap-proval.

Firesys Icons BubbleTransparent 2 white background.png Approve current values

Use this option to approve the current values as a deviation. The validation will be listed as a de-viation again, even if a value has only changed slightly. You can also add a comment and con-firm the dialogue with “OK”.

The deviation is approved and the respective information on the validation is shown as an Excel comment. This contains a date stamp, user information and the release value (Delta).


Glühbirne neu.png
Good to know

Approved deviations are no longer listed as “Deviations” on the validation sheet under “Errors in validations”, they are listed as “Approved”.

Practical example: Approve a deviation


A detailed explanation of the individual steps

To approve deviations from validations:

  1. Click on the purple arrow in Excel in the group "firesys" to switch to the validation sheet

  2. On the validation sheet, select the validation for which you want to approve a deviation.
    → A dialogue window opens

  3. Click on the "Edit" function in the "Validations" group in the "*Contents" menu band. Select the "approve deviation" option here.

  4. A dialog box opens, in which you can now enter the new delta value to determine the maximum deviation. Optionally, you can check the current values or add a comment to the approved validation.

  5. .
  6. Confirm the change with a final click on "Ok".


  7. For control:
    The validation value previously highlighted in red now changes to the step color black. Additionally, you can move the mouse over the red triangle on the right above the value. The information about the time, the author and the values of the approved validation will be displayed here.

See also

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

Further contents

firesys website
Customer area
YouTube