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

You can use the standard Excel commands to paste cell values or entire rows into the WIP In Process and WIP Complete sheets. You can also add new rows to the body of the report table or delete existing rows in the standard Excel way. Some cells include calculations and SUM formulas. These cells are filled automatically when you fill in the corresponding source cells. These include sum cells and columns such as Estimated Gross Profit and Estimated Contract Revenue. Columns that contain formulas have the text header in italics and should not be edited, whereas editable cells have a gray background.

wip_cell_types

Predefined sheets

When you paste cells or rows into the predefined sheets, note the following:

 

The number of pasted columns should correspond to the number of columns in the predefined sheet. If you accidentally paste a larger number of columns or type text outside the default table, unwanted columns may appear (e.g., Column 1, Column2, and so on) (see screenshot below).

wip_unwanted_columns

To delete the unwanted columns, right-click the cell and select Delete | Table Columns. To prevent Excel 2013 from adding new columns and rows automatically, go to File | Options | Proofing | AutoCorrect Options | AutoFormat As You Type | Apply as you work and clear the check box Include new rows and columns in table.

 

When you paste data, it is recommended to keep only the values but not the formatting. Namely, select the Paste Values option when you paste cells or rows (see screenshot below).

wip_excel_paste_values

While generating the XBRL instance file, the add-in ignores any cell formatting information and exports the actual value of the Excel cell. However, the actual value may be different from the value displayed in the cell because of the cell formatting information. You can see the actual value (the one that will be written to the XBRL instance) in the formula bar of Excel (see example below).

wip_excel_values

In the example above, the value that will be written to the XBRL instance is 11987630. Note that the number accuracy reported in the XBRL instance file will depend on the value you selected for the Accuracy property.

 

As you enter data in Excel, the add-in may automatically round up values in cells which are calculated automatically: the so-called calculated cells, which always have a white background. The add-in never rounds up values in cells where you enter data (such cells appear with a gray background).

 

However, when you export data to XBRL, both the manually entered cells and, if necessary, the calculated cells will be rounded up automatically in the XBRL instance file. This action is intentional. Otherwise, it would lead to inconsistency warnings due to rounding up. Note that the values in the original Excel spreadsheet remain unaffected after you export data to an XBRL instance file.

 

© 2017-2023 Altova GmbH