Menu Commands
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 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.