Acorn User 1

home *** CD-ROM | disk | FTP | other *** search

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

Wrap

Text File | 1994-06-01 | 62.7 KB | 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