The next step in the data extraction process is to refine how the data appears in
the data extraction table. Once the data has been extracted from the drawing, it is
displayed in columns on the Refine Data page of the Data Extraction Wizard where you
can sort and reorder columns, add a formula column, and so on. You can also link to
an Excel spreadsheet to add information from a spreadsheet to the extracted data.

From this page in the wizard, you can do the following:

• Reorder, rename, hide, and sort data in columns
• Format data in cells (for example: specify a data format or convert text to lowercase)
• Insert a formula column or insert a totals footer for individual columns
• Filter data in columns
• Display or hide the Count or Name columns
• Group identical rows or display them individually
• Preview the table in a separate window
• Create a data link to an Excel spreadsheet

By right-clicking on a column label in the grid view on the Refine Data page, you
access options for organizing the information the way you want it to appear in a table
or in the order you want it in an external file.

Data can be displayed in either an expanded or collapsed format. In an expanded format,
each property is displayed in an individual row in the data grid. In a collapsed format,
duplicate property names are grouped together. A Count column is automatically created
where the total number of properties are shown for each property row.

All columns that are visible in the data grid are output to the table or external
file. Any columns that have been hidden are not included.

You can sort a single column or multiple columns at the same time using the Sort Columns
dialog box.

You can insert formula columns into the data grid. Basic arithmetic operations (+,
-, *, /) are available including functions from QUICKCALC and CAL commands, such as
SIN, COS, and LOG. An icon displays in column labels for formula columns.

When identical rows containing numerical data are combined, where all rows containing
the same property are collapsed into one row, the sum of the data is displayed.

After the data has been organized, the next step is to choose an output format on
the Choose Output page.

Columns from Excel Spreadsheets

If you want to include columns from an Excel spreadsheet with the extracted data,
use the Link External Data dialog box to set up a link to an XLS file.

If columns from an Excel spreadsheet are extracted, you can organize, manipulate,
and hide the columns as data extraction columns. An icon in each Excel column label
distinguishes the spreadsheet columns from extracted data columns. The icon is not
displayed in the data extraction table.

If spreadsheet column names contain any of the following characters, they are removed
before the columns are displayed in the data grid on the Refine Data page:

< / “ : ; ? * | = â€ک

When a column from an Excel spreadsheet is labeled the same as a column from the extracted
drawing data, both columns are displayed; however, the Excel column label has -(External) added to the label name.