Inserting Report Values in MS Excel | Lucanet Knowledge Base

Documentation

Getting Started

Global Functions

Lucanet Lume

Administration

Data Hub

Consolidation & Financial Planning

Lease Accounting

Extended Planning & Analysis (xP&A)

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

MS Office Variants

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

Using the Area and Column Assistant

Creating and Editing Word Files

Versioning and Recovery of MS Office Files

Creating and Inserting Document Variables

Reviewing Layout Check Violations

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

Tax Compliance & Reporting

Banking & Cash Management

Data Collection

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.

How you insert report values into an Excel file in Disclosure Management depends on the Office variant you use. In Office for the Web and Office Native, the user guidance and interface are identical.

In Office for the Web and Office Native, proceed as follows to insert report values from a Data Import:

In the Excel ribbon, click Programming Assistant.

The Programming Assistant opens as a task pane on the right and is displayed as follows, for example:

Shows the 'Programming assistant' task pane of Disclosure Management with the 'Auto Programming' tab, the drop-down lists 'Selected column' and 'Data source', the field 'Search', a list of report values with the columns 'Alias', 'Name', '*(-1)', 'Value' and 'Data source', the 'Preview' and the buttons 'Clear' and 'Apply'. — Programming Assistant as a task pane in Office for the Web and Office Native

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

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

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

Click Apply.

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

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

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

Shows the 'Programming Assistant' window of Disclosure Management in MS Excel with the drop-down list 'Selected Column', the 'Auto Programming' tab with the field 'Filter', the drop-down list 'Data Source' and a list of report values with the columns 'Alias', 'Name', '*(-1)', 'Value' and 'Data Source', the 'Preview' and the buttons 'Clear' and 'Adopt'. Highlighted in red is the 'Auto Programming' tab. — '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 of the Programming Assistant, the imported values are assigned to cells in the Excel file in Disclosure Management.

The following options are available on the Auto Programming tab:

Option	Description
Selected Column	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	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	Data source from which report values are to be carried over.
List of report values	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. Alias: 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.
Preview	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.
Clear	Clears the preview and, after clicking Adopt, also clears the value and programming in MS Excel.
Adopt	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 of Disclosure Management.

Shows part of the list of report values in the Programming Assistant of Disclosure Management. The row with the item number '4711' 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.