Insert values in Excel: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (26 dazwischenliegende Versionen von 4 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Einfügen.jpg|1200px|center]] | |||
{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;" | {| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;" | ||
| Zeile 25: | Zeile 9: | ||
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=]] | |style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=]] | ||
|style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">Insert values in Excel</div> | |style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">Insert values in Excel</div> | ||
firesys offers you the possibility to insert numerical values from the MeetingPoint into your Excel document. You can use these numbers as a basis for further operations.<br /> | |||
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=]] | |style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=]] | ||
|} | |} | ||
| Zeile 31: | Zeile 15: | ||
| 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:Image.Cell.Type.ExcelValue.24.png|32px|link= | <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:Image.Cell.Type.ExcelValue.24.png|32px|link=Insert_transmitter_values]] [[Insert_transmitter_values|Insert transmitter values]]</div> | ||
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link= | <!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_transmitter_values]]--> | ||
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). <small> '''[[ | 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). <small> '''[[Insert_transmitter_values|more]]'''</small> | ||
---- | ---- | ||
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte ---------------------------------------------------------------------> | | 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:Image.Cell.Type.DatabaseValue.32.png|32px|link= | <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:Image.Cell.Type.DatabaseValue.32.png|32px|link=Insert_manual_values]] [[Insert_manual_values|Insert manual values]]</div> | ||
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link= | <!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_manual_values]]--> | ||
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 | 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 master value manager. <small>'''[[Insert_manual_values|more]]'''</small> | ||
----- | ----- | ||
| style="width: 30%"|<!-- ABS.1: Rechte Spalte -----------------------------------------------------------------------> | | 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:Image.Cell.AccountValue.24.png|32px|link= | <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:Image.Cell.AccountValue.24.png|32px|link=Insert account values]] [[Insert account values|Insert account values]]</div> | ||
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link= | <!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert account values]]--> | ||
An account value is a master value in firesys that can be written to the MeetingPoint via the account | An account value is a master value in firesys that can be written to the MeetingPoint via the account folder or via the Data import and is assigned to a unique key date. <small>'''[[Insert account values|more]]'''</small> | ||
----- | ----- | ||
</div> | </div> | ||
| Zeile 54: | Zeile 38: | ||
| 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: | <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: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= | <!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert an account calculation or account aggregate]]--> | ||
An account calculation | An account calculation and an account aggregate are composed of the mathematical addition/subtraction of several account values or account calculations. <small>'''[[Insert_an_account_calculation_or_account_aggregate|more]]'''</small> | ||
----- | ----- | ||
| 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:Synchronisieren 32.png|link= | <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:Synchronisieren 32.png|link=Synchronise and detach]] [[Synchronise and detach|Synchronise and detach]] </div> | ||
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link= | <!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Synchronise and detach]]--> | ||
The | All master values currently linked in the workbook are matched and synchronized with the values stored in the MeetingPoint. The connection of master values to the MeetingPoint can be removed using the "Detach" function. <small>'''[[Synchronise and detach|more]]'''</small> | ||
----- | ----- | ||
|} | |} | ||
== | == See also == | ||
[[Datei:Navigation_hoch.svg|link=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[Maintain_Excel_contents|Maintain Excel contents]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Data_import|Data import]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[The_functions_of_the_master_value_manager|The functions of the master value manager]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[The_validation_basic_functions|The validation basic functions]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[An_overview_of_the_rolling_forward_function|An overview of the rolling forward function]] <br> | |||
[[Datei:Navigation_rechts.svg|link=]] [[Automated_worksheet|Automated worksheet]] <br> | |||
{{ | {{MoreContent}} | ||
[[Kategorie:English-Excel Dokument-Werteeinfügen-Übersicht]] | [[Kategorie:English-Excel Dokument-Werteeinfügen-Übersicht]] | ||
Aktuelle Version vom 19. November 2021, 13:02 Uhr
| |||||
|
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 master value manager. more |
An account value is a master value in firesys that can be written to the MeetingPoint via the account folder or via the Data import and is assigned to a unique key date. more
| |||
|
An account calculation and an account aggregate are composed of the mathematical addition/subtraction of several account values or account calculations. more |
All master values currently linked in the workbook are matched and synchronized with the values stored in the MeetingPoint. The connection of master values to the MeetingPoint can be removed using the "Detach" function. 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