PC-DMIS either creates a new Excel Form Report file for each execution or appends the results to the existing report file to fill up the data in the template.
To append data, you need to set the same report file name for each execution.
Depending on the template’s orientation, PC-DMIS appends the data in two ways:
PC-DMIS adds the dimension for each measurement execution as a row or column in a continuous sequence at the end of an existing file.
PC-DMIS adds the measured values to the measurement result's row or column.
Example of measured value data appended in multiple columns for each execution
To do this, you need to associate the Measured Value field under the Dimension group with the required cells in the template.
To associate multiple cells with a Measured Value field, follow these steps:
There are two ways to select multiple consecutive cells in a row or column:
Option 1
Hold down the Shift key and click the first cell in a row or column. Continue to hold the Shift key and click the last cell in the row or column.
Option 2
Left-click the first cell to select it. Keep the left-mouse button pressed on the first cell, and drag the mouse cursor over the cells in the same row or column to multi-select them.
To select multiple non-consecutive cells, hold down the Ctrl key and click the cells. Click a selected cell again to unselect it.
Drag the Measured Value field under the Dimension group to the selected cells.
This step associates the Measured Value field with the required cells.
PC-DMIS decides whether to append the measure data at the end of the existing file, or add the measured values in multiple columns based on the association of fields in a template.
If you associate a measured value field with multiple cells in a template and set it as a data area, PC-DMIS outputs the results in multiple rows or columns.
If you associate a measured value field with a single cell in a template, and set it as a data area, PC-DMIS outputs the results at the end of an existing file.