Configure roll forward: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(15 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
When you work with firesys, you should ideally be able to work on your business reports on a long-term basis, and in doing so, prepare your report for the next quarter or financial year. The “roll forward” function can support you with this. You can use it to automatically transfer values that are located in one column in an Excel workbook to a different column after the setup process. You can use this master data to quickly and easily create a basis for additional reports.  
When you work with firesys, you should ideally be able to work on your business reports on a long-term basis, and in doing so, prepare your report for the next quarter or financial year. The “roll forward” function can support you with this. You can use it to automatically transfer values that are located in one column in an Excel workbook to a different column after the setup process.  




<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center
[[Datei:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center]]


desc none
</imagemap>




Zeile 11: Zeile 9:


In the &ldquo;*Content&rdquo; menu ribbon, the &quot;Roll forward&quot; group contains all functions that you need for setting up and executing the roll forward function. The central working environment is the roll forward work area. You open and close the work area by clicking on the &ldquo;Work area&rdquo; button.
In the &ldquo;*Content&rdquo; menu ribbon, the &quot;Roll forward&quot; group contains all functions that you need for setting up and executing the roll forward function. The central working environment is the roll forward work area. You open and close the work area by clicking on the &ldquo;Work area&rdquo; button.
[[Datei: Excel Validierung Zentralwert-Manager Hinzufügen.jpg |mini|upright=2.0|Configure]]
 
[[Datei:EN Excel Inhalt Vorrollen Konfigurieren.jpg |mini|upright=1.2|Configure]]


== Task pane  „Configure “==
== Task pane  „Configure “==
===  [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] Changes ===
===  [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] Changes ===
<b>Save and close</b><br>
<b>[[Datei:Image.Cell.SaveAndClose.32.png|16px]]Save and close</b><br>
Saves the changes and closes the roll forward task pane.
Saves the changes and closes the roll forward task pane.


=== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] Columns ===
=== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] Columns ===
<b>Display columns</b> <br>
<b>[[Datei:Image.Cell.Rollforward.SelectColumn.32.png|16px]]Display columns</b> <br>
Marks on the worksheet all columns defined for roll forward.<br>
Marks on the worksheet all columns defined for roll forward.<br>


<b>Add column</b><br>
<b>[[Datei:Image-Common-Plus.48.png|16px]]Add column</b><br>
The selected column will be added to the configuration.<br>
The selected column will be added to the configuration.<br>


<b>Change column</b><br>
<b>[[Datei:Image.Common.Edit.48.png|link=|16px]]Change column</b><br>
Replaces the column selected in the list with the selected column on the worksheet.<br>
Replaces the column selected in the list with the selected column on the worksheet.<br>


<b>Remove column</b><br>
<b>[[Datei:Image-Common-Remove-X.png|16px]]Remove column</b><br>
Removes the column from the configuration.<br>
Removes the column from the configuration.<br>


<b>Move column up</b><br>
<b>[[Datei:Image.Common.Arrow.Up.16.png|16px]]Move column up</b><br>
Moves the selected column into the future.<br>
Moves the selected column into the future.<br>


<b>Move column down</b><br>
<b>[[Datei:Image-Common-ArrowDown.png|16px]]Move column down</b><br>
Moves the selected column into the past.<br>
Moves the selected column into the past.<br>


=== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] Groups ===
=== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] Groups ===


<b> Create group </b><br>
<b>[[Datei:Image.Cell.RollForward.ChainKit.32.png|16px]] Create group </b><br>
Creates a group for roll forward at the selected location.
Creates a group for roll forward at the selected location.


<b> Disband group </b><br>
<b>[[Datei:Image.Cell.RollForward.ChainBreak.32.png|16px]]  Disband group </b><br>
Detaches the roll forward group at the selected location.  
Detaches the roll forward group at the selected location.  


===  [[File:Firesys Icons BubbleTransparent 4 white background.png|link=|24px]] Worksheet ===
===  [[File:Firesys Icons BubbleTransparent 4 white background.png|link=|24px]] Other===  
 
<b> Worksheet </b> <br>
Displays the title of the currently selected worksheet.  
Displays the title of the currently selected worksheet.  


===  [[File:Firesys Icons BubbleTransparent 5 white background.png|link=|24px]] Account group ===
<b> Account group </b><br>
If you have not yet assigned an account group to a worksheet for which you want to use the "Roll forward" function, the "Account group" drop-down list will have the entry "No account group".  
If you have not yet assigned an account group to a worksheet for which you want to use the "Roll forward" function, the "Account group" drop-down list will have the entry "No account group".  
Only after you make a click in the field and the dropdown list opens, the MeetingPoint is accessed and all available account groups are displayed in the dropdown list.
Only after you make a click in the field and the dropdown list opens, the MeetingPoint is accessed and all available account groups are displayed in the dropdown list.


===  [[File:Firesys Icons BubbleTransparent 6 white background.png|link=|24px]]Direction ===
<b> Direction </b> <br>
Shows an overview of the direction in which the selected columns are rolled forward.  
Shows an overview of the direction in which the selected columns are rolled forward. Furthermore, the key dates for the roll forward can be selected here via drop-down list.




Zeile 60: Zeile 61:




{{Vorlage:Video-Tabellen_vorrollen}}
{{Vorlage:Video-Tabellen_vorrollen-English}}
 
 
==Video: Roll forward with multiple same key dates ==
 
{{Vorlage:Video-Vorrollen mit mehreren gleichen Stichtagen-English}}
 


==Key date-independent and key date-dependent worksheets==
==Key date-independent and key date-dependent worksheets==
Zeile 108: Zeile 115:




[[Datei:Excel_Werte_einfügen_Stichtagabhängig.jpg|center|700px]]
[[Datei:EN Excel Werte einfügen Stichtagabhängig.jpg|center|700px]]




Zeile 118: Zeile 125:
* An account group has been created in MeetingPoint.
* An account group has been created in MeetingPoint.
* At least two key dates exist in this account group
* At least two key dates exist in this account group
* The key dates were assigned to the columns
}}
}}




{{
{{
Vorlage:GoodtoKnow
Vorlage:GoodtoKnowSmall


|Gutzuwissen = The key dates used for the table columns to be rolled forward for account values, account calculations or aggregates must be sorted chronologically in ascending order.
|Gutzuwissen = The key dates used for the table columns to be rolled forward for account values, account calculations or aggregates must be sorted chronologically in ascending order.


}}
}}
== The placeholder function in the "Roll forward" task pane ==
In order to be able to roll forward a table that contains key date-dependent account values with key date-independent values (that are not stored in MeetingPoint), so-called placeholders are used for the key date-independent values. These are used if no account values are stored in a column, but the column is to be rolled forward anyway.
To do this, assign the key date "Placeholder" to the column without account values in the "Roll forward" task pane. Assign the corresponding key date to the columns with account values.
In this way, you can roll forward worksheets that contain two different types of values.


== Video: Prepare a new or existing table containing key date-dependent values for roll forward. ==
== Video: Prepare a new or existing table containing key date-dependent values for roll forward. ==




{{Vorlage:Video-Tabelle vorrollen Zentralwerte}}
{{Vorlage:Video-Tabelle vorrollen Zentralwerte-English}}




Zeile 137: Zeile 153:




{{Vorlage:Video-Vorgerollte Tabelle bearbeiten}}
{{Vorlage:Video-Vorgerollte Tabelle bearbeiten-English}}


<!--
<!--
Zeile 230: Zeile 246:


[[Datei:Navigation_hoch.svg|link=]]  [[Insert_values_in_Excel|Insert values in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_values_in_Excel|Insert values in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Rolling_forward_values_from_the_MeetingPoint|Rolling forward values from the MeetingPoint]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Rolling_forward_case_studies|Rolling forward case studies]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Rolling_forward_case_studies|Rolling forward case studies]] <br>



Aktuelle Version vom 19. November 2021, 13:24 Uhr

When you work with firesys, you should ideally be able to work on your business reports on a long-term basis, and in doing so, prepare your report for the next quarter or financial year. The “roll forward” function can support you with this. You can use it to automatically transfer values that are located in one column in an Excel workbook to a different column after the setup process.


EN Menüband Excel Inhalt Vorrollen.jpg


The roll forward function

In the “*Content” menu ribbon, the "Roll forward" group contains all functions that you need for setting up and executing the roll forward function. The central working environment is the roll forward work area. You open and close the work area by clicking on the “Work area” button.

Configure

Task pane „Configure “

Firesys Icons BubbleTransparent 1 white background.png Changes

Image.Cell.SaveAndClose.32.pngSave and close
Saves the changes and closes the roll forward task pane.

Firesys Icons BubbleTransparent 2 white background.png Columns

Image.Cell.Rollforward.SelectColumn.32.pngDisplay columns
Marks on the worksheet all columns defined for roll forward.

Image-Common-Plus.48.pngAdd column
The selected column will be added to the configuration.

Image.Common.Edit.48.pngChange column
Replaces the column selected in the list with the selected column on the worksheet.

Image-Common-Remove-X.pngRemove column
Removes the column from the configuration.

Image.Common.Arrow.Up.16.pngMove column up
Moves the selected column into the future.

Image-Common-ArrowDown.pngMove column down
Moves the selected column into the past.

Firesys Icons BubbleTransparent 3 white background.png Groups

Image.Cell.RollForward.ChainKit.32.png Create group
Creates a group for roll forward at the selected location.

Image.Cell.RollForward.ChainBreak.32.png Disband group
Detaches the roll forward group at the selected location.

Firesys Icons BubbleTransparent 4 white background.png Other

Worksheet
Displays the title of the currently selected worksheet.

Account group
If you have not yet assigned an account group to a worksheet for which you want to use the "Roll forward" function, the "Account group" drop-down list will have the entry "No account group". Only after you make a click in the field and the dropdown list opens, the MeetingPoint is accessed and all available account groups are displayed in the dropdown list.

Direction
Shows an overview of the direction in which the selected columns are rolled forward. Furthermore, the key dates for the roll forward can be selected here via drop-down list.


Video: Prepare a new or existing table for roll forward

A detailed explanation of the individual steps

Setting up the roll forward function

  1. Open the worksheet containing the table that should be set up for using the “roll forward” function.

  2. In the *Content“ menu ribbon, in the “Roll forward” group, click on the upper part of the “Work area” split button.
    →the “Roll forward” work area opens.

  3. Use the mouse to navigate to the table column in which the values from a different column should be rolled forward. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area.
    →The selected column is now displayed in the list area.

  4. Navigate with the mouse to the table column from which values should be rolled forward in a different column. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area.
    → The list area now also displays the selected column - and a blue arrow points in the direction of the values to be rolled forward.

  5. Then click on the “Save” icon in the “Changes” group in the “Roll forward” work area.
    → The work area closes automatically.


Executing the “Roll forward” function

  1. In the “*Content” menu ribbon, in the “Roll forward” group, click on the “Execute” button.
    → A dialogue opens.

  2. displaying information about the last successful “roll forward” process and optionally enables you to specify a free text that is used in the “roll forward” history. Before executing the “roll forward” process, if you want to obtain information about which worksheets are being rolled forward, click on the “Status update“ button.

  3. Clicking on “Start” starts the “roll forward” process.
    Note: Any changes that were not saved must be saved beforehand – furthermore, firesys creates a backup copy of your workbook which you must also consent to.
    → Your workbook is rolled forward.


Video: Roll forward with multiple same key dates


The explanation of each step in detail

How to prepare the roll forward of a table with several equal key dates:

  1. In Excel, click the "Configure" button in the "*Content" ribbon in the "Roll forwards" group.
    → The "Roll forwards" task pane opens on the right-hand side.

  2. In the task pane, under "Account group", select the account group for which the values exist.

  3. Select one cell at a time in the columns you want to roll forward and click the green "Add" plus in the "Columns" group in the "Roll Forward" task pane.
    → The selected columns will be displayed in the list area. A blue arrow indicates in which direction is rolled forward.

  4. Assign the appropriate key date to each column in the list area on the right.

  5. To configure groups for roll forward, select the last element of the group you want to create and click the left icon "Create group" in the "Roll forward" task pane in the "Groups" group.
    → A separation will now appear below the selected line so that the blue arrows are interrupted at this point.

  6. Click the "Save" icon in the "Changes" group in the "Roll forwards" task pane to save the defined groups and automatically close the task pane.
    → The task pane is closed automatically.


Key date-independent and key date-dependent worksheets

In general, we distinguish between a key date independent and a key date dependent worksheet when rolling forward.

These different value types are divided into the so-called key date-dependent and key date-independent worksheets with the following assignment:


Key date independent worksheets Key date dependent worksheets
Values inserted manually Account values
Formula cells (references/firesys formulas) Account calculations, account aggregates
References in the workbook
Transmitter values
Manual values


Key date independent worksheet

A key date independent worksheet is defined by inserting only values that have been

  • were inserted manually
  • contain local references
  • contain references in the document
  • contain Transmitter values or Manual values from the MeetingPoint


Excel Werte einfügen Stichtagunabhängig.jpg


Key date dependent worksheet

A key date dependent worksheet is defined by inserting account values, or account calculations or account aggregates from the MeetingPoint in addition to the types of values listed under "Key date independent worksheet".


EN Excel Werte einfügen Stichtagabhängig.jpg


Image.Fire.Info.32.png
Definition

The "roll forward" of worksheets can only be executed for key date-dependent worksheets if

  • An account group has been created in MeetingPoint.
  • At least two key dates exist in this account group
  • The key dates were assigned to the columns


Glühbirne neu.png
Good to know

The key dates used for the table columns to be rolled forward for account values, account calculations or aggregates must be sorted chronologically in ascending order.

The placeholder function in the "Roll forward" task pane

In order to be able to roll forward a table that contains key date-dependent account values with key date-independent values (that are not stored in MeetingPoint), so-called placeholders are used for the key date-independent values. These are used if no account values are stored in a column, but the column is to be rolled forward anyway.

To do this, assign the key date "Placeholder" to the column without account values in the "Roll forward" task pane. Assign the corresponding key date to the columns with account values.

In this way, you can roll forward worksheets that contain two different types of values.

Video: Prepare a new or existing table containing key date-dependent values for roll forward.


A detailed explanation of the individual steps

Setting up the roll forward function

  1. Open the worksheet containing the table that should be set up for using the “roll forward” function.

  2. In the “*Content” menu ribbon, in the “Roll forward” group, click on the upper part of the “Work area” split area to open the “Roll forward” work area.

  3. In the “Account group” drop-down menu, select the account group from which the account values or calculations originate that are located in the column to be rolled forward.

  4. Use the mouse to navigate to the table column from which the values should be rolled forward in a different column. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area.
    → The selected column is now displayed in the list area.

  5. In the “Roll forward” work area in the list area, select the entry that you previously created and assign the correct key date to the entry in the drop-down menu.

  6. Use the mouse to navigate to the table column in which the values from a different column should be rolled forward. Then click on the green “Add” icon in the “Columns” group in the “Roll forward” work area.
    → The list area now also displays the selected column – and a blue arrow displays the direction of the values to be rolled forward.

  7. In the “Roll forward” work area in the list area, select the previously created entry and assign the correct key date to the entry in the drop-down menu.

  8. Then click on the “Save” icon in the “Changes” group in the “Roll forward” work area.
    → the work area closes automatically.


Executing the “Roll forward” function

  1. In the “*Content” menu ribbon, in the “Roll forward” group, click on the “Execute” button.
    → A dialogue opens that displays information about the last successful “roll forward” process and optionally enables you to enter a free text which is transferred to the “Roll forward” history.

  2. In the “Key dates” area in the list view, check the information that is listed for the individual “roll forward” operations to see whether the key date to be rolled forward is always correct.

  3. Before executing the “roll forward” process, if you want to obtain information about which worksheets are being rolled forward, click on the “Status update” button.

  4. Clicking on “Start” starts the “roll forward” process.
    Note: Any changes that were not saved must be saved beforehand – furthermore, firesys creates a backup copy of your workbook which you must also consent to.
    → Your workbook is rolled forward.


Video: Edit a table that has already been rolled forward


A detailed explanation of the individual steps

Processing the roll forward function

  1. Open the worksheet containing the table with already defined roll columns.

  2. In the “*Content” menu ribbon, in the “Roll forward” group, click on the upper part of the “Work area” split area to open the “Roll forward” work area. You will find an overview of the roll columns that were already defined in the “Roll forward” work area in the list view in the “Direction” group. You can tell the direction from the blue arrow.

  3. The “Columns” group contains the following functions:

    • Image.Cell.Rollforward.SelectColumn.32.png Display columns:

    • Image.Common.Plus.24.png Add column:

    • Image.Common.Edit.24.png Change column:

    • Image-Common-Remove-X.png Remove column:

    • Image.Common.Arrow.Up.16.png / Image.Common.Arrow.Down.png Move column up/down:

  4. Once you have made your changes, then click on the “Save” icon in the “Changes” group in the “Roll forward” work area.
    → the work area closes automatically.

See also

Navigation hoch.svg Insert values in Excel
Navigation rechts.svg Rolling forward case studies

Further contents

firesys website
Customer area
YouTube