...
 | | to move up a line |
| | to move down a line |
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
| | SHIFT |
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
| | TAB |
| | to move to the previous slot to the left |
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
| | TAB |
| | to move to the next slot to the right |
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
| | TAB |
| | to move to the left-most slot |
...
500/6
and press the
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| ENTER |
key to enter it into slot B2. The number 83.33 will be displayed right-aligned in slot B2.
...
and press
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| ENTER |
. The value 83.33 will appear in slot C2. Likewise enter the expression
B2 into slots D2 and E2.
...
and then type the new value:
400/6
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| ENTER |
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| ENTER |
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| ENTER |
to execute it. Answer the prompts as follows, pressing
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| ENTER |
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| ENTER |
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| TAB |
to move the cursor to slot B7.
...
Press the
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| ENTER |
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| ENTER |
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| TAB |
and
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| SHIFT |
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| TAB |
,
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
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | key | lightgrey |
|---|
|
| ENTER |
to enter the expression.
...
Number of decimal places | 0 |
Floating format | No |
Press
| Highlight |
|---|
| lightgrey |
|---|
| lightgrey |
|---|
| class | keylightgrey |
|---|
|
| ENTER |
and the numbers will be displayed with no decimal places.
...