Magellan / Release 3 Multiple Worksheet Consolidation

Magellan's viewing, marking, and launching features can all be combined in a
powerful way to consolidate multiple worksheets into 1-2-3 Release 3.  This
makes it possible to select several worksheets in Magellan that you would like
to make into a 3-d worksheet in Release 3 and have Magellan take care of the
rest!

The trick is to use a special feature of Magellan that allows you to take
multiple marked files and pass their names and paths to another application
during a Magellan Launch via a file called MAGELLAN.MRK.  Many programs can
take as a command line parameter a file name filled with several file names,
but 1-2-3 is not one of them, so the finale of the trick is accomplished with 
a special worksheet that does this last part.  Below are some assumptions,
descriptions, instructions, and known limitations.

1.  Setup the Magellan/1-2-3 R3 Consolidator
--------------------------------------------

   1.1  Assumptions
   ----------------
        * 1-2-3 R3 is installed on your computer.
        * Magellan is installed in C:\MAG2.
        * MAGCON.WK3 is in your C:\MAG2\MGDEMO directory.
        * You are using the standard "off the rack" Magellan Launch table 
          entry for 1-2-3 R3.

             If Magellan is installed anywhere other than in C:\MAG2\, you
             need to modify the \0 (autoexec) macro in MAGCON.WK3 to
             indicate where it is located before executing the 
             Magellan 1-2-3 R3 consolidator.

             One line in the macro contains the string:

                  /fit{ce}C:\MAG2\MAGELLAN.MRK~

             Edit "C:\MAG2\" to indicate where your copy of Magellan is
             located.

             To make working on MAGCON.WK3 easier, you might want to start
             1-2-3 R3 with a blank worksheet (use the Run option instead
             of Load in Magellan Launch) and temporarily turn off the
             Autoexecuting Macros option by using the command:
             /wgdanq.
             Then retrieve MAGCON.WK3.

   1.2  What to do
   ---------------

      A. In Magellan, create the Launch Table entry.

         The easiest way to do this is to copy the current 1-2-3 R3 launch 
         table entry and then make a few minor changes.
             Press F7 (Launch).
             Move to the 1-2-3 R3 launch table entry.
             Press F2 (Copy).
             Press S (Setup).

      B. Now make the changes necessary to create the entry.

         The title MUST start with the an asterisk.  You can call this entry
         anything you like.  We suggest "*Consolidate Wkshts".

         The Command, Directory, and Filespec lines are fine.  Leave them 
         as is.  Leave the Viewer fill-in field blank.

         Edit the Keystroke fill-in field so that this entry only launches 
         into the MAGCON file.  Move the cursor to the right until it is 
         on the "x" in the string.  Press Ctrl-Enter to delete the rest of 
         the line, then type {Esc}{Esc}c:\mag2\mgdemo\magcon.wk3{Enter}

         The new keystroke string should be:

             {Pause10}{Enter}/{Right}{Right}{Right}{Right}{Enter}{Enter}{Esc}
             {Esc}c:\mag2\mgdemo\magcon.wk3{Enter}

         Press Enter twice to save your changes to the Launch table.


2.  Using the Consolidator
--------------------------

In order to use the consolidator, simply mark (with the space bar) any .WK1 or
.WK3 files you wish to use.  Press F7 and move the cursor to the Consolidation
entry.  Press Enter to Load the Consolidator.  Sit back and enjoy.

If you choose any .WKS files (from 1-2-3 ver.1), they will automatically be
saved as .WK3 files if you chose to save.  This is a feature of 1-2-3 R3.


3.  How it works
----------------

The Consolidator lets you select any number of worksheet files in Magellan and
bring them all into a R3 session sequentially.  Key uses for this application
include:

        * Beginning the process of translating 2-dimensional models into
          3-dimensions.

        * Easing the file linking process by retrieving the files together.

        * Comparing several files.

        * Specifying files when files contain the components of an application
          that need to be in memory concurrently (i.e., macro libraries, large
          databases separate from analysis, etc).