Insert values in Excel: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 39: | Zeile 39: | ||
| style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | | style="width: 30%"|<!-- ABSCHNITT 1 -------------------------------------------------------------------------------> | ||
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------> | <!-- ABS.1: Linke 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:32px-G38.png|32px|link=Insert an account calculation]] [[Insert an account calculation|Insert an account calculation]]</div> | <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:32px-G38.png|32px|link=Insert an account calculation]] [[Insert an account calculation or account aggregate|Insert an account calculation or account aggregate]]</div> | ||
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert an account calculation]]--> | <!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert an account calculation or account aggregate]]--> | ||
An account calculation consists of the mathematical addition/subtraction of several account values. <small>'''[[ | An account calculation consists of the mathematical addition/subtraction of several account values. <small>'''[[Insert_an_account_calculation_or_account_aggregate|more]]'''</small> | ||
----- | ----- | ||
Version vom 23. März 2021, 10:53 Uhr
<imagemap>Image:EN_Excel Menüband Inhalt Zentralwerte Einfügen.jpg|1200px|center
desc none </imagemap>
| |||||
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
Maintain Excel contents
Data import
The functions of the master value manager
The validation basic functions
An overview of the rolling forward function
Automated worksheet