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 Cost Script < prev next >
MacBinary | 1991-05-16 | 19.5 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 Cost 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', 19241 bytes "Resource Cost Script" , at 0x4ba9 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 43 6f 73 74 20 |..Resour|ce Cost |
|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 4b 29 00 | 00 01 c3 a4 58 08 a0 a4 |.....K).|....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 f5 e7 00 00 |........|........|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 b2 3e 00 00 |BAT_BTSC|0101.>..|
|00000090| 1f 0c 00 00 17 0b 00 00 | 17 0b 00 00 17 0b 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 0a 00 |........|........|
|000000d0| 11 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 3c 00 1b 00 00 01 |........|..<.....|
|000000f0| f9 f8 1a 00 06 18 00 00 | 00 00 00 00 00 00 39 f2 |........|......9.|
|00000100| 26 00 1b 00 00 02 f9 f8 | 1b 00 00 03 f9 f8 1b 00 |&.......|........|
|00000110| 00 04 f9 f8 1b 00 00 05 | f9 f8 1b 00 00 06 f9 f8 |........|........|
|00000120| 1b 00 00 07 f9 f8 fc f6 | 00 00 fd 04 1b 00 00 fd |........|........|
|00000130| 16 00 03 00 11 4d 50 20 | 52 65 73 6f 75 72 63 65 |.....MP |Resource|
|00000140| 20 54 61 62 6c 65 fe 40 | 18 00 00 00 00 00 00 00 | Table.@|........|
|00000150| 00 39 f2 e0 00 1b 00 00 | 08 f9 f4 00 00 fd 03 01 |.9......|........|
|00000160| 01 fd 06 00 00 00 00 00 | fd 0e 08 01 01 01 01 07 |........|........|
|00000170| 07 00 00 00 00 ff 00 fd | 15 00 06 00 10 4d 50 20 |........|.....MP |
|00000180| 50 72 6f 6a 65 63 74 20 | 54 61 62 6c 65 fe 40 18 |Project |Table.@.|
|00000190| 00 00 00 00 00 00 00 00 | 39 f2 88 00 fd 04 1a 04 |........|9.......|
|000001a0| 01 fd 13 08 01 01 01 01 | 0c 08 0f 00 00 00 00 00 |........|........|
|000001b0| 00 ff 7f ff 00 fd 02 0c | 1b 00 00 08 f9 f4 00 01 |........|........|
|000001c0| fd 0e 08 01 01 01 01 07 | 07 02 00 2a 00 ff 00 fd |........|...*....|
|000001d0| 16 00 06 00 11 4d 50 20 | 52 65 73 6f 75 72 63 65 |.....MP |Resource|
|000001e0| 20 54 61 62 6c 65 fd 13 | 08 01 01 01 01 0c 08 0f | Table..|........|
|000001f0| 00 00 ff 7f 2b 00 2b 00 | ff 00 fd 02 0c fd 13 08 |....+.+.|........|
|00000200| 01 01 01 01 0c 08 0f 00 | 00 ff 7f 2d 00 2f 00 ff |........|...-./..|
|00000210| 00 fd 03 18 04 18 00 00 | 00 00 00 00 f0 3f fa 1d |........|.....?..|
|00000220| 10 00 fd 03 01 01 18 00 | 00 00 00 00 00 00 00 fa |........|........|
|00000230| 1d 0c 00 18 00 00 00 00 | 00 00 00 00 fa fb f6 00 |........|........|
|00000240| 00 fd 04 08 01 05 18 00 | 00 00 00 00 00 f0 3f fe |........|......?.|
|00000250| 19 d1 fa fb f6 00 01 18 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| f4 03 01 18 00 00 00 00 | 00 00 08 40 f4 00 05 1a |........|...@....|
|00000270| 00 00 2a 00 00 00 00 00 | 00 00 40 18 00 00 00 00 |..*.....|..@.....|
|00000280| 00 00 f0 3f 1d 1f 00 1a | 00 00 2a 00 00 00 00 00 |...?....|..*.....|
|00000290| 00 00 40 18 00 00 00 00 | 00 00 f0 3f f7 1a 00 05 |..@.....|...?....|
|000002a0| 2e f4 00 05 1a 00 05 f5 | 1a 00 1a 03 01 18 00 00 |........|........|
|000002b0| 00 00 00 80 46 40 1a 00 | 05 d4 d2 2e f4 03 01 1d |....F@..|........|
|000002c0| c7 ff 1a 03 01 18 00 00 | 00 00 00 00 00 00 3d f2 |........|......=.|
|000002d0| 6c 00 fd 59 23 00 55 4e | 6f 20 63 6f 73 74 20 69 |l..Y#.UN|o cost i|
|000002e0| 6e 66 6f 72 6d 61 74 69 | 6f 6e 20 68 61 73 20 62 |nformati|on has b|
|000002f0| 65 65 6e 20 65 6e 74 65 | 72 65 64 20 69 6e 20 74 |een ente|red in t|
|00000300| 68 65 20 52 65 73 6f 75 | 72 63 65 20 54 61 62 6c |he Resou|rce Tabl|
|00000310| 65 2e 20 20 43 61 6e 6e | 6f 74 20 63 72 65 61 74 |e.  Cann|ot creat|
|00000320| 65 20 74 68 65 20 67 72 | 61 70 68 2e fd 03 01 01 |e the gr|aph.....|
|00000330| 18 00 00 00 00 00 00 f0 | 3f f4 00 06 fb f6 00 00 |........|?.......|
|00000340| fd 37 17 01 2c 19 1b 50 | 6c 61 6e 6e 65 64 20 43 |.7..,..P|lanned C|
|00000350| 6f 73 74 20 42 79 20 52 | 65 73 6f 75 72 63 65 20 |ost By R|esource |
|00000360| 2d 20 5f 19 08 6d 6d 2f | 64 64 2f 79 79 68 35 ff |- _..mm/|dd/yyh5.|
|00000370| 01 07 07 00 00 2a 00 ff | fd 14 17 00 08 52 65 73 |.....*..|.....Res|
|00000380| 6f 75 72 63 65 01 07 07 | 01 00 2a 00 ff fd 16 17 |ource...|..*.....|
|00000390| 00 0a 54 6f 74 61 6c 20 | 43 6f 73 74 01 07 07 01 |..Total |Cost....|
|000003a0| 00 2b 00 ff fd 15 17 00 | 09 55 6e 69 74 20 43 6f |.+......|.Unit Co|
|000003b0| 73 74 01 07 07 01 00 2c | 00 ff fd 14 17 00 08 44 |st.....,|.......D|
|000003c0| 75 72 61 74 69 6f 6e 01 | 07 07 01 00 2d 00 ff 18 |uration.|....-...|
|000003d0| 00 00 00 00 00 00 08 40 | f4 00 05 1a 00 00 2a 00 |.......@|......*.|
|000003e0| 00 00 00 00 00 00 40 18 | 00 00 00 00 00 00 f0 3f |......@.|.......?|
|000003f0| 1d 1f 00 1a 00 00 2a 00 | 00 00 00 00 00 00 40 18 |......*.|......@.|
|00000400| 00 00 00 00 00 00 f0 3f | f7 1a 00 05 2e f4 00 05 |.......?|........|
|00000410| 1a 00 05 f5 1a 00 fd 14 | 17 80 01 10 18 00 00 00 |........|........|
|00000420| 00 00 00 47 40 1a 00 05 | d4 d3 ff 1d c7 ff fb f6 |...G@...|........|
|00000430| 00 00 18 00 00 00 00 00 | 00 00 40 f4 00 04 18 00 |........|..@.....|
|00000440| 00 00 00 00 80 44 40 18 | 00 00 00 00 00 00 14 40 |.....D@.|.......@|
|00000450| 1d 1c 00 18 00 00 00 00 | 00 80 44 40 18 00 00 00 |........|..D@....|
|00000460| 00 00 00 14 40 f7 1a 00 | 04 2e f4 00 04 1a 00 04 |....@...|........|
|00000470| f5 a0 00 18 00 00 00 00 | 00 00 00 40 f4 00 03 1a |........|...@....|
|00000480| 00 01 18 00 00 00 00 00 | 00 f0 3f 1d 16 00 1a 00 |........|..?.....|
|00000490| 01 18 00 00 00 00 00 00 | f0 3f f7 1a 00 03 2e f4 |........|.?......|
|000004a0| 00 03 1a 00 03 f5 68 00 | 1a 00 04 1a 00 03 d4 f4 |......h.|........|
|000004b0| 00 02 1a 00 02 d3 53 38 | f2 52 00 18 00 00 00 00 |......S8|.R......|
|000004c0| 00 00 08 40 f4 00 05 1a | 00 00 2a 00 00 00 00 00 |...@....|..*.....|
|000004d0| 00 00 40 18 00 00 00 00 | 00 00 f0 3f 1d 1f 00 1a |..@.....|...?....|
|000004e0| 00 00 2a 00 00 00 00 00 | 00 00 40 18 00 00 00 00 |..*.....|..@.....|
|000004f0| 00 00 f0 3f f7 1a 00 05 | 2e f4 00 05 1a 00 05 f5 |...?....|........|
|00000500| 0b 00 1b 00 00 09 f9 f8 | 1d d6 ff 1d 82 ff 1d 44 |........|.......D|
|00000510| ff fb f6 00 01 1a 00 02 | d2 18 00 00 00 00 00 80 |........|........|
|00000520| 45 40 1a 00 05 d4 d2 39 | f2 3e 00 1a 00 04 2a 00 |E@.....9|.>....*.|
|00000530| 00 00 00 00 00 f0 3f 1a | 00 03 d4 d2 18 00 00 00 |......?.|........|
|00000540| 00 00 00 47 40 1a 00 05 | d4 d2 2e f4 03 01 fd 18 |...G@...|........|
|00000550| 17 01 05 1a 03 01 ff 01 | 0f 18 00 00 00 00 00 00 |........|........|
|00000560| 47 40 1a 00 05 d4 ff fb | f6 00 01 18 00 00 00 00 |G@......|........|
|00000570| 00 00 08 40 f4 00 05 1a | 00 00 2a 00 00 00 00 00 |...@....|..*.....|
|00000580| 00 00 40 18 00 00 00 00 | 00 00 f0 3f 1d 1f 00 1a |..@.....|...?....|
|00000590| 00 00 2a 00 00 00 00 00 | 00 00 40 18 00 00 00 00 |..*.....|..@.....|
|000005a0| 00 00 f0 3f f7 1a 00 05 | 2e f4 00 05 1a 00 05 f5 |...?....|........|
|000005b0| 45 00 19 01 3d 18 00 00 | 00 00 00 00 47 40 1a 00 |E...=...|....G@..|
|000005c0| 05 d4 35 19 01 2a 35 18 | 00 00 00 00 00 80 46 40 |..5..*5.|......F@|
|000005d0| 1a 00 05 d4 35 f4 03 01 | fd 19 17 01 05 1a 03 01 |....5...|........|
|000005e0| ff 01 10 18 00 00 00 00 | 00 00 46 40 1a 00 05 d4 |........|..F@....|
|000005f0| d3 ff 1d 9c ff fb f6 00 | 00 fd 31 08 01 01 01 01 |........|..1.....|
|00000600| 2a 18 00 00 00 00 00 80 | 45 40 18 00 00 00 00 00 |*.......|E@......|
|00000610| 00 f0 3f 18 00 00 00 00 | 00 00 47 40 1a 00 00 2a |..?.....|..G@...*|
|00000620| 00 00 00 00 00 00 00 40 | d8 ff 00 fd 03 06 01 fd |.......@|........|
|00000630| 03 01 01 fd 06 00 00 00 | 00 00 fd 04 1a 04 01 fd |........|........|
|00000640| 05 1a 05 00 0d fd 05 1a | 05 00 04 fd 05 1a 05 00 |........|........|
|00000650| 03 fd 05 1a 05 00 05 fd | 0e 08 01 01 01 01 07 07 |........|........|
|00000660| 01 00 01 00 ff 00 fd 04 | 06 02 00 fd 13 08 01 01 |........|........|
|00000670| 01 01 0c 08 0f 01 00 01 | 00 01 00 04 00 ff 00 fd |........|........|
|00000680| 07 0f 03 02 02 12 00 fd | 0f 0f 03 01 00 09 48 65 |........|......He|
|00000690| 6c 76 65 74 69 63 61 fd | 07 0f 03 03 00 01 42 fd |lvetica.|......B.|
|000006a0| 07 0f 03 03 00 01 49 fd | 07 19 01 01 02 70 08 fd |......I.|.....p..|
|000006b0| 07 19 00 01 02 d0 02 fd | 13 08 01 01 01 01 0c 08 |........|........|
|000006c0| 0f 02 00 02 00 01 00 04 | 00 ff 00 fd 07 0f 03 02 |........|........|
|000006d0| 02 0e 00 fd 0f 0f 03 01 | 00 09 48 65 6c 76 65 74 |........|..Helvet|
|000006e0| 69 63 61 fd 07 0f 03 03 | 00 01 42 fd 07 0f 03 03 |ica.....|..B.....|
|000006f0| 00 01 49 fd 0a 0f 0a 00 | 05 4f 74 6c 62 72 fd 04 |..I.....|.Otlbr..|
|00000700| 0f 04 02 fd 31 08 01 01 | 01 01 2a 18 00 00 00 00 |....1...|..*.....|
|00000710| 00 00 00 40 18 00 00 00 | 00 00 00 10 40 18 00 00 |...@....|....@...|
|00000720| 00 00 00 00 14 40 1a 00 | 00 2a 00 00 00 00 00 00 |.....@..|.*......|
|00000730| 08 40 d8 ff 00 fd 0f 0f | 03 01 00 09 48 65 6c 76 |.@......|....Helv|
|00000740| 65 74 69 63 61 fd 09 0f | 0a 00 04 54 4c 42 52 fd |etica...|...TLBR.|
|00000750| 31 08 01 01 01 01 2a 18 | 00 00 00 00 00 00 08 40 |1.....*.|.......@|
|00000760| 18 00 00 00 00 00 00 10 | 40 18 00 00 00 00 00 00 |........|@.......|
|00000770| 10 40 1a 00 00 2a 00 00 | 00 00 00 00 08 40 d8 ff |.@...*..|.....@..|
|00000780| 00 fd 05 0f 05 00 20 fd | 06 0f 05 02 01 09 fd 0f |...... .|........|
|00000790| 19 01 02 01 07 07 00 00 | 00 00 ff 02 b4 00 fd 0f |........|........|
|000007a0| 19 00 02 01 07 07 00 00 | 00 00 ff 02 b4 00 fd 0f |........|........|
|000007b0| 19 01 02 01 07 07 00 00 | 05 00 ff 02 b4 00 fd 20 |........|....... |
|000007c0| 19 00 02 01 18 18 00 00 | 00 00 00 00 f0 3f 1a 00 |........|.....?..|
|000007d0| 00 2a 00 00 00 00 00 00 | 10 40 d4 ff 02 b4 00 fb |.*......|.@......|
|000007e0| f6 00 00 fd 62 15 00 04 | 01 31 08 0f 00 00 13 00 |....b...|.1......|
|000007f0| 07 00 0d 00 18 00 00 00 | 00 00 00 f0 3f 18 00 00 |........|....?...|
|00000800| 00 00 00 00 00 00 18 00 | 00 00 00 00 80 53 40 18 |........|.....S@.|
|00000810| 00 00 00 00 00 80 5f 40 | e3 ff 01 2b 18 00 00 00 |......_@|...+....|
|00000820| 00 00 00 00 40 18 00 00 | 00 00 00 00 08 40 18 00 |....@...|.....@..|
|00000830| 00 00 00 00 00 08 40 1a | 00 00 2a 00 00 00 00 00 |......@.|..*.....|
|00000840| 00 08 40 d8 d3 ff fd 08 | 09 01 04 01 81 00 00 fd |..@.....|........|
|00000850| 04 16 00 00 fd 05 16 06 | 0e 03 fd 0d 09 01 04 01 |........|........|
|00000860| 81 00 06 00 01 81 00 00 | 1a 00 00 18 00 00 00 00 |........|........|
|00000870| 00 00 34 40 3a f2 08 00 | fd 05 16 04 02 00 fd 07 |..4@:...|........|
|00000880| 16 04 04 01 00 80 fd 0f | 16 04 04 01 01 03 00 00 |........|........|
|00000890| 00 e0 ff ff 6f 41 fd 07 | 16 04 04 01 02 80 fd 06 |....oA..|........|
|000008a0| 16 04 04 00 85 fd 0f 16 | 04 03 01 00 03 00 00 00 |........|........|
|000008b0| 60 77 77 67 41 fd 0f 16 | 04 03 01 01 03 00 00 00 |`wwgA...|........|
|000008c0| e0 ff ff 6f 41 fd 07 16 | 04 03 01 02 80 fd 06 16 |...oA...|........|
|000008d0| 04 03 00 80 fd 0d 09 01 | 04 01 81 00 06 00 01 83 |........|........|
|000008e0| 00 00 fd 07 16 04 04 01 | 00 80 fd 0f 16 04 04 01 |........|........|
|000008f0| 01 03 00 00 00 e0 ff ff | 6f 41 fd 07 16 04 04 01 |........|oA......|
|00000900| 02 81 fd 06 16 04 04 00 | 85 fd 07 16 04 03 01 00 |........|........|
|00000910| 80 fd 0f 16 04 03 01 01 | 03 00 00 00 e0 ff ff 6f |........|.......o|
|00000920| 41 fd 07 16 04 03 01 02 | 81 fd 06 16 04 03 00 80 |A.......|........|
|00000930| fd 05 16 03 00 05 fd 0c | 09 01 04 01 81 00 04 00 |........|........|
|00000940| 01 81 00 fd 0d 0f 00 00 | 03 00 00 00 00 00 a0 6b |........|.......k|
|00000950| 41 fd 0e 08 01 01 01 01 | 07 07 01 00 01 00 ff 00 |A.......|........|
|00000960| fd 08 09 00 04 01 81 00 | 00 fd 04 16 01 02 fd 0e |........|........|
|00000970| 08 01 01 01 01 07 07 00 | 00 0e 00 ff 00 fd 0e 08 |........|........|
|00000980| 01 01 01 01 07 07 00 00 | 07 00 ff 00 fd 03 06 01 |........|........|
|00000990| fd 04 08 01 07 fd 03 1b | 02 fd 04 1b 00 01 fd 06 |........|........|
|000009a0| 16 04 04 00 85 fb f6 00 | 00 fd 12 1d 00 00 00 02 |........|........|
|000009b0| ff ff 02 ff ff 00 02 20 | 1c 02 70 08 fd 58 1e 0b |....... |..p..X..|
|000009c0| 00 44 43 6f 70 79 20 63 | 68 61 72 74 20 6f 72 20 |.DCopy c|hart or |
|000009d0| 74 61 62 6c 65 20 74 6f | 20 43 6c 69 70 62 6f 61 |table to| Clipboa|
|000009e0| 72 64 20 61 6e 64 20 63 | 6c 6f 73 65 20 77 6f 72 |rd and c|lose wor|
|000009f0| 6b 73 68 65 65 74 20 77 | 69 74 68 6f 75 74 20 73 |ksheet w|ithout s|
|00000a00| 61 76 69 6e 67 3f 00 00 | 02 b4 00 02 b4 00 01 02 |aving?..|........|
|00000a10| b8 1a 02 d0 02 fd 06 0f | 02 00 1c 00 fd 20 1e 00 |........|..... ..|
|00000a20| 01 00 0a 20 20 20 20 4e | 6f 20 20 20 20 00 00 00 |...    N|o    ...|
|00000a30| 02 38 0d 02 54 06 01 02 | a0 05 02 68 01 fd 33 1e |.8..T...|...h..3.|
|00000a40| 00 01 00 0d 20 20 20 20 | 54 61 62 6c 65 20 20 20 |....    |Table   |
|00000a50| 20 01 00 0d 20 20 20 20 | 43 68 61 72 74 20 20 20 | ...    |Chart   |
|00000a60| 20 00 00 00 02 18 15 02 | d0 02 01 02 a0 05 02 a0 | .......|........|
|00000a70| 05 fd 06 1d 0b 01 82 00 | fd 03 1d 09 fd 25 21 03 |........|.....%!.|
|00000a80| 00 00 1f 27 52 65 73 6f | 75 72 63 65 20 43 6f 73 |...'Reso|urce Cos|
|00000a90| 74 20 53 63 72 69 70 74 | 3a 64 6f 6e 65 27 20 3d |t Script|:done' =|
|00000aa0| 20 30 fd 06 1d 0b 01 83 | 00 fd a0 21 03 00 00 9a | 0......|...!....|
|00000ab0| 4f 4e 20 4d 4f 55 53 45 | 55 50 09 09 09 09 09 09 |ON MOUSE|UP......|
|00000ac0| 09 7b 20 57 68 65 6e 20 | 6d 6f 75 73 65 20 72 65 |.{ When |mouse re|
|00000ad0| 6c 65 61 73 65 64 20 7d | 0d 09 09 27 52 65 73 6f |leased }|...'Reso|
|00000ae0| 75 72 63 65 20 43 6f 73 | 74 20 53 63 72 69 70 74 |urce Cos|t Script|
|00000af0| 3a 64 6f 6e 65 27 20 3d | 20 31 09 09 09 7b 20 49 |:done' =| 1...{ I|
|00000b00| 66 20 70 72 65 73 73 65 | 64 2c 20 64 6f 6e 65 20 |f presse|d, done |
|00000b10| 3d 20 31 20 7d 0d 09 09 | 51 55 49 54 20 44 49 41 |= 1 }...|QUIT DIA|
|00000b20| 4c 4f 47 20 42 4f 58 09 | 09 09 09 09 09 7b 20 51 |LOG BOX.|.....{ Q|
|00000b30| 75 69 74 20 64 69 61 6c | 6f 67 20 7d 0d 09 09 45 |uit dial|og }...E|
|00000b40| 4e 44 20 4d 4f 55 53 45 | 55 50 fd 06 1d 0b 01 84 |ND MOUSE|UP......|
|00000b50| 00 fd 03 1d 08 fd 25 21 | 03 00 00 1f 27 52 65 73 |......%!|....'Res|
|00000b60| 6f 75 72 63 65 20 43 6f | 73 74 20 53 63 72 69 70 |ource Co|st Scrip|
|00000b70| 74 3a 64 6f 6e 65 27 20 | 3d 20 32 fd 03 1d 03 1a |t:done' |= 2.....|
|00000b80| 00 06 18 00 00 00 00 00 | 00 f0 3f 39 f2 3f 00 fd |........|..?9.?..|
|00000b90| 31 08 01 01 01 01 2a 18 | 00 00 00 00 00 00 f0 3f |1.....*.|.......?|
|00000ba0| 18 00 00 00 00 00 00 f0 | 3f 18 00 00 00 00 00 00 |........|?.......|
|00000bb0| 18 40 1a 00 00 2a 00 00 | 00 00 00 00 10 40 d8 ff |.@...*..|.....@..|
|00000bc0| 00 fd 03 06 01 fd 03 01 | 01 1d 23 00 1a 00 06 18 |........|..#.....|
|00000bd0| 00 00 00 00 00 00 00 40 | 39 f2 13 00 fd 08 09 01 |.......@|9.......|
|00000be0| 04 01 81 00 00 fd 03 06 | 01 fd 03 01 01 fb fc 0c |........|........|
|00000bf0| 00 6c 61 73 74 5f 52 54 | 5f 72 6f 77 00 0c 00 6c |.last_RT|_row...l|
|00000c00| 61 73 74 5f 50 54 5f 72 | 6f 77 01 0d 00 63 75 72 |ast_PT_r|ow...cur|
|00000c10| 72 65 6e 74 5f 63 65 6c | 6c 02 08 00 63 75 72 5f |rent_cel|l...cur_|
|00000c20| 72 6f 77 03 08 00 63 75 | 72 5f 63 6f 6c 04 05 00 |row...cu|r_col...|
|00000c30| 6c 6f 6f 70 05 05 00 64 | 6f 6e 65 06 0a 01 00 47 |loop...d|one....G|
|00000c40| 45 54 5f 44 41 54 41 4f | 00 00 00 0b 01 00 54 45 |ET_DATAO|......TE|
|00000c50| 53 54 5f 44 41 54 41 7c | 01 00 00 0e 01 00 43 52 |ST_DATA||......CR|
|00000c60| 45 41 54 45 5f 54 41 42 | 4c 45 65 02 00 00 10 01 |EATE_TAB|LEe.....|
|00000c70| 00 43 41 4c 43 5f 44 55 | 52 41 54 49 4f 4e 53 57 |.CALC_DU|RATIONSW|
|00000c80| 03 00 00 11 01 00 43 52 | 45 41 54 45 5f 46 4f 52 |......CR|EATE_FOR|
|00000c90| 4d 55 4c 41 53 90 04 00 | 00 12 01 00 43 52 45 41 |MULAS...|....CREA|
|00000ca0| 54 45 5f 57 4f 52 4b 53 | 48 45 45 54 1e 05 00 00 |TE_WORKS|HEET....|
|00000cb0| 0e 01 00 43 52 45 41 54 | 45 5f 43 48 41 52 54 08 |...CREAT|E_CHART.|
|00000cc0| 07 00 00 0d 01 00 41 53 | 4b 5f 54 4f 5f 43 4f 50 |......AS|K_TO_COP|
|00000cd0| 59 ce 08 00 00 0a 01 00 | 47 45 54 5f 52 4f 57 53 |Y.......|GET_ROWS|
|00000ce0| 66 01 00 00 0e 01 00 41 | 44 44 5f 54 4f 5f 54 41 |f......A|DD_TO_TA|
|00000cf0| 42 4c 45 3a 04 00 00 7b | 2a 2a 2a 2a 2a 2a 2a 2a |BLE:...{|********|
|00000d00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 43 4f |********|***** CO|
|00000d20| 53 54 20 42 59 20 52 45 | 53 4f 55 52 43 45 20 2a |ST BY RE|SOURCE *|
|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 | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000d50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 20 20 |********|*****.  |
|00000d60| a9 20 31 39 39 31 20 43 | 6c 61 72 69 73 20 43 6f |. 1991 C|laris Co|
|00000d70| 72 70 6f 72 61 74 69 6f | 6e 2e 20 20 41 6c 6c 20 |rporatio|n.  All |
|00000d80| 72 69 67 68 74 73 20 72 | 65 73 65 72 76 65 64 2e |rights r|eserved.|
|00000d90| 0d 0d 20 20 4c 41 53 54 | 20 4d 4f 44 49 46 49 45 |..  LAST| MODIFIE|
|00000da0| 44 3a 20 20 31 2f 31 34 | 2f 39 31 0d 0d 20 20 54 |D:  1/14|/91..  T|
|00000db0| 61 62 6c 65 73 20 55 73 | 65 64 3a 0d 09 a5 20 20 |ables Us|ed:...  |
|00000dc0| 52 65 73 6f 75 72 63 65 | 20 54 61 62 6c 65 0d 09 |Resource| Table..|
|00000dd0| a5 20 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |.  Proje|ct Table|
|00000de0| 0d 0d 20 20 41 73 73 75 | 6d 70 74 69 6f 6e 73 3a |..  Assu|mptions:|
|00000df0| 0d 09 a5 20 41 6c 6c 20 | 63 6f 6c 75 6d 6e 73 20 |... All |columns |
|00000e00| 69 6e 76 6f 6c 76 69 6e | 67 20 72 65 73 6f 75 72 |involvin|g resour|
|00000e10| 63 65 73 20 61 72 65 20 | 65 78 70 6f 72 74 65 64 |ces are |exported|
|00000e20| 2e 0d 09 a5 20 41 6c 6c | 20 6f 74 68 65 72 20 63 |.... All| other c|
|00000e30| 6f 6c 75 6d 6e 73 20 61 | 72 65 20 6e 6f 74 20 65 |olumns a|re not e|
|00000e40| 78 70 6f 72 74 65 64 20 | 65 78 63 65 70 74 20 74 |xported |except t|
|00000e50| 68 65 20 54 61 73 6b 20 | 4e 61 6d 65 20 63 6f 6c |he Task |Name col|
|00000e60| 75 6d 6e 20 28 6d 75 73 | 74 20 62 65 20 65 78 70 |umn (mus|t be exp|
|00000e70| 6f 72 74 65 64 29 0d 09 | 2d 2d 3e 20 50 72 6f 6a |orted)..|--> Proj|
|00000e80| 65 63 74 20 54 61 62 6c | 65 20 73 68 6f 75 6c 64 |ect Tabl|e should|
|00000e90| 20 68 61 76 65 20 34 31 | 20 63 6f 6c 75 6d 6e 73 | have 41| columns|
|00000ea0| 20 28 35 20 63 6f 6c 75 | 6d 6e 73 20 70 65 72 20 | (5 colu|mns per |
|00000eb0| 72 65 73 6f 75 72 63 65 | 20 2a 20 38 20 72 65 73 |resource| * 8 res|
|00000ec0| 6f 75 72 63 65 73 20 2b | 20 54 61 73 6b 20 4e 61 |ources +| Task Na|
|00000ed0| 6d 65 20 3d 20 34 31 29 | 0d 0d 2a 2a 2a 2a 2a 2a |me = 41)|..******|
|00000ee0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000ef0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f00| 20 44 45 46 49 4e 45 20 | 47 4c 4f 42 41 4c 20 56 | DEFINE |GLOBAL V|
|00000f10| 41 52 49 41 42 4c 45 53 | 20 2a 2a 2a 2a 2a 2a 2a |ARIABLES| *******|
|00000f20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 7d |********|*******}|
|00000f40| 0d 0d 44 45 46 49 4e 45 | 20 6c 61 73 74 5f 52 54 |..DEFINE| last_RT|
|00000f50| 5f 72 6f 77 09 09 7b 20 | 4e 75 6d 62 65 72 20 6f |_row..{ |Number o|
|00000f60| 66 20 72 6f 77 73 20 69 | 6e 20 52 65 73 6f 75 72 |f rows i|n Resour|
|00000f70| 63 65 20 54 61 62 6c 65 | 20 7d 0d 44 45 46 49 4e |ce Table| }.DEFIN|
|00000f80| 45 20 6c 61 73 74 5f 50 | 54 5f 72 6f 77 09 09 7b |E last_P|T_row..{|
|00000f90| 20 4e 75 6d 62 65 72 20 | 6f 66 20 72 6f 77 73 20 | Number |of rows |
|00000fa0| 69 6e 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |in Proje|ct Table|
|00000fb0| 20 7d 0d 44 45 46 49 4e | 45 20 63 75 72 72 65 6e | }.DEFIN|E curren|
|00000fc0| 74 5f 63 65 6c 6c 09 09 | 7b 20 43 75 72 72 65 6e |t_cell..|{ Curren|
|00000fd0| 74 20 43 65 6c 6c 20 7d | 0d 44 45 46 49 4e 45 20 |t Cell }|.DEFINE |
|00000fe0| 63 75 72 5f 72 6f 77 3b | 20 63 75 72 5f 63 6f 6c |cur_row;| cur_col|
|00000ff0| 09 7b 20 43 75 72 72 65 | 6e 74 20 72 6f 77 20 61 |.{ Curre|nt row a|
|00001000| 6e 64 20 63 6f 6c 75 6d | 6e 20 7d 0d 44 45 46 49 |nd colum|n }.DEFI|
|00001010| 4e 45 20 6c 6f 6f 70 09 | 09 09 7b 20 4d 61 69 6e |NE loop.|..{ Main|
|00001020| 20 6c 6f 6f 70 20 63 6f | 75 6e 74 65 72 20 7d 0d | loop co|unter }.|
|00001030| 44 45 46 49 4e 45 20 64 | 6f 6e 65 09 09 09 7b 20 |DEFINE d|one...{ |
|00001040| 44 6f 6e 65 20 66 6c 61 | 67 20 7d 0d 0d 64 6f 6e |Done fla|g }..don|
|00001050| 65 20 3d 20 30 09 09 09 | 09 7b 20 53 65 74 20 64 |e = 0...|.{ Set d|
|00001060| 6f 6e 65 20 66 6c 61 67 | 20 74 6f 20 7a 65 72 6f |one flag| to zero|
|00001070| 20 7d 0d 0d 7b 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 20 4d 41 49 4e 20 |********|** MAIN |
|000010a0| 53 43 52 49 50 54 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |SCRIPT *|********|
|000010b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000010d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 49 46 20 47 |********|*}..IF G|
|000010e0| 45 54 5f 44 41 54 41 28 | 29 09 09 09 09 09 09 09 |ET_DATA(|).......|
|000010f0| 09 7b 20 52 75 6e 20 47 | 45 54 5f 44 41 54 41 20 |.{ Run G|ET_DATA |
|00001100| 66 75 6e 63 74 69 6f 6e | 20 7d 0d 09 43 41 4c 4c |function| }..CALL|
|00001110| 20 54 45 53 54 5f 44 41 | 54 41 28 29 09 09 09 09 | TEST_DA|TA()....|
|00001120| 09 09 7b 20 52 75 6e 20 | 54 45 53 54 5f 44 41 54 |..{ Run |TEST_DAT|
|00001130| 41 20 66 75 6e 63 74 69 | 6f 6e 20 7d 0d 09 49 46 |A functi|on }..IF|
|00001140| 20 64 6f 6e 65 20 3d 20 | 30 09 09 09 09 09 09 09 | done = |0.......|
|00001150| 7b 20 49 66 20 64 61 74 | 61 20 70 61 73 73 65 73 |{ If dat|a passes|
|00001160| 20 74 65 73 74 20 7d 0d | 09 09 43 41 4c 4c 20 43 | test }.|..CALL C|
|00001170| 52 45 41 54 45 5f 54 41 | 42 4c 45 28 29 09 09 09 |REATE_TA|BLE()...|
|00001180| 09 09 7b 20 52 75 6e 20 | 43 52 45 41 54 45 5f 54 |..{ Run |CREATE_T|
|00001190| 41 42 4c 45 20 66 75 6e | 63 74 69 6f 6e 20 7d 0d |ABLE fun|ction }.|
|000011a0| 09 09 43 41 4c 4c 20 43 | 41 4c 43 5f 44 55 52 41 |..CALL C|ALC_DURA|
|000011b0| 54 49 4f 4e 53 28 29 09 | 09 09 09 7b 20 52 75 6e |TIONS().|...{ Run|
|000011c0| 20 43 41 4c 43 5f 44 55 | 52 41 54 49 4f 4e 53 20 | CALC_DU|RATIONS |
|000011d0| 66 75 6e 63 74 69 6f 6e | 20 7d 0d 09 09 43 41 4c |function| }...CAL|
|000011e0| 4c 20 43 52 45 41 54 45 | 5f 46 4f 52 4d 55 4c 41 |L CREATE|_FORMULA|
|000011f0| 53 28 29 09 09 09 09 7b | 20 52 75 6e 20 43 52 45 |S()....{| Run CRE|
|00001200| 41 54 45 5f 46 4f 52 4d | 55 4c 41 53 20 66 75 6e |ATE_FORM|ULAS fun|
|00001210| 63 74 69 6f 6e 20 7d 0d | 09 09 43 41 4c 4c 20 43 |ction }.|..CALL C|
|00001220| 52 45 41 54 45 5f 57 4f | 52 4b 53 48 45 45 54 28 |REATE_WO|RKSHEET(|
|00001230| 29 09 09 09 09 7b 20 52 | 75 6e 20 43 52 45 41 54 |)....{ R|un CREAT|
|00001240| 45 5f 57 4f 52 4b 53 48 | 45 45 54 20 66 75 6e 63 |E_WORKSH|EET func|
|00001250| 74 69 6f 6e 20 7d 0d 09 | 09 43 41 4c 4c 20 43 52 |tion }..|.CALL CR|
|00001260| 45 41 54 45 5f 43 48 41 | 52 54 28 29 09 09 09 09 |EATE_CHA|RT()....|
|00001270| 09 7b 20 52 75 6e 20 43 | 52 45 41 54 45 5f 43 48 |.{ Run C|REATE_CH|
|00001280| 41 52 54 20 66 75 6e 63 | 74 69 6f 6e 20 7d 0d 09 |ART func|tion }..|
|00001290| 09 43 41 4c 4c 20 41 53 | 4b 5f 54 4f 5f 43 4f 50 |.CALL AS|K_TO_COP|
|000012a0| 59 28 29 09 09 09 09 09 | 7b 20 52 75 6e 20 41 53 |Y().....|{ Run AS|
|000012b0| 4b 5f 54 4f 5f 43 4f 50 | 59 20 66 75 6e 63 74 69 |K_TO_COP|Y functi|
|000012c0| 6f 6e 20 7d 0d 09 45 4e | 44 20 49 46 09 09 09 09 |on }..EN|D IF....|
|000012d0| 09 09 09 09 7b 20 45 6e | 64 20 6c 6f 67 69 63 61 |....{ En|d logica|
|000012e0| 6c 20 49 46 20 7d 0d 45 | 4e 44 20 49 46 0d 0d 7b |l IF }.E|ND IF..{|
|000012f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001310| 2a 2a 2a 2a 2a 20 47 45 | 54 5f 44 41 54 41 20 2a |***** GE|T_DATA *|
|00001320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001330| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001340| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001350| 2a 2a 2a 2a 2a 0d 20 20 | 54 68 69 73 20 66 75 6e |*****.  |This fun|
|00001360| 63 74 69 6f 6e 20 6f 70 | 65 6e 73 20 74 68 65 20 |ction op|ens the |
|00001370| 32 20 63 68 61 72 74 73 | 20 75 73 65 64 20 62 79 |2 charts| used by|
|00001380| 20 74 68 69 73 20 73 63 | 72 69 70 74 20 61 6e 64 | this sc|ript and|
|00001390| 20 65 78 74 72 61 63 74 | 73 20 74 68 65 20 64 61 | extract|s the da|
|000013a0| 74 61 20 66 72 6f 6d 20 | 74 68 65 6d 2e 0d 20 2a |ta from |them.. *|
|000013b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001400| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001410| 2a 2a 2a 7d 0d 0d 46 55 | 4e 43 54 49 4f 4e 20 47 |***}..FU|NCTION G|
|00001420| 45 54 5f 44 41 54 41 28 | 29 0d 09 52 45 50 41 49 |ET_DATA(|)..REPAI|
|00001430| 4e 54 20 4f 46 46 09 09 | 09 09 09 09 09 7b 20 54 |NT OFF..|.....{ T|
|00001440| 75 72 6e 20 52 65 70 61 | 69 6e 74 20 6f 66 66 20 |urn Repa|int off |
|00001450| 74 6f 20 73 70 65 65 64 | 20 75 70 20 6f 70 65 72 |to speed| up oper|
|00001460| 61 74 69 6f 6e 20 7d 0d | 09 4f 50 45 4e 20 22 4d |ation }.|.OPEN "M|
|00001470| 50 20 52 65 73 6f 75 72 | 63 65 20 54 61 62 6c 65 |P Resour|ce Table|
|00001480| 22 09 09 09 09 09 7b 20 | 4f 70 65 6e 20 52 65 73 |".....{ |Open Res|
|00001490| 6f 75 72 63 65 20 54 61 | 62 6c 65 20 74 6f 20 64 |ource Ta|ble to d|
|000014a0| 65 74 65 72 6d 69 6e 65 | 20 23 20 6f 66 20 72 65 |etermine| # of re|
|000014b0| 73 6f 75 72 63 65 73 20 | 7d 0d 09 49 46 20 43 45 |sources |}..IF CE|
|000014c0| 52 52 4f 52 28 29 20 3d | 20 30 09 09 09 09 09 09 |RROR() =| 0......|
|000014d0| 7b 20 43 68 65 63 6b 20 | 69 66 20 74 68 65 20 64 |{ Check |if the d|
|000014e0| 6f 63 75 6d 65 6e 74 20 | 77 61 73 20 66 6f 75 6e |ocument |was foun|
|000014f0| 64 20 7d 0d 09 09 6c 61 | 73 74 5f 52 54 5f 72 6f |d }...la|st_RT_ro|
|00001500| 77 20 3d 20 47 45 54 5f | 52 4f 57 53 28 29 20 20 |w = GET_|ROWS()  |
|00001510| 09 09 09 7b 20 44 65 74 | 65 72 6d 69 6e 65 20 23 |...{ Det|ermine #|
|00001520| 20 6f 66 20 72 6f 77 73 | 20 69 6e 20 74 68 65 20 | of rows| in the |
|00001530| 52 65 73 6f 75 72 63 65 | 20 54 61 62 6c 65 20 7d |Resource| Table }|
|00001540| 0d 09 09 43 4c 4f 53 45 | 20 4e 4f 57 09 09 09 09 |...CLOSE| NOW....|
|00001550| 09 09 09 7b 20 43 6c 6f | 73 65 20 52 65 73 6f 75 |...{ Clo|se Resou|
|00001560| 72 63 65 20 54 61 62 6c | 65 20 77 69 74 68 6f 75 |rce Tabl|e withou|
|00001570| 74 20 73 61 76 69 6e 67 | 20 7d 0d 09 09 4e 45 57 |t saving| }...NEW|
|00001580| 20 57 4f 52 4b 53 48 45 | 45 54 20 22 22 09 09 09 | WORKSHE|ET ""...|
|00001590| 09 09 7b 20 43 72 65 61 | 74 65 20 6e 65 77 20 75 |..{ Crea|te new u|
|000015a0| 6e 74 69 74 6c 65 64 20 | 77 6f 72 6b 73 68 65 65 |ntitled |workshee|
|000015b0| 74 20 7d 0d 09 09 53 45 | 4c 45 43 54 20 52 41 4e |t }...SE|LECT RAN|
|000015c0| 47 45 20 41 31 09 09 09 | 09 09 7b 20 4d 61 6b 65 |GE A1...|..{ Make|
|000015d0| 20 73 75 72 65 20 74 68 | 65 20 6e 65 78 74 20 6c | sure th|e next l|
|000015e0| 69 6e 65 20 70 75 74 73 | 20 74 68 65 20 69 6e 66 |ine puts| the inf|
|000015f0| 6f 20 69 6e 20 64 65 73 | 69 72 65 64 20 6c 6f 63 |o in des|ired loc|
|00001600| 61 74 69 6f 6e 20 7d 0d | 09 09 41 50 50 45 4e 44 |ation }.|..APPEND|
|00001610| 20 22 4d 50 20 50 72 6f | 6a 65 63 74 20 54 61 62 | "MP Pro|ject Tab|
|00001620| 6c 65 22 09 09 09 7b 20 | 41 70 70 65 6e 64 20 74 |le"...{ |Append t|
|00001630| 68 65 20 50 72 6f 6a 65 | 63 74 20 54 61 62 6c 65 |he Proje|ct Table|
|00001640| 20 64 6f 63 75 6d 65 6e | 74 20 7d 0d 09 09 49 46 | documen|t }...IF|
|00001650| 20 43 45 52 52 4f 52 28 | 29 20 3d 20 30 09 09 09 | CERROR(|) = 0...|
|00001660| 09 09 7b 20 43 68 65 63 | 6b 20 65 72 72 6f 72 20 |..{ Chec|k error |
|00001670| 72 65 74 75 72 6e 65 64 | 20 62 79 20 4f 50 45 4e |returned| by OPEN|
|00001680| 20 7d 0d 09 09 09 5a 4f | 4f 4d 20 57 49 4e 44 4f | }....ZO|OM WINDO|
|00001690| 57 09 09 09 09 09 7b 20 | 5a 6f 6f 6d 20 74 68 65 |W.....{ |Zoom the|
|000016a0| 20 77 69 6e 64 6f 77 20 | 74 6f 20 66 69 6c 6c 20 | window |to fill |
|000016b0| 74 68 65 20 73 63 72 65 | 65 6e 20 7d 09 09 09 0d |the scre|en }....|
|000016c0| 09 09 09 53 45 4c 45 43 | 54 20 52 41 4e 47 45 20 |...SELEC|T RANGE |
|000016d0| 41 31 2e 2e 41 56 4c 48 | 31 20 20 09 09 09 7b 20 |A1..AVLH|1  ...{ |
|000016e0| 53 65 6c 65 63 74 20 66 | 69 72 73 74 20 72 6f 77 |Select f|irst row|
|000016f0| 20 6f 66 20 50 72 6f 6a | 65 63 74 20 54 61 62 6c | of Proj|ect Tabl|
|00001700| 65 20 7d 0d 09 09 09 49 | 4e 53 45 52 54 09 09 09 |e }....I|NSERT...|
|00001710| 09 09 09 7b 20 49 6e 73 | 65 72 74 20 61 20 6e 65 |...{ Ins|ert a ne|
|00001720| 77 20 72 6f 77 20 7d 09 | 0d 09 09 09 6c 61 73 74 |w row }.|....last|
|00001730| 5f 50 54 5f 72 6f 77 20 | 3d 20 47 45 54 5f 52 4f |_PT_row |= GET_RO|
|00001740| 57 53 28 29 20 20 09 09 | 7b 20 44 65 74 65 72 6d |WS()  ..|{ Determ|
|00001750| 69 6e 65 20 23 20 6f 66 | 20 72 6f 77 73 20 69 6e |ine # of| rows in|
|00001760| 20 74 68 65 20 50 72 6f | 6a 65 63 74 20 54 61 62 | the Pro|ject Tab|
|00001770| 6c 65 20 43 68 61 72 74 | 20 7d 0d 09 09 09 53 45 |le Chart| }....SE|
|00001780| 4c 45 43 54 20 52 41 4e | 47 45 20 41 51 33 20 20 |LECT RAN|GE AQ3  |
|00001790| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 63 65 6c |....{ Se|lect cel|
|000017a0| 6c 20 41 51 33 20 7d 0d | 09 09 09 41 50 50 45 4e |l AQ3 }.|...APPEN|
|000017b0| 44 20 22 4d 50 20 52 65 | 73 6f 75 72 63 65 20 54 |D "MP Re|source T|
|000017c0| 61 62 6c 65 22 09 09 7b | 20 41 70 70 65 6e 64 20 |able"..{| Append |
|000017d0| 74 68 65 20 52 65 73 6f | 75 72 63 65 20 54 61 62 |the Reso|urce Tab|
|000017e0| 6c 65 20 64 6f 63 75 6d | 65 6e 74 20 7d 0d 09 09 |le docum|ent }...|
|000017f0| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 20 41 52 |.SELECT |RANGE AR|
|00001800| 31 2e 2e 41 52 33 32 37 | 36 38 09 09 7b 20 53 65 |1..AR327|68..{ Se|
|00001810| 6c 65 63 74 20 63 6f 6c | 75 6d 6e 20 41 52 20 7d |lect col|umn AR }|
|00001820| 0d 09 09 09 49 4e 53 45 | 52 54 09 09 09 09 09 09 |....INSE|RT......|
|00001830| 7b 20 49 6e 73 65 72 74 | 20 61 20 6e 65 77 20 63 |{ Insert| a new c|
|00001840| 6f 6c 75 6d 6e 20 7d 0d | 09 09 09 53 45 4c 45 43 |olumn }.|...SELEC|
|00001850| 54 20 52 41 4e 47 45 20 | 41 54 31 2e 2e 41 56 33 |T RANGE |AT1..AV3|
|00001860| 32 37 36 38 09 09 7b 20 | 53 65 6c 65 63 74 20 65 |2768..{ |Select e|
|00001870| 78 74 72 61 20 75 6e 77 | 61 6e 74 65 64 20 52 65 |xtra unw|anted Re|
|00001880| 73 6f 75 72 63 65 20 54 | 61 62 6c 65 20 63 6f 6c |source T|able col|
|00001890| 75 6d 6e 73 20 7d 0d 09 | 09 09 52 45 4d 4f 56 45 |umns }..|..REMOVE|
|000018a0| 20 44 41 54 41 20 41 4e | 44 20 4f 42 4a 45 43 54 | DATA AN|D OBJECT|
|000018b0| 53 09 09 09 7b 20 44 65 | 6c 65 74 65 20 61 6c 6c |S...{ De|lete all|
|000018c0| 20 74 68 65 20 64 61 74 | 61 20 7d 0d 09 09 09 52 | the dat|a }....R|
|000018d0| 45 54 55 52 4e 20 31 09 | 09 09 09 09 09 7b 20 52 |ETURN 1.|.....{ R|
|000018e0| 65 74 75 72 6e 20 76 61 | 6c 75 65 20 69 6e 64 69 |eturn va|lue indi|
|000018f0| 63 61 74 69 6e 67 20 73 | 63 72 69 70 74 20 73 68 |cating s|cript sh|
|00001900| 6f 75 6c 64 20 63 6f 6e | 74 69 6e 75 65 20 7d 0d |ould con|tinue }.|
|00001910| 09 09 45 4c 53 45 0d 09 | 09 09 43 4c 4f 53 45 20 |..ELSE..|..CLOSE |
|00001920| 4e 4f 57 09 09 09 09 09 | 09 7b 20 43 6c 6f 73 65 |NOW.....|.{ Close|
|00001930| 20 74 68 65 20 6e 65 77 | 20 77 6f 72 6b 73 68 65 | the new| workshe|
|00001940| 65 74 20 77 69 74 68 6f | 75 74 20 73 61 76 69 6e |et witho|ut savin|
|00001950| 67 20 7d 0d 09 09 09 52 | 45 54 55 52 4e 20 30 09 |g }....R|ETURN 0.|
|00001960| 09 09 09 09 09 7b 20 52 | 65 74 75 72 6e 20 76 61 |.....{ R|eturn va|
|00001970| 6c 75 65 20 69 6e 64 69 | 63 61 74 69 6e 67 20 74 |lue indi|cating t|
|00001980| 68 65 20 73 63 72 69 70 | 74 20 73 68 6f 75 6c 64 |he scrip|t should|
|00001990| 20 62 65 20 73 74 6f 70 | 70 65 64 20 7d 0d 09 09 | be stop|ped }...|
|000019a0| 45 4e 44 20 49 46 0d 09 | 45 4c 53 45 0d 09 09 52 |END IF..|ELSE...R|
|000019b0| 45 54 55 52 4e 20 30 09 | 09 09 09 09 09 09 7b 20 |ETURN 0.|......{ |
|000019c0| 52 65 74 75 72 6e 20 76 | 61 6c 75 65 20 69 6e 64 |Return v|alue ind|
|000019d0| 69 63 61 74 69 6e 67 20 | 73 63 72 69 70 74 20 73 |icating |script s|
|000019e0| 68 6f 75 6c 64 20 73 74 | 6f 70 20 7d 0d 09 45 4e |hould st|op }..EN|
|000019f0| 44 20 49 46 0d 45 4e 44 | 20 46 55 4e 43 54 49 4f |D IF.END| FUNCTIO|
|00001a00| 4e 0d 0d 7b 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |N..{****|********|
|00001a10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001a20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 47 45 54 5f 52 4f |********|* GET_RO|
|00001a30| 57 53 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |WS *****|********|
|00001a40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001a50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001a60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 20 20 54 68 69 73 |********|*.  This|
|00001a70| 20 66 75 6e 63 74 69 6f | 6e 20 64 65 74 65 72 6d | functio|n determ|
|00001a80| 69 6e 65 73 20 74 68 65 | 20 6e 75 6d 62 65 72 20 |ines the| number |
|00001a90| 6f 66 20 72 6f 77 73 20 | 75 73 65 64 20 6f 6e 20 |of rows |used on |
|00001aa0| 61 20 63 68 61 72 74 2e | 20 20 57 65 20 66 69 72 |a chart.|  We fir|
|00001ab0| 73 74 20 73 65 6c 65 63 | 74 20 61 6c 6c 20 61 63 |st selec|t all ac|
|00001ac0| 74 69 76 65 20 63 65 6c | 6c 73 2e 0d 20 20 57 65 |tive cel|ls..  We|
|00001ad0| 20 74 68 65 6e 20 75 73 | 65 20 74 68 65 20 53 45 | then us|e the SE|
|00001ae0| 4c 45 43 54 49 4f 4e 20 | 66 75 6e 63 74 69 6f 6e |LECTION |function|
|00001af0| 20 74 6f 20 72 65 74 75 | 72 6e 20 74 68 65 20 72 | to retu|rn the r|
|00001b00| 61 6e 67 65 20 61 6e 64 | 20 74 68 65 20 52 4f 57 |ange and| the ROW|
|00001b10| 53 20 66 75 6e 63 74 69 | 6f 6e 20 74 6f 20 67 65 |S functi|on to ge|
|00001b20| 74 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 66 0d |t the nu|mber of.|
|00001b30| 20 20 72 6f 77 73 20 69 | 6e 20 74 68 61 74 20 72 |  rows i|n that r|
|00001b40| 61 6e 67 65 2e 20 20 54 | 68 65 20 72 65 73 75 6c |ange.  T|he resul|
|00001b50| 74 69 6e 67 20 76 61 6c | 75 65 20 69 73 20 74 68 |ting val|ue is th|
|00001b60| 65 6e 20 72 65 74 75 72 | 6e 65 64 20 74 6f 20 74 |en retur|ned to t|
|00001b70| 68 65 20 63 61 6c 6c 69 | 6e 67 20 73 74 61 74 65 |he calli|ng state|
|00001b80| 6d 65 6e 74 2e 0d 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ment.. *|********|
|00001b90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ba0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001bb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001bc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001bd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001be0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 7d 0d 0d 46 55 |********|***}..FU|
|00001bf0| 4e 43 54 49 4f 4e 20 47 | 45 54 5f 52 4f 57 53 28 |NCTION G|ET_ROWS(|
|00001c00| 29 0d 09 53 45 4c 45 43 | 54 20 41 43 54 49 56 45 |)..SELEC|T ACTIVE|
|00001c10| 20 43 45 4c 4c 53 09 09 | 09 09 09 09 7b 20 53 65 | CELLS..|....{ Se|
|00001c20| 6c 65 63 74 20 6e 6f 6e | 2d 62 6c 61 6e 6b 20 63 |lect non|-blank c|
|00001c30| 65 6c 6c 73 20 7d 0d 09 | 52 45 54 55 52 4e 20 52 |ells }..|RETURN R|
|00001c40| 4f 57 53 28 53 45 4c 45 | 43 54 49 4f 4e 28 31 29 |OWS(SELE|CTION(1)|
|00001c50| 29 09 09 09 09 7b 20 44 | 65 74 65 72 6d 69 6e 65 |)....{ D|etermine|
|00001c60| 20 23 20 6f 66 20 72 6f | 77 73 20 69 6e 20 73 65 | # of ro|ws in se|
|00001c70| 6c 65 63 74 65 64 20 72 | 61 6e 67 65 20 7d 0d 45 |lected r|ange }.E|
|00001c80| 4e 44 20 46 55 4e 43 54 | 49 4f 4e 0d 0d 7b 2a 2a |ND FUNCT|ION..{**|
|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 20 54 45 53 54 | 5f 44 41 54 41 20 2a 2a |*** TEST|_DATA **|
|00001cc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001cd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ce0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001cf0| 2a 2a 2a 0d 20 20 54 68 | 69 73 20 66 75 6e 63 74 |***.  Th|is funct|
|00001d00| 69 6f 6e 20 76 65 72 69 | 66 69 65 73 20 74 68 61 |ion veri|fies tha|
|00001d10| 74 20 73 6f 6d 65 20 72 | 65 73 6f 75 72 63 65 20 |t some r|esource |
|00001d20| 63 6f 73 74 73 20 68 61 | 76 65 20 62 65 65 6e 20 |costs ha|ve been |
|00001d30| 65 6e 74 65 72 65 64 2e | 20 20 49 66 20 74 68 65 |entered.|  If the|
|00001d40| 20 74 6f 74 61 6c 20 72 | 65 73 6f 75 72 63 65 20 | total r|esource |
|00001d50| 63 6f 73 74 20 69 73 0d | 20 20 65 71 75 61 6c 20 |cost is.|  equal |
|00001d60| 74 6f 20 7a 65 72 6f 2c | 20 69 74 20 77 69 6c 6c |to zero,| it will|
|00001d70| 20 64 69 73 70 6c 61 79 | 20 61 20 64 69 61 6c 6f | display| a dialo|
|00001d80| 67 20 62 6f 78 20 61 6e | 64 20 65 78 69 74 20 74 |g box an|d exit t|
|00001d90| 68 65 20 73 63 72 69 70 | 74 2e 0d 20 2a 2a 2a 2a |he scrip|t.. ****|
|00001da0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001db0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001dc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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| 7d 0d 0d 46 55 4e 43 54 | 49 4f 4e 20 54 45 53 54 |}..FUNCT|ION TEST|
|00001e10| 5f 44 41 54 41 28 29 0d | 09 44 45 46 49 4e 45 20 |_DATA().|.DEFINE |
|00001e20| 74 6f 74 61 6c 5f 63 6f | 73 74 09 09 09 09 09 09 |total_co|st......|
|00001e30| 7b 20 54 6f 74 61 6c 20 | 63 6f 73 74 20 61 63 63 |{ Total |cost acc|
|00001e40| 75 6d 75 6c 61 74 6f 72 | 20 7d 0d 09 74 6f 74 61 |umulator| }..tota|
|00001e50| 6c 5f 63 6f 73 74 20 3d | 20 30 09 09 09 09 09 09 |l_cost =| 0......|
|00001e60| 09 7b 20 53 65 74 20 74 | 6f 74 61 6c 5f 63 6f 73 |.{ Set t|otal_cos|
|00001e70| 74 20 74 6f 20 7a 65 72 | 6f 20 7d 0d 0d 09 46 4f |t to zer|o }...FO|
|00001e80| 52 20 4c 4f 4f 50 20 3d | 20 33 20 54 4f 20 6c 61 |R LOOP =| 3 TO la|
|00001e90| 73 74 5f 52 54 5f 72 6f | 77 2b 32 09 09 09 09 7b |st_RT_ro|w+2....{|
|00001ea0| 20 52 65 70 65 61 74 20 | 66 6f 72 20 61 6c 6c 20 | Repeat |for all |
|00001eb0| 64 61 74 61 20 72 6f 77 | 73 20 7d 0d 09 09 74 6f |data row|s }...to|
|00001ec0| 74 61 6c 5f 63 6f 73 74 | 20 3d 20 74 6f 74 61 6c |tal_cost| = total|
|00001ed0| 5f 63 6f 73 74 20 09 09 | 09 09 7b 20 74 6f 74 61 |_cost ..|..{ tota|
|00001ee0| 6c 5f 63 6f 73 74 20 3d | 20 74 6f 74 61 6c 5f 63 |l_cost =| total_c|
|00001ef0| 6f 73 74 20 2b 2e 2e 2e | 20 7d 0d 09 09 09 2b 20 |ost +...| }....+ |
|00001f00| 49 4e 44 49 52 45 43 54 | 28 4d 41 4b 45 43 45 4c |INDIRECT|(MAKECEL|
|00001f10| 4c 28 34 35 3b 6c 6f 6f | 70 29 29 09 09 7b 20 2e |L(45;loo|p))..{ .|
|00001f20| 2e 2e 74 68 65 20 64 61 | 74 61 20 69 6e 20 74 68 |..the da|ta in th|
|00001f30| 65 20 63 75 72 72 65 6e | 74 20 63 65 6c 6c 20 7d |e curren|t cell }|
|00001f40| 0d 09 45 4e 44 20 46 4f | 52 09 09 09 09 09 09 09 |..END FO|R.......|
|00001f50| 09 7b 20 45 6e 64 20 46 | 4f 52 20 6c 6f 6f 70 20 |.{ End F|OR loop |
|00001f60| 7d 0d 09 49 46 20 74 6f | 74 61 6c 5f 63 6f 73 74 |}..IF to|tal_cost|
|00001f70| 20 3c 3d 20 30 09 09 09 | 09 09 09 7b 20 49 66 20 | <= 0...|...{ If |
|00001f80| 74 68 65 20 74 6f 74 61 | 6c 20 63 6f 73 74 20 69 |the tota|l cost i|
|00001f90| 73 20 6c 65 73 73 20 74 | 68 61 6e 20 6f 72 20 65 |s less t|han or e|
|00001fa0| 71 75 61 6c 20 74 6f 20 | 7a 65 72 6f 20 7d 0d 09 |qual to |zero }..|
|00001fb0| 09 09 09 09 09 09 09 09 | 09 7b 20 44 69 73 70 6c |........|.{ Displ|
|00001fc0| 61 79 20 65 72 72 6f 72 | 20 6d 65 73 73 61 67 65 |ay error| message|
|00001fd0| 20 7d 0d 09 09 4d 45 53 | 53 41 47 45 20 22 4e 6f | }...MES|SAGE "No|
|00001fe0| 20 63 6f 73 74 20 69 6e | 66 6f 72 6d 61 74 69 6f | cost in|formatio|
|00001ff0| 6e 20 68 61 73 20 62 65 | 65 6e 20 65 6e 74 65 72 |n has be|en enter|
|00002000| 65 64 20 69 6e 20 74 68 | 65 20 52 65 73 6f 75 72 |ed in th|e Resour|
|00002010| 63 65 20 54 61 62 6c 65 | 2e 20 20 43 61 6e 6e 6f |ce Table|.  Canno|
|00002020| 74 20 63 72 65 61 74 65 | 20 74 68 65 20 67 72 61 |t create| the gra|
|00002030| 70 68 2e 22 20 0d 09 09 | 43 4c 4f 53 45 20 4e 4f |ph." ...|CLOSE NO|
|00002040| 57 09 09 09 09 09 09 09 | 7b 20 43 6c 6f 73 65 20 |W.......|{ Close |
|00002050| 50 72 6f 6a 65 63 74 20 | 54 61 62 6c 65 20 77 69 |Project |Table wi|
|00002060| 74 68 6f 75 74 20 73 61 | 76 69 6e 67 20 7d 0d 09 |thout sa|ving }..|
|00002070| 09 64 6f 6e 65 20 3d 20 | 31 09 09 09 09 09 09 09 |.done = |1.......|
|00002080| 7b 20 53 65 74 20 64 6f | 6e 65 20 66 6c 61 67 20 |{ Set do|ne flag |
|00002090| 74 6f 20 31 20 7d 0d 09 | 45 4e 44 20 49 46 09 09 |to 1 }..|END IF..|
|000020a0| 09 09 09 09 09 09 7b 20 | 45 6e 64 20 6c 6f 67 69 |......{ |End logi|
|000020b0| 63 61 6c 20 49 46 20 7d | 0d 45 4e 44 20 46 55 4e |cal IF }|.END FUN|
|000020c0| 43 54 49 4f 4e 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |CTION..{|********|
|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 20 43 52 |********|***** CR|
|000020f0| 45 41 54 45 5f 54 41 42 | 4c 45 20 2a 2a 2a 2a 2a |EATE_TAB|LE *****|
|00002100| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002110| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 20 20 |********|*****.  |
|00002130| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 63 72 |This fun|ction cr|
|00002140| 65 61 74 65 73 20 61 20 | 6e 65 77 20 74 61 62 6c |eates a |new tabl|
|00002150| 65 20 6f 6e 20 61 6e 20 | 61 76 61 69 6c 61 62 6c |e on an |availabl|
|00002160| 65 20 61 72 65 61 20 6f | 66 20 74 68 65 20 77 6f |e area o|f the wo|
|00002170| 72 6b 73 68 65 65 74 2e | 20 20 54 68 69 73 20 74 |rksheet.|  This t|
|00002180| 61 62 6c 65 20 77 69 6c | 6c 20 63 6f 6e 74 61 69 |able wil|l contai|
|00002190| 6e 0d 20 20 74 68 65 20 | 63 6f 73 74 20 69 6e 66 |n.  the |cost inf|
|000021a0| 6f 72 6d 61 74 69 6f 6e | 20 65 78 74 72 61 63 74 |ormation| extract|
|000021b0| 65 64 20 66 72 6f 6d 20 | 74 68 65 20 50 72 6f 6a |ed from |the Proj|
|000021c0| 65 63 74 20 54 61 62 6c | 65 2e 20 20 49 74 20 77 |ect Tabl|e.  It w|
|000021d0| 69 6c 6c 20 74 68 65 6e | 20 62 65 20 75 73 65 64 |ill then| be used|
|000021e0| 20 69 6e 20 74 68 65 20 | 63 72 65 61 74 69 6f 6e | in the |creation|
|000021f0| 20 6f 66 20 74 68 65 0d | 20 20 43 6f 73 74 20 62 | of the.|  Cost b|
|00002200| 79 20 52 65 73 6f 75 72 | 63 65 20 63 68 61 72 74 |y Resour|ce chart|
|00002210| 2e 0d 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.. *****|********|
|00002220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002240| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002250| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002260| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002270| 2a 2a 2a 2a 2a 2a 2a 7d | 0d 0d 46 55 4e 43 54 49 |*******}|..FUNCTI|
|00002280| 4f 4e 20 43 52 45 41 54 | 45 5f 54 41 42 4c 45 28 |ON CREAT|E_TABLE(|
|00002290| 29 0d 09 50 55 54 20 22 | 50 6c 61 6e 6e 65 64 20 |)..PUT "|Planned |
|000022a0| 43 6f 73 74 20 42 79 20 | 52 65 73 6f 75 72 63 65 |Cost By |Resource|
|000022b0| 20 2d 20 22 0d 09 09 26 | 41 44 41 54 45 28 4e 4f | - "...&|ADATE(NO|
|000022c0| 57 28 29 3b 22 6d 6d 2f | 64 64 2f 79 79 22 29 20 |W();"mm/|dd/yy") |
|000022d0| 49 4e 54 4f 20 41 51 31 | 09 09 7b 20 50 6c 61 63 |INTO AQ1|..{ Plac|
|000022e0| 65 20 43 68 61 72 74 20 | 54 69 74 6c 65 20 69 6e |e Chart |Title in|
|000022f0| 74 6f 20 63 65 6c 6c 20 | 41 51 31 20 7d 0d 09 50 |to cell |AQ1 }..P|
|00002300| 55 54 20 22 52 65 73 6f | 75 72 63 65 22 20 49 4e |UT "Reso|urce" IN|
|00002310| 54 4f 20 41 51 32 20 09 | 09 09 09 09 7b 20 50 6c |TO AQ2 .|....{ Pl|
|00002320| 61 63 65 20 68 65 61 64 | 69 6e 67 20 69 6e 74 6f |ace head|ing into|
|00002330| 20 63 65 6c 6c 20 41 51 | 32 20 7d 0d 09 50 55 54 | cell AQ|2 }..PUT|
|00002340| 20 22 54 6f 74 61 6c 20 | 43 6f 73 74 22 20 49 4e | "Total |Cost" IN|
|00002350| 54 4f 20 41 52 32 20 09 | 09 09 09 7b 20 50 6c 61 |TO AR2 .|...{ Pla|
|00002360| 63 65 20 68 65 61 64 69 | 6e 67 20 69 6e 74 6f 20 |ce headi|ng into |
|00002370| 63 65 6c 6c 20 41 52 32 | 20 7d 0d 09 50 55 54 20 |cell AR2| }..PUT |
|00002380| 22 55 6e 69 74 20 43 6f | 73 74 22 20 49 4e 54 4f |"Unit Co|st" INTO|
|00002390| 20 41 53 32 20 09 09 09 | 09 7b 20 50 6c 61 63 65 | AS2 ...|.{ Place|
|000023a0| 20 68 65 61 64 69 6e 67 | 20 69 6e 74 6f 20 63 65 | heading| into ce|
|000023b0| 6c 6c 20 41 53 32 20 7d | 0d 09 50 55 54 20 22 44 |ll AS2 }|..PUT "D|
|000023c0| 75 72 61 74 69 6f 6e 22 | 20 49 4e 54 4f 20 41 54 |uration"| INTO AT|
|000023d0| 32 20 09 09 09 09 09 7b | 20 50 6c 61 63 65 20 68 |2 .....{| Place h|
|000023e0| 65 61 64 69 6e 67 20 69 | 6e 74 6f 20 63 65 6c 6c |eading i|nto cell|
|000023f0| 20 41 54 32 20 7d 0d 09 | 46 4f 52 20 6c 6f 6f 70 | AT2 }..|FOR loop|
|00002400| 20 3d 20 33 20 54 4f 20 | 6c 61 73 74 5f 52 54 5f | = 3 TO |last_RT_|
|00002410| 72 6f 77 2b 32 09 09 09 | 09 7b 20 52 65 70 65 61 |row+2...|.{ Repea|
|00002420| 74 20 66 6f 72 20 65 61 | 63 68 20 72 6f 77 20 7d |t for ea|ch row }|
|00002430| 0d 09 09 50 55 54 20 30 | 20 69 6e 74 6f 20 52 41 |...PUT 0| into RA|
|00002440| 4e 47 45 28 4d 41 4b 45 | 43 45 4c 4c 28 34 36 3b |NGE(MAKE|CELL(46;|
|00002450| 6c 6f 6f 70 29 29 09 7b | 20 50 75 74 20 61 20 30 |loop)).{| Put a 0|
|00002460| 20 69 6e 74 6f 20 74 68 | 65 20 73 65 6c 65 63 74 | into th|e select|
|00002470| 65 64 20 63 65 6c 6c 20 | 7d 0d 09 45 4e 44 20 46 |ed cell |}..END F|
|00002480| 4f 52 09 09 09 09 09 09 | 09 09 7b 20 45 6e 64 20 |OR......|..{ End |
|00002490| 72 65 70 65 61 74 65 64 | 20 73 65 63 74 69 6f 6e |repeated| section|
|000024a0| 20 7d 0d 45 4e 44 20 46 | 55 4e 43 54 49 4f 4e 0d | }.END F|UNCTION.|
|000024b0| 0d 7b 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.{******|********|
|000024c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000024d0| 2a 2a 2a 2a 2a 2a 2a 20 | 43 41 4c 43 5f 44 55 52 |******* |CALC_DUR|
|000024e0| 41 54 49 4f 4e 53 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ATIONS *|********|
|000024f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002500| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002510| 2a 2a 2a 2a 2a 2a 2a 0d | 20 20 54 68 69 73 20 66 |*******.|  This f|
|00002520| 75 6e 63 74 69 6f 6e 20 | 67 6f 65 73 20 74 68 72 |unction |goes thr|
|00002530| 6f 75 67 68 20 74 68 65 | 20 63 6f 6c 75 6d 6e 73 |ough the| columns|
|00002540| 20 69 6e 20 74 68 65 20 | 50 72 6f 6a 65 63 74 20 | in the |Project |
|00002550| 54 61 62 6c 65 20 74 68 | 61 74 20 63 6f 6e 74 61 |Table th|at conta|
|00002560| 69 6e 20 72 65 73 6f 75 | 72 63 65 20 6e 61 6d 65 |in resou|rce name|
|00002570| 73 2e 20 20 49 74 20 67 | 6f 65 73 0d 20 20 74 68 |s.  It g|oes.  th|
|00002580| 72 6f 75 67 68 20 61 6c | 6c 20 74 68 65 20 72 65 |rough al|l the re|
|00002590| 73 6f 75 72 63 65 73 20 | 69 6e 20 6f 75 72 20 6e |sources |in our n|
|000025a0| 65 77 20 74 61 62 6c 65 | 20 75 6e 74 69 6c 20 69 |ew table| until i|
|000025b0| 66 20 66 69 6e 64 73 20 | 61 20 6d 61 74 63 68 2e |f finds |a match.|
|000025c0| 20 20 57 68 65 6e 20 61 | 20 6d 61 74 63 68 20 69 |  When a| match i|
|000025d0| 73 20 66 6f 75 6e 64 2c | 20 69 74 20 61 64 64 73 |s found,| it adds|
|000025e0| 20 0d 20 20 74 68 65 20 | 57 6f 72 6b 2f 55 6e 69 | .  the |Work/Uni|
|000025f0| 74 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 66 6f |t inform|ation fo|
|00002600| 72 20 74 68 61 74 20 72 | 65 73 6f 75 72 63 65 20 |r that r|esource |
|00002610| 74 6f 20 74 68 65 20 65 | 78 69 73 74 69 6e 67 20 |to the e|xisting |
|00002620| 64 75 72 61 74 69 6f 6e | 20 76 61 6c 75 65 20 66 |duration| value f|
|00002630| 72 6f 6d 20 74 68 65 20 | 74 61 62 6c 65 20 61 6e |rom the |table an|
|00002640| 64 0d 20 20 75 70 64 61 | 74 65 73 20 74 68 65 20 |d.  upda|tes the |
|00002650| 74 61 62 6c 65 2e 0d 20 | 2a 2a 2a 2a 2a 2a 2a 2a |table.. |********|
|00002660| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 2a 2a |********|********|
|000026a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000026b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 46 |********|****}..F|
|000026c0| 55 4e 43 54 49 4f 4e 20 | 43 41 4c 43 5f 44 55 52 |UNCTION |CALC_DUR|
|000026d0| 41 54 49 4f 4e 53 28 29 | 0d 09 46 4f 52 20 63 75 |ATIONS()|..FOR cu|
|000026e0| 72 5f 63 6f 6c 20 3d 20 | 32 20 74 6f 20 34 31 20 |r_col = |2 to 41 |
|000026f0| 53 54 45 50 20 35 09 09 | 09 09 7b 20 52 65 70 65 |STEP 5..|..{ Repe|
|00002700| 61 74 20 66 6f 72 20 65 | 61 63 68 20 6f 66 20 74 |at for e|ach of t|
|00002710| 68 65 20 38 20 52 65 73 | 6f 75 72 63 65 20 63 6f |he 8 Res|ource co|
|00002720| 6c 75 6d 6e 73 20 7d 0d | 09 09 46 4f 52 20 63 75 |lumns }.|..FOR cu|
|00002730| 72 5f 72 6f 77 20 3d 20 | 32 20 74 6f 20 6c 61 73 |r_row = |2 to las|
|00002740| 74 5f 50 54 5f 72 6f 77 | 09 09 7b 20 52 65 70 65 |t_PT_row|..{ Repe|
|00002750| 61 74 20 66 6f 72 20 65 | 61 63 68 20 72 6f 77 20 |at for e|ach row |
|00002760| 6f 66 20 74 68 65 20 50 | 72 6f 6a 65 63 74 20 54 |of the P|roject T|
|00002770| 61 62 6c 65 20 7d 0d 09 | 09 09 63 75 72 72 65 6e |able }..|..curren|
|00002780| 74 5f 63 65 6c 6c 20 3d | 20 4d 41 4b 45 43 45 4c |t_cell =| MAKECEL|
|00002790| 4c 28 63 75 72 5f 63 6f | 6c 3b 63 75 72 5f 72 6f |L(cur_co|l;cur_ro|
|000027a0| 77 29 20 7b 20 44 65 74 | 65 72 6d 69 6e 65 20 63 |w) { Det|ermine c|
|000027b0| 75 72 72 65 6e 74 20 63 | 65 6c 6c 20 7d 0d 09 09 |urrent c|ell }...|
|000027c0| 09 49 46 20 20 4e 4f 54 | 20 49 53 42 4c 41 4e 4b |.IF  NOT| ISBLANK|
|000027d0| 28 52 41 4e 47 45 28 63 | 75 72 72 65 6e 74 5f 63 |(RANGE(c|urrent_c|
|000027e0| 65 6c 6c 29 29 20 7b 20 | 49 66 20 74 68 65 20 63 |ell)) { |If the c|
|000027f0| 75 72 72 65 6e 74 20 63 | 65 6c 6c 20 69 73 20 6e |urrent c|ell is n|
|00002800| 6f 74 20 62 6c 61 6e 6b | 20 7d 0d 09 09 09 09 46 |ot blank| }.....F|
|00002810| 4f 52 20 6c 6f 6f 70 20 | 3d 20 33 20 74 6f 20 6c |OR loop |= 3 to l|
|00002820| 61 73 74 5f 52 54 5f 52 | 6f 77 2b 32 09 7b 20 52 |ast_RT_R|ow+2.{ R|
|00002830| 65 70 65 61 74 20 66 6f | 72 20 65 61 63 68 20 72 |epeat fo|r each r|
|00002840| 6f 77 20 69 6e 20 6f 75 | 72 20 6e 65 77 20 74 61 |ow in ou|r new ta|
|00002850| 62 6c 65 20 7d 0d 09 09 | 09 09 09 43 41 4c 4c 20 |ble }...|...CALL |
|00002860| 41 44 44 5f 54 4f 5f 54 | 41 42 4c 45 28 29 09 09 |ADD_TO_T|ABLE()..|
|00002870| 7b 20 43 61 6c 6c 20 66 | 75 6e 63 74 69 6f 6e 20 |{ Call f|unction |
|00002880| 41 44 44 5f 54 4f 5f 54 | 41 42 4c 45 20 7d 0d 09 |ADD_TO_T|ABLE }..|
|00002890| 09 09 09 45 4e 44 20 46 | 4f 52 09 09 09 09 09 7b |...END F|OR.....{|
|000028a0| 20 45 6e 64 20 46 6f 72 | 20 6c 6f 6f 70 20 7d 0d | End For| loop }.|
|000028b0| 09 09 09 45 4e 44 20 49 | 46 09 09 09 09 09 09 7b |...END I|F......{|
|000028c0| 20 45 6e 64 20 6c 6f 67 | 69 63 61 6c 20 49 46 20 | End log|ical IF |
|000028d0| 7d 0d 09 09 45 4e 44 20 | 46 4f 52 09 09 09 09 09 |}...END |FOR.....|
|000028e0| 09 09 7b 20 45 6e 64 20 | 46 6f 72 20 6c 6f 6f 70 |..{ End |For loop|
|000028f0| 20 7d 0d 09 45 4e 44 20 | 46 4f 52 09 09 09 09 09 | }..END |FOR.....|
|00002900| 09 09 09 7b 20 45 6e 64 | 20 46 6f 72 20 6c 6f 6f |...{ End| For loo|
|00002910| 70 20 7d 0d 45 4e 44 20 | 46 55 4e 43 54 49 4f 4e |p }.END |FUNCTION|
|00002920| 0d 0d 7b 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |..{*****|********|
|00002930| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002940| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 41 44 44 5f 54 |********|** ADD_T|
|00002950| 4f 5f 54 41 42 4c 45 20 | 2a 2a 2a 2a 2a 2a 2a 2a |O_TABLE |********|
|00002960| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 | 0d 20 20 54 68 69 73 20 |********|.  This |
|00002990| 66 75 6e 63 74 69 6f 6e | 20 64 65 74 65 72 6d 69 |function| determi|
|000029a0| 6e 65 73 20 69 66 20 74 | 68 65 20 74 77 6f 20 72 |nes if t|he two r|
|000029b0| 65 73 6f 75 72 63 65 20 | 6e 61 6d 65 73 20 6d 61 |esource |names ma|
|000029c0| 74 63 68 2e 20 20 49 66 | 20 74 68 65 79 20 64 6f |tch.  If| they do|
|000029d0| 2c 20 69 74 20 69 6e 63 | 72 65 6d 65 6e 74 73 20 |, it inc|rements |
|000029e0| 74 68 65 20 64 75 72 61 | 74 69 6f 6e 0d 20 20 76 |the dura|tion.  v|
|000029f0| 61 6c 75 65 20 69 6e 20 | 74 68 65 20 74 61 62 6c |alue in |the tabl|
|00002a00| 65 20 62 79 20 74 68 65 | 20 61 6d 6f 75 6e 74 20 |e by the| amount |
|00002a10| 69 6e 20 74 68 65 20 50 | 72 6f 6a 65 63 74 20 54 |in the P|roject T|
|00002a20| 61 62 6c 65 2e 0d 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |able.. *|********|
|00002a30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002a40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002a50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002a60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002a70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002a80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 7d 0d 0d 46 55 |********|***}..FU|
|00002a90| 4e 43 54 49 4f 4e 20 41 | 44 44 5f 54 4f 5f 54 41 |NCTION A|DD_TO_TA|
|00002aa0| 42 4c 45 28 29 0d 09 44 | 45 46 49 4e 45 20 64 75 |BLE()..D|EFINE du|
|00002ab0| 72 61 74 69 6f 6e 09 09 | 09 09 09 09 09 09 20 20 |ration..|......  |
|00002ac0| 7b 20 54 65 6d 70 6f 72 | 61 72 79 20 64 75 72 61 |{ Tempor|ary dura|
|00002ad0| 74 69 6f 6e 20 7d 0d 0d | 09 49 46 20 49 4e 44 49 |tion }..|.IF INDI|
|00002ae0| 52 45 43 54 28 63 75 72 | 72 65 6e 74 5f 63 65 6c |RECT(cur|rent_cel|
|00002af0| 6c 29 20 3d 20 49 4e 44 | 49 52 45 43 54 28 4d 41 |l) = IND|IRECT(MA|
|00002b00| 4b 45 43 45 4c 4c 28 34 | 33 3b 6c 6f 6f 70 29 29 |KECELL(4|3;loop))|
|00002b10| 20 20 7b 20 44 6f 65 73 | 20 63 75 72 72 65 6e 74 |  { Does| current|
|00002b20| 20 63 65 6c 6c 20 6d 61 | 74 63 68 20 74 61 62 6c | cell ma|tch tabl|
|00002b30| 65 20 65 6e 74 72 79 3f | 20 7d 0d 09 09 64 75 72 |e entry?| }...dur|
|00002b40| 61 74 69 6f 6e 20 3d 20 | 49 4e 44 49 52 45 43 54 |ation = |INDIRECT|
|00002b50| 28 4d 41 4b 45 43 45 4c | 4c 28 63 75 72 5f 63 6f |(MAKECEL|L(cur_co|
|00002b60| 6c 2b 31 3b 63 75 72 5f | 72 6f 77 29 29 20 09 20 |l+1;cur_|row)) . |
|00002b70| 20 7b 20 47 65 74 20 62 | 6f 74 68 20 76 61 6c 75 | { Get b|oth valu|
|00002b80| 65 73 20 61 6e 64 20 61 | 64 64 20 74 68 65 6d 20 |es and a|dd them |
|00002b90| 7d 0d 09 09 09 2b 20 49 | 4e 44 49 52 45 43 54 28 |}....+ I|NDIRECT(|
|00002ba0| 4d 41 4b 45 43 45 4c 4c | 28 34 36 3b 6c 6f 6f 70 |MAKECELL|(46;loop|
|00002bb0| 29 29 0d 09 09 50 55 54 | 20 64 75 72 61 74 69 6f |))...PUT| duratio|
|00002bc0| 6e 20 49 4e 54 4f 20 4d | 41 4b 45 43 45 4c 4c 28 |n INTO M|AKECELL(|
|00002bd0| 34 36 3b 6c 6f 6f 70 29 | 09 09 09 20 20 7b 20 50 |46;loop)|...  { P|
|00002be0| 75 74 20 74 68 65 20 72 | 65 73 75 6c 74 20 62 61 |ut the r|esult ba|
|00002bf0| 63 6b 20 69 6e 74 6f 20 | 74 68 65 20 74 61 62 6c |ck into |the tabl|
|00002c00| 65 20 7d 0d 09 45 4e 44 | 20 49 46 09 09 09 09 09 |e }..END| IF.....|
|00002c10| 09 09 09 09 09 20 20 7b | 20 45 6e 64 20 6c 6f 67 |.....  {| End log|
|00002c20| 69 63 61 6c 20 49 46 20 | 7d 0d 45 4e 44 20 46 55 |ical IF |}.END FU|
|00002c30| 4e 43 54 49 4f 4e 0d 0d | 7b 2a 2a 2a 2a 2a 2a 2a |NCTION..|{*******|
|00002c40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 43 |********|****** C|
|00002c60| 52 45 41 54 45 5f 46 4f | 52 4d 55 4c 41 53 20 2a |REATE_FO|RMULAS *|
|00002c70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002c90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 0d 20 |********|******. |
|00002ca0| 20 54 68 69 73 20 66 75 | 6e 63 74 69 6f 6e 20 70 | This fu|nction p|
|00002cb0| 75 74 73 20 61 20 66 6f | 72 6d 75 6c 61 20 69 6e |uts a fo|rmula in|
|00002cc0| 74 6f 20 74 68 65 20 54 | 6f 74 61 6c 20 63 6f 6c |to the T|otal col|
|00002cd0| 75 6d 6e 20 6f 66 20 6f | 75 72 20 6e 65 77 20 74 |umn of o|ur new t|
|00002ce0| 61 62 6c 65 20 74 68 61 | 74 20 63 6f 6d 70 75 74 |able tha|t comput|
|00002cf0| 65 73 20 74 68 65 20 74 | 6f 74 61 6c 20 63 6f 73 |es the t|otal cos|
|00002d00| 74 20 66 6f 72 0d 20 20 | 65 61 63 68 20 72 65 73 |t for.  |each res|
|00002d10| 6f 75 72 63 65 2e 0d 20 | 2a 2a 2a 2a 2a 2a 2a 2a |ource.. |********|
|00002d20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 7d 0d 0d 46 |********|****}..F|
|00002d80| 55 4e 43 54 49 4f 4e 20 | 43 52 45 41 54 45 5f 46 |UNCTION |CREATE_F|
|00002d90| 4f 52 4d 55 4c 41 53 28 | 29 0d 09 44 45 46 49 4e |ORMULAS(|)..DEFIN|
|00002da0| 45 20 66 6f 72 6d 75 6c | 61 09 09 09 09 09 09 09 |E formul|a.......|
|00002db0| 09 7b 20 66 6f 72 6d 75 | 6c 61 20 76 61 72 69 61 |.{ formu|la varia|
|00002dc0| 62 6c 65 20 7d 0d 0d 09 | 46 4f 52 20 6c 6f 6f 70 |ble }...|FOR loop|
|00002dd0| 20 3d 20 33 20 54 4f 20 | 6c 61 73 74 5f 52 54 5f | = 3 TO |last_RT_|
|00002de0| 72 6f 77 2b 32 09 09 09 | 09 09 7b 20 52 65 70 65 |row+2...|..{ Repe|
|00002df0| 61 74 20 66 6f 72 20 65 | 61 63 68 20 72 6f 77 20 |at for e|ach row |
|00002e00| 69 6e 20 74 68 65 20 74 | 61 62 6c 65 20 7d 0d 09 |in the t|able }..|
|00002e10| 09 66 6f 72 6d 75 6c 61 | 20 3d 20 22 3d 22 26 4d |.formula| = "="&M|
|00002e20| 41 4b 45 43 45 4c 4c 28 | 34 36 3b 6c 6f 6f 70 29 |AKECELL(|46;loop)|
|00002e30| 26 22 2a 22 26 4d 41 4b | 45 43 45 4c 4c 28 34 35 |&"*"&MAK|ECELL(45|
|00002e40| 3b 6c 6f 6f 70 29 20 7b | 20 43 61 6c 63 75 6c 61 |;loop) {| Calcula|
|00002e50| 74 65 20 74 68 65 20 63 | 6f 72 72 65 63 74 20 66 |te the c|orrect f|
|00002e60| 6f 72 6d 75 6c 61 20 62 | 79 20 70 6f 73 69 74 69 |ormula b|y positi|
|00002e70| 6f 6e 20 7d 0d 09 09 50 | 55 54 20 66 6f 72 6d 75 |on }...P|UT formu|
|00002e80| 6c 61 20 49 4e 54 4f 20 | 52 41 4e 47 45 28 4d 41 |la INTO |RANGE(MA|
|00002e90| 4b 45 43 45 4c 4c 28 34 | 34 3b 6c 6f 6f 70 29 29 |KECELL(4|4;loop))|
|00002ea0| 09 7b 20 20 61 6e 64 20 | 70 75 74 20 69 74 20 69 |.{  and |put it i|
|00002eb0| 6e 74 6f 20 74 68 65 20 | 63 75 72 72 65 6e 74 20 |nto the |current |
|00002ec0| 63 65 6c 6c 20 7d 09 09 | 0d 09 45 4e 44 20 46 4f |cell }..|..END FO|
|00002ed0| 52 09 09 09 09 09 09 09 | 09 09 7b 20 45 6e 64 20 |R.......|..{ End |
|00002ee0| 46 6f 72 20 6c 6f 6f 70 | 20 7d 0d 45 4e 44 20 46 |For loop| }.END F|
|00002ef0| 55 4e 43 54 49 4f 4e 0d | 0d 7b 2a 2a 2a 2a 2a 2a |UNCTION.|.{******|
|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 20 |********|******* |
|00002f20| 43 52 45 41 54 45 5f 57 | 4f 52 4b 53 48 45 45 54 |CREATE_W|ORKSHEET|
|00002f30| 20 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 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00002f60| 20 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |  This f|unction |
|00002f70| 63 72 65 61 74 65 73 20 | 61 20 6e 65 77 20 77 6f |creates |a new wo|
|00002f80| 72 6b 73 68 65 65 74 20 | 61 6e 64 20 70 61 73 74 |rksheet |and past|
|00002f90| 65 73 20 69 6e 20 74 68 | 65 20 74 61 62 6c 65 20 |es in th|e table |
|00002fa0| 63 72 65 61 74 65 64 20 | 6f 6e 20 74 68 65 20 50 |created |on the P|
|00002fb0| 72 6f 6a 65 63 74 20 54 | 61 62 6c 65 2e 20 20 54 |roject T|able.  T|
|00002fc0| 68 69 73 0d 20 20 77 61 | 73 20 64 6f 6e 65 20 74 |his.  wa|s done t|
|00002fd0| 6f 20 65 6c 69 6d 69 6e | 61 74 65 20 63 6c 75 74 |o elimin|ate clut|
|00002fe0| 74 65 72 20 6f 6e 20 74 | 68 65 20 6f 72 69 67 69 |ter on t|he origi|
|00002ff0| 6e 61 6c 20 77 6f 72 6b | 73 68 65 65 74 2e 0d 20 |nal work|sheet.. |
|00003000| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003010| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003020| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003030| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003040| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003050| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003060| 2a 2a 2a 2a 7d 0d 0d 46 | 55 4e 43 54 49 4f 4e 20 |****}..F|UNCTION |
|00003070| 43 52 45 41 54 45 5f 57 | 4f 52 4b 53 48 45 45 54 |CREATE_W|ORKSHEET|
|00003080| 28 29 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 |()..SELE|CT RANGE|
|00003090| 28 4d 41 4b 45 52 41 4e | 47 45 28 34 33 3b 31 3b |(MAKERAN|GE(43;1;|
|000030a0| 34 36 3b 6c 61 73 74 5f | 52 54 5f 72 6f 77 2b 32 |46;last_|RT_row+2|
|000030b0| 29 29 20 7b 20 53 65 6c | 65 63 74 20 65 6e 74 69 |)) { Sel|ect enti|
|000030c0| 72 65 20 64 61 74 61 20 | 72 61 6e 67 65 20 7d 0d |re data |range }.|
|000030d0| 09 43 4f 50 59 09 09 09 | 09 09 09 09 09 09 7b 20 |.COPY...|......{ |
|000030e0| 43 6f 70 79 20 74 68 65 | 20 73 65 6c 65 63 74 65 |Copy the| selecte|
|000030f0| 64 20 72 61 6e 67 65 20 | 7d 0d 09 43 4c 4f 53 45 |d range |}..CLOSE|
|00003100| 20 4e 4f 57 09 09 09 09 | 09 09 09 09 7b 20 43 6c | NOW....|....{ Cl|
|00003110| 6f 73 65 20 50 72 6f 6a | 65 63 74 20 54 61 62 6c |ose Proj|ect Tabl|
|00003120| 65 20 77 69 74 68 6f 75 | 74 20 73 61 76 69 6e 67 |e withou|t saving|
|00003130| 20 7d 0d 09 4e 45 57 20 | 57 4f 52 4b 53 48 45 45 | }..NEW |WORKSHEE|
|00003140| 54 20 22 22 09 09 09 09 | 09 09 7b 20 43 72 65 61 |T ""....|..{ Crea|
|00003150| 74 65 20 6e 65 77 20 77 | 6f 72 6b 73 68 65 65 74 |te new w|orksheet|
|00003160| 20 7d 0d 09 5a 4f 4f 4d | 20 57 49 4e 44 4f 57 09 | }..ZOOM| WINDOW.|
|00003170| 09 09 09 09 09 09 7b 20 | 5a 6f 6f 6d 20 77 69 6e |......{ |Zoom win|
|00003180| 64 6f 77 20 74 6f 20 66 | 69 6c 6c 20 73 63 72 65 |dow to f|ill scre|
|00003190| 65 6e 20 7d 0d 09 48 49 | 44 45 20 48 45 41 44 49 |en }..HI|DE HEADI|
|000031a0| 4e 47 53 09 09 09 09 09 | 09 09 7b 20 48 69 64 65 |NGS.....|..{ Hide|
|000031b0| 20 63 6f 6c 75 6d 6e 20 | 61 6e 64 20 72 6f 77 20 | column |and row |
|000031c0| 68 65 61 64 69 6e 67 73 | 20 7d 0d 09 48 49 44 45 |headings| }..HIDE|
|000031d0| 20 54 4f 4f 4c 20 42 4f | 58 09 09 09 09 09 09 09 | TOOL BO|X.......|
|000031e0| 7b 20 48 69 64 65 20 74 | 6f 6f 6c 20 62 6f 78 20 |{ Hide t|ool box |
|000031f0| 7d 0d 09 48 49 44 45 20 | 45 4e 54 52 59 20 42 41 |}..HIDE |ENTRY BA|
|00003200| 52 09 09 09 09 09 09 09 | 7b 20 48 69 64 65 20 65 |R.......|{ Hide e|
|00003210| 6e 74 72 79 20 62 61 72 | 20 7d 0d 09 48 49 44 45 |ntry bar| }..HIDE|
|00003220| 20 43 45 4c 4c 20 47 52 | 49 44 09 09 09 09 09 09 | CELL GR|ID......|
|00003230| 09 7b 20 48 69 64 65 20 | 63 65 6c 6c 20 67 72 69 |.{ Hide |cell gri|
|00003240| 64 20 7d 09 0d 09 53 45 | 4c 45 43 54 20 52 41 4e |d }...SE|LECT RAN|
|00003250| 47 45 20 42 32 09 09 09 | 09 09 09 7b 20 53 65 6c |GE B2...|...{ Sel|
|00003260| 65 63 74 20 70 61 73 74 | 69 6e 67 20 70 6f 69 6e |ect past|ing poin|
|00003270| 74 20 7d 0d 09 50 41 53 | 54 45 09 09 09 09 09 09 |t }..PAS|TE......|
|00003280| 09 09 7b 20 50 61 73 74 | 65 20 74 68 65 20 63 68 |..{ Past|e the ch|
|00003290| 61 72 74 20 69 6e 74 6f | 20 6e 65 77 20 77 6f 72 |art into| new wor|
|000032a0| 6b 73 68 65 65 74 20 7d | 0d 09 53 45 4c 45 43 54 |ksheet }|..SELECT|
|000032b0| 20 52 41 4e 47 45 20 42 | 32 2e 2e 45 32 09 09 09 | RANGE B|2..E2...|
|000032c0| 09 09 09 7b 20 53 65 6c | 65 63 74 20 74 68 65 20 |...{ Sel|ect the |
|000032d0| 74 69 74 6c 65 20 72 61 | 6e 67 65 20 7d 0d 09 54 |title ra|nge }..T|
|000032e0| 45 58 54 20 53 49 5a 45 | 20 31 38 09 09 09 09 09 |EXT SIZE| 18.....|
|000032f0| 09 09 7b 20 53 65 74 20 | 74 65 78 74 20 73 69 7a |..{ Set |text siz|
|00003300| 65 20 74 6f 20 31 38 20 | 70 6f 69 6e 74 73 20 7d |e to 18 |points }|
|00003310| 0d 09 54 45 58 54 20 46 | 4f 4e 54 20 22 48 65 6c |..TEXT F|ONT "Hel|
|00003320| 76 65 74 69 63 61 22 09 | 09 09 09 09 7b 20 53 65 |vetica".|....{ Se|
|00003330| 74 20 66 6f 6e 74 20 74 | 6f 20 48 65 6c 76 65 74 |t font t|o Helvet|
|00003340| 69 63 61 20 7d 0d 09 54 | 45 58 54 20 53 54 59 4c |ica }..T|EXT STYL|
|00003350| 45 20 22 42 22 09 09 09 | 09 09 09 09 7b 20 53 65 |E "B"...|....{ Se|
|00003360| 74 20 74 65 78 74 20 73 | 74 79 6c 65 20 74 6f 20 |t text s|tyle to |
|00003370| 42 6f 6c 64 20 7d 0d 09 | 54 45 58 54 20 53 54 59 |Bold }..|TEXT STY|
|00003380| 4c 45 20 22 49 22 09 09 | 09 09 09 09 09 7b 20 53 |LE "I"..|.....{ S|
|00003390| 65 74 20 74 65 78 74 20 | 73 74 79 6c 65 20 74 6f |et text |style to|
|000033a0| 20 49 74 61 6c 69 63 20 | 7d 0d 09 43 4f 4c 55 4d | Italic |}..COLUM|
|000033b0| 4e 20 57 49 44 54 48 20 | 28 20 31 2e 35 20 49 4e |N WIDTH |( 1.5 IN|
|000033c0| 43 48 45 53 20 29 09 09 | 09 09 7b 20 53 65 74 20 |CHES )..|..{ Set |
|000033d0| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 77 69 64 74 68 |the colu|mn width|
|000033e0| 20 66 6f 72 20 61 6c 6c | 20 63 6f 6c 75 6d 6e 73 | for all| columns|
|000033f0| 20 7d 0d 09 52 4f 57 20 | 48 45 49 47 48 54 20 28 | }..ROW |HEIGHT (|
|00003400| 20 2e 35 20 49 4e 43 48 | 45 53 20 29 09 09 09 09 | .5 INCH|ES )....|
|00003410| 09 7b 20 49 6e 63 72 65 | 61 73 65 20 72 6f 77 20 |.{ Incre|ase row |
|00003420| 68 65 69 67 68 74 20 66 | 6f 72 20 74 69 74 6c 65 |height f|or title|
|00003430| 20 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 | }..SELE|CT RANGE|
|00003440| 20 42 33 2e 2e 45 33 09 | 09 09 09 09 09 7b 20 53 | B3..E3.|.....{ S|
|00003450| 65 6c 65 63 74 20 74 68 | 65 20 68 65 61 64 69 6e |elect th|e headin|
|00003460| 67 20 72 61 6e 67 65 20 | 7d 0d 09 54 45 58 54 20 |g range |}..TEXT |
|00003470| 53 49 5a 45 20 31 34 09 | 09 09 09 09 09 09 7b 20 |SIZE 14.|......{ |
|00003480| 53 65 74 20 74 65 78 74 | 20 73 69 7a 65 20 74 6f |Set text| size to|
|00003490| 20 31 34 20 70 6f 69 6e | 74 73 20 7d 0d 09 54 45 | 14 poin|ts }..TE|
|000034a0| 58 54 20 46 4f 4e 54 20 | 22 48 65 6c 76 65 74 69 |XT FONT |"Helveti|
|000034b0| 63 61 22 09 09 09 09 09 | 7b 20 53 65 74 20 66 6f |ca".....|{ Set fo|
|000034c0| 6e 74 20 74 6f 20 48 65 | 6c 76 65 74 69 63 61 20 |nt to He|lvetica |
|000034d0| 7d 0d 09 54 45 58 54 20 | 53 54 59 4c 45 20 22 42 |}..TEXT |STYLE "B|
|000034e0| 22 09 09 09 09 09 09 09 | 7b 20 53 65 74 20 74 65 |".......|{ Set te|
|000034f0| 78 74 20 73 74 79 6c 65 | 20 74 6f 20 42 6f 6c 64 |xt style| to Bold|
|00003500| 20 7d 0d 09 54 45 58 54 | 20 53 54 59 4c 45 20 22 | }..TEXT| STYLE "|
|00003510| 49 22 09 09 09 09 09 09 | 09 7b 20 53 65 74 20 74 |I"......|.{ Set t|
|00003520| 65 78 74 20 73 74 79 6c | 65 20 74 6f 20 49 74 61 |ext styl|e to Ita|
|00003530| 6c 69 63 20 7d 0d 09 43 | 45 4c 4c 20 42 4f 52 44 |lic }..C|ELL BORD|
|00003540| 45 52 20 22 4f 74 6c 62 | 72 22 09 09 09 09 09 09 |ER "Otlb|r"......|
|00003550| 7b 20 4f 75 74 6c 69 6e | 65 20 48 65 61 64 69 6e |{ Outlin|e Headin|
|00003560| 67 73 20 7d 0d 09 41 4c | 49 47 4e 20 43 45 4e 54 |gs }..AL|IGN CENT|
|00003570| 45 52 09 09 09 09 09 09 | 09 7b 20 43 65 6e 74 65 |ER......|.{ Cente|
|00003580| 72 20 68 65 61 64 69 6e | 67 73 20 77 69 74 68 69 |r headin|gs withi|
|00003590| 6e 20 63 6f 6c 75 6d 6e | 73 20 7d 0d 09 53 45 4c |n column|s }..SEL|
|000035a0| 45 43 54 20 52 41 4e 47 | 45 28 4d 41 4b 45 52 41 |ECT RANG|E(MAKERA|
|000035b0| 4e 47 45 28 32 3b 34 3b | 35 3b 6c 61 73 74 5f 52 |NGE(2;4;|5;last_R|
|000035c0| 54 5f 72 6f 77 2b 33 29 | 29 20 7b 20 53 65 6c 65 |T_row+3)|) { Sele|
|000035d0| 63 74 20 65 6e 74 69 72 | 65 20 64 61 74 61 20 72 |ct entir|e data r|
|000035e0| 61 6e 67 65 20 7d 0d 09 | 54 45 58 54 20 46 4f 4e |ange }..|TEXT FON|
|000035f0| 54 20 22 48 65 6c 76 65 | 74 69 63 61 22 09 09 09 |T "Helve|tica"...|
|00003600| 09 09 7b 20 53 65 74 20 | 66 6f 6e 74 20 74 6f 20 |..{ Set |font to |
|00003610| 48 65 6c 76 65 74 69 63 | 61 20 7d 0d 09 43 45 4c |Helvetic|a }..CEL|
|00003620| 4c 20 42 4f 52 44 45 52 | 20 22 54 4c 42 52 22 09 |L BORDER| "TLBR".|
|00003630| 09 09 09 09 09 7b 20 43 | 72 65 61 74 65 20 63 65 |.....{ C|reate ce|
|00003640| 6c 6c 20 67 72 69 64 20 | 66 6f 72 20 64 61 74 61 |ll grid |for data|
|00003650| 20 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 | }..SELE|CT RANGE|
|00003660| 28 4d 41 4b 45 52 41 4e | 47 45 28 33 3b 34 3b 34 |(MAKERAN|GE(3;4;4|
|00003670| 3b 6c 61 73 74 5f 52 54 | 5f 72 6f 77 2b 33 29 29 |;last_RT|_row+3))|
|00003680| 20 7b 20 53 65 6c 65 63 | 74 20 64 6f 6c 6c 61 72 | { Selec|t dollar|
|00003690| 20 72 61 6e 67 65 20 7d | 0d 09 46 4f 52 4d 41 54 | range }|..FORMAT|
|000036a0| 20 43 55 52 52 45 4e 43 | 59 09 09 09 09 09 09 7b | CURRENC|Y......{|
|000036b0| 20 46 6f 72 6d 61 74 20 | 61 73 20 63 75 72 72 65 | Format |as curre|
|000036c0| 6e 63 79 20 7d 0d 09 55 | 53 45 20 43 4f 4d 4d 41 |ncy }..U|SE COMMA|
|000036d0| 53 09 09 09 09 09 09 09 | 7b 20 46 6f 72 6d 61 74 |S.......|{ Format|
|000036e0| 20 77 69 74 68 20 63 6f | 6d 6d 61 73 20 7d 0d 09 | with co|mmas }..|
|000036f0| 43 4f 4c 55 4d 4e 20 57 | 49 44 54 48 20 52 41 4e |COLUMN W|IDTH RAN|
|00003700| 47 45 20 41 31 20 54 4f | 20 2e 31 32 35 20 49 4e |GE A1 TO| .125 IN|
|00003710| 43 48 09 09 09 7b 20 53 | 65 74 20 63 6f 6c 75 6d |CH...{ S|et colum|
|00003720| 6e 20 77 69 64 74 68 20 | 6f 66 20 61 64 6a 61 63 |n width |of adjac|
|00003730| 65 6e 74 20 63 6f 6c 75 | 6d 6e 20 7d 0d 09 52 4f |ent colu|mn }..RO|
|00003740| 57 20 48 45 49 47 48 54 | 20 52 41 4e 47 45 20 41 |W HEIGHT| RANGE A|
|00003750| 31 20 54 4f 20 2e 31 32 | 35 20 49 4e 43 48 09 09 |1 TO .12|5 INCH..|
|00003760| 09 7b 20 53 65 74 20 72 | 6f 77 20 68 65 69 67 68 |.{ Set r|ow heigh|
|00003770| 74 20 6f 66 20 61 64 6a | 61 63 65 6e 74 20 72 6f |t of adj|acent ro|
|00003780| 77 20 7d 0d 09 43 4f 4c | 55 4d 4e 20 57 49 44 54 |w }..COL|UMN WIDT|
|00003790| 48 20 52 41 4e 47 45 20 | 46 31 20 54 4f 20 2e 31 |H RANGE |F1 TO .1|
|000037a0| 32 35 20 49 4e 43 48 09 | 09 09 7b 20 53 65 74 20 |25 INCH.|..{ Set |
|000037b0| 63 6f 6c 75 6d 6e 20 77 | 69 64 74 68 20 6f 66 20 |column w|idth of |
|000037c0| 61 64 6a 61 63 65 6e 74 | 20 63 6f 6c 75 6d 6e 20 |adjacent| column |
|000037d0| 7d 0d 09 52 4f 57 20 48 | 45 49 47 48 54 20 52 41 |}..ROW H|EIGHT RA|
|000037e0| 4e 47 45 28 4d 41 4b 45 | 43 45 4c 4c 28 31 3b 6c |NGE(MAKE|CELL(1;l|
|000037f0| 61 73 74 5f 52 54 5f 72 | 6f 77 2b 34 29 29 20 54 |ast_RT_r|ow+4)) T|
|00003800| 4f 20 2e 31 32 35 20 49 | 4e 43 48 20 7b 20 53 65 |O .125 I|NCH { Se|
|00003810| 74 20 72 6f 77 20 68 65 | 69 67 68 74 20 6f 66 20 |t row he|ight of |
|00003820| 61 64 6a 61 63 65 6e 74 | 20 72 6f 77 20 7d 0d 45 |adjacent| row }.E|
|00003830| 4e 44 20 46 55 4e 43 54 | 49 4f 4e 0d 0d 7b 2a 2a |ND FUNCT|ION..{**|
|00003840| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003860| 2a 2a 2a 20 43 52 45 41 | 54 45 5f 43 48 41 52 54 |*** CREA|TE_CHART|
|00003870| 20 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 2a 2a 2a 2a |********|********|
|00003890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000038a0| 2a 2a 2a 0d 20 20 54 68 | 69 73 20 66 75 6e 63 74 |***.  Th|is funct|
|000038b0| 69 6f 6e 20 63 72 65 61 | 74 65 73 20 61 20 63 68 |ion crea|tes a ch|
|000038c0| 61 72 74 20 62 61 73 65 | 64 20 6f 6e 20 74 68 65 |art base|d on the|
|000038d0| 20 6e 65 77 20 74 61 62 | 6c 65 20 77 65 20 68 61 | new tab|le we ha|
|000038e0| 76 65 20 63 72 65 61 74 | 65 64 2e 20 20 53 69 6e |ve creat|ed.  Sin|
|000038f0| 63 65 20 74 68 69 73 20 | 63 68 61 72 74 20 6f 6e |ce this |chart on|
|00003900| 6c 79 20 68 61 73 0d 20 | 20 6f 6e 65 20 73 65 72 |ly has. | one ser|
|00003910| 69 65 73 2c 20 77 65 20 | 77 69 6c 6c 20 68 69 64 |ies, we |will hid|
|00003920| 65 20 74 68 65 20 4c 65 | 67 65 6e 64 20 69 6e 20 |e the Le|gend in |
|00003930| 6f 72 64 65 72 20 74 6f | 20 61 6c 6c 6f 77 20 66 |order to| allow f|
|00003940| 6f 72 20 6d 6f 72 65 20 | 72 6f 6f 6d 20 6f 6e 20 |or more |room on |
|00003950| 74 68 65 20 63 68 61 72 | 74 2e 0d 20 2a 2a 2a 2a |the char|t.. ****|
|00003960| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003970| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003980| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003990| 2a 2a 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| 7d 0d 0d 46 55 4e 43 54 | 49 4f 4e 20 43 52 45 41 |}..FUNCT|ION CREA|
|000039d0| 54 45 5f 43 48 41 52 54 | 28 29 0d 09 41 64 64 20 |TE_CHART|()..Add |
|000039e0| 43 68 61 72 74 20 52 61 | 6e 67 65 20 66 72 61 63 |Chart Ra|nge frac|
|000039f0| 28 48 31 2e 2e 4e 32 30 | 3b 31 3b 30 3b 37 38 3b |(H1..N20|;1;0;78;|
|00003a00| 31 32 36 29 20 20 09 7b | 20 43 72 65 61 74 65 20 |126)  .{| Create |
|00003a10| 63 68 61 72 74 20 75 73 | 69 6e 67 20 6f 75 72 20 |chart us|ing our |
|00003a20| 6e 65 77 20 74 61 62 6c | 65 20 7d 0d 09 09 55 73 |new tabl|e }...Us|
|00003a30| 69 6e 67 20 52 41 4e 47 | 45 28 4d 41 4b 45 52 41 |ing RANG|E(MAKERA|
|00003a40| 4e 47 45 28 32 3b 33 3b | 33 3b 6c 61 73 74 5f 52 |NGE(2;3;|3;last_R|
|00003a50| 54 5f 72 6f 77 2b 33 29 | 29 0d 09 53 45 4c 45 43 |T_row+3)|)..SELEC|
|00003a60| 54 20 4f 42 4a 45 43 54 | 20 31 09 09 09 09 09 09 |T OBJECT| 1......|
|00003a70| 7b 20 53 65 6c 65 63 74 | 20 74 68 65 20 63 68 61 |{ Select| the cha|
|00003a80| 72 74 20 7d 0d 09 42 41 | 52 09 09 09 09 09 09 09 |rt }..BA|R.......|
|00003a90| 09 09 7b 20 53 65 74 20 | 63 68 61 72 74 20 74 79 |..{ Set |chart ty|
|00003aa0| 70 65 20 74 6f 20 42 61 | 72 20 7d 0d 09 56 45 52 |pe to Ba|r }..VER|
|00003ab0| 54 49 43 41 4c 20 43 48 | 41 52 54 20 50 41 52 53 |TICAL CH|ART PARS|
|00003ac0| 49 4e 47 09 09 09 09 09 | 7b 20 53 65 74 20 63 68 |ING.....|{ Set ch|
|00003ad0| 61 72 74 20 70 61 72 73 | 69 6e 67 20 74 6f 20 76 |art pars|ing to v|
|00003ae0| 65 72 74 69 63 61 6c 20 | 7d 0d 09 53 45 4c 45 43 |ertical |}..SELEC|
|00003af0| 54 20 43 48 41 52 54 20 | 31 20 41 58 49 53 20 31 |T CHART |1 AXIS 1|
|00003b00| 09 09 09 09 09 7b 20 53 | 65 6c 65 63 74 20 74 68 |.....{ S|elect th|
|00003b10| 65 20 78 2d 61 78 69 73 | 20 7d 0d 09 49 46 20 6c |e x-axis| }..IF l|
|00003b20| 61 73 74 5f 52 54 5f 72 | 6f 77 20 3e 20 32 30 09 |ast_RT_r|ow > 20.|
|00003b30| 09 09 09 09 09 7b 20 49 | 66 20 74 68 65 72 65 20 |.....{ I|f there |
|00003b40| 61 72 65 20 74 6f 6f 20 | 6d 61 6e 79 20 68 61 73 |are too |many has|
|00003b50| 68 20 6d 61 72 6b 73 20 | 6f 6e 20 74 68 65 2e 2e |h marks |on the..|
|00003b60| 2e 7d 0d 09 09 48 49 44 | 45 20 41 58 49 53 20 48 |.}...HID|E AXIS H|
|00003b70| 41 53 48 09 09 09 09 09 | 09 7b 20 2e 2e 2e 58 2d |ASH.....|.{ ...X-|
|00003b80| 61 78 69 73 2c 20 68 69 | 64 65 20 74 68 65 6d 20 |axis, hi|de them |
|00003b90| 64 75 65 20 74 6f 20 63 | 72 6f 77 64 69 6e 67 20 |due to c|rowding |
|00003ba0| 7d 0d 09 45 4e 44 20 49 | 46 0d 09 41 58 49 53 20 |}..END I|F..AXIS |
|00003bb0| 4d 41 4a 4f 52 20 47 52 | 49 44 20 46 47 20 30 09 |MAJOR GR|ID FG 0.|
|00003bc0| 09 09 09 09 7b 20 44 65 | 66 69 6e 65 20 4d 61 6a |....{ De|fine Maj|
|00003bd0| 6f 72 20 47 72 69 64 20 | 66 6f 72 65 67 72 6f 75 |or Grid |foregrou|
|00003be0| 6e 64 20 63 6f 6c 6f 72 | 20 7d 0d 09 41 58 49 53 |nd color| }..AXIS|
|00003bf0| 20 4d 41 4a 4f 52 20 47 | 52 49 44 20 42 47 20 31 | MAJOR G|RID BG 1|
|00003c00| 36 37 37 37 32 31 35 09 | 09 09 09 7b 20 44 65 66 |6777215.|...{ Def|
|00003c10| 69 6e 65 20 4d 61 6a 6f | 72 20 47 72 69 64 20 62 |ine Majo|r Grid b|
|00003c20| 61 63 6b 67 72 6f 75 6e | 64 20 63 6f 6c 6f 72 20 |ackgroun|d color |
|00003c30| 7d 0d 09 41 58 49 53 20 | 4d 41 4a 4f 52 20 47 52 |}..AXIS |MAJOR GR|
|00003c40| 49 44 20 50 41 54 54 45 | 52 4e 20 30 09 09 09 09 |ID PATTE|RN 0....|
|00003c50| 7b 20 44 65 66 69 6e 65 | 20 4d 61 6a 6f 72 20 47 |{ Define| Major G|
|00003c60| 72 69 64 20 70 61 74 74 | 65 72 6e 20 7d 0d 09 41 |rid patt|ern }..A|
|00003c70| 58 49 53 20 4d 41 4a 4f | 52 20 47 52 49 44 20 57 |XIS MAJO|R GRID W|
|00003c80| 49 44 54 48 20 35 09 09 | 09 09 09 7b 20 44 65 66 |IDTH 5..|...{ Def|
|00003c90| 69 6e 65 20 4d 61 6a 6f | 72 20 47 72 69 64 20 77 |ine Majo|r Grid w|
|00003ca0| 69 64 74 68 20 7d 0d 09 | 41 58 49 53 20 4d 49 4e |idth }..|AXIS MIN|
|00003cb0| 4f 52 20 47 52 49 44 20 | 46 47 20 31 32 33 30 33 |OR GRID |FG 12303|
|00003cc0| 32 39 31 09 09 09 09 7b | 20 44 65 66 69 6e 65 20 |291....{| Define |
|00003cd0| 4d 69 6e 6f 72 20 47 72 | 69 64 20 66 6f 72 65 67 |Minor Gr|id foreg|
|00003ce0| 72 6f 75 6e 64 20 63 6f | 6c 6f 72 20 7d 0d 09 41 |round co|lor }..A|
|00003cf0| 58 49 53 20 4d 49 4e 4f | 52 20 47 52 49 44 20 42 |XIS MINO|R GRID B|
|00003d00| 47 20 31 36 37 37 37 32 | 31 35 09 09 09 09 7b 20 |G 167772|15....{ |
|00003d10| 44 65 66 69 6e 65 20 4d | 69 6e 6f 72 20 47 72 69 |Define M|inor Gri|
|00003d20| 64 20 62 61 63 6b 67 72 | 6f 75 6e 64 20 63 6f 6c |d backgr|ound col|
|00003d30| 6f 72 20 7d 0d 09 41 58 | 49 53 20 4d 49 4e 4f 52 |or }..AX|IS MINOR|
|00003d40| 20 47 52 49 44 20 50 41 | 54 54 45 52 4e 20 30 09 | GRID PA|TTERN 0.|
|00003d50| 09 09 09 7b 20 44 65 66 | 69 6e 65 20 4d 69 6e 6f |...{ Def|ine Mino|
|00003d60| 72 20 47 72 69 64 20 70 | 61 74 74 65 72 6e 20 7d |r Grid p|attern }|
|00003d70| 0d 09 41 58 49 53 20 4d | 49 4e 4f 52 20 47 52 49 |..AXIS M|INOR GRI|
|00003d80| 44 20 57 49 44 54 48 20 | 30 09 09 09 09 09 7b 20 |D WIDTH |0.....{ |
|00003d90| 44 65 66 69 6e 65 20 4d | 69 6e 6f 72 20 47 72 69 |Define M|inor Gri|
|00003da0| 64 20 77 69 64 74 68 20 | 7d 0d 09 53 45 4c 45 43 |d width |}..SELEC|
|00003db0| 54 20 43 48 41 52 54 20 | 31 20 41 58 49 53 20 33 |T CHART |1 AXIS 3|
|00003dc0| 09 09 09 09 09 7b 20 53 | 65 6c 65 63 74 20 74 68 |.....{ S|elect th|
|00003dd0| 65 20 79 2d 61 78 69 73 | 20 7d 0d 09 41 58 49 53 |e y-axis| }..AXIS|
|00003de0| 20 4d 41 4a 4f 52 20 47 | 52 49 44 20 46 47 20 30 | MAJOR G|RID FG 0|
|00003df0| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 4d 61 |.....{ D|efine Ma|
|00003e00| 6a 6f 72 20 47 72 69 64 | 20 66 6f 72 65 67 72 6f |jor Grid| foregro|
|00003e10| 75 6e 64 20 63 6f 6c 6f | 72 20 7d 0d 09 41 58 49 |und colo|r }..AXI|
|00003e20| 53 20 4d 41 4a 4f 52 20 | 47 52 49 44 20 42 47 20 |S MAJOR |GRID BG |
|00003e30| 31 36 37 37 37 32 31 35 | 09 09 09 09 7b 20 44 65 |16777215|....{ De|
|00003e40| 66 69 6e 65 20 4d 61 6a | 6f 72 20 47 72 69 64 20 |fine Maj|or Grid |
|00003e50| 62 61 63 6b 67 72 6f 75 | 6e 64 20 63 6f 6c 6f 72 |backgrou|nd color|
|00003e60| 20 7d 0d 09 41 58 49 53 | 20 4d 41 4a 4f 52 20 47 | }..AXIS| MAJOR G|
|00003e70| 52 49 44 20 50 41 54 54 | 45 52 4e 20 31 09 09 09 |RID PATT|ERN 1...|
|00003e80| 09 7b 20 44 65 66 69 6e | 65 20 4d 61 6a 6f 72 20 |.{ Defin|e Major |
|00003e90| 47 72 69 64 20 70 61 74 | 74 65 72 6e 20 7d 0d 09 |Grid pat|tern }..|
|00003ea0| 41 58 49 53 20 4d 41 4a | 4f 52 20 47 52 49 44 20 |AXIS MAJ|OR GRID |
|00003eb0| 57 49 44 54 48 20 35 09 | 09 09 09 09 7b 20 44 65 |WIDTH 5.|....{ De|
|00003ec0| 66 69 6e 65 20 4d 61 6a | 6f 72 20 47 72 69 64 20 |fine Maj|or Grid |
|00003ed0| 77 69 64 74 68 20 7d 0d | 09 41 58 49 53 20 4d 49 |width }.|.AXIS MI|
|00003ee0| 4e 4f 52 20 47 52 49 44 | 20 46 47 20 30 09 09 09 |NOR GRID| FG 0...|
|00003ef0| 09 09 7b 20 44 65 66 69 | 6e 65 20 4d 69 6e 6f 72 |..{ Defi|ne Minor|
|00003f00| 20 47 72 69 64 20 66 6f | 72 65 67 72 6f 75 6e 64 | Grid fo|reground|
|00003f10| 20 63 6f 6c 6f 72 20 7d | 0d 09 41 58 49 53 20 4d | color }|..AXIS M|
|00003f20| 49 4e 4f 52 20 47 52 49 | 44 20 42 47 20 31 36 37 |INOR GRI|D BG 167|
|00003f30| 37 37 32 31 35 09 09 09 | 09 7b 20 44 65 66 69 6e |77215...|.{ Defin|
|00003f40| 65 20 4d 69 6e 6f 72 20 | 47 72 69 64 20 62 61 63 |e Minor |Grid bac|
|00003f50| 6b 67 72 6f 75 6e 64 20 | 63 6f 6c 6f 72 20 7d 0d |kground |color }.|
|00003f60| 09 41 58 49 53 20 4d 49 | 4e 4f 52 20 47 52 49 44 |.AXIS MI|NOR GRID|
|00003f70| 20 50 41 54 54 45 52 4e | 20 31 09 09 09 09 7b 20 | PATTERN| 1....{ |
|00003f80| 44 65 66 69 6e 65 20 4d | 69 6e 6f 72 20 47 72 69 |Define M|inor Gri|
|00003f90| 64 20 70 61 74 74 65 72 | 6e 20 7d 0d 09 41 58 49 |d patter|n }..AXI|
|00003fa0| 53 20 4d 49 4e 4f 52 20 | 47 52 49 44 20 57 49 44 |S MINOR |GRID WID|
|00003fb0| 54 48 20 30 09 09 09 09 | 09 7b 20 44 65 66 69 6e |TH 0....|.{ Defin|
|00003fc0| 65 20 4d 69 6e 6f 72 20 | 47 72 69 64 20 77 69 64 |e Minor |Grid wid|
|00003fd0| 74 68 20 7d 0d 09 48 49 | 44 45 20 4c 45 47 45 4e |th }..HI|DE LEGEN|
|00003fe0| 44 09 09 09 09 09 09 09 | 7b 20 48 69 64 65 20 74 |D.......|{ Hide t|
|00003ff0| 68 65 20 6c 65 67 65 6e | 64 20 7d 0d 09 53 45 4c |he legen|d }..SEL|
|00004000| 45 43 54 20 43 48 41 52 | 54 20 31 20 53 45 52 49 |ECT CHAR|T 1 SERI|
|00004010| 45 53 20 31 09 09 09 09 | 09 7b 20 53 65 6c 65 63 |ES 1....|.{ Selec|
|00004020| 74 20 74 68 65 20 63 68 | 61 72 74 20 62 61 72 73 |t the ch|art bars|
|00004030| 20 7d 0d 09 46 49 4c 4c | 20 46 47 20 31 34 34 38 | }..FILL| FG 1448|
|00004040| 33 34 35 36 09 09 09 09 | 09 09 7b 20 44 65 73 69 |3456....|..{ Desi|
|00004050| 67 6e 61 74 65 20 74 68 | 65 20 63 68 61 72 74 20 |gnate th|e chart |
|00004060| 62 61 72 20 63 6f 6c 6f | 72 20 7d 0d 09 53 45 4c |bar colo|r }..SEL|
|00004070| 45 43 54 20 52 41 4e 47 | 45 20 42 32 09 09 09 09 |ECT RANG|E B2....|
|00004080| 09 09 7b 20 53 65 6c 65 | 63 74 20 74 69 74 6c 65 |..{ Sele|ct title|
|00004090| 20 63 65 6c 6c 20 7d 0d | 09 53 45 4c 45 43 54 20 | cell }.|.SELECT |
|000040a0| 4d 4f 52 45 20 4f 42 4a | 45 43 54 20 31 09 09 09 |MORE OBJ|ECT 1...|
|000040b0| 09 09 7b 20 41 6c 73 6f | 20 73 65 6c 65 63 74 20 |..{ Also| select |
|000040c0| 74 68 65 20 63 68 61 72 | 74 20 7d 0d 09 54 49 54 |the char|t }..TIT|
|000040d0| 4c 45 20 52 41 4e 47 45 | 09 09 09 09 09 09 09 7b |LE RANGE|.......{|
|000040e0| 20 44 65 73 69 67 6e 61 | 74 65 20 74 68 65 20 63 | Designa|te the c|
|000040f0| 68 61 72 74 20 74 69 74 | 6c 65 20 7d 0d 09 53 45 |hart tit|le }..SE|
|00004100| 4c 45 43 54 20 52 41 4e | 47 45 20 4f 31 09 09 09 |LECT RAN|GE O1...|
|00004110| 09 09 09 7b 20 53 65 6c | 65 63 74 20 63 65 6c 6c |...{ Sel|ect cell|
|00004120| 20 74 6f 20 6d 6f 76 65 | 20 76 69 65 77 20 62 65 | to move| view be|
|00004130| 79 6f 6e 64 20 63 68 61 | 72 74 20 61 72 65 61 20 |yond cha|rt area |
|00004140| 7d 0d 09 53 45 4c 45 43 | 54 20 52 41 4e 47 45 20 |}..SELEC|T RANGE |
|00004150| 48 31 09 09 09 09 09 09 | 7b 20 53 65 6c 65 63 74 |H1......|{ Select|
|00004160| 20 63 65 6c 6c 20 74 6f | 20 6d 6f 76 65 20 76 69 | cell to| move vi|
|00004170| 65 77 20 74 6f 20 63 68 | 61 72 74 20 61 72 65 61 |ew to ch|art area|
|00004180| 20 7d 0d 09 43 4f 50 59 | 09 09 09 09 09 09 09 09 | }..COPY|........|
|00004190| 09 7b 20 43 6f 70 79 20 | 65 6d 70 74 79 20 63 65 |.{ Copy |empty ce|
|000041a0| 6c 6c 20 74 6f 20 63 6c | 65 61 72 20 74 68 65 20 |ll to cl|ear the |
|000041b0| 63 6c 69 70 62 6f 61 72 | 64 20 7d 0d 09 55 4e 53 |clipboar|d }..UNS|
|000041c0| 45 4c 45 43 54 09 09 09 | 09 09 09 09 09 7b 20 55 |ELECT...|.....{ U|
|000041d0| 6e 73 65 6c 65 63 74 20 | 61 6c 6c 20 69 74 65 6d |nselect |all item|
|000041e0| 73 20 7d 0d 09 52 45 50 | 41 49 4e 54 20 57 49 4e |s }..REP|AINT WIN|
|000041f0| 44 4f 57 09 09 09 09 09 | 09 09 7b 20 52 65 70 61 |DOW.....|..{ Repa|
|00004200| 69 6e 74 20 74 68 65 20 | 77 69 6e 64 6f 77 20 7d |int the |window }|
|00004210| 0d 09 52 45 50 41 49 4e | 54 20 4f 4e 09 09 09 09 |..REPAIN|T ON....|
|00004220| 09 09 09 7b 20 54 75 72 | 6e 20 52 65 70 61 69 6e |...{ Tur|n Repain|
|00004230| 74 20 6f 6e 20 74 6f 20 | 73 68 6f 77 20 63 68 61 |t on to |show cha|
|00004240| 72 74 20 7d 0d 09 41 58 | 49 53 20 4d 41 4a 4f 52 |rt }..AX|IS MAJOR|
|00004250| 20 47 52 49 44 20 57 49 | 44 54 48 20 35 09 09 09 | GRID WI|DTH 5...|
|00004260| 09 09 7b 20 53 65 74 20 | 67 72 69 64 20 77 69 64 |..{ Set |grid wid|
|00004270| 74 68 20 7d 0d 45 4e 44 | 20 46 55 4e 43 54 49 4f |th }.END| FUNCTIO|
|00004280| 4e 0d 0d 7b 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |N..{****|********|
|00004290| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000042a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 41 53 4b 5f 54 4f |********|* ASK_TO|
|000042b0| 5f 43 4f 50 59 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |_COPY **|********|
|000042c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000042d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000042e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 20 20 54 68 69 73 |********|*.  This|
|000042f0| 20 66 75 6e 63 74 69 6f | 6e 20 64 69 73 70 6c 61 | functio|n displa|
|00004300| 79 73 20 61 20 6d 6f 64 | 61 6c 20 64 69 61 6c 6f |ys a mod|al dialo|
|00004310| 67 20 62 6f 78 20 77 68 | 69 63 68 20 61 73 6b 73 |g box wh|ich asks|
|00004320| 20 69 66 20 79 6f 75 20 | 77 61 6e 74 20 74 6f 20 | if you |want to |
|00004330| 63 6c 6f 73 65 20 74 68 | 65 20 66 69 6c 65 2e 20 |close th|e file. |
|00004340| 20 49 66 20 79 6f 75 20 | 63 68 6f 6f 73 65 0d 20 | If you |choose. |
|00004350| 20 22 43 68 61 72 74 22 | 2c 20 74 68 65 20 63 68 | "Chart"|, the ch|
|00004360| 61 72 74 20 69 73 20 63 | 6f 70 69 65 64 20 74 6f |art is c|opied to|
|00004370| 20 74 68 65 20 63 6c 69 | 70 62 6f 61 72 64 20 61 | the cli|pboard a|
|00004380| 6e 64 20 74 68 65 20 66 | 69 6c 65 20 69 73 20 63 |nd the f|ile is c|
|00004390| 6c 6f 73 65 64 2e 20 20 | 49 66 20 79 6f 75 20 63 |losed.  |If you c|
|000043a0| 68 6f 6f 73 65 20 22 54 | 61 62 6c 65 22 2c 20 74 |hoose "T|able", t|
|000043b0| 68 65 0d 20 20 74 61 62 | 6c 65 20 69 73 20 63 6f |he.  tab|le is co|
|000043c0| 70 69 65 64 20 74 6f 20 | 74 68 65 20 63 6c 69 70 |pied to |the clip|
|000043d0| 62 6f 61 72 64 20 61 6e | 64 20 74 68 65 20 66 69 |board an|d the fi|
|000043e0| 6c 65 20 69 73 20 63 6c | 6f 73 65 64 2e 20 20 49 |le is cl|osed.  I|
|000043f0| 66 20 79 6f 75 20 63 68 | 6f 6f 73 65 20 22 4e 6f |f you ch|oose "No|
|00004400| 22 2c 20 74 68 65 20 64 | 69 61 6c 6f 67 20 64 69 |", the d|ialog di|
|00004410| 73 61 70 70 65 61 72 73 | 0d 20 20 61 6e 64 20 74 |sappears|.  and t|
|00004420| 68 65 20 73 63 72 69 70 | 74 20 74 65 72 6d 69 6e |he scrip|t termin|
|00004430| 61 74 65 73 20 77 69 74 | 68 20 74 68 65 20 66 69 |ates wit|h the fi|
|00004440| 6c 65 20 6f 70 65 6e 2e | 0d 20 2a 2a 2a 2a 2a 2a |le open.|. ******|
|00004450| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004460| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|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 2a 2a 2a 2a 2a |********|********|
|000044a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 7d 0d |********|******}.|
|000044b0| 0d 46 55 4e 43 54 49 4f | 4e 20 41 53 4b 5f 54 4f |.FUNCTIO|N ASK_TO|
|000044c0| 5f 43 4f 50 59 28 29 0d | 09 4e 45 57 20 4d 4f 44 |_COPY().|.NEW MOD|
|000044d0| 41 4c 20 44 49 41 4c 4f | 47 20 42 4f 58 20 41 54 |AL DIALO|G BOX AT|
|000044e0| 20 28 2d 31 3b 2d 31 29 | 28 35 20 49 4e 43 48 3b | (-1;-1)|(5 INCH;|
|000044f0| 31 2e 35 20 49 4e 43 48 | 29 20 09 7b 20 43 72 65 |1.5 INCH|) .{ Cre|
|00004500| 61 74 65 20 61 20 63 65 | 6e 74 65 72 65 64 20 6d |ate a ce|ntered m|
|00004510| 6f 64 61 6c 20 64 69 61 | 6c 6f 67 20 62 6f 78 20 |odal dia|log box |
|00004520| 7d 0d 09 41 44 44 20 54 | 45 58 54 20 22 43 6f 70 |}..ADD T|EXT "Cop|
|00004530| 79 20 63 68 61 72 74 20 | 6f 72 20 74 61 62 6c 65 |y chart |or table|
|00004540| 20 74 6f 20 43 6c 69 70 | 62 6f 61 72 64 20 61 6e | to Clip|board an|
|00004550| 64 20 63 6c 6f 73 65 20 | 77 6f 72 6b 73 68 65 65 |d close |workshee|
|00004560| 74 20 77 69 74 68 6f 75 | 74 20 73 61 76 69 6e 67 |t withou|t saving|
|00004570| 3f 22 20 0d 09 09 41 54 | 20 28 2e 31 32 35 20 49 |?" ...AT| (.125 I|
|00004580| 4e 43 48 3b 20 2e 31 32 | 35 20 49 4e 43 48 29 20 |NCH; .12|5 INCH) |
|00004590| 2b 20 28 34 2e 37 35 20 | 49 4e 43 48 3b 20 2e 35 |+ (4.75 |INCH; .5|
|000045a0| 20 49 4e 43 48 29 09 7b | 20 50 6c 61 63 65 20 74 | INCH).{| Place t|
|000045b0| 65 78 74 20 69 6e 74 6f | 20 64 69 61 6c 6f 67 20 |ext into| dialog |
|000045c0| 62 6f 78 20 7d 0d 09 4e | 4f 20 4c 49 4e 45 20 42 |box }..N|O LINE B|
|000045d0| 4f 52 44 45 52 09 09 09 | 09 09 09 09 09 7b 20 54 |ORDER...|.....{ T|
|000045e0| 75 72 6e 20 6f 66 66 20 | 6c 69 6e 65 20 62 6f 72 |urn off |line bor|
|000045f0| 64 65 72 20 66 6f 72 20 | 74 65 78 74 20 6f 62 6a |der for |text obj|
|00004600| 65 63 74 20 7d 0d 09 41 | 44 44 20 50 55 53 48 20 |ect }..A|DD PUSH |
|00004610| 42 55 54 54 4f 4e 20 22 | 20 20 20 20 4e 6f 20 20 |BUTTON "|    No  |
|00004620| 20 20 22 09 09 09 0d 09 | 09 41 54 20 28 32 2e 33 |  ".....|.AT (2.3|
|00004630| 35 20 49 4e 43 48 3b 20 | 31 2e 31 32 35 20 49 4e |5 INCH; |1.125 IN|
|00004640| 43 48 29 20 2b 20 28 31 | 20 49 4e 43 48 3b 20 2e |CH) + (1| INCH; .|
|00004650| 32 35 20 49 4e 43 48 29 | 09 7b 20 41 64 64 20 4e |25 INCH)|.{ Add N|
|00004660| 6f 20 62 75 74 74 6f 6e | 20 7d 0d 09 41 44 44 20 |o button| }..ADD |
|00004670| 50 55 53 48 20 42 55 54 | 54 4f 4e 20 22 20 20 20 |PUSH BUT|TON "   |
|00004680| 20 54 61 62 6c 65 20 20 | 20 20 22 3b 20 22 20 20 | Table  |  "; "  |
|00004690| 20 20 43 68 61 72 74 20 | 20 20 20 22 20 09 09 09 |  Chart |   " ...|
|000046a0| 09 09 0d 09 09 41 54 20 | 28 33 2e 37 35 20 49 4e |.....AT |(3.75 IN|
|000046b0| 43 48 3b 20 2e 35 20 49 | 4e 43 48 29 20 2b 20 28 |CH; .5 I|NCH) + (|
|000046c0| 31 20 49 4e 43 48 3b 20 | 31 20 49 4e 43 48 29 09 |1 INCH; |1 INCH).|
|000046d0| 7b 20 41 64 64 20 54 61 | 62 6c 65 20 61 6e 64 20 |{ Add Ta|ble and |
|000046e0| 43 68 61 72 74 20 62 75 | 74 74 6f 6e 73 20 7d 0d |Chart bu|ttons }.|
|000046f0| 09 53 45 4c 45 43 54 20 | 43 4f 4e 54 52 4f 4c 20 |.SELECT |CONTROL |
|00004700| 32 09 09 09 09 09 09 09 | 7b 20 53 65 6c 65 63 74 |2.......|{ Select|
|00004710| 20 4e 6f 20 62 75 74 74 | 6f 6e 20 7d 0d 09 44 49 | No butt|on }..DI|
|00004720| 41 4c 4f 47 20 43 41 4e | 43 45 4c 20 50 55 53 48 |ALOG CAN|CEL PUSH|
|00004730| 20 42 55 54 54 4f 4e 09 | 09 09 09 09 7b 20 44 65 | BUTTON.|....{ De|
|00004740| 66 69 6e 65 20 62 75 74 | 74 6f 6e 20 61 73 20 61 |fine but|ton as a|
|00004750| 20 63 61 6e 63 65 6c 20 | 62 75 74 74 6f 6e 20 7d | cancel |button }|
|00004760| 0d 09 53 43 52 49 50 54 | 20 22 27 52 65 73 6f 75 |..SCRIPT| "'Resou|
|00004770| 72 63 65 20 43 6f 73 74 | 20 53 63 72 69 70 74 3a |rce Cost| Script:|
|00004780| 64 6f 6e 65 27 20 3d 20 | 30 22 09 09 7b 20 49 66 |done' = |0"..{ If|
|00004790| 20 70 72 65 73 73 65 64 | 2c 20 64 6f 6e 65 20 3d | pressed|, done =|
|000047a0| 20 30 20 7d 0d 09 53 45 | 4c 45 43 54 20 43 4f 4e | 0 }..SE|LECT CON|
|000047b0| 54 52 4f 4c 20 33 09 09 | 09 09 09 09 09 7b 20 53 |TROL 3..|.....{ S|
|000047c0| 65 6c 65 63 74 20 54 61 | 62 6c 65 20 62 75 74 74 |elect Ta|ble butt|
|000047d0| 6f 6e 20 7d 0d 09 53 43 | 52 49 50 54 20 22 4f 4e |on }..SC|RIPT "ON|
|000047e0| 20 4d 4f 55 53 45 55 50 | 09 09 09 09 09 09 09 7b | MOUSEUP|.......{|
|000047f0| 20 57 68 65 6e 20 6d 6f | 75 73 65 20 72 65 6c 65 | When mo|use rele|
|00004800| 61 73 65 64 20 7d 0d 09 | 09 27 52 65 73 6f 75 72 |ased }..|.'Resour|
|00004810| 63 65 20 43 6f 73 74 20 | 53 63 72 69 70 74 3a 64 |ce Cost |Script:d|
|00004820| 6f 6e 65 27 20 3d 20 31 | 09 09 09 7b 20 49 66 20 |one' = 1|...{ If |
|00004830| 70 72 65 73 73 65 64 2c | 20 64 6f 6e 65 20 3d 20 |pressed,| done = |
|00004840| 31 20 7d 0d 09 09 51 55 | 49 54 20 44 49 41 4c 4f |1 }...QU|IT DIALO|
|00004850| 47 20 42 4f 58 09 09 09 | 09 09 09 7b 20 51 75 69 |G BOX...|...{ Qui|
|00004860| 74 20 64 69 61 6c 6f 67 | 20 7d 0d 09 09 45 4e 44 |t dialog| }...END|
|00004870| 20 4d 4f 55 53 45 55 50 | 22 09 09 09 09 09 09 09 | MOUSEUP|".......|
|00004880| 7b 20 45 6e 64 20 73 63 | 72 69 70 74 20 7d 0d 09 |{ End sc|ript }..|
|00004890| 53 45 4c 45 43 54 20 43 | 4f 4e 54 52 4f 4c 20 34 |SELECT C|ONTROL 4|
|000048a0| 09 09 09 09 09 09 09 7b | 20 53 65 6c 65 63 74 20 |.......{| Select |
|000048b0| 43 68 61 72 74 20 62 75 | 74 74 6f 6e 20 7d 0d 09 |Chart bu|tton }..|
|000048c0| 44 49 41 4c 4f 47 20 44 | 45 46 41 55 4c 54 20 50 |DIALOG D|EFAULT P|
|000048d0| 55 53 48 20 42 55 54 54 | 4f 4e 09 09 09 09 09 7b |USH BUTT|ON.....{|
|000048e0| 20 44 65 66 69 6e 65 20 | 62 75 74 74 6f 6e 20 61 | Define |button a|
|000048f0| 73 20 74 68 65 20 64 65 | 66 61 75 6c 74 20 62 75 |s the de|fault bu|
|00004900| 74 74 6f 6e 20 7d 0d 09 | 53 43 52 49 50 54 20 22 |tton }..|SCRIPT "|
|00004910| 27 52 65 73 6f 75 72 63 | 65 20 43 6f 73 74 20 53 |'Resourc|e Cost S|
|00004920| 63 72 69 70 74 3a 64 6f | 6e 65 27 20 3d 20 32 22 |cript:do|ne' = 2"|
|00004930| 09 09 7b 20 49 66 20 70 | 72 65 73 73 65 64 2c 20 |..{ If p|ressed, |
|00004940| 64 6f 6e 65 20 3d 20 31 | 20 7d 0d 09 55 53 45 20 |done = 1| }..USE |
|00004950| 44 49 41 4c 4f 47 20 42 | 4f 58 09 09 09 09 09 09 |DIALOG B|OX......|
|00004960| 09 09 7b 20 44 69 73 70 | 6c 61 79 20 64 69 61 6c |..{ Disp|lay dial|
|00004970| 6f 67 20 6f 6e 2d 73 63 | 72 65 65 6e 20 7d 0d 09 |og on-sc|reen }..|
|00004980| 49 46 20 64 6f 6e 65 20 | 3d 20 31 09 09 09 09 09 |IF done |= 1.....|
|00004990| 09 09 09 7b 20 49 66 20 | 64 6f 6e 65 20 3d 20 31 |...{ If |done = 1|
|000049a0| 20 28 54 61 62 6c 65 20 | 77 61 73 20 70 72 65 73 | (Table |was pres|
|000049b0| 73 65 64 29 20 7d 0d 09 | 09 53 45 4c 45 43 54 20 |sed) }..|.SELECT |
|000049c0| 52 41 4e 47 45 28 4d 41 | 4b 45 52 41 4e 47 45 28 |RANGE(MA|KERANGE(|
|000049d0| 31 3b 31 3b 36 3b 6c 61 | 73 74 5f 52 54 5f 72 6f |1;1;6;la|st_RT_ro|
|000049e0| 77 2b 34 29 29 09 7b 20 | 53 65 6c 65 63 74 20 74 |w+4)).{ |Select t|
|000049f0| 61 62 6c 65 20 7d 0d 09 | 09 43 4f 50 59 09 09 09 |able }..|.COPY...|
|00004a00| 09 09 09 09 09 09 7b 20 | 43 6f 70 79 20 74 6f 20 |......{ |Copy to |
|00004a10| 74 68 65 20 63 6c 69 70 | 62 6f 61 72 64 20 7d 0d |the clip|board }.|
|00004a20| 09 09 43 4c 4f 53 45 20 | 4e 4f 57 09 09 09 09 09 |..CLOSE |NOW.....|
|00004a30| 09 09 09 7b 20 43 6c 6f | 73 65 20 73 68 65 65 74 |...{ Clo|se sheet|
|00004a40| 20 77 69 74 68 6f 75 74 | 20 73 61 76 69 6e 67 20 | without| saving |
|00004a50| 7d 0d 09 45 4c 53 45 49 | 46 20 64 6f 6e 65 20 3d |}..ELSEI|F done =|
|00004a60| 20 32 09 09 09 09 09 09 | 09 7b 20 49 66 20 64 6f | 2......|.{ If do|
|00004a70| 6e 65 20 3d 20 32 20 28 | 43 68 61 72 74 20 77 61 |ne = 2 (|Chart wa|
|00004a80| 73 20 70 72 65 73 73 65 | 64 29 20 7d 0d 09 09 53 |s presse|d) }...S|
|00004a90| 45 4c 45 43 54 20 43 48 | 41 52 54 20 31 09 09 09 |ELECT CH|ART 1...|
|00004aa0| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 63 68 61 |....{ Se|lect cha|
|00004ab0| 72 74 20 7d 0d 09 09 43 | 4f 50 59 09 09 09 09 09 |rt }...C|OPY.....|
|00004ac0| 09 09 09 09 7b 20 43 6f | 70 79 20 74 6f 20 74 68 |....{ Co|py to th|
|00004ad0| 65 20 63 6c 69 70 62 6f | 61 72 64 20 7d 0d 09 09 |e clipbo|ard }...|
|00004ae0| 43 4c 4f 53 45 20 4e 4f | 57 09 09 09 09 09 09 09 |CLOSE NO|W.......|
|00004af0| 09 7b 20 43 6c 6f 73 65 | 20 73 68 65 65 74 20 77 |.{ Close| sheet w|
|00004b00| 69 74 68 6f 75 74 20 73 | 61 76 69 6e 67 20 7d 0d |ithout s|aving }.|
|00004b10| 09 45 4e 44 20 49 46 09 | 09 09 09 09 09 09 09 09 |.END IF.|........|
|00004b20| 7b 20 45 6e 64 20 6c 6f | 67 69 63 61 6c 20 49 46 |{ End lo|gical IF|
|00004b30| 20 7d 0d 45 4e 44 20 46 | 55 4e 43 54 49 4f 4e 0d | }.END F|UNCTION.|
|00004b40| 0d 7b 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.{******|********|
|00004b50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b60| 2a 2a 2a 2a 2a 2a 2a 20 | 45 4e 44 20 53 43 52 49 |******* |END SCRI|
|00004b70| 50 54 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |PT *****|********|
|00004b80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004ba0| 2a 2a 2a 2a 2a 2a 7d 0d | 00 00 00 00 00 00 00 00 |******}.|........|
|00004bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c00| 00 00 01 00 00 00 01 87 | 00 00 00 87 00 00 00 3c |........|.......<|
|00004c10| b2 30 2e ff e2 d0 6e ff | e0 48 c0 d0 80 22 6d d6 |.0....n.|.H..."m.|
|00004c20| b2 32 2e ff e0 48 c1 d2 | 81 33 b0 08 00 18 00 20 |.2...H..|.3..... |
|00004c30| 14 52 65 73 6f 75 72 63 | 65 20 43 6f 73 74 20 53 |.Resourc|e Cost S|
|00004c40| 63 72 69 70 74 63 02 00 | 00 00 52 73 53 63 52 73 |criptc..|..RsScRs|
|00004c50| 00 00 52 73 53 63 52 73 | 6c 76 01 00 00 d0 00 00 |..RsScRs|lv......|
|00004c60| 00 00 00 84 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004c70| 00 00 a4 58 08 a0 00 00 | 4b 29 00 00 01 c3 ee 18 |...X....|K)......|
|00004c80| f8 ff ae 4e 5e 4e 75 f3 | 73 6f 72 74 20 20 20 00 |...N^Nu.|sort   .|
|00004c90| 00 00 00 0b e4 29 48 00 | 04 4e 56 ff c6 48 e7 01 |.....)H.|.NV..H..|
|00004ca0| 18 4a ad b9 f0 67 00 00 | fa 4a 6d ba 0a 66 00 00 |.J...g..|.Jm..f..|
|00004cb0| c4 70 01 b0 6d b9 f8 67 | 1a 70 03 b0 6d b9 f8 66 |.p..m..g|.p..m..f|
|00004cc0| 00 00 b2 4a 6d b9 f6 67 | 0a 70 04 b0 6d b9 f6 66 |...Jm..g|.p..m..f|
|00004cd0| 00 00 a2 2f 2d b9 f0 4e | ad 17 62 70 01 b0 6d b9 |.../-..N|..bp..m.|
|00004ce0| f8 58 8f 67 08 70 04 b0 | 6d b9 f6 67 54 47 ed b9 |.X.g.p..|m..gTG..|
|00004cf0| da 70 01 b0 6b 00 0c 66 | 38 48 6e ff c6 4e ad 12 |.p..k..f|8Hn..N..|
|00004d00| 00 00 00 83 06 ff 92 45 | 3f e5 32 30 00 04 00 00 |.......E|?.20....|
|00004d10| 00 00 00 00 00 00 a4 58 | 0b 60 a4 58 0b 60 a1 20 |.......X|.`.X.`. |
|00004d20| 06 7d 00 00 91 e8 00 00 | 00 51 00 06 06 4f 61 73 |.}......|.Q...Oas|
|00004d30| 69 73 ba 00 0a 53 75 65 | 20 57 61 72 6e 65 72 00 |is...Sue| Warner.|
|00004d40| 01 36 00 14 52 65 73 6f | 75 72 63 65 20 43 6f 73 |.6..Reso|urce Cos|
|00004d50| 74 20 53 63 72 69 70 74 | 00 0f 43 68 61 6e 67 65 |t Script|..Change|
|00004d60| 73 20 66 6f 72 20 78 31 | 31 00 00 1a 43 68 65 63 |s for x1|1...Chec|
|00004d70| 6b 20 69 6e 20 66 6f 72 | 20 67 6f 6c 64 65 6e 20 |k in for| golden |
|00004d80| 73 75 62 6d 69 74 00 00 | 00 01 00 00 00 01 87 00 |submit..|........|
|00004d90| 00 00 87 00 00 00 3c 00 | 04 6e 84 01 7a 00 00 00 |......<.|.n..z...|
|00004da0| 1c 00 32 00 00 63 6b 69 | 64 00 00 00 0a 00 80 00 |..2..cki|d.......|
|00004db0| 00 00 00 00 00 00 00 00 | 00 09 50 72 6f 6a 65 63 |........|..Projec|
|00004dc0| 74 6f 72 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |tor.....|........|
|00004dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+