Category : Lotus and other Spreadsheets
Archive   : 123LCK23.ZIP
Filename : 123LEARN.AD

123-LEARN
Version 2.3
produced by Softsmith Enterprises
tm
(c) 1987 All Rights Reserved

(versions of this product prior to 2.2 were not published)

This product is a non-user-supported version of 123-Learn version
2.2. Version 2.2 was developed using Lotus 123 version 2.01, and
certain incompatibilities of 123-Learn 2.2 with Lotus 123 version
2.0 have been rectified in 123-Learn version 2.3.

The 123-Learn manual and order form are both available at this
point provided you have a printer on-line. Note that 123-Learn is
guaranteed to function as described and delimited here.

123-Learn is not copy-protected in any way.

Installing 123-LEARN:

#1- Go to an empty range in your spreadsheet at least 10 wide
by 56 deep. 123-Learn will be installed here.

#2- Insert 123-Learn disk in default drive (usually "b:")

#3- Make sure the mode indicator (upper right) says READY

#4- Type "/FCCN123-Learn" [PRESS RETURN TWICE] continue typing
"/RNC\" (don't type the quotation marks!).

#5- Now specify a letter you want to use when you invoke
123-Learn (The facility will activate whenever you type
"ALT" and the letter at the same time) [PRESS RETURN TWICE]

#6- Press "ALT" and your chosen letter at the same time.
(Be sure 123-Learn disk is still in default drive)

#7- After a few moments, 123-Learn will be installed- try it.
Using 123-LEARN:

#1- Initially, 123-Learn brings up the main menu to get data
on the current task:

GO NEW APPEND DISPLAY QUIT

#1a- The "go" command invokes the last macro you worked on.
#1b- The "new" command allows you to make temporary or
permanent macros, and prompts you to show it where
you want permanent macros written. Temporary macros
are written below 123-Learn automatically.
#1c- The "append" command adds the following keystrokes to
the last macro you worked on- this is best done after
using the "go" command to show you where you are.
#1d- The "display" command shows the current display of the
command line-press any key to return to the main menu.
#1e- The "quit" command stops learn-mode, but the "append"
command may still be used later on. "Quit" can be
used to make unrecorded keystrokes before continuing.






Using 123-Learn:

#2- While 123-Learn is on, each keystroke made is recorded in
a macro so tasks may be repeated automatically!

#3- 123-Learn is usually transparent to the user- you know it's
on only by the "CMD" indicator at the bottom of the screen.

#4- 123-Learn isn't transparent to the user when backslash "\"
is pressed. Then, the facility brings up this menu:

DONE FIELD* PAUSE* WAIT* RESUME SOUND ~ MACROS

#4a- Pressing the [ESC] key will rid you of the menu. The
"\" will be typed normally and learn mode will
continue.
#4b- The "done" feature simply embeds a terminating command
in the macro and brings the main menu back up.
(N.B. The command used is "{return}", not "{quit}")
* When using these features, check the upper-right indicator for status
123-LEARN features:

#1- The "field" feature lets you embed pauses in the macro
for users to type in data. When you call this feature,

FIELD is shown in the upper-right box (the indicator).

no keystrokes will be recorded until the you press
[RETURN]. Then you can continue in learn mode.

#2- The "pause" feature lets you embed pauses in the macro
until the user presses any key- there is no opportunity
for input. When you call this feature,

PAUSE is shown in the upper-right box (the indicator).

execution is suspended until a key is pressed- then learn
mode resumes.
N.B.: A range named "L22\" is used by all macros with embeded
pauses, deleting this range name invalidates the macros.
123-LEARN features:

#3- The "wait" feature prompts you to input the time to wait
in the format x,x,x where x is:

[number of hours to wait],[minutes to wait],[and seconds]

WAIT shows in the indicator for the specified period.

#4- The "sound" feature embeds and plays beeps when numbers are
typed. It is turned on/off like a light switch.

#5- The "resume" feature continues learn-mode as though you'd
never typed "\" (note "\" is not typed using this feature).

#6- If you want to type "~", you have to use the "~" feature,
since "~" is a macro symbol for [RETURN], typing it
directly will do the same thing as pressing [RETURN].

#7- The "macro" feature brings up a menu of advanced options...






123-LEARN advanced features:

#7(cont)- The "macro" feature brings up the following menu:

LOOP KNOT DOWN IF NOT ROUTINE MENU BELL

#1- Using the "loop" feature causes the macro to start over
again from the beginning- it will stop learn mode unless
you're in a conditional routine (see "if" feature).

#2- The "knot" feature funtions like the "loop", except it
repeats the macro from the beginning of the current macro
line (keep track of macro lines with the "bell" feature).
N.B.: Macros with this feature can't be moved to new addresses.

#3- Using the "down" feature will force the macro to
write all further keystrokes in the next cell below
the cell in which it's currently writing. This happens
automatically when the current cell is full unless a condi-
tional routine is in progress (see "interruptions").
123-LEARN advanced features:

#4- The "if" feature lets you specify certain keystrokes
that will only be executed under certain conditions.
(a "conditional routine"). This menu is brought up:

EQUATION VALUE LABEL

#4a- The "equation" feature prompts you to input a
specific equation that must be true to execute the
conditional routine.
#4a(1)- Not specifying any equation will cause the
conditional routine to execute as the curser
encounters a blank cell.
#4b- The "value" feature prompts for a number or a
numeric formula (example: +a1+(b1*c1) ).
#4b(1)- Not specifying any value will cause the
conditional routine to execute as the curser
encounters any cell containing a value.

123-LEARN advanced features:

#4c- The "label" feature prompts for a label, or a
string formula (example: +a1&@left(b1,3)&c1 )
#4c(1)- A label must be input in quotes ("example").
#4c(2)- Do not put string formulas in quotes.
#4a(1)- Not specifying any string will cause the
conditional routine to execute as the curser
encounters a any cell containing a label.
#4b- The conditional routine continues until:
#4b(1)- You press "\d" (for "done") - This causes a
conditional termination of macro execution.
#4b(2)- You use the "loop" or "knot" feature - This
causes a conditional repetition of the macro.
#4b(3)- You use the "down" feature - This means the
macro continues normally after the condition-
al routine is finished.
#4c- When the routine is done, normal learn mode resumes.

#5- The "not" feature executes routine if a condition's false.






123-LEARN advanced features:

#6- The "routine" feature causes the macro you're making to
invoke another macro. After entering a macro name, you
tell 123-Learn what to do after the invoked macro is done.
#6a- If the invoked macro contains the "{RESTART}"
or "{QUIT}" commands, it won't return "control"
to the original macro when finished.
#6b- Deleting these commands will cause the invoked macro
to return to the original macro and execute the rest
of the keystrokes you recorded there.
#6c- You are free to specify a nonexistant macro, as
long as you make a macro under that name before you
try to invoke it.

#7- The "menu" feature calls a macro menu like the "routine"
feature calls a macro.

#8- The "bell" feature causes a bell to sound when 123-Learn
fills the cell it's currently writing in.
123-LEARN interruptions:

#1- 123-LEARN may occaisionally interrupt learning to ask
if you want a specific cell's contents written over.
This is because the current cell is full, but the next
cell already has contents. Toggle between the choices
given to alternately see both the displayed value and
formulaic contents of the threatened cell.

#2- Triggering a 123-error while using 123-LEARN will
cause the facility to display the cause of the error,
and return you to the main menu. Control-Break will
bring you straight to the main menu. NOTE: CTRL-BREAK
will clear out any keystrokes that you've typed ahead!

#3- Erasing the worksheet or calling a new file while using
123-Learn will cause you to loose all macro commands
that have been recorded since you last saved the file.
These commands should be typed into the macro manually
and the file should be saved before invoking the macro.
123-LEARN general considerations:

#1- Enabling 123's "protection" feature (by typing
"/w(orksheet)g(lobal)p(rotection)e(nable)") could
trigger unrecoverable macro errors if the macro area
isn't unprotected (temporary macro storage is directly
under the 123-Learn program in your spreadsheet).

#2- Inputing invalid equations, routine names or formulas using
the "macro" or "if" features will result in unrecoverable
errors when a macro generated with 123-Learn is invoked.

#3- Starting a temporary macro while in edit mode will cause
unexpected results to appear on the command line while
123-Learn is being used. This is due to Lotus 123 software
design. Regardless of the unexpected results, the new macro
will function as expected when invoked through 123-Learn.

#4- Try to make the macro in the tutorial worksheet "tutor.wk1"
It will show you how 123-Learn can be fully utilized!






123-LEARN product warranty.

#1- In no event will Softsmith be liable to you or any other
person for any damages direct, incidental or consequential
arising out of the use or inability to use this product.

#2- Failure of this product to perform functions described and
delimited in this documentation are grounds for a refund
provided the following conditions.
#2a- You have described the conditions in which the failure
occurred specifically in writing to Softsmith.
#2b- Softsmith has verified that your version of 123-Learn
cannot function as described under the specific condi-
tions by emulating those conditions in tests.
#2c- If the error cannot be reproduced in tests by Soft-
smith a refund will not be given. External reasons
for the failure (i.e. misuse, wrong Lotus version)
will be provided at Softsmith's discretion.


123-LEARN Distribution Agreement:


If you distribute 123-Learn to employees or other subordinates under
your management, or are a designated software/office supply purchaser of
an institution to whom 123-Learn is distributed, you are required to
pay, or cause the institution to pay, for the institution's copy of
the facility..



Distribution of this product beyond the purchasers family, firm or
institution with or without monetary compensation is forbidden.
Inquiries about commercial distributor licensing with Softsmith
Enterprises is welcome.











123-LEARN Order Form:

































































_________
__________________ | Place |
__________________ | Stamp |
__________________ | Here |
`-------'




Softsmith Enterprises
1425 Denman Avenue
Coshocton, Ohio 43812





________________________________________________________________________
fold here

















________________________________________________________________________
fold here
YES! The marked Softsmith products sound like boons to my office or
business' productivity! Please ship right away...

PRICE BILLING IF CHECK IS NOT ENCLOSED,
123-Lock vers. 2.3 $20.00 ________ ENTER CREDIT/BANK CARD NUMBER
123-Learn vers. 2.3 $35.00 ________ __________________________
123-APGR vers. 1.0 (FREE with your order - please read description
NAME OF BANK OR CREDIT CARD
TOTAL BILLING ___________________________
========

==> All Softsmith products are unprotected and freely copyable <==
Ohio residents include 5«% sales tax DO NOT SEND $CASH$

--(tear)------------(tear)------------(tear)------------(tear)-------














(Above is your payment envelope- please fold and seal edges
and sides, fill out return address, stamp and send!)

Other products developed by Softsmith Enterprizes:

123-APGR: This automated spreadsheet finds the average periodic growth
rate and standard error of any time series data as a percent,
useful in forecasts and measuring your performance against
financial targets (usually expressed as percentages also!)

123-Lock: This security facility can lock up your keyboard or blank
the screen until you type in your own password. 123-Lock
can be invoked anytime, autoinvoked when certain files are
retrieved, when 123 is booted or even when your system
boots! 123-Lock insures your system will not be tampered
with for the next five minutes or the next five years.
Invokable from a macro.






123-LEARN End:


Thank you for your time thus far. Hopefully 123-Learn will
become a valuable productivity tool to you. If not, or if you
see room for improvements, please use the order form to let us
know.



Note: Lotus and 123 are trademarks of Lotus Development Corp.