Dec 052017
Simple, but still useful Lotus 1-2-3 tutor.
File 123LRN22.ZIP from The Programmer’s Corner in
Category Lotus and other Spreadsheets
Simple, but still useful Lotus 1-2-3 tutor.
File Name File Size Zip Size Zip Type
123LEARN.DOC 18183 5793 deflated
123LEARN.WK1 42012 14492 deflated
TUTOR.WK1 26665 8850 deflated

Download File 123LRN22.ZIP Here

Contents of the 123LEARN.DOC file

Version 2.2
produced by Softsmith Enterprises
(c) 1987 All Rights Reserved

(earlier versions of this product were not published)

This product isn't copy-protected. The spreadsheet has been
restricted from direct access only to insure there is always
an unaltered copy of the facility for backup and distribution.
(You may inadvertently lose your copy of the facility!)
User agreement, manual and registration form are all available at
this point provided you have a printer on-line. Or, you may
view the documentation on your screen by retrieving "123LEARN.WK1"
in Lotus 123 version 2.0 and up, or you may get your hardcopy
immediately by printing this document file.
Instructions for installing the facility in your Lotus files follow...
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:


#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:


#4a- Pressing the [ESC] key will rid you of the menu. The
"\" will be typed normally and learn mode will
#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).

#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:


#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:


#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: [email protected](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 as though
you'd type "\d(one)."

#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 executed.

#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 User Agreement:

You are hereby provided a license to use 123-Learn provided the
following conditions typical of user-supported software:

#1- Payment of billing as calculated under the billing section

of this Agreement.

#2- No receipt of any form of remuneration or consideration
for distribution of this product to others beyond those
verifiable costs of disks, P.C. rentals, ect. - Individuals
or institutions receiving 123-Learn will either pay the
regular billing to Softsmith Enterprise or it will be payed
by the distributor, provided the distributor is authorized
to do so under the distribution agreement (see below).

#3- In no event will the author 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.

123-LEARN Distribution Agreement:

You are hereby provided a license to distribute 123-Learn free of
charge provided the following conditions.

#1- The software and/or documentation of this product are not
altered in any way whatsoever.

#2- You don't qualify as a purchaser for those to whom
123-Learn is distributed (as defined below).

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 each user's copy as calculated
under the billing section of this Agreement (volume discounts available)

A user is defined as any individual who by requirements of employment
can and do use 123-Learn. Users of macros created using 123-Learn are
not necessarilly users as defined here.
123-LEARN billing:

123-Learn costs ten dollars ($10.00) per user, with a two dollar ($2.00)
discount for each user beyond 1 to whom a copy is distributed by a
purchaser as defined under the Distribution Agreement. See chart:

Number of users Itemized billing Total billing
1 $10 $10.00
2 10+8 $18.00
3 10+8+6 $24.00
4 10+8+6+4 $28.00
5 10+8+6+4+2 $30.00
6 ad infinitum 10+8+6+4+2+0 $30.00

N.B.: Those who do not receive this product from a purchaser as defined
under the Distribution Agreement are required to calculate their billing
anew, counting themselves as user #1.

123-LEARN User Registration Form:

__________________ | Place
__________________ | Stamp
__________________ | Here
Softsmith Enterprises
1425 Denman Avenue
Coshocton, Ohio 43812

fold here

fold here

I've found 123-Learn, Version 2.2 to be a valuable facility, here is my
payment of billing as calculated under the User Agreement:

BILLING: $_______ ___________________________ __________________
fold here
I'd also like to order these other Softsmith products:

PRODUCT BILLING PRICE No./Users(Discount $1 for each

123-LOCK $_______ $5.00 _________for each user over one)
APGR $0.00 _________
(Included a prestamped disk envelope with any APGR order!)
Ohio residents include 5% sales tax DO NOT SEND $CASH$!!!

(This is your payment envelope, stamp, return address and
seal the edges- then send! Thanks for the registration!)

Other products developed by Softsmith Enterprizes:

123-LOCK: Provides superior spreadsheet protection any time you need
it- quick keyboard lock-up/screen-blank while in a file, on
retrieving a file or when 123 boots-up; 123-Lock insures that
your files/system will be untampered with in five minutes or
five years! Uses your password. May be invoked from a macro.

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-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 registration form to
let us know. User supported software cannot require billing
of unsatisfied users...

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

 December 5, 2017  Add comments

Leave a Reply