A table is a statistical representation of data for a future or commodity over a specified period of time. You can create a table of the Worksheet data you entered in the Configuration window. To table this Worksheet data, select View>Table from the MIMIC menu bar, or select the Table button from the toolbar. MIMIC displays the table in the Table window.

To return to the Configuration window, select the Configuration button from the toolbar.

A table contains a Dates column and then a column of data for each symbol. For example, row 'A' from the Worksheet is the first column of data, row 'B' the second column of data, and so on. A table contains data for the dates indicated in the Date Options pane. At the bottom of a table, MIMIC displays table summary statistics.

In a table, there are certain options, features and settings you can make. These settings can apply to the following:

The options and settings for the current table are set in the Worksheet Options pane. To select options and settings for all future tables, select Options>User Preferences from the menu bar, and then select the Table tab.

For more information on the Table tab, see the section called “Table Tab” in this guide.

To print a table, select File>Print Table from the MIMIC menu bar, or select the Print button from the toolbar.

Table Options in the Worksheet Options Pane

For a current or active table, you can set the table data to skip all NaN values, skip weekend values, include table summary statistics, and set the display to ascending order. By default, all these options are selected.

MIMIC includes the following table options in the Worksheet Options pane:

Option	Function
Skip All NaN	Removes null data values for a date, it they exist.
Missing Data NaNs	Fills table with specified data for all NaN values.
Skip Weekends	Excludes weekend data (data for a Saturday or a Sunday). This feature can only be selected when using the following Execution Units in the Worksheet Options pane: Days, Hours, Minutes, Seconds and Milliseconds.
Table Summary Stats	Includes summary statistics, such as the sum, averages, percentages, and the standard deviation.
Table Date Sort Ascending	Sorts the table data by the oldest date first.

You can also include seasonal analysis information in your table. For more information on Seasonal Analysis, see the section called “Seasonal Analysis ” in this guide.