Creating and Editing Excel Files

Getting Started

Global Functions

Lucanet Lume

Data Hub

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

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

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

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

Excel files form the main basis for using report data from the source system. For report generation purposes, data from the Excel files can be embedded in Word files in such a way that the values in the report are updated automatically if the Excel data are updated, e.g. as a result of an additional data import. To that end, an Excel file can be assigned to every chapter of a Disclosure Management document in the Cockpit.

Excel files can be created in the Cockpit or in the detail view of a chapter. Alternatively, existing files located in the local file directory can be assigned to a chapter to create a new Excel file.

To create an Excel file for a chapter:

Click Cockpit in the overview or click Document in the function bar.

Opening a document in Disclosure Management

Click the three dots icon

at the end of the desired chapter row.

Choose MS Excel | Add Excel file or MS Excel | Add external Excel file from the context menu.

MS Excel will open with a new workbook. As soon as you Check In the file, it will be displayed in the MS Excel column of the Cockpit.

Excel files assigned to a chapter can be opened from the Cockpit for editing purposes.

To open an Excel file for a chapter:

Click Cockpit in the overview or click Document in the function bar.

You have two options for opening the file:

Click the desired file.

Click the

three dots icon

at the end of the desired chapter row and choose

MS Excel | Open Excel file

from the context menu:

The file will open in MS Excel and can be edited using the Excel ribbon.

Excel files can be edited using the Excel ribbon. The Excel ribbon provides specific functions tailored to Disclosure Management:

Displays the top bar of MS Excel. Displays the Excel ribbon with all its functions. — Excel ribbon for Disclosure Management

The Ribbons for Disclosure Management chapter provides an overview of all the functions available in the Excel ribbon.

Have you not installed the ribbons yet? Then go to the Toolbox of Disclosure Management and first install the Excel ribbon, the Word ribbon, and the Dispatcher. The Dispatcher is responsible for communication between Disclosure Management and the MS Office files.