# Category : Financial and Statistics

Archive : PROSPANS.ZIP

Filename : PROCALC.HLP

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.TXT2CALCDSAV.TXT&5CALCMGO2.TXTÇ8CALCOAUT.TXTÜ;CALCOEGA.TXT@CALCOFRM.TXTBCALCPRT.TXT §DCALCRDEL.TXTVHCALCREF.TXT ëICALCRINS.TXT@LCALCSYS.TXT 2NCALCWADD.TXTbCALCWCLS.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

***** 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:

position is less than the starting block column then Block

Mode is terminated.

position is less than the starting block row then Block

Mode is terminated.

Coordinate's row or column is less than the starting block's

row or column then the Block Mode is terminated.

Mode. If the resulting row position is less than the

starting block row then Block Mode is terminated.

Mode.

Column Widths. If the resulting column position is less

than the starting block column then Block Mode is terminated.

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

***** 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

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

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

Press

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

HELP WINDOW MOVEMENT

Up Arrow Key Scroll one line up

Down Arrow Key Scroll one line Down

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

highlighted characters to move the bar cursor to a Menu option. Press the

exit the menu. Specific Help may be obtained on any option by placing

the bar cursor and pressing the

STANDARD COMMANDS:

displayed from the current menu option.

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

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

þ 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.

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

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

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/