P17 P1 START> Information to get you up and running P3 Cursors How to move around the spreadsheet with the cursor P32 F1-Keys P4 Format How to change the appearance of your spreadsheet P5 Print Print all or a portion of your spreadsheet P10 Column How to Adjust the width of a Column P11 Graph A description of available graphs P12 Macro A little about macro keystroking P16 Range Operating on a Range of cells P18 Math The standard math functions P21 Finance Some Financial functions P23 Stats Statistical functions P28 Logical Logical Functions P30 Sorting How to sort a group of records P31 Quest So ask your database what you want to know P34 Explain P33 HERE! N N P *** A S - E A S Y - A S *** N P Welcome to the ASEASYAS help screens. To view a selected page of P help, simply move the pointer ( at the bottom of the screen) to P highlight a command and press [enter]. N P To access the MAIN menu from the spreadsheet press the [/] key. To P exit from any menu press the [ESC] key. N P The ASEASYAS menu structure follows a series of branches. Each P branch represents , either an additional menu or at the lowest level P a command choice. N P Several command switches must be activated to enable display options. N P ASEASY /H Enables graphics for Hercules type adaptors P ASEASY /E Enables graphics for EGA type adaptors P ASEASY /Q Quick screen updating for CGA type adaptors N P (-- See Next Page for Instructions on How to Order Your OWN Copy --) P O R D E R F O R M N P To register and get YOUR OWN copy of AS-EASY-AS, and a PRINTED P manual, print this form on your printer, using Shift-PrtSc, fill it out P and send it to TRIUS Inc. . N P Send me a registered P copy of AS-EASY-AS : Name: ________________________________________ N P Address: _____________________________________ N P City:______________ State:_____ Zip:________ N P Enclosed is a check P for $30.00 payable to >> TRIUS, Inc. P 15 Atkinson Street P Lynn, Mass. 01905 N P Signature__________________________ Date:____/____/_____ N P M O V I N G A R O U N D N P ╔═══════════╗ ╔══════╦═══════╦═══════╗ P ║ TAB ║ ║ 7 ║ 8 ║ 9 ║ P ║ PgRt ║ ║ Home ║ UP ║ Pgup ║ P ║ PgLt ║ ╠══════╬═══════╬═══════╣ P ╚═══════════╝ ║ 4 ║ 5 ║ 6 ║ P ║ Left ║ ║ Right║ P Each of the keys on the cursor ╠══════╬═══════╬═══════╣ P keypad has the ability to move ║ 1 ║ 2 ║ 3 ║ P the cursor around the spreadsheet. ║ End ║ Down ║ PgDn ║ P ╔══╚══════╬═══════╬═══════╝ P Home - Move to cell A1 ║ 0 ║ . ║ P Up - Move up one row ║ Insert ║ Delete║ P Pgup - Move up 20 rows ╚═════════╩═══════╝ P Left - Move left one column P Right- Move right one column PgRt - Move right one page P Down - Move down one row PgLt - Move left one page P Pgdn - Move down 20 rows N P F O R M A T T I N G N P The appearance of cells in a rectangular range can be assigned a P format with the following keystrokes: /rf N P TYPE FORMAT STATUS N P Fixed 123.12 [F2] P Science 1.245E+8 [S3] P Comma 1,500.0 [,1] P Currency $523.52 [C2] P Percent 34.12 [%2] P General P Text +A1+B2 [T] P +/- +++++ [+/-] P Date 20 May,87 [D1] Six different forms P Hide [H] Invisible cell P Reset Return to global format N N P P R I N T I N G N P The print menu may be selected from the main menu by selecting then P PRINT sub-menu. Your next decision will be to either, send all P output to a printer OR send all output to an ascii .PRN file. N P After selecting your output device, you must define a range to print P with the RANGE command. Listed below is the print menu structure. N P RANGE LINE PAGE ALIGN OTHER GO QUIT N P Once the range has been defined you can start printing by selecting P GO. To exit the print menu select QUIT. N N N N N P [More........] N P P R I N T C O M M A N D S N P Range - stands for the rectangular area of the spreadsheet which is P to be printed. This must be defined prior to initiating printing. N P LINE - advance the paper in the printer a single line upwards. N P PAGE - advance the paper in the printer to the top of next page. N P ALIGN - Since most computers don't know exactly where the top of the P page is you have to tell it. So line up the paper perforation with P the top of your printers print head. Then select ALIGN. This P synchronizes the computers and the printer so the pages line up. N P * * * * * * * * N P If you don't ALIGN your printer you may print over the paper P perforation. Messy! P [More...stuff] N P OPTION - This selection allows access to another menu. N P MARGINS P LEFT - Maximum left margin is 240 characters P RIGHT - Maximum right margin is 240 characters P TOP - Set the number of blank lines before printed text P BOTTOM - Set the number of blank lines after printed text N P PG-LENGTH - Allows you to set the length of a page. Up to 1024 lines P HEADER - The header string will be the top line of every page P FOOTER - The footer string will be the bottom line of every page P SETUP - Send special formatting control codes to the printer P TYPE - Instead of printing appearance , print contents N P GO - Finally when ready to print, select go. N P Notes: You can STOP the printer at any time by pressing the [ESC] key N N P [More...stuff] P C O N T R O L C O D E S N P With every type of printer you usually get a printer manual. P Somewhere in the manual are instructions for formatting the P appearance of characters produced by the printer. These instructions P usually consist of a series of codes sent to the printer. For P example the codes to produce EMPHASIZED text with an EPSON type P printer are: 027 069 N P The number 27 stands for the [escape] code and the number 69 stands P for the capital letter 'E'. N N P You can define the codes by selecting the following PRINT commands: N P / PRINTTO PRINTER OPTION SETUP N P After which you will be prompted to enter a setup string. N P [More...Codes] P All control codes must be placed in a SETUP string. ASEASYAS will P accept codes only if they are separated by the back-slash character P [\] . For example type the following in response to the prompt for P the setup string: N P \027\069 [enter] N P If you want to change the string you can edit it by reselecting the P SETUP option. Other commonly used codes for an EPSON type printers P are: N P \027\070 Emphasized text off \027\071 Double Strike on P \015 Condensed text on \027\072 Double Strike off P \018 Condensed text off \027\048 1/8" line spacing P \014 Enlarged text on \027\049 7/72" line spacing P \020 Enlarged text off \027\050 1/6" line spacing N P It is possible to place many different codes in the same Setup string. N N P C O L U M N W I D T H S N P You may adjust the width of any individual column by pressing the P following sequence of keystrokes: P /wcs32 [enter] N P This example activates the main menu, selects WSHEET COLUMN SET P and then inputs the size as 32 columns. N P OR . . . . N P Instead of typing you can also adjust the width by using the cursor P [left] and [right] keys. Try pressing one of these keys when P prompted for the column width. N P You can also adjust the global column width which applies equally to P all columns for which no local width has been assigned. For example P try typing: P /wgc15 [enter] N P G R A P H S N P You can plot up to 6 different curves on a single graph. Types of P graphs include: N P LINE - X values are treated as labels and plotted in P the order they occur in the X-range N P X-Y - X values treated as numbers N P BAR - X values treated as labels N P PIE - Y values plotted as percent of sum of Y values. P X contents are treated as labels and plotted P next to percent Y values. N P Scaling of both the X and Y axis can be performed. Log Scales can P also be applied to either the X or Y axis or Both axis. The graph menu P can be activated by pressing the slash [/] and the letter G. N P M A C R O S N P A macro is a sequence of keystrokes or commands which can be performed P automatically, just like a program. Macros can be defined by assigning P a range name a single letter [A..Z] preceeded by a [\] backslash. N P The macro will continue to execute downwards from the first row until a P blank row is reached or the [ESC] key is pressed. N P AutoExecute macros start executing immediately after a spreadsheet is P loaded. To define an autoexecute macro apply a range name of \0 to the P first macro cell to be executed. N P All macro keys and substitute function keys must be enclosed in braces {}. P Try the following simple macro which moves the cursor right 2 cells. N P Type the following in cell A1: {RT}{RT} [ENTER] N P Give cell A1 a range name of \A. Now press [alt] and the letter A. SEE! N P M A C R O K E Y S N P {LT} - move cursor left {PGLT} - move one page left P {RT} - move cursor right {PGRT} - move one page right P {UP} - move cursor up {PGUP} - move one page up P {DN} - move cursor down {PGDN} - move one page down N P Substitute Function keys and OTHERs. N P {EDIT} {NAME} {GOTO} {CALC} ~ - Substitute for [enter] P {ESC} {ABS} {WIND} {GRAPH} N P {?} - Pause for input N N N N N P [More........] N P M A C R O L A N G U A G E (1) N P A special set of programming macros is available which gives sub- P routines, goto's and special label and value inputs. Each option is P preceded by a slash [/x] and an identify letter. These choices are P available only from within an executing macro. N P {Jump} - JUMP to cell following instruction and start executing P {Call} - CALL routine at following cell and execute until {Ret} P {Ret} - RETURN from a called subroutine P {Quit} - QUIT, stop executing the macro P {If Test} - IF true then execute at following cell:else next row P {InLabel "Prompt",A1} - Input a LABEL and place at following cell P {InValue "Prompt",A2} - Input a NUMBER and place at following cell N N P For example: {Inlabel "What is your name:",A5} N P This will prompt for label place the result in cell A5. N P M A C R O L A N G U A G E (2) N P {MenuJump NAME} - Define your own menu and jump according to P menu selection. P {MenuCall NAME} - Similar to above but acts as subroutine call P {MenuWidth A1} - Set the width of menu, up to a maximum of 30 P {MenuXy A1,A2} - Set the col,row position of the menu. P {MenuOn} - Turn on menu updating P {MenuOff} - Turn off menu updating P {ScrnOn} - Turn on the screen display update P {ScrnOff} - Turn off the screen display update P {Update} - Refresh the screen with new cell values P {ClrScr} - Clear the entire screen P {GotoXy A1,A2} - Position character cursor at col,row P {Write "Message"} - Place message at character cursor position P {WriteLn "Message"} - Same as above ,after move cursor row down P {Recalc RANGE} - Calculate only the specified range P {Blank RANGE} - Erase the specified range P {Tone A1,A2} - Play a tone of duration, frequency P {Beep} - A single beep sound. P R A N G E N P The Range command allows you to operate on a rectangular block of P cells. For example, consider all the cells bounded by cell A1 and P cell D2, and assume that the cursor is currently at A1. To format P all the cells within the above block, to FIXED FORMAT with two P decimals, enter the followin keystrokes: N P /r ff 2 [ENTER] [LEFT] [LEFT] [DOWN] [DOWN] [ENTER] P ││ ││ │ │ │ │ │ │ └────── Finish P ││ ││ │ │ │ │ │ └─ Operation P ││ ││ │ │ │ │ └── Move to D2 P ││ ││ │ │ │ └── Move to D1 P ││ ││ │ │ └── Move to C1 P ││ ││ │ └─ Move to B1 P ││ ││ └── 2 Decimals P ││ │└─ Fixed P ││ └─ Format P │└─ Range P └─ Invoke Menu [More........] N N P The following operations can be performed on a range(block) of cells: N P FORMAT with a choice of: N P FIXED PERCENT COMMA TEXT DATE P SCIENCE CURRENCY +/- HIDE RESET N P NAME : Give a rectangular range of cells a name N P ERASE : Erase a range of cells N P LOCK : Prevent or allow changes on a cell N P PREFIX : Set up a range of cells to default to left P justified, right justified or centered. N P AUDIT : Trace the links to a cell throughout the worksheet. N P F U N C T I O N S N P The following functions act upon the arguement (represented by 'x' ) P contained within the parenthesis. The argument may be a value or a P formula which references other cells within the spreadsheet. N P Function Description Example P ──────────────────────────────────────────────────────────────────── P @ABS(x) Returns the absolute value of arguement. N P Example. @ABS(-10) = 10 N P @INT(x) Integer value of arguement. The fractional part P of the number is truncated and the integer P remainder is returned. N P Example: @INT(10.6) = 10 N P [More........] N P Function Description Example P ──────────────────────────────────────────────────────────────────── N P @LOG(x) Logarithm to base '10' @LOG(10) = 1 N P @LN(x) Natural Logarithmn of base 'e' @LN(6) = 1.7917594692 N P @EXP(x) Raise 'e' to the 'x' power @EXP(5) = 148.4131591 N P @SIN(x) Sine of angle, x in radians. @SIN(1.047) = 0.866 N P @COS(x) Cosine of angle, x in radians. @COS(1.047) = 0.5 N P @TAN(x) Tangent of angle, x in radians @TAN(1.047) = 1.732 N P @ATAN(x) Arc Tangent, returns radians @ATAN(1.732) = 1.047 N P @ASIN(x) Arc Sine, returns radians @ASIN(0.866) = 1.0471 N P @ACOS(x) Arc cosine, returns radians @ACOS(0.5) = 1.0471 P Function Description Example P ─────────────────────────────────────────────────────────────────── P @SQRT(x) Square root of arguement. @SQRT(2) = 1.4142135624 N P @MOD(x,y) Modula division, @MOD(10,3) = 1 P Remainder of x divided by y @MOD(8,2) = 0 N P @PI Constant which has a value of @PI = 3.14159... N P @NA Constant has a value of -1 N P @TRUE Constant has a value of 1 N P @FALSE Constant has a value of 0 N P @RAND Returns a new random number after each CALC. N P @ROUND(x,y) Rounds value x to y digits right @ROUND(123.123,1) = 123.1 P of decimal. Negative round to left.@ROUND(123.123,-2)= 100 N P F I N A N C I A L F U N C T I O N S (1) N P @PMT(Principal,interest,period) ex. @PMT(75000,0.0925,30) = 7462.61 N P Returns the amount of an annuity equal to the principal P amortized over the period. P ──────────────────────────────────────────────────────────────────── N P @PV(Annuity,interest rate,period) ex. @PV(700,0.0925,30) = 7035.08 N P Returns the present value corresponding to an annuity occuring P over the specified period. Reverse of the above. P ──────────────────────────────────────────────────────────────────── P @FV(Annuity,interest rate,period) ex. @FV(700,0.0925,30) = 99979.77 N P Returns the future value corresponding to an annuity occuring P over the specified period. Reverse of the above. N P [More...Math] N P F I N A N C I A L F U N C T I O N S (2) N P @NPV(Interest rate,Range) @NPV(0.1,A1..D1) N P Returns the Net present value of a cash flow over interest P period. N P ──────────────────────────────────────────────────────────────────── N P @IRR(Interest rate,Range) @IRR(0.11,H1..H5) N P Returns the Rate of Return per period associated with a cash P flow. More than one solution may be possible if cash flow changes P between positive and negative values throughout range. N N N N N N P S T A T I S T I C A L F U N C T I O N S (1) N P Statistical functions operate on a range of values. A range P specifies a rectangular block of data in the spreadsheet. Only ONE P range may be used as an arguement. i.e. Range = A1..B10 defines the P block of data from: P a1...b1 P a10...b10 N P When specifying the range only two dots can be used to seperate P cells. i.e. A1..B6 N P The range may be specified in two ways. N P The first way is to type the name of the formula up to and including P the first bracket. At this point use the cursor keys to move the P pointer out of the cell, and move it to one corner of the desired P range you wish to highlight. P [More........] N P S T A T I S T I C A L F U N C T I O N S (2) N P Press the '.' key. This anchors the pointer so that additional P pointer movements highlights more than just a single cell. N P Expand the pointer until the desired range is completely highlighted. P If the range is bigger than that area displayed on the screen then P press the '.' anchor key to examine each of the corners of the range. P A little flashing cursor will indicate the current corner. It is P also this side of the pointer which may be moved by the cursor keys. N P When the range is completly highlighted press any other key to return P to your original cell and continue to input your formula. Or if your P finished with the formula press the [enter] key. Your formula will P be entered into the spreadsheet at the current cell position. N N N P [More...Stats] N P S T A T I S T I C A L F U N C T I O N S (3) N P The second way to specify a range is simply to type the range name by P specifying the corners of the range as individual cells separated by P two periods. i.e. A1..B2 N P Presented below are the statistical functions available within P ASEASYAS. To illustrate the use of each function an example is P included. N P All examples will operate on the numbers contained in the portion of P the spreadsheet duplicated below, A1..B2 N P /........A/.......B/.......C/ P 1 1.1 5.6 8.2 P 2 2.3 7.5 10 P 3 3.5 4.4 2 N P [More....Stats] N P S T A T I S T I C A L F U N C T I O N S (4) N N P @SUM(Range) Sum of the range @Sum(A1..C3) = 44.6 N P @AVG(Range) Average value of the range @Avg(A1..B2) = 4.955555 N P @COUNT(Range) Count the number of elements @Count(A1..B2) = 9 P in the range. Blank cells ignored. N P @MIN(Range) Minimum value in the range @Min(A1..B2) = 1.1 N P @MAX(Range) Maximum value in the range @Max(A1..B2) = 10 N P @VAR(Range) Returns the population variance of @Var(A1..B2) = 8.438024 P the range. N P @STD(Range) Standard deviation of the range @Std(A1..B2) = 2.904827 N P [More........] P S T A T I S T I C A L F U N C T I O N S (5) N N N P @HLOOKUP(compare,range,ofs) N P Returns the value at vertical offset in the column P that matches the compare value. N P Ex. @HLOOKUP(5.6,A1..C3,1) N P @VLOOKUP(compare,range,ofs) N P Returns the value at horizontal offset in the row P that matches the compare value. N P Ex. @VLOOKUP(2.3,A1..C3,2) N N P [More........] P L O G I C A L F U N C T I O N S N P The function @IF(Test arguement,arg1,arg2) returns: N P value of arg1 if the test is true P value of arg2 if the test is false N P Test may use logical operators >,<,=,<>,>=,<= #OR#, #AND#, #XOR etc. N P Example @if(10>2,3*2,4+5) = 6 P @IF(10<2,3*2,4+5) = 9 N P As an example of using logic within a formula try the following: N P +(a1>2)*3+(a1<=2)*4 N P This formula will yield a result of 3 if the value stored in P cell A1 is greater than 2 and will yield a 4 if the value is P less than or equal to 2. N P D A T E F U N C T I O N S N P @DATE(Year,Month,Day) @DATE(87,5,20) = 31917 N P Returns a unique integer for each day since Jan 1,1900 N P @TODAY P Returns the unique integer corresponding to todays date. N P @YEAR(x) @YEAR(31917) = 87 P Computes the year in which unique day occurs N P @MONTH(x) @MONTH(31917) = 5 P Based on total elapsed days determine month N P @DAY(X) @DAY(31917) = 20 P Based on total elapsed days determine day in month N N N P S O R T I N G N P Sorting a data base of records by any field ( a column ) may be P done by performing the following sequence of keystrokes. N P 1. Get into the Data Sort menu by typing /DS N P 2. Define the INPUT range, This includes all records in the data P base.( i.e. all rows and columns, excluding the headings) N P 3. Define the PRIMARY key N P 4. Optional: Define the SECONDARY key or tie breaker N P 5. Select GO to initiate the sort. N P 6. WAIT! The sort will be completed shortly and a beep will P sound. N N P Q U E S T I O N I N G N P So now you have entered in your data and you want to extract all P records which match a selected criteria. Follow these steps. N P 1. Define your Criterion range by first copying those headings P over top of the fields you wish to search. The headings P MUST match exactly. N P 2. In the row beneath each of the headings type in the criteria. P If searching for a string match use the wildcard identifiers. N P asterix * - match all characters including and to right of * P mark ? - match single character in position of ? mark. N P Example NAME <---- Heading of data base P BOB? <---- First criterion P B* <---- Second , match all beginning with P letter B N P F U N C T I O N K E Y S N N P ┌─────╖ ┌─────╖ P Display - HELP ««« │ F1 ║ │ F2 ║ »»» EDIT - Allow changes to cell P Help ╘═════╝ ╘═════╝ under cursor. P ┌─────╖ ┌─────╖ P List - NAME ««« │ F3 ║ │ F4 ║ »»» ABS - Makes cell references P File names ╘═════╝ ╘═════╝ absolute P ┌─────╖ ┌─────╖ P Move to - GOTO ««« │ F5 ║ │ F6 ║ »»» WINDOW - Changes windows or P indicated ╘═════╝ ╘═════╝ flips screens. P cell ┌─────╖ ┌─────╖ P Undefined - │ F7 ║ │ F8 ║ - Undefined P ╘═════╝ ╘═════╝ P ┌─────╖ ┌─────╖ P Recalc - CALC ««« │ F9 ║ │ F10 ║ »»» GRAPH - Display current graph P all cells ╘═════╝ ╘═════╝ N N P T R O U B L E N P Following are answers to some commonly asked questions. N P Question Answer N P I see ASTERIXES where my number Number is to wide to be displayed P used to be. in the column. Expand column until P Number appears or change format , P /Wsheet Column Set N P Not all of my spreadsheet prints. Your print margins are not wide P Part is cut off. enough. Expand margin with, N P /PrintTo Printer Options Margin N P How do I get an AUTOEXEC macro. Give your macro a range name of \0. P If you want worksheet to autoload P give it a name of AUTOEXEC.WKS N P E X P L A I N N PPARSE - Converts a string (a collection of characters) into equivalent P formulas or values in adjacent columns in the same row. N PTABLE - Allows you to automate the process of changing individual P cells (which feed a spreadsheet model) and have the spreadsheet P get the result and place it in a table for you. N PSORT - You can sort a range of data alphabetically and numerically. P Each row is a single RECORD of information. Each column P represents a FIELD. You can sort based on a single field or P with an additional tie breaker field. N PQUESTION - With a data base as described in sort, you can make ASEASYAS P search through the data base and extract (place in another area P copies of the record) records which match the criteria you define. N N P [The end]