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.
If your template contains five rows or columns to store data for measurement results, the template can store data only for five runs. When you execute the Excel Form report command after five runs, PC-DMIS displays the message that it cannot append to the report file because all the defined rows or columns in the selected Excel form report template are filled up. You can rename the report file in the Results folder and try again.
To record the data from the measurement routine executions that are more than the defined rows or columns, do one of the following:
Rename the Excel form file in the directory defined in the Report Settings dialog box and then re-execute the Excel Form report command.
Modify the template to add more rows or columns for the amount of data being collected. You need to associate a measured value field and then re-execute the Excel Form report command.