Page Comparison

.key { border-right: #000000 1px solid; padding-right: 1px; border-top: #000000 1px solid; padding-left: 1px; font-size: 12px; font-weight: normal; border-left: #000000 1px solid; border-bottom: #000000 1px solid; }

The next worked example shows how to use the Cambridge Z88 to perform numerical calculations. It shows how you would analyse your monthly expenses, and discover what proportion of your income you were spending on each.

You will learn how to:

• Enter numbers and expressions into a table
• Copy expressions to save typing
• Perform calculations
• Alter the format of the numbers

...

TABImage Added Image Added

TABImage Added

TABImage Added

		to move up a line
		to move down a line
Highlight
lightgrey	lightgrey
class	key
SHIFT
Highlight
lightgrey	lightgrey
class	key
	to move to the previous slot to the left
Highlight
lightgrey	lightgrey
class	key
	to move to the next slot to the right
	lightgrey
class	key
Highlight
lightgrey		to move to the left-most slot

...

The slot B2 will be highlighted on the screen to show that you are editing an expression slot, and the cursor will move to the centre of the top line of the screen so that you can enter an expression. Type the expression

500/6

and press the  HighlightlightgreylightgreyclasskeyENTERkey to Image Added key to enter it into slot B2. The number 83.33 will be displayed right-aligned in slot B2.

...

Move to slot C2 and press X to enter an expression. Then type

B2

and press  HighlightlightgreylightgreyclasskeyENTERImage Added. The value 83.33 will appear in slot C2. Likewise enter the expression B2 into slots D2 and E2.

Effectively you have specified that you always want slots C2 to E2 to contain the same value as slot B2. So, for example, suppose you were granted a rates reduction to £400 per half-year. Move the cursor back to slot B2 and type X to display the slot's previous contents, 500/6. Delete them, by typing

...

and then type the new value:

400/6  HighlightlightgreylightgreyclasskeyENTER Image Added

Not only will the value in B2 change to 66.67, but slots C2 to E2 will also change, since they refer to this value.

...

Next you are going to enter the figure 200 for the four months' mortgage payments. Type 200 into slot B3. If you forgot to type X when entering the figure, the number will appear left-aligned just as you entered it. In this case, move the cursor back to the slot and press X and then  HighlightlightgreylightgreyclasskeyENTERafterwardsImage Added afterwards.

You do not need to type the same value in slots C3 to E3; the Replicate command will do it automatically.

Select the Replicate command from the BLOCKS menu, and press  HighlightlightgreylightgreyclasskeyENTERto Image Added to execute it. Answer the prompts as follows, pressing Image Modified to move to the next line after entering B3:

...

This says that you are going to replicate the value in slot B3 to the range of slots C3 to E3. Press  HighlightlightgreylightgreyclasskeyENTERto Image Added to give the command, and the figure 200.00 should appear across the entire row so that the table appears as shown:

...

Note that until you press the  HighlightlightgreylightgreyclasskeyENTERkey you Image Added key you can alter the values you have typed for the ranges, moving between the two prompts with and .

...

You are now going to produce monthly totals for the expenses. Enter the label TOTAL into slot A7, and press  HighlightlightgreylightgreyclasskeyTABto Image Added to move the cursor to slot B7.

Now press X, and enter the following expression:

sum(B2 B6)

Press the  HighlightlightgreylightgreyclasskeyENTERkeyImage Added key, and PipeDream will perform the calculation and instantly display the sum of the figures in the range of slots B2 to B6; ie all the expenses for January.

...

Range to copy from

B7

Range to copy to

C7 E7

Press  HighlightlightgreylightgreyclasskeyENTERand Image Added and totals will appear for each column. The Replicate command has automatically altered the range B2B6 to give the appropriate totals in columns C to E.

...

Instead of typing the references B7 and E7, you can 'point to' each slot by moving the highlighted slot with the keys  HighlightlightgreylightgreyclasskeyTABand  HighlightlightgreylightgreyclasskeySHIFT HighlightlightgreylightgreyclasskeyTABImage Added and Image Added Image Added,   and , and then give the Insert Reference command, K, to enter the corresponding references, B7 and then E7, into the editing line.

...

sum(B2 E2)/$F$7 * 100

Press  HighlightlightgreylightgreyclasskeyENTERto Image Added to enter the expression.

This expression is built up as follows:

...

Number of decimal places

0 

Floating format

No

Press  HighlightlightgreylightgreyclasskeyENTERand Image Added and the numbers will be displayed with no decimal places.

...