Acorn User 1/AU_CD1.iso/demos/s_to_z/schema2/Tutorial/Tutorial

Text File | 1994-06-01 | 64KB | 2,731 lines

AASHEET 128 60 SCHEMA2
AB10 234
ADTutorial
BD100
BI2
MB
234 48 0
$$
MA
1 226 0
2 146 0
1 140 0
2 146 0
1 136 0
3 146 0
$$
BG146 48
BL146 48
BE0 1 100 0 0 0 0 0
BK0 0 0 0
BC6 0 0 0 1 1 1 0 0
BH0
CB0 1
CA0 Plain - 7ff System 192 192 0 0 0 0 ffffff00 %a1%0.2f
CB1 1
CA1 Accountant - 7ff Corpus.Medium 192 192 0 0 0 0 ffffff00 %a1%br(,),%0.2f
CB2 1
CA2 Currency - 7ff System 192 192 0 0 0 0 ffffff00 %a1$%0.2f
CB3 1
CA3 Heading - 7ff System 192 192 0 0 0 eeee00 77777700 %a1%0.2f
CB4 1
CA4 Percentage - 7ff System 192 192 1 0 0 0 ffffff00 %0.2f%%
CB5 1
CA5 Scientific - 7ff System 192 192 2 0 0 0 ffffff00 %a0%0.3e
CB6 1
CA6 UKCur - 7ff System 192 192 0 0 0 0 ffffff00 %a1%cn0000dd00£%6.2f
CB7 1
CA7 USCur - 7ff System 192 192 0 0 0 0 ffffff00 %a1%cn0000dd00$%6.2f
CB8 1
CA8 TimeAndDate1 - 7ff System 192 192 2 0 0 0 ffffff00 %24:%mi:%se %dy/%mn/%yr
CB9 1
CA9 TimeAndDate2 - 7ff System 192 192 2 0 0 0 ffffff00 %z12:%mi %am %zdy%st %mo %ce%yr
CB10 1
CA10 BlueCntr - 7ff System 192 192 2 0 0 99440000 ffffff00 %a1%0.2f
CB11 1
CA11 PlainPd - 7ff System 192 192 1 0 0 0 ffffff00 %a1£%cn0000FF00%0.2f
CB12 1
CA12 PlainBlue - 7ff System 192 192 0 0 0 99440000 ffffff00 %a1%0.2f
CB13 1
CA13 PlainGrn - 7ff System 192 192 0 0 0 cc0000 ffffff00 %a1%0.2f
CB14 1
CA14 Plain0DP - 7ff System 192 192 1 0 0 0 ffffff00 %a1%0.0f
CB15 1
CA15 PlainGrn0DP - 7ff System 192 192 0 0 0 cc0000 ffffff00 %a1%0.0f
CB16 1
CA16 - Heading 19 System 192 192 0 0 0 eeee00 77777700 %a1%0.2f
CB17 1
CA17 - Plain 19 System 192 192 0 0 0 0 ffffff00 %a1%0.2f
CB29 1
CA29 - BlueCntr 39 System 192 192 0 0 0 99440000 ffffff00 %a1%0.2f
CB18 1
CA18 - PlainBlue 19 System 192 192 0 0 0 99440000 ffffff00 %a1%0.2f
CB19 1
CA19 - PlainGrn 19 System 192 192 0 0 0 cc0000 ffffff00 %a1%0.2f
CB20 1
CA20 - Heading 39 System 192 192 2 0 0 eeee00 77777700 %a1%0.2f
CB21 1
CA21 - Plain 99 System 192 192 0 0 0 0 bbeeee00 %a1%0.2f
CB22 1
CA22 - Heading 20 System 192 192 0 0 0 eeee00 77777700 %a1%0.2f
CB23 1
CA23 - PlainPd 19 System 192 192 1 0 0 0 ffffff00 %a1£%cn0000FF00%0.2f
CB24 1
CA24 - Plain0DP 19 System 192 192 1 0 0 0 ffffff00 %a1%0.0f
CB25 1
CA25 - PlainGrn0DP 19 System 192 192 0 0 0 cc0000 ffffff00 %a1%0.0f
CB26 1
CA26 - BlueCntr 19 System 192 192 2 0 0 99440000 ffffff00 %a1%0.2f
CB27 1
CA27 - Plain d9 System 192 192 0 0 0 99440000 eeee00 %a1%0.2f
CB28 1
CA28 - Heading 99 System 192 192 0 0 0 eeee00 bbbbbb00 %a1%0.2f
FD1 Screen 1
GA1 1 2000402 1 0
GA2 1 2000444 -37 0
GA3 1 2000444 -37 0
GA4 1 2000444 -37 0
GA5 1 2000444 -37 0
GA6 1 2000444 -37 0
GA7 1 2000444 -37 0
GA8 1 2000444 -37 0
GA9 1 2000444 -37 0
GA10 1 2000444 -37 0
FD2
GA1 2 2000442 2 0
GA2 2 2000444 -37 0
GA3 2 2000444 -37 0
GA4 2 2000444 -37 0
GA6 2 2000444 -37 0
GA7 2 2000444 -37 0
GA8 2 2000444 -37 0
GA9 2 2000444 -37 0
GA10 2 2000444 -37 0
FD3 Schema spreadsheet: an introduction
GA1 3 2000402 3 0
GA2 3 2000444 -37 0
GA3 3 2000444 -37 0
GA4 3 2000444 -37 0
GA5 3 2000444 -37 0
GA6 3 2000444 -37 0
GA7 3 2000444 -37 0
GA8 3 2000444 -37 0
GA9 3 2000444 -37 0
GA10 3 2000444 -37 0
GA1 4 2000444 -37 0
GA2 4 2000444 -37 0
GA3 4 2000444 -37 0
FD4 This file introduces you to the Schema2 spreadsheet.
GA4 4 2000682 4 0
GA5 4 2000444 -37 0
GA6 4 2000444 -37 0
GA7 4 2000444 -37 0
GA8 4 2000444 -37 0
GA9 4 2000444 -37 0
GA10 4 2000444 -37 0
GA1 5 2000444 -37 0
GA2 5 2000444 -37 0
GA3 5 2000444 -37 0
FD5 You work through a series of numbered Screens.
GA4 5 2000682 5 0
GA5 5 2000444 -37 0
GA6 5 2000444 -37 0
GA7 5 2000444 -37 0
GA8 5 2000444 -37 0
GA9 5 2000444 -37 0
GA10 5 2000444 -37 0
FD6 After each one, tap the <Page Down> key, or click beneath the slider
GA1 6 2000742 6 0
GA2 6 2000444 -37 0
GA3 6 2000444 -37 0
GA5 6 2000444 -37 0
GA6 6 2000444 -37 0
GA7 6 2000444 -37 0
GA8 6 2000444 -37 0
GA9 6 2000444 -37 0
GA10 6 2000444 -37 0
FD7  in the scroll bar, for the next screen. DO NOT RESIZE THE WINDOW.
GA1 7 2000742 7 0
GA2 7 2000444 -37 0
GA3 7 2000444 -37 0
GA5 7 2000444 -37 0
GA6 7 2000444 -37 0
GA7 7 2000444 -37 0
GA8 7 2000444 -37 0
GA9 7 2000444 -37 0
GA10 7 2000444 -37 0
GA1 8 2000444 -37 0
GA2 8 2000444 -37 0
GA3 8 2000444 -37 0
GA5 8 2000444 -37 0
GA6 8 2000444 -37 0
GA7 8 2000444 -37 0
GA8 8 2000444 -37 0
GA9 8 2000444 -37 0
GA10 8 2000444 -37 0
GA1 9 2000444 -37 0
GA2 9 2000444 -37 0
GA3 9 2000444 -37 0
FD8 If you get lost, or wish to go straight to a particular
GA4 9 2000682 8 0
GA5 9 2000444 -37 0
GA6 9 2000444 -37 0
GA7 9 2000444 -37 0
GA8 9 2000444 -37 0
GA9 9 2000444 -37 0
GA10 9 2000444 -37 0
GA1 10 2000444 -37 0
GA2 10 2000444 -37 0
GA3 10 2000444 -37 0
FD9 Screen, click the "?" icon in the ribbon of icons
GA4 10 2000682 9 0
GA5 10 2000444 -37 0
GA6 10 2000444 -37 0
GA7 10 2000444 -37 0
GA8 10 2000444 -37 0
GA9 10 2000444 -37 0
GA10 10 2000444 -37 0
GA1 11 2000444 -37 0
GA2 11 2000444 -37 0
GA3 11 2000444 -37 0
FD10    in the grey region above this ruled area
GA4 11 2000682 10 0
GA5 11 2000444 -37 0
GA6 11 2000444 -37 0
GA7 11 2000444 -37 0
GA8 11 2000444 -37 0
GA9 11 2000444 -37 0
GA10 11 2000444 -37 0
GA1 12 2000444 -37 0
GA2 12 2000444 -37 0
GA3 12 2000444 -37 0
FD11      and enter the required Screen number.
GA4 12 2000682 11 0
GA5 12 2000444 -37 0
GA6 12 2000444 -37 0
GA7 12 2000444 -37 0
GA8 12 2000444 -37 0
GA9 12 2000444 -37 0
GA10 12 2000444 -37 0
FD12 Author: Richard Warrington
GA1 13 2000402 12 0
GA2 13 2000444 -37 0
GA3 13 2000444 -37 0
GA4 13 2000444 -37 0
GA5 13 2000444 -37 0
GA6 13 2000444 -37 0
GA7 13 2000444 -37 0
GA8 13 2000444 -37 0
GA9 13 2000444 -37 0
GA10 13 2000444 -37 0
FD13 Screen 2
GA1 14 2000402 13 0
FD14 What is a spreadsheet?
GA2 14 2000402 14 0
GA3 14 2000444 -37 0
GA4 14 2000444 -37 0
GA5 14 2000444 -37 0
GA6 14 2000444 -37 0
GA7 14 2000444 -37 0
GA8 14 2000444 -37 0
GA9 14 2000444 -37 0
GA10 14 2000444 -37 0
GA1 15 2000444 -37 0
GA2 15 2000444 -37 0
GA3 15 2000444 -37 0
GA4 15 2000444 -37 0
GA5 15 2000444 -37 0
GA6 15 2000444 -37 0
GA7 15 2000444 -37 0
GA8 15 2000444 -37 0
GA9 15 2000444 -37 0
GA10 15 2000444 -37 0
FD15 a) Like a piece of paper ruled into rows and columns,
GA1 16 2000482 15 0
GA2 16 2000444 -37 0
GA3 16 2000444 -37 0
GA4 16 2000444 -37 0
GA5 16 2000444 -37 0
GA6 16 2000444 -37 0
GA7 16 2000444 -37 0
GA8 16 2000444 -37 0
GA9 16 2000444 -37 0
GA10 16 2000444 -37 0
FD16    a spreadsheet may be used to add up lists of numbers.
GA1 17 2000482 16 0
GA2 17 2000444 -37 0
GA3 17 2000444 -37 0
GA4 17 2000444 -37 0
GA5 17 2000444 -37 0
GA6 17 2000444 -37 0
GA7 17 2000444 -37 0
GA8 17 2000444 -37 0
GA9 17 2000444 -37 0
GA10 17 2000444 -37 0
FD17 b) With a piece of paper, YOU have to do the arithmetic;
GA1 18 2000482 17 0
GA2 18 2000444 -37 0
GA3 18 2000444 -37 0
GA4 18 2000444 -37 0
GA5 18 2000444 -37 0
GA6 18 2000444 -37 0
GA7 18 2000444 -37 0
GA8 18 2000444 -37 0
GA9 18 2000444 -37 0
GA10 18 2000444 -37 0
FD18    with a spreadsheet, the PROGRAM does the work.
GA1 19 2000482 18 0
GA2 19 2000444 -37 0
GA3 19 2000444 -37 0
GA4 19 2000444 -37 0
GA5 19 2000444 -37 0
GA6 19 2000444 -37 0
GA7 19 2000444 -37 0
GA8 19 2000444 -37 0
GA9 19 2000444 -37 0
GA10 19 2000444 -37 0
FD19 c) Of course, a spreadsheet will do a great more than simple adding.
GA1 20 2000482 19 0
GA2 20 2000444 -37 0
GA3 20 2000444 -37 0
GA4 20 2000444 -37 0
GA5 20 2000444 -37 0
GA6 20 2000444 -37 0
GA7 20 2000444 -37 0
GA8 20 2000444 -37 0
GA9 20 2000444 -37 0
GA10 20 2000444 -37 0
FD20    As you will discover, Schema2 will:
GA1 21 2000482 20 0
GA2 21 2000444 -37 0
GA3 21 2000444 -37 0
GA4 21 2000444 -37 0
GA5 21 2000444 -37 0
GA6 21 2000444 -37 0
GA7 21 2000444 -37 0
GA8 21 2000444 -37 0
GA9 21 2000444 -37 0
GA10 21 2000444 -37 0
FD21    - do all sorts of calculations;
GA1 22 2000482 21 0
GA2 22 2000444 -37 0
GA3 22 2000444 -37 0
GA4 22 2000444 -37 0
GA5 22 2000444 -37 0
GA6 22 2000444 -37 0
GA7 22 2000444 -37 0
GA8 22 2000444 -37 0
GA9 22 2000444 -37 0
GA10 22 2000444 -37 0
FD22    - draw many different types of chart;
GA1 23 2000482 22 0
GA2 23 2000444 -37 0
GA3 23 2000444 -37 0
GA4 23 2000444 -37 0
GA5 23 2000444 -37 0
GA6 23 2000444 -37 0
GA7 23 2000444 -37 0
GA8 23 2000444 -37 0
GA9 23 2000444 -37 0
GA10 23 2000444 -37 0
FD23    - act like a database, with search and sort;
GA1 24 2000482 23 0
GA2 24 2000444 -37 0
GA3 24 2000444 -37 0
GA4 24 2000444 -37 0
GA5 24 2000444 -37 0
GA6 24 2000444 -37 0
GA7 24 2000444 -37 0
GA8 24 2000444 -37 0
GA9 24 2000444 -37 0
GA10 24 2000444 -37 0
FD24    - handle time and dates, as well as numbers;
GA1 25 2000482 24 0
GA2 25 2000444 -37 0
GA3 25 2000444 -37 0
GA4 25 2000444 -37 0
GA5 25 2000444 -37 0
GA6 25 2000444 -37 0
GA7 25 2000444 -37 0
GA8 25 2000444 -37 0
GA9 25 2000444 -37 0
GA10 25 2000444 -37 0
FD25    - let you write macros (programs) to extend its power.
GA1 26 2000482 25 0
GA2 26 2000444 -37 0
GA3 26 2000444 -37 0
GA4 26 2000444 -37 0
GA5 26 2000444 -37 0
GA6 26 2000444 -37 0
GA7 26 2000444 -37 0
GA8 26 2000444 -37 0
GA9 26 2000444 -37 0
GA10 26 2000444 -37 0
FD26 Screen 3
GA1 27 2000402 26 0
FD27 Rows, columns, and cells
GA2 27 2000402 27 0
GA3 27 2000444 -37 0
GA4 27 2000444 -37 0
GA5 27 2000444 -37 0
GA6 27 2000444 -37 0
GA7 27 2000444 -37 0
GA8 27 2000444 -37 0
GA9 27 2000444 -37 0
GA10 27 2000444 -37 0
GA1 28 2000444 -37 0
GA2 28 2000444 -37 0
GA3 28 2000444 -37 0
GA4 28 2000444 -37 0
GA5 28 2000444 -37 0
GA6 28 2000444 -37 0
GA7 28 2000444 -37 0
GA8 28 2000444 -37 0
GA9 28 2000444 -37 0
GA10 28 2000444 -37 0
FD28 a) The spreadsheet is ruled into rows and columns.
GA1 29 2000482 28 0
GA2 29 2000444 -37 0
GA3 29 2000444 -37 0
GA4 29 2000444 -37 0
GA5 29 2000444 -37 0
GA6 29 2000444 -37 0
GA7 29 2000444 -37 0
GA8 29 2000444 -37 0
GA9 29 2000444 -37 0
GA10 29 2000444 -37 0
FD29    Each row is labelled with a number, each column with a letter.
GA1 30 2000482 29 0
GA2 30 2000444 -37 0
GA3 30 2000444 -37 0
GA4 30 2000444 -37 0
GA5 30 2000444 -37 0
GA6 30 2000444 -37 0
GA7 30 2000444 -37 0
GA8 30 2000444 -37 0
GA9 30 2000444 -37 0
GA10 30 2000444 -37 0
GA1 31 2000444 -37 0
GA2 31 2000444 -37 0
GA3 31 2000444 -37 0
GA4 31 2000444 -37 0
GA5 31 2000444 -37 0
GA6 31 2000444 -37 0
GA7 31 2000444 -37 0
GA8 31 2000444 -37 0
GA9 31 2000444 -37 0
GA10 31 2000444 -37 0
FD30 b) The lines which mark the columns and rows form boxes or CELLS.
GA1 32 2000482 30 0
GA2 32 2000444 -37 0
GA3 32 2000444 -37 0
GA4 32 2000444 -37 0
GA5 32 2000444 -37 0
GA6 32 2000444 -37 0
GA7 32 2000444 -37 0
GA8 32 2000444 -37 0
GA9 32 2000444 -37 0
GA10 32 2000444 -37 0
FD31    The grey cell to the right would be called G33  =>
GA1 33 2000482 31 0
GA2 33 2000444 -37 0
GA3 33 2000444 -37 0
GA4 33 2000444 -37 0
GA5 33 2000444 -37 0
GA6 33 2000444 -37 0
FD32
GA7 33 23c0702 32 0
GA8 33 2000444 -37 0
GA9 33 2000444 -37 0
GA10 33 2000444 -37 0
GA1 34 2000444 -37 0
GA2 34 2000444 -37 0
GA3 34 2000444 -37 0
GA4 34 2000444 -37 0
GA5 34 2000444 -37 0
GA6 34 2000444 -37 0
GA7 34 2000444 -37 0
GA8 34 2000444 -37 0
GA9 34 2000444 -37 0
GA10 34 2000444 -37 0
FD33 c) You are always "in" just ONE cell, called the CURRENT CELL.
GA1 35 482 33 ="c) You are always \"in\" just ONE cell, called the CURRENT CELL."
GA2 35 2000444 -37 0
GA3 35 2000444 -37 0
GA4 35 2000444 -37 0
GA5 35 2000444 -37 0
GA6 35 2000444 -37 0
GA7 35 2000444 -37 0
GA8 35 2000444 -37 0
GA9 35 2000444 -37 0
GA10 35 2000444 -37 0
GA1 36 2000444 -37 0
GA2 36 2000444 -37 0
GA3 36 2000444 -37 0
GA4 36 2000444 -37 0
GA5 36 2000444 -37 0
GA6 36 2000444 -37 0
GA7 36 2000444 -37 0
GA8 36 2000444 -37 0
GA9 36 2000444 -37 0
GA10 36 2000444 -37 0
FD34 d) To move to another cell, simply point and click.
GA1 37 2000482 34 0
GA2 37 2000444 -37 0
GA3 37 2000444 -37 0
GA4 37 2000444 -37 0
GA5 37 2000444 -37 0
GA6 37 2000444 -37 0
GA7 37 2000444 -37 0
GA8 37 2000444 -37 0
GA9 37 2000444 -37 0
GA10 37 2000444 -37 0
FD35    Try this now: move the pointer over the boxed cell
GA1 38 2000482 35 0
GA2 38 2000444 -37 0
GA3 38 2000444 -37 0
GA4 38 2000444 -37 0
GA5 38 2000444 -37 0
GA6 38 2000444 -37 0
GA7 38 2000444 -37 0
GA8 38 2000444 -37 0
GA9 38 2000444 -37 0
GA10 38 2000444 -37 0
FD36    at the end of this line and tap Select:
GA1 39 2000482 36 0
GA2 39 2000444 -37 0
GA3 39 2000444 -37 0
GA4 39 2000444 -37 0
GA5 39 2000444 -37 0
GA6 39 2000444 -37 0
GA7 39 23c0444 -37 0
GA8 39 2000444 -37 0
GA9 39 2000444 -37 0
GA10 39 2000444 -37 0
FD37 Screen 4
GA1 40 2000402 37 0
FD38 Entering numbers - and automatic addition
GA2 40 2000402 38 0
GA3 40 2000444 -37 0
GA4 40 2000444 -37 0
GA5 40 2000444 -37 0
GA6 40 2000444 -37 0
GA7 40 2000444 -37 0
GA8 40 2000444 -37 0
GA9 40 2000444 -37 0
GA10 40 2000444 -37 0
GA1 41 2000444 -37 0
GA2 41 2000444 -37 0
GA4 41 2000444 -37 0
GA5 41 2000444 -37 0
GA6 41 2000444 -37 0
GA7 41 2000444 -37 0
GA8 41 2000444 -37 0
GA9 41 2000444 -37 0
GA10 41 2000444 -37 0
FD39 Income
GA1 42 2280442 39 0
FD40 Week 1
GA2 42 2200442 40 0
FD41   a) Move into cell B43 - ie click over
GA3 42 2000482 41 0
GA4 42 2000444 -37 0
GA5 42 2000444 -37 0
GA6 42 2000444 -37 0
GA7 42 2000444 -37 0
GA8 42 2000444 -37 0
GA9 42 2000444 -37 0
GA10 42 2000444 -37 0
FD42 Pocket money
GA1 43 2080442 42 0
GA2 43 441 1.65 =1.65
FD43 ⇦    the cell pointed to by the arrow.
GA3 43 2000482 43 0
GA4 43 2000444 -37 0
GA5 43 2000444 -37 0
GA6 43 2000444 -37 0
GA7 43 2000444 -37 0
GA8 43 2000444 -37 0
GA9 43 2000444 -37 0
GA10 43 2000444 -37 0
FD44 Paper round
GA1 44 2080442 44 0
GA2 44 441 3.5 =3.5
FD45   b) Look at the top-left of the window:
GA3 44 2000482 45 0
GA4 44 2000444 -37 0
GA5 44 2000444 -37 0
GA6 44 2000444 -37 0
GA7 44 2000444 -37 0
GA8 44 2000444 -37 0
GA9 44 2000444 -37 0
GA10 44 2000444 -37 0
FD46 Gifts
GA1 45 2080442 46 0
GA2 45 2000440 4 0
FD47      the DATA ENTRY AREA under the title bar
GA3 45 2000482 47 0
GA4 45 2000444 -37 0
GA5 45 2000444 -37 0
GA6 45 2000444 -37 0
GA7 45 2000444 -37 0
GA8 45 2000444 -37 0
GA9 45 2000444 -37 0
GA10 45 2000444 -37 0
FD48 Other
GA1 46 2080442 48 0
GA2 46 441 1.5 =1.5
FD49      shows the cell's value, & below it the
GA3 46 2000482 49 0
GA4 46 2000444 -37 0
GA5 46 2000444 -37 0
GA6 46 2000444 -37 0
GA7 46 2000444 -37 0
GA8 46 2000444 -37 0
GA9 46 2000444 -37 0
GA10 46 2000444 -37 0
FD50 Total
GA1 47 2180442 50 0
GA2 47 1005c1 10.65 =SUM(B43..B46)
FD51      REFERENCE AREA names the cell as "B43"
GA3 47 2000482 51 0
GA4 47 2000444 -37 0
GA5 47 2000444 -37 0
GA6 47 2000444 -37 0
GA7 47 2000444 -37 0
GA8 47 2000444 -37 0
GA9 47 2000444 -37 0
GA10 47 2000444 -37 0
FD52 c) Tap <Delete> . The caret appears in the data entry area and the
GA1 48 2000482 52 0
GA2 48 2000444 -37 0
GA3 48 2000444 -37 0
GA4 48 2000444 -37 0
GA5 48 2000444 -37 0
GA6 48 2000444 -37 0
GA7 48 2000444 -37 0
GA8 48 2000444 -37 0
GA9 48 2000444 -37 0
GA10 48 2000444 -37 0
FD53    5 is deleted. Finish deleting the old value, key in the value 2,
GA1 49 2000482 53 0
GA2 49 2000444 -37 0
GA3 49 2000444 -37 0
GA4 49 2000444 -37 0
GA5 49 2000444 -37 0
GA6 49 2000444 -37 0
GA7 49 2000444 -37 0
GA8 49 2000444 -37 0
GA9 49 2000444 -37 0
GA10 49 2000444 -37 0
FD54    tap <Return>: 2.00 replaces 1.65 in cell B43, "Total" goes up.
GA1 50 2000482 54 0
GA2 50 2000444 -37 0
GA3 50 2000444 -37 0
GA4 50 2000444 -37 0
GA5 50 2000444 -37 0
GA6 50 2000444 -37 0
GA7 50 2000444 -37 0
GA8 50 2000444 -37 0
GA9 50 2000444 -37 0
GA10 50 2000444 -37 0
FD55 d) Try changing other values and check "Total". Try clicking the
GA1 51 2000482 55 0
GA2 51 2000444 -37 0
GA3 51 2000444 -37 0
GA4 51 2000444 -37 0
GA5 51 2000444 -37 0
GA6 51 2000444 -37 0
GA7 51 2000444 -37 0
GA8 51 2000444 -37 0
GA9 51 2000444 -37 0
GA10 51 2000444 -37 0
FD56     green tick icon next to the reference area instead of <Return>
GA1 52 2000482 56 0
GA2 52 2000444 -37 0
GA3 52 2000444 -37 0
GA4 52 2000444 -37 0
GA5 52 2000444 -37 0
GA6 52 2000444 -37 0
GA7 52 2000444 -37 0
GA8 52 2000444 -37 0
GA9 52 2000444 -37 0
GA10 52 2000444 -37 0
FD57 Screen 5
GA1 53 2000402 57 0
FD58 How is the addition done?
GA2 53 2000402 58 0
GA3 53 2000444 -37 0
GA4 53 2000444 -37 0
GA5 53 2000444 -37 0
GA6 53 2000444 -37 0
GA7 53 2000444 -37 0
GA8 53 2000444 -37 0
GA9 53 2000444 -37 0
GA10 53 2000444 -37 0
GA1 54 2000444 -37 0
GA2 54 2000444 -37 0
GA3 54 2000444 -37 0
GA4 54 2000444 -37 0
GA5 54 2000444 -37 0
GA6 54 2000444 -37 0
GA7 54 2000444 -37 0
GA8 54 2000444 -37 0
GA9 54 2000444 -37 0
GA10 54 2000444 -37 0
FD59 Income
GA1 55 2280442 59 0
FD60 Week 1
GA2 55 2200442 60 0
FD61    a) If you look at this window, it seems
GA3 55 2000482 61 0
GA4 55 2000444 -37 0
GA5 55 2000444 -37 0
GA6 55 2000444 -37 0
GA7 55 2000444 -37 0
GA8 55 2000444 -37 0
GA9 55 2000444 -37 0
GA10 55 2000444 -37 0
FD62 Pocket money
GA1 56 2080442 62 0
GA2 56 441 1.65 &2 43
FD63       that CELLS contain WORDS or NUMBERS.
GA3 56 2000482 63 0
GA4 56 2000444 -37 0
GA5 56 2000444 -37 0
GA6 56 2000444 -37 0
GA7 56 2000444 -37 0
GA8 56 2000444 -37 0
GA9 56 2000444 -37 0
GA10 56 2000444 -37 0
FD64 Paper round
GA1 57 2080442 64 0
GA2 57 441 3.5 &2 44
FD65    b) But a cell may also contain a FORMULA
GA3 57 2000482 65 0
GA4 57 2000444 -37 0
GA5 57 2000444 -37 0
GA6 57 2000444 -37 0
GA7 57 2000444 -37 0
GA8 57 2000444 -37 0
GA9 57 2000444 -37 0
GA10 57 2000444 -37 0
FD66 Gifts
GA1 58 2080442 66 0
GA2 58 2000440 4 0
FD67       - this is a rule for working-out what
GA3 58 2000482 67 0
GA4 58 2000444 -37 0
GA5 58 2000444 -37 0
GA6 58 2000444 -37 0
GA7 58 2000444 -37 0
GA8 58 2000444 -37 0
GA9 58 2000444 -37 0
GA10 58 2000444 -37 0
FD68 Other
GA1 59 2080442 68 0
GA2 59 441 1.5 &2 46
FD69       number to display.
GA3 59 2000482 69 0
GA4 59 2000444 -37 0
GA5 59 2000444 -37 0
GA6 59 2000444 -37 0
GA7 59 2000444 -37 0
GA8 59 2000444 -37 0
GA9 59 2000444 -37 0
GA10 59 2000444 -37 0
FD70 Total
GA1 60 2180442 70 0
GA2 60 1005c1 10.65 &2 47
GA3 60 2000444 -37 0
GA4 60 2000444 -37 0
GA5 60 2000444 -37 0
GA6 60 2000444 -37 0
GA7 60 2000444 -37 0
GA8 60 2000444 -37 0
GA9 60 2000444 -37 0
GA10 60 2000444 -37 0
FD71 c) Click into cell B57: the data entry area shows the NUMBER 3.5
GA1 61 2000482 71 0
GA2 61 2000444 -37 0
GA3 61 2000444 -37 0
GA4 61 2000444 -37 0
GA5 61 2000444 -37 0
GA6 61 2000444 -37 0
GA7 61 2000444 -37 0
GA8 61 2000444 -37 0
GA9 61 2000444 -37 0
GA10 61 2000444 -37 0
FD72 d) Click into cell A58: the data entry area shows the WORD "Gifts".
GA1 62 2000482 72 0
GA2 62 2000444 -37 0
GA3 62 2000444 -37 0
GA4 62 2000444 -37 0
GA5 62 2000444 -37 0
GA6 62 2000444 -37 0
GA7 62 2000444 -37 0
GA8 62 2000444 -37 0
GA9 62 2000444 -37 0
GA10 62 2000444 -37 0
FD73 e) Click into cell B60: the data entry area shows the FORMULA
GA1 63 2000482 73 0
GA2 63 2000444 -37 0
GA3 63 2000444 -37 0
GA4 63 2000444 -37 0
GA5 63 2000444 -37 0
GA6 63 2000444 -37 0
GA7 63 2000444 -37 0
GA8 63 2000444 -37 0
GA9 63 2000444 -37 0
GA10 63 2000444 -37 0
FD74     =SUM(B56..B59)   This means: "Add up the block from B56 to B59".
GA1 64 2000482 74 0
GA2 64 2000444 -37 0
GA3 64 2000444 -37 0
GA4 64 2000444 -37 0
GA5 64 2000444 -37 0
GA6 64 2000444 -37 0
GA7 64 2000444 -37 0
GA8 64 2000444 -37 0
GA9 64 2000444 -37 0
GA10 64 2000444 -37 0
FD75     Cell B60 CONTAINS a FORMULA, but DISPLAYS its RESULT.
GA1 65 2000482 75 0
GA2 65 2000444 -37 0
GA3 65 2000444 -37 0
GA4 65 2000444 -37 0
GA5 65 2000444 -37 0
GA6 65 2000444 -37 0
GA7 65 2000444 -37 0
GA8 65 2000444 -37 0
GA9 65 2000444 -37 0
GA10 65 2000444 -37 0
FD76 Screen 6
GA1 66 2000402 76 0
FD77 Entering a formula yourself
GA2 66 2000402 77 0
GA3 66 2000444 -37 0
GA4 66 2000444 -37 0
GA5 66 2000444 -37 0
GA6 66 2000444 -37 0
GA7 66 2000444 -37 0
GA8 66 2000444 -37 0
GA9 66 2000444 -37 0
GA10 66 2000444 -37 0
GA1 67 2000444 -37 0
GA2 67 2000444 -37 0
GA3 67 2000444 -37 0
GA4 67 2000444 -37 0
GA5 67 2000444 -37 0
GA6 67 2000444 -37 0
GA7 67 2000444 -37 0
GA8 67 2000444 -37 0
GA9 67 2000444 -37 0
GA10 67 2000444 -37 0
FD78 Income
GA1 68 2280442 78 0
FD79 Week 1
GA2 68 2200442 79 0
FD80 Week 2
GA3 68 2200442 80 0
FD81   a) There is now a column for a
GA4 68 2000482 81 0
GA5 68 2000444 -37 0
GA6 68 2000444 -37 0
GA7 68 2000444 -37 0
GA8 68 2000444 -37 0
GA9 68 2000444 -37 0
GA10 68 2000444 -37 0
FD82 Pocket money
GA1 69 2080442 82 0
GA2 69 2000440 2 0
GA3 69 2000440 2 0
FD83      second week - but no Total.
GA4 69 2000482 83 0
GA5 69 2000444 -37 0
GA6 69 2000444 -37 0
GA7 69 2000444 -37 0
GA8 69 2000444 -37 0
GA9 69 2000444 -37 0
GA10 69 2000444 -37 0
FD84 Paper round
GA1 70 2080442 84 0
GA2 70 441 3.5 &2 44
GA3 70 441 3.5 &2 44
FD85   b) Click into B73: the data entry
GA4 70 2000482 85 0
GA5 70 2000444 -37 0
GA6 70 2000444 -37 0
GA7 70 2000444 -37 0
GA8 70 2000444 -37 0
GA9 70 2000444 -37 0
GA10 70 2000444 -37 0
FD86 Gifts
GA1 71 2080442 86 0
GA2 71 2000440 4 0
GA3 71 441 1.45 =1.45
FD87      area shows:  =SUM(B69..B72)
GA4 71 2000482 87 0
GA5 71 2000444 -37 0
GA6 71 2000444 -37 0
GA7 71 2000444 -37 0
GA8 71 2000444 -37 0
GA9 71 2000444 -37 0
GA10 71 2000444 -37 0
FD88 Other
GA1 72 2080442 88 0
GA2 72 441 1.5 &2 46
GA3 72 441 3.2 =3.2
FD89   Note: The equals sign (=) means
GA4 72 20006c2 89 0
GA5 72 2000444 -37 0
GA6 72 2000444 -37 0
GA7 72 2000444 -37 0
GA8 72 2000444 -37 0
GA9 72 2000444 -37 0
GA10 72 2000444 -37 0
FD90 Total
GA1 73 2180442 90 0
GA2 73 1005c1 11 &2 47
GA3 73 21005c4 -37 0
FD91   what follows is a formula
GA4 73 20006c2 91 0
GA5 73 2000444 -37 0
GA6 73 2000444 -37 0
GA7 73 2000444 -37 0
GA8 73 2000444 -37 0
GA9 73 2000444 -37 0
GA10 73 2000444 -37 0
GA1 74 2000444 -37 0
GA2 74 2000444 -37 0
GA3 74 2000484 -37 0
GA4 74 2000444 -37 0
GA5 74 2000444 -37 0
GA6 74 2000444 -37 0
GA7 74 2000444 -37 0
GA8 74 2000444 -37 0
GA9 74 2000444 -37 0
GA10 74 2000444 -37 0
FD92 c) A similar FORMULA is needed in C73, to add up the numbers
GA1 75 2000482 92 0
GA2 75 2000444 -37 0
GA3 75 2000444 -37 0
GA4 75 2000444 -37 0
GA5 75 2000444 -37 0
GA6 75 2000444 -37 0
GA7 75 2000444 -37 0
GA8 75 2000444 -37 0
GA9 75 2000444 -37 0
GA10 75 2000444 -37 0
FD93    from C69 to C72.
GA1 76 2000482 93 0
GA2 76 2000444 -37 0
GA3 76 2000444 -37 0
GA4 76 2000444 -37 0
GA5 76 2000444 -37 0
GA6 76 2000444 -37 0
GA7 76 2000444 -37 0
GA8 76 2000444 -37 0
GA9 76 2000444 -37 0
GA10 76 2000444 -37 0
FD94 d) Click into C73, key-in:  =SUM(C69..C72)  and then tap <Return>.
GA1 77 2000482 94 0
GA2 77 2000444 -37 0
GA3 77 2000444 -37 0
GA4 77 2000444 -37 0
GA5 77 2000444 -37 0
GA6 77 2000444 -37 0
GA7 77 2000444 -37 0
GA8 77 2000444 -37 0
GA9 77 2000444 -37 0
GA10 77 2000444 -37 0
FD95    The correct Total will show.
GA1 78 2000482 95 0
GA2 78 2000444 -37 0
GA3 78 2000444 -37 0
GA4 78 2000444 -37 0
GA5 78 2000444 -37 0
GA6 78 2000444 -37 0
GA7 78 2000444 -37 0
GA8 78 2000444 -37 0
GA9 78 2000444 -37 0
GA10 78 2000444 -37 0
FD96 Screen 7
GA1 79 2000402 96 0
FD97 Formulae doing simple arithmetic: some to try
GA2 79 2000402 97 0
GA3 79 2000444 -37 0
GA4 79 2000444 -37 0
GA5 79 2000444 -37 0
GA6 79 2000444 -37 0
GA7 79 2000444 -37 0
GA8 79 2000444 -37 0
GA9 79 2000444 -37 0
GA10 79 2000444 -37 0
FD98 a) Formulae can be simple or complicated, they can do a variety of
GA1 80 2000482 98 0
GA2 80 2000444 -37 0
GA3 80 2000444 -37 0
GA4 80 2000444 -37 0
GA5 80 2000444 -37 0
GA6 80 2000444 -37 0
GA7 80 2000444 -37 0
GA8 80 2000444 -37 0
GA9 80 2000444 -37 0
GA10 80 2000444 -37 0
FD99    jobs - and they don't need to be near the cells they refer to.
GA1 81 2000482 99 0
GA2 81 2000444 -37 0
GA3 81 2000444 -37 0
GA4 81 2000444 -37 0
GA5 81 2000444 -37 0
GA6 81 2000444 -37 0
GA7 81 2000444 -37 0
GA8 81 2000444 -37 0
GA9 81 2000444 -37 0
GA10 81 2000444 -37 0
FD100 b) Every cell on this screen which CONTAINS A FORMULA has been made
GA1 82 2000482 100 0
GA2 82 2000444 -37 0
GA3 82 2000444 -37 0
GA4 82 2000444 -37 0
GA5 82 2000444 -37 0
GA6 82 2000444 -37 0
GA7 82 2000444 -37 0
GA8 82 2000444 -37 0
GA9 82 2000444 -37 0
GA10 82 2000444 -37 0
FD101    to DISPLAY THE RESULT in green.
GA1 83 2000482 101 0
GA2 83 2000444 -37 0
GA3 83 2000444 -37 0
GA4 83 2000444 -37 0
GA5 83 2000444 -37 0
GA6 83 2000444 -37 0
GA7 83 2000444 -37 0
GA8 83 2000444 -37 0
GA9 83 2000444 -37 0
GA10 83 2000444 -37 0
FD102 c) Click into each "green" cell, read the formula there from the
GA1 84 2000482 102 0
GA2 84 2000444 -37 0
GA3 84 2000444 -37 0
GA4 84 2000444 -37 0
GA5 84 2000444 -37 0
GA6 84 2000444 -37 0
GA7 84 2000444 -37 0
GA8 84 2000444 -37 0
GA9 84 2000444 -37 0
GA10 84 2000444 -37 0
FD103    data entry area. Note: " * " means multiply, " / " means divide.
GA1 85 2000482 103 0
GA2 85 2000444 -37 0
GA3 85 2000444 -37 0
GA4 85 2000444 -37 0
GA5 85 2000444 -37 0
GA6 85 2000444 -37 0
GA7 85 2000444 -37 0
GA8 85 2000444 -37 0
GA9 85 2000444 -37 0
GA10 85 2000444 -37 0
FD104 Formula cells
GA1 86 2000402 104 0
FD105 Cells used by formulae
GA2 86 2000402 105 0
GA3 86 2000444 -37 0
GA4 86 2000444 -37 0
GA5 86 2000444 -37 0
GA6 86 2000444 -37 0
GA7 86 2000444 -37 0
GA8 86 2000444 -37 0
GA9 86 2000444 -37 0
GA10 86 2000444 -37 0
GA1 87 4c0 18 =B87+C87
GA2 87 23c0600 5 0
GA3 87 23c0600 13 0
FD106  ⇦
GA4 87 2000482 106 0
FD107 d) Click into these
GA5 87 2000482 107 0
GA6 87 2000444 -37 0
GA7 87 2000444 -37 0
GA8 87 2000444 -37 0
GA9 87 2000444 -37 0
GA10 87 2000444 -37 0
GA1 88 4c0 12 =B88*C88
GA2 88 23c0600 4 0
GA3 88 23c0600 3 0
FD108  ⇦
GA4 88 2000482 108 0
FD109    boxed cells, enter
GA5 88 2000482 109 0
GA6 88 2000444 -37 0
GA7 88 2000444 -37 0
GA8 88 2000444 -37 0
GA9 88 2000444 -37 0
GA10 88 2000444 -37 0
GA1 89 4c0 -2 =B89-C89
GA2 89 23c0600 12 0
GA3 89 23c0600 14 0
FD110  ⇦
GA4 89 2000482 110 0
FD111    new numbers, and tap
GA5 89 2000482 111 0
GA6 89 2000444 -37 0
GA7 89 2000444 -37 0
GA8 89 2000444 -37 0
GA9 89 2000444 -37 0
GA10 89 2000444 -37 0
GA1 90 4c1 5 =B90/C90
GA2 90 23c0600 20 0
GA3 90 23c0600 4 0
FD112  ⇦
GA4 90 2000482 112 0
FD113    <Return>. Study the
GA5 90 2000482 113 0
GA6 90 2000444 -37 0
GA7 90 2000444 -37 0
GA8 90 2000444 -37 0
GA9 90 2000444 -37 0
GA10 90 2000444 -37 0
GA1 91 4c0 12 =B91+C87-10
GA2 91 23c0600 9 0
GA3 91 2000604 -37 0
FD114  ⇦
GA4 91 2000482 114 0
FD115    changes in column A.
GA5 91 2000482 115 0
GA6 91 2000444 -37 0
GA7 91 2000444 -37 0
GA8 91 2000444 -37 0
GA9 91 2000444 -37 0
GA10 91 2000444 -37 0
FD116 Screen 8
GA1 92 2000402 116 0
FD117 Formulae doing simple arithmetic: more to try
GA2 92 2000402 117 0
GA3 92 2000444 -37 0
GA4 92 2000444 -37 0
GA5 92 2000444 -37 0
GA6 92 2000444 -37 0
GA7 92 2000444 -37 0
GA8 92 2000444 -37 0
GA9 92 2000444 -37 0
GA10 92 2000444 -37 0
FD118 a) Each green cell contains a formula and displays its result.
GA1 93 2000482 118 0
GA2 93 2000444 -37 0
GA3 93 2000444 -37 0
GA4 93 2000444 -37 0
GA5 93 2000444 -37 0
GA6 93 2000444 -37 0
GA7 93 2000444 -37 0
GA8 93 2000444 -37 0
GA9 93 2000444 -37 0
GA10 93 2000444 -37 0
FD119    The formulae refer to the boxed numbers in columns F and G.
GA1 94 2000482 119 0
GA2 94 2000444 -37 0
GA3 94 2000444 -37 0
GA4 94 2000444 -37 0
GA5 94 2000444 -37 0
GA6 94 2000444 -37 0
GA7 94 2000444 -37 0
GA8 94 2000444 -37 0
GA9 94 2000444 -37 0
GA10 94 2000444 -37 0
FD120 b) Look at each formula by clicking into a green cell, then change
GA1 95 2000482 120 0
GA2 95 2000444 -37 0
GA3 95 2000444 -37 0
GA4 95 2000444 -37 0
GA5 95 2000444 -37 0
GA6 95 2000444 -37 0
GA7 95 2000444 -37 0
GA8 95 2000444 -37 0
GA9 95 2000444 -37 0
GA10 95 2000444 -37 0
FD121    some of the boxed numbers referred to by the formula so that the
GA1 96 2000482 121 0
GA2 96 2000444 -37 0
GA3 96 2000444 -37 0
GA4 96 2000444 -37 0
GA5 96 2000444 -37 0
GA6 96 2000444 -37 0
GA7 96 2000444 -37 0
GA8 96 2000444 -37 0
GA9 96 2000444 -37 0
GA10 96 2000444 -37 0
FD122    green value becomes the same as the blue value to its right.
GA1 97 2000482 122 0
GA2 97 2000444 -37 0
GA3 97 2000444 -37 0
GA4 97 2000444 -37 0
GA5 97 2000444 -37 0
GA6 97 2000444 -37 0
GA7 97 2000444 -37 0
GA8 97 2000444 -37 0
GA9 97 2000444 -37 0
GA10 97 2000444 -37 0
FD123 Formula
GA1 98 2000402 123 0
GA2 98 2000404 -37 0
FD124 Result
GA3 98 2000402 124 0
GA4 98 2000404 -37 0
FD125 Numbers used by formulae:
GA5 98 2000402 125 0
GA6 98 2000444 -37 0
GA7 98 2000444 -37 0
GA8 98 2000444 -37 0
GA9 98 2000444 -37 0
GA10 98 2000444 -37 0
FD126 cell
GA1 99 2000402 126 0
GA2 99 2000444 -37 0
FD127 to get
GA3 99 2000402 127 0
GA4 99 2000444 -37 0
FD128 change to get new result
GA5 99 2000402 128 0
GA6 99 2000444 -37 0
GA7 99 2000444 -37 0
GA8 99 2000444 -37 0
GA9 99 2000444 -37 0
GA10 99 2000444 -37 0
GA1 100 4c0 20 =F100+G100
GA2 100 2000444 -37 0
GA3 100 2000480 14 0
GA4 100 2000444 -37 0
GA5 100 2000444 -37 0
GA6 100 23c0600 15 0
GA7 100 23c0600 5 0
GA8 100 2000444 -37 0
GA9 100 2000444 -37 0
GA10 100 2000444 -37 0
GA1 101 4c0 32 =F101*G101
GA2 101 2000444 -37 0
GA3 101 2000480 20 0
GA4 101 2000444 -37 0
GA5 101 2000444 -37 0
GA6 101 23c0600 4 0
GA7 101 23c0600 8 0
GA8 101 2000444 -37 0
GA9 101 2000444 -37 0
GA10 101 2000444 -37 0
GA1 102 4c0 5 =F102-G102
GA2 102 2000444 -37 0
GA3 102 2000480 10 0
GA4 102 2000444 -37 0
GA5 102 2000444 -37 0
GA6 102 23c0600 16 0
GA7 102 23c0600 11 0
GA8 102 2000444 -37 0
GA9 102 2000444 -37 0
GA10 102 2000444 -37 0
GA1 103 4c1 6 =F103/G103
GA2 103 2000444 -37 0
GA3 103 2000480 4 0
GA4 103 2000444 -37 0
GA5 103 2000444 -37 0
GA6 103 23c0600 12 0
GA7 103 23c0600 2 0
GA8 103 2000444 -37 0
GA9 103 2000444 -37 0
GA10 103 2000444 -37 0
GA1 104 4c0 80 =100-F104
GA2 104 2000444 -37 0
GA3 104 2000480 10 0
GA4 104 2000444 -37 0
GA5 104 2000444 -37 0
GA6 104 23c0600 20 0
GA7 104 2000604 -37 0
GA8 104 2000444 -37 0
GA9 104 2000444 -37 0
GA10 104 2000444 -37 0
FD129 Screen 9
GA1 105 2000402 129 0
FD130 Formulae which work on blocks of cells
GA2 105 2000402 130 0
GA3 105 2000444 -37 0
GA4 105 2000444 -37 0
GA5 105 2000444 -37 0
GA6 105 2000444 -37 0
GA7 105 2000444 -37 0
GA8 105 2000444 -37 0
GA9 105 2000444 -37 0
GA10 105 2000444 -37 0
GA1 106 2000444 -37 0
GA2 106 2000444 -37 0
GA3 106 2000444 -37 0
GA4 106 2000444 -37 0
GA5 106 2000444 -37 0
GA6 106 2000444 -37 0
GA7 106 2000444 -37 0
GA8 106 2000444 -37 0
GA9 106 2000444 -37 0
GA10 106 2000444 -37 0
FD131 a) The formulae on this screen work on the block of numbers which
GA1 107 2000482 131 0
GA2 107 2000444 -37 0
GA3 107 2000444 -37 0
GA4 107 2000444 -37 0
GA5 107 2000444 -37 0
GA6 107 2000444 -37 0
GA7 107 2000444 -37 0
GA8 107 2000444 -37 0
GA9 107 2000444 -37 0
GA10 107 2000444 -37 0
FD132    starts at A113, ends at A117, and so is named "A113..A117"
GA1 108 2000482 132 0
GA2 108 2000444 -37 0
GA3 108 2000444 -37 0
GA4 108 2000444 -37 0
GA5 108 2000444 -37 0
GA6 108 2000444 -37 0
GA7 108 2000444 -37 0
GA8 108 2000444 -37 0
GA9 108 2000444 -37 0
GA10 108 2000444 -37 0
FD133 b) Click into each result in column B, look at the formula there.
GA1 109 2000482 133 0
GA2 109 2000444 -37 0
GA3 109 2000444 -37 0
GA4 109 2000444 -37 0
GA5 109 2000444 -37 0
GA6 109 2000444 -37 0
GA7 109 2000444 -37 0
GA8 109 2000444 -37 0
GA9 109 2000444 -37 0
GA10 109 2000444 -37 0
GA1 110 2000444 -37 0
GA2 110 2000444 -37 0
GA3 110 2000444 -37 0
GA4 110 2000444 -37 0
FD134 c) Alter column A values,
GA5 110 2000482 134 0
GA6 110 2000444 -37 0
GA7 110 2000444 -37 0
GA8 110 2000444 -37 0
GA9 110 2000444 -37 0
GA10 110 2000444 -37 0
FD135 Block of
GA1 111 2000502 135 0
FD136 Formula
GA2 111 2000502 136 0
FD137 Description
GA3 111 2000502 137 0
GA4 111 2000444 -37 0
FD138    and study results in
GA5 111 2000482 138 0
GA6 111 2000444 -37 0
GA7 111 2000444 -37 0
GA8 111 2000444 -37 0
GA9 111 2000444 -37 0
GA10 111 2000444 -37 0
FD139 cells
GA1 112 2000502 139 0
GA2 112 2000502 139 0
FD140  of result
GA3 112 2000502 140 0
GA4 112 2000444 -37 0
FD141    column B each time:
GA5 112 2000482 141 0
GA6 112 2000444 -37 0
GA7 112 2000444 -37 0
GA8 112 2000444 -37 0
GA9 112 2000444 -37 0
GA10 112 2000444 -37 0
GA1 113 2000540 40 0
GA2 113 641 5 =COUNT(A113..A117)
FD142  Count of block
GA3 113 2000442 142 0
GA4 113 2000444 -37 0
FD143 change A117 from 10 to 110
GA5 113 2000482 143 0
GA6 113 2000444 -37 0
GA7 113 2000444 -37 0
GA8 113 2000444 -37 0
GA9 113 2000444 -37 0
GA10 113 2000444 -37 0
GA1 114 2000540 70 0
GA2 114 4c1 200 =SUM(A113..A117)
FD144  Sum of block
GA3 114 2000442 144 0
GA4 114 2000444 -37 0
FD145 change A115 from 30 to 60
GA5 114 2000482 145 0
GA6 114 2000444 -37 0
GA7 114 2000444 -37 0
GA8 114 2000444 -37 0
GA9 114 2000444 -37 0
GA10 114 2000444 -37 0
GA1 115 2000540 30 0
GA2 115 4c1 70 =MAX(A113..A117)
FD146  Maximum in block
GA3 115 2000442 146 0
GA4 115 2000444 -37 0
FD147 change every cell value
GA5 115 2000482 147 0
GA6 115 2000444 -37 0
GA7 115 2000444 -37 0
GA8 115 2000444 -37 0
GA9 115 2000444 -37 0
GA10 115 2000444 -37 0
GA1 116 2000540 50 0
GA2 116 4c1 10 =MIN(A113..A117)
FD148  Minimum in block
GA3 116 2000442 148 0
GA4 116 2000444 -37 0
FD149 in block A113 to A117
GA5 116 2000482 149 0
GA6 116 2000444 -37 0
GA7 116 2000444 -37 0
GA8 116 2000444 -37 0
GA9 116 2000444 -37 0
GA10 116 2000444 -37 0
GA1 117 2000540 10 0
GA2 117 4c1 40 =AVERAGE(A113..A117)
FD150  Average of block
GA3 117 2000442 150 0
GA4 117 2000444 -37 0
FD151 to the value 2
GA5 117 2000482 151 0
GA6 117 2000444 -37 0
GA7 117 2000444 -37 0
GA8 117 2000444 -37 0
GA9 117 2000444 -37 0
GA10 117 2000444 -37 0
FD152 Screen 10
GA1 118 2000402 152 0
FD153 Entering formulae without really trying
GA2 118 2000402 153 0
GA3 118 2000444 -37 0
GA4 118 2000444 -37 0
GA5 118 2000444 -37 0
GA6 118 2000444 -37 0
GA7 118 2000444 -37 0
GA8 118 2000444 -37 0
GA9 118 2000444 -37 0
GA10 118 2000444 -37 0
FD154 a) You will now extend the income record to cover a useful 6 weeks.
GA1 119 2000482 154 0
GA2 119 2000444 -37 0
GA3 119 2000444 -37 0
GA4 119 2000444 -37 0
GA5 119 2000444 -37 0
GA6 119 2000444 -37 0
GA7 119 2000444 -37 0
GA8 119 2000444 -37 0
GA9 119 2000444 -37 0
GA10 119 2000444 -37 0
FD155 b) Click into C130: the data entry area shows:  SUM(C126..C129)
GA1 120 2000482 155 0
GA2 120 2000444 -37 0
GA3 120 2000444 -37 0
GA4 120 2000444 -37 0
GA5 120 2000444 -37 0
GA6 120 2000444 -37 0
GA7 120 2000444 -37 0
GA8 120 2000444 -37 0
GA9 120 2000444 -37 0
GA10 120 2000444 -37 0
FD156 c) Instead of entering 4 similar formulae in D130, E130, ..., just
GA1 121 2000482 156 0
GA2 121 2000444 -37 0
GA3 121 2000444 -37 0
GA4 121 2000444 -37 0
GA5 121 2000484 -37 0
GA6 121 2000444 -37 0
GA7 121 2000444 -37 0
GA8 121 2000444 -37 0
GA9 121 2000444 -37 0
GA10 121 2000444 -37 0
FD157    point at C130, press Select, drag to G130, tap <Return>. When
GA1 122 2000482 157 0
GA2 122 2000444 -37 0
GA3 122 2000444 -37 0
GA4 122 2000444 -37 0
GA5 122 2000444 -37 0
GA6 122 2000444 -37 0
GA7 122 2000444 -37 0
GA8 122 2000444 -37 0
GA9 122 2000444 -37 0
GA10 122 2000444 -37 0
FD158    when warned about changing a block of cells, click "Accept".
GA1 123 2000482 158 0
GA2 123 2000444 -37 0
GA3 123 2000444 -37 0
GA4 123 2000444 -37 0
GA5 123 2000444 -37 0
GA6 123 2000444 -37 0
GA7 123 2000444 -37 0
GA8 123 2000444 -37 0
GA9 123 2000444 -37 0
GA10 123 2000444 -37 0
FD159 d) Click into D130, E130, ...  check each formula suits its column.
GA1 124 2000482 159 0
GA2 124 2000444 -37 0
GA3 124 2000444 -37 0
GA4 124 2000444 -37 0
GA5 124 2000444 -37 0
GA6 124 2000444 -37 0
GA7 124 2000444 -37 0
GA8 124 2000444 -37 0
GA9 124 2000444 -37 0
GA10 124 2000444 -37 0
FD160 Income
GA1 125 2280442 160 0
FD161 Week 1
GA2 125 2200442 161 0
FD162 Week 2
GA3 125 2200442 162 0
FD163 Week 3
GA4 125 2200442 163 0
FD164 Week 4
GA5 125 2200442 164 0
FD165 Week 5
GA6 125 2200442 165 0
FD166 Week 6
GA7 125 2200442 166 0
FD167       ⇩
GA8 125 2000482 167 0
GA9 125 2000444 -37 0
GA10 125 2000444 -37 0
FD168 Pocket money
GA1 126 2080442 168 0
GA2 126 2000440 2 0
GA3 126 2000440 2 0
GA4 126 2000440 2 0
GA5 126 441 2.5 =2.5
GA6 126 441 2.5 &5 126
GA7 126 441 2.5 &5 126
FD169       ⇩
GA8 126 2000482 169 0
GA9 126 2000444 -37 0
GA10 126 2000444 -37 0
FD170 Paper round
GA1 127 2080442 170 0
GA2 127 441 3.5 &2 44
GA3 127 441 3.5 &2 44
GA4 127 441 3.5 &2 44
GA5 127 441 3.5 &2 44
GA6 127 441 3.5 &2 44
GA7 127 441 3.5 &2 44
FD171       ⇩
GA8 127 2000482 171 0
GA9 127 2000444 -37 0
GA10 127 2000444 -37 0
FD172 Gifts
GA1 128 2080442 172 0
GA2 128 2000440 4 0
GA3 128 441 1.45 &3 71
GA4 128 2000440 0 0
GA5 128 441 1.5 &2 46
GA6 128 441 1.2 =1.2
GA7 128 2000440 0 0
FD173       ⇩
GA8 128 2000482 173 0
GA9 128 2000444 -37 0
GA10 128 2000444 -37 0
FD174 Other
GA1 129 2080442 174 0
GA2 129 441 1.5 &2 46
GA3 129 441 3.2 &3 72
GA4 129 441 1.6 =1.6
GA5 129 2000440 0 0
GA6 129 441 0.5 =.5
GA7 129 441 0.8 =.8
FD175       ⇩
GA8 129 2000482 175 0
GA9 129 2000444 -37 0
GA10 129 2000444 -37 0
FD176 Total
GA1 130 2180442 176 0
GA2 130 1005c1 11 &2 47
GA3 130 1005c1 10.15 &2 47
GA4 130 21002c4 -37 0
GA5 130 21002c4 -37 0
GA6 130 21002c4 -37 0
GA7 130 21002c4 -37 0
FD177       ⇩
GA8 130 2000482 177 0
GA9 130 2000444 -37 0
GA10 130 2000444 -37 0
FD178 Screen 11
GA1 131 2000402 178 0
FD179 More about blocks of cells
GA2 131 2000402 179 0
GA3 131 2000444 -37 0
GA4 131 2000444 -37 0
GA5 131 2000444 -37 0
GA6 131 2000444 -37 0
GA7 131 2000444 -37 0
GA8 131 2000444 -37 0
GA9 131 2000444 -37 0
GA10 131 2000444 -37 0
FD180 a) When a formula is copied into a selected block of cells, Schema2
GA1 132 2000482 180 0
GA2 132 2000444 -37 0
GA3 132 2000444 -37 0
GA4 132 2000444 -37 0
GA5 132 2000444 -37 0
GA6 132 2000444 -37 0
GA7 132 2000444 -37 0
GA8 132 2000444 -37 0
GA9 132 2000444 -37 0
GA10 132 2000444 -37 0
FD181    adjusts it to suit each new position: if the copied formula
GA1 133 2000482 181 0
GA2 133 2000444 -37 0
GA3 133 2000444 -37 0
GA4 133 2000444 -37 0
GA5 133 2000444 -37 0
GA6 133 2000444 -37 0
GA7 133 2000444 -37 0
GA8 133 2000444 -37 0
GA9 133 2000444 -37 0
GA10 133 2000444 -37 0
FD182    totals the four cells above it, it will be adjusted to total
GA1 134 2000482 182 0
GA2 134 2000444 -37 0
GA3 134 2000444 -37 0
GA4 134 2000444 -37 0
GA5 134 2000444 -37 0
GA6 134 2000444 -37 0
GA7 134 2000444 -37 0
GA8 134 2000444 -37 0
GA9 134 2000444 -37 0
GA10 134 2000444 -37 0
FD183    the four cells above each new position.
GA1 135 2000482 183 0
GA2 135 2000444 -37 0
GA3 135 2000444 -37 0
GA4 135 2000444 -37 0
GA5 135 2000444 -37 0
GA6 135 21c0444 -37 0
GA7 135 2000444 -37 0
GA8 135 2000444 -37 0
GA9 135 2000444 -37 0
GA10 135 2000444 -37 0
FD184 b) The reference area names the current block:
GA1 136 2000482 184 0
GA2 136 2000444 -37 0
GA3 136 2000444 -37 0
GA4 136 2000444 -37 0
GA5 136 2000444 -37 0
GA6 136 20c0444 -37 0
GA7 136 2000444 -37 0
GA8 136 2000444 -37 0
GA9 136 2000444 -37 0
GA10 136 2000444 -37 0
FD185    With the pointer over F135, drag to F138
GA1 137 2000482 185 0
GA2 137 2000444 -37 0
GA3 137 2000444 -37 0
GA4 137 2000444 -37 0
GA5 137 2000444 -37 0
GA6 137 20c0444 -37 0
GA7 137 2000444 -37 0
GA8 137 2000444 -37 0
GA9 137 2000444 -37 0
GA10 137 2000444 -37 0
FD186    Now the reference area shows:  F135..F138
GA1 138 2000482 186 0
GA2 138 2000444 -37 0
GA3 138 2000444 -37 0
GA4 138 2000444 -37 0
GA5 138 2000444 -37 0
GA6 138 22c0444 -37 0
GA7 138 2000444 -37 0
GA8 138 2000444 -37 0
GA9 138 2000444 -37 0
GA10 138 2000444 -37 0
FD187 c) There is ALWAYS a CURRENT BLOCK, as well as a CURRENT CELL.
GA1 139 2000482 187 0
GA2 139 2000444 -37 0
GA3 139 2000444 -37 0
GA4 139 2000444 -37 0
GA5 139 2000444 -37 0
GA6 139 2000444 -37 0
GA7 139 2000444 -37 0
GA8 139 2000444 -37 0
GA9 139 2000444 -37 0
GA10 139 2000444 -37 0
FD188    If only one cell is selected then it is both the current block
GA1 140 2000482 188 0
GA2 140 2000444 -37 0
GA3 140 2000444 -37 0
GA4 140 2000444 -37 0
GA5 140 2000444 -37 0
GA6 140 2000444 -37 0
GA7 140 2000444 -37 0
GA8 140 2000444 -37 0
GA9 140 2000444 -37 0
GA10 140 2000444 -37 0
FD189    and the current cell.
GA1 141 2000482 189 0
GA2 141 2000444 -37 0
GA3 141 2000444 -37 0
GA4 141 2000444 -37 0
GA5 141 2000444 -37 0
GA6 141 2000444 -37 0
GA7 141 2000444 -37 0
GA8 141 2000444 -37 0
GA9 141 2000444 -37 0
GA10 141 2000444 -37 0
FD190    If several cells are selected, then the current cell is at its
GA1 142 2000482 190 0
GA2 142 2000444 -37 0
GA3 142 2000444 -37 0
GA4 142 2000444 -37 0
GA5 142 2000444 -37 0
GA6 142 2000444 -37 0
GA7 142 2000444 -37 0
GA8 142 2000444 -37 0
GA9 142 2000444 -37 0
GA10 142 2000444 -37 0
FD191    top left corner.
GA1 143 2000482 191 0
GA2 143 2000444 -37 0
GA3 143 2000444 -37 0
GA4 143 2000444 -37 0
GA5 143 2000444 -37 0
GA6 143 2000444 -37 0
GA7 143 2000444 -37 0
GA8 143 2000444 -37 0
GA9 143 2000444 -37 0
GA10 143 2000444 -37 0
FD192 Screen 12
GA1 144 2000402 192 0
FD193 Handling expenditure (spending) as well as income
GA2 144 2000402 193 0
GA3 144 2000444 -37 0
GA4 144 2000444 -37 0
GA5 144 2000444 -37 0
GA6 144 2000444 -37 0
GA7 144 2000444 -37 0
GA8 144 2000444 -37 0
GA9 144 2000444 -37 0
GA10 144 2000444 -37 0
FD194 Income
GA1 145 2280442 194 0
FD195 Week 1
GA2 145 2200442 195 0
FD196 Week 2
GA3 145 2200442 196 0
FD197 Week 3
GA4 145 2200442 197 0
FD198  a) Now expenditure also
GA5 145 2000482 198 0
GA6 145 2000444 -37 0
GA7 145 2000444 -37 0
GA8 145 2000444 -37 0
GA9 145 2000444 -37 0
GA10 145 2000444 -37 0
FD199 Brought fwd
GA1 146 2080442 199 0
GA2 146 2000440 0 0
GA3 146 441 4.5 =B156
GA4 146 441 1.199999999999999 &3 146
FD200     is shown for each week
GA5 146 2000482 200 0
GA6 146 2000444 -37 0
GA7 146 2000444 -37 0
GA8 146 2000444 -37 0
GA9 146 2000444 -37 0
GA10 146 2000444 -37 0
FD201 Pocket money
GA1 147 2080442 201 0
GA2 147 2000440 12 0
GA3 147 2000440 2 0
GA4 147 441 2.25 =2.25
FD202     (to fit window, fewer
GA5 147 2000482 202 0
GA6 147 2000444 -37 0
GA7 147 2000444 -37 0
GA8 147 2000444 -37 0
GA9 147 2000444 -37 0
GA10 147 2000444 -37 0
FD203 Paper round
GA1 148 2080442 203 0
GA2 148 441 3.5 &2 44
GA3 148 441 3.5 &2 44
GA4 148 441 3.5 &2 44
FD204     incomes now included)
GA5 148 2000482 204 0
GA6 148 2000444 -37 0
GA7 148 2000444 -37 0
GA8 148 2000444 -37 0
GA9 148 2000444 -37 0
GA10 148 2000444 -37 0
FD205 Total in
GA1 149 2180442 205 0
GA2 149 1005c1 15.5 =SUM(B146..B148)
GA3 149 1005c1 10 &2 149
GA4 149 1005c1 6.949999999999999 &2 149
FD206  b) Row 156 finds the end
GA5 149 2000482 206 0
GA6 149 2000444 -37 0
GA7 149 2000444 -37 0
GA8 149 2000444 -37 0
GA9 149 2000444 -37 0
GA10 149 2000444 -37 0
FD207 Expenditure
GA1 150 2280442 207 0
GA2 150 2200444 -37 0
GA3 150 2200444 -37 0
GA4 150 2200444 -37 0
FD208     of week balance as the
GA5 150 2000482 208 0
GA6 150 2000444 -37 0
GA7 150 2000444 -37 0
GA8 150 2000444 -37 0
GA9 150 2000444 -37 0
GA10 150 2000444 -37 0
FD209 Going out
GA1 151 2080442 209 0
GA2 151 441 1.8 =1.8
GA3 151 441 7.4 =7.4
GA4 151 2000440 2 0
FD210     difference between
GA5 151 2000482 210 0
GA6 151 2000444 -37 0
GA7 151 2000444 -37 0
GA8 151 2000444 -37 0
GA9 151 2000444 -37 0
GA10 151 2000444 -37 0
FD211 Music
GA1 152 2080442 211 0
GA2 152 441 2.4 =2.4
GA3 152 2000440 0 0
GA4 152 441 4.7 =4.7
FD212     "Total in" and
GA5 152 2000482 212 0
GA6 152 2000444 -37 0
GA7 152 2000444 -37 0
GA8 152 2000444 -37 0
GA9 152 2000444 -37 0
GA10 152 2000444 -37 0
FD213 Clothing
GA1 153 2080442 213 0
GA2 153 441 6.8 =6.8
GA3 153 2000440 0 0
GA4 153 441 10.6 =10.6
FD214     "Total out".
GA5 153 2000482 214 0
GA6 153 2000444 -37 0
GA7 153 2000444 -37 0
GA8 153 2000444 -37 0
GA9 153 2000444 -37 0
GA10 153 2000444 -37 0
FD215 Other
GA1 154 2080442 215 0
GA2 154 2000440 0 0
GA3 154 441 1.4 =1.4
GA4 154 2000440 0 0
FD216   c) Row 146 starts each
GA5 154 2000482 216 0
GA6 154 2000444 -37 0
GA7 154 2000444 -37 0
GA8 154 2000444 -37 0
GA9 154 2000444 -37 0
GA10 154 2000444 -37 0
FD217 Total out
GA1 155 2180442 217 0
GA2 155 1005c1 11 &2 47
GA3 155 1005c1 8.800000000000001 &2 47
GA4 155 1005c1 17.3 &2 47
FD218      week with balance
GA5 155 2000482 218 0
GA6 155 2000444 -37 0
GA7 155 2000444 -37 0
GA8 155 2000444 -37 0
GA9 155 2000444 -37 0
GA10 155 2000444 -37 0
FD219 Balance
GA1 156 23c0442 219 0
GA2 156 3005c1 4.5 =B149-B155
GA3 156 3005c1 1.199999999999999 &2 156
GA4 156 3005c1 -10.35 &2 156
FD220      from previous week.
GA5 156 2000482 220 0
GA6 156 2000444 -37 0
GA7 156 2000444 -37 0
GA8 156 2000444 -37 0
GA9 156 2000444 -37 0
GA10 156 2000444 -37 0
FD221 Screen 13
GA1 157 2000402 221 0
FD222 More on handling expenditure as well as income
GA2 157 2000402 222 0
GA3 157 2000444 -37 0
GA4 157 2000444 -37 0
GA5 157 2000444 -37 0
GA6 157 2000444 -37 0
GA7 157 2000444 -37 0
GA8 157 2000444 -37 0
GA9 157 2000444 -37 0
GA10 157 2000444 -37 0
FD223 Income
GA1 158 2280442 223 0
FD224 Week 1
GA2 158 2200442 224 0
FD225 Week 2
GA3 158 2200442 225 0
FD226 Week 3
GA4 158 2200442 226 0
FD227  a) Click into cells B168
GA5 158 2000482 227 0
GA6 158 2000444 -37 0
GA7 158 2000444 -37 0
GA8 158 2000444 -37 0
GA9 158 2000444 -37 0
GA10 158 2000444 -37 0
FD228 Brought fwd
GA1 159 2080442 228 0
GA2 159 2000440 0 0
GA3 159 1 5.100000000000001 &3 146
GA4 159 441 1.800000000000001 &3 146
FD229     to D168, check each
GA5 159 2000482 229 0
GA6 159 2000444 -37 0
GA7 159 2000444 -37 0
GA8 159 2000444 -37 0
GA9 159 2000444 -37 0
GA10 159 2000444 -37 0
FD230 Pocket money
GA1 160 2080442 230 0
GA2 160 2000440 12 0
GA3 160 2000440 2 0
GA4 160 441 2.25 &4 147
FD231     formula adds up a
GA5 160 2000482 231 0
GA6 160 2000444 -37 0
GA7 160 2000444 -37 0
GA8 160 2000444 -37 0
GA9 160 2000444 -37 0
GA10 160 2000444 -37 0
FD232 Paper round
GA1 161 2080442 232 0
GA2 161 441 3.5 &2 44
GA3 161 441 3.5 &2 44
GA4 161 441 3.5 &2 44
FD233     week's spending.
GA5 161 2000482 233 0
GA6 161 2000444 -37 0
GA7 161 2000444 -37 0
GA8 161 2000444 -37 0
GA9 161 2000444 -37 0
GA10 161 2000444 -37 0
FD234 Total in
GA1 162 2180442 234 0
GA2 162 1005c1 15.5 &2 149
GA3 162 1005c1 10.6 &2 149
GA4 162 1005c1 7.550000000000001 &2 149
FD235  b) Click into cells B169
GA5 162 2000482 235 0
GA6 162 2000444 -37 0
GA7 162 2000444 -37 0
GA8 162 2000444 -37 0
GA9 162 2000444 -37 0
GA10 162 2000444 -37 0
FD236 Expenditure
GA1 163 2280442 236 0
GA2 163 2200444 -37 0
GA3 163 2200444 -37 0
GA4 163 2200444 -37 0
FD237     to D169, check each
GA5 163 2000482 237 0
GA6 163 2000444 -37 0
GA7 163 2000444 -37 0
GA8 163 2000444 -37 0
GA9 163 2000444 -37 0
GA10 163 2000444 -37 0
FD238 Going out
GA1 164 2080442 238 0
GA2 164 441 1.2 &6 128
GA3 164 441 7.4 &3 151
GA4 164 2000440 2 0
FD239     has "Total in"
GA5 164 2000482 239 0
GA6 164 2000444 -37 0
GA7 164 2000444 -37 0
GA8 164 2000444 -37 0
GA9 164 2000444 -37 0
GA10 164 2000444 -37 0
FD240 Music
GA1 165 2080442 240 0
GA2 165 441 2.4 &2 152
GA3 165 2000440 0 0
GA4 165 441 4.7 &4 152
FD241     less "Total out"
GA5 165 2000482 241 0
GA6 165 2000444 -37 0
GA7 165 2000444 -37 0
GA8 165 2000444 -37 0
GA9 165 2000444 -37 0
GA10 165 2000444 -37 0
FD242 Clothing
GA1 166 2080442 242 0
GA2 166 441 6.8 &2 153
GA3 166 2000440 0 0
GA4 166 441 10.6 &4 153
FD243     for its column.
GA5 166 2000482 243 0
GA6 166 2000444 -37 0
GA7 166 2000444 -37 0
GA8 166 2000444 -37 0
GA9 166 2000444 -37 0
GA10 166 2000444 -37 0
FD244 Other
GA1 167 2080442 244 0
GA2 167 2000440 0 0
GA3 167 441 1.4 &3 154
GA4 167 2000440 0 0
FD245  c) Check that cell C159
GA5 167 2000482 245 0
GA6 167 2000444 -37 0
GA7 167 2000444 -37 0
GA8 167 2000444 -37 0
GA9 167 2000444 -37 0
GA10 167 2000444 -37 0
FD246 Total out
GA1 168 2180442 246 0
GA2 168 1005c1 10.4 &2 47
GA3 168 1005c1 8.800000000000001 &2 47
GA4 168 1005c1 17.3 &2 47
FD247     carries forward the
GA5 168 2000482 247 0
GA6 168 2000444 -37 0
GA7 168 2000444 -37 0
GA8 168 2000444 -37 0
GA9 168 2000444 -37 0
GA10 168 2000444 -37 0
FD248 Balance
GA1 169 23c0442 248 0
GA2 169 3005c1 5.100000000000001 &2 156
GA3 169 3005c1 1.800000000000001 &2 156
GA4 169 3005c1 -9.75 &2 156
FD249     balance from B169 etc.
GA5 169 2000482 249 0
GA6 169 2000444 -37 0
GA7 169 2000444 -37 0
GA8 169 2000444 -37 0
GA9 169 2000444 -37 0
GA10 169 2000444 -37 0
FD250 Screen 14
GA1 170 2000402 250 0
FD251 Drawing a chart from the figures
GA2 170 2000402 251 0
GA3 170 2000444 -37 0
GA4 170 2000444 -37 0
GA5 170 2000444 -37 0
GA6 170 2000444 -37 0
GA7 170 2000444 -37 0
GA8 170 2000444 -37 0
GA9 170 2000444 -37 0
GA10 170 2000444 -37 0
FD252 Income
GA1 171 2280442 252 0
FD253 Week 1
GA2 171 2200442 253 0
FD254 Week 2
GA3 171 2200442 254 0
FD255 Week 3
GA4 171 2200442 255 0
FD256 a) Select block A171..D174
GA5 171 2000482 256 0
GA6 171 2000444 -37 0
GA7 171 2000444 -37 0
GA8 171 2000444 -37 0
GA9 171 2000444 -37 0
GA10 171 2000444 -37 0
FD257 Brought fwd
GA1 172 2080442 257 0
GA2 172 2000440 0 0
GA3 172 441 5.100000000000001 &3 146
GA4 172 441 1.800000000000001 &3 146
FD258    with a Select click in
GA5 172 2000482 258 0
GA6 172 2000444 -37 0
GA7 172 2000444 -37 0
GA8 172 2000444 -37 0
GA9 172 2000444 -37 0
GA10 172 2000444 -37 0
FD259 Pocket money
GA1 173 2080442 259 0
GA2 173 2000440 12 0
GA3 173 2000440 2 0
GA4 173 441 2.25 &4 147
FD260    A171 and a Adjust click
GA5 173 2000482 260 0
GA6 173 2000444 -37 0
GA7 173 2000444 -37 0
GA8 173 2000444 -37 0
GA9 173 2000444 -37 0
GA10 173 2000444 -37 0
FD261 Paper round
GA1 174 2080442 261 0
GA2 174 441 3.5 &2 44
GA3 174 441 3.5 &2 44
GA4 174 441 3.5 &2 44
FD262    in D174 (an alternative
GA5 174 2000482 262 0
GA6 174 2000444 -37 0
GA7 174 2000444 -37 0
GA8 174 2000444 -37 0
GA9 174 2000444 -37 0
GA10 174 2000444 -37 0
FD263 Total in
GA1 175 2180442 263 0
GA2 175 1005c1 15.5 &2 149
GA3 175 1005c1 10.6 &2 149
GA4 175 1005c1 7.550000000000001 &2 149
FD264    to dragging).
GA5 175 2000482 264 0
GA6 175 2000444 -37 0
GA7 175 2000444 -37 0
GA8 175 2000444 -37 0
GA9 175 2000444 -37 0
GA10 175 2000444 -37 0
FD265 Expenditure
GA1 176 2280442 265 0
GA2 176 2200444 -37 0
GA3 176 2200444 -37 0
GA4 176 2200444 -37 0
FD266 b) Click second icon
GA5 176 2000482 266 0
GA6 176 2000444 -37 0
GA7 176 2000444 -37 0
GA8 176 2000444 -37 0
GA9 176 2000444 -37 0
GA10 176 2000444 -37 0
FD267 Going out
GA1 177 2080442 267 0
GA2 177 441 1.2 &6 128
GA3 177 441 7.4 &3 151
GA4 177 2000440 4 0
FD268    (it shows bars) in ICON
GA5 177 2000482 268 0
GA6 177 2000444 -37 0
GA7 177 2000444 -37 0
GA8 177 2000444 -37 0
GA9 177 2000444 -37 0
GA10 177 2000444 -37 0
FD269 Music
GA1 178 2080442 269 0
GA2 178 441 2.4 &2 152
GA3 178 2000440 0 0
GA4 178 441 4.7 &4 152
FD270    RIBBON above sheet
GA5 178 2000482 270 0
GA6 178 2000444 -37 0
GA7 178 2000444 -37 0
GA8 178 2000444 -37 0
GA9 178 2000444 -37 0
GA10 178 2000444 -37 0
FD271 Clothing
GA1 179 2080442 271 0
GA2 179 441 6.8 &2 153
GA3 179 2000440 0 0
GA4 179 441 10.6 &4 153
FD272    ... Schema2 chooses and
GA5 179 2000482 272 0
GA6 179 2000444 -37 0
GA7 179 2000444 -37 0
GA8 179 2000444 -37 0
GA9 179 2000444 -37 0
GA10 179 2000444 -37 0
FD273 Other
GA1 180 2080442 273 0
GA2 180 2000440 0 0
GA3 180 441 1.4 &3 154
GA4 180 2000440 0 0
FD274    draws a suitable chart.
GA5 180 2000482 274 0
GA6 180 2000444 -37 0
GA7 180 2000444 -37 0
GA8 180 2000444 -37 0
GA9 180 2000444 -37 0
GA10 180 2000444 -37 0
FD275 Total out
GA1 181 2180442 275 0
GA2 181 1005c1 10.4 &2 47
GA3 181 1005c1 8.800000000000001 &2 47
GA4 181 1005c1 19.3 &2 47
FD276 c) Close chart window by
GA5 181 2000482 276 0
GA6 181 2000444 -37 0
GA7 181 2000444 -37 0
GA8 181 2000444 -37 0
GA9 181 2000444 -37 0
GA10 181 2000444 -37 0
FD277 Balance
GA1 182 23c0442 277 0
GA2 182 3005c1 5.100000000000001 &2 156
GA3 182 3005c1 1.800000000000001 &2 156
GA4 182 3005c1 -11.75 &2 156
FD278    clicking its Quit icon.
GA5 182 2000482 278 0
GA6 182 2000444 -37 0
GA7 182 2000444 -37 0
GA8 182 2000444 -37 0
GA9 182 2000444 -37 0
GA10 182 2000444 -37 0
FD279 Screen 15
GA1 183 2000402 279 0
FD280 Choosing the type of chart
GA2 183 2000402 280 0
GA3 183 2000444 -37 0
GA4 183 2000444 -37 0
GA5 183 2000444 -37 0
GA6 183 2000444 -37 0
GA7 183 2000444 -37 0
GA8 183 2000444 -37 0
GA9 183 2000444 -37 0
GA10 183 2000444 -37 0
FD281 a) The third icon in the ribbon (it shows lines) offers a
GA1 184 2000482 281 0
GA2 184 2000444 -37 0
GA3 184 2000444 -37 0
GA4 184 2000444 -37 0
GA5 184 2000444 -37 0
GA6 184 2000444 -37 0
GA7 184 2000444 -37 0
GA8 184 2000444 -37 0
GA9 184 2000444 -37 0
GA10 184 2000444 -37 0
FD282    choice of charts. Select the block A190..E194 and click the icon.
GA1 185 2000482 282 0
GA2 185 2000444 -37 0
GA3 185 2000444 -37 0
GA4 185 2000444 -37 0
GA5 185 2000444 -37 0
GA6 185 2000444 -37 0
GA7 185 2000444 -37 0
GA8 185 2000444 -37 0
GA9 185 2000444 -37 0
GA10 185 2000444 -37 0
FD283 b) In the New Graph dialogue click the arrow icon, and choose
GA1 186 2000482 283 0
GA2 186 2000444 -37 0
GA3 186 2000444 -37 0
GA4 186 2000444 -37 0
GA5 186 2000444 -37 0
GA6 186 2000444 -37 0
GA7 186 2000444 -37 0
GA8 186 2000444 -37 0
GA9 186 2000444 -37 0
GA10 186 2000444 -37 0
FD284    "Pie chart" from the Graph Type menu.
GA1 187 2000482 284 0
GA2 187 2000444 -37 0
GA3 187 2000444 -37 0
GA4 187 2000444 -37 0
GA5 187 2000444 -37 0
GA6 187 2000444 -37 0
GA7 187 2000444 -37 0
GA8 187 2000444 -37 0
GA9 187 2000444 -37 0
GA10 187 2000444 -37 0
FD285 c) Click the [Graph] button in the New Graph dialogue.
GA1 188 2000482 285 0
GA2 188 2000444 -37 0
GA3 188 2000444 -37 0
GA4 188 2000444 -37 0
GA5 188 2000444 -37 0
GA6 188 2000444 -37 0
GA7 188 2000444 -37 0
GA8 188 2000444 -37 0
GA9 188 2000444 -37 0
GA10 188 2000444 -37 0
FD286 d) Close the pie chart window by clicking its Quit icon.
GA1 189 2000482 286 0
GA2 189 2000444 -37 0
GA3 189 2000444 -37 0
GA4 189 2000444 -37 0
GA5 189 2000444 -37 0
GA6 189 2000444 -37 0
GA7 189 2000444 -37 0
GA8 189 2000444 -37 0
GA9 189 2000444 -37 0
GA10 189 2000444 -37 0
FD287 Expenditure
GA1 190 2280442 287 0
FD288 Week 1
GA2 190 2200442 288 0
FD289 Week 2
GA3 190 2200442 289 0
FD290 Week 3
GA4 190 2200442 290 0
FD291 Week 4
GA5 190 2200442 291 0
GA6 190 2000444 -37 0
GA7 190 2000444 -37 0
GA8 190 2000444 -37 0
GA9 190 2000444 -37 0
GA10 190 2000444 -37 0
FD292 Going out
GA1 191 2080442 292 0
GA2 191 441 1.2 &6 128
GA3 191 441 7.4 &3 151
GA4 191 2000440 2 0
GA5 191 441 1.2 &6 128
GA6 191 2000444 -37 0
GA7 191 2000444 -37 0
GA8 191 2000444 -37 0
GA9 191 2000444 -37 0
GA10 191 2000444 -37 0
FD293 Music
GA1 192 2080442 293 0
GA2 192 441 2.4 &2 152
GA3 192 2000440 6 0
GA4 192 441 4.7 &4 152
GA5 192 2000440 0 0
GA6 192 2000444 -37 0
GA7 192 2000444 -37 0
GA8 192 2000444 -37 0
GA9 192 2000444 -37 0
GA10 192 2000444 -37 0
FD294 Clothing
GA1 193 2080442 294 0
GA2 193 441 6.8 &2 153
GA3 193 2000440 0 0
GA4 193 441 10.6 &4 153
GA5 193 2000440 0 0
GA6 193 2000444 -37 0
GA7 193 2000444 -37 0
GA8 193 2000444 -37 0
GA9 193 2000444 -37 0
GA10 193 2000444 -37 0
FD295 Other
GA1 194 2080442 295 0
GA2 194 2000440 0 0
GA3 194 441 1.4 &3 154
GA4 194 2000440 0 0
GA5 194 441 3.2 &3 72
GA6 194 2000444 -37 0
GA7 194 2000444 -37 0
GA8 194 2000444 -37 0
GA9 194 2000444 -37 0
GA10 194 2000444 -37 0
FD296 Total out
GA1 195 2180442 296 0
GA2 195 1005c1 10.4 &2 47
GA3 195 1005c1 14.8 &2 47
GA4 195 1005c1 17.3 &2 47
GA5 195 1005c1 4.4 &2 47
GA6 195 2000444 -37 0
GA7 195 2000444 -37 0
GA8 195 2000444 -37 0
GA9 195 2000444 -37 0
GA10 195 2000444 -37 0
FD297 Screen 16
GA1 196 2000402 297 0
FD298 Row Totals (Sideways Totals)
GA2 196 2000402 298 0
GA3 196 2000444 -37 0
GA4 196 2000444 -37 0
GA5 196 2000444 -37 0
GA6 196 2000444 -37 0
GA7 196 2000444 -37 0
GA8 196 2000444 -37 0
GA9 196 2000444 -37 0
GA10 196 2000444 -37 0
FD299 a) Click into B207: data entry area shows formula SUM(B203..B206)
GA1 197 2000482 299 0
GA2 197 2000444 -37 0
GA3 197 2000444 -37 0
GA4 197 2000444 -37 0
GA5 197 2000444 -37 0
GA6 197 2000444 -37 0
GA7 197 2000444 -37 0
GA8 197 2000444 -37 0
GA9 197 2000444 -37 0
GA10 197 2000444 -37 0
FD300    totalling a COLUMN. However, SUM( ) works with any BLOCK.
GA1 198 2000482 300 0
GA2 198 2000444 -37 0
GA3 198 2000444 -37 0
GA4 198 2000444 -37 0
GA5 198 2000444 -37 0
GA6 198 2000444 -37 0
GA7 198 2000444 -37 0
GA8 198 2000444 -37 0
GA9 198 2000444 -37 0
GA10 198 2000444 -37 0
FD301 b) Click into F203: data entry line shows formula SUM(B203..E203)
GA1 199 2000482 301 0
GA2 199 2000444 -37 0
GA3 199 2000444 -37 0
GA4 199 2000444 -37 0
GA5 199 2000444 -37 0
GA6 199 2000444 -37 0
GA7 199 2000444 -37 0
GA8 199 2000444 -37 0
GA9 199 2000444 -37 0
GA10 199 2000444 -37 0
FD302    B203 and E203 are in the same row, so this gives a ROW total.
GA1 200 2000482 302 0
GA2 200 2000444 -37 0
GA3 200 2000444 -37 0
GA4 200 2000444 -37 0
GA5 200 2000444 -37 0
GA6 200 2000444 -37 0
GA7 200 2000444 -37 0
GA8 200 2000444 -37 0
GA9 200 2000444 -37 0
GA10 200 2000444 -37 0
FD303 c) Click into F207: here a rectangular BLOCK is totalled.
GA1 201 2000482 303 0
GA2 201 2000444 -37 0
GA3 201 2000444 -37 0
GA4 201 2000444 -37 0
GA5 201 2000444 -37 0
GA6 201 2000444 -37 0
GA7 201 2000444 -37 0
GA8 201 2000444 -37 0
GA9 201 2000444 -37 0
GA10 201 2000444 -37 0
FD304 Expenditure
GA1 202 2280442 304 0
FD305 Week 1
GA2 202 2200442 305 0
FD306 Week 2
GA3 202 2200442 306 0
FD307 Week 3
GA4 202 2200442 307 0
FD308 Week 4
GA5 202 2200442 308 0
FD309 Month Totals
GA6 202 2000402 309 0
GA7 202 2000444 -37 0
GA8 202 2000444 -37 0
GA9 202 2000444 -37 0
GA10 202 2000444 -37 0
FD310 Going out
GA1 203 2080442 310 0
GA2 203 441 1.2 &6 128
GA3 203 441 7.4 &3 151
GA4 203 2000440 2 0
GA5 203 441 1.2 &6 128
GA6 203 3405c1 11.8 =SUM(B203..E203)
GA7 203 2380444 -37 0
GA8 203 2000444 -37 0
GA9 203 2000444 -37 0
GA10 203 2000444 -37 0
FD311 Music
GA1 204 2080442 311 0
GA2 204 441 2.4 &2 152
GA3 204 2000440 6 0
GA4 204 441 4.7 &4 152
GA5 204 2000440 0 0
GA6 204 3405c1 13.1 &6 203
GA7 204 2380444 -37 0
GA8 204 2000444 -37 0
GA9 204 2000444 -37 0
GA10 204 2000444 -37 0
FD312 Clothing
GA1 205 2080442 312 0
GA2 205 441 6.8 &2 153
GA3 205 2000440 0 0
GA4 205 441 10.6 &4 153
GA5 205 2000440 0 0
GA6 205 3405c1 17.4 &6 203
GA7 205 2380444 -37 0
GA8 205 2000444 -37 0
GA9 205 2000444 -37 0
GA10 205 2000444 -37 0
FD313 Other
GA1 206 2080442 313 0
GA2 206 2000440 0 0
GA3 206 441 1.4 &3 154
GA4 206 2000440 0 0
GA5 206 441 3.2 &3 72
GA6 206 3405c1 4.6 &6 203
GA7 206 2380444 -37 0
GA8 206 2000444 -37 0
GA9 206 2000444 -37 0
GA10 206 2000444 -37 0
FD314 Total out
GA1 207 2180442 314 0
GA2 207 1005c1 10.4 &2 47
GA3 207 1005c1 14.8 &2 47
GA4 207 1005c1 17.3 &2 47
GA5 207 1005c1 4.4 &2 47
GA6 207 3405c1 46.9 =SUM(B203..E206)
GA7 207 2380444 -37 0
GA8 207 2000444 -37 0
GA9 207 2000444 -37 0
GA10 207 2000444 -37 0
FD315 ! In what follows, be ready to drag dialogues off instructions  !
GA1 208 2100582 315 0
GA8 208 2000444 -37 0
GA9 208 2000444 -37 0
GA10 208 2000444 -37 0
FD316 Screen 17
GA1 209 2000402 316 0
FD317 Organising charts without reorganising data
GA2 209 2000402 317 0
GA3 209 2000444 -37 0
GA4 209 2000444 -37 0
GA5 209 2000444 -37 0
GA6 209 2000444 -37 0
GA7 209 2000444 -37 0
GA8 209 2000444 -37 0
GA9 209 2000444 -37 0
GA10 209 2000444 -37 0
FD318 a) It's possible to chart column F totals with labels from column A.
GA1 210 2000482 318 0
GA2 210 2000444 -37 0
GA3 210 2000444 -37 0
GA4 210 2000444 -37 0
GA5 210 2000444 -37 0
GA6 210 2000444 -37 0
GA7 210 2000444 -37 0
GA8 210 2000444 -37 0
GA9 210 2000444 -37 0
GA10 210 2000444 -37 0
FD319 b) Select block A216...F220. Click third icon in ribbon.
GA1 211 2000482 319 0
GA2 211 2000444 -37 0
GA3 211 2000444 -37 0
GA4 211 2000444 -37 0
GA5 211 2000444 -37 0
GA6 211 2000444 -37 0
GA7 211 2000444 -37 0
GA8 211 2000444 -37 0
GA9 211 2000444 -37 0
GA10 211 2000444 -37 0
FD320    Click menu arrow in New Graph dialogue. Click on "General".
GA1 212 2000302 320 0
GA2 212 2000444 -37 0
GA3 212 2000444 -37 0
GA4 212 2000444 -37 0
GA5 212 2000444 -37 0
GA6 212 2000444 -37 0
GA7 212 2000444 -37 0
GA8 212 2000444 -37 0
GA9 212 2000444 -37 0
GA10 212 2000444 -37 0
FD321    Click [Data selection] in New Graph dialogue. Click "By column".
GA1 213 2000482 321 0
GA2 213 2000444 -37 0
GA3 213 2000444 -37 0
GA4 213 2000444 -37 0
GA5 213 2000444 -37 0
GA6 213 2000444 -37 0
GA7 213 2000444 -37 0
GA8 213 2000444 -37 0
GA9 213 2000444 -37 0
GA10 213 2000444 -37 0
FD322    Click "Dataset 1" option box. Click menu arrow on same line.
GA1 214 2000482 322 0
GA2 214 2000444 -37 0
GA3 214 2000444 -37 0
GA4 214 2000444 -37 0
GA5 214 2000444 -37 0
GA6 214 2000444 -37 0
GA7 214 2000444 -37 0
GA8 214 2000444 -37 0
GA9 214 2000444 -37 0
GA10 214 2000444 -37 0
FD323    Click "F: Month totals" & [OK]. Click [Graph] in Graph dialogue.
GA1 215 2000482 323 0
GA2 215 2000444 -37 0
GA3 215 2000444 -37 0
GA4 215 2000444 -37 0
GA5 215 2000444 -37 0
GA6 215 2000444 -37 0
GA7 215 2000444 -37 0
GA8 215 2000444 -37 0
GA9 215 2000444 -37 0
GA10 215 2000444 -37 0
FD324 Expenditure
GA1 216 2280442 324 0
FD325 Week 1
GA2 216 2200442 325 0
FD326 Week 2
GA3 216 2200442 326 0
FD327 Week 3
GA4 216 2200442 327 0
FD328 Week 4
GA5 216 2200442 328 0
FD329 Month Totals
GA6 216 2000402 329 0
GA7 216 2000444 -37 0
GA8 216 2000444 -37 0
GA9 216 2000444 -37 0
GA10 216 2000444 -37 0
FD330 Going out
GA1 217 2080442 330 0
GA2 217 441 1.2 &6 128
GA3 217 441 7.4 &3 151
GA4 217 2000440 2 0
GA5 217 441 1.2 &6 128
GA6 217 3405c1 11.8 &6 203
GA7 217 2380444 -37 0
GA8 217 2000444 -37 0
GA9 217 2000444 -37 0
GA10 217 2000444 -37 0
FD331 Music
GA1 218 2080442 331 0
GA2 218 441 2.4 &2 152
GA3 218 2000440 0 0
GA4 218 441 4.7 &4 152
GA5 218 2000440 0 0
GA6 218 3405c1 7.1 &6 203
GA7 218 2380444 -37 0
GA8 218 2000444 -37 0
GA9 218 2000444 -37 0
GA10 218 2000444 -37 0
FD332 Clothing
GA1 219 2080442 332 0
GA2 219 441 6.8 &2 153
GA3 219 2000440 0 0
GA4 219 441 10.6 &4 153
GA5 219 2000440 0 0
GA6 219 3405c1 17.4 &6 203
GA7 219 2380444 -37 0
GA8 219 2000444 -37 0
GA9 219 2000444 -37 0
GA10 219 2000444 -37 0
FD333 Other
GA1 220 2080442 333 0
GA2 220 2000440 0 0
GA3 220 441 1.4 &3 154
GA4 220 2000440 0 0
GA5 220 441 3.2 &3 72
GA6 220 3405c1 4.6 &6 203
GA7 220 2380444 -37 0
GA8 220 2000444 -37 0
GA9 220 2000444 -37 0
GA10 220 2000444 -37 0
FD334 Total out
GA1 221 2180442 334 0
GA2 221 1005c1 10.4 &2 47
GA3 221 1005c1 8.800000000000001 &2 47
GA4 221 1005c1 17.3 &2 47
GA5 221 1005c1 4.4 &2 47
GA6 221 3405c1 40.9 &6 207
GA7 221 2380444 -37 0
GA8 221 2000444 -37 0
GA9 221 2000444 -37 0
GA10 221 2000444 -37 0
FD335 Screen 18
GA1 222 2000402 335 0
FD336 Hot-linking charts
GA2 222 2000402 336 0
GA3 222 2000444 -37 0
GA4 222 2000444 -37 0
GA5 222 2000444 -37 0
GA6 222 2000444 -37 0
GA7 222 2000444 -37 0
GA8 222 2000444 -37 0
GA9 222 2000444 -37 0
GA10 222 2000444 -37 0
FD337 a) Select block A230...B233. Click third icon in ribbon.
GA1 223 2000482 337 0
GA2 223 2000444 -37 0
GA3 223 2000444 -37 0
GA5 223 2000444 -37 0
GA6 223 2000444 -37 0
GA7 223 2000444 -37 0
GA8 223 2000444 -37 0
GA9 223 2000444 -37 0
GA10 223 2000444 -37 0
FD338    Click menu arrow in New Graph dialogue. Click "Horiz.. Histo..".
GA1 224 2000302 338 0
GA2 224 2000444 -37 0
GA3 224 2000444 -37 0
GA4 224 2000444 -37 0
GA5 224 2000444 -37 0
GA6 224 2000444 -37 0
GA7 224 2000444 -37 0
GA8 224 2000444 -37 0
GA9 224 2000444 -37 0
GA10 224 2000444 -37 0
FD339    Click [Options..] in Graph dialogue. Select the block C229..G234
GA1 225 2000482 339 0
GA2 225 2000444 -37 0
GA3 225 2000444 -37 0
GA4 225 2000444 -37 0
GA5 225 2000444 -37 0
GA6 225 2000444 -37 0
GA7 225 2000444 -37 0
GA8 225 2000444 -37 0
GA9 225 2000444 -37 0
GA10 225 2000444 -37 0
FD340    Click [Fit selection]. Click [OK]. Click [Graph] (Graph dialogue)
GA1 226 2000482 340 0
GA2 226 2000444 -37 0
GA3 226 2000444 -37 0
GA4 226 2000444 -37 0
GA5 226 2000444 -37 0
GA6 226 2000444 -37 0
GA7 226 2000444 -37 0
GA8 226 2000444 -37 0
GA9 226 2000444 -37 0
GA10 226 2000444 -37 0
FD341    Click over the block C229..G234. Then with pointer over chart,
GA1 227 2000482 341 0
GA2 227 2000444 -37 0
GA3 227 2000444 -37 0
GA4 227 2000444 -37 0
GA5 227 2000444 -37 0
GA6 227 2000444 -37 0
GA7 227 2000444 -37 0
GA8 227 2000444 -37 0
GA9 227 2000444 -37 0
GA10 227 2000444 -37 0
FD342    Menu => File => Hotlink    - now try new values in B230..B233
GA1 228 2000482 342 0
GA2 228 2000444 -37 0
GA3 228 2000444 -37 0
GA4 228 2000444 -37 0
GA5 228 2000444 -37 0
GA6 228 2000444 -37 0
GA7 228 2000444 -37 0
GA8 228 2000444 -37 0
GA9 228 2000444 -37 0
GA10 228 2000444 -37 0
FD343 Expenditure
GA1 229 2280442 343 0
FD344 Week 1
GA2 229 2200442 344 0
GA8 229 2000444 -37 0
GA9 229 2000444 -37 0
GA10 229 2000444 -37 0
FD345 Going out
GA1 230 2080442 345 0
GA2 230 2000440 4 0
GA8 230 2000444 -37 0
GA9 230 2000444 -37 0
GA10 230 2000444 -37 0
FD346 Music
GA1 231 2080442 346 0
GA2 231 441 2.4 &2 152
GA8 231 2000444 -37 0
GA9 231 2000444 -37 0
GA10 231 2000444 -37 0
FD347 Clothing
GA1 232 2080442 347 0
GA2 232 441 6.8 &2 153
GA8 232 2000444 -37 0
GA9 232 2000444 -37 0
GA10 232 2000444 -37 0
FD348 Other
GA1 233 2080442 348 0
GA2 233 2000440 10 0
GA8 233 2000444 -37 0
GA9 233 2000444 -37 0
GA10 233 2000444 -37 0
FD349 Total out
GA1 234 2180442 349 0
GA2 234 1005c1 23.2 &2 47
GA8 234 2000444 -37 0
GA9 234 2000444 -37 0
GA10 234 2000444 -37 0
ZZ