Configure roll forward: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 3: | Zeile 3: | ||
<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center | <imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center | ||
desc none | desc none | ||
</imagemap> | </imagemap> | ||
Version vom 6. August 2020, 09:40 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. You can use this master data to quickly and easily create a basis for additional reports.
<imagemap>Image:EN_Excel_Menüband_Inhalt_Vorrollen.jpg|1200px|center
desc none </imagemap>
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.
The figures that were located in the “2017” column are automatically transferred to the “2018” column when you execute the “roll forward” 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
→ Go to the detailed description
If you have
- created a new table and want to prepare it generally to use the “roll forward” function,
- or if you have a table to which the “roll forward” function was not yet applied,
you will find all of the information you require here.
...are newly prepared for rolling forward and contain values that are not dependent on key dates from the MeetingPoint
→ 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 “roll forward” function,
- or if you have a table to which the “roll forward” function was not yet applied,
you will find all of the information you require here.
...already exist and contain values that are not dependent on key fates from the MeetingPoint
→ 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 “roll forward” function,
- or if you have a table to which the “roll forward” function was not yet applied,
you will find all of the information you require here.
...already exist
→ Go to the detailed description
If you have
an existing table that was already used for the “roll forward” function which does not contain any numerical values from the MeetingPoint, you will find all of the information you require here.
...already exist and contain values that are dependent on key fates from the MeetingPoint
→ Go to the detailed description
If you want to edit an
existing table that was already used for the “roll forward” function and (in the meantime) contains transmitter or manual values from the MeetingPoint, you will find all of the information you require here.
...already exist and contain values that are dependent on key dates from the MeetingPoint
→ Go to the detailed description
If you want to edit an existing table
- that was already used for the “roll forward” function and (in the meantime) contains account values or calculations from the MeetingPoint,
- you will find all of the information you require here.
See also
Insert values in Excel
Rolling forward values from the MeetingPoint
Rolling forward case studies