Inserting Report Values in MS Excel

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

The Lucanet Disclosure Management User Interface

All Steps at a Glance

Basic Configuration

Dashboard

Configuring a Document

Cockpit

Creating and Editing Chapters

Creating and Editing Periods

Importing Data

Working with MS Office Files

Ribbons for Disclosure Management

Creating and Editing Excel Files

Mode of Excel Files

Configuring an Excel File

Names and Name Extensions in MS Excel

Creating and Editing Columns

Inserting Report Values in MS Excel

Defining Outareas

Programming References

Using Layouts in MS Excel

Inserting Tables From ESG Reports

Creating and Editing Word Files

Versioning and Recovery of MS Office Files

Creating and Inserting Document Variables

Creating and Editing Validations

Using the Data View

Using the XBRL Tagger

Creating Result Document

Rolling Forward or Copying a Document

Editing Documents in the XBRL Tagger

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Disclosure Management provides the Programming Assistant for inserting report values in Excel files. This allows previously imported report values to be inserted in an Excel table easily and conveniently.

Data to be used from an ESG report created with Lucanet ESG Reporting are inserted into an Excel file using a separate function in the Excel ribbon. How to do this is described in the chapter Inserting Tables From ESG Reports.

To insert report values from a Data Import in MS Excel:

Double-click a cell in a value column or programming column. The Programming Assistant will then be displayed in MS Excel:

The Programming Wizard of Disclosure Management is displayed in MS Excel. The 'Auto Programming' tab is open. The tab heading is highlighted in a red border. — 'Auto Programming' tab in the Programming Wizard in MS Excel

Configure the Selected Column and Data Source drop-down lists.

If necessary, enter a character string in the Filter input field to filter the list of report values.

In the Alias column of the list of report values, activate the check box of the value that you want to carry over to the Excel file.

Click Adopt.

In the Excel ribbon, click Check In to apply the changes in Disclosure Management.

You should be aware that the programming columns in the Excel file might be on top of each other for the current year and previous year. When using the programming column, it is therefore important to ensure that the desired column is set in the Selected Column drop-down list before inserting report values.

On the Auto Programming tab, the imported values are assigned to cells in the Excel file in Disclosure Management.

The following options are available on the Auto Programming tab:

Depending on whether you have opened the Programming Assistant via a value column or programming column, the value columns or programming columns available in the Excel file will be shown to you for selection in the Selected Column drop-down list.

Filter value for the report data. The specified filter will be applied across all four columns, meaning you can also search for texts, names, or even individual values.

Data source from which report values are to be carried over.

Once all the settings have been configured, a list will be displayed with all the report values that can be inserted in the Excel file:

The Alias column displays the account numbers or item numbers from the data source or Data Import.

Activate the check box of the value(s) that you want to carry over to the Excel file.

The selected report values are displayed here as a preview along with

their name (account/item numbers from the alias column),

their value,

and the programming in the programming column.

Clears the preview and, after clicking Adopt, also clears the value and programming in MS Excel.

Adopts new/changed programming in the Excel file.

After clicking

Adopt

, a semicolon followed by the selected alias (e.g.

;10100230

) will be entered in the programming column. The value of the selected alias will be entered in the value column. With immediate effect, the current report value of this account/item number will always be displayed in the corresponding value column.

To apply the changes in Disclosure Management, the Excel file must be subsequently checked in.

If an item number that does not exist in the current data import is addressed in the programming column, this will be highlighted in red and labeled as Unknown in the Programming Assistant.

Displays part of the Programming Assistant. A row contains the entry 'Unknown' in red in the 'Name' column. — An unknown item number is displayed in the Programming Assistant.

If this item number is present again in a later data import, the corresponding report value will be displayed as normal. For example, this may be the case when zero values are not imported.

As soon as the report value of the item number is no longer zero in a later import, it will be displayed in the Programming Assistant along with its name, value, and data source.