|
|
| Zeile 28: |
Zeile 28: |
| 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>'''[[Additional_functions_in_the_master_value_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>'''[[Additional_functions_in_the_master_value_manager|more]]'''</small> |
| ----- | | ----- |
|
| |
| | 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:rxbtnCellMultiUpdate_32.png|link=Working_with_master_values]] [[Working_with_master_values|Working with master values]]</div>
| |
|
| |
| <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Working_with_master_values]]-->
| |
| 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>'''[[Working_with_master_values|more]]'''</small>
| |
| -----
| |
| </div>
| |
| <br />
| |
| |-
| |
| |
| |
| | 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:rxbtnCellMultiCompareNewDbCell_32.png|link=Insert_transmitter_values]] [[Insert_transmitter_values|Insert transmitter values]]</div>
| |
|
| |
| <!-- [[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_transmitter_values]]-->
| |
| Transmitter values are numbers (master values) that are made available to the MeetingPoint from Excel files for cross-file validations. <small>'''[[Insert_transmitter_values|more]]'''</small>
| |
| -----
| |
| |
| |
|
| |
|
| |} | | |} |
Version vom 17. März 2021, 13:57 Uhr
<imagemap>Image:EN_Excel_Menüband_Inhalt_Zentralwerte.jpg|1200px|center
desc none
</imagemap>
|
|
The functions of the master value manager
If you use the full functional scope of the master value manager, you can compare figures with each other across files. This means you can professionalise the integrity of your data records.
|
|
|
|
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
|
See also
Maintain Excel contents
Data import
Insert values in Excel
The validation basic functions
An overview of the rolling forward function
Automated worksheet
Further contents
→ firesys website
→ Customer area
→ YouTube
