UNISTAT - the ultimate Excel statistics add-in

2.2.0. Output Medium Toolbar

The Output Medium Toolbar appears on Data Processor, Output Window and Graphics Editor window after performing a procedure. In Excel Add-In Mode, the UNISTAT toolbar is visible at all times, but the Output Medium buttons will be functional only after a procedure has been performed. All toolbars have similar Output Medium buttons, but there may be additional window-specific buttons and not all output buttons may appear depending on which application is installed on the system. The Word, Excel and browser buttons will appear only if their respective applications have been installed previously.

When all options are available, the Output Medium Toolbar will look like this on different windows:

Data Processor: Output Medium Toolbar

Output Window: Output Medium Toolbar

Graphics Editor: Output Medium Toolbar

Excel add-in: Output Medium Toolbar

The toolbar buttons have the following tasks:

Output Medium Toolbar  Last Procedure Dialogue: The last dialogue in the hierarchy of Procedure Dialogues will be displayed allowing you to change the output options without having to re-run the entire procedure.

Output Medium Toolbar  Send Matrix to Data Processor (Stand-Alone Mode only): This button is available only when the output from a procedure is in table format. When it is clicked, the table will be copied to Data Processor cells starting from the first blank column available, so that it can be used as input for further analysis. Even if numbers in the output are formatted to display a limited number of digits, they will be copied to the spreadsheet cells with the full 15 digits of precision. Abbreviated labels will be generated for each column added to the spreadsheet.

Output Medium Toolbar  Output to Output Window (Stand-Alone Mode only): This is UNISTAT’s own WordPad-like Output Window. The text output is in old style line printer format and graphics are in enhanced metafile format.

Output Medium Toolbar  Output to Word: Output is sent to the current document in Word, at the current cursor position, as formatted Word tables and enhanced metafile format pictures. See 2.2.2. Output to Word below.

Output Medium Toolbar  Output to Excel: Output is sent to a new Excel worksheet in the form of formatted Excel tables and enhanced metafile format pictures. See 2.2.3. Output to Excel below.

Output Medium Toolbar  Output to Web Browser: Output is sent to the default web browser in the form of HTML tables and PNG format bitmap images. See 2.2.4. Output to Web Browser below.

Output Medium Toolbar  Output to the Clipboard: Output is copied to the clipboard using a fixed width font (as in Output Window). Graphics are in enhanced metafile format.

Output Medium Toolbar  Macro Shortcut Buttons (Stand-Alone Mode, Data Processor only): The macro file Documents\Unistat60\UsrBtn1.usm is run and output is sent to the Default Output Medium. See 2.4.2.4. Macro Shortcut Buttons.

Output Medium Toolbar  Lock UNISTAT Data (Excel Add-In Mode only): The highlighted block of data in the active Excel worksheet is locked. While this button is depressed, highlighting other blocks will not change the data to be analysed by UNISTAT. To change the analysis range click on this button again and then highlight a new block of data.

Output Medium Toolbar  UNISTAT Help (Excel Add-In Mode only): This button launches the UNISTAT help system.