User Defined Excel Format

Create a user defined excel format.

Excel File Setting

  1. Excel File Path: Define the path of the company standard report file to be used for saving the result.
    If you do not have the standard report file, you have to create a blank excel file beforehand.
  2. Result Save Sheet Name: Select the sheet to save the result.
  3. Summary Sheet Name: Select the sheet to save the test summary.
  4. Net Summary Sheet Name: Select the sheet to save net group summary.
  5. Auto Add to Available Record Type: Automatically add the available test item.
    If you select this option, you can skip the next step.
  6. Result Data Column No: Create the number of columns corresponding to the test result.
    You should remember the contents of the report you want to record, and predict the type and number of results. For example, if you need 10 columns, enter 10 and click Apply.
  7. Add Column [Field] No: Create the number of columns with a predefined number.
    1. Enter the number of columns you want after that and click Apply.
    2. If you want to delete a column, select the column and click Delete.
  8. Use Header Name On Excel File: DFE defines the name of each column using the default name.
  9. 1st Result Data Insertion Location: Select the cell where the result data from the first category is to be saved.
  10. Temporary Data Recording ID Area: The history of the tests is provided in the user defined format, so you should select a cell for the program to use for this feature. Generally, you should select 1-A.
  11. Next: Go to the next step.
  12. Save: Save the current setup environment. (*.DFEE file)
  13. Save As: Save the current setup environment with a different name.
  14. Load: Load the pre-saved setup environment file.

Set Row of Test Report

If you selected Auto Add to Available Record Type in Excel File Setting, you can skip this step.

  1. Available Record Type: View a list of all test items and sub items available.
    You can selectively choose the needed categories and move them to the Record Type for Export section by clicking Add.
  2. Record Type For Export: View the test items to be recorded.

Set Column of Test Report

  1. Record Type for Export: View the selected categories of Set Row of Test Report.
    1. Check Item: View test item name list.
    2. 2nd ID: View the test sub-item name list.
  2. Select Cell Type: When you select a category from Available record type, it is activated on the 3 window. When you select this activated category, the selection in 2 will be activated as well. You can select the categories in Available Record Type. Record Type for Export can be accessed by selecting one of the provided formats.
    1. User Defined String: Configure each column and row manually.
    2. Predefined Item: Use the predefined item for each column of report. Click Set Predefined Item List.
      The Predefined Item dialog displays. The Predefined Item List shows available report items.
  3. Choose the items that are needed and move them to the Selected Predefined Item List by clicking Add.
    The Selected Predefined Item List shows the report items to be recorded.
  4. Apply Set Same Value in Column: DFE fills every row of each column with identical contents. You can also define other categories separately for convenience.
  5. Column setup section: View all of the columns and rows that you defined.
    You can modify them by double-clicking each item.
  6. Click Finish/Excel Export to create a report.
    The following information is shown.
    • Title of each item.
    • Each test subject has a column. Each column is provided with the contents that you defined in Set Column of Test Report.
    • Zoom view of error point.
    • Position of error point in PCB.

    The test history of up to 10 tests can be saved in the same Excel report file.