Automated worksheet: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (5 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Bearbeiten-Einfügen-Lösen.jpg|center|1200px]] | |||
{| 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 10: | Zeile 9: | ||
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=Die_Kontenmappe]] | |style="width:10%"| [[Bild:Excel_Funktionen_64.png|left|64px|link=Die_Kontenmappe]] | ||
|style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">Automated worksheet</div> | |style="width:80%; padding: 3px; text-align: center;"| <div style="font-size:190%; line-height:170%;">Automated worksheet</div> | ||
firesys offers a possibility to efficiently insert numerical values from the MeetingPoint into your Excel document with the automated worksheets. The information about accounts or account calculations are sufficient to insert directly key date-related values into the number columns.<br/> | firesys offers a possibility to efficiently insert numerical values from the MeetingPoint into your Excel document with the automated worksheets. The information about accounts or account calculations or account aggregates are sufficient to insert directly key date-related values into the number columns.<br/> | ||
|style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=Die_Kontenmappe]] | |style="width:10%"| [[Bild:Excel_Funktionen_64.png|64px|right|link=Die_Kontenmappe]] | ||
|} | |} | ||
| Zeile 24: | Zeile 23: | ||
| 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: | <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:Arbeitsblatt automatisieren menu.png|link=Automate_worksheet]] [[Automate_worksheet|Automate worksheet]]</div> | ||
<!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Automate_worksheet]]--> | <!--[[Datei:Blatt-Inspektor.jpg|left|175px|Testbild|link=Automate_worksheet]]--> | ||
Insert accounts or account | Insert accounts, account calculations or account aggregates from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. <small>'''[[Automate_worksheet|mehr]]'''</small> | ||
----- | ----- | ||
</div> | </div> | ||
Aktuelle Version vom 19. November 2021, 13:27 Uhr
| |||||
|
Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint. mehr
|
Insert accounts, account calculations or account aggregates from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. mehr |
Text and number columns and other master value columns can be added to the automated worksheet. The definition of the columns can also be adjusted. mehr
| |||
|
Use this function to detach the automated worksheet from the MeetingPoint. mehr |
|||||
See also
Maintain Excel contents
Data import
The functions of the master value manager
Insert values in Excel
The validation basic functions
An overview of the rolling forward function