Quelltext der Seite Configure roll forward

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 &ldquo;roll forward&rdquo; 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. 


[[Datei:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center]]



== The roll forward function ==

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:EN Excel Inhalt Vorrollen Konfigurieren.jpg |mini|upright=1.2|Configure]]

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

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

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

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

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

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

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

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

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

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

<b> Worksheet </b> <br>
Displays the title of the currently selected worksheet. 

<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". 
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.

<b> Direction </b> <br>
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 ==


{{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==

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:


{| class="wikitable"
! style="text-align: center; font-weight:bold;" | Key date independent worksheets
! style="font-weight:bold;" |  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


[[Datei:Excel_Werte_einfügen_Stichtagunabhängig.jpg|center|700px]]


=== 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".


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


{{
Vorlage:Definition

|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 
}}


{{
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.

}}

== 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. ==


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


== Video: Edit a table that has already been rolled forward ==


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

<!--
[[Datei:EN_Excel_Werte_einfügen_Schaubild7.jpg|center|800px]]


The figures that were located in the &ldquo;2017&rdquo; column are automatically transferred to the &ldquo;2018&rdquo; column when you execute the &ldquo;roll forward&rdquo; function. The roll forward function can be executed in firesys on all worksheets that are not locked and which do not contain any diagram or Pivot elements. The only requirement is that a print area is defined with which the dimensions of the table can be described in more detail. There are two different types of worksheets that can be rolled forward:


== The various scenarios for rolling forward tables that....==

=== ...are newly prepared for rolling forward  ===
[[Rolling_forward_case_studies#Prepare_a_new_or_existing_table_for_rolling_forward|&rarr; Go to the detailed description]]

If you have

* created a new table and want to prepare it generally to use the &ldquo;roll forward&rdquo; function,
* or if you have a table to which the &ldquo;roll forward&rdquo; function was not yet applied,

you will find all of the information you require here.


[[Datei:EN_Excel_Werte_einfügen_Schaubild8.jpg|center|800px]]


=== ...are newly prepared for rolling forward and contain values that are not dependent on key dates from the MeetingPoint ===
[[Rolling_forward_case_studies#Prepare_a_new_or_existing_table_that_contains_values_that_are_dependent_on_key_dates_for_rolling_forward|&rarr; Go to the detailed description]]

If you have

* created a new table that contains transmitter values or manual values and if you want to prepare it for using the &ldquo;roll forward&rdquo; function,
* or if you have a table to which the &ldquo;roll forward&rdquo; function was not yet applied,


you will find all of the information you require here.


[[Datei:EN_Excel_Werte_einfügen_Schaubild9.jpg|center|800px]]


=== ...already exist and contain values that are not dependent on key fates from the MeetingPoint ===
[[Rolling_forward_case_studies#Prepare_a_new_or_existing_table_that_contains_values_that_are_dependent_on_key_dates_for_rolling_forward|&rarr;  Go to the detailed description]]

If you have created a new table

* that contains transmitter values or manual values and if you want to prepare it for using the &ldquo;roll forward&rdquo; function,
* or if you have a table to which the &ldquo;roll forward&rdquo; function was not yet applied,

you will find all of the information you require here.


[[Datei:EN_Excel_Werte_einfügen_Schaubild10.jpg|center|800px]]


=== ...already exist ===
[[Rolling_forward_case_studies#Edit_a_table_that_was_rolled_forward_already|&rarr; Go to the detailed description]]

If you have 

an existing table that was already used for the &ldquo;roll forward&rdquo; function which does not contain any numerical values from the MeetingPoint,
you will find all of the information you require here.


[[Datei:EN_Excel_Werte_einfügen_Schaubild13.jpg|center|800px]]


=== ...already exist and contain values that are dependent on key fates from the MeetingPoint ===
[[Rolling_forward_case_studies#Edit_a_table_that_was_rolled_forward_already_and_contains_values_that_are_not_dependent_on_key_dates|&rarr; Go to the detailed description]]

If you want to edit an 

existing table that was already used for the &ldquo;roll forward&rdquo; function and (in the meantime) contains transmitter or manual values from the MeetingPoint,
you will find all of the information you require here.


[[Datei:EN_Excel_Werte_einfügen_Schaubild11.jpg|center|800px]]


=== ...already exist and contain values that are dependent on key dates from the MeetingPoint ===
[[Rolling_forward_case_studies#Edit_a_table_that_was_rolled_forward_already_and_contains_values_that_are_dependent_on_key_dates|&rarr; Go to the detailed description]]

If you want to edit an existing table

* that was already used for the &ldquo;roll forward&rdquo; function and (in the meantime) contains account values or calculations from the MeetingPoint,
* you will find all of the information you require here.


[[Datei:EN_Excel_Werte_einfügen_Schaubild12.jpg|center|800px]]

-->
== See also ==

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

{{MoreContent}}

[[Kategorie:English-Excel Vorrollen]]