W - Word Processor

WORD PROCESSOR FILE HELP

WORD PROCESSOR LOAD HELP

WORD PROCESSOR TOOLS HELP

Formatting Text (W)

Word Processor - General Instructions (W)

Printing from the Word Processor (W)

Spreadsheet Setup (W)

Before you press :

After you press :

Spreadsheet Example before calculating with :

Spreadsheet Example after calculating with :

Note to ABC Programmers

Tabs (W)

Find (search a file) <Ctrl F> <Edit Help . . .> make copy of document <Alt G> undo line changes <Ctrl Z> Jump to line specified<Alt J> ruler <Alt -> display record Length <Alt L> centering ruler <Alt => set Marker <Alt M> Add text of dif page <Alt A> add New word to dict. <Alt N> start of col.\lines <Alt B> tOtal/save spreadsheet<Alt O> Encrypt/unencrypt <Alt E> Sort page(s) <Alt S> Format text <Alt F> center a line <Alt H> <File Help . . .> Insert removed text <Alt I> New record <Ctrl N> column end & remove <Alt K> Print <Ctrl P> line end & remove <Alt R> close lookup <F5> move screen to right <F11> close all lookups <Shift F5> move screen to left <F12> open lookup <F6> alternate lookup <Shift F6> <Load Help . . .>

WORD PROCESSOR EDIT HELP <Ctrl A> Add a blank line at the cursor. This pushes the following lines down.

<Ctrl E> Erase the line at the cursor. This brings up the following lines if there are any.

<Ctrl Z> Cancel line changes. You may be typing changes on a line and then decide you don't want it changed after all. You may press to cancel your changes, providing you have not moved the cursor from the line or used any other or functions since you made the change.

<Alt ->(dash) This gives a help line which is useful for counting characters and spaces on the screen. This help line appears on the line below the cursor position when you press , and disappears when you move the cursor

centering text on the screen. This help line appears on the line below the cursor position when you press , and disappears when you move the cursor over the help line. is also used for centering text.

<Alt A> Add text from another page. This command asks which page of data you want and inserts it at the current cursor position. Using a new page will duplicate a record.

<Alt B> Define beginning of block (for use with and .) Place cursor at the beginning of the block that you want to move or delete and press . The computer beeps to confirm your action. Place the cursor at the opposite corner of the block and press . This removes the block. To insert the block, move the cursor to the top left corner of where you want the block and press to insert it. You can use repeatedly if you want a number of copies. For each copy move the cursor

<Alt D> Divide line. Place the cursor where you want to divide the line and press . Beginning with the character at the cursor, the line will move down to the next line, pushing the following lines down if there are any.

<Alt E> Encrypt document. Press . Enter a password. Re-enter the password. To unencrypt the document, press . Enter the password. DON'T FORGET YOUR PASSWORD!

<Alt F> Format a page of text. will search the page of text for a ^M command and begin formatting the text on the line below the command. You may enter a ^M command line at the beginning of the page or at any point within the page where you want to set or change the margins. The text and the ^M command must be against the left side of the screen for this command to work properly. The right margin may be adjusted on the screen, but the left margin may only be adjusted when printing the page.

Here is an example of a margin command: ^M0540 The numbers 05 specify a left margin of 5, and 40 specifies a right margin of 40. The computer will find the difference between 5 and 40 and format the page of text to that width when you press .

Indentations in the left margin tell the computer that this is the beginning of a paragraph. The left margin will not change on the screen, but when printed the margins will be as set by the ^M command.

The ^M must be followed by the desired left and right margin widths. These numbers must always be entered as two digits.

You may also insert commands within the page to center, right justify, or left justify the text. Following are these commands:

                         <^<> Left justify text
                         <^*> Center text
                         <^>> Right justify text

These commands are activated only when you print the page. They are not part of the ^M command, but they use the margins specified by the ^M command to determine where to place the text. For another method of formatting text, from the Shift F1 screen select Questions and then the Formatting Text option.

<Alt H> Center one line of text. To center the line where your cursor is, press . The text is centered within the first 80 columns of the Word Processor screen. The cursor moves down a line at the same time, allowing you to use to center the next line down if you desire to.

<Alt I> Insert text removed by or . This command inserts text, that you removed with the or command, into your document at the cursor. This command may be used repeatedly because it stores the block in memory until you remove another block with the or command, or until you leave the Word Processor file (W). This command copies lines or blocks.

<Alt K> Define end and remove a block of text. This command is much the same as , except it allows you to cut a block of text that is not the full width of the screen. ( removes all the text on the line or lines, the full width of the screen.) Place the cursor at the opposite corner from where you pressed to cut out the block. The width of the column depends on the cursor position when you define the beginning and end of the block using and .

<Alt R> Define end of screen-width block and remove it. This command removes from the beginning of one line to the end of another line. Use to mark the first line. Use to define the last line and remove the entire block from the document. If you wish, without can be used to remove one line of text. To remove only a partial line of text use with . Either way, use to insert the block or line of text.

<Page Up> Move cursor up 22 lines.

<Page Down> Move cursor down 22 lines.

<F11>Move Word Processor Screen to the right. This works in conjunction with . It moves the Word Processor screen in the opposite direction as , 10 characters at a time.

<F12> Move Word Processor Screen to the left. Since ABC Version 5, you are not limited to lines of 80 characters on the Word Processor. When you press the whole screen with the text moves 10 characters to the left. You may have lines of up to 190 characters.

<Shift Up Arrow> Jump cursor to the top line of the document.

<Shift Down Arrow> Jump cursor to bottom of document. This places the cursor immediately below the last line of the document.

<Shift Left Arrow> Jump cursor to left side of screen, unless you are in the active part of a spreadsheet or have tabs set. If you are in the active part of a spreadsheet, the cursor will jump to the next column division to the left. If you have tabs set, the cursor will jump to the next tab definition to the left.

<Shift Right Arrow> Jump cursor to right side of screen, unless you are in the active part of a spreadsheet or have tabs set. If you are in the active part of a spreadsheet, the cursor will jump to the next column division to the right. If you have tabs set, the cursor will jump to the next tab definition to the right.

<Tab> Tabs are automatically set to every eighth place, but may be defined otherwise. To define tabs, begin a line with a capital C followed by a and a capital T. Place a stile (|) where you want the tabs. A page may contain as many tab definitions as desired. The computer always uses the nearest tab definition line ABOVE the cursor location. Tab definitions are saved with the page but do not print.

<Home> Place the cursor at the beginning of a line or field. Pressing the key places the cursor against the left margin of a Word Processor document or spreadsheet. Any where else in the program, places the cursor at the beginning of the field.

<End> Place the cursor at the end of a line or field. If the line is full, places the cursor on the last character.

WORD PROCESSOR FILE HELP
<Ctrl P> Print Word Processor documents. When you press you will be prompted with various messages from which you may select different options. Depending on which option you select, you will be prompted with several more messages.From the screen, select Questions, and then P for more details on printing options.

<Ctrl N> Clear the screen, without saving or unsaving the current record, and set the reference number to the next available number.

<F5> exit lookup <Shift F5> close all lookups <F6> open lookup <Shift F6> alterate lookup

<F9> save record <Shift F9> delete record <F10> selection screen <Shift F10> go to menu bar

<Esc> Exit one level <Alt-F4> exit ABC

WORD PROCESSOR LOAD HELP
<Ctrl D> If you want to enter the same, or almost the same, information under a different page code, type in the new page code and press . When prompted, enter the page code of the page of information you want to duplicate and press .

<F7> previous record

<F8> next record

WORD PROCESSOR TOOLS HELP
<Ctrl F> Find (search file). This command is used to search the Word Processor file for words or phrases. Pull up the record where you want to start searching, or clear the screen to start at the first Word Processor record. Press , enter the word or phrase you are searching for and press . You will be asked where you want to stop searching. Enter the code of the record where you want to stop searching and press . The computer will search the file and stop when it finds the specified word or phrase. If it does not find it, it will simply stop at the record you specified.

<Alt G> Make a copy of the document. Sometimes you may wish to make another copy of a page of a Word Processor document. If you press , then "M" (for Merge), next , and lastly type "U," the characters that you type after the U will be the page code for the additional copy of the document. (If that code already exists in the Word Processor file a message appears alerting you of that. You must press again and use a different code if you want to make a copy of the original document. When the computer accepts the new code, you will see it in the top left corner.) Press to save the new record. The old record with the old code is retained.

<Alt J> Jump to line number. Pressing the gives the following message, "At line __ Jump to line __". You may use this command to find out what line of your document your cursor is on or the number of lines in your document, and you may ener the number of the line to which you want the cursor to jump. If you use this to find out what line the cursor is on or how many lines are in your document, you may press to leave the cursor at its present position.

<Alt L> Display record length. This gives a message at the bottom of the screen telling you how many characters long your document is.

<Alt M> Set marker. This command allows you to set a mark to which you can return from any point in the Word Processor file (W). Place your cursor on the line you wish to return to. Press . The computer will ask for a marker number. Enter a number from 0 to 9. For example, press 2. Now at any point in the Word Processor document, you can press , and the cursor will jump to the marker point. Note: When you press your number, you cannot use the keypad numbers. You must use the keyboard numbers above the letters. Your location is erased when you leave the Word Processor record, even if you go to another Word Processor document.

<Alt S> Sort page. This command sorts the lines of the page in alphabetical order. Most symbols come first, followed by numbers, uppercase letters and lowercase letters. If some of the lines begin at the left margin and some of them don't, the sort might seem to be wrong. This is because the computer interprets each space as a character that preceeds all other characters. So, for accurate sorting all lines to be sorted should begin the same distance from the left margin.

<Alt V> Verify spelling. If you have the ABC dictionary installed, you can check the spelling of your document. Move the cursor to where you want to start the spell checking and press . If the computer finds a word that is not in its dictionary, it stops at the last letter of the unfound word. At the bottom of the screen the computer lists the words that are the closest alphabetically to the word it did not find. If one of those words is the correct spelling of the word in the document, replace the incorrect word with the correct word. If you want to add the word to the ABC dictionary, press .

<Alt X> Runs a page of programing. WUTRREPORT is an example of such a report.

<F4> Start macro from the line the cursor is on. Press and the macro name.

<Shift F4> Record Macro. Press to begin recording. Then enter the macro keystrokes. Press to end the macro. Press <M> for more information.

<Shift F3> calculator. Use + to add and total and - to subtract. Use / to divide and * to multiply. Use ) to clear and ( for off. Use = or for equals.

Printer Commands (W) You can insert printer commands within your word processor documents to print various character pitches and letter qualities. Depending on your printer and printer driver some of these may not be available. The commands are as follows:

                                            ^- - Single space
         ^1 - 5 characters per inch         ^D - Draft quality
         ^2 - 6 characters per inch         ^L - Letter quality
         ^3 - 8 characters per inch         ^U - Utility quality
         ^P - 10 characters per inch        ^H - High characters
         ^E - 12 characters per inch        ^_ - Start underlining
         ^C - 17 characters per inch        ^Q - Quit underlining
         ^6 - 6 lines per inch              ^W - Start wide letters
         ^8 - 8 lines per inch              ^N - End wide letters
         ^F - Formfeed                      ^K - Don't print line
         ^S - Set top of form               ^> - Right justify text
         ^. - End of record(Stop printing)  ^< - Left justify text
         ^= - Double space                  ^* - Center text
         ^M - Margin(see Alt+F from Shift F1 screen under EDIT help)

^Gfxx - Load a specified record from a specified file. This is used to bring information from another record into the printed document. This command is usually used with the ^Ifxxo and ^Rfxxo commands. See ^Rfxxo.

^Ifxxo - Insert field#. This command uses the same options as the ^Rfxxo command. See ^Rfxxo.

^Rfxxo - Replace this space with specified information. The ^Rfxxo command is used to bring information from another record into the printed document. Here is what the ^Rfxxo means:

The "R" means Replace.

The "f" stands for the file the information shall come from, such as C for Customer file or I for Inventory file.

The "xx" stand for the field number of the file. For example, field # 01 on the Customer file is the Customer Name field. The "o" stands for one of the following options:

A - Prints only if something is in the next field.

B - Prints the following field if nothing is in this field

N - When the name in the field is entered as Last Name, First Name it prints the first name first and then the last name.

G - When the name in the field is entered as Last Name, First Name it prints the first name only. Otherwise, it prints Sir.

Z - The "Z" works only on a field with a zip code. It prints City, State and Zip Code from the Zip Code file (Z)

The following codes only work when they are attached to the ^Rfxxo command. (They do not work with the Z option.)

                      C - Center text in space
                      L - Left justify text in space
                      R - Right justify text in space

Here is an example of how ^Gfxx, ^Ifxxo and ^Rfxxo work in the heading of a form letter:

                                                ^I#08
         ^GVABC0                              ^R#04Z              ^

         ^RV01N                  ^
         ^IV03
         ^RV04Z                  ^

         Dear ^IV01G^,

Now the translation - ^GVABC0 - tells the computer to Get the record of a Vendor coded ABC0 on the V screen so that information from that record can be included in the printed Word Processor document. The G means Get, the V means the Vendor file and the rest of the command is the vendor code. This information is not displayed on the Word Processor screen, it simply makes the information available to be pulled into the printed document with the ^Ifxxo or ^Rfxxo commands.

^I#08 means Insert, here, the system date, which is field number 08 on the # screen.

^R#04Z__________^ tells the computer to Replace the space between the two carets (^) with information from the # screen. Field 04 is the Zip Code field. The "Z" tells the computer to print the City and State that go with that Zip code.

^RV01___________^ tells the computer to Replace the space between the two carets (^) with information from the V screen. (The record currently on the V screen is the vendor coded ABC0 because of the ^GVABC0 command above.) Field number 01 is the name field.

^IV03 tells the computer to insert, here, from the V file, field # 03, which is the street address.

^RV04Z______________^ tells the computer to Replace the space between the two carets (^) with information from the V screen. Field # 04 is the Zip code field, the Z means print the city and state that go with that Zip code.

The ^IV01G tells the computer to check the vendor file. The "G" option means, if there is a person's first name in field # 01, it shall insert that name here. If it is a business name in field # 01, it shall use the word "Sir" instead.

Notice, when you use the ^R command, the size of the field has to be defined with carets (^). If there are more characters in the specified field than what there is room between the carets (^), the extra characters will not print. The ^I command does not require an ending caret (^).

When the example heading is printed with the +P command, it should look similar to this:

                                                 7/ 4/1997
                                                 JONESTOWN PA 17038

         ADVANCED BUSINESS COMPUTERS
         88 GREBLE ROAD
         JONESTOWN  PA  17038

         Dear Sirs,

^X - User defined codes (This means that depending on your printer, additional options could be set up.)

^Y - User defined codes

^Z - User defined codes

^A - prints the ASCII character of the decimal three-digit set. The sets must end with a caret (^). This allows you to print many characters and symbols that are not on a standard keyboard. The possibilities depend on your printer and printer driver.

All the Printer Commands, listed above begin with a caret (^). Here is an example of the use of printer commands:

^_The people are studious.^Q This sentence will be underlined when it is printed because the ^_ begins underlining and the ^Q stops the underlining.

Another example:

^5WE DECLARE ^3that we are the people ^Pthat understand ^Cvery little.^P

The first two words of the sentence will print at 5 characters per inch. The clause "that we are the people" will print at 8 characters per inch. The next two words, "that understand" is set to normal print which is 10 characters per inch. The last two words will print condensed, at 17 characters per inch. The ^P at the end of the sentence, sets the size back to normal print, 10 characters per inch.

These printer commands will override the size entered when you press to print the document. In other words, if you press and select C to print 17 characters per inch, the computer will use the inserted printer commands, regardless of your size selection.

Printer commands do not print when you print the document with . Nor is the space they use on the screen seen on the printout.

NOTE: These commands must be properly set up in the Printer Configuration file ('P) for your specific printer in order for the commands to work.

Formatting Text (W)
Formatting text means to make the margins straight. If a left margin number is specified, the document to be formatted does not have to aligned at the left side of the screen before it is formatted.

1. Press when the cursor is on the first line that you want formatted.

2. Press on the last line to be formatted. The message, "Enter width to format" appears.

3. Type the length that you want for each line, maximum 80. If you also want to set the left margin, type the margin size, separating the two numbers with a comma. (The total of

the two numbers must not exceed 80.) Press . The text is formatted according to your specifications. NOTE: Sometimes the right margin will not be straight because the computer puts a maximum of only two spaces between words.

For example, 70,5 would be lines 70 spaces long with left and right margins of 5 spaces. 70,10 would be lines of 70, a left margin of 10 and no right margin.

If you want paragraph indentions in the formatted document, all your lines, except the indentions, must begin at the left margin. Do not specify a left margin after pressing . For another method of formatting text, from the screen, see under the Edit section.

Word Processor - General Instructions (W)
This file is used for word processing and often takes the place of a typewriter. You can use this file for a wide variety of functions, from addressing envelopes to calculating spreadsheets.

The first line on the screen is the Code line. If you wish to save the documents you type in the Word Processor file (W), you must enter a code on this line. This should be done before you begin typing your document. It doesn't need to be fancy, just a few letters or numbers that you may use to reference the document.

For example, you may want to reference your letters by LTR-___. Say you were writing a letter to ADVANCED BUSINESS COMPUTERS. You may enter a code like this:

LTR-ABC. Then a letter to an individual by the name of Joe L. Blow could be coded LTR-JLB. By following a pattern like the above, you can easily find what you are looking for, since this file is sorted alphabetically by the codes.

The standard Function Keys are used in this screen also. You can find a summary list of these functions and how they perform in Appendix B. Press< B > to go to Appendics B.

When you press to save the document you just typed, the computer will enter the system date on the line just below the code. The date is entered like this: Two digits for the year, two digits for the month and two digits for the day.

For example, July 4, 1997 would be 970704. This allows you to see exactly when you wrote or last edited the document, and you don't need to worry about typing the date for information purposes. The computer automatically does it for you.

The code and the date do not print when you print your documents.

The third line is the beginning of your document. You may start your document on this line, or any following line to fit your application.

When in the Word Processor file (W) you have some and commands to simplify and speed your work. Press to view them.

Printing from the Word Processor (W)
When you are ready to print something that has been typed in the Word Processor, press . A message appears at the bottom of the screen, "Enter printer device S-Screen, P-10 cpi, E-12 cpi, C-17 cpi, M-Modem".

Simply press to print with the current printer settings.

Press S to display the document on the screen.

If you have only one printer and you want standard size print, 10 characters per inch, press P (Pica).

If you want slightly smaller print, 12 characters per inch, press E.

For condensed print, 17 characters per inch, press C.

To print to another computer, via a modem, press M. (The modem must be hooked up properly to a phone line for this to work.)

If you have more than one printer in your computer system, you can specify which printer to use by pressing N and entering the number. The next message that displays at the bottom of the screen is, "Enter # of copies to print, W Wide lines, or ' list:". This option allows you to select your desired number of copies at once rather than pressing every time and going through the submenus for each copy.

If you press when asked for the number of copies to print, the computer will automatically print one copy of your document. If you specify the number of copies, it will give you this message, "Enter number of lines on page or label".

You may specify the number of lines on a page for purposes like printing labels, etc. where you want to repeat a few lines a number of times. Take return address labels for an example. Type your name and address as you want it to appear on the label, starting on line three of the screen. Press . Press P, E, or C to select the desired character pitch. Now type the number of labels you want to print. Press . Type the number of lines on each label. Press . (If you are printing 1" labels, enter 6 as the number of lines on a page or label.)

The computer automatically prints 8 lines per inch if the total number of lines in your document is between 62 and 83. Otherwise, it prints 6 lines per inch.

If your document doesn't fit on 1 sheet of paper, it will print on two.

The Wide lines option was used more before ABC Version 5, when a Word Processor document was limited to 80 characters wide on the screen and you desired to print something wider than that. Currently the limit is 190 characters, so the Wide lines option is rarely needed anymore for printing on wide paper. For that rare case,

this is how it works. Suppose you have a sentence that is 240 characters wide and you want to print it all on one line on wide paper. Type all that fits on one line of the screen, using to shift the screen to the left. End the line with an open-bracket ([). Finish the sentence on the next line. The open-bracket ([) tells the computer to "attach" the following line onto the end of the first line when it is printed.

To print a document that is set up for wide lines (see preceding paragraph), prepare your printer with wide paper and press . Press P, E or C to select the desired pitch. When the message, "Enter # of copies to print, W Wide lines, or ' list:" appears, enter W. This tells the computer to print one copy with wide lines. If you want to print ten copies with wide lines you would enter 10,W.

The 'list option is used to print a list of Word Processor records in succession rather than pulling up each one and printing them individually.

To use this option, make a record in the Word Processor file (W) and list the codes of the Word Processor records you want to print. (This list must be against the left side of the screen, and must begin on the fourth line on the screen. Let one line blank below the date line.)

When you receive the message, "Enter # of copies to print, W Wide lines, or ' list:", enter apostrophe (') followed immediately by the code of the record that contains the list of codes to print.

Spreadsheet Setup (W)
The Word Processor file can be used to set up spreadsheets to add, subtract, multiply or divide columns and rows of numbers. Spreadsheets are used for quotes, timesheets, expense records, formula calculations, etc.

Spreadsheets can have a maximum of 25 columns and 99 rows. Each line is limited to 128 characters.

A spreadsheet will calculate only when you press +O. Calculation starts where a line begins with a C followed by a Space and calculates from left to right on that line, processing all the following lines the same way. Calculation stops where it finds a line beginning with a Q command.

NOTE: A C T command (C T) is used for setting tabs and does not start or affect calculation. A (C T) line is

To define the columns, enter a line beginning with a C, and use a stile (|) to mark the beginning and end of each column. The columns are automatically defined as A, B, C, etc., from left to right. A formula can be entered within the column divisions. For example, if you want Column A and Column B to total in Column C, enter A+B between the two stiles of Column C.

The following commands may be used between the stiles. Use "+" to Add. Use "-" to Subtract. Use "*" to Multiply. Use "/" to Divide.

"`" (Accent Mark) is used to add more than two columns of numbers. For example: Use A`D instead of A+B+C+D.

":" (Colon) is used to load information from other files. For example, a list of customers and their account balances. Enter a colon (:) followed by a C in Column A to tell the computer to load information from the Customer

file (C). Then list the Customer Codes you want to get the information from in that column. The first character of each code MUST be directly below the beginning stile. In the other columns enter a C, followed by the Field # from which you want to load the information. In our example, we want field # 1 which is the Customer's Name and field # 55 which is the Customer's Balance. Press< A >to go to Appendix A for a list of File Codes and Field #'s. Or press with the cursor in the desired screen and field and a message at the bottom of the screen tells you the Field #.) The information will load from the specified file and field when you press .

Following is an example of how your spreadsheet might look:

Before you press :

             CUSTOMER BALANCES
         C   | :C          | C1                     | C55         |
         H=========================================================
             BROCH 0
             DIADAI0
             HAVELC0
         H                                          ---------------
         T
         Q

After you press :

             CUSTOMER BALANCES
         C   | :C          | C1                     | C55         |
         H=========================================================
             BROCH 0       BROWN, CHARLES                  5660.01
             DIADAI0       DIAMOND DAIRIES INC.             588.36
             HAVELC0       HAVECO ELECTRIC COMP             776.87
         H                                         ---------------
         T                                                 7025.24
         Q

Within a spreadsheet, any line may begin with a command character. The command character must always be placed at the extreme left of the line you want it to affect. If a valid command character is not found at the beginning of a line, that line is added to the column totals. A column total is the total of the column at any given point in the column. For explanation of the command characters which can be used in your spreadsheet, see the following information:

A - (Average) The computer will divide the column totals by the number of active lines and put the results on this line.

C - A "C" followed by a Space defines this line as the beginning of the spreadsheet Column divisions and formulas are also defined on this line.

D - This command is used to duplicate a line from another place in the Word Processor. If you want to duplicate a line from the record you are working on, enter D followed by a comma, and the code word beginning at the third character on the line you want to duplicate. If you want to duplicate a line from another Word Processor record, enter that record code after the D and before the comma. The line you want to duplicate MUST begin on the third space in from the left side of the screen.

H - (Heading) No calculation is done on this line, but it appears on the printed spreadsheet.

N - Save the currently loaded record calculation at this point and begin calculation on the following Word Processor record. The following Word Processor record must not have a C command, or the computer will treat it like a separate spreadsheet rather than a continuation of the first.

O - Calculate other records. This is similar to the N command, except it allows you to specify which record you want to calculate next, instead of beginning calculation on the following Word Processor record. To specify the record(s) you want to calculate, enter O Record code, Record code. This command saves the current record calculation at this point and begins calculation on the specified record. When it is finished calculating the specified record, it comes back to the currently loaded record and searches for the next specified record to calculate. If it finds none, it finishes calculating the currently loaded record. This command may be used on the specified records also, as long as the total number of non-calculated records does not reach the maximum. The maximum number of noncalculated records varies depending on the length of the record codes. For record codes that are eight characters long, you may have approximately twenty records.

Q - This is the end of the spreadsheet. The computer now scans for the next C command.

S - (Subtotal) Print column subtotals on this line.

T - (Total) Print column totals on this line.

V - (Variable Type) All columns normally default to money type (.00). To change this type, enter one of the following commands within the column you want to change. You may have as many of these commands as necessary within one column. If you have two commands on one line within a column, it will use the second and ignore the first. These commands must be placed on a line that begins with a V.

         4 - 4-place Decimal
         6 - 6-place Decimal
         I - Integer (Whole Numbers)
         M - Money (.00)
         F - Floating Decimal
         A - (ASCII)  This allows you to enter  letters and numbers
         within the column. The column will not total.
         Z - Zero the column totals at this point.

         +   Add this line to the column totals. NOTE: This command
         is optional.  If  there  is  no other  command entered  it
         automatically defaults to add.

         -   Subtract this line from the column totals.
         *   Multiply the column totals by the figures on this line.
         /   Divide the column totals by the figures on this line.

         X   No calculation is done on this line. It doesn't appear
         on printout.

Spreadsheet Example before calculating with :

         SHOE SALES FORECAST FOR 1997 BY QUARTERS
         Style      1st     2nd     3rd     4th  Total Average/Qtr
         ==========================================================
         C        |       |       |       |       |  A`D  |  E/4  |
         V        I       I       I       I       I       I
           Dress  9500    8700    12000   6000
           Career 4000    8200    6000    9000
           Sport  13500   6000    9000    8700
         V                                                 Z
         H --------------------------------------------------------
         T Totals
         Q

Spreadsheet Example after calculating with :

         SHOE SALES FORECAST FOR 1997 BY QUARTERS
         Style       1st     2nd     3rd     4th  Total Average/Qtr
         ==========================================================
         C        |       |       |       |       |  A`D  |  E/4  |
         V        I       I       I       I       I       I
           Dress      9500    8700   12000    6000   36200    9050
           Career     4000    8200    6000    9000   27200    6800
           Sport     13500    6000    9000    8700   37200    9300
         V                                                Z
         H --------------------------------------------------------
         T Totals    27000   22900   27000   23700  100600
         Q

Note to ABC Programmers
For documentation on spreadsheet variable usage, and use of the "K" command, see WB56 in program source data.

Tabs (W)
Tabs are automatically set to every eighth place, but may be defined otherwise. To define tabs, begin a line with a capital C followed by a space and capital T. Place a stile (|) where you want the tabs. A page may contain as many tab definitions as desired. The computer always uses the nearest tab definition line above the cursor location. Tab definitions are saved with the page but do not print.