Monster Media 1993 #2/Image.iso/spread/thinkr30.zip/THINK.HLP

Text File | 1993-05-10 | 8KB | 214 lines

The Thinker Help Screens
@1,Summary of Functions
@2,Mathematical functions
@3,Statistical functions
@4,Financial functions
@5,Special functions
@6,Features of The Thinker
@7,Command sequences
@8,Worksheet options
@9,Print options
@10,"HOW TO"
@11,"How to become a registered user"
##1
                              Available Functions

NOTE:Some arguments may be ranges such as A1.B3, or numbers. When a range or
a list of arguments may be used, LIST is given in the function description.
If the function takes only a single argument "arg" will be designated.

    Mathematical Functions           Statistical Functions
    ----------------------           ---------------------
    @ABS(arg)    @LN(arg)            @AVG(list)    @SS(list)
    @ACOS(arg)   @LOG(arg)           @COUNT(list)  @STD(list)
    @ASIN(arg)   @MOD(x,y)           @MAX(list)    @SUM(list)
    @ATAN(arg)   @PI                 @MIN(list)    @VAR(list)
    @ATAN2(arg)  @RAND               @SEM(list)
    @COS(arg)    @ROUND(x,n)
    @EXP(arg)    @SIN(arg)           Financial Functions
    @INT(arg)    @SQRT(arg)          -----------------------
                 @TAN(arg)           @FV(pmt,int,term)
                                     @IRR(guess,list)
    Special Functions                @NPV(x,list)
    ----------------------           @PMT(prn,int,term)
    @ERR         @DEC(arg,n)         @PV(pmt,int,term)
##2
                             Mathematical Functions
                             ----------------------
    @ABS(arg)  - absolute value
    @ACOS(arg) - arc cosine
    @ASIN(arg) - arc sine
    @ATAN(arg) - 2 quadrant arc tangent
    @ATAN2(arg)- 4 quadrant arc tangent
    @COS(arg)  - cosine
    @EXP(arg)  - exponential
    @INT(arg)  - integer part
    @LN(arg)   - log base e
    @LOG(arg)  - log base 10
    @MOD(x,y)  - x modulo y
    @PI        - pi (π)
    @RAND      - random number between 0 and 1
    @ROUND(x,n)- round a number to n decimal places
    @SIN(arg)  - sine
    @SQRT(arg) - square root
    @TAN(arg)  - tangent
##3
                             Statistical Functions
                             ---------------------


    @AVG(list)    - average or items in list
    @COUNT(list)  - counts number of items in list
    @MAX(list)    - maximum of values in list
    @MIN(list)    - minimum of values in list
    @SEM(list)    - standard error of the mean from list
    @SS(list)     - sum of sqaures from list
    @STD(list)    - standard deviation from list
    @SUM(list)    - sum of numbers in list
    @VAR(list)    - variance of numbers in list



##4
                              Financial Functions
                            -----------------------
    @FV(pmt,int,term)  - FUTURE VALUE OF AN ANNUITY
                         pmt = payment made each period
                         int = interest per period; term = number of periods

    @IRR(guess,list)   - INTERNAL RATE OF RETURN
                         guess = initial guess (usually 0 to 1.)
                         list = cash flows

    @NPV(x,list)       - NET PRESENT VALUE
                         x = per period interest rate
                         list = cash flows

    @PMT(prn,int,term) - MORTGAGE PAYMENT PER PERIOD
                         prn = beginning principle
                         int = per period interest rate
                         term = how many payments to be made

    @PV(pmt,int,term)  - PRESENT VALUE OF AN ORDINARY ANNUITY
                         pmt = payment per period
                         int = interest per period; term = number of periods
##5

                               Special Functions
                               -----------------

@ERR - designates a value of ERR (error). A cell with value ERR will
       cause subsequent functions to return a value of ERR.

@DEC(x,n) - causes the number associated with the cell to print out
            the number to n decimal places.
##6
                             Features of The Thinker
                             -----------------------

Size of worksheet - 26 columns lettered A to Z
                    125 rows

Maximum number of cells defined at one time = 1000

Calculations are performed in natural sequence. That is, a calculation does
not take place until all previous cells which related to that cell have also
been calculated.

All files to be accessed must be in the same sub-directory.
##7
                               Command Sequences
                               -----------------

All commands are invoked by first typing the slash "/" character.
A menu will then be presented:

Worksheet  Range  Copy  Move  File  Print  Quit

To choose one of these options, press the first letter of the option, or move
the selection marker by pressing the space bar, then press ENTER when the
desired options is highlighted. Another menu, or a question may then appear
on the screen.

-WORKSHEET - options having to do with the entire worksheet (Global, Insert,
             Delete, Column-Width, and Erase)
-RANGE - Erase a range of cells
-COPY and MOVE - Copy or move a range of cells
-FILE - Save or Retrieve a file, or list files on disk
-PRINT - Print a worksheet to a file or to the printer.
-QUIT - End the program
##8
                               Worksheet Options
                               -----------------

-GLOBAL - Set global column-width, or choose manual or automatic calculation

-INSERT - Insert blank columns or rows

-DELETE - Delete column or rows

-COLUMN-WIDTH - Set or Reset column width of a specific column

-ERASE - Erase the entire worksheet
##9
                                 Print Options
                                 -------------

-RANGE - Select range of worksheet to print

-LINE - Print a single blank line on the page

-PAGE - Go to top of page

-CLEAR - Clear the print selections

-ALIGH - Align the paper

-GO - Begin printing

-QUIT - Quit the print procedure

-SETUP - Send printer a setup code
##10
                                     HOW TO

HOW TO QUIT - When you return to the worksheet screen, press the slash key
"/". The menu will appear. Next press the "Q" key. You will be given one more
"Yes No" choice. If you wish to stop the program, press the "Y" key.

HOW TO SAVE A FILE - Press "/", then choose "F" for FILE. Choose "S" for
SAVE. Next enter a name for your worksheet, using eight or fewer characters.

HOW TO GET A FILE BACK - Press "/", then choose "F" for FILE. Choose "R" for
RETRIEVE. Next enter the name of the file to get. If you don't know the name
of the file, see next "How to".

HOW TO GET A LISTING OF FILES ON DISK - Press "/", then choose "F" for FILE.
Next choose "L" for list. You will be asked to specify either THINKER files or
all files. Choosing THINKER will list all files with the ".TKR" extension.

##11


          The THINKER  program is  a copyrighted  program that  allows
          users, under  certain  conditions,  to copy  and  share  the
          program  with  others.  Never  call  it  a  "public  domain"
          program. You  are not  allowed to  make photocopies  of  the
          manual. Persons who  use THE THINKER  are obliged to  become
          officially licensed users by registering. This provides  you
          with several advantages. You  receive information about  new
          releases, bugs, updates and problems. You also get a copy of
          the latest version of the program and manual on disk. If you
          use THE THINKER, you  should print the  ORDER form on  disk,
          and become a registered user. To print the file named ORDER,
          with the THINKER disk in the A drive, use the command:

          A>COPY ORDER LPT1:

          Thanks.
ORDER,
          with the THINKER disk in the A drive, use the command:

          A>COPY ORDER LPT1: