home *** CD-ROM | disk | FTP | other *** search
- FHS-manual Version 0.3 27-11-1993 FHSpread V2.01
-
-
- 1.ABOUT FHSPREAD:
-
- 1.1.THE PROGRAM:
-
- This program is publicdomain. You may distribute as many
- copies as you wish, but please don't ask for more than
- the price of a floppy in return. This document must also
- always be included.
-
- The program is written in GFABASIC and compiled with
- it's GFA-compiler. The reason why I wrote this program
- is, that I just needed a good spreadsheet.
-
- 1.2.BUGREPORTS & UPDATES:
-
- If you've found some bugs during using it, please let me
- know by sending your bug-report to:
-
- Frank Hartog
- Indischestraat 45
- 2022 VP Haarlem
- The Netherlands
-
- If you want the latest update, pleas send:
-
- -An envelope with your name & address and something that
- covers the costs of having it send back to you.
- -An EMPTY floppy.
- (- A small token of appreciation (Preferably in dollars)
- By including the above, you will expedite a quicker
- response.)
- Please also state which version you use.
- Than I will send you the latest update of FHSPREAD as
- soon as possible.
- If you have included a fee, I will also let you know when
- a new version is available.
-
-
- 1.3.GETTING STARTED:
-
- If you want to copy the program you only have to copy the
- FHSPREAD-drawer to the disk or directory you wish. The
- FHSPREAD-drawer must contain the following files:
- FHS :this is the executable program.
- FHS_Historyfile :this is a text document.
- FHS_Manual :this is the file you are looking at
- right now.
- FHHC :this program needs to be in the same
- drawer as FHS if you want to make a
- hardcopy.
-
-
- To start FHS, you can select its icon or an icon of
- another FHS-sheetfile. You can also start FHS from CLI
- followed by the name of a FHS-sheetfile, the sheet will
- then be automatically loaded.
-
- !! If an ERROR 26 occurs during program start up, just
- delete the FHS_prefs file and after that FHS should
- work fine !!!
-
-
-
- 2.THE MENU:
-
- In the following chapter all the menu items will be
- explained, starting with the extreme left and ending
- with the extreme right menu. (Thanks to a special
- calculation algorithm, there is no need for a special
- menu-item to adjust the iteration, because there is no
- need for iteration.)
-
-
- 2.1.FHSPREAD V2.0:
-
- 2.1.1.ABOUT:
-
- Will introduceyou to the author of the program, and
- details about the version of the program.
-
- 2.1.2.NEW:
-
- Will erase the current sheet and clean the memory, but
- before this, it shows a requester to prompt if you are
- sure of this step in case you make an error.
-
- 2.1.3.LOAD:
-
- Will load an existing sheet, which must be a FHS-file,
- using a filerequestor.
-
- 2.1.4.SAVE AS:
-
- Will write the current sheet to a disk or wherever you
- wish to write it to, using a file requestor.
-
- 2.1.5.SAVE:
-
- Will (over)write the current sheet. If you have not
- written the sheet before, the program will show the file
- requestor.
-
- 2.1.6.DELETE:
-
- Will delete a file which is selected using the file
- requester. Before deleting the file, the program will
- prompt for confirmation.
-
- 2.1.7.PRINT:
-
- Will pop up a print window in which you can set:
-
- LEFT border offset,
- RIGHT border offset,
- TOP margin,
- BOTTOM margin,
- PAGE length,
- RANGE of the cells you want to print,
- NLQ on/off nearletterquality,
- DSTRK on/off doublestrike the protected cells.
- PRINT print the range of cells to a printerdevice or
- to a file.
- CANCEL will leave the print window.
-
- These items can be selected pressing the buttons with
- a mouse or by pressing the highlighted keys.
-
- 2.1.8.QUIT:
-
- Ques what, this option will quit the program.
-
- 2.2.SHEET:
-
- 2.2.1.COLUMN:
-
- Will let you set the width of the column which is
- indicated by the current cursor position.
- Default width is 10.
-
- 2.2.2.MOVE:
-
- Will move a selected range of cells to another position in
- the sheet. The incremental cell pointers in the cell will
- also change.
-
- 2.2.3.COPY:
-
- Will copy a selected range of cells to another position in
- the sheet. The incremental cell pointers in the cell will
- also change.
-
- 2.2.4.ERASE:
-
- Will erase a selected range of cells.
-
- 2.2.5.GOTO:
-
- Will let you jump to a specific position in the sheet, so
- you don't have to scroll all the way to it.
-
- 2.3.FORMAT:
-
- The menu items below will work in the following sequence:
- First select the menu-item from the menu, then select
- a range of cells after which, the selected cells will be
- changed or adjusted according to the selection chosen.
-
- 2.3.1.LEFT:
-
- Will align the selected cells to the left of their
- column.
-
- 2.3.2.RIGHT:
-
- Will align the selected cells to the right of their
- column.
-
-
- 2.3.3.CENTER:
-
- Will center the selected cells of their column.
-
-
- 2.3.4.CURRENCY:
-
- Will print the numeric cells in a currency notation.
-
- 2.3.5.NORMAL:
-
- Reset the selected cells.
-
- 2.3.6.FIXED:
-
- Defines a selected range of cells with a fixed number of
- decimal places.
-
- 2.3.7.PROCENTS:
-
- Will print the value of a numeric cell as a percentage.
- e.g. `0.89' will be shown as `89 %'.
-
- 2.3.8.HIDE:
-
- Will hide the selected cells. Where the cells contain a
- data they can be made visible with the next option.
-
- 2.3.9.UNHIDE:
-
- Will make the hidden cells visible again.
-
- 2.3.10.PROTECT:
-
- This will protect the selected cells from being
- overwritten. This will only be active if the option
- PROTECT ON is selected in the PREFS-menu.
- The selected cells will be printed in black.
-
- 2.3.11.UNPROTECT:
-
- This will make the protected cells unprotected.
-
- 2.4.LABEL:
-
- If you have created more than one label, you can use them
- in the formulas. When you have created a label of only
- one cell, you can use that label as a value. Otherwise
- you can use it as a standard range with for example the
- commands SUM or AVG.
-
- 2.4.1.CREATE:
-
- Will let you create a new label:
- First select CREATE from the menu,
- type in the name which you want to assign to the label
- and select a range of cells.
- You can create a maximum of twenty labels.
- If you select only one cell, the label will be used as
- a numeric value.
-
- 2.4.2.DELETE:
-
- Will show you the existing labels. A label can be deleted
- by selecting the labelname or by typing the number of the
- label and entering it with the return key.
- In cells, which referred to the label that was deleted, the
- name of the label will be replaced by the range or the
- cellpointer to which the label referred to.
- To leave the window press the right mousebutton or hit
- the return key.
-
- 2.4.3.SHOW:
-
- Will show the existing labels.
- To leave the window press return or press the
- left mousebutton.
-
- 2.5.GRAPH:
-
- 2.5.1.VIEW:
-
- Gives you a graphical representation of the selected
- ranges, selected with the menu-items which are explained
- in the following paragraphs.
-
- 2.5.2.TYPE:
-
- Selecting the type of graphical presentation:
- -LINE : Connects every point with a line.
- Each different line will have a different
- pattern.
- -BAR : Every value will be presented as a bar.
- Each Bar of a different range will have
- a different pattern.
- -STRAIGHT : One straight line will be drawn through al the
- points. Each different line will have a
- different pattern.
-
- 2.5.3.PRINT:
-
- Will dump your graphical representation to a printer.
- (Hardcopy).
-
- 2.5.4.SAVEIFF:
-
- Will write your graphical representation as an IFF-file to
- a disk.
-
- 2.5.5.X:
-
- Select the range of cells which will be displayed as the
- X-axis on your graphical presentation.
-
- 2.5.6.ABCDE:
-
- Select the ranges of cells which will be displayed as the
- Y-axis on your graphical representation.
-
- 2.5.7.TITLES:
-
- Will show a window in which you can give every axis a
- name and give your whole graphical representation a title.
- To leave the window, none of the bars must be active.
- Press return or place the mousepointer to the window
- and press the mousebutton then hit the space bar or press
- both mousebuttons.
-
- 2.6.PREFS:
-
- 2.6.1.LACED/HIRES:
-
- Will switch between a laced or a hires screen.
-
- 2.6.2.AUTOCALC:
-
- Will switch on/off the automatic recalculation of the
- sheet every time a numeric value or a formula is entered.
- When this option is off you can recalculate the sheet by
- pressing function key number ten (F10).
-
- 2.6.3.TASKPRI:
-
- This menu-item will let you select task priority. You can
- choose between +1,0 and -1 by selecting the value in its
- submenu.
-
- 2.6.4.WORKBENCH:
-
- Will let you switch on/off the workbench (if possible)
- to obtain some extra memory.
-
- 2.6.5.PROTECTION ON:
-
- If this option is on, the protected cells cannot be
- re-entered.
-
- 2.6.6.NTSC/PAL:
-
- Switches the sheet to PAL or NTSC.
-
- 2.6.7.WBSCREEN/COSTUMSCREEN:
-
- When WBSCREEN is selected, FHS will use a resizeable window
- on your workbench. If COSTUMSCREEN is selected, FHS will
- use its own screen.
-
- 2.6.8.CURRENCY:
-
- Lets you change the way in which you want to express your
- currency. Default is F, that stands for Dutch florin or
- Dutch gilders.
-
-
- 2.6.9.SAVE ICON:
-
- If switched on, it saves an icon with your FHS-sheet
- file.
-
- 2.6.10.LOAD PREFS:
-
- Let you load an already saved preference setting.
-
- 2.6.11.SAVE PREFS:
-
- Writes your prefs setting to the directory from which FHS
- is started.
-
- 2.7.KEYBOARD EQUIVALENTS:
-
- For almost every menu-item there is a keyboard
- equivalent. What they are can be seen by selecting a
- menu-item with your mouse.
-
- There are three variations:
-
- 1. Amiga sign + character means: right amiga button +
- character
- 2. A + character1 - character2 means: First press both
- Alt + character1 then press character2.
- 3. C + character1 - character2 means: First press both
- Ctrl + character1 then press character2.
-
- 3.AVAILABLE FUNCTIONS:
-
- In this chapter all available functions are listed:
-
- SIN(val) = Calculates the sine in radians.
- ASIN(val) = Calculates the arcsine in radians.
- COS(val) = Calculates the cosine in radians.
- ACOS(val) = Calculates the arccosine in radians.
- TAN(val) = Calculates the tangent in radians.
- ATN(val) = Calculates the arctangent in radians.
-
- RAD(val) = Changes degrees to radians.
- DEG(val) = Changes radians to dergees.
-
- ROUND(val,n) = Will round a numeric value to n digits.
- MOD(val,n) = Will give the modulus n of val.
-
- RANDOM(val) = Wil generate a random value between zero
- and val.
- EXP(val) = Calculates e^val.
- LOG(val) = Calculates the natural logarithm of val.
- LOG10(val) = Calculates the (LOG(val)/LOG(10)).
-
- FACT(val) = Calculates val!
- VARIAT(val,n) = Calculates val!/(val-n)!
- COMBIN(val,n) = Calculates val!/((val-n)!*n!)
-
-
- AVG(list) = Will calculate the average of all values
- in the list.
- 'example (AVG(A1..B3))'
- SUM(list) = Will sum all values in the list.
- 'example (SUM(A1..B3))'
- COUNT(list) = Will count the number of used cells in
- the list.
- 'example (COUNT(A1..B3))'
-
- There are also three constant values:
-
- PI = Will return the value of 3.14....etc.
- ( FALSE = Will return a '0'.
- TRUE = Will return a '-1'. these will be used
- in future versions. )
-
- Use F10 (function key number 10) to recalculate the
- spreadsheet.
-
- 4.ENTERING DATA:
-
- Use F2 (function key number 2) to change the items of a
- cell. You can also use this on an empty cell.
-
- 4.1.ENTERING TEXT:
-
- Place the cursor on the cell in which you want to start
- entering text. The program will recognize automatically if
- you are entering text. The default alignment is to the left,
- which can be recognised by a ' at the beginning af the
- text.
- If you want to align the text to the right you must first
- type a `.
- If you want to have the text centered you must first
- type a ^.
- If the text is longer than the width of the cell, the
- text will be printed over the empty cells next to
- the starting cell.
- Cells which already contain data will show their own
- data.
- To leave a cell you can press:-ENTER
- -CURSORKEY
- -MOUSEKEY
-
- 4.2.ENTERING NUMERIC VALUES:
-
- A numeric value can be entered simply by typing a value on
- the current cell.
-
- 4.3.ENTERING FORMULAS:
-
- If you want to put a formula in a cell, you must start
- by typing a '('. If you want to use values from another
- cell, just use the cursorkeys to go to the particular
- cell and enter ^,*,/,+ or - or if you want to select a
- range by pressing '.' and press the cursorkeys again.
- The program uses the usual priorities between +,- and *,/,^.
-
- 5.0.END NOTE:
-
- I want to thank you to Alex Teesdale for his advise on
- writing this manual.