Data Tables

Data tables represent the second major document type of ImageWarp's workspace. They are used to display data obtained from measurements in a spreadsheet format. Data tables are usually loaded from ImageWarp's data files created by measurement tools.

The worksheet area of a data table is composed of data elements positioned in the grid cells. Each column of the grid corresponds to a certain measurement parameter, while each row corresponds to a specific object measured. You can edit the values in white cells by clicking a desired cell and entering a new value. You can also paste a worksheet function into it by clicking the Function button on the toolbar at the top of the frame. The two leftmost columns of the table show the ordinal numbers and class IDs of the objects respectively. They appear shaded, and they cannot be modified. ImageWarp displays the class IDs in colors corresponding to the equivalent indexes in the multiphase palette. The shaded row at the top of the grid lists the names of the parameters and the units in which they are measured. To edit a parameter field, right-click it and select Edit Param from the popup menu.

Each cell of the grid is assigned a pair of coordinates that consists of a letter and number. The letter represents the column and the number represents the row the cell is located in. "A" corresponds to the Class ID column, while "1" corresponds to the first data row in the grid. Thus, the abbreviation B3 defines the cell which contains the value of the first parameter measured for the third object. When you position the mouse cursor over a cell, a tooltip will appear showing you the coordinate of the cell and the numerical value or worksheet function stored in the cell.

You can select a desired cell by clicking it. To select a range of cells, press the left mouse button and drag over the desired range. You can add additional cells to your selection by holding the CTRL key and clicking the desired cells. To select an entire column, click the column heading. To select an entire row, click the row heading. To select the entire table, click the "Object" heading. The selected cells can be copied to the Clipboard and pasted to a different area of the table, another table, or an external application.

Like any window, a data table can be moved and resized. To move a data table, drag its title bar. To resize a data table, drag its borders. You can enlarge a table frame to its maximum possible size in the workspace by clicking the Maximize button on the right side of the image title bar. If the viewable table size exceeds the size of the window, you can use the scroll bars or arrow keys to pan the grid within its frame. If you make the width of a table frame bigger than the viewable grid size, the grid columns will be resized proportionally to fit the width of the frame. You can also change the size of each individual column or row. To increase or decrease the width of a column, drag the line to the right of the column heading. To increase or decrease the height of a row, drag the line below the row heading.

ImageWarp's data tables provide an extensive data analysis functionality. To sort the data by any selected parameter in the ascending order, double-click the corresponding column heading. If you double-click the column heading again, ImageWarp will sort the data in the descending order. To display the data in the original order, click the Refresh button. You can choose to display the data belonging to a certain class by selecting the desired class ID in the Active class box located on the toolbar at the top of the frame. The toolbar also provides the following commands:

   Refresh   

Click this button to reload the table from the data file and refresh its content. Note that all the modifications made to the data in the table will be lost.

   Resize   

Click this button to resize the table. The Resize Table dialog box will appear where you can select the number of rows and columns in the table. Select the Fill with zeroes check box if you want the new cells of the table to be filled with zero values.

   Paste formula   

Click this button to select a worksheet formula and paste it into a grid cell. When you do, the Paste formula dialog box will appear. If you inserted formulas into your table, use the extended DBX format when saving the table in order to retain the formulas.

   Export to Excel   

Click this button to transfer the data to Microsoft Excel for further analysis. If the Excel application is not open, ImageWarp will attempt to start it automatically before transferring data. If you receive an error message, make sure Microsoft Excel is installed in the system and you have enough memory to run both Excel and ImageWarp.

   Statistics   

Click this button to switch the table to the Statistics mode. In this mode, a table reports a statistical summary of the data for each measurement parameter. The column layout of this mode is identical to the one of the Standard mode, while the rows show the following information: the total number of objects (Count), sum of measurements for each parameter (Sum), minimum (Min), maximum (Max), median (Med) average value (Avg), geometric mean (GMean), harmonic mean (HMean), population standard deviation (Std), sample standard deviation (Stds), population variance (Var), sample variance (Vars) and mean of squares (Msq). To switch the table back to the Standard mode, click the Statistics button again.

   Chart   

Click this button to switch to display a Chart for a currently selected parameter.

You can adjust the print settings of the current data table by using the Page Setup command from the File menu. Use Print Preview to see how the table will look on paper.