TK-Calc Reference

Section I ~ TK-CALC Commands
Section II ~ TK-CALC Operations

The command section provides a listing and general operation of each of the TK-CALC commands. Options within a particular command are listed with the command in the order that they appear on the prompt line.

The Operations section provides information regarding the operations that can be used during an edit session.

Because the Blank command will remove the data permanently from the spreadsheet, the user must enter a "Y" confirming that the data is to be indeed removed.

one cell to another cell
one cell to a range of cells
a range of cells to an equal size range
a range of cells to a larger range

Each copy operation requires 5 steps:

1. Issue the Copy command: /C
2. Enter the starting address of the source.
3. Enter the stopping address of the source.
4. Enter the starting address of the target.
5. Enter the stopping address of the target.

If you are copying only one cell, then the starting and stopping addresses will be the same.

Example:

Source A1 to A1
Target D1 to D1

Example:

Source A1 to C6 is an error

Example:

Source A1 to A6
Target D1 to (press RETURN and the compute will calculate D6)

Example:

Source A1 to A6
Target D1 to D4

If the target range is in a different direction than the source, then a rectangle block will be created with multiple sources.

Example:

Source A1 to E1
Target A4 to A7

The Copy command copies values, formats and formulas. If the formulas contain relative addresses, then the addresses will be modified automatically to reflect the target area. Absolute addresses will not be changed.

You may cancel the copy command by pressing the RETURN key without entering an address in either of the source entries and the first entry of the target. If you enter an address, and then decide to cancel, delete the address with the delete key and then press RETURN.

Move the pointer to the Row or Column that you want to delete and issue the /D command. Enter a R to delete the row, a C to delete the column. Press a RETURN only to cancel the command.

The data is edited with the aid of the editing keys including the four cursor keys, insert and delete character keys and the regular keyboard text. Characters entered will replace the characters overwritten. Press RETURN when the edited data is to be restored in the cell.

The options available under the format command are:

$	A currency format with a dollar sign immediately preceding the number. Negative values are displayed with parentheses. The number of places to the right of the decimal point is selectable by the user.
Default	Restores format to the default setting, numbers are right-justified and labels are left justified.
Fixed	Displays numbers with a fixed number of places to the right of the decimal point. The number is selectable between 0 and 9. If the cell entry contains more digits to the right than is displayed, the number will be rounded to the specified number of digits.
Integer	Displays all numbers rounded to the nearest whole number.
Left	Displays the cell entry left justified within the cell. This is the default format for labels.
Right	Displays the cell entry right-justified within the cell. This is the default format for numbers.
Title	Allows the cell contents to spill over into the adjacent cells to the right. This format is used with labels where the label is wider than the column width.

Selecting the Column Width option allows you to select one standard column width that will be used with the entire sheet. This is particularly useful to compress the size of the sheet down to fit more columns on a single display or printed page. The column widths will remain at the selected width until either readjusted with the Length command or another Global Column Width command. The Global Default command will return the column widths to their original widths.

The Global Formats command allows you to assign a format setting to all entries in the sheet. You may choose to override all entries or only the entries that were not previously set with the Format command. See the Format command for a listing of the various formats that you can set.

Example:

1) Press TAB
2) Enter in AE12
3) Press RETURN

If you enter a "R", all of the rows from the pointer position on down will be moved one row down and a blank row will be inserted where the pointer is. If you enter a "C", all of the columns from the pointer to the right will be moved to the right and a blank column will be inserted where the pointer is.

Formulas that reference any of the columns or rows that were moved during the insert will be adjusted to reflect the new addresses. This is true whether the formulas use absolute or relative addressing.

Note that TK-CALC will not allow you to insert a column if the 255th column or column IU has been occupied, nor will it allow you insert a row if row 999 is occupied.

Move your pointer to the column that is to be changed. Enter the Length command "/L" followed by the new length. The column will be expanded or contracted as needed to the new size.

Use the Global Column Length command if you want to adjust all columns on the sheet at once.

As in the Copy command you can point to the locations rather than enter their coordinates. Each Move operation requires 4 steps:

1. Issue the Move command: /M
2. Enter the first address of the FROM range.
3. Enter the last address of the FROM range.
4. Enter the first address of the TO range.

The starting and stopping point is called a range. You may enter the range by typing the cell addresses or you may move the pointer on the screen to point to the correct cell. Press "RETURN" and then you will be asked for the stopping address. Once again, you can enter it or point to it.

If you are moving only one cell, then the starting and stopping addresses will be the same.

Example:

FROM: C3 to C3
TO: D1 to D1

Example:

FROM: A1 to A11 moves a column
FROM: D3 to G3 moves a row

Example:

FROM: A1 to D6
(specifies a block of entries from columns a thru D and rows 1 to 6)

You may cancel the Move command by pressing the "RETURN" key without entering an address in either of the FROM entries and the first entry of the TO range. If you enter an address, and then decide to cancel, delete the address with the delete key and then press "RETURN".

See the Print Option under the TK-CALC Menu Options for a detailed listing of the input requirements for this command. Since you can only print this one sheet with this command, you will not have to select the spreadsheet to be printed.

First move the pointer to the cell that you want the repeat character to fill. Enter the repeat character following the "/R" command and the cell will be filled with that character. To create a row of this repeated character, you can copy the first cell accross the row with the Copy command.

To split the screen into two windows, first move your pointer to the row or column where you desire the split to take place. Generally this would be somewhere close to the center of the sheet so that each window will be the same size. Activate the Window command with a "/W" and enter either a "H" for a horizontal split or a "V" for a vertical split.

Once the screen is split, you can jump from the one screen to the other by pressing the ";" (semicolon) key. In order to revert back to the single window screen, enter the window command again, "/W", followed by the letter S for single screen.

Row addressing is a one to three digit number starting with row 1 at the top of the sheet to row 999 at the bottom.

Cell addressing in TK-CALC allows you to identify a single cell location by giving the column and row coordinates. The cell addressed resides on the intersection of the column and row. The column is always listed first, then followed by the row number, such as A1, G45, or CA12.

Cell addressing in formulas may be listed in a number of different ways:

1. By dropping the row number, the row of the formula is assumed, such as A, C, EE, or GA

2. By using the letter r (lower case R) in place of the column letters will make the column of the formula to be assumed, such as r12, r3 or r345.

3. By inserting a $ in front of the column letters or the row numbers, or both, will cause the row or columns to be absolute values that are not changed by copying, moving or shift the cell contents. $A$5 is an example of this type of addressing called Absolute addressing. Cell references without the $ are called Relative addresses and will change if moved to another part in the spreadsheet.

$	Dollar sign + decimal
Default	The standard format
Fixed	Fixed decimal point
Integer	Number rounded to whole value
Left	Data Left-justified
Right	Data Right-justified
Title	Text may extend to right of cell boundary

Formulas may be of any length up to 50 characters. They must obey the rules of numeric values which means that they must begin with one of the following characters:

+ - 0 1 2 3 4 5 6 7 8 9 ( @ .

A formula consists of one or more values separated by operators. The values may be numbers (a constant), cell addresses, and/or functions. The operators are simple mathematical operators and are listed below:

+ Positive (when it is first)
- Negative (when it is first)
+ Addition
- Subtraction
* Multiplication
/ Division
\ Integer Division (no fraction)
# Modulo (remainder of division)

If, for example, you want to enter the formula +B3/D1 , you would first enter the +, then use the cursor keys to move the pointer to cell B3. You will see that the computer fills in the cell addresses as you move around. Once you are on B3, then press the next operator /, to freeze the B3 in the formula and allow you to continue on to the D1. Move the cursor to D1 and press RETURN to end the formula.

It is important for you to remember that the operators are executed in strictly left to right order. You must use the parenthesis to override this order. For example, note how the parenthesis change the results in the following two formulas:

+B2*D1+D2 result: 46

+B2*(D1+D2) result: 100

Formulas that exceed the 50 character limit will have to be split up into one more intermediate calculations.