Insert values in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
Zeile 1: Zeile 1:
<imagemap>Datei:Excel Menüband Inhalt Einfügen Andere-Werte.jpg|center|1200px
<imagemap>Image:EN_Excel_Menüband_Inhalt_Kontomappe_Zentralwerte.jpg|1200px|center
rect 1 79 208 191 [[Die_Basisfunktionen_von_firesy]]
rect 2 85 204 193 [[The_basic_functions_of_firesys]]
rect 212 78 283 190 [[Die_Kontenmappe]]
rect 211 82 515 192 [[The_account_workbook]]
rect 287 77 365 189 [[Arbeit_mit_Zentralwerten]]
rect 522 82 612 192 [[The_functions_of_the_master_value_manager]]
rect 371 76 513 108 [[Die_Kontenmappe#Kontenmappen_sortieren]]
rect 614 81 698 191 [[Synchronise_and_detach]]
rect 372 110 512 139 [[Die_Kontenmappe#Zeilen_l.C3.B6schen]]
rect 884 82 1041 184 [[The_validation_basic_functions]]
rect 373 140 510 171 [[Die_Kontenmappe#Der_Kontowert-Verlauf]]
rect 702 114 879 136 [[Synchronise_and_detach]]
rect 535 83 623 190 [[Der_Zentralwert-Manager]]
rect 702 140 880 168 [[Insert_transmitter_values]]
rect 626 82 731 191 [[Werte_synchronisieren_und_lösen]]
rect 705 81 878 110 [[Insert_values_in_Excel]]
rect 735 83 888 112 [[Werte_in_Excel_einfügen]]
rect 1046 83 1181 190 [[An_overview_of_the_rolling_forward_function]]
rect 733 112 888 135 [[Werte_synchronisieren_und_lösen#Werte_l.C3.B6sen]]
rect 736 135 888 169 [[Senderwerte_einfügen]]
rect 894 81 991 188 [[Das_Validierungsblatt]]
rect 998 80 1122 110 [[Validierungen_erstellen]]
rect 996 112 1118 137 [[Validierung_bearbeiten]]
rect 995 141 1118 176 [[Validierung_löschen]]
rect 1132 81 1287 190 [[Die_Vorrollen_Funktionen_in_der_Übersicht]]
desc none
desc none
</imagemap>
</imagemap>

Version vom 22. April 2020, 07:20 Uhr

<imagemap>Image:EN_Excel_Menüband_Inhalt_Kontomappe_Zentralwerte.jpg|1200px|center rect 2 85 204 193 The_basic_functions_of_firesys rect 211 82 515 192 The_account_workbook rect 522 82 612 192 The_functions_of_the_master_value_manager rect 614 81 698 191 Synchronise_and_detach rect 884 82 1041 184 The_validation_basic_functions rect 702 114 879 136 Synchronise_and_detach rect 702 140 880 168 Insert_transmitter_values rect 705 81 878 110 Insert_values_in_Excel rect 1046 83 1181 190 An_overview_of_the_rolling_forward_function desc none </imagemap>

Excel Funktionen 64.png
Insert values in Excel

With version 20.1., firesys is offering you a way of inserting numerical values from the MeetingPoint into your Excel document. You can use these numbers as the basis of additional operations.

Excel Funktionen 64.png

A transmitter value contains a numerical value which is found at a different location in the workbook, or in a different Excel workbook (transmitter values cannot be created on workbooks that are created by firesys). more


A manual value is a data record in the firesys MeetingPoint that contains a numerical value and a name and can be created directly in the firesys menu ribbon. more


An account value is a master value in firesys that can be written to the MeetingPoint via the account workbook and has a high level of integrity as a result of the key date reference. more



An account calculation consists of the mathematical addition/subtraction of several account values. more


The constant integrity of your data is a fundamental element of firesys. It should be possible to update even cross-file document structures through their connection to the firesys MeetingPoint just by pressing a button. more


In addition to inserting and synchronising master values, there are additional tools in firesys that can facilitate working with or managing master values. more


See also

Navigation hoch.svg Maintain Excel contents
Navigation rechts.svg The account workbook
Navigation rechts.svg The functions of the master value manager
Navigation rechts.svg The validation basic functions
Navigation rechts.svg An overview of the roll forward functions

Further contents

firesys website
Customer area
YouTube