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

Entering Data

Home Prev Top Next

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.


Note that some cells include calculations and SUM formulas. These cells are filled automatically when you fill in the corresponding source cells. These include sum cells as well as 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.


When you paste cells or rows into the predefined sheets, be aware of 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 (named "Column 1", "Column2", and so on).


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 click to clear the Include new rows and columns in table check box.


When you paste data, it is recommended to keep only the values but not the formatting. Namely, select the Paste Values option when pasting cells or rows:


While generating the XBRL instance file, the add-in ignores any cell formatting information and exports the actual value of the Excel cell. However, bear in mind that 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. Consider this example:


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 (see Controlling Numeric Accuracy).


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