/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.iso / More Information / MacProject II / Sort Script

< prev

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 0b 53 6f 72 74 20 53 | 63 72 69 70 74 00 00 00 |..Sort S|cript...|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|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 52 73 53 63 52 73 6c | 76 01 00 00 00 00 00 00 |.RsScRsl|v.......|
|00000050| 00 00 00 00 00 4e 8c 00 | 00 01 ba a4 58 08 a0 a4 |.....N..|....X...|
|00000060| 58 08 a0 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |X.......|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 ad 62 00 00 |........|.....b..|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 a7 3f 00 00 |BAT_BTSC|0101.?..|
|00000090| 8d 0e 00 00 d9 0d 00 00 | d9 0d 00 00 d9 0d 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 0a 00 07 00 |........|........|
|000000d0| 11 00 00 00 00 00 00 00 | 18 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 f4 00 00 fd 04 1b 00 | 00 1b 00 00 00 f9 f2 19 |........|........|
|000000f0| 00 1b 00 00 01 f9 f8 1b | 00 00 02 f9 f8 fd 04 1b |........|........|
|00000100| 00 01 1b 00 00 03 f9 f8 | fc f6 00 00 fd 06 00 00 |........|........|
|00000110| 00 00 00 fd 0e 08 01 01 | 01 01 07 07 00 00 00 00 |........|........|
|00000120| ff 00 fd 15 00 06 00 10 | 4d 50 20 50 72 6f 6a 65 |........|MP Proje|
|00000130| 63 74 20 54 61 62 6c 65 | fe 40 18 00 00 00 00 00 |ct Table|.@......|
|00000140| 00 00 00 39 f2 14 00 fd | 04 1a 04 01 18 00 00 00 |...9....|........|
|00000150| 00 00 00 f0 3f fa 1d 0c | 00 18 00 00 00 00 00 00 |....?...|........|
|00000160| 00 00 fa fb f6 00 00 1b | 00 00 04 f9 f4 00 08 fd |........|........|
|00000170| 31 08 01 01 01 01 2a 18 | 00 00 00 00 00 00 f0 3f |1.....*.|.......?|
|00000180| 18 00 00 00 00 00 00 f0 | 3f 18 00 00 00 00 00 80 |........|?.......|
|00000190| 4f 40 1a 00 08 2b 00 00 | 00 00 00 00 f0 3f d8 ff |O@...+..|.....?..|
|000001a0| 00 fd 09 0f 0a 00 04 54 | 4c 42 52 fd 0f 0f 03 01 |.......T|LBR.....|
|000001b0| 00 09 48 65 6c 76 65 74 | 69 63 61 fd 07 19 01 01 |..Helvet|ica.....|
|000001c0| 02 c0 06 fd 0e 08 01 01 | 01 01 07 07 00 00 00 00 |........|........|
|000001d0| ff 00 fd 07 19 01 01 02 | e0 10 fd 31 08 01 01 01 |........|...1....|
|000001e0| 01 2a 18 00 00 00 00 00 | 00 28 40 18 00 00 00 00 |.*......|.(@.....|
|000001f0| 00 00 f0 3f 18 00 00 00 | 00 00 00 31 40 1a 00 08 |...?....|...1@...|
|00000200| 2b 00 00 00 00 00 00 f0 | 3f d8 ff 00 fd 05 0f 05 |+.......|?.......|
|00000210| 00 20 fd 06 0f 05 02 01 | 09 fd 13 08 01 01 01 01 |. ......|........|
|00000220| 0c 08 0f 00 00 00 00 00 | 00 ff 7f ff 00 fd 02 0c |........|........|
|00000230| fd 07 19 00 01 02 b0 01 | fd 0d 0f 03 00 03 00 00 |........|........|
|00000240| 00 00 00 a0 6b 41 fd 07 | 0f 03 02 02 09 00 fd 0f |....kA..|........|
|00000250| 0f 03 01 00 09 48 65 6c | 76 65 74 69 63 61 fd 07 |.....Hel|vetica..|
|00000260| 0f 03 03 00 01 42 fd 07 | 0f 03 03 00 01 49 fd 04 |.....B..|.....I..|
|00000270| 0f 04 02 fd 10 17 00 04 | 4e 61 6d 65 01 07 07 00 |........|Name....|
|00000280| 00 00 00 ff fd 13 17 00 | 07 54 61 73 6b 20 49 44 |........|.Task ID|
|00000290| 01 07 07 00 00 01 00 ff | fd 14 17 00 08 53 75 62 |........|.....Sub|
|000002a0| 74 69 74 6c 65 01 07 07 | 00 00 02 00 ff fd 1a 17 |title...|........|
|000002b0| 00 0e 45 61 72 6c 69 65 | 73 74 20 53 74 61 72 74 |..Earlie|st Start|
|000002c0| 01 07 07 00 00 03 00 ff | fd 1b 17 00 0f 45 61 72 |........|.....Ear|
|000002d0| 6c 69 65 73 74 20 46 69 | 6e 69 73 68 01 07 07 00 |liest Fi|nish....|
|000002e0| 00 04 00 ff fd 18 17 00 | 0c 4c 61 74 65 73 74 20 |........|.Latest |
|000002f0| 53 74 61 72 74 01 07 07 | 00 00 05 00 ff fd 19 17 |Start...|........|
|00000300| 00 0d 4c 61 74 65 73 74 | 20 46 69 6e 69 73 68 01 |..Latest| Finish.|
|00000310| 07 07 00 00 06 00 ff fd | 11 17 00 05 53 6c 61 63 |........|....Slac|
|00000320| 6b 01 07 07 00 00 07 00 | ff fd 18 17 00 0c 41 63 |k.......|......Ac|
|00000330| 74 75 61 6c 20 53 74 61 | 72 74 01 07 07 00 00 08 |tual Sta|rt......|
|00000340| 00 ff fd 19 17 00 0d 41 | 63 74 75 61 6c 20 46 69 |.......A|ctual Fi|
|00000350| 6e 69 73 68 01 07 07 00 | 00 09 00 ff fd 12 17 00 |nish....|........|
|00000360| 06 25 20 44 6f 6e 65 01 | 07 07 00 00 0a 00 ff fd |.% Done.|........|
|00000370| 16 17 00 0a 46 69 78 65 | 64 20 43 6f 73 74 01 07 |....Fixe|d Cost..|
|00000380| 07 00 00 0b 00 ff fd 19 | 17 00 0d 52 65 73 6f 75 |........|...Resou|
|00000390| 72 63 65 20 43 6f 73 74 | 01 07 07 00 00 0c 00 ff |rce Cost|........|
|000003a0| fd 18 17 00 0c 46 69 78 | 65 64 20 49 6e 63 6f 6d |.....Fix|ed Incom|
|000003b0| 65 01 07 07 00 00 0d 00 | ff fd 17 17 00 0b 41 63 |e.......|......Ac|
|000003c0| 74 75 61 6c 20 43 6f 73 | 74 01 07 07 00 00 0e 00 |tual Cos|t.......|
|000003d0| ff fd 1a 17 00 0e 41 63 | 74 2e 20 52 65 73 2e 20 |......Ac|t. Res. |
|000003e0| 43 6f 73 74 01 07 07 00 | 00 0f 00 ff fd 19 17 00 |Cost....|........|
|000003f0| 0d 41 63 74 75 61 6c 20 | 49 6e 63 6f 6d 65 01 07 |.Actual |Income..|
|00000400| 07 00 00 10 00 ff fd 10 | 17 00 04 54 79 70 65 01 |........|...Type.|
|00000410| 07 07 00 00 11 00 ff fd | 16 17 00 0a 53 75 62 70 |........|....Subp|
|00000420| 72 6f 6a 65 63 74 01 07 | 07 00 00 12 00 ff fd 10 |roject..|........|
|00000430| 17 00 04 44 61 79 73 01 | 07 07 00 00 13 00 ff fd |...Days.|........|
|00000440| 17 17 00 0b 41 63 74 75 | 61 6c 20 44 61 79 73 01 |....Actu|al Days.|
|00000450| 07 07 00 00 14 00 ff fd | 18 17 00 0c 45 6c 61 70 |........|....Elap|
|00000460| 73 65 64 20 54 69 6d 65 | 01 07 07 00 00 15 00 ff |sed Time|........|
|00000470| fd 1d 17 00 11 4c 65 76 | 65 6c 69 6e 67 20 50 72 |.....Lev|eling Pr|
|00000480| 69 6f 72 69 74 79 01 07 | 07 00 00 16 00 ff 18 00 |iority..|........|
|00000490| 00 00 00 00 00 37 40 f4 | 00 09 18 00 00 00 00 00 |.....7@.|........|
|000004a0| 00 4d 40 18 00 00 00 00 | 00 00 14 40 1d 1c 00 18 |.M@.....|...@....|
|000004b0| 00 00 00 00 00 00 4d 40 | 18 00 00 00 00 00 00 14 |......M@|........|
|000004c0| 40 f7 1a 00 09 2e f4 00 | 09 1a 00 09 f5 c7 00 fd |@.......|........|
|000004d0| 26 17 00 08 52 65 73 6f | 75 72 63 65 01 19 1a 00 |&...Reso|urce....|
|000004e0| 09 2a 00 00 00 00 00 00 | f0 3f 18 00 00 00 00 00 |.*......|.?......|
|000004f0| 00 f0 3f d4 d3 ff fd 27 | 17 00 09 57 6f 72 6b 2d |..?....'|...Work-|
|00000500| 44 61 79 73 01 19 1a 00 | 09 2a 00 00 00 00 00 00 |Days....|.*......|
|00000510| 00 40 18 00 00 00 00 00 | 00 f0 3f d4 d3 ff fd 24 |.@......|..?....$|
|00000520| 17 00 06 4e 75 6d 62 65 | 72 01 19 1a 00 09 2a 00 |...Numbe|r.....*.|
|00000530| 00 00 00 00 00 08 40 18 | 00 00 00 00 00 00 f0 3f |......@.|.......?|
|00000540| d4 d3 ff fd 26 17 00 08 | 25 20 45 66 66 6f 72 74 |....&...|% Effort|
|00000550| 01 19 1a 00 09 2a 00 00 | 00 00 00 00 10 40 18 00 |.....*..|.....@..|
|00000560| 00 00 00 00 00 f0 3f d4 | d3 ff fd 26 17 00 08 44 |......?.|...&...D|
|00000570| 75 72 61 74 69 6f 6e 01 | 19 1a 00 09 2a 00 00 00 |uration.|....*...|
|00000580| 00 00 00 14 40 18 00 00 | 00 00 00 00 f0 3f d4 d3 |....@...|.....?..|
|00000590| ff 1d 1d ff fd 13 08 01 | 01 01 01 0c 08 0f 00 00 |........|........|
|000005a0| ff 7f 03 00 06 00 ff 00 | fd 06 0f 05 00 50 81 fd |........|.....P..|
|000005b0| 13 08 01 01 01 01 0c 08 | 0f 00 00 ff 7f 08 00 09 |........|........|
|000005c0| 00 ff 00 fd 06 0f 05 00 | 50 81 fd 13 08 01 01 01 |........|P.......|
|000005d0| 01 0c 08 0f 00 00 ff 7f | 00 00 00 00 ff 00 fd 02 |........|........|
|000005e0| 0c fd 04 08 01 07 fd 05 | 1a 05 00 0d fd 05 1a 05 |........|........|
|000005f0| 00 04 fd 05 1a 05 00 03 | fd 05 1a 05 00 05 18 00 |........|........|
|00000600| 00 00 00 00 00 00 40 f4 | 00 09 18 00 00 00 00 00 |......@.|........|
|00000610| 00 10 40 18 00 00 00 00 | 00 00 f0 3f 1d 1c 00 18 |..@.....|...?....|
|00000620| 00 00 00 00 00 00 10 40 | 18 00 00 00 00 00 00 f0 |.......@|........|
|00000630| 3f f7 1a 00 09 2e f4 00 | 09 1a 00 09 f5 1a 00 fd |?.......|........|
|00000640| 14 17 81 01 10 18 00 00 | 00 00 00 40 50 40 1a 00 |........|...@P@..|
|00000650| 09 d4 d3 ff 1d ca ff 18 | 00 00 00 00 00 00 14 40 |........|.......@|
|00000660| f4 00 09 18 00 00 00 00 | 00 00 1c 40 18 00 00 00 |........|...@....|
|00000670| 00 00 00 f0 3f 1d 1c 00 | 18 00 00 00 00 00 00 1c |....?...|........|
|00000680| 40 18 00 00 00 00 00 00 | f0 3f f7 1a 00 09 2e f4 |@.......|.?......|
|00000690| 00 09 1a 00 09 f5 1a 00 | fd 14 17 80 01 10 18 00 |........|........|
|000006a0| 00 00 00 00 40 50 40 1a | 00 09 d4 d3 ff 1d ca ff |....@P@.|........|
|000006b0| fd 10 17 01 05 1a 00 08 | ff 01 07 07 07 00 40 00 |........|......@.|
|000006c0| ff fd 17 08 01 01 01 01 | 10 19 0c 52 32 43 36 35 |........|...R2C65|
|000006d0| 2e 2e 52 38 43 36 35 ff | 00 fd 06 0f 05 02 01 0b |..R8C65.|........|
|000006e0| fd 0d 08 01 01 01 01 06 | 19 02 41 31 ff 00 fd 04 |........|..A1....|
|000006f0| 08 01 07 fb f6 00 00 fd | 04 08 01 05 18 00 00 00 |........|........|
|00000700| 00 00 00 f0 3f fe 19 d1 | 2a 00 00 00 00 00 00 f0 |....?...|*.......|
|00000710| 3f fa fb f6 00 00 fd 41 | 1e 00 01 00 07 53 6f 72 |?......A|.....Sor|
|00000720| 74 2e 2e 2e 00 01 01 31 | 08 0f 01 00 02 00 00 00 |t......1|........|
|00000730| 00 00 18 00 00 00 00 00 | 00 00 00 18 00 00 00 00 |........|........|
|00000740| 00 00 45 40 18 00 00 00 | 00 00 40 5f 40 18 00 00 |..E@....|..@_@...|
|00000750| 00 00 00 20 6b 40 e3 ff | fd 75 21 03 00 00 6f 4f |... k@..|.u!...oO|
|00000760| 4e 20 4d 4f 55 53 45 55 | 50 0d 09 47 45 54 20 53 |N MOUSEU|P..GET S|
|00000770| 43 52 49 50 54 20 22 53 | 6f 72 74 20 53 63 72 69 |CRIPT "S|ort Scri|
|00000780| 70 74 22 0d 09 43 41 4c | 4c 20 27 53 6f 72 74 20 |pt"..CAL|L 'Sort |
|00000790| 53 63 72 69 70 74 3a 53 | 4f 52 54 5f 44 49 41 4c |Script:S|ORT_DIAL|
|000007a0| 4f 47 27 28 29 0d 09 52 | 45 4d 4f 56 45 20 53 43 |OG'()..R|EMOVE SC|
|000007b0| 52 49 50 54 20 22 53 6f | 72 74 20 53 63 72 69 70 |RIPT "So|rt Scrip|
|000007c0| 74 22 0d 45 4e 44 20 4d | 4f 55 53 45 55 50 fd 0e |t".END M|OUSEUP..|
|000007d0| 08 01 01 01 01 07 07 00 | 00 00 00 ff 00 fd 07 19 |........|........|
|000007e0| 01 01 02 c0 06 fb f6 00 | 00 19 05 52 38 43 36 35 |........|...R8C65|
|000007f0| d2 f4 00 08 fd 12 1d 00 | 00 00 02 ff ff 02 ff ff |........|........|
|00000800| 00 02 50 19 02 78 0f fd | 24 1e 00 01 00 0e 20 20 |..P..x..|$.....  |
|00000810| 20 20 43 61 6e 63 65 6c | 20 20 20 20 00 00 00 02 |  Cancel|    ....|
|00000820| 40 0b 02 38 0d 01 02 a0 | 05 02 68 01 fd 20 1e 00 |@..8....|..h.. ..|
|00000830| 01 00 0a 20 20 20 20 4f | 4b 20 20 20 20 00 00 00 |...    O|K    ...|
|00000840| 02 48 12 02 38 0d 01 02 | a0 05 02 68 01 fd 06 1d |.H..8...|...h....|
|00000850| 0b 01 81 00 fd 03 1d 09 | fd 1c 21 03 00 00 16 27 |........|..!....'|
|00000860| 53 6f 72 74 20 53 63 72 | 69 70 74 3a 64 6f 6e 65 |Sort Scr|ipt:done|
|00000870| 27 20 3d 20 30 fd 06 1d | 0b 01 82 00 fd 03 1d 08 |' = 0...|........|
|00000880| fd eb 21 03 00 00 e5 0d | 09 09 27 53 6f 72 74 20 |..!.....|..'Sort |
|00000890| 53 63 72 69 70 74 3a 66 | 6b 27 20 3d 20 43 54 56 |Script:f|k' = CTV|
|000008a0| 41 4c 55 45 28 34 3b 30 | 29 0d 09 09 27 53 6f 72 |ALUE(4;0|)...'Sor|
|000008b0| 74 20 53 63 72 69 70 74 | 3a 73 6b 27 20 3d 20 43 |t Script|:sk' = C|
|000008c0| 54 56 41 4c 55 45 28 35 | 3b 30 29 0d 09 09 27 53 |TVALUE(5|;0)...'S|
|000008d0| 6f 72 74 20 53 63 72 69 | 70 74 3a 74 6b 27 20 3d |ort Scri|pt:tk' =|
|000008e0| 20 43 54 56 41 4c 55 45 | 28 36 3b 30 29 0d 09 09 | CTVALUE|(6;0)...|
|000008f0| 27 53 6f 72 74 20 53 63 | 72 69 70 74 3a 6d 31 27 |'Sort Sc|ript:m1'|
|00000900| 20 3d 20 43 54 56 41 4c | 55 45 28 37 3b 31 29 0d | = CTVAL|UE(7;1).|
|00000910| 09 09 27 53 6f 72 74 20 | 53 63 72 69 70 74 3a 6d |..'Sort |Script:m|
|00000920| 32 27 20 3d 20 43 54 56 | 41 4c 55 45 28 37 3b 32 |2' = CTV|ALUE(7;2|
|00000930| 29 0d 09 09 27 53 6f 72 | 74 20 53 63 72 69 70 74 |)...'Sor|t Script|
|00000940| 3a 6d 33 27 20 3d 20 43 | 54 56 41 4c 55 45 28 37 |:m3' = C|TVALUE(7|
|00000950| 3b 33 29 0d 09 09 27 53 | 6f 72 74 20 53 63 72 69 |;3)...'S|ort Scri|
|00000960| 70 74 3a 64 6f 6e 65 27 | 20 3d 20 31 fd 18 1e 0b |pt:done'| = 1....|
|00000970| 00 04 53 6f 72 74 00 00 | 02 b4 00 02 b4 00 01 02 |..Sort..|........|
|00000980| 80 16 02 a0 05 fd 06 0f | 02 00 1c 00 fd 59 1e 09 |........|.....Y..|
|00000990| 01 00 09 54 61 73 6b 20 | 4e 61 6d 65 01 00 0e 45 |...Task |Name...E|
|000009a0| 61 72 6c 69 65 73 74 20 | 53 74 61 72 74 01 00 0c |arliest |Start...|
|000009b0| 41 63 74 75 61 6c 20 53 | 74 61 72 74 01 00 06 25 |Actual S|tart...%|
|000009c0| 20 44 6f 6e 65 01 00 08 | 53 75 62 74 69 74 6c 65 | Done...|Subtitle|
|000009d0| 00 00 00 02 e8 05 03 01 | 00 00 00 00 c0 88 40 01 |........|......@.|
|000009e0| 02 b8 08 02 68 01 fd 0e | 1e 52 01 0a 19 05 52 32 |....h...|.R....R2|
|000009f0| 43 36 35 d2 ff fd 59 1e | 09 01 00 09 54 61 73 6b |C65...Y.|....Task|
|00000a00| 20 4e 61 6d 65 01 00 0e | 45 61 72 6c 69 65 73 74 | Name...|Earliest|
|00000a10| 20 53 74 61 72 74 01 00 | 0c 41 63 74 75 61 6c 20 | Start..|.Actual |
|00000a20| 53 74 61 72 74 01 00 06 | 25 20 44 6f 6e 65 01 00 |Start...|% Done..|
|00000a30| 08 53 75 62 74 69 74 6c | 65 00 00 00 02 e8 05 03 |.Subtitl|e.......|
|00000a40| ff ff ff ff ff df 99 40 | 01 02 b8 08 02 68 01 fd |.......@|.....h..|
|00000a50| 0e 1e 52 01 0a 19 05 52 | 33 43 36 35 d2 ff fd 53 |..R....R|3C65...S|
|00000a60| 1e 09 01 00 09 54 61 73 | 6b 20 4e 61 6d 65 01 00 |.....Tas|k Name..|
|00000a70| 0e 45 61 72 6c 69 65 73 | 74 20 53 74 61 72 74 01 |.Earlies|t Start.|
|00000a80| 00 0c 41 63 74 75 61 6c | 20 53 74 61 72 74 01 00 |..Actual| Start..|
|00000a90| 06 25 20 44 6f 6e 65 01 | 00 08 53 75 62 74 69 74 |.% Done.|..Subtit|
|00000aa0| 6c 65 00 00 00 02 e8 05 | 02 d8 09 01 02 b8 08 02 |le......|........|
|00000ab0| 68 01 fd 0e 1e 52 01 0a | 19 05 52 34 43 36 35 d2 |h....R..|..R4C65.|
|00000ac0| ff fd 46 1e 03 01 00 0a | 44 65 73 63 65 6e 64 69 |..F.....|Descendi|
|00000ad0| 6e 67 01 00 0a 44 65 73 | 63 65 6e 64 69 6e 67 01 |ng...Des|cending.|
|00000ae0| 00 0a 44 65 73 63 65 6e | 64 69 6e 67 00 00 00 02 |..Descen|ding....|
|00000af0| 78 0f 03 01 00 00 00 00 | c0 88 40 01 02 70 08 03 |x.......|..@..p..|
|00000b00| 33 33 33 33 33 f3 9f 40 | fd 06 0f 02 00 1c 00 19 |33333..@|........|
|00000b10| 05 52 35 43 36 35 d2 18 | 00 00 00 00 00 00 f0 3f |.R5C65..|.......?|
|00000b20| 39 f2 0a 00 fd 04 1e 24 | 81 1d 07 00 fd 04 1e 23 |9......$|.......#|
|00000b30| 81 19 05 52 36 43 36 35 | d2 18 00 00 00 00 00 00 |...R6C65|........|
|00000b40| f0 3f 39 f2 0a 00 fd 04 | 1e 24 82 1d 07 00 fd 04 |.?9.....|.$......|
|00000b50| 1e 23 82 19 05 52 37 43 | 36 35 d2 18 00 00 00 00 |.#...R7C|65......|
|00000b60| 00 00 f0 3f 39 f2 0a 00 | fd 04 1e 24 83 1d 07 00 |...?9...|...$....|
|00000b70| fd 04 1e 23 83 fd 1e 1e | 0a 00 00 02 b4 00 03 34 |...#....|.......4|
|00000b80| 33 33 33 33 b3 7d 40 00 | 02 9c 18 03 34 33 33 33 |3333.}@.|....4333|
|00000b90| 33 b3 7d 40 fd 1f 1e 0b | 00 05 4b 65 79 20 31 00 |3.}@....|..Key 1.|
|00000ba0| 00 02 b0 01 03 01 00 00 | 00 00 c0 88 40 01 02 a8 |........|....@...|
|00000bb0| 03 02 b0 01 fd 06 0f 02 | 00 1c 00 fd 1f 1e 0b 00 |........|........|
|00000bc0| 05 4b 65 79 20 32 00 00 | 02 b0 01 03 ff ff ff ff |.Key 2..|........|
|00000bd0| ff df 99 40 01 02 a8 03 | 02 b0 01 fd 06 0f 02 00 |...@....|........|
|00000be0| 1c 00 fd 19 1e 0b 00 05 | 4b 65 79 20 33 00 00 02 |........|Key 3...|
|00000bf0| b0 01 02 d8 09 01 02 a8 | 03 02 b0 01 fd 06 0f 02 |........|........|
|00000c00| 00 1c 00 fd 04 08 01 07 | fd 03 1d 03 1a 00 00 18 |........|........|
|00000c10| 00 00 00 00 00 00 f0 3f | 39 f2 fd 00 fd 12 17 01 |.......?|9.......|
|00000c20| 05 1a 00 01 ff 01 09 19 | 05 52 32 43 36 35 ff fd |........|.R2C65..|
|00000c30| 12 17 01 05 1a 00 02 ff | 01 09 19 05 52 33 43 36 |........|....R3C6|
|00000c40| 35 ff fd 12 17 01 05 1a | 00 03 ff 01 09 19 05 52 |5.......|.......R|
|00000c50| 34 43 36 35 ff fd 12 17 | 01 05 1a 00 04 ff 01 09 |4C65....|........|
|00000c60| 19 05 52 35 43 36 35 ff | fd 12 17 01 05 1a 00 05 |..R5C65.|........|
|00000c70| ff 01 09 19 05 52 36 43 | 36 35 ff fd 12 17 01 05 |.....R6C|65......|
|00000c80| 1a 00 06 ff 01 09 19 05 | 52 37 43 36 35 ff fd 04 |........|R7C65...|
|00000c90| 1b 00 00 18 00 00 00 00 | 00 00 f0 3f f4 00 07 1a |........|...?....|
|00000ca0| 00 01 1b 01 00 05 f9 f8 | 18 00 00 00 00 00 00 00 |........|........|
|00000cb0| 40 f4 00 07 1a 00 02 1b | 01 00 05 f9 f8 18 00 00 |@.......|........|
|00000cc0| 00 00 00 00 08 40 f4 00 | 07 1a 00 03 1b 01 00 05 |.....@..|........|
|00000cd0| f9 f8 fd 28 08 01 01 01 | 01 21 18 00 00 00 00 00 |...(....|.!......|
|00000ce0| 00 00 40 18 00 00 00 00 | 00 00 00 40 18 00 00 00 |..@.....|...@....|
|00000cf0| 00 00 00 50 40 1a 00 08 | d8 ff 00 fd 03 11 00 fd |...P@...|........|
|00000d00| 0e 08 01 01 01 01 07 07 | 00 00 00 00 ff 00 fd 04 |........|........|
|00000d10| 08 01 07 fd 03 1b 02 fb | f6 01 00 1a 03 01 f7 18 |........|........|
|00000d20| 00 00 00 00 00 00 f0 3f | 39 f2 15 00 f8 18 00 00 |.......?|9.......|
|00000d30| 00 00 00 00 00 40 1b 01 | 00 06 f9 f8 1d 87 00 f7 |.....@..|........|
|00000d40| 18 00 00 00 00 00 00 00 | 40 39 f2 15 00 f8 18 00 |........|@9......|
|00000d50| 00 00 00 00 00 14 40 1b | 01 00 06 f9 f8 1d 66 00 |......@.|......f.|
|00000d60| f7 18 00 00 00 00 00 00 | 08 40 39 f2 15 00 f8 18 |........|.@9.....|
|00000d70| 00 00 00 00 00 00 24 40 | 1b 01 00 06 f9 f8 1d 45 |......$@|.......E|
|00000d80| 00 f7 18 00 00 00 00 00 | 00 10 40 39 f2 15 00 f8 |........|..@9....|
|00000d90| 18 00 00 00 00 00 00 28 | 40 1b 01 00 06 f9 f8 1d |.......(|@.......|
|00000da0| 24 00 f7 18 00 00 00 00 | 00 00 14 40 39 f2 15 00 |$.......|...@9...|
|00000db0| f8 18 00 00 00 00 00 00 | 10 40 1b 01 00 06 f9 f8 |........|.@......|
|00000dc0| 1d 03 00 f8 fb f6 01 00 | fd 1c 08 01 01 01 01 15 |........|........|
|00000dd0| 1a 03 01 18 00 00 00 00 | 00 00 00 40 1a 03 01 1a |........|...@....|
|00000de0| 00 08 d8 ff 00 1a 00 07 | f7 18 00 00 00 00 00 00 |........|........|
|00000df0| f0 3f 39 f2 36 00 f8 1a | 00 04 f7 18 00 00 00 00 |.?9.6...|........|
|00000e00| 00 00 00 00 39 f2 0a 00 | f8 fd 03 11 02 1d 19 00 |....9...|........|
|00000e10| f7 18 00 00 00 00 00 00 | f0 3f 39 f2 0a 00 f8 fd |........|.?9.....|
|00000e20| 03 11 03 1d 03 00 f8 1d | 87 00 f7 18 00 00 00 00 |........|........|
|00000e30| 00 00 00 40 39 f2 36 00 | f8 1a 00 05 f7 18 00 00 |...@9.6.|........|
|00000e40| 00 00 00 00 00 00 39 f2 | 0a 00 f8 fd 03 11 04 1d |......9.|........|
|00000e50| 19 00 f7 18 00 00 00 00 | 00 00 f0 3f 39 f2 0a 00 |........|...?9...|
|00000e60| f8 fd 03 11 05 1d 03 00 | f8 1d 45 00 f7 18 00 00 |........|..E.....|
|00000e70| 00 00 00 00 08 40 39 f2 | 36 00 f8 1a 00 06 f7 18 |.....@9.|6.......|
|00000e80| 00 00 00 00 00 00 00 00 | 39 f2 0a 00 f8 fd 03 11 |........|9.......|
|00000e90| 04 1d 19 00 f7 18 00 00 | 00 00 00 00 f0 3f 39 f2 |........|.....?9.|
|00000ea0| 0a 00 f8 fd 03 11 05 1d | 03 00 f8 1d 03 00 f8 fb |........|........|
|00000eb0| fc 05 00 64 6f 6e 65 00 | 03 00 66 6b 01 03 00 73 |...done.|..fk...s|
|00000ec0| 6b 02 03 00 74 6b 03 03 | 00 6d 31 04 03 00 6d 32 |k...tk..|.m1...m2|
|00000ed0| 05 03 00 6d 33 06 08 00 | 6b 65 79 5f 6e 75 6d 07 |...m3...|key_num.|
|00000ee0| 09 00 6c 61 73 74 5f 72 | 6f 77 08 05 00 6c 6f 6f |..last_r|ow...loo|
|00000ef0| 70 09 10 01 00 4d 41 4b | 45 5f 4e 45 57 5f 53 48 |p....MAK|E_NEW_SH|
|00000f00| 45 45 54 31 00 00 00 0c | 01 00 41 44 44 5f 54 49 |EET1....|..ADD_TI|
|00000f10| 54 4c 45 53 8c 00 00 00 | 0c 01 00 41 44 44 5f 42 |TLES....|...ADD_B|
|00000f20| 55 54 54 4f 4e 3b 06 00 | 00 0d 01 00 53 4f 52 54 |UTTON;..|....SORT|
|00000f30| 5f 44 49 41 4c 4f 47 0e | 07 00 00 0a 01 00 47 45 |_DIALOG.|......GE|
|00000f40| 54 5f 52 4f 57 53 1c 06 | 00 00 0b 01 01 53 4f 52 |T_ROWS..|.....SOR|
|00000f50| 54 5f 54 59 50 45 40 0c | 00 00 06 01 01 53 4f 52 |T_TYPE@.|.....SOR|
|00000f60| 54 ed 0c 00 00 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |T....{**|********|
|00000f70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 53 |********|****** S|
|00000f90| 4f 52 54 20 53 43 52 49 | 50 54 20 2a 2a 2a 2a 2a |ORT SCRI|PT *****|
|00000fa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 20 20 a9 20 31 39 39 |********|.  . 199|
|00000fd0| 31 20 43 6c 61 72 69 73 | 20 43 6f 72 70 6f 72 61 |1 Claris| Corpora|
|00000fe0| 74 69 6f 6e 2e 20 20 41 | 6c 6c 20 72 69 67 68 74 |tion.  A|ll right|
|00000ff0| 73 20 72 65 73 65 72 76 | 65 64 2e 0d 0d 20 20 4c |s reserv|ed...  L|
|00001000| 41 53 54 20 4d 4f 44 49 | 46 49 45 44 3a 20 20 31 |AST MODI|FIED:  1|
|00001010| 2f 31 34 2f 39 31 0d 0d | 20 20 54 68 69 73 20 73 |/14/91..|  This s|
|00001020| 63 72 69 70 74 20 77 69 | 6c 6c 20 73 6f 72 74 20 |cript wi|ll sort |
|00001030| 74 68 65 20 50 72 6f 6a | 65 63 74 20 54 61 62 6c |the Proj|ect Tabl|
|00001040| 65 20 64 61 74 61 20 65 | 78 70 6f 72 74 65 64 20 |e data e|xported |
|00001050| 66 72 6f 6d 20 4d 61 63 | 50 72 6f 6a 65 63 74 20 |from Mac|Project |
|00001060| 49 49 20 69 6e 20 41 73 | 63 65 6e 64 69 6e 67 20 |II in As|cending |
|00001070| 6f 72 20 44 65 73 63 65 | 6e 64 69 6e 67 0d 20 20 |or Desce|nding.  |
|00001080| 6f 72 64 65 72 20 62 61 | 73 65 64 20 6f 6e 20 6f |order ba|sed on o|
|00001090| 6e 65 20 6f 66 20 74 68 | 65 20 66 6f 6c 6c 6f 77 |ne of th|e follow|
|000010a0| 69 6e 67 20 63 72 69 74 | 65 72 69 61 3a 0d 09 a5 |ing crit|eria:...|
|000010b0| 20 20 54 61 73 6b 20 4e | 61 6d 65 0d 09 a5 20 20 |  Task N|ame...  |
|000010c0| 45 61 72 6c 69 65 73 74 | 20 53 74 61 72 74 20 44 |Earliest| Start D|
|000010d0| 61 74 65 0d 09 a5 20 20 | 41 63 74 75 61 6c 20 53 |ate...  |Actual S|
|000010e0| 74 61 72 74 20 44 61 74 | 65 0d 09 a5 20 20 25 20 |tart Dat|e...  % |
|000010f0| 44 6f 6e 65 20 2d 20 6f | 66 20 65 61 63 68 20 74 |Done - o|f each t|
|00001100| 61 73 6b 0d 09 a5 20 20 | 53 75 62 74 69 74 6c 65 |ask...  |Subtitle|
|00001110| 20 2d 20 6f 70 74 69 6f | 6e 61 6c 20 75 73 65 72 | - optio|nal user|
|00001120| 2d 64 65 66 69 6e 65 64 | 20 66 69 65 6c 64 0d 0d |-defined| field..|
|00001130| 20 20 54 61 62 6c 65 73 | 20 75 73 65 64 3a 0d 09 |  Tables| used:..|
|00001140| a5 20 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |.  Proje|ct Table|
|00001150| 0d 0d 20 20 41 73 73 75 | 6d 70 74 69 6f 6e 73 3a |..  Assu|mptions:|
|00001160| 0d 09 a5 20 20 41 6c 6c | 20 63 6f 6c 75 6d 6e 73 |...  All| columns|
|00001170| 20 66 72 6f 6d 20 74 68 | 65 20 50 72 6f 6a 65 63 | from th|e Projec|
|00001180| 74 20 54 61 62 6c 65 20 | 61 72 65 20 65 78 70 6f |t Table |are expo|
|00001190| 72 74 65 64 2e 0d 20 0d | 2a 2a 2a 2a 2a 2a 2a 2a |rted.. .|********|
|000011a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000011b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 44 |********|****** D|
|000011c0| 45 46 49 4e 45 20 47 4c | 4f 42 41 4c 20 56 41 52 |EFINE GL|OBAL VAR|
|000011d0| 49 41 42 4c 45 53 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |IABLES *|********|
|000011e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000011f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 7d 0d 0d |********|*****}..|
|00001200| 44 45 46 49 4e 45 20 64 | 6f 6e 65 09 09 09 7b 20 |DEFINE d|one...{ |
|00001210| 44 6f 6e 65 20 66 6c 61 | 67 20 7d 0d 44 45 46 49 |Done fla|g }.DEFI|
|00001220| 4e 45 20 66 6b 09 09 09 | 09 7b 20 46 69 72 73 74 |NE fk...|.{ First|
|00001230| 20 73 6f 72 74 20 6b 65 | 79 20 6e 75 6d 62 65 72 | sort ke|y number|
|00001240| 20 63 68 6f 73 65 6e 20 | 7d 0d 44 45 46 49 4e 45 | chosen |}.DEFINE|
|00001250| 20 73 6b 09 09 09 09 7b | 20 53 65 63 6f 6e 64 20 | sk....{| Second |
|00001260| 73 6f 72 74 20 6b 65 79 | 20 6e 75 6d 62 65 72 20 |sort key| number |
|00001270| 63 68 6f 73 65 6e 20 7d | 0d 44 45 46 49 4e 45 20 |chosen }|.DEFINE |
|00001280| 74 6b 09 09 09 09 7b 20 | 54 68 69 72 64 20 73 6f |tk....{ |Third so|
|00001290| 72 74 20 6b 65 79 20 6e | 75 6d 62 65 72 20 63 68 |rt key n|umber ch|
|000012a0| 6f 73 65 6e 20 7d 0d 44 | 45 46 49 4e 45 20 6d 31 |osen }.D|EFINE m1|
|000012b0| 09 09 09 09 7b 20 53 6f | 72 74 20 6d 65 74 68 6f |....{ So|rt metho|
|000012c0| 64 20 2d 20 41 73 63 65 | 6e 64 69 6e 67 2f 44 65 |d - Asce|nding/De|
|000012d0| 73 63 65 6e 64 69 6e 67 | 20 2d 20 4b 65 79 20 31 |scending| - Key 1|
|000012e0| 20 7d 0d 44 45 46 49 4e | 45 20 6d 32 09 09 09 09 | }.DEFIN|E m2....|
|000012f0| 7b 20 53 6f 72 74 20 6d | 65 74 68 6f 64 20 2d 20 |{ Sort m|ethod - |
|00001300| 41 73 63 65 6e 64 69 6e | 67 2f 44 65 73 63 65 6e |Ascendin|g/Descen|
|00001310| 64 69 6e 67 20 2d 20 4b | 65 79 20 32 20 7d 0d 44 |ding - K|ey 2 }.D|
|00001320| 45 46 49 4e 45 20 6d 33 | 09 09 09 09 7b 20 53 6f |EFINE m3|....{ So|
|00001330| 72 74 20 6d 65 74 68 6f | 64 20 2d 20 41 73 63 65 |rt metho|d - Asce|
|00001340| 6e 64 69 6e 67 2f 44 65 | 73 63 65 6e 64 69 6e 67 |nding/De|scending|
|00001350| 20 2d 20 4b 65 79 20 33 | 20 7d 0d 44 45 46 49 4e | - Key 3| }.DEFIN|
|00001360| 45 20 6b 65 79 5f 6e 75 | 6d 09 09 09 7b 20 53 6f |E key_nu|m...{ So|
|00001370| 72 74 20 6b 65 79 20 6e | 75 6d 62 65 72 20 7d 0d |rt key n|umber }.|
|00001380| 44 45 46 49 4e 45 20 6c | 61 73 74 5f 72 6f 77 09 |DEFINE l|ast_row.|
|00001390| 09 7b 20 4c 61 73 74 20 | 72 6f 77 20 69 6e 20 74 |.{ Last |row in t|
|000013a0| 68 65 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |he Proje|ct Table|
|000013b0| 20 7d 0d 44 45 46 49 4e | 45 20 6c 6f 6f 70 09 09 | }.DEFIN|E loop..|
|000013c0| 09 7b 20 4d 61 69 6e 20 | 6c 6f 6f 70 20 63 6f 75 |.{ Main |loop cou|
|000013d0| 6e 74 65 72 20 7d 0d 0d | 64 6f 6e 65 20 3d 20 30 |nter }..|done = 0|
|000013e0| 09 09 09 09 7b 20 53 65 | 74 20 64 6f 6e 65 20 66 |....{ Se|t done f|
|000013f0| 6c 61 67 20 74 6f 20 7a | 65 72 6f 20 7d 0d 0d 7b |lag to z|ero }..{|
|00001400| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001410| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001420| 2a 2a 2a 2a 2a 20 4d 41 | 49 4e 20 53 43 52 49 50 |***** MA|IN SCRIP|
|00001430| 54 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |T ******|********|
|00001440| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001450| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001460| 2a 2a 2a 2a 7d 0d 0d 52 | 45 50 41 49 4e 54 20 4f |****}..R|EPAINT O|
|00001470| 46 46 09 09 09 09 7b 20 | 54 75 72 6e 20 73 63 72 |FF....{ |Turn scr|
|00001480| 65 65 6e 20 72 65 70 61 | 69 6e 74 20 6f 66 66 20 |een repa|int off |
|00001490| 74 6f 20 73 70 65 65 64 | 20 65 78 65 63 75 74 69 |to speed| executi|
|000014a0| 6f 6e 20 7d 0d 49 46 20 | 4d 41 4b 45 5f 4e 45 57 |on }.IF |MAKE_NEW|
|000014b0| 5f 53 48 45 45 54 28 29 | 09 09 09 7b 20 43 72 65 |_SHEET()|...{ Cre|
|000014c0| 61 74 65 20 74 68 65 20 | 72 65 73 75 6c 74 73 20 |ate the |results |
|000014d0| 77 6f 72 6b 73 68 65 65 | 74 20 7d 0d 09 43 41 4c |workshee|t }..CAL|
|000014e0| 4c 20 41 44 44 5f 54 49 | 54 4c 45 53 28 29 09 09 |L ADD_TI|TLES()..|
|000014f0| 7b 20 41 64 64 20 63 6f | 6c 75 6d 6e 20 74 69 74 |{ Add co|lumn tit|
|00001500| 6c 65 73 20 61 6e 64 20 | 64 65 74 65 72 6d 69 6e |les and |determin|
|00001510| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |e number| of rows|
|00001520| 20 7d 0d 09 43 41 4c 4c | 20 41 44 44 5f 42 55 54 | }..CALL| ADD_BUT|
|00001530| 54 4f 4e 28 29 09 09 7b | 20 41 64 64 20 73 6f 72 |TON()..{| Add sor|
|00001540| 74 20 62 75 74 74 6f 6e | 20 66 6f 72 20 66 75 72 |t button| for fur|
|00001550| 74 68 65 72 20 73 6f 72 | 74 69 6e 67 20 7d 0d 09 |ther sor|ting }..|
|00001560| 52 45 50 41 49 4e 54 20 | 4f 4e 09 09 09 7b 20 54 |REPAINT |ON...{ T|
|00001570| 75 72 6e 20 72 65 70 61 | 69 6e 74 20 6f 6e 20 7d |urn repa|int on }|
|00001580| 0d 09 43 41 4c 4c 20 53 | 4f 52 54 5f 44 49 41 4c |..CALL S|ORT_DIAL|
|00001590| 4f 47 28 29 09 09 7b 20 | 53 6f 72 74 20 74 68 65 |OG()..{ |Sort the|
|000015a0| 20 70 72 6f 6a 65 63 74 | 20 74 61 62 6c 65 20 62 | project| table b|
|000015b0| 61 73 65 64 20 6f 6e 20 | 75 73 65 72 20 64 65 66 |ased on |user def|
|000015c0| 69 6e 65 64 20 63 72 69 | 74 65 72 69 61 20 7d 0d |ined cri|teria }.|
|000015d0| 45 4e 44 20 49 46 0d 0d | 7b 2a 2a 2a 2a 2a 2a 2a |END IF..|{*******|
|000015e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000015f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 4d 41 4b |********|**** MAK|
|00001600| 45 5f 4e 45 57 5f 53 48 | 45 45 54 20 2a 2a 2a 2a |E_NEW_SH|EET ****|
|00001610| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001620| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001630| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 20 20 |********|*****.  |
|00001640| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 63 72 |This fun|ction cr|
|00001650| 65 61 74 65 73 20 61 20 | 6e 65 77 20 77 6f 72 6b |eates a |new work|
|00001660| 73 68 65 65 74 20 69 6e | 20 77 68 69 63 68 20 74 |sheet in| which t|
|00001670| 68 65 20 66 69 6e 61 6c | 20 73 63 72 69 70 74 20 |he final| script |
|00001680| 72 65 73 75 6c 74 73 20 | 77 69 6c 6c 20 62 65 20 |results |will be |
|00001690| 64 69 73 70 6c 61 79 65 | 64 2e 0d 20 20 54 68 69 |displaye|d..  Thi|
|000016a0| 73 20 73 74 65 70 20 69 | 73 20 6e 65 63 65 73 73 |s step i|s necess|
|000016b0| 61 72 79 20 73 6f 20 74 | 68 61 74 20 74 68 65 20 |ary so t|hat the |
|000016c0| 66 69 6e 61 6c 20 77 6f | 72 6b 73 68 65 65 74 20 |final wo|rksheet |
|000016d0| 6d 61 79 20 62 65 20 6c | 65 66 74 20 6f 70 65 6e |may be l|eft open|
|000016e0| 20 77 68 65 6e 20 72 65 | 2d 65 78 65 63 75 74 69 | when re|-executi|
|000016f0| 6e 67 0d 20 20 74 68 65 | 20 73 61 6d 65 20 45 78 |ng.  the| same Ex|
|00001700| 63 68 61 6e 67 65 20 69 | 74 65 6d 20 28 6f 72 20 |change i|tem (or |
|00001710| 61 6e 6f 74 68 65 72 20 | 77 68 69 63 68 20 75 73 |another |which us|
|00001720| 65 73 20 74 68 65 20 73 | 61 6d 65 20 65 78 70 6f |es the s|ame expo|
|00001730| 72 74 20 64 6f 63 75 6d | 65 6e 74 29 20 77 69 74 |rt docum|ent) wit|
|00001740| 68 6f 75 74 20 63 61 75 | 73 69 6e 67 0d 20 20 61 |hout cau|sing.  a|
|00001750| 20 63 6f 6e 66 6c 69 63 | 74 20 6f 66 20 77 6f 72 | conflic|t of wor|
|00001760| 6b 73 68 65 65 74 20 6e | 61 6d 65 73 2e 0d 20 2a |ksheet n|ames.. *|
|00001770| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001780| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001790| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000017d0| 2a 2a 2a 7d 0d 0d 46 55 | 4e 43 54 49 4f 4e 20 4d |***}..FU|NCTION M|
|000017e0| 41 4b 45 5f 4e 45 57 5f | 53 48 45 45 54 28 29 0d |AKE_NEW_|SHEET().|
|000017f0| 09 4e 45 57 20 57 4f 52 | 4b 53 48 45 45 54 20 22 |.NEW WOR|KSHEET "|
|00001800| 22 09 09 09 7b 20 43 72 | 65 61 74 65 20 61 20 6e |"...{ Cr|eate a n|
|00001810| 65 77 20 75 6e 74 69 74 | 6c 65 64 20 77 6f 72 6b |ew untit|led work|
|00001820| 73 68 65 65 74 20 7d 0d | 09 53 45 4c 45 43 54 20 |sheet }.|.SELECT |
|00001830| 52 41 4e 47 45 20 41 31 | 09 09 09 7b 20 4d 61 6b |RANGE A1|...{ Mak|
|00001840| 65 20 73 75 72 65 20 74 | 68 65 20 6e 65 78 74 20 |e sure t|he next |
|00001850| 6c 69 6e 65 20 70 75 74 | 73 20 74 68 65 20 69 6e |line put|s the in|
|00001860| 66 6f 20 69 6e 20 74 68 | 65 20 64 65 73 69 72 65 |fo in th|e desire|
|00001870| 64 20 6c 6f 63 61 74 69 | 6f 6e 20 7d 0d 09 41 50 |d locati|on }..AP|
|00001880| 50 45 4e 44 20 22 4d 50 | 20 50 72 6f 6a 65 63 74 |PEND "MP| Project|
|00001890| 20 54 61 62 6c 65 22 09 | 7b 20 41 70 70 65 6e 64 | Table".|{ Append|
|000018a0| 20 4d 61 63 50 72 6f 6a | 65 63 74 20 65 78 70 6f | MacProj|ect expo|
|000018b0| 72 74 20 64 61 74 61 20 | 66 69 6c 65 20 7d 0d 09 |rt data |file }..|
|000018c0| 49 46 20 43 45 52 52 4f | 52 28 29 20 3d 20 30 09 |IF CERRO|R() = 0.|
|000018d0| 09 09 0d 09 09 5a 4f 4f | 4d 20 57 49 4e 44 4f 57 |.....ZOO|M WINDOW|
|000018e0| 09 09 09 7b 20 4d 61 6b | 65 20 73 75 72 65 20 77 |...{ Mak|e sure w|
|000018f0| 69 6e 64 6f 77 20 66 69 | 6c 6c 73 20 74 68 65 20 |indow fi|lls the |
|00001900| 73 63 72 65 65 6e 20 7d | 0d 09 09 52 45 54 55 52 |screen }|...RETUR|
|00001910| 4e 20 31 09 09 09 09 7b | 20 52 65 74 75 72 6e 20 |N 1....{| Return |
|00001920| 61 20 76 61 6c 75 65 20 | 69 6e 64 69 63 61 74 69 |a value |indicati|
|00001930| 6e 67 20 74 68 65 20 73 | 63 72 69 70 74 20 73 68 |ng the s|cript sh|
|00001940| 6f 75 6c 64 20 63 6f 6e | 74 69 6e 75 65 20 7d 0d |ould con|tinue }.|
|00001950| 09 45 4c 53 45 0d 09 09 | 52 45 54 55 52 4e 20 30 |.ELSE...|RETURN 0|
|00001960| 09 09 09 09 7b 20 52 65 | 74 75 72 6e 20 61 20 76 |....{ Re|turn a v|
|00001970| 61 6c 75 65 20 69 6e 64 | 69 63 61 74 69 6e 67 20 |alue ind|icating |
|00001980| 74 68 65 20 73 63 72 69 | 70 74 20 73 68 6f 75 6c |the scri|pt shoul|
|00001990| 64 20 62 65 20 73 74 6f | 70 70 65 64 20 7d 0d 09 |d be sto|pped }..|
|000019a0| 45 4e 44 20 49 46 0d 45 | 4e 44 20 46 55 4e 43 54 |END IF.E|ND FUNCT|
|000019b0| 49 4f 4e 0d 0d 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ION..{**|********|
|000019c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000019d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 41 44 44 5f |********|*** ADD_|
|000019e0| 54 49 54 4c 45 53 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |TITLES *|********|
|000019f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001a00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001a10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 20 20 54 68 |********|***.  Th|
|00001a20| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 66 6f 72 6d |is funct|ion form|
|00001a30| 61 74 73 20 74 68 65 20 | 70 72 6f 6a 65 63 74 20 |ats the |project |
|00001a40| 74 61 62 6c 65 20 69 6e | 74 6f 20 61 20 6d 6f 72 |table in|to a mor|
|00001a50| 65 20 70 72 65 73 65 6e | 74 61 62 6c 65 20 66 6f |e presen|table fo|
|00001a60| 72 6d 2e 20 20 49 74 20 | 61 64 64 73 20 74 69 74 |rm.  It |adds tit|
|00001a70| 6c 65 73 2c 20 68 69 64 | 65 73 20 0d 20 20 61 74 |les, hid|es .  at|
|00001a80| 74 72 69 62 75 74 65 73 | 20 73 75 63 68 20 61 73 |tributes| such as|
|00001a90| 20 74 69 74 6c 65 73 20 | 61 6e 64 20 74 68 65 20 | titles |and the |
|00001aa0| 74 6f 6f 6c 62 6f 78 20 | 61 6e 64 20 72 65 6d 6f |toolbox |and remo|
|00001ab0| 76 65 73 20 74 68 65 20 | 67 72 69 64 20 6c 69 6e |ves the |grid lin|
|00001ac0| 65 73 2e 20 20 49 20 74 | 68 65 6e 20 68 61 76 65 |es.  I t|hen have|
|00001ad0| 20 69 74 20 6f 75 74 6c | 69 6e 65 0d 20 20 74 68 | it outl|ine.  th|
|00001ae0| 65 20 61 63 74 69 76 65 | 20 63 65 6c 6c 73 20 77 |e active| cells w|
|00001af0| 69 74 68 20 61 20 62 6f | 72 64 65 72 2e 0d 20 2a |ith a bo|rder.. *|
|00001b00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b60| 2a 2a 2a 7d 0d 0d 46 55 | 4e 43 54 49 4f 4e 20 41 |***}..FU|NCTION A|
|00001b70| 44 44 5f 54 49 54 4c 45 | 53 28 29 0d 09 6c 61 73 |DD_TITLE|S()..las|
|00001b80| 74 5f 72 6f 77 20 3d 20 | 47 45 54 5f 52 4f 57 53 |t_row = |GET_ROWS|
|00001b90| 28 29 09 09 09 09 09 7b | 20 44 65 74 65 72 6d 69 |().....{| Determi|
|00001ba0| 6e 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 50 72 6f |ne numbe|r of Pro|
|00001bb0| 6a 65 63 74 20 54 61 62 | 6c 65 20 72 6f 77 73 20 |ject Tab|le rows |
|00001bc0| 7d 0d 09 53 45 4c 45 43 | 54 20 52 41 4e 47 45 28 |}..SELEC|T RANGE(|
|00001bd0| 4d 41 4b 45 52 41 4e 47 | 45 28 31 3b 31 3b 36 33 |MAKERANG|E(1;1;63|
|00001be0| 3b 6c 61 73 74 5f 72 6f | 77 2d 31 29 29 09 7b 20 |;last_ro|w-1)).{ |
|00001bf0| 53 65 6c 65 63 74 20 61 | 6c 6c 20 64 61 74 61 20 |Select a|ll data |
|00001c00| 63 65 6c 6c 73 20 7d 0d | 09 43 45 4c 4c 20 42 4f |cells }.|.CELL BO|
|00001c10| 52 44 45 52 20 22 54 4c | 42 52 22 09 09 09 09 09 |RDER "TL|BR".....|
|00001c20| 09 7b 20 41 70 70 6c 79 | 20 62 6f 72 64 65 72 20 |.{ Apply| border |
|00001c30| 74 6f 20 73 65 6c 65 63 | 74 65 64 20 63 65 6c 6c |to selec|ted cell|
|00001c40| 73 20 7d 0d 09 54 45 58 | 54 20 46 4f 4e 54 20 22 |s }..TEX|T FONT "|
|00001c50| 48 65 6c 76 65 74 69 63 | 61 22 09 09 09 09 09 7b |Helvetic|a".....{|
|00001c60| 20 53 65 74 20 66 6f 6e | 74 20 74 6f 20 48 65 6c | Set fon|t to Hel|
|00001c70| 76 65 74 69 63 61 20 7d | 0d 09 43 4f 4c 55 4d 4e |vetica }|..COLUMN|
|00001c80| 20 57 49 44 54 48 20 31 | 2e 32 20 49 4e 43 48 45 | WIDTH 1|.2 INCHE|
|00001c90| 53 09 09 09 09 09 7b 20 | 53 65 74 20 63 6f 6c 75 |S.....{ |Set colu|
|00001ca0| 6d 6e 20 77 69 64 74 68 | 20 7d 0d 09 53 45 4c 45 |mn width| }..SELE|
|00001cb0| 43 54 20 52 41 4e 47 45 | 20 41 31 09 09 09 09 09 |CT RANGE| A1.....|
|00001cc0| 09 7b 20 53 65 6c 65 63 | 74 20 6e 61 6d 65 20 63 |.{ Selec|t name c|
|00001cd0| 6f 6c 75 6d 6e 20 7d 0d | 09 43 4f 4c 55 4d 4e 20 |olumn }.|.COLUMN |
|00001ce0| 57 49 44 54 48 20 33 20 | 49 4e 43 48 45 53 09 09 |WIDTH 3 |INCHES..|
|00001cf0| 09 09 09 7b 20 53 65 74 | 20 74 68 65 20 77 69 64 |...{ Set| the wid|
|00001d00| 74 68 20 74 6f 20 33 20 | 69 6e 63 68 65 73 20 7d |th to 3 |inches }|
|00001d10| 0d 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 28 4d |..SELECT| RANGE(M|
|00001d20| 41 4b 45 52 41 4e 47 45 | 28 31 32 3b 31 3b 31 37 |AKERANGE|(12;1;17|
|00001d30| 3b 6c 61 73 74 5f 72 6f | 77 2d 31 29 29 09 7b 20 |;last_ro|w-1)).{ |
|00001d40| 53 65 6c 65 63 74 20 61 | 6c 6c 20 63 75 72 72 65 |Select a|ll curre|
|00001d50| 6e 63 79 20 63 65 6c 6c | 73 20 7d 0d 09 46 4f 52 |ncy cell|s }..FOR|
|00001d60| 4d 41 54 20 43 55 52 52 | 45 4e 43 59 09 09 09 09 |MAT CURR|ENCY....|
|00001d70| 09 09 7b 20 41 70 70 6c | 79 20 63 75 72 72 65 6e |..{ Appl|y curren|
|00001d80| 63 79 20 66 6f 72 6d 61 | 74 74 69 6e 67 20 7d 0d |cy forma|tting }.|
|00001d90| 09 55 53 45 20 43 4f 4d | 4d 41 53 09 09 09 09 09 |.USE COM|MAS.....|
|00001da0| 09 09 7b 20 55 73 65 20 | 63 6f 6d 6d 61 73 20 69 |..{ Use |commas i|
|00001db0| 6e 20 63 65 6c 6c 20 66 | 6f 72 6d 61 74 20 7d 0d |n cell f|ormat }.|
|00001dc0| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 20 41 31 |.SELECT |RANGE A1|
|00001dd0| 2e 2e 41 56 4c 48 31 09 | 09 09 09 09 7b 20 53 65 |..AVLH1.|....{ Se|
|00001de0| 6c 65 63 74 20 66 6b 20 | 63 6f 6c 75 6d 6e 20 7d |lect fk |column }|
|00001df0| 0d 09 49 4e 53 45 52 54 | 09 09 09 09 09 09 09 09 |..INSERT|........|
|00001e00| 7b 20 49 6e 73 65 72 74 | 20 61 20 6e 65 77 20 72 |{ Insert| a new r|
|00001e10| 6f 77 20 7d 0d 09 52 4f | 57 20 48 45 49 47 48 54 |ow }..RO|W HEIGHT|
|00001e20| 20 2e 33 20 49 4e 43 48 | 09 09 09 09 09 09 7b 20 | .3 INCH|......{ |
|00001e30| 53 65 74 20 72 6f 77 20 | 68 65 69 67 68 74 20 66 |Set row |height f|
|00001e40| 6f 72 20 73 65 6c 65 63 | 74 65 64 20 72 6f 77 20 |or selec|ted row |
|00001e50| 7d 0d 09 54 45 58 54 20 | 43 4f 4c 4f 52 20 42 4c |}..TEXT |COLOR BL|
|00001e60| 55 45 28 29 09 09 09 09 | 09 09 7b 20 53 65 74 20 |UE()....|..{ Set |
|00001e70| 73 65 6c 65 63 74 65 64 | 20 74 65 78 74 20 63 6f |selected| text co|
|00001e80| 6c 6f 72 20 74 6f 20 62 | 6c 75 65 20 7d 0d 09 54 |lor to b|lue }..T|
|00001e90| 45 58 54 20 53 49 5a 45 | 20 39 09 09 09 09 09 09 |EXT SIZE| 9......|
|00001ea0| 09 7b 20 53 65 74 20 74 | 65 78 74 20 73 69 7a 65 |.{ Set t|ext size|
|00001eb0| 20 74 6f 20 39 20 70 6f | 69 6e 74 73 20 7d 0d 09 | to 9 po|ints }..|
|00001ec0| 54 45 58 54 20 46 4f 4e | 54 20 22 48 65 6c 76 65 |TEXT FON|T "Helve|
|00001ed0| 74 69 63 61 22 09 09 09 | 09 09 7b 20 53 65 74 20 |tica"...|..{ Set |
|00001ee0| 66 6f 6e 74 20 74 6f 20 | 48 65 6c 76 65 74 69 63 |font to |Helvetic|
|00001ef0| 61 20 7d 0d 09 54 45 58 | 54 20 53 54 59 4c 45 20 |a }..TEX|T STYLE |
|00001f00| 22 42 22 09 09 09 09 09 | 09 09 7b 20 53 65 74 20 |"B".....|..{ Set |
|00001f10| 74 65 78 74 20 73 74 79 | 6c 65 20 74 6f 20 42 6f |text sty|le to Bo|
|00001f20| 6c 64 20 7d 0d 09 54 45 | 58 54 20 53 54 59 4c 45 |ld }..TE|XT STYLE|
|00001f30| 20 22 49 22 09 09 09 09 | 09 09 09 7b 20 53 65 74 | "I"....|...{ Set|
|00001f40| 20 74 65 78 74 20 73 74 | 79 6c 65 20 74 6f 20 49 | text st|yle to I|
|00001f50| 74 61 6c 69 63 20 7d 0d | 09 41 4c 49 47 4e 20 43 |talic }.|.ALIGN C|
|00001f60| 45 4e 54 45 52 09 09 09 | 09 09 09 09 7b 20 43 65 |ENTER...|....{ Ce|
|00001f70| 6e 74 65 72 20 74 69 74 | 6c 65 73 20 7d 0d 09 50 |nter tit|les }..P|
|00001f80| 55 54 20 22 4e 61 6d 65 | 22 20 49 4e 54 4f 20 52 |UT "Name|" INTO R|
|00001f90| 31 43 31 20 09 09 09 09 | 09 7b 20 50 6c 61 63 65 |1C1 ....|.{ Place|
|00001fa0| 20 4e 61 6d 65 20 69 6e | 74 6f 20 63 65 6c 6c 20 | Name in|to cell |
|00001fb0| 7d 0d 09 50 55 54 20 22 | 54 61 73 6b 20 49 44 22 |}..PUT "|Task ID"|
|00001fc0| 20 49 4e 54 4f 20 52 31 | 43 32 20 09 09 09 09 09 | INTO R1|C2 .....|
|00001fd0| 7b 20 50 6c 61 63 65 20 | 54 61 73 6b 20 49 44 20 |{ Place |Task ID |
|00001fe0| 69 6e 74 6f 20 63 65 6c | 6c 20 7d 0d 09 50 55 54 |into cel|l }..PUT|
|00001ff0| 20 22 53 75 62 74 69 74 | 6c 65 22 20 49 4e 54 4f | "Subtit|le" INTO|
|00002000| 20 52 31 43 33 20 09 09 | 09 09 7b 20 50 6c 61 63 | R1C3 ..|..{ Plac|
|00002010| 65 20 53 75 62 74 69 74 | 6c 65 20 69 6e 74 6f 20 |e Subtit|le into |
|00002020| 63 65 6c 6c 20 7d 0d 09 | 50 55 54 20 22 45 61 72 |cell }..|PUT "Ear|
|00002030| 6c 69 65 73 74 20 53 74 | 61 72 74 22 20 49 4e 54 |liest St|art" INT|
|00002040| 4f 20 52 31 43 34 20 09 | 09 09 7b 20 50 6c 61 63 |O R1C4 .|..{ Plac|
|00002050| 65 20 45 61 72 6c 69 65 | 73 74 20 53 74 61 72 74 |e Earlie|st Start|
|00002060| 20 69 6e 74 6f 20 63 65 | 6c 6c 20 7d 0d 09 50 55 | into ce|ll }..PU|
|00002070| 54 20 22 45 61 72 6c 69 | 65 73 74 20 46 69 6e 69 |T "Earli|est Fini|
|00002080| 73 68 22 20 49 4e 54 4f | 20 52 31 43 35 20 09 09 |sh" INTO| R1C5 ..|
|00002090| 09 7b 20 50 6c 61 63 65 | 20 45 61 72 6c 69 65 73 |.{ Place| Earlies|
|000020a0| 74 20 46 69 6e 69 73 68 | 20 69 6e 74 6f 20 63 65 |t Finish| into ce|
|000020b0| 6c 6c 20 7d 0d 09 50 55 | 54 20 22 4c 61 74 65 73 |ll }..PU|T "Lates|
|000020c0| 74 20 53 74 61 72 74 22 | 20 49 4e 54 4f 20 52 31 |t Start"| INTO R1|
|000020d0| 43 36 20 09 09 09 09 7b | 20 50 6c 61 63 65 20 4c |C6 ....{| Place L|
|000020e0| 61 74 65 73 74 20 53 74 | 61 72 74 20 69 6e 74 6f |atest St|art into|
|000020f0| 20 63 65 6c 6c 20 7d 0d | 09 50 55 54 20 22 4c 61 | cell }.|.PUT "La|
|00002100| 74 65 73 74 20 46 69 6e | 69 73 68 22 20 49 4e 54 |test Fin|ish" INT|
|00002110| 4f 20 52 31 43 37 20 09 | 09 09 7b 20 50 6c 61 63 |O R1C7 .|..{ Plac|
|00002120| 65 20 4c 61 74 65 73 74 | 20 46 69 6e 69 73 68 20 |e Latest| Finish |
|00002130| 69 6e 74 6f 20 63 65 6c | 6c 20 7d 0d 09 50 55 54 |into cel|l }..PUT|
|00002140| 20 22 53 6c 61 63 6b 22 | 20 49 4e 54 4f 20 52 31 | "Slack"| INTO R1|
|00002150| 43 38 20 09 09 09 09 09 | 7b 20 50 6c 61 63 65 20 |C8 .....|{ Place |
|00002160| 53 6c 61 63 6b 20 69 6e | 74 6f 20 63 65 6c 6c 20 |Slack in|to cell |
|00002170| 7d 0d 09 50 55 54 20 22 | 41 63 74 75 61 6c 20 53 |}..PUT "|Actual S|
|00002180| 74 61 72 74 22 20 49 4e | 54 4f 20 52 31 43 39 20 |tart" IN|TO R1C9 |
|00002190| 09 09 09 09 7b 20 50 6c | 61 63 65 20 41 63 74 75 |....{ Pl|ace Actu|
|000021a0| 61 6c 20 53 74 61 72 74 | 20 69 6e 74 6f 20 63 65 |al Start| into ce|
|000021b0| 6c 6c 20 7d 0d 09 50 55 | 54 20 22 41 63 74 75 61 |ll }..PU|T "Actua|
|000021c0| 6c 20 46 69 6e 69 73 68 | 22 20 49 4e 54 4f 20 52 |l Finish|" INTO R|
|000021d0| 31 43 31 30 20 09 09 09 | 7b 20 50 6c 61 63 65 20 |1C10 ...|{ Place |
|000021e0| 41 63 74 75 61 6c 20 46 | 69 6e 69 73 68 20 69 6e |Actual F|inish in|
|000021f0| 74 6f 20 63 65 6c 6c 20 | 7d 0d 09 50 55 54 20 22 |to cell |}..PUT "|
|00002200| 25 20 44 6f 6e 65 22 20 | 49 4e 54 4f 20 52 31 43 |% Done" |INTO R1C|
|00002210| 31 31 20 09 09 09 09 09 | 7b 20 50 6c 61 63 65 20 |11 .....|{ Place |
|00002220| 25 20 44 6f 6e 65 20 69 | 6e 74 6f 20 63 65 6c 6c |% Done i|nto cell|
|00002230| 20 7d 0d 09 50 55 54 20 | 22 46 69 78 65 64 20 43 | }..PUT |"Fixed C|
|00002240| 6f 73 74 22 20 49 4e 54 | 4f 20 52 31 43 31 32 20 |ost" INT|O R1C12 |
|00002250| 09 09 09 09 7b 20 50 6c | 61 63 65 20 46 69 78 65 |....{ Pl|ace Fixe|
|00002260| 64 20 43 6f 73 74 20 69 | 6e 74 6f 20 63 65 6c 6c |d Cost i|nto cell|
|00002270| 20 7d 0d 09 50 55 54 20 | 22 52 65 73 6f 75 72 63 | }..PUT |"Resourc|
|00002280| 65 20 43 6f 73 74 22 20 | 49 4e 54 4f 20 52 31 43 |e Cost" |INTO R1C|
|00002290| 31 33 20 09 09 09 7b 20 | 50 6c 61 63 65 20 52 65 |13 ...{ |Place Re|
|000022a0| 73 6f 75 72 63 65 20 43 | 6f 73 74 20 69 6e 74 6f |source C|ost into|
|000022b0| 20 63 65 6c 6c 20 7d 0d | 09 50 55 54 20 22 46 69 | cell }.|.PUT "Fi|
|000022c0| 78 65 64 20 49 6e 63 6f | 6d 65 22 20 49 4e 54 4f |xed Inco|me" INTO|
|000022d0| 20 52 31 43 31 34 20 09 | 09 09 7b 20 50 6c 61 63 | R1C14 .|..{ Plac|
|000022e0| 65 20 46 69 78 65 64 20 | 49 6e 63 6f 6d 65 20 69 |e Fixed |Income i|
|000022f0| 6e 74 6f 20 63 65 6c 6c | 20 7d 0d 09 50 55 54 20 |nto cell| }..PUT |
|00002300| 22 41 63 74 75 61 6c 20 | 43 6f 73 74 22 20 49 4e |"Actual |Cost" IN|
|00002310| 54 4f 20 52 31 43 31 35 | 20 09 09 09 09 7b 20 50 |TO R1C15| ....{ P|
|00002320| 6c 61 63 65 20 41 63 74 | 75 61 6c 20 43 6f 73 74 |lace Act|ual Cost|
|00002330| 20 69 6e 74 6f 20 63 65 | 6c 6c 20 7d 0d 09 50 55 | into ce|ll }..PU|
|00002340| 54 20 22 41 63 74 2e 20 | 52 65 73 2e 20 43 6f 73 |T "Act. |Res. Cos|
|00002350| 74 22 20 49 4e 54 4f 20 | 52 31 43 31 36 20 09 09 |t" INTO |R1C16 ..|
|00002360| 09 7b 20 50 6c 61 63 65 | 20 41 63 74 75 61 6c 20 |.{ Place| Actual |
|00002370| 52 65 73 6f 75 72 63 65 | 20 43 6f 73 74 20 69 6e |Resource| Cost in|
|00002380| 74 6f 20 63 65 6c 6c 20 | 7d 0d 09 50 55 54 20 22 |to cell |}..PUT "|
|00002390| 41 63 74 75 61 6c 20 49 | 6e 63 6f 6d 65 22 20 49 |Actual I|ncome" I|
|000023a0| 4e 54 4f 20 52 31 43 31 | 37 20 09 09 09 7b 20 50 |NTO R1C1|7 ...{ P|
|000023b0| 6c 61 63 65 20 41 63 74 | 75 61 6c 20 49 6e 63 6f |lace Act|ual Inco|
|000023c0| 6d 65 20 69 6e 74 6f 20 | 63 65 6c 6c 20 7d 0d 09 |me into |cell }..|
|000023d0| 50 55 54 20 22 54 79 70 | 65 22 20 49 4e 54 4f 20 |PUT "Typ|e" INTO |
|000023e0| 52 31 43 31 38 20 09 09 | 09 09 09 7b 20 50 6c 61 |R1C18 ..|...{ Pla|
|000023f0| 63 65 20 54 79 70 65 20 | 69 6e 74 6f 20 63 65 6c |ce Type |into cel|
|00002400| 6c 20 7d 0d 09 50 55 54 | 20 22 53 75 62 70 72 6f |l }..PUT| "Subpro|
|00002410| 6a 65 63 74 22 20 49 4e | 54 4f 20 52 31 43 31 39 |ject" IN|TO R1C19|
|00002420| 20 09 09 09 09 7b 20 50 | 6c 61 63 65 20 53 75 62 | ....{ P|lace Sub|
|00002430| 70 72 6f 6a 65 63 74 20 | 69 6e 74 6f 20 63 65 6c |project |into cel|
|00002440| 6c 20 7d 0d 09 50 55 54 | 20 22 44 61 79 73 22 20 |l }..PUT| "Days" |
|00002450| 49 4e 54 4f 20 52 31 43 | 32 30 20 09 09 09 09 09 |INTO R1C|20 .....|
|00002460| 7b 20 50 6c 61 63 65 20 | 44 61 79 73 20 69 6e 74 |{ Place |Days int|
|00002470| 6f 20 63 65 6c 6c 20 7d | 0d 09 50 55 54 20 22 41 |o cell }|..PUT "A|
|00002480| 63 74 75 61 6c 20 44 61 | 79 73 22 20 49 4e 54 4f |ctual Da|ys" INTO|
|00002490| 20 52 31 43 32 31 20 09 | 09 09 09 7b 20 50 6c 61 | R1C21 .|...{ Pla|
|000024a0| 63 65 20 41 63 74 75 61 | 6c 20 44 61 79 73 20 69 |ce Actua|l Days i|
|000024b0| 6e 74 6f 20 63 65 6c 6c | 20 7d 0d 09 50 55 54 20 |nto cell| }..PUT |
|000024c0| 22 45 6c 61 70 73 65 64 | 20 54 69 6d 65 22 20 49 |"Elapsed| Time" I|
|000024d0| 4e 54 4f 20 52 31 43 32 | 32 20 09 09 09 7b 20 50 |NTO R1C2|2 ...{ P|
|000024e0| 6c 61 63 65 20 45 6c 61 | 70 73 65 64 20 54 69 6d |lace Ela|psed Tim|
|000024f0| 65 20 69 6e 74 6f 20 63 | 65 6c 6c 20 7d 0d 09 50 |e into c|ell }..P|
|00002500| 55 54 20 22 4c 65 76 65 | 6c 69 6e 67 20 50 72 69 |UT "Leve|ling Pri|
|00002510| 6f 72 69 74 79 22 20 49 | 4e 54 4f 20 52 31 43 32 |ority" I|NTO R1C2|
|00002520| 33 20 09 09 7b 20 50 6c | 61 63 65 20 4c 65 76 65 |3 ..{ Pl|ace Leve|
|00002530| 6c 69 6e 67 20 50 72 69 | 6f 72 69 74 79 20 69 6e |ling Pri|ority in|
|00002540| 74 6f 20 63 65 6c 6c 20 | 7d 0d 09 46 6f 72 20 6c |to cell |}..For l|
|00002550| 6f 6f 70 20 3d 20 32 33 | 20 74 6f 20 35 38 20 53 |oop = 23| to 58 S|
|00002560| 74 65 70 20 35 09 09 09 | 09 7b 20 52 65 70 65 61 |tep 5...|.{ Repea|
|00002570| 74 20 66 6f 72 20 61 6c | 6c 20 52 65 73 6f 75 72 |t for al|l Resour|
|00002580| 63 65 20 63 6f 6c 75 6d | 6e 73 20 7d 0d 09 09 09 |ce colum|ns }....|
|00002590| 50 55 54 20 22 52 65 73 | 6f 75 72 63 65 22 20 49 |PUT "Res|ource" I|
|000025a0| 4e 54 4f 20 52 41 4e 47 | 45 28 4d 41 4b 45 43 45 |NTO RANG|E(MAKECE|
|000025b0| 4c 4c 28 6c 6f 6f 70 20 | 2b 20 31 3b 20 31 29 29 |LL(loop |+ 1; 1))|
|000025c0| 09 7b 20 50 6c 61 63 65 | 20 52 65 73 6f 75 72 63 |.{ Place| Resourc|
|000025d0| 65 20 69 6e 74 6f 20 63 | 65 6c 6c 20 7d 0d 09 09 |e into c|ell }...|
|000025e0| 09 50 55 54 20 22 57 6f | 72 6b 2d 44 61 79 73 22 |.PUT "Wo|rk-Days"|
|000025f0| 20 49 4e 54 4f 20 52 41 | 4e 47 45 28 4d 41 4b 45 | INTO RA|NGE(MAKE|
|00002600| 43 45 4c 4c 28 6c 6f 6f | 70 20 2b 20 32 3b 20 31 |CELL(loo|p + 2; 1|
|00002610| 29 29 09 7b 20 50 6c 61 | 63 65 20 57 6f 72 6b 2d |)).{ Pla|ce Work-|
|00002620| 44 61 79 73 20 69 6e 74 | 6f 20 63 65 6c 6c 20 7d |Days int|o cell }|
|00002630| 0d 09 09 09 50 55 54 20 | 22 4e 75 6d 62 65 72 22 |....PUT |"Number"|
|00002640| 20 49 4e 54 4f 20 52 41 | 4e 47 45 28 4d 41 4b 45 | INTO RA|NGE(MAKE|
|00002650| 43 45 4c 4c 28 6c 6f 6f | 70 20 2b 20 33 3b 20 31 |CELL(loo|p + 3; 1|
|00002660| 29 29 09 7b 20 50 6c 61 | 63 65 20 4e 75 6d 62 65 |)).{ Pla|ce Numbe|
|00002670| 72 20 69 6e 74 6f 20 63 | 65 6c 6c 20 7d 0d 09 09 |r into c|ell }...|
|00002680| 09 50 55 54 20 22 25 20 | 45 66 66 6f 72 74 22 20 |.PUT "% |Effort" |
|00002690| 49 4e 54 4f 20 52 41 4e | 47 45 28 4d 41 4b 45 43 |INTO RAN|GE(MAKEC|
|000026a0| 45 4c 4c 28 6c 6f 6f 70 | 20 2b 20 34 3b 20 31 29 |ELL(loop| + 4; 1)|
|000026b0| 29 09 7b 20 50 6c 61 63 | 65 20 25 20 45 66 66 6f |).{ Plac|e % Effo|
|000026c0| 72 74 20 69 6e 74 6f 20 | 63 65 6c 6c 20 7d 0d 09 |rt into |cell }..|
|000026d0| 09 09 50 55 54 20 22 44 | 75 72 61 74 69 6f 6e 22 |..PUT "D|uration"|
|000026e0| 20 49 4e 54 4f 20 52 41 | 4e 47 45 28 4d 41 4b 45 | INTO RA|NGE(MAKE|
|000026f0| 43 45 4c 4c 28 6c 6f 6f | 70 20 2b 20 35 3b 20 31 |CELL(loo|p + 5; 1|
|00002700| 29 29 09 7b 20 50 6c 61 | 63 65 20 44 75 72 61 74 |)).{ Pla|ce Durat|
|00002710| 69 6f 6e 20 69 6e 74 6f | 20 63 65 6c 6c 20 7d 0d |ion into| cell }.|
|00002720| 09 45 4e 44 20 46 4f 52 | 09 09 09 09 09 09 09 09 |.END FOR|........|
|00002730| 7b 20 45 6e 64 20 46 4f | 52 20 6c 6f 6f 70 20 7d |{ End FO|R loop }|
|00002740| 0d 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 20 44 |..SELECT| RANGE D|
|00002750| 31 2e 2e 47 33 32 37 36 | 38 09 09 09 09 09 7b 20 |1..G3276|8.....{ |
|00002760| 53 65 6c 65 63 74 20 45 | 53 2c 20 45 46 2c 20 4c |Select E|S, EF, L|
|00002770| 53 2c 20 4c 46 20 63 6f | 6c 75 6d 6e 73 20 7d 0d |S, LF co|lumns }.|
|00002780| 09 46 4f 52 4d 41 54 20 | 44 41 54 45 20 31 09 09 |.FORMAT |DATE 1..|
|00002790| 09 09 09 09 09 7b 20 46 | 6f 72 6d 61 74 20 61 73 |.....{ F|ormat as|
|000027a0| 20 4d 4d 2f 44 44 2f 59 | 59 20 7d 0d 09 53 45 4c | MM/DD/Y|Y }..SEL|
|000027b0| 45 43 54 20 52 41 4e 47 | 45 20 49 31 2e 2e 4a 33 |ECT RANG|E I1..J3|
|000027c0| 32 37 36 38 09 09 09 09 | 09 7b 20 53 65 6c 65 63 |2768....|.{ Selec|
|000027d0| 74 20 41 53 2c 20 41 46 | 20 63 6f 6c 75 6d 6e 73 |t AS, AF| columns|
|000027e0| 20 7d 0d 09 46 4f 52 4d | 41 54 20 44 41 54 45 20 | }..FORM|AT DATE |
|000027f0| 31 09 09 09 09 09 09 09 | 7b 20 46 6f 72 6d 61 74 |1.......|{ Format|
|00002800| 20 61 73 20 4d 4d 2f 44 | 44 2f 59 59 20 7d 0d 09 | as MM/D|D/YY }..|
|00002810| 53 45 4c 45 43 54 20 52 | 41 4e 47 45 20 41 31 2e |SELECT R|ANGE A1.|
|00002820| 2e 41 33 32 37 36 38 09 | 09 09 09 09 7b 20 53 65 |.A32768.|....{ Se|
|00002830| 6c 65 63 74 20 66 6b 20 | 63 6f 6c 75 6d 6e 20 7d |lect fk |column }|
|00002840| 0d 09 49 4e 53 45 52 54 | 09 09 09 09 09 09 09 09 |..INSERT|........|
|00002850| 7b 20 49 6e 73 65 72 74 | 20 61 20 6e 65 77 20 63 |{ Insert| a new c|
|00002860| 6f 6c 75 6d 6e 20 7d 0d | 09 55 4e 53 45 4c 45 43 |olumn }.|.UNSELEC|
|00002870| 54 09 09 09 09 09 09 09 | 09 7b 20 55 4e 53 45 4c |T.......|.{ UNSEL|
|00002880| 45 43 54 20 61 6c 6c 20 | 66 69 65 6c 64 73 20 7d |ECT all |fields }|
|00002890| 0d 09 48 49 44 45 20 48 | 45 41 44 49 4e 47 53 09 |..HIDE H|EADINGS.|
|000028a0| 09 09 09 09 09 09 7b 20 | 48 69 64 65 20 63 6f 6c |......{ |Hide col|
|000028b0| 75 6d 6e 20 68 65 61 64 | 69 6e 67 73 20 7d 0d 09 |umn head|ings }..|
|000028c0| 48 49 44 45 20 54 4f 4f | 4c 20 42 4f 58 09 09 09 |HIDE TOO|L BOX...|
|000028d0| 09 09 09 09 7b 20 48 69 | 64 65 20 74 6f 6f 6c 20 |....{ Hi|de tool |
|000028e0| 70 61 6c 65 74 74 65 20 | 7d 0d 09 48 49 44 45 20 |palette |}..HIDE |
|000028f0| 45 4e 54 52 59 20 42 41 | 52 09 09 09 09 09 09 09 |ENTRY BA|R.......|
|00002900| 7b 20 48 69 64 65 20 65 | 6e 74 72 79 20 62 61 72 |{ Hide e|ntry bar|
|00002910| 20 7d 0d 09 48 49 44 45 | 20 43 45 4c 4c 20 47 52 | }..HIDE| CELL GR|
|00002920| 49 44 09 09 09 09 09 09 | 09 7b 20 48 69 64 65 20 |ID......|.{ Hide |
|00002930| 77 6f 72 6b 73 68 65 65 | 74 20 67 72 69 64 20 7d |workshee|t grid }|
|00002940| 0d 09 46 6f 72 20 6c 6f | 6f 70 20 3d 20 32 20 74 |..For lo|op = 2 t|
|00002950| 6f 20 34 09 09 09 09 09 | 09 7b 20 53 74 6f 72 61 |o 4.....|.{ Stora|
|00002960| 67 65 20 66 6f 72 20 73 | 6f 72 74 20 6b 65 79 20 |ge for s|ort key |
|00002970| 73 65 74 74 69 6e 67 73 | 20 7d 0d 09 09 50 55 54 |settings| }...PUT|
|00002980| 20 31 20 49 4e 54 4f 20 | 52 41 4e 47 45 28 4d 41 | 1 INTO |RANGE(MA|
|00002990| 4b 45 43 45 4c 4c 28 36 | 35 3b 6c 6f 6f 70 29 29 |KECELL(6|5;loop))|
|000029a0| 09 7b 20 53 65 74 20 61 | 6c 6c 20 73 6f 72 74 20 |.{ Set a|ll sort |
|000029b0| 76 61 6c 75 65 73 20 74 | 6f 20 31 20 28 69 6e 69 |values t|o 1 (ini|
|000029c0| 74 69 61 6c 6c 79 29 20 | 7d 0d 09 45 4e 44 20 46 |tially) |}..END F|
|000029d0| 4f 52 09 09 09 09 09 09 | 09 09 7b 20 45 6e 64 20 |OR......|..{ End |
|000029e0| 6f 66 20 46 4f 52 20 6c | 6f 6f 70 20 7d 0d 09 46 |of FOR l|oop }..F|
|000029f0| 6f 72 20 6c 6f 6f 70 20 | 3d 20 35 20 74 6f 20 37 |or loop |= 5 to 7|
|00002a00| 09 09 09 09 09 09 7b 20 | 53 74 6f 72 61 67 65 20 |......{ |Storage |
|00002a10| 66 6f 72 20 64 65 73 63 | 65 6e 64 69 6e 67 20 63 |for desc|ending c|
|00002a20| 68 65 63 6b 20 62 6f 78 | 20 73 65 74 74 69 6e 67 |heck box| setting|
|00002a30| 73 20 7d 0d 09 09 50 55 | 54 20 30 20 49 4e 54 4f |s }...PU|T 0 INTO|
|00002a40| 20 52 41 4e 47 45 28 4d | 41 4b 45 43 45 4c 4c 28 | RANGE(M|AKECELL(|
|00002a50| 36 35 3b 6c 6f 6f 70 29 | 29 09 7b 20 53 65 74 20 |65;loop)|).{ Set |
|00002a60| 61 6c 6c 20 63 68 65 63 | 6b 20 62 6f 78 65 73 20 |all chec|k boxes |
|00002a70| 74 6f 20 30 20 28 69 6e | 69 74 69 61 6c 6c 79 29 |to 0 (in|itially)|
|00002a80| 20 7d 0d 09 45 4e 44 20 | 46 4f 52 09 09 09 09 09 | }..END |FOR.....|
|00002a90| 09 09 09 7b 20 45 6e 64 | 20 6f 66 20 46 4f 52 20 |...{ End| of FOR |
|00002aa0| 6c 6f 6f 70 20 7d 0d 09 | 50 55 54 20 6c 61 73 74 |loop }..|PUT last|
|00002ab0| 5f 72 6f 77 20 49 4e 54 | 4f 20 52 38 43 36 35 09 |_row INT|O R8C65.|
|00002ac0| 09 09 09 09 7b 20 53 74 | 6f 72 61 67 65 20 66 6f |....{ St|orage fo|
|00002ad0| 72 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |r number| of rows|
|00002ae0| 20 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 | }..SELE|CT RANGE|
|00002af0| 20 22 52 32 43 36 35 2e | 2e 52 38 43 36 35 22 09 | "R2C65.|.R8C65".|
|00002b00| 09 09 09 7b 20 53 65 6c | 65 63 74 20 73 74 6f 72 |...{ Sel|ect stor|
|00002b10| 61 67 65 20 72 61 6e 67 | 65 20 7d 0d 09 48 49 44 |age rang|e }..HID|
|00002b20| 45 20 43 45 4c 4c 53 09 | 09 09 09 09 09 09 7b 20 |E CELLS.|......{ |
|00002b30| 48 69 64 65 20 73 74 6f | 72 61 67 65 20 72 61 6e |Hide sto|rage ran|
|00002b40| 67 65 20 7d 0d 09 53 45 | 4c 45 43 54 20 52 41 4e |ge }..SE|LECT RAN|
|00002b50| 47 45 20 22 41 31 22 09 | 09 09 09 09 09 7b 20 47 |GE "A1".|.....{ G|
|00002b60| 6f 20 74 6f 20 66 69 72 | 73 74 20 63 65 6c 6c 20 |o to fir|st cell |
|00002b70| 7d 0d 09 55 4e 53 45 4c | 45 43 54 09 09 09 09 09 |}..UNSEL|ECT.....|
|00002b80| 09 09 09 7b 20 55 4e 53 | 45 4c 45 43 54 20 63 65 |...{ UNS|ELECT ce|
|00002b90| 6c 6c 73 20 7d 0d 45 4e | 44 20 46 55 4e 43 54 49 |lls }.EN|D FUNCTI|
|00002ba0| 4f 4e 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ON..{***|********|
|00002bb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002bc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 47 45 54 5f 52 |********|** GET_R|
|00002bd0| 4f 57 53 20 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |OWS ****|********|
|00002be0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002bf0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 0d 20 20 54 68 69 |********|**.  Thi|
|00002c10| 73 20 66 75 6e 63 74 69 | 6f 6e 20 64 65 74 65 72 |s functi|on deter|
|00002c20| 6d 69 6e 65 73 20 74 68 | 65 20 6e 75 6d 62 65 72 |mines th|e number|
|00002c30| 20 6f 66 20 72 6f 77 73 | 20 75 73 65 64 20 6f 6e | of rows| used on|
|00002c40| 20 61 20 63 68 61 72 74 | 2e 20 20 57 65 20 66 69 | a chart|.  We fi|
|00002c50| 72 73 74 20 73 65 6c 65 | 63 74 20 61 6c 6c 20 61 |rst sele|ct all a|
|00002c60| 63 74 69 76 65 20 63 65 | 6c 6c 73 2e 0d 20 20 57 |ctive ce|lls..  W|
|00002c70| 65 20 74 68 65 6e 20 75 | 73 65 20 74 68 65 20 53 |e then u|se the S|
|00002c80| 45 4c 45 43 54 49 4f 4e | 20 66 75 6e 63 74 69 6f |ELECTION| functio|
|00002c90| 6e 20 74 6f 20 72 65 74 | 75 72 6e 20 74 68 65 20 |n to ret|urn the |
|00002ca0| 72 61 6e 67 65 20 61 6e | 64 20 74 68 65 20 52 4f |range an|d the RO|
|00002cb0| 57 53 20 66 75 6e 63 74 | 69 6f 6e 20 74 6f 20 67 |WS funct|ion to g|
|00002cc0| 65 74 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |et the n|umber of|
|00002cd0| 0d 20 20 72 6f 77 73 20 | 69 6e 20 74 68 61 74 20 |.  rows |in that |
|00002ce0| 72 61 6e 67 65 2e 20 20 | 54 68 65 20 72 65 73 75 |range.  |The resu|
|00002cf0| 6c 74 69 6e 67 20 76 61 | 6c 75 65 20 69 73 20 74 |lting va|lue is t|
|00002d00| 68 65 6e 20 72 65 74 75 | 72 6e 65 64 20 74 6f 20 |hen retu|rned to |
|00002d10| 74 68 65 20 63 61 6c 6c | 69 6e 67 20 73 74 61 74 |the call|ing stat|
|00002d20| 65 6d 65 6e 74 2e 0d 20 | 2a 2a 2a 2a 2a 2a 2a 2a |ement.. |********|
|00002d30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 46 |********|****}..F|
|00002d90| 55 4e 43 54 49 4f 4e 20 | 47 45 54 5f 52 4f 57 53 |UNCTION |GET_ROWS|
|00002da0| 28 29 0d 09 53 45 4c 45 | 43 54 20 41 43 54 49 56 |()..SELE|CT ACTIV|
|00002db0| 45 20 43 45 4c 4c 53 09 | 09 09 09 09 09 7b 20 53 |E CELLS.|.....{ S|
|00002dc0| 65 6c 65 63 74 20 6e 6f | 6e 2d 62 6c 61 6e 6b 20 |elect no|n-blank |
|00002dd0| 63 65 6c 6c 73 20 7d 0d | 09 52 45 54 55 52 4e 20 |cells }.|.RETURN |
|00002de0| 52 4f 57 53 28 53 45 4c | 45 43 54 49 4f 4e 28 31 |ROWS(SEL|ECTION(1|
|00002df0| 29 29 20 2b 20 31 09 09 | 09 09 7b 20 44 65 74 65 |)) + 1..|..{ Dete|
|00002e00| 72 6d 69 6e 65 20 23 20 | 6f 66 20 72 6f 77 73 20 |rmine # |of rows |
|00002e10| 69 6e 20 73 65 6c 65 63 | 74 65 64 20 72 61 6e 67 |in selec|ted rang|
|00002e20| 65 20 7d 0d 45 4e 44 20 | 46 55 4e 43 54 49 4f 4e |e }.END |FUNCTION|
|00002e30| 0d 0d 7b 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |..{*****|********|
|00002e40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e50| 2a 2a 2a 2a 2a 2a 2a 2a | 20 41 44 44 5f 42 55 54 |********| ADD_BUT|
|00002e60| 54 4f 4e 20 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |TON ****|********|
|00002e70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e90| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 20 20 54 68 69 73 20 |********|.  This |
|00002ea0| 66 75 6e 63 74 69 6f 6e | 20 61 64 64 73 20 61 20 |function| adds a |
|00002eb0| 62 75 74 74 6f 6e 20 69 | 6e 74 6f 20 63 6f 6c 75 |button i|nto colu|
|00002ec0| 6d 6e 20 31 20 74 6f 20 | 61 6c 6c 6f 77 20 66 75 |mn 1 to |allow fu|
|00002ed0| 72 74 68 65 72 20 73 6f | 72 74 69 6e 67 20 6f 66 |rther so|rting of|
|00002ee0| 20 74 68 65 20 50 72 6f | 6a 65 63 74 20 54 61 62 | the Pro|ject Tab|
|00002ef0| 6c 65 2e 0d 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |le.. ***|********|
|00002f00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 46 55 4e 43 |********|*}..FUNC|
|00002f60| 54 49 4f 4e 20 41 44 44 | 5f 42 55 54 54 4f 4e 28 |TION ADD|_BUTTON(|
|00002f70| 29 0d 09 41 44 44 20 50 | 55 53 48 20 42 55 54 54 |)..ADD P|USH BUTT|
|00002f80| 4f 4e 20 22 53 6f 72 74 | 2e 2e 2e 22 20 52 41 4e |ON "Sort|..." RAN|
|00002f90| 47 45 20 28 66 72 61 63 | 28 41 32 2e 2e 41 33 3b |GE (frac|(A2..A3;|
|00002fa0| 30 3b 34 32 3b 31 32 35 | 3b 32 31 37 29 29 09 7b |0;42;125|;217)).{|
|00002fb0| 20 41 64 64 20 53 6f 72 | 74 20 62 75 74 74 6f 6e | Add Sor|t button|
|00002fc0| 20 74 6f 20 77 6f 72 6b | 73 68 65 65 74 20 7d 0d | to work|sheet }.|
|00002fd0| 09 53 43 52 49 50 54 09 | 09 09 09 09 09 09 09 09 |.SCRIPT.|........|
|00002fe0| 09 7b 20 53 63 72 69 70 | 74 20 66 6f 72 20 70 75 |.{ Scrip|t for pu|
|00002ff0| 73 68 20 62 75 74 74 6f | 6e 20 7d 0d 22 4f 4e 20 |sh butto|n }."ON |
|00003000| 4d 4f 55 53 45 55 50 0d | 09 47 45 54 20 53 43 52 |MOUSEUP.|.GET SCR|
|00003010| 49 50 54 20 22 22 53 6f | 72 74 20 53 63 72 69 70 |IPT ""So|rt Scrip|
|00003020| 74 22 22 0d 09 43 41 4c | 4c 20 27 53 6f 72 74 20 |t""..CAL|L 'Sort |
|00003030| 53 63 72 69 70 74 3a 53 | 4f 52 54 5f 44 49 41 4c |Script:S|ORT_DIAL|
|00003040| 4f 47 27 28 29 0d 09 52 | 45 4d 4f 56 45 20 53 43 |OG'()..R|EMOVE SC|
|00003050| 52 49 50 54 20 22 22 53 | 6f 72 74 20 53 63 72 69 |RIPT ""S|ort Scri|
|00003060| 70 74 22 22 0d 45 4e 44 | 20 4d 4f 55 53 45 55 50 |pt"".END| MOUSEUP|
|00003070| 22 09 09 09 09 09 09 09 | 09 09 09 7b 20 45 6e 64 |".......|...{ End|
|00003080| 20 70 75 73 68 20 62 75 | 74 74 6f 6e 20 73 63 72 | push bu|tton scr|
|00003090| 69 70 74 20 7d 0d 09 53 | 45 4c 45 43 54 20 52 41 |ipt }..S|ELECT RA|
|000030a0| 4e 47 45 20 41 31 09 09 | 09 09 09 09 09 09 7b 20 |NGE A1..|......{ |
|000030b0| 53 65 6c 65 63 74 20 66 | 69 72 73 74 20 63 65 6c |Select f|irst cel|
|000030c0| 6c 20 7d 0d 09 43 4f 4c | 55 4d 4e 20 57 49 44 54 |l }..COL|UMN WIDT|
|000030d0| 48 20 31 2e 32 20 49 4e | 43 48 09 09 09 09 09 09 |H 1.2 IN|CH......|
|000030e0| 09 7b 20 53 65 74 20 74 | 68 65 20 63 6f 6c 75 6d |.{ Set t|he colum|
|000030f0| 6e 20 77 69 64 74 68 20 | 7d 0d 45 4e 44 20 46 55 |n width |}.END FU|
|00003100| 4e 43 54 49 4f 4e 0d 09 | 0d 7b 2a 2a 2a 2a 2a 2a |NCTION..|.{******|
|00003110| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|00003130| 53 4f 52 54 5f 44 49 41 | 4c 4f 47 20 2a 2a 2a 2a |SORT_DIA|LOG ****|
|00003140| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003150| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003160| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00003170| 20 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |  This f|unction |
|00003180| 64 69 73 70 6c 61 79 73 | 20 61 20 6d 6f 64 61 6c |displays| a modal|
|00003190| 20 64 69 61 6c 6f 67 20 | 62 6f 78 20 77 68 69 63 | dialog |box whic|
|000031a0| 68 20 61 73 6b 73 20 77 | 68 61 74 20 74 79 70 65 |h asks w|hat type|
|000031b0| 20 6f 66 20 73 6f 72 74 | 20 77 65 20 77 61 6e 74 | of sort| we want|
|000031c0| 20 74 6f 20 70 65 72 66 | 6f 72 6d 2e 0d 20 2a 2a | to perf|orm.. **|
|000031d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000031e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000031f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003210| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003230| 2a 2a 7d 0d 0d 46 55 4e | 43 54 49 4f 4e 20 53 4f |**}..FUN|CTION SO|
|00003240| 52 54 5f 44 49 41 4c 4f | 47 28 29 0d 09 6c 61 73 |RT_DIALO|G()..las|
|00003250| 74 5f 72 6f 77 20 3d 20 | 49 4e 44 49 52 45 43 54 |t_row = |INDIRECT|
|00003260| 28 22 52 38 43 36 35 22 | 29 09 09 09 09 09 09 7b |("R8C65"|)......{|
|00003270| 20 67 65 74 20 6c 61 73 | 74 5f 72 6f 77 20 66 72 | get las|t_row fr|
|00003280| 6f 6d 20 73 74 6f 72 61 | 67 65 20 7d 0d 0d 09 4e |om stora|ge }...N|
|00003290| 45 57 20 4d 4f 44 41 4c | 20 44 49 41 4c 4f 47 20 |EW MODAL| DIALOG |
|000032a0| 42 4f 58 20 41 54 20 28 | 2d 31 3b 2d 31 29 28 34 |BOX AT (|-1;-1)(4|
|000032b0| 2e 35 20 49 4e 43 48 3b | 32 2e 37 35 20 49 4e 43 |.5 INCH;|2.75 INC|
|000032c0| 48 29 20 20 09 7b 20 43 | 72 65 61 74 65 20 61 20 |H)  .{ C|reate a |
|000032d0| 63 65 6e 74 65 72 65 64 | 20 6d 6f 64 61 6c 20 64 |centered| modal d|
|000032e0| 69 61 6c 6f 67 20 62 6f | 78 20 7d 0d 7b 31 7d 09 |ialog bo|x }.{1}.|
|000032f0| 41 44 44 20 50 55 53 48 | 20 42 55 54 54 4f 4e 20 |ADD PUSH| BUTTON |
|00003300| 22 20 20 20 20 43 61 6e | 63 65 6c 20 20 20 20 22 |"    Can|cel    "|
|00003310| 20 41 54 20 09 09 09 09 | 7b 20 41 64 64 20 43 61 | AT ....|{ Add Ca|
|00003320| 6e 63 65 6c 20 62 75 74 | 74 6f 6e 20 7d 0d 09 09 |ncel but|ton }...|
|00003330| 28 32 2e 30 20 49 4e 43 | 48 3b 20 32 2e 33 35 20 |(2.0 INC|H; 2.35 |
|00003340| 49 4e 43 48 29 20 2b 20 | 28 31 20 49 4e 43 48 3b |INCH) + |(1 INCH;|
|00003350| 20 2e 32 35 20 49 4e 43 | 48 29 09 09 09 0d 7b 32 | .25 INC|H)....{2|
|00003360| 7d 09 41 44 44 20 50 55 | 53 48 20 42 55 54 54 4f |}.ADD PU|SH BUTTO|
|00003370| 4e 20 22 20 20 20 20 4f | 4b 20 20 20 20 22 20 41 |N "    O|K    " A|
|00003380| 54 20 09 09 09 09 09 7b | 20 41 64 64 20 4f 4b 20 |T .....{| Add OK |
|00003390| 62 75 74 74 6f 6e 20 7d | 0d 09 09 28 33 2e 32 35 |button }|...(3.25|
|000033a0| 20 49 4e 43 48 3b 20 32 | 2e 33 35 20 49 4e 43 48 | INCH; 2|.35 INCH|
|000033b0| 29 20 2b 20 28 31 20 49 | 4e 43 48 3b 20 2e 32 35 |) + (1 I|NCH; .25|
|000033c0| 20 49 4e 43 48 29 09 09 | 09 0d 09 53 45 4c 45 43 | INCH)..|...SELEC|
|000033d0| 54 20 43 4f 4e 54 52 4f | 4c 20 31 09 09 09 09 09 |T CONTRO|L 1.....|
|000033e0| 09 09 09 7b 20 53 65 6c | 65 63 74 20 43 61 6e 63 |...{ Sel|ect Canc|
|000033f0| 65 6c 20 62 75 74 74 6f | 6e 20 7d 0d 09 44 49 41 |el butto|n }..DIA|
|00003400| 4c 4f 47 20 43 41 4e 43 | 45 4c 20 50 55 53 48 20 |LOG CANC|EL PUSH |
|00003410| 42 55 54 54 4f 4e 09 09 | 09 09 09 09 7b 20 44 65 |BUTTON..|....{ De|
|00003420| 66 69 6e 65 20 62 75 74 | 74 6f 6e 20 61 73 20 61 |fine but|ton as a|
|00003430| 20 63 61 6e 63 65 6c 20 | 62 75 74 74 6f 6e 20 7d | cancel |button }|
|00003440| 0d 09 53 43 52 49 50 54 | 20 22 27 53 6f 72 74 20 |..SCRIPT| "'Sort |
|00003450| 53 63 72 69 70 74 3a 64 | 6f 6e 65 27 20 3d 20 30 |Script:d|one' = 0|
|00003460| 22 09 09 09 09 09 7b 20 | 53 65 74 20 64 6f 6e 65 |".....{ |Set done|
|00003470| 20 66 6c 61 67 20 74 6f | 20 30 20 7d 0d 09 53 45 | flag to| 0 }..SE|
|00003480| 4c 45 43 54 20 43 4f 4e | 54 52 4f 4c 20 32 09 09 |LECT CON|TROL 2..|
|00003490| 09 09 09 09 09 09 7b 20 | 53 65 6c 65 63 74 20 4f |......{ |Select O|
|000034a0| 4b 20 62 75 74 74 6f 6e | 20 7d 0d 09 44 49 41 4c |K button| }..DIAL|
|000034b0| 4f 47 20 44 45 46 41 55 | 4c 54 20 50 55 53 48 20 |OG DEFAU|LT PUSH |
|000034c0| 42 55 54 54 4f 4e 09 09 | 09 09 09 09 7b 20 44 65 |BUTTON..|....{ De|
|000034d0| 66 69 6e 65 20 64 65 66 | 61 75 6c 74 20 62 75 74 |fine def|ault but|
|000034e0| 74 6f 6e 20 61 6e 64 20 | 61 73 73 69 67 6e 20 73 |ton and |assign s|
|000034f0| 63 72 69 70 74 20 7d 0d | 09 53 43 52 49 50 54 22 |cript }.|.SCRIPT"|
|00003500| 0d 09 09 27 53 6f 72 74 | 20 53 63 72 69 70 74 3a |...'Sort| Script:|
|00003510| 66 6b 27 20 3d 20 43 54 | 56 41 4c 55 45 28 34 3b |fk' = CT|VALUE(4;|
|00003520| 30 29 0d 09 09 27 53 6f | 72 74 20 53 63 72 69 70 |0)...'So|rt Scrip|
|00003530| 74 3a 73 6b 27 20 3d 20 | 43 54 56 41 4c 55 45 28 |t:sk' = |CTVALUE(|
|00003540| 35 3b 30 29 0d 09 09 27 | 53 6f 72 74 20 53 63 72 |5;0)...'|Sort Scr|
|00003550| 69 70 74 3a 74 6b 27 20 | 3d 20 43 54 56 41 4c 55 |ipt:tk' |= CTVALU|
|00003560| 45 28 36 3b 30 29 0d 09 | 09 27 53 6f 72 74 20 53 |E(6;0)..|.'Sort S|
|00003570| 63 72 69 70 74 3a 6d 31 | 27 20 3d 20 43 54 56 41 |cript:m1|' = CTVA|
|00003580| 4c 55 45 28 37 3b 31 29 | 0d 09 09 27 53 6f 72 74 |LUE(7;1)|...'Sort|
|00003590| 20 53 63 72 69 70 74 3a | 6d 32 27 20 3d 20 43 54 | Script:|m2' = CT|
|000035a0| 56 41 4c 55 45 28 37 3b | 32 29 0d 09 09 27 53 6f |VALUE(7;|2)...'So|
|000035b0| 72 74 20 53 63 72 69 70 | 74 3a 6d 33 27 20 3d 20 |rt Scrip|t:m3' = |
|000035c0| 43 54 56 41 4c 55 45 28 | 37 3b 33 29 0d 09 09 27 |CTVALUE(|7;3)...'|
|000035d0| 53 6f 72 74 20 53 63 72 | 69 70 74 3a 64 6f 6e 65 |Sort Scr|ipt:done|
|000035e0| 27 20 3d 20 31 22 0d 7b | 33 7d 09 41 44 44 20 54 |' = 1".{|3}.ADD T|
|000035f0| 45 58 54 20 22 53 6f 72 | 74 22 20 09 09 09 09 09 |EXT "Sor|t" .....|
|00003600| 09 09 09 7b 20 50 6c 61 | 63 65 20 74 65 78 74 20 |...{ Pla|ce text |
|00003610| 69 6e 74 6f 20 64 69 61 | 6c 6f 67 20 62 6f 78 20 |into dia|log box |
|00003620| 7d 0d 09 09 41 54 20 28 | 2e 31 32 35 20 49 4e 43 |}...AT (|.125 INC|
|00003630| 48 3b 20 2e 31 32 35 20 | 49 4e 43 48 29 20 2b 20 |H; .125 |INCH) + |
|00003640| 28 34 20 49 4e 43 48 3b | 20 31 20 49 4e 43 48 29 |(4 INCH;| 1 INCH)|
|00003650| 0d 09 4e 4f 20 4c 49 4e | 45 20 42 4f 52 44 45 52 |..NO LIN|E BORDER|
|00003660| 09 09 09 09 09 09 09 09 | 09 7b 20 54 75 72 6e 20 |........|.{ Turn |
|00003670| 6f 66 66 20 6c 69 6e 65 | 20 62 6f 72 64 65 72 20 |off line| border |
|00003680| 66 6f 72 20 74 65 78 74 | 20 6f 62 6a 65 63 74 20 |for text| object |
|00003690| 7d 0d 7b 34 7d 09 41 44 | 44 20 50 4f 50 55 50 20 |}.{4}.AD|D POPUP |
|000036a0| 4d 45 4e 55 20 22 54 61 | 73 6b 20 4e 61 6d 65 22 |MENU "Ta|sk Name"|
|000036b0| 3b 22 45 61 72 6c 69 65 | 73 74 20 53 74 61 72 74 |;"Earlie|st Start|
|000036c0| 22 3b 09 09 09 7b 20 41 | 64 64 20 70 6f 70 75 70 |";...{ A|dd popup|
|000036d0| 20 66 6f 72 20 4b 65 79 | 20 31 20 7d 0d 09 09 22 | for Key| 1 }..."|
|000036e0| 41 63 74 75 61 6c 20 53 | 74 61 72 74 22 3b 22 25 |Actual S|tart";"%|
|000036f0| 20 44 6f 6e 65 22 3b 22 | 53 75 62 74 69 74 6c 65 | Done";"|Subtitle|
|00003700| 22 20 0d 09 09 41 54 20 | 28 31 2e 30 35 20 49 4e |" ...AT |(1.05 IN|
|00003710| 43 48 3b 20 2e 35 35 20 | 49 4e 43 48 29 20 2b 20 |CH; .55 |INCH) + |
|00003720| 28 31 2e 35 35 20 49 4e | 43 48 3b 20 2e 32 35 20 |(1.55 IN|CH; .25 |
|00003730| 49 4e 43 48 20 29 0d 09 | 43 55 52 52 45 4e 54 20 |INCH )..|CURRENT |
|00003740| 50 4f 50 55 50 20 4d 45 | 4e 55 20 49 54 45 4d 20 |POPUP ME|NU ITEM |
|00003750| 49 4e 44 49 52 45 43 54 | 20 28 22 52 32 43 36 35 |INDIRECT| ("R2C65|
|00003760| 22 29 09 09 09 7b 20 47 | 65 74 20 6c 61 73 74 20 |")...{ G|et last |
|00003770| 73 65 6c 65 63 74 69 6f | 6e 20 66 72 6f 6d 20 73 |selectio|n from s|
|00003780| 74 6f 72 61 67 65 20 7d | 0d 7b 35 7d 09 41 44 44 |torage }|.{5}.ADD|
|00003790| 20 50 4f 50 55 50 20 4d | 45 4e 55 20 22 54 61 73 | POPUP M|ENU "Tas|
|000037a0| 6b 20 4e 61 6d 65 22 3b | 22 45 61 72 6c 69 65 73 |k Name";|"Earlies|
|000037b0| 74 20 53 74 61 72 74 22 | 3b 09 09 09 7b 20 41 64 |t Start"|;...{ Ad|
|000037c0| 64 20 70 6f 70 75 70 20 | 66 6f 72 20 4b 65 79 20 |d popup |for Key |
|000037d0| 32 20 7d 0d 09 09 22 41 | 63 74 75 61 6c 20 53 74 |2 }..."A|ctual St|
|000037e0| 61 72 74 22 3b 22 25 20 | 44 6f 6e 65 22 3b 22 53 |art";"% |Done";"S|
|000037f0| 75 62 74 69 74 6c 65 22 | 20 0d 09 09 41 54 20 28 |ubtitle"| ...AT (|
|00003800| 31 2e 30 35 20 49 4e 43 | 48 3b 20 31 2e 31 35 20 |1.05 INC|H; 1.15 |
|00003810| 49 4e 43 48 29 20 2b 20 | 28 31 2e 35 35 20 49 4e |INCH) + |(1.55 IN|
|00003820| 43 48 3b 20 2e 32 35 20 | 49 4e 43 48 20 29 09 09 |CH; .25 |INCH )..|
|00003830| 0d 09 43 55 52 52 45 4e | 54 20 50 4f 50 55 50 20 |..CURREN|T POPUP |
|00003840| 4d 45 4e 55 20 49 54 45 | 4d 20 49 4e 44 49 52 45 |MENU ITE|M INDIRE|
|00003850| 43 54 20 28 22 52 33 43 | 36 35 22 29 09 09 09 7b |CT ("R3C|65")...{|
|00003860| 20 47 65 74 20 6c 61 73 | 74 20 73 65 6c 65 63 74 | Get las|t select|
|00003870| 69 6f 6e 20 66 72 6f 6d | 20 73 74 6f 72 61 67 65 |ion from| storage|
|00003880| 20 7d 0d 7b 36 7d 09 41 | 44 44 20 50 4f 50 55 50 | }.{6}.A|DD POPUP|
|00003890| 20 4d 45 4e 55 20 22 54 | 61 73 6b 20 4e 61 6d 65 | MENU "T|ask Name|
|000038a0| 22 3b 22 45 61 72 6c 69 | 65 73 74 20 53 74 61 72 |";"Earli|est Star|
|000038b0| 74 22 3b 09 09 09 7b 20 | 41 64 64 20 70 6f 70 75 |t";...{ |Add popu|
|000038c0| 70 20 66 6f 72 20 4b 65 | 79 20 33 20 7d 0d 09 09 |p for Ke|y 3 }...|
|000038d0| 22 41 63 74 75 61 6c 20 | 53 74 61 72 74 22 3b 22 |"Actual |Start";"|
|000038e0| 25 20 44 6f 6e 65 22 3b | 22 53 75 62 74 69 74 6c |% Done";|"Subtitl|
|000038f0| 65 22 20 0d 09 09 41 54 | 20 28 31 2e 30 35 20 49 |e" ...AT| (1.05 I|
|00003900| 4e 43 48 3b 20 31 2e 37 | 35 20 49 4e 43 48 29 20 |NCH; 1.7|5 INCH) |
|00003910| 2b 20 28 31 2e 35 35 20 | 49 4e 43 48 3b 20 2e 32 |+ (1.55 |INCH; .2|
|00003920| 35 20 49 4e 43 48 20 29 | 0d 09 43 55 52 52 45 4e |5 INCH )|..CURREN|
|00003930| 54 20 50 4f 50 55 50 20 | 4d 45 4e 55 20 49 54 45 |T POPUP |MENU ITE|
|00003940| 4d 20 49 4e 44 49 52 45 | 43 54 20 28 22 52 34 43 |M INDIRE|CT ("R4C|
|00003950| 36 35 22 29 09 09 09 7b | 20 47 65 74 20 6c 61 73 |65")...{| Get las|
|00003960| 74 20 73 65 6c 65 63 74 | 69 6f 6e 20 66 72 6f 6d |t select|ion from|
|00003970| 20 73 74 6f 72 61 67 65 | 20 7d 0d 7b 37 7d 09 41 | storage| }.{7}.A|
|00003980| 44 44 20 43 48 45 43 4b | 20 42 4f 58 20 22 44 65 |DD CHECK| BOX "De|
|00003990| 73 63 65 6e 64 69 6e 67 | 22 3b 22 44 65 73 63 65 |scending|";"Desce|
|000039a0| 6e 64 69 6e 67 22 3b 22 | 44 65 73 63 65 6e 64 69 |nding";"|Descendi|
|000039b0| 6e 67 22 09 7b 20 41 64 | 64 20 63 68 65 63 6b 20 |ng".{ Ad|d check |
|000039c0| 62 6f 78 65 73 20 66 6f | 72 20 73 6f 72 74 20 64 |boxes fo|r sort d|
|000039d0| 69 72 65 63 74 69 6f 6e | 20 7d 0d 09 09 41 54 20 |irection| }...AT |
|000039e0| 28 32 2e 37 35 20 49 4e | 43 48 3b 20 2e 35 35 20 |(2.75 IN|CH; .55 |
|000039f0| 49 4e 43 48 29 20 2b 20 | 28 31 2e 35 20 49 4e 43 |INCH) + |(1.5 INC|
|00003a00| 48 3b 20 31 2e 34 32 20 | 49 4e 43 48 29 0d 09 4e |H; 1.42 |INCH)..N|
|00003a10| 4f 20 4c 49 4e 45 20 42 | 4f 52 44 45 52 09 09 09 |O LINE B|ORDER...|
|00003a20| 09 09 09 09 09 09 7b 20 | 54 75 72 6e 20 6f 66 66 |......{ |Turn off|
|00003a30| 20 6c 69 6e 65 20 62 6f | 72 64 65 72 20 66 6f 72 | line bo|rder for|
|00003a40| 20 63 68 65 63 6b 20 62 | 6f 78 65 73 20 7d 0d 09 | check b|oxes }..|
|00003a50| 49 46 20 49 4e 44 49 52 | 45 43 54 20 28 22 52 35 |IF INDIR|ECT ("R5|
|00003a60| 43 36 35 22 29 20 3d 20 | 31 09 09 09 09 09 09 7b |C65") = |1......{|
|00003a70| 20 49 46 20 6c 61 73 74 | 20 73 65 6c 65 63 74 69 | IF last| selecti|
|00003a80| 6f 6e 20 77 61 73 20 63 | 68 65 63 6b 65 64 20 28 |on was c|hecked (|
|00003a90| 66 72 6f 6d 20 73 74 6f | 72 61 67 65 29 20 7d 0d |from sto|rage) }.|
|00003aa0| 09 09 43 48 45 43 4b 20 | 42 4f 58 20 31 09 09 09 |..CHECK |BOX 1...|
|00003ab0| 09 09 09 09 09 7b 20 49 | 66 20 79 65 73 2c 20 63 |.....{ I|f yes, c|
|00003ac0| 68 65 63 6b 20 62 6f 78 | 20 7d 0d 09 45 4c 53 45 |heck box| }..ELSE|
|00003ad0| 09 09 09 09 09 09 09 09 | 09 09 09 7b 20 49 66 20 |........|...{ If |
|00003ae0| 69 74 20 77 61 73 20 6e | 6f 74 20 7d 0d 09 09 55 |it was n|ot }...U|
|00003af0| 4e 43 48 45 43 4b 20 42 | 4f 58 20 31 09 09 09 09 |NCHECK B|OX 1....|
|00003b00| 09 09 09 09 7b 20 55 6e | 63 68 65 63 6b 20 62 6f |....{ Un|check bo|
|00003b10| 78 20 7d 0d 09 45 4e 44 | 20 49 46 09 09 09 09 09 |x }..END| IF.....|
|00003b20| 09 09 09 09 09 7b 20 45 | 6e 64 20 6f 66 20 6c 6f |.....{ E|nd of lo|
|00003b30| 67 69 63 61 6c 20 49 46 | 20 7d 0d 09 49 46 20 49 |gical IF| }..IF I|
|00003b40| 4e 44 49 52 45 43 54 20 | 28 22 52 36 43 36 35 22 |NDIRECT |("R6C65"|
|00003b50| 29 20 3d 20 31 09 09 09 | 09 09 09 7b 20 49 46 20 |) = 1...|...{ IF |
|00003b60| 6c 61 73 74 20 73 65 6c | 65 63 74 69 6f 6e 20 77 |last sel|ection w|
|00003b70| 61 73 20 63 68 65 63 6b | 65 64 20 28 66 72 6f 6d |as check|ed (from|
|00003b80| 20 73 74 6f 72 61 67 65 | 29 20 7d 0d 09 09 43 48 | storage|) }...CH|
|00003b90| 45 43 4b 20 42 4f 58 20 | 32 09 09 09 09 09 09 09 |ECK BOX |2.......|
|00003ba0| 09 7b 20 49 66 20 79 65 | 73 2c 20 63 68 65 63 6b |.{ If ye|s, check|
|00003bb0| 20 62 6f 78 20 7d 0d 09 | 45 4c 53 45 09 09 09 09 | box }..|ELSE....|
|00003bc0| 09 09 09 09 09 09 09 7b | 20 49 66 20 69 74 20 77 |.......{| If it w|
|00003bd0| 61 73 20 6e 6f 74 20 7d | 0d 09 09 55 4e 43 48 45 |as not }|...UNCHE|
|00003be0| 43 4b 20 42 4f 58 20 32 | 09 09 09 09 09 09 09 09 |CK BOX 2|........|
|00003bf0| 7b 20 55 6e 63 68 65 63 | 6b 20 62 6f 78 20 7d 0d |{ Unchec|k box }.|
|00003c00| 09 45 4e 44 20 49 46 09 | 09 09 09 09 09 09 09 09 |.END IF.|........|
|00003c10| 09 7b 20 45 6e 64 20 6f | 66 20 6c 6f 67 69 63 61 |.{ End o|f logica|
|00003c20| 6c 20 49 46 20 7d 0d 09 | 49 46 20 49 4e 44 49 52 |l IF }..|IF INDIR|
|00003c30| 45 43 54 20 28 22 52 37 | 43 36 35 22 29 20 3d 20 |ECT ("R7|C65") = |
|00003c40| 31 09 09 09 09 09 09 7b | 20 49 46 20 6c 61 73 74 |1......{| IF last|
|00003c50| 20 73 65 6c 65 63 74 69 | 6f 6e 20 77 61 73 20 63 | selecti|on was c|
|00003c60| 68 65 63 6b 65 64 20 28 | 66 72 6f 6d 20 73 74 6f |hecked (|from sto|
|00003c70| 72 61 67 65 29 20 7d 0d | 09 09 43 48 45 43 4b 20 |rage) }.|..CHECK |
|00003c80| 42 4f 58 20 33 09 09 09 | 09 09 09 09 09 7b 20 49 |BOX 3...|.....{ I|
|00003c90| 66 20 79 65 73 2c 20 63 | 68 65 63 6b 20 62 6f 78 |f yes, c|heck box|
|00003ca0| 20 7d 0d 09 45 4c 53 45 | 09 09 09 09 09 09 09 09 | }..ELSE|........|
|00003cb0| 09 09 09 7b 20 49 66 20 | 69 74 20 77 61 73 20 6e |...{ If |it was n|
|00003cc0| 6f 74 20 7d 0d 09 09 55 | 4e 43 48 45 43 4b 20 42 |ot }...U|NCHECK B|
|00003cd0| 4f 58 20 33 09 09 09 09 | 09 09 09 09 7b 20 55 6e |OX 3....|....{ Un|
|00003ce0| 63 68 65 63 6b 20 62 6f | 78 20 7d 0d 09 45 4e 44 |check bo|x }..END|
|00003cf0| 20 49 46 09 09 09 09 09 | 09 09 09 09 09 7b 20 45 | IF.....|.....{ E|
|00003d00| 6e 64 20 6f 66 20 6c 6f | 67 69 63 61 6c 20 49 46 |nd of lo|gical IF|
|00003d10| 20 7d 0d 7b 38 7d 09 41 | 44 44 20 43 55 53 54 4f | }.{8}.A|DD CUSTO|
|00003d20| 4d 20 42 55 54 54 4f 4e | 20 41 54 20 28 2e 31 32 |M BUTTON| AT (.12|
|00003d30| 35 20 49 4e 43 48 3b 20 | 2e 33 33 20 49 4e 43 48 |5 INCH; |.33 INCH|
|00003d40| 29 09 09 09 7b 20 41 64 | 64 20 6c 69 6e 65 20 75 |)...{ Ad|d line u|
|00003d50| 6e 64 65 72 20 22 53 6f | 72 74 22 20 61 74 20 74 |nder "So|rt" at t|
|00003d60| 6f 70 20 6f 66 20 64 69 | 61 6c 6f 67 20 7d 0d 09 |op of di|alog }..|
|00003d70| 09 28 34 2e 33 37 35 20 | 49 4e 43 48 3b 20 2e 33 |.(4.375 |INCH; .3|
|00003d80| 33 20 49 4e 43 48 29 0d | 09 41 44 44 20 54 45 58 |3 INCH).|.ADD TEX|
|00003d90| 54 20 22 4b 65 79 20 31 | 22 20 09 09 09 09 09 09 |T "Key 1|" ......|
|00003da0| 09 09 7b 20 50 6c 61 63 | 65 20 74 65 78 74 20 69 |..{ Plac|e text i|
|00003db0| 6e 74 6f 20 64 69 61 6c | 6f 67 20 62 6f 78 20 7d |nto dial|og box }|
|00003dc0| 0d 09 09 41 54 20 28 2e | 33 20 49 4e 43 48 3b 20 |...AT (.|3 INCH; |
|00003dd0| 2e 35 35 20 49 4e 43 48 | 29 20 2b 20 28 2e 36 35 |.55 INCH|) + (.65|
|00003de0| 20 49 4e 43 48 3b 20 2e | 33 20 49 4e 43 48 20 29 | INCH; .|3 INCH )|
|00003df0| 0d 09 4e 4f 20 4c 49 4e | 45 20 42 4f 52 44 45 52 |..NO LIN|E BORDER|
|00003e00| 09 09 09 09 09 09 09 09 | 09 7b 20 54 75 72 6e 20 |........|.{ Turn |
|00003e10| 6f 66 66 20 6c 69 6e 65 | 20 62 6f 72 64 65 72 20 |off line| border |
|00003e20| 66 6f 72 20 74 65 78 74 | 20 6f 62 6a 65 63 74 20 |for text| object |
|00003e30| 7d 0d 09 41 44 44 20 54 | 45 58 54 20 22 4b 65 79 |}..ADD T|EXT "Key|
|00003e40| 20 32 22 20 09 09 09 09 | 09 09 09 09 7b 20 50 6c | 2" ....|....{ Pl|
|00003e50| 61 63 65 20 74 65 78 74 | 20 69 6e 74 6f 20 64 69 |ace text| into di|
|00003e60| 61 6c 6f 67 20 62 6f 78 | 20 7d 0d 09 09 41 54 20 |alog box| }...AT |
|00003e70| 28 2e 33 20 49 4e 43 48 | 3b 20 31 2e 31 35 20 49 |(.3 INCH|; 1.15 I|
|00003e80| 4e 43 48 29 20 2b 20 28 | 2e 36 35 20 49 4e 43 48 |NCH) + (|.65 INCH|
|00003e90| 3b 20 2e 33 20 49 4e 43 | 48 20 29 0d 09 4e 4f 20 |; .3 INC|H )..NO |
|00003ea0| 4c 49 4e 45 20 42 4f 52 | 44 45 52 09 09 09 09 09 |LINE BOR|DER.....|
|00003eb0| 09 09 09 09 7b 20 54 75 | 72 6e 20 6f 66 66 20 6c |....{ Tu|rn off l|
|00003ec0| 69 6e 65 20 62 6f 72 64 | 65 72 20 66 6f 72 20 74 |ine bord|er for t|
|00003ed0| 65 78 74 20 6f 62 6a 65 | 63 74 20 7d 0d 09 41 44 |ext obje|ct }..AD|
|00003ee0| 44 20 54 45 58 54 20 22 | 4b 65 79 20 33 22 20 09 |D TEXT "|Key 3" .|
|00003ef0| 09 09 09 09 09 09 09 7b | 20 50 6c 61 63 65 20 74 |.......{| Place t|
|00003f00| 65 78 74 20 69 6e 74 6f | 20 64 69 61 6c 6f 67 20 |ext into| dialog |
|00003f10| 62 6f 78 20 7d 0d 09 09 | 41 54 20 28 2e 33 20 49 |box }...|AT (.3 I|
|00003f20| 4e 43 48 3b 20 31 2e 37 | 35 20 49 4e 43 48 29 20 |NCH; 1.7|5 INCH) |
|00003f30| 2b 20 28 2e 36 35 20 49 | 4e 43 48 3b 20 2e 33 20 |+ (.65 I|NCH; .3 |
|00003f40| 49 4e 43 48 20 29 0d 09 | 4e 4f 20 4c 49 4e 45 20 |INCH )..|NO LINE |
|00003f50| 42 4f 52 44 45 52 09 09 | 09 09 09 09 09 09 09 7b |BORDER..|.......{|
|00003f60| 20 54 75 72 6e 20 6f 66 | 66 20 6c 69 6e 65 20 62 | Turn of|f line b|
|00003f70| 6f 72 64 65 72 20 66 6f | 72 20 74 65 78 74 20 6f |order fo|r text o|
|00003f80| 62 6a 65 63 74 20 7d 0d | 09 55 4e 53 45 4c 45 43 |bject }.|.UNSELEC|
|00003f90| 54 09 09 09 09 09 09 09 | 09 09 09 7b 20 55 4e 53 |T.......|...{ UNS|
|00003fa0| 45 4c 45 43 54 20 6c 61 | 73 74 20 6f 62 6a 65 63 |ELECT la|st objec|
|00003fb0| 74 20 7d 0d 09 55 53 45 | 20 44 49 41 4c 4f 47 20 |t }..USE| DIALOG |
|00003fc0| 42 4f 58 09 09 09 09 09 | 09 09 09 09 7b 20 44 69 |BOX.....|....{ Di|
|00003fd0| 73 70 6c 61 79 20 64 69 | 61 6c 6f 67 20 6f 6e 2d |splay di|alog on-|
|00003fe0| 73 63 72 65 65 6e 20 7d | 0d 09 49 46 20 64 6f 6e |screen }|..IF don|
|00003ff0| 65 20 3d 20 31 09 09 09 | 09 09 09 09 09 09 7b 20 |e = 1...|......{ |
|00004000| 49 46 20 64 6f 6e 65 20 | 66 6c 61 67 20 69 73 20 |IF done |flag is |
|00004010| 65 71 75 61 6c 20 74 6f | 20 31 20 7d 0d 09 09 50 |equal to| 1 }...P|
|00004020| 55 54 20 66 6b 20 49 4e | 54 4f 20 22 52 32 43 36 |UT fk IN|TO "R2C6|
|00004030| 35 22 09 09 09 09 09 09 | 09 7b 20 50 75 74 20 73 |5"......|.{ Put s|
|00004040| 65 6c 65 63 74 69 6f 6e | 20 69 6e 74 6f 20 73 74 |election| into st|
|00004050| 6f 72 61 67 65 20 7d 0d | 09 09 50 55 54 20 73 6b |orage }.|..PUT sk|
|00004060| 20 49 4e 54 4f 20 22 52 | 33 43 36 35 22 09 09 09 | INTO "R|3C65"...|
|00004070| 09 09 09 09 7b 20 50 75 | 74 20 73 65 6c 65 63 74 |....{ Pu|t select|
|00004080| 69 6f 6e 20 69 6e 74 6f | 20 73 74 6f 72 61 67 65 |ion into| storage|
|00004090| 20 7d 0d 09 09 50 55 54 | 20 74 6b 20 49 4e 54 4f | }...PUT| tk INTO|
|000040a0| 20 22 52 34 43 36 35 22 | 09 09 09 09 09 09 09 7b | "R4C65"|.......{|
|000040b0| 20 50 75 74 20 73 65 6c | 65 63 74 69 6f 6e 20 69 | Put sel|ection i|
|000040c0| 6e 74 6f 20 73 74 6f 72 | 61 67 65 20 7d 0d 09 09 |nto stor|age }...|
|000040d0| 50 55 54 20 6d 31 20 49 | 4e 54 4f 20 22 52 35 43 |PUT m1 I|NTO "R5C|
|000040e0| 36 35 22 09 09 09 09 09 | 09 09 7b 20 50 75 74 20 |65".....|..{ Put |
|000040f0| 73 65 6c 65 63 74 69 6f | 6e 20 69 6e 74 6f 20 73 |selectio|n into s|
|00004100| 74 6f 72 61 67 65 20 7d | 0d 09 09 50 55 54 20 6d |torage }|...PUT m|
|00004110| 32 20 49 4e 54 4f 20 22 | 52 36 43 36 35 22 09 09 |2 INTO "|R6C65"..|
|00004120| 09 09 09 09 09 7b 20 50 | 75 74 20 73 65 6c 65 63 |.....{ P|ut selec|
|00004130| 74 69 6f 6e 20 69 6e 74 | 6f 20 73 74 6f 72 61 67 |tion int|o storag|
|00004140| 65 20 7d 0d 09 09 50 55 | 54 20 6d 33 20 49 4e 54 |e }...PU|T m3 INT|
|00004150| 4f 20 22 52 37 43 36 35 | 22 09 09 09 09 09 09 09 |O "R7C65|".......|
|00004160| 7b 20 50 75 74 20 73 65 | 6c 65 63 74 69 6f 6e 20 |{ Put se|lection |
|00004170| 69 6e 74 6f 20 73 74 6f | 72 61 67 65 20 7d 0d 09 |into sto|rage }..|
|00004180| 09 52 45 50 41 49 4e 54 | 20 4f 46 46 09 09 09 09 |.REPAINT| OFF....|
|00004190| 09 09 09 09 7b 20 54 75 | 72 6e 20 6f 66 66 20 72 |....{ Tu|rn off r|
|000041a0| 65 70 61 69 6e 74 20 74 | 6f 20 73 70 65 65 64 20 |epaint t|o speed |
|000041b0| 6f 70 65 72 61 74 69 6f | 6e 20 7d 0d 09 09 6b 65 |operatio|n }...ke|
|000041c0| 79 5f 6e 75 6d 20 3d 20 | 31 09 09 09 09 09 09 09 |y_num = |1.......|
|000041d0| 09 7b 20 53 65 74 20 6b | 65 79 20 74 6f 20 31 20 |.{ Set k|ey to 1 |
|000041e0| 7d 0d 09 09 43 41 4c 4c | 20 53 4f 52 54 5f 54 59 |}...CALL| SORT_TY|
|000041f0| 50 45 28 66 6b 29 09 09 | 09 09 09 09 09 7b 20 43 |PE(fk)..|.....{ C|
|00004200| 61 6c 6c 20 46 75 6e 63 | 74 69 6f 6e 20 53 4f 52 |all Func|tion SOR|
|00004210| 54 5f 54 59 50 45 20 7d | 0d 09 09 6b 65 79 5f 6e |T_TYPE }|...key_n|
|00004220| 75 6d 20 3d 20 32 09 09 | 09 09 09 09 09 09 7b 20 |um = 2..|......{ |
|00004230| 53 65 74 20 6b 65 79 20 | 74 6f 20 32 20 7d 0d 09 |Set key |to 2 }..|
|00004240| 09 43 41 4c 4c 20 53 4f | 52 54 5f 54 59 50 45 28 |.CALL SO|RT_TYPE(|
|00004250| 73 6b 29 09 09 09 09 09 | 09 09 7b 20 43 61 6c 6c |sk).....|..{ Call|
|00004260| 20 46 75 6e 63 74 69 6f | 6e 20 53 4f 52 54 5f 54 | Functio|n SORT_T|
|00004270| 59 50 45 20 7d 0d 09 09 | 6b 65 79 5f 6e 75 6d 20 |YPE }...|key_num |
|00004280| 3d 20 33 09 09 09 09 09 | 09 09 09 7b 20 53 65 74 |= 3.....|...{ Set|
|00004290| 20 6b 65 79 20 74 6f 20 | 33 20 7d 0d 09 09 43 41 | key to |3 }...CA|
|000042a0| 4c 4c 20 53 4f 52 54 5f | 54 59 50 45 28 74 6b 29 |LL SORT_|TYPE(tk)|
|000042b0| 09 09 09 09 09 09 09 7b | 20 43 61 6c 6c 20 46 75 |.......{| Call Fu|
|000042c0| 6e 63 74 69 6f 6e 20 53 | 4f 52 54 5f 54 59 50 45 |nction S|ORT_TYPE|
|000042d0| 20 7d 0d 09 09 53 45 4c | 45 43 54 20 52 41 4e 47 | }...SEL|ECT RANG|
|000042e0| 45 28 4d 41 4b 45 52 41 | 4e 47 45 28 32 3b 32 3b |E(MAKERA|NGE(2;2;|
|000042f0| 36 34 3b 6c 61 73 74 5f | 72 6f 77 29 29 09 09 7b |64;last_|row))..{|
|00004300| 20 53 65 6c 65 63 74 20 | 65 6e 74 69 72 65 20 50 | Select |entire P|
|00004310| 72 6f 6a 65 63 74 20 54 | 61 62 6c 65 20 28 6d 69 |roject T|able (mi|
|00004320| 6e 75 73 20 63 6f 6c 75 | 6d 6e 73 29 20 7d 0d 09 |nus colu|mns) }..|
|00004330| 09 53 4f 52 54 20 4e 4f | 57 09 09 09 09 09 09 09 |.SORT NO|W.......|
|00004340| 09 09 7b 20 50 65 72 66 | 6f 72 6d 20 74 68 65 20 |..{ Perf|orm the |
|00004350| 73 6f 72 74 20 7d 0d 09 | 09 53 45 4c 45 43 54 20 |sort }..|.SELECT |
|00004360| 52 41 4e 47 45 20 41 31 | 09 09 09 09 09 09 09 7b |RANGE A1|.......{|
|00004370| 20 53 65 6c 65 63 74 20 | 63 65 6c 6c 20 41 31 20 | Select |cell A1 |
|00004380| 74 6f 20 73 77 69 74 63 | 68 20 76 69 65 77 20 7d |to switc|h view }|
|00004390| 0d 09 09 55 4e 53 45 4c | 45 43 54 09 09 09 09 09 |...UNSEL|ECT.....|
|000043a0| 09 09 09 09 7b 20 55 4e | 53 45 4c 45 43 54 20 74 |....{ UN|SELECT t|
|000043b0| 68 65 20 73 65 6c 65 63 | 74 65 64 20 63 65 6c 6c |he selec|ted cell|
|000043c0| 73 20 7d 0d 09 09 52 45 | 50 41 49 4e 54 20 57 49 |s }...RE|PAINT WI|
|000043d0| 4e 44 4f 57 09 09 09 09 | 09 09 09 09 7b 20 52 65 |NDOW....|....{ Re|
|000043e0| 70 61 69 6e 74 20 74 68 | 65 20 77 69 6e 64 6f 77 |paint th|e window|
|000043f0| 20 74 6f 20 73 68 6f 77 | 20 63 68 61 6e 67 65 73 | to show| changes|
|00004400| 20 7d 0d 09 45 4e 44 20 | 49 46 09 09 09 09 09 09 | }..END |IF......|
|00004410| 09 09 09 09 7b 20 45 6e | 64 20 6c 6f 67 69 63 61 |....{ En|d logica|
|00004420| 6c 20 49 46 20 7d 0d 45 | 4e 44 20 46 55 4e 43 54 |l IF }.E|ND FUNCT|
|00004430| 49 4f 4e 0d 0d 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ION..{**|********|
|00004440| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004450| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 53 4f 52 54 |********|*** SORT|
|00004460| 5f 54 59 50 45 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |_TYPE **|********|
|00004470| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004480| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004490| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 20 20 54 68 |********|***.  Th|
|000044a0| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 64 65 74 65 |is funct|ion dete|
|000044b0| 72 6d 69 6e 65 73 20 77 | 68 61 74 20 74 79 70 65 |rmines w|hat type|
|000044c0| 20 6f 66 20 73 6f 72 74 | 20 77 65 20 77 61 6e 74 | of sort| we want|
|000044d0| 20 61 6e 64 20 70 61 73 | 73 65 73 20 74 68 65 20 | and pas|ses the |
|000044e0| 61 70 70 72 6f 70 72 69 | 61 74 65 20 63 6f 6c 75 |appropri|ate colu|
|000044f0| 6d 6e 20 6e 75 6d 62 65 | 72 20 74 6f 20 74 68 65 |mn numbe|r to the|
|00004500| 0d 20 20 73 63 72 69 70 | 74 20 53 4f 52 54 2e 0d |.  scrip|t SORT..|
|00004510| 20 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a | *******|********|
|00004520| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004530| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004540| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004550| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004560| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004570| 2a 2a 2a 2a 2a 7d 0d 0d | 46 55 4e 43 54 49 4f 4e |*****}..|FUNCTION|
|00004580| 20 53 4f 52 54 5f 54 59 | 50 45 28 74 79 70 65 29 | SORT_TY|PE(type)|
|00004590| 0d 09 43 41 53 45 20 74 | 79 70 65 09 09 09 09 09 |..CASE t|ype.....|
|000045a0| 7b 20 53 74 61 72 74 20 | 6c 6f 67 69 63 61 6c 20 |{ Start |logical |
|000045b0| 43 41 53 45 20 6f 6e 20 | 74 79 70 65 20 7d 0d 09 |CASE on |type }..|
|000045c0| 09 57 48 45 4e 20 31 09 | 09 09 09 7b 20 49 6e 20 |.WHEN 1.|...{ In |
|000045d0| 74 68 65 20 43 41 53 45 | 20 74 68 61 74 20 74 79 |the CASE| that ty|
|000045e0| 70 65 20 65 71 75 61 6c | 73 20 31 20 7d 0d 09 09 |pe equal|s 1 }...|
|000045f0| 09 43 41 4c 4c 20 53 4f | 52 54 28 32 29 09 09 7b |.CALL SO|RT(2)..{|
|00004600| 20 43 61 6c 6c 20 53 4f | 52 54 20 66 75 6e 63 74 | Call SO|RT funct|
|00004610| 69 6f 6e 20 61 6e 64 20 | 70 61 73 73 20 63 6f 6c |ion and |pass col|
|00004620| 75 6d 6e 20 6e 75 6d 62 | 65 72 20 32 20 7d 0d 09 |umn numb|er 2 }..|
|00004630| 09 57 48 45 4e 20 32 09 | 09 09 09 7b 20 49 6e 20 |.WHEN 2.|...{ In |
|00004640| 74 68 65 20 43 41 53 45 | 20 74 68 61 74 20 74 79 |the CASE| that ty|
|00004650| 70 65 20 65 71 75 61 6c | 73 20 32 20 7d 0d 09 09 |pe equal|s 2 }...|
|00004660| 09 43 41 4c 4c 20 53 4f | 52 54 28 35 29 09 09 7b |.CALL SO|RT(5)..{|
|00004670| 20 43 61 6c 6c 20 53 4f | 52 54 20 66 75 6e 63 74 | Call SO|RT funct|
|00004680| 69 6f 6e 20 61 6e 64 20 | 70 61 73 73 20 63 6f 6c |ion and |pass col|
|00004690| 75 6d 6e 20 6e 75 6d 62 | 65 72 20 35 20 7d 0d 09 |umn numb|er 5 }..|
|000046a0| 09 57 48 45 4e 20 33 09 | 09 09 09 7b 20 49 6e 20 |.WHEN 3.|...{ In |
|000046b0| 74 68 65 20 43 41 53 45 | 20 74 68 61 74 20 74 79 |the CASE| that ty|
|000046c0| 70 65 20 65 71 75 61 6c | 73 20 33 20 7d 0d 09 09 |pe equal|s 3 }...|
|000046d0| 09 43 41 4c 4c 20 53 4f | 52 54 28 31 30 29 09 09 |.CALL SO|RT(10)..|
|000046e0| 7b 20 43 61 6c 6c 20 53 | 4f 52 54 20 66 75 6e 63 |{ Call S|ORT func|
|000046f0| 74 69 6f 6e 20 61 6e 64 | 20 70 61 73 73 20 63 6f |tion and| pass co|
|00004700| 6c 75 6d 6e 20 6e 75 6d | 62 65 72 20 31 30 7d 0d |lumn num|ber 10}.|
|00004710| 09 09 57 48 45 4e 20 34 | 09 09 09 09 7b 20 49 6e |..WHEN 4|....{ In|
|00004720| 20 74 68 65 20 43 41 53 | 45 20 74 68 61 74 20 74 | the CAS|E that t|
|00004730| 79 70 65 20 65 71 75 61 | 6c 73 20 34 20 7d 0d 09 |ype equa|ls 4 }..|
|00004740| 09 09 43 41 4c 4c 20 53 | 4f 52 54 28 31 32 29 09 |..CALL S|ORT(12).|
|00004750| 09 7b 20 43 61 6c 6c 20 | 53 4f 52 54 20 66 75 6e |.{ Call |SORT fun|
|00004760| 63 74 69 6f 6e 20 61 6e | 64 20 70 61 73 73 20 63 |ction an|d pass c|
|00004770| 6f 6c 75 6d 6e 20 6e 75 | 6d 62 65 72 20 31 32 20 |olumn nu|mber 12 |
|00004780| 7d 0d 09 09 57 48 45 4e | 20 35 09 09 09 09 7b 20 |}...WHEN| 5....{ |
|00004790| 49 6e 20 74 68 65 20 43 | 41 53 45 20 74 68 61 74 |In the C|ASE that|
|000047a0| 20 74 79 70 65 20 65 71 | 75 61 6c 73 20 35 20 7d | type eq|uals 5 }|
|000047b0| 0d 09 09 09 43 41 4c 4c | 20 53 4f 52 54 28 34 29 |....CALL| SORT(4)|
|000047c0| 09 09 7b 20 43 61 6c 6c | 20 53 4f 52 54 20 66 75 |..{ Call| SORT fu|
|000047d0| 6e 63 74 69 6f 6e 20 61 | 6e 64 20 70 61 73 73 20 |nction a|nd pass |
|000047e0| 63 6f 6c 75 6d 6e 20 6e | 75 6d 62 65 72 20 34 20 |column n|umber 4 |
|000047f0| 7d 0d 09 45 4e 44 20 43 | 41 53 45 09 09 09 09 09 |}..END C|ASE.....|
|00004800| 7b 20 45 6e 64 20 6c 6f | 67 69 63 61 6c 20 43 41 |{ End lo|gical CA|
|00004810| 53 45 20 7d 0d 45 4e 44 | 20 46 55 4e 43 54 49 4f |SE }.END| FUNCTIO|
|00004820| 4e 0d 0d 7b 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |N..{****|********|
|00004830| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004840| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 53 4f 52 54 20 2a |********|* SORT *|
|00004850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004860| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004870| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004880| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 20 20 54 68 69 73 |********|*.  This|
|00004890| 20 66 75 6e 63 74 69 6f | 6e 20 73 6f 72 74 73 20 | functio|n sorts |
|000048a0| 74 68 65 20 74 61 62 6c | 65 20 62 79 20 74 68 65 |the tabl|e by the|
|000048b0| 20 73 70 65 63 69 66 69 | 65 64 20 63 6f 6c 75 6d | specifi|ed colum|
|000048c0| 6e 2e 20 20 42 61 73 65 | 64 20 6f 6e 20 74 68 65 |n.  Base|d on the|
|000048d0| 20 6b 65 79 20 6e 75 6d | 62 65 72 20 61 6e 64 20 | key num|ber and |
|000048e0| 74 68 65 0d 20 20 73 6f | 72 74 20 6d 65 74 68 6f |the.  so|rt metho|
|000048f0| 64 2c 20 69 74 20 64 65 | 74 65 72 6d 69 6e 65 73 |d, it de|termines|
|00004900| 20 77 68 61 74 20 74 79 | 70 65 20 6f 66 20 73 6f | what ty|pe of so|
|00004910| 72 74 20 6b 65 79 20 77 | 69 6c 6c 20 62 65 20 61 |rt key w|ill be a|
|00004920| 73 73 69 67 6e 65 64 20 | 74 6f 20 74 68 65 20 73 |ssigned |to the s|
|00004930| 65 6c 65 63 74 65 64 20 | 72 61 6e 67 65 2e 0d 20 |elected |range.. |
|00004940| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004950| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004960| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004970| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004980| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004990| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000049a0| 2a 2a 2a 2a 7d 0d 0d 46 | 55 4e 43 54 49 4f 4e 20 |****}..F|UNCTION |
|000049b0| 53 4f 52 54 28 73 6f 72 | 74 5f 4b 65 79 29 0d 09 |SORT(sor|t_Key)..|
|000049c0| 53 45 4c 45 43 54 20 52 | 41 4e 47 45 28 4d 41 4b |SELECT R|ANGE(MAK|
|000049d0| 45 52 41 4e 47 45 28 73 | 6f 72 74 5f 6b 65 79 3b |ERANGE(s|ort_key;|
|000049e0| 32 3b 73 6f 72 74 5f 6b | 65 79 3b 6c 61 73 74 5f |2;sort_k|ey;last_|
|000049f0| 72 6f 77 29 29 09 7b 20 | 53 65 6c 65 63 74 20 63 |row)).{ |Select c|
|00004a00| 6f 6c 75 6d 6e 20 6e 75 | 6d 62 65 72 20 70 61 73 |olumn nu|mber pas|
|00004a10| 73 65 64 20 74 6f 20 66 | 75 6e 63 74 69 6f 6e 20 |sed to f|unction |
|00004a20| 7d 0d 09 43 41 53 45 20 | 6b 65 79 5f 6e 75 6d 09 |}..CASE |key_num.|
|00004a30| 09 09 09 09 09 09 09 09 | 7b 20 43 61 73 65 20 6f |........|{ Case o|
|00004a40| 6e 20 6b 65 79 5f 6e 75 | 6d 20 7d 0d 09 09 57 48 |n key_nu|m }...WH|
|00004a50| 45 4e 20 31 09 09 09 09 | 09 09 09 09 09 7b 20 49 |EN 1....|.....{ I|
|00004a60| 6e 20 43 41 53 45 20 74 | 68 69 73 20 69 73 20 74 |n CASE t|his is t|
|00004a70| 68 65 20 66 69 72 73 74 | 20 6b 65 79 20 7d 0d 09 |he first| key }..|
|00004a80| 09 09 43 41 53 45 20 6d | 31 09 09 09 09 09 09 09 |..CASE m|1.......|
|00004a90| 09 7b 20 43 61 73 65 20 | 6f 6e 20 6d 31 20 28 20 |.{ Case |on m1 ( |
|00004aa0| 66 69 72 73 74 20 6b 65 | 79 20 63 68 65 63 6b 20 |first ke|y check |
|00004ab0| 62 6f 78 20 29 20 7d 0d | 09 09 09 09 57 48 45 4e |box ) }.|....WHEN|
|00004ac0| 20 30 09 09 09 09 09 09 | 09 7b 20 49 6e 20 43 41 | 0......|.{ In CA|
|00004ad0| 53 45 20 63 68 65 63 6b | 20 62 6f 78 20 6e 6f 74 |SE check| box not|
|00004ae0| 20 73 65 6c 65 63 74 65 | 64 20 7d 0d 09 09 09 09 | selecte|d }.....|
|00004af0| 09 41 53 43 45 4e 44 49 | 4e 47 20 4b 45 59 09 09 |.ASCENDI|NG KEY..|
|00004b00| 09 09 09 7b 20 4d 61 6b | 65 20 73 65 6c 65 63 74 |...{ Mak|e select|
|00004b10| 69 6f 6e 20 61 6e 20 41 | 73 63 65 6e 64 69 6e 67 |ion an A|scending|
|00004b20| 20 6b 65 79 20 7d 0d 09 | 09 09 09 57 48 45 4e 20 | key }..|...WHEN |
|00004b30| 31 09 09 09 09 09 09 09 | 7b 20 49 6e 20 63 61 73 |1.......|{ In cas|
|00004b40| 65 20 63 68 65 63 6b 20 | 62 6f 78 20 69 73 20 73 |e check |box is s|
|00004b50| 65 6c 65 63 74 65 64 20 | 7d 0d 09 09 09 09 09 44 |elected |}......D|
|00004b60| 45 53 43 45 4e 44 49 4e | 47 20 4b 45 59 09 09 09 |ESCENDIN|G KEY...|
|00004b70| 09 09 7b 20 4d 61 6b 65 | 20 73 65 6c 65 63 74 69 |..{ Make| selecti|
|00004b80| 6f 6e 20 61 20 44 65 73 | 63 65 6e 64 69 6e 67 20 |on a Des|cending |
|00004b90| 6b 65 79 20 7d 0d 09 09 | 09 45 4e 44 20 43 41 53 |key }...|.END CAS|
|00004ba0| 45 09 09 09 09 09 09 09 | 09 7b 20 45 6e 64 20 6f |E.......|.{ End o|
|00004bb0| 66 20 43 41 53 45 20 7d | 0d 09 09 57 48 45 4e 20 |f CASE }|...WHEN |
|00004bc0| 32 09 09 09 09 09 09 09 | 09 09 7b 20 49 6e 20 43 |2.......|..{ In C|
|00004bd0| 41 53 45 20 74 68 69 73 | 20 69 73 20 74 68 65 20 |ASE this| is the |
|00004be0| 73 65 63 6f 6e 64 20 6b | 65 79 20 7d 0d 09 09 09 |second k|ey }....|
|00004bf0| 43 41 53 45 20 6d 32 09 | 09 09 09 09 09 09 09 7b |CASE m2.|.......{|
|00004c00| 20 43 61 73 65 20 6f 6e | 20 6d 32 20 28 20 73 65 | Case on| m2 ( se|
|00004c10| 63 6f 6e 64 20 6b 65 79 | 20 63 68 65 63 6b 20 62 |cond key| check b|
|00004c20| 6f 78 20 29 20 7d 0d 09 | 09 09 09 57 48 45 4e 20 |ox ) }..|...WHEN |
|00004c30| 30 09 09 09 09 09 09 09 | 7b 20 49 6e 20 43 41 53 |0.......|{ In CAS|
|00004c40| 45 20 63 68 65 63 6b 20 | 62 6f 78 20 6e 6f 74 20 |E check |box not |
|00004c50| 73 65 6c 65 63 74 65 64 | 20 7d 0d 09 09 09 09 09 |selected| }......|
|00004c60| 41 44 44 20 41 53 43 45 | 4e 44 49 4e 47 20 4b 45 |ADD ASCE|NDING KE|
|00004c70| 59 09 09 09 09 7b 20 41 | 64 64 20 61 6e 20 41 73 |Y....{ A|dd an As|
|00004c80| 63 65 6e 64 69 6e 67 20 | 6b 65 79 20 7d 0d 09 09 |cending |key }...|
|00004c90| 09 09 57 48 45 4e 20 31 | 09 09 09 09 09 09 09 7b |..WHEN 1|.......{|
|00004ca0| 20 49 6e 20 43 41 53 45 | 20 63 68 65 63 6b 20 62 | In CASE| check b|
|00004cb0| 6f 78 20 69 73 20 73 65 | 6c 65 63 74 65 64 20 7d |ox is se|lected }|
|00004cc0| 0d 09 09 09 09 09 41 44 | 44 20 44 45 53 43 45 4e |......AD|D DESCEN|
|00004cd0| 44 49 4e 47 20 4b 45 59 | 09 09 09 09 7b 20 41 64 |DING KEY|....{ Ad|
|00004ce0| 64 20 61 20 44 65 73 63 | 65 6e 64 69 6e 67 20 6b |d a Desc|ending k|
|00004cf0| 65 79 20 7d 0d 09 09 09 | 45 4e 44 20 43 41 53 45 |ey }....|END CASE|
|00004d00| 09 09 09 09 09 09 09 09 | 7b 20 45 6e 64 20 6f 66 |........|{ End of|
|00004d10| 20 43 41 53 45 20 7d 0d | 09 09 57 48 45 4e 20 33 | CASE }.|..WHEN 3|
|00004d20| 09 09 09 09 09 09 09 09 | 09 7b 20 49 6e 20 43 41 |........|.{ In CA|
|00004d30| 53 45 20 74 68 69 73 20 | 69 73 20 74 68 65 20 33 |SE this |is the 3|
|00004d40| 72 64 20 6b 65 79 20 7d | 0d 09 09 09 43 41 53 45 |rd key }|....CASE|
|00004d50| 20 6d 33 09 09 09 09 09 | 09 09 09 7b 20 43 41 53 | m3.....|...{ CAS|
|00004d60| 45 20 6f 6e 20 6d 33 20 | 28 20 74 68 69 72 64 20 |E on m3 |( third |
|00004d70| 6b 65 79 20 63 68 65 63 | 6b 20 62 6f 78 20 29 20 |key chec|k box ) |
|00004d80| 7d 0d 09 09 09 09 57 48 | 45 4e 20 30 09 09 09 09 |}.....WH|EN 0....|
|00004d90| 09 09 09 7b 20 49 6e 20 | 43 41 53 45 20 63 68 65 |...{ In |CASE che|
|00004da0| 63 6b 20 62 6f 78 20 6e | 6f 74 20 73 65 6c 65 63 |ck box n|ot selec|
|00004db0| 74 65 64 20 7d 0d 09 09 | 09 09 09 41 44 44 20 41 |ted }...|...ADD A|
|00004dc0| 53 43 45 4e 44 49 4e 47 | 20 4b 45 59 09 09 09 09 |SCENDING| KEY....|
|00004dd0| 7b 20 41 64 64 20 61 6e | 20 41 73 63 65 6e 64 69 |{ Add an| Ascendi|
|00004de0| 6e 67 20 6b 65 79 20 7d | 0d 09 09 09 09 57 48 45 |ng key }|.....WHE|
|00004df0| 4e 20 31 09 09 09 09 09 | 09 09 7b 20 49 6e 20 43 |N 1.....|..{ In C|
|00004e00| 41 53 45 20 63 68 65 63 | 6b 20 62 6f 78 20 69 73 |ASE chec|k box is|
|00004e10| 20 73 65 6c 65 63 74 65 | 64 20 7d 0d 09 09 09 09 | selecte|d }.....|
|00004e20| 09 41 44 44 20 44 45 53 | 43 45 4e 44 49 4e 47 20 |.ADD DES|CENDING |
|00004e30| 4b 45 59 09 09 09 09 7b | 20 41 64 64 20 61 20 44 |KEY....{| Add a D|
|00004e40| 65 73 63 65 6e 64 69 6e | 67 20 6b 65 79 20 7d 0d |escendin|g key }.|
|00004e50| 09 09 09 45 4e 44 20 43 | 41 53 45 09 09 09 09 09 |...END C|ASE.....|
|00004e60| 09 09 09 7b 20 45 6e 64 | 20 6f 66 20 43 41 53 45 |...{ End| of CASE|
|00004e70| 20 7d 0d 09 45 4e 44 20 | 43 41 53 45 09 09 09 09 | }..END |CASE....|
|00004e80| 09 09 09 09 09 09 7b 20 | 45 6e 64 20 6f 66 20 43 |......{ |End of C|
|00004e90| 41 53 45 20 7d 0d 45 4e | 44 20 46 55 4e 43 54 49 |ASE }.EN|D FUNCTI|
|00004ea0| 4f 4e 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ON..{***|********|
|00004eb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004ec0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 45 4e 44 20 53 |********|** END S|
|00004ed0| 43 52 49 50 54 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |CRIPT **|********|
|00004ee0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004ef0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004f00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 00 00 00 00 00 |********|*}......|
|00004f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f80| 00 00 01 00 00 00 01 7e | 00 00 00 7e 00 00 00 3c |.......~|...~...<|
|00004f90| 00 00 00 2a 07 4e 65 74 | 77 6f 72 6b 02 00 00 00 |...*.Net|work....|
|00004fa0| 63 64 65 76 61 74 64 76 | 21 80 ff 80 01 c0 00 00 |cdevatdv|!.......|
|00004fb0| 0b 53 6f 72 74 20 53 63 | 72 69 70 74 02 00 00 00 |.Sort Sc|ript....|
|00004fc0| 52 73 53 63 52 73 6c 76 | 01 00 00 9c 01 00 00 00 |RsScRslv|........|
|00004fd0| 00 00 52 73 53 63 52 73 | 6c 76 01 00 00 9c 01 00 |..RsScRs|lv......|
|00004fe0| 00 00 00 84 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ff0| 00 00 a4 58 08 a0 00 00 | 4e 8c 00 00 01 ba 00 00 |...X....|N.......|
|00005000| 00 00 00 00 00 00 00 00 | 00 00 0d 00 00 00 00 2a |........|.......*|
|00005010| 07 4e 65 74 77 6f 72 6b | 02 00 00 00 63 64 65 76 |.Network|....cdev|
|00005020| 61 74 64 76 21 80 08 40 | 01 40 00 00 00 00 4e f0 |atdv!..@|.@....N.|
|00005030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 1d 6a |........|.......j|
|00005040| 00 00 1e 00 a0 cf bf c0 | a0 cf bf c0 00 00 00 00 |........|........|
|00005050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 20 2a |........|...... *|
|00005070| 00 05 00 00 00 00 00 00 | 00 00 00 00 00 00 18 00 |........|........|
|00005080| 00 00 00 7a c6 a7 90 e6 | 3f e5 32 30 00 04 00 00 |...z....|?.20....|
|00005090| 00 00 00 00 00 00 a4 58 | 0b 60 a4 58 0b 60 a1 20 |.......X|.`.X.`. |
|000050a0| 06 7d 00 00 91 e8 00 00 | 00 53 00 06 06 4f 61 73 |.}......|.S...Oas|
|000050b0| 69 73 ba 00 0a 53 75 65 | 20 57 61 72 6e 65 72 00 |is...Sue| Warner.|
|000050c0| 01 36 00 0b 53 6f 72 74 | 20 53 63 72 69 70 74 00 |.6..Sort| Script.|
|000050d0| 0f 43 68 61 6e 67 65 73 | 20 66 6f 72 20 78 31 31 |.Changes| for x11|
|000050e0| 00 00 1a 43 68 65 63 6b | 20 69 6e 20 66 6f 72 20 |...Check| in for |
|000050f0| 67 6f 6c 64 65 6e 20 73 | 75 62 6d 69 74 00 00 00 |golden s|ubmit...|
|00005100| 01 00 00 00 01 7e 00 00 | 00 7e 00 00 00 3c 00 04 |.....~..|.~...<..|
|00005110| 6e 84 01 7a 00 00 00 1c | 00 32 00 00 63 6b 69 64 |n..z....|.2..ckid|
|00005120| 00 00 00 0a 00 80 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005130| 09 50 72 6f 6a 65 63 74 | 6f 72 00 00 00 00 00 00 |.Project|or......|
|00005140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+