Source Data
There are two ways in which to get data into the program, you can either load data from an external file or project using the Load Data functionality, or enter the data directly into the grid / matrix.
The data grid / matrix format is a two dimenstional array, Strains horizontally entered and Tests vertically.
The above example shows the format of the data, with six strains, N898, etc. and three tests I51, etc. the strain names are entered in the first column, and the test names entered in the fist row.
Resultant data from the tests must be coded into a format suitable for computation. unit characters are coded as two state characters where the possession of a character is scored as "+" and its absence as " -". If you can't decide the test result score, then it is scored as "?".
To assist in manaully entering and editing data there are six edit feature, the features can be accessed by right clicking your mouse and using the pop-up menu or using control combinations on the keyboard.
Cut : Ctrl +X,
Cut to Clipboard a cell, range of cell, row or number of rows, coulmn or number of columns.
Copy : Ctrl + C,
Copy to Clipboard a cell, range of cell, row or number of rows, coulmn or number of columns.
Paste : Ctrl + V,
Paste from Clipboard a cell, range of cell, row or number of rows, coulmn or number of columns.
Insert : Ctrl + I,
inserts column(s)/row(s) at cursor position.
Delete : Ctrl + D,
Delete high lighted column(s) or row(s).
Clear : Ctrl + R,
Clear all data on pointed column or row.
Functions
Modes of operation
In "Read only" mode
- Data can be exported to an Excel or Text file but no changes can be made to data, all other button functions are grayed out
In ¡°Edit mode¡±
All button functions are available and data can be edited directly
Load Data
Load from other Project in database : Choose a project you made before. Click !
Load from Text File : Tab delimited text file
Load from MS Excel File : Excel file
Save
Saves the data to the internal database and changes the mode to ¡°Read only¡± locking the data for editing
Erase all
Data is removed from the database, before the program executes this command a dialogue box is displayed asking for confirmations as once erased data is not recoverable, unless you have exported it before hand.
Export Data
Save to Excel file : Save as a Excel file
Save to Text file : Saves as a tab delimited text file.