Automated worksheet: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „<imagemap>Datei:EN_Excel Menüband Inhalt Zentralwerte Bearbeiten-Einfügen-Lösen.jpg|center|1200px desc none </imagemap> {| class="toptextcells" style="pad…“) |
Keine Bearbeitungszusammenfassung |
||
| (10 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 9: | Zeile 8: | ||
{| style="background:#FFFFFF; width:100%; border-collapse:collapse;" | {| style="background:#FFFFFF; width:100%; border-collapse:collapse;" | ||
|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%;"> | |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 16: | 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: | <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:rxbtnCellInsertTargetCells_32.png||link=Insert_automated_worksheet]] [[Insert_automated_worksheet|Insert automated worksheet]]</div> | ||
<!--[[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= | <!--[[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> | ||
| 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: | <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 40: | Zeile 39: | ||
| | | | ||
| 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:rxbtnCellUnlinkTargetCell_32.png|link=Detach_automated_worksheet]] [[Detach_automated_worksheet|Detach automated worksheet]]</div> | ||
<!--[[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