Approve deviation: 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 11: Zeile 11:




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




=== [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|20px]] Approve delta  ===
<b> [[Datei:firesys_Icons_BubbleTransparent_1_white_background.png|link=|20px]] Approve delta  </b>


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


=== [[Datei:firesys_Icons_BubbleTransparent_2_white_background.png|link=|20px]] Approve current values ===
<b> [[Datei:firesys_Icons_BubbleTransparent_2_white_background.png|link=|20px]] Approve current values</b>


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”.
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”.
Zeile 26: Zeile 26:


{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = Approved deviations are no longer listed as “Deviations” on the validation sheet under “Errors in validations”, they are listed as “Approved”.
|Gutzuwissen = Approved deviations are no longer listed as “Deviations” on the validation sheet under “Errors in validations”, they are listed as “Approved”.
Zeile 32: Zeile 32:
}}
}}


== Practical example: Approve a deviation ==
== Video: Approve a deviation ==


{{Vorlage:Video-ValidierungAbweichungEN}}
{{Vorlage:Video-ValidierungAbweichung-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_validations|Create validations]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Create_validations|Create validations]] <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=]]  [[The_validation_worksheet|The validation worksheet]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Delete_validations|Delete validation]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Edit_validations|Edit validations]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Delete_validations|Delete validations]]  <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Update_validations|Update validations]]  <br>


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

Aktuelle Version vom 19. November 2021, 13:19 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”.

Video: 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