The Macintosh Demo Applications CD

home *** CD-ROM | disk | FTP | other *** search
/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.iso / More Information / MacProject II / Resource Work Script < prev next >
MacBinary | 1991-05-16 | 16.3 KB | [RsSc/Rslv]
view JSON data |
view as text |
open on a Mac |
open on a PC

This file was processed as: MacBinary (archive/macBinary).

You can browse this item here: Resource Work Script
Confidence	Program	Detection	Match Type	Support
`10%`	dexvert	MacBinary `(archive/macBinary)`	fallback	Supported
`100%`	file	MacBinary II, inited, Thu May 16 06:00:00 1991, modified Thu May 16 06:00:00 1991, creator 'Rslv', type 'RsSc', 15951 bytes "Resource Work Script" , at 0x3ecf 451 bytes resource	default (weak)
`99%`	file	data	default
`66%`	TrID	raw Group 3 FAX bitmap	default (weak)
`33%`	TrID	MacBinary 2	default (weak)
`100%`	lsar	MacBinary	default
id metadata
key	value
macFileType	`[RsSc]`
macFileCreator	`[Rslv]`
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 14 52 65 73 6f 75 72 | 63 65 20 57 6f 72 6b 20 |..Resour|ce Work |
|00000010| 53 63 72 69 70 74 00 00 | 00 00 00 00 00 00 00 00 |Script..|........|
|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 3e 4f 00 | 00 01 c3 a4 58 08 a0 a4 |.....>O.|....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 fa b0 00 00 |........|........|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 fa 33 00 00 |BAT_BTSC|0101.3..|
|00000090| fd 09 00 00 1b 09 00 00 | 1b 09 00 00 1b 09 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 07 00 08 00 |........|........|
|000000d0| 0f 00 00 00 00 00 00 00 | 18 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 f4 00 06 1b 00 00 00 | f9 f2 20 00 1b 00 00 01 |........|.. .....|
|000000f0| f9 f8 1b 00 00 02 f9 f8 | 1b 00 00 03 f9 f8 1b 00 |........|........|
|00000100| 00 04 f9 f8 1b 00 00 05 | f9 f8 fc f6 00 00 fd 04 |........|........|
|00000110| 1b 00 00 fd 16 00 03 00 | 11 4d 50 20 52 65 73 6f |........|.MP Reso|
|00000120| 75 72 63 65 20 54 61 62 | 6c 65 fe 40 18 00 00 00 |urce Tab|le.@....|
|00000130| 00 00 00 00 00 39 f2 c9 | 00 1b 00 00 06 f9 f4 00 |.....9..|........|
|00000140| 00 fd 03 01 01 fd 06 00 | 00 00 00 00 fd 0e 08 01 |........|........|
|00000150| 01 01 01 07 07 00 00 00 | 00 ff 00 fd 15 00 06 00 |........|........|
|00000160| 10 4d 50 20 50 72 6f 6a | 65 63 74 20 54 61 62 6c |.MP Proj|ect Tabl|
|00000170| 65 fe 40 18 00 00 00 00 | 00 00 00 00 39 f2 71 00 |e.@.....|....9.q.|
|00000180| fd 04 1a 04 01 1b 00 00 | 06 f9 f4 00 01 fd 0e 08 |........|........|
|00000190| 01 01 01 01 07 07 00 00 | 2a 00 ff 00 fd 16 00 06 |........|*.......|
|000001a0| 00 11 4d 50 20 52 65 73 | 6f 75 72 63 65 20 54 61 |..MP Res|ource Ta|
|000001b0| 62 6c 65 fd 13 08 01 01 | 01 01 0c 08 0f 00 00 ff |ble.....|........|
|000001c0| 7f 2b 00 2b 00 ff 00 fd | 02 0c fd 13 08 01 01 01 |.+.+....|........|
|000001d0| 01 0c 08 0f 00 00 ff 7f | 2d 00 2f 00 ff 00 fd 03 |........|-./.....|
|000001e0| 18 04 18 00 00 00 00 00 | 00 f0 3f fa 1d 10 00 fd |........|..?.....|
|000001f0| 03 01 01 18 00 00 00 00 | 00 00 00 00 fa 1d 0c 00 |........|........|
|00000200| 18 00 00 00 00 00 00 00 | 00 fa fb f6 00 00 fd 04 |........|........|
|00000210| 08 01 05 18 00 00 00 00 | 00 00 f0 3f fe 19 d1 fa |........|...?....|
|00000220| fb f6 00 00 18 00 00 00 | 00 00 00 f0 3f f4 00 03 |........|....?...|
|00000230| 1a 00 00 18 00 00 00 00 | 00 00 f0 3f 1d 16 00 1a |........|...?....|
|00000240| 00 00 18 00 00 00 00 00 | 00 f0 3f f7 1a 00 03 2e |........|..?.....|
|00000250| f4 00 03 1a 00 03 f5 44 | 00 fd 14 17 80 01 10 18 |.......D|........|
|00000260| 00 00 00 00 00 00 46 40 | 1a 00 03 d4 d3 ff fd 14 |......F@|........|
|00000270| 17 80 01 10 18 00 00 00 | 00 00 00 47 40 1a 00 03 |........|...G@...|
|00000280| d4 d3 ff fd 14 17 80 01 | 10 18 00 00 00 00 00 00 |........|........|
|00000290| 48 40 1a 00 03 d4 d3 ff | 1d a6 ff fb f6 00 00 18 |H@......|........|
|000002a0| 00 00 00 00 00 00 08 40 | f4 00 05 18 00 00 00 00 |.......@|........|
|000002b0| 00 00 45 40 18 00 00 00 | 00 00 00 14 40 1d 1c 00 |..E@....|....@...|
|000002c0| 18 00 00 00 00 00 00 45 | 40 18 00 00 00 00 00 00 |.......E|@.......|
|000002d0| 14 40 f7 1a 00 05 2e f4 | 00 05 1a 00 05 f5 a0 00 |.@......|........|
|000002e0| 18 00 00 00 00 00 00 f0 | 3f f4 00 04 1a 00 01 18 |........|?.......|
|000002f0| 00 00 00 00 00 00 f0 3f | 1d 16 00 1a 00 01 18 00 |.......?|........|
|00000300| 00 00 00 00 00 f0 3f f7 | 1a 00 04 2e f4 00 04 1a |......?.|........|
|00000310| 00 04 f5 68 00 1a 00 05 | 1a 00 04 d4 f4 00 02 1a |...h....|........|
|00000320| 00 02 d3 53 38 f2 52 00 | 18 00 00 00 00 00 00 f0 |...S8.R.|........|
|00000330| 3f f4 00 03 1a 00 00 2a | 00 00 00 00 00 00 f0 3f |?......*|.......?|
|00000340| 18 00 00 00 00 00 00 f0 | 3f 1d 1f 00 1a 00 00 2a |........|?......*|
|00000350| 00 00 00 00 00 00 f0 3f | 18 00 00 00 00 00 00 f0 |.......?|........|
|00000360| 3f f7 1a 00 03 2e f4 00 | 03 1a 00 03 f5 0b 00 1b |?.......|........|
|00000370| 00 00 07 f9 f8 1d d6 ff | 1d 82 ff 1d 44 ff fb f6 |........|....D...|
|00000380| 00 03 1a 00 02 d2 18 00 | 00 00 00 00 80 45 40 1a |........|.....E@.|
|00000390| 00 03 d4 d2 39 f2 c5 00 | 1a 00 05 2a 00 00 00 00 |....9...|...*....|
|000003a0| 00 00 f0 3f 1a 00 04 d4 | d2 18 00 00 00 00 00 00 |...?....|........|
|000003b0| 47 40 1a 00 03 d4 d2 2e | f4 03 01 18 00 00 00 00 |G@......|........|
|000003c0| 00 00 46 40 1a 00 03 d4 | d2 2a 00 00 00 00 00 00 |..F@....|.*......|
|000003d0| f0 3f f4 03 02 18 00 00 | 00 00 00 00 48 40 1a 00 |.?......|....H@..|
|000003e0| 03 d4 d2 18 00 00 00 00 | 00 00 00 40 1a 00 04 d4 |........|...@....|
|000003f0| d2 2d 00 00 00 00 00 00 | 59 40 1a 00 05 2a 00 00 |.-......|Y@...*..|
|00000400| 00 00 00 00 f0 3f 1a 00 | 04 d4 d2 30 2e f4 03 03 |.....?..|...0....|
|00000410| fd 18 17 01 05 1a 03 01 | ff 01 0f 18 00 00 00 00 |........|........|
|00000420| 00 00 47 40 1a 00 03 d4 | ff fd 18 17 01 05 1a 03 |..G@....|........|
|00000430| 02 ff 01 0f 18 00 00 00 | 00 00 00 46 40 1a 00 03 |........|...F@...|
|00000440| d4 ff fd 18 17 01 05 1a | 03 03 ff 01 0f 18 00 00 |........|........|
|00000450| 00 00 00 00 48 40 1a 00 | 03 d4 ff fb f6 00 00 18 |....H@..|........|
|00000460| 00 00 00 00 00 00 f0 3f | f4 00 03 1a 00 00 18 00 |.......?|........|
|00000470| 00 00 00 00 00 f0 3f 1d | 16 00 1a 00 00 18 00 00 |......?.|........|
|00000480| 00 00 00 00 f0 3f f7 1a | 00 03 2e f4 00 03 1a 00 |.....?..|........|
|00000490| 03 f5 79 00 fd 39 17 01 | 25 19 01 3d 18 00 00 00 |..y..9..|%..=....|
|000004a0| 00 00 00 47 40 1a 00 03 | d4 35 19 01 2a 35 18 00 |...G@...|.5..*5..|
|000004b0| 00 00 00 00 80 46 40 1a | 00 03 d4 35 ff 01 10 18 |.....F@.|...5....|
|000004c0| 00 00 00 00 00 80 47 40 | 1a 00 03 d4 d3 ff fd 39 |......G@|.......9|
|000004d0| 17 01 25 19 01 3d 18 00 | 00 00 00 00 00 48 40 1a |..%..=..|.....H@.|
|000004e0| 00 03 d4 35 19 01 2a 35 | 18 00 00 00 00 00 80 46 |...5..*5|.......F|
|000004f0| 40 1a 00 03 d4 35 ff 01 | 10 18 00 00 00 00 00 80 |@....5..|........|
|00000500| 48 40 1a 00 03 d4 d3 ff | 1d 71 ff fb f6 00 00 fd |H@......|.q......|
|00000510| 28 08 01 01 01 01 21 18 | 00 00 00 00 00 80 45 40 |(.....!.|......E@|
|00000520| 18 00 00 00 00 00 00 f0 | 3f 18 00 00 00 00 00 80 |........|?.......|
|00000530| 48 40 1a 00 00 d8 ff 00 | fd 03 06 01 fd 03 01 01 |H@......|........|
|00000540| fd 06 00 00 00 00 00 fd | 04 1a 04 01 fd 05 1a 05 |........|........|
|00000550| 00 05 fd 05 1a 05 00 0d | fd 05 1a 05 00 03 fd 05 |........|........|
|00000560| 1a 05 00 04 fd 0a 08 01 | 01 01 00 02 42 35 00 fd |........|....B5..|
|00000570| 04 06 02 00 fd 32 17 01 | 27 19 16 52 65 73 6f 75 |.....2..|'..Resou|
|00000580| 72 63 65 20 57 6f 72 6b | 20 54 61 62 6c 65 20 2d |rce Work| Table -|
|00000590| 20 5f 19 08 6d 6d 2f 64 | 64 2f 79 79 68 35 ff 01 | _..mm/d|d/yyh5..|
|000005a0| 07 07 01 00 01 00 ff fd | 14 17 00 08 52 45 53 4f |........|....RESO|
|000005b0| 55 52 43 45 01 07 07 02 | 00 01 00 ff fd 10 17 00 |URCE....|........|
|000005c0| 04 4e 41 4d 45 01 07 07 | 03 00 01 00 ff fd 12 17 |.NAME...|........|
|000005d0| 00 06 4e 55 4d 42 45 52 | 01 07 07 02 00 02 00 ff |..NUMBER|........|
|000005e0| fd 14 17 00 08 4f 46 20 | 54 41 53 4b 53 01 07 07 |.....OF |TASKS...|
|000005f0| 03 00 02 00 ff fd 10 17 | 00 04 55 4e 49 54 01 07 |........|..UNIT..|
|00000600| 07 02 00 03 00 ff fd 10 | 17 00 04 43 4f 53 54 01 |........|...COST.|
|00000610| 07 07 03 00 03 00 ff fd | 13 17 00 07 50 4c 41 4e |........|....PLAN|
|00000620| 4e 45 44 01 07 07 02 00 | 04 00 ff fd 14 17 00 08 |NED.....|........|
|00000630| 44 55 52 41 54 49 4f 4e | 01 07 07 03 00 04 00 ff |DURATION|........|
|00000640| fd 13 17 00 07 50 4c 41 | 4e 4e 45 44 01 07 07 02 |.....PLA|NNED....|
|00000650| 00 05 00 ff fd 10 17 00 | 04 43 4f 53 54 01 07 07 |........|.COST...|
|00000660| 03 00 05 00 ff fd 12 17 | 00 06 41 43 54 55 41 4c |........|..ACTUAL|
|00000670| 01 07 07 02 00 06 00 ff | fd 14 17 00 08 44 55 52 |........|.....DUR|
|00000680| 41 54 49 4f 4e 01 07 07 | 03 00 06 00 ff fd 12 17 |ATION...|........|
|00000690| 00 06 41 43 54 55 41 4c | 01 07 07 02 00 07 00 ff |..ACTUAL|........|
|000006a0| fd 10 17 00 04 43 4f 53 | 54 01 07 07 03 00 07 00 |.....COS|T.......|
|000006b0| ff fd 31 08 01 01 01 01 | 2a 18 00 00 00 00 00 00 |..1.....|*.......|
|000006c0| 00 40 18 00 00 00 00 00 | 00 08 40 18 00 00 00 00 |.@......|..@.....|
|000006d0| 00 00 20 40 1a 00 00 2a | 00 00 00 00 00 00 10 40 |.. @...*|.......@|
|000006e0| d8 ff 00 fd 07 0f 03 02 | 02 0a 00 fd 0f 0f 03 01 |........|........|
|000006f0| 00 09 48 65 6c 76 65 74 | 69 63 61 fd 0a 0f 0a 00 |..Helvet|ica.....|
|00000700| 05 4f 74 6c 62 52 fd 13 | 08 01 01 01 01 0c 08 0f |.OtlbR..|........|
|00000710| 02 00 03 00 01 00 07 00 | ff 00 fd 07 0f 03 03 00 |........|........|
|00000720| 01 42 fd 07 0f 03 03 00 | 01 49 fd 04 0f 04 02 fd |.B......|.I......|
|00000730| 0a 0f 0a 00 05 4f 74 6c | 62 72 fd 31 08 01 01 01 |.....Otl|br.1....|
|00000740| 01 2a 18 00 00 00 00 00 | 00 10 40 18 00 00 00 00 |.*......|..@.....|
|00000750| 00 00 14 40 18 00 00 00 | 00 00 00 10 40 1a 00 00 |...@....|....@...|
|00000760| 2a 00 00 00 00 00 00 10 | 40 d8 ff 00 fd 05 0f 05 |*.......|@.......|
|00000770| 00 20 fd 06 0f 05 02 01 | 09 fd 31 08 01 01 01 01 |. ......|..1.....|
|00000780| 2a 18 00 00 00 00 00 00 | 18 40 18 00 00 00 00 00 |*.......|.@......|
|00000790| 00 14 40 18 00 00 00 00 | 00 00 18 40 1a 00 00 2a |..@.....|...@...*|
|000007a0| 00 00 00 00 00 00 10 40 | d8 ff 00 fd 05 0f 05 00 |.......@|........|
|000007b0| 20 fd 06 0f 05 02 01 09 | fd 31 08 01 01 01 01 2a | .......|.1.....*|
|000007c0| 18 00 00 00 00 00 00 20 | 40 18 00 00 00 00 00 00 |....... |@.......|
|000007d0| 14 40 18 00 00 00 00 00 | 00 20 40 1a 00 00 2a 00 |.@......|. @...*.|
|000007e0| 00 00 00 00 00 10 40 d8 | ff 00 fd 05 0f 05 00 20 |......@.|....... |
|000007f0| fd 06 0f 05 02 01 09 fd | 0f 19 01 02 01 07 07 00 |........|........|
|00000800| 00 00 00 ff 02 b4 00 fd | 0f 19 00 02 01 07 07 00 |........|........|
|00000810| 00 00 00 ff 02 b4 00 fd | 0e 08 01 01 01 01 07 07 |........|........|
|00000820| 01 00 01 00 ff 00 fd 0f | 0f 03 01 00 09 48 65 6c |........|.....Hel|
|00000830| 76 65 74 69 63 61 fd 07 | 0f 03 03 00 01 42 fd 07 |vetica..|.....B..|
|00000840| 0f 03 03 00 01 49 fd 07 | 0f 03 02 02 12 00 fd 07 |.....I..|........|
|00000850| 19 00 01 02 b0 01 fd 0f | 19 01 02 01 07 07 00 00 |........|........|
|00000860| 08 00 ff 02 b4 00 fd 20 | 19 00 02 01 18 18 00 00 |....... |........|
|00000870| 00 00 00 00 f0 3f 1a 00 | 00 2a 00 00 00 00 00 00 |.....?..|.*......|
|00000880| 14 40 d4 ff 02 b4 00 fd | 0e 08 01 01 01 01 07 07 |.@......|........|
|00000890| 00 00 00 00 ff 00 fd 03 | 06 01 fd 04 08 01 07 fd |........|........|
|000008a0| 04 1b 00 01 fb f6 00 00 | fd 12 1d 00 00 00 02 ff |........|........|
|000008b0| ff 02 ff ff 00 02 50 19 | 02 70 08 fd 4f 1e 0b 00 |......P.|.p..O...|
|000008c0| 3b 43 6f 70 79 20 74 61 | 62 6c 65 20 74 6f 20 43 |;Copy ta|ble to C|
|000008d0| 6c 69 70 62 6f 61 72 64 | 20 61 6e 64 20 63 6c 6f |lipboard| and clo|
|000008e0| 73 65 20 77 6f 72 6b 73 | 68 65 65 74 20 77 69 74 |se works|heet wit|
|000008f0| 68 6f 75 74 20 73 61 76 | 69 6e 67 3f 00 00 02 b4 |hout sav|ing?....|
|00000900| 00 02 b4 00 01 02 e8 17 | 02 d0 02 fd 06 0f 02 00 |........|........|
|00000910| 1c 00 fd 2e 1e 00 01 00 | 0a 20 20 20 20 4e 6f 20 |........|.    No |
|00000920| 20 20 20 01 00 0b 20 20 | 20 20 59 65 73 20 20 20 |   ...  |  Yes   |
|00000930| 20 00 00 00 02 48 12 02 | 84 03 01 02 a0 05 02 38 | ....H..|.......8|
|00000940| 04 fd 06 1d 0b 01 82 00 | fd 03 1d 09 fd 25 21 03 |........|.....%!.|
|00000950| 00 00 1f 27 52 65 73 6f | 75 72 63 65 20 57 6f 72 |...'Reso|urce Wor|
|00000960| 6b 20 53 63 72 69 70 74 | 3a 64 6f 6e 65 27 20 3d |k Script|:done' =|
|00000970| 20 30 fd 06 1d 0b 01 83 | 00 fd 03 1d 08 fd 25 21 | 0......|......%!|
|00000980| 03 00 00 1f 27 52 65 73 | 6f 75 72 63 65 20 57 6f |....'Res|ource Wo|
|00000990| 72 6b 20 53 63 72 69 70 | 74 3a 64 6f 6e 65 27 20 |rk Scrip|t:done' |
|000009a0| 3d 20 31 fd 03 1d 03 1a | 00 06 18 00 00 00 00 00 |= 1.....|........|
|000009b0| 00 f0 3f 39 f2 3c 00 fd | 31 08 01 01 01 01 2a 18 |..?9.<..|1.....*.|
|000009c0| 00 00 00 00 00 00 f0 3f | 18 00 00 00 00 00 00 f0 |.......?|........|
|000009d0| 3f 18 00 00 00 00 00 00 | 22 40 1a 00 00 2a 00 00 |?.......|"@...*..|
|000009e0| 00 00 00 00 14 40 d8 ff | 00 fd 03 06 01 fd 03 01 |.....@..|........|
|000009f0| 01 fb fc 0c 00 6c 61 73 | 74 5f 52 54 5f 72 6f 77 |.....las|t_RT_row|
|00000a00| 00 0c 00 6c 61 73 74 5f | 50 54 5f 72 6f 77 01 0d |...last_|PT_row..|
|00000a10| 00 63 75 72 72 65 6e 74 | 5f 63 65 6c 6c 02 05 00 |.current|_cell...|
|00000a20| 6c 6f 6f 70 03 08 00 63 | 75 72 5f 72 6f 77 04 08 |loop...c|ur_row..|
|00000a30| 00 63 75 72 5f 63 6f 6c | 05 05 00 64 6f 6e 65 06 |.cur_col|...done.|
|00000a40| 0a 01 00 47 45 54 5f 44 | 41 54 41 33 00 00 00 0f |...GET_D|ATA3....|
|00000a50| 01 00 43 4c 45 41 52 5f | 43 4f 4c 55 4d 4e 53 49 |..CLEAR_|COLUMNSI|
|00000a60| 01 00 00 10 01 00 43 41 | 4c 43 5f 44 55 52 41 54 |......CA|LC_DURAT|
|00000a70| 49 4f 4e 53 c4 01 00 00 | 11 01 00 43 52 45 41 54 |IONS....|...CREAT|
|00000a80| 45 5f 46 4f 52 4d 55 4c | 41 53 84 03 00 00 0e 01 |E_FORMUL|AS......|
|00000a90| 00 43 52 45 41 54 45 5f | 54 41 42 4c 45 34 04 00 |.CREATE_|TABLE4..|
|00000aa0| 00 0d 01 00 41 53 4b 5f | 54 4f 5f 43 4f 50 59 cd |....ASK_|TO_COPY.|
|00000ab0| 07 00 00 0a 01 00 47 45 | 54 5f 52 4f 57 53 33 01 |......GE|T_ROWS3.|
|00000ac0| 00 00 0e 01 00 41 44 44 | 5f 54 4f 5f 54 41 42 4c |.....ADD|_TO_TABL|
|00000ad0| 45 a7 02 00 00 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |E....{**|********|
|00000ae0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000af0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 52 45 53 4f |********|*** RESO|
|00000b00| 55 52 43 45 20 57 4f 52 | 4b 20 54 41 42 4c 45 20 |URCE WOR|K TABLE |
|00000b10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 20 20 a9 20 |********|***.  . |
|00000b40| 31 39 39 31 20 43 6c 61 | 72 69 73 20 43 6f 72 70 |1991 Cla|ris Corp|
|00000b50| 6f 72 61 74 69 6f 6e 2e | 20 20 41 6c 6c 20 72 69 |oration.|  All ri|
|00000b60| 67 68 74 73 20 72 65 73 | 65 72 76 65 64 2e 0d 0d |ghts res|erved...|
|00000b70| 20 20 4c 41 53 54 20 4d | 4f 44 49 46 49 45 44 3a |  LAST M|ODIFIED:|
|00000b80| 20 20 31 2f 31 34 2f 39 | 31 0d 0d 20 20 54 61 62 |  1/14/9|1..  Tab|
|00000b90| 6c 65 73 20 55 73 65 64 | 3a 0d 09 a5 20 20 52 65 |les Used|:...  Re|
|00000ba0| 73 6f 75 72 63 65 20 54 | 61 62 6c 65 0d 09 a5 20 |source T|able... |
|00000bb0| 20 50 72 6f 6a 65 63 74 | 20 54 61 62 6c 65 0d 0d | Project| Table..|
|00000bc0| 20 20 41 73 73 75 6d 70 | 74 69 6f 6e 73 3a 0d 09 |  Assump|tions:..|
|00000bd0| a5 20 20 41 6c 6c 20 72 | 65 73 6f 75 72 63 65 2d |.  All r|esource-|
|00000be0| 72 65 6c 61 74 65 64 20 | 63 6f 6c 75 6d 6e 73 20 |related |columns |
|00000bf0| 69 6e 20 74 68 65 20 50 | 72 6f 6a 65 63 74 20 54 |in the P|roject T|
|00000c00| 61 62 6c 65 20 61 72 65 | 20 65 78 70 6f 72 74 65 |able are| exporte|
|00000c10| 64 0d 09 a5 20 20 41 6c | 6c 20 6f 74 68 65 72 20 |d...  Al|l other |
|00000c20| 63 6f 6c 75 6d 6e 73 20 | 61 72 65 20 6e 6f 74 20 |columns |are not |
|00000c30| 65 78 70 6f 72 74 65 64 | 20 65 78 63 65 70 74 20 |exported| except |
|00000c40| 74 68 65 20 54 61 73 6b | 20 4e 61 6d 65 20 61 6e |the Task| Name an|
|00000c50| 64 20 25 20 44 6f 6e 65 | 20 28 74 68 65 73 65 20 |d % Done| (these |
|00000c60| 6d 75 73 74 20 62 65 20 | 65 78 70 6f 72 74 65 64 |must be |exported|
|00000c70| 29 0d 09 2d 2d 3e 20 50 | 72 6f 6a 65 63 74 20 54 |)..--> P|roject T|
|00000c80| 61 62 6c 65 20 73 68 6f | 75 6c 64 20 68 61 76 65 |able sho|uld have|
|00000c90| 20 34 32 20 63 6f 6c 75 | 6d 6e 73 20 28 35 20 63 | 42 colu|mns (5 c|
|00000ca0| 6f 6c 75 6d 6e 73 20 70 | 65 72 20 72 65 73 6f 75 |olumns p|er resou|
|00000cb0| 72 63 65 20 2a 20 38 20 | 72 65 73 6f 75 72 63 65 |rce * 8 |resource|
|00000cc0| 73 20 2b 20 54 61 73 6b | 20 4e 61 6d 65 20 2b 0d |s + Task| Name +.|
|00000cd0| 09 20 20 20 20 25 20 44 | 6f 6e 65 20 3d 20 34 32 |.    % D|one = 42|
|00000ce0| 29 0d 0d 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |)..*****|********|
|00000cf0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 44 45 46 49 4e 45 |********|* DEFINE|
|00000d10| 20 47 4c 4f 42 41 4c 20 | 56 41 52 49 41 42 4c 45 | GLOBAL |VARIABLE|
|00000d20| 53 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |S ******|********|
|00000d30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d40| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 44 45 46 49 4e |********|}..DEFIN|
|00000d50| 45 20 6c 61 73 74 5f 52 | 54 5f 72 6f 77 09 09 7b |E last_R|T_row..{|
|00000d60| 20 4e 75 6d 62 65 72 20 | 6f 66 20 72 6f 77 73 20 | Number |of rows |
|00000d70| 69 6e 20 52 65 73 6f 75 | 72 63 65 20 54 61 62 6c |in Resou|rce Tabl|
|00000d80| 65 20 7d 0d 44 45 46 49 | 4e 45 20 6c 61 73 74 5f |e }.DEFI|NE last_|
|00000d90| 50 54 5f 72 6f 77 09 09 | 7b 20 4e 75 6d 62 65 72 |PT_row..|{ Number|
|00000da0| 20 6f 66 20 72 6f 77 73 | 20 69 6e 20 50 72 6f 6a | of rows| in Proj|
|00000db0| 65 63 74 20 54 61 62 6c | 65 20 7d 0d 44 45 46 49 |ect Tabl|e }.DEFI|
|00000dc0| 4e 45 20 63 75 72 72 65 | 6e 74 5f 63 65 6c 6c 09 |NE curre|nt_cell.|
|00000dd0| 09 7b 20 43 75 72 72 65 | 6e 74 20 43 65 6c 6c 20 |.{ Curre|nt Cell |
|00000de0| 7d 0d 44 45 46 49 4e 45 | 20 6c 6f 6f 70 09 09 09 |}.DEFINE| loop...|
|00000df0| 7b 20 4d 61 69 6e 20 6c | 6f 6f 70 20 63 6f 75 6e |{ Main l|oop coun|
|00000e00| 74 65 72 20 7d 0d 44 45 | 46 49 4e 45 20 63 75 72 |ter }.DE|FINE cur|
|00000e10| 5f 72 6f 77 3b 20 63 75 | 72 5f 63 6f 6c 09 7b 20 |_row; cu|r_col.{ |
|00000e20| 43 75 72 72 65 6e 74 20 | 72 6f 77 20 61 6e 64 20 |Current |row and |
|00000e30| 63 6f 6c 75 6d 6e 20 7d | 0d 44 45 46 49 4e 45 20 |column }|.DEFINE |
|00000e40| 64 6f 6e 65 09 09 09 7b | 20 44 6f 6e 65 20 66 6c |done...{| Done fl|
|00000e50| 61 67 20 7d 0d 0d 64 6f | 6e 65 20 3d 20 30 09 09 |ag }..do|ne = 0..|
|00000e60| 09 09 7b 20 53 65 74 20 | 64 6f 6e 65 20 66 6c 61 |..{ Set |done fla|
|00000e70| 67 20 74 6f 20 7a 65 72 | 6f 20 7d 0d 0d 7b 2a 2a |g to zer|o }..{**|
|00000e80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000e90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ea0| 2a 2a 2a 20 4d 41 49 4e | 20 53 43 52 49 50 54 20 |*** MAIN| SCRIPT |
|00000eb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ec0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ed0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ee0| 2a 2a 7d 0d 0d 49 46 20 | 47 45 54 5f 44 41 54 41 |**}..IF |GET_DATA|
|00000ef0| 28 29 09 09 09 09 09 09 | 09 09 7b 20 52 75 6e 20 |()......|..{ Run |
|00000f00| 47 45 54 5f 44 41 54 41 | 20 66 75 6e 63 74 69 6f |GET_DATA| functio|
|00000f10| 6e 20 7d 0d 09 43 41 4c | 4c 20 43 4c 45 41 52 5f |n }..CAL|L CLEAR_|
|00000f20| 43 4f 4c 55 4d 4e 53 28 | 29 09 09 09 09 09 7b 20 |COLUMNS(|).....{ |
|00000f30| 52 75 6e 20 43 4c 45 41 | 52 5f 43 4f 4c 55 4d 4e |Run CLEA|R_COLUMN|
|00000f40| 53 20 66 75 6e 63 74 69 | 6f 6e 20 7d 0d 09 43 41 |S functi|on }..CA|
|00000f50| 4c 4c 20 43 41 4c 43 5f | 44 55 52 41 54 49 4f 4e |LL CALC_|DURATION|
|00000f60| 53 28 29 09 09 09 09 09 | 7b 20 52 75 6e 20 43 41 |S().....|{ Run CA|
|00000f70| 4c 43 5f 44 55 52 41 54 | 49 4f 4e 53 20 66 75 6e |LC_DURAT|IONS fun|
|00000f80| 63 74 69 6f 6e 20 7d 0d | 09 43 41 4c 4c 20 43 52 |ction }.|.CALL CR|
|00000f90| 45 41 54 45 5f 46 4f 52 | 4d 55 4c 41 53 28 29 09 |EATE_FOR|MULAS().|
|00000fa0| 09 09 09 09 7b 20 52 75 | 6e 20 43 52 45 41 54 45 |....{ Ru|n CREATE|
|00000fb0| 5f 46 4f 52 4d 55 4c 41 | 53 20 66 75 6e 63 74 69 |_FORMULA|S functi|
|00000fc0| 6f 6e 20 7d 0d 09 43 41 | 4c 4c 20 43 52 45 41 54 |on }..CA|LL CREAT|
|00000fd0| 45 5f 54 41 42 4c 45 28 | 29 09 09 09 09 09 09 7b |E_TABLE(|)......{|
|00000fe0| 20 52 75 6e 20 43 52 45 | 41 54 45 5f 54 41 42 4c | Run CRE|ATE_TABL|
|00000ff0| 45 20 66 75 6e 63 74 69 | 6f 6e 20 7d 0d 09 43 41 |E functi|on }..CA|
|00001000| 4c 4c 20 41 53 4b 5f 54 | 4f 5f 43 4f 50 59 28 29 |LL ASK_T|O_COPY()|
|00001010| 09 09 09 09 09 09 7b 20 | 52 75 6e 20 41 53 4b 5f |......{ |Run ASK_|
|00001020| 54 4f 5f 43 4f 50 59 20 | 66 75 6e 63 74 69 6f 6e |TO_COPY |function|
|00001030| 20 7d 0d 45 4e 44 20 49 | 46 0d 0d 7b 2a 2a 2a 2a | }.END I|F..{****|
|00001040| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001050| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001060| 2a 20 47 45 54 5f 44 41 | 54 41 20 2a 2a 2a 2a 2a |* GET_DA|TA *****|
|00001070| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001080| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001090| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010a0| 2a 0d 20 20 54 68 69 73 | 20 66 75 6e 63 74 69 6f |*.  This| functio|
|000010b0| 6e 20 6f 70 65 6e 73 20 | 74 68 65 20 74 77 6f 20 |n opens |the two |
|000010c0| 63 68 61 72 74 73 20 75 | 73 65 64 20 62 79 20 74 |charts u|sed by t|
|000010d0| 68 69 73 20 73 63 72 69 | 70 74 20 61 6e 64 20 65 |his scri|pt and e|
|000010e0| 78 74 72 61 63 74 73 20 | 74 68 65 20 64 61 74 61 |xtracts |the data|
|000010f0| 20 66 72 6f 6d 20 74 68 | 65 6d 2e 20 20 0d 20 2a | from th|em.  . *|
|00001100| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001110| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001130| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001140| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001150| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001160| 2a 2a 2a 7d 0d 0d 46 55 | 4e 43 54 49 4f 4e 20 47 |***}..FU|NCTION G|
|00001170| 45 54 5f 44 41 54 41 28 | 29 0d 09 52 45 50 41 49 |ET_DATA(|)..REPAI|
|00001180| 4e 54 20 4f 46 46 09 09 | 09 09 09 09 09 7b 20 54 |NT OFF..|.....{ T|
|00001190| 75 72 6e 20 52 65 70 61 | 69 6e 74 20 6f 66 66 20 |urn Repa|int off |
|000011a0| 74 6f 20 73 70 65 65 64 | 20 75 70 20 6f 70 65 72 |to speed| up oper|
|000011b0| 61 74 69 6f 6e 20 7d 0d | 09 4f 50 45 4e 20 22 4d |ation }.|.OPEN "M|
|000011c0| 50 20 52 65 73 6f 75 72 | 63 65 20 54 61 62 6c 65 |P Resour|ce Table|
|000011d0| 22 09 09 09 09 09 7b 20 | 4f 70 65 6e 20 52 65 73 |".....{ |Open Res|
|000011e0| 6f 75 72 63 65 20 54 61 | 62 6c 65 20 74 6f 20 64 |ource Ta|ble to d|
|000011f0| 65 74 65 72 6d 69 6e 65 | 20 23 20 6f 66 20 72 65 |etermine| # of re|
|00001200| 73 6f 75 72 63 65 73 20 | 7d 0d 09 49 46 20 43 45 |sources |}..IF CE|
|00001210| 52 52 4f 52 28 29 20 3d | 20 30 09 09 09 09 09 09 |RROR() =| 0......|
|00001220| 7b 20 43 68 65 63 6b 20 | 69 66 20 74 68 65 20 64 |{ Check |if the d|
|00001230| 6f 63 75 6d 65 6e 74 20 | 77 61 73 20 66 6f 75 6e |ocument |was foun|
|00001240| 64 20 7d 0d 09 09 6c 61 | 73 74 5f 52 54 5f 72 6f |d }...la|st_RT_ro|
|00001250| 77 20 3d 20 47 45 54 5f | 52 4f 57 53 28 29 20 20 |w = GET_|ROWS()  |
|00001260| 09 09 09 7b 20 44 65 74 | 65 72 6d 69 6e 65 20 23 |...{ Det|ermine #|
|00001270| 20 6f 66 20 72 6f 77 73 | 20 69 6e 20 74 68 65 20 | of rows| in the |
|00001280| 52 65 73 6f 75 72 63 65 | 20 54 61 62 6c 65 20 7d |Resource| Table }|
|00001290| 0d 09 09 43 4c 4f 53 45 | 20 4e 4f 57 09 09 09 09 |...CLOSE| NOW....|
|000012a0| 09 09 09 7b 20 43 6c 6f | 73 65 20 52 65 73 6f 75 |...{ Clo|se Resou|
|000012b0| 72 63 65 20 54 61 62 6c | 65 20 77 69 74 68 6f 75 |rce Tabl|e withou|
|000012c0| 74 20 73 61 76 69 6e 67 | 20 7d 0d 09 09 4e 45 57 |t saving| }...NEW|
|000012d0| 20 57 4f 52 4b 53 48 45 | 45 54 20 22 22 09 09 09 | WORKSHE|ET ""...|
|000012e0| 09 09 7b 20 43 72 65 61 | 74 65 20 6e 65 77 20 75 |..{ Crea|te new u|
|000012f0| 6e 74 69 74 6c 65 64 20 | 77 6f 72 6b 73 68 65 65 |ntitled |workshee|
|00001300| 74 20 7d 0d 09 09 53 45 | 4c 45 43 54 20 52 41 4e |t }...SE|LECT RAN|
|00001310| 47 45 20 41 31 09 09 09 | 09 09 7b 20 4d 61 6b 65 |GE A1...|..{ Make|
|00001320| 20 73 75 72 65 20 74 68 | 65 20 6e 65 78 74 20 6c | sure th|e next l|
|00001330| 69 6e 65 20 70 75 74 73 | 20 74 68 65 20 69 6e 66 |ine puts| the inf|
|00001340| 6f 20 69 6e 20 64 65 73 | 69 72 65 64 20 6c 6f 63 |o in des|ired loc|
|00001350| 61 74 69 6f 6e 20 7d 0d | 09 09 41 50 50 45 4e 44 |ation }.|..APPEND|
|00001360| 20 22 4d 50 20 50 72 6f | 6a 65 63 74 20 54 61 62 | "MP Pro|ject Tab|
|00001370| 6c 65 22 09 09 09 7b 20 | 41 70 70 65 6e 64 20 74 |le"...{ |Append t|
|00001380| 68 65 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |he Proje|ct Table|
|00001390| 20 64 6f 63 75 6d 65 6e | 74 20 7d 0d 09 09 49 46 | documen|t }...IF|
|000013a0| 20 43 45 52 52 4f 52 28 | 29 20 3d 20 30 09 09 09 | CERROR(|) = 0...|
|000013b0| 09 09 7b 20 43 68 65 63 | 6b 20 65 72 72 6f 72 20 |..{ Chec|k error |
|000013c0| 72 65 74 75 72 6e 65 64 | 20 62 79 20 4f 50 45 4e |returned| by OPEN|
|000013d0| 20 7d 0d 09 09 09 5a 4f | 4f 4d 20 57 49 4e 44 4f | }....ZO|OM WINDO|
|000013e0| 57 09 09 09 09 09 7b 20 | 5a 6f 6f 6d 20 74 68 65 |W.....{ |Zoom the|
|000013f0| 20 77 69 6e 64 6f 77 20 | 74 6f 20 66 69 6c 6c 20 | window |to fill |
|00001400| 74 68 65 20 73 63 72 65 | 65 6e 20 7d 09 09 09 0d |the scre|en }....|
|00001410| 09 09 09 6c 61 73 74 5f | 50 54 5f 72 6f 77 20 3d |...last_|PT_row =|
|00001420| 20 47 45 54 5f 52 4f 57 | 53 28 29 20 20 09 09 7b | GET_ROW|S()  ..{|
|00001430| 20 44 65 74 65 72 6d 69 | 6e 65 20 23 20 6f 66 20 | Determi|ne # of |
|00001440| 72 6f 77 73 20 69 6e 20 | 74 68 65 20 50 72 6f 6a |rows in |the Proj|
|00001450| 65 63 74 20 54 61 62 6c | 65 20 43 68 61 72 74 20 |ect Tabl|e Chart |
|00001460| 7d 0d 09 09 09 53 45 4c | 45 43 54 20 52 41 4e 47 |}....SEL|ECT RANG|
|00001470| 45 20 41 51 31 20 20 09 | 09 09 09 7b 20 53 65 6c |E AQ1  .|...{ Sel|
|00001480| 65 63 74 20 63 65 6c 6c | 20 41 51 31 20 7d 0d 09 |ect cell| AQ1 }..|
|00001490| 09 09 41 50 50 45 4e 44 | 20 22 4d 50 20 52 65 73 |..APPEND| "MP Res|
|000014a0| 6f 75 72 63 65 20 54 61 | 62 6c 65 22 09 09 7b 20 |ource Ta|ble"..{ |
|000014b0| 41 70 70 65 6e 64 20 74 | 68 65 20 52 65 73 6f 75 |Append t|he Resou|
|000014c0| 72 63 65 20 54 61 62 6c | 65 20 64 6f 63 75 6d 65 |rce Tabl|e docume|
|000014d0| 6e 74 20 7d 0d 09 09 09 | 53 45 4c 45 43 54 20 52 |nt }....|SELECT R|
|000014e0| 41 4e 47 45 20 41 52 31 | 2e 2e 41 52 33 32 37 36 |ANGE AR1|..AR3276|
|000014f0| 38 09 09 7b 20 53 65 6c | 65 63 74 20 63 6f 6c 75 |8..{ Sel|ect colu|
|00001500| 6d 6e 20 41 52 20 7d 0d | 09 09 09 49 4e 53 45 52 |mn AR }.|...INSER|
|00001510| 54 09 09 09 09 09 09 7b | 20 49 6e 73 65 72 74 20 |T......{| Insert |
|00001520| 61 20 6e 65 77 20 63 6f | 6c 75 6d 6e 20 7d 0d 09 |a new co|lumn }..|
|00001530| 09 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 20 41 |..SELECT| RANGE A|
|00001540| 54 31 2e 2e 41 56 33 32 | 37 36 38 09 09 7b 20 53 |T1..AV32|768..{ S|
|00001550| 65 6c 65 63 74 20 65 78 | 74 72 61 20 75 6e 77 61 |elect ex|tra unwa|
|00001560| 6e 74 65 64 20 52 65 73 | 6f 75 72 63 65 20 54 61 |nted Res|ource Ta|
|00001570| 62 6c 65 20 63 6f 6c 75 | 6d 6e 73 20 7d 0d 09 09 |ble colu|mns }...|
|00001580| 09 52 45 4d 4f 56 45 20 | 44 41 54 41 20 41 4e 44 |.REMOVE |DATA AND|
|00001590| 20 4f 42 4a 45 43 54 53 | 09 09 09 7b 20 44 65 6c | OBJECTS|...{ Del|
|000015a0| 65 74 65 20 61 6c 6c 20 | 74 68 65 20 64 61 74 61 |ete all |the data|
|000015b0| 20 7d 0d 09 09 09 52 45 | 54 55 52 4e 20 31 09 09 | }....RE|TURN 1..|
|000015c0| 09 09 09 09 7b 20 52 65 | 74 75 72 6e 20 76 61 6c |....{ Re|turn val|
|000015d0| 75 65 20 69 6e 64 69 63 | 61 74 69 6e 67 20 73 63 |ue indic|ating sc|
|000015e0| 72 69 70 74 20 73 68 6f | 75 6c 64 20 63 6f 6e 74 |ript sho|uld cont|
|000015f0| 69 6e 75 65 20 7d 0d 09 | 09 45 4c 53 45 0d 09 09 |inue }..|.ELSE...|
|00001600| 09 43 4c 4f 53 45 20 4e | 4f 57 09 09 09 09 09 09 |.CLOSE N|OW......|
|00001610| 7b 20 43 6c 6f 73 65 20 | 74 68 65 20 6e 65 77 20 |{ Close |the new |
|00001620| 77 6f 72 6b 73 68 65 65 | 74 20 77 69 74 68 6f 75 |workshee|t withou|
|00001630| 74 20 73 61 76 69 6e 67 | 20 7d 0d 09 09 09 52 45 |t saving| }....RE|
|00001640| 54 55 52 4e 20 30 09 09 | 09 09 09 09 7b 20 52 65 |TURN 0..|....{ Re|
|00001650| 74 75 72 6e 20 76 61 6c | 75 65 20 69 6e 64 69 63 |turn val|ue indic|
|00001660| 61 74 69 6e 67 20 74 68 | 65 20 73 63 72 69 70 74 |ating th|e script|
|00001670| 20 73 68 6f 75 6c 64 20 | 62 65 20 73 74 6f 70 70 | should |be stopp|
|00001680| 65 64 20 7d 0d 09 09 45 | 4e 44 20 49 46 0d 09 45 |ed }...E|ND IF..E|
|00001690| 4c 53 45 0d 09 09 52 45 | 54 55 52 4e 20 30 09 09 |LSE...RE|TURN 0..|
|000016a0| 09 09 09 09 09 7b 20 52 | 65 74 75 72 6e 20 76 61 |.....{ R|eturn va|
|000016b0| 6c 75 65 20 69 6e 64 69 | 63 61 74 69 6e 67 20 73 |lue indi|cating s|
|000016c0| 63 72 69 70 74 20 73 68 | 6f 75 6c 64 20 73 74 6f |cript sh|ould sto|
|000016d0| 70 20 7d 0d 09 45 4e 44 | 20 49 46 0d 45 4e 44 20 |p }..END| IF.END |
|000016e0| 46 55 4e 43 54 49 4f 4e | 0d 0d 7b 2a 2a 2a 2a 2a |FUNCTION|..{*****|
|000016f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001700| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001710| 20 47 45 54 5f 52 4f 57 | 53 20 2a 2a 2a 2a 2a 2a | GET_ROW|S ******|
|00001720| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001730| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001740| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001750| 0d 20 20 54 68 69 73 20 | 66 75 6e 63 74 69 6f 6e |.  This |function|
|00001760| 20 64 65 74 65 72 6d 69 | 6e 65 73 20 74 68 65 20 | determi|nes the |
|00001770| 6e 75 6d 62 65 72 20 6f | 66 20 72 6f 77 73 20 75 |number o|f rows u|
|00001780| 73 65 64 20 6f 6e 20 61 | 20 63 68 61 72 74 2e 20 |sed on a| chart. |
|00001790| 20 57 65 20 66 69 72 73 | 74 20 73 65 6c 65 63 74 | We firs|t select|
|000017a0| 20 61 6c 6c 20 61 63 74 | 69 76 65 20 63 65 6c 6c | all act|ive cell|
|000017b0| 73 2e 0d 20 20 57 65 20 | 74 68 65 6e 20 75 73 65 |s..  We |then use|
|000017c0| 20 74 68 65 20 53 45 4c | 45 43 54 49 4f 4e 20 66 | the SEL|ECTION f|
|000017d0| 75 6e 63 74 69 6f 6e 20 | 74 6f 20 72 65 74 75 72 |unction |to retur|
|000017e0| 6e 20 74 68 65 20 72 61 | 6e 67 65 20 61 6e 64 20 |n the ra|nge and |
|000017f0| 74 68 65 20 52 4f 57 53 | 20 66 75 6e 63 74 69 6f |the ROWS| functio|
|00001800| 6e 20 74 6f 20 67 65 74 | 20 74 68 65 20 6e 75 6d |n to get| the num|
|00001810| 62 65 72 20 6f 66 0d 20 | 20 72 6f 77 73 20 69 6e |ber of. | rows in|
|00001820| 20 74 68 61 74 20 72 61 | 6e 67 65 2e 20 20 54 68 | that ra|nge.  Th|
|00001830| 65 20 72 65 73 75 6c 74 | 69 6e 67 20 76 61 6c 75 |e result|ing valu|
|00001840| 65 20 69 73 20 74 68 65 | 6e 20 72 65 74 75 72 6e |e is the|n return|
|00001850| 65 64 20 74 6f 20 74 68 | 65 20 63 61 6c 6c 69 6e |ed to th|e callin|
|00001860| 67 20 73 74 61 74 65 6d | 65 6e 74 2e 0d 20 2a 2a |g statem|ent.. **|
|00001870| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001880| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000018a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000018b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000018c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000018d0| 2a 2a 7d 0d 0d 46 55 4e | 43 54 49 4f 4e 20 47 45 |**}..FUN|CTION GE|
|000018e0| 54 5f 52 4f 57 53 28 29 | 0d 09 53 45 4c 45 43 54 |T_ROWS()|..SELECT|
|000018f0| 20 41 43 54 49 56 45 20 | 43 45 4c 4c 53 09 09 09 | ACTIVE |CELLS...|
|00001900| 09 09 09 7b 20 53 65 6c | 65 63 74 20 6e 6f 6e 2d |...{ Sel|ect non-|
|00001910| 62 6c 61 6e 6b 20 63 65 | 6c 6c 73 20 7d 0d 09 52 |blank ce|lls }..R|
|00001920| 45 54 55 52 4e 20 52 4f | 57 53 28 53 45 4c 45 43 |ETURN RO|WS(SELEC|
|00001930| 54 49 4f 4e 28 31 29 29 | 09 09 09 09 7b 20 44 65 |TION(1))|....{ De|
|00001940| 74 65 72 6d 69 6e 65 20 | 23 20 6f 66 20 72 6f 77 |termine |# of row|
|00001950| 73 20 69 6e 20 73 65 6c | 65 63 74 65 64 20 72 61 |s in sel|ected ra|
|00001960| 6e 67 65 20 7d 0d 45 4e | 44 20 46 55 4e 43 54 49 |nge }.EN|D FUNCTI|
|00001970| 4f 4e 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ON..{***|********|
|00001980| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001990| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 43 4c 45 41 52 |********|** CLEAR|
|000019a0| 5f 43 4f 4c 55 4d 4e 53 | 20 2a 2a 2a 2a 2a 2a 2a |_COLUMNS| *******|
|000019b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 0d 20 20 54 68 69 73 |********|*.  This|
|000019e0| 20 66 75 6e 63 74 69 6f | 6e 20 69 6e 69 74 69 61 | functio|n initia|
|000019f0| 6c 69 7a 65 73 20 74 68 | 65 20 63 6f 6c 75 6d 6e |lizes th|e column|
|00001a00| 73 20 69 6e 20 77 68 69 | 63 68 20 63 61 6c 63 75 |s in whi|ch calcu|
|00001a10| 6c 61 74 65 64 20 76 61 | 6c 75 65 73 20 77 69 6c |lated va|lues wil|
|00001a20| 6c 20 62 65 20 65 6e 74 | 65 72 65 64 2e 20 20 54 |l be ent|ered.  T|
|00001a30| 68 69 73 20 69 73 20 64 | 6f 6e 65 20 74 6f 0d 20 |his is d|one to. |
|00001a40| 20 65 6e 73 75 72 65 20 | 74 68 61 74 20 75 6e 75 | ensure |that unu|
|00001a50| 73 65 64 20 72 65 73 6f | 75 72 63 65 73 20 77 69 |sed reso|urces wi|
|00001a60| 6c 6c 20 64 69 73 70 6c | 61 79 20 7a 65 72 6f 20 |ll displ|ay zero |
|00001a70| 66 6f 72 20 74 68 65 73 | 65 20 76 61 6c 75 65 73 |for thes|e values|
|00001a80| 2e 0d 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.. *****|********|
|00001a90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001aa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ab0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ac0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ad0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ae0| 2a 2a 2a 2a 2a 2a 2a 7d | 0d 0d 46 55 4e 43 54 49 |*******}|..FUNCTI|
|00001af0| 4f 4e 20 43 4c 45 41 52 | 5f 43 4f 4c 55 4d 4e 53 |ON CLEAR|_COLUMNS|
|00001b00| 28 29 0d 09 46 4f 52 20 | 6c 6f 6f 70 20 3d 20 31 |()..FOR |loop = 1|
|00001b10| 20 54 4f 20 6c 61 73 74 | 5f 52 54 5f 72 6f 77 09 | TO last|_RT_row.|
|00001b20| 09 09 09 7b 20 52 65 70 | 65 61 74 20 66 6f 72 20 |...{ Rep|eat for |
|00001b30| 65 61 63 68 20 72 6f 77 | 20 7d 0d 09 09 50 55 54 |each row| }...PUT|
|00001b40| 20 30 20 69 6e 74 6f 20 | 52 41 4e 47 45 28 4d 41 | 0 into |RANGE(MA|
|00001b50| 4b 45 43 45 4c 4c 28 34 | 34 3b 6c 6f 6f 70 29 29 |KECELL(4|4;loop))|
|00001b60| 09 7b 20 50 75 74 20 61 | 20 30 20 69 6e 74 6f 20 |.{ Put a| 0 into |
|00001b70| 74 68 65 20 73 65 6c 65 | 63 74 65 64 20 63 65 6c |the sele|cted cel|
|00001b80| 6c 20 7d 0d 09 09 50 55 | 54 20 30 20 69 6e 74 6f |l }...PU|T 0 into|
|00001b90| 20 52 41 4e 47 45 28 4d | 41 4b 45 43 45 4c 4c 28 | RANGE(M|AKECELL(|
|00001ba0| 34 36 3b 6c 6f 6f 70 29 | 29 09 7b 20 50 75 74 20 |46;loop)|).{ Put |
|00001bb0| 61 20 30 20 69 6e 74 6f | 20 74 68 65 20 73 65 6c |a 0 into| the sel|
|00001bc0| 65 63 74 65 64 20 63 65 | 6c 6c 20 7d 0d 09 09 50 |ected ce|ll }...P|
|00001bd0| 55 54 20 30 20 69 6e 74 | 6f 20 52 41 4e 47 45 28 |UT 0 int|o RANGE(|
|00001be0| 4d 41 4b 45 43 45 4c 4c | 28 34 38 3b 6c 6f 6f 70 |MAKECELL|(48;loop|
|00001bf0| 29 29 09 7b 20 50 75 74 | 20 61 20 30 20 69 6e 74 |)).{ Put| a 0 int|
|00001c00| 6f 20 74 68 65 20 73 65 | 6c 65 63 74 65 64 20 63 |o the se|lected c|
|00001c10| 65 6c 6c 20 7d 0d 09 45 | 4e 44 20 46 4f 52 09 09 |ell }..E|ND FOR..|
|00001c20| 09 09 09 09 09 09 7b 20 | 45 6e 64 20 72 65 70 65 |......{ |End repe|
|00001c30| 61 74 65 64 20 73 65 63 | 74 69 6f 6e 20 7d 0d 45 |ated sec|tion }.E|
|00001c40| 4e 44 20 46 55 4e 43 54 | 49 4f 4e 0d 0d 7b 2a 2a |ND FUNCT|ION..{**|
|00001c50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c70| 2a 2a 2a 20 43 41 4c 43 | 5f 44 55 52 41 54 49 4f |*** CALC|_DURATIO|
|00001c80| 4e 53 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |NS *****|********|
|00001c90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ca0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001cb0| 2a 2a 2a 0d 20 20 54 68 | 69 73 20 66 75 6e 63 74 |***.  Th|is funct|
|00001cc0| 69 6f 6e 20 67 6f 65 73 | 20 74 68 72 6f 75 67 68 |ion goes| through|
|00001cd0| 20 74 68 65 20 63 6f 6c | 75 6d 6e 73 20 69 6e 20 | the col|umns in |
|00001ce0| 74 68 65 20 50 72 6f 6a | 65 63 74 20 54 61 62 6c |the Proj|ect Tabl|
|00001cf0| 65 20 74 68 61 74 20 63 | 6f 6e 74 61 69 6e 20 72 |e that c|ontain r|
|00001d00| 65 73 6f 75 72 63 65 20 | 6e 61 6d 65 73 2e 20 20 |esource |names.  |
|00001d10| 49 74 20 67 6f 65 73 0d | 20 20 74 68 72 6f 75 67 |It goes.|  throug|
|00001d20| 68 20 61 6c 6c 20 74 68 | 65 20 72 65 73 6f 75 72 |h all th|e resour|
|00001d30| 63 65 73 20 69 6e 20 6f | 75 72 20 6e 65 77 20 74 |ces in o|ur new t|
|00001d40| 61 62 6c 65 20 75 6e 74 | 69 6c 20 69 66 20 66 69 |able unt|il if fi|
|00001d50| 6e 64 73 20 61 20 6e 6f | 6e 2d 62 6c 61 6e 6b 20 |nds a no|n-blank |
|00001d60| 66 69 65 6c 64 2e 20 20 | 57 68 65 6e 20 61 20 66 |field.  |When a f|
|00001d70| 69 65 6c 64 20 69 73 0d | 20 20 66 6f 75 6e 64 20 |ield is.|  found |
|00001d80| 74 68 61 74 20 63 6f 6e | 74 61 69 6e 73 20 61 20 |that con|tains a |
|00001d90| 72 65 73 6f 75 72 63 65 | 20 6e 61 6d 65 2c 20 74 |resource| name, t|
|00001da0| 68 65 20 66 75 6e 63 74 | 69 6f 6e 20 41 44 44 5f |he funct|ion ADD_|
|00001db0| 54 4f 5f 54 41 42 4c 45 | 20 69 73 20 63 61 6c 6c |TO_TABLE| is call|
|00001dc0| 65 64 2e 0d 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ed.. ***|********|
|00001dd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001de0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001df0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001e20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 46 55 4e 43 |********|*}..FUNC|
|00001e30| 54 49 4f 4e 20 43 41 4c | 43 5f 44 55 52 41 54 49 |TION CAL|C_DURATI|
|00001e40| 4f 4e 53 28 29 0d 09 46 | 4f 52 20 63 75 72 5f 63 |ONS()..F|OR cur_c|
|00001e50| 6f 6c 20 3d 20 33 20 74 | 6f 20 34 32 20 53 54 45 |ol = 3 t|o 42 STE|
|00001e60| 50 20 35 09 09 09 09 7b | 20 52 65 70 65 61 74 20 |P 5....{| Repeat |
|00001e70| 66 6f 72 20 65 61 63 68 | 20 6f 66 20 74 68 65 20 |for each| of the |
|00001e80| 38 20 52 65 73 6f 75 72 | 63 65 20 63 6f 6c 75 6d |8 Resour|ce colum|
|00001e90| 6e 73 20 7d 0d 09 09 46 | 4f 52 20 63 75 72 5f 72 |ns }...F|OR cur_r|
|00001ea0| 6f 77 20 3d 20 31 20 74 | 6f 20 6c 61 73 74 5f 50 |ow = 1 t|o last_P|
|00001eb0| 54 5f 72 6f 77 09 09 7b | 20 52 65 70 65 61 74 20 |T_row..{| Repeat |
|00001ec0| 66 6f 72 20 65 61 63 68 | 20 72 6f 77 20 6f 66 20 |for each| row of |
|00001ed0| 74 68 65 20 50 72 6f 6a | 65 63 74 20 54 61 62 6c |the Proj|ect Tabl|
|00001ee0| 65 20 7d 0d 09 09 09 63 | 75 72 72 65 6e 74 5f 63 |e }....c|urrent_c|
|00001ef0| 65 6c 6c 20 3d 20 4d 41 | 4b 45 43 45 4c 4c 28 63 |ell = MA|KECELL(c|
|00001f00| 75 72 5f 63 6f 6c 3b 63 | 75 72 5f 72 6f 77 29 20 |ur_col;c|ur_row) |
|00001f10| 7b 20 44 65 66 69 6e 65 | 20 63 75 72 72 65 6e 74 |{ Define| current|
|00001f20| 20 63 65 6c 6c 20 7d 0d | 09 09 09 49 46 20 20 4e | cell }.|...IF  N|
|00001f30| 4f 54 20 49 53 42 4c 41 | 4e 4b 28 52 41 4e 47 45 |OT ISBLA|NK(RANGE|
|00001f40| 28 63 75 72 72 65 6e 74 | 5f 63 65 6c 6c 29 29 20 |(current|_cell)) |
|00001f50| 7b 20 49 66 20 74 68 65 | 20 63 75 72 72 65 6e 74 |{ If the| current|
|00001f60| 20 63 65 6c 6c 20 69 73 | 20 6e 6f 74 20 62 6c 61 | cell is| not bla|
|00001f70| 6e 6b 2e 2e 2e 7d 0d 09 | 09 09 09 46 4f 52 20 6c |nk...}..|...FOR l|
|00001f80| 6f 6f 70 20 3d 20 31 20 | 74 6f 20 6c 61 73 74 5f |oop = 1 |to last_|
|00001f90| 52 54 5f 52 6f 77 2b 31 | 09 7b 20 52 65 70 65 61 |RT_Row+1|.{ Repea|
|00001fa0| 74 20 66 6f 72 20 65 61 | 63 68 20 72 6f 77 20 69 |t for ea|ch row i|
|00001fb0| 6e 20 6f 75 72 20 6e 65 | 77 20 74 61 62 6c 65 20 |n our ne|w table |
|00001fc0| 7d 0d 09 09 09 09 09 43 | 41 4c 4c 20 41 44 44 5f |}......C|ALL ADD_|
|00001fd0| 54 4f 5f 54 41 42 4c 45 | 28 29 09 09 7b 20 43 61 |TO_TABLE|()..{ Ca|
|00001fe0| 6c 6c 20 66 75 6e 63 74 | 69 6f 6e 20 41 44 44 5f |ll funct|ion ADD_|
|00001ff0| 54 4f 5f 54 41 42 4c 45 | 20 7d 0d 09 09 09 09 45 |TO_TABLE| }.....E|
|00002000| 4e 44 20 46 4f 52 09 09 | 09 09 09 7b 20 45 6e 64 |ND FOR..|...{ End|
|00002010| 20 46 6f 72 20 6c 6f 6f | 70 20 7d 0d 09 09 09 45 | For loo|p }....E|
|00002020| 4e 44 20 49 46 09 09 09 | 09 09 09 7b 20 45 6e 64 |ND IF...|...{ End|
|00002030| 20 6c 6f 67 69 63 61 6c | 20 49 46 20 7d 0d 09 09 | logical| IF }...|
|00002040| 45 4e 44 20 46 4f 52 09 | 09 09 09 09 09 09 7b 20 |END FOR.|......{ |
|00002050| 45 6e 64 20 46 6f 72 20 | 6c 6f 6f 70 20 7d 0d 09 |End For |loop }..|
|00002060| 45 4e 44 20 46 4f 52 09 | 09 09 09 09 09 09 09 7b |END FOR.|.......{|
|00002070| 20 45 6e 64 20 46 6f 72 | 20 6c 6f 6f 70 20 7d 0d | End For| loop }.|
|00002080| 45 4e 44 20 46 55 4e 43 | 54 49 4f 4e 0d 0d 7b 2a |END FUNC|TION..{*|
|00002090| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020b0| 2a 2a 2a 2a 20 41 44 44 | 5f 54 4f 5f 54 41 42 4c |**** ADD|_TO_TABL|
|000020c0| 45 28 29 20 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |E() ****|********|
|000020d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020f0| 2a 2a 2a 2a 0d 20 20 54 | 68 69 73 20 66 75 6e 63 |****.  T|his func|
|00002100| 74 69 6f 6e 20 64 65 74 | 65 72 6d 69 6e 65 73 20 |tion det|ermines |
|00002110| 69 66 20 74 68 65 20 74 | 77 6f 20 72 65 73 6f 75 |if the t|wo resou|
|00002120| 72 63 65 20 6e 61 6d 65 | 73 20 6d 61 74 63 68 2e |rce name|s match.|
|00002130| 20 20 49 66 20 74 68 65 | 79 20 64 6f 2c 20 69 74 |  If the|y do, it|
|00002140| 20 69 6e 63 72 65 6d 65 | 6e 74 73 20 74 68 65 20 | increme|nts the |
|00002150| 64 75 72 61 74 69 6f 6e | 2c 0d 20 20 61 63 74 75 |duration|,.  actu|
|00002160| 61 6c 20 64 75 72 61 74 | 69 6f 6e 20 61 6e 64 20 |al durat|ion and |
|00002170| 6e 75 6d 62 65 72 20 6f | 66 20 74 61 73 6b 73 20 |number o|f tasks |
|00002180| 69 6e 20 74 68 65 20 74 | 61 62 6c 65 20 62 79 20 |in the t|able by |
|00002190| 74 68 65 20 61 6d 6f 75 | 6e 74 20 69 6e 20 74 68 |the amou|nt in th|
|000021a0| 65 20 50 72 6f 6a 65 63 | 74 20 54 61 62 6c 65 2e |e Projec|t Table.|
|000021b0| 0d 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |. ******|********|
|000021c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000021f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002200| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002210| 2a 2a 2a 2a 2a 2a 7d 0d | 0d 46 55 4e 43 54 49 4f |******}.|.FUNCTIO|
|00002220| 4e 20 41 44 44 5f 54 4f | 5f 54 41 42 4c 45 28 29 |N ADD_TO|_TABLE()|
|00002230| 0d 09 44 45 46 49 4e 45 | 20 64 75 72 61 74 69 6f |..DEFINE| duratio|
|00002240| 6e 09 09 7b 20 54 65 6d | 70 6f 72 61 72 79 20 64 |n..{ Tem|porary d|
|00002250| 75 72 61 74 69 6f 6e 20 | 7d 0d 09 44 45 46 49 4e |uration |}..DEFIN|
|00002260| 45 20 6e 75 6d 5f 74 61 | 73 6b 73 09 09 7b 20 54 |E num_ta|sks..{ T|
|00002270| 65 6d 70 6f 72 61 72 79 | 20 6e 75 6d 62 65 72 20 |emporary| number |
|00002280| 6f 66 20 74 61 73 6b 73 | 20 7d 0d 09 44 45 46 49 |of tasks| }..DEFI|
|00002290| 4e 45 20 61 63 74 5f 64 | 75 72 61 74 69 6f 6e 09 |NE act_d|uration.|
|000022a0| 09 7b 20 54 65 6d 70 6f | 72 61 72 79 20 61 63 74 |.{ Tempo|rary act|
|000022b0| 75 61 6c 20 64 75 72 61 | 74 69 6f 6e 20 7d 0d 0d |ual dura|tion }..|
|000022c0| 09 49 46 20 49 4e 44 49 | 52 45 43 54 28 63 75 72 |.IF INDI|RECT(cur|
|000022d0| 72 65 6e 74 5f 63 65 6c | 6c 29 20 3d 20 49 4e 44 |rent_cel|l) = IND|
|000022e0| 49 52 45 43 54 28 4d 41 | 4b 45 43 45 4c 4c 28 34 |IRECT(MA|KECELL(4|
|000022f0| 33 3b 6c 6f 6f 70 29 29 | 20 20 7b 20 44 6f 65 73 |3;loop))|  { Does|
|00002300| 20 63 75 72 72 65 6e 74 | 20 63 65 6c 6c 20 6d 61 | current| cell ma|
|00002310| 74 63 68 20 74 61 62 6c | 65 20 65 6e 74 72 79 3f |tch tabl|e entry?|
|00002320| 20 7d 0d 09 09 64 75 72 | 61 74 69 6f 6e 20 3d 20 | }...dur|ation = |
|00002330| 49 4e 44 49 52 45 43 54 | 28 4d 41 4b 45 43 45 4c |INDIRECT|(MAKECEL|
|00002340| 4c 28 63 75 72 5f 63 6f | 6c 2b 31 3b 63 75 72 5f |L(cur_co|l+1;cur_|
|00002350| 72 6f 77 29 29 20 09 20 | 20 7b 20 47 65 74 20 62 |row)) . | { Get b|
|00002360| 6f 74 68 20 76 61 6c 75 | 65 73 20 61 6e 64 20 61 |oth valu|es and a|
|00002370| 64 64 20 74 68 65 6d 20 | 7d 0d 09 09 09 2b 20 49 |dd them |}....+ I|
|00002380| 4e 44 49 52 45 43 54 28 | 4d 41 4b 45 43 45 4c 4c |NDIRECT(|MAKECELL|
|00002390| 28 34 36 3b 6c 6f 6f 70 | 29 29 0d 09 09 6e 75 6d |(46;loop|))...num|
|000023a0| 5f 74 61 73 6b 73 20 3d | 20 49 4e 44 49 52 45 43 |_tasks =| INDIREC|
|000023b0| 54 28 4d 41 4b 45 43 45 | 4c 4c 28 34 34 3b 6c 6f |T(MAKECE|LL(44;lo|
|000023c0| 6f 70 29 29 20 2b 20 31 | 09 09 20 20 7b 20 41 64 |op)) + 1|..  { Ad|
|000023d0| 64 20 31 20 74 6f 20 74 | 68 65 20 6e 75 6d 62 65 |d 1 to t|he numbe|
|000023e0| 72 20 6f 66 20 74 61 73 | 6b 73 20 7d 0d 09 09 61 |r of tas|ks }...a|
|000023f0| 63 74 5f 64 75 72 61 74 | 69 6f 6e 20 3d 20 49 4e |ct_durat|ion = IN|
|00002400| 44 49 52 45 43 54 28 4d | 41 4b 45 43 45 4c 4c 28 |DIRECT(M|AKECELL(|
|00002410| 34 38 3b 6c 6f 6f 70 29 | 29 20 09 09 20 20 7b 20 |48;loop)|) ..  { |
|00002420| 4d 75 6c 74 69 70 6c 69 | 65 73 20 74 68 65 20 25 |Multipli|es the %|
|00002430| 20 64 6f 6e 65 20 66 6f | 72 20 74 68 65 20 74 61 | done fo|r the ta|
|00002440| 73 6b 2e 2e 2e 20 7d 0d | 09 09 09 2b 20 28 28 49 |sk... }.|...+ ((I|
|00002450| 4e 44 49 52 45 43 54 28 | 4d 41 4b 45 43 45 4c 4c |NDIRECT(|MAKECELL|
|00002460| 28 32 3b 63 75 72 5f 72 | 6f 77 29 29 20 2f 20 31 |(2;cur_r|ow)) / 1|
|00002470| 30 30 29 20 09 20 20 7b | 20 2e 2e 2e 62 79 20 74 |00) .  {| ...by t|
|00002480| 68 65 20 64 75 72 61 74 | 69 6f 6e 20 74 6f 20 63 |he durat|ion to c|
|00002490| 61 6c 63 75 6c 61 74 65 | 20 74 68 65 2e 2e 2e 20 |alculate| the... |
|000024a0| 7d 0d 09 09 09 2a 20 49 | 4e 44 49 52 45 43 54 28 |}....* I|NDIRECT(|
|000024b0| 4d 41 4b 45 43 45 4c 4c | 28 63 75 72 5f 63 6f 6c |MAKECELL|(cur_col|
|000024c0| 2b 31 3b 63 75 72 5f 72 | 6f 77 29 29 29 09 20 20 |+1;cur_r|ow))).  |
|000024d0| 7b 20 2e 2e 2e 61 63 74 | 75 61 6c 20 64 75 72 61 |{ ...act|ual dura|
|000024e0| 74 69 6f 6e 20 66 6f 72 | 20 74 68 65 20 72 65 73 |tion for| the res|
|000024f0| 6f 75 72 63 65 20 7d 0d | 09 09 50 55 54 20 64 75 |ource }.|..PUT du|
|00002500| 72 61 74 69 6f 6e 20 49 | 4e 54 4f 20 4d 41 4b 45 |ration I|NTO MAKE|
|00002510| 43 45 4c 4c 28 34 36 3b | 6c 6f 6f 70 29 09 09 09 |CELL(46;|loop)...|
|00002520| 20 20 7b 20 50 75 74 20 | 74 68 65 20 6e 65 77 20 |  { Put |the new |
|00002530| 64 75 72 61 74 69 6f 6e | 20 69 6e 74 6f 20 74 68 |duration| into th|
|00002540| 65 20 74 61 62 6c 65 20 | 7d 0d 09 09 50 55 54 20 |e table |}...PUT |
|00002550| 6e 75 6d 5f 74 61 73 6b | 73 20 49 4e 54 4f 20 4d |num_task|s INTO M|
|00002560| 41 4b 45 43 45 4c 4c 28 | 34 34 3b 6c 6f 6f 70 29 |AKECELL(|44;loop)|
|00002570| 09 09 09 20 20 7b 20 50 | 75 74 20 74 68 65 20 6e |...  { P|ut the n|
|00002580| 65 77 20 6e 75 6d 62 65 | 72 20 6f 66 20 74 61 73 |ew numbe|r of tas|
|00002590| 6b 73 20 69 6e 74 6f 20 | 74 68 65 20 74 61 62 6c |ks into |the tabl|
|000025a0| 65 20 7d 09 09 09 0d 09 | 09 50 55 54 20 61 63 74 |e }.....|.PUT act|
|000025b0| 5f 64 75 72 61 74 69 6f | 6e 20 49 4e 54 4f 20 4d |_duratio|n INTO M|
|000025c0| 41 4b 45 43 45 4c 4c 28 | 34 38 3b 6c 6f 6f 70 29 |AKECELL(|48;loop)|
|000025d0| 09 09 09 20 20 7b 20 50 | 75 74 20 74 68 65 20 6e |...  { P|ut the n|
|000025e0| 65 77 20 61 63 74 75 61 | 6c 20 64 75 72 61 74 69 |ew actua|l durati|
|000025f0| 6f 6e 20 69 6e 74 6f 20 | 74 68 65 20 74 61 62 6c |on into |the tabl|
|00002600| 65 20 7d 0d 09 45 4e 44 | 20 49 46 09 09 09 09 09 |e }..END| IF.....|
|00002610| 09 09 09 09 09 20 20 7b | 20 45 6e 64 20 6c 6f 67 |.....  {| End log|
|00002620| 69 63 61 6c 20 49 46 20 | 7d 0d 45 4e 44 20 46 55 |ical IF |}.END FU|
|00002630| 4e 43 54 49 4f 4e 0d 0d | 7b 2a 2a 2a 2a 2a 2a 2a |NCTION..|{*******|
|00002640| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002650| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 43 |********|****** C|
|00002660| 52 45 41 54 45 5f 46 4f | 52 4d 55 4c 41 53 20 2a |REATE_FO|RMULAS *|
|00002670| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002680| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002690| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 20 |********|******. |
|000026a0| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 70 | This fu|nction p|
|000026b0| 75 74 73 20 61 20 66 6f | 72 6d 75 6c 61 20 69 6e |uts a fo|rmula in|
|000026c0| 74 6f 20 74 68 65 20 54 | 6f 74 61 6c 20 63 6f 6c |to the T|otal col|
|000026d0| 75 6d 6e 20 6f 66 20 6f | 75 72 20 6e 65 77 20 74 |umn of o|ur new t|
|000026e0| 61 62 6c 65 20 74 68 61 | 74 20 63 6f 6d 70 75 74 |able tha|t comput|
|000026f0| 65 73 20 74 68 65 20 74 | 6f 74 61 6c 20 63 6f 73 |es the t|otal cos|
|00002700| 74 20 66 6f 72 0d 20 20 | 65 61 63 68 20 72 65 73 |t for.  |each res|
|00002710| 6f 75 72 63 65 2e 0d 20 | 2a 2a 2a 2a 2a 2a 2a 2a |ource.. |********|
|00002720| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002730| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002740| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002750| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002760| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002770| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 46 |********|****}..F|
|00002780| 55 4e 43 54 49 4f 4e 20 | 43 52 45 41 54 45 5f 46 |UNCTION |CREATE_F|
|00002790| 4f 52 4d 55 4c 41 53 28 | 29 0d 09 46 4f 52 20 6c |ORMULAS(|)..FOR l|
|000027a0| 6f 6f 70 20 3d 20 31 20 | 54 4f 20 6c 61 73 74 5f |oop = 1 |TO last_|
|000027b0| 52 54 5f 72 6f 77 09 09 | 09 09 09 7b 20 52 65 70 |RT_row..|...{ Rep|
|000027c0| 65 61 74 20 66 6f 72 20 | 65 61 63 68 20 72 6f 77 |eat for |each row|
|000027d0| 20 69 6e 20 74 68 65 20 | 74 61 62 6c 65 20 7d 0d | in the |table }.|
|000027e0| 09 09 50 55 54 20 22 3d | 22 26 4d 41 4b 45 43 45 |..PUT "=|"&MAKECE|
|000027f0| 4c 4c 28 34 36 3b 6c 6f | 6f 70 29 26 22 2a 22 09 |LL(46;lo|op)&"*".|
|00002800| 09 09 09 7b 20 43 61 6c | 63 75 6c 61 74 65 20 74 |...{ Cal|culate t|
|00002810| 68 65 20 63 6f 72 72 65 | 63 74 20 66 6f 72 6d 75 |he corre|ct formu|
|00002820| 6c 61 20 62 79 20 70 6f | 73 69 74 69 6f 6e 20 7d |la by po|sition }|
|00002830| 0d 09 09 09 26 4d 41 4b | 45 43 45 4c 4c 28 34 35 |....&MAK|ECELL(45|
|00002840| 3b 6c 6f 6f 70 29 20 69 | 6e 74 6f 20 52 41 4e 47 |;loop) i|nto RANG|
|00002850| 45 28 4d 41 4b 45 43 45 | 4c 4c 28 34 37 3b 6c 6f |E(MAKECE|LL(47;lo|
|00002860| 6f 70 29 29 20 20 7b 20 | 61 6e 64 20 70 75 74 20 |op))  { |and put |
|00002870| 69 74 20 69 6e 74 6f 20 | 74 68 65 20 63 75 72 72 |it into |the curr|
|00002880| 65 6e 74 20 63 65 6c 6c | 20 7d 20 0d 09 09 50 55 |ent cell| } ...PU|
|00002890| 54 20 22 3d 22 26 4d 41 | 4b 45 43 45 4c 4c 28 34 |T "="&MA|KECELL(4|
|000028a0| 38 3b 6c 6f 6f 70 29 26 | 22 2a 22 09 09 09 09 7b |8;loop)&|"*"....{|
|000028b0| 20 43 61 6c 63 75 6c 61 | 74 65 20 74 68 65 20 63 | Calcula|te the c|
|000028c0| 6f 72 72 65 63 74 20 66 | 6f 72 6d 75 6c 61 20 62 |orrect f|ormula b|
|000028d0| 79 20 70 6f 73 69 74 69 | 6f 6e 20 7d 0d 09 09 09 |y positi|on }....|
|000028e0| 26 4d 41 4b 45 43 45 4c | 4c 28 34 35 3b 6c 6f 6f |&MAKECEL|L(45;loo|
|000028f0| 70 29 20 69 6e 74 6f 20 | 52 41 4e 47 45 28 4d 41 |p) into |RANGE(MA|
|00002900| 4b 45 43 45 4c 4c 28 34 | 39 3b 6c 6f 6f 70 29 29 |KECELL(4|9;loop))|
|00002910| 20 20 7b 20 61 6e 64 20 | 70 75 74 20 69 74 20 69 |  { and |put it i|
|00002920| 6e 74 6f 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 |nto the |current |
|00002930| 63 65 6c 6c 20 7d 20 0d | 09 45 4e 44 20 46 4f 52 |cell } .|.END FOR|
|00002940| 09 09 09 09 09 09 09 09 | 09 7b 20 45 6e 64 20 46 |........|.{ End F|
|00002950| 6f 72 20 6c 6f 6f 70 20 | 7d 0d 45 4e 44 20 46 55 |or loop |}.END FU|
|00002960| 4e 43 54 49 4f 4e 0d 0d | 7b 2a 2a 2a 2a 2a 2a 2a |NCTION..|{*******|
|00002970| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002980| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 43 |********|****** C|
|00002990| 52 45 41 54 45 5f 54 41 | 42 4c 45 20 2a 2a 2a 2a |REATE_TA|BLE ****|
|000029a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000029b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000029c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 20 |********|******. |
|000029d0| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 63 | This fu|nction c|
|000029e0| 72 65 61 74 65 73 20 61 | 20 6e 65 77 20 74 61 62 |reates a| new tab|
|000029f0| 6c 65 20 6f 6e 20 61 20 | 6e 65 77 20 77 6f 72 6b |le on a |new work|
|00002a00| 73 68 65 65 74 2e 20 20 | 54 68 69 73 20 74 61 62 |sheet.  |This tab|
|00002a10| 6c 65 20 77 69 6c 6c 20 | 63 6f 6e 74 61 69 6e 20 |le will |contain |
|00002a20| 74 68 65 20 63 6f 73 74 | 20 69 6e 66 6f 72 6d 61 |the cost| informa|
|00002a30| 74 69 6f 6e 0d 20 20 63 | 6f 70 69 65 64 20 66 72 |tion.  c|opied fr|
|00002a40| 6f 6d 20 74 68 65 20 50 | 72 6f 6a 65 63 74 20 54 |om the P|roject T|
|00002a50| 61 62 6c 65 2e 20 20 49 | 74 20 77 69 6c 6c 20 74 |able.  I|t will t|
|00002a60| 68 65 6e 20 62 65 20 75 | 73 65 64 20 69 6e 20 74 |hen be u|sed in t|
|00002a70| 68 65 20 63 72 65 61 74 | 69 6f 6e 20 6f 66 20 74 |he creat|ion of t|
|00002a80| 68 65 20 52 65 73 6f 75 | 72 63 65 20 57 6f 72 6b |he Resou|rce Work|
|00002a90| 20 54 61 62 6c 65 2e 0d | 20 2a 2a 2a 2a 2a 2a 2a | Table..| *******|
|00002aa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ab0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ac0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ad0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ae0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002af0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 7d 0d 0d |********|*****}..|
|00002b00| 46 55 4e 43 54 49 4f 4e | 20 43 52 45 41 54 45 5f |FUNCTION| CREATE_|
|00002b10| 54 41 42 4c 45 28 29 0d | 09 53 45 4c 45 43 54 20 |TABLE().|.SELECT |
|00002b20| 52 41 4e 47 45 28 4d 41 | 4b 45 52 41 4e 47 45 28 |RANGE(MA|KERANGE(|
|00002b30| 34 33 3b 31 3b 34 39 3b | 6c 61 73 74 5f 52 54 5f |43;1;49;|last_RT_|
|00002b40| 72 6f 77 29 29 09 7b 20 | 53 65 6c 65 63 74 20 74 |row)).{ |Select t|
|00002b50| 61 62 75 6c 61 74 65 64 | 20 64 61 74 61 20 66 72 |abulated| data fr|
|00002b60| 6f 6d 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |om Proje|ct Table|
|00002b70| 20 7d 0d 09 43 4f 50 59 | 09 09 09 09 09 09 09 09 | }..COPY|........|
|00002b80| 09 7b 20 43 6f 70 79 20 | 74 68 69 73 20 69 6e 66 |.{ Copy |this inf|
|00002b90| 6f 72 6d 61 74 69 6f 6e | 20 74 6f 20 74 68 65 20 |ormation| to the |
|00002ba0| 63 6c 69 70 62 6f 61 72 | 64 20 7d 0d 09 43 4c 4f |clipboar|d }..CLO|
|00002bb0| 53 45 20 4e 4f 57 09 09 | 09 09 09 09 09 09 7b 20 |SE NOW..|......{ |
|00002bc0| 43 6c 6f 73 65 20 74 68 | 65 20 50 72 6f 6a 65 63 |Close th|e Projec|
|00002bd0| 74 20 54 61 62 6c 65 20 | 7d 0d 09 4e 45 57 20 57 |t Table |}..NEW W|
|00002be0| 4f 52 4b 53 48 45 45 54 | 20 22 22 09 09 09 09 09 |ORKSHEET| "".....|
|00002bf0| 09 7b 20 4f 70 65 6e 20 | 61 20 6e 65 77 20 77 6f |.{ Open |a new wo|
|00002c00| 72 6b 73 68 65 65 74 20 | 7d 0d 09 5a 4f 4f 4d 20 |rksheet |}..ZOOM |
|00002c10| 57 49 4e 44 4f 57 09 09 | 09 09 09 09 09 7b 20 5a |WINDOW..|.....{ Z|
|00002c20| 6f 6f 6d 20 77 69 6e 64 | 6f 77 20 74 6f 20 66 69 |oom wind|ow to fi|
|00002c30| 6c 6c 20 74 68 65 20 73 | 63 72 65 65 6e 20 7d 0d |ll the s|creen }.|
|00002c40| 09 48 49 44 45 20 43 45 | 4c 4c 20 47 52 49 44 09 |.HIDE CE|LL GRID.|
|00002c50| 09 09 09 09 09 09 7b 20 | 48 69 64 65 20 74 68 65 |......{ |Hide the|
|00002c60| 20 63 65 6c 6c 20 67 72 | 69 64 20 7d 0d 09 48 49 | cell gr|id }..HI|
|00002c70| 44 45 20 48 45 41 44 49 | 4e 47 53 09 09 09 09 09 |DE HEADI|NGS.....|
|00002c80| 09 09 7b 20 48 69 64 65 | 20 72 6f 77 20 61 6e 64 |..{ Hide| row and|
|00002c90| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 73 | column |headings|
|00002ca0| 20 7d 0d 09 48 49 44 45 | 20 45 4e 54 52 59 20 42 | }..HIDE| ENTRY B|
|00002cb0| 41 52 09 09 09 09 09 09 | 09 7b 20 48 69 64 65 20 |AR......|.{ Hide |
|00002cc0| 74 68 65 20 64 61 74 61 | 20 65 6e 74 72 79 20 62 |the data| entry b|
|00002cd0| 61 72 20 61 74 20 74 6f | 70 20 6f 66 20 74 68 65 |ar at to|p of the|
|00002ce0| 20 77 69 6e 64 6f 77 20 | 7d 0d 09 48 49 44 45 20 | window |}..HIDE |
|00002cf0| 54 4f 4f 4c 20 42 4f 58 | 09 09 09 09 09 09 09 7b |TOOL BOX|.......{|
|00002d00| 20 48 69 64 65 20 74 68 | 65 20 74 6f 6f 6c 20 62 | Hide th|e tool b|
|00002d10| 6f 78 20 61 74 20 74 68 | 65 20 6c 65 66 74 20 6f |ox at th|e left o|
|00002d20| 66 20 74 68 65 20 77 69 | 6e 64 6f 77 20 7d 0d 09 |f the wi|ndow }..|
|00002d30| 53 45 4c 45 43 54 20 52 | 41 4e 47 45 28 22 42 35 |SELECT R|ANGE("B5|
|00002d40| 22 29 09 09 09 09 09 09 | 7b 20 53 65 6c 65 63 74 |")......|{ Select|
|00002d50| 20 69 6e 73 65 72 74 69 | 6f 6e 20 70 6f 69 6e 74 | inserti|on point|
|00002d60| 20 66 6f 72 20 74 68 65 | 20 64 61 74 61 20 7d 0d | for the| data }.|
|00002d70| 09 50 41 53 54 45 09 09 | 09 09 09 09 09 09 7b 20 |.PASTE..|......{ |
|00002d80| 50 61 73 74 65 20 74 68 | 65 20 64 61 74 61 20 66 |Paste th|e data f|
|00002d90| 72 6f 6d 20 74 68 65 20 | 63 6c 69 70 62 6f 61 72 |rom the |clipboar|
|00002da0| 64 20 6f 6e 74 6f 20 77 | 6f 72 6b 73 68 65 65 74 |d onto w|orksheet|
|00002db0| 20 7d 0d 09 50 55 54 20 | 22 52 65 73 6f 75 72 63 | }..PUT |"Resourc|
|00002dc0| 65 20 57 6f 72 6b 20 54 | 61 62 6c 65 20 2d 20 22 |e Work T|able - "|
|00002dd0| 20 09 09 09 09 7b 20 50 | 6c 61 63 65 20 74 69 74 | ....{ P|lace tit|
|00002de0| 6c 65 2e 2e 2e 20 7d 0d | 09 09 26 41 44 41 54 45 |le... }.|..&ADATE|
|00002df0| 28 4e 4f 57 28 29 3b 22 | 6d 6d 2f 64 64 2f 79 79 |(NOW();"|mm/dd/yy|
|00002e00| 22 29 20 49 4e 54 4f 20 | 42 32 09 09 7b 20 2e 2e |") INTO |B2..{ ..|
|00002e10| 2e 61 6e 64 20 64 61 74 | 65 20 69 6e 74 6f 20 63 |.and dat|e into c|
|00002e20| 65 6c 6c 20 42 32 20 7d | 0d 09 50 55 54 20 22 52 |ell B2 }|..PUT "R|
|00002e30| 45 53 4f 55 52 43 45 22 | 20 49 4e 54 4f 20 42 33 |ESOURCE"| INTO B3|
|00002e40| 20 09 09 09 09 09 7b 20 | 50 6c 61 63 65 20 68 65 | .....{ |Place he|
|00002e50| 61 64 69 6e 67 20 69 6e | 74 6f 20 63 65 6c 6c 20 |ading in|to cell |
|00002e60| 42 33 20 7d 0d 09 50 55 | 54 20 22 4e 41 4d 45 22 |B3 }..PU|T "NAME"|
|00002e70| 20 49 4e 54 4f 20 42 34 | 09 09 09 09 09 09 7b 20 | INTO B4|......{ |
|00002e80| 50 6c 61 63 65 20 68 65 | 61 64 69 6e 67 20 69 6e |Place he|ading in|
|00002e90| 74 6f 20 63 65 6c 6c 20 | 42 34 20 7d 0d 09 50 55 |to cell |B4 }..PU|
|00002ea0| 54 20 22 4e 55 4d 42 45 | 52 22 20 49 4e 54 4f 20 |T "NUMBE|R" INTO |
|00002eb0| 43 33 09 09 09 09 09 7b | 20 50 6c 61 63 65 20 68 |C3.....{| Place h|
|00002ec0| 65 61 64 69 6e 67 20 69 | 6e 74 6f 20 63 65 6c 6c |eading i|nto cell|
|00002ed0| 20 43 33 20 7d 0d 09 50 | 55 54 20 22 4f 46 20 54 | C3 }..P|UT "OF T|
|00002ee0| 41 53 4b 53 22 20 49 4e | 54 4f 20 43 34 09 09 09 |ASKS" IN|TO C4...|
|00002ef0| 09 09 7b 20 50 6c 61 63 | 65 20 68 65 61 64 69 6e |..{ Plac|e headin|
|00002f00| 67 20 69 6e 74 6f 20 63 | 65 6c 6c 20 43 34 20 7d |g into c|ell C4 }|
|00002f10| 0d 09 50 55 54 20 22 55 | 4e 49 54 22 20 49 4e 54 |..PUT "U|NIT" INT|
|00002f20| 4f 20 44 33 20 09 09 09 | 09 09 09 7b 20 50 6c 61 |O D3 ...|...{ Pla|
|00002f30| 63 65 20 68 65 61 64 69 | 6e 67 20 69 6e 74 6f 20 |ce headi|ng into |
|00002f40| 63 65 6c 6c 20 44 33 20 | 7d 0d 09 50 55 54 20 22 |cell D3 |}..PUT "|
|00002f50| 43 4f 53 54 22 20 49 4e | 54 4f 20 44 34 09 09 09 |COST" IN|TO D4...|
|00002f60| 09 09 09 7b 20 50 6c 61 | 63 65 20 68 65 61 64 69 |...{ Pla|ce headi|
|00002f70| 6e 67 20 69 6e 74 6f 20 | 63 65 6c 6c 20 44 34 20 |ng into |cell D4 |
|00002f80| 7d 0d 09 50 55 54 20 22 | 50 4c 41 4e 4e 45 44 22 |}..PUT "|PLANNED"|
|00002f90| 20 49 4e 54 4f 20 45 33 | 20 09 09 09 09 09 7b 20 | INTO E3| .....{ |
|00002fa0| 50 6c 61 63 65 20 68 65 | 61 64 69 6e 67 20 69 6e |Place he|ading in|
|00002fb0| 74 6f 20 63 65 6c 6c 20 | 45 33 20 7d 0d 09 50 55 |to cell |E3 }..PU|
|00002fc0| 54 20 22 44 55 52 41 54 | 49 4f 4e 22 20 49 4e 54 |T "DURAT|ION" INT|
|00002fd0| 4f 20 45 34 09 09 09 09 | 09 7b 20 50 6c 61 63 65 |O E4....|.{ Place|
|00002fe0| 20 68 65 61 64 69 6e 67 | 20 69 6e 74 6f 20 63 65 | heading| into ce|
|00002ff0| 6c 6c 20 45 34 20 7d 0d | 09 50 55 54 20 22 50 4c |ll E4 }.|.PUT "PL|
|00003000| 41 4e 4e 45 44 22 20 49 | 4e 54 4f 20 46 33 20 09 |ANNED" I|NTO F3 .|
|00003010| 09 09 09 09 7b 20 50 6c | 61 63 65 20 68 65 61 64 |....{ Pl|ace head|
|00003020| 69 6e 67 20 69 6e 74 6f | 20 63 65 6c 6c 20 46 33 |ing into| cell F3|
|00003030| 20 7d 0d 09 50 55 54 20 | 22 43 4f 53 54 22 20 49 | }..PUT |"COST" I|
|00003040| 4e 54 4f 20 46 34 09 09 | 09 09 09 09 7b 20 50 6c |NTO F4..|....{ Pl|
|00003050| 61 63 65 20 68 65 61 64 | 69 6e 67 20 69 6e 74 6f |ace head|ing into|
|00003060| 20 63 65 6c 6c 20 46 34 | 20 7d 0d 09 50 55 54 20 | cell F4| }..PUT |
|00003070| 22 41 43 54 55 41 4c 22 | 20 49 4e 54 4f 20 47 33 |"ACTUAL"| INTO G3|
|00003080| 09 09 09 09 09 7b 20 50 | 6c 61 63 65 20 68 65 61 |.....{ P|lace hea|
|00003090| 64 69 6e 67 20 69 6e 74 | 6f 20 63 65 6c 6c 20 47 |ding int|o cell G|
|000030a0| 33 20 7d 0d 20 09 50 55 | 54 20 22 44 55 52 41 54 |3 }. .PU|T "DURAT|
|000030b0| 49 4f 4e 22 20 49 4e 54 | 4f 20 47 34 09 09 09 09 |ION" INT|O G4....|
|000030c0| 09 7b 20 50 6c 61 63 65 | 20 68 65 61 64 69 6e 67 |.{ Place| heading|
|000030d0| 20 69 6e 74 6f 20 63 65 | 6c 6c 20 47 34 20 7d 0d | into ce|ll G4 }.|
|000030e0| 09 50 55 54 20 22 41 43 | 54 55 41 4c 22 20 49 4e |.PUT "AC|TUAL" IN|
|000030f0| 54 4f 20 48 33 09 09 09 | 09 09 7b 20 50 6c 61 63 |TO H3...|..{ Plac|
|00003100| 65 20 68 65 61 64 69 6e | 67 20 69 6e 74 6f 20 63 |e headin|g into c|
|00003110| 65 6c 6c 20 48 33 20 7d | 0d 09 50 55 54 20 22 43 |ell H3 }|..PUT "C|
|00003120| 4f 53 54 22 20 49 4e 54 | 4f 20 48 34 09 09 09 09 |OST" INT|O H4....|
|00003130| 09 09 7b 20 50 6c 61 63 | 65 20 68 65 61 64 69 6e |..{ Plac|e headin|
|00003140| 67 20 69 6e 74 6f 20 63 | 65 6c 6c 20 48 34 20 7d |g into c|ell H4 }|
|00003150| 0d 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 28 4d |..SELECT| RANGE(M|
|00003160| 41 4b 45 52 41 4e 47 45 | 28 32 3b 33 3b 38 3b 6c |AKERANGE|(2;3;8;l|
|00003170| 61 73 74 5f 52 54 5f 72 | 6f 77 2b 34 29 29 20 7b |ast_RT_r|ow+4)) {|
|00003180| 20 53 65 6c 65 63 74 20 | 65 6e 74 69 72 65 20 74 | Select |entire t|
|00003190| 61 62 6c 65 20 72 61 6e | 67 65 20 7d 0d 09 54 45 |able ran|ge }..TE|
|000031a0| 58 54 20 53 49 5a 45 20 | 31 30 09 09 09 09 09 09 |XT SIZE |10......|
|000031b0| 09 7b 20 53 65 74 20 74 | 65 78 74 20 73 69 7a 65 |.{ Set t|ext size|
|000031c0| 20 74 6f 20 31 30 20 70 | 6f 69 6e 74 73 20 7d 0d | to 10 p|oints }.|
|000031d0| 09 54 45 58 54 20 46 4f | 4e 54 20 22 48 65 6c 76 |.TEXT FO|NT "Helv|
|000031e0| 65 74 69 63 61 22 09 09 | 09 09 09 7b 20 53 65 74 |etica"..|...{ Set|
|000031f0| 20 66 6f 6e 74 20 74 6f | 20 48 65 6c 76 65 74 69 | font to| Helveti|
|00003200| 63 61 20 7d 0d 09 63 65 | 6c 6c 20 62 6f 72 64 65 |ca }..ce|ll borde|
|00003210| 72 20 22 4f 74 6c 62 52 | 22 09 09 09 09 09 09 7b |r "OtlbR|"......{|
|00003220| 20 53 65 74 20 63 65 6c | 6c 20 62 6f 72 64 65 72 | Set cel|l border|
|00003230| 20 74 6f 20 6f 75 74 6c | 69 6e 65 2f 72 69 67 68 | to outl|ine/righ|
|00003240| 74 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |t }..SEL|ECT RANG|
|00003250| 45 20 42 33 2e 2e 48 34 | 09 09 09 09 09 09 7b 20 |E B3..H4|......{ |
|00003260| 53 65 6c 65 63 74 20 74 | 68 65 20 74 69 74 6c 65 |Select t|he title|
|00003270| 20 72 61 6e 67 65 20 7d | 0d 09 54 45 58 54 20 53 | range }|..TEXT S|
|00003280| 54 59 4c 45 20 22 42 22 | 09 09 09 09 09 09 09 7b |TYLE "B"|.......{|
|00003290| 20 53 65 74 20 74 65 78 | 74 20 73 74 79 6c 65 20 | Set tex|t style |
|000032a0| 74 6f 20 42 6f 6c 64 20 | 7d 0d 09 54 45 58 54 20 |to Bold |}..TEXT |
|000032b0| 53 54 59 4c 45 20 22 49 | 22 09 09 09 09 09 09 09 |STYLE "I|".......|
|000032c0| 7b 20 53 65 74 20 74 65 | 78 74 20 73 74 79 6c 65 |{ Set te|xt style|
|000032d0| 20 74 6f 20 49 74 61 6c | 69 63 20 7d 0d 09 41 4c | to Ital|ic }..AL|
|000032e0| 49 47 4e 20 43 45 4e 54 | 45 52 09 09 09 09 09 09 |IGN CENT|ER......|
|000032f0| 09 7b 20 43 65 6e 74 65 | 72 20 74 68 65 20 74 69 |.{ Cente|r the ti|
|00003300| 74 6c 65 73 20 7d 0d 09 | 43 45 4c 4c 20 42 4f 52 |tles }..|CELL BOR|
|00003310| 44 45 52 20 22 4f 74 6c | 62 72 22 09 09 09 09 09 |DER "Otl|br".....|
|00003320| 09 7b 20 53 65 74 20 63 | 65 6c 6c 20 62 6f 72 64 |.{ Set c|ell bord|
|00003330| 65 72 20 74 6f 20 6f 75 | 74 6c 69 6e 65 20 7d 0d |er to ou|tline }.|
|00003340| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 28 4d 41 |.SELECT |RANGE(MA|
|00003350| 4b 45 52 41 4e 47 45 28 | 34 3b 35 3b 34 3b 6c 61 |KERANGE(|4;5;4;la|
|00003360| 73 74 5f 52 54 5f 72 6f | 77 2b 34 29 29 20 7b 20 |st_RT_ro|w+4)) { |
|00003370| 53 65 6c 65 63 74 20 55 | 6e 69 74 20 43 6f 73 74 |Select U|nit Cost|
|00003380| 20 63 6f 6c 75 6d 6e 20 | 7d 0d 09 46 4f 52 4d 41 | column |}..FORMA|
|00003390| 54 20 43 55 52 52 45 4e | 43 59 09 09 09 09 09 09 |T CURREN|CY......|
|000033a0| 7b 20 46 6f 72 6d 61 74 | 20 61 73 20 63 75 72 72 |{ Format| as curr|
|000033b0| 65 6e 63 79 20 7d 0d 09 | 55 53 45 20 43 4f 4d 4d |ency }..|USE COMM|
|000033c0| 41 53 09 09 09 09 09 09 | 09 7b 20 46 6f 72 6d 61 |AS......|.{ Forma|
|000033d0| 74 20 77 69 74 68 20 63 | 6f 6d 6d 61 73 20 7d 0d |t with c|ommas }.|
|000033e0| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 28 4d 41 |.SELECT |RANGE(MA|
|000033f0| 4b 45 52 41 4e 47 45 28 | 36 3b 35 3b 36 3b 6c 61 |KERANGE(|6;5;6;la|
|00003400| 73 74 5f 52 54 5f 72 6f | 77 2b 34 29 29 20 7b 20 |st_RT_ro|w+4)) { |
|00003410| 53 65 6c 65 63 74 20 50 | 6c 61 6e 6e 65 64 20 43 |Select P|lanned C|
|00003420| 6f 73 74 20 63 6f 6c 75 | 6d 6e 20 7d 0d 09 46 4f |ost colu|mn }..FO|
|00003430| 52 4d 41 54 20 43 55 52 | 52 45 4e 43 59 09 09 09 |RMAT CUR|RENCY...|
|00003440| 09 09 09 7b 20 46 6f 72 | 6d 61 74 20 61 73 20 63 |...{ For|mat as c|
|00003450| 75 72 72 65 6e 63 79 20 | 7d 0d 09 55 53 45 20 43 |urrency |}..USE C|
|00003460| 4f 4d 4d 41 53 09 09 09 | 09 09 09 09 7b 20 46 6f |OMMAS...|....{ Fo|
|00003470| 72 6d 61 74 20 77 69 74 | 68 20 63 6f 6d 6d 61 73 |rmat wit|h commas|
|00003480| 20 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 | }..SELE|CT RANGE|
|00003490| 28 4d 41 4b 45 52 41 4e | 47 45 28 38 3b 35 3b 38 |(MAKERAN|GE(8;5;8|
|000034a0| 3b 6c 61 73 74 5f 52 54 | 5f 72 6f 77 2b 34 29 29 |;last_RT|_row+4))|
|000034b0| 20 7b 20 53 65 6c 65 63 | 74 20 41 63 74 75 61 6c | { Selec|t Actual|
|000034c0| 20 43 6f 73 74 20 63 6f | 6c 75 6d 6e 20 7d 0d 09 | Cost co|lumn }..|
|000034d0| 46 4f 52 4d 41 54 20 43 | 55 52 52 45 4e 43 59 09 |FORMAT C|URRENCY.|
|000034e0| 09 09 09 09 09 7b 20 46 | 6f 72 6d 61 74 20 61 73 |.....{ F|ormat as|
|000034f0| 20 63 75 72 72 65 6e 63 | 79 20 7d 0d 09 55 53 45 | currenc|y }..USE|
|00003500| 20 43 4f 4d 4d 41 53 09 | 09 09 09 09 09 09 7b 20 | COMMAS.|......{ |
|00003510| 46 6f 72 6d 61 74 20 77 | 69 74 68 20 63 6f 6d 6d |Format w|ith comm|
|00003520| 61 73 20 7d 0d 09 43 4f | 4c 55 4d 4e 20 57 49 44 |as }..CO|LUMN WID|
|00003530| 54 48 20 52 41 4e 47 45 | 20 41 31 20 54 4f 20 2e |TH RANGE| A1 TO .|
|00003540| 31 32 35 20 49 4e 43 48 | 09 09 09 7b 20 53 65 74 |125 INCH|...{ Set|
|00003550| 20 62 6f 72 64 65 72 20 | 63 6f 6c 75 6d 6e 20 68 | border |column h|
|00003560| 65 69 67 68 74 20 7d 0d | 09 52 4f 57 20 48 45 49 |eight }.|.ROW HEI|
|00003570| 47 48 54 20 52 41 4e 47 | 45 20 41 31 20 54 4f 20 |GHT RANG|E A1 TO |
|00003580| 2e 31 32 35 20 49 4e 43 | 48 09 09 09 7b 20 53 65 |.125 INC|H...{ Se|
|00003590| 74 20 62 6f 72 64 65 72 | 20 72 6f 77 20 68 65 69 |t border| row hei|
|000035a0| 67 68 74 20 7d 0d 09 53 | 45 4c 45 43 54 20 52 41 |ght }..S|ELECT RA|
|000035b0| 4e 47 45 20 42 32 09 09 | 09 09 09 09 7b 20 53 65 |NGE B2..|....{ Se|
|000035c0| 6c 65 63 74 20 74 69 74 | 6c 65 20 7d 0d 09 54 45 |lect tit|le }..TE|
|000035d0| 58 54 20 46 4f 4e 54 20 | 22 48 65 6c 76 65 74 69 |XT FONT |"Helveti|
|000035e0| 63 61 22 09 09 09 09 09 | 7b 20 53 65 74 20 66 6f |ca".....|{ Set fo|
|000035f0| 6e 74 20 74 6f 20 48 65 | 6c 76 65 74 69 63 61 20 |nt to He|lvetica |
|00003600| 7d 0d 09 54 45 58 54 20 | 53 54 59 4c 45 20 22 42 |}..TEXT |STYLE "B|
|00003610| 22 09 09 09 09 09 09 09 | 7b 20 53 65 74 20 73 74 |".......|{ Set st|
|00003620| 79 6c 65 20 74 6f 20 62 | 6f 6c 64 20 7d 0d 09 54 |yle to b|old }..T|
|00003630| 45 58 54 20 53 54 59 4c | 45 20 22 49 22 09 09 09 |EXT STYL|E "I"...|
|00003640| 09 09 09 09 7b 20 53 65 | 74 20 73 74 79 6c 65 20 |....{ Se|t style |
|00003650| 74 6f 20 69 74 61 6c 69 | 63 20 7d 0d 09 54 45 58 |to itali|c }..TEX|
|00003660| 54 20 53 49 5a 45 20 31 | 38 09 09 09 09 09 09 09 |T SIZE 1|8.......|
|00003670| 7b 20 53 65 74 20 66 6f | 6e 74 20 73 69 7a 65 20 |{ Set fo|nt size |
|00003680| 74 6f 20 31 38 70 74 20 | 7d 0d 09 52 4f 57 20 48 |to 18pt |}..ROW H|
|00003690| 45 49 47 48 54 20 28 2e | 33 20 49 4e 43 48 29 09 |EIGHT (.|3 INCH).|
|000036a0| 09 09 09 09 7b 20 53 65 | 74 20 72 6f 77 20 68 65 |....{ Se|t row he|
|000036b0| 69 67 68 74 20 66 6f 72 | 20 74 69 74 6c 65 20 7d |ight for| title }|
|000036c0| 0d 09 43 4f 4c 55 4d 4e | 20 57 49 44 54 48 20 52 |..COLUMN| WIDTH R|
|000036d0| 41 4e 47 45 20 49 31 20 | 54 4f 20 2e 31 32 35 20 |ANGE I1 |TO .125 |
|000036e0| 49 4e 43 48 09 09 09 7b | 20 53 65 74 20 61 64 6a |INCH...{| Set adj|
|000036f0| 61 63 65 6e 74 20 63 6f | 6c 75 6d 6e 20 77 69 64 |acent co|lumn wid|
|00003700| 74 68 20 7d 0d 09 52 4f | 57 20 48 45 49 47 48 54 |th }..RO|W HEIGHT|
|00003710| 20 52 41 4e 47 45 20 28 | 4d 41 4b 45 43 45 4c 4c | RANGE (|MAKECELL|
|00003720| 28 31 3b 6c 61 73 74 5f | 52 54 5f 72 6f 77 2b 35 |(1;last_|RT_row+5|
|00003730| 29 29 20 0d 09 09 54 4f | 20 2e 31 32 35 20 49 4e |)) ...TO| .125 IN|
|00003740| 43 48 09 09 09 09 09 09 | 7b 20 53 65 74 20 61 64 |CH......|{ Set ad|
|00003750| 6a 61 63 65 6e 74 20 72 | 6f 77 20 68 65 69 67 68 |jacent r|ow heigh|
|00003760| 74 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |t }..SEL|ECT RANG|
|00003770| 45 20 41 31 09 09 09 09 | 09 09 7b 20 53 65 6c 65 |E A1....|..{ Sele|
|00003780| 63 74 20 66 69 72 73 74 | 20 63 65 6c 6c 20 7d 0d |ct first| cell }.|
|00003790| 09 43 4f 50 59 09 09 09 | 09 09 09 09 09 09 7b 20 |.COPY...|......{ |
|000037a0| 43 6f 70 79 20 65 6d 70 | 74 79 20 63 65 6c 6c 20 |Copy emp|ty cell |
|000037b0| 74 6f 20 63 6c 65 61 72 | 20 74 68 65 20 63 6c 69 |to clear| the cli|
|000037c0| 70 62 6f 61 72 64 20 7d | 0d 09 55 4e 53 45 4c 45 |pboard }|..UNSELE|
|000037d0| 43 54 09 09 09 09 09 09 | 09 09 7b 20 44 65 73 65 |CT......|..{ Dese|
|000037e0| 6c 65 63 74 20 61 6c 6c | 20 66 69 65 6c 64 73 20 |lect all| fields |
|000037f0| 7d 0d 09 52 45 50 41 49 | 4e 54 20 4f 4e 09 09 09 |}..REPAI|NT ON...|
|00003800| 09 09 09 09 7b 20 54 75 | 72 6e 20 72 65 70 61 69 |....{ Tu|rn repai|
|00003810| 6e 74 20 6f 6e 20 7d 0d | 45 4e 44 20 46 55 4e 43 |nt on }.|END FUNC|
|00003820| 54 49 4f 4e 0d 0d 7b 2a | 2a 2a 2a 2a 2a 2a 2a 2a |TION..{*|********|
|00003830| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003840| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 41 53 4b |********|**** ASK|
|00003850| 5f 54 4f 5f 43 4f 50 59 | 20 2a 2a 2a 2a 2a 2a 2a |_TO_COPY| *******|
|00003860| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003870| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003880| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 20 20 54 |********|****.  T|
|00003890| 68 69 73 20 66 75 6e 63 | 74 69 6f 6e 20 64 69 73 |his func|tion dis|
|000038a0| 70 6c 61 79 73 20 61 20 | 6d 6f 64 61 6c 20 64 69 |plays a |modal di|
|000038b0| 61 6c 6f 67 20 62 6f 78 | 20 77 68 69 63 68 20 61 |alog box| which a|
|000038c0| 73 6b 73 20 69 66 20 79 | 6f 75 20 77 61 6e 74 20 |sks if y|ou want |
|000038d0| 74 6f 20 63 6c 6f 73 65 | 20 74 68 65 20 66 69 6c |to close| the fil|
|000038e0| 65 2e 20 20 49 66 20 79 | 6f 75 20 63 68 6f 6f 73 |e.  If y|ou choos|
|000038f0| 65 0d 20 20 22 59 65 73 | 22 20 74 68 65 20 74 61 |e.  "Yes|" the ta|
|00003900| 62 6c 65 20 69 73 20 63 | 6f 70 69 65 64 20 74 6f |ble is c|opied to|
|00003910| 20 74 68 65 20 63 6c 69 | 70 62 6f 61 72 64 20 61 | the cli|pboard a|
|00003920| 6e 64 20 74 68 65 20 66 | 69 6c 65 20 69 73 20 63 |nd the f|ile is c|
|00003930| 6c 6f 73 65 64 2e 20 20 | 49 66 20 79 6f 75 20 63 |losed.  |If you c|
|00003940| 68 6f 6f 73 65 20 22 4e | 6f 22 20 74 68 65 20 64 |hoose "N|o" the d|
|00003950| 69 61 6c 6f 67 0d 20 20 | 64 69 73 61 70 70 65 61 |ialog.  |disappea|
|00003960| 72 73 20 61 6e 64 20 74 | 68 65 20 73 63 72 69 70 |rs and t|he scrip|
|00003970| 74 20 74 65 72 6d 69 6e | 61 74 65 73 20 77 69 74 |t termin|ates wit|
|00003980| 68 20 74 68 65 20 66 69 | 6c 65 20 6f 70 65 6e 2e |h the fi|le open.|
|00003990| 0d 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |. ******|********|
|000039a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000039f0| 2a 2a 2a 2a 2a 2a 7d 0d | 0d 46 55 4e 43 54 49 4f |******}.|.FUNCTIO|
|00003a00| 4e 20 41 53 4b 5f 54 4f | 5f 43 4f 50 59 28 29 0d |N ASK_TO|_COPY().|
|00003a10| 09 4e 45 57 20 4d 4f 44 | 41 4c 20 44 49 41 4c 4f |.NEW MOD|AL DIALO|
|00003a20| 47 20 42 4f 58 20 41 54 | 20 28 2d 31 3b 2d 31 29 |G BOX AT| (-1;-1)|
|00003a30| 28 34 2e 35 20 49 4e 43 | 48 3b 31 2e 35 20 49 4e |(4.5 INC|H;1.5 IN|
|00003a40| 43 48 29 09 7b 20 43 72 | 65 61 74 65 20 61 20 63 |CH).{ Cr|eate a c|
|00003a50| 65 6e 74 65 72 65 64 20 | 34 2e 35 78 31 2e 35 20 |entered |4.5x1.5 |
|00003a60| 6d 6f 64 61 6c 20 64 69 | 61 6c 6f 67 20 62 6f 78 |modal di|alog box|
|00003a70| 20 7d 0d 09 41 44 44 20 | 54 45 58 54 20 22 43 6f | }..ADD |TEXT "Co|
|00003a80| 70 79 20 74 61 62 6c 65 | 20 74 6f 20 43 6c 69 70 |py table| to Clip|
|00003a90| 62 6f 61 72 64 20 61 6e | 64 20 63 6c 6f 73 65 20 |board an|d close |
|00003aa0| 77 6f 72 6b 73 68 65 65 | 74 20 77 69 74 68 6f 75 |workshee|t withou|
|00003ab0| 74 20 73 61 76 69 6e 67 | 3f 22 20 0d 09 09 41 54 |t saving|?" ...AT|
|00003ac0| 20 28 2e 31 32 35 20 49 | 4e 43 48 3b 20 2e 31 32 | (.125 I|NCH; .12|
|00003ad0| 35 20 49 4e 43 48 29 20 | 2b 20 28 34 2e 32 35 20 |5 INCH) |+ (4.25 |
|00003ae0| 49 4e 43 48 3b 20 2e 35 | 20 49 4e 43 48 29 09 7b |INCH; .5| INCH).{|
|00003af0| 20 50 6c 61 63 65 20 74 | 65 78 74 20 69 6e 74 6f | Place t|ext into|
|00003b00| 20 64 69 61 6c 6f 67 20 | 62 6f 78 20 7d 0d 09 4e | dialog |box }..N|
|00003b10| 4f 20 4c 49 4e 45 20 42 | 4f 52 44 45 52 09 09 09 |O LINE B|ORDER...|
|00003b20| 09 09 09 09 09 7b 20 54 | 75 72 6e 20 6f 66 66 20 |.....{ T|urn off |
|00003b30| 6c 69 6e 65 20 62 6f 72 | 64 65 72 20 66 6f 72 20 |line bor|der for |
|00003b40| 74 65 78 74 20 6f 62 6a | 65 63 74 20 7d 0d 09 41 |text obj|ect }..A|
|00003b50| 44 44 20 50 55 53 48 20 | 42 55 54 54 4f 4e 20 22 |DD PUSH |BUTTON "|
|00003b60| 20 20 20 20 4e 6f 20 20 | 20 20 22 3b 20 22 20 20 |    No  |  "; "  |
|00003b70| 20 20 59 65 73 20 20 20 | 20 22 20 41 54 20 09 7b |  Yes   | " AT .{|
|00003b80| 20 41 64 64 20 4e 6f 20 | 61 6e 64 20 59 65 73 20 | Add No |and Yes |
|00003b90| 62 75 74 74 6f 6e 73 20 | 7d 0d 09 09 28 33 2e 32 |buttons |}...(3.2|
|00003ba0| 35 20 49 4e 43 48 3b 20 | 2e 36 32 35 20 49 4e 43 |5 INCH; |.625 INC|
|00003bb0| 48 29 20 2b 20 28 31 20 | 49 4e 43 48 3b 20 2e 37 |H) + (1 |INCH; .7|
|00003bc0| 35 20 49 4e 43 48 29 0d | 09 53 45 4c 45 43 54 20 |5 INCH).|.SELECT |
|00003bd0| 43 4f 4e 54 52 4f 4c 20 | 32 09 09 09 09 09 09 09 |CONTROL |2.......|
|00003be0| 7b 20 53 65 6c 65 63 74 | 20 4e 6f 20 62 75 74 74 |{ Select| No butt|
|00003bf0| 6f 6e 20 7d 0d 09 44 49 | 41 4c 4f 47 20 43 41 4e |on }..DI|ALOG CAN|
|00003c00| 43 45 4c 20 50 55 53 48 | 20 42 55 54 54 4f 4e 09 |CEL PUSH| BUTTON.|
|00003c10| 09 09 09 09 7b 20 44 65 | 66 69 6e 65 20 62 75 74 |....{ De|fine but|
|00003c20| 74 6f 6e 20 61 73 20 61 | 20 63 61 6e 63 65 6c 20 |ton as a| cancel |
|00003c30| 62 75 74 74 6f 6e 20 7d | 0d 09 53 43 52 49 50 54 |button }|..SCRIPT|
|00003c40| 20 22 27 52 65 73 6f 75 | 72 63 65 20 57 6f 72 6b | "'Resou|rce Work|
|00003c50| 20 53 63 72 69 70 74 3a | 64 6f 6e 65 27 20 3d 20 | Script:|done' = |
|00003c60| 30 22 09 09 7b 20 49 66 | 20 70 72 65 73 73 65 64 |0"..{ If| pressed|
|00003c70| 2c 20 64 6f 6e 65 20 3d | 20 30 20 7d 0d 09 53 45 |, done =| 0 }..SE|
|00003c80| 4c 45 43 54 20 43 4f 4e | 54 52 4f 4c 20 33 09 09 |LECT CON|TROL 3..|
|00003c90| 09 09 09 09 09 7b 20 53 | 65 6c 65 63 74 20 59 65 |.....{ S|elect Ye|
|00003ca0| 73 20 62 75 74 74 6f 6e | 20 7d 0d 09 44 49 41 4c |s button| }..DIAL|
|00003cb0| 4f 47 20 44 45 46 41 55 | 4c 54 20 50 55 53 48 20 |OG DEFAU|LT PUSH |
|00003cc0| 42 55 54 54 4f 4e 09 09 | 09 09 09 7b 20 44 65 66 |BUTTON..|...{ Def|
|00003cd0| 69 6e 65 20 62 75 74 74 | 6f 6e 20 61 73 20 74 68 |ine butt|on as th|
|00003ce0| 65 20 64 65 66 61 75 6c | 74 20 62 75 74 74 6f 6e |e defaul|t button|
|00003cf0| 20 7d 0d 09 53 43 52 49 | 50 54 20 22 27 52 65 73 | }..SCRI|PT "'Res|
|00003d00| 6f 75 72 63 65 20 57 6f | 72 6b 20 53 63 72 69 70 |ource Wo|rk Scrip|
|00003d10| 74 3a 64 6f 6e 65 27 20 | 3d 20 31 22 09 09 7b 20 |t:done' |= 1"..{ |
|00003d20| 49 66 20 70 72 65 73 73 | 65 64 2c 20 64 6f 6e 65 |If press|ed, done|
|00003d30| 20 3d 20 31 20 7d 0d 09 | 55 53 45 20 44 49 41 4c | = 1 }..|USE DIAL|
|00003d40| 4f 47 20 42 4f 58 09 09 | 09 09 09 09 09 09 7b 20 |OG BOX..|......{ |
|00003d50| 44 69 73 70 6c 61 79 20 | 64 69 61 6c 6f 67 20 6f |Display |dialog o|
|00003d60| 6e 2d 73 63 72 65 65 6e | 20 7d 0d 09 49 46 20 64 |n-screen| }..IF d|
|00003d70| 6f 6e 65 20 3d 20 31 09 | 09 09 09 09 09 09 09 7b |one = 1.|.......{|
|00003d80| 20 49 66 20 64 6f 6e 65 | 20 3d 20 31 20 28 59 65 | If done| = 1 (Ye|
|00003d90| 73 20 77 61 73 20 70 72 | 65 73 73 65 64 29 20 7d |s was pr|essed) }|
|00003da0| 0d 09 09 53 45 4c 45 43 | 54 20 52 41 4e 47 45 28 |...SELEC|T RANGE(|
|00003db0| 4d 41 4b 45 52 41 4e 47 | 45 28 31 3b 31 3b 39 3b |MAKERANG|E(1;1;9;|
|00003dc0| 6c 61 73 74 5f 52 54 5f | 72 6f 77 2b 35 29 29 09 |last_RT_|row+5)).|
|00003dd0| 7b 20 53 65 6c 65 63 74 | 20 74 61 62 6c 65 20 7d |{ Select| table }|
|00003de0| 0d 09 09 43 4f 50 59 09 | 09 09 09 09 09 09 09 09 |...COPY.|........|
|00003df0| 7b 20 43 6f 70 79 20 74 | 6f 20 74 68 65 20 63 6c |{ Copy t|o the cl|
|00003e00| 69 70 62 6f 61 72 64 20 | 7d 0d 09 09 43 4c 4f 53 |ipboard |}...CLOS|
|00003e10| 45 20 4e 4f 57 09 09 09 | 09 09 09 09 09 7b 20 43 |E NOW...|.....{ C|
|00003e20| 6c 6f 73 65 20 77 69 74 | 68 6f 75 74 20 73 61 76 |lose wit|hout sav|
|00003e30| 69 6e 67 20 7d 0d 09 45 | 4e 44 20 49 46 09 09 09 |ing }..E|ND IF...|
|00003e40| 09 09 09 09 09 09 7b 20 | 45 6e 64 20 6c 6f 67 69 |......{ |End logi|
|00003e50| 63 61 6c 20 49 46 20 7d | 0d 45 4e 44 20 46 55 4e |cal IF }|.END FUN|
|00003e60| 43 54 49 4f 4e 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |CTION..{|********|
|00003e70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003e80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 45 4e |********|***** EN|
|00003e90| 44 20 53 43 52 49 50 54 | 20 2a 2a 2a 2a 2a 2a 2a |D SCRIPT| *******|
|00003ea0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003eb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003ec0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 00 00 |********|****}...|
|00003ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f00| 00 00 01 00 00 00 01 87 | 00 00 00 87 00 00 00 3c |........|.......<|
|00003f10| 00 00 00 2a 0e 53 74 6f | 6e 65 53 65 72 53 65 6d |...*.Sto|neSerSem|
|00003f20| 49 74 61 72 02 00 00 00 | 4c 57 46 4e 41 53 50 46 |Itar....|LWFNASPF|
|00003f30| 14 52 65 73 6f 75 72 63 | 65 20 57 6f 72 6b 20 53 |.Resourc|e Work S|
|00003f40| 63 72 69 70 74 63 02 00 | 00 00 52 73 53 63 52 73 |criptc..|..RsScRs|
|00003f50| 00 00 52 73 53 63 52 73 | 6c 76 01 00 00 9c 00 00 |..RsScRs|lv......|
|00003f60| 00 00 00 84 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f70| 00 00 a4 58 08 a0 00 00 | 3e 4f 00 00 01 c3 00 00 |...X....|>O......|
|00003f80| 00 00 00 00 00 00 00 00 | 00 00 0b 00 00 00 00 2a |........|.......*|
|00003f90| 05 53 79 6d 62 6f 02 00 | 00 00 4c 57 46 4e 41 53 |.Symbo..|..LWFNAS|
|00003fa0| 50 46 21 00 02 c0 00 c0 | 00 00 00 00 82 cd 00 00 |PF!.....|........|
|00003fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 7f 56 00 00 |........|.....V..|
|00003fc0| 84 00 a2 c3 4c 3f a2 c3 | 4c 3f 00 00 00 00 00 00 |....L?..|L?......|
|00003fd0| 00 00 00 00 00 00 00 00 | 31 ce 00 00 00 00 00 00 |........|1.......|
|00003fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 5a d5 00 16 |........|....Z...|
|00003ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 1c 00 00 00 |........|........|
|00004000| 00 00 00 83 fe 14 92 44 | 3f e5 32 30 00 04 00 00 |.......D|?.20....|
|00004010| 00 00 00 00 00 00 a4 58 | 0b 60 a4 58 0b 60 a1 20 |.......X|.`.X.`. |
|00004020| 06 7d 00 00 91 e8 00 00 | 00 52 00 06 06 4f 61 73 |.}......|.R...Oas|
|00004030| 69 73 ba 00 0a 53 75 65 | 20 57 61 72 6e 65 72 00 |is...Sue| Warner.|
|00004040| 01 36 00 14 52 65 73 6f | 75 72 63 65 20 57 6f 72 |.6..Reso|urce Wor|
|00004050| 6b 20 53 63 72 69 70 74 | 00 0f 43 68 61 6e 67 65 |k Script|..Change|
|00004060| 73 20 66 6f 72 20 78 31 | 31 00 00 1a 43 68 65 63 |s for x1|1...Chec|
|00004070| 6b 20 69 6e 20 66 6f 72 | 20 67 6f 6c 64 65 6e 20 |k in for| golden |
|00004080| 73 75 62 6d 69 74 00 00 | 00 01 00 00 00 01 87 00 |submit..|........|
|00004090| 00 00 87 00 00 00 3c 00 | 04 6e 84 01 7a 00 00 00 |......<.|.n..z...|
|000040a0| 1c 00 32 00 00 63 6b 69 | 64 00 00 00 0a 00 80 00 |..2..cki|d.......|
|000040b0| 00 00 00 00 00 00 00 00 | 00 09 50 72 6f 6a 65 63 |........|..Projec|
|000040c0| 74 6f 72 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |tor.....|........|
|000040d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+