This screen is used for word processing, addressing envelopes, calculating spreadsheets, and more. While there is a good bit of power driving the word processor, and the spreadsheet and other mini-programming capabilities can be quite handy in conjunction with other ABC Software features, I would recommend Works, Word, or some other simple but professional Text Editor for your correspondence needs.
To learn more about the usefulness of this Text Editor in creating specialized reports and spreadsheets for your ABC Accounting data, ask about our Mini-Programming workshop. You’ll reap a lot of powerful information.
Helps Accessed From the Word Processor (W) Screen
File Help (W)
Ctrl+N—clears the screen so that a new record can be created.
Ctrl+P—Prints Word Processor documents. When you press Ctrl+P 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. See the section titled Printing From the Word Processor for more detail on this subject.
F5—exits lookup.
F6—opens lookup.
F9—saves record.
Shift+F9—deletes record.
F10—goes to the Selection Screen.
Shift+F10—goes to the Menu Bar.
Esc—exits one level.
Alt+F4—exits ABC.
Ctrl+D—Duplicates. 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 Ctrl+D. When prompted, enter the code of the page of information you want to duplicate and press Enter.
F7— loads previous record.
F8—loads next record.
Edit Help (W)
Ctrl+A—Adds a blank line at the cursor. This pushes the following lines down.
Ctrl+C—Copies text. Place your cursor on the field that contains the text you wish to copy and press Ctrl+C. Then move your cursor to the field you want your information copied to and use the paste (Ctrl+V) function.
Ctrl+E—Erases the line at the cursor.
Ctrl+V—pastes text. Any text that has been copied (with Ctrl+C) or cut (with Ctrl+X) may be pasted into any other field by using the Ctrl+V function. Simply place your cursor in the field you want to copy the information to and press Ctrl+V.
Ctrl+X—cuts text. Place your cursor on the field you want the text removed from and press Ctrl+X. The text will disappear. If you want to replace this text in another field, simply move your cursor to that field and use the paste (Ctrl+V) function.
Ctrl+Z—Zap! Undoes latest changes to the line the cursor is on. You may press Ctrl+Z to cancel your changes, providing you have not moved the cursor from the line or used any other Alt or Ctrl 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 Alt+-, and disappears when you move the cursor over the help line.
Alt+= —This gives a help line which is useful for centering text on the screen. This help line appears on the line below the cursor position when you press Alt+=, and disappears when you move the cursor over the help line. Alt+H is also used for centering text.
Alt+A—Adds 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—defines Beginning of block. (For use with Alt+K and Alt+R.) Place cursor at the beginning of the block you want to move or delete and press Alt+B. Then place the cursor at the opposite corner of the block and press Alt+K. This cuts the block. To insert the block, use Alt+I. (See Alt+I for more help on insertions.)
Alt+D—Divides a line. Place the cursor where you want to divide the line and press Alt+D. Beginning with the character at the cursor, the line will move down to the next line, pushing any following lines down.
Alt+E—Encrypts a document.
Any document written in the ABC Word Processor can be encrypted so that unauthorized persons cannot read or delete what is written.
To encrypt a document, press Alt+E and enter the password. The password can be letters, symbols or a word of your choice. You need to reenter the password to verify it.
To unencrypt an encrypted document, press Alt+E and enter the password.
DON'T FORGET YOUR PASSWORD!! It could take hours of costly programmer time to figure out what your password was. Even then, there is no guarantee that it can be discovered.
Alt+F—Formats a page of text.
1. Press Alt+B when the cursor is on the first line that you want formatted.
2. Press Alt+F 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 Enter. The text is formatted according to your specifications.
NOTE: Sometimes the right margin will not be straight/justified because there is a limit of only two spaces between words.
ALSO NOTE: These hot keys will not work on spreadsheets.
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 your formatted document, all your lines, except the indentions, must begin at the left margin. Do not specify a left margin after pressing Alt+F.
For another method of formatting text, go to the Shift+F1 screen and see Alt+F under the Edit section.
Alt+H—centers a line of text. To center the line your cursor is on, press Alt+H. The text is centered within the first 80 columns of the screen; then the cursor moves down a line, allowing you to use Alt+H to center the next line.
Alt+I—Insert text removed by Alt+K or Alt+R. This command inserts text that you removed with the Alt+K or Alt+R 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 Alt+K or Alt+R command, or until you leave the Word Processor (W) screen. This command copies lines or blocks.
Note that inserting text that has been removed with the Alt+K command requires that you create space for that text. Otherwise it will overwrite whatever text is already there. On the other hand, when used with Alt+R, Alt+I creates its own space.
Alt+K—Define end and remove a block of text. This command is much the same as Alt+R, except it allows you to cut a block of text that is not the full width of the screen. (Alt+R 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 Alt+B 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 Alt+B and Alt+K.
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 Alt+B to mark the first line. Use Alt+R to define the last line and remove the entire block from the document. If you wish, Alt+R without Alt+B can be used to remove one line of text. To remove only a partial line of text use Alt+B with Alt+K. Either way, use Alt+I to insert the block or line of text.
Page Up—moves cursor up 22 lines.
Page Down—moves cursor down 22 lines.
Shift+Up arrow—jumps cursor to the top line of the document.
Shift+Down arrow—jumps cursor to bottom of document. This places the cursor immediately below the last line of the document.
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 Space and a capital T. Place a stile (|) where you want the tabs. A page may contain as many tab definitions as desired. The program always uses the nearest tab definition line ABOVE the cursor location. Tab definitions are saved with the page but do not print.
Home—places the cursor at the beginning of a line or field. Pressing the Home key places the cursor against the left margin of a Word Processor document or spreadsheet.
End—Place the cursor at the end of a line or field. If the line is full, End places the cursor on the last character. (You may have to use the scroll bar at the bottom of the window to view text that goes beyond the visible portion of the screen.)
Tools Help (W)
Ctrl+F—searches for information. This command is used to search the Word Processor records 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 Ctrl+F, enter the word or phrase you are searching for and press Enter. You will be asked where you want to stop searching. Enter the code of the record where you want to stop searching (or press ~ if you want to search all records) and press Enter. The program searches the records for this screen and stops 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 Alt+G, then M (for Merge), next Enter, and lastly type a capital 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 on the Word Processor, a message appears alerting you of that. You must press Alt+G again and use a different code if you want to make a copy of the original document. If the new code is accepted, you will see it in the top left corner.) Press F9 to save the new record. The old record with the old code is retained.
Alt+J—Jumps to requested line number. Pressing Alt+J 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 enter 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 Enter to leave the cursor at its present position.
Alt+L—displays record Length. This gives a message at the bottom of the screen telling you how many characters long your document is.
Alt+M—sets Marker. This command allows you to mark a point to which you can return from any point in the document. Place your cursor on the line you wish to return to. Press Alt+M. You will be asked for a marker number. Enter a number from 0 to 9. For example, press 2. Now at any point in this document, you can press Alt+2 and the cursor will jump to the marker point.
NOTE: When you press your Alt+number, you cannot use the keypad numbers. You must use the keyboard numbers above the letters. Your location is erased when you leave that Word Processor record.
Alt+N—tells the spell checker to add this word to its dictionary. (Used within the Alt+V dictionary function.)
Alt+O—A spreadsheet will calculate only when you press Alt+O. Calculation starts where a line begins with a C followed by a space and calculates from left to right starting on that line, and continuing on the following lines. Calculation stops at a line beginning with a Q command.
Alt+S—Sorts a page alphabetically. 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 program acknowledges spaces as a symbol. And a space is indexed before any other character. So, for accurate sorting, all lines to be sorted should begin the same distance from the left margin.
Alt+V—Verifies 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 check and press Alt+V. Each time an unrecognized word is found, the cursor stops at the last letter of that word. An information line at the bottom of the screen lists the words that are closest alphabetically to the unrecognized word. If one of those words is the correct spelling of the word in the document, manually replace the incorrect word with the correct word. If you want to add the word to your ABC Accounting software’s dictionary, press Alt+N.
Alt+X—runs a page of programming. WUTRREPORT is an example of such a report.
Shift+F3—brings up an accountant's* calculator when your press it the first time. The second time you press it, the final calculations showing are entered into the field the cursor was on.
+ adds or totals - subtracts / divides
* multiplies ) clears ( exits calculator
= totals or equals
*If you are not familiar with an accountant’s calculator, you may want to take a little time to familiarize yourself with the differences in usage here. Figures are entered as positive or negative: i.e. 100+50-75= would be entered as 100+; 50+; 75- The answer calculates each time you press the positive or negative sign. The = sign or Enter key seldom need be used unless you are multiplying or dividing.
Text Editor Code Setup (W.0)
The first line on the Text Editor screen is the reference code line. Any document you wish to save in the Text Editor (W) screen should have a code entered before you begin typing the 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 all your correspondence with LTR___ (for letter). Say you were writing a letter to ADVANCED BUSINESS COMPUTERS. You could enter a code such as LTRABC. Then a letter to an individual by the name of Joe L. Blow could be coded LTRJLB.
By following a pattern like the above, you can more easily find what you are looking for, since this screen is indexed alphabetically by code.
Any standard function keys can be used in your code. You can find a list of these keys in the order they would appear "alphabetically" in Appendix B.
When you press F9 to save a document, the system date automatically encoded on the line just below your reference code. Unlike many of the dates in the ABC Accounting software, this date is entered as follows: Two digits for the year, two digits for the month and two digits for the day.
For example, Dec. 25, 2004 would be 041225.
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 code and the date do not print when you print your documents. Thus the third line is the first available line for your actual document.
Printer Commands (W)
1. 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. Be aware that all printer commands must start with a caret (^).
Here are the more commonly used commands:
^—Single space
^*—Center text
^_ —Start underlining
^.—End of record(Stop printing)
^<—Left justify text
^>—Right justify text
^=—Double space
^1—5 characters per inch
^2—6 characters per inch
^3—8 characters per inch
^6—6 lines per inch
^8—8 lines per inch
^P—10 characters per inch
^C—17 characters per inch
^D—Draft quality
^E—12 characters per inch
^F—Form feed
^H—High characters
^K—Don't print line
^L—Letter quality
^M—Margin
^N—End wide letters
^S—Set top of form
^Q—Quit underlining
^U—Utility quality
^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 computer just crashed.^Q
This sentence will be underlined when it is printed because the ^_ begins underlining and the ^Q stops the underlining.
Another example:
^1WE 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 Ctrl+P to print the document. In other words, the commands you inserted in the text will be used by default, even if you press Ctrl+P and select C to print 17 characters per inch.
Printer commands do not print when you print the document with Ctrl+P, just as the hidden formatting symbols of a Word document will not show on the printed page.
NOTE: These commands must be properly set up in the Printer Configuration ('P) screen for your specific printer in order for the commands to work.
NOTE ALSO that the right justify and left justify options work only per line. Each line that you want justified in this way needs to include the command.
2. There are several command formats used for setting up documents. Once again, these commands must have carets in front of them in order to work.
A. The ^Rfxxo___^ command format is used to bring information from another record into the document you are now creating. The information will not show on the Word Processor (W) screen but will be printed. (This command is used in conjunction with the ^Gfxx command which we will discuss below.)
1. The R means Replace. Always start this command with a caret immediately followed by an R.
2. The f stands for the file (screen) the information shall come from. Type a C in place of the f in the command format if the information you want comes from the Customer (C) screen. Type I if the information should come from the Inventory (I) screen.
3. The xx of the format stands for the Field Number of the screen you wanted the information from. Type the two digit number of the field you want the information to come from in place of the xx. For example, type 01 after the C if you want the customer's name to appear. Field 1 is the Customer Name field.
4. The o in the command format stands for option and can be replaced with any one of the following options.
C—Centers text according to designated margins.
G—when the name in the field is entered in the last name/first name format, it prints the first name only. Otherwise it prints Sir.
L—Left justifies text according to designated margins.
N—when the name in the field is entered in the last name/first name format, it prints the first name first and then the last name.
With N, you have a choice of 2 second options.
NA—prints the name as described above as well as whatever is in the next field (or the field After it), provided there is anything in that field. This combination is generally used when requesting data from the Name field.
NB—prints the name as described above, but gets it from the previous field (the field Before it) if there is nothing in this field. This combination is generally used when requesting information from the Attention field.
R—Right justifies text according to designated margins.
Z—The Z works only on a field with a zip code. It prints the city and state that go with the zip code indicated.
5. The caret at the end of the command string designates the margins. Nothing will be printed beyond the ending caret. So make sure you give yourself sufficient space. Also, any centering or justifying is done according to the beginning and ending carets of your command.
B. The ^Gfxx command format Gets a specified record from a specified file. This command will be used in conjunction with the ^Ifxxo^ and ^Rfxxo___^ commands.
1. The G is used to call up or Get a certain record. Always start this command with a caret immediately followed by a G.
2. The f in the command format stands for file (or screen). Type the letter of the screen you want your information to come from in place of the f.
3. The xx stands for the full code used for the record you are getting information from. This will be more than two characters and often has a number included at the end of the code when taken from the Customer screen or some of the other screens.
4. Note that this command string does not use a closing caret. Because it is used in conjunction with the other command strings and is not actually used to print data, there is no need of a closing caret. No further information can be entered on this line because of this.
C. The ^Ifxxo^ command format is used to Insert a certain field number. This command is practically identical to the ^Rfxxo___^ command except for the fact that the end caret is placed right up against the end of the command. The entire field to be inserted is copied regardless of the position of the caret. One advantage of this command over the ^Rfxxo___^ command is the fact that you may type other information on the same line as the ^Ifxxo^ command anytime after the caret. This makes it useful on a line with a greeting, enabling you to use a comma afterwards. A disadvantage is that you do not have a choice of options other than G.
1. The I is used to Insert information. Always start this command with a caret immediately followed by an I.
2. The f in the command format stands for file (or screen). Type the letter of the screen you want your information to come from in place of the f.
3. The xx of the format stands for the two-digit Field Number of the screen you wanted the information from.
4. The o of the format stands for option. Only option G, as discussed with the ^Rfxxo___^ commands, will work.
5. The caret at the end of this command string does not designate margins. Therefore it should be placed immediately following the command with no spaces in between.
III. Here is an example of how ^Gfxx, ^Ifxxo^ and ^Rfxxo___^ work in the heading of a form letter.
^I#08^
R#04Z ^
^GVADVBUC0
^RV01NA ^
^RV02NB ^
^IV03^
^RV04Z ^
Dear ^IV01G^,
A. Notice that you need to use beginning and ending carets if you want the command to print the designated data.
B. ^I#08^ means Insert the System Date (08) field from the # screen. (The I command does not require an ending caret.)
C. ^R#04Z_______^ says to Replace the space between the two carets with information from the Zip Code (04) field of the # (Company Setup) screen. The Z at the end also brings city and state information for that zip code from the Zip Code screen. Notice that when you use the ^R command, the size of the field is defined by the carets (^). If there are more characters in the specified field than what there is room between the carets, the extra characters will not print.
D. ^GVABC0 says to Get the record of a Vendor coded ABC0 on the V screen. Because this is a G code, it will only get this information (not enter into the Text Editor record) so it will be available for use with any ^Rfxxo___^ or ^Ifxxo^ commands that you use for this document.
E. ^RV01NA____^ says to Replace the space between the two carets with information from the Vendor Name (01) field of the V screen. (Using the record that the Get command brought up.)
F. ^IV03^ means Insert the information from the Street Address (03) field on the V screen.
G. ^RV04Z______________^ means Replace the space between the 2 carets with information from the Zip Code (04) field of the V screen. The Z means print the city and state that go with that zip code.
H. The ^IV01G^, means Insert the information from the Vendor Name (01) field of the V Screen. The G option means that if there is a name in this field with the last name/first name format, only the first name will print. If there is a business name in this field, the word Sir will print instead. (Do make sure you use the comma after this command to make it work properly.)
I. When the example heading is printed with the Ctrl+P command, it should look similar to this:
6/21/2003
JONESTOWN, PA 17038
ADVANCED BUSINESS CONCEPTS
27 EAST BERLIN RD
WINCHESTER, NY 01037
DEAR SIR,
Alt+F will search the page of text for a ^M (caret+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 spaces, and 40 specifies a right margin of 40 spaces. The text on the page is formatted to a width of 35 characters (40-5=35) when you press Alt+F.
Indentations in the left margin indicate the beginning of a paragraph. Though the left margin will not change on the screen, the printed page will have margins as set by the ^M command.
The ^M must be followed by the desired left and right margin widths. Each of these numbers must 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, you may go to the section titled Formatting Text later on in this chapter.
Printing from the Word Processor (W)
When you are ready to print something that has been typed in the Word Processor, press Ctrl+P. A message box appears, saying "Enter P)rinter N)umber D)isk or press Enter."
- Simply press Enter to print with the current printer settings.
- Press N if you want to enter a specific printer number. A message box advises you to enter a printer # from 00 to 99.
- Press D if you want to save the document to disk. A message box appears for you to enter the screen name you want to send the record to.
The next message box says, "Enter a format option, # of copies, or Enter for 1 copy." This option allows you to select your desired number of copies at once rather than pressing Ctrl+P every time and going through the submenus for each copy.
- If you press Enter when asked for the number of copies to print, one copy will be printed by default.
- If you specify the number of copies, you will be asked to: "Enter number of lines on page or label".
- The “Format Option” choice is basically obsolete. Ignore that part of the prompt unless you still use the wide paper for printing.
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.
1. Type your name and address as you want it to appear on the label, starting on line three of the screen.
2. Press Ctrl+P.
3. Press Enter.
4. Now type the number of labels you want to print.
5. Press Enter.
6. Type the number of lines on each label.
7. Press Enter.
(If you are printing 1-inch labels, enter 6 as the number of lines on a page or label.)
This text editor 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 continue to print on the next page.
You can also print an entire 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 (W) screen listing 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. Leave one line blank below the date line.)
When you receive the message, "Enter a format option, # of copies, or Enter for 1 copy", enter apostrophe (') followed immediately by the code of the record that contains the list of codes to print.
Spreadsheet Setup (W)
The Word Processor 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 Alt+O. Calculation starts where a line begins with a C followed by a space and calculates from left to right starting on that line, and continuing on the following lines. Calculation stops at a line beginning with a Q command.
NOTE: A C+Space+T command (C T) is used for setting tabs and does not start or affect calculation. A C T line is skipped when encountered during calculation.
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.
+—Adds
-—Subtracts
*—Multiplies
/—Divides
` (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 screens.
For example, a list of customers and their account balances. Enter a colon (:) followed by a C in Column A to load information from the Customer screen. 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. (Go to Appendix A for a list of Screen Codes and Field #s. Or press Ctrl+G 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 screen and field when you press Alt+O.
Following is an example of how your spreadsheet might look:
Before you press Alt+O:
After you press Alt+O:
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) Column totals will be divided by the number of active lines to find the average.
C—A C followed by a Space defines this line as the beginning of the spreadsheet Column divisions. Formulas are also defined on this line.
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 next Word Processor record. The following Word Processor record must not have a C+Space command, or the it will be treated 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 and the 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 non-calculated 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 program will scan ahead for the next C+Space command.
S—(Subtotal) Print column subtotals on this line.
T—(Total) Print column totals on this line.
V—(Variable) 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—Zeros the column totals at this point.
+—Adds this line to the column totals. NOTE: This command is optional. If there is no other command entered, it automatically defaults to add.
-—Subtracts 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 Alt+O:
Spreadsheet Example after calculating with Alt+O: