Additional functions in the master value manager: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(18 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Datei:EN-Excel Validierung Zentralwert-Manager Menü.jpg|1200px|center
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Zentralwert-Manager.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_Zentralenwerten]]
rect 961 79 1045 193 [[Arbeit_mit_Senderwerten]]
rect 1052 81 1364 194 [[Die_Kontenmappe]]
desc none
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
</imagemap>




Zeile 25: Zeile 18:




[[Datei:EN Excel Validierung Zentralwert-Manager Liste-Arbeitsmappen.jpg|center|600px]]
[[Datei:EN Excel Validierung Liste-Arbeitsmappen.jpg|center|600px]]




Zeile 31: Zeile 24:




[[Datei:EN Excel Validierung-Verbundene-ArbeitsmappInfo.jpg|center|600px]]
[[Datei:EN Excel Validierung Verbundene-Arbeitsmappen Info.jpg|center|600px]]




Zeile 43: Zeile 36:
}}
}}


=== [[Datei:rxbtnCellMultiCompareShowInXlsUsedCells_16.png|link=|16px]] List recipient cells ===
=== [[Datei:Zentralwerte.png|link=|16px]] Linked master values ===
 
Lists all master values of this Excel file which are used in cross-file validations. You can display additional information for each entry and use the search to quickly find the recipient cell you are looking for.


Lists all master values that are used in your workbook. The individual master values are shown categorised by their respective master value types. Use the “Expand all” or “Collapse all” functions to navigate in the list area more quickly or to obtain information about the individual entries.


[[Datei:Excel Validierung Empfängerzellen-anzeigen.jpg|center|600px]]


Each individual master value is displayed as a list entry and contains information about the name of the Excel worksheet in which the master value occurs (in this example, “Overview P&L” and subsequently the position of the individual cells (such as cells “E21” or “E22”)


=== [[Datei:rxbtnCellMultiCompareShowServerCells_16.png|link=|16px]] List transmitter values ===


Lists all central values of this Excel file which are available for cross-file validations in the MeetingPoint. Here you can display all information about the respective transmitter values and edit the description and comment relating to the transmitter values.


 
[[Datei:EN_Excel_Werte-einfügen_ÜbersichtVerbundeneZentralwerte.jpg|center|800px]]
[[Datei:EN Excel Validierung Senderwerte-anzeigen.jpg|center|600px]]




Zeile 64: Zeile 53:




[[Datei:EN-Excel Validierung Zentralwert-Manager Archivmappe-erstellen.jpg|center|500px]]
[[Datei:EN Excel Validierung Archivmappe-erstellen.jpg|center|400px]]




Zeile 72: Zeile 61:




[[Datei:EN-Excel Validierung Zentralwert-Manager Archivmappe-zurückschreiben.jpg|center|400px]]
[[Datei:EN Excel Validierung Archivmappe-zurückschreiben.jpg|center|400px]]




Zeile 82: Zeile 71:


== See also ==
== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[Übersicht_Zentralwert-Manager|An overview of all functions of master values]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Der Zentralwert-Manager|The master value manager in firesys]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[The_master_value_manager|The master value manager]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Arbeit_mit_Zentralwerten|Working with master values in firesys]] <br>
 
[[Datei:Navigation_rechts.svg|link=]]  [[Arbeit_mit_Senderwerten|Working with transmitter values in firesys]] <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-Zentralwerte-Content]]
[[Kategorie:English-Excel Dokument-Zentralwerte-Content]]

Aktuelle Version vom 19. November 2021, 12:58 Uhr

EN Menüband Excel Inhalt Zentralwerte Zentralwert-Manager.jpg



Additional functions in the master value manager

The view of the extended options in the master value manager

RxbtnCellManagerDo 16.png Master value manager

→ An overview of the functions of the master value manager

Open the master value manager and manage the values which were prepared in the MeetingPoint.

RxbtnCellShowConnectedWorkbooks 16.png Linked workbooks

Lists all linked Excel workbooks which also validate with master values and/or make master values available for cross-file validations for the MeetingPoint. Here you can open the respective files or open them as write-protected and use the search function to quickly find the Excel workbook you are looking for.


EN Excel Validierung Liste-Arbeitsmappen.jpg


If one or more Excel workbooks are no longer available, or if they have been renamed or moved, an information icon is displayed.


EN Excel Validierung Verbundene-Arbeitsmappen Info.jpg


You can now use the “Remove from list” function to remove the relevant workbooks from the list.


Glühbirne neu.png
Good to know

If links to Excel workbooks with cross-file validations have got lost, the original path of the file is always displayed in the list area.

Zentralwerte.png Linked master values

Lists all master values that are used in your workbook. The individual master values are shown categorised by their respective master value types. Use the “Expand all” or “Collapse all” functions to navigate in the list area more quickly or to obtain information about the individual entries.


Each individual master value is displayed as a list entry and contains information about the name of the Excel worksheet in which the master value occurs (in this example, “Overview P&L” and subsequently the position of the individual cells (such as cells “E21” or “E22”)


EN Excel Werte-einfügen ÜbersichtVerbundeneZentralwerte.jpg


RxbtnCellAccountValues 9 16.png Create archive workbook

Here you can create a workbook out of the MeetingPoint. The required account group can be listed with all accounts and values for a selected key date. Optionally, you can specify whether the information should be automatically saved in the MeetingPoint.


EN Excel Validierung Archivmappe-erstellen.jpg


RxbtnCellAccountValues 7 16.png Write back archive workbook

Writes this archive workbook back to the MeetingPoint. This restores all accounts and values for a key date.


EN Excel Validierung Archivmappe-zurückschreiben.jpg


The “Write back” function, which writes back the archive workbook to the MeetingPoint and the “Status update” function are available for checking whether the changes made can be transferred.

RxbtnCellRemoveToolsValidation 16.png Remove toolsvalidation components

Removes all components that are required for toolsvalidation from the current workbook.

See also

Navigation hoch.svg The functions of the master value manager
Navigation rechts.svg The master value manager


Further contents

firesys website
Customer area
YouTube