Category : Lotus and other Spreadsheets
Archive   : WORDPLAN.ZIP
Filename : WORDPLAN.WP

\ncalc
\fill
\comment
\comment use default 66 lines per page
\comment \plength 60
\comment
\rmargin 72
\indent 5
\space 12
\center 1
W O R D P L A N TM
\space 11
\center 1
Version A.00.00
\space 17
\center 2
Copyright (C) 1986, DEA Software
All Rights Reserved
\bpage
\footer
\space 5
\center 1
First Edition .............September 1986
\space 8
\center 1
Disclaimer
\space
\fill
The information contained in this document is subject to change
without notice.
\space
DEA SOFTWARE MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS
MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
\space
DEA Software shall not be liable for errors contained herein or
for incidental or consequential damages in connection with the
furnishing, performance or use of this material. This document
contains proprietary information which is protected by copyright.
All rights are reserved. No part of this document may be
photocopied, reproduced or translated to another program language
without the prior written consent of DEA Software.
\space
All business application software is inherently complex and
users are cautioned to verify the results of their work.
\space
Trademarks
\space
\nfill
WordPlan is a trademark of DEA Software.
1-2-3 is a registered trademark of Lotus Development Corporation.
WordStar is a trademark of MicroPro International Corp.
DIF is a trademark of Software Arts Products Corp.
VisiCalc is registered trademark of VisiCorp.
PC-WRITE is a trademark of Quicksoft.
TURBO Lightning is a trademark of Borland International.
TURBO Editor Toolbox is a trademark of Borland International.
MicroStar is a trademark of Borland International.
\fill
\space
\center 2
Copyright (C) 1986, DEA Software
All Rights Reserved
\bpage
\footer
\center
Your WordPlan License
\space
WordPlan is distributed as a shareware product. The diskette with
WordPlan on it can be freely copied and shared. The latest
version is available from us at $10.00. We encourage users if
they find WordPlan useful to send DEA Software a donation of
$49.95. We ask for your help in distributing WordPlan to others
and encouraging them to send donations to us.
\nfill
Send checks to:
DEA Software
P.O. Box 968
Fremont, CA 94537

What you get if you donate $49.95

1. You will receive a printed copy of the WordPlan manual.

2. You will receive the most recent version of WordPlan.

3. You will receive the next update to WordPlan free.

4. You will receive future notices of updates.

5. You will help make the shareware concept work. Without your
support we can not afford to maintain and create additional
shareware products.


You may NOT:

1. Charge anything for WordPlan. An exception is made for
registered user groups who may charge a cost-based fee (not to
exceed $6) to cover their own costs.

2. Distribute this program in connection with any other product or
service, or as part of a corporate or institutionally supported
distribution. Site license and bundling agreements are available
upon request.

3. Distribute the program in modified form.

4. Copy or reproduce the printed documentation in any form.
\bpage
\center
Table of Contents
\space 3
What is WordPlan? ........................... 1

Possible uses ............................... 2

How to run WordPlan ......................... 3

General Editing keys for the menu fields .... 4

How to use the menus ........................ 5

Start up menu ............................... 5

Run Script menu ............................. 6

Run Editor menu ............................. 7

WordPlan Editor Quick Reference ............. 8

WordPlan Editor pull-down menus ............. 9

Run Convert menu ............................ 10

WordPlan Script Quick Reference ............. 11

WordPlan script language .................... 13

Common definitions .......................... 14

Special Business functions .................. 14

Calculation commands ........................ 17

Text formatting commands .................... 25

Non-command lines ........................... 29

Sample script ............................... 29

Problem/Enhancement Report .................. 37

\bpage 1
\footer WordPlan (tm) Copyright (C) 1986 DEA Software Page #
\center
What is WordPlan?
\space 2
\fill
WordPlan is the first "Living Document Processor" for Lotus 1-2-3
and other applications. WordPlan can read multiple Lotus 1-2-3
files and produce custom reports and documents. Unlike other
products which require the user to cut and paste Lotus 1-2-3
values into their documents whenever values change, with
WordPlan you only do it once. When values change in a Lotus
1-2-3 worksheet WordPlan is able to update all the numbers and
reformat the document.
\space
WordPlan is more than an add-on utility to Lotus 1-2-3. Because
it has an interactive modeling language with full math and
financial functions, it can be used stand-alone to provide
integrated text and numeric processing. WordPlan also includes a
powerful programmable script processing language so that the
user can create interactive applications. Interfaces to other
spreadsheet programs and applications are provided via the DIF
interchange format which WordPlan can read and write.
\space
WordPlan is menu and function key driven providing an easy and
friendly user interface. WordPlan's full screen script editor
has many word processing capabilities including an interface with
Borland's Lightning spelling checker. WordPlan has the ability to
convert WordStar documents into WordPlan format and back. When an
error is detected while processing a WordPlan script the user can
elect to have WordPlan automatically bring up the script editor
and position the cursor at the point of
error.
\space
WordPlan reads and can produce standard ASCII text files and thus
will work well with other editors or word processors. One very
fine shareware word processor that can be used with WordPlan is
PC-Write from Quicksoft.
\space
WordPlan will run on any IBM PC/XT/AT/JR or 100% compatible and
requires a minimum of 128k (recommend 256k+) and 1 disk drive.
\space
WordPlan is a must for Lotus 1-2-3 users who mix text and numbers
for reports and documents. WordPlan is also well suited for
people that have custom applications (such as accounting) and
want to create custom reports easily. WordPlan can be used to
request information interactively and merge it with standard
documents such as form letters, contracts, job offers, wills,
legal documents, and competitive proposals. It can also be used
as a data entry system for Lotus 1-2-3 via DIF files.
\bpage
\space 2
\center
Possible uses
\space 2
WordPlan is more than a text formatter or modeling package; it is
a decision support system generator. WordPlan can be used to
create interactive turn key decision support
applications.
\space
WordPlan can be used to perform "What if?" analysis, create
documents, develop financial models, produce proposals, generate
reports, etc. Below is a list of possible WordPlan
applications for an office and business environment.
\space
Examples:
\break
Real Estate Calculations - Calculation of real estate
investments, mortages, rent payments etc.
\space
Legal Documents - Contracts, job offers, purchase orders,
wills, etc. can be created, maintained and updated.
\space
Sales Proposals - Text and data can be merged to produce
competitive proposals.
\space
Form Letters - WordPlan can request text interactively and
merge it with standard form letters.
\space
Manuals - WordPlan allows the user to format text to produce
finished documents.
\space
Financial Reports - Math and business calculations can be
performed and financial reports produced.
\space
Business Analysis - Risk analysis, merchandising
calculations, time value of money, trade discounts, etc.
\space
Forms manager - Take any form and recreate it on your PC.
Load your pre-printed forms and let WordPlan help you fill
them out.
\bpage
\space 2
\center
How to run WordPlan
\nfill
\space
The current distribution disk contains the following files.

The WordPlan program files.

WP.COM
WPMAIN.CHN
WPRUN.CHN
WPRUN.000
WPRUN.001
WPED.CHN
WPED.000
EDITERR.MSG

The WordPlan demo script files

MENU.WP - Main demo menu script file
DEMO1.WP - Demo of financial script
DEMO1.WKS - 1-2-3 WKS file needed for DEMO1.WP
DEMO2.WP - Demo of sample form letter script
DEMO3.WP - Demo of summary of sales and cash receipt script

The WordPlan documentaion file

WORDPLAN.WP

Note!! all the WordPlan program files must be residing on your
current default directory while running. This restriction will be
changed in a future release of WordPlan.

To run type:

>WP

The following menus will be displayed.

1. To print out the WordPlan documentation go to the
Run Script menu and enter "WORDPLAN.WP" as the input file
to process. You can either output the documentation to
the default list device "LST" or you can specify a file
or other device to print to. Then press Start Process to
print the manual.

2. To run the demo's go to the Run Script menu and enter
"MENU.WP". As above decide on where you want the output
printed. Then press Start Process to run the demos.
\bpage
\space 2
\center
General Editing keys for the menu fields
\space 2
Return ........... Positions the cursor to the next menu field.

Tab ........... Positions the cursor to the next menu field.

<- (left arrow) .. Moves the cursor left one character position.

-> (right arrow) . Moves the cursor right one character position.

Insert key ....... Turns ON/OFF insert mode for the current field,
characters are inserted before the cursor position.

Delete key ....... The character to the right of the cursor is deleted.

Back space key ... The character to the left of the cursor is deleted.

Delete line key .. The current field is cleared.
\bpage
\space 2
\center
How to use the menus

Start up menu:

+-------------------------------------------------------------------+
| WordPlan (tm) Version XX.XX (C) Copyright DEA Software 1986 | Notes
| |
| WordPlan (tm) |
| (C) Copyright DEA Software 1986 |
| All rights reserved |
| Version XX.XX |
| |
| If you find this program to be of value, your donation to the |
| Author will be greatly appreciated. (Suggested donation $49.95) |
| |
| Send checks to: |
| DEA Software |
| P.O. Box 968 |
| Fremont, CA 94537 |
| |
| |
| Users are encourged to copy and share this program. |
| |
+-------------------------------------------------------------------+
|1-Run 2-Run 3-Run 4- 5-Page 6- 7- 8-Exit |
| Script Editor Convert Eject |
+-------------------------------------------------------------------+


1-Run Script : Load and display Script processing menu.

2-Run Editor : Load and run the WordPlan screen editor.

3-Run Convert : Load and display the Word Star conversion menu.

5-Page Eject : Send a line feed character to the standard list
device.

8-Exit : Exit WordPlan and return to DOS.
\bpage
Pressing function key 1 (Run Script) will display the following menu.

+-------------------------------------------------------------------+
| WordPlan (tm) Version XX.XX (C) Copyright DEA Software 1986 | Notes
| |
| |
| Process WordPlan script files |
| |
| |
| |
| Input file to process : MENU.WP ________________ |
| |
| Output file to write : ________________________ |
| (Default is printer LST:) |
| |
| Fill in the input and output filenames and select the appropriate|
| function key. |
| |
| fkey 1 : Start processing the WordPlan script file |
| |
+-------------------------------------------------------------------+
|1-Start 2- 3- 4- 5-Page 6- 7- 8-Exit |
|Process Eject |
+-------------------------------------------------------------------+

You can use the tab char or the Return key to switch from field to field.

1-Start Process : Start processing the script file specified in
Input file. Output goes to the file specified or
device in Output file. If Output file is blank
then output goes to the default list device LST:.

Input and Output filenames are normal DOS file
names and can be qualified by a path.

Other supported device names are:
LST: - system list device (printer)
CON: - the console device
AUX: - auxiliary device (COM1:)

5-Page Eject : Send a line feed character to the standard
list device LST:.

8-Exit : Exit Run Script menu and return to the Main
menu.
\bpage
Pressing function key 2 (Run Editor) will load and start the WordPlan
screen editor.

+-----------------------------------------------------------------------+
| WordPlan Editor Version XX.XX |
| IBM-PC/XT/AT/PCjr |
| |
| |
| Copyright (C) 1986 DEA Software |
| |
| |
| OpenFile: SAMPLE.WP___________________ |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
+-----------------------------------------------------------------------+
\space
\fill
Enter a script file name you wish to edit and press the CR key to
open the file for editing.
\space
WordPlan has a WordStar like easy to use text editor. If you are
familiar with MicroPro's WordStar, then you will find it very easy to
learn how to use the WordPlan editor. The only documentation we are
providing on the use of our editor is the Quick Reference guide below.
We suggest that you use the short guide and try editing a file.
\space
The WordPlan editor is a modified version of MicroStar from the TURBO
Editor Toolbox a Borland International product. Because of this fine
package we are able to offer you an editor that has Word wrap, Undo
last change, Auto indent, Find and Find/Replace, Block move and copy,
centering, multiple windows and a host of other features.
\space
Since the WordPlan editor is a RAM based editor, you can only
edit a file that will fit in available memory. To produce
documents larger than available RAM split it up into two or
more files and use the \include command to chain the files
together.
\nfill
\bpage
\space 2
\center
WordPlan Editor Quick Reference

F10 Activate Pulldown Menus

^A Left Word ^Q^S To left on line
^S Left Character ^Q^D To right on line
^D Right Character ^Q^J Jump to marker
^F Right Word ^Q^I Toggle auto indent mode
^E Up Line ^Q^R To top of File
^X Down Line ^Q^C To end of File
^R Up Page ^Q^B To begin of Block
^C Down Page ^Q^K To end of Block
^W Scroll Up ^Q 1 Jump to Marker 1
^Z Scroll Down ^Q 2 Jump to Marker 2
RETURN New Line .... ....
^N Insert Line ^Q 9 Jump to Marker 9
^G, DEL Delete Character ^Q^Y Delete Line Right
BKSP Delete Left Character ^Q^F Find Pattern
^I Tab ^Q^A Find and Replace
^T Delete Word
^Y Delete Line ^K^S Save File & Resume
^B Reformat Paragraph ^K^D Save & Open file
^V Toggle Insert Mode ^K^X Exit to DOS
^L Find Next Occurrence ^K^Q Abandon & open file
^J Beginning/End of line ^K 1 Set Marker 1
^P Insert Char by ASCII ^K 2 Set Marker 2
.... ....
^O^O Open new window ^K 9 Set Marker 9
^O^L Set Left Margin ^K^B Begin Block
^O^R Set Right Margin ^K^K End Block
^O^C Center Line ^K^H Hide Block
^O^K Change Case ^K^C Copy Block
^O^S Set UNDO Limit ^K^V Move Block
^O^W Toggle Wordwrap Mode ^K^Y Delete Block
^O^G Goto other window ^K^W Write Block
^O^I Goto Column ^K^R Read block
^O^N Goto Line ^K^M Set marker
^O^Y Destroy window ^K^T Define tab width
ESC Undo last change ^K^L Lightning spell check

Home Home cursor to start of line
Up-Arrow Move cursor up Down-Arrow Move cursor down
Left-Arrow Move cursor left Right-Arrow Move cursor right
Ins Toggle insert ON/OFF DEL Delete char
PgUp Page Up PgDn Page Down
\bpage
\space 2
\center
WordPlan Editor pull-down menus
\space
\fill
The WordPlan pull-down menu system can be activated by pressing
function key F10. Once activated you can use the left and right
arrow keys to position the cursor selection. By pressing the CR
key the command pull-down menu will appear. Now using the up and
down arrows you can now select the command to perform. Pressing
the ESC key will cancel the command pull-down menu and pressing
the ESC key a second time will cancel the cursor selection menu.
\nfill
\space
Pull-down menus

Block :
Begin, End, Copy, Move, Read, Write, Delete, Hide/show,
Spell check

Search :
Find, find/Replace, Next

Go to :
Top of file, End of file, Begin block, end Block, Line,
Column, Go marker, Set marker

Text format :
Insert ON/OFF, Word wrap ON/OFF, Auto indent ON/OFF, Left
margin ##, Right margin ##, Tab size ##, Undo limit ##

Window :
Select, Open, Close

File :
Open, Close, Save, save As, Directory, Logged dir, Print,
copY, Rename, Erase, Quit
\bpage
Pressing function key 3 (Run Convert) will load and start the WordPlan
conversion program.

+-------------------------------------------------------------------+
| WordPlan (tm) Version XX.XX (C) Copyright DEA Software 1986 |
| |
| File Conversion Section |
| |
| |
| Input file to convert : demo.doc________________ |
| |
| Output file to create : demo.out________________ |
| |
| |
| Fill in the input and output filenames and select the appropriate|
| function key. |
| |
| fkey 1 : Convert WordStar document to WordPlan document |
| fkey 2 : Convert WordPlan output to WordStar document |
| fkey 3 : Convert WordPlan document to ASCII document |
+-------------------------------------------------------------------+
|1-WS to 2-WP to 3-WP to 4- 5- 6- 7- 8-Done |
| WPlan WStar ASCII |
+-------------------------------------------------------------------+

Enter the file name to convert and the file name to create
then press one of the conversion function keys.

F1 - WS to WPlan will start converting a WordStar document
into a WordPlan document.

F2 - WP to WStar will start converting a WordPlan document
into a WordStar document.

F3 - WP to ASCII will start converting a WordPlan document
into a standard ASCII document. (all soft CR's into hard CR's)

F8 - Done will return to main menu.
\bpage
\space 2
\center
WordPlan Script Language Quick Reference

Business Functions

1. ABS (expression) ------------ Absolute value of expression
2. AVE (val, .., val) ---------- Average of set of values
3. FV (n, i) ------------------ Future Value
4. FVA (n, i) ------------------ Sum of Annunity
5. IRR (inv, cf1, .., cfn) ----- Internal Rate of Return
6. MAX (val, .., val) ---------- Maximum of set of values
7. MIN (val, .., val) ---------- Minimum of set of values
8. NPV (i, inv, cf1, .., cfn) -- Net Present Value
9. PV (n, i) ------------------- Present Value
10. PVA (n, i) ------------------ Present Value of an Annunity
11. SUM (val, .., val) ---------- Sum of set of values
12. TRUNC (val) ----------------- Returns whole number

Control and Calculation commands

1. \equation - assign cell variables to a value or math expression
2. \equation - assign cell variables to a character string
3. \mask - assign a output formating mask to cell variables
4. \display - display user messages to screen
5. \if - skip next command based on boolean test
6. \pad - turn on padding of cell output
\npad - turn off padding of cell output
7. \rdnumber - read values from keyboard with user prompt and
range checking
8. \rdtext - read text from keyboard with user prompt
9. \skip - skip text and commands until matching \eskip level
\eskip - end skiping of text and commands
10. \ntext - turn off processing text but does not affect
command processing
\text - turn on processing of text
11. \clscreen - clears the display screen
12. \gotoxy - move cursor to user column and row
13. \ceol - clear screen from cursor to end of line
14. \initialize - deletes all cell variables
15. \ldwks - load a user specified Lotus 1-2-3 worksheet
16. \include - append an alternate script file
17. \rag - set text formating for right ragged edges
\nrag - set text formating for right justified edges
18. \wrline - display user message and move cursor to next
line
19. \escape - output user escape characters
20. \tlen - assign padding width to text variables
21. \wrdif - write a user specified DIF file
22. \lddif - read a user specified DIF file
23. \cpad - overide default pad character (period) in text
24. \calc - turn on cell pre-processing in text
\ncalc - turn off cell pre-processing in text
25. \comment - user comments
26. \pcontrol - turn on page control processing of text
\npcontrol - turn off page control processing of text
27. \quit - terminate processing of script file now


Text Formatting Commands

causes
break
1. \break Y - output partially filled line and start new line
2. \bpage n Y - skip to top of new page and print page number
3. \center n Y - center n lines
4. \fill Y - turn on filling and justification of text
5. \nfill Y - turn off filling and justification of text
6. \footer str N - user footer title at bottom of eack page
7. \header str N - user header title at top of each page
8. \indent n N - sets left text margin
9. \tindent n Y - temporary set left margin for next line
10. \lspacing n N - sets the spacing between lines
11. \plength n N - sets the current page length
12. \rmargin n N - set the right text margin
13. \space n Y - output blank lines
14. \uline n N - underlines the next n lines of input
\bpage
\fill
\space 2
\center
WordPlan script language
\space 2
WordPlan uses the \ character, when it is the first character on
the line, to indicate that what follows is not to be part of the
text. The \ signals an equation, a question or other command.
This way, you can embed equations, prompts, etc. in your text for
calculation and control purposes.
\space
The @ character indicates that what follows is a variable. These
variables are storage locations that can be used for
calculations and as formatted output in the text.
\space
You can perform operations on ranges of variables (such as
totaling costs) by specifying only the lowest and highest
variable . Example: SUM(@A2..@B7)
\bpage
\space 2
\center
Some common definitions
\space 2
"value_range" - The user can specify a range of value locations
by using the character "." multiple times between
the two value location references.
\nfill
\space
Example: "@A1..@C5" or "@A1.@C5"
refer to the rectangular cell locations A1 to C5.

A1 A2 A3 A4 A5
B1 B2 B3 B4 B5
C1 C2 C3 C4 C5
\space
\fill
(You must note that the value location reference must be in
an increasing order. Therefore "@A10..@A1" is illegal.)
\space 2
"math equations" - WordPlan allows the user to perform from
simple "+", "-", "*", "/" to more complex equations with
built-in business functions.
\space
\nfill
Examples:
1. @A1+@D2
2. (@B1+@C2)*@D3
3. @A100 + irr(256000,@B5.@B26)
4. (((@AA5 + 256.89) / 127) * sum(@A2.@B125))
\space 2
\center
The Special Business Functions
\space 2
ABS - (math equation)
Returns the absolute value of the equation.

Example: abs(-256) returns 256

AVE - (value,....,value)
Returns the average of the set of values.

Example: ave (256, 156, 7) returns 139.6666

FV - (n, i)
Calculate Future Value of $1 at the end of n periods.
n = number of periods, i = interest.
fv = (1 + i)n

Example: fv(10, .06) returns 1.7909

FVA - (n, i)
Calculates the Sum of an Annunity of $1 Per Period
for n Periods.

n = number of periods, i = interest.

fva = ((1 + i)n - 1) / i

Example: fva(10, .06) returns 13.1817

IRR - (inv, cf1,..., cfn)
Calculates the Internal Rate of Return on investment.
inv = initial investment, cf1 = cash flow for first
year, cfn = cash flow for year n.

This equation solves for the value of i (irr) where
the net present value is equal to zero.

npv = -inv + cf1/(1+i)1+cf2/(1+i)2..cfn/(1+i)n = 0.

Example: irr(200000, -4000, 20000, 27000, 42000,
56000, 230000) returns .1272 (12.72%).

MAX - (value,..., value)
Returns the maximum of the set of values.

Example: max(256, 156, 7) returns 256

MIN - (value,..., value)
Returns the minimum of the set of values.

Example: min(256, 156, 7) returns 7

NPV - (i, inv, cf1,..., cfn)
Calculates the Net Present Value of an investment.
i = interest, inv = initial investment, cf1 = cash
flow for first year, cfn = cash flow for nth year.

npv = -inv + cf1/(1+i) + cf2/(1+i)2 .. cfn/(1+i)n

Example: npv(.1, 100000, 7000, 8500, 9000, 120000)
returns 2111.8776

PV - (n, i)
Calculates the Present Value of $1.
n = the period and i = interest.

pv = 1/(1+i)n

Example: pv(10, .06) returns .5584

PVA - (n, i)
Calculate Present Value of an Annunity of $1 per
period for n periods.
n = number of periods, i = interest.

pva = (1 - (1 / (1 + k)n) / i)

Example: pva(10, .06) returns 7.3600

SUM - (value,..., value)
Returns the sum of the set of values.

Example: sum (256, 156, 7) returns 419

TRUNC - (value)
Returns the value to the left of the decimal point.

Example: trunc (-256.789) returns -256.00
\bpage
\space 2
\center
Calculation commands
\space
\fill
In the Calculation Commands only the first 4 characters of
the command are looked at to determine the command.
\nfill
\space 2
Example: "\equation @A1 = 125" is equal to "\equ @A1 = 125"

WordPlan determines the command by "\equ" and the "ation" is
ignored.
\space 3
1. Setting a cell location to a value or math equation.
"\equation value_vars = math_equation"

Examples:
\equation @A1 = 125
\equation @A1.@B50 = 125
\equation @A1.@B50,@D77,@D99 = 125
\equation @B1 = (125 * @C5) / 256
\equation @B55 = npv (.5, @A5, @A9.@A25)
\equation @F5.@G12 = ave(max(@B5.@B10,@C34,199),@C55.@C100,@D1)
\space
\fill
The math equation is calculated on the right side of the "="
character and the value is saved in each of the Cell
Locations on the left side.
\space
A special feature of WordPlan: If the first character on the
right side of the "=" is a "+","-","/", or a "*", WordPlan will
calculate the math equation on the right side of the "=" after
the special operator character. Then, for each Cell Location on
the left, in their order of occurence, WordPlan will apply the
operator against the current value of the Cell Location with the
calculated value and save the new
value into the Cell Location.
\nfill
\space
\equation @A1.@A3 = + 125 is equal to the following three
statements:

\equation @A1 = @A1 + 125
\equation @A2 = @A2 + 125
\equation @A3 = @A3 + 125

Examples:

\equation @A1 = + (256 * ave (@C5.@D10))
\equation @A1.@D50 = * 256
\equation @A1,@B5.@B9,@B12 = / (@E14 *195) / @C25)
\equation @B34.@B55 = - (max (199, @A5.@A60) * .059)
\space 2
2. Setting a Cell location to a character string.

The Maximum number of characters you can store in a text
location is 255.

"\equation cell_var = 'character string"

Examples:
\equation @A1 = 'John R. Doe
\equation @A2 = 'California
\equation @B43 = 'North Valley
\equation @C19 = 'Great Britian

3. Setting an Output Format Mask.

A Format Mask is a method for defining how a particular Cell
Location will be printed out in the user's text output. Each
Cell Location has a Format Mask associated with it. The user
can change the default Format Mask to suit his particular
needs.

Note: The Format Mask can be a maximum of 255 characters in
length.

"\mask value_vars = Format_Mask"
Example: \mask @A1 = $###,###.##

Defining an output Format Mask:

(@) Each @ represents a digit position. An @ inserts a digit
in the Cell Location in the output text location. If
there are more @s than digits in the Cell Location, a
leading zero is inserted for each additional @. The @
character needs only occure once in the numeric mask.

(#) Each # represents a digit position. A # suppresses a
leading zero in this character position if it is to the
left of the decimal point of the Cell Location. When
placed to the right of the decimal point, zeros are
suppressed only if all number digits are zero.

(*) Each asterisk "*" represents a digit position.
Unused digits are forced to be returned as asterisks
instead of blanks.

($) Each "$" represents a digit position. A floating
dollar sign is returned in front of the number.

(.) The "." character inserts a decimal point in the
corresponding position in the formatted output text. Any
zeros to the right become significant.

(,) The "," character inserts a comma in the corresponding
position in the formatted text output if there are any
significant digits to the left.

(-) A sign position holder. If a negative number a minus will
be returned in that position.

(+) A sign position holder. If a positive number a plus will
be returned. If negative a minus will be returned.

Note:

1) Any other characters will be copied to the formatted
output text unchanged.

2) Decimals are rounded if they exceed the number of decimals
specified by the format.

3) If the number is too large for the mask, all digit
positions are filled with asterisks.


If the Cell Location contains 12345.6789

"@@@@@@@@@@" produces "0000012346"
"##########" produces "12346"
"**********" produces "*****12346"
"$#########" produces "$12346"
"@@@,@@@" produces "012,346"
"$#####.##" produces "$12345.68"
"Salary is $###,###.##" produces "Salary is $12,345.68"

Examples of setting Cell Location Format Masks:

\mask @A1 = $###,###.##
\mask @A1.@A10,@B30,@D50.@AA70 = $###,###,###.##
\mask @D7,@C12 = @@@/@@/@@@@
\mask @A34 = AGE = ## and WEIGHT = ####
\mask @CN12 = $########.##


Note: As new Cell Locations are created they will have a
default Mask of "###############.##"

4. Display command - allows the user to display messages to the
terminal. It does not affect the formatted text output. You can
include Cell Variables in the message.

"\display user message"

Examples:

\display Hello We are currently calculating NPV values
\display Entering Budget calculation section
\display Creating Business Tables
\display Old Cell is @A43 Enter New Value

5. If Command - allows the user to skip the next command by
using a boolean test.

"\if "

If the result of the relational operation is true then
process the next WordPlan command, otherwise the next command
will be skipped.

Relational_operators are:

"=" Equal To
"<" Less Than
">" Greater Than
"<=" Less Than Or Equal To
">=" Greater Than Or Equal To
"<>" Not Equal To

Examples:

\if @A2 = 195
\if (@A1 + @D5) * 256 <= (@A7 + @D9) * 256
\if @AA1 = (ave(@A2.@A9) + 10) * 5

6. Pad Command - allows turning On or Off the padding
attribute of each Cell or Text Location. If padding is
turned on for a Cell Location, blanks are added to the left to
make the output text as wide as the Format Mask. For Text
Locations, blanks are added to the right to make the output
text as wide as the Text Location Format Length.

"\pad vars" - turn padding on
"\npad vars" - turn padding off

Examples: \pad @C1
\npad @A1.@D50
\pad @A3,@C5.@C25,@D5

7. Rdnumber Command - allows the user to solicit values or
equations from the terminal and store the calculated value
into Cell Locations. If min and max ranges are specified then
WordPlan checks to see that only numbers within those ranges are
entered.

"\rdnumber vars # min_range, max_range : user message"

Examples:

\rdnumber @A61.@C25,@D35 # 100, 500 : Input The Price Of Cement?
\rdnumber @C5,@D6 : Enter Todays Date in MMDDYY format ?
\rdnumber @A5 # 10, 20 : Enter a number between 10 and 20


8. Rdtext Command - allows the user to solicit text from the
terminal and store it into Text Cell variables.

"\rdtext vars : user message"

Examples:

\rdtext @A1..@B10 : Enter Your Name
\rdtext @B1, B5 : Enter Street Address


9. Skip and End Skip commands - allow the user to skip
processing portions of the input text.

"\skip skip_level"
"\eskip skip_level"

When a \skip command is entered, WordPlan will skip
processing the incoming text until a \eskip command with the
same skip_level is entered. All WordPlan commands are also
ignored except \eskip commands. The \skip command was
designed to be used with the \if command to control the
formatted output.

A \eskip command without a previous executed \skip command
with the same skip_level is ignored by WordPlan.

Examples:

\if @A6 = 100
\skip 5
.
. All text in between is not processed by WordPlan
. if Cell Location A6 is equal to 100.
.
\eskip 5


10. Text Off/On command - allows the user to turn the text output
processing off but continue processing all WordPlan commands.

"\ntext" Turn text processing off.
"\text " Turn text processing on.

This feature was designed to be used with the \if command.

Examples:

\if @C5*79 >= 99
\ntext
.
. If @A5*79 is greater than or equal to 99 then
. the text in between is not processed. But the
. WordPlan commands are still processed.
.
\equation @C3.@C6 = ave(@A12.@B14) + 234
.
.
\text

11. Clscreen command - Clears the display screen

"\clscreen"

12. Gotoxy command - Move the cursor to user column, row

"\gotoxy col, row"

Example:

\gotoxy 5, 10 move cursor to column 5 row 10

13. Ceol command - Clear screen from cursor to end of line

"\ceol"

14. Initialize command - Initializes all of memory (deletes all cell
variables).

"\initialize"

15. Ldwks command - Load a user specified Lotus 1-2-3 worksheet
into memory.

"\ldwks wksname"

note! wksname can be a text cell variable that contains a wks
filename.

Example:

\ldwks demo.wks
\ldwks @A1

16. Include command - Append an alternate script file here.

"\include scriptname"

note! scriptname can be a text cell variable that contains a
script filename.

Example:

\include script2.doc
\include @A5

17. Rag command - Set for ragged text formating output

"\rag" - set for ragged formating
"\nrag" - set for non-ragged formating

18. Wrline command - Display user message and move cursor to next
line.

"\wrline message"

note! message can contain cell variables

Example:

\wrline Main Menu
\wrline Current rate is @3 on this date

19. Escape command - Allows the output of user escape characters.

"\escape #,#,#,#....."

#'s are in decimal notation

Example:

\escape 27, 15
\escape 27, 31, 45, 50

20. Tlen command - Set text cell variables pad length

"\tlen vars = length"

Example:

\tlen @A3..C10, @D4 = 10

21. Wrdif command - Lets you write a user specified DIF file. User
must specify starting and ending cell variable names.

"\wrdif difname : start_var..end_var"

note! difname can be a text cell variable which contains a dif
filename.

Example:

\wrdif savefile.dif : @A1..@D15
\wrdif @A2 : @A1..@D15

22. Lddif command - Lets you load a DIF file into memory. The user
must specify the starting cell location.

"lddif difname : start_var"

note! difname can be a text cell variable which contains a dif
filename.

Example:

\lddif oldfile.dif : @B1
\lddif @A2 : @B1

23. Cpad command - Allow the user to change the ignore pad
character. This feature is used to help the user line up cell
variables in formated text. (default ".")

"\cpad char"

Example:

\cpad *
\cpad "

24. Calc On/Off command - If on then pre-process cell vars in the
text. (default ON)

"\calc" - turn on cell pre-processing
"\ncalc" - turn off cell pre-processing

25. Comment command - Allow the user to include comments in their
scripts. They are ignored when encountered.

"\comment comment_message"

Example:

\comment
\comment We are calculating the Totals here
\comment

26. Pcontrol command - Allow the user to turn ON/OFF formfeed,
headings, trailers, etc.. in the WordPlan output.(default ON)

This command is very useful when you would like to use the formatting
capabilities of your own word processor or text formatter.

"\pcontrol" - Turn on page control processing
"\npcontrol" - Turn off page control processing


27. Quit command - Terminate processing of script file now.

"\quit"
\bpage
\space 2
\center
Text Formatting commands (Optional)
\fill
\space
Allow the user to format text to produce finished documents. The
Formatter provides the user with automatic right margin
justification, control of paging, indenting, centering, titling,
page numbering, underlining, and multiple line spacing. If the
user has a Word Processor or other text formatter they can use
their own program to produce the final
formatted text.
\nfill
\space
1. Break Command - Outputs the partially filled line. A new line
will now be filled from the following input text. This allows
the user to separate paragraphs. Other Formatting Commands
also generates breaks.

"\break"

2. Break Page - Skips to the top of a new page and sets the
specified page number. It will cause a line break.

"\bpage {n}"

n is optional and if specified will set the next output
page number to n.

Example:

\bpage 45 causes a page break and sets next
page to 45.

3. Centering - Allows the user to center n lines. This command
causes a break.

"\center n"

n is optional , if specified, WordPlan will center the next n
lines else it will center only the next text line.

Example:

\center 5 Center the next 5 text lines


4. Fill Command - Turns on the filling and automatic right
margin justification of the output text. WordPlan will try to
pack as many words as it can into a text line for output and
will add blanks evenly in the line to make the right margins
balance out.

"\fill"

default is filling turned on.


5. No Filling Command - Turns off the filling process and lines
are copied as is to output text.

"\nfill"

default is filling turned on.


6. Footer Title - Sets the footer title that will be printed at
the bottom of every output page.

"\footer footer_string"

footer_string is the footer title the user wishes to display
at the bottom of every printed page. If the character "#" is
included in the string it will be replaced by the current
page number.

Example:

\footer Mary Had A Little Lamb Page #


7. Header Title - Sets the header title that will be printed at
the top of every output page.

"\header header_string"

header_string is the header title the user wishes to display
at the top of every printed page. If the character "#" is
included in the string it will be replaced by the current
page number.

Example:

\header Story Book Land Page #


8. Indent - Sets the output text left margin to column n. It
does not cause a break.

"\indent n"

n is required and sets the left margin to it.

Example:

\indent 10 Sets the left margin to 10


9. Temporary Indent - Temporary sets the left margin to n for
one line. It causes a page break before setting the left
margin.

"\tindent n"

n is optional and if set will cause a break and the next
output line will be indented "n" spaces. After that line is
written, the current left margin is reset. The default for n
is 0.

Example:

\tindent 15 Temporary indent to column 15


10. Line Spacing - Sets the spacing between lines.

"\lspacing n"

n = the number of spaces between lines.
The default for n is 1.

Example:

\lspacing 2 double spacing


11. Page Length - Sets the current page length in lines. No break
occurs.

"\plength n"

n is optional and if specified will set the current page
length to it, else it will set it to 66.

Example:

\plength 56


12. Set Right Margin - allows the user to set the right text
output margin. This command does not cause a break.

"\rmargin n"

n is optional and if specified will set the right margin to n
else it is set to the default value of 60.

Example:

\rmargin 66 Set the right margin to 66


13. Spacing - allows the user to add blank lines between text
output. It causes a break then outputs a blank line.

"\space n"

n is optional and if specified will output n blank lines else
it outputs only one blank line.


14. Underlining - Underlines the next n lines of input, but it
does not cause a break.

"\uline n"

n is optional and if specified will underline the next n
input lines, otherwise only the next line is underlined.

Example:

\uline 10 This will underlined the next 10
lines.

\bpage
\space 2
\center
Processing of Non-command lines
\fill
\space
Non-command lines are all other input lines that are not the
aboved. These input text are formatted and written to the output
text file. Cell Location identifiers that are included in this
text, are replaced by the formatted value in these Cell
Locations. The format of the value is based on format mask in
that Cell Location. Text Location indentifiers are replaced with
the text stored in the Text Location. The replacement string is
padded on the right if text padding is on. All other text is
formatted by the built in text formatter if that option is
selected by the user for writing to the output text file.
Referencing cell locations in text is specified by a @ followed
with the cell location and as many pad characters as you like.
The default pad char is a period.
\nfill
\space
Example 1:

Mary had @2 white sheep and @3 black sheep.

@2...... White Sheep
@3...... Black Sheep
--------
@4...... Total Sheep


Example 2: Sample financial script

\clscreen
\comment
\comment READING LOTUS 1-2-3 WORKSHEET
\comment
\ldwks demo1.wks
\comment
\comment setup formatting commands
\comment
\nfill
\rmargin 72
\wrline 1985 ANNUAL REPORT
\indent 6
\center 4
1 9 8 5
A N N U A L
R E P O R T
A C M E C R E D I T U N I O N
\space
P R E S I D E N T ' S M E S S A G E
\space
\pad @C1..@C4
\mask @C1 = #,###
\mask @C2..@C4 = $##
\fill
\tindent 5
1985 has been a year of new programs and services at the Credit
Union. We introduced Share Draft Checking, All Saver
Certificates, Net Check payroll deductions, free travelers
checks, redemption of U.S. Savings Bonds, and Credit Line - a
self-replenishing, revolving line of credit. With the addition of
these programs, the Credit Union is now a more complete,
"one-stop" financial institution.
\space
\tindent 5
The Share Draft program has proven to be a major success story.
We opened more than @C1 accounts this year, and we expect this
number will grow as we add new services to the program. At
year-end, Credit Line was introduced; it provides overdraft
protection for Share Draft accounts, and is a source of immediate
credit. This is accomplished through a single credit application.
\tindent 5
Our other new programs and services have been equally well
received. The All Saver Certificate has proven to be of great
interest to our members. They have invested more than @C2 million
in this tax-free program. Free travelers checks and bond
redemptions are some other services our members are finding
increasingly attractive.
\tindent 5
Our new Individual Retirement Account policy will provide our
members a place to accumulate tax deferred funds. These accounts
will earn high dividends, while members save, augmenting their
retirement income.
\tindent 5
Even though 1985 was again a year of turmoil throughout the
economy, your Credit Union maintained its strong financial
position. We paid over @C3 million in dividends, met all
regulatory reserve requirements, and added to contingency
reserves. As of the end of November, our assets totalled over @C4
million.
\tindent 5
Looking to the future, the Credit Union is planning more new
programs and services. In an effort to increase the convenience
and accessibility of the Credit Union, we are planning to install
automated teller machines within the ACME complex in 1986. These
machines will be an added member service for simple transactions
such as account inquiries, deposits, and withdrawals. They should
help relieve the congestion in our lobby and parking areas. We
are also studying the feasibility of establishing a branch
office.
\tindent 5
In the past 20 years, the Credit Union has seen a large number of
changes and substantial expansion. It is through our professional
staff, dedicated Board of Directors, and especially our loyal
membership that we have been able to increase and improve our
services. We look now to the challenge of 1986 and foresee a year
of further growth and service improvements for you, our members.
\space 1
\tindent 5
John Doe, President
\bpage
\nfill
S T A T E M E N T O F C O N D I T I O N
\space
\comment
\comment SETTING UP DISPLAY FORMAT MASK
\comment
\pad @A1.@B25
\mask @A1.@B40 = ##,###,###,###
\comment
\comment CALCULATING COLUMN SUMS
\comment
\equation @B30 = sum(@B1..@B5)
\equation @A30 = sum(@A1..@A5)
\equation @B31 = sum(@B6..@B12)
\equation @A31 = sum(@A6..@A12)
\comment
\comment display yearly summaries
\comment
December 31 December 31
Assets 1985 1984
--------------------------------------------------------------------
Cash and
Investments @B1........... @A1...........
Loans to Members @B2........... @A2...........
Buildings and
Equipment @B3........... @A3...........
Receivable @B4........... @A4...........
All other Assets @B5........... @A5...........
--------------------------------------------------------------------
Total Assets @B30.......... @A30..........
\space 2
Liabilities and Members' Equity
--------------------------------------------------------------------
Members' Share and
Certificate Accounts @B6........... @A6...........
Accounts Payable @B7........... @A7...........
Notes Payable @B8........... @A8...........
Dividends Payable @B9........... @A9...........
Undivided Earnings @B10.......... @A10..........
Regular and
Contingency
Reserves @B11.......... @A11..........
Accrued Liabilities @B12.......... @A12..........
--------------------------------------------------------------------
Total Liabilities and
Members' Equity @B31.......... @A31..........
--------------------------------------------------------------------
\space
\comment
\comment convert to millions of dollars format
\comment
\equation @B1..@B14,@B30,@B31 = /1000000
\equation @A1..@A14,@A30,@A31 = /1000000
\comment
\comment calculate percent differences
\comment
\equation @A32 = (@B30 - @A30) / @A30 * 100
\equation @A33 = (@B06 - @A06) / @A06 * 100
\equation @A34 = (@B02 - @A02) / @A02 * 100
\equation @A35 = (@B13 - @A13) / @A13 * 100
\equation @A36 = (@b11 - @A11) / @A11 * 100
\equation @A37 = (@B01 - @A01) / @A01 * 100
\equation @A38 = (@B14 - @A14) / @A14 * 100
\comment
\comment set up output masks
\comment
\mask @A01..@B31 = #,###.#
\mask @A32..@A38 = ###.# %
\space
Year-end Financial Results for 1985 and 1984
(in millions)
1985 1984 %Change
--------------------------------------------------------------------
Total Assets @B30... @A30... @A32...
Members Share &
Certificate Accounts @B06... @A06... @A33...
Loans to Members @B02... @A02... @A34...
Delinquent Loans @B13... @A13... @A35...
Reserves @B11... @A11... @A36...
Cash & Investments @B01... @A01... @A37...
Dividends Paid to @B14... @A14... @A38...
\bpage
\equation @A39 = sum(@B15..@B18)
\mask @B15..@B18, @A39 = ###,###,###
\npad @A39
C R E D I T C O M M I T T E E R E P O R T
\space
--------------------------------------------------------------------
\space
\fill
\tindent 5
Throughout this year, lending activity continued at a steady
pace. The Credit Union offered a very diverse program that
included personal loans, auto/truck loans, share secured loans,
and real estate loans. Toward the end of 1985, we offered a new
program called Credit Line. This is a revolving line of credit,
and can be used as overdraft protection for share draft accounts.
\tindent 5
The Board of Directors maintained a continuing review of loan
activity throughout this year, and hopes economic conditions will
soon permit a return to an expanded loan policy. We think our new
line of credit will be a step towards this expansion, as well as
some other new programs now being considered by the Board of
Directors. These programs will be announced as they are
developed.
\tindent 5
Loan activity, although reduced from 1984, maintained a very
steady pace. During 1985, the Credit Union loaned @A39 to its
members. Loans of the following types were made:
\pad @A39
\space
\nfill
Personal @B15.......
Auto/Truck @B16.......
Real Estate @B17.......
Shared Secured @B18.......
TOTAL @A39.......
\space
\fill
\tindent 5
The Credit Committee appreciates your support in the past and
hopes to be able to offer an expanded loan policy in 1986.
\space
\tindent
Peter Doe, Chairman
\bpage
Sample Output

1 9 8 5
A N N U A L
R E P O R T
A C M E C R E D I T U N I O N

P R E S I D E N T ' S M E S S A G E

1985 has been a year of new programs and services at the
Credit Union. We introduced Share Draft Checking, All Saver
Certificates, Net Check payroll deductions, free travelers checks,
redemption of U.S. Savings Bonds, and Credit Line - a
self-replenishing, revolving line of credit. With the addition of
these programs, the Credit Union is now a more complete,
"one-stop" financial institution.

The Share Draft program has proven to be a major success
story. We opened more than 4,000 accounts this year, and we expect
this number will grow as we add new services to the program. At
year-end, Credit Line was introduced; it provides overdraft
protection for Share Draft accounts, and is a source of immediate
credit. This is accomplished through a single credit application.
Our other new programs and services have been equally well
received. The All Saver Certificate has proven to be of great
interest to our members. They have invested more than $11 million
in this tax-free program. Free travelers checks and bond
redemptions are some other services our members are finding
increasingly attractive.
Our new Individual Retirement Account policy will provide our
members a place to accumulate tax deferred funds. These accounts
will earn high dividends, while members save, augmenting their
retirement income.
Even though 1985 was again a year of turmoil throughout the
economy, your Credit Union maintained its strong financial
position. We paid over $12 million in dividends, met all
regulatory reserve requirements, and added to contingency
reserves. As of the end of November, our assets totalled over $15
million.
Looking to the future, the Credit Union is planning more new
programs and services. In an effort to increase the convenience
and accessibility of the Credit Union, we are planning to install
automated teller machines within the ACME complex in 1986. These
machines will be an added member service for simple transactions
such as account inquiries, deposits, and withdrawals. They should
help relieve the congestion in our lobby and parking areas. We are
also studying the feasibility of establishing a branch office.
In the past 20 years, the Credit Union has seen a large
number of changes and substantial expansion. It is through our
professional staff, dedicated Board of Directors, and especially
our loyal membership that we have been able to increase and
improve our services. We look now to the challenge of 1986 and
foresee a year of further growth and service improvements for you,
our members.

John Doe, President
\bpage
S T A T E M E N T O F C O N D I T I O N

December 31 December 31
Assets 1985 1984
--------------------------------------------------------------------
Cash and
Investments 47,659,015 47,277,068
Loans to Members 107,181,431 107,893,357
Buildings and
Equipment 988,424 1,074,163
Receivable 696,894 1,078,838
All other Assets 91,824 102,189
--------------------------------------------------------------------
Total Assets 156,617,588 157,425,615

Liabilities and Members' Equity
--------------------------------------------------------------------
Members' Share and
Certificate Accounts 141,240,257 138,892,579
Accounts Payable 9,011 1,691,398
Notes Payable 0 3,375,000
Dividends Payable 1,896,856 2,191,210
Undivided Earnings 75,000 380,269
Regular and
Contingency
Reserves 12,868,845 10,751,350
Accrued Liabilities 527,619 143,809
--------------------------------------------------------------------
Total Liabilities and
Members' Equity 156,617,588 157,425,615
--------------------------------------------------------------------


Year-end Financial Results for 1985 and 1984
(in millions)
1985 1984 %Change
--------------------------------------------------------------------
Total Assets 156.6 157.4 -0.5 %
Members Share &
Certificate Accounts 141.2 138.9 1.7 %
Loans to Members 107.2 107.9 -0.7 %
Delinquent Loans 0.4 0.7 -42.9 %
Reserves 12.9 10.8 19.7 %
Cash & Investments 47.7 47.3 0.8 %
Dividends Paid to 13.8 11.3 22.1 %
\bpage
C R E D I T C O M M I T T E E R E P O R T

--------------------------------------------------------------------

Throughout this year, lending activity continued at a steady
pace. The Credit Union offered a very diverse program that
included personal loans, auto/truck loans, share secured loans,
and real estate loans. Toward the end of 1985, we offered a new
program called Credit Line. This is a revolving line of credit,
and can be used as overdraft protection for share draft accounts.
The Board of Directors maintained a continuing review of loan
activity throughout this year, and hopes economic conditions will
soon permit a return to an expanded loan policy. We think our new
line of credit will be a step towards this expansion, as well as
some other new programs now being considered by the Board of
Directors. These programs will be announced as they are developed.
Loan activity, although reduced from 1984, maintained a very
steady pace. During 1985, the Credit Union loaned 38,450,763 to
its members. Loans of the following types were made:

Personal 12,951,691
Auto/Truck 16,803,003
Real Estate 7,038,147
Shared Secured 1,657,922
TOTAL 38,450,763

The Credit Committee appreciates your support in the past and
hopes to be able to offer an expanded loan policy in 1986.

Peter Doe, Chairman
\bpage
\space 1
\center
Problem/Enhancement Report
\space
Bug/Enhancement # ___________
(leave blank)
\space
Classify:(circle one) New Problem / Enhancement / Documentation Error

WordPlan release version ________________ Report Date ____________

Name ____________________________ Phone __________________

Company Name _______________________________________________________

Address _______________________________________________________

_______________________________________________________


Detailed Description ________________________________________________

_____________________________________________________________________

_____________________________________________________________________

_____________________________________________________________________

_____________________________________________________________________

Attach any other relevant material, such as printouts.

Hardware Configuration:

Type of computer _____________ Amount of memory _________

Printer (P/S) ________________ How connected ____________

Monitor board ________________ Disks ____________________

Dos version ________________ Additional info __________

____________________________________________________________

Return to : DEA Software
Dept. B
P.O. Box 968
Fremont, CA 94537

If you wish to receive a written reply, please enclosed a self
addressed/stamped envelope.