[WT-support] Statistics in Wintest

[Bob Wilson, N6TV]

On Tue, Oct 29, 2013 at 3:12 AM, paterson gordon <
gordon.paterson at blueyonder.co.uk> wrote:

> Is there any options to see STATS by op?  We used OPON/ OPOFF.


One manual way to get such statistics by operator is to export the operator
field to a text file (.TXT or .CSV), which will show you the operator who
made every QSO (if you select the Operator column using the "Options"
button).  Create an Excel spreadsheet with two columns:  the Cabrillo
"QSO:" line in column 1 (from the .log file), and the Operator Call (from
the .csv file) in column 2.

Use Excel filters to select one set of "QSO:" lines per operator.  Export
those lines to create a separate Cabrillo file for every operator.  Add a
header and trailer line to each Cabrillo file.

Then use the Cabrillo Statistics Program (http://bit.ly/cabstat) or
Win-Test to generate one rate sheet per Cabrillo file.

If you're comfortable creating "Pivot tables" in Excel, you could also
generate the rate sheets directly from the .CSV data.

73,
Bob, N6TV
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.f5mzn.org/pipermail/support/attachments/20131029/2a1ac874/attachment-0001.html>