SV-Budget
0 0 0 0
0 0 6 256
GR
1 100 100 1.00 1.00
DI7 19 20
STAREA?
1
STBAR?
2
STBLUE?
3
STDAY?
4
STE?
5
STGREEN?
6
STHOUR?
7
STLINE?
8
STMINUTE?
9
STPI?
a
STPIE?
b
STRED?
c
STSCATTER?
d
STSECOND?
e
STSTACKED?
f
STTRANSPARENT?
10
STUNSTACKED?
11
STVAT?
12
STWEEK?
13
DI7 14 1
STAccountant?
2
STBlueCntr?
a
STHeading?
9
STPercentage?
3
STPlain?
1
STPlain0DP?
e
STPlainBlue?
c
STPlainGrn?
d
STPlainPd?
b
STScientific?
4
STTimeAndDate1?
5
STTimeAndDate2?
6
STUKCur?
7
STUSCur?
8
4<"RSystem                     ,  7, 13,       0,ffffff00,%fac"
5<"RSystem                     ,  7, 13,    dd00,ffffff00,-%fac"
6<"RSystem                     ,  7, 13,       0,ffffff00,%fac"
7<"LSystem                     ,  7, 13,       0,ffffff00,%fac"
8<"RCorpus.Medium              , 12, 12,       0,ffffff00,%fac"
9<"RCorpus.Medium              , 12, 12,       0,ffffff00,(%fac)"
10<"RCorpus.Medium              , 12, 12,       0,ffffff00,%fac"
11<"LCorpus.Medium              , 12, 12,       0,ffffff00,%ia"
12<"RSystem                     ,  7, 13,       0,ffffff00,%fac%%"
13<"RSystem                     ,  7, 13,       0,ffffff00,-%fac%%"
14<"RSystem                     ,  7, 13,       0,ffffff00,%fac%%"
15<"RSystem                     ,  7, 13,       0,ffffff00,%ia"
16<"LSystem                     ,  7, 13,       0,ffffff00,%ead"
17<"LSystem                     ,  7, 13,       0,ffffff00,-%ead"
18<"LSystem                     ,  7, 13,       0,ffffff00,%ead"
19<"CSystem                     ,  7, 13,       0,ffffff00,%ia"
20<"CSystem                     ,  7, 13,       0,ffffff00,%24:%mi:%se %dy/%mn/%yr"
21<"CSystem                     ,  7, 13,       0,ffffff00,%24:%mi:%se %dy/%mn/%yr"
22<"CSystem                     ,  7, 13,       0,ffffff00,%24:%mi:%se %dy/%mn/%yr"
23<"CSystem                     ,  7, 13,       0,ffffff00,%ia"
24<"CSystem                     ,  7, 13,       0,ffffff00,%z12:%mi %am %zdy%st %mo %ce%yr"
25<"CSystem                     ,  7, 13,       0,ffffff00,%z12:%mi %am %zdy%st %mo %ce%yr"
26<"CSystem                     ,  7, 13,       0,ffffff00,%z12:%mi %am %zdy%st %mo %ce%yr"
27<"CSystem                     ,  7, 13,       0,ffffff00,%ia"
28<"RCorpus.Medium              , 10, 10,       0,ffffff00,%fgc" 
29<"RCorpus.Medium              , 10, 10,    dd00,ffffff00,%fgc"
30<"RCorpus.Medium              , 10, 10,       0,ffffff00,%fgc"
31<"LCorpus.Medium              , 10, 10,       0,ffffff00,%ia"
32<"RCorpus.Medium              , 10, 10,       0,ffffff00,$%fgc"
33<"RCorpus.Medium              , 10, 10,    dd00,ffffff00,$%fgc"
34<"RCorpus.Medium              , 10, 10,       0,ffffff00,$%fgc"
35<"LCorpus.Medium              , 10, 10,       0,ffffff00,%ia"
36<"RSystem,                     007,013,00000000,FFFFFF00,%fab"
39<"LSystem                     ,  7, 13,  eeee00,77777700,%fab"
40<"RSystem                     ,  7, 13,99440000,ffffff00,%fac"
41<"RSystem                     ,  7, 13,99440000,ffffff00,-%fac"
42<"RSystem                     ,  7, 13,99440000,ffffff00,%fac"
43<"CSystem                     ,  7, 13,99440000,ffffff00,%fab"
44<"RSystem                     ,  7, 13,       0,ffffff00,%fac"
45<"RSystem                     ,  7, 13,    dd00,ffffff00,-%fac"
46<"RSystem                     ,  7, 13,       0,ffffff00,%fac"
48<"RSystem                     ,  7, 13,99440000,ffffff00,%fac"
49<"RSystem                     ,  7, 13,99440000,ffffff00,-%fac"
50<"RSystem                     ,  7, 13,99440000,ffffff00,%fac"
51<"LSystem                     ,  7, 13,99440000,ffffff00,%fab"
52<"RSystem                     ,  7, 13,  cc0000,ffffff00,%fac"
53<"RSystem                     ,  7, 13,  cc0000,ffffff00,-%fac"
54<"RSystem                     ,  7, 13,  cc0000,ffffff00,%fac"
55<"LSystem                     ,  7, 13,  cc0000,ffffff00,-%fab"
56<"RSystem                     ,  7, 13,       0,ffffff00,%faa"
57<"RSystem                     ,  7, 13,       0,ffffff00,-%faa"
58<"RSystem                     ,  7, 13,       0,ffffff00,%faa"
-1<End
NU
118
a49
1
1
1
8
1
8
1
8
1
0
0
0
0
0
65756c42
72746e43
0
0
0
0
0
0
0
50
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2c
1
1
2c
2
3
2c
4
5
2c
6
6
2c
7
7
2c
8
9
2c
a
c
2c
d
d
2c
e
e
2c
f
11
2c
12
15
2c
16
1c
2c
1d
1f
2c
20
29
2c
2a
34
2c
35
47
2c
48
51
2c
52
79
2c
7a
ab
2c
ac
bd
2c
be
c2
2c
c3
ee
2c
ef
f0
2c
NU
9
0
0
80
1
1
cc
2
a
80
MA
1 1
CE10096002
STScreen 1?
1 3
CE10096002
STSchema spreadsheet: an introduction?
1 15
CE10096002
STTap <Page Down>?
1 16
CE10096002
STScreen 2?
1 18
CE100c6002
STa) Like a piece of paper ruled into rows and columns, a spreadsheet?
1 19
CE100c6002
ST   may be used to add up lists of numbers.?
1 20
CE100c6002
STb) With a piece of paper, YOU have to do the arithmetic; with a?
1 21
CE100c6002
ST   spreadsheet, the PROGRAM does the work.?
1 22
CE100c6002
STc) Of course, a spreadsheet will do a great more than simple adding.?
1 23
CE100c6002
ST   As you will discover, Schema will:?
1 24
CE100c6002
ST   - do all sorts of calculations;?
1 25
CE100c6002
ST   - draw bar and pie charts, and a range of line graphs;?
1 26
CE100c6002
ST   - act like a database, with search and sort;?
1 27
CE100c6002
ST   - handle time and dates, as well as numbers;?
1 28
CE100c6002
ST   - let you write macros (programs) to extend its power.?
1 30
CE10096002
STTap <Page Down>?
1 31
CE10096002
STScreen 3?
1 33
CE100c6002
STa) The spreadsheet is ruled into rows and columns. Each row is?
1 34
CE100c6002
ST   labelled with a number, and each column with a letter.?
1 36
CE100c6002
STb) The column and row lines form boxes or CELLS. The grey cell?
1 37
CE100c6002
ST   at the end of this line would be called G37.?
1 39
CEc6002
STc) You are always "in" just ONE cell, called the CURRENT CELL.?
ST"c) You are always \"in\" just ONE cell, called the CURRENT CELL."  ?
1 41
CE100c6002
STd) To move to another cell, you simply point and click (with Select).?
1 42
CE100c6002
ST   Try this now. Put the pointer over the boxed cell?
1 43
CE100c6002
ST   at the end of this line, and tap Select.?
1 44
CE100c6404
-37
1 45
CE10096002
STTap <Page Down>?
1 46
CE10096002
STScreen 4?
1 48
CE100160a2
STIncome?
1 49
CE10016022
STPocket money?
1 50
CE10016022
STPaper round?
1 51
CE10016022
STGifts?
1 52
CE10016022
STOther?
1 53
CE10016062
STTotal?
1 60
CE10096002
STTap <Page Down>?
1 61
CE10096002
STScreen 5?
1 63
CE100160a2
STIncome?
1 64
CE10016022
STPocket money?
1 65
CE10016022
STPaper round?
1 66
CE10016022
STGifts?
1 67
CE10016022
STOther?
1 68
CE10016062
STTotal?
1 70
CE100c4002
STc) Click into cell B65: line 2 of the screen shows the NUMBER 3.5?
1 71
CE100c4002
STd) Click into cell A66: line 2 of the screen shows the WORD "Gifts".?
1 72
CE100c4002
STe) Click into cell B68: line 2 of the screen shows the FORMULA?
1 73
CE100c4002
ST   SUM(B64><B67). This means: "Add up the list from B64 to B67".?
1 74
CE100c4002
ST   Cell B68 CONTAINS a FORMULA, but DISPLAYS its RESULT.?
1 75
CE10096002
STTap <Page Down>?
1 76
CE10096002
STScreen 6?
1 78
CE100160a2
STIncome?
1 79
CE10016022
STPocket money?
1 80
CE10016022
STPaper round?
1 81
CE10016022
STGifts?
1 82
CE10016022
STOther?
1 83
CE10016062
STTotal?
1 85
CE100c4002
STd) A similar FORMULA is needed in C83, to add up the numbers from?
1 86
CE100c4002
ST   C79 to C82.?
1 87
CE100c4002
STe) Click into C83, and key-in:  SUM(C79><C82)    - then tap <Return>?
1 88
CE100c4002
ST   and the correct Total will show.?
1 89
CE100c4002
ST   (If you make a slip, use <Delete>, and try again).?
1 90
CE10096002
STTap <Page Down>?
1 91
CE10096002
STScreen 7?
1 92
CE100c4002
STa) Formulae can be simple or complicated, they can do a variety of?
1 93
CE100c4002
ST   jobs - and they do not need to be near the cells they refer to.?
1 94
CE100c4002
STb) Every cell on this screen which CONTAINS A FORMULA has been made?
1 95
CE100c4002
ST   to DISPLAY THE RESULT in green.?
1 96
CE100c4002
STc) Click into each "green" cell, and read the formula there from the?
1 97
CE100c4002
ST   data entry line. (Note: "*" means multiply, "/" means divide).?
1 99
CE10094002
STFormula cells?
1 100
CEd4000
18
STC100+D100?
1 101
CEd4000
12
STC101*D101?
1 102
CEd4000
-2
STC102-D102?
1 103
CEd4001
5.
STC103/D103?
1 104
CEd4000
12
STC104+D100-10?
1 105
CE10096002
STTap <Page Down>?
1 106
CE10096002
STScreen 8?
1 107
CE100c4002
STa) Again, each cell which contains a formula has been made to?
1 108
CE100c4002
ST   display the result in green.?
1 109
CE100c4002
STb) Your job is to look at each formula by clicking into a green cell,?
1 110
CE100c4002
ST   and then to change the numbers in the cells used by the formula?
1 111
CE100c4002
ST   so that the new result is the same as the blue number alongside.?
1 112
CE10094002
STFormula?
1 113
CE10094002
STcell?
1 114
CEd4000
20
STF114+G114?
1 115
CEd4000
32
STF115*G115?
1 116
CEd4000
5
STF116-G116?
1 117
CEd4001
6.
STF117/G117?
1 118
CEd4000
80
ST100-F118?
1 120
CE10096002
STTap <Page Down>?
1 121
CE10096002
STScreen 9?
1 123
CE100c4002
STa) All the formulae on this screen work on the block of numbers?
1 124
CE100c4002
ST   which starts at A129 and ends at A133 (so is named "A129><A133").?
1 125
CE100c4002
STb) Click into each result in column B, and look at the formula there.?
1 127
CE10094002
STBlock of?
1 128
CE10094002
STcells?
1 129
CE100e0000
40
1 130
CE100e0000
70
1 131
CE100e0000
30
1 132
CE100e0000
50
1 133
CE100e0000
10
1 135
CE10096002
STTap <Page Down>?
1 136
CE10096002
STScreen 10?
1 137
CE100c4002
STa) You will now extend the income record to cover a useful 6 weeks.?
1 138
CE100c4002
STb) Click into B149: the data entry line shows:  SUM(B145><B148)?
1 139
CE100c4002
STc) Click into C149: the data entry line shows:  SUM(C145><C148)?
1 140
CE100c4002
STd) You could enter 4 similar formulae in D149, E149, etc - BUT ....?
1 141
CE100c4002
STe) ... there is an easier way. With the pointer over C149, hold down?
1 142
CE100c4002
ST   Select, drag until pointer is over G149, tap <Return> (see note )?
1 143
CE100c4002
STf) Click into D149, E149, ..  see how each formula suits its column.?
1 144
CE100160a2
STIncome?
1 145
CE10016022
STPocket money?
1 146
CE10016022
STPaper round?
1 147
CE10016022
STGifts?
1 148
CE10016022
STOther?
1 149
CE10016062
STTotal?
1 150
CE10096002
STTap <Page Down>?
1 151
CE10096002
STScreen 11?
1 152
CE100c4002
STa) The easy setting-up of the Totals formulae on Screen 9 depended?
1 153
CE100c4002
ST   on MARKING a block of cells.?
1 154
CE100c4002
STb) When a formula is copied into a marked block of cells, Schema?
1 155
CE100c4002
ST   alters the formula so that it suits each new position.?
1 156
CE100c4002
ST   If the copied formula adds up the four cells above it, then it?
1 157
CE100c4002
ST   will be altered to add up the four cells above its new position.?
1 158
CE100c6002
STc) To select a block, you click and drag. Try this:?
1 159
CE100c6002
ST   with the pointer over G158, hold down Select,?
1 160
CE100c6002
ST   and drag until the pointer is over G160.?
1 161
CE100c4002
STd) Notice that line 5 of the screen shows "Block:  G158><G160".?
1 162
CE100c4002
STe) There is always a CURRENT BLOCK, as well as a CURRENT CELL. The?
1 163
CE100c4002
ST   BLOCK is YELLOW, the CURRENT CELL is GREEN (or BLUE if it is?
1 164
CE100c6002
ST   inside the current block).?
1 165
CE10096002
STTap <Page Down>?
1 166
CE10096002
STScreen 12?
1 167
CE100c4002
STa) The income record now covers 6 weeks, but has no sensible figures?
1 168
CE100c4002
ST   for Weeks 3 to 6. Copy the figures below into the record. Begin?
1 169
CE100c4002
ST   by clicking into D175 and keying 2.25 - then tap arrow down: this?
1 170
CE100c4002
ST   does the entry AND moves?
1 171
CE100c4002
ST   you to the next cell. All?
1 172
CE100c4002
ST   arrow keys work this way.?
1 174
CE100160a2
STIncome?
1 175
CE10016022
STPocket money?
1 176
CE10016022
STPaper round?
1 177
CE10016022
STGifts?
1 178
CE10016022
STOther?
1 179
CE10016062
STTotal?
1 180
CE10096002
STTap <Page Down>?
1 181
CE10096002
STScreen 13?
1 182
CE100160a2
STIncome?
1 183
CE10014022
STBrought fwd?
1 184
CE10016022
STPocket money?
1 185
CE10016022
STPaper round?
1 186
CE10016022
STGifts?
1 187
CE10016022
STOther?
1 188
CE10016062
STTotal in?
1 189
CE100160a2
STExpenditure?
1 190
CE10016022
STGoing out?
1 191
CE10016022
STMusic?
1 192
CE10016022
STClothing?
1 193
CE10016022
STOther?
1 194
CE10016062
STTotal out?
1 195
CE100140f2
STBalance?
1 196
CE10096002
STScreen 14?
1 197
CE100160a2
STIncome?
1 198
CE10014022
STBrought fwd?
1 199
CE10016022
STPocket money?
1 200
CE10016022
STPaper round?
1 201
CE10016022
STGifts?
1 202
CE10016022
STOther?
1 203
CE10016062
STTotal in?
1 204
CE100160a2
STExpenditure?
1 205
CE10016022
STGoing out?
1 206
CE10016022
STMusic?
1 207
CE10016022
STClothing?
1 208
CE10016022
STOther?
1 209
CE10016062
STTotal out?
1 210
CE100140f2
STBalance?
1 211
CE10096002
STScreen 15?
1 212
CE100160a2
STIncome?
1 213
CE10014022
STBrought fwd?
1 214
CE10016022
STPocket money?
1 215
CE10016022
STPaper round?
1 216
CE10016022
STGifts?
1 217
CE10016022
STOther?
1 218
CE10016062
STTotal in?
1 219
CE100160a2
STExpenditure?
1 220
CE10016022
STGoing out?
1 221
CE10016022
STMusic?
1 222
CE10016022
STClothing?
1 223
CE10016022
STOther?
1 224
CE10016062
STTotal out?
1 225
CE100140f2
STBalance?
1 226
CE10096002
STScreen 16?
1 227
CE100c6002
STa) Click into B239: data entry line shows the formula SUM(B235><B238)?
1 228
CE100c4002
ST   B235 and B238 are in the same column, so this gives a COLUMN total.?
1 229
CE100c6002
STb) However, the SUM(....) formula works with any BLOCK.?
1 230
CE100c6002
STc) Click into F235: data entry line shows the formula SUM(B235><E235)?
1 231
CE100c4002
ST   B235 and F235 are in the same row, so this gives a ROW total.?
1 232
CE100c6002
STd) Click into F239: here a rectangular BLOCK is totalled.?
1 233
CE100c6002
STe) To see a pie chart drawn from "Month totals", key <Ctrl>+<F10>?
1 234
CE100160a2
STExpenditure?
1 235
CE10016022
STGoing out?
1 236
CE10016022
STMusic?
1 237
CE10016022
STClothing?
1 238
CE10016022
STOther?
1 239
CE10016062
STTotal out?
2 16
CE10096002
STWhat is a spreadsheet??
2 31
CE10096002
STRows, columns, and cells?
2 46
CE10096002
STEntering numbers - and automatic addition?
2 48
CE10016082
STWeek 1?
2 49
CE12001
1.65
ST1.65?
2 50
CE12001
3.5
ST3.5?
2 51
CE10012000
4
2 52
CE12001
1.5
ST1.5?
2 53
CEb6041
10.65
STSUM(B49><B52)?
2 61
CE10096002
STHow is the addition done??
2 63
CE10016082
STWeek 1?
2 64
CE12001
1.65
ST$49,2?
2 65
CE12001
3.5
ST$50,2?
2 66
CE10012000
4
2 67
CE12001
1.5
ST$52,2?
2 68
CEb6041
10.65
ST$53,2?
2 76
CE10096002
STEntering a formula yourself?
2 78
CE10016082
STWeek 1?
2 79
CE10012000
2
2 80
CE12001
3.5
ST$50,2?
2 81
CE10012000
4
2 82
CE12001
1.5
ST$52,2?
2 83
CEb6041
11.
ST$53,2?
2 91
CE10096002
STFormulae for simple arithmetic: some to try?
2 106
CE10096002
STFormulae for simple arithmetic: more to try?
2 112
CE10094404
-37
2 121
CE10096002
STFormulae which work on blocks of cells?
2 127
CE10094002
STFormula?
2 128
CE10094002
STresult?
2 129
CEe4001
5.
STCOUNT(A129><A133)?
2 130
CEe4001
200.
STSUM(A129><A133)?
2 131
CEe4001
70.
STMAX(A129><A133)?
2 132
CEe4001
10.
STMIN(A129><A133)?
2 133
CE14001
40.
STAVERAGE(A129><A133)?
2 136
CE10096002
STEntering formulae without really trying?
2 144
CE10016082
STWeek 1?
2 145
CE10012000
2
2 146
CE12001
3.5
ST$50,2?
2 147
CE10012000
4
2 148
CE12001
1.5
ST$52,2?
2 149
CEb6041
11.
ST$53,2?
2 151
CE10096002
STMarking a block of cells?
2 166
CE10096002
STThe record of income continued?
2 174
CE10016082
STWeek 1?
2 175
CE10012000
2
2 176
CE12001
3.5
ST$50,2?
2 177
CE10012000
4
2 178
CE12001
1.5
ST$52,2?
2 179
CEb6041
11.
ST$53,2?
2 181
CE10096002
STHandling expenditure (spending) as well as income?
2 182
CE10016082
STWeek 1?
2 183
CE10014000
0
2 184
CE10012000
2
2 185
CE12001
3.5
ST$50,2?
2 186
CE10012000
4
2 187
CE12001
1.5
ST$52,2?
2 188
CEb6041
11.
STSUM(B183><B187)?
2 189
CE10016484
-37
2 190
CE12001
1.8
ST1.8?
2 191
CE12001
2.4
ST2.4?
2 192
CE12001
6.8
ST6.8?
2 193
CE10012000
0
2 194
CEb6041
11.
ST$53,2?
2 195
CEb40c1
0.
STB188-B194?
2 196
CE10096002
STMore on handling expenditure as well as income?
2 197
CE10016082
STWeek 1?
2 198
CE10014000
0
2 199
CE10012000
2
2 200
CE12001
3.5
ST$50,2?
2 201
CE10012000
4
2 202
CE12001
1.5
ST$52,2?
2 203
CEb6041
11.
ST$188,2?
2 204
CE10016484
-37
2 205
CE12001
1.2
ST1.2?
2 206
CE12001
2.4
ST$191,2?
2 207
CE12001
6.8
ST$192,2?
2 208
CE10012000
0
2 209
CEb6041
10.4
ST$53,2?
2 210
CEb40c1
0.6
ST$195,2?
2 211
CE10096002
STDrawing charts from the figures?
2 212
CE10016082
STWeek 1?
2 213
CE10014000
0
2 214
CE10012000
2
2 215
CE12001
3.5
ST$50,2?
2 216
CE10012000
4
2 217
CE12001
1.5
ST$52,2?
2 218
CEb6041
11.
ST$188,2?
2 219
CE10016484
-37
2 220
CE12001
1.2
ST$205,2?
2 221
CE12001
2.4
ST$191,2?
2 222
CE12001
6.8
ST$192,2?
2 223
CE10012000
0
2 224
CEb6041
10.4
ST$53,2?
2 225
CEb40c1
0.6
ST$195,2?
2 226
CE10096002
STRow Totals (Sideways Totals) - and a pie chart?
2 234
CE10016484
-37
2 235
CE12001
1.2
ST$205,2?
2 236
CE12001
2.4
ST$191,2?
2 237
CE12001
6.8
ST$192,2?
2 238
CE10012000
0
2 239
CEb6041
10.4
ST$53,2?
3 49
CE100c4002
ST   ?
3 78
CE10016082
STWeek 2?
3 79
CE10012000
2
3 80
CE12001
3.5
ST$50,2?
3 81
CE12001
1.45
ST1.45?
3 82
CE12001
3.2
ST3.2?
3 83
CE100b2444
-37
3 84
CE100c4404
-37
3 99
CE10094002
STCells used by formulae?
3 100
CE100e0050
5
3 101
CE100e0010
4
3 102
CE100e0010
12
3 103
CE100e0010
20
3 104
CE100e0090
9
3 112
CE10094002
STResult?
3 113
CE10094002
STto get?
3 114
CE100c4000
14
3 115
CE100c4000
20
3 116
CE100c4000
10
3 117
CE100c4000
4
3 118
CE100c4000
10
3 127
CE10094002
STDescription?
3 128
CE10094002
STof result?
3 129
CE10014002
ST Count of block?
3 130
CE10014002
ST Sum of block?
3 131
CE10014002
ST Maximum in block?
3 132
CE10014002
ST Minimum in block?
3 133
CE10014002
ST Average of block?
3 144
CE10016082
STWeek 2?
3 145
CE10012000
2
3 146
CE12001
3.5
ST$50,2?
3 147
CE12001
1.45
ST$81,3?
3 148
CE12001
3.2
ST$82,3?
3 149
CEb2041
10.15
ST$53,2?
3 150
CE100c4002
ST    Note: if asked to confirm, click OK to fill.?
3 174
CE10016082
STWeek 2?
3 175
CE10012000
2
3 176
CE12001
3.5
ST$50,2?
3 177
CE12001
1.45
ST$81,3?
3 178
CE12001
3.2
ST$82,3?
3 179
CEb6041
10.15
ST$53,2?
3 182
CE10016082
STWeek 2?
3 183
CE14001
0.
STB195?
3 184
CE10012000
2
3 185
CE12001
3.5
ST$50,2?
3 186
CE12001
1.45
ST$81,3?
3 187
CE12001
3.2
ST$82,3?
3 188
CEb6041
10.15
ST$188,2?
3 189
CE10016484
-37
3 190
CE12001
7.4
ST7.4?
3 191
CE10012000
0
3 192
CE10012000
0
3 193
CE12001
1.4
ST1.4?
3 194
CEb6041
8.8
ST$53,2?
3 195
CEb40c1
1.35
ST$195,2?
3 197
CE10016082
STWeek 2?
3 198
CE14001
0.6
ST$183,3?
3 199
CE10012000
2
3 200
CE12001
3.5
ST$50,2?
3 201
CE12001
1.45
ST$81,3?
3 202
CE12001
3.2
ST$82,3?
3 203
CEb6041
10.75
ST$188,2?
3 204
CE10016484
-37
3 205
CE12001
7.4
ST$190,3?
3 206
CE10012000
0
3 207
CE10012000
0
3 208
CE12001
1.4
ST$193,3?
3 209
CEb6041
8.8
ST$53,2?
3 210
CEb40c1
1.95
ST$195,2?
3 212
CE10016082
STWeek 2?
3 213
CE14001
0.6
ST$183,3?
3 214
CE10012000
2
3 215
CE12001
3.5
ST$50,2?
3 216
CE10012000
5
3 217
CE12001
3.2
ST$82,3?
3 218
CEb6041
14.3
ST$188,2?
3 219
CE10016484
-37
3 220
CE12001
7.4
ST$190,3?
3 221
CE10012000
0
3 222
CE10012000
0
3 223
CE12001
1.4
ST$193,3?
3 224
CEb6041
8.8
ST$53,2?
3 225
CEb40c1
5.5
ST$195,2?
3 234
CE10016484
-37
3 235
CE12001
7.4
ST$190,3?
3 236
CE10012000
0
3 237
CE10012000
0
3 238
CE12001
1.4
ST$193,3?
3 239
CEb6041
8.8
ST$53,2?
4 6
CE100a6002
STThis file introduces you to the Schema spreadsheet.?
4 7
CE100a6002
STYou work through a series of numbered screens.?
4 8
CE100a6002
STAfter each one, tap the <Page Down> key for the next.?
4 9
CE100a4404
-37
4 10
CE100a6002
STIf you get lost,?
4 11
CE100a6002
STreturn here by tapping the <Home> key, and?
4 12
CE100a6002
STthen tap <Page Down> until you find the screen you need.?
4 48
CE100c6002
STa) Move into cell B49 - ie click over?
4 49
CE100c6002
ST   the cell pointed to by the arrows.?
4 50
CE100c6002
STb) Look at the top-left of the screen:?
4 51
CE100c6002
ST   line 2 shows the cell's value (1.65),?
4 52
CE100c6002
ST   and line 4 reads "Cell:  B49"?
4 53
CE100c2002
ST   ( = cell not locked, you can change;?
4 54
CE100c2002
ST    a  would mean cell locked).?
4 55
CE100c6002
STc) Key-in the value 2, tap <Return> -?
4 56
CE100c6002
ST   no need to <Delete> the old value.?
4 57
CE100c6002
STd) Notice 1.65 is replaced by 2.00?
4 58
CE100c6002
ST   and Total goes up by 35p to 11.00?
4 59
CE100c6002
STe) Try changing some other values - and?
4 60
CE100c6002
ST   check that "Total" is always right.?
4 63
CE100c4002
STa) If you look at the screen, it seems?
4 64
CE100c4002
ST   that CELLS contain WORDS or NUMBERS.?
4 65
CE100c4002
STb) But a cell may also contain a FORMULA?
4 66
CE100c4002
ST   - this is a rule for working-out what?
4 67
CE100c4002
ST   number to display.?
4 100
CE100e0040
13
4 101
CE100e0000
3
4 102
CE100e0000
14
4 103
CE100e0000
4
4 104
CE100e4484
-37
4 112
CE10096404
-37
4 144
CE10014082
STWeek 3?
4 145
CE10010000
2
4 146
CE10001
3.5
ST$50,2?
4 147
CE10010000
0
4 148
CE10001
1.6
ST1.6?
4 149
CE100b0444
-37
4 170
CEc4051
2.25
ST2.25?
4 171
CEc4011
3.5
ST$50,2?
4 172
CE100c4010
0
4 173
CEc4091
0.98
ST.98?
4 174
CE10014082
STWeek 3?
4 179
CEb4041
0.
ST$53,2?
4 182
CE10014082
STWeek 3?
4 183
CE14001
1.35
ST$183,3?
4 184
CE10001
2.25
ST$170,4?
4 185
CE10001
3.5
ST$50,2?
4 186
CE10010000
0
4 187
CE10001
0.98
ST$173,4?
4 188
CEb4041
8.08
ST$188,2?
4 189
CE10014484
-37
4 190
CE10010000
2
4 191
CE10001
4.7
ST4.7?
4 192
CE10001
10.6
ST10.6?
4 193
CE10010000
0
4 194
CEb4041
17.3
ST$53,2?
4 195
CEb40c1
-9.22
ST$195,2?
4 197
CE10014082
STWeek 3?
4 198
CE14001
1.95
ST$183,3?
4 199
CE10001
2.25
ST$170,4?
4 200
CE10001
3.5
ST$50,2?
4 201
CE10010000
0
4 202
CE10001
0.98
ST$173,4?
4 203
CEb4041
8.68
ST$188,2?
4 204
CE10014484
-37
4 205
CE10010000
2
4 206
CE10001
4.7
ST$191,4?
4 207
CE10001
10.6
ST$192,4?
4 208
CE10010000
0
4 209
CEb4041
17.3
ST$53,2?
4 210
CEb40c1
-8.62
ST$195,2?
4 212
CE10014082
STWeek 3?
4 213
CE14001
5.5
ST$183,3?
4 214
CE10001
2.25
ST$170,4?
4 215
CE10001
3.5
ST$50,2?
4 216
CE10010000
0
4 217
CE10001
0.98
ST$173,4?
4 218
CEb4041
12.23
ST$188,2?
4 219
CE10014484
-37
4 220
CE10010000
4
4 221
CE10001
4.7
ST$191,4?
4 222
CE10001
10.6
ST$192,4?
4 223
CE10010000
0
4 224
CEb4041
19.3
ST$53,2?
4 225
CEb40c1
-7.07
ST$195,2?
4 234
CE10014484
-37
4 235
CE10010000
2
4 236
CE10001
4.7
ST$191,4?
4 237
CE10001
10.6
ST$192,4?
4 238
CE10010000
0
4 239
CEb4041
17.3
ST$53,2?
5 78
CE100c4002
STa) Line 2 of the screen is best?
5 79
CE100c4002
ST   called the data entry line.?
5 80
CE100c4002
STb) There is now a column for a?
5 81
CE100c4002
ST  second week - but no Total.?
5 82
CE100c4002
STc) Click into B83 and data entry?
5 83
CE100c4002
ST   line shows: SUM(B79><B82)?
5 100
CE10014464
-37
5 101
CE10014424
-37
5 102
CE10014424
-37
5 103
CE10014424
-37
5 104
CE100144a4
-37
5 112
CE10094002
STNumbers used by formulae:?
5 113
CE10094002
STchange these to get new result?
5 139
CE100c4404
-37
5 140
CE100c4404
-37
5 144
CE10014082
STWeek 4?
5 145
CE10001
2.5
ST2.5?
5 146
CE10001
3.5
ST$50,2?
5 147
CE10001
1.5
ST$52,2?
5 148
CE10010000
0
5 149
CE100b0444
-37
5 170
CEc4041
2.25
ST$170,4?
5 171
CEc4001
3.5
ST$50,2?
5 172
CEc4001
2.4
ST2.40?
5 173
CE100c4080
0
5 174
CE10014082
STWeek 4?
5 179
CEb4041
0.
ST$53,2?
5 182
CE10014082
STWeek 4?
5 183
CE14001
-9.22
ST$183,3?
5 184
CE10001
2.25
ST$170,4?
5 185
CE10001
3.5
ST$50,2?
5 186
CE10001
2.4
ST$191,2?
5 187
CE10010000
0
5 188
CEb4041
-1.07
ST$188,2?
5 189
CE10014484
-37
5 190
CE10001
1.2
ST$205,2?
5 191
CE10010000
0
5 192
CE10010000
0
5 193
CE10010000
0
5 194
CEb4041
1.2
ST$53,2?
5 195
CEb40e1
-2.27
ST$195,2?
5 197
CE10014082
STWeek 4?
5 198
CE14001
-8.62
ST$183,3?
5 199
CE10001
2.25
ST$170,4?
5 200
CE10001
3.5
ST$50,2?
5 201
CE10001
2.4
ST$191,2?
5 202
CE10010000
0
5 203
CEb4041
-0.47
ST$188,2?
5 204
CE10014484
-37
5 205
CE10001
1.2
ST$205,2?
5 206
CE10010000
0
5 207
CE10010000
0
5 208
CE10010000
0
5 209
CEb4041
1.2
ST$53,2?
5 210
CEb40e1
-1.67
ST$195,2?
5 212
CE10014082
STWeek 4?
5 213
CE14001
-7.07
ST$183,3?
5 214
CE10001
2.25
ST$170,4?
5 215
CE10001
3.5
ST$50,2?
5 216
CE10001
2.4
ST$191,2?
5 217
CE10010000
7
5 218
CEb4041
8.08
ST$188,2?
5 219
CE10014484
-37
5 220
CE10001
1.2
ST$205,2?
5 221
CE10010000
0
5 222
CE10010000
0
5 223
CE10010000
0
5 224
CEb4041
1.2
ST$53,2?
5 225
CEb40e1
6.88
ST$195,2?
5 234
CE10014484
-37
5 235
CE10001
1.2
ST$205,2?
5 236
CE10010000
0
5 237
CE10010000
0
5 238
CE10001
3.2
ST$82,3?
5 239
CEb4041
4.4
ST$53,2?
6 100
CE100c4002
STd) Click into these?
6 101
CE100c4002
ST   boxed cells, enter?
6 102
CE100c4002
ST   new numbers, and tap?
6 103
CE100c4002
ST   <Return>. Study the?
6 104
CE100c4002
ST   changes in column A.?
6 114
CE100e0000
15
6 115
CE100e0000
4
6 116
CE100e0000
16
6 117
CE100e0000
12
6 118
CE100e0000
20
6 127
CE100c4002
STc) Try these new values,?
6 128
CE100c4002
ST   and study results in?
6 129
CE100c4002
ST   column B each time:?
6 130
CE100c4002
ST   - change A133 to 110?
6 131
CE100c4002
ST   - change A131 to 60?
6 132
CE100c4002
ST   - change every cell?
6 133
CE100c4002
ST     from A129 to A133?
6 134
CE100c4002
ST     to the value 10?
6 144
CE10014082
STWeek 5?
6 145
CE10001
2.5
ST$145,5?
6 146
CE10001
3.5
ST$50,2?
6 147
CE10001
1.2
ST$205,2?
6 148
CE10001
0.5
ST.5?
6 149
CE100b0444
-37
6 170
CEc4041
2.25
ST$170,4?
6 171
CEc4001
3.8
ST3.8?
6 172
CEc4001
1.85
ST1.85?
6 173
CEc4081
2.21
ST2.21?
6 174
CE10014082
STWeek 5?
6 179
CEb4041
0.
ST$53,2?
6 183
CE100c4002
ST a) Now expenditure?
6 184
CE100c4002
ST    (spending) is shown?
6 185
CE100c4002
ST    for each week.?
6 186
CE100c4002
ST b) Row 195 works out?
6 187
CE100c4002
ST    the difference?
6 188
CE100c4002
ST    between "Total in"?
6 189
CE100c4002
ST    and "Total out",?
6 190
CE100c4002
ST    which is what is?
6 191
CE100c4002
ST    left each week.?
6 192
CE100c4002
ST c) Row 183 starts each?
6 193
CE100c4002
ST    week with balance?
6 194
CE100c4002
ST    from previous week.?
6 198
CE100c4002
ST a) Click into cell B209?
6 199
CE100c4002
ST    to E209, check each?
6 200
CE100c4002
ST    formula adds up a?
6 201
CE100c4002
ST    week's spending.?
6 202
CE100c4002
ST b) Click into cell B210?
6 203
CE100c4002
ST    to E210, check each?
6 204
CE100c4002
ST    finds "Total in"?
6 205
CE100c4002
ST    less "Total out"?
6 206
CE100c4002
ST    for its column.?
6 207
CE100c4002
ST c) Check that cell C198?
6 208
CE100c4002
ST    copies the balance?
6 209
CE100c4002
ST    from B210, and so on.?
6 211
CE100c4002
STa) Schema can draw a?
6 212
CE100c4002
ST   variety of charts?
6 213
CE100c4002
ST   directly from numbers?
6 214
CE100c4002
ST   in cells.?
6 215
CE100c4002
STb) This spreadsheet has?
6 216
CE100c4002
ST   been programmed to?
6 217
CE100c4002
ST   draw a bar chart of?
6 218
CE100c4002
ST   Totals and Balances.?
6 219
CE100c4002
STc) To see the chart,?
6 220
CE100c4002
ST   key <Ctrl>+<F9>?
6 221
CE100c4002
STd) Try changing some?
6 222
CE100c4002
ST   numbers and redoing?
6 223
CE100c4002
ST   the chart. Compare?
6 224
CE100c4002
ST   numbers with bars.?
6 234
CE10094002
STMonth Totals?
6 235
CEb40d1
11.8
STSUM(B235><E235)?
6 236
CEb40d1
7.1
ST$235,6?
6 237
CEb72d1
17.4
ST$235,6?
6 238
CEb72d1
4.6
ST$235,6?
6 239
CEb72d1
40.9
STSUM(B235><E238)?
7 37
CE10096002
ST?
7 43
CE100164f4
-37
7 114
CE100e0000
5
7 115
CE100e0000
8
7 116
CE100e0000
11
7 117
CE100e0000
2
7 118
CE100e0404
-37
7 144
CE10014082
STWeek 6?
7 145
CE10001
2.5
ST$145,5?
7 146
CE10001
3.5
ST$50,2?
7 147
CE10010000
0
7 148
CE10001
0.8
ST.8?
7 149
CE100b0444
-37
7 158
CE10012474
-37
7 159
CE10012434
-37
7 160
CE100124b4
-37
7 170
CEc4061
2.25
ST$170,4?
7 171
CEc4021
3.8
ST$171,6?
7 172
CE100c4020
1
7 173
CE100c40a0
3
7 174
CE10014082
STWeek 6?
7 179
CEb4041
0.
ST$53,2?
7 195
CE10096002
STTap <Page Down>?
7 210
CE10096002
STTap <Page Down>?
7 225
CE10096002
STTap <Page Down>?
7 235
CE100144e4
-37
7 236
CE100144e4
-37
7 237
CE100144e4
-37
7 238
CE100144e4
-37
7 239
CE100144e4
-37
8 144
CE100c4002
ST      ?
8 145
CE100c4002
ST      ?
8 146
CE100c4002
ST      ?
8 147
CE100c4002
ST      ?
8 148
CE100c4002
ST      ?
8 149
CE100c4002
ST      ?
8 240
CE10096002
STEnd?
30001 30001
CE10012000
4
30002 30001
CE10012000
1
30003 30001
CE12000
-16777216
ST0xff000000?
30004 30001
CE12001
86400.
ST86400?
30005 30001
CE12001
2.171828183
ST2.171828183?
30006 30001
CE12000
16711680
ST0x00ff0000?
30007 30001
CE10012000
3600
30008 30001
CE10012000
3
30009 30001
CE10012000
60
30010 30001
CE12001
3.14159265
ST3.14159265?
30011 30001
CE10012000
6
30012 30001
CE12000
65280
ST0x0000ff00?
30013 30001
CE10012000
5
30014 30001
CE10012000
1
30015 30001
CE10012000
1
30016 30001
CE12000
-1
ST-1?
30017 30001
CE10012000
0
30018 30001
CE12001
0.15
ST0.15?
30019 30001
CE12001
604800.
ST604800?
0  0


