The validation basic functions: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (26 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Datei:EN_Menüband_Excel_Inhalt_Validierungen.jpg|1200px|center]] | |||
| Zeile 45: | Zeile 32: | ||
</div> | </div> | ||
| style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | ||
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:Auto-Validierung.png|link=Auto-validations_in_firesys]] [[Auto-validations_in_firesys|Auto-validations]]</div> | <div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:Auto-Validierung.png|link=Auto-validations_in_firesys]] [[Auto-validations_in_firesys|Auto-validations in firesys]]</div> | ||
<!--<div style="text-align:center;"> --> | <!--<div style="text-align:center;"> --> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Auto-validations_in_firesys]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Auto-validations_in_firesys]]--> | ||
With an auto-validation you can search your Excel file for additional occurrences of the selected number. Multiple selection of up to 10 cells is possible. <small>'''[[Auto-validations_in_firesys|more]]'''</small> | With an auto-validation you can search your Excel file for additional occurrences of the selected number. Multiple selection of up to 10 cells is possible. <small>'''[[Auto-validations_in_firesys|more]]'''</small> | ||
----- | ----- | ||
| Zeile 56: | Zeile 42: | ||
| style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | | style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | ||
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------> | <!-- ABS.1: Linke Spalte ------------------------------------------------------------------------> | ||
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei: | <div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:Validierungsblatt.png|link=The validation worksheet]] [[The_validation_worksheet|The validation worksheet]]</div> | ||
<!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Edit_validations]]--> | |||
With the validation sheet you have the possibility to compare "pairs of numbers" with each other and thus check for validation and consistency. The pairs of numbers are clearly summarized on the validation sheet, deviations are additionally displayed. <small>'''[[The_validation_worksheet|more]]'''</small> | |||
----- | ----- | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | ||
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellDeleteRow_32.png|link=Delete validations]] [[Delete validations| | <div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellEditValidationEntry_32.png|link=Edit_validations]][[Edit_validations|Edit]],[[Datei:rxbtnCellDeleteRow_32.png|link=Delete validations]] [[Delete validations|delete]] and [[Datei:RxbtnCellCreateUpdateCompare 32.png|link=Update_validations]] [[Update_validations|update validations]]</div> | ||
<div style="text-align:center;"> | <div style="text-align:center;"> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Delete validations]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Delete validations]]--> | ||
It is also possible to edit, update and delete created validations later. Here firesys offers you fast accessible tools. <small>'''[[Update_validations|more]]'''</small> | |||
----- | ----- | ||
</div> | </div> | ||
<br /> | <br /> | ||
| style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | | style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | ||
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellReleaseDeviation_32.png|link= | <div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnCellReleaseDeviation_32.png|link=Approve_deviation]] [[Approve_deviation|Approve deviations]]</div> | ||
<!--<div style="text-align:center;"> --> | <!--<div style="text-align:center;"> --> | ||
[[Datei:Dummybild.jpeg|left|175px|link= | <!-- [[Datei:Dummybild.jpeg|left|175px|link=Approve_deviation]]--> | ||
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 validation sheet nor are they marked as errors in the Word tables. <small>'''[[Approve_deviation|more]]'''</small> | |||
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 validation sheet nor are they marked as errors in the Word tables. <small>'''[[ | |||
---- | ---- | ||
| Zeile 86: | Zeile 69: | ||
|} | |} | ||
== See also == | |||
[[Datei:Navigation_hoch.svg|link=]] [[Maintain_Excel_contents|Maintain Excel contents]] <br> | |||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] | [[Datei:Navigation_rechts.svg|link=]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] | [[Datei:Navigation_rechts.svg|link=]] [[Insert_values_in_Excel|Insert values in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] | [[Datei:Navigation_rechts.svg|link=]] [[An_overview_of_the_rolling_forward_function|An overview of the rolling forward function]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Automated_worksheet|Automated worksheet]] <br> | ||
{{MoreContent}} | {{MoreContent}} | ||
[[Kategorie:Excel Dokument- | [[Kategorie:English-Excel Dokument-Zentralwerte-Übersicht]] | ||
Aktuelle Version vom 19. November 2021, 13:10 Uhr
| |||||
|
With the help of a single validation you can create a new validation whereby two individual values are related to each other. more
|
With the help of a multiple validation you can create a new validation whereby you can summarise several values in formulas. This enables you to validate related values in one step. more |
With an auto-validation you can search your Excel file for additional occurrences of the selected number. Multiple selection of up to 10 cells is possible. more | |||
|
With the validation sheet you have the possibility to compare "pairs of numbers" with each other and thus check for validation and consistency. The pairs of numbers are clearly summarized on the validation sheet, deviations are additionally displayed. more
|
It is also possible to edit, update and delete created validations later. Here firesys offers you fast accessible tools. more
|
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 validation sheet nor are they marked as errors in the Word tables. more | |||
See also
Maintain Excel contents
Data import
The functions of the master value manager
Insert values in Excel
An overview of the rolling forward function
Automated worksheet