The firesys video zone: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
(55 dazwischenliegende Versionen von 6 Benutzern werden nicht angezeigt) | |||
Zeile 2: | Zeile 2: | ||
==Word== | ==Word== | ||
=== firesys group=== | |||
==== Reconnecting MeetingPoint ==== | |||
Attach a new MeetingPoint to one or more documents. | |||
{{Vorlage:Video-Word-firesys-MeetingPoint neu anbinden-English}} | |||
===Layout menu ribbon=== | ===Layout menu ribbon=== | ||
====Design texts with the StyleGuide==== | ====Design texts with the StyleGuide==== | ||
The StyleGuide makes the text formats that were developed especially for your publication according to the StyleGuide available in a separate task area. | The StyleGuide makes the text formats that were developed especially for your publication according to the StyleGuide available in a separate task area. | ||
{{Video-StyleGuideWord-English}} | {{Video-StyleGuideWord-English}} | ||
Zeile 15: | Zeile 22: | ||
The firesys table assistant helps with with creating, formatting and changing tables. | The firesys table assistant helps with with creating, formatting and changing tables. | ||
{{Vorlage:Video-Tabellenassistent - Eine leere Tabelle neu erstellen-English}} | {{Vorlage:Video-Tabellenassistent - Eine leere Tabelle neu erstellen-English}} | ||
Zeile 24: | Zeile 30: | ||
Change the table and column widths from the specified values or define manual values. | Change the table and column widths from the specified values or define manual values. | ||
{{Vorlage:Video-Tabellenassistent-English}} | {{Vorlage:Video-Tabellenassistent-English}} | ||
Zeile 33: | Zeile 38: | ||
Change the height of the individual rows in your table by using the context-sensitive table menu in firesys. | Change the height of the individual rows in your table by using the context-sensitive table menu in firesys. | ||
{{Vorlage:Video-Tabellenassistent-Höhe-English}} | {{Vorlage:Video-Tabellenassistent-Höhe-English}} | ||
Zeile 42: | Zeile 46: | ||
Use firesys to add a new row to an existing table. | Use firesys to add a new row to an existing table. | ||
{{Vorlage:Video-Tabellenassistent - Einfügen einer zusätzlichen Spalte und Zeile-English}} | {{Vorlage:Video-Tabellenassistent - Einfügen einer zusätzlichen Spalte und Zeile-English}} | ||
==== Page layout ==== | |||
Select the type area for the current section or the entire document. | |||
{{Vorlage:Video-Seitenlayout-Englisch}} | |||
===firesys-Layout menu ribbon=== | |||
====Apply colour scheme==== | |||
Use this function to apply a previously created color scheme to your document so that it conforms to your design guidelines. | |||
{{Vorlage:Video-firesys-Layout-Farbschema anwenden-English}} | |||
==== Create a new colour scheme ==== | |||
Here you can create a new colour scheme and then apply it to your document. | |||
{{Vorlage:Video-firesys-Layout-Ein neues Farbschema erstellen-English}} | |||
==== Edit diagrams ==== | |||
Design your diagrams in the corporate design by adjusting the colour scheme and font. | |||
{{Vorlage:Video-firesys-Layout-Diagramme bearbeiten-English}} | |||
==== Edit tables ==== | |||
Design your tables in the corporate design by adapting the colour scheme to your wishes. | |||
{{Vorlage:Video-Layout-Manager-Tabellen bearbeiten-English}} | |||
==== Edit texts ==== | |||
Design your texts in the corporate design by adapting the layout of the texts according to your wishes. | |||
{{Vorlage:Video-firesys-Layout Texte bearbeiten-English}} | |||
==== Edit page colour ==== | |||
Customise the page colour of your document in the Layout manager. | |||
{{Vorlage:Edit_pages}} | |||
==== Customize bullets ==== | |||
Customize bullets in the Layout manager according to your individual preferences. | |||
{{Vorlage:Video-Layout-Manager-Aufzählungen anpassen-English}} | |||
==== Create Table of Contents ==== | |||
Clicking the "Table of Contents" button inserts a table of contents at the location of the insertion point. | |||
{{Vorlage:Video-Word Premiumlayout Inhaltsverzeichnis erstellen-Englisch}} | |||
Zeile 52: | Zeile 118: | ||
This highlights in green all linked Excel objects in the body text, or else it removes the highlighting. | This highlights in green all linked Excel objects in the body text, or else it removes the highlighting. | ||
{{Vorlage:Video-Status-Markierungen-English}} | {{Vorlage:Video-Status-Markierungen-English}} | ||
Zeile 61: | Zeile 126: | ||
Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document. | Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document. | ||
{{Vorlage:Video-Daten im Text aus Datei einfügen-English}} | |||
Zeile 70: | Zeile 134: | ||
Use this function to insert the content of a single cell that you have just selected in Excel directly as a linked firesys object in the body text of your Word document. | Use this function to insert the content of a single cell that you have just selected in Excel directly as a linked firesys object in the body text of your Word document. | ||
{{Vorlage:Video-Daten im Text direkt aus markierter Zelle einfügen-English}} | |||
Zeile 79: | Zeile 142: | ||
Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document. | Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document. | ||
{{Vorlage:Video-Daten im Text mit Optionen einfügen-English}} | |||
Zeile 88: | Zeile 150: | ||
Use this function to insert a table from an Excel file as a linked firesys table object in Word. | Use this function to insert a table from an Excel file as a linked firesys table object in Word. | ||
{{Vorlage:Video-Tabelle aus Datei einfügen-English}} | {{Vorlage:Video-Tabelle aus Datei einfügen-English}} | ||
Zeile 97: | Zeile 158: | ||
With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object. | With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object. | ||
{{Vorlage:Video-Tabelle direkt aus markiertem Excel-Bereich einfügen-English}} | |||
Zeile 106: | Zeile 166: | ||
You can use these functions to update your linked Excel data with one click. This means that your business report always contains correctly maintained values. | You can use these functions to update your linked Excel data with one click. This means that your business report always contains correctly maintained values. | ||
{{Vorlage:Video-Excel-Inhalte_aktualisieren-English}} | {{Vorlage:Video-Excel-Inhalte_aktualisieren-English}} | ||
Zeile 115: | Zeile 174: | ||
Inserts any graphics file (such as JPG, BMP, EMF, GIF, PNG, TIF) as a linked firesys graphics object in the existing format in your Word document. | Inserts any graphics file (such as JPG, BMP, EMF, GIF, PNG, TIF) as a linked firesys graphics object in the existing format in your Word document. | ||
{{Vorlage:Video-Grafik im Fließtext einfügen-English}} | {{Vorlage:Video-Grafik im Fließtext einfügen-English}} | ||
Zeile 124: | Zeile 182: | ||
Inserts a diagram created in Excel or PowerPoint as a linked graphic in EMF format. The source program can remain closed and you do not have to manually save the diagram as a graphic beforehand. | Inserts a diagram created in Excel or PowerPoint as a linked graphic in EMF format. The source program can remain closed and you do not have to manually save the diagram as a graphic beforehand. | ||
{{Vorlage:Video-Grafik_aus_PowerPoint-English}} | {{Vorlage:Video-Grafik_aus_PowerPoint-English}} | ||
Zeile 133: | Zeile 190: | ||
Inserts a selected graphic into the currently opened Excel document directly as a linked graphic. | Inserts a selected graphic into the currently opened Excel document directly as a linked graphic. | ||
{{Vorlage:Video-Grafik_aus_Excel_einfügen-English}} | {{Vorlage:Video-Grafik_aus_Excel_einfügen-English}} | ||
==== Create a story ==== | |||
Select the text you require in your master. This is saved as a new story and integrated into the master. | |||
{{Vorlage:Video-Partikel_erstellen-English}} | {{Vorlage:Video-Partikel_erstellen-English}} | ||
Zeile 151: | Zeile 206: | ||
You can manually create a new version of the current Word document (if desired with all Word, Excel, PowerPoint and graphics files) and assign a status to a version. | You can manually create a new version of the current Word document (if desired with all Word, Excel, PowerPoint and graphics files) and assign a status to a version. | ||
{{Vorlage:Video-Versionierung-English}} | {{Vorlage:Video-Versionierung-English}} | ||
==== The Help and Search Function in the Managers==== | |||
Use the help and search function in the firesys managers to get information about and filter individual items. | |||
{{Vorlage:Video-Word-Inhalt-Excel-Daten-Excel-Daten-Manager-Hilfe und Suche-Funktion in den Managern-English}} | |||
Zeile 162: | Zeile 223: | ||
You can use the firesys AutoCorrect function to define terms which can then be converted automatically into a different spelling, meaning that undesirable abbreviations can be avoided, for example. | You can use the firesys AutoCorrect function to define terms which can then be converted automatically into a different spelling, meaning that undesirable abbreviations can be avoided, for example. | ||
{{Vorlage:Video-Autokorrektur-English}} | {{Vorlage:Video-Autokorrektur-English}} | ||
Zeile 171: | Zeile 231: | ||
The “Layout check” function checks your files for formal design problems and detects such problems faster and in more detail than the human eye ever could. It also immediately provides assistance with their correction. | The “Layout check” function checks your files for formal design problems and detects such problems faster and in more detail than the human eye ever could. It also immediately provides assistance with their correction. | ||
{{Vorlage:Video-Layout Check-English}} | {{Vorlage:Video-Layout Check-English}} | ||
Zeile 180: | Zeile 239: | ||
Use the coupler to join certain terms together so they are never separated through line breaks. Rules can be defined by using regular expressions. | Use the coupler to join certain terms together so they are never separated through line breaks. Rules can be defined by using regular expressions. | ||
{{Vorlage:Video-Koppler-English}} | {{Vorlage:Video-Koppler-English}} | ||
Zeile 189: | Zeile 247: | ||
Here you can determine where certain words can be hyphenated. You can also determine hyphenation suggestions on how certain words are to be hyphenated in Word. | Here you can determine where certain words can be hyphenated. You can also determine hyphenation suggestions on how certain words are to be hyphenated in Word. | ||
{{Vorlage:Video-Silbentrennung-English}} | {{Vorlage:Video-Silbentrennung-English}} | ||
====Never hyphenate word==== | |||
With the “Never hyphenate word” function you can define words that must always be kept together in your document and must not be separated with line breaks. This enables you to better adhere to your corporate identity, for example. | |||
{{Vorlage:Video-Wort-nie-trennen-English}} | {{Vorlage:Video-Wort-nie-trennen-English}} | ||
Zeile 207: | Zeile 263: | ||
All typography functions are executed at a click. This sets couplers, excludes words from hyphenation and applies separations to specific words. | All typography functions are executed at a click. This sets couplers, excludes words from hyphenation and applies separations to specific words. | ||
{{Vorlage:Video-Typografie-Funktionen-English}} | {{Vorlage:Video-Typografie-Funktionen-English}} | ||
Zeile 216: | Zeile 271: | ||
You can reduce your text quickly by a line with just one click. | You can reduce your text quickly by a line with just one click. | ||
{{Vorlage:Video-Laufweite-Wortabstand-English}} | {{Vorlage:Video-Laufweite-Wortabstand-English}} | ||
==== Prepare web version ==== | |||
With the Prepare web version function, you can automatically generate an HTML document of your annual report at the touch of a button. If you wish, all your tables can be output in one complete file or in a single file. | |||
{{Vorlage:Video-Word-Veröffentlichen-Web-Export Web-Version vorbereiten-English}} | |||
==== Prepare translation ==== | |||
With the help of the “Prepare translation” function, you can prepare your document(s) for export to a translator. All language-specific changes, such as run-length adjustments, change tracking or manual line breaks, are removed from the document. | |||
{{Vorlage:Video-Word-Veröffentlichen-Sprache und Zahlenformat-Übersetzung vorbereiten-English}} | |||
==== Prepare Text-Tagging ==== | |||
You can use this feature to create content controls. | |||
{{Vorlage:Video-Texttagging TaskPane-Englisch}} | |||
==Excel== | ==Excel== | ||
=== | |||
=== Design menu ribbon === | |||
====Design a table with the StyleGuide==== | ====Design a table with the StyleGuide==== | ||
Design your contents in Excel with the StyleGuide | Design your contents in Excel with the StyleGuide | ||
{{Vorlage:Video-StyleGuide-Excel-English}} | |||
Zeile 235: | Zeile 312: | ||
Use the following steps to prepare the table so it can be linked with your Word document. | Use the following steps to prepare the table so it can be linked with your Word document. | ||
{{Vorlage:Video-Tabelle formatieren-English}} | {{Vorlage:Video-Tabelle formatieren-English}} | ||
Zeile 244: | Zeile 320: | ||
Remove all unnecessary or duplicate styles from your Excel workbook. | Remove all unnecessary or duplicate styles from your Excel workbook. | ||
{{Vorlage:Video-Formatvorlagen_entfernen-English}} | {{Vorlage:Video-Formatvorlagen_entfernen-English}} | ||
==== Format cells in color with the function | ==== Format cells in color with the function “Highlight” ==== | ||
Colours cells in Excel yellow or removes this highlighting so that this can be transferred to Word. This way, numbers or texts in tables, that have not been defined yet, can be highlighted | Colours cells in Excel yellow or removes this highlighting so that this can be transferred to Word. This way, numbers or texts in tables, that have not been defined yet, can be highlighted sustainably. | ||
{{Vorlage:Video- | {{Vorlage:Video-HervorhebungHervorheben-English}} | ||
==== Format cells in color with the function | ==== Format cells in color with the function “Hide numbers” ==== | ||
Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator. | Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator. | ||
{{Vorlage:Video- | {{Vorlage:Video-HervorhebungZahlenverbergen-English}} | ||
==== Format cells in color using the | ==== Format cells in color using the “Ignore number format” function ==== | ||
Highlights the selected cells in green or deselects them so that when you transfer them to Word, the number format specified in Word is ignored. | Highlights the selected cells in green or deselects them so that when you transfer them to Word, the number format specified in Word is ignored. | ||
{{Vorlage:Video- | {{Vorlage:Video-HervorhebungZahlenformatIgnorieren-English}} | ||
==== Format cells in color with the function | ==== Format cells in color with the function “Import brackets” ==== | ||
Selects or deselects the selected cells in blue so that the brackets are displayed when the table is transferred to Word. | Selects or deselects the selected cells in blue so that the brackets are displayed when the table is transferred to Word. | ||
{{Vorlage:Video-Hervohebungen-Klammern | {{Vorlage:Video-Hervohebungen-Klammern einlesen-English}} | ||
==== | ==== Format cells in color with the function “Strikethrough” ==== | ||
Highlights the selected cells in light blue or removes this highlight again. With cells that are highlighted in light blue, two diagonal lines are set when they are imported into Word. This can be used in reports, for example, which are created in accordance with the Solvency II Standard. | Highlights the selected cells in light blue or removes this highlight again. With cells that are highlighted in light blue, two diagonal lines are set when they are imported into Word. This can be used in reports, for example, which are created in accordance with the Solvency II Standard. | ||
{{Vorlage:Video- | {{Vorlage:Video-HervorhebungDurchkreuzen-English}} | ||
==== Account calculation on automated worksheet ==== | |||
The “Sum” function allows you to create account calculations directly on the Automated Data Sheet. | |||
{{Vorlage:Video-Kontenberechnung auf automatisiertem Arbeitsblatt-English}} | |||
==== Delete Empty Ranges from Excel spreadsheet ==== | |||
You can use the Empty Ranges function to delete empty columns and rows from your Excel spreadsheet. | |||
{{Vorlage:Video-Excel Gestaltung Bereiche Leere Bereiche-English}} | |||
==== Hide columns and rows in Excel spreadsheet ==== | |||
Hide columns and rows that you do not need using the "X/Y Ranges" function. | |||
{{{{Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English}} | |||
====Configure row types ==== | |||
Configure different row types for your Excel spreadsheets. | |||
{{Vorlage:Video-Excel-Gestaltung-Formatierung-Styleguide-Zeilentypen konfigurieren-English}} | |||
=== Premium Layout ribbon === | |||
==== Adjust grafic width ==== | |||
In firesys it is possible to adjust the width of the graphics in Excel to the type area in Word. | |||
{{Vorlage:Video-StyleGuideWord-English}} | |||
Zeile 294: | Zeile 404: | ||
{{Vorlage:Video- | {{Vorlage:Video-BedingteFormatierungFarbskala-English}} | ||
{{Vorlage:Video-BedingteFormatierungRichtungen-English}} | |||
{{Vorlage:Video-BedingteFormatierungSchriftfarbe-English}} | |||
===Translation menu ribbon=== | ===Translation menu ribbon=== | ||
====Create a dictionary==== | ====Create a dictionary==== | ||
If the texts of the master language are in the first column and those of the secondary language are in the second column of the print area, you can create a dictionary with just one click. | If the texts of the master language are in the first column and those of the secondary language are in the second column of the print area, you can create a dictionary with just one click. | ||
{{Vorlage:Video-Wörterbuch erstellen-English}} | {{Vorlage:Video-Wörterbuch erstellen-English}} | ||
Zeile 310: | Zeile 432: | ||
The translation manager automatically proposes translations from the firesys dictionary. | The translation manager automatically proposes translations from the firesys dictionary. | ||
{{Vorlage:Video-Übersetzung vorschlagen-English}} | {{Vorlage:Video-Übersetzung vorschlagen-English}} | ||
==== Select language in Excel ==== | |||
Change the language in the Excel file and transfer the change to Word. | |||
{{Vorlage:Video-Excel-Übersetzung Wörterbuch-Sprache wählen-English}} | |||
==== Use word list ==== | |||
Use the word list to add terms to your Excel file and include them in the dictionary. | |||
{{Vorlage:Video-Excel Übersetzung Wörterbuch Wortliste benutzen-English}} | |||
=== Content menu ribbon === | |||
====Create a validation==== | ====Create a validation==== | ||
The validation function provides support with defining the required number pairs for the validation. | The validation function provides support with defining the required number pairs for the validation. | ||
{{Vorlage:Video-Validierung erstellen-English}} | {{Vorlage:Video-Validierung erstellen-English}} | ||
{{Vorlage:Video-Validierung erstellen Mehrfach-English}} | |||
==== Create a Autovalidation ==== | ==== Create a Autovalidation ==== | ||
Zeile 328: | Zeile 471: | ||
The autovalidation is a tool from firesys which quickly creates a validation by selecting a cell. | The autovalidation is a tool from firesys which quickly creates a validation by selecting a cell. | ||
{{Vorlage:Autovalidierung | |||
{{Vorlage:Video-Autovalidierung erstellen-English}} | |||
==== Approve a deviation ==== | ==== Approve a deviation ==== | ||
Zeile 334: | Zeile 479: | ||
When using the validation function in firesys, you can additionally release deviations, which you want to release manually for further use, with one of the tools from firesys according to your requirements. | When using the validation function in firesys, you can additionally release deviations, which you want to release manually for further use, with one of the tools from firesys according to your requirements. | ||
{{Vorlage:Video- | |||
{{Vorlage:Video-ValidierungAbweichung-English}} | |||
==== Create a manual value ==== | ==== Create a manual value ==== | ||
Zeile 340: | Zeile 487: | ||
A manual value is one of the different value types in firesys, with which you can use the MeetingPoint to use numbers across files. | A manual value is one of the different value types in firesys, with which you can use the MeetingPoint to use numbers across files. | ||
{{Vorlage:Video- ManuellerWert | |||
{{Vorlage:Video- ManuellerWert erstellen-English}} | |||
==== Insert a manual value ==== | ==== Insert a manual value ==== | ||
Zeile 346: | Zeile 495: | ||
You can insert a manual value in Excel at any time in a cell of your choice (this cell must not contain another master value). | You can insert a manual value in Excel at any time in a cell of your choice (this cell must not contain another master value). | ||
{{Vorlage:Video- ManuellerWert | |||
{{Vorlage:Video- ManuellerWert einfügen-English}} | |||
Zeile 353: | Zeile 503: | ||
A sender value is one of the different types of values in firesys, with which you can use the MeetingPoint to use numbers across files. Here the distinction between the sender and the receiver value is important. | A sender value is one of the different types of values in firesys, with which you can use the MeetingPoint to use numbers across files. Here the distinction between the sender and the receiver value is important. | ||
{{Vorlage:Video- Senderwert | |||
{{Vorlage:Video- Senderwert erstellen-English}} | |||
==== Insert a transmitter value ==== | ==== Insert a transmitter value ==== | ||
Zeile 359: | Zeile 511: | ||
You can insert a sender value in Excel at any time in a cell of your choice (this cell must not contain another master value). | You can insert a sender value in Excel at any time in a cell of your choice (this cell must not contain another master value). | ||
{{Vorlage:Video- Senderwert | |||
{{Vorlage:Video- Senderwert einfügen-English}} | |||
==== Create an Import definition ==== | |||
Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys. | |||
{{Vorlage:Video-Import-Definition_erstellen-English}} | |||
==== Create an account value ==== | ==== Create an account value ==== | ||
Zeile 365: | Zeile 527: | ||
You can use the account workbook to quickly transfer a large number of individual account values to the MeetingPoint and then use those account values across files, for example, for an account calculation. In addition, account values stored in the MeetingPoint can also be inserted into Excel worksheets. | You can use the account workbook to quickly transfer a large number of individual account values to the MeetingPoint and then use those account values across files, for example, for an account calculation. In addition, account values stored in the MeetingPoint can also be inserted into Excel worksheets. | ||
{{Vorlage:Video- Kontowerte | |||
{{Vorlage:Video- Kontowerte erstellen-English}} | |||
==== Insert an account value ==== | ==== Insert an account value ==== | ||
The insertion of an account value is shown in the | The insertion of an account value is shown in the “Insert values” work area. Here you can insert an account value in Excel at any time in a cell of your choice (this cell must not contain any other master value). | ||
{{Vorlage:Video-Tabellenassistent - Kontowerte einfügen-English}} | |||
{{Vorlage:Video- | |||
==== Insert automated worksheet ==== | |||
Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint. | |||
{{Vorlage:Video-Automatisiertes Arbeitsblatt einfügen-English}} | |||
==== Automate worksheet ==== | |||
Insert accounts or account calculations from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column. | |||
{{Vorlage:Video-Arbeitsblatt automatisieren-English}} | |||
==== Edit automated worksheet ==== | |||
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. | |||
{{Vorlage:Video-Automatisiertes Arbeitsblatt bearbeiten-English}} | |||
Zeile 378: | Zeile 564: | ||
You can create an account calculation from individual account values, which allows you to add/subtract several items. | You can create an account calculation from individual account values, which allows you to add/subtract several items. | ||
{{Vorlage:Video- Kontenberechnung | |||
{{Vorlage:Video- Kontenberechnung erstellen-English}} | |||
==== Insert account calculation ==== | ==== Insert account calculation ==== | ||
The insertion of an account calculation is shown in the | The insertion of an account calculation is shown in the “Insert values” task pane. Here you can insert an account calculation in Excel at any time in a cell of your choice (this cell must not contain any other master value). | ||
{{Vorlage:Video- Kontenberechnung einfügen-English}} | |||
==== Edit account calculation ==== | |||
In firesys it is always possible to edit defined “account calculation” configurations afterwards. | |||
{{Vorlage:Video- Kontenberechnung bearbeiten-English}} | |||
==== Create an account aggregate ==== | |||
You can create and edit account aggregates using the Account Calculation/Create Account Aggregate feature in the Master value manager. | |||
{{Vorlage:Video-Kontenaggregat erstellen-English}} | |||
==== The Rounding Wizard-Create a manual rounding ==== | |||
You can use firesys to round the results of your account calculations and account aggregates retrospectively using the rounding wizard. | |||
{{Vorlage:Video-Rundungs-Assistent-Manuelle Rundung erstellen-English}} | |||
==== The Rounding Wizard-Create a Manual Rounding with Delta ==== | |||
Using the Manual rounding value function in the Master value manager, you can subsequently round the results of your account calculations and account aggregates by adding a delta. | |||
{{Vorlage:Video-Rundungs-Assistent-Manuelle Rundung mit Delta erstellen-English}} | |||
==== The Rounding Wizard-Create a Fixed Value with Delta ==== | |||
Using the Manual rounding value feature in the Master value manager, you can subsequently round the results of your account calculations and account aggregates by adding a fixed value delta. | |||
{{Vorlage:Video-Rundungs-Assistent-Festwert mit Delta erstellen-English}} | |||
==== Synchronize values ==== | ==== Synchronize values ==== | ||
You can quickly check the integrity and validity of your central values with the | You can quickly check the integrity and validity of your central values with the “Synchronize values” function and restore them if necessary. | ||
{{Vorlage:Video-Werte synchronisieren-English}} | |||
==== Highlight master values ==== | ==== Highlight master values ==== | ||
Zeile 397: | Zeile 633: | ||
When working with firesys you can always quickly see which cells of your workbook are currently interacting with the MeetingPoint as a master value using the sheet inspector. | When working with firesys you can always quickly see which cells of your workbook are currently interacting with the MeetingPoint as a master value using the sheet inspector. | ||
{{Vorlage: | |||
{{Vorlage:Video-Zentralwerte_hervorheben-English}} | |||
==== Display central value history ==== | |||
In the Central Value Manager you can display the central value history for manual, transmitter and master values. | |||
{{Vorlage:Video- Zentralwert-Verlauf-English}} | |||
==== Copy Key date ==== | |||
In the Central Value Manager, you can copy an existing key date plus the associated values and assign a new date to it. | |||
{{Vorlage:Video-Zentralwert-Manager Stichtag kopieren-English}} | |||
==== Preparing a new or existing table for roll forward ==== | |||
You can prepare tables for your next reporting cycle using the “roll forward” function. | |||
{{Vorlage:Video-Tabellen_vorrollen}} | |||
==== Prepare a new or existing table containing key date-dependent values for roll forward ==== | |||
You can prepare tables containing master values and key date dependent values for your next reporting cycle using the “roll forward function”. | |||
{{Vorlage:Video-Tabellen vorrollen-English}} | |||
==== Roll forward with several identical key dates ==== | |||
The “Group” function allows you to create a group for roll forward at the selected position. This is advantageous if the table has several identical key dates. | |||
{{Vorlage:Video-Vorrollen mit mehreren gleichen Stichtagen-English}} | |||
==== Edit an already rolled forward table ==== | ==== Edit an already rolled forward table ==== | ||
In firesys it is always possible to edit defined | In firesys it is always possible to edit defined “roll forward” configurations of tables afterwards. | ||
{{Vorlage:Video-Vorgerollte Tabelle bearbeiten-English}} | |||
== See also == | == See also == |
Aktuelle Version vom 28. November 2023, 10:17 Uhr
All videos on the firesys software are displayed here.
Word
firesys group
Reconnecting MeetingPoint
Attach a new MeetingPoint to one or more documents.
To attach a MeetingPoint to a document:
Requirement: If no MeetingPoint is connected to the document or the previously used MeetingPoint has not been found, a dialogue box opens automatically when the document is opened, stating that a MeetingPoint must be specified. To connect a MeetingPoint to the document, confirm in the dialogue with “Yes”.
-
The firesys welcome dialogue opens. Select your preferred language here.
-
Then click on “Next >”.
-
On the following page of the dialogue you can select a new MeetingPoint. Click on the three dots to the right of “Please select a MeetingPoint”.
→ A selection dialogue opens.
-
Drag and drop the folder containing the MeetingPoint into the selection field.
Note: Alternatively, you can connect the MeetingPoint further down in the dialogue via the button “Additional folders”. Confirm with “OK”. Note: If you subsequently want to attach several Word documents at the same time (including stories) to the newly selected MeetingPoint, you can do this in the “Connect further documents” section. This saves you having to attach each individual document. Click on the three dots under “Connect further documents” and proceed in the selection dialogue that opens in the same way as when selecting the MeetingPoint.
-
Click on “Next >”.
→ Your documents are bound to the MeetingPoint.
Note: Please note that after changing the MeetingPoint, save, close and reopen the document to be able to work optimally with firesys.
Design texts with the StyleGuide
The StyleGuide makes the text formats that were developed especially for your publication according to the StyleGuide available in a separate task area.
How to use the StyleGuide to assign styles to text areas in Word:
-
In Word, in the “Layout” menu ribbon, click on the “StyleGuide” button in the “Text” group.
→ A work area opens on the right-hand side. -
Select a text area in Word to which you want to assign a style.
-
In the StyleGuide work area, click on the style you require.
→ The selected style is assigned to the selected text area.
Create a new table in Word
The firesys table assistant helps with with creating, formatting and changing tables.
Use this function to create a new, blank table in your Word document in accordance with your style guidelines. You can also insert tables into your document if the contents do not originate from Excel:
-
Click in the place in the document where you want to insert the table.
-
In the tab "*Design" in the group "Tables" click on the button
"*Table assistant". .
-
Select the desired template for the table – depending on your layout
-
Enter the number of columns and rows that you want in your table.
-
Then select a width for the new table.
-
Enter the width you require for the “Other columns” (usually the columns filled with numbers). The width of the “First column” (usually the text column) is adjusted automatically.
-
Choose whether the table header is to be repeated on every page.
-
Click OK to confirm your selection and to create
→ a table with the parameters you have specified.
Manually change a table
Change the table and column widths from the specified values or define manual values.
To edit a table, proceed as follows:
-
Hover the cursor over the table you want to change.
-
Open the table assistant. You have two options for this:
-
In the tab "*Design" in the group "Tables" click on the button
"*Table assistant".
-
Open the context menu by right-clicking on the table and click on
"*Table assistant".
-
Carry out the steps necessary for your editing:
-
Select the desired template for the table - depending on your layout.
-
Enter the number of columns and rows you want your table to have.
-
Select a width for the table.
-
Optionally place a tick in front of "Repeat headers on each page if you wish to do so.
-
Define the desired width of the text and number columns.
-
If you click Yes.
→ you might have to redo some of the manual formatting that you already applied to the table.
Note: After selecting a different template for an existing table, you will be prompted by firesys warning that manual formatting you previously applied to the table will be removed.
Table assistant – change table height
Change the height of the individual rows in your table by using the context-sensitive table menu in firesys.
Shrinking and stretching a table allows you to reduce (shrink) or increase (stretch) the height of tables by minute amounts.
-
Hover the cursor over the table you want to change.
→ The following open on the left side of the menu ribbon other context-sensitive tabs. -
Click on the "*firesys" tab.
-
Use the
“Shrink” menu options to reduce the table's height:
-
Click “Decrease the line spacing” to reduce the line spacing in the table by 0.1 pt.
-
Click “Decrease space before” to reduce the spacing between a paragraph and the paragraph above by 0.1 pt in all table rows.
-
Click “Decrease space after” to reduce the spacing between a paragraph and the paragraph below by 0.1 pt in all table rows.
-
Use the
“Stretch” menu options to increase the table’s height. The steps involved in stretching the table are identical to the steps required for shrinking the table.
-
Repeat the shrink or stretch commands as many times as necessary until the table has reached the desired height.
Note Click the menu options under “Reset” to undo the modifications and restore the spacing originally set in the style.
→ You have shrunk/stretched the table.
Table assistant – insert a row
Use firesys to add a new row to an existing table.
Insert a new row
-
Hover the cursor over the table row above or below of where you want to insert a new row.
→ The following open on the left side of the menu ribbon other context-sensitive tabs. -
Click on "Rows" in the "*firesys" tab in the
"Rows and Columns" group.
-
Click either “Insert above” or “Insert below” to add a row above or below the row where your cursor is pointed.
→ You have inserted an additional line.
Insert a new column
-
Click in the column of your table next to which you want to insert an additional column.
→ Additional context-sensitive tabs open on the left side of the ribbon. -
Click on "Column" in the "*firesys" tab in the
"Rows and columns" group.
-
Click on "Insert Right"/"Insert Left" to insert a column to the right or left of the column where your cursor is positioned.
-
Then call up the Table assistant to adjust the width of the table and columns.
→ You have added an extra column to your table.
Page layout
Select the type area for the current section or the entire document.
How to adjust the type area in your document:
-
On the "*Design" tab, in the "Page layout" group, click the "Layout functions" button and, in the submenu, click "Type area".
-
A dialog opens where you can choose between different settings for the page layout.
-
Click on the settings that you want to use for your layout.
The selected settings are applied to the document.
Apply colour scheme
Use this function to apply a previously created color scheme to your document so that it conforms to your design guidelines.
How to apply a colour scheme to your document:
-
On the “*Premium Layout” tab, in the “Premium Layout” group, click the “Apply” button.
→ A dialog will open where you can choose between all created colour schemes which one you want to apply to your document. -
Click the colour scheme you want to apply.
→ The selected colour scheme is then applied to your document.
Note: Please note that graphics will only be adjusted if you select the “Update all graphics” option here.
Alternatively, you can manually update your graphics afterwards to present them in the new layout.
Create a new colour scheme
Here you can create a new colour scheme and then apply it to your document.
To create a new colour scheme:
-
On the “*Premium Layout” tab in the “Premium Layout” group, click on the “Layout manager” button.
→ The Layout manager opens. -
Click on the button “Create” in the group “Colour scheme”.
→ A dialogue opens. -
Give your new colour scheme a name. After you have given a name
-
Click on “OK”.
→A dialogue appears in which you can choose whether your new colour scheme should be created on the basis of the current colour scheme or on the basis of the firesys layout. Select an option. -
Click on one of the options.
→Your newly created colour scheme is displayed in the Layout manager list.
Edit diagrams
Design your diagrams in the corporate design by adjusting the colour scheme and font.
This is how you design your diagrams in the corporate design:
-
Click on the “Layout manager“ button in the “*Premium Layout” tab in the “Premium Layout” group.
→ The Layout manager opens. -
In the Layout manager, select the colour scheme you want to adjust and click on the arrow symbol on the left.
-
Click on “Diagrams” underneath.
→ In the group “Diagrams” the “Edit” button is now selectable. -
Click on the “Edit” button.
→ The editing window opens. -
Select the elements you want to adjust.
-
The following things can be changed individually:
-
Font and colour of the axis labelling
-
Font and colour of the data caption
-
Colour of the individual data types (previous year, current year, forecast, budget)
-
Colour of the individual arrows (Positive development and Negative development)
Note: you can set custom colours via the RGB values as well as select them via the Office colour palette. Switch between these two options with the “User-defined colour” button in the lower left corner.
-
-
Click on "OK" to confirm your settings.
→ The settings made are transferred to the Layout manager. To apply the changes to the document, the layout must be applied (see Apply Colour scheme).
Edit tables
Design your tables in the corporate design by adapting the colour scheme to your wishes.
To edit tables using the Layout manager:
-
Click on the “Layout manager” button in the “*Premium Layout” tab in the “Premium Layout” group.
→ The Layout manager opens. -
In the Layout manager, select the colour scheme you want to adjust and click on the arrow symbol on the left.
-
Click on “Tables” underneath.
→ In the “Tables” group, the “Edit” button is now selectable. -
Click on the “Edit” button.
→ The editing window opens. -
Select the elements you want to adjust. The following things can be changed individually for all highlight variants:
-
Column highlighting
-
Bar colour (top and bottom)
-
Font colour, size and style
-
Cell wallpaper colour
Note: Related elements are displayed in the “Edit tables” dialogue when you hold the mouse pointer over the corresponding element.
Also note that you can set custom colours via the RGB values as well as select them via the Office colour palette. Switch between these two options with the “Custom colour” button in the lower left corner. -
-
Click on "OK".
→ You have edited a table in the Layout manager. To apply the changes to the document, the layout must be applied again (see Farbschema anwenden).
Edit texts
Design your texts in the corporate design by adapting the layout of the texts according to your wishes.
To edit texts in the Layout manager:
-
Click on the “Layout manager” button in the menu ribbon under “*Premium Layout” in the “Premium Layout” group.
→ The Layout manager opens. -
Select the desired colour scheme.
-
Click on the arrow symbol to the left of the desired colour scheme.
→ A drop-down menu opens. -
Click on the arrow symbol next to “Texts” in the drop-down menu.
→ Another drop-down menu opens with the template “Standard”. -
Select the standard template and click on “Edit” in the Layout manager in the “Texts” group.
→ The "Edit style sheet" window opens. -
Make the desired settings.
-
Click on “Ok”.
→ A dialogue appears in which you can select whether you want to change only the currently selected template or also all subsequent templates. -
Select the desired option.
→ The changes are saved and the style sheet is adjusted. To apply the changes to the document, the layout must be applied again ( see Farbschema anwenden)
Edit page colour
Customise the page colour of your document in the Layout manager.
To edit the page colour of your document, proceed as follows:
-
Click on "Layout manager" in the "*Premium Layout" tab in the "Premium Layout" group.
→ The Layout manager opens. -
Click on
, to open the detailed view of the colour scheme.
-
Click on
next to "Pages" to open the detailed view of the page colour.
-
Click on "Page colour".
→ The "Edit" button is now selectable. -
Click on
"Edit".
→ The "Select colour" window opens. -
Select the desired colour.
-
Click on "OK".
-
Click on
"Apply".
→ The "Apply Colour scheme" window opens. -
Click on the Colour scheme you have just edited.
→ The Colour scheme is updated.
⇒ You have changed the page colour of your document.
Customize bullets
Customize bullets in the Layout manager according to your individual preferences.
To edit bullets in Layout Manager:
-
Click the “Layout Manager” button in the ribbon under “*Premium Layout” in the “Premium Layout” group.
→The Layout Manager opens. -
Select the preferred colour scheme.
-
Click the arrow icon to the left of the colour scheme you want.
→A drop-down menu opens. -
In the drop-down menu, click the arrow icon next to “Texts”.
→Another drop-down menu opens with the “Standard” template. -
In the drop-down menu, click the arrow icon next to “Default”.
→Another drop-down menu opens. -
Click the arrow icon next to “Enumeration” in the drop-down menu and select the “Enumeration 2” style.
-
Then click on “Edit texts” at the top of the Layout manager.
→The “Edit style sheet” window opens. -
Click on the omega symbol under the “Bullets” item.
→The “Define bullets” window opens. -
Make the desired settings and then click “Ok”.
→The selected character is displayed under the “Bullet” item. -
To apply the settings in the style sheet, click “Ok”.<
→The changed settings are displayed in the Layout Manager.
Create Table of Contents
Clicking the "Table of Contents" button inserts a table of contents at the location of the insertion point.
Um ein Inhaltsverzeichnis einzufügen gehen Sie wie folgt vor:
Voraussetzungen:
-
The caret’s position is not within a table.
-
The caret’s position is not in the header or footer.
-
The caret’s position is not in a paragraph with a position frame.
-
The caret’s position is in an empty paragraph.
-
Place your caret at the point in the document where you want to create your table of contents. Note the prerequisites.
-
Click on the button "Table of contents" in the tab "*Premium Layout" in the group "Premium Layout".
→ The dialogue for creating a table of contents opens. -
Select how many levels of headings you want to display in your table of contents.
-
Under "Page number", place a tick in front of "Show" if you want to create a table of contents with page numbers displayed.
-
Under "Page number", place a tick in front of "Align right" if you want the page numbers to be displayed right-aligned.
-
Select a tap leader from the drop-down menu.
-
Click on "OK".
→ The table of contents is created. If you want to make changes to the table of contents, create a new table of contents at the same place, the old one will be deleted automatically.
Menu ribbon contents
Highlight data in text
This highlights in green all linked Excel objects in the body text, or else it removes the highlighting.
How to define coloured highlighting in firesys:
-
In Word, in the “*Content” menu ribbon, in the “Linked objects” group, click on the “Set” button in the “Selection” area.
→ A selection menu opensHere you can select whether you want to be supported by coloured highlighting for identifying data in text elements, lost Excel data links or firesys stories. -
Select the option you require.
→ The selected option is then executed and the coloured highlighting is displayed in Word.
Reference: If you no longer require the coloured highlighting that is currently set, you can use the “Remove” button to return the visual display to the its original status.
Insert data in text from file
Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document.
This is how you insert a data in text object directly from a file into Word with firesys:
-
In Excel, highlight the cell that you want to add to Word as a linked data object in the body text.
-
Give the selected cell a name as otherwise it cannot be imported.
-
Save the Excel file.
-
Repeat this procedure for each cell that you want to add to Word as a linked data object in body text.
-
Go to Word and position the cursor where you want to insert the data in the document.
-
On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “Data in text...” area.
→ A data selection dialogue opens.. -
Select the Excel file containing the worksheet with the cell you require (“data source”).
→ The linktext assistant opens -
The linktext assistant opens.
-
Select the worksheet containing the required cell.
-
Select the cell using the name that you defined in Excel.
-
If applicable, check “Set absolute value” if you want to add a number as an absolute value.
-
Click on "OK".
→ The linktext assistant inserts the data from the selected Excel cell into your body text.
Insert data in text directly from the selected Excel cell
Use this function to insert the content of a single cell that you have just selected in Excel directly as a linked firesys object in the body text of your Word document.
This is how you insert data in text objects directly from a selected cell in Excel into Word with firesys:
-
In Excel, highlight the cell that you want to add to Word as a linked data object in body text.
-
Give the selected cell a name as otherwise it cannot be imported.
-
Save the Excel file.
-
Switch to the Word file and position the cursor where you want to insert the data from the selected cell.
-
Click on the “*Content” tab in the “Excel data” group on the “Insert” menu, and select “Directly from selected Excel cells” or “Directly from selected Excel cells as an absolute value” under the section “Data in text&rdquo.
→ The linktext assistant inserts the data from the highlighted Excel cell into your body text.
Insert data in text directly from the selected Excel cell with options
Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document.
Preparatory steps:
-
So that you can enter a value with a different unit, it must be given a name in Excel beforehand. More information is available here.
This is how you insert a data in text object with a different unit into Word with firesys:
-
Select the cell of the value you require in your Excel document and then switch to the Word document.
-
Save the Excel file.
-
Position the mouse cursor at the point in your Word document where you want to insert the value.
-
Click on the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “Directly from the selected Excel cell with options” from the “Data in text” area.
→ A selection dialog opens. -
Select the operator, the factor and the rounded decimal places here. The “Result/preview” field enables you to check the data that was inserted into the text object.
-
Confirm the dialog with “OK”.
→ The value is inserted directly with the saved Premium Layout.
Insert a table from a file
Use this function to insert a table from an Excel file as a linked firesys table object in Word.
This is how you insert a table in Excel into Word with firesys:
-
On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “From file...” area.
-
The following dialog selection shows the Excel files that are already linked and open.
-
Files that are currently open on your desktop are displayed as
-
Files that you have already used to import objects into your Word document are displayed as
-
You can add documents by clicking the “Additional files” button or dragging the files directly to the corresponding button.
-
Select the Excel file from which the data is to be inserted (“Data source”).
-
A selection dialog opens. Select here the worksheet from which you want to insert your data.
-
Then select the range in the worksheet that you want to insert in Word. You can search both lists when they are expanded.
-
You can also select “Format manually” to prevent your tables being automatically adapted and formatted during insertion and updating Confirm the dialog with “OK”.
-
The table is inserted with the saved preset layout.
So that a table can be inserted, a table must have been formatted properly beforehand. You can find information about this here.
Insert table directly from the selected Excel range
With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object.
Preparatory steps:
So that a table can be inserted, a table must have been formatted properly beforehand. You can find information about this here.
This is how you insert a table in Excel into Word with firesys:
-
Select the table area in your Excel document and then switch to the Word document you require.
-
Save the Excel document.
-
Change to the Word document.
-
Position the mouse pointer at the location where you want to insert the table in the document.
-
On the “*Content” tab in the “Excel data” group, click on the “Insert” menu and select “Directly from selected Excel range” in the “Table” area.
→ The Table assistant opens. -
You can make optional settings relating to the table and column width in the table assistant that now opens. Then confirm the dialog with “OK”.
→ The table is inserted with the saved preset layout.
Update Excel contents
You can use these functions to update your linked Excel data with one click. This means that your business report always contains correctly maintained values.
This is how you update linked Excel objects with firesys, in three different ways:
-
Option 1: By using the “Update” function in the menu ribbon (shown in this video)
-
Use the mouse pointer to select a linked Excel object that you want to update.
-
In the “*Content” menu ribbon, in the “Excel data manager” group, click on the “Update” button.
→ A progress dialog appears.
Note:The “Update all Excel objects” function is also available on the split button.
→The Excel object was updated. -
Option 2: By using the context-sensitive menu in firesys
-
Use the mouse pointer to select a linked Excel object that you want to update.
-
Right-click in the object’s area.
→The context-sensitive menu appears. -
Here you can select the “Update” function.
→ A progress dialog then appears.
→ The Excel object was updated. -
Option 3: By using the menu ribbon in the Excel data manager
-
Use the mouse pointer to select a linked Excel object that you want to update.
-
In the “*Content” menu ribbon, in the “Excel data manager” group, click on the “Excel data manager” button.
→This opens the Excel data manager and the “Update” ribbon contains the update functions. -
Here you can choose whether you want to update all or just the selected Excel objects.
→A progress dialog then appears.
→ The Excel object(s) are updated.
Insert a graphic into body text
Inserts any graphics file (such as JPG, BMP, EMF, GIF, PNG, TIF) as a linked firesys graphics object in the existing format in your Word document.
This is how you insert a graphic from a file (into the body text):
-
Point the cursor at the position in your Word document where you want to insert the graphics.
-
In the “*Content” tab, click on the “Insert...” menu in the “Graphic” group and select “From file...”.
-
You can insert graphics by clicking on the “Additional files” button, or by dragging the files directly to the corresponding button.
-
Select the file you want to insert and confirm by clicking “OK”.
→ The graphic will be inserted
Insert a graphic directly from PowerPoint
Inserts a diagram created in Excel or PowerPoint as a linked graphic in EMF format. The source program can remain closed and you do not have to manually save the diagram as a graphic beforehand.
This is how you insert graphics from PowerPoint/Excel (into body text):
-
Place the cursor at the position in your Word document where you want to insert the graphic.
-
In the “*Content” tab, click on the “Insert” menu in the “Graphic” group and select “from PowerPoint...”.
→ The following dialog shows the already linked and open PowerPoint files: -
Files that are currently open on your desktop are displayed as “Open”.
-
Files that you have already used to import objects into your Word document are displayed as “Linked”.
-
You can add documents by clicking the “Additional files” button or dragging the files directly to the corresponding button.
-
Select the Excel file from which the data is to be inserted (“Data source”).
-
Select the graphics that you want to insert into your Word document. You can see a preview of the selected graphics in the right-hand window.
-
If you enable the “Including Microsoft Office graphics object” option, linkgraphics automatically imports the diagram’s automatically generated elements from the spreadsheet into the Word document.
-
If you disable this option, the elements are ignored as auxiliary graphics when imported.
-
Click “OK” to confirm your selection.
→ The graphic will be inserted.
Insert a graphic directly from Excel (into body text)
Inserts a selected graphic into the currently opened Excel document directly as a linked graphic.
-
In Excel, highlight the graphics that you want to import into Word as a linked graphics object.
-
Go to the Word file and point the cursor where you want to insert the graphics.
-
On the “*Content” tab in the “Graphics” menu, click “Insert...” and select “Directly from Excel”.
→ The graphic will be inserted
This is how you insert a graphic directly from Excel:
Create a story
Select the text you require in your master. This is saved as a new story and integrated into the master.
How to create a new story:
-
Use the cursor to select the area in your Word document that should be the content of the new story.
-
On the “*Content” tab, in the “Collaboration” group, click on the “Create” menu.
→ An information dialogue opens, indicating that the Master must first be saved. -
This opens an information dialog indicating that the master must be saved first of all. To continue, click on “Yes”.
→ A Windows save dialogue opens. -
A Windows save dialog then opens in which you have to specify the storage location of the new story.
-
"Click on "OK".
→ After a short calculation time, the selected area of the document is then saved as a new story at the specified path.
Create a version
You can manually create a new version of the current Word document (if desired with all Word, Excel, PowerPoint and graphics files) and assign a status to a version.
To create a new version in firesys
-
In the “*Content” menu ribbon, in the “Versioning” group, click on the “New version” button.
→ A dialog opens with the following settings options: -
Version type
Select whether you wish to create a main version or auxiliary version. The versions are automatically numbered before the point (new main version), or after the point (new auxiliary version). -
Workflow status
Gives you the possibility of assigning the new version one of three statuses “Draft”, “Pending” or “Approved”. -
Version comments
Comments on the version can be entered here. -
Click on "OK.
→ Versioning is carried out.
The Help and Search Function in the Managers
Use the help and search function in the firesys managers to get information about and filter individual items.
How to use the help and search function in the firesys managers:
-
Click on the button “Excel data manager” in the menu ribbon “*Design” in the group “Excel data”. The Excel data manager opens.
→ At the bottom right of the Excel data manager you will find both the “Search & Filter” and the “Help” function. -
If you click on the “Search & Filter” button, a task pane opens.
→Here you will find an overview of all filterable properties of the contents of the respective manager. As soon as you click on a filter, the display in the list view changes. Only the elements that correspond to the selected filter category are displayed. You can reset the selection at any time by deselecting the individual elements or by clicking on the “Cancel filter” button above the list. -
If you click on the “Help” button, the help area opens. All functions of the manager are displayed here with the symbol used and the function name. You can expand each list element to obtain further information. In addition, a red arrow is displayed for all elements that are permanently visible in the manager's menu ribbon. If you touch the functions with the mouse, it shows you the position of the button in the menu band of the data manager. If you click on an element, a descriptive text is displayed below the element.
Note: The help and search function is shown as an example for all managers using the Excel data manager.
The AutoCorrect function
You can use the firesys AutoCorrect function to define terms which can then be converted automatically into a different spelling, meaning that undesirable abbreviations can be avoided, for example.
How to add a term to the AutoCorrect function:
-
Select a word in your document.
-
On the “*Publish” ribbon, in the “Layout and wording” group, click on the lower half of the “AutoCorrect” button and select “Add term”.
→A dialog window opens. -
Here you can define your entries more precisely with the following settings:
-
Enter the incorrect spelling of the term here.
-
Enter the correct spelling of the term here.
-
Select a group for the new term or create a new group via “Manage groups”.
-
Add a comment to the term (optional).
Adds the term to the AutoCorrect function.
-
Closes the task field without adding a new term.
-
Click on "Add".
→ Der Begriff wird der Autokorrektur hinzugefügt.
This term
Replace with
Group
Comment
Add
Cancel
The layout check
The “Layout check” function checks your files for formal design problems and detects such problems faster and in more detail than the human eye ever could. It also immediately provides assistance with their correction.
How to use the layout check in Word:
-
Open the Layout check window via the “Layout check” button in the “Layout and wording” group on the “*Publish” tab.
→ The layout check task area opens and comprises three elements (Parameters/Results/Exceptions). -
Choose what should be checked in the “Parameters” group:
-
“Complete” conducts a comprehensive review all categories.
-
Under “Selection” you can choose from the following profiles for the check: colours, typography, tables, proofreading, Federal Gazette.
-
“Complete” conducts a comprehensive review all categories.
-
Click “Custom” to select what you want to check.
-
Then click “Start” to carry out the Layout check.
→ The Layout check is carried out.
The coupler
Use the coupler to join certain terms together so they are never separated through line breaks. Rules can be defined by using regular expressions.
This is how you insert a new rule in the coupler:
Note: The steps listed here execute a maximum example. The video does not include all steps.
-
First set the rules according to which non-breaking spaces between specific terms (text and/or numbers) should be inserted. In the “*Publish” ribbon, in the “Typography” group click on “Typography functions”.
→ The typography task field will open. -
In the task field, select “Add rule” in the following dialog on the “Coupler” tab.
→ A dialog appears. -
In the dialog box you can define the respective elements of the coupler rule in the “Left” and “Right” area.
-
Enter the exact text that is situated to the left or right of the non-breaking space or select placeholders:
-
[0-9] for any numbers
-
[a-z] for any letters
-
Select how the two terms should be coupled:
-
Couple:
A “normal width” non-breaking space; example: EUR 251 million. -
Closely couple:
inserts a narrow non-breaking space to reduce the spacing between two terms; example: 100 %. -
Hide spacing:
suppresses spacing between two terms. This function is particularly useful when different rules apply to different languages; example: the spacing required in German between the number and percent symbol should be suppressed in English -
Force space:
ensures a non-breaking space between certain terms even if it was not manually inserted when the text was input; example: “[0-9]” and “%” -
Click “OK” to confirm your selection.
→ You added a Coupler rule.
Left/right [0-9] and [a-z]
Hyphenation
Here you can determine where certain words can be hyphenated. You can also determine hyphenation suggestions on how certain words are to be hyphenated in Word.
How to enter a new word as a hyphenation rule:
-
In the “*Publish” menu ribbon, in the “Typography” group, click on the “Typography functions” button.
→ The typography task field will open. -
Select “Add rule” in the task field on the “Hyphenate” tab.
→ An entry dialogue opens./ -
Enter the term you require in the input dialog.
-
Place the cursor at the point(s) at which you would like the word to be hyphenated and click on the “hyphenate” button. Repeat the process at all points at which you would like the word to be hyphenated.
-
Click “OK” to confirm the dialog.
→ You have added a new syllabification rule.
Never hyphenate word
With the “Never hyphenate word” function you can define words that must always be kept together in your document and must not be separated with line breaks. This enables you to better adhere to your corporate identity, for example.
How to enter a new never hyphenate word rule:
-
In the “*Publish” menu ribbon, in the “Typography” group, click on the “Typography functions” button.
→ The typography task field will open. -
In the task field, select the “Add rule” button on the “Never separate word” tab.
→ An input dialogue opens. -
Enter the term you require in the input dialog.
-
Click “OK” to confirm the dialog.
→ You have created a new word never disconnect rule
Execute the typography functions
All typography functions are executed at a click. This sets couplers, excludes words from hyphenation and applies separations to specific words.
This is how you execute the firesys typography functions in Word:
-
Position the mouse pointer at any location in your document or, if you want to execute the typography functions for only a specific area in your document, select a text area in Word.
-
Select a range of text in Word to perform Typography functions only on a specific range in your document.
-
In the “*Publish” menu ribbon, in the “Typography” group, click on the “Start” button.
→ A query appears asking whether you want to execute all typography functions now. You can confirm this dialog box with “OK”. -
Confirm the dialogue with "Ok".
→ The typography functions are then executed by firesys
→ A results dialog appears showing you a summary of the changes that were made.
Reduce letter and word spacing
You can reduce your text quickly by a line with just one click.
How to change the letter spacing in your document:
-
Select the text area in your document whose letter spacing you want to change.
-
In the “*Publish” menu ribbon, in the “Typography” group, click on the lower half of the “Typography” button and press the button you require in the “Word spacing” function.
ReferenceIn this example, the letter spacing is changed to a smaller value than before by using the “Reduce” function.
→ The letter spacing of your selected text area is changed by 0.05 Pt.
Prepare web version
With the Prepare web version function, you can automatically generate an HTML document of your annual report at the touch of a button. If you wish, all your tables can be output in one complete file or in a single file.
To prepare a document as a web version:
-
On the “*Publish” tab in the “Web export” group, click on the “Prepare web version” button.
→ The "Prepare web version" dialogue opens. -
In the “Prepare web version” dialogue you can choose between different options to customise the web export according to your wishes.
-
Select the output directory in the "Web version" tab.
-
Select whether an HTML document is to be created.
-
Select whether the tables are to be exported together and/or individually.
-
-
Once all settings in “Web version” have been made, click on “Next”.
-
In the “Document” tab, you have the option of splitting your document individually and exporting graphics.
-
Once all settings have been made in “Document”, click on “Next”.
-
In the “Tables” tab, the exported tables can be given names, a logo can be inserted and other options can be set.
-
Click on the “Complete” button to start the export.
→ When the preparation of the web version is finished, there is a folder in the output directory containing the subfolders “Report”, “Graphics” and “Tables” with corresponding contents.
Prepare translation
With the help of the “Prepare translation” function, you can prepare your document(s) for export to a translator. All language-specific changes, such as run-length adjustments, change tracking or manual line breaks, are removed from the document.
How to prepare your documents for translation:
-
On the “*Publish” tab in the “Language and number format” group, click the “Prepare for translation” button.
→ The dialogue “Prepare translation” opens. -
Select the output directory.
-
Select a language with the appropriate suffix for the target document.
-
Specify which stories are to be prepared, optionally with or without a Master document.
-
Click on the button “Prepare...” to start the process.
→ A dialogue appears. -
Click on “Yes” if you want to save the document and prepare the translation.
→ When the process has stopped, a dialogue appears indicating that your document has been saved in the directory you specified. -
Click “Close” to close the dialogue.
Note: You can prepare your document(s) for export to a translator by removing all language-specific changes from the document, such as letter-spacing adjustments, change tracking, manual line breaks and anything else.
Prepare Text-Tagging
You can use this feature to create content controls.
To assign content controls to text areas in Word:
-
In Word, in the "Publish" ribbon, in the "XBRL Export" group, click the "Text Tagging mandatory elements" button.
→ A task pane opens on the right side. -
Select a text area in Word to which you want to assign a content control.
-
Click the desired element in the task pane.
→ The selected content control is assigned to the selected text area.
Excel
Design a table with the StyleGuide
Design your contents in Excel with the StyleGuide
This is how you change the formatting of your Excel table with the StyleGuide:
-
Position the mouse pointer in the row or cell in your Excel workbook that you want to format.
-
In “*Layout” menu ribbon, in the “Formatting” group, click on the “StyleGuide” button.
→ The StyleGuide work area opens. -
In the list area of the work area, select the formatting level you require.
→ The required formatting is now applied to the entire row in your table.
Prepare a table for import into Word
Use the following steps to prepare the table so it can be linked with your Word document.
This is how you can assign ranges to a table in Excel:
-
To be able to insert a table in Word, it needs an assigned name or print area. To do this, select the complete range of the table in your Excel document.
-
Click on the "Print Area" button in the "*Design" ribbon in the "Areas" group to set the previously defined selection as the print area.
→ The print area is set, the table can now be used in Word (see Insert a table from a file).
To assign a line type, proceed as follows:
-
Select the corresponding row or a cell from this row that you want to assign.
-
Click on "Line types" in the "Formatting" group in the "*Design" ribbon.
→ A menu opens with various options. -
Select the line type you want to assign - e.g. "Table header single" for the table header line.
→ The line type is assigned.
To assign a column highlight, proceed as follows:
-
Highlight the column to be highlighted.
-
Klicken Sie im Menüband „*Gestaltung“ in der Gruppe „Formatierung“ auf das Menü „Highlight“ und wählen Sie ein Highlight aus dem Dropdown-Menü aus.
→ Das Highlight wird zugewiesen.
Remove styles from the Excel workbook
Remove all unnecessary or duplicate styles from your Excel workbook.
How to remove superfluous styles:
-
In the “*Layout” menu ribbon, in the “Formatting” group, click on the lower half of the “StyleGuide” button and choose “Remove styles”
→ A dialog opens. -
In the dialog, select the styles that you want to remove...
-
either individually and manually from the list of displayed styles.
-
or use the “Select visible” function to select all styles that are currently displayed.
Note: You can use the search function at any time to filter the styles that are displayed according to your requirements.
-
Click “OK” to confirm your selection.
→ A final result report shows an overview of the number of styles that were removed
Note: If there are no unused styles in your document, an information dialog is displayed.
Format cells in color with the function “Highlight”
Colours cells in Excel yellow or removes this highlighting so that this can be transferred to Word. This way, numbers or texts in tables, that have not been defined yet, can be highlighted sustainably.
How to use the highlighting functions of firesys:
-
Open an Excel workbook and select the cells you want to highlight on the worksheet.
-
Click on the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Highlighting (yellow)" function.
→The selected cells are highlighted in yellow. -
Now switch to the corresponding Word document and select the appropriate table.
-
Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".
-
In the group "Hide numbers" you can activate the function "Transfer highlights from Excel".
-
Now you can close the firesys settings.
-
Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
→ The selected table is updated and the highlighted cells are highlighted in yellow.
Format cells in color with the function “Hide numbers”
Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator.
To use the highlighting functions of firesys:
-
Open an Excel workbook and select the cells you want to highlight on the worksheet.
-
Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Hide numbers (red)" function.
-
Now switch to the corresponding Word document and select the appropriate table.
-
Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".
-
In the "Hide numbers" group, you can activate the function "Hide Excel cells with a red background during import" and then specify the number of X-characters to replace the numbers.
-
Now you can close the firesys settings.
-
Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
→ The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.
→ The selected cells are highlighted in red.
Format cells in color using the “Ignore number format” function
Highlights the selected cells in green or deselects them so that when you transfer them to Word, the number format specified in Word is ignored.
How to use the highlighting functions of firesys:
-
Open an Excel workbook and select the cells you want to highlight on the worksheet.
-
Click on the "Highlighting" button in the "Formatting" group of the "Design" menu band and select the "Ignore number format" function (green).
→ The selected cells are highlighted in red - -
Now switch to the corresponding Word document and select the appropriate table.
-
Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".
-
In the "Hide numbers" group, you can activate the function "Hide Excel cells with red background when reading in" and then specify the number of X-characters to replace the numbers.
-
Now you can close the firesys settings.
-
Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
→ The selected table is updated and the number format is kept as desired and is not replaced by the format defined for the numerical values in Word.
Format cells in color with the function “Import brackets”
Selects or deselects the selected cells in blue so that the brackets are displayed when the table is transferred to Word.
-
In Excel, select the appropriate worksheet and cells.
-
In the "Design" ribbon, in the "Formatting" group, click the "Highlight" button (shown as a bucket icon).
-
Select the "Import brackets" (blue) option.
→ Select a width for the new table - The selected cells are highlighted in blue in Excel. -
Switch to the corresponding Word document in which the Excel table is linked and select the appropriate table.
-
In the "Contents" menu, in the "Excel Data" group, click on the "Update current Excel object" button.
→ The selected table is updated and the numerical values from Excel are replaced by the numbers in brackets.
Format cells in color with the function “Strikethrough”
Highlights the selected cells in light blue or removes this highlight again. With cells that are highlighted in light blue, two diagonal lines are set when they are imported into Word. This can be used in reports, for example, which are created in accordance with the Solvency II Standard.
How to use the highlighting functions of firesys:
-
Open an Excel workbook and select the cells you want to highlight on the worksheet.
-
Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Cross over (light blue)" function.
→Selected cells are highlighted in light blue. -
Now switch to the corresponding Word document and select the appropriate table.
-
Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".
-
In the group "Hide numbers" you can activate the function "Transfer highlights from Excel".
-
Now you can close the firesys settings.
-
Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
→The selected table is updated and the cells highlighted in the Excel document are crossed out.
Account calculation on automated worksheet
The “Sum” function allows you to create account calculations directly on the Automated Data Sheet.
This allows you to create account calculations and account aggregates using the "Sum" function on an automated worksheet:
-
Go to the automated worksheet
-
In the master value column, select the cells with the values you want to use for the account calculation/account aggregate.
Note: You must always select an empty cell so that the result of the account calculation/account aggregate can be inserted there.
-
Click the "Sum" button in the "Formulas" group in the "*Design" ribbon.
→ The "Account calculation/Create account aggregate" dialog appears. Here you need to define a unique name for the account calculation used, as well as select the account group in which the account values needed for the account calculation are located. -
From the list area with all account values, left-click to select the account values you want to add - and right-click to subtract. Optionally, you can also set a mathematical operator, a factor and an automatic rounding of the result.
-
Confirm the dialog with "OK".
→ The account calculation/account aggregate is displayed to you in the master value column and automatically written to the MeetingPoint.
Delete Empty Ranges from Excel spreadsheet
You can use the Empty Ranges function to delete empty columns and rows from your Excel spreadsheet.
To delete empty rows and columns from your Excel spreadsheet:
-
Select the table in which empty rows and columns are to be marked.
-
In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.
-
Select “Rows” in the drop-down under “Select”.
→ All empty rows in your selection will be marked. -
Then select “Columns” in the drop-down under “Select”.
→ All empty columns in your selection will be marked. -
Again, select the table in which empty rows are to be deleted.
-
In the tab “*Design” in the group “Ranges” click on the button “Empty areas”.
-
Select “Rows” in the drop-down under “Delete”.
→ All empty rows in your selection will be deleted. -
Again, select the table in which empty columns are to be deleted.
-
In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.
-
Select “Columns” in the drop-down under “Delete”.
→ All empty columns in your selection will be deleted.
Hide columns and rows in Excel spreadsheet
Hide columns and rows that you do not need using the "X/Y Ranges" function.
{{
How to hide individual rows and columns in your Excel spreadsheet:
-
Write an “x” to the left of the rows that are to be hidden. Write a “y” above the corresponding columns.
-
Select the table in which the rows/columns are to be hidden.
-
In the tab “*Design” in the group “Ranges” click on the button “X/Y areas”.
-
Select the option “Rows” in the drop-down under “Hide”.
→The rows marked with “x” are hidden. -
To hide the columns marked with “y”, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.
-
Select the option “Columns” in the drop-down under “Hide”.
→ The columns marked with “y” are hidden. -
To show the hidden rows and columns again, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.
-
Select the option “Rows and columns” in the drop-down under “Show”.
→ The rows marked with “x” and the columns marked with “y” are shown again.
Configure row types
Configure different row types for your Excel spreadsheets.
How to configure row types for your Excel tables:
-
In the “*Style” tab in the “Formatting” group, click on the “StyleGuide” split button.
-
In the drop-down menu that opens, select the item “Configure row types”.
→The dialogue “Configure row types” opens. Here you have the option to choose from different templates. -
Click on the desired element.
Note: The “Edit” and “Reset” buttons are activated when you click on the element. -
Click on “Edit”.
→ The dialogue “Assign styles” opens. Here you can search for all existing Excel format templates. -
Select the ones you want to assign to their selection and then press “OK”.
→ The dialogue closes. You will see your selection in the edited template in the "Configure row types" dialogue. -
To undo your adjustments, select the template you want to change.
-
Click on the “Reset” button to delete the format assignment.
→ The adjustments will be reversed
Premium Layout ribbon
Adjust grafic width
In firesys it is possible to adjust the width of the graphics in Excel to the type area in Word.
How to use the StyleGuide to assign styles to text areas in Word:
-
In Word, in the “Layout” menu ribbon, click on the “StyleGuide” button in the “Text” group.
→ A work area opens on the right-hand side. -
Select a text area in Word to which you want to assign a style.
-
In the StyleGuide work area, click on the style you require.
→ The selected style is assigned to the selected text area.
Formatting cells in color using conditional formatting
In firesys it is possible to use the functionality of conditional formatting known from Excel. With this you can quickly visualize your data sets in color or with symbols - which helps you to recognize trends quickly.
To assign a colored conditional formatting to table cells:
-
Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.
-
Click on the "Conditional Formatting" button in the "*Premium Layout" ribbon.
-
Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
→ The selected cells are now highlighted, depending on the selected formatting scale.
To assign a colored conditional formatting to table cells:
-
Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.
-
Click on the "Conditional Formatting" button in the "Design" ribbon.
-
Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.
→ The selected cells are now provided with colored arrows, depending on the selected formatting direction. -
Switch to the Word document in which the linked table was included.
-
Open the firesys settings and check that the function "Set highlighting" is selected in the group "Table layout and structure" in the tab "Data from Excel".
-
Select the desired table - and execute the function "Update selected object" in the menu band "Contents" in the group "Excel data".
→ The table is now updated and the corresponding conditional formatting with is applied to the table.
To assign a colored conditional formatting to table cells:
-
Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.
-
Click on the "Conditional Formatting" button in the "Design" ribbon.
-
Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion.
→ A dialog opens where you can specify the behavior of the conditional formatting more precisely. -
Select the "custom format" option in the right-hand selection dialog.
-
In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.
-
Save the Excel document and switch to Word.
-
Make sure that the setting "Font color" is activated in the group "Data from Excel" in the submenu "Table design and structure" in the firesys settings.
-
Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band.
→ The table is updated and the conditional formatting is applied to the table. .
Create a dictionary
If the texts of the master language are in the first column and those of the secondary language are in the second column of the print area, you can create a dictionary with just one click.
This is how you create a dictionary with firesys:
-
On the “*Translation” ribbon, in the “Dictionary” group, choose the “Create/update” button. In the dialog that follows, select one of the two options:
-
Single-language tables
In this case, the text is entered as the master language (language 1) within the print areas of your workbook. -
Bilingual tables
Choose this option if you have the texts of the master language in the first column and those of the secondary language in the second column of the print area. Column labels must be entered manually in the translation manager. -
Check the information in the following window.
Note:In the dialog you can see which worksheets in your Excel workbook in the dictionary or ignored. Sheets without a print area and protected sheets cannot be added to the dictionary. -
Click on
-
“Cancel” to correct the settings
-
“OK” to create the dictionary or
→ The dictionary is created.
Propose translations for tables
The translation manager automatically proposes translations from the firesys dictionary.
This is how you use firesys to propose translations for existing terms in the original language:
-
Position the mouse pointer in the cell in your Excel workbook where you want to have a translation proposed for a term.
-
In the “*Translation” menu ribbon, in the “Dictionary” group, click on the “Translation manager” button.
→ After the translation manager opens. -
the term is automatically selected in the currently selected Excel cell in the list view. Now click on the “Propose translation” button in the “Translation” group.
-
A dialog opens in which you can select
-
Whether a translation should be proposed for all terms or only the selected term
-
Which languages should be used.
-
Then click on “OK” and end the process.
→ Translations are then displayed in the list view of the translation manager according to your specifications.
Select language in Excel
Change the language in the Excel file and transfer the change to Word.
To change the language in the Excel file and change in Word:
-
In Excel, click on the button “Select language” on the tab “*Translation” in the group “Dictionary”.
-
Select the desired target language from the drop-down menu.
→ The data in the Excel file is translated in real time. -
Save your Excel file and open the Word document containing the translated data.
-
Click on the “*Publish” tab in Word.
-
In the “Language and number format” group, select the desired target language from the drop-down menu.
-
Then select all the Excel data in the text whose language is to be changed.
-
On the “*Contents” tab in the “Excel data” group, click on the “Update” button.
→ Your data will be translated.
Note: The number format set for the target language is also applied.
Use word list
Use the word list to add terms to your Excel file and include them in the dictionary.
How to use the word list in Excel:
-
Select the cell where a term is to be inserted.
-
On the “*Translation” tab, in the “Dictionary” group, click the “Word List” button.
→ The task pane "Word list" opens on the right with all the terms from the dictionary. You can use the search function to find the term you want to use. -
Select the desired term and click on the button “Add term” in the task pane “Word list”.
→ The term is inserted in the selected cell. -
On the “*Translation” tab in the “Dictionary” group, click the “Add directly” button.
→ The term is then transformed and included in the synopsis.
Create a validation
The validation function provides support with defining the required number pairs for the validation.
This is how you insert a new validation in Excel:
-
Click on the “Create validation” button in the “*Validation” menu ribbon in the “Validation and consistency” group
→ A selection dialog opens, displaying the various validation types. -
Select the “Single validation” function here.
→ Your Excel worksheet is extended with the validation work area. -
Use the mouse cursor to select the cell for which the validation should be created and in the “Value 1” range, click on “Transfer value from cell”.
-
Now select the cell in your Excel workbook that contains the second value of the validation and in the “Select value 2” range, click on “Transfer value from cell”.
-
Click “OK” to confirm the prompt.
→ An information dialog confirms that the validation was created. -
You can then use the “Go to validation worksheet” function to open the validation worksheet.
→ your validation is displayed.
To insert a new validation in Excel:
-
Click on the "Create validation" button in the "*Content" ribbon in the "Validations" group.
→ A selection dialogue opens that shows you the different validation types. -
Select the "Single validation" function.
→ The validation task pane is added to your Excel worksheet. -
Use the mouse pointer to select the cell for which the validation is to be created and press the "Take value from cell" button in the "Select value 1" range.
-
Now select the cell in your Excel workbook that contains the second value of the validation and press the button "Take value from cell" in the range "Select value 2".
-
Confirm the entry by clicking on "Ok".
→ An information dialogue confirms the creation of the validation. You can then use the function "switch to validation sheet" to open the validation sheet where your validation is displayed.
Create a Autovalidation
The autovalidation is a tool from firesys which quickly creates a validation by selecting a cell.
To create an Auto Validation:
-
To do this, open the Excel workbook in which you want to create an autovalidation.
-
Select the desired cell.
-
Click the "Create" button in the "Validation" group in the "*Content" ribbon.
→ A dialog opens -
Select "Autovalidation" in the dialog.
→ A dialog opens in which you can create an autovalidation and configure it according to your requirements. -
Make your adjustments.
→ Finally, you can inform yourself about all your validations on the validation sheet.
Approve a deviation
When using the validation function in firesys, you can additionally release deviations, which you want to release manually for further use, with one of the tools from firesys according to your requirements.
To approve deviations from validations:
-
Click on the purple arrow in Excel in the group "firesys" to switch to the validation sheet
-
On the validation sheet, select the validation for which you want to approve a deviation.
→ A dialogue window opens -
Click on the "Edit" function in the "Validations" group in the "*Contents" menu band. Select the "approve deviation" option here.
-
A dialog box opens, in which you can now enter the new delta value to determine the maximum deviation. Optionally, you can check the current values or add a comment to the approved validation.
.
-
Confirm the change with a final click on "Ok".
-
For control:
The validation value previously highlighted in red now changes to the step color black. Additionally, you can move the mouse over the red triangle on the right above the value. The information about the time, the author and the values of the approved validation will be displayed here.
Create a manual value
A manual value is one of the different value types in firesys, with which you can use the MeetingPoint to use numbers across files.
How to create a manual value:
-
Open an Excel workbook and activate firesys.
Note: A prerequisite is that a compatible MeetingPoint was already connected. -
In the “*Content” menu ribbon, in the “Master values” group, open the master value manager.
-
In the “Management” group, click on the “Add” button.
→ A selection dialogue box opens. -
Select the “Manual value” option.
-
An input dialogue opens in which you can assign a name and a numerical value to the manual value. You also have the option of entering a comment. Then confirm by clicking on “OK”
→ the manual value is created.
Insert a manual value
You can insert a manual value in Excel at any time in a cell of your choice (this cell must not contain another master value).
How to insert a transmitter value:
-
Open the Excel workbook in which the manual value should be inserted.
-
Select the cell you require.
-
In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
→ A work area opens. -
In the "Data type" range, select "Manual values" from the drop-down menu.
-
In the "Actions" range, select the desired value in the list area and then click on the left button "Insert selected value".
→ The manual value is inserted.
Creating a transmitter value
A sender value is one of the different types of values in firesys, with which you can use the MeetingPoint to use numbers across files. Here the distinction between the sender and the receiver value is important.
How to create a transmitter value:
-
Open the Excel workbook that contains the transmitter value you require.
-
Select the cell of the required transmitter value.
-
Click the "Insert" button in the "*Content" ribbon in the "Master values" group.
→ A dialog opens. -
Select the "Transmitter value" option.
Note: You must save the Excel file beforehand and you must select a cell that contains a number.
→ A dialogue box opens displaying the position and current value of the selected cell. -
Assign a unique label.
-
You can optionally add a comment.
-
Click on "Ok".
→ The transmitter value is created.
Insert a transmitter value
You can insert a sender value in Excel at any time in a cell of your choice (this cell must not contain another master value).
How to insert a transmitter value:
-
Open the Excel workbook in which the transmitter value is to be inserted.
-
Select a cell.
-
Click on the "Insert" button in the "*Content" ribbon in the "Master values" group.
→ A dialog opens. -
Select the option "Master value".
Note: You must save the Excel file beforehand and you must select a cell that contains a number.
→ The "Insert values" task pane opens. -
In the "Data type" range, select the entry "Transmitter values" from the drop-down menu.
-
Select the desired value in the "Actions" list area.
-
Click on the button
„Insert selected value“.
→ The transmitter value is inserted.
Create an Import definition
Define how the data from the upstream system is transferred “modelled” to the MeetingPoint with the help of firesys.
To add a new Import definition in the Data Import Manager:
-
Create an Import definition after which your data should be inserted into the MeetingPoint. Select the “Data Import Manager” button in the “Data Import” group in the “*Content” menu bar.
→ The data import manager opens. Choose the “Create” button in the “Import definition” group.
→ A dialogue box opens.Click on “Next” to go to the “File Settings” tab.
-
In the area “Number format” the decimal separator and the thousand separator of the import file are set.
Click on “Next” to access the “Assignment & Options” tab.
account
name
value
comment
-
The account, name and value columns are mandatory for data import; the Comment column is optional. All columns can only be assigned once.
-
In the area “Import options” additional options can be created that are applied when the data is read in. With the help of these options the data can be modelled and then transferred to the firesys-MeetingPoint.
-
In the video, an option is created to divide the account values by 1 million during transfer.
-
There are further options, the choices depend on the “target column”.
-
If you want to work with multiple read options, the order in which the options should be applied must be defined.
-
Click on “Finish” to enter the data import manager.
→ The created import definition is now available.
File selection: In the dialog you have the possibility to select a data source from which the data should be read. In the Details area, further meta information can be added to the import definition. As a target for your data you can use an already existing key date in the firesys-MeetingPoint or you can define a new one at this point.
File settings: Determine whether column headings are present in the import file If this is the case, the option will not transfer the first line of the file. Furthermore the column delimiter must be specified, so that firesys can recognize and transfer the records correctly.
Assignment & Options: In the area “Column assignment and preview” the data records must be structured. The area contains the live view of the import options. To import the data into the firesys-MeetingPoint the columns of the import file must be defined. There are four types for the data columns to choose from:
Create an account value
You can use the account workbook to quickly transfer a large number of individual account values to the MeetingPoint and then use those account values across files, for example, for an account calculation. In addition, account values stored in the MeetingPoint can also be inserted into Excel worksheets.
How to create an account value:
-
Open an Excel workbook and activate firesys.
Note: A prerequisite is that a compatible MeetingPoint was already connected. -
In the “*Content” menu ribbon, in the “Master values” group,
→ open the master value manager. -
In the “Management” group, click on the “Add” button.
→ A selection dialogue box opens. -
Select the “Account group” option and in the input dialogue box that opens, enter the name you require.
-
Then close the master value manager and in the “Account workbook” group, click on the “Create” button.
→ This opens a dialogue box -
which you can select the account workbook to which the account values should be written, and also whether you want to create a new account workbook or load an existing one from the MeetingPoint.
-
This opens a new Excel worksheet in which you can define the components of the individual account values.
-
By using the “Transfer” function (in the “Account workbook” group), you can transfer all of the account values that exist in the account workbook into the MeetingPoint.
→ You have created an account value.
Insert an account value
The insertion of an account value is shown in the “Insert values” work area. Here you can insert an account value in Excel at any time in a cell of your choice (this cell must not contain any other master value).
How to insert an account value:
-
Open the Excel workbook in which the account value should be inserted.
-
Select the cell you require.
-
In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
→ The "Insert" task pane opens. -
Select the value type "Account values" from the drop-down menu in the "Data type" area
-
Select the desired account value in the list area and click on the left button "Insert selected value" in the "Actions" area.
→ The account value is inserted.
Insert automated worksheet
Create an automated worksheet that allows you to efficiently insert master values from the MeetingPoint.
How to create an automated worksheet:
-
Open the workbook in which you want to create the Automated Worksheet.
-
Click on the "Insert" button in the "*Contents" menu bar in the "Master values" group.
→ A selection dialog opens -
select "Automated Worksheet".
-
Give your Automated Worksheet a name.
-
In the number columns, select which key dates your Automated Worksheet should have.
-
Confirm your entries by clicking on "OK".
→ The Automated Worksheet will be inserted with the selected values and you can continue to edit it.
Automate worksheet
Insert accounts or account calculations from the MeetingPoint. The corresponding account values are inserted based on the assignment of key dates for each column.
How to insert accounts and account calculations into an automated worksheet:
-
Open the worksheet where you want to insert accounts and/or account calculations.
-
In the master value column, select the row where the keydate should be inserted.
-
Click on the "Insert" button in the "*Content" menu in the "Master values" group.
→ Es öffnet sich ein Auswahldialog. -
A selection dialog opens in which you can now select "Automate worksheet".
→ Rechts erscheint der Arbeitsbereich „Arbeitsblatt automatisieren“. -
On the right hand side the task pane "Automate Worksheet" appears, in which you press the right button under "Actions" to have the keydate inserted automatically.
-
To insert an account calculation, select "Account calculation" in the drop-down area under "Data type".
→ Nun sehen Sie die Auswahl an Kontenberechnungen unter „Werte“. -
Now you can see the selection of account calculations under "Values". Select the account calculation to be inserted.
-
Then click on the left button under "Actions" to insert the values in the table.
-
Next, click on the row of the master value column where an account is to be inserted.
-
Select "Accounts" in the task pane, under Data type.
-
Under "Values", you can now select the account to be inserted. To find a specific account in a large number of accounts, you can also search directly for a specific account in the search field.
-
Under "Actions", click on the left button to insert the value of the account in the selected row.
Edit automated worksheet
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.
How to assign a new master value column to a value column:
-
Open the automated worksheet in which a value column is to be assigned to a new master value column.
-
Click on the "Edit" button in the "Master values" group in the "*Contents" ribbon.
→ The "Definition" task pane opens on the right. -
Click on any cell in the column that is to become the new master value column.
-
In the task pane, select the column that is to be modified and click the button in the "Master value column" row.
→ The name of the new master value column is now displayed in the row. -
Save the changes by clicking on the "Disk" in the upper left corner of the task pane.
→ The newly assigned master value column is grayed out and can now be filled.
Create account calculation
You can create an account calculation from individual account values, which allows you to add/subtract several items.
How to create an account calculation:
-
Make sure that account values are already stored in your MeetingPoint.
-
Open the Master value manager in the "*Content" menu ribbon in the "Master values" group.
-
Click on the "Add" button in the "Management" group.
→ A selection dialogue box opens. -
Select the “Account calculation” option.
→ The account calculation dialogue box opens. -
Here you have to enter a unique name for the account group that you used and select the account group in which the account values that are required for the account calculation are located.
-
From the list area with all account values, select those account values that you want to add with a left click, and those that you want to subtract with a right click.
-
You can also configure a mathematical operator, a factor and automatic rounding of the result.
-
Exit the dialogue box by clicking on the “OK” button.
→ The account calculation is now automatically transferred to the MeetingPoint.
Optional options:
Insert account calculation
The insertion of an account calculation is shown in the “Insert values” task pane. Here you can insert an account calculation in Excel at any time in a cell of your choice (this cell must not contain any other master value).
How to insert an account calculation:
-
Open the Excel workbook in which the account calculation should be inserted.
-
Select the cell you require.
-
In the “*Content” menu ribbon, in the “Master values” group, click on the “Insert” button.
→ A dialogue opens. -
Click on "Master value".
→ The task pane "Insert values" opens. -
In the work area, select “Account calculation” as the data type and then the account group you require and the correct key date.
-
The stored Account calculations appear in the list area. Select the desired Account calculation here.
-
If you do not require a manual rounding value, you can click on the left-hand button in the “Actions” area to insert the account calculation.
→ Account calculation is inserted in the selected cell
Edit account calculation
In firesys it is always possible to edit defined “account calculation” configurations afterwards.
To edit an account calculation:
-
Make sure that an account calculation already exists in your MeetingPoint.
-
In the “*Content” menu ribbon, in the “Master values” group, open the master value manager.
-
In the list view, navigate to the desired account calculation.
-
Click the “Edit” button in the “Management” group.
→ The account calculation dialog opens. -
From the list area with all account values, select those account values that you want to add with a left click, and those that you want to subtract with a right click.
-
You can also configure a mathematical operator, a factor and automatic rounding of the result.
-
Exit the dialogue box by clicking on the “OK” button.
→ The account calculation is now automatically adjusted in the MeetingPoint. -
If you have already inserted the Account calculation in your Excel workbook, click on the "Synchronise values" button in the "*Contents" ribbon in the "Master values" group.
→ The adjustments are transferred to Excel.
Preparatory activities:
Create an account aggregate
You can create and edit account aggregates using the Account Calculation/Create Account Aggregate feature in the Master value manager.
To create an account aggregate in the Master value manager:
-
In the ribbon, go to the "*Content" tab in the "Master values" group and select the Master value manager.
→ The Master value manager opens. -
Click the "Add" button in the Master value manager.
→The "Account calculation/Create account aggregate" dialog appears. -
Here you must define a unique name for the account aggregate used and select the account group in which the account values and account calculations required for the account aggregate are located.
-
From the list area with all account values and account calculations, select the account values and account calculations you want to add with a left click and the account values and account calculations you want to subtract with a right click.
Optionally, you can additionally set a mathematical operator, a factor, an automatic rounding of the result and write a comment. -
Confirm the dialog with "OK".
→ The account aggregate is automatically written to the MeetingPoint and can be viewed via the Master value manager.
Note: An account aggregate contains at least one account calculation.
The Rounding Wizard-Create a manual rounding
You can use firesys to round the results of your account calculations and account aggregates retrospectively using the rounding wizard.
To create a manual rounding for an account calculation/aggregate of accounts:
-
Open an Excel workbook and select the cell on the worksheet whose account calculation or account aggregate is to be provided with a rounding value.
-
Click on the “Insert” button in the “*Content” menu ribbon in the "Master values" group.
-
In the selection dialogue that then appears, select the option “Master value”.
→ The task pane “Insert values” opens on the right. -
Select “Account calculations and account aggregates” from the drop-down menu under “Data type”.
-
Then assign the desired account group and the desired key date.
-
Select an account calculation or account aggregate below.
-
Click on the symbol “Open the rounding wizard” in the group “Actions”.
→ The rounding wizard opens. -
Select manual rounding in the drop-down menu under “Rounding type”.
-
Enter the desired value under “Manual rounding value”.
-
Confirm your entry with “Ok”.
-
Select the rounded account calculation/account aggregate in the task pane.
-
Click on the button “Insert selected value” in the group “Actions”.
→ The account calculation/account aggregate is inserted.
The Rounding Wizard-Create a Manual Rounding with Delta
Using the Manual rounding value function in the Master value manager, you can subsequently round the results of your account calculations and account aggregates by adding a delta.
To create a manual rounding with delta for an account calculation/aggregate in the Master value manager:
-
Click on the button “Open Master value manager” in the menu ribbon “*Content” in the group “Master values”.
→ The Master value manager opens. -
In the Master value manager, select the desired account calculation/account aggregate.
-
Click on the button “Edit” in the Master value manager in the group “Administration”.
→ The editing dialogue opens. -
Select “Manual rounding value” in the editing dialogue.
→ The rounding wizard opens. -
Under “Rounding type” in the drop-down menu, select “Manual rounding with delta”.
-
Enter your desired rounding value under “Manual rounding value” and your desired delta under “Delta”.
→ The result of the manual rounding is displayed under “Final result”. -
Click on “Ok”.
→ The manual rounding is displayed in the Master value manager under the relevant account calculation/account aggregate.
The Rounding Wizard-Create a Fixed Value with Delta
Using the Manual rounding value feature in the Master value manager, you can subsequently round the results of your account calculations and account aggregates by adding a fixed value delta.
To create a manual rounding for a fixed value with delta for an account calculation/aggregate in the Master value manager:
-
Click on the button “Open Master value manager” in the menu ribbon “*Content” in the group “Master values“.
→ The Master value manager opens. -
In the Master value manager, select the desired account calculation/account aggregate.
-
Click on the button “Edit” in the Master value manager in the group “Administration”.
→ The editing dialogue opens. -
Select “Manual rounding value” in the editing dialogue.
→The rounding wizard opens. -
Under “Rounding type” in the drop-down menu, select the item “Fixed value with delta”.
-
Enter your desired value under “Fixed value” and your desired delta under “Delta”.
→ The result of the rounding is displayed under “Final result”. -
Click on “Ok”.
→ The manual rounding is displayed in the Master value manager under the relevant account calculation/account aggregate.
Synchronize values
You can quickly check the integrity and validity of your central values with the “Synchronize values” function and restore them if necessary.
How to synchronise your master values:
-
Ensure that master values already exist in your account workbook.
-
Open the Excel workbook whose master values should be synchronised.
-
In the “*Content” menu ribbon in the “Master values” group, click on the “Synchronise values” button.
→ A progress dialogue box appears informing you about the progress of the synchronisation and subsequently a result report. -
Clicking on “Close” ends the synchronisation.
Important note:
If any conflicts occurred during the synchronisation, an overview manager appears listing all of the conflicts.
Highlight master values
When working with firesys you can always quickly see which cells of your workbook are currently interacting with the MeetingPoint as a master value using the sheet inspector.
To highlight a master value on your worksheet:
-
Open an Excel workbook and activate firesys.
Note: It is assumed that a compatible MeetingPoint has already been connected. -
Open the Sheet Inspector in the "*Status" menu band in the "Information" group.
-
Click on one of the two buttons in the "Select master values" group in the task pane.
→ Click on the left symbol (select master values) to highlight all Excel cells that receive information from the MeetingPoint.
→ Click on the right symbol (select sender cells) to highlight all Excel cells that send information to the MeetingPoint.
Display central value history
In the Central Value Manager you can display the central value history for manual, transmitter and master values.
How to display the master value history for manual, transmitter and account values:
-
In the "*Content" ribbon, in the "Master values" group, click the "Master value manager" button.
→ The Master value manager opens. -
Select a value.
-
In the Master value manager, in the "Information" group, click the "Master value history" button.
→ A results dialog opens that shows you the history of the values.
Copy Key date
In the Central Value Manager, you can copy an existing key date plus the associated values and assign a new date to it.
How to copy a key date in the Master value manager:
-
In the "*Content" ribbon, in the "Master values" group, click the "Master value manager" button.
→ The Master value manager opens. -
Select the key date you want to copy.
-
In the Master value manager, in the Administration group, click the "Copy key date" button.
→ A dialog opens. -
Where you can assign a new date for the key date copy.
-
Confirm by clicking "OK".
→ The key date with the associated values was copied and given a new date.
Preparing a new or existing table for roll forward
You can prepare tables for your next reporting cycle using the “roll forward” function.
Einrichtung der Vorrollen-Funktion
-
Öffnen Sie das Arbeitsblatt, das die Tabelle, die für die Verwendung mit der „Vorrollen“-Funktion eingerichtet werden soll, enthält.
-
Klicken Sie im Menüband „*Inhalt“ in der Gruppe „Vorollen“ auf den oberen Teil des Split-Buttons „Arbeitsbereich“.
→ Der „Vorrollen“-Arbeitsbereich öffnet sich. -
Navigieren Sie mit der Maus in die Tabellenspalte, in die Werte aus einer anderen Spalte vorgerollt werden sollen. Klicken Sie auf das grüne „Hinzufügen“-Symbol in der Gruppe „Spalten“ im „Vorrollen“-Arbeitsbereich.
→ Im Listenbereich wird Ihnen nun die ausgewählte Spalte angezeigt. -
Navigieren Sie mit der Maus in die Tabellenspalte, aus der Werte in eine anderen Spalte vorgerollt werden sollen. Klicken Sie auf das grüne „Hinzufügen“-Symbol in der Gruppe „Spalten“ im „Vorrollen“-Arbeitsbereich.
→ Im Listenbereich wird Ihnen nun ebenfalls die ausgewählte Spalte angezeigt - und ein blauer Richtungspfeil zeigt Ihnen die Richtung der vorzurollenden Werte an. -
Klicken Sie abschließend auf das „Speichern“-Symbol in der Gruppe „Änderungen“ im „Vorrollen“-Arbeitsbereich.
→ Der Arbeitsbereich wird automatisch geschlossen.
Das Ausführen der Funktion „Vorrollen“
-
Klicken Sie im Menüband „*Inhalt“ in der Gruppe „Vorrollen“ auf den Knopf „Ausführen“.
→ Ein Dialog öffnet sich. -
Der Dialog zeigt Ihnen Informationen zum letzten erfolgreichen „Vorrollen“-Vorgang an und ermöglicht optional, einen Freitext anzugeben, der in die „Vorrollen“-Historie übernommen wird. Möchten Sie vor dem Ausführen des „Vorrollen“-Vorgangs Informationen darüber erhalten, welche Arbeitsblätter vorgerollt werden, können Sie auf den Knopf „Statusupdate klicken“.
-
Mit einem Klick auf „Starten“ wird der „Vorrollen“-Vorgang gestartet.
Hinweis: Ungespeicherte Änderungen müssen vorher unbedingt gespeichert werden - und zusätzlich legt firesys eine Sicherheitskopie Ihrer Arbeitsmappe an, der Sie ebenfalls zustimmen müssen.
→ Ihre Arbeitsmappe wird vorgerollt.
Prepare a new or existing table containing key date-dependent values for roll forward
You can prepare tables containing master values and key date dependent values for your next reporting cycle using the “roll forward function”.
Setting up the roll forward function
-
Open the worksheet containing the table that should be set up for using the “roll forward” function.
-
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. -
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. -
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. -
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
-
In the “*Content” menu ribbon, in the “Roll forward” group, click on the “Execute” button.
→ A dialogue opens. -
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.
-
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.
Roll forward with several identical key dates
The “Group” function allows you to create a group for roll forward at the selected position. This is advantageous if the table has several identical key dates.
How to prepare the roll forward of a table with several equal key dates:
-
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. -
In the task pane, under "Account group", select the account group for which the values exist.
-
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. -
Assign the appropriate key date to each column in the list area on the right.
-
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. -
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.
Edit an already rolled forward table
In firesys it is always possible to edit defined “roll forward” configurations of tables afterwards.
Processing the roll forward function
-
Open the worksheet containing the table with already defined roll columns.
-
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.
-
The “Columns” group contains the following functions:
-
Display columns:
-
Add column:
-
Change column:
-
Remove column:
-
/
Move column up/down:
-
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
Home page
The firesys functions in Word
The firesys functions in Excel
The firesys basic functions