PCjs Machines

Home of the original IBM PC emulator for browsers.

Logo

PC-SIG Diskette Library (Disk #207)

[PCjs Machine "ibm5150"]

Waiting for machine "ibm5150" to load....

Information about “LOTUS WORKSHEETS #1”

This disk contains a collection of some really nice worksheets. AUTO.WKS
records every auto expense and tracks repair history. JOGLOG.WKS, a
memory hog (needs 340k), is designed for the serious runner who must
track performance at every level.  FEDTAX83.WKS is complete.  PAD.WKS
is a sophisticated demo of Desktop-like templates. Additional
spreadsheets are available from the author.  AUTO and JOGLOG are
especially well designed for profressional performance management.

System Requirements: 340k, two disk drives, LOTUS 1-2-3 version 1A

How to Start:  Access through LOTUS 1-2-3

File Descriptions:

123KEY   BAT  Batch start up file
123KEY   PRO  Prokey template - permits using numeric key pad with LOTUS
123KEY   DOC  Documentation
AUTO     WKS  Calculates your gas usage and mileage  (Vince Heiker)
JOGLOG   WKS  Simple jogging log  (Vince Heiker)
FEDTAX83 WKS  1983 Tax Schedules 1040, 1040A, B, C, W  (Les Wheeler)
TREND123 MAC  Version 1.0 (John Dannenfeldt) - Curve fitting macro
TREND123 DOC  Documentation
PAD      WKS  Version 1.2 (Frank Girard) - Desktop-like template

123KEY.DOC

          PROKEY SUBSET FOR 1-2-3        [123KEY.DOC]
          -----------------------
In order for Prokey to work with a 123 spreadsheet, certain
setups are required.  First, the 123 system disk must contain
the files PROKEY.EXE (the main PROKEY tm. program) as well as
the file 123KEY.PRO which is the file that contains all the
custom key assignments to be used while in 1-2-3.

An additional third file may be included 123KEY.BAT (may be
re-named Autoexec.bat).  This file installs prokey and the keys
before it calls in the main 1-2-3 program.
     [123KEY.BAT]=  PROKEY/R 123KEY.PRO
                    123
                    ^Z
Upon boot-up the PROKEYS for 1-2-3 will be loaded into high
memory and will be invisible to the user until called.

One additional set-up is required on each new spreadsheet that
is started.  Because of the way 1-2-3 defines certain of the
function keys, it is necessary to inbed the definitions some
where in a group of isolated spreadsheet cells.  In doing so
you will cause PROKEY to interact with the 1-2-3 typing alternative.

The result is to move the functions STEP NAME ABS QUERY TABLE CALC GRAPH
from their respective keys F3 F4 F7 F8 F9 F10 to their new assignments
respectively altF3 altF4 altF7 altF8 altF9 altF10.

The move is to allow the re-assignment of those function keys as follows:
         F3   becomes HOME
         F4   becomes END
         F7   becomes the UP arrow
         F8   becomes the DOWN arrow
         F9   becomes the LEFT arrow
        F10   becomes the RIGHT arrow

You may now leave your NumLock key on and use the keypad as a
numeric keypad.  As stated above this requires a ONE-TIME-ONLY
setup on EACH NEW spreadsheet.  The setup is an automatic feature
built into the Prokey set loaded by the first step.  To use the
setup feature do this:

****  AFTER YOU HAVE CALLED IN A NEW SHEET OR CLEARDED THE       ****
****  OLD SHEET TO BUILD A NEW ONE, PRESS altF2  .               ****

      AltF2 moves the cursor to Cell position BA1 and writes
      cells that 1-2-3 's typing alternative will use in
      re-defining the keypad.  If this group of cells at
      BA1 is going to interfere with the spreadsheet, you
      may change their location by useing the 1-2-3 MOVE
      command to move the group to another section of the sheet.
      Or if you can change the prokey 123PRO.KEY file to have
      another beginning cell in place of BA1 (To do this pull
      up 123PRO.KEY with an editor and find BA1, change it!).

      Each cell in this special group has a range name and they
      remain the same in a 1-2-3 move. It is these names that
      the typing alternative uses in looking for those cells.






               |------|------|
               | HELP |EDIT  |
               |      |      |
               |  alt | alt  |                Print this template on an
               | step |setup |                Epson or Epson-like printer
               |------|------|                in the compressed print mode.
               | HOME |END   |
               |      |      |                then draw the arrows in the
               |  alt |alt   |                bottom four boxes as follows:
               | name |abs   |
               |------|------|
               |      |      |
               | GOTO |WINDOW|
               |      |      |
               |------|------|
               | /|\  |  |   |
               |  |   | \|/  |                    up           down
               |  alt |alt   |
               |query |table |
               |------|------|                   left          right
               | /___ | ___\ |
               | \    |    / |
               |  alt |alt   |                  Now tape this to your 1-2-3
               | calc |graph |                  plastic template.
               |______|______|


To use this you need to own PROKEY and download three files to put on your
1-2-3 system disk.  They are as follows : [123KEY.DOC]=this explanation
[123KEY.PRO]=the prokey definition file   [123KEY.BAT]=the new 123 autoexec.bat


CRC.TXT

PC-SIG Disk No. #207, version v1

The following is a list of the file checksums which should be produced by
the CRCK4 program on disk #9 (and others).  If the CRC numbers do not match
you may have a bad file.  To use type:  CRCK4 <filespec>

CRCK4 output for this disk:


CRCK ver 4.2B (MS DOS VERSION )
CTL-S pauses, CTL-C aborts

--> FILE:  123KEY  .BAT         CRC = 00 00

--> FILE:  123KEY  .DOC         CRC = 3B B9

--> FILE:  123KEY  .PRO         CRC = 06 41

--> FILE:  AUTO    .WKS         CRC = A6 9E

--> FILE:  FEDTAX83.WKS         CRC = BD 9B

--> FILE:  JOGLOG  .WKS         CRC = 15 D4

--> FILE:  PAD     .WKS         CRC = 06 72

--> FILE:  TREND123.DOC         CRC = 53 75

--> FILE:  TREND123.MAC         CRC = D1 15

--> FILE:  XXX     .            CRC = 46 EA

--> FILE:  CRC     .TXT         CRC = 2A 7C

--> FILE:  CRCK4   .COM         CRC = BD 22

 ---------------------> SUM OF CRCS = 15 8B

DONE

These and other Public Domain and user-supported programs from:

PC Software Interest Group
1125 Stewart Ct  Suite G
Sunnyvale, CA 94086
(408) 730-9291

FILES207.TXT

------------------------------------------------------------------------
Disk No xxx   Lotus 123 Templates and Tools                    v1
------------------------------------------------------------------------
123KEY   BAT  Batch start up file
123KEY   DOC  Documentation
123KEY   PRO  Prokey template - permits using numeric key pad with LOTUS
AUTO     WKS  Calculates your gas usage and mileage (Vince Heiker)
FEDTAX83 WKS  1983 Tax Schedules 1040, 1040A, B, C, W (Les Wheeler)
JOGLOG   WKS  Simple jogging log (Vince Heiker)
PAD      WKS  V1.2 (Frank Girard) - Desktop-like template
TREND123 DOC  Documentation
TREND123 MAC  V1.0 (John Dannenfeldt) - Curve fitting macro for Lotus

TREND123.DOC

                                   TREND123
                                 version 1.0
                       A Lotus 123 Curve fitting macro
               created by John C. Dannenfeldt (Compuserve 71435,561)

The file TREND123.WKS is a independent macro that may be used within any Lotus
123 spreadsheet.  This version enables you to create a set of data points with
the range name LINE or CURVE which fit any set of data points you range name
DATA with either a least squares straight line or an exponential curve:

     Linear (LINE)-         y=(c1 * x) + c2

     Exponential (CURVE)-   ln y=(c1 * x) + c2

Restrictions:
     The DATA range must be continous.. no blank cells.
     ...     ...    must be less than 257 points long.
     You must be at A70 before you load the macro into your worksheet.
     Your spreadsheet must not extend beyond A1..IV69 or it may be partially
        overwritten.

Instructions:
     Before running the macro you must:
          1) Define a continuous set of numbers range named DATA.
               They may be in either a row or column orientation but the
               program takes much longer to work on the vertical ranges
               because it must first transpose them into a horizontal range.

          2) Name the macro so that you can call it by typing:

               /RNC\t  then press (ENTER)
               A70     then press (ENTER)

          3) Load the macro into your spreadsheet-
             Now goto A70 and type:

               /FCCETREND123   then press (ENTER)

    To activate the macro type ALT-T and follow the instructions.  When the
    macro is done it will return you to its main menu and ask if you would
    like to do a linear or exponential curve fit or quit.  If you do a
    different curve fit the old LINE or CURVE will be destroyed.  If you quit
    you may then look at LINE or CURVE directly or even better graph it beside
    the original DATA that you were trying to fit the curve to.

Comments:
     I was forced to create some type of curve fitting regime for an
application I had and in the process developed part of the current macro.  The
next version will include some additional curve fitting routines such as
parabolic, moving averages and exponential smoothing.
     Some of the things I don't like about this macro are a result of the
limitations of the 123 macro language.  After finally figuring out how to
transpose a column into a row I certainly wished that 123 had a general
command for that function.  Hopefully the next version will have an easier to
use macro language.
     Feel free to make changes to the routine to fit your needs.  Some obvious
variants would be a basically vertical layout (which would make vertical
ranges faster to input) and locating the origin of the macro at a point more
suitable for your particular spreadsheet( remember that all references to
cells within a macro must be changed for it to work in a new location).
     If you got this macro in the form TREND123.HEX you must convert it to a
binary file called TREND123.WKS before trying to use it in a worksheet.

 If you have any suggestions contact me on COMPUSERVE at the IBMPC SIG.


Directory of PC-SIG Library Disk #0207

 Volume in drive A has no label
 Directory of A:\

123KEY   BAT        31  12-11-83   4:09p
123KEY   DOC      4166  12-11-83   4:09p
123KEY   PRO       602  12-11-83   4:10p
AUTO     WKS     44928   6-24-84   6:17p
CRC      TXT      1123  11-15-84   9:17a
CRCK4    COM      1536  10-21-82   7:54p
FEDTAX83 WKS     38400   1-12-84   8:31a
FILES207 TXT       768   6-24-84   7:23p
JOGLOG   WKS    100992   6-24-84   6:25p
PAD      WKS     29312   2-05-84   1:24a
TREND123 DOC      3250  12-11-83   2:39p
TREND123 MAC      4224  12-11-83   2:32p
       12 file(s)     229332 bytes
                       86016 bytes free