home *** CD-ROM | disk | FTP | other *** search
| MacBinary | 1995-05-09 | 376.3 KB | [help/CTRl] |
open in: 
MacOS 8.1
|
Win98
|
DOS
browse contents |
view JSON data
|
view as text
This file was processed as: MacBinary
(archive/macBinary).
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 10%
| dexvert
| MacBinary (archive/macBinary)
| fallback
| Supported |
| 100%
| file
| MacBinary II, inited, bundle, Thu Feb 2 07:19:20 1995, modified Tue May 9 06:46:51 1995, creator 'CTRl', type 'help' "macControl Help", at 0x80 385078 bytes resource Apple HFS/HFS+ resource fork, map offset 0x5c90d, map length 0x1729, data length 0x5c80d, nextResourceMap 0xae95fc, fileRef 0xcdc, list offset 0x1c, name offset 0x166e, 21 types, 0x564e554d 'VNUM' * 1 resource offset 0xaa
| default (weak)
| |
| 99%
| file
| data
| default
| |
| 100%
| TrID
| MacBinary 2
| default (weak)
| |
| 100%
| siegfried
| fmt/1762 MacBinary (II)
| default
| |
| 100%
| lsar
| MacBinary
| default
|
|
| id metadata |
|---|
| key | value |
|---|
| macFileType | [help] |
| macFileCreator | [CTRl] |
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 0f 6d 61 63 43 6f 6e | 74 72 6f 6c 20 48 65 6c |..macCon|trol Hel|
|00000010| 70 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |p.......|........|
|00000020| 00 00 00 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 68 65 6c 70 43 54 52 | 6c 21 00 00 00 00 00 00 |.helpCTR|l!......|
|00000050| 00 00 00 00 00 00 00 00 | 05 e0 36 ab 56 7e 48 ab |........|..6.V~H.|
|00000060| d4 f8 9b 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 f3 11 00 00 |........|........|
|00000080| 00 00 01 00 00 05 c9 0d | 00 05 c8 0d 00 00 17 29 |........|.......)|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 0f 6d 61 63 43 6f 6e 74 | 72 6f 6c 20 48 65 6c 70 |.macCont|rol Help|
|000000c0| 02 00 00 00 68 65 6c 70 | 43 54 52 6c 21 00 00 00 |....help|CTRl!...|
|000000d0| 00 00 68 65 6c 70 43 54 | 52 6c 21 00 00 00 00 00 |..helpCT|Rl!.....|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 ab 56 7e 48 00 00 | 00 00 00 05 e0 36 00 00 |...V~H..|.....6..|
|00000100| 00 00 00 00 00 00 00 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 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 04 00 00 00 1b | 00 00 00 36 03 00 80 00 |........|...6....|
|00000190| 00 00 03 33 2e 35 2b 33 | 2e 35 2c 20 a9 20 31 39 |...3.5+3|.5, . 19|
|000001a0| 38 38 2d 31 39 39 34 20 | 42 72 65 69 74 73 63 68 |88-1994 |Breitsch|
|000001b0| 77 65 72 64 74 20 61 6e | 64 20 50 61 72 74 6e 65 |werdt an|d Partne|
|000001c0| 72 73 00 00 00 4e 4d 54 | 68 69 73 20 64 6f 63 75 |rs...NMT|his docu|
|000001d0| 6d 65 6e 74 20 63 6f 6e | 74 61 69 6e 73 20 74 68 |ment con|tains th|
|000001e0| 65 20 6d 61 63 43 6f 6e | 74 72 6f 6c 2d 48 65 6c |e macCon|trol-Hel|
|000001f0| 70 2d 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 61 6e |p-inform|ation an|
|00000200| 64 20 63 61 6e 20 6e 6f | 74 20 62 65 20 6f 70 65 |d can no|t be ope|
|00000210| 6e 65 64 2e 00 00 00 40 | 7f ff 40 01 47 f1 49 c9 |ned....@|..@.G.I.|
|00000220| c9 4b 88 8a 88 8a 84 8a | 8f f2 90 12 95 12 da 93 |.K......|........|
|00000230| 55 11 4f e1 40 01 7f ff | 7f ff 7f ff 7f ff 7f ff |U.O.@...|........|
|00000240| ff ff ff ff ff fe ff fe | ff fe ff fe ff ff ff ff |........|........|
|00000250| 7f ff 7f ff 7f ff 7f ff | 00 00 01 00 0f ff ff fe |........|........|
|00000260| 10 00 00 01 10 00 00 01 | 10 00 00 01 10 07 ff 81 |........|........|
|00000270| 10 08 00 41 10 10 78 21 | 10 10 cc 21 10 10 cc 25 |...A..x!|...!...%|
|00000280| 50 10 18 2b b0 10 30 29 | 90 10 30 28 80 10 00 28 |P..+..0)|..0(...(|
|00000290| 80 10 30 28 80 10 30 28 | 80 08 00 48 80 07 ff 88 |..0(..0(|...H....|
|000002a0| 80 00 00 08 80 ff fe 08 | 81 00 01 08 91 50 01 08 |........|.....P..|
|000002b0| b1 00 01 09 51 54 01 0b | 11 00 01 05 11 55 01 01 |....QT..|.....U..|
|000002c0| 11 00 01 01 11 55 41 01 | 11 00 01 01 10 ff fe 01 |.....UA.|........|
|000002d0| 10 00 00 01 10 00 00 01 | 0f ff ff fe 0f ff ff fe |........|........|
|000002e0| 1f ff ff ff 1f ff ff ff | 1f ff ff ff 1f ff ff ff |........|........|
|000002f0| 1f ff ff ff 1f ff ff ff | 1f ff ff ff 1f ff ff ff |........|........|
|00000300| 5f ff ff fb ff ff ff f9 | ff ff ff f8 ff ff ff f8 |_.......|........|
|00000310| ff ff ff f8 ff ff ff f8 | ff ff ff f8 ff ff ff f8 |........|........|
|00000320| ff ff ff f8 ff ff ff f8 | ff ff ff f8 ff ff ff f8 |........|........|
|00000330| ff ff ff f9 5f ff ff fb | 1f ff ff ff 1f ff ff ff |...._...|........|
|00000340| 1f ff ff ff 1f ff ff ff | 1f ff ff ff 1f ff ff ff |........|........|
|00000350| 1f ff ff ff 1f ff ff ff | 0f ff ff fe 00 00 00 80 |........|........|
|00000360| 0f ff ff ff ff ff ff ff | 0f cc cc cc cc cc cc cf |........|........|
|00000370| 0f cc ce ee ee ee cc cf | 0f cc e7 7f ff 7d ec cf |........|.....}..|
|00000380| ff cc e7 7f 7f 7d ec ff | fc cc e7 77 f7 7d ec fc |.....}..|...w.}..|
|00000390| fc cc e7 77 f7 7d ec f0 | fc cc ee 77 f7 ee ec f0 |...w.}..|...w....|
|000003a0| fc cc ee ee ee ee cc f0 | fc ce cc cc cc ce cc f0 |........|........|
|000003b0| fc ce ce cc cc ce cc fc | ff ce ec ec cc ce cc ff |........|........|
|000003c0| 0f ce ce ce cc ce cc cf | 0f cc ee ee ee ec cc cf |........|........|
|000003d0| 0f cc cc cc cc cc cc cf | 0f ff ff ff ff ff ff ff |........|........|
|000003e0| 00 00 02 00 00 00 ff ff | ff ff ff ff ff ff ff ff |........|........|
|000003f0| ff ff ff f0 00 0f 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 00 00 00 0f 00 0f 0c cc | cc cc cc cc cc cc cc cc |........|........|
|00000410| cc cc cc cf 00 0f 0c cc | cc cc cc cc cc cc cc cc |........|........|
|00000420| cc cc cc cf 00 0f 0c cc | cc cc cf ff ff ff ff ff |........|........|
|00000430| fc cc cc cf 00 0f 0c cc | cc cc fc cc cc cc cc cc |........|........|
|00000440| df cc cc cf 00 0f 0c cc | cc cf cc 77 7f ff f7 7c |........|...w...||
|00000450| cd fc cc cf 00 0f 0c cc | cc cf c7 77 ff 77 ff 77 |........|...w.w.w|
|00000460| cd fc cc cf 00 0f 0c cc | cc cf c7 77 ff 77 ff 77 |........|...w.w.w|
|00000470| cd fc cf cf 0f 0f 0c cc | cc cf c7 77 77 7f f7 77 |........|...ww..w|
|00000480| cd fc f0 ff f0 ff 0c cc | cc cf c7 77 77 ff 77 77 |........|...ww.ww|
|00000490| cd fc f0 0f f0 0f 0c cc | cc cf c7 77 77 ff 77 77 |........|...ww.ww|
|000004a0| cd fc f0 00 f0 c0 0c cc | cc cf c7 77 77 77 77 77 |........|...wwwww|
|000004b0| cd fc f0 00 f0 cc cc cc | cc cf c7 77 77 ff 77 7c |........|...ww.w||
|000004c0| cd fc f0 00 f0 cc cc cc | cc cf cc 77 77 ff 7c cc |........|...ww.|.|
|000004d0| dd fc f0 00 f0 cc cc cc | cc cc fc cc cc cc cc dd |........|........|
|000004e0| df cc f0 00 f0 cc cc cc | cc cc cf ff ff ff ff ff |........|........|
|000004f0| fc cc f0 00 f0 cc cc cc | cc cc cc cc cc cc cc cc |........|........|
|00000500| cc cc f0 00 f0 cc cc cc | ee ee ee ee ee ee ee ec |........|........|
|00000510| cc cc f0 00 f0 cc cc ce | 00 00 00 00 00 00 00 0e |........|........|
|00000520| cc cc f0 00 f0 cf 0c ce | 0e ce cc cc cc cc cc de |........|........|
|00000530| cc cc f0 00 f0 ff 0c ce | 0c cc cc cc cc cc cc de |........|........|
|00000540| cc cc f0 0f 0f 0f 0c ce | 0e ce ce cc cc cc cc de |........|........|
|00000550| cc cc f0 ff 00 0f 0c ce | 0c cc cc cc cc cc cc de |........|........|
|00000560| cc cc cf cf 00 0f 0c ce | 0e ce ce ce cc cc cc de |........|........|
|00000570| cc cc cc cf 00 0f 0c ce | 0c cc cc cc cc cc cc de |........|........|
|00000580| cc cc cc cf 00 0f 0c ce | 0e ce ce ce ce cc cc de |........|........|
|00000590| cc cc cc cf 00 0f 0c ce | dd dd dd dd dd dd dd de |........|........|
|000005a0| cc cc cc cf 00 0f 0c cc | ee ee ee ee ee ee ee ec |........|........|
|000005b0| cc cc cc cf 00 0f 0c cc | cc cc cc cc cc cc cc cc |........|........|
|000005c0| cc cc cc cf 00 0f 0c cc | cc cc cc cc cc cc cc cc |........|........|
|000005d0| cc cc cc cf 00 00 ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005e0| ff ff ff f0 00 00 01 00 | 00 ff ff ff ff ff ff ff |........|........|
|000005f0| ff ff ff ff ff ff ff ff | 00 ff f6 f6 f6 f6 f6 f6 |........|........|
|00000600| f6 f6 f6 f6 f6 f6 f6 ff | 00 ff f6 f6 f6 fc fc fc |........|........|
|00000610| fc fc fc fc f6 f6 f6 ff | 00 ff f6 f6 fc c0 c0 ff |........|........|
|00000620| ff ff c0 f9 fc f6 f6 ff | ff ff f6 f6 fc c0 c0 ff |........|........|
|00000630| c0 ff c0 f9 fc f6 ff ff | ff f6 f6 f6 fc c0 c0 c0 |........|........|
|00000640| ff c0 c0 f9 fc f6 ff f6 | ff f6 f6 f6 fc c0 c0 c0 |........|........|
|00000650| ff c0 c0 f9 fc f6 ff 00 | ff f6 f6 f6 fc fc c0 c0 |........|........|
|00000660| ff c0 fc fc fc f6 ff 00 | ff f6 f6 f6 fc fc fc fc |........|........|
|00000670| fc fc fc fc f6 f6 ff 00 | ff f6 f6 fc f7 f7 f7 f7 |........|........|
|00000680| f7 f7 f7 fc f6 f6 ff 00 | ff f6 f6 fc f7 fc f7 f7 |........|........|
|00000690| f7 f7 f7 fc f6 f6 ff f6 | ff ff f6 fc fc f7 fc f7 |........|........|
|000006a0| f7 f7 f7 fc f6 f6 ff ff | 00 ff f6 fc f7 fc f7 fc |........|........|
|000006b0| f7 f7 f7 fc f6 f6 f6 ff | 00 ff f6 f6 fc fc fc fc |........|........|
|000006c0| fc fc fc f6 f6 f6 f6 ff | 00 ff f6 f6 f6 f6 f6 f6 |........|........|
|000006d0| f6 f6 f6 f6 f6 f6 f6 ff | 00 ff ff ff ff ff ff ff |........|........|
|000006e0| ff ff ff ff ff ff ff ff | 00 00 04 00 00 00 00 00 |........|........|
|000006f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000700| ff ff ff ff ff ff ff ff | ff ff ff 00 00 00 00 ff |........|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 ff 00 00 00 ff |........|........|
|00000730| 00 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000740| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000750| 00 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000760| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000770| 00 f6 f6 f6 f6 f6 f6 f6 | 2b ff ff ff ff ff ff ff |........|+.......|
|00000780| ff ff ff ff ff f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000790| 00 f6 f6 f6 f6 f6 f6 2b | ff 2b 2b 2b 2b 2b 2b 2b |.......+|.+++++++|
|000007a0| 2b 2b 2b 2b f9 ff f6 f6 | f6 f6 f6 ff 00 00 00 ff |++++....|........|
|000007b0| 00 f6 f6 f6 f6 f6 f6 ff | 2b 2b c0 c0 c0 ff ff ff |........|++......|
|000007c0| ff c0 c0 2b 2b f9 ff f6 | f6 f6 f6 ff 00 00 00 ff |...++...|........|
|000007d0| 00 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 ff ff c0 c0 |........|+.......|
|000007e0| ff ff c0 c0 2b f9 ff f6 | f6 f6 f6 ff 00 00 00 ff |....+...|........|
|000007f0| 00 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 ff ff c0 c0 |........|+.......|
|00000800| ff ff c0 c0 2b f9 ff f6 | f6 ff f6 ff 00 ff 00 ff |....+...|........|
|00000810| 00 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 c0 c0 c0 ff |........|+.......|
|00000820| ff c0 c0 c0 2b f9 ff f6 | ff 00 ff ff ff 00 ff ff |....+...|........|
|00000830| 00 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 c0 c0 ff ff |........|+.......|
|00000840| c0 c0 c0 c0 2b f9 ff f6 | ff 00 00 ff ff 00 00 ff |....+...|........|
|00000850| 00 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 c0 c0 ff ff |........|+.......|
|00000860| c0 c0 c0 c0 2b f9 ff f6 | ff 00 00 00 ff 00 f6 00 |....+...|........|
|00000870| 00 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 c0 c0 c0 c0 |........|+.......|
|00000880| c0 c0 c0 c0 2b f9 ff f6 | ff 00 00 00 ff 00 f6 f6 |....+...|........|
|00000890| f6 f6 f6 f6 f6 f6 f6 ff | 2b c0 c0 c0 c0 c0 ff ff |........|+.......|
|000008a0| c0 c0 c0 2b 2b f9 ff f6 | ff 00 00 00 ff 00 f6 f6 |...++...|........|
|000008b0| f6 f6 f6 f6 f6 f6 f6 ff | 2b 2b c0 c0 c0 c0 ff ff |........|++......|
|000008c0| c0 2b 2b 2b f9 f9 ff f6 | ff 00 00 00 ff 00 f6 f6 |.+++....|........|
|000008d0| f6 f6 f6 f6 f6 f6 f6 f6 | ff 2b 2b 2b 2b 2b 2b 2b |........|.+++++++|
|000008e0| 2b 2b f9 f9 f9 ff f6 f6 | ff 00 00 00 ff 00 f6 f6 |++......|........|
|000008f0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 ff ff ff ff ff ff ff |........|........|
|00000900| ff ff ff ff ff f6 f6 f6 | ff 00 00 00 ff 00 f6 f6 |........|........|
|00000910| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000920| f6 f6 f6 f6 f6 f6 f6 f6 | ff 00 00 00 ff 00 f6 f6 |........|........|
|00000930| f6 f6 f6 f6 fc fc fc fc | fc fc fc fc fc fc fc fc |........|........|
|00000940| fc fc fc 2b f6 2b f6 2b | ff 00 00 00 ff 00 f6 f6 |...+.+.+|........|
|00000950| f6 f6 f6 fc f5 f5 f5 f5 | f5 f5 f5 f5 f5 f5 f5 f5 |........|........|
|00000960| f5 f5 f5 fc f6 f6 f6 f6 | ff 00 00 00 ff 00 f6 ff |........|........|
|00000970| 00 f6 f6 fc f5 fc f7 fc | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|00000980| f7 f7 fa fc f6 f6 f6 f6 | ff 00 00 00 ff 00 ff ff |........|........|
|00000990| 00 f6 f6 fc f5 f7 f7 f7 | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|000009a0| f7 f7 fa fc f6 f6 f6 f6 | ff 00 00 ff 00 ff 00 ff |........|........|
|000009b0| 00 f6 f6 fc f5 fc f7 fc | f7 fc f7 f7 f7 f7 f7 f7 |........|........|
|000009c0| f7 f7 fa fc f6 f6 f6 f6 | ff 00 ff ff 00 00 00 ff |........|........|
|000009d0| 00 f6 f6 fc f5 f7 f7 f7 | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|000009e0| f7 f7 fa fc f6 f6 f6 f6 | f6 ff f6 ff 00 00 00 ff |........|........|
|000009f0| 00 f6 f6 fc f5 fc f7 fc | f7 fc f7 fc f7 f7 f7 f7 |........|........|
|00000a00| f7 f7 fa fc f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000a10| 00 f6 f6 fc f5 f7 f7 f7 | f7 f7 f7 f7 f7 f7 f7 f7 |........|........|
|00000a20| f7 f7 fa fc f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000a30| 00 f6 f6 fc f5 fc f7 fc | f7 fc f7 fc f7 fc f7 f7 |........|........|
|00000a40| f7 f7 fa fc f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000a50| 00 f6 f6 fc fa fa fa fa | fa fa fa fa fa fa fa fa |........|........|
|00000a60| fa fa fa fc f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000a70| 00 f6 f6 f6 fc fc fc fc | fc fc fc fc fc fc fc fc |........|........|
|00000a80| fc fc fc f6 f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000a90| 00 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000aa0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 ff |........|........|
|00000ab0| 00 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 f6 f6 f6 f6 f6 |........|........|
|00000ac0| f6 f6 f6 f6 f6 f6 f6 f6 | f6 f6 f6 ff 00 00 00 00 |........|........|
|00000ad0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000ae0| ff ff ff ff ff ff ff ff | ff ff ff 00 00 00 00 07 |........|........|
|00000af0| 68 65 6c 70 00 00 00 00 | 00 00 1c 43 54 52 6c 00 |help....|...CTRl.|
|00000b00| 00 00 01 49 43 4e 23 00 | 00 00 00 00 b4 46 52 45 |...ICN#.|.....FRE|
|00000b10| 46 00 00 00 00 00 86 00 | 00 00 da 00 08 1c 46 6f |F.......|......Fo|
|00000b20| 72 20 64 65 66 69 6e 69 | 6e 67 20 61 20 64 61 74 |r defini|ng a dat|
|00000b30| 61 62 61 73 65 20 63 65 | 6c 6c 16 46 6f 72 20 64 |abase ce|ll.For d|
|00000b40| 65 66 69 6e 69 6e 67 20 | 61 20 66 6f 72 6d 75 6c |efining |a formul|
|00000b50| 61 27 46 6f 72 20 64 65 | 66 69 6e 69 6e 67 20 61 |a'For de|fining a|
|00000b60| 6e 20 61 74 74 72 69 62 | 75 74 65 2d 20 6f 72 20 |n attrib|ute- or |
|00000b70| 6d 65 6e 75 20 63 65 6c | 6c 18 46 6f 72 20 64 65 |menu cel|l.For de|
|00000b80| 66 69 6e 69 6e 67 20 61 | 20 74 69 6d 65 20 63 65 |fining a| time ce|
|00000b90| 6c 6c 2c 53 74 6f 70 73 | 20 74 68 65 20 65 6e 74 |ll,Stops| the ent|
|00000ba0| 72 79 2c 20 77 69 74 68 | 6f 75 74 20 73 74 6f 72 |ry, with|out stor|
|00000bb0| 69 6e 67 20 74 68 65 20 | 63 68 61 6e 67 65 73 19 |ing the |changes.|
|00000bc0| 45 6e 64 73 20 61 6e 64 | 20 73 74 6f 72 65 73 20 |Ends and| stores |
|00000bd0| 74 68 65 20 65 6e 74 72 | 79 1a 4f 70 65 6e 73 20 |the entr|y.Opens |
|00000be0| 74 68 65 20 61 74 74 72 | 69 62 75 74 65 20 77 69 |the attr|ibute wi|
|00000bf0| 6e 64 6f 77 00 00 00 00 | b3 53 75 6d 6d 61 74 69 |ndow....|.Summati|
|00000c00| 6f 6e 20 46 75 6e 63 74 | 69 6f 6e 0d 0d 53 55 4d |on Funct|ion..SUM|
|00000c10| 20 28 20 46 5b 31 2e 2e | 31 30 2c 34 5d 20 29 0d | ( F[1..|10,4] ).|
|00000c20| 0d 6f 72 0d 53 61 6c 65 | 73 3a 31 2f 39 30 20 3d |.or.Sale|s:1/90 =|
|00000c30| 20 53 55 4d 28 20 a5 50 | 72 6f 64 75 63 74 0d 3a | SUM( .P|roduct.:|
|00000c40| 28 61 6c 6c 29 3a 53 61 | 6c 65 73 3a 31 2f 39 30 |(all):Sa|les:1/90|
|00000c50| 20 29 0d 0d 6f 72 0d 53 | 61 6c 65 73 3a a5 50 72 | )..or.S|ales:.Pr|
|00000c60| 6f 64 75 63 74 20 47 72 | 6f 75 70 73 3a 31 2f 39 |oduct Gr|oups:1/9|
|00000c70| 30 20 3d 0d 53 55 4d 28 | 20 a5 50 72 6f 64 75 63 |0 =.SUM(| .Produc|
|00000c80| 74 3a 28 41 73 73 69 67 | 6e 6d 65 6e 74 0d 3a a5 |t:(Assig|nment.:.|
|00000c90| 50 72 6f 64 75 63 74 20 | 47 72 6f 75 70 73 29 3a |Product |Groups):|
|00000ca0| 53 61 6c 65 73 3a 31 2f | 39 30 20 29 00 00 00 69 |Sales:1/|90 )...i|
|00000cb0| 47 69 76 65 73 20 74 68 | 65 20 63 75 72 72 65 6e |Gives th|e curren|
|00000cc0| 74 20 64 61 74 65 20 0d | 6f 72 20 74 68 65 20 63 |t date .|or the c|
|00000cd0| 75 72 72 65 6e 74 20 74 | 69 6d 65 0d 0d 44 41 54 |urrent t|ime..DAT|
|00000ce0| 45 54 49 4d 45 20 28 30 | 29 20 67 69 76 65 73 20 |ETIME (0|) gives |
|00000cf0| 74 68 65 20 64 61 74 65 | 0d 0d 6f 72 0d 44 41 54 |the date|..or.DAT|
|00000d00| 45 54 49 4d 45 20 28 31 | 29 20 67 69 76 65 73 20 |ETIME (1|) gives |
|00000d10| 74 68 65 20 74 69 6d 65 | 0d 00 00 00 2d 43 68 61 |the time|....-Cha|
|00000d20| 6e 67 65 73 20 61 6e 79 | 20 64 61 74 61 20 74 79 |nges any| data ty|
|00000d30| 70 65 20 74 6f 20 74 65 | 78 74 0d 0d 54 45 58 54 |pe to te|xt..TEXT|
|00000d40| 20 28 20 56 61 6c 75 65 | 20 29 00 00 00 78 43 68 | ( Value| )...xCh|
|00000d50| 61 6e 67 65 73 20 61 6e | 79 20 74 69 6d 65 20 72 |anges an|y time r|
|00000d60| 65 66 65 72 65 6e 63 65 | 20 0d 69 6e 74 6f 20 61 |eference| .into a|
|00000d70| 20 6d 6f 6e 74 68 6c 79 | 20 74 69 6d 65 20 72 65 | monthly| time re|
|00000d80| 66 65 72 65 6e 63 65 20 | 0d 0d 4d 4f 4e 54 48 20 |ference |..MONTH |
|00000d90| 28 20 44 61 74 65 20 29 | 0d 0d 28 66 6f 72 20 65 |( Date )|..(for e|
|00000da0| 78 61 6d 70 6c 65 2c 20 | 31 39 39 31 20 6f 72 20 |xample, |1991 or |
|00000db0| 31 2f 31 33 2f 39 31 0d | 62 65 63 6f 6d 65 73 20 |1/13/91.|becomes |
|00000dc0| 31 2f 39 31 20 29 00 00 | 00 ad 4d 61 6b 65 73 20 |1/91 )..|..Makes |
|00000dd0| 70 6f 73 73 69 62 6c 65 | 20 0d 63 6f 6e 64 69 74 |possible| .condit|
|00000de0| 69 6f 6e 61 6c 20 63 61 | 6c 63 75 6c 61 74 69 6f |ional ca|lculatio|
|00000df0| 6e 73 0d 0d 49 46 20 28 | 20 46 5b 63 31 2c 72 31 |ns..IF (| F[c1,r1|
|00000e00| 5d 20 3e 20 46 5b 63 32 | 2c 72 32 5d 20 29 20 54 |] > F[c2|,r2] ) T|
|00000e10| 48 45 4e 20 0d 28 20 46 | 5b 63 33 2c 72 33 5d 20 |HEN .( F|[c3,r3] |
|00000e20| 29 20 45 4c 53 45 20 28 | 20 46 5b 63 34 2c 72 34 |) ELSE (| F[c4,r4|
|00000e30| 5d 20 29 0d 0d 6f 72 0d | 49 46 20 28 20 a5 50 72 |] )..or.|IF ( .Pr|
|00000e40| 6f 64 75 63 74 3a 53 61 | 6c 65 73 3a 31 2f 39 30 |oduct:Sa|les:1/90|
|00000e50| 20 3c 20 31 30 30 30 20 | 29 0d 54 48 45 4e 20 28 | < 1000 |).THEN (|
|00000e60| 20 54 61 78 20 31 20 29 | 20 45 4c 53 45 20 28 20 | Tax 1 )| ELSE ( |
|00000e70| 54 61 78 20 32 20 29 00 | 00 00 5e 45 4d 50 54 59 |Tax 2 ).|..^EMPTY|
|00000e80| 20 28 30 29 20 72 65 70 | 72 65 73 65 6e 74 73 0d | (0) rep|resents.|
|00000e90| 61 6e 20 65 6d 70 74 79 | 20 66 69 65 6c 64 0d 0d |an empty| field..|
|00000ea0| 49 46 20 28 20 46 5b 63 | 31 2c 72 31 5d 20 3d 20 |IF ( F[c|1,r1] = |
|00000eb0| 45 4d 50 54 59 20 28 30 | 29 20 29 20 0d 54 48 45 |EMPTY (0|) ) .THE|
|00000ec0| 4e 20 28 20 30 20 29 20 | 45 4c 53 45 20 28 20 46 |N ( 0 ) |ELSE ( F|
|00000ed0| 5b 63 32 2c 72 32 5d 20 | 29 00 00 00 51 67 69 76 |[c2,r2] |)...Qgiv|
|00000ee0| 65 73 20 74 68 65 20 72 | 65 66 65 72 65 6e 63 65 |es the r|eference|
|00000ef0| 20 20 20 20 20 20 0d 64 | 65 6e 6f 74 61 74 69 6f | .d|enotatio|
|00000f00| 6e 20 6f 66 20 61 20 63 | 65 6c 6c 20 20 20 20 20 |n of a c|ell |
|00000f10| 20 20 20 0d 0d 43 45 4c | 4c 52 45 46 45 52 45 4e | ..CEL|LREFEREN|
|00000f20| 43 45 20 28 46 5b 72 2c | 63 5d 29 20 20 20 00 00 |CE (F[r,|c]) ..|
|00000f30| 00 49 47 69 76 65 73 20 | 74 68 65 20 6e 61 6d 65 |.IGives |the name|
|00000f40| 20 6f 66 20 74 68 65 20 | 75 73 65 72 0d 77 68 6f | of the |user.who|
|00000f50| 20 69 73 20 6c 6f 67 67 | 65 64 20 69 6e 74 6f 20 | is logg|ed into |
|00000f60| 74 68 65 20 0d 64 61 74 | 61 62 61 73 65 0d 0d 55 |the .dat|abase..U|
|00000f70| 53 45 52 4e 41 4d 45 20 | 28 30 29 00 00 00 ff 43 |SERNAME |(0)....C|
|00000f80| 6f 6d 62 69 6e 65 73 20 | 6d 75 6c 74 69 70 6c 65 |ombines |multiple|
|00000f90| 20 4d 61 63 72 6f 20 66 | 6f 72 6d 75 6c 61 73 20 | Macro f|ormulas |
|00000fa0| 0d 69 6e 74 6f 20 61 20 | 73 69 6e 67 6c 65 20 66 |.into a |single f|
|00000fb0| 6f 72 6d 75 6c 61 0d 0d | 4d 61 63 72 6f 66 6f 72 |ormula..|Macrofor|
|00000fc0| 6d 75 6c 61 3a 4e 4f 69 | 3a 28 57 6f 72 6b 73 68 |mula:NOi|:(Worksh|
|00000fd0| 65 65 74 29 20 3d 0d 4d | 41 43 52 4f 20 28 46 5b |eet) =.M|ACRO (F[|
|00000fe0| 63 31 2e 2e 63 32 2c 72 | 31 2e 2e 72 32 5d 3b 20 |c1..c2,r|1..r2]; |
|00000ff0| 6e 3b 20 6d 29 0d 0d 6e | 20 3d 20 30 20 20 77 69 |n; m)..n| = 0 wi|
|00001000| 74 68 20 44 69 73 70 6c | 61 79 3b 20 20 0d 6e 20 |th Displ|ay; .n |
|00001010| 3d 20 31 20 20 77 69 74 | 68 6f 75 74 20 44 69 73 |= 1 wit|hout Dis|
|00001020| 70 6c 61 79 3b 0d 6d 20 | 3d 20 30 20 6d 61 6e 75 |play;.m |= 0 manu|
|00001030| 61 6c 20 73 74 61 72 74 | 3b 0d 6d 20 3d 20 32 20 |al start|;.m = 2 |
|00001040| 61 75 74 6f 6d 61 74 69 | 63 20 73 74 61 72 74 3b |automati|c start;|
|00001050| 0d 46 5b 63 31 2e 2e 63 | 32 2c 72 31 2e 2e 72 32 |.F[c1..c|2,r1..r2|
|00001060| 5d 20 63 6f 6e 74 61 69 | 6e 73 20 74 68 65 20 0d |] contai|ns the .|
|00001070| 4d 61 63 72 6f 20 66 6f | 72 6d 75 6c 61 73 00 00 |Macro fo|rmulas..|
|00001080| 00 c7 4d 61 63 72 6f 66 | 75 6e 63 74 69 6f 6e 20 |..Macrof|unction |
|00001090| 74 68 61 74 20 65 6e 61 | 62 6c 65 73 20 74 68 65 |that ena|bles the|
|000010a0| 20 75 73 65 72 0d 74 6f | 20 61 75 74 6f 6d 61 74 | user.to| automat|
|000010b0| 69 63 61 6c 6c 79 20 70 | 72 69 6e 74 20 61 20 67 |ically p|rint a g|
|000010c0| 69 76 65 6e 20 73 65 74 | 20 6f 66 0d 70 61 67 65 |iven set| of.page|
|000010d0| 73 0d 0d 4d 61 63 72 6f | 66 6f 72 6d 75 6c 61 20 |s..Macro|formula |
|000010e0| 3a 20 4e 4f 69 20 3a 20 | 28 57 6f 72 6b 73 68 65 |: NOi : |(Workshe|
|000010f0| 65 74 29 20 3d 20 0d 41 | 55 54 4f 50 52 49 4e 54 |et) = .A|UTOPRINT|
|00001100| 20 28 20 46 5b 63 31 2e | 2e 63 32 2c 72 31 2e 2e | ( F[c1.|.c2,r1..|
|00001110| 72 32 5d 20 29 0d 0d 28 | 46 5b 63 31 2e 2e 63 32 |r2] )..(|F[c1..c2|
|00001120| 2c 72 31 2e 2e 72 32 5d | 20 64 65 66 69 6e 65 73 |,r1..r2]| defines|
|00001130| 20 74 68 65 20 70 61 67 | 65 73 0d 74 6f 20 62 65 | the pag|es.to be|
|00001140| 20 70 72 69 6e 74 65 64 | 29 00 00 00 9f 4d 61 63 | printed|)....Mac|
|00001150| 72 6f 66 75 6e 63 74 69 | 6f 6e 20 74 68 61 74 20 |rofuncti|on that |
|00001160| 6f 70 65 6e 73 20 61 20 | 64 69 61 6c 6f 67 2e 20 |opens a |dialog. |
|00001170| 54 68 65 20 20 20 0d 75 | 73 65 72 20 6d 61 79 20 |The .u|ser may |
|00001180| 71 75 69 74 20 74 68 65 | 20 6d 61 63 72 6f 20 66 |quit the| macro f|
|00001190| 72 6f 6d 20 77 68 69 63 | 68 20 20 20 20 20 0d 74 |rom whic|h .t|
|000011a0| 68 69 73 20 6d 61 63 72 | 6f 66 75 6e 63 74 69 6f |his macr|ofunctio|
|000011b0| 6e 20 68 61 73 20 62 65 | 65 6e 20 63 61 6c 6c 65 |n has be|en calle|
|000011c0| 64 20 75 70 2e 20 20 20 | 20 0d 0d 43 4f 4e 46 49 |d up. | ..CONFI|
|000011d0| 52 4d 20 28 22 44 6f 20 | 79 6f 75 20 77 61 6e 74 |RM ("Do |you want|
|000011e0| 20 74 6f 20 71 75 69 74 | 20 3f 22 29 00 00 00 6d | to quit| ?")...m|
|000011f0| 43 68 61 6e 67 65 73 20 | 61 6e 79 20 74 69 6d 65 |Changes |any time|
|00001200| 20 72 65 66 65 72 65 6e | 63 65 20 0d 69 6e 74 6f | referen|ce .into|
|00001210| 20 61 20 79 65 61 72 6c | 79 20 74 69 6d 65 20 72 | a yearl|y time r|
|00001220| 65 66 65 72 65 6e 63 65 | 0d 0d 59 45 41 52 20 28 |eference|..YEAR (|
|00001230| 20 44 61 74 65 20 29 0d | 0d 28 66 6f 72 20 65 78 | Date ).|.(for ex|
|00001240| 61 6d 70 6c 65 2c 20 31 | 2f 31 33 2f 39 31 20 0d |ample, 1|/13/91 .|
|00001250| 62 65 63 6f 6d 65 73 20 | 31 39 39 31 29 00 00 00 |becomes |1991)...|
|00001260| 19 6c 6f 67 20 62 61 73 | 65 20 31 30 0d 0d 4c 47 |.log bas|e 10..LG|
|00001270| 20 28 20 56 61 6c 75 65 | 20 29 00 00 00 1d 41 62 | ( Value| )....Ab|
|00001280| 73 6f 6c 75 74 65 20 76 | 61 6c 75 65 0d 0d 41 42 |solute v|alue..AB|
|00001290| 53 20 28 20 56 61 6c 75 | 65 20 29 00 00 01 29 4d |S ( Valu|e )...)M|
|000012a0| 61 63 72 6f 66 75 6e 63 | 74 69 6f 6e 20 66 6f 72 |acrofunc|tion for|
|000012b0| 20 74 68 65 20 6c 69 73 | 74 69 6e 67 20 0d 6f 66 | the lis|ting .of|
|000012c0| 20 76 61 72 69 6f 75 73 | 20 61 73 73 69 67 6e 6d | various| assignm|
|000012d0| 65 6e 74 73 20 0d 73 70 | 61 6e 6e 69 6e 67 20 6d |ents .sp|anning m|
|000012e0| 75 6c 74 69 70 6c 65 20 | 6c 65 76 65 6c 73 20 0d |ultiple |levels .|
|000012f0| 28 6d 75 73 74 20 62 65 | 20 64 65 66 69 6e 65 64 |(must be| defined|
|00001300| 20 69 6e 20 61 20 66 6c | 65 78 69 62 6c 65 20 63 | in a fl|exible c|
|00001310| 65 6c 6c 29 0d 0d 45 58 | 50 41 4e 44 20 28 46 5b |ell)..EX|PAND (F[|
|00001320| 63 31 2e 2e 63 32 2c 72 | 31 2e 2e 72 32 5d 3b 20 |c1..c2,r|1..r2]; |
|00001330| 61 3b 20 30 3b 20 62 29 | 0d 20 0d 61 20 3d 20 50 |a; 0; b)|. .a = P|
|00001340| 61 67 65 20 6e 75 6d 62 | 65 72 3b 0d 62 20 3d 20 |age numb|er;.b = |
|00001350| 30 20 52 65 70 65 74 69 | 74 69 6f 6e 20 6f 66 20 |0 Repeti|tion of |
|00001360| 61 74 74 72 69 62 75 74 | 65 73 3b 0d 62 20 3d 20 |attribut|es;.b = |
|00001370| 31 20 4e 6f 20 72 65 70 | 65 74 69 74 69 6f 6e 20 |1 No rep|etition |
|00001380| 6f 66 20 61 74 74 72 69 | 62 75 74 65 73 3b 0d 46 |of attri|butes;.F|
|00001390| 5b 63 31 2e 2e 63 32 2c | 72 31 2e 2e 72 32 5d 20 |[c1..c2,|r1..r2] |
|000013a0| 64 65 66 69 6e 65 73 20 | 72 61 6e 67 65 20 0d 77 |defines |range .w|
|000013b0| 68 65 72 65 20 6f 75 74 | 70 75 74 20 69 73 20 64 |here out|put is d|
|000013c0| 69 73 70 6c 61 79 65 64 | 00 00 00 19 4e 61 74 75 |isplayed|....Natu|
|000013d0| 72 61 6c 20 6c 6f 67 0d | 0d 4c 4e 20 28 20 56 61 |ral log.|.LN ( Va|
|000013e0| 6c 75 65 20 29 00 00 00 | 1b 53 71 75 61 72 65 20 |lue )...|.Square |
|000013f0| 72 6f 6f 74 0d 0d 53 51 | 52 54 20 28 20 56 61 6c |root..SQ|RT ( Val|
|00001400| 75 65 20 29 00 00 00 1f | 49 6e 74 65 67 65 72 20 |ue )....|Integer |
|00001410| 66 75 6e 63 74 69 6f 6e | 0d 0d 49 4e 54 20 28 20 |function|..INT ( |
|00001420| 56 61 6c 75 65 20 29 00 | 00 00 5b 54 68 69 73 20 |Value ).|..[This |
|00001430| 65 6e 61 62 6c 65 73 20 | 74 68 65 20 75 73 65 72 |enables |the user|
|00001440| 20 20 20 20 20 20 20 20 | 20 0d 74 6f 20 63 68 6f | | .to cho|
|00001450| 6f 73 65 20 61 64 64 69 | 74 69 6f 6e 61 6c 20 20 |ose addi|tional |
|00001460| 20 20 20 20 20 20 20 20 | 20 0d 66 75 6e 63 74 69 | | .functi|
|00001470| 6f 6e 73 20 74 68 61 74 | 20 61 72 65 20 61 76 61 |ons that| are ava|
|00001480| 69 6c 61 62 6c 65 00 00 | 00 a9 45 6e 61 62 6c 65 |ilable..|..Enable|
|00001490| 73 20 74 68 65 20 75 73 | 65 72 20 74 6f 20 64 65 |s the us|er to de|
|000014a0| 66 69 6e 65 20 61 6e 64 | 20 0d 72 65 63 61 6c 6c |fine and| .recall|
|000014b0| 20 61 6e 20 61 73 73 69 | 67 6e 6d 65 6e 74 20 0d | an assi|gnment .|
|000014c0| 0d 41 53 53 49 47 4e 4d | 45 4e 54 3a 4e 4f 31 3a |.ASSIGNM|ENT:NO1:|
|000014d0| 0d 44 61 69 72 79 20 50 | 72 6f 64 75 63 74 73 20 |.Dairy P|roducts |
|000014e0| 3d 20 42 75 74 74 65 72 | 20 0d 6f 72 0d 0d 53 61 |= Butter| .or..Sa|
|000014f0| 6c 65 73 3a a5 50 72 6f | 64 75 63 74 20 47 72 6f |les:.Pro|duct Gro|
|00001500| 75 70 20 3d 20 0d 53 55 | 4d 20 28 a5 50 72 6f 64 |up = .SU|M (.Prod|
|00001510| 75 63 74 73 3a 28 41 53 | 53 49 47 4e 4d 45 4e 54 |ucts:(AS|SIGNMENT|
|00001520| 3a 0d a5 50 72 6f 64 75 | 63 74 20 47 72 6f 75 70 |:..Produ|ct Group|
|00001530| 29 29 0d 00 00 00 5e 44 | 65 66 69 6e 65 73 20 61 |))....^D|efines a|
|00001540| 6c 6c 20 74 68 65 20 61 | 74 74 72 69 62 75 74 65 |ll the a|ttribute|
|00001550| 73 20 0d 69 6e 20 61 20 | 67 69 76 65 6e 20 67 72 |s .in a |given gr|
|00001560| 6f 75 70 0d 0d a5 50 72 | 6f 64 75 63 74 3a 28 41 |oup...Pr|oduct:(A|
|00001570| 4c 4c 29 0d 6f 72 0d 53 | 61 6c 65 73 20 3d 20 53 |LL).or.S|ales = S|
|00001580| 55 4d 20 0d 28 a5 50 72 | 6f 64 75 63 74 3a 28 41 |UM .(.Pr|oduct:(A|
|00001590| 4c 4c 29 29 0d 00 00 00 | b0 53 75 6d 6d 61 74 69 |LL))....|.Summati|
|000015a0| 6f 6e 20 46 75 6e 63 74 | 69 6f 6e 0d 0d 53 55 4d |on Funct|ion..SUM|
|000015b0| 20 28 20 46 5b 31 2e 2e | 31 30 2c 34 5d 20 29 0d | ( F[1..|10,4] ).|
|000015c0| 6f 72 0d 53 61 6c 65 73 | 3a 31 2f 39 30 20 3d 20 |or.Sales|:1/90 = |
|000015d0| 53 55 4d 28 20 a5 50 72 | 6f 64 75 63 74 0d 3a 28 |SUM( .Pr|oduct.:(|
|000015e0| 61 6c 6c 29 3a 53 61 6c | 65 73 3a 31 2f 39 30 20 |all):Sal|es:1/90 |
|000015f0| 29 0d 6f 72 0d 53 61 6c | 65 73 3a a5 50 72 6f 64 |).or.Sal|es:.Prod|
|00001600| 75 63 74 20 47 72 6f 75 | 70 73 3a 31 2f 39 30 20 |uct Grou|ps:1/90 |
|00001610| 3d 0d 53 55 4d 28 20 a5 | 50 72 6f 64 75 63 74 3a |=.SUM( .|Product:|
|00001620| 28 41 73 73 69 67 6e 6d | 65 6e 74 0d 3a a5 50 72 |(Assignm|ent.:.Pr|
|00001630| 6f 64 75 63 74 20 47 72 | 6f 75 70 73 29 3a 53 61 |oduct Gr|oups):Sa|
|00001640| 6c 65 73 3a 31 2f 39 30 | 29 00 00 00 5e 44 65 66 |les:1/90|)...^Def|
|00001650| 69 6e 65 73 20 61 6c 6c | 20 74 68 65 20 61 74 74 |ines all| the att|
|00001660| 72 69 62 75 74 65 73 20 | 0d 69 6e 20 61 20 67 69 |ributes |.in a gi|
|00001670| 76 65 6e 20 67 72 6f 75 | 70 0d 0d a5 50 72 6f 64 |ven grou|p...Prod|
|00001680| 75 63 74 3a 28 41 4c 4c | 29 0d 6f 72 0d 53 61 6c |uct:(ALL|).or.Sal|
|00001690| 65 73 20 3d 20 53 55 4d | 20 0d 28 a5 50 72 6f 64 |es = SUM| .(.Prod|
|000016a0| 75 63 74 3a 28 41 4c 4c | 29 29 0d 00 00 00 a9 45 |uct:(ALL|)).....E|
|000016b0| 6e 61 62 6c 65 73 20 74 | 68 65 20 75 73 65 72 20 |nables t|he user |
|000016c0| 74 6f 20 64 65 66 69 6e | 65 20 61 6e 64 20 0d 72 |to defin|e and .r|
|000016d0| 65 63 61 6c 6c 20 61 6e | 20 61 73 73 69 67 6e 6d |ecall an| assignm|
|000016e0| 65 6e 74 20 0d 0d 41 53 | 53 49 47 4e 4d 45 4e 54 |ent ..AS|SIGNMENT|
|000016f0| 3a 4e 4f 31 3a 0d 44 61 | 69 72 79 20 50 72 6f 64 |:NO1:.Da|iry Prod|
|00001700| 75 63 74 73 20 3d 20 42 | 75 74 74 65 72 20 0d 6f |ucts = B|utter .o|
|00001710| 72 0d 0d 53 61 6c 65 73 | 3a a5 50 72 6f 64 75 63 |r..Sales|:.Produc|
|00001720| 74 20 47 72 6f 75 70 20 | 3d 20 0d 53 55 4d 20 28 |t Group |= .SUM (|
|00001730| a5 50 72 6f 64 75 63 74 | 73 3a 28 41 53 53 49 47 |.Product|s:(ASSIG|
|00001740| 4e 4d 45 4e 54 3a 0d a5 | 50 72 6f 64 75 63 74 20 |NMENT:..|Product |
|00001750| 47 72 6f 75 70 29 29 0d | 00 00 00 88 53 75 6d 73 |Group)).|....Sums|
|00001760| 20 75 70 20 64 61 74 61 | 20 76 61 6c 75 65 73 20 | up data| values |
|00001770| 66 6f 72 20 0d 61 20 73 | 70 65 63 69 66 69 63 20 |for .a s|pecific |
|00001780| 70 65 72 69 6f 64 20 6f | 66 20 74 69 6d 65 0d 0d |period o|f time..|
|00001790| 54 6f 74 61 6c 20 53 61 | 6c 65 73 20 3a 20 a5 50 |Total Sa|les : .P|
|000017a0| 72 6f 64 75 63 74 73 20 | 3d 0d 54 49 4d 45 53 55 |roducts |=.TIMESU|
|000017b0| 4d 28 20 53 61 6c 65 73 | 3a a5 50 72 6f 64 75 63 |M( Sales|:.Produc|
|000017c0| 74 73 0d 3a 31 2f 31 39 | 30 34 61 3b 20 53 74 61 |ts.:1/19|04a; Sta|
|000017d0| 72 74 20 74 69 6d 65 3b | 20 0d 45 6e 64 20 74 69 |rt time;| .End ti|
|000017e0| 6d 65 20 29 00 00 00 ad | 4d 61 6b 65 73 20 70 6f |me )....|Makes po|
|000017f0| 73 73 69 62 6c 65 20 0d | 63 6f 6e 64 69 74 69 6f |ssible .|conditio|
|00001800| 6e 61 6c 20 63 61 6c 63 | 75 6c 61 74 69 6f 6e 73 |nal calc|ulations|
|00001810| 0d 0d 49 46 20 28 20 46 | 5b 63 31 2c 72 31 5d 20 |..IF ( F|[c1,r1] |
|00001820| 3e 20 46 5b 63 32 2c 72 | 32 5d 20 29 20 54 48 45 |> F[c2,r|2] ) THE|
|00001830| 4e 20 0d 28 20 46 5b 63 | 33 2c 72 33 5d 20 29 20 |N .( F[c|3,r3] ) |
|00001840| 45 4c 53 45 20 28 20 46 | 5b 63 34 2c 72 34 5d 20 |ELSE ( F|[c4,r4] |
|00001850| 29 0d 0d 6f 72 0d 49 46 | 20 28 20 a5 50 72 6f 64 |)..or.IF| ( .Prod|
|00001860| 75 63 74 3a 53 61 6c 65 | 73 3a 31 2f 39 30 20 3c |uct:Sale|s:1/90 <|
|00001870| 20 31 30 30 30 20 29 0d | 54 48 45 4e 20 28 20 54 | 1000 ).|THEN ( T|
|00001880| 61 78 20 31 20 29 20 45 | 4c 53 45 20 28 20 54 61 |ax 1 ) E|LSE ( Ta|
|00001890| 78 20 32 20 29 00 00 00 | 78 43 68 61 6e 67 65 73 |x 2 )...|xChanges|
|000018a0| 20 61 6e 79 20 74 69 6d | 65 20 72 65 66 65 72 65 | any tim|e refere|
|000018b0| 6e 63 65 20 0d 69 6e 74 | 6f 20 61 20 6d 6f 6e 74 |nce .int|o a mont|
|000018c0| 68 6c 79 20 74 69 6d 65 | 20 72 65 66 65 72 65 6e |hly time| referen|
|000018d0| 63 65 20 0d 0d 4d 4f 4e | 54 48 20 28 20 44 61 74 |ce ..MON|TH ( Dat|
|000018e0| 65 20 29 0d 0d 28 66 6f | 72 20 65 78 61 6d 70 6c |e )..(fo|r exampl|
|000018f0| 65 2c 20 31 39 39 31 20 | 6f 72 20 31 2f 31 33 2f |e, 1991 |or 1/13/|
|00001900| 39 31 0d 62 65 63 6f 6d | 65 73 20 31 2f 39 31 20 |91.becom|es 1/91 |
|00001910| 29 00 00 00 7c 58 54 49 | 4d 45 20 28 30 29 20 72 |)...|XTI|ME (0) r|
|00001920| 65 70 72 65 73 65 6e 74 | 73 20 74 68 65 20 70 6f |epresent|s the po|
|00001930| 69 6e 74 20 6f 66 20 0d | 74 69 6d 65 20 61 73 20 |int of .|time as |
|00001940| 64 65 66 69 6e 65 64 20 | 69 6e 20 74 68 65 20 63 |defined |in the c|
|00001950| 65 6c 6c 0d 0d 53 61 6c | 65 73 3a 31 2f 39 30 20 |ell..Sal|es:1/90 |
|00001960| 3d 20 49 46 20 28 58 54 | 49 4d 45 20 28 30 29 20 |= IF (XT|IME (0) |
|00001970| 3e 0d 35 2f 39 30 29 20 | 54 48 45 4e 20 28 20 2e |>.5/90) |THEN ( .|
|00001980| 2e 2e 20 29 20 45 4c 53 | 45 20 28 20 2e 2e 2e 20 |.. ) ELS|E ( ... |
|00001990| 29 00 00 00 d6 41 6c 6c | 6f 77 73 20 66 6f 72 20 |)....All|ows for |
|000019a0| 61 6e 20 61 74 74 72 69 | 62 75 74 65 20 74 6f 20 |an attri|bute to |
|000019b0| 62 65 20 75 73 65 64 0d | 61 73 20 61 6e 20 61 74 |be used.|as an at|
|000019c0| 74 72 69 62 75 74 65 2c | 20 69 6e 73 74 65 61 64 |tribute,| instead|
|000019d0| 20 6f 66 20 61 20 0d 64 | 61 74 61 62 61 73 65 20 | of a .d|atabase |
|000019e0| 64 65 66 69 6e 69 74 69 | 6f 6e 0d 0d a5 53 74 6f |definiti|on...Sto|
|000019f0| 72 65 73 3a 20 53 61 6c | 65 73 20 3d 20 49 46 20 |res: Sal|es = IF |
|00001a00| 28 a5 53 74 6f 72 65 73 | 3a 0d 6d 61 67 6e 69 74 |(.Stores|:.magnit|
|00001a10| 75 64 65 20 3d 20 41 54 | 54 52 49 42 55 54 45 20 |ude = AT|TRIBUTE |
|00001a20| 28 6c 61 72 67 65 29 29 | 20 0d 54 48 45 4e 20 28 |(large))| .THEN (|
|00001a30| 20 2e 2e 2e 20 29 20 45 | 4c 53 45 20 28 20 2e 2e | ... ) E|LSE ( ..|
|00001a40| 2e 20 29 0d 0d 28 20 6c | 61 72 67 65 20 69 73 20 |. )..( l|arge is |
|00001a50| 69 6e 20 74 68 69 73 20 | 63 61 73 65 20 61 6e 20 |in this |case an |
|00001a60| 61 74 74 72 69 62 75 74 | 65 20 29 00 00 00 5e 45 |attribut|e )...^E|
|00001a70| 4d 50 54 59 20 28 30 29 | 20 72 65 70 72 65 73 65 |MPTY (0)| represe|
|00001a80| 6e 74 73 0d 61 6e 20 65 | 6d 70 74 79 20 66 69 65 |nts.an e|mpty fie|
|00001a90| 6c 64 0d 0d 49 46 20 28 | 20 46 5b 63 31 2c 72 31 |ld..IF (| F[c1,r1|
|00001aa0| 5d 20 3d 20 45 4d 50 54 | 59 20 28 30 29 20 29 20 |] = EMPT|Y (0) ) |
|00001ab0| 0d 54 48 45 4e 20 28 20 | 30 20 29 20 45 4c 53 45 |.THEN ( |0 ) ELSE|
|00001ac0| 20 28 20 46 5b 63 32 2c | 72 32 5d 20 29 00 00 00 | ( F[c2,|r2] )...|
|00001ad0| bc 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 64 |.This fu|nction d|
|00001ae0| 65 74 65 72 6d 69 6e 65 | 73 20 74 68 65 20 6e 75 |etermine|s the nu|
|00001af0| 6d 62 65 72 0d 6f 66 20 | 66 69 65 6c 64 73 20 77 |mber.of |fields w|
|00001b00| 68 69 63 68 20 61 72 65 | 20 69 6e 20 61 20 67 69 |hich are| in a gi|
|00001b10| 76 65 6e 20 72 61 6e 67 | 65 2c 0d 6f 72 20 74 68 |ven rang|e,.or th|
|00001b20| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 61 74 74 72 |e number| of attr|
|00001b30| 69 62 75 74 65 73 20 69 | 6e 20 61 0d 67 69 76 65 |ibutes i|n a.give|
|00001b40| 6e 20 64 61 74 61 62 61 | 73 65 20 73 65 6c 65 63 |n databa|se selec|
|00001b50| 74 69 6f 6e 0d 0d 43 4f | 55 4e 54 41 4c 4c 28 20 |tion..CO|UNTALL( |
|00001b60| 46 5b 63 2c 72 31 2e 2e | 72 32 5d 20 29 0d 0d 6f |F[c,r1..|r2] )..o|
|00001b70| 72 0d 43 4f 55 4e 54 41 | 4c 4c 28 20 a5 50 72 6f |r.COUNTA|LL( .Pro|
|00001b80| 64 75 63 74 73 3a 28 61 | 6c 6c 29 20 29 00 00 01 |ducts:(a|ll) )...|
|00001b90| 16 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 64 |.This fu|nction d|
|00001ba0| 65 74 65 72 6d 69 6e 65 | 73 20 74 68 65 20 6e 75 |etermine|s the nu|
|00001bb0| 6d 62 65 72 0d 6f 66 20 | 66 69 65 6c 64 73 20 69 |mber.of |fields i|
|00001bc0| 6e 20 61 20 67 69 76 65 | 6e 20 72 61 6e 67 65 2c |n a give|n range,|
|00001bd0| 0d 6f 72 20 74 68 65 20 | 6e 75 6d 62 65 72 20 6f |.or the |number o|
|00001be0| 66 20 61 74 74 72 69 62 | 75 74 65 73 20 69 6e 20 |f attrib|utes in |
|00001bf0| 61 0d 67 69 76 65 6e 20 | 64 61 74 61 62 61 73 65 |a.given |database|
|00001c00| 20 73 65 6c 65 63 74 69 | 6f 6e 2c 20 74 61 6b 69 | selecti|on, taki|
|00001c10| 6e 67 20 69 6e 74 6f 20 | 0d 63 6f 6e 73 69 64 65 |ng into |.conside|
|00001c20| 72 61 74 69 6f 6e 20 6f | 6e 6c 79 20 74 68 6f 73 |ration o|nly thos|
|00001c30| 65 20 63 65 6c 6c 73 20 | 74 68 61 74 20 0d 61 72 |e cells |that .ar|
|00001c40| 65 20 6e 6f 74 20 65 6d | 70 74 79 0d 0d 43 4f 55 |e not em|pty..COU|
|00001c50| 4e 54 56 41 4c 55 45 28 | 20 46 5b 63 2c 72 31 2e |NTVALUE(| F[c,r1.|
|00001c60| 2e 72 32 5d 20 29 0d 0d | 6f 72 0d 43 4f 55 4e 54 |.r2] )..|or.COUNT|
|00001c70| 56 41 4c 55 45 28 a5 50 | 72 6f 64 75 63 74 73 3a |VALUE(.P|roducts:|
|00001c80| 28 61 6c 6c 29 3a 0d 20 | 20 20 20 20 20 20 20 20 |(all):. | |
|00001c90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001ca0| 20 53 61 6c 65 73 29 00 | 00 00 76 54 68 65 20 6d | Sales).|..vThe m|
|00001cb0| 6f 73 74 20 73 70 65 63 | 69 66 69 63 20 65 6c 65 |ost spec|ific ele|
|00001cc0| 6d 65 6e 74 20 6f 66 20 | 0d 61 20 74 69 6d 65 20 |ment of |.a time |
|00001cd0| 72 65 66 65 72 65 6e 63 | 65 20 62 65 63 6f 6d 65 |referenc|e become|
|00001ce0| 73 20 0d 61 20 6e 75 6d | 65 72 69 63 61 6c 20 76 |s .a num|erical v|
|00001cf0| 61 6c 75 65 0d 0d 50 45 | 52 49 4f 44 20 28 33 2f |alue..PE|RIOD (3/|
|00001d00| 39 30 29 20 62 65 63 6f | 6d 65 73 20 33 3b 0d 28 |90) beco|mes 3;.(|
|00001d10| 31 2f 33 2f 39 31 29 20 | 62 65 63 6f 6d 65 73 20 |1/3/91) |becomes |
|00001d20| 31 00 00 00 69 47 69 76 | 65 73 20 74 68 65 20 63 |1...iGiv|es the c|
|00001d30| 75 72 72 65 6e 74 20 64 | 61 74 65 20 0d 6f 72 20 |urrent d|ate .or |
|00001d40| 74 68 65 20 63 75 72 72 | 65 6e 74 20 74 69 6d 65 |the curr|ent time|
|00001d50| 0d 0d 44 41 54 45 54 49 | 4d 45 20 28 30 29 20 67 |..DATETI|ME (0) g|
|00001d60| 69 76 65 73 20 74 68 65 | 20 64 61 74 65 0d 0d 6f |ives the| date..o|
|00001d70| 72 0d 44 41 54 45 54 49 | 4d 45 20 28 31 29 20 67 |r.DATETI|ME (1) g|
|00001d80| 69 76 65 73 20 74 68 65 | 20 74 69 6d 65 0d 00 00 |ives the| time...|
|00001d90| 00 2d 43 68 61 6e 67 65 | 73 20 61 6e 79 20 64 61 |.-Change|s any da|
|00001da0| 74 61 20 74 79 70 65 20 | 74 6f 20 74 65 78 74 0d |ta type |to text.|
|00001db0| 0d 54 45 58 54 20 28 20 | 56 61 6c 75 65 20 29 00 |.TEXT ( |Value ).|
|00001dc0| 00 00 74 41 64 64 73 20 | 74 77 6f 20 63 65 6c 6c |..tAdds |two cell|
|00001dd0| 73 20 74 6f 67 65 74 68 | 65 72 2c 20 61 73 20 6c |s togeth|er, as l|
|00001de0| 6f 6e 67 20 61 73 0d 62 | 6f 74 68 20 63 65 6c 6c |ong as.b|oth cell|
|00001df0| 73 20 61 72 65 20 6e 6f | 74 20 45 4d 50 54 59 3b |s are no|t EMPTY;|
|00001e00| 20 6f 74 68 65 72 77 69 | 73 65 2c 0d 74 68 65 20 | otherwi|se,.the |
|00001e10| 72 65 73 75 6c 74 20 69 | 73 20 45 4d 50 54 59 20 |result i|s EMPTY |
|00001e20| 0d 0d 56 61 6c 75 65 20 | 31 20 50 4c 55 53 20 56 |..Value |1 PLUS V|
|00001e30| 61 6c 75 65 20 32 20 00 | 00 00 7e 53 75 62 74 72 |alue 2 .|..~Subtr|
|00001e40| 61 63 74 73 20 6f 6e 65 | 20 63 65 6c 6c 20 66 72 |acts one| cell fr|
|00001e50| 6f 6d 20 61 6e 6f 74 68 | 65 72 2c 20 0d 61 73 20 |om anoth|er, .as |
|00001e60| 6c 6f 6e 67 20 61 73 20 | 62 6f 74 68 20 63 65 6c |long as |both cel|
|00001e70| 6c 73 20 61 72 65 20 6e | 6f 74 20 45 4d 50 54 59 |ls are n|ot EMPTY|
|00001e80| 3b 20 0d 6f 74 68 65 72 | 77 69 73 65 2c 20 74 68 |; .other|wise, th|
|00001e90| 65 20 72 65 73 75 6c 74 | 20 69 73 20 45 4d 50 54 |e result| is EMPT|
|00001ea0| 59 0d 0d 56 61 6c 75 65 | 20 31 20 4d 49 4e 55 53 |Y..Value| 1 MINUS|
|00001eb0| 20 56 61 6c 75 65 20 32 | 20 00 00 00 19 6c 6f 67 | Value 2| ....log|
|00001ec0| 20 62 61 73 65 20 31 30 | 0d 0d 4c 47 20 28 20 56 | base 10|..LG ( V|
|00001ed0| 61 6c 75 65 20 29 00 00 | 00 1d 41 62 73 6f 6c 75 |alue )..|..Absolu|
|00001ee0| 74 65 20 76 61 6c 75 65 | 0d 0d 41 42 53 20 28 20 |te value|..ABS ( |
|00001ef0| 56 61 6c 75 65 20 29 00 | 00 00 5b 54 68 69 73 20 |Value ).|..[This |
|00001f00| 65 6e 61 62 6c 65 73 20 | 74 68 65 20 75 73 65 72 |enables |the user|
|00001f10| 20 20 20 20 20 20 20 20 | 20 0d 74 6f 20 63 68 6f | | .to cho|
|00001f20| 6f 73 65 20 61 64 64 69 | 74 69 6f 6e 61 6c 20 20 |ose addi|tional |
|00001f30| 20 20 20 20 20 20 20 20 | 20 0d 66 75 6e 63 74 69 | | .functi|
|00001f40| 6f 6e 73 20 74 68 61 74 | 20 61 72 65 20 61 76 61 |ons that| are ava|
|00001f50| 69 6c 61 62 6c 65 00 00 | 00 88 54 68 69 73 20 66 |ilable..|..This f|
|00001f60| 75 6e 63 74 69 6f 6e 20 | 61 6c 6c 6f 77 73 20 74 |unction |allows t|
|00001f70| 68 65 20 75 73 65 72 20 | 74 6f 20 61 64 64 0d 74 |he user |to add.t|
|00001f80| 65 78 74 20 74 6f 20 61 | 20 6d 61 63 72 6f 66 6f |ext to a| macrofo|
|00001f90| 72 6d 75 6c 61 0d 0d 0d | 4d 61 63 72 6f 66 6f 72 |rmula...|Macrofor|
|00001fa0| 6d 75 6c 61 3a 4e 4f 69 | 3a 28 57 6f 72 6b 73 68 |mula:NOi|:(Worksh|
|00001fb0| 65 65 74 29 20 3d 0d 41 | 55 54 4f 41 53 53 49 47 |eet) =.A|UTOASSIG|
|00001fc0| 4e 4d 45 4e 54 28 2e 2e | 2e 20 29 0d 2b 22 20 43 |NMENT(..|. ).+" C|
|00001fd0| 72 65 61 74 65 20 41 73 | 73 69 67 6e 6d 65 6e 74 |reate As|signment|
|00001fe0| 20 22 00 00 00 f4 48 65 | 6c 70 73 20 74 6f 20 64 | "....He|lps to d|
|00001ff0| 65 66 69 6e 65 20 74 68 | 65 20 74 69 6d 65 20 72 |efine th|e time r|
|00002000| 61 6e 67 65 20 66 6f 72 | 20 0d 66 75 6e 63 74 69 |ange for| .functi|
|00002010| 6f 6e 73 20 77 68 69 63 | 68 20 63 61 72 72 79 20 |ons whic|h carry |
|00002020| 6f 75 74 20 0d 74 69 6d | 65 20 72 61 6e 67 65 20 |out .tim|e range |
|00002030| 6f 70 65 72 61 74 69 6f | 6e 73 0d 0d 41 53 53 49 |operatio|ns..ASSI|
|00002040| 47 4e 4d 45 4e 54 3a 4e | 4f 69 3a 28 57 6f 72 6b |GNMENT:N|Oi:(Work|
|00002050| 73 68 65 65 74 29 20 3d | 0d 41 55 54 4f 41 53 53 |sheet) =|.AUTOASS|
|00002060| 49 47 4e 4d 45 4e 54 28 | a5 44 65 70 61 72 74 6d |IGNMENT(|.Departm|
|00002070| 65 6e 74 73 3b 0d a5 44 | 65 70 61 72 74 6d 65 6e |ents;..D|epartmen|
|00002080| 74 73 3a 43 6f 73 74 73 | 3a 0d 31 2f 39 30 20 74 |ts:Costs|:.1/90 t|
|00002090| 6f 20 31 32 2f 39 32 29 | 20 20 0d 0d 6f 72 0d a5 |o 12/92)| ..or..|
|000020a0| 50 72 6f 64 75 63 74 73 | 3a 53 61 6c 65 73 20 54 |Products|:Sales T|
|000020b0| 6f 74 61 6c 20 3d 0d 53 | 55 4d 28 a5 50 72 6f 64 |otal =.S|UM(.Prod|
|000020c0| 75 63 74 73 3a 53 61 6c | 65 73 3a 0d 31 2f 39 30 |ucts:Sal|es:.1/90|
|000020d0| 20 74 6f 20 31 32 2f 39 | 31 29 00 00 00 c7 4d 61 | to 12/9|1)....Ma|
|000020e0| 63 72 6f 66 75 6e 63 74 | 69 6f 6e 20 74 68 61 74 |crofunct|ion that|
|000020f0| 20 65 6e 61 62 6c 65 73 | 20 74 68 65 20 75 73 65 | enables| the use|
|00002100| 72 0d 74 6f 20 61 75 74 | 6f 6d 61 74 69 63 61 6c |r.to aut|omatical|
|00002110| 6c 79 20 70 72 69 6e 74 | 20 61 20 67 69 76 65 6e |ly print| a given|
|00002120| 20 73 65 74 20 6f 66 0d | 70 61 67 65 73 0d 0d 4d | set of.|pages..M|
|00002130| 61 63 72 6f 66 6f 72 6d | 75 6c 61 20 3a 20 4e 4f |acroform|ula : NO|
|00002140| 69 20 3a 20 28 57 6f 72 | 6b 73 68 65 65 74 29 20 |i : (Wor|ksheet) |
|00002150| 3d 20 0d 41 55 54 4f 50 | 52 49 4e 54 20 28 20 46 |= .AUTOP|RINT ( F|
|00002160| 5b 63 31 2e 2e 63 32 2c | 72 31 2e 2e 72 32 5d 20 |[c1..c2,|r1..r2] |
|00002170| 29 0d 0d 28 46 5b 63 31 | 2e 2e 63 32 2c 72 31 2e |)..(F[c1|..c2,r1.|
|00002180| 2e 72 32 5d 20 64 65 66 | 69 6e 65 73 20 74 68 65 |.r2] def|ines the|
|00002190| 20 70 61 67 65 73 0d 74 | 6f 20 62 65 20 70 72 69 | pages.t|o be pri|
|000021a0| 6e 74 65 64 29 00 00 00 | c4 4d 61 63 72 6f 66 75 |nted)...|.Macrofu|
|000021b0| 6e 63 74 69 6f 6e 20 74 | 68 61 74 20 69 6d 70 6f |nction t|hat impo|
|000021c0| 72 74 73 20 0d 61 20 74 | 65 78 74 20 66 69 6c 65 |rts .a t|ext file|
|000021d0| 0d 0d 4d 41 43 52 4f 46 | 55 4e 43 54 49 4f 4e 3a |..MACROF|UNCTION:|
|000021e0| 20 4e 4f 69 3a 20 28 57 | 6f 72 6b 73 68 65 65 74 | NOi: (W|orksheet|
|000021f0| 29 20 3d 0d 41 55 54 4f | 49 4d 50 4f 52 54 28 20 |) =.AUTO|IMPORT( |
|00002200| 46 5b 63 31 2e 2e 63 32 | 2c 72 31 2e 2e 72 32 5d |F[c1..c2|,r1..r2]|
|00002210| 3b 0d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |;. | |
|00002220| 20 20 20 20 20 20 20 20 | 20 20 20 30 20 6f 72 20 | | 0 or |
|00002230| 46 69 6c 65 20 6e 61 6d | 65 3b 30 20 29 0d 0d 28 |File nam|e;0 )..(|
|00002240| 20 46 5b 63 31 2e 2e 63 | 32 2c 72 31 2e 2e 72 32 | F[c1..c|2,r1..r2|
|00002250| 5d 20 64 65 66 69 6e 65 | 73 20 74 68 65 20 0d 69 |] define|s the .i|
|00002260| 6d 70 6f 72 74 20 66 6f | 72 6d 61 74 29 00 00 01 |mport fo|rmat)...|
|00002270| 32 4d 61 63 72 6f 66 75 | 6e 63 74 69 6f 6e 20 74 |2Macrofu|nction t|
|00002280| 68 61 74 20 65 78 70 6f | 72 74 73 20 0d 64 61 74 |hat expo|rts .dat|
|00002290| 61 20 74 6f 20 61 20 74 | 65 78 74 20 66 69 6c 65 |a to a t|ext file|
|000022a0| 0d 0d 4d 41 43 52 4f 46 | 55 4e 43 54 49 4f 4e 3a |..MACROF|UNCTION:|
|000022b0| 20 4e 4f 69 20 20 3d 20 | 41 55 54 4f 45 58 50 4f | NOi = |AUTOEXPO|
|000022c0| 52 54 0d 28 47 65 6e 65 | 72 61 6c 69 7a 65 64 20 |RT.(Gene|ralized |
|000022d0| 49 6e 70 75 74 20 56 61 | 6c 75 65 3b 20 53 65 6c |Input Va|lue; Sel|
|000022e0| 65 63 74 69 6f 6e 20 6f | 72 20 30 3b 0d 20 46 69 |ection o|r 0;. Fi|
|000022f0| 6c 65 20 6e 61 6d 65 20 | 6f 72 20 30 3b 20 30 3b |le name |or 0; 0;|
|00002300| 20 45 78 70 6f 72 74 20 | 66 6f 72 6d 61 74 20 6f | Export |format o|
|00002310| 72 20 30 29 0d 0d 28 20 | 30 20 69 6e 73 74 65 61 |r 0)..( |0 instea|
|00002320| 64 20 6f 66 20 73 65 6c | 65 63 74 69 6f 6e 20 3a |d of sel|ection :|
|00002330| 20 6e 6f 20 73 65 6c 65 | 63 74 69 6f 6e 3b 0d 20 | no sele|ction;. |
|00002340| 20 30 20 69 6e 73 74 65 | 61 64 20 6f 66 20 66 69 | 0 inste|ad of fi|
|00002350| 6c 65 20 6e 61 6d 65 20 | 3a 20 6d 61 6e 75 61 6c |le name |: manual|
|00002360| 20 66 69 6c 65 20 73 65 | 6c 65 63 74 69 6f 6e 3b | file se|lection;|
|00002370| 0d 20 20 30 20 69 6e 73 | 74 65 61 64 20 6f 66 20 |. 0 ins|tead of |
|00002380| 65 78 70 6f 72 74 20 66 | 6f 72 6d 61 74 20 3a 20 |export f|ormat : |
|00002390| 73 74 61 6e 64 61 72 64 | 20 66 6f 72 6d 61 74 20 |standard| format |
|000023a0| 29 0d 0d 00 00 01 13 4d | 61 63 72 6f 66 75 6e 63 |)......M|acrofunc|
|000023b0| 74 69 6f 6e 20 66 6f 72 | 20 0d 63 72 65 61 74 69 |tion for| .creati|
|000023c0| 6e 67 20 61 73 73 69 67 | 6e 6d 65 6e 74 73 20 0d |ng assig|nments .|
|000023d0| 0d 4d 41 43 52 4f 46 55 | 4e 43 54 49 4f 4e 3a 4e |.MACROFU|NCTION:N|
|000023e0| 4f 69 20 3d 0d 41 55 54 | 4f 41 53 53 49 47 4e 4d |Oi =.AUT|OASSIGNM|
|000023f0| 45 4e 54 20 0d 28 6c 65 | 66 74 20 73 69 64 65 20 |ENT .(le|ft side |
|00002400| 6f 66 20 61 73 73 69 67 | 6e 6d 65 6e 74 3b 20 47 |of assig|nment; G|
|00002410| 72 6f 75 70 20 74 6f 20 | 0d 62 65 20 61 73 73 69 |roup to |.be assi|
|00002420| 67 6e 65 64 3b 20 47 65 | 6e 65 72 61 6c 69 7a 65 |gned; Ge|neralize|
|00002430| 64 0d 49 6e 70 75 74 20 | 56 61 6c 75 65 29 0d 0d |d.Input |Value)..|
|00002440| 6f 72 0d 4d 41 43 52 4f | 46 55 4e 43 54 49 4f 4e |or.MACRO|FUNCTION|
|00002450| 3a 4e 4f 69 20 3d 0d 41 | 55 54 4f 41 53 53 49 47 |:NOi =.A|UTOASSIG|
|00002460| 4e 4d 45 4e 54 20 0d 28 | 4c 65 66 74 20 73 69 64 |NMENT .(|Left sid|
|00002470| 65 20 6f 66 20 61 73 73 | 69 67 6e 6d 65 6e 74 3b |e of ass|ignment;|
|00002480| 20 47 72 6f 75 70 20 74 | 6f 0d 62 65 20 61 73 73 | Group t|o.be ass|
|00002490| 69 67 6e 65 64 3b 20 47 | 65 6e 65 72 61 6c 69 7a |igned; G|eneraliz|
|000024a0| 65 64 20 49 6e 70 75 74 | 0d 56 61 6c 75 65 3b 20 |ed Input|.Value; |
|000024b0| 53 65 6c 65 63 74 69 6f | 6e 29 00 00 00 85 4d 61 |Selectio|n)....Ma|
|000024c0| 63 72 6f 66 75 6e 63 74 | 69 6f 6e 20 74 68 61 74 |crofunct|ion that|
|000024d0| 20 64 65 6c 65 74 65 73 | 20 61 6c 6c 0d 64 61 74 | deletes| all.dat|
|000024e0| 61 62 61 73 65 20 76 61 | 6c 75 65 73 20 6f 66 20 |abase va|lues of |
|000024f0| 61 20 67 69 76 65 6e 0d | 67 65 6e 65 72 61 6c 69 |a given.|generali|
|00002500| 7a 61 74 69 6f 6e 0d 0d | 4d 41 43 52 4f 46 55 4e |zation..|MACROFUN|
|00002510| 43 54 49 4f 4e 3a 4e 4f | 69 20 3d 0d 44 45 4c 45 |CTION:NO|i =.DELE|
|00002520| 54 45 20 28 20 47 65 6e | 65 72 61 6c 69 7a 65 64 |TE ( Gen|eralized|
|00002530| 20 49 6e 70 75 74 0d 56 | 61 6c 75 65 3b 30 20 3b | Input.V|alue;0 ;|
|00002540| 30 20 29 00 00 01 01 4d | 61 63 72 6f 66 75 6e 63 |0 )....M|acrofunc|
|00002550| 74 69 6f 6e 20 66 6f 72 | 20 74 68 65 20 73 6f 72 |tion for| the sor|
|00002560| 74 69 6e 67 0d 6f 66 20 | 61 73 73 69 67 6e 6d 65 |ting.of |assignme|
|00002570| 6e 74 73 0d 0d 4d 41 43 | 52 4f 46 55 4e 43 54 49 |nts..MAC|ROFUNCTI|
|00002580| 4f 4e 3a 20 4e 4f 69 20 | 3d 0d 41 55 54 4f 53 4f |ON: NOi |=.AUTOSO|
|00002590| 52 54 28 20 44 65 66 69 | 6e 69 74 69 6f 6e 20 6f |RT( Defi|nition o|
|000025a0| 66 20 0d 61 73 73 69 67 | 6e 6d 65 6e 74 3b 20 53 |f .assig|nment; S|
|000025b0| 6f 72 74 69 6e 67 20 63 | 72 69 74 65 72 69 6f 6e |orting c|riterion|
|000025c0| 20 0d 6f 72 20 30 20 3b | 20 6e 20 29 0d 0d 28 20 | .or 0 ;| n )..( |
|000025d0| 30 20 49 6e 73 74 65 61 | 64 20 6f 66 20 73 6f 72 |0 Instea|d of sor|
|000025e0| 74 69 6e 67 20 63 72 69 | 74 65 72 69 6f 6e 20 3a |ting cri|terion :|
|000025f0| 20 0d 20 20 20 20 20 41 | 6c 70 68 61 6e 75 6d 65 | . A|lphanume|
|00002600| 72 69 63 20 73 6f 72 74 | 69 6e 67 3b 0d 20 20 6e |ric sort|ing;. n|
|00002610| 20 3d 20 31 20 41 73 63 | 65 6e 64 69 6e 67 20 73 | = 1 Asc|ending s|
|00002620| 6f 72 74 69 6e 67 3b 0d | 20 20 6e 20 3d 20 32 20 |orting;.| n = 2 |
|00002630| 44 65 73 63 65 6e 64 69 | 6e 67 20 20 73 6f 72 74 |Descendi|ng sort|
|00002640| 69 6e 67 20 29 0d 20 20 | 00 00 00 ff 43 6f 6d 62 |ing ). |....Comb|
|00002650| 69 6e 65 73 20 6d 75 6c | 74 69 70 6c 65 20 4d 61 |ines mul|tiple Ma|
|00002660| 63 72 6f 20 66 6f 72 6d | 75 6c 61 73 20 0d 69 6e |cro form|ulas .in|
|00002670| 74 6f 20 61 20 73 69 6e | 67 6c 65 20 66 6f 72 6d |to a sin|gle form|
|00002680| 75 6c 61 0d 0d 4d 61 63 | 72 6f 66 6f 72 6d 75 6c |ula..Mac|roformul|
|00002690| 61 3a 4e 4f 69 3a 28 57 | 6f 72 6b 73 68 65 65 74 |a:NOi:(W|orksheet|
|000026a0| 29 20 3d 0d 4d 41 43 52 | 4f 20 28 46 5b 63 31 2e |) =.MACR|O (F[c1.|
|000026b0| 2e 63 32 2c 72 31 2e 2e | 72 32 5d 3b 20 6e 3b 20 |.c2,r1..|r2]; n; |
|000026c0| 6d 29 0d 0d 6e 20 3d 20 | 30 20 20 77 69 74 68 20 |m)..n = |0 with |
|000026d0| 44 69 73 70 6c 61 79 3b | 20 20 0d 6e 20 3d 20 31 |Display;| .n = 1|
|000026e0| 20 20 77 69 74 68 6f 75 | 74 20 44 69 73 70 6c 61 | withou|t Displa|
|000026f0| 79 3b 0d 6d 20 3d 20 30 | 20 6d 61 6e 75 61 6c 20 |y;.m = 0| manual |
|00002700| 73 74 61 72 74 3b 0d 6d | 20 3d 20 32 20 61 75 74 |start;.m| = 2 aut|
|00002710| 6f 6d 61 74 69 63 20 73 | 74 61 72 74 3b 0d 46 5b |omatic s|tart;.F[|
|00002720| 63 31 2e 2e 63 32 2c 72 | 31 2e 2e 72 32 5d 20 63 |c1..c2,r|1..r2] c|
|00002730| 6f 6e 74 61 69 6e 73 20 | 74 68 65 20 0d 4d 61 63 |ontains |the .Mac|
|00002740| 72 6f 20 66 6f 72 6d 75 | 6c 61 73 00 00 01 0e 4d |ro formu|las....M|
|00002750| 61 63 72 6f 66 75 6e 63 | 74 69 6f 6e 20 74 6f 20 |acrofunc|tion to |
|00002760| 63 68 6f 73 65 20 61 20 | 73 74 61 74 65 20 6f 66 |chose a |state of|
|00002770| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 20 0d 0d 53 | calcula|tion ..S|
|00002780| 45 54 53 54 41 54 45 20 | 28 20 6e 20 29 0d 6e 0d |ETSTATE |( n ).n.|
|00002790| 3d 20 31 3a 09 42 61 73 | 65 20 43 61 6c 63 75 6c |= 1:.Bas|e Calcul|
|000027a0| 61 74 69 6f 6e 0d 3d 20 | 32 3a 09 50 68 61 73 65 |ation.= |2:.Phase|
|000027b0| 20 32 0d 3d 20 33 3a 09 | 6e 6f 20 63 6f 72 72 65 | 2.= 3:.|no corre|
|000027c0| 63 74 69 6f 6e 20 6f 66 | 20 72 65 73 75 6c 74 73 |ction of| results|
|000027d0| 0d 3d 20 34 3a 09 63 6f | 72 72 65 63 74 69 6f 6e |.= 4:.co|rrection|
|000027e0| 20 6f 6e 6c 79 20 77 69 | 74 68 20 62 61 73 65 20 | only wi|th base |
|000027f0| 66 6f 6d 75 6c 61 73 0d | 3d 20 35 3a 09 63 6f 72 |fomulas.|= 5:.cor|
|00002800| 72 65 63 74 69 6f 6e 20 | 77 69 74 68 20 65 76 65 |rection |with eve|
|00002810| 72 79 20 66 6f 72 6d 75 | 6c 61 0d 3d 20 36 3a 09 |ry formu|la.= 6:.|
|00002820| 75 70 64 61 74 65 20 62 | 75 69 6c 64 2d 75 70 20 |update b|uild-up |
|00002830| 61 72 65 61 0d 3d 20 37 | 3a 09 62 75 66 66 65 72 |area.= 7|:.buffer|
|00002840| 20 65 6e 74 72 69 65 73 | 0d 3d 20 38 3a 09 65 76 | entries|.= 8:.ev|
|00002850| 61 6c 75 61 74 65 20 62 | 75 66 66 65 72 00 00 00 |aluate b|uffer...|
|00002860| 9f 4d 61 63 72 6f 66 75 | 6e 63 74 69 6f 6e 20 74 |.Macrofu|nction t|
|00002870| 68 61 74 20 6f 70 65 6e | 73 20 61 20 64 69 61 6c |hat open|s a dial|
|00002880| 6f 67 2e 20 54 68 65 20 | 20 20 0d 75 73 65 72 20 |og. The | .user |
|00002890| 6d 61 79 20 71 75 69 74 | 20 74 68 65 20 6d 61 63 |may quit| the mac|
|000028a0| 72 6f 20 66 72 6f 6d 20 | 77 68 69 63 68 20 20 20 |ro from |which |
|000028b0| 20 20 0d 74 68 69 73 20 | 6d 61 63 72 6f 66 75 6e | .this |macrofun|
|000028c0| 63 74 69 6f 6e 20 68 61 | 73 20 62 65 65 6e 20 63 |ction ha|s been c|
|000028d0| 61 6c 6c 65 64 20 75 70 | 2e 20 20 20 20 0d 0d 43 |alled up|. ..C|
|000028e0| 4f 4e 46 49 52 4d 20 28 | 22 44 6f 20 79 6f 75 20 |ONFIRM (|"Do you |
|000028f0| 77 61 6e 74 20 74 6f 20 | 71 75 69 74 20 3f 22 29 |want to |quit ?")|
|00002900| 00 00 00 98 4d 61 63 72 | 6f 66 75 6e 63 74 69 6f |....Macr|ofunctio|
|00002910| 6e 20 66 6f 72 20 61 75 | 74 6f 6d 61 74 69 63 61 |n for au|tomatica|
|00002920| 6c 6c 79 20 63 72 65 61 | 74 69 6e 67 0d 61 73 73 |lly crea|ting.ass|
|00002930| 69 67 6e 6d 65 6e 74 73 | 20 64 75 72 69 6e 67 20 |ignments| during |
|00002940| 61 20 64 61 74 61 20 69 | 6d 70 6f 72 74 0d 0d 41 |a data i|mport..A|
|00002950| 43 54 49 56 41 54 45 20 | 28 41 73 73 69 67 6e 6d |CTIVATE |(Assignm|
|00002960| 65 6e 74 20 64 65 66 69 | 6e 69 74 69 6f 6e 3b 20 |ent defi|nition; |
|00002970| 0d 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002980| 20 20 20 47 72 6f 75 70 | 20 74 6f 20 62 65 20 61 | Group| to be a|
|00002990| 73 73 69 67 6e 65 64 3b | 20 30 29 20 00 00 01 0a |ssigned;| 0) ....|
|000029a0| 4d 61 63 72 6f 66 75 6e | 63 74 69 6f 6e 20 66 6f |Macrofun|ction fo|
|000029b0| 72 20 63 6f 70 79 69 6e | 67 20 74 68 65 20 63 6f |r copyin|g the co|
|000029c0| 6e 74 65 6e 74 73 0d 6f | 66 20 6f 6e 65 20 73 65 |ntents.o|f one se|
|000029d0| 6c 65 63 74 65 64 20 61 | 72 65 61 20 69 6e 74 6f |lected a|rea into|
|000029e0| 20 61 6e 6f 74 68 65 72 | 20 20 0d 0d 4d 41 43 52 | another| ..MACR|
|000029f0| 4f 46 55 4e 43 54 49 4f | 4e 3a 4e 4f 69 3a 20 28 |OFUNCTIO|N:NOi: (|
|00002a00| 57 6f 72 6b 73 68 65 65 | 74 29 20 3d 0d 43 4f 50 |Workshee|t) =.COP|
|00002a10| 59 20 28 46 5b 63 31 2e | 2e 63 32 2c 72 31 2e 2e |Y (F[c1.|.c2,r1..|
|00002a20| 72 32 5d 3b 20 46 5b 63 | 33 2e 2e 63 34 2c 72 33 |r2]; F[c|3..c4,r3|
|00002a30| 2e 2e 72 34 5d 3b 20 6e | 29 0d 0d 6e 20 3d 20 30 |..r4]; n|)..n = 0|
|00002a40| 20 20 6c 69 6b 65 20 43 | 4f 50 59 20 61 6e 64 20 | like C|OPY and |
|00002a50| 50 41 53 54 45 20 20 66 | 72 6f 6d 20 74 68 65 20 |PASTE f|rom the |
|00002a60| 6d 65 6e 75 0d 6e 20 3d | 20 31 20 20 6c 69 6b 65 |menu.n =| 1 like|
|00002a70| 20 43 4f 50 59 20 61 6e | 64 20 50 41 53 54 45 20 | COPY an|d PASTE |
|00002a80| 53 50 45 43 49 41 4c 20 | 0d ca ca ca ca 20 20 56 |SPECIAL |..... V|
|00002a90| 41 4c 55 45 53 20 4f 4e | 4c 59 20 20 66 72 6f 6d |ALUES ON|LY from|
|00002aa0| 20 74 68 65 20 6d 65 6e | 75 0d 00 00 00 87 4d 61 | the men|u.....Ma|
|00002ab0| 63 72 6f 66 75 6e 63 74 | 69 6f 6e 20 66 6f 72 20 |crofunct|ion for |
|00002ac0| 61 75 74 6f 6d 61 74 69 | 63 61 6c 6c 79 20 0d 62 |automati|cally .b|
|00002ad0| 75 69 6c 64 69 6e 67 20 | 75 70 20 61 20 63 6f 6e |uilding |up a con|
|00002ae0| 6e 65 63 74 69 6f 6e 20 | 74 6f 20 61 20 68 6f 73 |nection |to a hos|
|00002af0| 74 0d 20 0d 43 4f 4e 4e | 45 43 54 20 28 44 61 74 |t. .CONN|ECT (Dat|
|00002b00| 61 62 61 73 65 20 65 78 | 74 65 6e 73 69 6f 6e 3b |abase ex|tension;|
|00002b10| 20 0d 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | . | |
|00002b20| 20 20 20 20 20 48 6f 73 | 74 3b 20 41 64 64 69 74 | Hos|t; Addit|
|00002b30| 69 6f 6e 20 29 00 00 00 | 50 4d 61 63 72 6f 66 75 |ion )...|PMacrofu|
|00002b40| 6e 63 74 69 6f 6e 20 74 | 68 61 74 20 73 65 6e 64 |nction t|hat send|
|00002b50| 73 0d 61 20 71 75 65 72 | 79 20 74 6f 20 61 20 68 |s.a quer|y to a h|
|00002b60| 6f 73 74 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ost | |
|00002b70| 0d 0d 53 45 4e 44 20 28 | 51 75 65 72 79 3b 20 46 |..SEND (|Query; F|
|00002b80| 69 6c 65 20 6e 61 6d 65 | 29 00 00 00 32 4d 61 63 |ile name|)...2Mac|
|00002b90| 72 6f 66 75 6e 63 74 69 | 6f 6e 20 66 6f 72 20 0d |rofuncti|on for .|
|00002ba0| 71 75 69 74 74 69 6e 67 | 20 6d 61 63 43 6f 6e 74 |quitting| macCont|
|00002bb0| 72 6f 6c 0d 0d 51 55 49 | 54 20 28 20 30 20 29 00 |rol..QUI|T ( 0 ).|
|00002bc0| 00 00 65 4d 61 63 72 6f | 66 75 6e 63 74 69 6f 6e |..eMacro|function|
|00002bd0| 20 66 6f 72 20 6f 70 65 | 6e 69 6e 67 0d 61 20 77 | for ope|ning.a w|
|00002be0| 6f 72 6b 73 68 65 65 74 | 0d 0d 4d 41 43 52 4f 46 |orksheet|..MACROF|
|00002bf0| 55 4e 43 54 49 4f 4e 20 | 3a 20 4e 4f 69 20 3d 0d |UNCTION |: NOi =.|
|00002c00| 4f 50 45 4e 20 28 41 54 | 54 52 49 42 55 54 45 0d |OPEN (AT|TRIBUTE.|
|00002c10| 20 28 4e 61 6d 65 20 6f | 66 20 77 6f 72 6b 73 68 | (Name o|f worksh|
|00002c20| 65 65 74 29 3b 20 30 29 | 00 00 00 f8 4d 61 63 72 |eet); 0)|....Macr|
|00002c30| 6f 66 75 6e 63 74 69 6f | 6e 20 61 6e 61 6c 79 73 |ofunctio|n analys|
|00002c40| 69 6e 67 20 61 6c 20 6c | 20 66 6f 72 6d 75 6c 61 |ing al l| formula|
|00002c50| 73 0d 0d 41 4e 41 4c 59 | 53 45 20 28 20 6e 20 29 |s..ANALY|SE ( n )|
|00002c60| 0d 0d 28 20 6e 20 3d 20 | 31 20 3a 20 73 77 69 74 |..( n = |1 : swit|
|00002c70| 63 68 20 74 6f 20 61 6e | 61 6c 79 73 69 73 20 6d |ch to an|alysis m|
|00002c80| 6f 64 65 3b 0d 20 20 6e | 20 3d 20 30 20 3a 20 73 |ode;. n| = 0 : s|
|00002c90| 77 69 74 63 68 20 74 6f | 20 6e 6f 72 6d 61 6c 20 |witch to| normal |
|00002ca0| 6d 6f 64 65 20 20 29 0d | 0d 46 6f 72 20 61 6e 20 |mode ).|.For an |
|00002cb0| 61 6e 61 6c 79 73 69 73 | 20 61 20 72 65 63 61 6c |analysis| a recal|
|00002cc0| 63 75 6c 61 74 69 6f 6e | 20 68 61 73 20 74 6f 20 |culation| has to |
|00002cd0| 74 61 6b 65 20 70 6c 61 | 63 65 2e 0d 50 72 65 76 |take pla|ce..Prev|
|00002ce0| 69 6f 75 73 6c 79 20 63 | 61 6c 63 75 6c 61 74 65 |iously c|alculate|
|00002cf0| 64 20 72 65 73 75 6c 74 | 73 20 77 69 6c 6c 20 62 |d result|s will b|
|00002d00| 65 20 6f 76 65 72 77 72 | 69 74 74 65 6e 0d 64 75 |e overwr|itten.du|
|00002d10| 72 69 6e 67 20 74 68 69 | 73 20 70 72 6f 63 65 64 |ring thi|s proced|
|00002d20| 75 72 65 2e 00 00 00 5b | 54 68 69 73 20 65 6e 61 |ure....[|This ena|
|00002d30| 62 6c 65 73 20 74 68 65 | 20 75 73 65 72 20 20 20 |bles the| user |
|00002d40| 20 20 20 20 20 20 0d 74 | 6f 20 63 68 6f 6f 73 65 | .t|o choose|
|00002d50| 20 61 64 64 69 74 69 6f | 6e 61 6c 20 20 20 20 20 | additio|nal |
|00002d60| 20 20 20 20 20 20 0d 66 | 75 6e 63 74 69 6f 6e 73 | .f|unctions|
|00002d70| 20 74 68 61 74 20 61 72 | 65 20 61 76 61 69 6c 61 | that ar|e availa|
|00002d80| 62 6c 65 00 00 00 a9 45 | 6e 61 62 6c 65 73 20 74 |ble....E|nables t|
|00002d90| 68 65 20 75 73 65 72 20 | 74 6f 20 64 65 66 69 6e |he user |to defin|
|00002da0| 65 20 61 6e 64 20 0d 72 | 65 63 61 6c 6c 20 61 6e |e and .r|ecall an|
|00002db0| 20 61 73 73 69 67 6e 6d | 65 6e 74 20 0d 0d 41 53 | assignm|ent ..AS|
|00002dc0| 53 49 47 4e 4d 45 4e 54 | 3a 4e 4f 31 3a 0d 44 61 |SIGNMENT|:NO1:.Da|
|00002dd0| 69 72 79 20 50 72 6f 64 | 75 63 74 73 20 3d 20 42 |iry Prod|ucts = B|
|00002de0| 75 74 74 65 72 20 0d 6f | 72 0d 0d 53 61 6c 65 73 |utter .o|r..Sales|
|00002df0| 3a a5 50 72 6f 64 75 63 | 74 20 47 72 6f 75 70 20 |:.Produc|t Group |
|00002e00| 3d 20 0d 53 55 4d 20 28 | a5 50 72 6f 64 75 63 74 |= .SUM (|.Product|
|00002e10| 73 3a 28 41 53 53 49 47 | 4e 4d 45 4e 54 3a 0d a5 |s:(ASSIG|NMENT:..|
|00002e20| 50 72 6f 64 75 63 74 20 | 47 72 6f 75 70 29 29 0d |Product |Group)).|
|00002e30| 00 00 00 4c 55 73 65 64 | 20 74 6f 20 64 65 66 69 |...LUsed| to defi|
|00002e40| 6e 65 20 0d 61 20 6d 61 | 63 72 6f 66 6f 72 6d 75 |ne .a ma|croformu|
|00002e50| 6c 61 0d 0d 4d 41 43 52 | 4f 46 55 4e 43 54 49 4f |la..MACR|OFUNCTIO|
|00002e60| 4e 3a 20 4e 4f 69 20 20 | 3d 0d 41 55 54 4f 41 53 |N: NOi |=.AUTOAS|
|00002e70| 53 49 47 4e 4d 45 4e 54 | 20 28 20 2e 2e 2e 20 29 |SIGNMENT| ( ... )|
|00002e80| 00 00 00 7f 46 6f 72 20 | 6e 75 6d 62 65 72 69 6e |....For |numberin|
|00002e90| 67 20 61 73 73 69 67 6e | 6d 65 6e 74 73 0d 6f 72 |g assign|ments.or|
|00002ea0| 20 6d 61 63 72 6f 66 6f | 72 6d 75 6c 61 73 0d 0d | macrofo|rmulas..|
|00002eb0| 41 53 53 49 47 4e 4d 45 | 4e 54 20 3a 20 4e 4f 31 |ASSIGNME|NT : NO1|
|00002ec0| 3a 20 53 74 6f 72 65 20 | 31 20 3d 0d 50 72 6f 64 |: Store |1 =.Prod|
|00002ed0| 75 63 74 20 31 0d 6f 72 | 0d 41 53 53 49 47 4e 4d |uct 1.or|.ASSIGNM|
|00002ee0| 45 4e 54 20 3a 20 4e 4f | 31 20 20 3d 0d 41 55 54 |ENT : NO|1 =.AUT|
|00002ef0| 4f 41 53 53 49 47 4e 4d | 45 4e 54 20 28 20 2e 2e |OASSIGNM|ENT ( ..|
|00002f00| 2e 20 29 00 00 00 80 46 | 6f 72 20 6e 75 6d 62 65 |. )....F|or numbe|
|00002f10| 72 69 6e 67 20 61 73 73 | 69 67 6e 6d 65 6e 74 73 |ring ass|ignments|
|00002f20| 0d 6f 72 20 6d 61 63 72 | 6f 66 6f 72 6d 75 6c 61 |.or macr|oformula|
|00002f30| 73 0d 0d 41 53 53 49 47 | 4e 4d 45 4e 54 20 3a 20 |s..ASSIG|NMENT : |
|00002f40| 4e 52 34 3a 20 53 74 6f | 72 65 20 31 20 3d 0d 50 |NR4: Sto|re 1 =.P|
|00002f50| 72 6f 64 75 63 74 20 31 | 0d 6f 72 0d 4d 41 43 52 |roduct 1|.or.MACR|
|00002f60| 4f 46 4f 52 4d 55 4c 41 | 20 3a 20 4e 52 37 20 3d |OFORMULA| : NR7 =|
|00002f70| 0d 41 55 54 4f 41 53 53 | 49 47 4e 4d 45 4e 54 28 |.AUTOASS|IGNMENT(|
|00002f80| 20 2e 2e 2e 20 29 20 00 | 00 00 6d 43 68 61 6e 67 | ... ) .|..mChang|
|00002f90| 65 73 20 61 6e 79 20 74 | 69 6d 65 20 72 65 66 65 |es any t|ime refe|
|00002fa0| 72 65 6e 63 65 20 0d 69 | 6e 74 6f 20 61 20 79 65 |rence .i|nto a ye|
|00002fb0| 61 72 6c 79 20 74 69 6d | 65 20 72 65 66 65 72 65 |arly tim|e refere|
|00002fc0| 6e 63 65 0d 0d 59 45 41 | 52 20 28 20 44 61 74 65 |nce..YEA|R ( Date|
|00002fd0| 20 29 0d 0d 28 66 6f 72 | 20 65 78 61 6d 70 6c 65 | )..(for| example|
|00002fe0| 2c 20 31 2f 31 33 2f 39 | 31 20 0d 62 65 63 6f 6d |, 1/13/9|1 .becom|
|00002ff0| 65 73 20 31 39 39 31 29 | 00 00 00 19 6c 6f 67 20 |es 1991)|....log |
|00003000| 62 61 73 65 20 31 30 0d | 0d 4c 47 20 28 20 56 61 |base 10.|.LG ( Va|
|00003010| 6c 75 65 20 29 00 00 00 | 1d 41 62 73 6f 6c 75 74 |lue )...|.Absolut|
|00003020| 65 20 76 61 6c 75 65 0d | 0d 41 42 53 20 28 20 56 |e value.|.ABS ( V|
|00003030| 61 6c 75 65 20 29 00 00 | 01 29 4d 61 63 72 6f 66 |alue )..|.)Macrof|
|00003040| 75 6e 63 74 69 6f 6e 20 | 66 6f 72 20 74 68 65 20 |unction |for the |
|00003050| 6c 69 73 74 69 6e 67 20 | 0d 6f 66 20 76 61 72 69 |listing |.of vari|
|00003060| 6f 75 73 20 61 73 73 69 | 67 6e 6d 65 6e 74 73 20 |ous assi|gnments |
|00003070| 0d 73 70 61 6e 6e 69 6e | 67 20 6d 75 6c 74 69 70 |.spannin|g multip|
|00003080| 6c 65 20 6c 65 76 65 6c | 73 20 0d 28 6d 75 73 74 |le level|s .(must|
|00003090| 20 62 65 20 64 65 66 69 | 6e 65 64 20 69 6e 20 61 | be defi|ned in a|
|000030a0| 20 66 6c 65 78 69 62 6c | 65 20 63 65 6c 6c 29 0d | flexibl|e cell).|
|000030b0| 0d 45 58 50 41 4e 44 20 | 28 46 5b 63 31 2e 2e 63 |.EXPAND |(F[c1..c|
|000030c0| 32 2c 72 31 2e 2e 72 32 | 5d 3b 20 61 3b 20 30 3b |2,r1..r2|]; a; 0;|
|000030d0| 20 62 29 0d 20 0d 61 20 | 3d 20 50 61 67 65 20 6e | b). .a |= Page n|
|000030e0| 75 6d 62 65 72 3b 0d 62 | 20 3d 20 30 20 52 65 70 |umber;.b| = 0 Rep|
|000030f0| 65 74 69 74 69 6f 6e 20 | 6f 66 20 61 74 74 72 69 |etition |of attri|
|00003100| 62 75 74 65 73 3b 0d 62 | 20 3d 20 31 20 4e 6f 20 |butes;.b| = 1 No |
|00003110| 72 65 70 65 74 69 74 69 | 6f 6e 20 6f 66 20 61 74 |repetiti|on of at|
|00003120| 74 72 69 62 75 74 65 73 | 3b 0d 46 5b 63 31 2e 2e |tributes|;.F[c1..|
|00003130| 63 32 2c 72 31 2e 2e 72 | 32 5d 20 64 65 66 69 6e |c2,r1..r|2] defin|
|00003140| 65 73 20 72 61 6e 67 65 | 20 0d 77 68 65 72 65 20 |es range| .where |
|00003150| 6f 75 74 70 75 74 20 69 | 73 20 64 69 73 70 6c 61 |output i|s displa|
|00003160| 79 65 64 00 00 00 19 4e | 61 74 75 72 61 6c 20 6c |yed....N|atural l|
|00003170| 6f 67 0d 0d 4c 4e 20 28 | 20 56 61 6c 75 65 20 29 |og..LN (| Value )|
|00003180| 00 00 00 1b 53 71 75 61 | 72 65 20 72 6f 6f 74 0d |....Squa|re root.|
|00003190| 0d 53 51 52 54 20 28 20 | 56 61 6c 75 65 20 29 00 |.SQRT ( |Value ).|
|000031a0| 00 00 1f 49 6e 74 65 67 | 65 72 20 66 75 6e 63 74 |...Integ|er funct|
|000031b0| 69 6f 6e 0d 0d 49 4e 54 | 20 28 20 56 61 6c 75 65 |ion..INT| ( Value|
|000031c0| 20 29 00 00 00 1e 53 71 | 75 61 72 65 20 66 75 6e | )....Sq|uare fun|
|000031d0| 63 74 69 6f 6e 0d 0d 53 | 51 52 20 28 20 56 61 6c |ction..S|QR ( Val|
|000031e0| 75 65 20 29 00 00 00 32 | 53 69 6e 65 20 66 75 6e |ue )...2|Sine fun|
|000031f0| 63 74 69 6f 6e 0d 0d 53 | 49 4e 20 28 20 41 6e 67 |ction..S|IN ( Ang|
|00003200| 6c 65 20 29 0d 0d 28 20 | 41 6e 67 6c 65 20 69 6e |le )..( |Angle in|
|00003210| 20 64 65 67 72 65 65 73 | 20 29 00 00 00 33 43 6f | degrees| )...3Co|
|00003220| 73 69 6e 65 20 66 75 6e | 63 74 69 6f 6e 0d 0d 43 |sine fun|ction..C|
|00003230| 4f 53 20 28 20 41 6e 67 | 6c 65 20 29 0d 0d 28 41 |OS ( Ang|le )..(A|
|00003240| 6e 67 6c 65 20 69 6e 20 | 64 65 67 72 65 65 73 20 |ngle in |degrees |
|00003250| 29 00 00 00 34 54 61 6e | 67 65 6e 74 20 66 75 6e |)...4Tan|gent fun|
|00003260| 63 74 69 6f 6e 0d 0d 54 | 41 4e 20 28 20 41 6e 67 |ction..T|AN ( Ang|
|00003270| 6c 65 20 29 0d 0d 28 41 | 6e 67 6c 65 20 69 6e 20 |le )..(A|ngle in |
|00003280| 64 65 67 72 65 65 73 20 | 29 00 00 00 39 41 72 63 |degrees |)...9Arc|
|00003290| 73 69 6e 65 20 66 75 6e | 63 74 69 6f 6e 0d 0d 41 |sine fun|ction..A|
|000032a0| 52 43 53 49 4e 20 28 20 | 56 61 6c 75 65 20 29 0d |RCSIN ( |Value ).|
|000032b0| 0d 28 20 52 65 73 75 6c | 74 20 69 6e 20 64 65 67 |.( Resul|t in deg|
|000032c0| 72 65 65 73 20 29 00 00 | 00 3b 41 72 63 63 6f 73 |rees )..|.;Arccos|
|000032d0| 69 6e 65 20 66 75 6e 63 | 74 69 6f 6e 0d 0d 41 52 |ine func|tion..AR|
|000032e0| 43 43 4f 53 20 28 20 56 | 61 6c 75 65 20 29 0d 0d |CCOS ( V|alue )..|
|000032f0| 28 20 52 65 73 75 6c 74 | 20 69 6e 20 64 65 67 72 |( Result| in degr|
|00003300| 65 65 73 20 29 00 00 00 | 3c 41 72 63 74 61 6e 67 |ees )...|<Arctang|
|00003310| 65 6e 74 20 66 75 6e 63 | 74 69 6f 6e 0d 0d 41 52 |ent func|tion..AR|
|00003320| 43 54 41 4e 20 28 20 56 | 61 6c 75 65 20 29 0d 0d |CTAN ( V|alue )..|
|00003330| 28 20 52 65 73 75 6c 74 | 20 69 6e 20 64 65 67 72 |( Result| in degr|
|00003340| 65 65 73 20 29 00 00 00 | bb 4d 65 61 6e 20 76 61 |ees )...|.Mean va|
|00003350| 6c 75 65 20 66 75 6e 63 | 74 69 6f 6e 0d 0d 4d 45 |lue func|tion..ME|
|00003360| 41 4e 20 28 20 46 5b 31 | 2e 2e 31 30 2c 34 5d 20 |AN ( F[1|..10,4] |
|00003370| 29 0d 0d 6f 72 0d 53 61 | 6c 65 73 3a 31 2f 39 30 |)..or.Sa|les:1/90|
|00003380| 20 3d 20 4d 45 41 4e 20 | 28 20 a5 50 72 6f 64 75 | = MEAN |( .Produ|
|00003390| 63 74 73 0d 3a 28 61 6c | 6c 29 3a 53 61 6c 65 73 |cts.:(al|l):Sales|
|000033a0| 3a 31 2f 39 30 20 29 0d | 0d 6f 72 0d 53 61 6c 65 |:1/90 ).|.or.Sale|
|000033b0| 73 3a a5 50 72 6f 64 75 | 63 74 20 67 72 6f 75 70 |s:.Produ|ct group|
|000033c0| 73 3a 31 2f 39 30 20 3d | 0d 4d 45 41 4e 20 28 20 |s:1/90 =|.MEAN ( |
|000033d0| a5 50 72 6f 64 75 63 74 | 73 3a 28 41 73 73 69 67 |.Product|s:(Assig|
|000033e0| 6e 6d 65 6e 74 0d 3a a5 | 50 72 6f 64 75 63 74 20 |nment.:.|Product |
|000033f0| 67 72 6f 75 70 73 29 3a | 53 61 6c 65 73 3a 31 2f |groups):|Sales:1/|
|00003400| 39 30 20 29 00 00 00 65 | 4c 6f 67 69 63 61 6c 20 |90 )...e|Logical |
|00003410| 22 41 4e 44 22 20 63 61 | 6c 63 75 6c 61 74 69 6f |"AND" ca|lculatio|
|00003420| 6e 73 0d 0d 49 46 20 20 | 20 28 20 28 20 53 61 6c |ns..IF | ( ( Sal|
|00003430| 65 73 20 3e 20 31 30 30 | 30 20 29 20 0d 41 4e 44 |es > 100|0 ) .AND|
|00003440| 20 28 20 50 72 6f 66 69 | 74 20 3d 20 35 30 30 20 | ( Profi|t = 500 |
|00003450| 29 20 29 0d 54 48 45 4e | 20 28 20 2e 2e 2e 20 29 |) ).THEN| ( ... )|
|00003460| 20 45 4c 53 45 20 28 20 | 2e 2e 2e 20 29 00 00 00 | ELSE ( |... )...|
|00003470| 7d 43 68 61 6e 67 65 73 | 20 61 6e 79 20 74 69 6d |}Changes| any tim|
|00003480| 65 20 72 65 66 65 72 65 | 6e 63 65 20 0d 69 6e 74 |e refere|nce .int|
|00003490| 6f 20 61 20 77 65 65 6b | 6c 79 20 28 37 20 64 61 |o a week|ly (7 da|
|000034a0| 79 29 0d 20 74 69 6d 65 | 20 72 65 66 65 72 65 6e |y). time| referen|
|000034b0| 63 65 0d 0d 4e 44 41 59 | 20 28 20 44 61 74 65 20 |ce..NDAY| ( Date |
|000034c0| 29 0d 0d 28 66 6f 72 20 | 65 78 61 6d 70 6c 65 2c |)..(for |example,|
|000034d0| 20 31 39 39 31 20 6f 72 | 0d 31 2f 39 31 20 62 65 | 1991 or|.1/91 be|
|000034e0| 63 6f 6d 65 73 20 31 2f | 31 2f 39 31 20 29 00 00 |comes 1/|1/91 )..|
|000034f0| 00 60 4c 6f 67 69 63 61 | 6c 20 22 4f 52 22 20 63 |.`Logica|l "OR" c|
|00003500| 61 6c 63 75 6c 61 74 69 | 6f 6e 73 0d 0d 49 46 20 |alculati|ons..IF |
|00003510| 28 20 28 20 53 61 6c 65 | 73 20 3e 20 31 30 30 30 |( ( Sale|s > 1000|
|00003520| 20 29 0d 4f 52 20 28 20 | 50 72 6f 66 69 74 20 3d | ).OR ( |Profit =|
|00003530| 20 35 30 30 20 29 20 29 | 0d 54 48 45 4e 20 28 20 | 500 ) )|.THEN ( |
|00003540| 2e 2e 2e 20 29 20 45 4c | 53 45 20 28 20 2e 2e 2e |... ) EL|SE ( ...|
|00003550| 20 29 00 00 00 76 43 68 | 61 6e 67 65 73 20 61 6e | )...vCh|anges an|
|00003560| 79 20 74 69 6d 65 20 72 | 65 66 65 72 65 6e 63 65 |y time r|eference|
|00003570| 20 0d 69 6e 74 6f 20 61 | 20 77 65 65 6b 6c 79 20 | .into a| weekly |
|00003580| 28 35 20 64 61 79 29 0d | 20 74 69 6d 65 20 72 65 |(5 day).| time re|
|00003590| 66 65 72 65 6e 63 65 0d | 0d 46 44 41 59 20 28 20 |ference.|.FDAY ( |
|000035a0| 44 61 74 65 20 29 0d 0d | 28 66 6f 72 20 65 78 61 |Date )..|(for exa|
|000035b0| 6d 70 6c 65 2c 20 36 2f | 39 31 20 0d 62 65 63 6f |mple, 6/|91 .beco|
|000035c0| 6d 65 73 20 36 2f 33 2f | 39 31 20 29 00 00 00 76 |mes 6/3/|91 )...v|
|000035d0| 43 68 61 6e 67 65 73 20 | 61 6e 79 20 74 69 6d 65 |Changes |any time|
|000035e0| 20 72 65 66 65 72 65 6e | 63 65 20 0d 69 6e 74 6f | referen|ce .into|
|000035f0| 20 61 20 77 65 65 6b 6c | 79 20 28 36 20 64 61 79 | a weekl|y (6 day|
|00003600| 29 0d 20 74 69 6d 65 20 | 72 65 66 65 72 65 6e 63 |). time |referenc|
|00003610| 65 0d 0d 53 44 41 59 20 | 28 20 44 61 74 65 20 29 |e..SDAY |( Date )|
|00003620| 0d 0d 28 66 6f 72 20 65 | 78 61 6d 70 6c 65 2c 20 |..(for e|xample, |
|00003630| 39 2f 39 31 20 0d 62 65 | 63 6f 6d 65 73 20 39 2f |9/91 .be|comes 9/|
|00003640| 32 2f 39 31 20 29 00 00 | 00 7a 43 68 61 6e 67 65 |2/91 )..|.zChange|
|00003650| 73 20 61 6e 79 20 74 69 | 6d 65 20 72 65 66 65 72 |s any ti|me refer|
|00003660| 65 6e 63 65 20 0d 69 6e | 74 6f 20 61 20 71 75 61 |ence .in|to a qua|
|00003670| 72 74 65 72 6c 79 20 74 | 69 6d 65 0d 72 65 66 65 |rterly t|ime.refe|
|00003680| 72 65 6e 63 65 0d 0d 51 | 55 41 52 54 45 52 20 28 |rence..Q|UARTER (|
|00003690| 20 44 61 74 65 20 29 0d | 0d 28 66 6f 72 20 65 78 | Date ).|.(for ex|
|000036a0| 61 6d 70 6c 65 2c 20 31 | 39 39 31 20 6f 72 20 32 |ample, 1|991 or 2|
|000036b0| 2f 31 2f 39 31 0d 62 65 | 63 6f 6d 65 73 20 51 31 |/1/91.be|comes Q1|
|000036c0| 2d 39 31 29 00 00 00 7b | 43 68 61 6e 67 65 73 20 |-91)...{|Changes |
|000036d0| 61 6e 79 20 74 69 6d 65 | 20 72 65 66 65 72 65 6e |any time| referen|
|000036e0| 63 65 20 0d 69 6e 74 6f | 20 61 20 68 61 6c 66 2d |ce .into| a half-|
|000036f0| 79 65 61 72 20 74 69 6d | 65 0d 72 65 66 65 72 65 |year tim|e.refere|
|00003700| 6e 63 65 0d 0d 48 41 4c | 46 59 45 41 52 20 28 20 |nce..HAL|FYEAR ( |
|00003710| 44 61 74 65 20 29 0d 0d | 28 66 6f 72 20 65 78 61 |Date )..|(for exa|
|00003720| 6d 70 6c 65 2c 20 31 39 | 39 31 20 6f 72 20 35 2f |mple, 19|91 or 5/|
|00003730| 31 2f 39 31 0d 62 65 63 | 6f 6d 65 73 20 48 31 2d |1/91.bec|omes H1-|
|00003740| 39 31 29 00 00 00 85 43 | 68 61 6e 67 65 73 20 61 |91)....C|hanges a|
|00003750| 6e 79 20 74 69 6d 65 20 | 72 65 66 65 72 65 6e 63 |ny time |referenc|
|00003760| 65 20 0d 69 6e 74 6f 20 | 69 74 73 20 63 6f 72 72 |e .into |its corr|
|00003770| 65 73 70 6f 6e 64 69 6e | 67 0d 20 77 65 65 6b 6c |espondin|g. weekl|
|00003780| 79 20 74 69 6d 65 20 72 | 65 66 65 72 65 6e 63 65 |y time r|eference|
|00003790| 0d 0d 57 45 45 4b 20 28 | 20 44 61 74 65 20 29 0d |..WEEK (| Date ).|
|000037a0| 0d 28 66 6f 72 20 65 78 | 61 6d 70 6c 65 2c 20 31 |.(for ex|ample, 1|
|000037b0| 39 39 31 20 6f 72 20 31 | 2f 35 2f 39 31 0d 62 65 |991 or 1|/5/91.be|
|000037c0| 63 6f 6d 65 73 20 57 31 | 2d 39 31 29 00 00 00 bc |comes W1|-91)....|
|000037d0| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 64 65 |This fun|ction de|
|000037e0| 74 65 72 6d 69 6e 65 73 | 20 74 68 65 20 6e 75 6d |termines| the num|
|000037f0| 62 65 72 0d 6f 66 20 66 | 69 65 6c 64 73 20 77 68 |ber.of f|ields wh|
|00003800| 69 63 68 20 61 72 65 20 | 69 6e 20 61 20 67 69 76 |ich are |in a giv|
|00003810| 65 6e 20 72 61 6e 67 65 | 2c 0d 6f 72 20 74 68 65 |en range|,.or the|
|00003820| 20 6e 75 6d 62 65 72 20 | 6f 66 20 61 74 74 72 69 | number |of attri|
|00003830| 62 75 74 65 73 20 69 6e | 20 61 0d 67 69 76 65 6e |butes in| a.given|
|00003840| 20 64 61 74 61 62 61 73 | 65 20 73 65 6c 65 63 74 | databas|e select|
|00003850| 69 6f 6e 0d 0d 43 4f 55 | 4e 54 41 4c 4c 28 20 46 |ion..COU|NTALL( F|
|00003860| 5b 63 2c 72 31 2e 2e 72 | 32 5d 20 29 0d 0d 6f 72 |[c,r1..r|2] )..or|
|00003870| 0d 43 4f 55 4e 54 41 4c | 4c 28 20 a5 50 72 6f 64 |.COUNTAL|L( .Prod|
|00003880| 75 63 74 73 3a 28 61 6c | 6c 29 20 29 00 00 00 3b |ucts:(al|l) )...;|
|00003890| 43 6f 72 72 65 73 70 6f | 6e 64 69 6e 67 20 77 65 |Correspo|nding we|
|000038a0| 65 6b 64 61 79 0d 66 6f | 72 20 61 20 67 69 76 65 |ekday.fo|r a give|
|000038b0| 6e 20 64 61 74 65 0d 0d | 0d 44 41 59 4f 46 57 45 |n date..|.DAYOFWE|
|000038c0| 45 4b 20 28 20 44 61 74 | 65 20 29 00 00 00 81 4e |EK ( Dat|e )....N|
|000038d0| 75 6d 62 65 72 20 6f 66 | 20 22 49 6e 74 65 72 65 |umber of| "Intere|
|000038e0| 73 74 20 44 61 79 73 22 | 20 ca ca ca ca ca 0d 62 |st Days"| ......b|
|000038f0| 65 74 77 65 65 6e 20 74 | 77 6f 20 64 61 74 65 73 |etween t|wo dates|
|00003900| 0d 0d 4e 75 6d 62 65 72 | 20 6f 66 20 69 6e 74 65 |..Number| of inte|
|00003910| 72 65 73 74 20 64 61 79 | 73 20 3d 20 0d 58 49 4e |rest day|s = .XIN|
|00003920| 54 45 52 45 53 54 44 41 | 59 53 20 28 20 44 61 74 |TERESTDA|YS ( Dat|
|00003930| 65 20 31 20 29 20 2d 0d | 58 49 4e 54 45 52 45 53 |e 1 ) -.|XINTERES|
|00003940| 54 44 41 59 53 20 28 20 | 44 61 74 65 20 32 20 29 |TDAYS ( |Date 2 )|
|00003950| 00 00 00 d8 4d 69 6e 69 | 6d 75 6d 20 76 61 6c 75 |....Mini|mum valu|
|00003960| 65 20 66 72 6f 6d 20 61 | 20 0d 73 65 6c 65 63 74 |e from a| .select|
|00003970| 69 6f 6e 20 6f 66 20 76 | 61 6c 75 65 73 0d 0d 4d |ion of v|alues..M|
|00003980| 49 4e 49 4d 55 4d 20 28 | 20 46 5b 31 2e 2e 31 30 |INIMUM (| F[1..10|
|00003990| 2c 34 5d 20 29 0d 0d 6f | 72 0d 53 61 6c 65 73 3a |,4] )..o|r.Sales:|
|000039a0| 31 2f 39 30 20 3d 20 4d | 49 4e 49 4d 55 4d 20 0d |1/90 = M|INIMUM .|
|000039b0| 28 a5 50 72 6f 64 75 63 | 74 73 3a 28 61 6c 6c 29 |(.Produc|ts:(all)|
|000039c0| 3a 53 61 6c 65 73 3a 31 | 2f 39 30 20 29 0d 0d 6f |:Sales:1|/90 )..o|
|000039d0| 72 0d 53 61 6c 65 73 3a | a5 50 72 6f 64 75 63 74 |r.Sales:|.Product|
|000039e0| 20 67 72 6f 75 70 73 3a | 31 2f 39 30 20 3d 0d 4d | groups:|1/90 =.M|
|000039f0| 49 4e 49 4d 55 4d 20 28 | a5 50 72 6f 64 75 63 74 |INIMUM (|.Product|
|00003a00| 73 3a 28 41 73 73 69 67 | 6e 6d 65 6e 74 0d 3a a5 |s:(Assig|nment.:.|
|00003a10| 50 72 6f 64 75 63 74 20 | 67 72 6f 75 70 73 29 3a |Product |groups):|
|00003a20| 53 61 6c 65 73 3a 31 2f | 39 30 20 29 00 00 00 d8 |Sales:1/|90 )....|
|00003a30| 4d 61 78 69 6d 75 6d 20 | 76 61 6c 75 65 20 66 72 |Maximum |value fr|
|00003a40| 6f 6d 20 61 20 0d 73 65 | 6c 65 63 74 69 6f 6e 20 |om a .se|lection |
|00003a50| 6f 66 20 76 61 6c 75 65 | 73 0d 0d 4d 41 58 49 4d |of value|s..MAXIM|
|00003a60| 55 4d 20 28 20 46 5b 31 | 2e 2e 31 30 2c 34 5d 20 |UM ( F[1|..10,4] |
|00003a70| 29 0d 0d 6f 72 0d 53 61 | 6c 65 73 3a 31 2f 39 30 |)..or.Sa|les:1/90|
|00003a80| 20 3d 20 4d 41 58 49 4d | 55 4d 20 0d 28 a5 50 72 | = MAXIM|UM .(.Pr|
|00003a90| 6f 64 75 63 74 73 3a 28 | 61 6c 6c 29 3a 53 61 6c |oducts:(|all):Sal|
|00003aa0| 65 73 3a 31 2f 39 30 20 | 29 0d 0d 6f 72 0d 53 61 |es:1/90 |)..or.Sa|
|00003ab0| 6c 65 73 3a a5 50 72 6f | 64 75 63 74 20 67 72 6f |les:.Pro|duct gro|
|00003ac0| 75 70 73 3a 31 2f 39 30 | 20 3d 0d 4d 41 58 49 4d |ups:1/90| =.MAXIM|
|00003ad0| 55 4d 20 28 a5 50 72 6f | 64 75 63 74 73 3a 28 41 |UM (.Pro|ducts:(A|
|00003ae0| 73 73 69 67 6e 6d 65 6e | 74 0d 3a a5 50 72 6f 64 |ssignmen|t.:.Prod|
|00003af0| 75 63 74 20 67 72 6f 75 | 70 73 29 3a 53 61 6c 65 |uct grou|ps):Sale|
|00003b00| 73 3a 31 2f 39 30 20 29 | 00 00 00 d1 46 75 6e 63 |s:1/90 )|....Func|
|00003b10| 74 69 6f 6e 20 66 6f 72 | 20 73 75 6d 6d 69 6e 67 |tion for| summing|
|00003b20| 20 75 70 0d 61 6c 6c 20 | 70 6f 73 69 74 69 76 65 | up.all |positive|
|00003b30| 20 76 61 6c 75 65 73 0d | 0d 50 53 55 4d 20 28 20 | values.|.PSUM ( |
|00003b40| 46 5b 31 2e 2e 31 30 2c | 34 5d 20 29 0d 0d 6f 72 |F[1..10,|4] )..or|
|00003b50| 0d 53 61 6c 65 73 3a 31 | 2f 39 30 20 3d 20 50 53 |.Sales:1|/90 = PS|
|00003b60| 55 4d 28 20 a5 50 72 6f | 64 75 63 74 73 0d 3a 28 |UM( .Pro|ducts.:(|
|00003b70| 61 6c 6c 29 3a 53 61 6c | 65 73 3a 31 2f 39 30 20 |all):Sal|es:1/90 |
|00003b80| 29 0d 0d 6f 72 0d 53 61 | 6c 65 73 3a a5 50 72 6f |)..or.Sa|les:.Pro|
|00003b90| 64 75 63 74 20 67 72 6f | 75 70 73 3a 31 2f 39 30 |duct gro|ups:1/90|
|00003ba0| 20 3d 0d 50 53 55 4d 28 | 20 a5 50 72 6f 64 75 63 | =.PSUM(| .Produc|
|00003bb0| 74 73 3a 28 41 73 73 69 | 67 6e 6d 65 6e 74 0d 3a |ts:(Assi|gnment.:|
|00003bc0| a5 50 72 6f 64 75 63 74 | 20 67 72 6f 75 70 73 29 |.Product| groups)|
|00003bd0| 3a 53 61 6c 65 73 3a 31 | 2f 39 30 20 29 00 00 00 |:Sales:1|/90 )...|
|00003be0| d1 46 75 6e 63 74 69 6f | 6e 20 66 6f 72 20 73 75 |.Functio|n for su|
|00003bf0| 6d 6d 69 6e 67 20 75 70 | 0d 61 6c 6c 20 6e 65 67 |mming up|.all neg|
|00003c00| 61 74 69 76 65 20 76 61 | 6c 75 65 73 0d 0d 4e 53 |ative va|lues..NS|
|00003c10| 55 4d 20 28 20 46 5b 31 | 2e 2e 31 30 2c 34 5d 20 |UM ( F[1|..10,4] |
|00003c20| 29 0d 0d 6f 72 0d 53 61 | 6c 65 73 3a 31 2f 39 30 |)..or.Sa|les:1/90|
|00003c30| 20 3d 20 4e 53 55 4d 28 | 20 a5 50 72 6f 64 75 63 | = NSUM(| .Produc|
|00003c40| 74 73 0d 3a 28 61 6c 6c | 29 3a 53 61 6c 65 73 3a |ts.:(all|):Sales:|
|00003c50| 31 2f 39 30 20 29 0d 0d | 6f 72 0d 53 61 6c 65 73 |1/90 )..|or.Sales|
|00003c60| 3a a5 50 72 6f 64 75 63 | 74 20 67 72 6f 75 70 73 |:.Produc|t groups|
|00003c70| 3a 31 2f 39 30 20 3d 0d | 4e 53 55 4d 28 20 a5 50 |:1/90 =.|NSUM( .P|
|00003c80| 72 6f 64 75 63 74 73 3a | 28 41 73 73 69 67 6e 6d |roducts:|(Assignm|
|00003c90| 65 6e 74 0d 3a a5 50 72 | 6f 64 75 63 74 20 67 72 |ent.:.Pr|oduct gr|
|00003ca0| 6f 75 70 73 29 3a 53 61 | 6c 65 73 3a 31 2f 39 30 |oups):Sa|les:1/90|
|00003cb0| 20 29 00 00 00 6d 43 68 | 65 63 6b 73 20 74 6f 20 | )...mCh|ecks to |
|00003cc0| 73 65 65 20 69 66 20 6f | 6e 65 20 74 65 78 74 20 |see if o|ne text |
|00003cd0| 0d 69 73 20 63 6f 6e 74 | 61 69 6e 65 64 20 69 6e |.is cont|ained in|
|00003ce0| 20 61 6e 6f 74 68 65 72 | 20 74 65 78 74 0d 0d 49 | another| text..I|
|00003cf0| 46 20 28 20 54 65 78 74 | 20 31 20 49 4e 53 54 52 |F ( Text| 1 INSTR|
|00003d00| 20 54 65 78 74 20 32 20 | 29 0d 54 48 45 4e 20 28 | Text 2 |).THEN (|
|00003d10| 20 2e 2e 2e 20 29 20 45 | 4c 53 45 20 28 20 2e 2e | ... ) E|LSE ( ..|
|00003d20| 2e 20 29 00 00 00 79 43 | 68 61 6e 67 65 73 20 61 |. )...yC|hanges a|
|00003d30| 6e 79 20 74 69 6d 65 20 | 72 65 66 65 72 65 6e 63 |ny time |referenc|
|00003d40| 65 20 0d 69 6e 74 6f 20 | 61 20 74 65 72 74 69 61 |e .into |a tertia|
|00003d50| 72 79 20 74 69 6d 65 20 | 72 65 66 65 72 65 6e 63 |ry time |referenc|
|00003d60| 65 0d 0d 54 45 52 54 49 | 41 4c 20 28 20 44 61 74 |e..TERTI|AL ( Dat|
|00003d70| 65 20 29 0d 0d 28 66 6f | 72 20 65 78 61 6d 70 6c |e )..(fo|r exampl|
|00003d80| 65 2c 20 31 39 39 31 20 | 6f 72 0d 34 2f 31 2f 39 |e, 1991 |or.4/1/9|
|00003d90| 31 20 62 65 63 6f 6d 65 | 73 20 54 31 2d 39 31 29 |1 become|s T1-91)|
|00003da0| 00 00 00 65 41 75 74 6f | 6d 61 74 69 63 61 6c 6c |...eAuto|maticall|
|00003db0| 79 20 69 6e 73 65 72 74 | 73 20 61 20 70 61 67 65 |y insert|s a page|
|00003dc0| 20 0d 6e 75 6d 62 65 72 | 20 77 68 65 6e 20 70 72 | .number| when pr|
|00003dd0| 69 6e 74 69 6e 67 20 0d | 0d 50 41 47 45 4e 55 4d |inting .|.PAGENUM|
|00003de0| 42 45 52 20 28 20 30 20 | 29 0d 20 28 4e 75 6d 62 |BER ( 0 |). (Numb|
|00003df0| 65 72 69 6e 67 20 62 65 | 67 69 6e 73 20 77 69 74 |ering be|gins wit|
|00003e00| 68 20 70 61 67 65 20 31 | 29 00 00 01 17 54 68 69 |h page 1|)....Thi|
|00003e10| 73 20 66 75 6e 63 74 69 | 6f 6e 20 64 65 74 65 72 |s functi|on deter|
|00003e20| 6d 69 6e 65 73 20 74 68 | 65 20 6e 75 6d 62 65 72 |mines th|e number|
|00003e30| 0d 6f 66 20 66 69 65 6c | 64 73 20 69 6e 20 61 20 |.of fiel|ds in a |
|00003e40| 67 69 76 65 6e 20 72 61 | 6e 67 65 2c 0d 6f 72 20 |given ra|nge,.or |
|00003e50| 74 68 65 20 6e 75 6d 62 | 65 72 20 6f 66 20 61 74 |the numb|er of at|
|00003e60| 74 72 69 62 75 74 65 73 | 20 69 6e 20 61 0d 67 69 |tributes| in a.gi|
|00003e70| 76 65 6e 20 64 61 74 61 | 62 61 73 65 20 73 65 6c |ven data|base sel|
|00003e80| 65 63 74 69 6f 6e 2c 20 | 74 61 6b 69 6e 67 20 69 |ection, |taking i|
|00003e90| 6e 74 6f 20 0d 63 6f 6e | 73 69 64 65 72 61 74 69 |nto .con|siderati|
|00003ea0| 6f 6e 20 6f 6e 6c 79 20 | 74 68 6f 73 65 20 63 65 |on only |those ce|
|00003eb0| 6c 6c 73 20 74 68 61 74 | 20 0d 61 72 65 20 6e 6f |lls that| .are no|
|00003ec0| 74 20 65 6d 70 74 79 0d | 0d 43 4f 55 4e 54 56 41 |t empty.|.COUNTVA|
|00003ed0| 4c 55 45 28 20 46 5b 63 | 2c 72 31 2e 2e 72 32 5d |LUE( F[c|,r1..r2]|
|00003ee0| 20 29 0d 0d 6f 72 0d 43 | 4f 55 4e 54 56 41 4c 55 | )..or.C|OUNTVALU|
|00003ef0| 45 28 a5 50 72 6f 64 75 | 63 74 73 3a 28 61 6c 6c |E(.Produ|cts:(all|
|00003f00| 29 3a 0d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |):. | |
|00003f10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 61 6c | | Sal|
|00003f20| 65 73 29 29 00 00 00 74 | 41 64 64 73 20 74 77 6f |es))...t|Adds two|
|00003f30| 20 63 65 6c 6c 73 20 74 | 6f 67 65 74 68 65 72 2c | cells t|ogether,|
|00003f40| 20 61 73 20 6c 6f 6e 67 | 20 61 73 0d 62 6f 74 68 | as long| as.both|
|00003f50| 20 63 65 6c 6c 73 20 61 | 72 65 20 6e 6f 74 20 45 | cells a|re not E|
|00003f60| 4d 50 54 59 3b 20 6f 74 | 68 65 72 77 69 73 65 2c |MPTY; ot|herwise,|
|00003f70| 0d 74 68 65 20 72 65 73 | 75 6c 74 20 69 73 20 45 |.the res|ult is E|
|00003f80| 4d 50 54 59 20 0d 0d 56 | 61 6c 75 65 20 31 20 50 |MPTY ..V|alue 1 P|
|00003f90| 4c 55 53 20 56 61 6c 75 | 65 20 32 20 00 00 00 7e |LUS Valu|e 2 ...~|
|00003fa0| 53 75 62 74 72 61 63 74 | 73 20 6f 6e 65 20 63 65 |Subtract|s one ce|
|00003fb0| 6c 6c 20 66 72 6f 6d 20 | 61 6e 6f 74 68 65 72 2c |ll from |another,|
|00003fc0| 20 0d 61 73 20 6c 6f 6e | 67 20 61 73 20 62 6f 74 | .as lon|g as bot|
|00003fd0| 68 20 63 65 6c 6c 73 20 | 61 72 65 20 6e 6f 74 20 |h cells |are not |
|00003fe0| 45 4d 50 54 59 3b 20 0d | 6f 74 68 65 72 77 69 73 |EMPTY; .|otherwis|
|00003ff0| 65 2c 20 74 68 65 20 72 | 65 73 75 6c 74 20 69 73 |e, the r|esult is|
|00004000| 20 45 4d 50 54 59 0d 0d | 56 61 6c 75 65 20 31 20 | EMPTY..|Value 1 |
|00004010| 4d 49 4e 55 53 20 56 61 | 6c 75 65 20 32 20 00 00 |MINUS Va|lue 2 ..|
|00004020| 00 76 54 68 65 20 6d 6f | 73 74 20 73 70 65 63 69 |.vThe mo|st speci|
|00004030| 66 69 63 20 65 6c 65 6d | 65 6e 74 20 6f 66 20 0d |fic elem|ent of .|
|00004040| 61 20 74 69 6d 65 20 72 | 65 66 65 72 65 6e 63 65 |a time r|eference|
|00004050| 20 62 65 63 6f 6d 65 73 | 20 0d 61 20 6e 75 6d 65 | becomes| .a nume|
|00004060| 72 69 63 61 6c 20 76 61 | 6c 75 65 0d 0d 50 45 52 |rical va|lue..PER|
|00004070| 49 4f 44 20 28 33 2f 39 | 30 29 20 62 65 63 6f 6d |IOD (3/9|0) becom|
|00004080| 65 73 20 33 3b 0d 28 31 | 2f 33 2f 39 31 29 20 62 |es 3;.(1|/3/91) b|
|00004090| 65 63 6f 6d 65 73 20 31 | 00 00 00 42 52 6f 75 6e |ecomes 1|...BRoun|
|000040a0| 64 69 6e 67 20 6f 66 66 | 20 6f 66 0d 61 20 6e 75 |ding off| of.a nu|
|000040b0| 6d 65 72 69 63 61 6c 20 | 76 61 6c 75 65 0d 0d 52 |merical |value..R|
|000040c0| 4f 55 4e 44 20 28 20 56 | 61 6c 75 65 3b 20 44 65 |OUND ( V|alue; De|
|000040d0| 63 69 6d 61 6c 20 70 6c | 61 63 65 73 20 29 00 00 |cimal pl|aces )..|
|000040e0| 00 65 59 69 65 6c 64 73 | 20 74 68 65 20 67 69 76 |.eYields| the giv|
|000040f0| 65 6e 20 6e 75 6d 62 65 | 72 20 6f 66 20 63 68 61 |en numbe|r of cha|
|00004100| 72 61 63 74 65 72 73 20 | 0d 66 72 6f 6d 20 74 68 |racters |.from th|
|00004110| 65 20 6c 65 66 74 20 6f | 66 20 74 68 65 20 74 65 |e left o|f the te|
|00004120| 78 74 20 0d 0d 4c 45 46 | 54 20 28 20 54 65 78 74 |xt ..LEF|T ( Text|
|00004130| 3b 20 4e 75 6d 62 65 72 | 20 6f 66 20 63 68 61 72 |; Number| of char|
|00004140| 61 63 74 65 72 73 29 00 | 00 00 46 4e 61 6d 65 20 |acters).|..FName |
|00004150| 6f 66 20 74 68 65 20 67 | 72 6f 75 70 20 74 6f 0d |of the g|roup to.|
|00004160| 77 68 69 63 68 20 61 6e | 20 61 74 74 72 69 62 75 |which an| attribu|
|00004170| 74 65 20 62 65 6c 6f 6e | 67 73 0d 0d 47 52 4f 55 |te belon|gs..GROU|
|00004180| 50 4e 41 4d 45 20 28 41 | 74 74 72 69 62 75 74 65 |PNAME (A|ttribute|
|00004190| 29 00 00 00 5c 41 20 70 | 6f 73 69 74 69 76 65 20 |)...\A p|ositive |
|000041a0| 76 61 6c 75 65 20 77 69 | 6c 6c 20 62 65 20 61 63 |value wi|ll be ac|
|000041b0| 63 65 70 74 65 64 3b 0d | 41 20 6e 65 67 61 74 69 |cepted;.|A negati|
|000041c0| 76 65 20 76 61 6c 75 65 | 20 79 69 65 6c 64 73 20 |ve value| yields |
|000041d0| 61 6e 20 45 4d 50 54 59 | 20 63 65 6c 6c 0d 0d 50 |an EMPTY| cell..P|
|000041e0| 4f 53 49 54 49 56 45 20 | 28 20 56 61 6c 75 65 20 |OSITIVE |( Value |
|000041f0| 29 00 00 00 5c 41 20 6e | 65 67 61 74 69 76 65 20 |)...\A n|egative |
|00004200| 76 61 6c 75 65 20 77 69 | 6c 6c 20 62 65 20 61 63 |value wi|ll be ac|
|00004210| 63 65 70 74 65 64 3b 0d | 41 20 70 6f 73 69 74 69 |cepted;.|A positi|
|00004220| 76 65 20 76 61 6c 75 65 | 20 79 69 65 6c 64 73 20 |ve value| yields |
|00004230| 61 6e 20 45 4d 50 54 59 | 20 63 65 6c 6c 0d 0d 4e |an EMPTY| cell..N|
|00004240| 45 47 41 54 49 56 45 20 | 28 20 56 61 6c 75 65 20 |EGATIVE |( Value |
|00004250| 29 00 00 00 86 43 68 61 | 6e 67 65 73 20 61 6e 79 |)....Cha|nges any|
|00004260| 20 74 69 6d 65 20 72 65 | 66 65 72 65 6e 63 65 20 | time re|ference |
|00004270| 0d 69 6e 74 6f 20 61 20 | 6e 69 6e 65 2d 6d 6f 6e |.into a |nine-mon|
|00004280| 74 68 20 74 69 6d 65 20 | 72 65 66 65 72 65 6e 63 |th time |referenc|
|00004290| 65 0d 0d 54 48 52 45 45 | 51 55 41 52 54 45 52 59 |e..THREE|QUARTERY|
|000042a0| 45 41 52 20 28 20 44 61 | 74 65 20 29 0d 0d 28 66 |EAR ( Da|te )..(f|
|000042b0| 6f 72 20 65 78 61 6d 70 | 6c 65 2c 20 31 39 39 31 |or examp|le, 1991|
|000042c0| 20 6f 72 20 35 2f 31 2f | 39 31 0d 62 65 63 6f 6d | or 5/1/|91.becom|
|000042d0| 65 73 20 44 31 2d 31 39 | 39 31 29 00 00 00 23 54 |es D1-19|91)...#T|
|000042e0| 69 74 6c 65 20 6f 66 20 | 74 68 65 20 77 6f 72 6b |itle of |the work|
|000042f0| 73 68 65 65 74 0d 0d 54 | 49 54 4c 45 20 28 20 30 |sheet..T|ITLE ( 0|
|00004300| 20 29 00 00 00 d6 41 6c | 6c 6f 77 73 20 66 6f 72 | )....Al|lows for|
|00004310| 20 61 6e 20 61 74 74 72 | 69 62 75 74 65 20 74 6f | an attr|ibute to|
|00004320| 20 62 65 20 75 73 65 64 | 0d 61 73 20 61 6e 20 61 | be used|.as an a|
|00004330| 74 74 72 69 62 75 74 65 | 2c 20 69 6e 73 74 65 61 |ttribute|, instea|
|00004340| 64 20 6f 66 20 61 20 0d | 64 61 74 61 62 61 73 65 |d of a .|database|
|00004350| 20 64 65 66 69 6e 69 74 | 69 6f 6e 0d 0d a5 53 74 | definit|ion...St|
|00004360| 6f 72 65 73 3a 20 53 61 | 6c 65 73 20 3d 20 49 46 |ores: Sa|les = IF|
|00004370| 20 28 a5 53 74 6f 72 65 | 73 3a 0d 6d 61 67 6e 69 | (.Store|s:.magni|
|00004380| 74 75 64 65 20 3d 20 41 | 54 54 52 49 42 55 54 45 |tude = A|TTRIBUTE|
|00004390| 20 28 6c 61 72 67 65 29 | 29 20 0d 54 48 45 4e 20 | (large)|) .THEN |
|000043a0| 28 20 2e 2e 2e 20 29 20 | 45 4c 53 45 20 28 20 2e |( ... ) |ELSE ( .|
|000043b0| 2e 2e 20 29 0d 0d 28 20 | 6c 61 72 67 65 20 69 73 |.. )..( |large is|
|000043c0| 20 69 6e 20 74 68 69 73 | 20 63 61 73 65 20 61 6e | in this| case an|
|000043d0| 20 61 74 74 72 69 62 75 | 74 65 20 29 00 00 00 33 | attribu|te )...3|
|000043e0| 45 78 70 6f 6e 65 6e 74 | 69 61 6c 20 46 75 6e 63 |Exponent|ial Func|
|000043f0| 74 69 6f 6e 0d ca ca ca | ca ca ca ca ca ca ca ca |tion....|........|
|00004400| ca ca ca ca 0d 45 58 50 | 20 28 20 56 61 6c 75 65 |.....EXP| ( Value|
|00004410| 20 29 20 00 00 00 c9 53 | 74 61 6e 64 61 72 64 20 | ) ....S|tandard |
|00004420| 76 61 72 69 61 74 69 6f | 6e 20 6f 66 20 61 20 73 |variatio|n of a s|
|00004430| 65 6c 65 63 74 69 6f 6e | 0d 0d 53 44 45 56 20 28 |election|..SDEV (|
|00004440| 20 46 5b 31 2e 2e 31 30 | 2c 34 5d 20 29 0d 0d 6f | F[1..10|,4] )..o|
|00004450| 72 0d 53 61 6c 65 73 3a | 31 2f 39 30 20 3d 20 53 |r.Sales:|1/90 = S|
|00004460| 44 45 56 20 28 20 a5 50 | 72 6f 64 75 63 74 73 0d |DEV ( .P|roducts.|
|00004470| 3a 28 61 6c 6c 29 3a 53 | 61 6c 65 73 3a 31 2f 39 |:(all):S|ales:1/9|
|00004480| 30 20 29 0d 0d 6f 72 0d | 53 61 6c 65 73 3a a5 50 |0 )..or.|Sales:.P|
|00004490| 72 6f 64 75 63 74 20 67 | 72 6f 75 70 73 3a 31 2f |roduct g|roups:1/|
|000044a0| 39 30 20 3d 0d 53 44 45 | 56 20 28 20 a5 50 72 6f |90 =.SDE|V ( .Pro|
|000044b0| 64 75 63 74 73 3a 28 41 | 73 73 69 67 6e 6d 65 6e |ducts:(A|ssignmen|
|000044c0| 74 0d 3a a5 50 72 6f 64 | 75 63 74 20 67 72 6f 75 |t.:.Prod|uct grou|
|000044d0| 70 73 29 3a 53 61 6c 65 | 73 3a 31 2f 39 30 20 29 |ps):Sale|s:1/90 )|
|000044e0| 00 00 00 3b 54 68 65 20 | 73 6c 6f 70 65 20 6f 66 |...;The |slope of|
|000044f0| 20 74 68 65 20 0d 72 65 | 67 72 65 73 73 69 6f 6e | the .re|gression|
|00004500| 20 6c 69 6e 65 0d 0d 53 | 4c 4f 50 45 20 28 46 5b | line..S|LOPE (F[|
|00004510| 63 31 2e 2e 63 32 2c 72 | 31 2e 2e 72 32 5d 29 00 |c1..c2,r|1..r2]).|
|00004520| 00 00 f4 4d 61 63 72 6f | 66 75 6e 63 74 69 6f 6e |...Macro|function|
|00004530| 20 74 68 61 74 20 69 6d | 70 6f 72 74 73 20 0d 61 | that im|ports .a|
|00004540| 20 74 65 78 74 20 66 69 | 6c 65 0d 0d 4d 41 43 52 | text fi|le..MACR|
|00004550| 4f 46 55 4e 43 54 49 4f | 4e 3a 20 4e 4f 69 3a 20 |OFUNCTIO|N: NOi: |
|00004560| 28 57 6f 72 6b 73 68 65 | 65 74 29 20 3d 0d 41 55 |(Workshe|et) =.AU|
|00004570| 54 4f 49 4d 50 4f 52 54 | 28 20 46 5b 63 31 2e 2e |TOIMPORT|( F[c1..|
|00004580| 63 32 2c 72 31 2e 2e 72 | 32 5d 3b 0d 20 20 20 20 |c2,r1..r|2];. |
|00004590| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000045a0| 20 20 20 20 20 46 69 6c | 65 20 6e 61 6d 65 20 6f | Fil|e name o|
|000045b0| 72 20 30 3b 30 20 29 0d | 0d 28 30 20 69 6e 73 74 |r 0;0 ).|.(0 inst|
|000045c0| 65 61 64 20 6f 66 20 66 | 69 6c 65 20 6e 61 6d 65 |ead of f|ile name|
|000045d0| 20 3a 0d 6d 61 6e 75 61 | 6c 20 66 69 6c 65 20 73 | :.manua|l file s|
|000045e0| 65 6c 65 63 74 69 6f 6e | 3b 0d 20 46 5b 63 31 2e |election|;. F[c1.|
|000045f0| 2e 63 32 2c 72 31 2e 2e | 72 32 5d 20 64 65 66 69 |.c2,r1..|r2] defi|
|00004600| 6e 65 73 20 74 68 65 20 | 0d 69 6d 70 6f 72 74 20 |nes the |.import |
|00004610| 66 6f 72 6d 61 74 29 00 | 00 00 51 54 68 65 20 69 |format).|..QThe i|
|00004620| 6e 74 65 72 63 65 70 74 | 20 6f 66 20 74 68 65 20 |ntercept| of the |
|00004630| 59 2d 61 78 69 73 0d 6f | 66 20 74 68 65 20 72 65 |Y-axis.o|f the re|
|00004640| 67 72 65 73 73 69 6f 6e | 20 6c 69 6e 65 0d 0d 59 |gression| line..Y|
|00004650| 49 4e 54 45 52 43 45 50 | 54 20 28 46 5b 63 31 2e |INTERCEP|T (F[c1.|
|00004660| 2e 63 32 2c 72 31 2e 2e | 72 32 5d 29 00 00 01 0e |.c2,r1..|r2])....|
|00004670| 4d 61 63 72 6f 66 75 6e | 63 74 69 6f 6e 20 74 6f |Macrofun|ction to|
|00004680| 20 63 68 6f 73 65 20 61 | 20 73 74 61 74 65 20 6f | chose a| state o|
|00004690| 66 20 63 61 6c 63 75 6c | 61 74 69 6f 6e 20 0d 0d |f calcul|ation ..|
|000046a0| 53 45 54 53 54 41 54 45 | 20 28 20 6e 20 29 0d 6e |SETSTATE| ( n ).n|
|000046b0| 0d 3d 20 31 3a 09 42 61 | 73 65 20 43 61 6c 63 75 |.= 1:.Ba|se Calcu|
|000046c0| 6c 61 74 69 6f 6e 0d 3d | 20 32 3a 09 50 68 61 73 |lation.=| 2:.Phas|
|000046d0| 65 20 32 0d 3d 20 33 3a | 09 6e 6f 20 63 6f 72 72 |e 2.= 3:|.no corr|
|000046e0| 65 63 74 69 6f 6e 20 6f | 66 20 72 65 73 75 6c 74 |ection o|f result|
|000046f0| 73 0d 3d 20 34 3a 09 63 | 6f 72 72 65 63 74 69 6f |s.= 4:.c|orrectio|
|00004700| 6e 20 6f 6e 6c 79 20 77 | 69 74 68 20 62 61 73 65 |n only w|ith base|
|00004710| 20 66 6f 6d 75 6c 61 73 | 0d 3d 20 35 3a 09 63 6f | fomulas|.= 5:.co|
|00004720| 72 72 65 63 74 69 6f 6e | 20 77 69 74 68 20 65 76 |rrection| with ev|
|00004730| 65 72 79 20 66 6f 72 6d | 75 6c 61 0d 3d 20 36 3a |ery form|ula.= 6:|
|00004740| 09 75 70 64 61 74 65 20 | 62 75 69 6c 64 2d 75 70 |.update |build-up|
|00004750| 20 61 72 65 61 0d 3d 20 | 37 3a 09 62 75 66 66 65 | area.= |7:.buffe|
|00004760| 72 20 65 6e 74 72 69 65 | 73 0d 3d 20 38 3a 09 65 |r entrie|s.= 8:.e|
|00004770| 76 61 6c 75 61 74 65 20 | 62 75 66 66 65 72 00 00 |valuate |buffer..|
|00004780| 00 52 54 68 65 20 63 6f | 72 72 65 6c 61 74 69 6f |.RThe co|rrelatio|
|00004790| 6e 20 63 6f 65 66 66 65 | 63 69 65 6e 74 0d 6f 66 |n coeffe|cient.of|
|000047a0| 20 74 68 65 20 72 65 67 | 72 65 73 73 69 6f 6e 20 | the reg|ression |
|000047b0| 6c 69 6e 65 0d 0d 43 4f | 52 52 45 4c 41 54 49 4f |line..CO|RRELATIO|
|000047c0| 4e 20 28 46 5b 63 31 2e | 2e 63 32 2c 72 31 2e 2e |N (F[c1.|.c2,r1..|
|000047d0| 72 32 5d 29 00 00 01 0a | 4d 61 63 72 6f 66 75 6e |r2])....|Macrofun|
|000047e0| 63 74 69 6f 6e 20 66 6f | 72 20 63 6f 70 79 69 6e |ction fo|r copyin|
|000047f0| 67 20 74 68 65 20 63 6f | 6e 74 65 6e 74 73 0d 6f |g the co|ntents.o|
|00004800| 66 20 6f 6e 65 20 73 65 | 6c 65 63 74 65 64 20 61 |f one se|lected a|
|00004810| 72 65 61 20 69 6e 74 6f | 20 61 6e 6f 74 68 65 72 |rea into| another|
|00004820| 20 20 0d 0d 4d 41 43 52 | 4f 46 55 4e 43 54 49 4f | ..MACR|OFUNCTIO|
|00004830| 4e 3a 4e 4f 69 3a 20 28 | 57 6f 72 6b 73 68 65 65 |N:NOi: (|Workshee|
|00004840| 74 29 20 3d 0d 43 4f 50 | 59 20 28 46 5b 63 31 2e |t) =.COP|Y (F[c1.|
|00004850| 2e 63 32 2c 72 31 2e 2e | 72 32 5d 3b 20 46 5b 63 |.c2,r1..|r2]; F[c|
|00004860| 33 2e 2e 63 34 2c 72 33 | 2e 2e 72 34 5d 3b 20 6e |3..c4,r3|..r4]; n|
|00004870| 29 0d 0d 6e 20 3d 20 30 | 20 20 6c 69 6b 65 20 43 |)..n = 0| like C|
|00004880| 4f 50 59 20 61 6e 64 20 | 50 41 53 54 45 20 20 66 |OPY and |PASTE f|
|00004890| 72 6f 6d 20 74 68 65 20 | 6d 65 6e 75 0d 6e 20 3d |rom the |menu.n =|
|000048a0| 20 31 20 20 6c 69 6b 65 | 20 43 4f 50 59 20 61 6e | 1 like| COPY an|
|000048b0| 64 20 50 41 53 54 45 20 | 53 50 45 43 49 41 4c 20 |d PASTE |SPECIAL |
|000048c0| 0d ca ca ca ca 20 20 56 | 41 4c 55 45 53 20 4f 4e |..... V|ALUES ON|
|000048d0| 4c 59 20 20 66 72 6f 6d | 20 74 68 65 20 6d 65 6e |LY from| the men|
|000048e0| 75 0d 00 00 00 32 4d 61 | 63 72 6f 66 75 6e 63 74 |u....2Ma|crofunct|
|000048f0| 69 6f 6e 20 66 6f 72 20 | 0d 71 75 69 74 74 69 6e |ion for |.quittin|
|00004900| 67 20 6d 61 63 43 6f 6e | 74 72 6f 6c 0d 0d 51 55 |g macCon|trol..QU|
|00004910| 49 54 20 28 20 30 20 29 | 00 00 00 65 4d 61 63 72 |IT ( 0 )|...eMacr|
|00004920| 6f 66 75 6e 63 74 69 6f | 6e 20 66 6f 72 20 6f 70 |ofunctio|n for op|
|00004930| 65 6e 69 6e 67 0d 61 20 | 77 6f 72 6b 73 68 65 65 |ening.a |workshee|
|00004940| 74 0d 0d 4d 41 43 52 4f | 46 55 4e 43 54 49 4f 4e |t..MACRO|FUNCTION|
|00004950| 20 3a 20 4e 4f 69 20 3d | 0d 4f 50 45 4e 20 28 41 | : NOi =|.OPEN (A|
|00004960| 54 54 52 49 42 55 54 45 | 0d 20 28 4e 61 6d 65 20 |TTRIBUTE|. (Name |
|00004970| 6f 66 20 77 6f 72 6b 73 | 68 65 65 74 29 3b 20 30 |of works|heet); 0|
|00004980| 29 00 00 00 ce 4c 61 73 | 74 20 76 61 6c 75 65 20 |)....Las|t value |
|00004990| 69 6e 20 61 20 73 65 6c | 65 63 74 65 64 20 61 72 |in a sel|ected ar|
|000049a0| 65 61 0d 0d 4c 53 54 56 | 41 4c 55 45 20 28 20 46 |ea..LSTV|ALUE ( F|
|000049b0| 5b 31 2e 2e 31 30 2c 34 | 5d 20 29 0d 0d 6f 72 0d |[1..10,4|] )..or.|
|000049c0| 53 61 6c 65 73 3a 31 2f | 39 30 20 3d 20 4c 53 54 |Sales:1/|90 = LST|
|000049d0| 56 41 4c 55 45 0d 28 a5 | 50 72 6f 64 75 63 74 73 |VALUE.(.|Products|
|000049e0| 3a 28 61 6c 6c 29 3a 53 | 61 6c 65 73 3a 31 2f 39 |:(all):S|ales:1/9|
|000049f0| 30 20 29 0d 0d 6f 72 0d | 53 61 6c 65 73 3a a5 50 |0 )..or.|Sales:.P|
|00004a00| 72 6f 64 75 63 74 20 67 | 72 6f 75 70 73 3a 31 2f |roduct g|roups:1/|
|00004a10| 39 30 20 3d 0d 4c 53 54 | 56 41 4c 55 45 28 20 a5 |90 =.LST|VALUE( .|
|00004a20| 50 72 6f 64 75 63 74 73 | 3a 28 41 73 73 69 67 6e |Products|:(Assign|
|00004a30| 6d 65 6e 74 0d 3a a5 50 | 72 6f 64 75 63 74 20 67 |ment.:.P|roduct g|
|00004a40| 72 6f 75 70 73 29 3a 53 | 61 6c 65 73 3a 31 2f 39 |roups):S|ales:1/9|
|00004a50| 30 20 29 00 00 00 fe 41 | 75 74 6f 6d 61 74 69 63 |0 )....A|utomatic|
|00004a60| 61 6c 6c 79 20 6a 75 6d | 70 73 20 74 6f 20 73 70 |ally jum|ps to sp|
|00004a70| 65 63 69 66 69 63 0d 63 | 65 6c 6c 73 20 6f 66 20 |ecific.c|ells of |
|00004a80| 61 20 64 61 74 61 20 65 | 6e 74 72 79 20 77 6f 72 |a data e|ntry wor|
|00004a90| 6b 73 68 65 65 74 0d 6f | 72 20 0d 63 61 72 72 69 |ksheet.o|r .carri|
|00004aa0| 65 73 20 6f 75 74 20 61 | 20 4d 61 63 72 6f 20 61 |es out a| Macro a|
|00004ab0| 66 74 65 72 20 61 0d 73 | 70 65 63 69 66 69 63 20 |fter a.s|pecific |
|00004ac0| 63 65 6c 6c 20 68 61 73 | 20 62 65 65 6e 20 63 68 |cell has| been ch|
|00004ad0| 61 6e 67 65 64 0d 28 6d | 75 73 74 20 62 65 20 64 |anged.(m|ust be d|
|00004ae0| 65 66 69 6e 65 64 20 69 | 6e 20 61 20 66 6c 65 78 |efined i|n a flex|
|00004af0| 69 62 6c 65 20 63 65 6c | 6c 29 0d 0d 4a 55 4d 50 |ible cel|l)..JUMP|
|00004b00| 20 28 46 5b 63 31 2e 2e | 63 32 2c 72 31 2e 2e 72 | (F[c1..|c2,r1..r|
|00004b10| 32 5d 3b 20 30 20 29 0d | 20 0d 28 20 46 5b 63 31 |2]; 0 ).| .( F[c1|
|00004b20| 2e 2e 63 32 2c 72 31 2e | 2e 72 32 5d 20 67 69 76 |..c2,r1.|.r2] giv|
|00004b30| 65 73 20 74 68 65 20 61 | 72 65 61 20 0d 6f 66 20 |es the a|rea .of |
|00004b40| 74 68 65 20 4a 55 4d 50 | 20 64 65 66 69 6e 69 74 |the JUMP| definit|
|00004b50| 69 6f 6e 20 29 00 00 00 | ea 4d 61 63 72 6f 66 75 |ion )...|.Macrofu|
|00004b60| 6e 63 74 69 6f 6e 20 66 | 6f 72 20 72 65 70 65 61 |nction f|or repea|
|00004b70| 74 65 64 20 65 78 65 63 | 75 74 69 6f 6e 0d 6f 66 |ted exec|ution.of|
|00004b80| 20 61 20 20 6d 61 63 72 | 6f 2c 20 77 69 74 68 6f | a macr|o, witho|
|00004b90| 75 74 20 74 68 65 20 75 | 73 65 72 20 68 61 76 69 |ut the u|ser havi|
|00004ba0| 6e 67 20 74 6f 0d 63 68 | 61 6e 67 65 20 77 6f 72 |ng to.ch|ange wor|
|00004bb0| 6b 73 68 65 65 74 73 20 | 6f 72 20 73 77 69 74 63 |ksheets |or switc|
|00004bc0| 68 20 6d 65 6e 75 63 65 | 6c 6c 73 0d 0d 4d 41 43 |h menuce|lls..MAC|
|00004bd0| 52 4f 46 55 4e 43 54 49 | 4f 4e 20 3a 20 4e 4f 69 |ROFUNCTI|ON : NOi|
|00004be0| 20 3a 20 0d 28 57 6f 72 | 6b 73 68 65 65 74 29 20 | : .(Wor|ksheet) |
|00004bf0| 3d 20 20 52 45 50 45 41 | 54 20 0d 28 20 46 5b 63 |= REPEA|T .( F[c|
|00004c00| 31 2e 2e 63 32 2c 72 31 | 2e 2e 72 32 5d 20 29 0d |1..c2,r1|..r2] ).|
|00004c10| 0d 28 46 5b 63 31 2e 2e | 63 32 2c 72 31 2e 2e 72 |.(F[c1..|c2,r1..r|
|00004c20| 32 5d 20 63 6f 6e 74 61 | 69 6e 73 20 0d 74 68 65 |2] conta|ins .the|
|00004c30| 20 65 78 61 63 74 20 64 | 65 66 69 6e 69 74 69 6f | exact d|efinitio|
|00004c40| 6e 20 29 00 00 00 b2 59 | 69 65 6c 64 73 20 74 68 |n )....Y|ields th|
|00004c50| 65 20 70 6f 69 6e 74 20 | 69 6e 20 74 69 6d 65 20 |e point |in time |
|00004c60| 6f 66 20 74 68 65 20 6c | 61 73 74 0d 76 61 6c 75 |of the l|ast.valu|
|00004c70| 65 20 69 6e 73 69 64 65 | 20 61 20 74 69 6d 65 20 |e inside| a time |
|00004c80| 69 6e 74 65 72 76 61 6c | 2c 20 74 68 61 74 20 69 |interval|, that i|
|00004c90| 73 20 0d 6e 6f 74 20 45 | 4d 50 54 59 0d 0d 4c 61 |s .not E|MPTY..La|
|00004ca0| 73 74 20 6d 6f 6e 74 68 | 60 73 20 73 61 6c 65 73 |st month|`s sales|
|00004cb0| 20 3a 20 a5 50 72 6f 64 | 75 63 74 73 20 3d 0d 4c | : .Prod|ucts =.L|
|00004cc0| 41 53 54 54 49 4d 45 20 | 28 53 61 6c 65 73 3a a5 |ASTTIME |(Sales:.|
|00004cd0| 50 72 6f 64 75 63 74 73 | 0d 3a 31 2f 31 39 30 34 |Products|.:1/1904|
|00004ce0| 61 3b 20 53 74 61 72 74 | 20 74 69 6d 65 3b 20 45 |a; Start| time; E|
|00004cf0| 6e 64 20 74 69 6d 65 20 | 29 00 00 00 98 59 69 65 |nd time |)....Yie|
|00004d00| 6c 64 73 20 74 68 65 20 | 6c 61 73 74 20 76 61 6c |lds the |last val|
|00004d10| 75 65 20 69 6e 20 61 20 | 67 69 76 65 6e 20 0d 74 |ue in a |given .t|
|00004d20| 69 6d 65 20 69 6e 74 65 | 72 76 61 6c 2c 20 74 68 |ime inte|rval, th|
|00004d30| 61 74 20 69 73 20 6e 6f | 74 20 45 4d 50 54 59 0d |at is no|t EMPTY.|
|00004d40| 0d 4c 61 73 74 20 53 61 | 6c 65 20 3a 20 a5 50 72 |.Last Sa|le : .Pr|
|00004d50| 6f 64 75 63 74 73 20 3d | 0d 4c 41 53 54 56 41 4c |oducts =|.LASTVAL|
|00004d60| 55 45 20 28 20 53 61 6c | 65 73 3a a5 50 72 6f 64 |UE ( Sal|es:.Prod|
|00004d70| 75 63 74 73 0d 3a 31 2f | 31 39 30 34 61 3b 20 53 |ucts.:1/|1904a; S|
|00004d80| 74 61 72 74 20 74 69 6d | 65 3b 20 45 6e 64 20 74 |tart tim|e; End t|
|00004d90| 69 6d 65 20 29 00 00 00 | 89 49 6e 74 65 72 6e 61 |ime )...|.Interna|
|00004da0| 6c 20 69 6e 74 65 72 65 | 73 74 20 72 61 74 65 ca |l intere|st rate.|
|00004db0| ca ca ca ca ca ca ca 0d | 0d 49 6e 74 65 72 65 73 |........|.Interes|
|00004dc0| 74 20 72 61 74 65 20 3a | 20 50 72 6f 6a 65 63 74 |t rate :| Project|
|00004dd0| 20 31 20 3d 0d 49 52 41 | 54 45 20 28 50 72 6f 6a | 1 =.IRA|TE (Proj|
|00004de0| 65 63 74 20 31 3a 20 43 | 6f 73 74 73 20 0d 3a 31 |ect 1: C|osts .:1|
|00004df0| 39 30 34 61 3b 20 53 74 | 61 72 74 20 74 69 6d 65 |904a; St|art time|
|00004e00| 3b 20 45 6e 64 20 74 69 | 6d 65 2c 0d 20 45 73 74 |; End ti|me,. Est|
|00004e10| 69 6d 61 74 65 64 20 76 | 61 6c 75 65 20 69 6e 20 |imated v|alue in |
|00004e20| 25 29 00 00 00 a6 50 52 | 45 53 45 4e 54 20 56 41 |%)....PR|ESENT VA|
|00004e30| 4c 55 45 20 6f 66 20 61 | 20 73 63 68 65 64 75 6c |LUE of a| schedul|
|00004e40| 65 20 6f 66 20 0d 70 61 | 79 6d 65 6e 74 73 20 61 |e of .pa|yments a|
|00004e50| 74 20 61 20 67 69 76 65 | 6e 20 69 6e 74 65 72 65 |t a give|n intere|
|00004e60| 73 74 20 72 61 74 65 0d | 0d 50 72 65 73 65 6e 74 |st rate.|.Present|
|00004e70| 76 61 6c 75 65 20 3a 20 | 50 72 6f 6a 65 63 74 20 |value : |Project |
|00004e80| 31 20 3d 0d 50 56 20 28 | 50 72 6f 6a 65 63 74 20 |1 =.PV (|Project |
|00004e90| 31 3a 20 43 6f 73 74 73 | 20 0d 3a 31 39 30 34 61 |1: Costs| .:1904a|
|00004ea0| 3b 20 53 74 61 72 74 20 | 74 69 6d 65 3b 20 45 6e |; Start |time; En|
|00004eb0| 64 20 74 69 6d 65 2c 0d | 20 69 6e 74 65 72 65 73 |d time,.| interes|
|00004ec0| 74 20 72 61 74 65 20 69 | 6e 20 25 29 00 00 00 a4 |t rate i|n %)....|
|00004ed0| 46 55 54 55 52 45 20 56 | 41 4c 55 45 20 6f 66 20 |FUTURE V|ALUE of |
|00004ee0| 61 20 73 63 68 65 64 75 | 6c 65 20 6f 66 20 0d 70 |a schedu|le of .p|
|00004ef0| 61 79 6d 65 6e 74 73 20 | 61 74 20 61 20 67 69 76 |ayments |at a giv|
|00004f00| 65 6e 20 69 6e 74 65 72 | 65 73 74 20 72 61 74 65 |en inter|est rate|
|00004f10| 0d 0d 46 75 74 75 72 65 | 76 61 6c 75 65 20 3a 20 |..Future|value : |
|00004f20| 50 72 6f 6a 65 63 74 20 | 31 20 3d 0d 46 56 20 28 |Project |1 =.FV (|
|00004f30| 50 72 6f 6a 65 63 74 20 | 31 3a 20 43 6f 73 74 73 |Project |1: Costs|
|00004f40| 20 0d 3a 31 39 30 34 61 | 3b 20 53 74 61 72 74 20 | .:1904a|; Start |
|00004f50| 74 69 6d 65 3b 20 45 6e | 64 20 74 69 6d 65 2c 0d |time; En|d time,.|
|00004f60| 20 69 6e 74 65 72 65 73 | 74 20 72 61 74 65 20 69 | interes|t rate i|
|00004f70| 6e 20 25 29 00 00 00 b6 | 50 52 45 53 45 4e 54 20 |n %)....|PRESENT |
|00004f80| 56 41 4c 55 45 20 77 69 | 74 68 20 61 20 67 69 76 |VALUE wi|th a giv|
|00004f90| 65 6e 20 66 69 72 73 74 | 0d 70 61 79 6d 65 6e 74 |en first|.payment|
|00004fa0| 20 61 6e 64 20 61 20 73 | 70 65 63 69 66 69 63 20 | and a s|pecific |
|00004fb0| 6e 75 6d 62 65 72 20 6f | 66 0d 6c 61 74 65 72 20 |number o|f.later |
|00004fc0| 70 61 79 6d 65 6e 74 73 | 0d 0d 0d 50 72 65 73 65 |payments|...Prese|
|00004fd0| 6e 74 76 61 6c 75 65 20 | 20 3d 0d 4e 50 56 20 28 |ntvalue | =.NPV (|
|00004fe0| 46 69 72 73 74 20 70 61 | 79 6d 65 6e 74 3b 20 66 |First pa|yment; f|
|00004ff0| 6f 6c 6c 6f 77 69 6e 67 | 20 70 61 79 6d 65 6e 74 |ollowing| payment|
|00005000| 3b 0d 4e 75 6d 62 65 72 | 20 6f 66 20 66 6f 6c 6c |;.Number| of foll|
|00005010| 6f 77 69 6e 67 20 70 61 | 79 6d 65 6e 74 73 3b 0d |owing pa|yments;.|
|00005020| 49 6e 74 65 72 65 73 74 | 20 72 61 74 65 29 00 00 |Interest| rate)..|
|00005030| 00 b7 46 55 54 55 52 45 | 20 56 41 4c 55 45 20 77 |..FUTURE| VALUE w|
|00005040| 69 74 68 20 61 20 67 69 | 76 65 6e 20 66 69 72 73 |ith a gi|ven firs|
|00005050| 74 0d 70 61 79 6d 65 6e | 74 20 61 6e 64 20 61 20 |t.paymen|t and a |
|00005060| 73 70 65 63 69 66 69 63 | 20 6e 75 6d 62 65 72 20 |specific| number |
|00005070| 6f 66 0d 6c 61 74 65 72 | 20 70 61 79 6d 65 6e 74 |of.later| payment|
|00005080| 73 0d 0d 0d 46 75 74 75 | 72 65 76 61 6c 75 65 20 |s...Futu|revalue |
|00005090| 20 3d 0d 4e 46 56 20 20 | 28 46 69 72 73 74 20 70 | =.NFV |(First p|
|000050a0| 61 79 6d 65 6e 74 3b 20 | 66 6f 6c 6c 6f 77 69 6e |ayment; |followin|
|000050b0| 67 20 0d 70 61 79 6d 65 | 6e 74 3b 20 4e 75 6d 62 |g .payme|nt; Numb|
|000050c0| 65 72 20 6f 66 20 66 6f | 6c 6c 6f 77 69 6e 67 20 |er of fo|llowing |
|000050d0| 0d 70 61 79 6d 65 6e 74 | 73 3b 20 49 6e 74 65 72 |.payment|s; Inter|
|000050e0| 65 73 74 20 72 61 74 65 | 29 00 00 00 98 4d 61 63 |est rate|)....Mac|
|000050f0| 72 6f 66 75 6e 63 74 69 | 6f 6e 20 66 6f 72 20 61 |rofuncti|on for a|
|00005100| 75 74 6f 6d 61 74 69 63 | 61 6c 6c 79 20 63 72 65 |utomatic|ally cre|
|00005110| 61 74 69 6e 67 0d 61 73 | 73 69 67 6e 6d 65 6e 74 |ating.as|signment|
|00005120| 73 20 64 75 72 69 6e 67 | 20 61 20 64 61 74 61 20 |s during| a data |
|00005130| 69 6d 70 6f 72 74 0d 0d | 41 43 54 49 56 41 54 45 |import..|ACTIVATE|
|00005140| 20 28 41 73 73 69 67 6e | 6d 65 6e 74 20 64 65 66 | (Assign|ment def|
|00005150| 69 6e 69 74 69 6f 6e 3b | 20 0d 20 20 20 20 20 20 |inition;| . |
|00005160| 20 20 20 20 20 20 20 20 | 20 20 20 20 47 72 6f 75 | | Grou|
|00005170| 70 20 74 6f 20 62 65 20 | 61 73 73 69 67 6e 65 64 |p to be |assigned|
|00005180| 3b 20 30 29 20 00 00 00 | 50 4d 61 63 72 6f 66 75 |; 0) ...|PMacrofu|
|00005190| 6e 63 74 69 6f 6e 20 74 | 68 61 74 20 73 65 6e 64 |nction t|hat send|
|000051a0| 73 0d 61 20 71 75 65 72 | 79 20 74 6f 20 61 20 68 |s.a quer|y to a h|
|000051b0| 6f 73 74 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ost | |
|000051c0| 0d 0d 53 45 4e 44 20 28 | 51 75 65 72 79 3b 20 46 |..SEND (|Query; F|
|000051d0| 69 6c 65 20 6e 61 6d 65 | 29 00 00 00 87 4d 61 63 |ile name|)....Mac|
|000051e0| 72 6f 66 75 6e 63 74 69 | 6f 6e 20 66 6f 72 20 61 |rofuncti|on for a|
|000051f0| 75 74 6f 6d 61 74 69 63 | 61 6c 6c 79 20 0d 62 75 |utomatic|ally .bu|
|00005200| 69 6c 64 69 6e 67 20 75 | 70 20 61 20 63 6f 6e 6e |ilding u|p a conn|
|00005210| 65 63 74 69 6f 6e 20 74 | 6f 20 61 20 68 6f 73 74 |ection t|o a host|
|00005220| 0d 20 0d 43 4f 4e 4e 45 | 43 54 20 28 44 61 74 61 |. .CONNE|CT (Data|
|00005230| 62 61 73 65 20 65 78 74 | 65 6e 73 69 6f 6e 3b 20 |base ext|ension; |
|00005240| 0d 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00005250| 20 20 20 20 48 6f 73 74 | 3b 20 41 64 64 69 74 69 | Host|; Additi|
|00005260| 6f 6e 20 29 00 00 00 1c | 46 6f 72 20 64 65 66 69 |on )....|For defi|
|00005270| 6e 69 6e 67 20 61 20 64 | 61 74 61 62 61 73 65 20 |ning a d|atabase |
|00005280| 63 65 6c 6c 00 00 00 16 | 46 6f 72 20 64 65 66 69 |cell....|For defi|
|00005290| 6e 69 6e 67 20 61 20 66 | 6f 72 6d 75 6c 61 00 00 |ning a f|ormula..|
|000052a0| 00 29 46 6f 72 20 64 65 | 66 69 6e 69 6e 67 20 61 |.)For de|fining a|
|000052b0| 6e 20 61 74 74 72 69 62 | 75 74 65 2d 20 6f 72 20 |n attrib|ute- or |
|000052c0| 61 20 6d 65 6e 75 20 63 | 65 6c 6c 00 00 00 18 46 |a menu c|ell....F|
|000052d0| 6f 72 20 64 65 66 69 6e | 69 6e 67 20 61 20 74 69 |or defin|ing a ti|
|000052e0| 6d 65 20 63 65 6c 6c 00 | 00 00 2d 63 61 6e 63 65 |me cell.|..-cance|
|000052f0| 6c 73 20 74 68 65 20 69 | 6e 70 75 74 2c 20 77 69 |ls the i|nput, wi|
|00005300| 74 68 6f 75 74 20 73 61 | 76 69 6e 67 20 74 68 65 |thout sa|ving the|
|00005310| 20 63 68 61 6e 67 65 73 | 00 00 00 19 51 75 69 74 | changes|....Quit|
|00005320| 73 20 61 6e 64 20 73 61 | 76 65 73 20 74 68 65 20 |s and sa|ves the |
|00005330| 69 6e 70 75 74 00 00 00 | 1a 4f 70 65 6e 73 20 74 |input...|.Opens t|
|00005340| 68 65 20 61 74 74 72 69 | 62 75 74 65 20 77 69 6e |he attri|bute win|
|00005350| 64 6f 77 00 00 00 d7 44 | 65 66 69 6e 65 73 20 6f |dow....D|efines o|
|00005360| 6e 20 77 68 69 63 68 20 | 73 69 64 65 73 20 6f 66 |n which |sides of|
|00005370| 20 61 20 67 72 61 70 68 | 69 63 20 0d 74 68 65 72 | a graph|ic .ther|
|00005380| 65 20 73 68 6f 75 6c 64 | 20 62 65 20 62 6f 72 64 |e should| be bord|
|00005390| 65 72 73 2c 20 61 6e 64 | 20 68 6f 77 20 6c 61 72 |ers, and| how lar|
|000053a0| 67 65 0d 74 68 65 79 20 | 73 68 6f 75 6c 64 20 62 |ge.they |should b|
|000053b0| 65 20 28 6f 6e 6c 79 20 | 77 69 74 68 20 32 44 2d |e (only |with 2D-|
|000053c0| 47 72 61 70 68 69 63 73 | 29 2e 0d 50 69 65 20 63 |Graphics|)..Pie c|
|000053d0| 68 61 72 74 73 20 77 69 | 74 68 20 64 65 70 74 68 |harts wi|th depth|
|000053e0| 20 63 61 6e 20 62 65 20 | 76 69 65 77 65 64 20 66 | can be |viewed f|
|000053f0| 72 6f 6d 0d 76 61 72 69 | 6f 75 73 20 61 6e 67 6c |rom.vari|ous angl|
|00005400| 65 73 20 62 79 20 64 65 | 66 69 6e 69 6e 67 20 74 |es by de|fining t|
|00005410| 68 65 20 75 70 70 65 72 | 20 61 6e 64 20 0d 6c 6f |he upper| and .lo|
|00005420| 77 65 72 20 62 6f 72 64 | 65 72 73 20 20 0d 00 00 |wer bord|ers ...|
|00005430| 00 f8 47 69 76 65 73 20 | 32 44 2d 67 72 61 70 68 |..Gives |2D-graph|
|00005440| 69 63 73 20 61 20 73 70 | 61 74 69 61 6c 20 63 68 |ics a sp|atial ch|
|00005450| 61 72 61 63 74 65 72 2e | 20 54 6f 20 67 69 76 65 |aracter.| To give|
|00005460| 0d 64 65 70 74 68 20 6e | 6f 74 20 6f 6e 6c 79 20 |.depth n|ot only |
|00005470| 74 6f 20 74 68 65 20 61 | 78 69 73 2c 20 62 75 74 |to the a|xis, but|
|00005480| 20 61 6c 73 6f 20 74 6f | 20 74 68 65 20 0d 67 72 | also to| the .gr|
|00005490| 61 70 68 69 63 20 69 74 | 73 65 6c 66 2c 20 61 20 |aphic it|self, a |
|000054a0| 64 65 70 74 68 20 72 61 | 6e 67 65 20 6d 75 73 74 |depth ra|nge must|
|000054b0| 20 62 65 20 63 68 6f 73 | 65 6e 0d 28 62 79 20 63 | be chos|en.(by c|
|000054c0| 6c 69 63 6b 69 6e 67 20 | 6f 6e 20 4f 50 54 49 4f |licking |on OPTIO|
|000054d0| 4e 29 2e 20 20 0d 0d 57 | 69 74 68 20 33 44 2d 63 |N). ..W|ith 3D-c|
|000054e0| 6f 6e 74 6f 75 72 2d 67 | 72 61 70 68 69 63 73 2c |ontour-g|raphics,|
|000054f0| 20 74 68 65 20 6e 75 6d | 62 65 72 20 6f 66 20 0d | the num|ber of .|
|00005500| 63 6f 6e 74 6f 75 72 20 | 6c 69 6e 65 73 20 69 73 |contour |lines is|
|00005510| 20 65 6e 74 65 72 65 64 | 20 69 6e 20 74 68 69 73 | entered| in this|
|00005520| 20 66 69 65 6c 64 20 0d | 0d 0d 00 00 00 ed 44 65 | field .|......De|
|00005530| 66 69 6e 65 73 20 74 68 | 65 20 73 69 7a 65 20 6f |fines th|e size o|
|00005540| 66 20 61 20 73 69 6e 67 | 6c 65 20 61 78 69 73 20 |f a sing|le axis |
|00005550| 69 6e 20 70 65 72 63 65 | 6e 74 0d 6f 66 20 74 68 |in perce|nt.of th|
|00005560| 65 20 64 65 66 61 75 6c | 74 2d 76 61 6c 75 65 2e |e defaul|t-value.|
|00005570| 20 20 54 68 69 73 20 61 | 6c 6c 6f 77 73 20 74 68 | This a|llows th|
|00005580| 65 20 75 73 65 72 0d 74 | 6f 20 65 6e 6c 61 72 67 |e user.t|o enlarg|
|00005590| 65 20 6f 72 20 72 65 64 | 75 63 65 20 74 68 65 20 |e or red|uce the |
|000055a0| 77 68 6f 6c 65 20 67 72 | 61 70 68 69 63 2e 0d 0d |whole gr|aphic...|
|000055b0| 49 74 20 69 73 20 65 61 | 73 69 65 72 20 74 6f 20 |It is ea|sier to |
|000055c0| 73 65 6c 65 63 74 20 74 | 68 65 20 67 72 61 70 68 |select t|he graph|
|000055d0| 69 63 20 61 6e 64 20 75 | 73 65 0d 74 68 65 20 75 |ic and u|se.the u|
|000055e0| 70 70 65 72 20 72 6f 77 | 20 6f 66 20 74 68 65 20 |pper row| of the |
|000055f0| 6e 75 6d 65 72 69 63 20 | 6b 65 79 70 61 64 20 6f |numeric |keypad o|
|00005600| 72 20 0d 74 6f 20 70 75 | 73 68 20 74 68 65 20 2b |r .to pu|sh the +|
|00005610| 20 6f 72 20 2d 20 6b 65 | 79 73 20 00 00 00 f9 45 | or - ke|ys ....E|
|00005620| 73 74 61 62 6c 69 73 68 | 65 73 20 77 68 61 74 20 |stablish|es what |
|00005630| 70 65 72 63 65 6e 74 20 | 6f 66 20 74 68 65 20 61 |percent |of the a|
|00005640| 78 69 73 20 69 73 20 75 | 73 65 64 20 69 6e 20 67 |xis is u|sed in g|
|00005650| 72 61 70 68 69 63 61 6c | 6c 79 20 64 65 70 69 63 |raphical|ly depic|
|00005660| 74 69 6e 67 20 74 68 65 | 20 64 61 74 61 2e 0d 0d |ting the| data...|
|00005670| 31 30 30 20 25 20 6d 65 | 61 6e 73 20 74 68 61 74 |100 % me|ans that|
|00005680| 20 74 68 65 20 68 69 67 | 68 65 73 74 20 64 61 74 | the hig|hest dat|
|00005690| 61 20 76 61 6c 75 65 20 | 69 73 20 74 68 65 20 73 |a value |is the s|
|000056a0| 61 6d 65 20 68 65 69 67 | 68 74 20 61 73 20 74 68 |ame heig|ht as th|
|000056b0| 65 20 68 69 67 68 65 73 | 74 20 61 78 69 73 20 76 |e highes|t axis v|
|000056c0| 61 6c 75 65 2e 0d 35 30 | 20 25 20 6d 65 61 6e 73 |alue..50| % means|
|000056d0| 20 74 68 61 74 20 74 68 | 65 20 68 69 67 68 65 73 | that th|e highes|
|000056e0| 74 20 61 78 69 73 20 76 | 61 6c 75 65 20 69 73 20 |t axis v|alue is |
|000056f0| 74 77 69 63 65 20 61 73 | 20 68 69 67 68 20 61 73 |twice as| high as|
|00005700| 20 74 68 65 20 68 69 67 | 68 65 73 74 20 64 61 74 | the hig|hest dat|
|00005710| 61 20 76 61 6c 75 65 2e | 00 00 00 d7 45 73 74 61 |a value.|....Esta|
|00005720| 62 6c 69 73 68 65 73 20 | 74 68 65 20 70 65 72 63 |blishes |the perc|
|00005730| 65 6e 74 61 67 65 20 74 | 68 61 74 20 74 68 65 20 |entage t|hat the |
|00005740| 67 72 61 70 68 69 63 20 | 6f 62 6a 65 63 74 73 20 |graphic |objects |
|00005750| 28 63 6f 6c 75 6d 6e 73 | 2c 20 65 74 63 2e 29 20 |(columns|, etc.) |
|00005760| 73 68 6f 75 6c 64 20 66 | 69 6c 6c 0d 66 72 6f 6d |should f|ill.from|
|00005770| 20 74 68 65 20 73 70 61 | 63 65 20 74 68 61 74 20 | the spa|ce that |
|00005780| 69 73 20 61 76 61 69 6c | 61 62 6c 65 20 6f 6e 20 |is avail|able on |
|00005790| 74 68 65 20 61 78 69 73 | 2e 0d 0d 54 68 69 73 20 |the axis|...This |
|000057a0| 61 6c 6c 6f 77 73 20 74 | 68 65 20 6f 62 6a 65 63 |allows t|he objec|
|000057b0| 74 73 20 74 6f 20 62 65 | 20 65 6e 6c 61 72 67 65 |ts to be| enlarge|
|000057c0| 64 20 77 69 74 68 6f 75 | 74 20 68 61 76 69 6e 67 |d withou|t having|
|000057d0| 20 74 6f 20 63 68 61 6e | 67 65 20 74 68 65 20 73 | to chan|ge the s|
|000057e0| 69 7a 65 20 6f 66 20 74 | 68 65 20 67 72 61 70 68 |ize of t|he graph|
|000057f0| 69 63 2e 00 00 00 ed 45 | 73 74 61 62 6c 69 73 68 |ic.....E|stablish|
|00005800| 65 73 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |es the n|umber of|
|00005810| 20 64 65 67 72 65 65 73 | 20 74 68 61 74 20 74 68 | degrees| that th|
|00005820| 65 20 67 72 61 70 68 20 | 73 68 6f 75 6c 64 20 72 |e graph |should r|
|00005830| 6f 74 61 74 65 20 6f 6e | 20 74 68 65 20 61 78 69 |otate on| the axi|
|00005840| 73 2e 0d 54 68 69 73 20 | 65 6e 61 62 6c 65 73 20 |s..This |enables |
|00005850| 74 68 65 20 75 73 65 72 | 20 74 6f 20 63 68 61 6e |the user| to chan|
|00005860| 67 65 20 74 68 65 20 76 | 69 73 75 61 6c 20 61 6e |ge the v|isual an|
|00005870| 67 6c 65 20 6f 66 20 74 | 68 65 20 67 72 61 70 68 |gle of t|he graph|
|00005880| 2e 0d 0d 49 74 20 69 73 | 20 65 61 73 69 65 72 20 |...It is| easier |
|00005890| 74 6f 20 73 65 6c 65 63 | 74 20 74 68 65 20 67 72 |to selec|t the gr|
|000058a0| 61 70 68 69 63 2c 20 61 | 6e 64 20 74 68 65 6e 20 |aphic, a|nd then |
|000058b0| 6d 61 6b 65 20 74 68 65 | 20 61 64 6a 75 73 74 6d |make the| adjustm|
|000058c0| 65 6e 74 20 77 69 74 68 | 20 74 68 65 20 68 65 6c |ent with| the hel|
|000058d0| 70 20 6f 66 20 74 68 65 | 20 61 72 72 6f 77 20 6b |p of the| arrow k|
|000058e0| 65 79 73 2e 00 00 01 3a | 4f 62 6a 65 63 74 73 20 |eys....:|Objects |
|000058f0| 74 68 61 74 20 61 72 65 | 20 66 61 72 74 68 65 72 |that are| farther|
|00005900| 20 61 77 61 79 20 73 65 | 65 6d 20 74 6f 20 62 65 | away se|em to be|
|00005910| 20 73 6d 61 6c 6c 65 72 | 20 74 68 61 6e 20 73 69 | smaller| than si|
|00005920| 6d 69 6c 61 72 20 6f 62 | 6a 65 63 74 73 20 74 68 |milar ob|jects th|
|00005930| 61 74 20 61 72 65 20 6e | 65 61 72 65 72 2e 0d 42 |at are n|earer..B|
|00005940| 79 20 63 68 61 6e 67 69 | 6e 67 20 74 68 65 20 66 |y changi|ng the f|
|00005950| 6f 63 61 6c 20 64 69 73 | 74 61 6e 63 65 2c 20 74 |ocal dis|tance, t|
|00005960| 68 65 20 73 74 72 65 6e | 67 74 68 20 6f 66 20 74 |he stren|gth of t|
|00005970| 68 69 73 20 65 66 66 65 | 63 74 20 63 61 6e 20 62 |his effe|ct can b|
|00005980| 65 20 63 68 61 6e 67 65 | 64 2e 0d 0d 41 20 66 6f |e change|d...A fo|
|00005990| 63 61 6c 20 64 69 73 74 | 61 6e 63 65 20 6f 66 20 |cal dist|ance of |
|000059a0| 7a 65 72 6f 20 72 65 73 | 75 6c 74 73 20 69 6e 20 |zero res|ults in |
|000059b0| 6e 65 61 72 20 61 6e 64 | 20 64 69 73 74 61 6e 74 |near and| distant|
|000059c0| 20 6f 62 6a 65 63 74 73 | 20 61 70 70 65 61 72 69 | objects| appeari|
|000059d0| 6e 67 20 74 6f 20 62 65 | 20 74 68 65 20 73 61 6d |ng to be| the sam|
|000059e0| 65 20 73 69 7a 65 2e 0d | 36 30 20 69 73 20 74 68 |e size..|60 is th|
|000059f0| 65 20 68 69 67 68 65 73 | 74 20 76 61 6c 75 65 20 |e highes|t value |
|00005a00| 77 68 69 63 68 20 70 72 | 6f 64 75 63 65 73 20 6d |which pr|oduces m|
|00005a10| 65 61 6e 69 6e 67 66 75 | 6c 20 72 65 73 75 6c 74 |eaningfu|l result|
|00005a20| 73 2e 00 00 01 18 45 73 | 74 61 62 6c 69 73 68 65 |s.....Es|tablishe|
|00005a30| 73 20 77 68 61 74 20 70 | 65 72 63 65 6e 74 61 67 |s what p|ercentag|
|00005a40| 65 20 74 68 65 20 67 72 | 61 70 68 69 63 2d 6f 62 |e the gr|aphic-ob|
|00005a50| 6a 65 63 74 20 67 72 6f | 75 70 73 20 28 63 6f 6c |ject gro|ups (col|
|00005a60| 75 6d 6e 20 67 72 6f 75 | 70 73 20 65 74 63 2e 29 |umn grou|ps etc.)|
|00005a70| 20 77 69 6c 6c 20 66 69 | 6c 6c 20 6f 66 20 74 68 | will fi|ll of th|
|00005a80| 65 20 73 70 61 63 65 20 | 74 68 61 74 20 0d 69 73 |e space |that .is|
|00005a90| 20 61 76 61 69 6c 61 62 | 6c 65 20 66 6f 72 20 74 | availab|le for t|
|00005aa0| 68 65 6d 2e 0d 0d 54 68 | 69 73 20 61 6c 6c 6f 77 |hem...Th|is allow|
|00005ab0| 73 20 74 68 65 20 77 69 | 64 74 68 20 6f 66 20 74 |s the wi|dth of t|
|00005ac0| 68 65 20 6f 62 6a 65 63 | 74 20 67 72 6f 75 70 73 |he objec|t groups|
|00005ad0| 20 74 6f 20 62 65 20 63 | 68 61 6e 67 65 64 20 77 | to be c|hanged w|
|00005ae0| 69 74 68 6f 75 74 20 63 | 68 61 6e 67 69 6e 67 20 |ithout c|hanging |
|00005af0| 74 68 65 20 73 69 7a 65 | 20 6f 66 20 74 68 65 20 |the size| of the |
|00005b00| 67 72 61 70 68 20 6f 72 | 20 74 68 65 0d 73 69 7a |graph or| the.siz|
|00005b10| 65 20 6f 66 20 74 68 65 | 20 69 6e 64 69 76 69 64 |e of the| individ|
|00005b20| 75 61 6c 20 6f 62 6a 65 | 63 74 73 20 28 63 6f 6c |ual obje|cts (col|
|00005b30| 75 6d 6e 73 2c 20 65 74 | 63 2e 29 2e 20 20 00 00 |umns, et|c.). ..|
|00005b40| 00 d6 45 73 74 61 62 6c | 69 73 68 65 73 20 77 68 |..Establ|ishes wh|
|00005b50| 61 74 20 70 65 72 63 65 | 6e 74 61 67 65 20 74 68 |at perce|ntage th|
|00005b60| 65 20 69 6e 64 69 76 69 | 64 75 61 6c 20 6f 62 6a |e indivi|dual obj|
|00005b70| 65 63 74 20 28 63 6f 6c | 75 6d 20 65 74 63 2e 29 |ect (col|um etc.)|
|00005b80| 20 77 69 6c 6c 20 66 69 | 6c 6c 20 6f 66 20 74 68 | will fi|ll of th|
|00005b90| 65 20 73 70 61 63 65 20 | 74 68 61 74 0d 69 73 20 |e space |that.is |
|00005ba0| 61 76 61 69 6c 61 62 6c | 65 20 66 6f 72 20 69 74 |availabl|e for it|
|00005bb0| 2e 0d 0d 54 68 69 73 20 | 61 6c 6c 6f 77 73 20 74 |...This |allows t|
|00005bc0| 68 65 20 77 69 64 74 68 | 20 6f 66 20 74 68 65 20 |he width| of the |
|00005bd0| 69 6e 64 69 76 69 64 75 | 61 6c 20 6f 62 6a 65 63 |individu|al objec|
|00005be0| 74 73 20 74 6f 20 62 65 | 20 63 68 61 6e 67 65 64 |ts to be| changed|
|00005bf0| 20 77 69 74 68 6f 75 74 | 20 63 68 61 6e 67 69 6e | without| changin|
|00005c00| 67 20 74 68 65 20 73 69 | 7a 65 20 6f 66 20 74 68 |g the si|ze of th|
|00005c10| 65 20 67 72 61 70 68 2e | 00 00 01 1a 50 72 6f 76 |e graph.|....Prov|
|00005c20| 69 64 65 64 20 74 68 61 | 74 20 61 20 76 61 6c 75 |ided tha|t a valu|
|00005c30| 65 20 6c 61 72 67 65 72 | 20 74 68 61 6e 20 7a 65 |e larger| than ze|
|00005c40| 72 6f 20 69 73 20 67 69 | 76 65 6e 2c 20 74 68 65 |ro is gi|ven, the|
|00005c50| 20 44 45 50 54 48 20 6f | 70 74 69 6f 6e 20 65 73 | DEPTH o|ption es|
|00005c60| 74 61 62 6c 69 73 68 65 | 73 20 69 6e 20 77 68 69 |tablishe|s in whi|
|00005c70| 63 68 20 61 72 65 61 20 | 6f 66 20 74 68 69 73 20 |ch area |of this |
|00005c80| 64 65 70 74 68 0d 74 68 | 65 20 67 72 61 70 68 69 |depth.th|e graphi|
|00005c90| 63 20 6f 62 6a 65 63 74 | 73 20 28 63 6f 6c 75 6d |c object|s (colum|
|00005ca0| 6e 73 20 65 74 63 2e 20 | 29 20 77 69 6c 6c 20 6c |ns etc. |) will l|
|00005cb0| 69 65 2e 0d 0d 49 74 20 | 69 73 20 69 6d 70 6f 72 |ie...It |is impor|
|00005cc0| 74 61 6e 74 20 74 6f 20 | 6e 6f 74 65 20 68 65 72 |tant to |note her|
|00005cd0| 65 20 74 68 61 74 20 74 | 68 65 20 69 6e 73 65 72 |e that t|he inser|
|00005ce0| 74 65 64 20 76 61 6c 75 | 65 20 6d 75 73 74 20 62 |ted valu|e must b|
|00005cf0| 65 20 62 65 74 77 65 65 | 6e 20 7a 65 72 6f 20 61 |e betwee|n zero a|
|00005d00| 6e 64 20 74 68 65 20 64 | 65 70 74 68 20 76 61 6c |nd the d|epth val|
|00005d10| 75 65 2c 20 69 66 20 74 | 68 65 0d 20 44 45 50 54 |ue, if t|he. DEPT|
|00005d20| 48 20 66 75 6e 63 74 69 | 6f 6e 20 69 73 20 74 6f |H functi|on is to|
|00005d30| 20 77 6f 72 6b 2e 00 00 | 00 e2 53 68 69 66 74 73 | work...|..Shifts|
|00005d40| 20 73 79 6d 62 6f 6c 73 | 20 6f 66 20 73 79 6d 62 | symbols| of symb|
|00005d50| 6f 6c 2d 67 72 61 70 68 | 69 63 73 2e 0d 50 6f 73 |ol-graph|ics..Pos|
|00005d60| 69 74 69 76 65 20 76 61 | 6c 75 65 73 20 6c 65 61 |itive va|lues lea|
|00005d70| 64 20 74 6f 20 61 20 73 | 68 69 66 74 20 75 70 20 |d to a s|hift up |
|00005d80| 61 6e 64 20 74 6f 20 74 | 68 65 20 72 69 67 68 74 |and to t|he right|
|00005d90| 2c 20 61 6e 64 20 6e 65 | 67 61 74 69 76 65 20 76 |, and ne|gative v|
|00005da0| 61 6c 75 65 73 20 76 69 | 63 65 2d 76 65 72 73 61 |alues vi|ce-versa|
|00005db0| 2e 0d 0d 49 6e 20 61 6c | 6c 20 6f 74 68 65 72 20 |...In al|l other |
|00005dc0| 67 72 61 70 68 69 63 20 | 74 79 70 65 73 2c 20 70 |graphic |types, p|
|00005dd0| 72 6f 76 69 64 65 64 20 | 74 68 61 74 20 74 68 65 |rovided |that the|
|00005de0| 20 6f 70 74 69 6f 6e 20 | 56 41 4c 55 45 53 20 69 | option |VALUES i|
|00005df0| 73 20 73 65 6c 65 63 74 | 65 64 2c 20 74 68 65 20 |s select|ed, the |
|00005e00| 64 69 73 70 6c 61 79 65 | 64 20 76 61 6c 75 65 73 |displaye|d values|
|00005e10| 20 77 69 6c 6c 20 73 68 | 69 66 74 2e 00 00 01 42 | will sh|ift....B|
|00005e20| 45 73 74 61 62 6c 69 73 | 68 65 73 20 74 68 65 20 |Establis|hes the |
|00005e30| 63 6f 6c 75 6d 6e 20 61 | 6e 64 20 74 68 65 20 72 |column a|nd the r|
|00005e40| 6f 77 2c 20 69 6e 20 77 | 68 69 63 68 20 74 68 65 |ow, in w|hich the|
|00005e50| 20 75 70 70 65 72 20 6c | 65 66 74 2d 68 61 6e 64 | upper l|eft-hand|
|00005e60| 20 63 6f 72 6e 65 72 20 | 6f 66 20 74 68 65 20 61 | corner |of the a|
|00005e70| 64 64 69 74 69 6f 6e 61 | 6c 0d 69 6e 66 6f 72 6d |dditiona|l.inform|
|00005e80| 61 74 69 6f 6e 20 66 6f | 72 20 74 68 65 20 67 72 |ation fo|r the gr|
|00005e90| 61 70 68 20 63 61 6e 20 | 62 65 20 66 6f 75 6e 64 |aph can |be found|
|00005ea0| 2e 20 20 0d 54 68 69 73 | 20 63 6f 6e 73 69 73 74 |. .This| consist|
|00005eb0| 73 20 6f 66 20 74 77 6f | 20 72 6f 77 73 20 61 6e |s of two| rows an|
|00005ec0| 64 20 74 68 72 65 65 20 | 63 6f 6c 75 6d 6e 73 2e |d three |columns.|
|00005ed0| 0d 0d 54 68 65 20 63 6f | 6c 75 6d 6e 73 20 67 69 |..The co|lumns gi|
|00005ee0| 76 65 20 74 68 65 20 6d | 69 6e 69 6d 75 6d 20 61 |ve the m|inimum a|
|00005ef0| 6e 64 20 6d 61 78 69 6d | 75 6d 20 66 6f 72 20 74 |nd maxim|um for t|
|00005f00| 68 65 20 78 2d 2c 20 20 | 79 2d 20 61 6e 64 20 7a |he x-, |y- and z|
|00005f10| 2d 61 78 65 73 20 72 65 | 73 70 65 63 74 69 76 65 |-axes re|spective|
|00005f20| 6c 79 2e 0d 54 68 65 20 | 66 69 72 73 74 20 72 6f |ly..The |first ro|
|00005f30| 77 20 63 6f 6e 74 61 69 | 6e 73 20 74 68 65 20 6d |w contai|ns the m|
|00005f40| 69 6e 69 6d 75 6d 2c 20 | 74 68 65 20 73 65 63 6f |inimum, |the seco|
|00005f50| 6e 64 20 74 68 65 20 6d | 61 78 69 6d 75 6d 2e 0d |nd the m|aximum..|
|00005f60| 0d 0d 00 00 00 ca 54 68 | 65 20 7a 65 72 6f 20 74 |......Th|e zero t|
|00005f70| 68 72 65 73 68 68 6f 6c | 64 20 64 65 74 65 72 6d |hreshhol|d determ|
|00005f80| 69 6e 65 73 20 69 66 20 | 74 68 65 20 76 61 6c 75 |ines if |the valu|
|00005f90| 65 20 5a 45 52 4f 20 69 | 73 20 69 6e 63 6c 75 64 |e ZERO i|s includ|
|00005fa0| 65 64 20 69 6e 20 74 68 | 65 20 79 2d 61 78 69 73 |ed in th|e y-axis|
|00005fb0| 20 76 61 6c 75 65 73 2e | 0d 0d 49 66 20 61 20 68 | values.|..If a h|
|00005fc0| 69 67 68 65 72 20 76 61 | 6c 75 65 20 69 73 20 63 |igher va|lue is c|
|00005fd0| 68 6f 73 65 6e 20 66 6f | 72 20 74 68 65 20 7a 65 |hosen fo|r the ze|
|00005fe0| 72 6f 20 74 68 72 65 73 | 68 68 6f 6c 64 2c 20 69 |ro thres|hhold, i|
|00005ff0| 74 20 69 73 20 6d 6f 72 | 65 20 6c 69 6b 65 6c 79 |t is mor|e likely|
|00006000| 20 74 68 61 74 20 74 68 | 65 20 7a 65 72 6f 20 69 | that th|e zero i|
|00006010| 73 20 69 6e 63 6c 75 64 | 65 64 0d 69 6e 20 74 68 |s includ|ed.in th|
|00006020| 65 20 79 2d 61 78 69 73 | 20 76 61 6c 75 65 73 2e |e y-axis| values.|
|00006030| 00 00 00 00 00 00 00 c5 | 45 73 74 61 62 6c 69 73 |........|Establis|
|00006040| 68 65 73 20 61 20 70 72 | 65 66 69 78 2e 0d 41 20 |hes a pr|efix..A |
|00006050| 70 72 65 66 69 78 20 69 | 73 20 61 20 74 65 78 74 |prefix i|s a text|
|00006060| 2c 20 74 68 61 74 20 69 | 73 20 67 69 76 65 6e 20 |, that i|s given |
|00006070| 62 65 66 6f 72 65 20 74 | 68 65 20 63 6f 6e 74 65 |before t|he conte|
|00006080| 6e 74 20 6f 66 20 61 20 | 63 65 6c 6c 2e 0d 0d 41 |nt of a |cell...A|
|00006090| 20 63 68 61 6e 67 65 20 | 61 66 66 65 63 74 73 20 | change |affects |
|000060a0| 61 6c 6c 20 65 71 75 61 | 6c 20 70 72 65 66 69 78 |all equa|l prefix|
|000060b0| 65 73 2e 0d 57 68 65 6e | 20 5c 35 20 69 73 20 67 |es..When| \5 is g|
|000060c0| 69 76 65 6e 2c 20 74 68 | 65 20 66 69 76 65 20 6c |iven, th|e five l|
|000060d0| 65 61 64 69 6e 67 20 63 | 68 61 72 61 63 74 65 72 |eading c|haracter|
|000060e0| 73 20 6f 66 20 74 68 65 | 20 63 65 6c 6c 20 61 72 |s of the| cell ar|
|000060f0| 65 20 65 6c 69 6d 69 6e | 61 74 65 64 0d 00 00 00 |e elimin|ated....|
|00006100| c1 45 73 74 61 62 6c 69 | 73 68 65 73 20 61 20 73 |.Establi|shes a s|
|00006110| 75 66 66 69 78 2e 0d 41 | 20 73 75 66 66 69 78 20 |uffix..A| suffix |
|00006120| 69 73 20 61 20 74 65 78 | 74 2c 20 74 68 61 74 20 |is a tex|t, that |
|00006130| 69 73 20 67 69 76 65 6e | 20 61 66 74 65 72 20 74 |is given| after t|
|00006140| 68 65 20 63 6f 6e 74 65 | 6e 74 20 6f 66 20 61 20 |he conte|nt of a |
|00006150| 63 65 6c 6c 2e 0d 0d 41 | 20 63 68 61 6e 67 65 20 |cell...A| change |
|00006160| 61 66 66 65 63 74 73 20 | 61 6c 6c 20 65 71 75 61 |affects |all equa|
|00006170| 6c 20 70 72 65 66 69 78 | 65 73 2e 0d 57 68 65 6e |l prefix|es..When|
|00006180| 20 5c 35 20 69 73 20 67 | 69 76 65 6e 2c 20 74 68 | \5 is g|iven, th|
|00006190| 65 20 6c 61 73 74 20 66 | 69 76 65 20 20 63 68 61 |e last f|ive cha|
|000061a0| 72 61 63 74 65 72 73 20 | 6f 66 20 74 68 65 20 63 |racters |of the c|
|000061b0| 65 6c 6c 20 61 72 65 20 | 65 6c 69 6d 69 6e 61 74 |ell are |eliminat|
|000061c0| 65 64 00 00 01 16 49 66 | 20 74 68 69 73 20 6f 70 |ed....If| this op|
|000061d0| 74 69 6f 6e 20 69 73 20 | 73 65 6c 65 63 74 65 64 |tion is |selected|
|000061e0| 2c 20 61 20 6e 65 77 20 | 63 61 6c 63 75 6c 61 74 |, a new |calculat|
|000061f0| 69 6f 6e 20 77 69 6c 6c | 20 66 6f 6c 6c 6f 77 2e |ion will| follow.|
|00006200| 0d 0d 53 74 6f 72 65 20 | 41 6c 6c 3a 0d 49 66 20 |..Store |All:.If |
|00006210| 74 68 65 20 63 61 6c 63 | 75 6c 61 74 69 6f 6e 20 |the calc|ulation |
|00006220| 69 73 20 63 61 6e 63 65 | 6c 6c 65 64 20 64 75 72 |is cance|lled dur|
|00006230| 69 6e 67 20 70 68 61 73 | 65 20 6f 6e 65 2c 20 69 |ing phas|e one, i|
|00006240| 74 20 6d 75 73 74 20 62 | 65 20 72 65 70 65 61 74 |t must b|e repeat|
|00006250| 65 64 2e 0d 49 66 20 74 | 68 65 20 63 61 6c 63 75 |ed..If t|he calcu|
|00006260| 6c 61 74 69 6f 6e 20 69 | 73 20 63 61 6e 63 65 6c |lation i|s cancel|
|00006270| 6c 65 64 20 64 75 72 69 | 6e 67 20 70 68 61 73 65 |led duri|ng phase|
|00006280| 20 74 77 6f 2c 20 69 74 | 20 63 61 6e 20 62 65 20 | two, it| can be |
|00006290| 72 65 73 75 6d 65 64 20 | 62 79 20 70 72 65 73 73 |resumed |by press|
|000062a0| 69 6e 67 20 11 32 2e 0d | 0d 53 74 6f 72 65 20 46 |ing .2..|.Store F|
|000062b0| 6c 65 78 69 62 6c 65 3a | 0d 41 6c 6c 20 73 74 6f |lexible:|.All sto|
|000062c0| 72 65 64 20 72 65 73 75 | 6c 74 73 20 77 69 6c 6c |red resu|lts will|
|000062d0| 20 62 65 20 64 65 6c 65 | 74 65 64 2e 00 00 00 7f | be dele|ted.....|
|000062e0| 53 74 61 72 74 73 20 61 | 20 6e 65 77 20 63 61 6c |Starts a| new cal|
|000062f0| 63 75 6c 61 74 69 6f 6e | 2e 0d 54 68 69 73 20 6f |culation|..This o|
|00006300| 70 74 69 6f 6e 20 69 73 | 20 6f 6e 6c 79 20 61 63 |ption is| only ac|
|00006310| 63 65 73 73 69 62 6c 65 | 2c 20 69 6e 20 74 68 65 |cessible|, in the|
|00006320| 20 65 76 65 6e 74 20 74 | 68 61 74 20 74 68 65 20 | event t|hat the |
|00006330| 53 74 6f 72 65 20 41 6c | 6c 20 6f 72 20 53 74 6f |Store Al|l or Sto|
|00006340| 72 65 20 46 6c 65 78 69 | 62 6c 65 0d 6f 70 74 69 |re Flexi|ble.opti|
|00006350| 6f 6e 20 69 73 20 73 65 | 6c 65 63 74 65 64 2e 00 |on is se|lected..|
|00006360| 00 00 f2 41 20 6e 65 77 | 20 63 61 6c 63 75 6c 61 |...A new| calcula|
|00006370| 74 69 6f 6e 20 66 6f 6c | 6c 6f 77 73 2e 0d 0d 53 |tion fol|lows...S|
|00006380| 74 6f 72 65 20 41 6c 6c | 3a 0d 49 66 20 74 68 65 |tore All|:.If the|
|00006390| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 20 69 73 20 | calcula|tion is |
|000063a0| 63 61 6e 63 65 6c 6c 65 | 64 20 64 75 72 69 6e 67 |cancelle|d during|
|000063b0| 20 70 68 61 73 65 20 6f | 6e 65 2c 20 69 74 20 6d | phase o|ne, it m|
|000063c0| 75 73 74 20 62 65 20 72 | 65 70 65 61 74 65 64 2e |ust be r|epeated.|
|000063d0| 0d 49 66 20 74 68 65 20 | 63 61 6c 63 75 6c 61 74 |.If the |calculat|
|000063e0| 69 6f 6e 20 69 73 20 63 | 61 6e 63 65 6c 6c 65 64 |ion is c|ancelled|
|000063f0| 20 64 75 72 69 6e 67 20 | 70 68 61 73 65 20 74 77 | during |phase tw|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
