home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1989-09-27 | 64.0 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| VangeliSTeam audio library Device (other/vangeliSTeamAudioLibraryDevice)
| ext
| Unsupported |
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 07 00 9a 01 41 01 00 16 | 00 4c 20 6f 66 20 53 68 |....A...|.L of Sh|
|00000010| 61 72 65 73 00 00 00 00 | 00 00 07 00 00 25 00 ff |ares....|.....%..|
|00000020| ff ae 02 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 0f 00 4c 20 50 65 | 72 63 65 6e 74 61 67 65 |....L Pe|rcentage|
|00000050| 00 0d 00 4c 20 20 43 75 | 72 72 65 6e 74 00 28 00 |...L Cu|rrent.(.|
|00000060| ff ff 86 00 75 01 07 00 | ce 07 e7 06 3f 07 c0 07 |....u...|....?...|
|00000070| dc 06 31 07 b4 07 d2 06 | 26 07 a7 07 c6 06 97 07 |..1.....|&.......|
|00000080| b8 06 00 5e 00 00 11 00 | 4c 20 20 43 6f 72 70 6f |...^....|L Corpo|
|00000090| 72 61 74 69 6f 6e 00 25 | 00 ff ff 02 03 00 00 00 |ration.%|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 0d 00 4c 20 |........|......L |
|000000c0| 20 43 75 72 72 65 6e 74 | 00 0d 00 4c 20 44 69 76 | Current|...L Div|
|000000d0| 69 64 65 6e 64 00 11 00 | 4c 20 20 20 59 65 61 72 |idend...|L Year|
|000000e0| 6c 79 00 00 d6 00 00 0d | 00 4c 20 20 20 59 65 61 |ly......|.L Yea|
|000000f0| 72 6c 79 00 0d 00 4c 50 | 75 72 63 68 61 73 65 20 |rly...LP|urchase |
|00000100| 00 25 00 ff ff 60 02 00 | 00 00 00 00 00 00 00 00 |.%...`..|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 0f 00 | 4c 20 20 44 61 74 65 20 |........|L Date |
|00000130| 6f 66 20 20 00 0c 00 4c | 20 43 75 72 72 65 6e 74 |of ...L| Current|
|00000140| 00 f0 ff 00 00 5f 01 00 | 00 00 00 00 00 00 41 01 |....._..|......A.|
|00000150| 80 0e 00 4c 65 20 20 43 | 61 70 69 74 61 6c 00 ea |...Le C|apital..|
|00000160| ff 41 01 af 01 00 00 00 | 00 00 00 00 00 00 00 00 |.A......|........|
|00000170| 00 00 5f 01 80 0b 00 4c | 20 53 79 6d 62 6f 6c 00 |.._....L| Symbol.|
|00000180| 0e 00 4c 20 20 50 75 72 | 63 68 61 73 65 00 0c 00 |..L Pur|chase...|
|00000190| 4c 20 20 4e 75 6d 62 65 | 72 00 f7 ff 2d 03 00 00 |L Numbe|r...-...|
|000001a0| 9a 01 80 0c 00 4c 45 78 | 63 68 61 6e 67 65 00 f7 |.....LEx|change..|
|000001b0| ff 5f 01 03 02 af 01 80 | 4b 00 4c 2d 2d 2d 2d 2d |._......|K.L-----|
|000001c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000001d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000001e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000001f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000200| 2d 2d 00 f7 ff af 01 57 | 02 03 02 80 4b 00 4c 20 |--.....W|....K.L |
|00000210| 20 20 64 61 74 61 20 6f | 6e 20 74 68 69 73 20 73 | data o|n this s|
|00000220| 70 72 65 61 64 73 68 65 | 65 74 20 28 43 54 52 4c |preadshe|et (CTRL|
|00000230| 2d 2d 58 20 6d 20 7b 73 | 65 6c 65 63 74 20 27 6d |--X m {s|elect 'm|
|00000240| 27 20 66 6f 72 20 6d 61 | 6e 75 61 6c 20 6f 70 74 |' for ma|nual opt|
|00000250| 69 6f 6e 7d 29 2e 00 f7 | ff 03 02 a5 02 57 02 80 |ion})...|.....W..|
|00000260| 45 00 4c 20 20 57 65 20 | 72 65 63 6f 6d 6d 65 6e |E.L We |recommen|
|00000270| 64 20 75 73 69 6e 67 20 | 74 68 65 20 6d 61 6e 75 |d using |the manu|
|00000280| 61 6c 20 72 65 63 61 6c | 63 75 6c 61 74 69 6f 6e |al recal|culation|
|00000290| 20 4d 4f 44 45 20 77 68 | 65 6e 20 65 6e 74 65 72 | MODE wh|en enter|
|000002a0| 69 6e 67 20 00 f7 ff 57 | 02 f9 02 a5 02 80 4b 00 |ing ...W|......K.|
|000002b0| 4c 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |L-------|--------|
|000002c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000002d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000002e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000002f0| 2d 2d 2d 2d 2d 2d 2d 2d | 00 f7 ff a5 02 2d 03 f9 |--------|.....-..|
|00000300| 02 80 2b 00 4c 43 6f 70 | 79 72 69 67 68 74 2c 20 |..+.LCop|yright, |
|00000310| 31 39 38 32 2c 20 50 65 | 72 66 65 63 74 20 53 6f |1982, Pe|rfect So|
|00000320| 66 74 77 61 72 65 2c 20 | 49 6e 63 2e 00 f7 ff f9 |ftware, |Inc.....|
|00000330| 02 9a 01 2d 03 80 1e 00 | 4c 20 53 54 4f 43 4b 20 |...-....|L STOCK |
|00000340| 50 4f 52 54 46 4f 4c 49 | 4f 20 45 56 41 4c 55 41 |PORTFOLI|O EVALUA|
|00000350| 54 4f 52 00 55 00 73 74 | 6f 63 6b 00 20 27 49 53 |TOR.U.st|ock. 'IS|
|00000360| 54 4f 43 4b 2e 50 43 00 | 6d 83 07 00 00 48 00 4c |TOCK.PC.|m....H.L|
|00000370| 02 13 16 00 10 00 10 00 | ed 12 d8 12 c3 12 00 00 |........|........|
|00000380| ff ff 02 00 00 00 64 6f | 75 62 6c 65 01 00 01 00 |......do|uble....|
|00000390| 74 65 20 28 01 00 01 00 | 01 00 01 00 09 00 02 00 |te (....|........|
|000003a0| ff ff 01 00 01 00 07 00 | 00 55 00 64 65 66 61 75 |........|.U.defau|
|000003b0| 6c 74 00 2e 44 45 46 41 | 55 4c 54 2e 50 43 00 77 |lt..DEFA|ULT.PC.w|
|000003c0| 6f 75 6c 64 20 00 00 00 | 00 00 00 00 00 00 00 00 |ould ...|........|
|000003d0| 00 00 00 00 00 ff ff 02 | 00 00 00 62 65 72 20 6f |........|...ber o|
|000003e0| 72 01 00 01 00 6f 72 6d | 75 01 00 01 00 01 00 01 |r....orm|u.......|
|000003f0| 00 09 00 02 00 ff ff 01 | 00 01 00 07 00 00 00 00 |........|........|
|00000400| 07 00 00 00 00 00 00 0d | 00 4e 00 00 00 00 00 00 |........|.N......|
|00000410| 00 00 00 00 0c 00 4e 00 | 00 00 00 00 00 00 00 00 |......N.|........|
|00000420| 0c 00 4e 00 00 00 00 00 | 00 00 00 00 0c 00 4e 00 |..N.....|......N.|
|00000430| 00 00 00 00 00 00 00 00 | 0c 00 4e 00 00 00 00 00 |........|..N.....|
|00000440| 00 00 00 00 0c 00 4e 00 | 00 00 00 00 00 00 00 00 |......N.|........|
|00000450| 0c 00 4e 00 00 00 00 00 | 00 00 00 00 0c 00 4e 00 |..N.....|......N.|
|00000460| 00 00 00 00 00 00 00 00 | 0c 00 4e 00 00 00 00 00 |........|..N.....|
|00000470| 00 00 00 00 0c 00 4e 00 | 00 00 00 00 00 00 00 00 |......N.|........|
|00000480| 1f 00 ff ff 9f 04 74 04 | 68 04 5c 04 50 04 44 04 |......t.|h.\.P.D.|
|00000490| 38 04 2c 04 20 04 14 04 | 07 04 f2 0b e6 0b 00 0b |8.,. ...|........|
|000004a0| 00 4c 20 20 20 52 65 6e | 74 00 1f 00 ff ff e8 04 |.L Ren|t.......|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 1f 00 ff ff 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 12 00 4c 20 43 61 73 68 |........|..L Cash|
|000004f0| 20 46 6c 6f 77 20 4f 75 | 74 00 1a 00 46 00 00 00 | Flow Ou|t...F...|
|00000500| 00 00 00 00 00 ff 7f 1e | 0f 28 1c 0d 05 3a 1c 0d |........|.(...:..|
|00000510| 08 29 00 00 1a 00 46 00 | 00 00 00 00 00 00 00 ff |.)....F.|........|
|00000520| 7f 1e 0f 28 1c 0c 05 3a | 1c 0c 08 29 00 00 1a 00 |...(...:|...)....|
|00000530| 46 00 00 00 00 00 00 00 | 00 ff 7f 1e 0f 28 1c 0b |F.......|.....(..|
|00000540| 05 3a 1c 0b 08 29 00 00 | 1a 00 46 00 00 00 00 00 |.:...)..|..F.....|
|00000550| 00 00 00 ff 7f 1e 0f 28 | 1c 0a 05 3a 1c 0a 08 29 |.......(|...:...)|
|00000560| 00 00 1a 00 46 00 00 00 | 00 00 00 00 00 ff 7f 1e |....F...|........|
|00000570| 0f 28 1c 09 05 3a 1c 09 | 08 29 00 00 1a 00 46 00 |.(...:..|.)....F.|
|00000580| 00 00 00 00 00 00 00 ff | 7f 1e 0f 28 1c 08 05 3a |........|...(...:|
|00000590| 1c 08 08 29 00 00 1a 00 | 46 00 00 00 00 00 00 00 |...)....|F.......|
|000005a0| 00 ff 7f 1e 0f 28 1c 07 | 05 3a 1c 07 08 29 00 00 |.....(..|.:...)..|
|000005b0| 1a 00 46 00 00 00 00 00 | 00 00 00 ff 7f 1e 0f 28 |..F.....|.......(|
|000005c0| 1c 06 05 3a 1c 06 08 29 | 00 00 1a 00 46 00 00 00 |...:...)|....F...|
|000005d0| 00 00 00 00 00 ff 7f 1e | 0f 28 1c 05 05 3a 1c 05 |........|.(...:..|
|000005e0| 08 29 00 00 1a 00 46 00 | 00 00 00 00 00 00 00 ff |.)....F.|........|
|000005f0| 7f 1e 0f 28 1c 04 05 3a | 1c 04 08 29 00 00 1a 00 |...(...:|...)....|
|00000600| 46 00 00 00 00 00 00 00 | 00 ff 7f 1e 0f 28 1c 03 |F.......|.....(..|
|00000610| 05 3a 1c 03 08 29 00 00 | 1a 00 46 00 00 00 00 00 |.:...)..|..F.....|
|00000620| 00 00 00 ff 7f 1e 0f 28 | 1c 02 05 3a 1c 02 08 29 |.......(|...:...)|
|00000630| 00 00 1f 00 ff ff 51 06 | 18 06 fe 05 e4 05 ca 05 |......Q.|........|
|00000640| b0 05 96 05 7c 05 62 05 | 48 05 2e 05 14 05 fa 04 |....|.b.|H.......|
|00000650| 00 18 00 4c 20 20 54 6f | 74 61 6c 20 43 61 73 68 |...L To|tal Cash|
|00000660| 20 46 6c 6f 77 20 49 6e | 00 1f 00 ff ff 88 06 00 | Flow In|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 09 00 4c 20 00 74 07 00 |........|..L .t..|
|00000690| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|000006a0| 00 00 00 00 00 00 00 00 | 00 0c 00 4e 00 00 00 00 |........|...N....|
|000006b0| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|000006c0| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|000006d0| 00 00 00 00 00 00 00 00 | 00 0c 00 4e 00 00 00 00 |........|...N....|
|000006e0| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|000006f0| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|00000700| 00 00 00 00 00 00 00 00 | 00 0c 00 4e 00 00 00 00 |........|...N....|
|00000710| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|00000720| 00 1f 00 ff ff 40 07 15 | 07 09 07 fd 06 f1 06 e5 |.....@..|........|
|00000730| 06 d9 06 cd 06 c1 06 b5 | 06 a9 06 9d 06 91 06 00 |........|........|
|00000740| 0c 00 4c 20 20 20 4f 74 | 68 65 72 00 0c 00 4e 00 |..L Ot|her...N.|
|00000750| 00 00 00 00 00 00 00 00 | 0c 00 4e 00 00 00 00 00 |........|..N.....|
|00000760| 00 00 00 00 0c 00 4e 00 | 00 00 00 00 00 00 00 00 |......N.|........|
|00000770| 0c 00 4e 00 00 00 00 00 | 00 00 00 00 0c 00 4e 00 |..N.....|......N.|
|00000780| 00 00 00 00 00 00 00 00 | 0c 00 4e 00 00 00 00 00 |........|..N.....|
|00000790| 00 00 00 00 0c 00 4e 00 | 00 00 00 00 00 00 00 00 |......N.|........|
|000007a0| 0c 00 4e 00 00 00 00 00 | 00 00 00 00 0c 00 4e 00 |..N.....|......N.|
|000007b0| 00 00 00 00 00 00 00 00 | 0c 00 4e 00 00 00 00 00 |........|..N.....|
|000007c0| 00 00 00 00 1f 00 ff ff | e3 07 14 00 07 00 b8 07 |........|........|
|000007d0| ac 07 a0 07 94 07 88 07 | 7c 07 70 07 64 07 58 07 |........||.p.d.X.|
|000007e0| 4c 07 00 1b 00 4c 20 20 | 20 41 63 63 6f 75 6e 74 |L....L | Account|
|000007f0| 73 20 52 65 63 65 69 76 | 61 62 6c 65 73 00 00 00 |s Receiv|ables...|
|00000800| 07 00 00 00 00 00 00 1c | 00 46 00 00 00 00 00 00 |........|.F......|
|00000810| 00 00 ff 7f 1c 0c 0a 2d | 1c 0c 12 00 08 07 00 00 |.......-|........|
|00000820| 07 00 00 16 00 46 00 00 | 00 00 00 00 00 00 ff 7f |.....F..|........|
|00000830| 1c 0b 0a 2d 1c 0b 12 00 | 00 16 00 46 00 00 00 00 |...-....|...F....|
|00000840| 00 00 00 00 ff 7f 1c 0a | 0a 2d 1c 0a 12 00 00 16 |........|.-......|
|00000850| 00 46 00 00 00 00 00 00 | 00 00 ff 7f 1c 09 0a 2d |.F......|.......-|
|00000860| 1c 09 12 00 00 16 00 46 | 00 00 00 00 00 00 00 00 |.......F|........|
|00000870| ff 7f 1c 08 0a 2d 1c 08 | 12 00 00 16 00 46 00 00 |.....-..|.....F..|
|00000880| 00 00 00 00 00 00 ff 7f | 1c 07 0a 2d 1c 07 12 00 |........|...-....|
|00000890| 00 16 00 46 00 00 00 00 | 00 00 00 00 ff 7f 1c 06 |...F....|........|
|000008a0| 0a 2d 1c 06 12 00 00 16 | 00 46 00 00 00 00 00 00 |.-......|.F......|
|000008b0| 00 00 ff 7f 1c 05 0a 2d | 1c 05 12 00 00 16 00 46 |.......-|.......F|
|000008c0| 00 00 00 00 00 00 00 00 | ff 7f 1c 04 0a 2d 1c 04 |........|.....-..|
|000008d0| 12 00 00 16 00 46 00 00 | 00 00 00 00 00 00 ff 7f |.....F..|........|
|000008e0| 1c 03 0a 2d 1c 03 12 00 | 00 16 00 46 00 00 00 00 |...-....|...F....|
|000008f0| 00 00 00 00 ff 7f 1c 02 | 0a 2d 1c 02 12 00 00 1f |........|.-......|
|00000900| 00 ff ff 3d 09 e9 08 d3 | 08 bd 08 a7 08 91 08 7b |...=....|.......{|
|00000910| 08 65 08 4f 08 39 08 23 | 08 07 08 e8 0f 00 1f 00 |.e.O.9.#|........|
|00000920| ff ff 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 1b 00 4c |........|.......L|
|00000940| 20 20 4d 6f 6e 74 68 6c | 79 20 43 61 73 68 20 50 | Monthl|y Cash P|
|00000950| 6f 73 69 74 69 6f 6e 00 | 1f 00 ff ff 96 09 00 00 |osition.|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 1f | 00 ff ff 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000990| 00 00 00 00 00 00 18 00 | 4c 20 54 6f 74 61 6c 20 |........|L Total |
|000009a0| 43 61 73 68 20 46 6c 6f | 77 20 4f 75 74 00 0c 00 |Cash Flo|w Out...|
|000009b0| 4e 00 00 00 00 00 00 00 | 00 00 0c 00 4e 00 00 00 |N.......|....N...|
|000009c0| 00 00 00 00 00 00 0c 00 | 4e 00 00 00 00 00 00 00 |........|N.......|
|000009d0| 00 00 0c 00 4e 00 00 00 | 00 00 00 00 00 00 0c 00 |....N...|........|
|000009e0| 4e 00 00 00 00 00 00 00 | 00 00 0c 00 4e 00 00 00 |N.......|....N...|
|000009f0| 00 00 00 00 00 00 0c 00 | 4e 00 00 00 00 00 00 00 |........|N.......|
|00000a00| 00 00 0c 00 4e 00 00 00 | 00 00 00 00 00 00 0c 00 |....N...|........|
|00000a10| 4e 00 00 00 00 00 00 00 | 00 00 0c 00 4e 00 00 00 |N.......|....N...|
|00000a20| 00 00 00 00 00 00 0c 00 | 4e 00 00 00 00 00 00 00 |........|N.......|
|00000a30| 00 00 0c 00 4e 00 00 00 | 00 00 00 00 00 00 1f 00 |....N...|........|
|00000a40| ff ff 5d 0a 32 0a 26 0a | 1a 0a 0e 0a 02 0a f6 09 |..].2.&.|........|
|00000a50| ea 09 de 09 d2 09 c6 09 | ba 09 ae 09 00 0c 00 4c |........|.......L|
|00000a60| 20 20 20 4f 74 68 65 72 | 00 0c 00 4e 00 00 00 00 | Other|...N....|
|00000a70| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|00000a80| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|00000a90| 00 00 00 00 00 00 00 00 | 00 0c 00 4e 00 00 00 00 |........|...N....|
|00000aa0| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|00000ab0| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 0c 00 4e 00 00 00 00 |........|...N....|
|00000ad0| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|00000ae0| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|00000af0| 00 00 00 00 00 00 00 00 | 00 1f 00 ff ff 18 0b ed |........|........|
|00000b00| 0a e1 0a d5 0a c9 0a bd | 0a b1 0a a5 0a 99 0a 8d |........|........|
|00000b10| 0a 81 0a 75 0a 69 0a 00 | 0f 00 4c 20 20 20 53 75 |...u.i..|..L Su|
|00000b20| 70 70 6c 69 65 73 00 0c | 00 4e 00 00 00 00 00 00 |pplies..|.N......|
|00000b30| 00 00 00 0c 00 4e 00 00 | 00 00 00 00 00 00 00 0c |.....N..|........|
|00000b40| 00 4e 00 00 00 00 00 00 | 00 00 00 0c 00 4e 00 00 |.N......|.....N..|
|00000b50| 00 00 00 00 00 00 00 0c | 00 4e 00 00 00 00 00 00 |........|.N......|
|00000b60| 00 00 00 0c 00 4e 00 00 | 00 00 00 00 00 00 00 0c |.....N..|........|
|00000b70| 00 4e 00 00 00 00 00 00 | 00 00 00 0c 00 4e 00 00 |.N......|.....N..|
|00000b80| 00 00 00 00 00 00 00 0c | 00 4e 00 00 00 00 00 00 |........|.N......|
|00000b90| 00 00 00 0c 00 4e 00 00 | 00 00 00 00 00 00 00 0c |.....N..|........|
|00000ba0| 00 4e 00 00 00 00 00 00 | 00 00 00 0c 00 4e 00 00 |.N......|.....N..|
|00000bb0| 00 00 00 00 00 00 00 1f | 00 ff ff d6 0b ab 0b 9f |........|........|
|00000bc0| 0b 93 0b 87 0b 7b 0b 6f | 0b 63 0b 57 0b 4b 0b 3f |.....{.o|.c.W.K.?|
|00000bd0| 0b 33 0b 27 0b 00 10 00 | 4c 20 20 20 55 74 69 6c |.3.'....|L Util|
|00000be0| 69 74 69 65 73 00 0c 00 | 4e 00 00 00 00 00 00 00 |ities...|N.......|
|00000bf0| 00 00 0c 00 4e 00 00 00 | 00 00 00 00 00 00 00 00 |....N...|........|
|00000c00| 07 00 00 00 00 00 00 0e | 00 ff ff 53 13 07 07 00 |........|...S....|
|00000c10| 00 09 07 00 00 09 00 ff | ff 6d 13 07 00 00 09 00 |........|.m......|
|00000c20| ff ff b5 13 07 00 00 09 | 00 ff ff 30 0c 07 00 00 |........|...0....|
|00000c30| 4c 00 4c 20 74 68 65 20 | 6e 6f 6e 2d 63 75 72 72 |L.L the |non-curr|
|00000c40| 65 6e 74 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |ent spre|adsheet |
|00000c50| 6d 61 79 20 62 65 63 6f | 6d 65 20 6f 75 74 64 61 |may beco|me outda|
|00000c60| 74 65 64 2c 20 69 66 20 | 69 74 20 69 73 20 6e 6f |ted, if |it is no|
|00000c70| 74 20 72 65 67 75 6c 61 | 72 6c 79 00 09 00 ff ff |t regula|rly.....|
|00000c80| 85 0c 07 00 00 4a 00 4c | 20 61 75 74 6f 6d 61 74 |.....J.L| automat|
|00000c90| 69 63 61 6c 6c 79 20 63 | 61 75 73 65 73 20 61 20 |ically c|auses a |
|00000ca0| 72 65 63 61 6c 63 75 6c | 61 74 69 6f 6e 20 69 6e |recalcul|ation in|
|00000cb0| 20 74 68 65 20 6f 74 68 | 65 72 2e 20 20 4f 74 68 | the oth|er. Oth|
|00000cc0| 65 72 77 69 73 65 20 64 | 61 74 61 20 69 6e 00 09 |erwise d|ata in..|
|00000cd0| 00 ff ff d8 0c 07 00 00 | 47 00 4c 20 27 6c 69 6e |........|G.L 'lin|
|00000ce0| 6b 65 64 27 20 6f 72 20 | 27 61 73 73 6f 63 69 61 |ked' or |'associa|
|00000cf0| 74 65 64 27 20 69 6e 20 | 73 75 63 68 20 61 20 77 |ted' in |such a w|
|00000d00| 61 79 20 74 68 61 74 20 | 61 20 72 65 63 61 6c 63 |ay that |a recalc|
|00000d10| 75 6c 61 74 69 6f 6e 20 | 69 6e 20 6f 6e 65 00 09 |ulation |in one..|
|00000d20| 00 ff ff 28 0d 07 00 00 | 48 00 4c 20 73 70 72 65 |...(....|H.L spre|
|00000d30| 61 64 73 68 65 65 74 20 | 66 69 6c 65 73 2e 20 20 |adsheet |files. |
|00000d40| 53 70 72 65 61 64 73 68 | 65 65 74 73 20 77 68 69 |Spreadsh|eets whi|
|00000d50| 63 68 20 72 65 66 65 72 | 65 6e 63 65 20 65 61 63 |ch refer|ence eac|
|00000d60| 68 20 6f 74 68 65 72 20 | 6d 75 73 74 20 62 65 00 |h other |must be.|
|00000d70| 09 00 ff ff 79 0d 07 00 | 00 49 00 4c 20 20 20 20 |....y...|.I.L |
|00000d80| 20 20 20 48 6f 77 65 76 | 65 72 2c 20 6d 6f 72 65 | Howev|er, more|
|00000d90| 20 69 73 20 6e 65 65 64 | 65 64 20 74 68 61 6e 20 | is need|ed than |
|00000da0| 6a 75 73 74 20 63 72 6f | 73 73 2d 72 65 66 65 72 |just cro|ss-refer|
|00000db0| 65 6e 63 65 73 20 62 65 | 74 77 65 65 6e 20 74 68 |ences be|tween th|
|00000dc0| 65 00 09 00 ff ff cb 0d | 07 00 00 3a 00 4c 20 65 |e.......|...:.L e|
|00000dd0| 69 74 68 65 72 20 63 6f | 6d 70 75 74 65 20 74 6f |ither co|mpute to|
|00000de0| 20 27 45 72 72 6f 72 21 | 27 20 6f 72 20 70 72 6f | 'Error!|' or pro|
|00000df0| 64 75 63 65 20 61 20 66 | 61 75 6c 74 79 20 76 61 |duce a f|aulty va|
|00000e00| 0c 00 4e 00 00 00 00 00 | 00 00 00 00 0c 00 4e 00 |..N.....|......N.|
|00000e10| 00 00 00 00 00 00 00 00 | 0c 00 4e 00 00 00 00 00 |........|..N.....|
|00000e20| 00 00 00 00 25 00 ff ff | 00 00 00 00 49 0e 18 0e |....%...|....I...|
|00000e30| 0c 0e 00 0e f4 0d de 0d | 00 00 00 00 d2 0d c6 0d |........|........|
|00000e40| b0 0d 94 0d 7e 0d 68 0d | 00 0c 00 4e 00 00 00 00 |....~.h.|...N....|
|00000e50| 00 00 00 00 00 16 00 46 | 61 6e 67 65 73 20 6d ff |.......F|anges m.|
|00000e60| ff ff 1c 0f 11 2f 1c 0e | 11 00 00 16 00 46 00 00 |...../..|.....F..|
|00000e70| 00 00 00 00 00 00 ff ff | 1c 0d 11 2d 1c 0e 11 00 |........|...-....|
|00000e80| 00 1c 00 46 00 00 00 00 | 00 00 00 00 ff ff 28 1c |...F....|......(.|
|00000e90| 03 11 2a 1c 05 11 29 2b | 1c 06 11 00 00 16 00 46 |..*...)+|.......F|
|00000ea0| 00 00 00 00 00 00 00 00 | ff ff 1c 03 11 2a 1c 04 |........|.....*..|
|00000eb0| 11 00 00 0c 00 4e 00 00 | 00 00 00 00 00 00 00 0c |.....N..|........|
|00000ec0| 00 4e 00 00 00 00 00 00 | 00 00 00 16 00 46 20 20 |.N......|.....F |
|00000ed0| 43 6f 6e 74 72 ff ff ff | 1c 04 11 2f 1c 07 11 00 |Contr...|.../....|
|00000ee0| 00 0c 00 4e 00 00 00 00 | 00 00 00 00 00 0c 00 4e |...N....|.......N|
|00000ef0| 00 00 00 00 00 00 00 00 | 00 0c 00 4e 00 00 00 00 |........|...N....|
|00000f00| 00 00 00 00 00 0c 00 4e | 00 00 00 00 00 00 00 00 |.......N|........|
|00000f10| 00 25 00 ff ff 00 00 00 | 00 36 0f 05 0f f9 0e ed |.%......|.6......|
|00000f20| 0e e1 0e cb 0e 00 00 00 | 00 bf 0e b3 0e 9d 0e 81 |........|........|
|00000f30| 0e 6b 0e 55 0e 00 0c 00 | 4e 00 00 00 00 00 00 00 |.k.U....|N.......|
|00000f40| 00 00 16 00 46 63 74 65 | 72 00 3a 00 ff ff ff 1c |....Fcte|r.:.....|
|00000f50| 0f 10 2f 1c 0e 10 00 00 | 16 00 46 00 00 00 00 00 |../.....|..F.....|
|00000f60| 00 00 00 ff ff 1c 0d 10 | 2d 1c 0e 10 00 00 1c 00 |........|-.......|
|00000f70| 46 00 00 00 00 00 00 00 | 00 ff ff 28 1c 03 10 2a |F.......|...(...*|
|00000f80| 1c 05 10 29 2b 1c 06 10 | 00 00 16 00 46 00 00 00 |...)+...|....F...|
|00000f90| 00 00 00 00 00 ff ff 1c | 03 10 2a 1c 04 10 00 00 |........|..*.....|
|00000fa0| 0c 00 4e 00 00 00 00 00 | 00 00 00 00 0c 00 4e 00 |..N.....|......N.|
|00000fb0| 00 00 00 00 00 00 00 00 | 16 00 46 6e 65 00 40 00 |........|..Fne.@.|
|00000fc0| 4c 20 ff ff ff 1c 04 10 | 2f 1c 07 10 00 00 0c 00 |L ......|/.......|
|00000fd0| 4e 00 00 00 00 00 00 00 | 00 00 0c 00 4e 00 00 00 |N.......|....N...|
|00000fe0| 00 00 00 00 00 00 0c 00 | 4e 00 00 00 00 00 00 00 |........|N.......|
|00000ff0| 00 00 0c 00 4e 00 00 00 | 00 00 00 00 00 00 00 00 |....N...|........|
|00001000| 07 00 00 00 00 00 00 0e | 00 ff ff be 17 65 79 07 |........|.....ey.|
|00001010| 00 00 07 00 00 09 00 ff | ff 1e 10 07 00 00 28 00 |........|......(.|
|00001020| 4c 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 |L | C|
|00001030| 6f 6e 74 72 6f 6c 2d 2d | 78 20 20 43 6f 6e 74 72 |ontrol--|x Contr|
|00001040| 6f 6c 2d 2d 66 00 09 00 | ff ff 4f 10 07 00 00 46 |ol--f...|..O....F|
|00001050| 00 4c 20 20 20 20 20 54 | 68 65 6e 20 66 69 6e 64 |.L T|hen find|
|00001060| 20 74 68 65 20 27 62 3a | 73 74 6f 63 6b 65 78 2e | the 'b:|stockex.|
|00001070| 70 63 27 20 66 69 6c 65 | 20 77 69 74 68 20 74 68 |pc' file| with th|
|00001080| 65 20 46 49 4e 44 20 46 | 49 4c 45 20 43 6f 6d 6d |e FIND F|ILE Comm|
|00001090| 61 6e 64 3a 00 09 00 ff | ff 9e 10 07 00 00 35 00 |and:....|......5.|
|000010a0| 4c 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L | |
|000010b0| 20 20 20 20 43 6f 6e 74 | 72 6f 6c 2d 2d 78 20 20 | Cont|rol--x |
|000010c0| 6f 20 28 74 68 65 20 6c | 65 74 74 65 72 20 27 6f |o (the l|etter 'o|
|000010d0| 27 29 00 09 00 ff ff dc | 10 07 00 00 14 00 4c 20 |')......|......L |
|000010e0| 57 49 4e 44 4f 57 20 43 | 6f 6d 6d 61 6e 64 2e 00 |WINDOW C|ommand..|
|000010f0| 09 00 ff ff f9 10 07 00 | 00 46 00 4c 20 77 69 6e |........|.F.L win|
|00001100| 64 6f 77 2e 20 20 54 68 | 69 73 20 72 65 71 75 69 |dow. Th|is requi|
|00001110| 72 65 73 20 79 6f 75 20 | 67 6f 20 74 6f 20 74 68 |res you |go to th|
|00001120| 65 20 4f 74 68 65 72 20 | 57 69 6e 64 6f 77 20 75 |e Other |Window u|
|00001130| 73 69 6e 67 20 74 68 65 | 20 4f 54 48 45 52 00 09 |sing the| OTHER..|
|00001140| 00 ff ff 51 11 07 00 00 | 09 00 ff ff 00 00 07 00 |...Q....|........|
|00001150| 00 4a 00 4c 20 20 20 20 | 52 65 74 72 69 65 76 65 |.J.L |Retrieve|
|00001160| 20 61 20 63 6f 70 79 20 | 6f 66 20 74 68 65 20 27 | a copy |of the '|
|00001170| 62 3a 73 74 6f 63 6b 65 | 78 2e 70 63 27 20 66 69 |b:stocke|x.pc' fi|
|00001180| 6c 65 20 61 6e 64 20 70 | 6c 61 63 65 20 69 74 20 |le and p|lace it |
|00001190| 69 6e 20 74 68 65 20 74 | 6f 70 00 09 00 ff ff ad |in the t|op......|
|000011a0| 11 07 00 00 09 00 ff ff | 00 00 07 00 00 4c 00 4c |........|.....L.L|
|000011b0| 20 20 20 20 20 20 20 20 | 20 20 43 6f 6e 74 72 6f | | Contro|
|000011c0| 6c 2d 2d 78 20 20 32 20 | 20 7b 61 6e 73 77 65 72 |l--x 2 | {answer|
|000011d0| 20 6e 6f 20 74 6f 20 74 | 68 65 20 27 53 79 6e 63 | no to t|he 'Sync|
|000011e0| 68 72 6f 6e 69 7a 65 20 | 57 69 6e 64 6f 77 73 27 |hronize |Windows'|
|000011f0| 20 70 72 6f 6d 70 74 7d | 00 09 00 ff ff 02 12 07 | prompt}|........|
|00001200| 00 00 15 00 4c 20 57 49 | 4e 44 4f 57 53 20 43 6f |....L WI|NDOWS Co|
|00001210| 6d 6d 61 6e 64 3a 00 09 | 00 ff ff 32 12 07 00 00 |mmand:..|...2....|
|00001220| 09 00 ff ff 00 00 07 00 | 00 09 00 ff ff 00 00 07 |........|........|
|00001230| 00 00 48 00 4c 20 20 20 | 20 20 20 42 65 67 69 6e |..H.L | Begin|
|00001240| 20 62 79 20 6d 6f 76 69 | 6e 67 20 74 68 65 20 63 | by movi|ng the c|
|00001250| 75 72 73 6f 72 20 74 6f | 20 6c 69 6e 65 20 31 31 |ursor to| line 11|
|00001260| 20 61 6e 64 20 65 6e 74 | 65 72 20 74 68 65 20 43 | and ent|er the C|
|00001270| 52 45 41 54 45 20 54 57 | 4f 00 09 00 ff ff 83 12 |REATE TW|O.......|
|00001280| 07 00 00 40 00 4c 20 20 | 20 20 20 20 20 20 20 20 |...@.L | |
|00001290| 20 20 20 20 4c 45 53 53 | 4f 4e 33 20 2d 2d 20 53 | LESS|ON3 -- S|
|000012a0| 74 6f 72 69 6e 67 20 26 | 20 50 72 69 6e 74 69 6e |toring &| Printin|
|000012b0| 67 20 59 6f 75 72 20 53 | 70 72 65 61 64 73 68 65 |g Your S|preadshe|
|000012c0| 65 74 00 15 00 66 ff ff | ff ff ff ff ff ff ff ff |et...f..|........|
|000012d0| ff ff ff ff ff ff 00 00 | 15 00 20 17 ff 0a ff ff |........|.. .....|
|000012e0| 0b ff 07 09 ff ff ff ff | ff 0c 0a 00 00 15 00 74 |........|.......t|
|000012f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00001300| 00 00 31 00 74 07 99 00 | 1f 00 03 01 db 07 f4 06 |..1.t...|........|
|00001310| 4f 07 60 00 95 06 a8 05 | bb 04 c5 0b d8 0a eb 09 |O.`.....|........|
|00001320| fe 08 09 08 13 0f 26 0e | 36 0d cb 0c c1 13 9c 13 |......&.|6.......|
|00001330| 07 00 00 55 00 6c 65 73 | 73 6f 6e 33 00 72 4c 45 |...U.les|son3.rLE|
|00001340| 53 53 4f 4e 33 2e 50 43 | 00 73 70 6c 61 79 69 f9 |SSON3.PC|.splayi.|
|00001350| 32 80 00 01 00 01 00 59 | 2c 50 2c 47 2c 00 00 ff |2......Y|,P,G,...|
|00001360| ff 02 00 00 00 00 4c 20 | 6c 69 6e 01 00 01 00 64 |......L |lin....d|
|00001370| 20 74 68 01 00 01 00 01 | 00 01 00 09 00 02 00 ff | th.....|........|
|00001380| ff 01 00 01 00 07 00 00 | 12 00 46 00 00 00 00 00 |........|..F.....|
|00001390| 00 00 00 ff ff 1c 27 14 | 00 00 25 00 ff ff e4 13 |......'.|..%.....|
|000013a0| 88 13 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 25 |........|.......%|
|000013c0| 00 ff ff 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013e0| 00 00 00 00 1a 00 4c 20 | 20 20 20 20 20 43 55 52 |......L | CUR|
|000013f0| 52 45 4e 54 20 45 51 55 | 49 54 59 20 3d 00 00 00 |RENT EQU|ITY =...|
|00001400| 07 00 00 00 00 00 00 51 | 00 4c 20 20 20 20 20 20 |.......Q|.L |
|00001410| 20 50 65 72 66 65 63 74 | 20 43 61 6c 63 20 70 72 | Perfect| Calc pr|
|00001420| 6f 76 69 64 65 73 20 74 | 77 6f 20 63 6f 6d 6d 61 |ovides t|wo comma|
|00001430| 6e 64 73 20 66 6f 72 20 | 73 74 6f 72 69 6e 67 20 |nds for |storing |
|00001440| 79 6f 75 72 20 73 70 72 | 65 61 64 73 68 65 65 74 |your spr|eadsheet|
|00001450| 2e 00 20 73 69 07 00 00 | 09 00 ff ff 61 14 07 00 |.. si...|....a...|
|00001460| 00 09 00 4c 00 00 09 07 | 00 00 09 00 ff ff 73 14 |...L....|......s.|
|00001470| 07 00 00 3c 00 4c 20 4f | 56 45 52 57 52 49 54 45 |...<.L O|VERWRITE|
|00001480| 53 20 74 68 65 20 6f 72 | 69 67 69 6e 61 6c 20 66 |S the or|iginal f|
|00001490| 69 6c 65 20 77 69 74 68 | 20 74 68 65 20 6d 6f 64 |ile with| the mod|
|000014a0| 69 66 69 65 64 20 76 65 | 72 73 69 6f 6e 2e 00 09 |ified ve|rsion...|
|000014b0| 00 ff ff b8 14 07 00 00 | 3f 00 4c 20 74 68 65 20 |........|?.L the |
|000014c0| 66 69 6c 65 20 62 79 20 | 77 72 69 74 69 6e 67 20 |file by |writing |
|000014d0| 69 74 20 6f 6e 74 6f 20 | 74 68 65 20 64 69 73 6b |it onto |the disk|
|000014e0| 65 74 74 65 2c 20 61 20 | 70 72 6f 63 65 73 73 20 |ette, a |process |
|000014f0| 77 68 69 63 68 20 00 09 | 00 ff ff 00 15 07 00 00 |which ..|........|
|00001500| 4c 00 4c 20 6f 72 69 67 | 69 6e 61 6c 20 76 65 72 |L.L orig|inal ver|
|00001510| 73 69 6f 6e 20 75 6e 74 | 69 6c 20 79 6f 75 20 65 |sion unt|il you e|
|00001520| 6e 74 65 72 20 74 68 65 | 20 53 41 56 45 20 46 49 |nter the| SAVE FI|
|00001530| 4c 45 20 43 6f 6d 6d 61 | 6e 64 20 77 68 69 63 68 |LE Comma|nd which|
|00001540| 20 74 68 65 6e 20 73 61 | 76 65 73 00 09 00 ff ff | then sa|ves.....|
|00001550| 55 15 07 00 00 47 00 4c | 20 41 6e 79 20 63 68 61 |U....G.L| Any cha|
|00001560| 6e 67 65 73 20 79 6f 75 | 20 6d 61 6b 65 20 74 6f |nges you| make to|
|00001570| 20 74 68 65 20 63 6f 70 | 79 20 69 6e 20 74 68 65 | the cop|y in the|
|00001580| 20 62 75 66 66 65 72 20 | 64 6f 65 73 20 6e 6f 74 | buffer |does not|
|00001590| 20 61 66 66 65 63 74 20 | 74 68 65 00 09 00 ff ff | affect |the.....|
|000015a0| a5 15 07 00 00 4a 00 4c | 20 61 20 27 63 6f 70 79 |.....J.L| a 'copy|
|000015b0| 27 20 6f 66 20 74 68 65 | 20 6f 72 69 67 69 6e 61 |' of the| origina|
|000015c0| 6c 20 73 70 72 65 61 64 | 73 68 65 65 74 20 77 68 |l spread|sheet wh|
|000015d0| 69 63 68 20 73 74 69 6c | 6c 20 72 65 6d 61 69 6e |ich stil|l remain|
|000015e0| 73 20 6f 6e 20 64 69 73 | 6b 65 74 74 65 2e 00 09 |s on dis|kette...|
|000015f0| 00 ff ff f8 15 07 00 00 | 3c 00 4c 20 69 6e 20 74 |........|<.L in t|
|00001600| 68 65 20 20 6d 65 6d 6f | 72 79 20 62 75 66 66 65 |he memo|ry buffe|
|00001610| 72 2c 20 74 68 65 20 73 | 70 72 65 61 64 73 68 65 |r, the s|preadshe|
|00001620| 65 74 20 72 65 70 72 65 | 73 65 6e 74 73 20 6f 6e |et repre|sents on|
|00001630| 6c 79 20 00 09 00 ff ff | 3d 16 07 00 00 44 00 4c |ly .....|=....D.L|
|00001640| 20 69 73 20 63 6f 70 69 | 65 64 20 69 6e 74 6f 20 | is copi|ed into |
|00001650| 61 20 74 65 6d 70 6f 72 | 61 72 79 20 77 6f 72 6b |a tempor|ary work|
|00001660| 20 73 70 61 63 65 20 63 | 61 6c 6c 65 64 20 61 20 | space c|alled a |
|00001670| 27 62 75 66 66 65 72 27 | 2e 20 20 57 68 69 6c 65 |'buffer'|. While|
|00001680| 00 09 00 ff ff 93 16 07 | 00 00 09 00 ff ff 00 00 |........|........|
|00001690| 07 00 00 49 00 4c 20 20 | 20 20 20 57 68 65 6e 20 |...I.L | When |
|000016a0| 79 6f 75 20 72 65 61 64 | 20 61 20 66 69 6c 65 20 |you read| a file |
|000016b0| 66 72 6f 6d 20 64 69 73 | 6b 65 74 74 65 20 69 6e |from dis|kette in|
|000016c0| 74 6f 20 74 68 65 20 63 | 6f 6d 70 75 74 65 72 27 |to the c|omputer'|
|000016d0| 73 20 6d 65 6d 6f 72 79 | 20 69 74 00 09 00 ff ff |s memory| it.....|
|000016e0| ee 16 07 00 00 09 00 ff | ff 00 00 07 00 00 4b 00 |........|......K.|
|000016f0| 4c 20 20 41 73 20 62 65 | 66 6f 72 65 2c 20 73 63 |L As be|fore, sc|
|00001700| 72 6f 6c 6c 20 74 68 65 | 20 62 6f 74 74 6f 77 20 |roll the| bottow |
|00001710| 77 69 6e 64 6f 77 20 77 | 69 74 68 20 74 68 65 20 |window w|ith the |
|00001720| 27 4f 74 68 65 72 20 57 | 69 6e 64 6f 77 27 20 63 |'Other W|indow' c|
|00001730| 6f 6d 6d 61 6e 64 73 2e | 00 09 00 ff ff 42 17 07 |ommands.|.....B..|
|00001740| 00 00 32 00 4c 20 20 6c | 6f 63 61 74 65 64 20 6f |..2.L l|ocated o|
|00001750| 6e 7d 2c 20 20 66 6f 6c | 6c 6f 77 65 64 20 62 79 |n}, fol|lowed by|
|00001760| 20 61 20 63 61 72 72 69 | 61 67 65 20 72 65 74 75 | a carri|age retu|
|00001770| 72 6e 2e 00 09 00 ff ff | 7d 17 07 00 00 41 00 4c |rn......|}....A.L|
|00001780| 20 20 27 62 3a 73 74 6f | 63 6b 65 78 2e 70 63 27 | 'b:sto|ckex.pc'|
|00001790| 20 7b 52 65 6d 65 6d 62 | 65 72 20 74 6f 20 67 69 | {Rememb|er to gi|
|000017a0| 76 65 20 74 68 65 20 64 | 69 73 6b 20 64 72 69 76 |ve the d|isk driv|
|000017b0| 65 20 74 68 65 20 66 69 | 6c 65 20 69 73 00 40 00 |e the fi|le is.@.|
|000017c0| 4c 20 20 20 57 68 65 6e | 20 50 65 72 66 65 63 74 |L When| Perfect|
|000017d0| 20 43 61 6c 63 20 72 65 | 73 70 6f 6e 64 73 2c 20 | Calc re|sponds, |
|000017e0| 22 46 69 6c 65 20 74 6f | 20 66 69 6e 64 20 3c 43 |"File to| find <C|
|000017f0| 52 3e 3a 20 22 2c 20 65 | 6e 74 65 72 3a 00 00 00 |R>: ", e|nter:...|
|00001800| 07 00 00 00 00 00 00 4a | 00 4c 20 66 69 6c 65 73 |.......J|.L files|
|00001810| 20 73 61 76 65 64 20 6f | 6e 20 64 69 73 6b 2d 2d | saved o|n disk--|
|00001820| 74 68 65 20 6f 72 69 67 | 69 6e 61 6c 20 61 6e 64 |the orig|inal and|
|00001830| 20 74 68 65 20 6d 6f 64 | 69 66 69 65 64 20 63 6f | the mod|ified co|
|00001840| 70 79 29 2e 20 20 4c 65 | 74 20 75 73 20 00 07 00 |py). Le|t us ...|
|00001850| 00 09 00 ff ff 5a 18 07 | 00 00 49 00 4c 20 73 70 |.....Z..|..I.L sp|
|00001860| 72 65 61 64 73 68 65 65 | 74 20 6f 6e 20 64 69 73 |readshee|t on dis|
|00001870| 6b 20 75 6e 64 65 72 20 | 74 68 65 20 6f 72 69 67 |k under |the orig|
|00001880| 69 6e 61 6c 20 66 69 6c | 65 6e 61 6d 65 2e 20 28 |inal fil|ename. (|
|00001890| 54 68 65 20 72 65 73 75 | 6c 74 20 69 73 20 74 77 |The resu|lt is tw|
|000018a0| 6f 20 00 09 00 ff ff ac | 18 07 00 00 48 00 4c 20 |o ......|....H.L |
|000018b0| 44 49 46 46 45 52 45 4e | 54 20 66 69 6c 65 20 6e |DIFFEREN|T file n|
|000018c0| 61 6d 65 2c 20 74 68 65 | 72 65 62 79 20 70 72 65 |ame, the|reby pre|
|000018d0| 73 65 72 76 69 6e 67 20 | 74 68 65 20 6f 72 69 67 |serving |the orig|
|000018e0| 69 6e 61 6c 20 76 65 72 | 73 69 6f 6e 20 6f 66 20 |inal ver|sion of |
|000018f0| 74 68 65 00 09 00 ff ff | fd 18 07 00 00 49 00 4c |the.....|.....I.L|
|00001900| 20 46 49 4c 45 20 43 6f | 6d 6d 61 6e 64 2c 20 77 | FILE Co|mmand, w|
|00001910| 68 69 63 68 20 61 6c 6c | 6f 77 73 20 79 6f 75 20 |hich all|ows you |
|00001920| 74 6f 20 73 61 76 65 20 | 61 20 73 70 72 65 61 64 |to save |a spread|
|00001930| 73 68 65 65 74 20 74 6f | 20 64 69 73 6b 20 75 6e |sheet to| disk un|
|00001940| 64 65 72 20 61 00 09 00 | ff ff 4f 19 07 00 00 49 |der a...|..O....I|
|00001950| 00 4c 20 20 20 20 20 20 | 20 54 68 65 20 73 65 63 |.L | The sec|
|00001960| 6f 6e 64 20 63 6f 6d 6d | 61 6e 64 20 66 6f 72 20 |ond comm|and for |
|00001970| 73 74 6f 72 69 6e 67 20 | 61 20 73 70 72 65 61 64 |storing |a spread|
|00001980| 73 68 65 65 74 20 66 69 | 6c 65 20 69 73 20 74 68 |sheet fi|le is th|
|00001990| 65 20 57 52 49 54 45 00 | 09 00 ff ff a1 19 07 00 |e WRITE.|........|
|000019a0| 00 22 00 4c 20 64 75 72 | 69 6e 67 20 6c 6f 6e 67 |.".L dur|ing long|
|000019b0| 20 65 64 69 74 69 6e 67 | 20 73 65 73 73 69 6f 6e | editing| session|
|000019c0| 73 2e 00 09 00 ff ff cc | 19 07 00 00 47 00 4c 20 |s.......|....G.L |
|000019d0| 74 68 65 20 53 41 56 45 | 20 46 49 4c 45 20 43 6f |the SAVE| FILE Co|
|000019e0| 6d 6d 61 6e 64 20 67 75 | 61 72 64 73 20 61 67 61 |mmand gu|ards aga|
|000019f0| 69 6e 73 74 20 61 63 63 | 69 64 65 6e 74 61 6c 20 |inst acc|idental |
|00001a00| 6c 6f 73 73 65 73 20 6f | 66 20 6e 65 77 20 64 61 |losses o|f new da|
|00001a10| 74 61 00 09 00 ff ff 1c | 1a 07 00 00 4b 00 4c 20 |ta......|....K.L |
|00001a20| 6f 72 69 67 69 6e 61 6c | 20 76 65 72 73 69 6f 6e |original| version|
|00001a30| 20 6f 66 20 74 68 65 20 | 73 70 72 65 61 64 73 68 | of the |spreadsh|
|00001a40| 65 65 74 20 77 61 73 20 | 74 68 65 72 65 20 62 65 |eet was |there be|
|00001a50| 66 6f 72 65 2e 20 20 49 | 66 20 75 73 65 64 20 6f |fore. I|f used o|
|00001a60| 66 74 65 6e 2c 20 00 09 | 00 ff ff 70 1a 07 00 00 |ften, ..|...p....|
|00001a70| 4c 00 4c 20 20 20 20 20 | 20 20 50 65 72 66 65 63 |L.L | Perfec|
|00001a80| 74 20 43 61 6c 63 20 63 | 6f 70 69 65 73 20 74 68 |t Calc c|opies th|
|00001a90| 65 20 73 70 72 65 61 64 | 73 68 65 65 74 20 74 6f |e spread|sheet to|
|00001aa0| 20 64 69 73 6b 2c 20 6f | 76 65 72 77 72 69 74 69 | disk, o|verwriti|
|00001ab0| 6e 67 20 77 68 61 74 65 | 76 65 72 00 09 00 ff ff |ng whate|ver.....|
|00001ac0| c5 1a 07 00 00 3e 00 4c | 20 70 72 6f 63 65 73 73 |.....>.L| process|
|00001ad0| 20 69 74 20 64 69 73 70 | 6c 61 79 73 20 74 68 65 | it disp|lays the|
|00001ae0| 20 6d 65 73 73 61 67 65 | 3a 20 20 22 57 72 69 74 | message|: "Writ|
|00001af0| 69 6e 67 20 53 54 4f 43 | 4b 45 58 2e 50 43 2e 2e |ing STOC|KEX.PC..|
|00001b00| 2e 22 00 09 00 ff ff 0c | 1b 07 00 00 49 00 4c 20 |."......|....I.L |
|00001b10| 20 20 20 20 50 65 72 66 | 65 63 74 20 43 61 6c 63 | Perf|ect Calc|
|00001b20| 20 62 65 67 69 6e 73 20 | 73 61 76 69 6e 67 20 74 | begins |saving t|
|00001b30| 68 65 20 73 70 72 65 61 | 64 73 68 65 65 74 20 74 |he sprea|dsheet t|
|00001b40| 6f 20 64 69 73 6b 2e 20 | 20 44 75 72 69 6e 67 20 |o disk. | During |
|00001b50| 74 68 69 73 00 09 00 ff | ff 5e 1b 07 00 00 2c 00 |this....|.^....,.|
|00001b60| 4c 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L | |
|00001b70| 20 20 20 43 6f 6e 74 72 | 6f 6c 2d 2d 78 20 20 43 | Contr|ol--x C|
|00001b80| 6f 6e 74 72 6f 6c 2d 2d | 73 00 09 00 ff ff 93 1b |ontrol--|s.......|
|00001b90| 07 00 00 12 00 4c 20 65 | 64 69 74 69 6e 67 20 74 |.....L e|diting t|
|00001ba0| 79 70 65 3a 00 09 00 ff | ff ae 1b 07 00 00 47 00 |ype:....|......G.|
|00001bb0| 4c 20 54 68 65 20 66 69 | 72 73 74 20 69 73 20 74 |L The fi|rst is t|
|00001bc0| 68 65 20 53 41 56 45 20 | 46 49 4c 45 20 43 6f 6d |he SAVE |FILE Com|
|00001bd0| 6d 61 6e 64 2e 20 20 41 | 74 20 61 6e 79 74 69 6d |mand. A|t anytim|
|00001be0| 65 20 64 75 72 69 6e 67 | 20 73 70 72 65 61 64 73 |e during| spreads|
|00001bf0| 68 65 65 74 00 09 00 ff | ff 07 14 07 00 00 00 00 |heet....|........|
|00001c00| 07 00 00 00 00 00 00 0b | 00 ff ff 6d 23 00 00 07 |........|...m#...|
|00001c10| 00 00 09 00 ff ff 1b 1c | 07 00 00 0d 00 4c 20 50 |........|.....L P|
|00001c20| 52 49 4e 54 49 4e 47 00 | 09 00 ff ff 31 1c 07 00 |RINTING.|....1...|
|00001c30| 00 15 00 4c 20 77 72 69 | 74 74 65 6e 20 74 6f 20 |...L wri|tten to |
|00001c40| 64 69 73 6b 2e 00 09 00 | ff ff b5 23 07 00 00 09 |disk....|...#....|
|00001c50| 00 ff ff 58 1c 07 00 00 | 48 00 4c 20 6e 6f 77 20 |...X....|H.L now |
|00001c60| 63 61 6c 6c 65 64 20 27 | 73 74 6f 63 6b 74 77 6f |called '|stocktwo|
|00001c70| 2e 70 63 27 2c 20 61 6e | 64 20 68 65 72 65 61 66 |.pc', an|d hereaf|
|00001c80| 74 65 72 2c 20 73 68 6f | 75 6c 64 20 61 20 53 41 |ter, sho|uld a SA|
|00001c90| 56 45 20 46 49 4c 45 20 | 43 6f 6d 6d 61 6e 64 00 |VE FILE |Command.|
|00001ca0| 09 00 ff ff a9 1c 07 00 | 00 48 00 4c 20 6d 6f 64 |........|.H.L mod|
|00001cb0| 69 66 69 65 64 20 76 65 | 72 73 69 6f 6e 2c 20 27 |ified ve|rsion, '|
|00001cc0| 73 74 6f 63 6b 74 77 6f | 2e 70 63 27 20 2e 20 20 |stocktwo|.pc' . |
|00001cd0| 54 68 65 20 66 69 6c 65 | 20 79 6f 75 20 61 72 65 |The file| you are|
|00001ce0| 20 77 6f 72 6b 69 6e 67 | 20 77 69 74 68 20 69 73 | working| with is|
|00001cf0| 00 09 00 ff ff fa 1c 07 | 00 00 4a 00 4c 20 69 6e |........|..J.L in|
|00001d00| 20 74 77 6f 20 66 69 6c | 65 20 6c 6f 63 61 74 69 | two fil|e locati|
|00001d10| 6f 6e 73 3a 20 20 74 68 | 65 20 6f 6c 64 20 76 65 |ons: th|e old ve|
|00001d20| 72 73 69 6f 6e 2c 20 27 | 73 74 6f 63 6b 65 78 2e |rsion, '|stockex.|
|00001d30| 70 63 27 2c 20 61 6e 64 | 20 74 68 65 20 6e 65 77 |pc', and| the new|
|00001d40| 6c 79 20 00 09 00 ff ff | 4d 1d 07 00 00 4b 00 4c |ly .....|M....K.L|
|00001d50| 20 74 6f 20 74 68 65 20 | 73 70 72 65 61 64 73 68 | to the |spreadsh|
|00001d60| 65 65 74 20 74 6f 20 63 | 6f 6e 74 69 6e 75 65 20 |eet to c|ontinue |
|00001d70| 77 6f 72 6b 69 6e 67 2e | 20 20 54 68 65 20 73 70 |working.| The sp|
|00001d80| 72 65 61 64 73 68 65 65 | 74 20 6e 6f 77 20 65 78 |readshee|t now ex|
|00001d90| 69 73 74 73 20 69 6e 00 | 09 00 ff ff a1 1d 07 00 |ists in.|........|
|00001da0| 00 49 00 4c 20 20 20 20 | 20 20 20 41 66 74 65 72 |.I.L | After|
|00001db0| 20 74 68 65 20 77 72 69 | 74 65 20 6f 70 65 72 61 | the wri|te opera|
|00001dc0| 74 69 6f 6e 20 69 73 20 | 63 6f 6d 70 6c 65 74 65 |tion is |complete|
|00001dd0| 20 50 65 72 66 65 63 74 | 20 43 61 6c 63 20 72 65 | Perfect| Calc re|
|00001de0| 74 75 72 6e 73 20 79 6f | 75 00 09 00 ff ff f3 1d |turns yo|u.......|
|00001df0| 07 00 00 34 00 4c 20 20 | 20 20 20 20 20 20 20 20 |...4.L | |
|00001e00| 20 20 20 20 20 20 20 20 | 20 20 20 20 22 57 72 69 | | "Wri|
|00001e10| 74 69 6e 67 20 42 3a 53 | 54 4f 43 4b 54 57 4f 2e |ting B:S|TOCKTWO.|
|00001e20| 50 43 2e 2e 2e 22 00 09 | 00 ff ff 30 1e 07 00 00 |PC..."..|...0....|
|00001e30| 41 00 4c 20 6e 61 6d 65 | 2e 20 20 44 75 72 69 6e |A.L name|. Durin|
|00001e40| 67 20 74 68 69 73 20 77 | 72 69 74 65 20 6f 70 65 |g this w|rite ope|
|00001e50| 72 61 74 69 6f 6e 20 74 | 68 65 20 6d 65 73 73 61 |ration t|he messa|
|00001e60| 67 65 20 69 73 20 64 69 | 73 70 6c 61 79 65 64 3a |ge is di|splayed:|
|00001e70| 00 09 00 ff ff 7a 1e 07 | 00 00 49 00 4c 20 20 20 |.....z..|..I.L |
|00001e80| 20 20 20 20 50 65 72 66 | 65 63 74 20 43 61 6c 63 | Perf|ect Calc|
|00001e90| 20 77 72 69 74 65 73 20 | 74 68 65 20 73 70 72 65 | writes |the spre|
|00001ea0| 61 64 73 68 65 65 74 20 | 74 6f 20 64 69 73 6b 20 |adsheet |to disk |
|00001eb0| 75 6e 64 65 72 20 74 68 | 65 20 6e 65 77 20 66 69 |under th|e new fi|
|00001ec0| 6c 65 00 09 00 ff ff cc | 1e 07 00 00 4d 00 4c 20 |le......|....M.L |
|00001ed0| 54 79 70 65 20 61 20 6e | 65 77 20 66 69 6c 65 6e |Type a n|ew filen|
|00001ee0| 61 6d 65 20 66 6f 72 20 | 74 68 65 20 53 74 6f 63 |ame for |the Stoc|
|00001ef0| 6b 20 50 6f 72 74 66 6f | 6c 69 6f 20 73 70 72 65 |k Portfo|lio spre|
|00001f00| 61 64 73 68 65 65 74 2c | 20 27 62 3a 73 74 6f 63 |adsheet,| 'b:stoc|
|00001f10| 6b 74 77 6f 2e 70 63 27 | 00 09 00 ff ff 22 1f 07 |ktwo.pc'|....."..|
|00001f20| 00 00 32 00 4c 20 20 20 | 20 20 20 20 20 20 20 20 |..2.L | |
|00001f30| 20 20 20 20 20 20 20 20 | 20 20 20 20 22 57 72 69 | | "Wri|
|00001f40| 74 65 20 74 6f 20 66 69 | 6c 65 3a 20 3c 43 52 3e |te to fi|le: <CR>|
|00001f50| 20 20 22 00 09 00 ff ff | 5d 1f 07 00 00 32 00 4c | ".....|]....2.L|
|00001f60| 20 20 20 20 20 20 20 50 | 65 72 66 65 63 74 20 43 | P|erfect C|
|00001f70| 61 6c 63 20 72 65 73 70 | 6f 6e 64 73 20 77 69 74 |alc resp|onds wit|
|00001f80| 68 20 74 68 65 20 6d 65 | 73 73 61 67 65 3a 00 09 |h the me|ssage:..|
|00001f90| 00 ff ff 98 1f 07 00 00 | 2f 00 4c 20 20 20 20 20 |........|/.L |
|00001fa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001fb0| 43 6f 6e 74 72 6f 6c 2d | 2d 78 20 20 43 6f 6e 74 |Control-|-x Cont|
|00001fc0| 72 6f 6c 2d 2d 77 00 09 | 00 ff ff d0 1f 07 00 00 |rol--w..|........|
|00001fd0| 25 00 4c 20 70 72 61 63 | 74 69 63 65 20 74 68 65 |%.L prac|tice the|
|00001fe0| 20 57 52 49 54 45 20 46 | 49 4c 45 20 43 6f 6d 6d | WRITE F|ILE Comm|
|00001ff0| 61 6e 64 3a 00 09 00 ff | ff 07 18 07 00 00 00 00 |and:....|........|
|00002000| 07 00 00 00 00 00 00 4f | 00 4c 20 68 61 76 65 20 |.......O|.L have |
|00002010| 6d 61 6e 79 20 6c 69 6e | 65 73 29 2c 20 69 74 20 |many lin|es), it |
|00002020| 6d 61 79 20 74 61 6b 65 | 20 73 65 76 65 72 61 6c |may take| several|
|00002030| 20 70 61 67 65 73 20 74 | 6f 20 70 72 69 6e 74 20 | pages t|o print |
|00002040| 74 68 65 20 66 69 72 73 | 74 20 73 63 72 65 65 6e |the firs|t screen|
|00002050| 2d 00 74 07 00 00 09 00 | ff ff 5f 20 07 00 00 48 |-.t.....|.._ ...H|
|00002060| 00 4c 20 73 65 63 6f 6e | 64 20 38 30 20 63 68 61 |.L secon|d 80 cha|
|00002070| 72 61 63 74 65 72 2d 63 | 6f 6c 75 6d 6e 73 2e 20 |racter-c|olumns. |
|00002080| 20 46 6f 72 20 73 70 72 | 65 61 64 73 68 65 65 74 | For spr|eadsheet|
|00002090| 73 20 74 68 61 74 20 61 | 72 65 20 6c 6f 6e 67 20 |s that a|re long |
|000020a0| 28 69 2e 65 2e 2c 00 09 | 00 ff ff b0 20 07 00 00 |(i.e.,..|.... ...|
|000020b0| 4a 00 4c 20 38 30 20 63 | 68 61 72 61 63 74 65 72 |J.L 80 c|haracter|
|000020c0| 2d 63 6f 6c 75 6d 6e 73 | 20 69 6e 20 74 68 65 69 |-columns| in thei|
|000020d0| 72 20 65 6e 74 69 72 65 | 74 79 20 62 65 66 6f 72 |r entire|ty befor|
|000020e0| 65 20 70 72 6f 63 65 65 | 64 69 6e 67 20 74 6f 20 |e procee|ding to |
|000020f0| 70 72 69 6e 74 20 74 68 | 65 00 09 00 ff ff 03 21 |print th|e......!|
|00002100| 07 00 00 4c 00 4c 20 79 | 6f 75 72 20 70 72 69 6e |...L.L y|our prin|
|00002110| 74 65 72 2e 20 20 50 65 | 72 66 65 63 74 20 43 61 |ter. Pe|rfect Ca|
|00002120| 6c 63 20 70 72 69 6e 74 | 73 20 62 79 20 63 6f 6c |lc print|s by col|
|00002130| 75 6d 6e 73 2e 20 20 49 | 74 20 77 69 6c 6c 20 70 |umns. I|t will p|
|00002140| 72 69 6e 74 20 74 68 65 | 20 66 69 72 73 74 00 09 |rint the| first..|
|00002150| 00 ff ff 58 21 07 00 00 | 4b 00 4c 20 20 20 20 20 |...X!...|K.L |
|00002160| 20 20 20 48 69 74 20 61 | 20 63 61 72 72 69 61 67 | Hit a| carriag|
|00002170| 65 20 72 65 74 75 72 6e | 2e 20 20 50 65 72 66 65 |e return|. Perfe|
|00002180| 63 74 20 43 61 6c 63 20 | 6f 75 74 70 75 74 73 20 |ct Calc |outputs |
|00002190| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|000021a0| 74 6f 00 09 00 ff ff ac | 21 07 00 00 47 00 4c 20 |to......|!...G.L |
|000021b0| 20 20 50 65 72 66 65 63 | 74 20 43 61 6c 63 20 72 | Perfec|t Calc r|
|000021c0| 65 73 70 6f 6e 64 73 20 | 77 69 74 68 20 74 68 65 |esponds |with the|
|000021d0| 20 6d 65 73 73 61 67 65 | 3a 20 20 20 22 50 72 69 | message|: "Pri|
|000021e0| 6e 74 20 74 6f 20 66 69 | 6c 65 3a 20 3c 43 52 3e |nt to fi|le: <CR>|
|000021f0| 20 22 00 09 00 ff ff fc | 21 07 00 00 2a 00 4c 20 | "......|!...*.L |
|00002200| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|00002210| 6f 6e 74 72 6f 6c 2d 2d | 78 20 20 43 6f 6e 74 72 |ontrol--|x Contr|
|00002220| 6f 6c 2d 2d 70 00 09 00 | ff ff 2f 22 07 00 00 45 |ol--p...|../"...E|
|00002230| 00 4c 20 6e 6f 20 70 72 | 69 6e 74 65 72 2c 20 69 |.L no pr|inter, i|
|00002240| 67 6e 6f 72 65 20 74 68 | 65 20 70 72 69 6e 74 20 |gnore th|e print |
|00002250| 63 6f 6d 6d 61 6e 64 73 | 2e 20 20 45 6e 74 65 72 |commands|. Enter|
|00002260| 20 74 68 65 20 50 52 49 | 4e 54 20 43 6f 6d 6d 61 | the PRI|NT Comma|
|00002270| 6e 64 3a 00 09 00 ff ff | 7d 22 07 00 00 4c 00 4c |nd:.....|}"...L.L|
|00002280| 20 4d 61 6b 65 20 73 75 | 72 65 20 79 6f 75 72 20 | Make su|re your |
|00002290| 70 72 69 6e 74 65 72 20 | 69 73 20 74 75 72 6e 65 |printer |is turne|
|000022a0| 64 20 6f 6e 20 61 6e 64 | 20 70 72 6f 70 65 72 6c |d on and| properl|
|000022b0| 79 20 61 74 74 61 63 68 | 65 64 2e 20 20 49 66 20 |y attach|ed. If |
|000022c0| 79 6f 75 20 68 61 76 65 | 00 09 00 ff ff d2 22 07 |you have|......".|
|000022d0| 00 00 4a 00 4c 20 73 68 | 65 65 74 2c 20 6f 72 20 |..J.L sh|eet, or |
|000022e0| 61 6e 79 20 64 65 66 69 | 6e 65 64 20 72 65 67 69 |any defi|ned regi|
|000022f0| 6f 6e 20 6f 66 20 69 74 | 2e 20 20 4c 65 74 20 75 |on of it|. Let u|
|00002300| 73 20 70 72 69 6e 74 20 | 27 73 74 6f 63 6b 74 77 |s print |'stocktw|
|00002310| 6f 2e 70 63 27 20 6e 6f | 77 2e 20 00 09 00 ff ff |o.pc' no|w. .....|
|00002320| 25 23 07 00 00 48 00 4c | 20 61 74 20 61 6e 79 74 |%#...H.L| at anyt|
|00002330| 69 6d 65 20 64 75 72 69 | 6e 67 20 65 64 69 74 69 |ime duri|ng editi|
|00002340| 6e 67 2e 20 20 59 6f 75 | 20 63 61 6e 20 70 72 69 |ng. You| can pri|
|00002350| 6e 74 20 65 69 74 68 65 | 72 20 74 68 65 20 65 6e |nt eithe|r the en|
|00002360| 74 69 72 65 20 73 70 72 | 65 61 64 2d 00 48 00 4c |tire spr|ead-.H.L|
|00002370| 20 20 20 20 20 20 20 50 | 72 69 6e 74 69 6e 67 20 | P|rinting |
|00002380| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|00002390| 69 73 20 76 65 72 79 20 | 73 69 6d 70 6c 65 2c 20 |is very |simple, |
|000023a0| 61 6e 64 20 63 61 6e 20 | 62 65 20 70 65 72 66 6f |and can |be perfo|
|000023b0| 72 6d 65 64 00 49 00 4c | 20 62 65 20 67 69 76 65 |rmed.I.L| be give|
|000023c0| 6e 2c 20 50 65 72 66 65 | 63 74 20 43 61 6c 63 20 |n, Perfe|ct Calc |
|000023d0| 77 69 6c 6c 20 6f 76 65 | 72 77 72 69 74 65 20 74 |will ove|rwrite t|
|000023e0| 68 65 20 6e 65 77 20 76 | 65 72 73 69 6f 6e 20 79 |he new v|ersion y|
|000023f0| 6f 75 20 68 61 76 65 20 | 6a 75 73 74 20 00 00 00 |ou have |just ...|
|00002400| 07 00 00 00 00 00 00 33 | 00 4c 20 20 20 20 20 20 |.......3|.L |
|00002410| 20 4e 6f 77 2c 20 74 79 | 70 65 20 74 68 65 20 50 | Now, ty|pe the P|
|00002420| 52 49 4e 54 20 52 45 47 | 49 4f 4e 20 43 6f 6d 6d |RINT REG|ION Comm|
|00002430| 61 6e 64 3a 00 00 09 07 | 00 00 09 00 ff ff 43 24 |and:....|......C$|
|00002440| 07 00 00 1b 00 4c 20 72 | 65 67 69 6f 6e 20 74 6f |.....L r|egion to|
|00002450| 20 62 65 20 70 72 69 6e | 74 65 64 2e 29 00 09 00 | be prin|ted.)...|
|00002460| ff ff 70 24 07 00 00 09 | 00 ff ff 00 00 07 00 00 |..p$....|........|
|00002470| 45 00 4c 20 28 54 68 65 | 20 6e 65 77 20 70 6f 73 |E.L (The| new pos|
|00002480| 69 74 69 6f 6e 20 6f 66 | 20 74 68 65 20 63 75 72 |ition of| the cur|
|00002490| 73 6f 72 20 6d 61 72 6b | 73 20 74 68 65 20 6f 74 |sor mark|s the ot|
|000024a0| 68 65 72 20 62 6f 75 6e | 64 61 72 79 20 6f 66 20 |her boun|dary of |
|000024b0| 74 68 65 20 00 09 00 ff | ff be 24 07 00 00 24 00 |the ....|..$...$.|
|000024c0| 4c 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |L | |
|000024d0| 20 20 20 20 20 20 20 45 | 73 63 61 70 65 2e 2e 2e | E|scape...|
|000024e0| 3e 00 09 00 ff ff eb 24 | 07 00 00 14 00 4c 20 43 |>......$|.....L C|
|000024f0| 4f 4c 55 4d 4e 20 43 6f | 6d 6d 61 6e 64 3a 00 09 |OLUMN Co|mmand:..|
|00002500| 00 ff ff 08 25 07 00 00 | 4a 00 4c 20 20 20 20 20 |....%...|J.L |
|00002510| 20 20 4d 6f 76 65 20 74 | 68 65 20 63 75 72 73 6f | Move t|he curso|
|00002520| 72 20 74 6f 20 74 68 65 | 20 62 6f 74 74 6f 6d 20 |r to the| bottom |
|00002530| 6f 66 20 74 68 65 20 63 | 6f 6c 75 6d 6e 20 75 73 |of the c|olumn us|
|00002540| 69 6e 67 20 74 68 65 20 | 42 4f 54 54 4f 4d 20 4f |ing the |BOTTOM O|
|00002550| 46 00 09 00 ff ff 5b 25 | 07 00 00 35 00 4c 20 20 |F.....[%|...5.L |
|00002560| 20 20 20 20 20 50 65 72 | 66 65 63 74 20 43 61 6c | Per|fect Cal|
|00002570| 63 20 72 65 73 70 6f 6e | 64 73 3a 20 20 22 4d 61 |c respon|ds: "Ma|
|00002580| 72 6b 20 73 65 74 20 61 | 74 20 61 31 22 20 2e 00 |rk set a|t a1" ..|
|00002590| 09 00 ff ff 99 25 07 00 | 00 4c 00 4c 20 20 20 20 |.....%..|.L.L |
|000025a0| 20 20 20 20 20 20 20 20 | 20 45 73 63 61 70 65 2e | | Escape.|
|000025b0| 2e 2e 3c 73 70 61 63 65 | 20 62 61 72 3e 20 20 7b |..<space| bar> {|
|000025c0| 74 68 65 20 6c 6f 6e 67 | 20 62 61 72 20 75 73 65 |the long| bar use|
|000025d0| 64 20 66 6f 72 20 74 79 | 70 69 6e 67 20 73 70 61 |d for ty|ping spa|
|000025e0| 63 65 73 7d 00 09 00 ff | ff ee 25 07 00 00 3a 00 |ces}....|..%...:.|
|000025f0| 4c 20 20 20 20 20 20 20 | 53 65 74 20 61 20 62 6f |L |Set a bo|
|00002600| 75 6e 64 61 72 79 20 6d | 61 72 6b 20 75 73 69 6e |undary m|ark usin|
|00002610| 67 20 74 68 65 20 4d 41 | 52 4b 20 53 45 54 20 43 |g the MA|RK SET C|
|00002620| 6f 6d 6d 61 6e 64 3a 00 | 09 00 ff ff 3a 26 07 00 |ommand:.|....:&..|
|00002630| 00 09 00 ff ff 00 00 07 | 00 00 27 00 4c 20 20 20 |........|..'.L |
|00002640| 20 20 20 20 50 6f 73 69 | 74 69 6f 6e 20 74 68 65 | Posi|tion the|
|00002650| 20 63 75 72 73 6f 72 20 | 61 74 20 27 61 31 27 2e | cursor |at 'a1'.|
|00002660| 00 09 00 ff ff 6a 26 07 | 00 00 3d 00 4c 20 77 6f |.....j&.|..=.L wo|
|00002670| 72 6b 73 20 62 79 20 70 | 72 69 6e 74 69 6e 67 20 |rks by p|rinting |
|00002680| 74 68 65 20 66 69 72 73 | 74 20 63 6f 6c 75 6d 6e |the firs|t column|
|00002690| 20 6f 66 20 6f 75 72 20 | 73 70 72 65 61 64 73 68 | of our |spreadsh|
|000026a0| 65 65 74 2e 20 20 00 09 | 00 ff ff b0 26 07 00 00 |eet. ..|....&...|
|000026b0| 4c 00 4c 20 43 6f 6d 6d | 61 6e 64 2c 20 79 6f 75 |L.L Comm|and, you|
|000026c0| 20 6d 75 73 74 20 64 65 | 66 69 6e 65 20 74 68 65 | must de|fine the|
|000026d0| 20 72 65 67 69 6f 6e 20 | 74 6f 20 62 65 20 70 72 | region |to be pr|
|000026e0| 69 6e 74 65 64 2e 20 20 | 4c 65 74 20 75 73 20 73 |inted. |Let us s|
|000026f0| 65 65 20 68 6f 77 20 74 | 68 69 73 00 09 00 ff ff |ee how t|his.....|
|00002700| 05 27 07 00 00 48 00 4c | 20 65 78 61 63 74 6c 79 |.'...H.L| exactly|
|00002710| 20 74 68 65 20 73 61 6d | 65 20 77 61 79 2c 20 65 | the sam|e way, e|
|00002720| 78 63 65 70 74 20 74 68 | 61 74 20 62 65 66 6f 72 |xcept th|at befor|
|00002730| 65 20 65 78 65 63 75 74 | 69 6e 67 20 74 68 65 20 |e execut|ing the |
|00002740| 50 52 49 4e 54 20 52 45 | 47 49 4f 4e 00 09 00 ff |PRINT RE|GION....|
|00002750| ff 5f 27 07 00 00 09 00 | ff ff 00 00 07 00 00 44 |._'.....|.......D|
|00002760| 00 4c 20 20 20 20 20 20 | 20 50 72 69 6e 74 69 6e |.L | Printin|
|00002770| 67 20 61 20 27 72 65 67 | 69 6f 6e 27 20 6f 66 20 |g a 'reg|ion' of |
|00002780| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|00002790| 69 73 20 61 63 63 6f 6d | 70 6c 69 73 68 65 64 20 |is accom|plished |
|000027a0| 69 6e 00 09 00 ff ff ac | 27 07 00 00 49 00 4c 20 |in......|'...I.L |
|000027b0| 66 75 6c 20 6f 66 20 63 | 6f 6c 75 6d 6e 73 2c 20 |ful of c|olumns, |
|000027c0| 62 65 66 6f 72 65 20 6d | 6f 76 69 6e 67 20 6f 6e |before m|oving on|
|000027d0| 20 74 6f 20 70 72 69 6e | 74 20 74 68 65 20 6e 65 | to prin|t the ne|
|000027e0| 78 74 20 67 72 6f 75 70 | 20 6f 66 20 63 6f 6c 75 |xt group| of colu|
|000027f0| 6d 6e 73 2e 00 09 00 ff | ff 07 20 07 00 00 00 00 |mns.....|.. .....|
|00002800| 07 00 00 00 00 00 00 09 | 00 ff ff 63 2e 07 00 00 |........|...c....|
|00002810| 09 00 ff ff 00 00 07 00 | 00 09 00 ff ff a8 2e 07 |........|........|
|00002820| 00 00 09 00 ff ff dd 2e | 07 00 00 09 00 ff ff 22 |........|......."|
|00002830| 2f 07 00 00 09 00 ff ff | 6a 2f 07 00 00 09 00 ff |/.......|j/......|
|00002840| ff b3 2f 07 00 00 09 00 | ff ff 4f 28 07 00 00 4b |../.....|..O(...K|
|00002850| 00 4c 20 62 65 20 61 63 | 63 65 73 73 65 64 20 62 |.L be ac|cessed b|
|00002860| 79 20 50 65 72 66 65 63 | 74 20 57 72 69 74 65 72 |y Perfec|t Writer|
|00002870| 2e 20 20 28 50 65 72 66 | 65 63 74 20 57 72 69 74 |. (Perf|ect Writ|
|00002880| 65 72 20 75 73 65 73 20 | 74 68 65 20 73 75 66 66 |er uses |the suff|
|00002890| 69 78 20 22 2e 6d 73 73 | 22 00 09 00 ff ff a3 28 |ix ".mss|"......(|
|000028a0| 07 00 00 44 00 4c 20 74 | 68 65 20 6d 65 73 73 61 |...D.L t|he messa|
|000028b0| 67 65 20 22 50 72 69 6e | 74 20 74 6f 20 66 69 6c |ge "Prin|t to fil|
|000028c0| 65 22 2c 20 20 73 75 70 | 70 6c 79 20 61 20 66 69 |e", sup|ply a fi|
|000028d0| 6c 65 20 6e 61 6d 65 20 | 74 68 61 74 20 63 61 6e |le name |that can|
|000028e0| 20 6c 61 74 65 72 00 09 | 00 ff ff f0 28 07 00 00 | later..|....(...|
|000028f0| 4b 00 4c 20 63 6f 6d 6d | 61 6e 64 73 20 61 73 20 |K.L comm|ands as |
|00002900| 79 6f 75 20 77 6f 75 6c | 64 20 6e 6f 72 6d 61 6c |you woul|d normal|
|00002910| 6c 79 2c 20 65 78 63 65 | 70 74 20 74 68 61 74 20 |ly, exce|pt that |
|00002920| 77 68 65 6e 20 50 65 72 | 66 65 63 74 20 43 61 6c |when Per|fect Cal|
|00002930| 63 20 70 72 65 73 65 6e | 74 73 00 09 00 ff ff 44 |c presen|ts.....D|
|00002940| 29 07 00 00 4a 00 4c 20 | 72 65 70 6f 72 74 20 74 |)...J.L |report t|
|00002950| 68 61 74 20 79 6f 75 20 | 61 72 65 20 70 72 65 70 |hat you |are prep|
|00002960| 61 72 69 6e 67 20 77 69 | 74 68 20 50 65 72 66 65 |aring wi|th Perfe|
|00002970| 63 74 20 57 72 69 74 65 | 72 2e 20 20 45 78 65 63 |ct Write|r. Exec|
|00002980| 75 74 65 20 74 68 65 20 | 70 72 69 6e 74 00 09 00 |ute the |print...|
|00002990| ff ff 97 29 07 00 00 48 | 00 4c 20 64 69 73 6b 20 |...)...H|.L disk |
|000029a0| 69 73 20 63 6f 6e 76 65 | 6e 69 65 6e 74 20 20 77 |is conve|nient w|
|000029b0| 68 65 6e 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 |hen you |want to |
|000029c0| 69 6e 63 6c 75 64 65 20 | 79 6f 75 72 20 73 70 72 |include |your spr|
|000029d0| 65 61 64 73 68 65 65 74 | 20 69 6e 20 61 20 00 09 |eadsheet| in a ..|
|000029e0| 00 ff ff e8 29 07 00 00 | 47 00 4c 20 69 73 20 73 |....)...|G.L is s|
|000029f0| 74 6f 72 65 64 20 75 73 | 69 6e 67 20 74 68 65 20 |tored us|ing the |
|00002a00| 57 52 49 54 45 20 46 49 | 4c 45 20 6f 72 20 53 41 |WRITE FI|LE or SA|
|00002a10| 56 45 20 46 49 4c 45 20 | 43 6f 6d 6d 61 6e 64 73 |VE FILE |Commands|
|00002a20| 2e 20 20 50 72 69 6e 74 | 69 6e 67 20 74 6f 00 09 |. Print|ing to..|
|00002a30| 00 ff ff 38 2a 07 00 00 | 4a 00 4c 20 74 6f 20 64 |...8*...|J.L to d|
|00002a40| 69 73 6b 20 61 73 20 61 | 20 27 73 63 72 65 65 6e |isk as a| 'screen|
|00002a50| 20 69 6d 61 67 65 27 2e | 20 20 54 68 69 73 20 69 | image'.| This i|
|00002a60| 73 20 75 6e 6c 69 6b 65 | 20 74 68 65 20 66 6f 72 |s unlike| the for|
|00002a70| 6d 20 69 6e 20 77 68 69 | 63 68 20 61 20 66 69 6c |m in whi|ch a fil|
|00002a80| 65 00 09 00 ff ff 8b 2a | 07 00 00 4b 00 4c 20 20 |e......*|...K.L |
|00002a90| 20 20 20 20 20 49 74 20 | 69 73 20 70 6f 73 73 69 | It |is possi|
|00002aa0| 62 6c 65 20 74 6f 20 70 | 72 69 6e 74 20 74 68 65 |ble to p|rint the|
|00002ab0| 20 73 70 72 65 61 64 73 | 68 65 65 74 2c 20 6f 72 | spreads|heet, or|
|00002ac0| 20 61 6e 79 20 70 6f 72 | 74 69 6f 6e 20 74 68 65 | any por|tion the|
|00002ad0| 72 65 6f 66 2c 00 09 00 | ff ff fa 2a 07 00 00 09 |reof,...|...*....|
|00002ae0| 00 ff ff 00 00 07 00 00 | 09 00 ff ff 00 00 07 00 |........|........|
|00002af0| 00 09 00 ff ff 00 00 07 | 00 00 22 00 4c 20 20 50 |........|..".L P|
|00002b00| 52 49 4e 54 49 4e 47 20 | 54 4f 20 27 50 45 52 46 |RINTING |TO 'PERF|
|00002b10| 45 43 54 20 57 52 49 54 | 45 52 27 00 09 00 ff ff |ECT WRIT|ER'.....|
|00002b20| 25 2b 07 00 00 35 00 4c | 20 72 65 74 75 72 6e 2e |%+...5.L| return.|
|00002b30| 20 20 50 65 72 66 65 63 | 74 20 43 61 6c 63 20 70 | Perfec|t Calc p|
|00002b40| 72 69 6e 74 73 20 74 68 | 65 20 64 65 66 69 6e 65 |rints th|e define|
|00002b50| 64 20 72 65 67 69 6f 6e | 2e 00 09 00 ff ff 6c 2b |d region|......l+|
|00002b60| 07 00 00 09 00 ff ff 00 | 00 07 00 00 46 00 4c 20 |........|....F.L |
|00002b70| 20 20 20 20 20 20 57 68 | 65 6e 20 50 65 72 66 65 | Wh|en Perfe|
|00002b80| 63 74 20 43 61 6c 63 20 | 72 65 73 70 6f 6e 64 73 |ct Calc |responds|
|00002b90| 20 22 50 72 69 6e 74 20 | 74 6f 20 66 69 6c 65 22 | "Print |to file"|
|00002ba0| 2c 20 74 79 70 65 20 61 | 20 63 61 72 72 69 61 67 |, type a| carriag|
|00002bb0| 65 00 09 00 ff ff c4 2b | 07 00 00 09 00 ff ff 00 |e......+|........|
|00002bc0| 00 07 00 00 28 00 4c 20 | 20 20 20 20 20 20 20 20 |....(.L | |
|00002bd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 43 6f 6e | | Con|
|00002be0| 74 72 6f 6c 2d 2d 78 20 | 20 20 70 00 09 00 ff ff |trol--x | p.....|
|00002bf0| 07 24 07 00 00 09 00 ff | ff 00 00 07 00 00 00 00 |.$......|........|
|00002c00| 07 00 00 00 00 00 00 0a | 00 ff ff 2a 32 00 07 00 |........|...*2...|
|00002c10| 00 09 00 ff ff 71 32 07 | 00 00 09 00 ff ff 00 00 |.....q2.|........|
|00002c20| 07 00 00 09 00 ff ff 00 | 00 07 00 00 09 00 ff ff |........|........|
|00002c30| b4 32 07 00 00 09 00 ff | ff 00 00 07 00 00 09 00 |.2......|........|
|00002c40| ff ff 00 00 07 00 00 09 | 00 20 ff 79 20 07 00 00 |........|. .y ...|
|00002c50| 09 00 72 ff 61 67 07 00 | 00 09 00 75 ff 6e 2e 07 |..r.ag..|...u.n..|
|00002c60| 00 00 55 00 6c 65 73 73 | 6f 6e 34 00 00 4c 45 53 |..U.less|on4..LES|
|00002c70| 53 4f 4e 34 2e 50 43 00 | 72 66 65 63 74 20 be 64 |SON4.PC.|rfect .d|
|00002c80| e5 00 01 00 01 00 b5 64 | ac 64 a3 64 00 00 ff ff |.......d|.d.d....|
|00002c90| 02 00 00 00 6f 20 46 69 | 6e 64 01 00 01 00 3e 3a |....o Fi|nd....>:|
|00002ca0| 20 22 01 00 01 00 01 00 | 01 00 09 00 02 00 ff ff | "......|........|
|00002cb0| 01 00 01 00 07 00 00 09 | 00 ff ff c9 2c 07 00 00 |........|....,...|
|00002cc0| 09 00 ff ff 00 00 07 00 | 00 29 00 4c 20 20 20 20 |........|.).L |
|00002cd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002ce0| 20 20 45 4e 44 20 4f 46 | 20 4c 45 53 53 4f 4e 20 | END OF| LESSON |
|00002cf0| 33 00 09 00 ff ff fb 2c | 07 00 00 13 00 4c 20 74 |3......,|.....L t|
|00002d00| 68 69 73 20 73 65 73 73 | 69 6f 6e 3f 22 00 09 00 |his sess|ion?"...|
|00002d10| ff ff 20 2d 07 00 00 09 | 00 ff ff 00 00 07 00 00 |.. -....|........|
|00002d20| 49 00 4c 20 20 20 20 20 | 41 6e 73 77 65 72 20 27 |I.L |Answer '|
|00002d30| 79 27 20 66 6f 72 20 79 | 65 73 20 74 6f 20 50 65 |y' for y|es to Pe|
|00002d40| 72 66 65 63 74 20 43 61 | 6c 63 27 73 20 71 75 65 |rfect Ca|lc's que|
|00002d50| 73 74 69 6f 6e 3a 20 20 | 22 49 67 6e 6f 72 65 20 |stion: |"Ignore |
|00002d60| 63 68 61 6e 67 65 73 20 | 00 09 00 ff ff 7b 2d 07 |changes |.....{-.|
|00002d70| 00 00 09 00 ff ff 00 00 | 07 00 00 2a 00 4c 20 20 |........|...*.L |
|00002d80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 43 6f | | Co|
|00002d90| 6e 74 72 6f 6c 2d 2d 78 | 20 20 43 6f 6e 74 72 6f |ntrol--x| Contro|
|00002da0| 6c 2d 2d 63 00 09 00 ff | ff ae 2d 07 00 00 12 00 |l--c....|..-.....|
|00002db0| 4c 20 51 55 49 54 20 43 | 6f 6d 6d 61 6e 64 3a 00 |L QUIT C|ommand:.|
|00002dc0| 09 00 ff ff d2 2d 07 00 | 00 09 00 ff ff 00 00 07 |.....-..|........|
|00002dd0| 00 00 44 00 4c 20 20 20 | 20 20 20 20 49 66 20 79 |..D.L | If y|
|00002de0| 6f 75 20 64 6f 20 6e 6f | 74 20 77 69 73 68 20 74 |ou do no|t wish t|
|00002df0| 6f 20 63 6f 6e 74 69 6e | 75 65 20 77 69 74 68 20 |o contin|ue with |
|00002e00| 74 68 65 20 6c 65 73 73 | 6f 6e 73 2c 20 74 79 70 |the less|ons, typ|
|00002e10| 65 20 74 68 65 00 09 00 | ff ff 28 2e 07 00 00 09 |e the...|..(.....|
|00002e20| 00 ff ff 00 00 07 00 00 | 3b 00 4c 20 20 20 20 20 |........|;.L |
|00002e30| 20 54 68 65 20 46 49 4e | 44 20 46 49 4c 45 20 43 | The FIN|D FILE C|
|00002e40| 6f 6d 6d 61 6e 64 20 69 | 73 3a 20 20 43 6f 6e 74 |ommand i|s: Cont|
|00002e50| 72 6f 6c 2d 2d 78 20 20 | 43 6f 6e 74 72 6f 6c 2d |rol--x |Control-|
|00002e60| 2d 66 00 45 00 4c 20 20 | 20 20 20 20 54 68 65 20 |-f.E.L | The |
|00002e70| 43 4c 45 41 52 20 45 4e | 54 49 52 45 20 4d 45 4d |CLEAR EN|TIRE MEM|
|00002e80| 4f 52 59 20 43 6f 6d 6d | 61 6e 64 20 69 73 3a 20 |ORY Comm|and is: |
|00002e90| 20 43 6f 6e 74 72 6f 6c | 2d 2d 78 20 20 43 6f 6e | Control|--x Con|
|00002ea0| 74 72 6f 6c 2d 2d 6b 00 | 35 00 4c 20 65 6e 74 69 |trol--k.|5.L enti|
|00002eb0| 72 65 20 6d 65 6d 6f 72 | 79 20 61 6e 64 20 72 65 |re memor|y and re|
|00002ec0| 61 64 20 69 6e 20 74 68 | 65 20 22 6c 65 73 73 6f |ad in th|e "lesso|
|00002ed0| 6e 34 2e 70 63 22 20 66 | 69 6c 65 2e 00 45 00 4c |n4.pc" f|ile..E.L|
|00002ee0| 20 72 65 70 6c 69 63 61 | 74 69 6e 67 20 66 6f 72 | replica|ting for|
|00002ef0| 6d 75 6c 61 73 2c 20 69 | 6e 73 65 72 74 69 6e 67 |mulas, i|nserting|
|00002f00| 2c 20 64 65 6c 65 74 69 | 6e 67 2c 20 61 6e 64 20 |, deleti|ng, and |
|00002f10| 6d 6f 76 69 6e 67 2c 20 | 63 6c 65 61 72 20 74 68 |moving, |clear th|
|00002f20| 65 00 48 00 4c 20 73 68 | 65 65 74 2e 20 20 49 66 |e.H.L sh|eet. If|
|00002f30| 20 79 6f 75 20 77 69 73 | 68 20 74 6f 20 63 6f 6e | you wis|h to con|
|00002f40| 74 69 6e 75 65 20 74 6f | 20 74 68 65 20 6e 65 78 |tinue to| the nex|
|00002f50| 74 20 6c 65 73 73 6f 6e | 20 77 68 69 63 68 20 64 |t lesson| which d|
|00002f60| 65 61 6c 73 20 77 69 74 | 68 00 49 00 4c 20 20 20 |eals wit|h.I.L |
|00002f70| 20 20 20 20 54 68 69 73 | 20 63 6f 6e 63 6c 75 64 | This| conclud|
|00002f80| 65 73 20 74 68 65 20 6c | 65 73 73 6f 6e 20 6f 6e |es the l|esson on|
|00002f90| 20 73 74 6f 72 69 6e 67 | 20 61 6e 64 20 70 72 69 | storing| and pri|
|00002fa0| 6e 74 69 6e 67 20 79 6f | 75 72 20 73 70 72 65 61 |nting yo|ur sprea|
|00002fb0| 64 2d 00 4b 00 4c 20 6f | 6e 20 61 6c 6c 20 69 74 |d-.K.L o|n all it|
|00002fc0| 73 20 66 69 6c 65 6e 61 | 6d 65 73 2e 20 54 68 75 |s filena|mes. Thu|
|00002fd0| 73 2c 20 27 73 74 6f 63 | 6b 74 77 6f 2e 70 63 27 |s, 'stoc|ktwo.pc'|
|00002fe0| 20 77 69 6c 6c 20 62 65 | 63 6f 6d 65 20 27 73 74 | will be|come 'st|
|00002ff0| 6f 63 6b 74 77 6f 2e 6d | 73 73 27 2e 29 00 00 00 |ocktwo.m|ss'.)...|
|00003000| 07 00 00 00 00 00 00 0d | 00 ff ff cb 37 ff ff ff |........|....7...|
|00003010| ff 07 00 00 09 00 ff ff | 1d 30 07 00 00 0d 00 4c |........|.0.....L|
|00003020| 20 43 6f 6d 6d 61 6e 64 | 3a 00 09 00 ff ff 33 30 | Command|:.....30|
|00003030| 07 00 00 44 00 4c 20 20 | 20 20 20 20 20 4d 6f 76 |...D.L | Mov|
|00003040| 65 20 74 68 65 20 63 75 | 72 73 6f 72 20 74 6f 20 |e the cu|rsor to |
|00003050| 74 68 65 20 74 6f 70 20 | 77 69 6e 64 6f 77 2c 20 |the top |window, |
|00003060| 75 73 69 6e 67 20 74 68 | 65 20 4f 54 48 45 52 20 |using th|e OTHER |
|00003070| 57 49 4e 44 4f 57 00 09 | 00 ff ff 80 30 07 00 00 |WINDOW..|....0...|
|00003080| 2a 00 4c 20 20 20 20 20 | 20 20 44 6f 20 6e 6f 74 |*.L | Do not|
|00003090| 20 73 79 6e 63 68 72 6f | 6e 69 7a 65 20 74 68 65 | synchro|nize the|
|000030a0| 20 77 69 6e 64 6f 77 73 | 2e 00 09 00 ff ff b3 30 | windows|.......0|
|000030b0| 07 00 00 29 00 4c 20 20 | 20 20 20 20 20 20 20 20 |...).L | |
|000030c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 43 6f | | Co|
|000030d0| 6e 74 72 6f 6c 2d 2d 78 | 20 20 32 00 09 00 ff ff |ntrol--x| 2.....|
|000030e0| e5 30 07 00 00 0d 00 4c | 20 43 6f 6d 6d 61 6e 64 |.0.....L| Command|
|000030f0| 3a 00 09 00 ff ff 04 31 | 07 00 00 09 00 ff ff 00 |:......1|........|
|00003100| 00 07 00 00 46 00 4c 20 | 20 20 20 20 20 4d 6f 76 |....F.L | Mov|
|00003110| 65 20 74 68 65 20 63 75 | 72 73 6f 72 20 74 6f 20 |e the cu|rsor to |
|00003120| 6c 69 6e 65 20 20 31 31 | 20 20 61 6e 64 20 74 79 |line 11| and ty|
|00003130| 70 65 20 74 68 65 20 43 | 52 45 41 54 45 20 54 57 |pe the C|REATE TW|
|00003140| 4f 20 57 49 4e 44 4f 57 | 53 00 09 00 ff ff 53 31 |O WINDOW|S.....S1|
|00003150| 07 00 00 34 00 4c 20 74 | 68 61 74 20 61 6e 61 6c |...4.L t|hat anal|
|00003160| 79 7a 65 73 20 27 43 61 | 73 68 20 46 6c 6f 77 27 |yzes 'Ca|sh Flow'|
|00003170| 20 66 6f 72 20 61 20 73 | 6d 61 6c 6c 20 62 75 73 | for a s|mall bus|
|00003180| 69 6e 65 73 73 2e 00 09 | 00 ff ff 90 31 07 00 00 |iness...|....1...|
|00003190| 49 00 4c 20 63 61 6e 20 | 62 65 20 69 6e 73 65 72 |I.L can |be inser|
|000031a0| 74 65 64 2c 20 64 65 6c | 65 74 65 64 2c 20 61 6e |ted, del|eted, an|
|000031b0| 64 20 6d 6f 76 65 64 2e | 20 20 57 65 20 77 69 6c |d moved.| We wil|
|000031c0| 6c 20 62 65 20 75 73 69 | 6e 67 20 61 20 73 70 72 |l be usi|ng a spr|
|000031d0| 65 61 64 73 68 65 65 74 | 00 09 00 ff ff e2 31 07 |eadsheet|......1.|
|000031e0| 00 00 48 00 4c 20 66 6f | 72 6d 75 6c 61 73 20 61 |..H.L fo|rmulas a|
|000031f0| 72 65 20 27 72 65 70 6c | 69 63 61 74 65 64 27 2e |re 'repl|icated'.|
|00003200| 20 20 41 6c 73 6f 2c 20 | 77 65 20 77 69 6c 6c 20 | Also, |we will |
|00003210| 73 65 65 20 68 6f 77 20 | 6c 69 6e 65 73 20 61 6e |see how |lines an|
|00003220| 64 20 63 6f 6c 75 6d 6e | 73 00 47 00 4c 20 66 6f |d column|s.G.L fo|
|00003230| 72 6d 75 6c 61 73 20 69 | 6e 74 6f 20 74 68 65 20 |rmulas i|nto the |
|00003240| 73 70 72 65 61 64 73 68 | 65 65 74 2e 20 20 49 6e |spreadsh|eet. In|
|00003250| 20 74 68 69 73 20 6c 65 | 73 73 6f 6e 20 77 65 20 | this le|sson we |
|00003260| 77 69 6c 6c 20 65 78 61 | 6d 69 6e 65 20 68 6f 77 |will exa|mine how|
|00003270| 00 43 00 4c 20 20 20 20 | 20 20 20 49 6e 20 4c 65 |.C.L | In Le|
|00003280| 73 73 6f 6e 32 20 77 65 | 20 6c 65 61 72 6e 65 64 |sson2 we| learned|
|00003290| 20 68 6f 77 20 74 6f 20 | 65 6e 74 65 72 20 6e 75 | how to |enter nu|
|000032a0| 6d 62 65 72 73 2c 20 6c | 61 62 65 6c 73 2c 20 61 |mbers, l|abels, a|
|000032b0| 6e 64 20 00 45 00 4c 20 | 20 20 20 4c 45 53 53 4f |nd .E.L | LESSO|
|000032c0| 4e 34 20 2d 2d 20 52 65 | 70 6c 69 63 61 74 69 6e |N4 -- Re|plicatin|
|000032d0| 67 20 46 6f 72 6d 75 6c | 61 73 2c 20 49 6e 73 65 |g Formul|as, Inse|
|000032e0| 72 74 69 6e 67 2c 20 44 | 65 6c 65 74 69 6e 67 20 |rting, D|eleting |
|000032f0| 26 20 4d 6f 76 69 6e 67 | 00 05 01 09 0c 7c 12 2b |& Moving|.....|.+|
|00003300| 12 22 12 19 12 fb 11 a6 | 11 9d 11 4a 11 41 11 f2 |."......|...J.A..|
|00003310| 10 d5 10 97 10 48 10 17 | 10 09 10 76 17 3b 17 e7 |.....H..|...v.;..|
|00003320| 16 de 16 8c 16 83 16 36 | 16 f1 15 9e 15 4e 15 f9 |.......6|.....N..|
|00003330| 14 b1 14 6c 14 5a 14 f7 | 1b a7 1b 8c 1b 57 1b 05 |...l.Z..|.....W..|
|00003340| 1b be 1a 69 1a 15 1a c5 | 19 9a 19 48 19 f6 18 a5 |...i....|...H....|
|00003350| 18 53 18 f7 1f c9 1f 91 | 1f 56 1f 1b 1f c5 1e 73 |.S......|.V.....s|
|00003360| 1e 29 1e ec 1d 9a 1d 46 | 1d f3 1c a2 1c 51 1c 48 |.).....F|.....Q.H|
|00003370| 1c 2a 1c 14 1c 09 1c 1e | 23 cb 22 76 22 28 22 f5 |.*......|#."v"(".|
|00003380| 21 a5 21 51 21 fc 20 a9 | 20 58 20 f7 27 a5 27 58 |!.!Q!. .| X .'.'X|
|00003390| 27 4f 27 fe 26 a9 26 63 | 26 33 26 2a 26 e7 25 92 |'O'.&.&c|&3&*&.%.|
|000033a0| 25 54 25 01 25 e4 24 b7 | 24 69 24 60 24 3c 24 f7 |%T%.%.$.|$i$`$<$.|
|000033b0| 2b ee 2b bd 2b b4 2b 65 | 2b 5c 2b 1e 2b f3 2a ea |+.+.+.+e|+\+.+.*.|
|000033c0| 2a e1 2a d8 2a 84 2a 31 | 2a e1 29 90 29 3d 29 e9 |*.*.*.*1|*.).)=).|
|000033d0| 28 9c 28 48 28 3f 28 36 | 28 2d 28 24 28 1b 28 12 |(.(H(?(6|(-($(.(.|
|000033e0| 28 09 28 21 2e 18 2e cb | 2d c2 2d a7 2d 74 2d 6b |(.(!....|-.-.-t-k|
|000033f0| 2d 19 2d 10 2d f4 2c c2 | 2c b9 2c 07 00 00 00 00 |-.-.-.,.|,.,.....|
|00003400| 07 00 00 00 00 00 00 0d | 00 ff ff 26 3b 00 07 00 |........|...&;...|
|00003410| 00 07 00 00 09 00 ff ff | 6b 3b 07 00 00 09 00 ff |........|k;......|
|00003420| ff 26 34 07 00 00 0e 00 | 4c 20 69 6e 20 27 62 31 |.&4.....|L in 'b1|
|00003430| 30 27 2e 00 09 00 ff ff | b3 3b 07 00 00 09 00 ff |0'......|.;......|
|00003440| ff 4f 34 07 00 00 09 00 | ff ff 00 00 07 00 00 48 |.O4.....|.......H|
|00003450| 00 4c 20 20 20 20 20 20 | 20 54 68 69 73 20 66 6f |.L | This fo|
|00003460| 72 6d 75 6c 61 20 69 6e | 73 74 72 75 63 74 73 20 |rmula in|structs |
|00003470| 50 65 72 66 65 63 74 20 | 43 61 6c 63 20 74 6f 20 |Perfect |Calc to |
|00003480| 61 64 64 20 74 68 65 20 | 65 6e 74 72 69 65 73 20 |add the |entries |
|00003490| 69 6e 20 74 68 65 00 09 | 00 ff ff a9 34 07 00 00 |in the..|....4...|
|000034a0| 09 00 ff ff 00 00 07 00 | 00 2d 00 4c 20 20 20 20 |........|.-.L |
|000034b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000034c0| 20 20 46 6f 72 6d 75 6c | 61 3a 20 73 75 6d 28 62 | Formul|a: sum(b|
|000034d0| 35 3a 62 38 29 00 09 00 | ff ff df 34 07 00 00 36 |5:b8)...|...4...6|
|000034e0| 00 4c 20 54 68 65 20 66 | 6f 72 6d 75 6c 61 20 77 |.L The f|ormula w|
|000034f0| 68 69 63 68 20 64 69 73 | 70 6c 61 79 73 20 69 6e |hich dis|plays in|
|00003500| 20 74 68 65 20 50 72 6f | 6d 70 74 20 4c 69 6e 65 | the Pro|mpt Line|
|00003510| 20 69 73 3a 00 09 00 ff | ff 1e 35 07 00 00 48 00 | is:....|..5...H.|
|00003520| 4c 20 61 74 20 65 6e 74 | 72 79 20 62 6f 78 20 27 |L at ent|ry box '|
|00003530| 62 31 30 27 2c 20 77 68 | 69 63 68 20 72 65 63 6f |b10', wh|ich reco|
|00003540| 72 64 73 20 22 54 6f 74 | 61 6c 20 43 61 73 68 20 |rds "Tot|al Cash |
|00003550| 46 6c 6f 77 20 49 6e 22 | 20 66 6f 72 20 4a 61 6e |Flow In"| for Jan|
|00003560| 75 61 72 79 2e 00 09 00 | ff ff 6f 35 07 00 00 49 |uary....|..o5...I|
|00003570| 00 4c 20 20 20 20 20 20 | 20 57 68 65 6e 20 79 6f |.L | When yo|
|00003580| 75 20 68 61 76 65 20 73 | 65 65 6e 20 74 68 65 20 |u have s|een the |
|00003590| 65 6e 74 69 72 65 20 73 | 70 72 65 61 64 73 68 65 |entire s|preadshe|
|000035a0| 65 74 2c 20 70 6f 73 69 | 74 69 6f 6e 20 74 68 65 |et, posi|tion the|
|000035b0| 20 63 75 72 73 6f 72 00 | 09 00 ff ff ca 35 07 00 | cursor.|.....5..|
|000035c0| 00 09 00 ff ff 00 00 07 | 00 00 3c 00 4c 20 20 20 |........|..<.L |
|000035d0| 20 20 20 20 4c 65 74 20 | 75 73 20 62 65 67 69 6e | Let |us begin|
|000035e0| 20 62 79 20 65 78 61 6d | 69 6e 69 6e 67 20 74 68 | by exam|ining th|
|000035f0| 65 20 65 6e 74 69 72 65 | 20 73 70 72 65 61 64 73 |e entire| spreads|
|00003600| 68 65 65 74 2e 00 09 00 | ff ff 0f 36 07 00 00 17 |heet....|...6....|
|00003610| 00 4c 20 69 6e 20 74 68 | 65 20 74 6f 70 20 77 69 |.L in th|e top wi|
|00003620| 6e 64 6f 77 2e 00 09 00 | ff ff 38 36 07 00 00 09 |ndow....|..86....|
|00003630| 00 ff ff 00 00 07 00 00 | 48 00 4c 20 20 20 20 20 |........|H.L |
|00003640| 20 20 50 65 72 66 65 63 | 74 20 43 61 6c 63 20 64 | Perfec|t Calc d|
|00003650| 69 73 70 6c 61 79 73 20 | 61 20 73 61 6d 70 6c 65 |isplays |a sample|
|00003660| 20 27 43 61 73 68 20 46 | 6c 6f 77 20 41 73 73 65 | 'Cash F|low Asse|
|00003670| 73 73 6d 65 6e 74 27 20 | 70 72 6f 67 72 61 6d 00 |ssment' |program.|
|00003680| 09 00 ff ff 92 36 07 00 | 00 09 00 ff ff 00 00 07 |.....6..|........|
|00003690| 00 00 48 00 4c 20 20 20 | 20 20 20 20 54 79 70 65 |..H.L | Type|
|000036a0| 20 74 68 65 20 66 69 6c | 65 6e 61 6d 65 20 27 62 | the fil|ename 'b|
|000036b0| 3a 63 61 73 68 2e 70 63 | 27 2c 20 66 6f 6c 6c 6f |:cash.pc|', follo|
|000036c0| 77 65 64 20 62 79 20 61 | 20 63 61 72 72 69 61 67 |wed by a| carriag|
|000036d0| 65 20 72 65 74 75 72 6e | 2e 00 09 00 ff ff ec 36 |e return|.......6|
|000036e0| 07 00 00 09 00 ff ff 00 | 00 07 00 00 31 00 4c 20 |........|....1.L |
|000036f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003700| 20 20 20 20 20 20 43 6f | 6e 74 72 6f 6c 2d 2d 78 | Co|ntrol--x|
|00003710| 20 20 43 6f 6e 74 72 6f | 6c 2d 2d 66 00 09 00 ff | Contro|l--f....|
|00003720| ff 2f 37 07 00 00 09 00 | ff ff 00 00 07 00 00 48 |./7.....|.......H|
|00003730| 00 4c 20 20 20 20 20 20 | 20 57 69 74 68 20 74 68 |.L | With th|
|00003740| 65 20 63 75 72 73 6f 72 | 20 69 6e 20 74 68 65 20 |e cursor| in the |
|00003750| 74 6f 70 20 77 69 6e 64 | 6f 77 20 74 79 70 65 20 |top wind|ow type |
|00003760| 74 68 65 20 46 49 4e 44 | 20 46 49 4c 45 20 43 6f |the FIND| FILE Co|
|00003770| 6d 6d 61 6e 64 3a 00 09 | 00 ff ff 80 37 07 00 00 |mmand:..|....7...|
|00003780| 4b 00 4c 20 41 67 61 69 | 6e 2c 20 79 6f 75 20 77 |K.L Agai|n, you w|
|00003790| 69 6c 6c 20 6e 65 65 64 | 20 74 68 65 20 27 4f 74 |ill need| the 'Ot|
|000037a0| 68 65 72 20 57 69 6e 64 | 6f 77 27 20 63 6f 6d 6d |her Wind|ow' comm|
|000037b0| 61 6e 64 73 20 74 6f 20 | 73 63 72 6f 6c 6c 20 74 |ands to |scroll t|
|000037c0| 68 65 20 6c 65 73 73 6f | 6e 2e 00 33 00 4c 20 20 |he lesso|n..3.L |
|000037d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 43 6f 6e 74 | | Cont|
|000037e0| 72 6f 6c 2d 2d 78 20 20 | 6f 20 20 28 73 6d 61 6c |rol--x |o (smal|
|000037f0| 6c 20 6c 65 74 74 65 72 | 20 27 6f 27 29 00 00 00 |l letter| 'o')...|
|00003800| 07 00 00 00 00 00 00 4e | 00 4c 20 27 54 6f 74 61 |.......N|.L 'Tota|
|00003810| 6c 20 43 61 73 68 20 46 | 6c 6f 77 20 4f 75 74 27 |l Cash F|low Out'|
|00003820| 20 66 6f 72 20 65 61 63 | 68 20 6d 6f 6e 74 68 20 | for eac|h month |
|00003830| 6f 66 20 74 68 65 20 79 | 65 61 72 2e 20 20 4d 6f |of the y|ear. Mo|
|00003840| 76 65 20 74 68 65 20 63 | 75 72 73 6f 72 20 74 6f |ve the c|ursor to|
|00003850| 20 00 07 00 00 09 00 ff | ff 67 38 07 00 00 09 00 | .......|.g8.....|
|00003860| ff ff 00 00 07 00 00 46 | 00 4c 20 20 20 20 20 20 |.......F|.L |
|00003870| 20 4c 65 74 20 75 73 20 | 65 6e 74 65 72 20 61 20 | Let us |enter a |
|00003880| 73 69 6d 69 6c 61 72 20 | 66 6f 72 6d 75 6c 61 20 |similar |formula |
|00003890| 69 6e 74 6f 20 4c 69 6e | 65 20 31 38 2c 20 77 68 |into Lin|e 18, wh|
|000038a0| 69 63 68 20 63 6f 6d 70 | 75 74 65 73 00 09 00 ff |ich comp|utes....|
|000038b0| ff b6 38 07 00 00 4a 00 | 4c 20 50 65 72 66 65 63 |..8...J.|L Perfec|
|000038c0| 74 20 43 61 6c 63 20 70 | 72 6f 76 69 64 65 73 20 |t Calc p|rovides |
|000038d0| 63 61 6c 6c 65 64 20 27 | 72 65 70 6c 69 63 61 74 |called '|replicat|
|000038e0| 69 6e 67 27 2e 20 20 4c | 65 74 20 75 73 20 73 65 |ing'. L|et us se|
|000038f0| 65 20 68 6f 77 20 69 74 | 20 77 6f 72 6b 73 2e 00 |e how it| works..|
|00003900| 09 00 ff ff 09 39 07 00 | 00 4c 00 4c 20 6f 66 20 |.....9..|.L.L of |
|00003910| 73 75 63 68 20 66 6f 72 | 6d 75 6c 61 73 20 63 6f |such for|mulas co|
|00003920| 75 6c 64 20 70 72 6f 76 | 65 20 74 65 64 69 6f 75 |uld prov|e tediou|
|00003930| 73 2c 20 77 65 72 65 20 | 69 74 20 6e 6f 74 20 66 |s, were |it not f|
|00003940| 6f 72 20 61 20 70 72 6f | 63 65 64 75 72 65 20 77 |or a pro|cedure w|
|00003950| 68 69 63 68 00 09 00 ff | ff 5e 39 07 00 00 4a 00 |hich....|.^9...J.|
|00003960| 4c 20 74 6f 20 61 63 63 | 6f 75 6e 74 20 66 6f 72 |L to acc|ount for|
|00003970| 20 74 68 65 69 72 20 70 | 6f 73 69 74 69 6f 6e 73 | their p|ositions|
|00003980| 20 6f 6e 20 74 68 65 20 | 73 70 72 65 61 64 73 68 | on the |spreadsh|
|00003990| 65 65 74 2e 20 20 45 6e | 74 65 72 69 6e 67 20 61 |eet. En|tering a|
|000039a0| 20 73 65 72 69 65 73 00 | 09 00 ff ff b1 39 07 00 | series.|.....9..|
|000039b0| 00 4c 00 4c 20 61 20 63 | 6f 6d 6d 6f 6e 20 77 61 |.L.L a c|ommon wa|
|000039c0| 79 20 6f 66 20 73 74 72 | 75 63 74 75 72 69 6e 67 |y of str|ucturing|
|000039d0| 20 63 6f 6e 73 65 63 75 | 74 69 76 65 20 66 6f 72 | consecu|tive for|
|000039e0| 6d 75 6c 61 73 2d 2d 76 | 61 72 79 69 6e 67 20 74 |mulas--v|arying t|
|000039f0| 68 65 6d 20 73 6c 69 67 | 68 74 6c 79 00 09 00 ff |hem slig|htly....|
|00003a00| ff 06 3a 07 00 00 4c 00 | 4c 20 74 68 65 20 63 6f |..:...L.|L the co|
|00003a10| 6f 72 64 69 6e 61 74 65 | 73 20 74 68 61 74 20 73 |ordinate|s that s|
|00003a20| 70 65 63 69 66 79 20 74 | 68 65 69 72 20 69 6e 64 |pecify t|heir ind|
|00003a30| 69 76 69 64 75 61 6c 20 | 63 6f 6c 75 6d 6e 20 70 |ividual |column p|
|00003a40| 6f 73 69 74 69 6f 6e 73 | 2e 20 54 68 69 73 20 69 |ositions|. This i|
|00003a50| 73 00 09 00 ff ff 5b 3a | 07 00 00 49 00 4c 20 74 |s.....[:|...I.L t|
|00003a60| 68 65 20 63 75 72 73 6f | 72 20 61 63 72 6f 73 73 |he curso|r across|
|00003a70| 20 6c 69 6e 65 20 31 30 | 2c 20 6e 6f 74 69 63 69 | line 10|, notici|
|00003a80| 6e 67 20 74 68 61 74 20 | 74 68 65 20 66 6f 72 6d |ng that |the form|
|00003a90| 75 6c 61 73 20 64 69 66 | 66 65 72 20 6f 6e 6c 79 |ulas dif|fer only|
|00003aa0| 20 69 6e 00 09 00 ff ff | ad 3a 07 00 00 4b 00 4c | in.....|.:...K.L|
|00003ab0| 20 20 20 20 20 20 20 45 | 78 63 65 70 74 20 66 6f | E|xcept fo|
|00003ac0| 72 20 74 68 65 69 72 20 | 76 61 72 69 61 62 6c 65 |r their |variable|
|00003ad0| 73 20 74 68 65 20 74 77 | 6f 20 66 6f 72 6d 75 6c |s the tw|o formul|
|00003ae0| 61 73 20 61 72 65 20 69 | 64 65 6e 74 69 63 61 6c |as are i|dentical|
|00003af0| 2e 20 20 4d 6f 76 65 00 | 09 00 ff ff 01 3b 07 00 |. Move.|.....;..|
|00003b00| 00 25 00 4c 20 20 20 20 | 20 20 20 20 20 20 20 20 |.%.L | |
|00003b10| 20 20 46 6f 72 6d 75 6c | 61 3a 20 73 75 6d 28 63 | Formul|a: sum(c|
|00003b20| 35 3a 63 38 29 00 45 00 | 4c 20 72 65 63 6f 72 64 |5:c8).E.|L record|
|00003b30| 73 20 74 68 65 20 73 61 | 6d 65 20 69 6e 66 6f 72 |s the sa|me infor|
|00003b40| 6d 61 74 69 6f 6e 20 66 | 6f 72 20 46 65 62 72 75 |mation f|or Febru|
|00003b50| 61 72 79 2e 20 20 48 65 | 72 65 20 74 68 65 20 66 |ary. He|re the f|
|00003b60| 6f 72 6d 75 6c 61 20 69 | 73 3a 00 48 00 4c 20 20 |ormula i|s:.H.L |
|00003b70| 20 20 20 20 20 4d 6f 76 | 65 20 74 68 65 20 63 75 | Mov|e the cu|
|00003b80| 72 73 6f 72 20 6f 6e 65 | 20 73 70 61 63 65 20 74 |rsor one| space t|
|00003b90| 6f 20 74 68 65 20 72 69 | 67 68 74 20 74 6f 20 74 |o the ri|ght to t|
|00003ba0| 68 65 20 65 6e 74 72 79 | 20 62 6f 78 20 77 68 69 |he entry| box whi|
|00003bb0| 63 68 00 4b 00 4c 20 70 | 72 65 76 69 6f 75 73 20 |ch.K.L p|revious |
|00003bc0| 66 6f 75 72 20 65 6e 74 | 72 79 20 62 6f 78 65 73 |four ent|ry boxes|
|00003bd0| 20 28 27 62 35 27 20 74 | 6f 20 27 62 38 27 29 20 | ('b5' t|o 'b8') |
|00003be0| 61 6e 64 20 74 6f 20 64 | 69 73 70 6c 61 79 20 74 |and to d|isplay t|
|00003bf0| 68 65 20 72 65 73 75 6c | 74 20 69 6e 20 00 00 00 |he resul|t in ...|
|00003c00| 07 00 00 00 00 00 00 0c | 00 ff ff 00 00 07 00 00 |........|........|
|00003c10| 07 00 00 09 00 ff ff 88 | 43 07 00 00 09 00 ff ff |........|C.......|
|00003c20| 25 3c 07 00 00 0d 00 4c | 20 43 6f 6d 6d 61 6e 64 |%<.....L| Command|
|00003c30| 3a 00 09 00 ff ff b9 43 | 07 00 00 09 00 ff ff 44 |:......C|.......D|
|00003c40| 3c 07 00 00 40 00 4c 20 | 74 68 65 20 27 53 61 76 |<...@.L |the 'Sav|
|00003c50| 65 20 42 75 66 66 65 72 | 27 20 66 6f 72 20 6c 61 |e Buffer|' for la|
|00003c60| 74 65 72 20 64 75 70 6c | 69 63 61 74 69 6f 6e 20 |ter dupl|ication |
|00003c70| 74 6f 20 6f 74 68 65 72 | 20 6c 6f 63 61 74 69 6f |to other| locatio|
|00003c80| 6e 73 2e 00 09 00 ff ff | 8d 3c 07 00 00 4b 00 4c |ns......|.<...K.L|
|00003c90| 20 20 20 20 20 50 65 72 | 66 65 63 74 20 43 61 6c | Per|fect Cal|
|00003ca0| 63 20 73 61 76 65 73 20 | 74 68 65 20 66 6f 72 6d |c saves |the form|
|00003cb0| 75 6c 61 20 69 6e 20 61 | 20 74 65 6d 70 6f 72 61 |ula in a| tempora|
|00003cc0| 72 79 20 73 74 6f 72 61 | 67 65 20 73 70 61 63 65 |ry stora|ge space|
|00003cd0| 20 63 61 6c 6c 65 64 00 | 09 00 ff ff e1 3c 07 00 | called.|.....<..|
|00003ce0| 00 29 00 4c 20 20 20 20 | 20 20 20 20 20 20 20 20 |.).L | |
|00003cf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 43 | | C|
|00003d00| 6f 6e 74 72 6f 6c 2d 2d | 57 00 09 00 ff ff 13 3d |ontrol--|W......=|
|00003d10| 07 00 00 18 00 4c 20 43 | 4f 50 59 20 45 4e 54 52 |.....L C|OPY ENTR|
|00003d20| 59 20 43 6f 6d 6d 61 6e | 64 3a 00 09 00 ff ff 34 |Y Comman|d:.....4|
|00003d30| 3d 07 00 00 42 00 4c 20 | 20 20 20 20 45 6e 74 65 |=...B.L | Ente|
|00003d40| 72 20 74 68 69 73 20 66 | 6f 72 6d 75 6c 61 20 77 |r this f|ormula w|
|00003d50| 69 74 68 20 61 20 63 61 | 72 72 69 61 67 65 20 72 |ith a ca|rriage r|
|00003d60| 65 74 75 72 6e 2e 20 20 | 4e 65 78 74 20 74 79 70 |eturn. |Next typ|
|00003d70| 65 20 74 68 65 00 09 00 | ff ff 7f 3d 07 00 00 2f |e the...|...=.../|
|00003d80| 00 4c 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.L | |
|00003d90| 20 20 20 20 46 4f 52 4d | 55 4c 41 3a 20 62 31 38 | FORM|ULA: b18|
|00003da0| 3d 73 75 6d 28 62 31 33 | 3a 62 31 36 29 00 09 00 |=sum(b13|:b16)...|
|00003db0| ff ff b7 3d 07 00 00 38 | 00 4c 20 74 68 69 73 20 |...=...8|.L this |
|00003dc0| 70 6f 73 69 74 69 6f 6e | 2e 20 20 42 65 67 69 6e |position|. Begin|
|00003dd0| 20 77 69 74 68 20 61 6e | 20 65 71 75 61 6c 73 20 | with an| equals |
|00003de0| 73 69 67 6e 20 20 28 20 | 20 3d 20 20 29 3a 00 09 |sign ( | = ):..|
|00003df0| 00 ff ff 01 3e 07 00 00 | 09 00 ff ff 00 00 07 00 |....>...|........|
|00003e00| 00 49 00 4c 20 20 20 20 | 20 20 20 57 69 74 68 20 |.I.L | With |
|00003e10| 74 68 65 20 63 75 72 73 | 6f 72 20 69 6e 20 70 6f |the curs|or in po|
|00003e20| 73 69 74 69 6f 6e 20 27 | 62 31 38 27 20 74 79 70 |sition '|b18' typ|
|00003e30| 65 20 74 68 65 20 69 6e | 69 74 69 61 6c 20 66 6f |e the in|itial fo|
|00003e40| 72 6d 75 6c 61 20 66 6f | 72 00 09 00 ff ff 5c 3e |rmula fo|r.....\>|
|00003e50| 07 00 00 09 00 ff ff 00 | 00 07 00 00 1a 00 4c 20 |........|......L |
|00003e60| 52 45 50 4c 49 43 41 54 | 49 4e 47 20 41 20 46 4f |REPLICAT|ING A FO|
|00003e70| 52 4d 55 4c 41 00 09 00 | ff ff 7f 3e 07 00 00 2a |RMULA...|...>...*|
|00003e80| 00 4c 20 72 65 66 6c 65 | 63 74 20 74 68 65 20 76 |.L refle|ct the v|
|00003e90| 61 72 69 6f 75 73 20 63 | 6f 6c 75 6d 6e 20 70 6f |arious c|olumn po|
|00003ea0| 73 69 74 69 6f 6e 73 2e | 00 09 00 ff ff b2 3e 07 |sitions.|......>.|
|00003eb0| 00 00 45 00 4c 20 65 76 | 65 72 79 20 65 6e 74 72 |..E.L ev|ery entr|
|00003ec0| 79 20 62 6f 78 20 69 6e | 20 6c 69 6e 65 20 31 38 |y box in| line 18|
|00003ed0| 2c 20 69 74 73 20 63 6f | 6f 72 64 69 6e 61 74 65 |, its co|ordinate|
|00003ee0| 20 76 61 72 69 61 62 6c | 65 73 20 63 68 61 6e 67 | variabl|es chang|
|00003ef0| 69 6e 67 20 74 6f 00 09 | 00 ff ff 09 3f 07 00 00 |ing to..|....?...|
|00003f00| 09 00 ff ff 00 00 07 00 | 00 48 00 4c 20 20 20 20 |........|.H.L |
|00003f10| 20 20 20 4c 69 6b 65 20 | 27 54 6f 74 61 6c 20 43 | Like |'Total C|
|00003f20| 61 73 68 20 46 6c 6f 77 | 20 49 6e 27 2c 20 74 68 |ash Flow| In', th|
|00003f30| 69 73 20 66 6f 72 6d 75 | 6c 61 20 77 69 6c 6c 20 |is formu|la will |
|00003f40| 62 65 20 64 75 70 6c 69 | 63 61 74 65 64 20 74 6f |be dupli|cated to|
|00003f50| 00 09 00 ff ff 5a 3f 07 | 00 00 2c 00 4c 20 20 20 |.....Z?.|..,.L |
|00003f60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003f70| 20 20 20 62 31 38 20 3d | 20 73 75 6d 28 62 31 33 | b18 =| sum(b13|
|00003f80| 3a 62 31 36 29 00 09 00 | ff ff 8f 3f 07 00 00 18 |:b16)...|...?....|
|00003f90| 00 4c 20 72 65 70 6c 69 | 63 61 74 65 64 20 77 69 |.L repli|cated wi|
|00003fa0| 6c 6c 20 62 65 3a 00 09 | 00 ff ff b0 3f 07 00 00 |ll be:..|....?...|
|00003fb0| 45 00 4c 20 70 6f 73 69 | 74 69 6f 6e 20 27 62 31 |E.L posi|tion 'b1|
|00003fc0| 38 27 20 7b 54 6f 20 67 | 65 74 20 74 68 65 72 65 |8' {To g|et there|
|00003fd0| 20 74 79 70 65 20 43 6f | 6e 74 72 6f 6c 2d 2d 76 | type Co|ntrol--v|
|00003fe0| 7d 2e 20 54 68 65 20 66 | 6f 72 6d 75 6c 61 20 74 |}. The f|ormula t|
|00003ff0| 6f 20 62 65 00 09 00 ff | ff 07 38 07 00 00 00 00 |o be....|..8.....|
|00004000| 07 00 00 00 00 00 00 11 | 00 ff ff b4 47 00 00 34 |........|....G..4|
|00004010| 08 f2 0f e6 0f 07 00 00 | 09 00 ff ff 21 40 07 00 |........|....!@..|
|00004020| 00 4c 00 4c 20 77 68 69 | 63 68 20 74 68 65 20 66 |.L.L whi|ch the f|
|00004030| 6f 72 6d 75 6c 61 20 77 | 69 6c 6c 20 62 65 20 27 |ormula w|ill be '|
|00004040| 72 65 70 6c 69 63 61 74 | 65 64 27 3f 20 20 49 74 |replicat|ed'? It|
|00004050| 20 61 73 6b 73 20 74 68 | 69 73 20 62 79 20 64 69 | asks th|is by di|
|00004060| 73 70 6c 61 79 69 6e 67 | 20 74 68 65 00 09 00 ff |splaying| the....|
|00004070| ff 76 40 07 00 00 4b 00 | 4c 20 74 68 65 79 20 62 |.v@...K.|L they b|
|00004080| 65 20 63 68 61 6e 67 65 | 64 20 74 6f 20 72 65 66 |e change|d to ref|
|00004090| 6c 65 63 74 20 74 68 65 | 20 70 6f 73 69 74 69 6f |lect the| positio|
|000040a0| 6e 73 20 6f 66 20 74 68 | 65 20 76 61 72 69 6f 75 |ns of th|e variou|
|000040b0| 73 20 65 6e 74 72 79 20 | 62 6f 78 65 73 20 74 6f |s entry |boxes to|
|000040c0| 00 09 00 ff ff ca 40 07 | 00 00 4c 00 4c 20 6f 72 |......@.|..L.L or|
|000040d0| 20 6e 6f 74 20 74 68 65 | 20 74 77 6f 20 76 61 72 | not the| two var|
|000040e0| 69 61 62 6c 65 73 20 69 | 6e 20 74 68 65 20 66 6f |iables i|n the fo|
|000040f0| 72 6d 75 6c 61 20 61 72 | 65 20 27 72 65 6c 61 74 |rmula ar|e 'relat|
|00004100| 69 76 65 27 2e 20 54 68 | 61 74 20 69 73 2c 20 73 |ive'. Th|at is, s|
|00004110| 68 6f 75 6c 64 00 09 00 | ff ff 1f 41 07 00 00 4c |hould...|...A...L|
|00004120| 00 4c 20 20 20 41 74 20 | 74 68 69 73 20 70 6f 69 |.L At |this poi|
|00004130| 6e 74 20 50 65 72 66 65 | 63 74 20 43 61 6c 63 20 |nt Perfe|ct Calc |
|00004140| 6e 65 65 64 73 20 74 6f | 20 6b 6e 6f 77 20 6f 6e |needs to| know on|
|00004150| 6c 79 20 6f 6e 65 20 6d | 6f 72 65 20 74 68 69 6e |ly one m|ore thin|
|00004160| 67 3a 20 77 68 65 74 68 | 65 72 00 09 00 ff ff 74 |g: wheth|er.....t|
|00004170| 41 07 00 00 3a 00 4c 20 | 62 79 20 67 69 76 69 6e |A...:.L |by givin|
|00004180| 67 20 74 68 65 20 6d 75 | 6c 74 69 70 6c 65 20 59 |g the mu|ltiple Y|
|00004190| 41 4e 4b 42 41 43 4b 20 | 43 6f 6d 6d 61 6e 64 3a |ANKBACK |Command:|
|000041a0| 20 20 20 45 73 63 61 70 | 65 2e 2e 2e 79 00 09 00 | Escap|e...y...|
|000041b0| ff ff b7 41 07 00 00 4b | 00 4c 20 20 20 20 20 20 |...A...K|.L |
|000041c0| 52 65 70 6c 69 63 61 74 | 65 20 74 68 65 20 66 6f |Replicat|e the fo|
|000041d0| 72 6d 75 6c 61 20 61 63 | 72 6f 73 73 20 74 68 65 |rmula ac|ross the|
|000041e0| 20 72 65 67 69 6f 6e 20 | 6f 66 20 65 6e 74 72 79 | region |of entry|
|000041f0| 20 62 6f 78 65 73 20 69 | 6e 20 6c 69 6e 65 20 31 | boxes i|n line 1|
|00004200| 38 00 09 00 ff ff 0b 42 | 07 00 00 22 00 4c 20 6f |8......B|...".L o|
|00004210| 74 68 65 72 20 62 6f 75 | 6e 64 61 72 79 20 6f 66 |ther bou|ndary of|
|00004220| 20 74 68 65 20 72 65 67 | 69 6f 6e 2e 00 09 00 ff | the reg|ion.....|
|00004230| ff 36 42 07 00 00 47 00 | 4c 20 43 6f 6d 6d 61 6e |.6B...G.|L Comman|
|00004240| 64 20 20 28 43 6f 6e 74 | 72 6f 6c 2d 2d 45 29 2e |d (Cont|rol--E).|
|00004250| 20 20 54 68 65 20 6e 65 | 77 20 70 6f 73 69 74 69 | The ne|w positi|
|00004260| 6f 6e 20 6f 66 20 74 68 | 65 20 63 75 72 73 6f 72 |on of th|e cursor|
|00004270| 20 64 65 66 69 6e 65 73 | 20 74 68 65 00 09 00 ff | defines| the....|
|00004280| ff 86 42 07 00 00 46 00 | 4c 20 20 20 20 20 20 20 |..B...F.|L |
|00004290| 4d 6f 76 65 20 74 68 65 | 20 63 75 72 73 6f 72 20 |Move the| cursor |
|000042a0| 74 6f 20 74 68 65 20 65 | 6e 64 20 6f 66 20 6c 69 |to the e|nd of li|
|000042b0| 6e 65 20 31 38 20 75 73 | 69 6e 67 20 74 68 65 20 |ne 18 us|ing the |
|000042c0| 45 4e 44 20 4f 46 20 4c | 49 4e 45 00 09 00 ff ff |END OF L|INE.....|
|000042d0| d5 42 07 00 00 24 00 4c | 20 74 68 65 20 66 6f 72 |.B...$.L| the for|
|000042e0| 6d 75 6c 61 20 77 69 6c | 6c 20 62 65 20 72 65 70 |mula wil|l be rep|
|000042f0| 6c 69 63 61 74 65 64 2e | 00 09 00 ff ff 02 43 07 |licated.|......C.|
|00004300| 00 00 47 00 4c 20 20 20 | 20 20 20 20 54 68 69 73 |..G.L | This|
|00004310| 20 27 6d 61 72 6b 27 20 | 64 65 66 69 6e 65 73 20 | 'mark' |defines |
|00004320| 74 68 65 20 62 65 67 69 | 6e 6e 69 6e 67 20 6f 66 |the begi|nning of|
|00004330| 20 74 68 65 20 27 72 65 | 67 69 6f 6e 27 20 6f 76 | the 're|gion' ov|
|00004340| 65 72 20 77 68 69 63 68 | 00 09 00 ff ff 52 43 07 |er which|.....RC.|
|00004350| 00 00 36 00 4c 20 20 20 | 20 20 20 20 50 65 72 66 |..6.L | Perf|
|00004360| 65 63 74 20 43 61 6c 63 | 20 72 65 73 70 6f 6e 64 |ect Calc| respond|
|00004370| 73 3a 20 20 22 4d 61 72 | 6b 20 73 65 74 20 61 74 |s: "Mar|k set at|
|00004380| 20 62 31 38 22 20 2e 00 | 31 00 4c 20 20 20 20 20 | b18" ..|1.L |
|00004390| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000043a0| 20 20 45 73 63 61 70 65 | 2e 20 2e 20 2e 3c 73 70 | Escape|. . .<sp|
|000043b0| 61 63 65 20 62 61 72 3e | 00 45 00 4c 20 20 20 20 |ace bar>|.E.L |
|000043c0| 20 20 20 53 65 74 20 61 | 6e 20 69 6e 76 69 73 69 | Set a|n invisi|
|000043d0| 62 6c 65 20 6d 61 72 6b | 20 61 74 20 70 6f 73 69 |ble mark| at posi|
|000043e0| 74 69 6f 6e 20 27 62 31 | 38 27 20 75 73 69 6e 67 |tion 'b1|8' using|
|000043f0| 20 74 68 65 20 4d 41 52 | 4b 20 53 45 54 00 00 00 | the MAR|K SET...|
|00004400| 07 00 00 00 00 00 00 0e | 00 ff ff 15 44 00 00 00 |........|....D...|
|00004410| 00 00 07 00 00 48 00 4c | 20 65 6d 70 6c 6f 79 65 |.....H.L| employe|
|00004420| 64 20 77 68 65 6e 20 6d | 61 6b 69 6e 67 20 72 6f |d when m|aking ro|
|00004430| 6f 6d 20 66 6f 72 20 61 | 64 64 69 74 69 6f 6e 61 |om for a|dditiona|
|00004440| 6c 20 64 61 74 61 20 74 | 68 61 74 20 69 73 20 65 |l data t|hat is e|
|00004450| 69 74 68 65 72 20 6e 65 | 77 20 6f 72 00 09 00 ff |ither ne|w or....|
|00004460| ff 66 44 07 00 00 48 00 | 4c 20 20 20 20 20 20 20 |.fD...H.|L |
|00004470| 49 6e 73 65 72 74 69 6e | 67 20 61 20 6c 69 6e 65 |Insertin|g a line|
|00004480| 20 6f 72 20 63 6f 6c 75 | 6d 6e 20 69 73 20 61 6c | or colu|mn is al|
|00004490| 73 6f 20 65 61 73 79 20 | 74 6f 20 64 6f 2e 20 20 |so easy |to do. |
|000044a0| 49 74 20 69 73 20 75 73 | 75 61 6c 6c 79 00 09 00 |It is us|ually...|
|000044b0| ff ff c0 44 07 00 00 09 | 00 ff ff 00 00 07 00 00 |...D....|........|
|000044c0| 0f 00 4c 20 20 49 4e 53 | 45 52 54 49 4e 47 00 09 |..L INS|ERTING..|
|000044d0| 00 ff ff d8 44 07 00 00 | 33 00 4c 20 61 67 61 69 |....D...|3.L agai|
|000044e0| 6e 20 61 6e 64 20 61 67 | 61 69 6e 20 69 6e 20 62 |n and ag|ain in b|
|000044f0| 75 69 6c 64 69 6e 67 20 | 79 6f 75 72 20 73 70 72 |uilding |your spr|
|00004500| 65 61 64 73 68 65 65 74 | 73 2e 00 09 00 ff ff 1d |eadsheet|s.......|
|00004510| 45 07 00 00 09 00 ff ff | 00 00 07 00 00 48 00 4c |E.......|.....H.L|
|00004520| 20 20 20 20 20 20 20 52 | 65 70 6c 69 63 61 74 69 | R|eplicati|
|00004530| 6e 67 20 69 73 20 61 20 | 73 69 6d 70 6c 65 20 61 |ng is a |simple a|
|00004540| 6e 64 20 65 61 73 79 20 | 70 72 6f 63 65 64 75 72 |nd easy |procedur|
|00004550| 65 20 74 68 61 74 20 79 | 6f 75 20 77 69 6c 6c 20 |e that y|ou will |
|00004560| 75 73 65 20 00 09 00 ff | ff 6e 45 07 00 00 19 00 |use ....|.nE.....|
|00004570| 4c 20 72 65 70 6c 69 63 | 61 74 65 64 20 66 6f 72 |L replic|ated for|
|00004580| 6d 75 6c 61 73 2e 00 09 | 00 ff ff 90 45 07 00 00 |mulas...|....E...|
|00004590| 46 00 4c 20 66 6f 72 20 | 61 6e 79 20 6d 6f 6e 74 |F.L for |any mont|
|000045a0| 68 2e 20 20 4d 6f 76 65 | 20 74 68 65 20 63 75 72 |h. Move| the cur|
|000045b0| 73 6f 72 20 62 61 63 6b | 77 61 72 64 20 61 6c 6f |sor back|ward alo|
|000045c0| 6e 67 20 6c 69 6e 65 20 | 31 38 20 74 6f 20 73 65 |ng line |18 to se|
|000045d0| 65 20 74 68 65 00 09 00 | ff ff df 45 07 00 00 49 |e the...|...E...I|
|000045e0| 00 4c 20 69 73 20 6e 6f | 77 20 64 69 73 70 6c 61 |.L is no|w displa|
|000045f0| 79 65 64 2c 20 69 6e 64 | 69 63 61 74 69 6e 67 20 |yed, ind|icating |
|00004600| 74 68 61 74 20 73 6f 20 | 66 61 72 20 6e 6f 20 63 |that so |far no c|
|00004610| 61 73 68 20 68 61 73 20 | 62 65 65 6e 20 70 61 69 |ash has |been pai|
|00004620| 64 20 27 6f 75 74 27 00 | 09 00 ff ff 31 46 07 00 |d 'out'.|....1F..|
|00004630| 00 4b 00 4c 20 62 6f 78 | 65 73 20 69 6e 20 6c 69 |.K.L box|es in li|
|00004640| 6e 65 20 31 38 2c 20 46 | 65 62 72 75 61 72 79 20 |ne 18, F|ebruary |
|00004650| 74 6f 20 44 65 63 65 6d | 62 65 72 2e 20 20 41 74 |to Decem|ber. At|
|00004660| 20 65 61 63 68 20 65 6e | 74 72 79 20 74 68 65 20 | each en|try the |
|00004670| 76 61 6c 75 65 20 27 30 | 27 20 20 00 09 00 ff ff |value '0|' .....|
|00004680| 8e 46 07 00 00 09 00 ff | ff 00 00 07 00 00 48 00 |.F......|......H.|
|00004690| 4c 20 20 20 20 20 20 20 | 50 65 72 66 65 63 74 20 |L |Perfect |
|000046a0| 43 61 6c 63 20 69 6d 6d | 65 64 69 61 74 65 6c 79 |Calc imm|ediately|
|000046b0| 20 72 65 70 6c 69 63 61 | 74 65 73 20 74 68 65 20 | replica|tes the |
|000046c0| 66 6f 72 6d 75 6c 61 20 | 74 6f 20 74 68 65 20 65 |formula |to the e|
|000046d0| 6e 74 72 79 20 00 09 00 | ff ff df 46 07 00 00 46 |ntry ...|...F...F|
|000046e0| 00 4c 20 66 6f 72 20 79 | 65 73 2e 20 20 54 68 65 |.L for y|es. The|
|000046f0| 20 71 75 65 73 74 69 6f | 6e 20 69 73 20 61 73 6b | questio|n is ask|
|00004700| 65 64 20 66 6f 72 20 27 | 62 31 36 27 2e 20 41 67 |ed for '|b16'. Ag|
|00004710| 61 69 6e 20 74 68 65 20 | 61 6e 73 77 65 72 2c 20 |ain the |answer, |
|00004720| 27 79 27 2e 00 09 00 ff | ff 2e 47 07 00 00 49 00 |'y'.....|..G...I.|
|00004730| 4c 20 48 65 72 65 2c 20 | 74 68 65 20 76 61 72 69 |L Here, |the vari|
|00004740| 61 62 6c 65 20 27 62 31 | 33 27 20 69 73 20 62 72 |able 'b1|3' is br|
|00004750| 61 63 6b 65 74 65 64 2e | 20 54 68 65 20 61 6e 73 |acketed.| The ans|
|00004760| 77 65 72 2c 20 6f 66 20 | 63 6f 75 72 73 65 2c 20 |wer, of |course, |
|00004770| 69 73 20 27 79 27 00 09 | 00 ff ff 80 47 07 00 00 |is 'y'..|....G...|
|00004780| 34 00 4c 20 20 20 20 20 | 20 20 20 20 20 20 20 62 |4.L | b|
|00004790| 31 38 20 3d 20 73 75 6d | 28 20 3e 62 31 33 3c 20 |18 = sum|( >b13< |
|000047a0| 3a 62 31 36 29 2e 20 2e | 20 2e 52 65 6c 61 74 69 |:b16). .| .Relati|
|000047b0| 76 65 3f 00 4a 00 4c 20 | 66 6f 72 6d 75 6c 61 20 |ve?.J.L |formula |
|000047c0| 69 6e 20 74 68 65 20 50 | 72 6f 6d 70 74 20 4c 69 |in the P|rompt Li|
|000047d0| 6e 65 20 61 6e 64 20 27 | 62 72 61 63 6b 65 74 69 |ne and '|bracketi|
|000047e0| 6e 67 27 20 74 68 65 20 | 76 61 72 69 61 62 6c 65 |ng' the |variable|
|000047f0| 20 69 6e 20 71 75 65 73 | 74 69 6f 6e 3a 00 00 00 | in ques|tion:...|
|00004800| 07 00 00 00 00 00 00 11 | 00 ff ff 82 4f 6c 65 73 |........|....Oles|
|00004810| 20 73 61 76 65 07 00 00 | 09 00 ff ff ca 4f 07 00 | save...|.....O..|
|00004820| 00 09 00 ff ff 33 48 07 | 00 00 09 00 ff ff 00 00 |.....3H.|........|
|00004830| 07 00 00 4a 00 4c 20 20 | 20 20 20 20 20 57 69 74 |...J.L | Wit|
|00004840| 68 20 74 68 65 20 63 75 | 72 73 6f 72 20 61 74 20 |h the cu|rsor at |
|00004850| 74 68 65 20 62 65 67 69 | 6e 6e 69 6e 67 20 6f 66 |the begi|nning of|
|00004860| 20 74 68 65 20 6e 65 77 | 20 6c 69 6e 65 20 31 36 | the new| line 16|
|00004870| 2c 20 70 72 65 73 73 20 | 74 68 65 20 00 09 00 ff |, press |the ....|
|00004880| ff 86 48 07 00 00 42 00 | 4c 20 6c 69 6e 65 73 20 |..H...B.|L lines |
|00004890| 68 61 76 65 20 62 65 65 | 6e 20 6d 6f 64 69 66 69 |have bee|n modifi|
|000048a0| 65 64 20 74 6f 20 72 65 | 66 6c 65 63 74 20 74 68 |ed to re|flect th|
|000048b0| 65 69 72 20 6e 65 77 20 | 6c 69 6e 65 20 70 6f 73 |eir new |line pos|
|000048c0| 69 74 69 6f 6e 73 2e 00 | 09 00 ff ff d1 48 07 00 |itions..|.....H..|
|000048d0| 00 42 00 4c 20 43 61 73 | 68 20 46 6c 6f 77 20 4f |.B.L Cas|h Flow O|
|000048e0| 75 74 27 20 6c 69 6e 65 | 20 31 39 2c 20 65 74 63 |ut' line| 19, etc|
|000048f0| 2e 20 20 41 6c 6c 20 66 | 6f 72 6d 75 6c 61 73 20 |. All f|ormulas |
|00004900| 63 6f 6e 74 61 69 6e 65 | 64 20 69 6e 20 74 68 65 |containe|d in the|
|00004910| 73 65 00 09 00 ff ff 1c | 49 07 00 00 46 00 4c 20 |se......|I...F.L |
|00004920| 6c 69 6e 65 73 20 62 65 | 6c 6f 77 20 69 74 20 64 |lines be|low it d|
|00004930| 6f 77 6e 20 6f 6e 65 20 | 6c 69 6e 65 2e 20 20 27 |own one |line. '|
|00004940| 4f 74 68 65 72 27 20 68 | 61 73 20 62 65 63 6f 6d |Other' h|as becom|
|00004950| 65 20 6c 69 6e 65 20 31 | 37 2c 20 27 54 6f 74 61 |e line 1|7, 'Tota|
|00004960| 6c 00 09 00 ff ff 74 49 | 07 00 00 09 00 ff ff 00 |l.....tI|........|
|00004970| 00 07 00 00 46 00 4c 20 | 20 20 20 20 20 20 50 65 |....F.L | Pe|
|00004980| 72 66 65 63 74 20 43 61 | 6c 63 20 69 6e 73 65 72 |rfect Ca|lc inser|
|00004990| 74 73 20 61 20 62 6c 61 | 6e 6b 20 6c 69 6e 65 2c |ts a bla|nk line,|
|000049a0| 20 73 68 69 66 74 69 6e | 67 20 27 4f 74 68 65 72 | shiftin|g 'Other|
|000049b0| 27 20 61 6e 64 20 61 6c | 6c 00 09 00 ff ff c3 49 |' and al|l......I|
|000049c0| 07 00 00 43 00 4c 20 20 | 20 20 20 20 20 20 20 20 |...C.L | |
|000049d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049e0| 20 20 20 43 6f 6e 74 72 | 6f 6c 2d 2d 6f 20 20 28 | Contr|ol--o (|
|000049f0| 6c 6f 77 65 72 63 61 73 | 65 20 6c 65 74 74 65 72 |lowercas|e letter|
|00004a00| 20 27 6f 27 29 00 09 00 | ff ff 0f 4a 07 00 00 20 | 'o')...|...J... |
|00004a10| 00 4c 20 54 79 70 65 20 | 74 68 65 20 4f 50 45 4e |.L Type |the OPEN|
|00004a20| 20 4c 49 4e 45 20 43 6f | 6d 6d 61 6e 64 3a 00 09 | LINE Co|mmand:..|
|00004a30| 00 ff ff 38 4a 07 00 00 | 48 00 4c 20 70 6f 73 69 |...8J...|H.L posi|
|00004a40| 74 69 6f 6e 20 74 68 65 | 20 63 75 72 73 6f 72 20 |tion the| cursor |
|00004a50| 6f 6e 20 65 6e 74 72 79 | 20 62 6f 78 20 27 61 31 |on entry| box 'a1|
|00004a60| 36 27 2c 20 77 68 65 72 | 65 20 27 4f 74 68 65 72 |6', wher|e 'Other|
|00004a70| 27 20 69 73 20 64 69 73 | 70 6c 61 79 65 64 2e 00 |' is dis|played..|
|00004a80| 09 00 ff ff 89 4a 07 00 | 00 43 00 4c 20 62 65 74 |.....J..|.C.L bet|
|00004a90| 77 65 65 6e 20 27 53 75 | 70 70 6c 69 65 73 27 2c |ween 'Su|pplies',|
|00004aa0| 20 6c 69 6e 65 20 31 35 | 2c 20 61 6e 64 20 27 4f | line 15|, and 'O|
|00004ab0| 74 68 65 72 27 2c 20 6c | 69 6e 65 20 31 36 2e 20 |ther', l|ine 16. |
|00004ac0| 20 54 68 65 72 65 66 6f | 72 65 2c 00 09 00 ff ff | Therefo|re,.....|
|00004ad0| d5 4a 07 00 00 44 00 4c | 20 73 6f 6d 65 77 68 65 |.J...D.L| somewhe|
|00004ae0| 72 65 20 57 49 54 48 49 | 4e 20 74 68 65 20 72 61 |re WITHI|N the ra|
|00004af0| 6e 67 65 20 6f 66 20 65 | 78 70 65 6e 73 65 73 20 |nge of e|xpenses |
|00004b00| 61 6c 72 65 61 64 79 20 | 70 72 65 73 65 6e 74 2c |already |present,|
|00004b10| 20 70 65 72 68 61 70 73 | 00 09 00 ff ff 22 4b 07 | perhaps|....."K.|
|00004b20| 00 00 47 00 4c 20 70 68 | 6f 6e 65 20 65 78 70 65 |..G.L ph|one expe|
|00004b30| 6e 73 65 73 20 75 6e 64 | 65 72 20 27 43 61 73 68 |nses und|er 'Cash|
|00004b40| 20 46 6c 6f 77 20 4f 75 | 74 27 2e 20 20 54 68 65 | Flow Ou|t'. The|
|00004b50| 20 6c 69 6e 65 20 73 68 | 6f 75 6c 64 20 62 65 20 | line sh|ould be |
|00004b60| 69 6e 73 65 72 74 65 64 | 00 09 00 ff ff 7b 4b 07 |inserted|.....{K.|
|00004b70| 00 00 09 00 ff ff 00 00 | 07 00 00 46 00 4c 20 20 |........|...F.L |
|00004b80| 20 20 20 20 20 46 6f 72 | 20 65 78 61 6d 70 6c 65 | For| example|
|00004b90| 2c 20 73 75 70 70 6f 73 | 65 20 74 68 61 74 20 77 |, suppos|e that w|
|00004ba0| 65 20 77 69 73 68 65 64 | 20 74 6f 20 61 64 64 20 |e wished| to add |
|00004bb0| 61 20 6c 69 6e 65 20 72 | 65 63 6f 72 64 69 6e 67 |a line r|ecording|
|00004bc0| 00 09 00 ff ff ca 4b 07 | 00 00 34 00 4c 20 77 61 |......K.|..4.L wa|
|00004bd0| 73 20 66 6f 72 67 6f 74 | 74 65 6e 20 77 68 65 6e |s forgot|ten when|
|00004be0| 20 74 68 65 20 73 70 72 | 65 61 64 73 68 65 65 74 | the spr|eadsheet|
|00004bf0| 20 77 61 73 20 63 72 65 | 61 74 65 64 2e 00 00 00 | was cre|ated....|
|00004c00| 07 00 00 00 00 00 00 0b | 00 ff ff b3 53 00 00 07 |........|....S...|
|00004c10| 00 00 09 00 ff ff 00 00 | 07 00 00 09 00 ff ff 24 |........|.......$|
|00004c20| 4c 07 00 00 47 00 4c 20 | 77 69 6c 6c 20 68 61 76 |L...G.L |will hav|
|00004c30| 65 20 74 6f 20 62 65 20 | 61 6c 74 65 72 65 64 20 |e to be |altered |
|00004c40| 6d 61 6e 75 61 6c 6c 79 | 20 74 6f 20 74 61 6b 65 |manually| to take|
|00004c50| 20 61 63 63 6f 75 6e 74 | 20 6f 66 20 74 68 65 20 | account| of the |
|00004c60| 69 6e 73 65 72 74 69 6f | 6e 2e 00 09 00 ff ff 74 |insertio|n......t|
|00004c70| 4c 07 00 00 48 00 4c 20 | 63 6f 75 72 73 65 2c 20 |L...H.L |course, |
|00004c80| 69 66 20 74 68 65 20 6c | 69 6e 65 20 69 73 20 69 |if the l|ine is i|
|00004c90| 6e 73 65 72 74 65 64 20 | 6f 75 74 73 69 64 65 20 |nserted |outside |
|00004ca0| 74 68 65 20 72 61 6e 67 | 65 2c 20 74 68 65 6e 20 |the rang|e, then |
|00004cb0| 74 68 65 20 66 6f 72 6d | 75 6c 61 00 09 00 ff ff |the form|ula.....|
|00004cc0| c5 4c 07 00 00 48 00 4c | 20 72 61 6e 67 65 20 6f |.L...H.L| range o|
|00004cd0| 66 20 65 6e 74 72 69 65 | 73 2c 20 61 6e 64 20 61 |f entrie|s, and a|
|00004ce0| 6d 6f 6e 67 20 77 68 69 | 63 68 20 61 20 6e 65 77 |mong whi|ch a new|
|00004cf0| 20 6c 69 6e 65 20 68 61 | 73 20 62 65 65 6e 20 69 | line ha|s been i|
|00004d00| 6e 73 65 72 74 65 64 2e | 20 20 4f 66 00 09 00 ff |nserted.| Of....|
|00004d10| ff 1f 4d 07 00 00 09 00 | ff ff 00 00 07 00 00 48 |..M.....|.......H|
|00004d20| 00 4c 20 20 20 20 20 20 | 20 50 65 72 66 65 63 74 |.L | Perfect|
|00004d30| 20 43 61 6c 63 20 77 69 | 6c 6c 20 61 75 74 6f 6d | Calc wi|ll autom|
|00004d40| 61 74 69 63 61 6c 6c 79 | 20 61 6c 74 65 72 20 66 |atically| alter f|
|00004d50| 6f 72 6d 75 6c 61 73 20 | 74 68 61 74 20 63 6f 6d |ormulas |that com|
|00004d60| 70 75 74 65 20 61 00 09 | 00 ff ff 79 4d 07 00 00 |pute a..|...yM...|
|00004d70| 09 00 ff ff 00 00 07 00 | 00 3e 00 4c 20 20 20 20 |........|.>.L |
|00004d80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004d90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004da0| 20 20 20 20 62 31 39 20 | 3d 20 73 75 6d 28 62 31 | b19 |= sum(b1|
|00004db0| 33 3a 62 31 37 29 00 09 | 00 ff ff c9 4d 07 00 00 |3:b17)..|....M...|
|00004dc0| 09 00 ff ff 00 00 07 00 | 00 38 00 4c 20 20 20 20 |........|.8.L |
|00004dd0| 20 20 20 41 66 74 65 72 | 20 74 68 65 20 6e 65 77 | After| the new|
|00004de0| 20 6c 69 6e 65 20 77 61 | 73 20 69 6e 73 65 72 74 | line wa|s insert|
|00004df0| 65 64 2c 20 74 68 69 73 | 20 62 65 63 61 6d 65 3a |ed, this| became:|
|00004e00| 00 09 00 ff ff 0a 4e 07 | 00 00 43 00 4c 20 20 20 |......N.|..C.L |
|00004e10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004e30| 20 20 20 20 20 20 20 20 | 20 20 62 31 38 20 3d 20 | | b18 = |
|00004e40| 73 75 6d 28 62 31 33 3a | 62 31 36 29 00 09 00 ff |sum(b13:|b16)....|
|00004e50| ff 56 4e 07 00 00 30 00 | 4c 20 65 6e 74 72 79 20 |.VN...0.|L entry |
|00004e60| 62 6f 78 20 27 62 31 39 | 27 2e 20 20 54 68 65 20 |box 'b19|'. The |
|00004e70| 6f 72 69 67 69 6e 61 6c | 20 66 6f 72 6d 75 6c 61 |original| formula|
|00004e80| 20 77 61 73 3a 00 09 00 | ff ff 8f 4e 07 00 00 4c | was:...|...N...L|
|00004e90| 00 4c 20 61 75 74 6f 6d | 61 74 69 63 61 6c 6c 79 |.L autom|atically|
|00004ea0| 20 62 65 65 6e 20 61 6c | 74 65 72 65 64 20 74 6f | been al|tered to|
|00004eb0| 20 69 6e 63 6c 75 64 65 | 20 74 68 65 20 6e 65 77 | include| the new|
|00004ec0| 20 6c 69 6e 65 2e 20 20 | 4d 6f 76 65 20 74 68 65 | line. |Move the|
|00004ed0| 20 63 75 72 73 6f 72 20 | 74 6f 00 09 00 ff ff e4 | cursor |to......|
|00004ee0| 4e 07 00 00 4b 00 4c 20 | 73 68 65 65 74 20 77 68 |N...K.L |sheet wh|
|00004ef0| 69 63 68 20 72 65 66 65 | 72 65 6e 63 65 64 20 74 |ich refe|renced t|
|00004f00| 68 69 73 20 72 61 6e 67 | 65 20 6f 66 20 6c 69 6e |his rang|e of lin|
|00004f10| 65 73 20 28 27 54 6f 74 | 61 6c 20 43 61 73 68 20 |es ('Tot|al Cash |
|00004f20| 46 6c 6f 77 20 4f 75 74 | 27 29 20 68 61 73 00 09 |Flow Out|') has..|
|00004f30| 00 ff ff 38 4f 07 00 00 | 4a 00 4c 20 69 6e 74 65 |...8O...|J.L inte|
|00004f40| 67 72 61 74 65 64 20 69 | 6e 74 6f 20 74 68 65 20 |grated i|nto the |
|00004f50| 73 70 72 65 61 64 73 68 | 65 65 74 2e 20 20 54 68 |spreadsh|eet. Th|
|00004f60| 61 74 20 69 73 2c 20 74 | 68 65 20 66 6f 72 6d 75 |at is, t|he formu|
|00004f70| 6c 61 20 69 6e 20 74 68 | 65 20 73 70 72 65 61 64 |la in th|e spread|
|00004f80| 2d 00 48 00 4c 20 20 20 | 20 20 20 20 49 74 20 73 |-.H.L | It s|
|00004f90| 68 6f 75 6c 64 20 62 65 | 20 65 6d 70 68 61 73 69 |hould be| emphasi|
|00004fa0| 7a 65 64 20 74 68 61 74 | 20 74 68 65 20 6e 65 77 |zed that| the new|
|00004fb0| 20 6c 69 6e 65 20 68 61 | 73 20 62 65 65 6e 20 63 | line ha|s been c|
|00004fc0| 6f 6d 70 6c 65 74 65 6c | 79 00 34 00 4c 20 73 70 |ompletel|y.4.L sp|
|00004fd0| 61 63 65 20 62 61 72 20 | 33 20 74 69 6d 65 73 20 |ace bar |3 times |
|00004fe0| 61 6e 64 20 74 79 70 65 | 20 74 68 65 20 6c 61 62 |and type| the lab|
|00004ff0| 65 6c 20 27 50 6f 73 74 | 61 67 65 27 2e 00 00 00 |el 'Post|age'....|
|00005000| 07 00 00 00 00 00 00 09 | 00 ff ff 10 50 07 00 00 |........|....P...|
|00005010| 45 00 4c 20 20 20 20 20 | 20 20 44 65 6c 65 74 69 |E.L | Deleti|
|00005020| 6e 67 20 61 20 6c 69 6e | 65 20 6f 72 20 63 6f 6c |ng a lin|e or col|
|00005030| 75 6d 6e 20 66 72 6f 6d | 20 61 20 73 70 72 65 61 |umn from| a sprea|
|00005040| 64 73 68 65 65 74 20 69 | 73 20 61 73 20 65 61 73 |dsheet i|s as eas|
|00005050| 79 20 61 73 00 09 00 ff | ff 5e 50 07 00 00 0e 00 |y as....|.^P.....|
|00005060| 4c 20 20 44 45 4c 45 54 | 49 4e 47 00 09 00 ff ff |L DELET|ING.....|
|00005070| 75 50 07 00 00 3a 00 4c | 20 69 6e 20 63 6f 6c 75 |uP...:.L| in colu|
|00005080| 6d 6e 20 27 63 27 20 68 | 61 73 20 62 65 65 6e 20 |mn 'c' h|as been |
|00005090| 6d 6f 76 65 64 20 74 6f | 20 63 6f 6c 75 6d 6e 20 |moved to| column |
|000050a0| 27 64 27 20 61 6e 64 20 | 73 6f 20 6f 6e 2e 00 09 |'d' and |so on...|
|000050b0| 00 ff ff b8 50 07 00 00 | 4b 00 4c 20 6f 76 65 72 |....P...|K.L over|
|000050c0| 20 31 2e 20 20 57 68 61 | 74 20 77 61 73 20 69 6e | 1. Wha|t was in|
|000050d0| 20 63 6f 6c 75 6d 6e 20 | 27 62 27 20 68 61 73 20 | column |'b' has |
|000050e0| 62 65 65 6e 20 6d 6f 76 | 65 64 20 74 6f 20 63 6f |been mov|ed to co|
|000050f0| 6c 75 6d 6e 20 27 63 27 | 2c 20 77 68 61 74 20 77 |lumn 'c'|, what w|
|00005100| 61 73 00 09 00 ff ff 15 | 51 07 00 00 09 00 ff ff |as......|Q.......|
|00005110| 00 00 07 00 00 4b 00 4c | 20 20 20 20 20 50 65 72 |.....K.L| Per|
|00005120| 66 65 63 74 20 43 61 6c | 63 20 69 6e 73 65 72 74 |fect Cal|c insert|
|00005130| 73 20 61 20 6e 65 77 20 | 63 6f 6c 75 6d 6e 20 27 |s a new |column '|
|00005140| 62 27 20 6d 6f 76 69 6e | 67 20 61 6c 6c 20 74 68 |b' movin|g all th|
|00005150| 65 20 6f 74 68 65 72 20 | 63 6f 6c 75 6d 6e 73 00 |e other |columns.|
|00005160| 09 00 ff ff 69 51 07 00 | 00 3d 00 4c 20 20 20 20 |....iQ..|.=.L |
|00005170| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005180| 20 20 20 20 20 20 20 20 | 45 73 63 61 70 65 2e 2e | |Escape..|
|00005190| 2e 6f 20 20 20 7b 74 68 | 65 20 6c 65 74 74 65 72 |.o {th|e letter|
|000051a0| 20 27 6f 27 7d 00 09 00 | ff ff af 51 07 00 00 19 | 'o'}...|...Q....|
|000051b0| 00 4c 20 4f 50 45 4e 20 | 43 4f 4c 55 4d 4e 20 43 |.L OPEN |COLUMN C|
|000051c0| 6f 6d 6d 61 6e 64 3a 00 | 09 00 ff ff d1 51 07 00 |ommand:.|.....Q..|
|000051d0| 00 4b 00 4c 20 61 74 20 | 74 68 65 20 70 6f 73 69 |.K.L at |the posi|
|000051e0| 74 69 6f 6e 20 6f 66 20 | 74 68 65 20 63 75 72 73 |tion of |the curs|
|000051f0| 6f 72 2e 20 20 57 69 74 | 68 20 74 68 65 20 63 75 |or. Wit|h the cu|
|00005200| 72 73 6f 72 20 69 6e 20 | 63 6f 6c 75 6d 6e 20 27 |rsor in |column '|
|00005210| 62 27 20 74 79 70 65 20 | 74 68 65 00 09 00 ff ff |b' type |the.....|
|00005220| 25 52 07 00 00 4b 00 4c | 20 61 20 6c 69 6e 65 20 |%R...K.L| a line |
|00005230| 65 78 63 65 70 74 20 74 | 68 61 74 20 50 65 72 66 |except t|hat Perf|
|00005240| 65 63 74 20 43 61 6c 63 | 20 6f 70 65 6e 73 20 61 |ect Calc| opens a|
|00005250| 20 6e 65 77 20 63 6f 6c | 75 6d 6e 2c 20 69 6e 73 | new col|umn, ins|
|00005260| 74 65 61 64 20 6f 66 20 | 61 20 6c 69 6e 65 2c 00 |tead of |a line,.|
|00005270| 09 00 ff ff 82 52 07 00 | 00 09 00 ff ff 00 00 07 |.....R..|........|
|00005280| 00 00 4c 00 4c 20 20 20 | 20 20 20 20 49 6e 73 65 |..L.L | Inse|
|00005290| 72 74 69 6e 67 20 61 20 | 63 6f 6c 75 6d 6e 20 69 |rting a |column i|
|000052a0| 73 20 70 65 72 66 6f 72 | 6d 65 64 20 69 6e 20 61 |s perfor|med in a|
|000052b0| 20 73 69 6d 69 6c 61 72 | 20 66 61 73 68 69 6f 6e | similar| fashion|
|000052c0| 20 74 6f 20 69 6e 73 65 | 72 74 69 6e 67 00 09 00 | to inse|rting...|
|000052d0| ff ff d7 52 07 00 00 3f | 00 4c 20 68 61 76 65 20 |...R...?|.L have |
|000052e0| 68 61 64 20 74 6f 20 62 | 65 20 6d 61 6e 75 61 6c |had to b|e manual|
|000052f0| 6c 79 20 61 6c 74 65 72 | 65 64 20 74 6f 20 69 6e |ly alter|ed to in|
|00005300| 63 6c 75 64 65 20 70 6f | 73 69 74 69 6f 6e 20 27 |clude po|sition '|
|00005310| 62 31 37 27 2e 00 09 00 | ff ff 1f 53 07 00 00 47 |b17'....|...S...G|
|00005320| 00 4c 20 6f 72 69 67 69 | 6e 61 6c 6c 79 20 69 6e |.L origi|nally in|
|00005330| 63 6c 75 64 65 64 20 6f | 6e 6c 79 20 76 61 6c 75 |cluded o|nly valu|
|00005340| 65 73 20 69 6e 20 74 68 | 65 20 72 61 6e 67 65 20 |es in th|e range |
|00005350| 27 62 31 33 27 20 74 6f | 20 27 62 31 36 27 20 77 |'b13' to| 'b16' w|
|00005360| 6f 75 6c 64 20 00 09 00 | ff ff 6f 53 07 00 00 44 |ould ...|..oS...D|
|00005370| 00 4c 20 31 37 2c 20 74 | 68 65 20 66 6f 72 6d 75 |.L 17, t|he formu|
|00005380| 6c 61 20 77 68 69 63 68 | 20 63 6f 6d 70 75 74 65 |la which| compute|
|00005390| 73 20 27 54 6f 74 61 6c | 20 43 61 73 68 20 46 6c |s 'Total| Cash Fl|
|000053a0| 6f 77 20 4f 75 74 27 2c | 20 61 6e 64 20 77 68 69 |ow Out',| and whi|
|000053b0| 63 68 00 4b 00 4c 20 20 | 20 20 20 20 20 46 6f 72 |ch.K.L | For|
|000053c0| 20 65 78 61 6d 70 6c 65 | 2c 20 69 66 20 77 65 20 | example|, if we |
|000053d0| 68 61 64 20 69 6e 73 65 | 72 74 65 64 20 27 50 6f |had inse|rted 'Po|
|000053e0| 73 74 61 67 65 27 20 42 | 45 4c 4f 57 20 27 4f 74 |stage' B|ELOW 'Ot|
|000053f0| 68 65 72 27 2c 20 61 74 | 20 6c 69 6e 65 00 00 00 |her', at| line...|
|00005400| 07 00 00 00 00 00 00 0a | 00 ff ff 11 54 20 07 00 |........|....T ..|
|00005410| 00 12 00 4c 20 55 73 65 | 72 27 73 20 47 75 69 64 |...L Use|r's Guid|
|00005420| 65 2e 00 09 00 ff ff 35 | 54 07 00 00 09 00 ff ff |e......5|T.......|
|00005430| 00 00 07 00 00 4a 00 4c | 20 44 65 74 61 69 6c 73 |.....J.L| Details|
|00005440| 20 66 6f 72 20 6f 74 68 | 65 72 20 64 65 6c 65 74 | for oth|er delet|
|00005450| 65 20 6f 70 65 72 61 74 | 69 6f 6e 73 20 61 72 65 |e operat|ions are|
|00005460| 20 70 72 6f 76 69 64 65 | 64 20 69 6e 20 79 6f 75 | provide|d in you|
|00005470| 72 20 50 65 72 66 65 63 | 74 20 43 61 6c 63 00 09 |r Perfec|t Calc..|
|00005480| 00 ff ff 91 54 07 00 00 | 09 00 ff ff 00 00 07 00 |....T...|........|
|00005490| 00 26 00 4c 20 20 20 20 | 20 20 20 20 20 20 20 20 |.&.L | |
|000054a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 45 73 63 61 | | Esca|
|000054b0| 70 65 2e 2e 2e 63 00 09 | 00 ff ff c0 54 07 00 00 |pe...c..|....T...|
|000054c0| 2a 00 4c 20 61 6e 64 20 | 65 6e 74 65 72 20 74 68 |*.L and |enter th|
|000054d0| 65 20 44 45 4c 45 54 45 | 20 43 4f 4c 55 4d 4e 20 |e DELETE| COLUMN |
|000054e0| 43 6f 6d 6d 61 6e 64 3a | 20 00 09 00 ff ff f3 54 |Command:| ......T|
|000054f0| 07 00 00 4b 00 4c 20 69 | 6e 73 65 72 74 65 64 20 |...K.L i|nserted |
|00005500| 69 6e 20 63 6f 6c 75 6d | 6e 20 27 62 27 2e 20 20 |in colum|n 'b'. |
|00005510| 4d 6f 76 65 20 74 68 65 | 20 63 75 72 73 6f 72 20 |Move the| cursor |
|00005520| 74 6f 20 61 6e 79 20 70 | 6f 73 69 74 69 6f 6e 20 |to any p|osition |
|00005530| 69 6e 20 63 6f 6c 75 6d | 6e 20 27 62 27 00 09 00 |in colum|n 'b'...|
|00005540| ff ff 47 55 07 00 00 48 | 00 4c 20 63 6f 6c 75 6d |..GU...H|.L colum|
|00005550| 6e 73 2c 20 61 6e 64 20 | 65 76 65 6e 20 72 65 67 |ns, and |even reg|
|00005560| 69 6f 6e 73 20 6f 66 20 | 64 61 74 61 2e 20 20 4c |ions of |data. L|
|00005570| 65 74 20 75 73 20 64 65 | 6c 65 74 65 20 74 68 65 |et us de|lete the|
|00005580| 20 6e 65 77 20 63 6f 6c | 75 6d 6e 20 77 65 00 09 | new col|umn we..|
|00005590| 00 ff ff a1 55 07 00 00 | 09 00 ff ff 00 00 07 00 |....U...|........|
|000055a0| 00 48 00 4c 20 20 20 20 | 20 20 20 49 74 20 69 73 |.H.L | It is|
|000055b0| 20 70 6f 73 73 69 62 6c | 65 20 74 6f 20 64 65 6c | possibl|e to del|
|000055c0| 65 74 65 20 6e 6f 74 20 | 6f 6e 6c 79 20 6c 69 6e |ete not |only lin|
|000055d0| 65 73 2c 20 62 75 74 20 | 73 69 6e 67 6c 65 20 65 |es, but |single e|
|000055e0| 6e 74 72 69 65 73 2c 20 | 00 09 00 ff ff f2 55 07 |ntries, |......U.|
|000055f0| 00 00 44 00 4c 20 77 69 | 74 68 69 6e 20 74 68 65 |..D.L wi|thin the|
|00005600| 73 65 20 6c 69 6e 65 73 | 20 61 72 65 20 61 64 6a |se lines| are adj|
|00005610| 75 73 74 65 64 20 74 6f | 20 72 65 66 6c 65 63 74 |usted to| reflect|
|00005620| 20 74 68 65 69 72 20 6e | 65 77 20 70 6f 73 69 74 | their n|ew posit|
|00005630| 69 6f 6e 73 2e 00 09 00 | ff ff 3f 56 07 00 00 49 |ions....|..?V...I|
|00005640| 00 4c 20 62 79 20 6f 6e | 65 20 61 6e 64 20 72 65 |.L by on|e and re|
|00005650| 6e 75 6d 62 65 72 69 6e | 67 20 74 68 65 6d 2e 20 |numberin|g them. |
|00005660| 20 41 73 20 77 68 65 6e | 20 69 6e 73 65 72 74 69 | As when| inserti|
|00005670| 6e 67 20 61 20 6c 69 6e | 65 2c 20 61 6c 6c 20 66 |ng a lin|e, all f|
|00005680| 6f 72 6d 75 6c 61 73 00 | 09 00 ff ff 9a 56 07 00 |ormulas.|.....V..|
|00005690| 00 09 00 ff ff 00 00 07 | 00 00 4c 00 4c 20 50 65 |........|..L.L Pe|
|000056a0| 72 66 65 63 74 20 43 61 | 6c 63 20 64 65 6c 65 74 |rfect Ca|lc delet|
|000056b0| 65 73 20 74 68 65 20 6c | 69 6e 65 2c 20 73 68 69 |es the l|ine, shi|
|000056c0| 66 74 69 6e 67 20 61 6c | 6c 20 6c 69 6e 65 73 20 |fting al|l lines |
|000056d0| 62 65 6c 6f 77 20 74 68 | 65 20 64 65 6c 65 74 69 |below th|e deleti|
|000056e0| 6f 6e 20 75 70 00 09 00 | ff ff ef 56 07 00 00 39 |on up...|...V...9|
|000056f0| 00 4c 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.L | |
|00005700| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005710| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 43 6f 6e | | Con|
|00005720| 74 72 6f 6c 2d 2d 63 00 | 09 00 ff ff 31 57 07 00 |trol--c.|....1W..|
|00005730| 00 2b 00 4c 20 6c 69 6e | 65 20 61 6e 64 20 74 79 |.+.L lin|e and ty|
|00005740| 70 65 20 74 68 65 20 44 | 45 4c 45 54 45 20 4c 49 |pe the D|ELETE LI|
|00005750| 4e 45 20 43 6f 6d 6d 61 | 6e 64 3a 00 09 00 ff ff |NE Comma|nd:.....|
|00005760| 65 57 07 00 00 49 00 4c | 20 6c 69 6e 65 20 31 34 |eW...I.L| line 14|
|00005770| 2c 20 27 55 74 69 6c 69 | 74 69 65 73 27 2e 20 20 |, 'Utili|ties'. |
|00005780| 4d 6f 76 65 20 74 68 65 | 20 63 75 72 73 6f 72 20 |Move the| cursor |
|00005790| 74 6f 20 61 6e 79 20 65 | 6e 74 72 79 20 70 6f 73 |to any e|ntry pos|
|000057a0| 69 74 69 6f 6e 20 6f 6e | 20 74 68 69 73 00 09 00 |ition on| this...|
|000057b0| ff ff b7 57 07 00 00 47 | 00 4c 20 69 6e 73 65 72 |...W...G|.L inser|
|000057c0| 74 69 6e 67 20 61 20 6c | 69 6e 65 20 6f 72 20 63 |ting a l|ine or c|
|000057d0| 6f 6c 75 6d 6e 2e 20 20 | 4c 65 74 20 75 73 20 73 |olumn. |Let us s|
|000057e0| 75 70 70 6f 73 65 20 74 | 68 61 74 20 77 65 20 77 |uppose t|hat we w|
|000057f0| 69 73 68 20 74 6f 20 64 | 65 6c 65 74 65 00 00 00 |ish to d|elete...|
|00005800| 07 00 00 00 00 00 00 0e | 00 ff ff 4d 5f 07 00 00 |........|...M_...|
|00005810| 09 00 07 00 00 09 00 ff | ff 97 5f 07 00 00 09 00 |........|.._.....|
|00005820| ff ff b4 5f 07 00 00 09 | 00 ff ff 30 58 07 00 00 |..._....|...0X...|
|00005830| 4c 00 4c 20 72 65 73 65 | 72 76 65 64 20 73 70 61 |L.L rese|rved spa|
|00005840| 63 65 20 69 6e 20 63 6f | 6d 70 75 74 65 72 20 6d |ce in co|mputer m|
|00005850| 65 6d 6f 72 79 2e 20 20 | 49 74 20 69 73 20 74 68 |emory. |It is th|
|00005860| 65 72 65 66 6f 72 65 20 | 70 6f 73 73 69 62 6c 65 |erefore |possible|
|00005870| 20 74 6f 20 72 65 73 74 | 6f 72 65 00 09 00 ff ff | to rest|ore.....|
|00005880| 85 58 07 00 00 4c 00 4c | 20 20 20 50 65 72 66 65 |.X...L.L| Perfe|
|00005890| 63 74 20 43 61 6c 63 20 | 74 65 6d 70 6f 72 61 72 |ct Calc |temporar|
|000058a0| 69 6c 79 20 73 61 76 65 | 73 20 65 76 65 72 79 20 |ily save|s every |
|000058b0| 64 65 6c 65 74 69 6f 6e | 20 69 6e 20 69 74 73 20 |deletion| in its |
|000058c0| 27 53 61 76 65 20 42 75 | 66 66 65 72 27 2c 20 61 |'Save Bu|ffer', a|
|000058d0| 00 09 00 ff ff da 58 07 | 00 00 0e 00 4c 20 20 59 |......X.|....L Y|
|000058e0| 41 4e 4b 42 41 43 4b 00 | 09 00 ff ff f1 58 07 00 |ANKBACK.|.....X..|
|000058f0| 00 2d 00 4c 20 61 63 63 | 6f 72 64 69 6e 67 6c 79 |.-.L acc|ordingly|
|00005900| 20 62 65 66 6f 72 65 20 | 61 6e 79 20 64 65 6c 65 | before |any dele|
|00005910| 74 69 6f 6e 20 69 73 20 | 6d 61 64 65 2e 00 09 00 |tion is |made....|
|00005920| ff ff 27 59 07 00 00 44 | 00 4c 20 6d 69 67 68 74 |..'Y...D|.L might|
|00005930| 20 72 65 66 65 72 65 6e | 63 65 20 74 68 65 20 64 | referen|ce the d|
|00005940| 61 74 61 20 61 62 6f 75 | 74 20 74 6f 20 62 65 20 |ata abou|t to be |
|00005950| 64 65 6c 65 74 65 64 2c | 20 61 6e 64 20 74 6f 20 |deleted,| and to |
|00005960| 61 6c 74 65 72 20 74 68 | 65 6d 00 09 00 ff ff 74 |alter th|em.....t|
|00005970| 59 07 00 00 4a 00 4c 20 | 66 6f 72 65 2c 20 69 74 |Y...J.L |fore, it|
|00005980| 20 69 73 20 61 6c 77 61 | 79 73 20 61 20 67 6f 6f | is alwa|ys a goo|
|00005990| 64 20 68 61 62 69 74 20 | 74 6f 20 63 68 65 63 6b |d habit |to check|
|000059a0| 20 63 61 72 65 66 75 6c | 6c 79 20 66 6f 72 20 66 | careful|ly for f|
|000059b0| 6f 72 6d 75 6c 61 73 20 | 77 68 69 63 68 00 09 00 |ormulas |which...|
|000059c0| ff ff c7 59 07 00 00 49 | 00 4c 20 72 65 66 65 72 |...Y...I|.L refer|
|000059d0| 65 6e 63 65 20 54 48 41 | 54 20 66 6f 72 6d 75 6c |ence THA|T formul|
|000059e0| 61 20 77 69 6c 6c 20 61 | 6c 73 6f 20 62 65 67 69 |a will a|lso begi|
|000059f0| 6e 20 63 6f 6d 70 75 74 | 69 6e 67 20 74 6f 20 27 |n comput|ing to '|
|00005a00| 45 72 72 6f 72 21 27 20 | 20 54 68 65 72 65 2d 00 |Error!' | There-.|
|00005a10| 09 00 ff ff 19 5a 07 00 | 00 46 00 4c 20 72 65 66 |.....Z..|.F.L ref|
|00005a20| 65 72 65 6e 63 65 20 74 | 6f 20 61 20 6e 6f 6e 2d |erence t|o a non-|
|00005a30| 65 78 69 73 74 65 6e 74 | 20 6c 69 6e 65 20 6f 72 |existent| line or|
|00005a40| 20 63 6f 6c 75 6d 6e 2e | 20 20 4f 74 68 65 72 20 | column.| Other |
|00005a50| 66 6f 72 6d 75 6c 61 73 | 20 77 68 69 63 68 00 09 |formulas| which..|
|00005a60| 00 ff ff 68 5a 07 00 00 | 4a 00 4c 20 74 68 65 20 |...hZ...|J.L the |
|00005a70| 6e 65 78 74 20 72 65 63 | 61 6c 63 75 6c 61 74 69 |next rec|alculati|
|00005a80| 6f 6e 2e 20 20 54 68 65 | 20 66 6f 72 6d 75 6c 61 |on. The| formula|
|00005a90| 20 69 73 2c 20 69 6e 20 | 66 61 63 74 2c 20 6c 65 | is, in |fact, le|
|00005aa0| 66 74 20 77 69 74 68 20 | 61 20 27 62 6c 69 6e 64 |ft with |a 'blind|
|00005ab0| 27 00 09 00 ff ff bb 5a | 07 00 00 4a 00 4c 20 57 |'......Z|...J.L W|
|00005ac0| 68 65 6e 20 74 68 69 73 | 20 68 61 70 70 65 6e 73 |hen this| happens|
|00005ad0| 2c 20 74 68 65 20 72 65 | 66 65 72 65 6e 63 69 6e |, the re|ferencin|
|00005ae0| 67 20 66 6f 72 6d 75 6c | 61 20 6d 61 79 20 63 6f |g formul|a may co|
|00005af0| 6d 70 75 74 65 20 74 6f | 20 27 45 72 72 6f 72 21 |mpute to| 'Error!|
|00005b00| 27 20 61 74 00 09 00 ff | ff 0e 5b 07 00 00 4c 00 |' at....|..[...L.|
|00005b10| 4c 20 72 65 66 65 72 65 | 6e 63 65 64 20 62 79 20 |L refere|nced by |
|00005b20| 73 6f 6d 65 20 66 6f 72 | 6d 75 6c 61 20 76 61 72 |some for|mula var|
|00005b30| 69 61 62 6c 65 20 69 6e | 20 61 6e 6f 74 68 65 72 |iable in| another|
|00005b40| 20 70 61 72 74 20 6f 66 | 20 74 68 65 20 73 70 72 | part of| the spr|
|00005b50| 65 61 64 73 68 65 65 74 | 2e 00 09 00 ff ff 63 5b |eadsheet|......c[|
|00005b60| 07 00 00 47 00 4c 20 62 | 65 63 61 75 73 65 20 74 |...G.L b|ecause t|
|00005b70| 68 65 20 63 68 61 6e 63 | 65 20 65 78 69 73 74 73 |he chanc|e exists|
|00005b80| 20 74 68 61 74 20 74 68 | 65 20 64 65 6c 65 74 65 | that th|e delete|
|00005b90| 64 20 6c 69 6e 65 20 6f | 72 20 63 6f 6c 75 6d 6e |d line o|r column|
|00005ba0| 20 69 73 20 62 65 69 6e | 67 00 09 00 ff ff b3 5b | is bein|g......[|
|00005bb0| 07 00 00 4b 00 4c 20 20 | 20 20 20 20 20 57 65 20 |...K.L | We |
|00005bc0| 73 68 6f 75 6c 64 20 6e | 6f 74 65 20 74 68 61 74 |should n|ote that|
|00005bd0| 20 64 65 6c 65 74 69 6e | 67 20 64 61 74 61 20 6d | deletin|g data m|
|00005be0| 61 79 20 61 74 20 74 69 | 6d 65 73 20 65 6e 74 61 |ay at ti|mes enta|
|00005bf0| 69 6c 20 73 6f 6d 65 20 | 72 69 73 6b 2c 00 00 00 |il some |risk,...|
|00005c00| 07 00 00 00 00 00 00 0e | 00 ff ff 15 5c 20 20 20 |........|....\ |
|00005c10| 20 50 07 00 00 45 00 4c | 20 69 73 20 49 44 45 4e | P...E.L| is IDEN|
|00005c20| 54 49 43 41 4c 20 74 6f | 20 74 68 61 74 20 77 65 |TICAL to| that we|
|00005c30| 20 68 61 76 65 20 6a 75 | 73 74 20 73 65 65 6e 20 | have ju|st seen |
|00005c40| 66 6f 72 20 72 65 73 74 | 6f 72 69 6e 67 20 61 20 |for rest|oring a |
|00005c50| 64 65 6c 65 74 69 6f 6e | 2c 00 09 00 ff ff 63 5c |deletion|,.....c\|
|00005c60| 07 00 00 48 00 4c 20 20 | 20 20 20 20 20 54 68 65 |...H.L | The|
|00005c70| 20 50 72 6f 63 65 64 75 | 72 65 20 66 6f 72 20 27 | Procedu|re for '|
|00005c80| 6d 6f 76 69 6e 67 27 20 | 6c 69 6e 65 73 20 61 6e |moving' |lines an|
|00005c90| 64 20 63 6f 6c 75 6d 6e | 73 20 74 6f 20 6e 65 77 |d column|s to new|
|00005ca0| 20 6c 6f 63 61 74 69 6f | 6e 73 00 09 00 ff ff c6 | locatio|ns......|
|00005cb0| 5c 07 00 00 09 00 ff ff | 00 00 07 00 00 09 00 ff |\.......|........|
|00005cc0| ff 00 00 07 00 00 11 00 | 4c 20 20 4d 4f 56 49 4e |........|L MOVIN|
|00005cd0| 47 20 44 41 54 41 00 09 | 00 ff ff e9 5c 07 00 00 |G DATA..|....\...|
|00005ce0| 09 00 ff ff 00 00 07 00 | 00 3b 00 4c 20 20 20 20 |........|.;.L |
|00005cf0| 20 28 46 6f 72 20 6d 6f | 72 65 20 63 6f 6d 70 6c | (For mo|re compl|
|00005d00| 65 74 65 20 64 65 74 61 | 69 6c 73 20 73 65 65 20 |ete deta|ils see |
|00005d10| 79 6f 75 72 20 55 73 65 | 72 27 73 20 47 75 69 64 |your Use|r's Guid|
|00005d20| 65 2e 29 00 09 00 ff ff | 2d 5d 07 00 00 15 00 4c |e.).....|-].....L|
|00005d30| 20 69 6e 20 74 68 69 73 | 20 6d 61 6e 6e 65 72 2e | in this| manner.|
|00005d40| 20 00 09 00 ff ff 54 5d | 07 00 00 09 00 ff ff 00 | .....T]|........|
|00005d50| 00 07 00 00 4b 00 4c 20 | 20 20 20 20 44 65 6c 65 |....K.L | Dele|
|00005d60| 74 65 64 20 65 6e 74 72 | 69 65 73 2c 20 63 6f 6c |ted entr|ies, col|
|00005d70| 75 6d 6e 73 2c 20 61 6e | 64 20 72 65 67 69 6f 6e |umns, an|d region|
|00005d80| 73 20 6f 66 20 64 61 74 | 61 20 63 61 6e 20 61 6c |s of dat|a can al|
|00005d90| 73 6f 20 62 65 20 72 65 | 73 74 6f 72 65 64 00 09 |so be re|stored..|
|00005da0| 00 ff ff a8 5d 07 00 00 | 36 00 4c 20 61 6c 6c 20 |....]...|6.L all |
|00005db0| 6c 69 6e 65 73 20 62 65 | 6c 6f 77 20 74 68 69 73 |lines be|low this|
|00005dc0| 20 64 6f 77 6e 20 62 79 | 20 6f 6e 65 20 61 6e 64 | down by| one and|
|00005dd0| 20 72 65 6e 75 6d 62 65 | 72 69 6e 67 2e 00 09 00 | renumbe|ring....|
|00005de0| ff ff f0 5d 07 00 00 09 | 00 ff ff 00 00 07 00 00 |...]....|........|
|00005df0| 4b 00 4c 20 20 20 20 20 | 20 20 50 65 72 66 65 63 |K.L | Perfec|
|00005e00| 74 20 43 61 6c 63 20 69 | 6d 6d 65 64 69 61 74 65 |t Calc i|mmediate|
|00005e10| 6c 79 20 72 65 73 74 6f | 72 65 73 20 74 68 65 20 |ly resto|res the |
|00005e20| 27 53 75 70 70 6c 69 65 | 73 27 20 4c 69 6e 65 2c |'Supplie|s' Line,|
|00005e30| 20 73 68 69 66 74 69 6e | 67 20 00 09 00 ff ff 44 | shiftin|g .....D|
|00005e40| 5e 07 00 00 31 00 4c 20 | 2d 2d 20 54 79 70 65 20 |^...1.L |-- Type |
|00005e50| 74 68 65 20 59 41 4e 4b | 42 41 43 4b 20 43 6f 6d |the YANK|BACK Com|
|00005e60| 6d 61 6e 64 20 3a 20 20 | 20 43 6f 6e 74 72 6f 6c |mand : | Control|
|00005e70| 2d 2d 79 2e 00 09 00 ff | ff 7e 5e 07 00 00 4c 00 |--y.....|.~^...L.|
|00005e80| 4c 20 20 20 20 27 53 75 | 70 70 6c 69 65 73 27 20 |L 'Su|pplies' |
|00005e90| 4c 69 6e 65 20 62 65 69 | 6e 67 20 68 65 6c 64 20 |Line bei|ng held |
|00005ea0| 69 6e 20 74 68 65 20 27 | 53 61 76 65 20 42 75 66 |in the '|Save Buf|
|00005eb0| 66 65 72 27 2e 20 4c 6f | 6f 6b 20 61 74 20 74 68 |fer'. Lo|ok at th|
|00005ec0| 65 20 72 65 73 75 6c 74 | 2e 00 09 00 ff ff d3 5e |e result|.......^|
|00005ed0| 07 00 00 47 00 4c 20 2d | 2d 20 44 6f 20 6e 6f 74 |...G.L -|- Do not|
|00005ee0| 20 6d 61 6b 65 20 61 6e | 79 20 66 75 72 74 68 65 | make an|y furthe|
|00005ef0| 72 20 64 65 6c 65 74 69 | 6f 6e 73 2c 20 73 69 6e |r deleti|ons, sin|
|00005f00| 63 65 20 74 68 65 73 65 | 20 77 69 6c 6c 20 72 65 |ce these| will re|
|00005f10| 70 6c 61 63 65 20 74 68 | 65 00 09 00 ff ff 23 5f |place th|e.....#_|
|00005f20| 07 00 00 2a 00 4c 20 74 | 6f 20 6c 69 6e 65 20 31 |...*.L t|o line 1|
|00005f30| 34 20 61 6e 64 20 65 6e | 74 65 72 69 6e 67 3a 20 |4 and en|tering: |
|00005f40| 20 43 6f 6e 74 72 6f 6c | 2d 2d 63 2e 00 4a 00 4c | Control|--c..J.L|
|00005f50| 20 20 46 6f 72 20 65 78 | 61 6d 70 6c 65 2c 20 6c | For ex|ample, l|
|00005f60| 65 74 20 75 73 20 64 65 | 6c 65 74 65 20 74 68 65 |et us de|lete the|
|00005f70| 20 27 53 75 70 70 6c 69 | 65 73 27 20 6c 69 6e 65 | 'Suppli|es' line|
|00005f80| 20 62 79 20 6d 6f 76 69 | 6e 67 20 74 68 65 20 63 | by movi|ng the c|
|00005f90| 75 72 73 6f 72 20 00 1d | 00 4c 20 20 20 20 20 20 |ursor ..|.L |
|00005fa0| 20 20 20 20 20 20 20 20 | 20 43 6f 6e 74 72 6f 6c | | Control|
|00005fb0| 2d 2d 79 00 4a 00 4c 20 | 74 68 65 20 6d 6f 73 74 |--y.J.L |the most|
|00005fc0| 20 72 65 63 65 6e 74 20 | 64 65 6c 65 74 69 6f 6e | recent |deletion|
|00005fd0| 20 66 72 6f 6d 20 74 68 | 69 73 20 62 75 66 66 65 | from th|is buffe|
|00005fe0| 72 20 75 73 69 6e 67 20 | 74 68 65 20 59 41 4e 4b |r using |the YANK|
|00005ff0| 42 41 43 4b 20 43 6f 6d | 6d 61 6e 64 3a 00 00 00 |BACK Com|mand:...|
|00006000| 07 00 00 00 00 00 00 0d | 00 ff ff 8e 67 ff 00 ff |........|....g...|
|00006010| 00 07 00 00 09 00 ff ff | 00 00 07 00 00 09 00 ff |........|........|
|00006020| ff bd 67 07 00 00 09 00 | ff ff 00 00 07 00 00 09 |..g.....|........|
|00006030| 00 ff ff 38 60 07 00 00 | 1d 00 4c 20 74 68 65 20 |...8`...|..L the |
|00006040| 27 62 3a 6c 65 73 73 6f | 6e 35 2e 70 63 27 20 66 |'b:lesso|n5.pc' f|
|00006050| 69 6c 65 2e 00 09 00 ff | ff 5e 60 07 00 00 4b 00 |ile.....|.^`...K.|
|00006060| 4c 20 70 72 6f 63 65 65 | 64 20 77 69 74 68 20 4c |L procee|d with L|
|00006070| 65 73 73 6f 6e 35 20 6e | 6f 77 2c 20 74 68 65 6e |esson5 n|ow, then|
|00006080| 20 63 6c 65 61 72 20 74 | 68 65 20 63 6f 6d 70 75 | clear t|he compu|
|00006090| 74 65 72 27 73 20 6d 65 | 6d 6f 72 79 20 61 6e 64 |ter's me|mory and|
|000060a0| 20 72 65 61 64 20 69 6e | 00 09 00 ff ff bb 60 07 | read in|......`.|
|000060b0| 00 00 09 00 ff ff 00 00 | 07 00 00 4a 00 4c 20 4c |........|...J.L L|
|000060c0| 65 73 73 6f 6e 35 20 64 | 65 61 6c 73 20 77 69 74 |esson5 d|eals wit|
|000060d0| 68 20 63 6f 70 79 69 6e | 67 20 64 61 74 61 20 62 |h copyin|g data b|
|000060e0| 65 74 77 65 65 6e 20 73 | 70 72 65 61 64 73 68 65 |etween s|preadshe|
|000060f0| 65 74 73 2e 20 20 49 66 | 20 79 6f 75 20 77 61 6e |ets. If| you wan|
|00006100| 74 20 74 6f 00 09 00 ff | ff 0e 61 07 00 00 4a 00 |t to....|..a...J.|
|00006110| 4c 20 20 20 20 20 20 20 | 20 20 43 6f 6e 74 72 6f |L | Contro|
|00006120| 6c 2d 2d 78 20 20 43 6f | 6e 74 72 6f 6c 2d 2d 77 |l--x Co|ntrol--w|
|00006130| 20 20 20 20 61 6e 64 20 | 73 75 70 70 6c 79 20 74 | and |supply t|
|00006140| 68 65 20 66 69 6c 65 6e | 61 6d 65 20 27 63 61 73 |he filen|ame 'cas|
|00006150| 68 31 2e 70 63 27 2e 00 | 09 00 ff ff 61 61 07 00 |h1.pc'..|....aa..|
|00006160| 00 0e 00 4c 20 45 6e 74 | 65 72 3a 20 20 20 00 09 |...L Ent|er: ..|
|00006170| 00 ff ff 78 61 07 00 00 | 49 00 4c 20 74 6f 20 74 |...xa...|I.L to t|
|00006180| 68 65 20 27 63 61 73 68 | 2e 70 63 27 20 66 69 6c |he 'cash|.pc' fil|
|00006190| 65 2c 20 73 69 6e 63 65 | 20 79 6f 75 20 77 69 6c |e, since| you wil|
|000061a0| 6c 20 62 65 20 75 73 69 | 6e 67 20 74 68 69 73 20 |l be usi|ng this |
|000061b0| 66 69 6c 65 20 69 6e 20 | 4c 65 73 73 6f 6e 35 2e |file in |Lesson5.|
|000061c0| 00 09 00 ff ff ca 61 07 | 00 00 48 00 4c 20 54 68 |......a.|..H.L Th|
|000061d0| 69 73 20 63 6f 6e 63 6c | 75 64 65 73 20 4c 65 73 |is concl|udes Les|
|000061e0| 73 6f 6e 34 2e 20 20 42 | 65 20 73 75 72 65 20 74 |son4. B|e sure t|
|000061f0| 6f 20 73 61 76 65 20 74 | 68 65 20 6d 6f 64 69 66 |o save t|he modif|
|00006200| 69 63 61 74 69 6f 6e 73 | 20 79 6f 75 20 68 61 76 |ications| you hav|
|00006210| 65 00 09 00 ff ff 24 62 | 07 00 00 09 00 ff ff 00 |e.....$b|........|
|00006220| 00 07 00 00 09 00 4c 20 | 45 4e 44 00 00 09 00 ff |......L |END.....|
|00006230| ff 36 62 07 00 00 40 00 | 4c 20 2d 52 65 69 6e 73 |.6b...@.|L -Reins|
|00006240| 65 72 74 20 74 68 65 20 | 6c 69 6e 65 20 75 73 69 |ert the |line usi|
|00006250| 6e 67 20 74 68 65 20 59 | 41 4e 4b 42 41 43 4b 20 |ng the Y|ANKBACK |
|00006260| 43 6f 6d 6d 61 6e 64 2c | 20 20 43 6f 6e 74 72 6f |Command,| Contro|
|00006270| 6c 2d 2d 59 2e 00 09 00 | ff ff 7f 62 07 00 00 41 |l--Y....|...b...A|
|00006280| 00 4c 20 2d 54 68 65 6e | 2c 20 6d 6f 76 65 20 74 |.L -Then|, move t|
|00006290| 68 65 20 63 75 72 73 6f | 72 20 74 6f 20 74 68 65 |he curso|r to the|
|000062a0| 20 27 53 75 70 70 6c 69 | 65 73 27 20 6c 69 6e 65 | 'Suppli|es' line|
|000062b0| 2c 20 62 65 6c 6f 77 20 | 27 52 65 6e 74 27 2e 00 |, below |'Rent'..|
|000062c0| 09 00 ff ff d2 62 07 00 | 00 09 00 ff ff 00 00 07 |.....b..|........|
|000062d0| 00 00 47 00 4c 20 46 69 | 72 73 74 2c 20 64 65 6c |..G.L Fi|rst, del|
|000062e0| 65 74 65 20 27 50 6f 73 | 74 61 67 65 27 20 77 69 |ete 'Pos|tage' wi|
|000062f0| 74 68 20 74 68 65 20 44 | 45 4c 45 54 45 20 4c 49 |th the D|ELETE LI|
|00006300| 4e 45 20 43 6f 6d 6d 61 | 6e 64 3a 20 20 43 6f 6e |NE Comma|nd: Con|
|00006310| 74 72 6f 6c 2d 2d 43 2e | 00 09 00 ff ff 22 63 07 |trol--C.|....."c.|
|00006320| 00 00 3c 00 4c 20 6d 6f | 76 65 20 27 50 6f 73 74 |..<.L mo|ve 'Post|
|00006330| 61 67 65 27 20 66 72 6f | 6d 20 6c 69 6e 65 20 31 |age' fro|m line 1|
|00006340| 35 20 74 6f 20 62 65 6c | 6f 77 20 27 52 65 6e 74 |5 to bel|ow 'Rent|
|00006350| 27 20 61 74 20 6c 69 6e | 65 20 31 34 2e 00 09 00 |' at lin|e 14....|
|00006360| ff ff 67 63 07 00 00 4a | 00 4c 20 44 49 46 46 45 |..gc...J|.L DIFFE|
|00006370| 52 45 4e 54 20 6c 6f 63 | 61 74 69 6f 6e 20 69 6e |RENT loc|ation in|
|00006380| 20 74 68 65 20 73 70 72 | 65 61 64 73 68 65 65 74 | the spr|eadsheet|
|00006390| 2e 20 20 54 6f 20 73 65 | 65 20 68 6f 77 20 74 68 |. To se|e how th|
|000063a0| 69 73 20 77 6f 72 6b 73 | 2c 20 6c 65 74 20 75 73 |is works|, let us|
|000063b0| 00 09 00 ff ff ba 63 07 | 00 00 44 00 4c 20 65 78 |......c.|..D.L ex|
|000063c0| 63 65 70 74 20 74 68 61 | 74 20 74 68 65 20 6d 61 |cept tha|t the ma|
|000063d0| 74 65 72 69 61 6c 20 69 | 73 20 72 65 73 74 6f 72 |terial i|s restor|
|000063e0| 65 64 20 66 72 6f 6d 20 | 74 68 65 20 53 61 76 65 |ed from |the Save|
|000063f0| 20 42 75 66 66 65 72 20 | 74 6f 20 61 20 00 00 00 | Buffer |to a ...|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
