The functions of the master value manager: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 24: | Zeile 24: | ||
<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:rxbtnCellManagerDo_32.png|link=Der_Zentralwert-Manager]] [[Der_Zentralwert-Manager|The master value manager interface]]</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:rxbtnCellManagerDo_32.png|link=Der_Zentralwert-Manager]] [[Der_Zentralwert-Manager|The master value manager interface]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Der_Zentralwert-Manager]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Der_Zentralwert-Manager]]--> | ||
The “control centre” for all master values. Keep an overview of which master values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. <small>'''[[Der_Zentralwert-Manager|more]]'''</small> | The “control centre” for all master values. Keep an overview of which master values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. <small>'''[[Der_Zentralwert-Manager|more]]'''</small> | ||
---- | ---- | ||
| Zeile 31: | Zeile 31: | ||
<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:Zentralwert_Funktionen_32.png|link=Weitere_Funktionen_Zentralwert-Manager]] [[Weitere_Funktionen_Zentralwert-Manager|Additional functions in the master value manager]]</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:Zentralwert_Funktionen_32.png|link=Weitere_Funktionen_Zentralwert-Manager]] [[Weitere_Funktionen_Zentralwert-Manager|Additional functions in the master value manager]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Weitere_Funktionen_Zentralwert-Manager]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Weitere_Funktionen_Zentralwert-Manager]]--> | ||
The “Master value manager” button has two action areas. In the lower area there is a menu with additional functions for managing the master values and displaying additional information. You can also create and write back archive workbooks. <small>'''[[Weitere_Funktionen_Zentralwert-Manager|more]]'''</small> | The “Master value manager” button has two action areas. In the lower area there is a menu with additional functions for managing the master values and displaying additional information. You can also create and write back archive workbooks. <small>'''[[Weitere_Funktionen_Zentralwert-Manager|more]]'''</small> | ||
----- | ----- | ||
| Zeile 39: | Zeile 38: | ||
<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:rxbtnCellMultiUpdate_32.png|link=Arbeit_mit_Zentralwerten]] [[Arbeit_mit_Zentralwerten|Working with master values]]</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:rxbtnCellMultiUpdate_32.png|link=Arbeit_mit_Zentralwerten]] [[Arbeit_mit_Zentralwerten|Working with master values]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Arbeit_mit_Zentralwerten]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Arbeit_mit_Zentralwerten]]--> | ||
Master values are all values in the MeetingPoint that can be used for performing cross-file validations. They can be made available from transmitter files or entered in the MeetingPoint as manual values via the master value manager. <small>'''[[Arbeit_mit_Zentralwerten|more]]'''</small> | Master values are all values in the MeetingPoint that can be used for performing cross-file validations. They can be made available from transmitter files or entered in the MeetingPoint as manual values via the master value manager. <small>'''[[Arbeit_mit_Zentralwerten|more]]'''</small> | ||
----- | ----- | ||
| Zeile 50: | Zeile 48: | ||
<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:rxbtnCellMultiCompareNewDbCell_32.png|link=Arbeit_mit_Senderwerten]] [[Arbeit_mit_Senderwerten|Working with transmitter values]]</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:rxbtnCellMultiCompareNewDbCell_32.png|link=Arbeit_mit_Senderwerten]] [[Arbeit_mit_Senderwerten|Working with transmitter values]]</div> | ||
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Arbeit_mit_Senderwerten]] | <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Arbeit_mit_Senderwerten]]--> | ||
Transmitter values are numbers (master values) that are made available to the MeetingPoint from Excel files for cross-file validations. <small>'''[[Arbeit_mit_Senderwerten|more]]'''</small> | Transmitter values are numbers (master values) that are made available to the MeetingPoint from Excel files for cross-file validations. <small>'''[[Arbeit_mit_Senderwerten|more]]'''</small> | ||
----- | ----- | ||
Version vom 12. Dezember 2019, 09:54 Uhr
<imagemap>Datei:Excel Validierung Zentralwert-Manager Menü.jpg|1200px|center rect 2 79 211 195 Die_Basisfunktionen_von_firesys rect 222 81 771 197 Übersicht_Validierungen rect 780 81 861 134 Der_Zentralwert-Manager rect 783 137 863 190 Einstellungen_Zentralwert-Manager rect 872 83 957 194 Arbeit_mit_Zentralwerten rect 961 79 1045 193 Arbeit_mit_Senderwerten rect 1052 81 1364 194 Die_Kontenmappe desc none
</imagemap>
| |||||
|
The “control centre” for all master values. Keep an overview of which master values are stored in the MeetingPoint. Here you can also create manual values and use these for cross-file validations later on. more |
The “Master value manager” button has two action areas. In the lower area there is a menu with additional functions for managing the master values and displaying additional information. You can also create and write back archive workbooks. more |
Master values are all values in the MeetingPoint that can be used for performing cross-file validations. They can be made available from transmitter files or entered in the MeetingPoint as manual values via the master value manager. more
| |||
|
Transmitter values are numbers (master values) that are made available to the MeetingPoint from Excel files for cross-file validations. more |
|||||
See also
The firesys functions in Excel
The layout functions in Excel
Translations in Excel
The worksheet status