Automated worksheet: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (7 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 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 19: | Zeile 18: | ||
<!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Insert_automated_worksheet]]--> | <!--[[Datei:StatusCockpit.jpg|left|175px|Testbild|link=Insert_automated_worksheet]]--> | ||
Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint. <small>'''[[Insert_automated_worksheet|mehr]]'''</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: | <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, 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> | ||
| Zeile 33: | Zeile 32: | ||
<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:rxbtnCellCodedSheetEdit_32.png|link=Edit_automated_worksheet]] [[Edit_automated_worksheet|Edit automated worksheet]]</div> | <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:rxbtnCellCodedSheetEdit_32.png|link=Edit_automated_worksheet]] [[Edit_automated_worksheet|Edit automated worksheet]]</div> | ||
<!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Edit_automated_worksheet]]--> | <!--[[Datei:Blatt-Navigator.jpg|left|175px|Testbild|link=Edit_automated_worksheet]]--> | ||
Text | 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. <small>'''[[Edit_automated_worksheet|mehr]]'''</small> | ||
----- | ----- | ||
</div> | </div> | ||
| Zeile 43: | Zeile 42: | ||
<!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=Detach_automated_worksheet]]--> | <!--[[Datei:Vorrollen.jpg|left|175px|Testbild|link=Detach_automated_worksheet]]--> | ||
Use this function to detach the automated worksheet from the MeetingPoint. <small>'''[[Detach_automated_worksheet|mehr]]'''</small> | |||
----- | ----- | ||
| | | | ||
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