S W I F T   &   E A S Y   S P R E A D S H E E T			(c) MDL 1988

Swift is a very powerful spreadsheet with so many features that this is just a 
brief summary of its abilities. The manual gives full details and many examples.

Loading Swift the first time, there are a few questions about your equipment to
configure Swift for use. This is saved as a file CONFIG.TXT ready for next time.

Down the main screen's left side are the ROW numbers and along the top the
COLUMN letters. An inverse bar moves with the cursor, showing your location.

Above this is the Cell Memory Display Line, which shows the contents of the
cell under the cursor, and the Entry Line. Anything you type appears here with
any PROMPT messages which need a response. If you edit a cell, its contents are
copied here for you to change, with full text editing.

"Swift" is printed in the top right corner; any operational messages appear here
like "Wait", while Swift performs some operation such as saving, "Circ"
(circular reference found), "Calc" (manual calculation is on) and "End" (<END>
key pressed and not followed by a cursor key or <HOME>).

At the bottom of the screen the Help Line lists the function key actions.

SWIFT & EASY!

Swift is so easy to use with its unique POP UP menu system, you'll soon find
your way around. Press either the <ESC> or "/" key to bring up the MAIN MENU,
then press the initial letter beside the option you want or move the highlight
bar with the cursor and press <ENTER>. You can also use these keys:

FUNCTION KEY				<SHIFT> FUNCTION KEY
F1 - Re-Edit cell
F2 - "Split screen" menu		F2 - "Status of Swift" menu
F3 - Erase a range of cells
F4 - Alter cell format			F4 - Alter format of text cells
F5 - Goto a cell
F6 - Search for text			F6 - Find next occurrence
F7 - Copy a range of cells
F8 - Move a range of cells
F9 - Recalculate sheet
F10- Execute a macro			F10- Create a macro

ENTERING DATA

There are four main types of data you can enter into a cell:
1. Numbers - a value up to 8 decimal places
2. Text - a string of characters, starting with a " (quote) if not a letter
3. Functions - see below
4. Formula - a combination of values, cell references or functions joined by a
mathematical operator ( + / - * ). If the formula starts with a cell reference
this must be prefixed with a "+", eg +A1*10. If Swift cannot display a result
it will show an asterisk.

You can move, copy or alter the display format of any range of cells.

SWIFT FUNCTONS

Here "range" is a top left starting cell and a bottom right ending cell,
seperated by a full stop. The function will only act over this range.
Parameters in square brackets [] are optional, such as "min" & "max" which are
values the function will operate between, ignoring anything outside. An
"expression" can be either a number, a cell reference, another function or even
a combination!

All functions start with "@" (the "at" symbol) and can be followed by a semi-
colon and comment to remind you what the result meant. Swift ignores comments
in any calculations or searches.

MATHEMATICAL, STATISTICAL AND FINANCIAL FUNCTIONS

@COUNT(range[,min,max]); no. cells in RANGE containing any value
@MAX(range[,min,max]); max value in RANGE
@MIN(range[,min,max]); min value in RANGE
@MEAN(range[,min,max]); the mean of RANGE
@POWER(A,B); A to the power of B (can be values or cell references)
@PV(amount,percentage,duration); the present value of AMOUNT based on
	PERCENTAGE and DURATION. Any of these can be an EXPRESSION.
@SQRT(expr.); square root of EXPRESSION
@STD(range); standard deviation of RANGE
@SUM(range[,min,max]); add all values in RANGE
@VAR(range[,min,max]); variance of RANGE

LOG FUNCTIONS:	@LOG(expr.)	@LN(expr.)	@EXP(expr.)
@LOG produces base 10 results; @LN produces "natural" logarithms to base "e".
@EXP calculates the EXPONENT of EXPRESSION - the opposite of @LN.

TRIG FUNCTIONS:	results in radians not degrees.
@SIN(expr.)	@COS(expr.)	@TAN(expr.) 
@ASIN(expr.)	@ACOS(expr.)	@ATAN(expr.)

TEST FUNCTIONS	- evaluated when the sheet is recalculated

@BEEP(test expr.); BEEPs if test expression is TRUE
@IF(test expr.,true expr.,false expr.); displays TRUE result if TEST result
	is true, otherwise the FALSE result
@AND and @OR can combine tests into one Test function. Test expressions are:
= equal to	<> not equal to		< less than	> greater than
<= equal to or less   		=> equal to or greater.

DATE FUNCTIONS

@DATE(date or cell); no. of days between 1/1/1900 and DATE. If CELL is used,
	it must contain a date.
@TODAY(cell); puts date from system clock into CELL

PROGRAMMED INPUT FUNCTIONS

@TEXT("prompt",cell)	@NUMBER("prompt",cell)		@ASSIGN(expr.,cell)
"PROMPT" is a string of text to appear as a prompt on the Entry Line and CELL is
where you want to store the input. @TEXT handles any string of characters
(numbers will be regarded as text) while @NUMBER will only accept a value.
@ASSIGN calculates the EXPRESSION and stores it in CELL.

GRAPH & GRAPH PLOTTING FUNCTIONS

@GRAPH(origin,xmax,ymax[,"+"]); ORIGIN is bottom left cell; XMAX is width in
	characters; YMAX is height in rows and "+" indicates a border required.
@PLOT(range,"type"[,min,max]); "TYPE" indicates graph type; h (histogram with
	infill); H (histogram,partial infill); s (stacked histogram with infill)
	S (stacked histogram,partial infill); l (line graph); p (scatter graph).
"TYPE" also needs the character to use, eg @PLOT(A1.A20,"#h",50,100) means plot
a histogram with the # character, using data from A1-A20 with values between 50
and 100.

GOAL SEEKING FUNCTIONS

@SETUP(start,operation); carry out OPERATION on START. This is used with -
@GOAL(test expr.); target or GOAL to achieve. Uses same tests as TEST functions.

LOOKUP FUNCTION - This very powerful database function searches tables of data.

@LOOKUP(range,cell,offset[,destination]); CELL is the cell containing the TEXT
	or VALUE to search for; OFFSET is the row or column to cross-refer to;
	DESTINATION is where to store the result.

Swift evaluates COMPARISON to check if it is looking for text or a value and
RANGE to see whether it is searching a horizontal table (rows) or a vertical
table (columns). When a match for COMPARISON is found, Swift refers to OFFSET
and stores the result in either the function cell or the destination. Text
results must be stored in another cell. Number ranges must be sorted (a RANGE
command) before searching, else an incorrect result may be returned. With text
searches Swift looks for an exact match and case is ignored.

ORDERING

Swift is available in two versions:

SWIFT ADVANCED  -  £29.95  fully working version of this demo
SWIFT STANDARD  -  £14.95  all features except database, Trig & Log functions

Send cheque/Postal/Money Orders payable to Maynard International Ltd to 

12 Chiltern Enterprise Centre, Station Road, Theale, Berkshire, RG7 4AA

Visa, Access or American Express accepted - phone (0734) 302600

Prices include VAT, P & P and comprehensive manual
Purchase Orders from Government Depts & Local Authorities welcome