SEND RESULTS TO… This option has a submenu with three selections:
• Printer Routes the data in the Results Window to the temporary printer file 'printfile' whenever the 'p' key is struck or OUTPUT RESULTS is selected. Actual printing occurs when you close this file with PRINT\CLOSE FILE. After printing the 'printfile' remains available (it is overwritten if any additional printing is performed).
• Tabular file... Opens a tabular (spreadsheet-format) text file for storing results generated by analysis menu operations. Data are saved in a tab-delineated format readable by many spreadsheet programs or statistical packages. Optionally, you can save results to an Excel-format file (double-clickable directly into Excel, with an appropriate Excel icon). Besides the results data, the spreadsheet file also contains column labels. Mean, SD, N, and variable name are always saved; other parameters (start of block, end of block, start and end time, elapsed time, analysis type, mass, and channel number and file name) are user-selectable. You can also enter one or two user-typed 'notes' with each case (edit fields appear in a window over the COMMENTS window when the 'p' key is struck; hit 'return' or click the window close button when the values are correct). Certain analyses, such as regressions, do not fit this format and cannot be put into tabular files.
The default is one set of analysis results per line in the spreadsheet, but if you've selected Excel format you can use the 'Multiple results per line' option to save the results from two to 15 different analyses per line. You need to specify how many results you want to save initially (you can't change this when the file is in use). Therefore, you need to keep track of the order of analyses so as to avoid confusion later on (scripting can help here). If you elect to use notes or store animal mass, these items are saved only once per spreadsheet line (not every time you save an analysis result).
Here is a general format for one line from a file with 2 results per line, with both user notes selected and mass saved:
Note1 • Note2 • M1 • SD1 • N1 • var1 • anal1 • mass • M2 • SD2 • N2 • var2 • anal2 <CR>
where • is a tab character, <CR> is a carriage return character, M1 = mean of the first result, SD1 = SD of first result, N1 = sample size of first result, var1 = variable for first result, anal1 = analysis for first result, mass = body mass, M2 = mean of the second result, etc.
Storage of results (in memory) occurs when you press the 'p' key (with the Results window open), or select OUTPUT RESULTS. The spreadsheet file is not saved to disk until you exit from LabAnalyst or use the PRINT \ CLOSE FILE option in the FILE menu.