Datatable View

Datatable view

The datatable view displays a table of a track's data. It has its own toolbar for selecting the track and visible data columns. The data displayed in the table can be analyzed with the Data Tool or copied to the clipboard for pasting into a spreadsheet or other application.

1. Selecting a track

Select a track from the dropdown list on the datatable view's toolbar.

Selecting a track

2. Selecting visible data columns

Select the data columns displayed in the table by clicking the Data button and checking those of interest. The time column is always displayed.

Cells for which no data exists are empty. In particular, velocities and accelerations cannot be determined at the beginning, end, or where there are gaps in the position data.

Selecting data columns Data columns displayed in table

3. Sorting rows

Click a column header to sort rows in ascending order of the data in the clicked column. The sorted column name is displayed in bold font.

Sorted column

4. Formatting data columns

Right-click the data table and select the Format Columns... item from the popup menu to display the Number Format dialog.

Number format dialog

In the dialog, select the names of the columns you wish to format. Use the shift and control keys to add or remove names from the selection. Enter the desired format into the format field to apply it to the selected columns. The sample field shows the result of the format applied to the number PI.

Click the Help button to display sample formats.

Format help

5. Selecting data cells

Click and drag in the table to select cells. Double-click any cell to select all cells, or double-click a column header to select that column.

Control-click a cell to add or remove that row and column to or from the current selection. Control-click a column header to add or remove that column to or from the current selection.

Shift-click a cell to add that and all intervening rows and columns to the current selection. Shift-click a column to add that and all intervening columns to the current selection.

Selecting cells Selecting a column

Click the blank area below the data table to deselect all cells.

6. Copying data

Right-click the table and select Copy Selected Data from the popup menu to copy the selected cells to the clipboard. On Mac, select one cell, then hold down both the shift and control keys while clicking on a second cell to select the enclosed range and pop up the Copy menu.

Cell values may be copied in full precision scientific notation or using the format displayed in the table.

Copying the data

By default, cells are copied as text strings delimited by tabs between columns and line returns between rows. You can change the column delimiter using the Set Delimiter menu as shown.

Setting the delimiter

7. Defining new data columns with Data Builder

Right-click the table and choose Define... to display a Data Builder with which you can define custom variables called data functions for plots and datatables.

Click the appropriate Add button to add new data functions or to define parameters for use in function expressions.

Adding a data function Gravitational potential energy function

Data functions can be virtually any mathematical function of parameters, track-defined data columns, and other data functions.

Data Builder help

8. Analyzing data with Data Tool

Right-click the table and choose Analyze... to open all visible columns in the Data Tool.

Analyze menu item

The Data Tool provides statistical analysis including automatic and manual curve fitting of all or any selected subset of the data. For help using Data Tool, open Data Tool and click its Help button.

Scale dialog