Processing evaluation data on the PC

If you specify the TABLE operand in addition to the list name in the LIST control parameter for KDCEVAL, the lists are created in table form. This type of processing is only possible for TASKS, TIMES, TCLASS, TACCL, TACPT, and TACLIST lists.

The lists generated in this way can be processed and formatted graphically on a PC using a spreadsheet program such as Microsoft^ Excel. The macro kdceval.xls is supplied on the WinAdmin data medium for Excel.

Carry out the following steps:

1. Transfer the list file generated by KDCEVAL to a PC using ftp or openFT and copy the macro kdceval.xls from the WinAdmin data medium on this PC.

   The macro requires that the file to be evaluated has the suffix .txt.

2. Call the macro (kdceval.xls) and read the list file into Excel. Excel then creates a separate spreadsheet for each list, as well as an additional sheet with summary information.

3. Process the individual lists as desired, e.g. by sorting a list and then converting it into a curve chart or bar chart.