Category : Financial and Statistics
Archive   : PROSPANS.ZIP
Filename : PROCALC.HLP

 
Output of file : PROCALC.HLP contained in archive : PROSPANS.ZIP
SFLIDÁA&( PROCALC.HLP CALCBCOP.TXTÁCALCBDEL.TXT§CALCBFRM.TXT|CALCBLK.TXT 2
CALCBSET.TXTC CALCBST.TXT 
CALCBTGL.TXTNCALCCCLR.TXTCALCCCOL.TXTCALCCDEL.TXT,CALCCDL.TXT ÙCALCCED.TXT ÐCALCCELL.TXT@CALCCINS.TXTÔCALCCMAN.TXTÌCALCCROW.TXTR"CALCCWID.TXTÔ#CALCDCOP.TXTa%CALCDDEL.TXT(CALCDEDT.TXT*CALCDOCU.TXTþ,CALCDRNM.TXT2CALCDSAV.TXT&5CALCMGO2.TXTÇ8CALCOAUT.TXTÜ;CALCOEGA.TXT@CALCOFRM.TXTBCALCPRT.TXT §DCALCRDEL.TXTVHCALCREF.TXT ëICALCRINS.TXT@LCALCSYS.TXT 2NCALCWADD.TXT bCALCWCLS.TXT#cCALCWERA.TXTÔdCALCWNXT.TXTfCALCWOPN.TXTRgCALCXIT.TXT i ¯m
***** BLOCK COPY *****

FUNCTION:
Copies a predefined block to a prompted coordinate.

ENTRY:
You will be prompted to enter the destination coordinate:

'Copy to cell: '

Next you will be prompted on whether to copy the formulas literally. If
you answer 'Y'es then the formulas are copied verbatum otherwise the
formulas are adapted to the new coordinates.

'Copy formula columns literally (Y/N): '

'Copy formula rows literally (Y/N): '

RESULTS:
The Block Area is copied using the options given to the destination
coordinate.

REMARKS:
Caution should be used not to overwrite desired data when using the Block
Copy command.

***** BLOCK DELETE *****

FUNCTION:
Delete the defined Block.

RESULTS:
All cells within the Block Area are cleared.

REMARKS
Block Delete is irreversible.
 BLOCK FORMAT

FUNCTION:
This command allows you to format the cells within a Block Area.

ENTRY:
You are first prompted on dollar format for cells having numeric values:

'Dollar Format (Y/N)? '

If your answer is 'Y'es then the digits to the right of the decimal place
are set to two, otherwise you are prompted to set them:

'Number of decimal places: '

If your answer to the dollar format question was 'Y'es then the cells
having numeric values are automatically right justified, otherwise you
will be prompted to set them:

'Justification - (L)eft, (C)enter, (R)ight '

The last prompt concerns the insertion of commas at appropriate intervals:

'Put commas in numbers (Y/N)? '

RESULTS:
All cells in the current block are formated accordingly.















PRESS TO EXIT

***** BLOCK *****

FUNCTION:
Opens a sub-menu of commands related to block operations.

ENTRY:
The Block commands include:

þ Copy Duplicate Block Area at specified coordinates.

þ Delete Clear cells in Block Area.

þ Format Setup format for Block Area cells.

þ Reset Set Block Area cells to original format.

þ Start Start Block Mode.

þ Toggle Toggle Block Mode to show or hide Block Area.


***** BLOCK RESET *****

FUNCTION:
Resets the format of the Block Area to the original options.

RESULTS:
The Block Area is displayed in the original format.


***** BLOCK START *****

FUNCTION:
This command begins the Block Mode. Upon selecting this option the
cursor keys will allow you to create a block.

The block begins from the coordinates from which you started the
block and ends at the current cursor position. The designated
block will normally be highlighted.


ENTRY:
Terminate Block Mode.

Decrease the Block Area by one column. If the current column
position is less than the starting block column then Block
Mode is terminated.

Increase the Block Area by one column.

Decrease the Block Area by one row. If the current row
position is less than the starting block row then Block
Mode is terminated.

Increase the Block Area by one row.

Increase the Block Area to the End Coordinate. If the End
Coordinate's row or column is less than the starting block's
row or column then the Block Mode is terminated.

Decrease the Block Area by 20/38 rows depending on the EGA
Mode. If the resulting row position is less than the
starting block row then Block Mode is terminated.

Increase the Block Area by 20/38 rows depending on the EGA
Mode.

Decrease the Block Area by X columns, where X depends on
Column Widths. If the resulting column position is less
than the starting block column then Block Mode is terminated.

Increase the Block Area by X columns, where X depends on
Column Widths.

RESULTS:
All cells in the current block are colored accordingly.


***** BLOCK TOGGLE *****

FUNCTION:
This command turns the Block Mode off.

RESULTS:
All cells in the current block are uncolored accordingly.



***** CELL CLEAR *****

FUNCTION:
This command clears the cell at the cursor.

RESULTS:
A blank cell is presented at the cursor.

REMARKS:
All data is irretrievably lost and new data must now be entered.


***** COLUMN *****

FUNCTION:
Options related to Column(s) may be selected through this option.

RESULT:
When selected, Column Commands displays a sub-menu with
column related options, which include:

þ Column Delete - Delete current column at bar cursor.

þ Column Insert - Insert a column row at the current bar cursor.

þ Column Width - Change the width of all cells in the current
column.






***** COLUMN DELETE *****

FUNCTION:
This command deletes the current Column at the cursor.

RESULTS:
The current column is deleted at the cursor. Any following columns are
bumped left to the fill the void remaining from the deleted Column.

RESTRICTIONS:
Attemps to interpret formulas using values from the deleted column may be
incorrect and should be checked.


***** CELL CLEAR *****

FUNCTION:
This command clears any entry of the current cell.

RESULTS:
The cell is displayed as empty.

REMARKS:
Any formulas using the cleared cell will be affected.

***** CELL EDIT *****

FUNCTION:
This command edits the current cell.



***** CELL *****

FUNCTION:
Opens a sub-menu of commands related to Cell operations.

ENTRY:
The Cell commands include:

þ Clear Clears the contents of the current Cell.

þ Edit Allows editing of the current Cell.

þ Go To Prompts you for the Cell coordinates where you
want to go.


***** COLUMN INSERT *****

FUNCTION:
This command inserts a new column at the cursor.

RESULTS:
A new column is inserted at the cursor. Any following columns are bumped
right to the next column.

REMARKS:
Formulas are interpreted and updated using the new column coordinates.

RESTRICTIONS:
þ Column Insert will abort if Column 'CV' has an entry in any row.

þ It may be necessary to invoke Recalc to update formula calculations.

***** SPREADSHEET RECALCULATE *****

FUNCTION:
When the Autocalculation is toggled 'OFF' then use this command to
recalculate values for cells using formulas.

RESULTS:
All cells using formulas will be updated to reflect current values and
displayed to the screen.

REMARKS:
Since Pro:CALC evaluates formulas from top to bottom and left to right,
formulas with a lesser coordinate (relatively closer to top-left) which
use values from cells with a greater coordinate represent a problem.

In this case it attempts to calculate a formula using a value from a cell
which itself has not yet been calculated. To correct for this occurence a
second Spreadsheet Recalculate is required.

Additionally, a Spreadsheet Recalculate must be invoked for each level
deep this backward-value-calculating occurs.



***** ROW *****

FUNCTION:
Options related to a row may be selected through this option.


RESULT:
When selected, Row Commands displays a sub-menu with row
related options, which include:

þ Row Delete - Delete current row at bar cursor.

þ Row Insert - Insert a new row at the current bar cursor.



***** COLUMN WIDTH *****

FUNCTION:
This command modifies the current Column's width.

ENTRY:
Pro:CALC prompts you to enter the new width of the current column:

"Set column width:"

RESULTS:
All cells in the current column are modified and redisplayed.

RESTRICTION:
Width must be in the range between 3 to 77, inclusively.

***** SPREADSHEET DUPLICATE *****

FUNCTION:
Spreadsheet Duplicate allows the user to copy a spreadsheet onto the disk.

ENTRY:
You will be prompted to enter the spreadsheet name. the spreadsheet name
may include the drive and path according to DOS convention.

'File to save: '

RESULTS:
If the spreadsheet exists then you will be asked to answer the following
question:
'The file exists. Overwrite it? Y/N'

If you answer 'Y'es then the new spreadsheet will be written on top of
the old file and all that data lost. If the spreadsheet does not exist,
the new spreadsheet will be written to the disk.


***** SPREEDSHEET ZAP *****

FUNCTION:
This command will delete a spreadsheet from the disk.

REMARKS:

You will be asked the following question:

'File to delete: '

If the file you want to delete does not exist, an error message will be
displayed saying "This is not a Pro:CALC Spreadsheet".

If the file you want to delete does exist, you will be asked the question:

'Are you sure you really want to delete this file?'

If you reply 'Y'es the file will be deleted.

RESTRICTIONS:

þ The file is irretrievable once deleted.


***** SPREADSHEET EDIT *****

FUNCTION:
Spreadsheet Edit allows the user to load a spreadsheet into the current
window.

ENTRY:
You will be prompted to enter the spreadsheet name. the spreadsheet name
may include the drive and path according to DOS convention.

'File to load: '

RESULTS:
If the spreadsheet exists then it is loaded to the current window. If the
specified spreadsheet does not exist a blank spreadsheet is loaded into
the current window. The blank spreadsheet is not named and must be saved
in order to create a named spreadsheet.

***** SPREADSHEET *****

FUNCTION:
Commands in this option deal specifically with the Spreadsheet files
themselves.

RESULT:
When selected, Spreadsheet displays a sub-menu with file related
commands, which include:

þ AutoCalc Toggles the autocalculation of formulas on/off.

þ Close Close current spreadsheet and exit.

þ Duplicate Creates a duplicate spreadsheet.

þ Edit Open a previously created spreadsheet.

þ Formula Toggles between displaying formulas and results.

þ Initiate Open a blank spreadsheet.

þ Lines Toggles between 25 and 43 line displays.

þ Next Activate next spreadsheet window.

þ Open Open additional spreadsheets.

þ Print Prints the spreadsheet currently on the screen.

þ Quit Exit Pro:CALC and save the current spreadsheet.

þ Recalculate If AutoCalc is off, this is used to recalculate the
values in cells containing formulas.

þ Save Write the current spreadsheet to disk.

þ Title Rename an existing spreadsheet on the disk.

þ Wipe Clears the existing spreadsheet.

þ Zap Delete a previously created spreadsheet from the disk.








***** SPREADSHEET TITLE *****

FUNCTION:
Spreadsheet Title allows the user to rename a spreadsheet from the
current window.

ENTRY:
You will be prompted to enter the spreadsheet name. the spreadsheet name
may include the drive and path according to DOS convention.

'File to load: '


RESULTS:
If the spreadsheet exists then you will be asked the following question:

'The file exists. Overwrite it? Y/N'

If you answer 'Y'es, the spreadsheet will be overlaid with the new data
and all old data lost. If the spreadsheet does not exist, the new data
will be written onto the disk.

***** SPREADSHEET SAVE *****

FUNCTION:
This command will save the current spreadsheet to a file.

ENTRY:
This command will prompt you to save the document:

"Save the spreadsheet?"

A 'Y' or 'N' is response is required. If Pro:CALC is subject to Pro:SPANS
no further entry is required. In the stand-alone version of Pro:CALC the
user will be prompted for the file name:

"Enter the file name of the spreadsheet"

The file name should conform to DOS nomenclature. If the file name
already exists Pro:CALC will prompt:

"The file exists. Do you want to overwrite it?"

A 'Y' or 'N' response is required.

RESULT:
The current spreadsheet is saved to a file, after which, editing of the
current spreadsheet may continue.

REMARK:

þ The Spreadsheet Save command may be discontinued using the Key.

***** CELL GOTO *****

FUNCTION:
To quickly locate the bar cursor at a particular cell coordinate.

ENTRY:
You will be prompted to enter the cell coordinate:

"Go to cell"

Enter the Column first, followed by the Row, then press to
execute.

RESULT:
The Bar Cursor will locate (goto) the requested cell. When possible the
screen will display the cell in the upper left corner.

REMARKS:

þ Columns must be in the range from 'A' to 'CV'.

þ Rows must be in the range from 1 to 64000.

EXAMPLES:
The Entry must be entered Column first then Row. There must be no spaces
between the Column and Row:

A3 Column 'A', Row 3.

BK13 Column 'BK', Row 13.

***** SPREADSHEET AUTOCALC *****

FUNCTION:
Toggles AutoCalculation on/off.

RESULT:
When AutoCalculation is toggled ON, calculation occurs after each
cell entry and is immediately displayed to the screen.

When AutoCalculation is toggled OFF, calculation only occurs when
you select SPREADSHEET RECALCULATE from the menu or SR.

REMARKS:
þ Improved cursor movement speed may occur when AutoCalculation is
toggled OFF.

þ Because Pro:CALC evaluates formulas from top to bottom and left to
right, formulas with a lesser coordinate (relatively closer to
top-left) which use values from cells with a greater coordinate
represent a problem. In this case it attempts to calculate a formula
using a value from a cell which itself has not yet been calculated. To
correct for this occurence a second Spreadsheet Recalculate is required.

Additionally, a Spreadsheet Recalculate must be invoked for each level
deep this backward-value-calculating occurs.

***** SPREADSHEET LINES *****

FUNCTION:
This command toggles between 25-line (default) and 43-line Display.

RESULTS:
If Spreadsheet Lines is toggled OFF then the screen displays 25 lines,
otherwise it displays 43 lines.

RESTRICTIONS:
Toggling Spreadsheet Lines to the ON mode may have unpredictable
results if your system is not setup for EGA.

SEE ALSO:
You may wish to consult your computer system documentation, specifically
concerning your monitor and display card, to determine if your system is
compatible for EGA display.

***** SPREADSHEET FORMULA *****

FUNCTION:
This command toggles between the display, of the cell's value and its
formula (where appropriate), in the Cell Display Area.

RESULTS:
The formula is displayed to the Cell Display Area and the value of the
current cell is dispalyed in the lower-left corner above the Cell Entry
Area when Forumla is toggled ON.

REMARKS:

þ Cell entry, from the Cell Entry Area, is not affected.

þ Formula display is restricted to the column width.

***** SPREADSHEET PRINT *****

FUNCTION:
This command prints the currently loaded spreadsheet to a printer.

ENTRY:
Pro:CALC will prompt you to answer questions concerning the format in
which the spreadsheet is to be printed.

The first prompt determines whether the printout should be of
80-character width ('N') or 130 character ('Y') width:

"Do you want to print in 132 columns?"

The next prompts asks whether the coordinates should be printed:

"Print the border?"

At this time, the spreadsheet is downloaded to the printer.

RESULTS:
The current spreadsheet, from the first cell (A1) to the page containing
the last non-blank cell, is printed.

REMARKS:
þ Ensure your printer is ON prior to printing.
þ Pro:CALC does not currently permit a sub section of the spreadsheet
to be printed . . . all or nothing.


***** ROW DELETE *****

FUNCTION:
This command deletes the current row at the cursor.

RESULTS:
The current row is deleted at the cursor. Any following rows are bumped
up to the fill the void left by the deleted row.

RESTRICTIONS:
Attempts to interpret formulas using values from the deleted row may be
incorrect and should be checked.


***** REFERENCES *****

FUNCTION:

References files may be selected through this option.

RESULTS:

The following reference materials are available:

þ Glossary A list of hundreds of financial terms and their
definitions.

þ License A copy of Pro:Spans' (Pro:Calc included) License
Agreement.

þ Order A copy of how to order INTAC's line of products.

þ Warranty A copy of Pro:Spans' (Pro:Calc included) Warranty
Agreement.




***** ROW INSERT *****

FUNCTION:
This command inserts a new row at the cursor.

RESULTS:
A new row is inserted at the cursor. Any following rows are bumped down
to the next row.

REMARKS:
Formulas are interpreted and updated using the new row coordinates.

RESTRICTIONS:

þ Row Insert will abort if row 100 has an entry in any column.

þ It may be necessary to invoke Window Recalc to update formula
calculations.

***** PRO:CALC SYSTEM HELP *****

GENERAL:
Press the bar before entering alphabetic text.
Press to Save and Exit.


OVERVIEW:
Pro:CALC is a spreadsheet program. It consists of a 64,000 x 64,000 matrix
of cells. A cell is an area on the spreadsheet at the intersection of any
given row (represented by a numeric expression) and any given column
(represented by an alphabetic character). The combination of the row and
column represent the coordinates.

Example: Coordinate

Where
Column 'A' intersects Row '1' = Coordinate 'A1'

A cell may contain one of three (3) types of entry: text, a value, or a
formula. The current cell type is displayed at the bottom left of the
screen.

Example: Formula Type

A3 Formula
A1+A2

Where A3 is of type Formula and equals A1+A2.

To make an entry into a cell, move the cursor to that cell and enter the
data. Cell type is automatically determined from the data entered.

HELP:
Help may be invoked using the key or from the Menu.

HELP WINDOW MOVEMENT

Up Arrow Key Scroll one line up
Down Arrow Key Scroll one line Down
Page up one window height
Page down one window height
Goto the beginning of Help
Goto the end of Help
Exit Help window

HELP NOMENCLATURE

<> These enclose the name of a single keystroke
() Comments
CAPS Subject headers

HELP GENERAL FORMAT:

This relates the general way help information is ordered (where
relevent).

þ Subject Header
þ Function
þ Result
þ Remarks

MENU:
The Menu is invoked using the key. Use the Arrow keys or the
highlighted characters to move the bar cursor to a Menu option. Press the
key to select the option, or to backup one level until you
exit the menu. Specific Help may be obtained on any option by placing
the bar cursor and pressing the Key.

STANDARD COMMANDS:

System Help is displayed, however, specific help is
displayed from the current menu option.

Activate drop down Menu.

BC Block Copy
BD Block Delete
BF Block Format
BR Block Reset
BS Block Start
BT Block Toggle

CC Cell Clear
CE Cell Edit
CG Cell Go to

CD Column Delete
CI Column Insert
CW Column Width

RG Reference Glossary
RL Reference License
RO Reference Order
RW Reference Warranty

RD Row Delete
RI Row Insert

SA Spreadsheet AutoCalculate
SC Spreadsheet Close
SD Spreadsheet Duplicate
SE Spreadsheet Edit
SF Spreadsheet Formula
SI Spreadsheet Initiate
SL Spreadsheet Lines
SN Spreadsheet Next
SO Spreadsheet Open
SP Spreadsheet Print
SQ Spreadsheet Quit
SR Spreadsheet Recalculate
SS Spreadsheet Save
ST Spreadsheet Title
SW Spreadsheet Wipe
SZ Spreadsheet Zap

Restore original
Move Left one cell
Move Right one cell
Move Up one cell
Move Down one cell
Move to first cell with data or cell A1
Move to last cell with data or cell A1
Move Up one page
Move Down one page
Move Left one page
Move Right one page

STANDARD OPERATORS: (In order of execution)

^ Power (example: 3^4 = 81)
* Multiply (example: 2*5 = 10)
/ Divide (example: 6/3 = 2)
: Sum group of cells (example: B1:B3 = B1+B2+B3)
+ Add (example: 5+4 = 9)
- Subtract (example: 7-3 = 4)

STANDARD MATHEMATICAL FUNCTIONS:

ABS Absolute value
ACOS Arc cosine
ASIN Arc sine
ATAN Arc tangent
COS Cosine
COSH Cosine, hyperbolic
EXP Exponential function
LOG Logarithm
LOG10 Logarithm, base 10
POW10 Raise argument to 10th power (Scientific Notation)
ROUND Round to nearest whole number
SIN Sine
SINH Sine, hyperbolic
SQR Square root
TAN Tangent
TANH Tangent, hyperbolic
TRUNC Return integer portion of number

EXAMPLE:
Complex Formula using Standard Functions & Operators

COS(A1)/TAN(A3)*(3*A2)+ABS(9.2E-2+A7)-(B4:B8)

***** SPREADSHEET INITIATE *****

FUNCTION:
Add a blank spreadsheet.

RESULTS:
A blank spreadsheet is added to the screen. All spreadsheets are
resized equally. The newly added spreadsheet becomes the current
spreadsheet.

***** SPREADSHEET CLOSE *****

FUNCTION:
Close current spreadsheet.

ENTRY
If the spreadsheet has not been saved since the last modification to it
then you will be prompted to:

'Save spreadsheet (Y/N)? '

RESULTS:
The current spreadsheet is closed and the remaining spreadsheets are
equally resized. The current spreadsheet defaults to the next spreadsheet.

***** SPREADSHEET WIPE *****

FUNCTION:
This command will clear all cells of any numbers, text or formulas in
the spreadsheet.

REMARK:
The SPREADSHEET WIPE command may be discontinued using the Key.

RESTRICTIONS:

þ The data is irretrievable once erased.


***** SPREADSHEET NEXT *****

FUNCTION:
Go to next spreadsheet.

RESULTS:
Advance active bar cursor to the next spreadsheet on the screen. The
location of the bar cursor in the former spreadsheet is marked and
reset to the marked location upon reentry.

***** SPREADSHEET OPEN *****

FUNCTION:
Add a pre-existing spreadsheet.

ENTRY:
You will be prompted to enter a drive (not required), path (not
required) and a pre-existing spreadsheet name (required).

RESULTS:
A pre-existing spreadsheet is opened on the screen. All spreadsheets
are resized equally. The newly added spreadsheet becomes the
current spreadsheet.

***** SPREADSHEET QUIT *****

FUNCTION:
This command will Quit Pro:CALC.

ENTRY:
Spreadsheet Quit will prompt you to save the document:

"Save the spreadsheet?"

A 'Y' or 'N' is response is required. If Pro:CALC is subject to
Pro:SPANS no further entry is required. In the stand-alone version of
Pro:CALC the user will be prompted for the file name:

"Enter the file name of the spreadsheet"

The file name should conform to DOS nomenclature. If the file name
already exists Pro:CALC will prompt:

"The file exists. Do you want to overwrite it?"

A 'Y' or 'N' response is required.

RESULT:
If Pro:CALC is subject to Pro:SPANS then the the file name is
maintained internally.

REMARK:

þ The Spreadsheet Quit command may be discontinued using the Key.

þ The Quit option is considered related to the Spreadsheet Commands,
however, it has been displaced for ease of use.

þ If the file already exists and you choose not to overwrite it, then
the spreadsheet will Quit, abandoning any modifications made since
the last save.


  3 Responses to “Category : Financial and Statistics
Archive   : PROSPANS.ZIP
Filename : PROCALC.HLP

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/