Quelltext der Seite Rolling forward values from the MeetingPoint

To ensure that firesys has a high degree of integrity in your everyday work, you have the option of using numerical values that are stored centrally in the MeetingPoint with the firesys-specific tools as well. In this way, you can also use the &ldquo;roll forward&rdquo; function on table columns that contain master values from the MeetingPoint.


<imagemap>Image:EN_Menüband_Excel_Inhalt_Vorrollen.jpg|1200px|center

desc none
</imagemap>


== An overview of the functions ==

=== General information ===

Working with master values from the MeetingPoint and the &ldquo;roll forward&rdquo; function requires an identical procedure to a regular &ldquo;roll forward&rdquo; operation (for more information, see [[General information about the roll forward function|this article]]. However, it is important that you know which value type occurs in the table and whether or not this value refers directly to specific key dates. An introductory overview of the values saved in the MeetingPoint:


* [[Datei:Image.Cell.Type.DatabaseValue.32.png|link=|48px]] '''Manual values'''
&rarr; [[Insert_manual_values|Go to the main article about inserting manual values]]

{{Vorlage:Definition-ManuellerWertENG}}


* [[Datei:Image.Cell.Type.ExcelValue.24.png|link=|48px]]  '''Transmitter values'''
&rarr; [[Insert_transmitter_values|Go to the main article about inserting transmitter values]]

{{Vorlage:Definition-SenderwertENG}}


* [[Datei:Image.Cell.AccountValue.24.png|link=|48px]] '''Account values'''
&rarr; [[Insert_account_values|Go to the main article about inserting account values]]

{{Vorlage:Definition-KontenwerteENG}}


* [[Datei:G38.png|link=|48px]] '''Account calculations'''
&rarr; [[Insert_an_account_calculation_or_account_aggregate|Go to the main article about inserting account calculations or account aggregate]]

{{Vorlage:Definition-KontenberechnungENG}}


These different value types are classified into 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
|-
| Manually inserted values
| Account values
|-
| Formula cells (references/firesys formulas)
| Account calculations
|-
| References in the workbook
| 
|-
| Transmitter values
| 
|-
| Manual values
| 
|}


=== Key date-independent worksheet ===

A key date-independent worksheet is defined by the fact that only values were inserted that

* were inserted manually
* contain local references
* contain references in the document
* contain transmitter values or manual values from the MeetingPoint


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


=== Key date-dependent worksheet ===

A key date-dependent worksheet is defined by the fact that in addition to the types of values listed under &ldquo;Key date-independent worksheet&rdquo;, account values or account calculations are also inserted from the MeetingPoint.


[[Datei:EN_Excel_Werte_einfügen_Stichtagabhängig.jpg|center|700px]]


{{
Vorlage:Definition

|Definition= Worksheets can be rolled forward with key date-dependent worksheets only if

* an account group was created in the MeetingPoint
* at least two key dates exist in this account group
}}


The roll forward process for these worksheets is described under XY. A difference is made between two cases:


==== Key date-dependent worksheet with (pre-)defined roll columns ====

If you have used an older version of firesys to define table columns to be rolled forward on worksheets, you have to assign an account group to all affected worksheets containing account values or calculations. In addition, all columns to be rolled forward must contain a key date.   


{{
Vorlage:GoodtoKnow

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

}}


==== Key date-dependent worksheet without (pre-)defined roll columns ====

If you are using an Excel workbook that was not yet assigned columns to be rolled forward before the installation or before firesys version 20.1.0, you can define a cleanly structured &ldquo;roll forward&rdquo; process. In addition to the mandatory selection of an account group, you have to assign key dates to each column to be rolled forward containing account values or calculations.


{{
Vorlage:Definition

|Definition= If you have not yet assigned an account group to a worksheet that you would like to use for the &ldquo;roll forward&rdquo; function, the &ldquo;Account group&rdquo; drop-down list is crossed out. You can access the MeetingPoint and all account groups that are available in the drop-down list only once you have clicked in the field and the drop-down list opens. 
}}

[[Kategorie: English-Excel Vorrollen]]

== See also ==

[[Datei:Navigation_hoch.svg|link=]]  [[An_overview_of_the_rolling_forward_function|An overview of the rolling forward function]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[General_information_about_the_roll_forward_function|General information about the roll forward function]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Rolling_forward_case_studies|Rolling forward case studies]] <br>

{{MoreContent}}