4.3. Calculated data

4.3.1. Tote controls

As you have seen earlier, the Tote performs a number of calculations while you are stepping through a plot. Of the two symbols at the foot of each secondary column in the Tote, the first one is the "remove" button, which removes that track from the Tote.

There is no need to remove the primary track from the Tote, just make another track the primary track by right-clicking on it in the plot.

4.3.2. Comma-separated Variables

The second symbol is the "copy" symbol which copies the current column of data to the clipboard in a comma-separated-variable text format.

4.3.3. Microsoft Excel

This information can be pasted directly into a spreadsheet such as Microsoft Excel.

Alternatively, Debrief can output a whole series of calculated data for each track in the Tote. To do this, you must enter the Track & Time Toolbox panel by clicking the right-most button on the second row of buttons shown above:

4.3.4. Copying data to clipboard

The Copy data to clipboard operation within the Track & Time Toolbox performs calculations between a number of tracks, outputting the data to the clipboard in tab-separated variable format. This textual data is ideally formatted for further analysis in Excel.

A header line is written first, which indicates the contents of each column:

The results from the primary track are listed first, which (as in the Tote) do not show results of calculated operations:

CARPET 12/Dec/95 05:00:00 000 02.00 269.7 n/a n/a n/a n/a 0500 0500

Lastly the secondary tracks are listed:

 BUNKUM 12/Dec/95 05:50:00 000 00.00 000.0 12381 311.0 R49.0 R0.264 F5 0550

The last two columns output give identifier information: the first of these is the name of the current item in this track, and the second is the point in the primary track nearest to the current time stamp: that-is the point in the primary track which has been used for the calculated results.