User Defined Excel Format

Use this format to define each category as needed and display the categories in one sheet.

Step 1 of 4

  • Excel File Path: Define the template file path. When an Excel file path is defined, DFM uses this template to create an Excel report. Create the file beforehand.
  • Result Save Sheet Name: Select the sheet to use with the file from the Excel file path.
  • Summary Sheet Name: Select the sheet name for the summary information.
  • Automatically record all available Contents to MS/Excel: Automatically record the result in the Excel file when the result is added by the DFM items.
  • 1st Result Data Insertion Location: Select the cell where the result data from the first category will be saved.
  • Temporary Data Recognition ID Area: Select a cell for the program to use for the Temporary Data Recognition ID Area. Often, 1-A is selected.
  • Click Next.

Step 2 of 4

  • Result Data Column No.: Display the columns corresponding to the test result. For example, If you need 10 columns, enter 10 and click Apply.
  • Add Column[Field] No.: If the predicted number of columns exceeds five, enter that value and click Add Column[Field] No.. If you want to delete a column from a total number of five or less columns, select the column and click Delete Selected Column.
  • Table: Contains information on each Column in the Excel file.
  • Click Next.

Step 3 of 4

  • Available Record Type: Select the available record type and the needed categories. Create a more efficient report by eliminating items such as components that are not managed, and so on.
  • Add/Remove: Click Add to add the selected item or click Remove to remove the selected item.
  • Record Type for Export: Display the test types that will be recorded. To cancel a selection, select the item and click Remove.
  • Click Next.

Step 4 of 4

  • Record Type For Export(Row Attribute): Contains the selected categories. Use to confirm the contents that will be included in the final report.
  • Selected Cell Type: A category is activated in the bottom window when you select it from Record Type for Export. When you select this activated category, the selection in Selected Cell Type will be activated as well. Selected Cell Type can be accessed by selecting one of the provided formats.
  • An identical number of columns you selected in Record Type For Export is displayed here. Select the columns and define the contents you wish to provide. You can enter the category you need with Record Type For Export and Selected Cell Type. With Selected Cell Type, a combo box appears and you can select the category. The category is determined by the information gained from the ECAD interface and the DFM. Using Selected Cell Type is convenient and accurate.
  • If the information provided in each category is identical when defining the Item Group, use the Set Same Value in Column button to select the data as identical. Define other categories separately for convenience.
  • After completing Steps 1 to 4, click Finish/Excel Export to create a report as shown below.
  • Enter the column information selected in Step 2 of 4 and save the file. The saved file becomes the selected file in step 1 of 4.
  • A column is provided for each test subject. Each column contains the information that you defined in step 4 of 4.
  • The DFM verification results can be accumulated up to 10 times.