Altova Work in Process XBRL Add-in for Excel, Version 2023r2

Menu Commands

Home Prev Top Next

This section describes the add-in commands available in the WIP tab of the Excel ribbon (see screenshot below). The commands in the WIP tab are organized into four groups: WIP Report, Import/Export, Windows, and WIP Add-in. The description of each add-in command is provided in the subsections below.

wip_ribbon_clean

 

WIP Report

Insert

Creates a new WIP report. This command is disabled if the WIP report sheet has already been inserted into the workbook.

 

Reset WIP Report Data

This is a split button which contains the following commands:

 

Reset WIP Report Data discards (deletes) any data entered in the sheets WIP In Process or WIP Completed and returns the Excel formulas to their default state. A confirmation dialog box prompts you for confirmation before data is discarded.

Restore only formulas restores the Excel formulas to their default state, without deleting any data.

 

For details, see Reset Data and Restore Formulas.

 

Report Completed Contracts

When selected, this option adds the WIP Completed sheet to the current workbook. This may be necessary if you want to report the completed WIP in addition to the WIP In Progress data.

 

Validate

Validates the WIP data against the underlying XBRL US WIP taxonomy and displays the validation results in a dialog box. For details, see Validate Data.

 

Import/Export

Import XBRL

Imports an XBRL WIP instance file to the current Excel spreadsheet. See Import WIP Data from XBRL.

 

Import Template

Imports data from custom WIP workbooks by means of predefined templates. See Import Data Using Templates.

 

Export XBRL

Imports an XBRL WIP instance file to the current Excel spreadsheet. See Import WIP Data from XBRL.

 

Windows

Toggle Actions Pane

Shows or hides the WIP Report Pane. By default, the WIP Report Pane is visible.

 

Toggle Validation Report

Shows or hides the Validation Report window. See Validate Data.

 

WIP Add-in

Help

Opens this help file in CHM (Microsoft Compiled HTML Help) format.

 

Add-In Activation

Displays the activation status of the add-in or provides options to enter or purchase a license key code.

 

About

Displays version information about the add-in.

 

Altova on the Web

Provides links to the Altova website, including links the Online Support Center, components download page, training and tutorials.

 

© 2017-2023 Altova GmbH