Entering Data

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Creating a new WIP Report >

Entering Data

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 and they are filled automatically when you fill in the corresponding source cells. These include sum cells, as well as columns such as "Estimated Gross Profit" or "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

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 if you type text outside the default table, unwanted columns may appear (named "Column 1", "Column2", and so on).

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

 

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

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, bear in mind that, as part of Excel functionality, the actual value may be different from the value displayed in the cell, because of the cell formatting information. You can view at any time the actual value (the one that will be written to the XBRL instance) in the formula bar of Excel. Consider this example:

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

 

As you enter data in Excel, the add-in may round automatically values in those cells which are calculated automatically (the so-called "calculated" cells, they always have a white background). The add-in never rounds 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 the calculated cells will be rounded automatically, if necessary, in the XBRL instance file. This behavior is intentional; otherwise, it would lead to inconsistency warnings due to rounding. Note that values in the original Excel spreadsheet remain unaffected after you export data to an XBRL instance file.


© 2019 Altova GmbH