Mode of Excel Files

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

The stored Excel files can generally be differentiated between in terms of whether and how they are programmed. The method for inserting and updating the values determines their mode.

The mode defines how report values from the Disclosure Management database are inserted and updated in the Excel tables for the chapters of a document.

The mode depends on whether and how the file or table is programmed. The mode of an Excel file tells you how report values are imported and updated.

The mode is assigned automatically by Disclosure Management.

The following modes exist for Excel files:

In Automatic mode, the Excel table is programmed so that Disclosure Management automatically inserts report values. The report values match the source system's items or accounts imported into Disclosure Management or are made up of calculation operations of multiple items. Manual changes to individual report values can only be made in the Data View.

In Semi-automatic mode, the Excel table is programmed so that at least one report value is recorded manually in the data view or in the Excel table. The manually maintained report values should ideally be entered and edited in the Data View. In addition, report values are automatically inserted and updated by Disclosure Management via items from the database.

In Manual mode, the Excel table is programmed so that all report values of the Excel document have to be maintained manually in the data view or in the Excel table. No report values are automatically inserted or updated.

If an Excel table is not programmed, it has no mode. Such tables are purely manual tables and are only edited in MS Excel itself and not managed by Disclosure Management. That means they cannot be edited via the data view and no history is maintained for the existing values.