The Macintosh Demo: Applications

home *** CD-ROM | disk | FTP | other *** search
/ The Macintosh Demo: Applications / Apple-MacintoshDemoApplicationsCD-1.0-1992.iso / More Information / MacProject II / Earned Value Script < prev next >
MacBinary | 1991-05-16 | 30.1 KB | [RsSc/Rslv]
open in:
MacOS 8.1 extracted |
Win98 extracted |
DOS extracted
view JSON data |
view as text

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

You can browse this item here: Earned Value 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', 30186 bytes "Earned Value Script" , at 0x766a 450 bytes resource	default (weak)
`99%`	file	data	default
`100%`	TrID	MacBinary 2	default (weak)
`100%`	siegfried	fmt/1762 MacBinary (II)	default
`100%`	lsar	MacBinary	default
id metadata
key	value
macFileType	`[RsSc]`
macFileCreator	`[Rslv]`
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 13 45 61 72 6e 65 64 | 20 56 61 6c 75 65 20 53 |..Earned| Value S|
|00000010| 63 72 69 70 74 00 00 00 | 00 00 00 00 00 00 00 00 |cript...|........|
|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 75 ea 00 | 00 01 c2 a4 58 08 a0 a4 |.....u..|....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 d5 b9 00 00 |........|........|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 ed 62 00 00 |BAT_BTSC|0101.b..|
|00000090| a5 12 00 00 42 11 00 00 | 42 11 00 00 42 11 00 00 |....B...|B...B...|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 0a 00 0c 00 |........|........|
|000000d0| 16 00 00 00 00 00 00 00 | 18 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 f4 00 05 18 00 00 00 | 00 00 00 f0 3f f4 00 06 |........|....?...|
|000000f0| 1a 00 05 f4 00 04 1a 00 | 05 f4 00 09 fd 04 1b 00 |........|........|
|00000100| 00 1b 00 00 00 f9 f8 1a | 00 09 38 f2 b1 00 1b 00 |........|..8.....|
|00000110| 00 01 f9 f8 1b 00 00 02 | f9 f4 00 00 1a 00 00 18 |........|........|
|00000120| 00 00 00 00 00 00 00 40 | 3a f2 47 00 1b 00 00 03 |.......@|:.G.....|
|00000130| f9 f8 1b 00 00 04 f9 f8 | 1b 00 00 05 f9 f8 1b 00 |........|........|
|00000140| 00 06 f9 f8 1a 00 09 38 | f2 25 00 1b 00 00 07 f9 |.......8|.%......|
|00000150| f8 1b 00 00 08 f9 f8 1b | 00 00 09 f9 f8 1b 00 00 |........|........|
|00000160| 0a f9 f8 fd 04 1b 00 01 | 1b 00 00 0b f9 f8 1d 4e |........|.......N|
|00000170| 00 fd 47 23 00 43 54 68 | 65 72 65 20 69 73 20 6e |..G#.CTh|ere is n|
|00000180| 6f 74 20 65 6e 6f 75 67 | 68 20 43 61 73 68 20 46 |ot enoug|h Cash F|
|00000190| 6c 6f 77 20 64 61 74 61 | 20 74 6f 20 63 72 65 61 |low data| to crea|
|000001a0| 74 65 20 61 6e 20 65 61 | 72 6e 65 64 20 76 61 6c |te an ea|rned val|
|000001b0| 75 65 20 67 72 61 70 68 | 2e fd 03 01 01 fc f6 00 |ue graph|........|
|000001c0| 00 fd 06 00 00 00 00 00 | fd 0e 08 01 01 01 01 07 |........|........|
|000001d0| 07 00 00 00 00 ff 00 fd | 17 00 06 00 12 4d 50 20 |........|.....MP |
|000001e0| 43 61 73 68 20 46 6c 6f | 77 20 54 61 62 6c 65 fe |Cash Flo|w Table.|
|000001f0| 40 18 00 00 00 00 00 00 | 00 00 39 f2 0a 00 fd 04 |@.......|..9.....|
|00000200| 1a 04 01 1d 08 00 1a 00 | 06 f4 00 09 fb f6 00 00 |........|........|
|00000210| fd 04 08 01 05 18 00 00 | 00 00 00 00 f0 3f fe 19 |........|.....?..|
|00000220| d1 fa fb f6 00 00 fd 13 | 08 01 01 01 01 0c 08 0f |........|........|
|00000230| 00 00 ff 7f 05 00 05 00 | ff 00 fd 03 06 01 fd 13 |........|........|
|00000240| 08 01 01 01 01 0c 08 0f | 00 00 ff 7f 09 00 09 00 |........|........|
|00000250| ff 00 fd 04 06 02 00 fd | 13 08 01 01 01 01 0c 08 |........|........|
|00000260| 0f 00 00 ff 7f 01 00 01 | 00 ff 00 fd 03 06 01 fd |........|........|
|00000270| 13 08 01 01 01 01 0c 08 | 0f 00 00 ff 7f 0a 00 0a |........|........|
|00000280| 00 ff 00 fd 04 06 02 00 | fd 13 08 01 01 01 01 0c |........|........|
|00000290| 08 0f 00 00 ff 7f 03 00 | 03 00 ff 00 fd 03 06 01 |........|........|
|000002a0| fd 13 08 01 01 01 01 0c | 08 0f 00 00 ff 7f 0b 00 |........|........|
|000002b0| 0b 00 ff 00 fd 04 06 02 | 00 fd 13 08 01 01 01 01 |........|........|
|000002c0| 0c 08 0f 00 00 00 00 00 | 00 ff 7f ff 00 fd 02 0c |........|........|
|000002d0| fb f6 00 00 18 00 00 00 | 00 00 00 08 40 f4 00 01 |........|....@...|
|000002e0| 1a 00 00 18 00 00 00 00 | 00 00 f0 3f 1d 16 00 1a |........|...?....|
|000002f0| 00 00 18 00 00 00 00 00 | 00 f0 3f f7 1a 00 01 2e |........|..?.....|
|00000300| f4 00 01 1a 00 01 f5 47 | 00 18 00 00 00 00 00 00 |.......G|........|
|00000310| 26 40 1a 00 01 d4 d2 f4 | 00 02 fd 30 17 01 1d 1a |&@......|...0....|
|00000320| 00 02 18 00 00 00 00 00 | 00 26 40 1a 00 01 2b 00 |........|.&@...+.|
|00000330| 00 00 00 00 00 f0 3f d4 | d2 2e ff 01 0f 18 00 00 |......?.|........|
|00000340| 00 00 00 00 26 40 1a 00 | 01 d4 ff 1d a3 ff fb f6 |....&@..|........|
|00000350| 00 00 18 00 00 00 00 00 | 00 08 40 f4 00 01 1a 00 |........|..@.....|
|00000360| 07 18 00 00 00 00 00 00 | f0 3f 1d 16 00 1a 00 07 |........|.?......|
|00000370| 18 00 00 00 00 00 00 f0 | 3f f7 1a 00 01 2e f4 00 |........|?.......|
|00000380| 01 1a 00 01 f5 47 00 18 | 00 00 00 00 00 00 28 40 |.....G..|......(@|
|00000390| 1a 00 01 d4 d2 f4 00 02 | fd 30 17 01 1d 1a 00 02 |........|.0......|
|000003a0| 18 00 00 00 00 00 00 28 | 40 1a 00 01 2b 00 00 00 |.......(|@...+...|
|000003b0| 00 00 00 f0 3f d4 d2 2e | ff 01 0f 18 00 00 00 00 |....?...|........|
|000003c0| 00 00 28 40 1a 00 01 d4 | ff 1d a3 ff 1a 00 07 2a |..(@....|.......*|
|000003d0| 00 00 00 00 00 00 f0 3f | f4 00 01 1a 00 00 18 00 |.......?|........|
|000003e0| 00 00 00 00 00 f0 3f 1d | 16 00 1a 00 00 18 00 00 |......?.|........|
|000003f0| 00 00 00 00 f0 3f f7 1a | 00 01 2e f4 00 01 1a 00 |.....?..|........|
|00000400| 01 f5 1b 00 fd 15 17 00 | 01 20 01 0f 18 00 00 00 |........|. ......|
|00000410| 00 00 00 28 40 1a 00 01 | d4 ff 1d cf ff fb f6 00 |...(@...|........|
|00000420| 09 fd 13 08 01 01 01 01 | 0c 08 0f 00 00 ff 7f 05 |........|........|
|00000430| 00 05 00 ff 00 fd 03 06 | 01 fd 15 00 03 00 10 4d |........|.......M|
|00000440| 50 20 50 72 6f 6a 65 63 | 74 20 54 61 62 6c 65 fe |P Projec|t Table.|
|00000450| 40 18 00 00 00 00 00 00 | 00 00 39 f2 2b 00 fd 04 |@.......|..9.+...|
|00000460| 1a 04 01 1b 00 00 02 f9 | f4 03 01 fd 13 08 01 01 |........|........|
|00000470| 01 01 0c 08 0f 00 00 ff | 7f 07 00 07 00 ff 00 fd |........|........|
|00000480| 04 06 02 00 1d 0c 00 1a | 00 06 f4 00 09 fd 03 01 |........|........|
|00000490| 01 1a 00 09 38 f2 da 03 | 1a 03 01 18 00 00 00 00 |....8...|........|
|000004a0| 00 00 00 00 3a f2 70 03 | 18 00 00 00 00 00 00 00 |....:.p.|........|
|000004b0| 40 f4 00 01 1a 00 00 18 | 00 00 00 00 00 00 f0 3f |@.......|.......?|
|000004c0| 1d 16 00 1a 00 00 18 00 | 00 00 00 00 00 f0 3f f7 |........|......?.|
|000004d0| 1a 00 01 2e f4 00 01 1a | 00 01 f5 19 00 fd 13 17 |........|........|
|000004e0| 80 01 0f 18 00 00 00 00 | 00 00 22 40 1a 00 01 d4 |........|.."@....|
|000004f0| ff 1d d1 ff 18 00 00 00 | 00 00 00 f0 3f f4 00 01 |........|....?...|
|00000500| 1a 03 01 18 00 00 00 00 | 00 00 f0 3f 1d 16 00 1a |........|...?....|
|00000510| 03 01 18 00 00 00 00 00 | 00 f0 3f f7 1a 00 01 2e |........|..?.....|
|00000520| f4 00 01 1a 00 01 f5 ec | 01 18 00 00 00 00 00 00 |........|........|
|00000530| 10 40 1a 00 01 d4 d2 f4 | 00 08 1a 00 08 18 00 00 |.@......|........|
|00000540| 00 00 00 00 00 00 3e f2 | c8 01 18 00 00 00 00 00 |......>.|........|
|00000550| 00 00 40 f4 03 05 18 00 | 00 00 00 00 00 00 40 1a |..@.....|......@.|
|00000560| 00 01 d4 d2 f4 03 02 1a | 03 02 18 00 00 00 00 00 |........|........|
|00000570| 00 20 40 1a 03 05 d4 d2 | 3b f2 27 00 1a 03 05 2a |. @.....|;.'....*|
|00000580| 00 00 00 00 00 00 f0 3f | f4 03 05 1a 03 05 1a 00 |.......?|........|
|00000590| 00 3a f2 0b 00 1a 00 00 | f4 03 05 1d 05 00 1d c8 |.:......|........|
|000005a0| ff fd 32 17 01 1f 18 00 | 00 00 00 00 00 14 40 1a |..2.....|......@.|
|000005b0| 00 01 d4 d2 18 00 00 00 | 00 00 00 22 40 1a 03 05 |........|..."@...|
|000005c0| d4 d2 2e ff 01 0f 18 00 | 00 00 00 00 00 22 40 1a |........|....."@.|
|000005d0| 03 05 d4 ff 18 00 00 00 | 00 00 00 1c 40 1a 00 01 |........|....@...|
|000005e0| d4 d2 18 00 00 00 00 00 | 00 00 00 39 f2 11 00 18 |........|...9....|
|000005f0| 00 00 00 00 00 00 00 00 | f4 03 03 1d 2b 00 18 00 |........|....+...|
|00000600| 00 00 00 00 00 08 40 1a | 00 01 d4 d2 18 00 00 00 |......@.|........|
|00000610| 00 00 00 00 40 1a 00 01 | d4 d2 2f 2a 00 00 00 00 |....@...|../*....|
|00000620| 00 00 f0 3f f4 03 03 1a | 00 08 2d 00 00 00 00 00 |...?....|..-.....|
|00000630| 00 59 40 1a 03 03 30 18 | 00 00 00 00 00 00 00 40 |.Y@...0.|.......@|
|00000640| 1a 00 01 d4 d2 2e f4 03 | 04 18 00 00 00 00 00 00 |........|........|
|00000650| 00 40 1a 00 01 d4 d2 f4 | 03 07 1a 03 03 18 00 00 |.@......|........|
|00000660| 00 00 00 00 00 00 39 f2 | 0b 00 1a 00 06 f4 00 04 |......9.|........|
|00000670| 1d 08 00 1a 00 05 f4 00 | 04 1a 00 04 1a 00 05 39 |........|.......9|
|00000680| f2 8f 00 18 00 00 00 00 | 00 00 20 40 1a 03 05 d4 |........|.. @....|
|00000690| d2 f4 03 06 1a 03 06 1a | 03 04 3c f2 0b 00 1a 03 |........|..<.....|
|000006a0| 06 f4 03 08 1d 0e 00 1a | 03 04 f4 03 08 1a 00 06 |........|........|
|000006b0| f4 00 04 1a 03 08 1a 03 | 07 2f 1a 03 03 31 18 00 |........|./...1..|
|000006c0| 00 00 00 00 00 18 40 1a | 00 01 d4 d2 30 f4 03 09 |......@.|....0...|
|000006d0| fd 27 17 01 14 18 00 00 | 00 00 00 00 22 40 1a 03 |.'......|...."@..|
|000006e0| 05 d4 d2 1a 03 09 2e ff | 01 0f 18 00 00 00 00 00 |........|........|
|000006f0| 00 22 40 1a 03 05 d4 ff | 1a 03 08 f4 03 07 1a 03 |."@.....|........|
|00000700| 05 2a 00 00 00 00 00 00 | f0 3f f4 03 05 1d 6b ff |.*......|.?....k.|
|00000710| 1d fe fd fd 13 08 01 01 | 01 01 0c 08 0f 00 00 ff |........|........|
|00000720| 7f 08 00 08 00 ff 00 fd | 03 06 01 fd 03 01 01 fd |........|........|
|00000730| 13 08 01 01 01 01 0c 08 | 0f 00 00 ff 7f 0c 00 0c |........|........|
|00000740| 00 ff 00 fd 04 06 02 00 | 18 00 00 00 00 00 00 08 |........|........|
|00000750| 40 f4 00 01 1a 00 07 18 | 00 00 00 00 00 00 f0 3f |@.......|.......?|
|00000760| 1d 16 00 1a 00 07 18 00 | 00 00 00 00 00 f0 3f f7 |........|......?.|
|00000770| 1a 00 01 2e f4 00 01 1a | 00 01 f5 47 00 18 00 00 |........|...G....|
|00000780| 00 00 00 00 2a 40 1a 00 | 01 d4 d2 f4 00 02 fd 30 |....*@..|.......0|
|00000790| 17 01 1d 1a 00 02 18 00 | 00 00 00 00 00 2a 40 1a |........|.....*@.|
|000007a0| 00 01 2b 00 00 00 00 00 | 00 f0 3f d4 d2 2e ff 01 |..+.....|..?.....|
|000007b0| 0f 18 00 00 00 00 00 00 | 2a 40 1a 00 01 d4 ff 1d |........|*@......|
|000007c0| a3 ff 1a 00 07 2a 00 00 | 00 00 00 00 f0 3f f4 00 |.....*..|.....?..|
|000007d0| 01 1a 00 00 18 00 00 00 | 00 00 00 f0 3f 1d 16 00 |........|....?...|
|000007e0| 1a 00 00 18 00 00 00 00 | 00 00 f0 3f f7 1a 00 01 |........|...?....|
|000007f0| 2e f4 00 01 1a 00 01 f5 | 1b 00 fd 15 17 00 01 20 |........|....... |
|00000800| 01 0f 18 00 00 00 00 00 | 00 2a 40 1a 00 01 d4 ff |........|.*@.....|
|00000810| 1d cf ff 1d 5c 00 1a 00 | 06 f4 00 09 fd 03 01 01 |....\...|........|
|00000820| fd 4b 23 00 47 54 68 65 | 72 65 20 69 73 20 6e 6f |.K#.GThe|re is no|
|00000830| 74 20 65 6e 6f 75 67 68 | 20 50 72 6f 6a 65 63 74 |t enough| Project|
|00000840| 20 54 61 62 6c 65 20 64 | 61 74 61 20 74 6f 20 63 | Table d|ata to c|
|00000850| 72 65 61 74 65 20 61 6e | 20 45 61 72 6e 65 64 20 |reate an| Earned |
|00000860| 56 61 6c 75 65 20 67 72 | 61 70 68 2e fd 03 01 01 |Value gr|aph.....|
|00000870| fb f6 00 00 1a 00 05 f4 | 00 04 18 00 00 00 00 00 |........|........|
|00000880| 00 00 40 f4 00 07 1a 00 | 00 f4 00 01 18 00 00 00 |..@.....|........|
|00000890| 00 00 00 08 40 18 00 00 | 00 00 00 00 f0 3f 32 1d |....@...|.....?2.|
|000008a0| 1d 00 18 00 00 00 00 00 | 00 08 40 18 00 00 00 00 |........|..@.....|
|000008b0| 00 00 f0 3f 32 f7 1a 00 | 01 2e f4 00 01 1a 00 01 |...?2...|........|
|000008c0| f5 4a 00 1a 00 04 1a 00 | 05 39 f2 3d 00 18 00 00 |.J......|.9.=....|
|000008d0| 00 00 00 00 20 40 1a 00 | 01 d4 d2 f4 00 02 18 00 |.... @..|........|
|000008e0| 00 00 00 00 00 20 40 1a | 00 01 2b 00 00 00 00 00 |..... @.|..+.....|
|000008f0| 00 f0 3f d4 d2 1a 00 02 | 3e f2 0e 00 1a 00 01 f4 |..?.....|>.......|
|00000900| 00 07 1a 00 06 f4 00 04 | 1d 99 ff fb f6 00 00 fd |........|........|
|00000910| 05 1a 05 00 0d fd 05 1a | 05 00 04 fd 05 1a 05 00 |........|........|
|00000920| 03 fd 05 1a 05 00 05 fd | 13 08 01 01 01 01 0c 08 |........|........|
|00000930| 0f 00 00 00 00 00 00 ff | 7f ff 00 fd 02 0c 1a 00 |........|........|
|00000940| 00 2a 00 00 00 00 00 00 | f0 3f f4 00 00 1a 00 07 |.*......|.?......|
|00000950| 2a 00 00 00 00 00 00 f0 | 3f f4 00 07 fd 14 17 00 |*.......|?.......|
|00000960| 08 53 74 61 72 74 69 6e | 67 01 07 07 01 00 00 00 |.Startin|g.......|
|00000970| ff fd 16 17 00 0a 50 6c | 61 6e 20 43 6f 73 74 73 |......Pl|an Costs|
|00000980| 01 07 07 01 00 01 00 ff | fd 17 17 00 0b 50 6c 61 |........|.....Pla|
|00000990| 6e 20 49 6e 63 6f 6d 65 | 01 07 07 01 00 02 00 ff |n Income|........|
|000009a0| fd 18 17 00 0c 41 63 74 | 75 61 6c 20 43 6f 73 74 |.....Act|ual Cost|
|000009b0| 73 01 07 07 01 00 03 00 | ff fd 19 17 00 0d 41 63 |s.......|......Ac|
|000009c0| 74 75 61 6c 20 49 6e 63 | 6f 6d 65 01 07 07 01 00 |tual Inc|ome.....|
|000009d0| 04 00 ff fd 12 17 00 06 | 45 6e 64 69 6e 67 01 07 |........|Ending..|
|000009e0| 07 01 00 05 00 ff fd 15 | 17 00 09 50 6c 61 6e 20 |........|...Plan |
|000009f0| 43 75 6d 2e 01 07 07 01 | 00 06 00 ff fd 17 17 00 |Cum.....|........|
|00000a00| 0b 41 63 74 75 61 6c 20 | 43 75 6d 2e 01 07 07 01 |.Actual |Cum.....|
|00000a10| 00 07 00 ff fd 10 17 00 | 04 44 61 74 65 01 07 07 |........|.Date...|
|00000a20| 01 00 09 00 ff fd 10 17 | 00 04 42 43 57 53 01 07 |........|..BCWS..|
|00000a30| 07 01 00 0a 00 ff fd 10 | 17 00 04 41 43 57 50 01 |........|...ACWP.|
|00000a40| 07 07 01 00 0b 00 ff fd | 10 17 00 04 42 43 57 50 |........|....BCWP|
|00000a50| 01 07 07 01 00 0c 00 ff | fd 13 08 01 01 01 01 0c |........|........|
|00000a60| 08 0f 01 00 01 00 00 00 | 0c 00 ff 00 fd 07 0f 03 |........|........|
|00000a70| 03 00 01 42 fd 04 0f 04 | 02 fd 28 08 01 01 01 01 |...B....|..(.....|
|00000a80| 21 18 00 00 00 00 00 00 | 26 40 18 00 00 00 00 00 |!.......|&@......|
|00000a90| 00 08 40 18 00 00 00 00 | 00 00 2a 40 1a 00 00 d8 |..@.....|..*@....|
|00000aa0| ff 00 fd 05 0f 05 00 20 | fd 06 0f 05 02 01 09 fd |....... |........|
|00000ab0| 28 08 01 01 01 01 21 18 | 00 00 00 00 00 00 24 40 |(.....!.|......$@|
|00000ac0| 18 00 00 00 00 00 00 08 | 40 18 00 00 00 00 00 00 |........|@.......|
|00000ad0| 24 40 1a 00 00 d8 ff 00 | fd 06 0f 05 00 50 81 fd |$@......|.....P..|
|00000ae0| 28 08 01 01 01 01 21 18 | 00 00 00 00 00 00 f0 3f |(.....!.|.......?|
|00000af0| 18 00 00 00 00 00 00 00 | 40 18 00 00 00 00 00 00 |........|@.......|
|00000b00| 2a 40 1a 00 00 d8 ff 00 | fd 0f 0f 03 01 00 09 48 |*@......|.......H|
|00000b10| 65 6c 76 65 74 69 63 61 | fd 07 19 01 01 02 00 09 |elvetica|........|
|00000b20| fd 09 0f 0a 00 04 54 42 | 4c 52 fd 28 08 01 01 01 |......TB|LR.(....|
|00000b30| 01 21 18 00 00 00 00 00 | 00 22 40 18 00 00 00 00 |.!......|."@.....|
|00000b40| 00 00 f0 3f 18 00 00 00 | 00 00 00 22 40 1a 00 00 |...?....|..."@...|
|00000b50| d8 ff 00 fd 09 0f 0a 00 | 04 74 62 6c 72 fd 07 19 |........|.tblr...|
|00000b60| 01 01 02 d0 02 fd 28 08 | 01 01 01 01 21 18 00 00 |......(.|....!...|
|00000b70| 00 00 00 00 00 40 18 00 | 00 00 00 00 00 00 40 18 |.....@..|......@.|
|00000b80| 00 00 00 00 00 00 14 40 | 1a 00 00 d8 ff 00 fd 28 |.......@|.......(|
|00000b90| 08 00 01 01 01 21 18 00 | 00 00 00 00 00 1c 40 18 |.....!..|......@.|
|00000ba0| 00 00 00 00 00 00 00 40 | 18 00 00 00 00 00 00 20 |.......@|....... |
|00000bb0| 40 1a 00 00 d8 ff 00 fd | 05 0f 05 00 20 fd 06 0f |@.......|.... ...|
|00000bc0| 05 02 01 09 fd 04 08 01 | 07 fb f6 00 02 1a 00 00 |........|........|
|00000bd0| 18 00 00 00 00 00 00 26 | 40 3a f2 98 00 1a 00 00 |.......&|@:......|
|00000be0| 2b 00 00 00 00 00 00 f0 | 3f 2d 00 00 00 00 00 00 |+.......|?-......|
|00000bf0| 22 40 95 f4 03 02 18 00 | 00 00 00 00 00 00 40 f4 |"@......|......@.|
|00000c00| 03 01 1a 03 02 18 00 00 | 00 00 00 00 f0 3f 1d 16 |........|.....?..|
|00000c10| 00 1a 03 02 18 00 00 00 | 00 00 00 f0 3f f7 1a 03 |........|....?...|
|00000c20| 01 2e f4 03 01 1a 03 01 | f5 4a 00 1a 03 01 2a 00 |........|.J....*.|
|00000c30| 00 00 00 00 00 f0 3f f4 | 00 01 1a 00 00 1a 03 02 |......?.|........|
|00000c40| 1d 10 00 1a 00 00 1a 03 | 02 f7 1a 00 01 2e f4 00 |........|........|
|00000c50| 01 1a 00 01 f5 1b 00 fd | 15 17 00 01 20 01 0f 18 |........|.... ...|
|00000c60| 00 00 00 00 00 00 24 40 | 1a 00 01 d4 ff 1d d5 ff |......$@|........|
|00000c70| 1d a0 ff fb f6 00 05 18 | 00 00 00 00 00 00 26 40 |........|......&@|
|00000c80| 1a 00 07 d4 d2 f4 03 01 | 18 00 00 00 00 00 00 28 |........|.......(|
|00000c90| 40 1a 00 07 d4 d2 f4 03 | 02 18 00 00 00 00 00 00 |@.......|........|
|00000ca0| 2a 40 1a 00 07 d4 d2 f4 | 03 03 1a 03 03 18 00 00 |*@......|........|
|00000cb0| 00 00 00 00 00 00 39 f2 | 1d 00 18 00 00 00 00 00 |......9.|........|
|00000cc0| 00 00 00 f4 03 04 18 00 | 00 00 00 00 00 00 00 f4 |........|........|
|00000cd0| 03 05 1d 30 00 1a 03 03 | 1a 03 02 2f 1a 03 03 31 |...0....|.../...1|
|00000ce0| 2c 00 00 00 00 00 00 59 | 40 f4 03 04 1a 03 03 1a |,......Y|@.......|
|00000cf0| 03 01 2f 1a 03 03 31 2c | 00 00 00 00 00 00 59 40 |../...1,|......Y@|
|00000d00| f4 03 05 fd 21 17 01 05 | 1a 03 04 ff 01 18 18 00 |....!...|........|
|00000d10| 00 00 00 00 00 28 40 1a | 00 00 2a 00 00 00 00 00 |.....(@.|..*.....|
|00000d20| 00 00 40 d4 ff fd 21 17 | 01 05 1a 03 05 ff 01 18 |..@...!.|........|
|00000d30| 18 00 00 00 00 00 00 28 | 40 1a 00 00 2a 00 00 00 |.......(|@...*...|
|00000d40| 00 00 00 08 40 d4 ff fd | 55 17 01 39 19 0f 43 6f |....@...|U..9..Co|
|00000d50| 73 74 20 56 61 72 69 61 | 6e 63 65 3a 20 18 00 00 |st Varia|nce: ...|
|00000d60| 00 00 00 00 28 40 1a 00 | 00 2a 00 00 00 00 00 00 |....(@..|.*......|
|00000d70| 00 40 d4 d2 18 00 00 00 | 00 00 00 f0 3f b9 35 19 |.@......|....?.5.|
|00000d80| 01 25 35 ff 01 18 18 00 | 00 00 00 00 00 28 40 1a |.%5.....|.....(@.|
|00000d90| 00 00 2a 00 00 00 00 00 | 00 00 40 d4 ff fd 59 17 |..*.....|..@...Y.|
|00000da0| 01 3d 19 13 53 63 68 65 | 64 75 6c 65 20 56 61 72 |.=..Sche|dule Var|
|00000db0| 69 61 6e 63 65 3a 20 18 | 00 00 00 00 00 00 28 40 |iance: .|......(@|
|00000dc0| 1a 00 00 2a 00 00 00 00 | 00 00 08 40 d4 d2 18 00 |...*....|...@....|
|00000dd0| 00 00 00 00 00 f0 3f b9 | 35 19 01 25 35 ff 01 18 |......?.|5..%5...|
|00000de0| 18 00 00 00 00 00 00 28 | 40 1a 00 00 2a 00 00 00 |.......(|@...*...|
|00000df0| 00 00 00 08 40 d4 ff fd | 34 08 01 01 01 01 2d 18 |....@...|4.....-.|
|00000e00| 00 00 00 00 00 00 28 40 | 1a 00 00 2a 00 00 00 00 |......(@|...*....|
|00000e10| 00 00 00 40 18 00 00 00 | 00 00 00 2a 40 1a 00 00 |...@....|...*@...|
|00000e20| 2a 00 00 00 00 00 00 08 | 40 d8 ff 00 fd 06 0f 0a |*.......|@.......|
|00000e30| 00 01 4f fb f6 00 00 fd | 04 08 01 07 fd 59 15 00 |..O.....|.....Y..|
|00000e40| 04 01 31 08 0f 00 00 14 | 00 10 00 16 00 18 00 00 |..1.....|........|
|00000e50| 00 00 00 00 f0 3f 18 00 | 00 00 00 00 00 00 00 18 |.....?..|........|
|00000e60| 00 00 00 00 00 80 58 40 | 18 00 00 00 00 00 80 5f |......X@|......._|
|00000e70| 40 e3 ff 01 22 18 00 00 | 00 00 00 00 24 40 18 00 |@..."...|....$@..|
|00000e80| 00 00 00 00 00 00 40 18 | 00 00 00 00 00 00 2a 40 |......@.|......*@|
|00000e90| 1a 00 00 d8 d3 ff fd 08 | 09 01 04 01 81 00 00 fd |........|........|
|00000ea0| 04 16 00 01 fd 05 16 06 | 0e 03 fd 34 08 00 01 01 |........|...4....|
|00000eb0| 01 2d 18 00 00 00 00 00 | 00 28 40 1a 00 00 2a 00 |.-......|.(@...*.|
|00000ec0| 00 00 00 00 00 00 40 18 | 00 00 00 00 00 00 28 40 |......@.|......(@|
|00000ed0| 1a 00 00 2a 00 00 00 00 | 00 00 08 40 d8 ff 00 fd |...*....|...@....|
|00000ee0| 07 0f 03 02 02 09 00 fd | 0f 0f 03 01 00 09 48 65 |........|......He|
|00000ef0| 6c 76 65 74 69 63 61 fd | 04 16 02 02 fd 05 16 02 |lvetica.|........|
|00000f00| 00 04 fd 04 08 01 07 fd | 08 09 01 04 01 81 00 00 |........|........|
|00000f10| fd 2b 17 01 20 19 0f 45 | 61 72 6e 65 64 20 56 61 |.+.. ..E|arned Va|
|00000f20| 6c 75 65 20 2d 20 5f 19 | 08 6d 6d 2f 64 64 2f 79 |lue - _.|.mm/dd/y|
|00000f30| 79 68 35 ff 01 07 07 00 | 00 09 00 ff fd 0e 08 01 |yh5.....|........|
|00000f40| 01 01 01 07 07 00 00 09 | 00 ff 00 fd 07 0f 03 02 |........|........|
|00000f50| 02 0c 00 fd 0f 0f 03 01 | 00 09 48 65 6c 76 65 74 |........|..Helvet|
|00000f60| 69 63 61 fd 07 0f 03 03 | 00 01 42 fd 07 0f 03 03 |ica.....|..B.....|
|00000f70| 00 01 49 fd 08 09 00 04 | 01 81 00 00 fd 04 16 01 |..I.....|........|
|00000f80| 02 fd 05 16 01 00 04 fd | 0c 09 01 04 01 81 00 04 |........|........|
|00000f90| 00 01 81 00 fd 06 0f 01 | 01 02 86 fd 0e 0f 01 01 |........|........|
|00000fa0| 00 03 00 00 00 00 00 40 | 65 41 fd 0c 09 01 04 01 |.......@|eA......|
|00000fb0| 81 00 04 00 01 82 00 fd | 06 0f 01 01 02 81 fd 08 |........|........|
|00000fc0| 0f 01 01 00 02 aa 00 fd | 0c 09 01 04 01 81 00 04 |........|........|
|00000fd0| 00 01 83 00 fd 06 0f 01 | 01 00 80 fd 0e 0f 01 01 |........|........|
|00000fe0| 01 03 00 00 00 e0 ff ff | 6f 41 fd 06 0f 01 01 02 |........|oA......|
|00000ff0| 81 fd 07 0f 01 00 02 3c | 00 fd 0d 09 01 04 01 81 |.......<|........|
|00001000| 00 06 00 01 81 00 00 1a | 00 00 18 00 00 00 00 00 |........|........|
|00001010| 00 34 40 3a f2 08 00 fd | 05 16 04 02 00 fd 07 16 |.4@:....|........|
|00001020| 04 04 01 00 80 fd 0f 16 | 04 04 01 01 03 00 00 00 |........|........|
|00001030| e0 ff ff 6f 41 fd 07 16 | 04 04 01 02 80 fd 06 16 |...oA...|........|
|00001040| 04 04 00 85 fd 0f 16 04 | 03 01 00 03 00 00 00 60 |........|.......`|
|00001050| 77 77 67 41 fd 0f 16 04 | 03 01 01 03 00 00 00 e0 |wwgA....|........|
|00001060| ff ff 6f 41 fd 07 16 04 | 03 01 02 80 fd 06 16 04 |..oA....|........|
|00001070| 03 00 80 fd 0d 09 01 04 | 01 81 00 06 00 01 83 00 |........|........|
|00001080| 00 fd 07 16 04 04 01 00 | 80 fd 0f 16 04 04 01 01 |........|........|
|00001090| 03 00 00 00 e0 ff ff 6f | 41 fd 07 16 04 04 01 02 |.......o|A.......|
|000010a0| 81 fd 06 16 04 04 00 85 | fd 07 16 04 03 01 00 80 |........|........|
|000010b0| fd 0f 16 04 03 01 01 03 | 00 00 00 e0 ff ff 6f 41 |........|......oA|
|000010c0| fd 07 16 04 03 01 02 81 | fd 06 16 04 03 00 80 fd |........|........|
|000010d0| 0e 08 01 01 01 01 07 07 | 00 00 17 00 ff 00 fd 0e |........|........|
|000010e0| 08 01 01 01 01 07 07 00 | 00 10 00 ff 00 fd 03 06 |........|........|
|000010f0| 01 fd 04 08 01 07 fb f6 | 00 00 fd 12 1d 00 00 00 |........|........|
|00001100| 02 ff ff 02 ff ff 00 02 | 50 19 02 70 08 fd 4f 1e |........|P..p..O.|
|00001110| 0b 00 3b 43 6f 70 79 20 | 63 68 61 72 74 20 74 6f |..;Copy |chart to|
|00001120| 20 43 6c 69 70 62 6f 61 | 72 64 20 61 6e 64 20 63 | Clipboa|rd and c|
|00001130| 6c 6f 73 65 20 77 6f 72 | 6b 73 68 65 65 74 20 77 |lose wor|ksheet w|
|00001140| 69 74 68 6f 75 74 20 73 | 61 76 69 6e 67 3f 00 00 |ithout s|aving?..|
|00001150| 02 b4 00 02 b4 00 01 02 | e8 17 02 d0 02 fd 06 0f |........|........|
|00001160| 02 00 1c 00 fd 2e 1e 00 | 01 00 0a 20 20 20 20 4e |........|...    N|
|00001170| 6f 20 20 20 20 01 00 0b | 20 20 20 20 59 65 73 20 |o    ...|    Yes |
|00001180| 20 20 20 00 00 00 02 48 | 12 02 84 03 01 02 a0 05 |   ....H|........|
|00001190| 02 38 04 fd 06 1d 0b 01 | 82 00 fd 03 1d 09 fd 24 |.8......|.......$|
|000011a0| 21 03 00 00 1e 27 45 61 | 72 6e 65 64 20 56 61 6c |!....'Ea|rned Val|
|000011b0| 75 65 20 53 63 72 69 70 | 74 3a 64 6f 6e 65 27 20 |ue Scrip|t:done' |
|000011c0| 3d 20 30 fd 06 1d 0b 01 | 83 00 fd 03 1d 08 fd 24 |= 0.....|.......$|
|000011d0| 21 03 00 00 1e 27 45 61 | 72 6e 65 64 20 56 61 6c |!....'Ea|rned Val|
|000011e0| 75 65 20 53 63 72 69 70 | 74 3a 64 6f 6e 65 27 20 |ue Scrip|t:done' |
|000011f0| 3d 20 31 fd 03 1d 03 1a | 00 04 18 00 00 00 00 00 |= 1.....|........|
|00001200| 00 f0 3f 39 f2 13 00 fd | 08 09 01 04 01 81 00 00 |..?9....|........|
|00001210| fd 03 06 01 fd 03 01 01 | fb fc 09 00 6c 61 73 74 |........|....last|
|00001220| 5f 72 6f 77 00 09 00 6c | 6f 6f 70 5f 76 61 72 01 |_row...l|oop_var.|
|00001230| 0d 00 74 68 65 5f 63 6f | 6e 74 65 6e 74 73 02 09 |..the_co|ntents..|
|00001240| 00 63 65 6c 6c 5f 73 74 | 72 03 05 00 64 6f 6e 65 |.cell_st|r...done|
|00001250| 04 06 00 66 61 6c 73 65 | 05 05 00 74 72 75 65 06 |...false|...true.|
|00001260| 0d 00 74 69 6d 65 5f 6e | 6f 77 5f 72 6f 77 07 0d |..time_n|ow_row..|
|00001270| 00 70 65 72 63 65 6e 74 | 5f 64 6f 6e 65 08 0c 00 |.percent|_done...|
|00001280| 73 74 6f 70 5f 73 63 72 | 69 70 74 09 10 01 00 4d |stop_scr|ipt....M|
|00001290| 41 4b 45 5f 4e 45 57 5f | 53 48 45 45 54 e6 00 00 |AKE_NEW_|SHEET...|
|000012a0| 00 0f 01 00 44 4f 5f 49 | 4e 49 54 49 41 4c 49 5a |....DO_I|NITIALIZ|
|000012b0| 45 4b 01 00 00 0a 01 00 | 47 45 54 5f 52 4f 57 53 |EK......|GET_ROWS|
|000012c0| 35 01 00 00 0f 01 00 43 | 41 4c 43 5f 54 49 4d 45 |5......C|ALC_TIME|
|000012d0| 5f 4e 4f 57 99 07 00 00 | 10 01 00 43 41 4c 43 55 |_NOW....|...CALCU|
|000012e0| 4c 41 54 45 5f 42 43 57 | 53 f9 01 00 00 10 01 00 |LATE_BCW|S.......|
|000012f0| 43 41 4c 43 55 4c 41 54 | 45 5f 41 43 57 50 77 02 |CALCULAT|E_ACWPw.|
|00001300| 00 00 10 01 00 43 41 4c | 43 55 4c 41 54 45 5f 42 |.....CAL|CULATE_B|
|00001310| 43 57 50 46 03 00 00 10 | 01 00 44 41 54 45 5f 52 |CWPF....|..DATE_R|
|00001320| 45 44 55 43 54 49 4f 4e | f2 0a 00 00 14 01 00 43 |EDUCTION|.......C|
|00001330| 41 4c 43 55 4c 41 54 45 | 5f 56 41 52 49 41 4e 43 |ALCULATE|_VARIANC|
|00001340| 45 9c 0b 00 00 0e 01 00 | 46 4f 52 4d 41 54 5f 54 |E.......|FORMAT_T|
|00001350| 41 42 4c 45 34 08 00 00 | 0e 01 00 43 52 45 41 54 |ABLE4...|...CREAT|
|00001360| 45 5f 43 48 41 52 54 5c | 0d 00 00 0d 01 00 41 53 |E_CHART\|......AS|
|00001370| 4b 5f 54 4f 5f 43 4f 50 | 59 1f 10 00 00 7b 2a 2a |K_TO_COP|Y....{**|
|00001380| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001390| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000013a0| 2a 2a 2a 20 45 41 52 4e | 45 44 20 56 41 4c 55 45 |*** EARN|ED VALUE|
|000013b0| 20 53 43 52 49 50 54 20 | 2a 2a 2a 2a 2a 2a 2a 2a | SCRIPT |********|
|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 0d 20 20 a9 20 | 31 39 39 31 20 43 6c 61 |***.  . |1991 Cla|
|000013f0| 72 69 73 20 43 6f 72 70 | 6f 72 61 74 69 6f 6e 2e |ris Corp|oration.|
|00001400| 20 20 41 6c 6c 20 72 69 | 67 68 74 73 20 72 65 73 |  All ri|ghts res|
|00001410| 65 72 76 65 64 2e 0d 0d | 20 20 4c 41 53 54 20 4d |erved...|  LAST M|
|00001420| 4f 44 49 46 49 45 44 3a | 20 20 31 2f 31 34 2f 39 |ODIFIED:|  1/14/9|
|00001430| 31 0d 0d 20 20 54 61 62 | 6c 65 73 20 55 73 65 64 |1..  Tab|les Used|
|00001440| 3a 0d 09 a5 20 20 50 72 | 6f 6a 65 63 74 20 54 61 |:...  Pr|oject Ta|
|00001450| 62 6c 65 0d 09 a5 20 20 | 43 61 73 68 20 46 6c 6f |ble...  |Cash Flo|
|00001460| 77 20 54 61 62 6c 65 0d | 0d 20 20 41 73 73 75 6d |w Table.|.  Assum|
|00001470| 70 74 69 6f 6e 73 3a 0d | 09 a5 20 20 43 61 73 68 |ptions:.|..  Cash|
|00001480| 20 46 6c 6f 77 20 22 45 | 6e 64 69 6e 67 22 20 63 | Flow "E|nding" c|
|00001490| 6f 6c 75 6d 6e 20 69 73 | 20 69 6e 20 63 6f 6c 75 |olumn is| in colu|
|000014a0| 6d 6e 20 36 3b 0d 09 a5 | 20 20 43 61 73 68 20 46 |mn 6;...|  Cash F|
|000014b0| 6c 6f 77 20 22 50 6c 61 | 6e 20 43 75 6d 75 6c 61 |low "Pla|n Cumula|
|000014c0| 74 69 76 65 22 20 69 73 | 20 63 6f 6c 75 6d 6e 20 |tive" is| column |
|000014d0| 37 3b 0d 09 a5 20 20 43 | 61 73 68 20 46 6c 6f 77 |7;...  C|ash Flow|
|000014e0| 20 22 41 63 74 75 61 6c | 20 43 75 6d 75 6c 61 74 | "Actual| Cumulat|
|000014f0| 69 76 65 22 20 69 73 20 | 63 6f 6c 75 6d 6e 20 38 |ive" is |column 8|
|00001500| 3b 0d 09 a5 20 20 54 69 | 6d 65 20 4e 6f 77 20 69 |;...  Ti|me Now i|
|00001510| 73 20 62 65 74 77 65 65 | 6e 20 74 68 65 20 6c 61 |s betwee|n the la|
|00001520| 73 74 20 74 77 6f 20 64 | 69 66 66 65 72 65 6e 74 |st two d|ifferent|
|00001530| 20 76 61 6c 75 65 73 20 | 69 6e 20 74 68 65 20 22 | values |in the "|
|00001540| 41 63 74 75 61 6c 0d 20 | 20 20 20 20 20 20 20 43 |Actual. |       C|
|00001550| 75 6d 75 6c 61 74 69 76 | 65 22 20 63 6f 6c 75 6d |umulativ|e" colum|
|00001560| 6e 3b 0d 09 a5 20 20 50 | 72 6f 6a 65 63 74 20 54 |n;...  P|roject T|
|00001570| 61 62 6c 65 20 22 4e 61 | 6d 65 22 20 69 73 20 69 |able "Na|me" is i|
|00001580| 6e 20 63 6f 6c 75 6d 6e | 20 31 3b 0d 20 20 09 a5 |n column| 1;.  ..|
|00001590| 20 20 50 72 6f 6a 65 63 | 74 20 54 61 62 6c 65 20 |  Projec|t Table |
|000015a0| 22 41 63 74 75 61 6c 20 | 53 74 61 72 74 22 20 69 |"Actual |Start" i|
|000015b0| 73 20 69 6e 20 63 6f 6c | 75 6d 6e 20 32 3b 0d 20 |s in col|umn 2;. |
|000015c0| 20 09 a5 20 20 50 72 6f | 6a 65 63 74 20 54 61 62 | ..  Pro|ject Tab|
|000015d0| 6c 65 20 22 41 63 74 75 | 61 6c 20 46 69 6e 69 73 |le "Actu|al Finis|
|000015e0| 68 22 20 69 73 20 69 6e | 20 63 6f 6c 75 6d 6e 20 |h" is in| column |
|000015f0| 33 3b 0d 20 20 09 a5 20 | 20 50 72 6f 6a 65 63 74 |3;.  .. | Project|
|00001600| 20 54 61 62 6c 65 20 22 | 25 44 6f 6e 65 22 20 69 | Table "|%Done" i|
|00001610| 73 20 69 6e 20 63 6f 6c | 75 6d 6e 20 34 3b 0d 20 |s in col|umn 4;. |
|00001620| 20 09 a5 20 20 50 72 6f | 6a 65 63 74 20 54 61 62 | ..  Pro|ject Tab|
|00001630| 6c 65 20 22 46 69 78 65 | 64 20 43 6f 73 74 22 20 |le "Fixe|d Cost" |
|00001640| 69 73 20 69 6e 20 63 6f | 6c 75 6d 6e 20 35 3b 0d |is in co|lumn 5;.|
|00001650| 20 20 09 a5 20 20 50 72 | 6f 6a 65 63 74 20 54 61 |  ..  Pr|oject Ta|
|00001660| 62 6c 65 20 22 52 65 73 | 6f 75 72 63 65 20 43 6f |ble "Res|ource Co|
|00001670| 73 74 22 20 69 73 20 69 | 6e 20 63 6f 6c 75 6d 6e |st" is i|n column|
|00001680| 20 36 3b 0d 09 a5 20 20 | 50 72 6f 6a 65 63 74 20 | 6;...  |Project |
|00001690| 54 61 62 6c 65 20 22 41 | 63 74 75 61 6c 20 44 61 |Table "A|ctual Da|
|000016a0| 79 73 22 20 69 73 20 69 | 6e 20 63 6f 6c 75 6d 6e |ys" is i|n column|
|000016b0| 20 37 2e 0d 0d 20 20 4e | 6f 74 65 73 3a 0d 09 45 | 7...  N|otes:..E|
|000016c0| 61 72 6e 65 64 20 76 61 | 6c 75 65 20 63 61 6c 63 |arned va|lue calc|
|000016d0| 75 6c 61 74 69 6f 6e 73 | 20 68 65 6c 70 20 61 20 |ulations| help a |
|000016e0| 70 72 6f 6a 65 63 74 20 | 70 6c 61 6e 6e 65 72 20 |project |planner |
|000016f0| 64 65 74 65 72 6d 69 6e | 65 20 68 6f 77 20 61 20 |determin|e how a |
|00001700| 70 72 6f 6a 65 63 74 20 | 69 73 20 70 72 6f 67 72 |project |is progr|
|00001710| 65 73 73 69 6e 67 0d 09 | 69 6e 20 63 6f 6d 70 61 |essing..|in compa|
|00001720| 72 69 73 6f 6e 20 74 6f | 20 74 68 65 20 70 6c 61 |rison to| the pla|
|00001730| 6e 6e 65 64 20 70 72 6f | 67 72 65 73 73 20 2d 2d |nned pro|gress --|
|00001740| 20 69 6e 20 74 65 72 6d | 73 20 6f 66 20 62 6f 74 | in term|s of bot|
|00001750| 68 20 63 6f 73 74 20 61 | 6e 64 20 73 63 68 65 64 |h cost a|nd sched|
|00001760| 75 6c 65 2e 20 54 68 65 | 20 66 6f 6c 6c 6f 77 69 |ule. The| followi|
|00001770| 6e 67 0d 09 64 65 66 69 | 6e 69 74 69 6f 6e 73 20 |ng..defi|nitions |
|00001780| 61 72 65 20 73 74 61 6e | 64 61 72 64 20 70 72 6f |are stan|dard pro|
|00001790| 6a 65 63 74 20 6d 61 6e | 61 67 65 6d 65 6e 74 20 |ject man|agement |
|000017a0| 74 65 72 6d 73 20 75 73 | 65 64 20 74 6f 20 63 61 |terms us|ed to ca|
|000017b0| 6c 63 75 6c 61 74 65 20 | 22 45 61 72 6e 65 64 20 |lculate |"Earned |
|000017c0| 56 61 6c 75 65 2e 22 20 | 20 0d 09 42 75 64 67 65 |Value." | ..Budge|
|000017d0| 74 65 64 20 43 6f 73 74 | 20 6f 66 20 57 6f 72 6b |ted Cost| of Work|
|000017e0| 20 53 63 68 65 64 75 6c | 65 64 20 28 42 43 57 53 | Schedul|ed (BCWS|
|000017f0| 29 0d 09 41 63 74 75 61 | 6c 20 43 6f 73 74 20 6f |)..Actua|l Cost o|
|00001800| 66 20 57 6f 72 6b 20 50 | 65 72 66 6f 72 6d 65 64 |f Work P|erformed|
|00001810| 20 28 41 43 57 50 29 0d | 09 42 75 64 67 65 74 65 | (ACWP).|.Budgete|
|00001820| 64 20 43 6f 73 74 20 6f | 66 20 57 6f 72 6b 20 50 |d Cost o|f Work P|
|00001830| 65 72 66 6f 72 6d 65 64 | 20 28 42 43 57 50 29 0d |erformed| (BCWP).|
|00001840| 09 0d 0d 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |...*****|********|
|00001850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001860| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 44 45 46 49 4e 45 |********|* DEFINE|
|00001870| 20 47 4c 4f 42 41 4c 20 | 56 41 52 49 41 42 4c 45 | GLOBAL |VARIABLE|
|00001880| 53 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |S ******|********|
|00001890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000018a0| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 44 45 46 49 4e |********|}..DEFIN|
|000018b0| 45 20 6c 61 73 74 5f 72 | 6f 77 09 09 09 7b 20 4c |E last_r|ow...{ L|
|000018c0| 61 73 74 20 72 6f 77 20 | 6f 66 20 74 68 65 20 74 |ast row |of the t|
|000018d0| 61 62 6c 65 20 7d 0d 44 | 45 46 49 4e 45 20 6c 6f |able }.D|EFINE lo|
|000018e0| 6f 70 5f 76 61 72 09 09 | 09 7b 20 4c 6f 6f 70 20 |op_var..|.{ Loop |
|000018f0| 69 74 65 72 61 74 69 6f | 6e 20 63 6f 75 6e 74 65 |iteratio|n counte|
|00001900| 72 20 7d 0d 44 45 46 49 | 4e 45 20 74 68 65 5f 63 |r }.DEFI|NE the_c|
|00001910| 6f 6e 74 65 6e 74 73 09 | 09 09 7b 20 54 68 65 20 |ontents.|..{ The |
|00001920| 63 6f 6e 74 65 6e 74 73 | 20 6f 66 20 61 20 63 65 |contents| of a ce|
|00001930| 6c 6c 20 7d 0d 44 45 46 | 49 4e 45 20 63 65 6c 6c |ll }.DEF|INE cell|
|00001940| 5f 73 74 72 09 09 09 7b | 20 43 75 72 72 65 6e 74 |_str...{| Current|
|00001950| 20 63 65 6c 6c 20 6c 6f | 63 61 74 69 6f 6e 20 7d | cell lo|cation }|
|00001960| 0d 44 45 46 49 4e 45 20 | 64 6f 6e 65 09 09 09 09 |.DEFINE |done....|
|00001970| 7b 20 44 6f 6e 65 20 66 | 6c 61 67 20 7d 0d 44 45 |{ Done f|lag }.DE|
|00001980| 46 49 4e 45 20 66 61 6c | 73 65 09 09 09 09 7b 20 |FINE fal|se....{ |
|00001990| 46 61 6c 73 65 20 76 61 | 72 69 61 62 6c 65 20 7d |False va|riable }|
|000019a0| 0d 44 45 46 49 4e 45 20 | 74 72 75 65 09 09 09 09 |.DEFINE |true....|
|000019b0| 7b 20 54 72 75 65 20 76 | 61 72 69 61 62 6c 65 20 |{ True v|ariable |
|000019c0| 7d 0d 44 45 46 49 4e 45 | 20 74 69 6d 65 5f 6e 6f |}.DEFINE| time_no|
|000019d0| 77 5f 72 6f 77 09 09 09 | 7b 20 4c 6f 63 61 74 69 |w_row...|{ Locati|
|000019e0| 6f 6e 20 6f 66 20 54 69 | 6d 65 20 4e 6f 77 20 72 |on of Ti|me Now r|
|000019f0| 6f 77 20 7d 0d 44 45 46 | 49 4e 45 20 70 65 72 63 |ow }.DEF|INE perc|
|00001a00| 65 6e 74 5f 64 6f 6e 65 | 09 09 09 7b 20 50 65 72 |ent_done|...{ Per|
|00001a10| 63 65 6e 74 61 67 65 20 | 6f 66 20 70 72 6f 6a 65 |centage |of proje|
|00001a20| 63 74 20 64 6f 6e 65 20 | 7d 0d 44 45 46 49 4e 45 |ct done |}.DEFINE|
|00001a30| 20 73 74 6f 70 5f 73 63 | 72 69 70 74 09 09 09 7b | stop_sc|ript...{|
|00001a40| 20 49 6e 64 69 63 61 74 | 65 73 20 69 66 20 73 63 | Indicat|es if sc|
|00001a50| 72 69 70 74 20 73 68 6f | 75 6c 64 20 62 65 20 73 |ript sho|uld be s|
|00001a60| 74 6f 70 70 65 64 20 62 | 65 63 61 75 73 65 20 6f |topped b|ecause o|
|00001a70| 66 20 69 6e 73 75 66 66 | 69 63 69 65 6e 74 20 64 |f insuff|icient d|
|00001a80| 61 74 61 20 7d 0d 0d 66 | 61 6c 73 65 20 3d 20 30 |ata }..f|alse = 0|
|00001a90| 09 09 09 09 09 7b 20 53 | 65 74 20 46 61 6c 73 65 |.....{ S|et False|
|00001aa0| 20 66 6c 61 67 20 74 6f | 20 30 20 7d 0d 74 72 75 | flag to| 0 }.tru|
|00001ab0| 65 20 3d 20 31 09 09 09 | 09 09 7b 20 53 65 74 20 |e = 1...|..{ Set |
|00001ac0| 54 72 75 65 20 66 6c 61 | 67 20 74 6f 20 31 20 7d |True fla|g to 1 }|
|00001ad0| 0d 64 6f 6e 65 20 3d 20 | 66 61 6c 73 65 09 09 09 |.done = |false...|
|00001ae0| 09 7b 20 49 6e 69 74 69 | 61 6c 69 7a 65 20 7d 0d |.{ Initi|alize }.|
|00001af0| 73 74 6f 70 5f 73 63 72 | 69 70 74 20 3d 20 66 61 |stop_scr|ipt = fa|
|00001b00| 6c 73 65 09 09 09 7b 20 | 49 6e 69 74 69 61 6c 69 |lse...{ |Initiali|
|00001b10| 7a 65 20 7d 0d 0d 7b 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ze }..{*|********|
|00001b20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 4d 41 49 |********|**** MAI|
|00001b40| 4e 20 53 43 52 49 50 54 | 20 2a 2a 2a 2a 2a 2a 2a |N SCRIPT| *******|
|00001b50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001b70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 7d 0d 0d 52 45 |********|***}..RE|
|00001b80| 50 41 49 4e 54 20 4f 46 | 46 09 09 09 09 09 09 7b |PAINT OF|F......{|
|00001b90| 20 54 75 72 6e 20 52 65 | 70 61 69 6e 74 20 6f 66 | Turn Re|paint of|
|00001ba0| 66 20 74 6f 20 73 70 65 | 65 64 20 6f 70 65 72 61 |f to spe|ed opera|
|00001bb0| 74 69 6f 6e 20 7d 0d 43 | 41 4c 4c 20 4d 41 4b 45 |tion }.C|ALL MAKE|
|00001bc0| 5f 4e 45 57 5f 53 48 45 | 45 54 28 29 09 09 09 09 |_NEW_SHE|ET()....|
|00001bd0| 7b 20 43 72 65 61 74 65 | 20 61 20 6e 65 77 20 77 |{ Create| a new w|
|00001be0| 6f 72 6b 73 68 65 65 74 | 20 74 6f 20 68 6f 6c 64 |orksheet| to hold|
|00001bf0| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 20 72 65 73 | calcula|tion res|
|00001c00| 75 6c 74 73 20 7d 0d 49 | 46 20 4e 4f 54 20 73 74 |ults }.I|F NOT st|
|00001c10| 6f 70 5f 73 63 72 69 70 | 74 09 09 09 09 09 7b 20 |op_scrip|t.....{ |
|00001c20| 43 6f 6e 74 69 6e 75 65 | 20 6f 6e 6c 79 20 69 66 |Continue| only if|
|00001c30| 20 74 68 65 20 66 69 6c | 65 20 77 61 73 20 70 72 | the fil|e was pr|
|00001c40| 6f 70 65 72 6c 79 20 66 | 6f 75 6e 64 20 7d 0d 09 |operly f|ound }..|
|00001c50| 43 41 4c 4c 20 44 4f 5f | 49 4e 49 54 49 41 4c 49 |CALL DO_|INITIALI|
|00001c60| 5a 45 28 29 09 09 09 7b | 20 44 6f 20 69 6e 69 74 |ZE()...{| Do init|
|00001c70| 69 61 6c 69 7a 61 74 69 | 6f 6e 20 6f 66 20 74 68 |ializati|on of th|
|00001c80| 65 20 77 6f 72 6b 73 68 | 65 65 74 20 7d 0d 09 6c |e worksh|eet }..l|
|00001c90| 61 73 74 5f 72 6f 77 20 | 3d 20 47 45 54 5f 52 4f |ast_row |= GET_RO|
|00001ca0| 57 53 28 29 09 09 09 7b | 20 44 65 74 65 72 6d 69 |WS()...{| Determi|
|00001cb0| 6e 65 20 74 68 65 20 6e | 75 6d 62 65 72 20 6f 66 |ne the n|umber of|
|00001cc0| 20 72 6f 77 73 20 69 6e | 20 74 68 65 20 43 61 73 | rows in| the Cas|
|00001cd0| 68 20 46 6c 6f 77 20 74 | 61 62 6c 65 20 7d 0d 09 |h Flow t|able }..|
|00001ce0| 49 46 20 6c 61 73 74 5f | 72 6f 77 20 3e 20 32 09 |IF last_|row > 2.|
|00001cf0| 09 09 09 7b 20 49 46 20 | 74 68 65 72 65 20 61 72 |...{ IF |there ar|
|00001d00| 65 20 6d 6f 72 65 20 74 | 68 61 6e 20 32 20 72 6f |e more t|han 2 ro|
|00001d10| 77 73 2e 2e 2e 20 7d 0d | 09 09 43 41 4c 4c 20 43 |ws... }.|..CALL C|
|00001d20| 41 4c 43 5f 54 49 4d 45 | 5f 4e 4f 57 28 29 09 09 |ALC_TIME|_NOW()..|
|00001d30| 7b 20 44 65 74 65 72 6d | 69 6e 65 20 74 68 65 20 |{ Determ|ine the |
|00001d40| 6c 6f 63 61 74 69 6f 6e | 20 6f 66 20 74 68 65 20 |location| of the |
|00001d50| 54 69 6d 65 20 4e 6f 77 | 20 72 6f 77 20 7d 0d 09 |Time Now| row }..|
|00001d60| 09 43 41 4c 4c 20 43 41 | 4c 43 55 4c 41 54 45 5f |.CALL CA|LCULATE_|
|00001d70| 42 43 57 53 28 29 09 09 | 7b 20 43 61 6c 63 75 6c |BCWS()..|{ Calcul|
|00001d80| 61 74 65 20 76 61 6c 75 | 65 73 20 66 6f 72 20 42 |ate valu|es for B|
|00001d90| 75 64 67 65 74 65 64 20 | 43 6f 73 74 20 6f 66 20 |udgeted |Cost of |
|00001da0| 57 6f 72 6b 20 53 63 68 | 65 64 75 6c 65 64 20 7d |Work Sch|eduled }|
|00001db0| 0d 09 09 43 41 4c 4c 20 | 43 41 4c 43 55 4c 41 54 |...CALL |CALCULAT|
|00001dc0| 45 5f 41 43 57 50 28 29 | 09 09 7b 20 43 61 6c 63 |E_ACWP()|..{ Calc|
|00001dd0| 75 6c 61 74 65 20 76 61 | 6c 75 65 73 20 66 6f 72 |ulate va|lues for|
|00001de0| 20 41 63 74 75 61 6c 20 | 43 6f 73 74 20 6f 66 20 | Actual |Cost of |
|00001df0| 57 6f 72 6b 20 50 65 72 | 66 6f 72 6d 65 64 20 7d |Work Per|formed }|
|00001e00| 0d 09 09 43 41 4c 4c 20 | 43 41 4c 43 55 4c 41 54 |...CALL |CALCULAT|
|00001e10| 45 5f 42 43 57 50 28 29 | 09 09 7b 20 43 61 6c 63 |E_BCWP()|..{ Calc|
|00001e20| 75 6c 61 74 65 20 76 61 | 6c 75 65 73 20 66 6f 72 |ulate va|lues for|
|00001e30| 20 42 75 64 67 65 74 65 | 64 20 43 6f 73 74 20 6f | Budgete|d Cost o|
|00001e40| 66 20 57 6f 72 6b 20 50 | 65 72 66 6f 72 6d 65 64 |f Work P|erformed|
|00001e50| 20 7d 0d 09 09 49 46 20 | 4e 4f 54 20 73 74 6f 70 | }...IF |NOT stop|
|00001e60| 5f 73 63 72 69 70 74 09 | 09 09 7b 20 49 46 20 73 |_script.|..{ IF s|
|00001e70| 74 6f 70 5f 73 63 72 69 | 70 74 20 69 73 20 7a 65 |top_scri|pt is ze|
|00001e80| 72 6f 2e 2e 2e 20 7d 0d | 09 09 09 43 41 4c 4c 20 |ro... }.|...CALL |
|00001e90| 44 41 54 45 5f 52 45 44 | 55 43 54 49 4f 4e 28 29 |DATE_RED|UCTION()|
|00001ea0| 09 7b 20 52 65 6d 6f 76 | 65 20 75 6e 77 61 6e 74 |.{ Remov|e unwant|
|00001eb0| 65 64 20 64 61 74 65 73 | 20 7d 0d 09 09 09 43 41 |ed dates| }....CA|
|00001ec0| 4c 4c 09 43 41 4c 43 55 | 4c 41 54 45 5f 56 41 52 |LL.CALCU|LATE_VAR|
|00001ed0| 49 41 4e 43 45 28 29 7b | 20 43 61 6c 63 75 6c 61 |IANCE(){| Calcula|
|00001ee0| 74 65 20 63 6f 73 74 20 | 61 6e 64 20 73 63 68 65 |te cost |and sche|
|00001ef0| 64 75 6c 65 20 76 61 72 | 69 61 6e 63 65 73 20 61 |dule var|iances a|
|00001f00| 74 20 54 69 6d 65 20 4e | 6f 77 20 7d 0d 09 09 09 |t Time N|ow }....|
|00001f10| 43 41 4c 4c 20 46 4f 52 | 4d 41 54 5f 54 41 42 4c |CALL FOR|MAT_TABL|
|00001f20| 45 28 29 09 09 7b 20 46 | 6f 72 6d 61 74 20 74 68 |E()..{ F|ormat th|
|00001f30| 65 20 74 61 62 6c 65 20 | 7d 0d 09 09 09 43 41 4c |e table |}....CAL|
|00001f40| 4c 20 43 52 45 41 54 45 | 5f 43 48 41 52 54 28 29 |L CREATE|_CHART()|
|00001f50| 09 09 7b 20 43 72 65 61 | 74 65 20 74 68 65 20 45 |..{ Crea|te the E|
|00001f60| 56 20 63 68 61 72 74 20 | 7d 0d 09 09 09 52 45 50 |V chart |}....REP|
|00001f70| 41 49 4e 54 20 4f 4e 09 | 09 09 7b 20 54 75 72 6e |AINT ON.|..{ Turn|
|00001f80| 20 52 65 70 61 69 6e 74 | 20 6f 6e 20 74 6f 20 73 | Repaint| on to s|
|00001f90| 68 6f 77 20 63 68 61 72 | 74 20 7d 0d 09 09 09 43 |how char|t }....C|
|00001fa0| 41 4c 4c 20 41 53 4b 5f | 54 4f 5f 43 4f 50 59 28 |ALL ASK_|TO_COPY(|
|00001fb0| 29 09 09 7b 20 41 73 6b | 20 69 66 20 77 65 20 77 |)..{ Ask| if we w|
|00001fc0| 61 6e 74 20 74 6f 20 63 | 6f 70 79 20 74 68 65 20 |ant to c|opy the |
|00001fd0| 67 72 61 70 68 20 61 6e | 64 20 63 6c 6f 73 65 20 |graph an|d close |
|00001fe0| 74 68 65 20 77 69 6e 64 | 6f 77 20 7d 0d 09 09 45 |the wind|ow }...E|
|00001ff0| 4e 44 20 49 46 09 09 09 | 09 09 7b 20 45 6e 64 20 |ND IF...|..{ End |
|00002000| 6c 6f 67 69 63 61 6c 20 | 49 46 20 7d 0d 09 45 4c |logical |IF }..EL|
|00002010| 53 45 09 09 09 09 09 09 | 09 7b 20 4f 74 68 65 72 |SE......|.{ Other|
|00002020| 77 69 73 65 20 7d 0d 09 | 09 4d 45 53 53 41 47 45 |wise }..|.MESSAGE|
|00002030| 20 22 54 68 65 72 65 20 | 69 73 20 6e 6f 74 20 65 | "There |is not e|
|00002040| 6e 6f 75 67 68 20 43 61 | 73 68 20 46 6c 6f 77 20 |nough Ca|sh Flow |
|00002050| 64 61 74 61 20 74 6f 20 | 63 72 65 61 74 65 20 61 |data to |create a|
|00002060| 6e 20 65 61 72 6e 65 64 | 20 76 61 6c 75 65 20 67 |n earned| value g|
|00002070| 72 61 70 68 2e 22 20 0d | 09 09 43 4c 4f 53 45 20 |raph." .|..CLOSE |
|00002080| 4e 4f 57 09 09 09 09 09 | 7b 20 43 6c 6f 73 65 20 |NOW.....|{ Close |
|00002090| 43 61 73 68 20 46 6c 6f | 77 20 54 61 62 6c 65 20 |Cash Flo|w Table |
|000020a0| 77 69 74 68 6f 75 74 20 | 73 61 76 69 6e 67 20 7d |without |saving }|
|000020b0| 0d 09 45 4e 44 20 49 46 | 0d 45 4e 44 20 49 46 0d |..END IF|.END IF.|
|000020c0| 0d 7b 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.{******|********|
|000020d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000020e0| 2a 2a 2a 2a 2a 20 4d 41 | 4b 45 5f 4e 45 57 5f 53 |***** MA|KE_NEW_S|
|000020f0| 48 45 45 54 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |HEET ***|********|
|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 0d 20 | 20 54 68 69 73 20 66 75 |******. | This fu|
|00002130| 6e 63 74 69 6f 6e 20 63 | 72 65 61 74 65 73 20 61 |nction c|reates a|
|00002140| 20 6e 65 77 20 77 6f 72 | 6b 73 68 65 65 74 20 69 | new wor|ksheet i|
|00002150| 6e 20 77 68 69 63 68 20 | 74 68 65 20 66 69 6e 61 |n which |the fina|
|00002160| 6c 20 73 63 72 69 70 74 | 20 72 65 73 75 6c 74 73 |l script| results|
|00002170| 20 77 69 6c 6c 20 62 65 | 20 64 69 73 70 6c 61 79 | will be| display|
|00002180| 65 64 2e 0d 20 20 54 68 | 69 73 20 73 74 65 70 20 |ed..  Th|is step |
|00002190| 69 73 20 6e 65 63 65 73 | 73 61 72 79 20 73 6f 20 |is neces|sary so |
|000021a0| 74 68 61 74 20 74 68 65 | 20 66 69 6e 61 6c 20 77 |that the| final w|
|000021b0| 6f 72 6b 73 68 65 65 74 | 20 6d 61 79 20 62 65 20 |orksheet| may be |
|000021c0| 6c 65 66 74 20 6f 70 65 | 6e 20 77 68 65 6e 20 72 |left ope|n when r|
|000021d0| 65 2d 65 78 65 63 75 74 | 69 6e 67 0d 20 20 74 68 |e-execut|ing.  th|
|000021e0| 65 20 73 61 6d 65 20 45 | 78 63 68 61 6e 67 65 20 |e same E|xchange |
|000021f0| 69 74 65 6d 20 28 6f 72 | 20 61 6e 6f 74 68 65 72 |item (or| another|
|00002200| 20 77 68 69 63 68 20 75 | 73 65 73 20 74 68 65 20 | which u|ses the |
|00002210| 73 61 6d 65 20 65 78 70 | 6f 72 74 20 64 6f 63 75 |same exp|ort docu|
|00002220| 6d 65 6e 74 29 20 77 69 | 74 68 6f 75 74 20 63 61 |ment) wi|thout ca|
|00002230| 75 73 69 6e 67 0d 20 20 | 61 20 63 6f 6e 66 6c 69 |using.  |a confli|
|00002240| 63 74 20 6f 66 20 77 6f | 72 6b 73 68 65 65 74 20 |ct of wo|rksheet |
|00002250| 6e 61 6d 65 73 2e 0d 20 | 2a 2a 2a 2a 2a 2a 2a 2a |names.. |********|
|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 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002280| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002290| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000022a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000022b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 46 |********|****}..F|
|000022c0| 55 4e 43 54 49 4f 4e 20 | 4d 41 4b 45 5f 4e 45 57 |UNCTION |MAKE_NEW|
|000022d0| 5f 53 48 45 45 54 28 29 | 0d 09 4e 45 57 20 57 4f |_SHEET()|..NEW WO|
|000022e0| 52 4b 53 48 45 45 54 20 | 22 22 09 09 09 7b 20 43 |RKSHEET |""...{ C|
|000022f0| 72 65 61 74 65 20 61 20 | 6e 65 77 20 75 6e 74 69 |reate a |new unti|
|00002300| 74 6c 65 64 20 77 6f 72 | 6b 73 68 65 65 74 20 7d |tled wor|ksheet }|
|00002310| 0d 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 20 41 |..SELECT| RANGE A|
|00002320| 31 09 09 09 7b 20 4d 61 | 6b 65 20 73 75 72 65 20 |1...{ Ma|ke sure |
|00002330| 74 68 65 20 6e 65 78 74 | 20 6c 69 6e 65 20 70 75 |the next| line pu|
|00002340| 74 73 20 74 68 65 20 69 | 6e 66 6f 20 69 6e 20 74 |ts the i|nfo in t|
|00002350| 68 65 20 64 65 73 69 72 | 65 64 20 6c 6f 63 61 74 |he desir|ed locat|
|00002360| 69 6f 6e 20 7d 0d 09 41 | 50 50 45 4e 44 20 22 4d |ion }..A|PPEND "M|
|00002370| 50 20 43 61 73 68 20 46 | 6c 6f 77 20 54 61 62 6c |P Cash F|low Tabl|
|00002380| 65 22 09 7b 20 41 70 70 | 65 6e 64 20 4d 61 63 50 |e".{ App|end MacP|
|00002390| 72 6f 6a 65 63 74 20 43 | 61 73 68 20 46 6c 6f 77 |roject C|ash Flow|
|000023a0| 20 65 78 70 6f 72 74 20 | 66 69 6c 65 20 7d 0d 09 | export |file }..|
|000023b0| 49 46 20 43 45 52 52 4f | 52 28 29 20 3d 20 30 09 |IF CERRO|R() = 0.|
|000023c0| 09 09 7b 20 56 65 72 69 | 66 79 20 74 68 61 74 20 |..{ Veri|fy that |
|000023d0| 74 68 65 20 66 69 6c 65 | 20 77 61 73 20 66 6f 75 |the file| was fou|
|000023e0| 6e 64 20 7d 0d 09 09 5a | 4f 4f 4d 20 57 49 4e 44 |nd }...Z|OOM WIND|
|000023f0| 4f 57 09 09 09 7b 20 4d | 61 6b 65 20 73 75 72 65 |OW...{ M|ake sure|
|00002400| 20 77 69 6e 64 6f 77 20 | 66 69 6c 6c 73 20 74 68 | window |fills th|
|00002410| 65 20 73 63 72 65 65 6e | 20 7d 0d 09 45 4c 53 45 |e screen| }..ELSE|
|00002420| 0d 09 09 73 74 6f 70 5f | 73 63 72 69 70 74 20 3d |...stop_|script =|
|00002430| 20 74 72 75 65 09 09 7b | 20 53 74 6f 70 20 73 63 | true..{| Stop sc|
|00002440| 72 69 70 74 20 65 78 65 | 63 75 74 69 6f 6e 20 69 |ript exe|cution i|
|00002450| 66 20 70 72 6f 62 6c 65 | 6d 73 20 66 6f 75 6e 64 |f proble|ms found|
|00002460| 20 7d 0d 09 45 4e 44 20 | 49 46 0d 45 4e 44 20 46 | }..END |IF.END F|
|00002470| 55 4e 43 54 49 4f 4e 0d | 0d 7b 2a 2a 2a 2a 2a 2a |UNCTION.|.{******|
|00002480| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002490| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|000024a0| 47 45 54 5f 52 4f 57 53 | 20 2a 2a 2a 2a 2a 2a 2a |GET_ROWS| *******|
|000024b0| 2a 2a 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 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|000024e0| 20 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |  This f|unction |
|000024f0| 64 65 74 65 72 6d 69 6e | 65 73 20 74 68 65 20 6e |determin|es the n|
|00002500| 75 6d 62 65 72 20 6f 66 | 20 72 6f 77 73 20 75 73 |umber of| rows us|
|00002510| 65 64 20 6f 6e 20 61 20 | 63 68 61 72 74 2e 20 20 |ed on a |chart.  |
|00002520| 57 65 20 66 69 72 73 74 | 20 73 65 6c 65 63 74 20 |We first| select |
|00002530| 61 6c 6c 20 61 63 74 69 | 76 65 20 63 65 6c 6c 73 |all acti|ve cells|
|00002540| 2e 0d 20 20 57 65 20 74 | 68 65 6e 20 75 73 65 20 |..  We t|hen use |
|00002550| 74 68 65 20 53 45 4c 45 | 43 54 49 4f 4e 20 66 75 |the SELE|CTION fu|
|00002560| 6e 63 74 69 6f 6e 20 74 | 6f 20 72 65 74 75 72 6e |nction t|o return|
|00002570| 20 74 68 65 20 72 61 6e | 67 65 20 61 6e 64 20 74 | the ran|ge and t|
|00002580| 68 65 20 52 4f 57 53 20 | 66 75 6e 63 74 69 6f 6e |he ROWS |function|
|00002590| 20 74 6f 20 67 65 74 20 | 74 68 65 20 6e 75 6d 62 | to get |the numb|
|000025a0| 65 72 20 6f 66 0d 20 20 | 72 6f 77 73 20 69 6e 20 |er of.  |rows in |
|000025b0| 74 68 61 74 20 72 61 6e | 67 65 2e 20 20 54 68 65 |that ran|ge.  The|
|000025c0| 20 72 65 73 75 6c 74 69 | 6e 67 20 76 61 6c 75 65 | resulti|ng value|
|000025d0| 20 69 73 20 74 68 65 6e | 20 72 65 74 75 72 6e 65 | is then| returne|
|000025e0| 64 20 74 6f 20 74 68 65 | 20 63 61 6c 6c 69 6e 67 |d to the| calling|
|000025f0| 20 73 74 61 74 65 6d 65 | 6e 74 2e 0d 20 2a 2a 2a | stateme|nt.. ***|
|00002600| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002610| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002620| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002630| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002640| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002650| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002660| 2a 7d 0d 0d 46 55 4e 43 | 54 49 4f 4e 20 47 45 54 |*}..FUNC|TION GET|
|00002670| 5f 52 4f 57 53 28 29 0d | 09 53 45 4c 45 43 54 20 |_ROWS().|.SELECT |
|00002680| 41 43 54 49 56 45 20 43 | 45 4c 4c 53 09 09 09 7b |ACTIVE C|ELLS...{|
|00002690| 20 53 65 6c 65 63 74 20 | 6e 6f 6e 2d 62 6c 61 6e | Select |non-blan|
|000026a0| 6b 20 63 65 6c 6c 73 20 | 7d 0d 09 52 45 54 55 52 |k cells |}..RETUR|
|000026b0| 4e 20 52 4f 57 53 28 53 | 45 4c 45 43 54 49 4f 4e |N ROWS(S|ELECTION|
|000026c0| 28 31 29 29 09 7b 20 44 | 65 74 65 72 6d 69 6e 65 |(1)).{ D|etermine|
|000026d0| 20 23 20 6f 66 20 72 6f | 77 73 20 69 6e 20 73 65 | # of ro|ws in se|
|000026e0| 6c 65 63 74 65 64 20 72 | 61 6e 67 65 20 7d 0d 45 |lected r|ange }.E|
|000026f0| 4e 44 20 46 55 4e 43 54 | 49 4f 4e 0d 0d 7b 2a 2a |ND FUNCT|ION..{**|
|00002700| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002710| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002720| 20 44 4f 5f 49 4e 49 54 | 49 41 4c 49 5a 45 20 2a | DO_INIT|IALIZE *|
|00002730| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002740| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002750| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002760| 2a 2a 0d 20 20 54 68 69 | 73 20 66 75 6e 63 74 69 |**.  Thi|s functi|
|00002770| 6f 6e 20 64 6f 65 73 20 | 73 6f 6d 65 20 69 6e 69 |on does |some ini|
|00002780| 74 69 61 6c 20 66 6f 72 | 6d 61 74 74 69 6e 67 2c |tial for|matting,|
|00002790| 20 63 6f 70 79 69 6e 67 | 20 61 6e 64 20 69 6e 73 | copying| and ins|
|000027a0| 65 72 74 69 6e 67 20 6f | 66 20 63 65 6c 6c 73 20 |erting o|f cells |
|000027b0| 74 6f 20 70 72 65 70 61 | 72 65 20 66 6f 72 0d 20 |to prepa|re for. |
|000027c0| 20 63 61 6c 63 75 6c 61 | 74 69 6f 6e 73 2e 0d 20 | calcula|tions.. |
|000027d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000027e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000027f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002800| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002810| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002820| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002830| 2a 2a 2a 2a 7d 0d 0d 46 | 55 4e 43 54 49 4f 4e 20 |****}..F|UNCTION |
|00002840| 44 4f 5f 49 4e 49 54 49 | 41 4c 49 5a 45 28 29 0d |DO_INITI|ALIZE().|
|00002850| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 20 46 31 |.SELECT |RANGE F1|
|00002860| 2e 2e 46 33 32 37 36 38 | 09 09 09 7b 20 53 65 6c |..F32768|...{ Sel|
|00002870| 65 63 74 20 74 68 65 20 | 45 6e 64 69 6e 67 20 64 |ect the |Ending d|
|00002880| 61 74 65 73 20 63 6f 6c | 75 6d 6e 20 7d 0d 09 43 |ates col|umn }..C|
|00002890| 4f 50 59 09 09 09 09 09 | 09 09 7b 20 43 6f 70 79 |OPY.....|..{ Copy|
|000028a0| 20 74 68 65 20 45 6e 64 | 69 6e 67 20 64 61 74 65 | the End|ing date|
|000028b0| 73 20 63 6f 6c 75 6d 6e | 20 7d 0d 09 53 45 4c 45 |s column| }..SELE|
|000028c0| 43 54 20 52 41 4e 47 45 | 20 4a 31 2e 2e 4a 33 32 |CT RANGE| J1..J32|
|000028d0| 37 36 38 09 09 09 7b 20 | 53 65 6c 65 63 74 20 61 |768...{ |Select a|
|000028e0| 20 62 6c 61 6e 6b 20 63 | 6f 6c 75 6d 6e 20 7d 0d | blank c|olumn }.|
|000028f0| 09 50 41 53 54 45 09 09 | 09 09 09 09 7b 20 50 61 |.PASTE..|....{ Pa|
|00002900| 73 74 65 20 74 68 65 20 | 65 6e 64 69 6e 67 20 64 |ste the |ending d|
|00002910| 61 74 65 73 20 7d 0d 09 | 53 45 4c 45 43 54 20 52 |ates }..|SELECT R|
|00002920| 41 4e 47 45 20 42 31 2e | 2e 42 33 32 37 36 38 09 |ANGE B1.|.B32768.|
|00002930| 09 09 7b 20 53 65 6c 65 | 63 74 20 74 68 65 20 50 |..{ Sele|ct the P|
|00002940| 6c 61 6e 6e 65 64 20 43 | 6f 73 74 20 63 6f 6c 75 |lanned C|ost colu|
|00002950| 6d 6e 20 7d 0d 09 43 4f | 50 59 09 09 09 09 09 09 |mn }..CO|PY......|
|00002960| 09 7b 20 43 6f 70 79 20 | 74 68 65 20 50 6c 61 6e |.{ Copy |the Plan|
|00002970| 6e 65 64 20 43 6f 73 74 | 20 63 6f 6c 75 6d 6e 20 |ned Cost| column |
|00002980| 7d 0d 09 53 45 4c 45 43 | 54 20 52 41 4e 47 45 20 |}..SELEC|T RANGE |
|00002990| 4b 31 2e 2e 4b 33 32 37 | 36 38 09 09 09 7b 20 53 |K1..K327|68...{ S|
|000029a0| 65 6c 65 63 74 20 61 20 | 62 6c 61 6e 6b 20 63 6f |elect a |blank co|
|000029b0| 6c 75 6d 6e 20 7d 0d 09 | 50 41 53 54 45 09 09 09 |lumn }..|PASTE...|
|000029c0| 09 09 09 7b 20 50 61 73 | 74 65 20 74 68 65 20 70 |...{ Pas|te the p|
|000029d0| 6c 61 6e 6e 65 64 20 63 | 6f 73 74 73 20 69 6e 20 |lanned c|osts in |
|000029e0| 70 72 65 70 61 72 61 74 | 69 6f 6e 20 66 6f 72 20 |preparat|ion for |
|000029f0| 42 43 57 53 20 7d 0d 09 | 53 45 4c 45 43 54 20 52 |BCWS }..|SELECT R|
|00002a00| 41 4e 47 45 20 44 31 2e | 2e 44 33 32 37 36 38 09 |ANGE D1.|.D32768.|
|00002a10| 09 09 7b 20 53 65 6c 65 | 63 74 20 74 68 65 20 41 |..{ Sele|ct the A|
|00002a20| 63 74 75 61 6c 20 43 6f | 73 74 20 63 6f 6c 75 6d |ctual Co|st colum|
|00002a30| 6e 20 7d 0d 09 43 4f 50 | 59 09 09 09 09 09 09 09 |n }..COP|Y.......|
|00002a40| 7b 20 43 6f 70 79 20 74 | 68 65 20 41 63 74 75 61 |{ Copy t|he Actua|
|00002a50| 6c 20 43 6f 73 74 20 63 | 6f 6c 75 6d 6e 20 7d 0d |l Cost c|olumn }.|
|00002a60| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 20 4c 31 |.SELECT |RANGE L1|
|00002a70| 2e 2e 4c 33 32 37 36 38 | 09 09 09 7b 20 53 65 6c |..L32768|...{ Sel|
|00002a80| 65 63 74 20 61 20 62 6c | 61 6e 6b 20 63 6f 6c 75 |ect a bl|ank colu|
|00002a90| 6d 6e 20 7d 0d 09 50 41 | 53 54 45 09 09 09 09 09 |mn }..PA|STE.....|
|00002aa0| 09 7b 20 50 61 73 74 65 | 20 74 68 65 20 61 63 74 |.{ Paste| the act|
|00002ab0| 75 61 6c 20 63 6f 73 74 | 73 20 69 6e 20 70 72 65 |ual cost|s in pre|
|00002ac0| 70 61 72 61 74 69 6f 6e | 20 66 6f 72 20 41 43 57 |paration| for ACW|
|00002ad0| 50 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |P }..SEL|ECT RANG|
|00002ae0| 45 20 41 31 2e 2e 41 56 | 4c 48 31 09 09 09 7b 20 |E A1..AV|LH1...{ |
|00002af0| 53 65 6c 65 63 74 20 74 | 68 65 20 66 69 72 73 74 |Select t|he first|
|00002b00| 20 72 6f 77 20 7d 0d 09 | 49 4e 53 45 52 54 09 09 | row }..|INSERT..|
|00002b10| 09 09 09 09 7b 20 49 6e | 73 65 72 74 20 61 20 6e |....{ In|sert a n|
|00002b20| 65 77 20 72 6f 77 20 7d | 0d 45 4e 44 20 46 55 4e |ew row }|.END FUN|
|00002b30| 43 54 49 4f 4e 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |CTION..{|********|
|00002b40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002b50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 20 43 41 4c 43 55 4c |********|* CALCUL|
|00002b60| 41 54 45 5f 42 43 57 53 | 20 2a 2a 2a 2a 2a 2a 2a |ATE_BCWS| *******|
|00002b70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002b80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002b90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 20 20 54 68 |********|***.  Th|
|00002ba0| 69 73 20 66 75 6e 63 74 | 69 6f 6e 20 63 61 6c 63 |is funct|ion calc|
|00002bb0| 75 6c 61 74 65 73 20 74 | 68 65 20 42 75 64 67 65 |ulates t|he Budge|
|00002bc0| 74 65 64 20 43 6f 73 74 | 20 6f 66 20 57 6f 72 6b |ted Cost| of Work|
|00002bd0| 20 53 63 68 65 64 75 6c | 65 64 20 62 79 20 61 63 | Schedul|ed by ac|
|00002be0| 63 75 6d 75 6c 61 74 69 | 6e 67 20 74 68 65 20 70 |cumulati|ng the p|
|00002bf0| 6c 61 6e 6e 65 64 0d 20 | 20 63 6f 73 74 73 20 66 |lanned. | costs f|
|00002c00| 6f 72 20 61 6c 6c 20 74 | 61 73 6b 73 20 28 66 69 |or all t|asks (fi|
|00002c10| 78 65 64 20 63 6f 73 74 | 73 20 61 6e 64 20 70 6c |xed cost|s and pl|
|00002c20| 61 6e 6e 65 64 20 72 65 | 73 6f 75 72 63 65 20 63 |anned re|source c|
|00002c30| 6f 73 74 73 29 20 69 6e | 20 74 68 65 20 70 72 6f |osts) in| the pro|
|00002c40| 6a 65 63 74 2e 20 20 56 | 61 6c 75 65 73 20 66 72 |ject.  V|alues fr|
|00002c50| 6f 6d 0d 20 20 74 68 65 | 20 22 50 6c 61 6e 6e 65 |om.  the| "Planne|
|00002c60| 64 20 43 6f 73 74 22 20 | 63 6f 6c 75 6d 6e 20 6f |d Cost" |column o|
|00002c70| 66 20 74 68 65 20 63 61 | 73 68 20 66 6c 6f 77 20 |f the ca|sh flow |
|00002c80| 74 61 62 6c 65 20 61 72 | 65 20 75 73 65 64 2e 20 |table ar|e used. |
|00002c90| 20 4e 6f 74 65 20 74 68 | 61 74 20 74 68 65 20 42 | Note th|at the B|
|00002ca0| 43 57 53 20 64 6f 65 73 | 20 6e 6f 74 0d 20 20 69 |CWS does| not.  i|
|00002cb0| 6e 63 6c 75 64 65 20 69 | 6e 63 6f 6d 65 73 2e 0d |nclude i|ncomes..|
|00002cc0| 20 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a | *******|********|
|00002cd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ce0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002cf0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002d20| 2a 2a 2a 2a 2a 7d 0d 0d | 46 55 4e 43 54 49 4f 4e |*****}..|FUNCTION|
|00002d30| 20 43 41 4c 43 55 4c 41 | 54 45 5f 42 43 57 53 28 | CALCULA|TE_BCWS(|
|00002d40| 29 0d 09 46 4f 52 20 6c | 6f 6f 70 5f 76 61 72 20 |)..FOR l|oop_var |
|00002d50| 3d 20 33 20 54 4f 20 6c | 61 73 74 5f 72 6f 77 20 |= 3 TO l|ast_row |
|00002d60| 53 54 45 50 20 31 09 09 | 7b 20 53 74 61 72 74 69 |STEP 1..|{ Starti|
|00002d70| 6e 67 20 61 74 20 72 6f | 77 20 33 2c 20 73 74 65 |ng at ro|w 3, ste|
|00002d80| 70 20 74 68 72 6f 75 67 | 68 20 65 61 63 68 20 72 |p throug|h each r|
|00002d90| 6f 77 20 7d 0d 09 09 74 | 68 65 5f 63 6f 6e 74 65 |ow }...t|he_conte|
|00002da0| 6e 74 73 20 3d 20 49 4e | 44 49 52 45 43 54 28 4d |nts = IN|DIRECT(M|
|00002db0| 41 4b 45 43 45 4c 4c 28 | 31 31 3b 6c 6f 6f 70 5f |AKECELL(|11;loop_|
|00002dc0| 76 61 72 29 29 7b 20 47 | 65 74 20 74 68 65 20 63 |var)){ G|et the c|
|00002dd0| 6f 6e 74 65 6e 74 73 20 | 6f 66 20 74 68 65 20 63 |ontents |of the c|
|00002de0| 75 72 72 65 6e 74 20 63 | 65 6c 6c 20 7d 0d 09 09 |urrent c|ell }...|
|00002df0| 50 55 54 20 74 68 65 5f | 63 6f 6e 74 65 6e 74 73 |PUT the_|contents|
|00002e00| 20 2b 0d 09 09 09 49 4e | 44 49 52 45 43 54 28 4d | +....IN|DIRECT(M|
|00002e10| 41 4b 45 43 45 4c 4c 28 | 31 31 3b 20 6c 6f 6f 70 |AKECELL(|11; loop|
|00002e20| 5f 76 61 72 2d 31 29 29 | 09 7b 20 2e 2e 2e 70 6c |_var-1))|.{ ...pl|
|00002e30| 75 73 20 74 68 65 20 63 | 6f 6e 74 65 6e 74 73 20 |us the c|ontents |
|00002e40| 6f 66 20 74 68 65 20 63 | 65 6c 6c 20 61 62 6f 76 |of the c|ell abov|
|00002e50| 65 20 7d 0d 09 09 09 49 | 4e 54 4f 20 4d 41 4b 45 |e }....I|NTO MAKE|
|00002e60| 43 45 4c 4c 28 31 31 3b | 20 6c 6f 6f 70 5f 76 61 |CELL(11;| loop_va|
|00002e70| 72 29 09 09 7b 20 2e 2e | 2e 62 61 63 6b 20 69 6e |r)..{ ..|.back in|
|00002e80| 74 6f 20 74 68 65 20 63 | 65 6c 6c 20 7d 0d 09 45 |to the c|ell }..E|
|00002e90| 4e 44 20 46 4f 52 09 09 | 09 09 09 09 09 09 7b 20 |ND FOR..|......{ |
|00002ea0| 65 6e 64 20 74 68 65 20 | 46 4f 52 20 6c 6f 6f 70 |end the |FOR loop|
|00002eb0| 20 7d 0d 45 4e 44 20 46 | 55 4e 43 54 49 4f 4e 0d | }.END F|UNCTION.|
|00002ec0| 0d 7b 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.{******|********|
|00002ed0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002ee0| 2a 2a 2a 20 43 41 4c 43 | 55 4c 41 54 45 5f 41 43 |*** CALC|ULATE_AC|
|00002ef0| 57 50 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |WP *****|********|
|00002f00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f20| 2a 2a 2a 2a 2a 0d 20 20 | 54 68 69 73 20 66 75 6e |*****.  |This fun|
|00002f30| 63 74 69 6f 6e 20 63 61 | 6c 63 75 6c 61 74 65 73 |ction ca|lculates|
|00002f40| 20 74 68 65 20 41 63 74 | 75 61 6c 20 43 6f 73 74 | the Act|ual Cost|
|00002f50| 20 6f 66 20 57 6f 72 6b | 20 50 65 72 66 6f 72 6d | of Work| Perform|
|00002f60| 65 64 2e 0d 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ed.. ***|********|
|00002f70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002fa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002fb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 46 55 4e 43 |********|*}..FUNC|
|00002fd0| 54 49 4f 4e 20 43 41 4c | 43 55 4c 41 54 45 5f 41 |TION CAL|CULATE_A|
|00002fe0| 43 57 50 28 29 0d 09 46 | 4f 52 20 6c 6f 6f 70 5f |CWP()..F|OR loop_|
|00002ff0| 76 61 72 20 3d 20 33 20 | 54 4f 20 74 69 6d 65 5f |var = 3 |TO time_|
|00003000| 6e 6f 77 5f 72 6f 77 20 | 53 54 45 50 20 31 09 09 |now_row |STEP 1..|
|00003010| 7b 20 66 72 6f 6d 20 72 | 6f 77 20 33 20 74 6f 20 |{ from r|ow 3 to |
|00003020| 54 69 6d 65 4e 6f 77 2c | 20 73 74 65 70 20 74 68 |TimeNow,| step th|
|00003030| 72 6f 75 67 68 20 65 61 | 63 68 20 72 6f 77 20 7d |rough ea|ch row }|
|00003040| 0d 09 09 74 68 65 5f 63 | 6f 6e 74 65 6e 74 73 20 |...the_c|ontents |
|00003050| 3d 20 49 4e 44 49 52 45 | 43 54 28 4d 41 4b 45 43 |= INDIRE|CT(MAKEC|
|00003060| 45 4c 4c 28 31 32 3b 6c | 6f 6f 70 5f 76 61 72 29 |ELL(12;l|oop_var)|
|00003070| 29 7b 20 47 65 74 20 74 | 68 65 20 63 6f 6e 74 65 |){ Get t|he conte|
|00003080| 6e 74 73 20 6f 66 20 74 | 68 65 20 63 75 72 72 65 |nts of t|he curre|
|00003090| 6e 74 20 63 65 6c 6c 20 | 7d 0d 09 09 50 55 54 20 |nt cell |}...PUT |
|000030a0| 74 68 65 5f 63 6f 6e 74 | 65 6e 74 73 20 2b 0d 09 |the_cont|ents +..|
|000030b0| 09 09 49 4e 44 49 52 45 | 43 54 28 4d 41 4b 45 43 |..INDIRE|CT(MAKEC|
|000030c0| 45 4c 4c 28 31 32 3b 20 | 6c 6f 6f 70 5f 76 61 72 |ELL(12; |loop_var|
|000030d0| 2d 31 29 29 09 7b 20 2e | 2e 2e 70 6c 75 73 20 74 |-1)).{ .|..plus t|
|000030e0| 68 65 20 63 6f 6e 74 65 | 6e 74 73 20 6f 66 20 74 |he conte|nts of t|
|000030f0| 68 65 20 63 65 6c 6c 20 | 61 62 6f 76 65 20 7d 0d |he cell |above }.|
|00003100| 09 09 09 49 4e 54 4f 20 | 4d 41 4b 45 43 45 4c 4c |...INTO |MAKECELL|
|00003110| 28 31 32 3b 20 6c 6f 6f | 70 5f 76 61 72 29 09 09 |(12; loo|p_var)..|
|00003120| 7b 20 2e 2e 2e 62 61 63 | 6b 20 69 6e 74 6f 20 74 |{ ...bac|k into t|
|00003130| 68 65 20 63 65 6c 6c 20 | 7d 0d 09 45 4e 44 20 46 |he cell |}..END F|
|00003140| 4f 52 09 09 09 09 09 09 | 09 09 7b 20 65 6e 64 20 |OR......|..{ end |
|00003150| 74 68 65 20 46 4f 52 20 | 6c 6f 6f 70 20 7d 0d 0d |the FOR |loop }..|
|00003160| 09 7b 20 42 6c 61 6e 6b | 20 74 68 65 20 63 65 6c |.{ Blank| the cel|
|00003170| 6c 73 20 62 65 6c 6f 77 | 20 54 69 6d 65 4e 6f 77 |ls below| TimeNow|
|00003180| 20 69 6e 20 74 68 65 20 | 41 43 57 50 20 63 6f 6c | in the |ACWP col|
|00003190| 75 6d 6e 20 7d 0d 09 46 | 4f 52 20 6c 6f 6f 70 5f |umn }..F|OR loop_|
|000031a0| 76 61 72 20 3d 20 74 69 | 6d 65 5f 6e 6f 77 5f 72 |var = ti|me_now_r|
|000031b0| 6f 77 2b 31 20 54 4f 20 | 6c 61 73 74 5f 72 6f 77 |ow+1 TO |last_row|
|000031c0| 20 53 54 45 50 20 31 0d | 20 09 09 50 55 54 20 22 | STEP 1.| ..PUT "|
|000031d0| 20 22 20 49 4e 54 4f 20 | 4d 41 4b 45 43 45 4c 4c | " INTO |MAKECELL|
|000031e0| 28 31 32 3b 20 6c 6f 6f | 70 5f 76 61 72 29 09 7b |(12; loo|p_var).{|
|000031f0| 20 50 75 74 20 61 20 62 | 6c 61 6e 6b 20 69 6e 74 | Put a b|lank int|
|00003200| 6f 20 74 68 65 20 63 65 | 6c 6c 20 7d 0d 09 45 4e |o the ce|ll }..EN|
|00003210| 44 20 46 4f 52 0d 45 4e | 44 20 46 55 4e 43 54 49 |D FOR.EN|D FUNCTI|
|00003220| 4f 4e 0d 0d 7b 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ON..{***|********|
|00003230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003240| 2a 2a 2a 2a 2a 2a 20 43 | 41 4c 43 55 4c 41 54 45 |****** C|ALCULATE|
|00003250| 5f 42 43 57 50 20 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |_BCWP **|********|
|00003260| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003270| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003280| 2a 2a 2a 2a 2a 2a 2a 2a | 0d 20 20 54 68 69 73 20 |********|.  This |
|00003290| 66 75 6e 63 74 69 6f 6e | 20 63 61 6c 63 75 6c 61 |function| calcula|
|000032a0| 74 65 73 20 74 68 65 20 | 42 75 64 67 65 74 65 64 |tes the |Budgeted|
|000032b0| 20 43 6f 73 74 20 6f 66 | 20 57 6f 72 6b 20 50 65 | Cost of| Work Pe|
|000032c0| 72 66 6f 72 6d 65 64 2e | 0d 20 2a 2a 2a 2a 2a 2a |rformed.|. ******|
|000032d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000032f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003310| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 7d 0d |********|******}.|
|00003330| 0d 46 55 4e 43 54 49 4f | 4e 20 43 41 4c 43 55 4c |.FUNCTIO|N CALCUL|
|00003340| 41 54 45 5f 42 43 57 50 | 28 29 0d 09 44 45 46 49 |ATE_BCWP|()..DEFI|
|00003350| 4e 45 20 70 72 6f 6a 5f | 74 61 62 6c 65 5f 72 6f |NE proj_|table_ro|
|00003360| 77 73 09 09 09 7b 20 76 | 61 72 69 61 62 6c 65 20 |ws...{ v|ariable |
|00003370| 66 6f 72 20 6e 75 6d 62 | 65 72 20 6f 66 20 50 72 |for numb|er of Pr|
|00003380| 6f 6a 65 63 74 20 54 61 | 62 6c 65 20 72 6f 77 73 |oject Ta|ble rows|
|00003390| 20 7d 0d 09 44 45 46 49 | 4e 45 20 74 68 65 5f 64 | }..DEFI|NE the_d|
|000033a0| 61 74 65 09 09 09 09 7b | 20 74 68 65 20 64 61 74 |ate....{| the dat|
|000033b0| 65 20 63 75 72 72 65 6e | 74 6c 79 20 69 6e 20 71 |e curren|tly in q|
|000033c0| 75 65 73 74 69 6f 6e 20 | 7d 0d 09 44 45 46 49 4e |uestion |}..DEFIN|
|000033d0| 45 20 61 63 74 75 61 6c | 5f 65 6c 61 70 73 65 64 |E actual|_elapsed|
|000033e0| 5f 74 69 6d 65 09 09 7b | 20 61 63 74 75 61 6c 20 |_time..{| actual |
|000033f0| 66 69 6e 69 73 68 20 64 | 61 74 65 20 6d 69 6e 75 |finish d|ate minu|
|00003400| 73 20 61 63 74 75 61 6c | 20 73 74 61 72 74 20 64 |s actual| start d|
|00003410| 61 74 65 20 7d 0d 09 44 | 45 46 49 4e 45 20 70 65 |ate }..D|EFINE pe|
|00003420| 72 63 65 6e 74 5f 64 6f | 6e 65 5f 66 69 6e 69 73 |rcent_do|ne_finis|
|00003430| 68 09 09 7b 20 22 64 61 | 74 65 22 20 6f 66 20 74 |h..{ "da|te" of t|
|00003440| 68 65 20 25 64 6f 6e 65 | 20 6f 66 20 74 61 73 6b |he %done| of task|
|00003450| 20 62 65 69 6e 67 20 65 | 76 61 6c 75 61 74 65 64 | being e|valuated|
|00003460| 20 7d 0d 09 44 45 46 49 | 4e 45 20 62 75 63 6b 65 | }..DEFI|NE bucke|
|00003470| 74 5f 6e 75 6d 62 65 72 | 09 09 09 7b 20 22 62 75 |t_number|...{ "bu|
|00003480| 63 6b 65 74 22 20 6e 75 | 6d 62 65 72 20 28 69 2e |cket" nu|mber (i.|
|00003490| 65 2e 2c 20 64 61 74 65 | 20 72 61 6e 67 65 20 63 |e., date| range c|
|000034a0| 65 6c 6c 29 20 77 68 65 | 72 65 20 0d 09 09 09 09 |ell) whe|re .....|
|000034b0| 09 09 09 09 09 63 6f 73 | 74 20 67 65 74 73 20 61 |.....cos|t gets a|
|000034c0| 63 63 72 75 65 64 20 7d | 0d 09 44 45 46 49 4e 45 |ccrued }|..DEFINE|
|000034d0| 20 62 75 63 6b 65 74 5f | 66 69 6e 69 73 68 09 09 | bucket_|finish..|
|000034e0| 09 7b 20 66 69 6e 69 73 | 68 20 64 61 74 65 20 6f |.{ finis|h date o|
|000034f0| 66 20 74 68 65 20 63 75 | 72 72 65 6e 74 20 63 6f |f the cu|rrent co|
|00003500| 73 74 20 62 75 63 6b 65 | 74 20 7d 0d 09 44 45 46 |st bucke|t }..DEF|
|00003510| 49 4e 45 20 6e 65 77 5f | 73 74 61 72 74 09 09 09 |INE new_|start...|
|00003520| 09 7b 20 61 64 6a 75 73 | 74 65 64 20 22 73 74 61 |.{ adjus|ted "sta|
|00003530| 72 74 22 20 64 61 74 65 | 20 6f 66 20 74 61 73 6b |rt" date| of task|
|00003540| 20 70 6f 72 74 69 6f 6e | 20 62 65 69 6e 67 20 65 | portion| being e|
|00003550| 76 61 6c 75 61 74 65 64 | 20 7d 0d 09 44 45 46 49 |valuated| }..DEFI|
|00003560| 4e 45 20 6e 65 77 5f 66 | 69 6e 69 73 68 09 09 09 |NE new_f|inish...|
|00003570| 09 7b 20 61 64 6a 75 73 | 74 65 64 20 22 66 69 6e |.{ adjus|ted "fin|
|00003580| 69 73 68 22 20 64 61 74 | 65 20 6f 66 20 74 61 73 |ish" dat|e of tas|
|00003590| 6b 20 70 6f 72 74 69 6f | 6e 20 62 65 69 6e 67 20 |k portio|n being |
|000035a0| 65 76 61 6c 75 61 74 65 | 64 20 7d 0d 09 44 45 46 |evaluate|d }..DEF|
|000035b0| 49 4e 45 20 63 6f 73 74 | 5f 70 6f 72 74 69 6f 6e |INE cost|_portion|
|000035c0| 09 09 09 09 7b 20 61 6d | 6f 75 6e 74 20 6f 66 20 |....{ am|ount of |
|000035d0| 63 6f 73 74 20 77 68 69 | 63 68 20 67 6f 65 73 20 |cost whi|ch goes |
|000035e0| 69 6e 74 6f 20 63 75 72 | 72 65 6e 74 20 62 75 63 |into cur|rent buc|
|000035f0| 6b 65 74 20 7d 0d 0d 09 | 53 45 4c 45 43 54 20 52 |ket }...|SELECT R|
|00003600| 41 4e 47 45 20 46 31 2e | 2e 46 33 32 37 36 38 09 |ANGE F1.|.F32768.|
|00003610| 09 09 7b 20 53 65 6c 65 | 63 74 20 74 68 65 20 45 |..{ Sele|ct the E|
|00003620| 6e 64 69 6e 67 20 64 61 | 74 65 73 20 63 6f 6c 75 |nding da|tes colu|
|00003630| 6d 6e 20 28 43 61 73 68 | 20 46 6c 6f 77 20 74 61 |mn (Cash| Flow ta|
|00003640| 62 6c 65 29 20 7d 0d 09 | 43 4f 50 59 09 09 09 09 |ble) }..|COPY....|
|00003650| 09 09 09 7b 20 43 6f 70 | 79 20 74 68 65 20 45 6e |...{ Cop|y the En|
|00003660| 64 69 6e 67 20 64 61 74 | 65 73 20 63 6f 6c 75 6d |ding dat|es colum|
|00003670| 6e 20 28 43 61 73 68 20 | 46 6c 6f 77 20 74 61 62 |n (Cash |Flow tab|
|00003680| 6c 65 29 20 7d 0d 0d 09 | 4f 50 45 4e 20 22 4d 50 |le) }...|OPEN "MP|
|00003690| 20 50 72 6f 6a 65 63 74 | 20 54 61 62 6c 65 22 09 | Project| Table".|
|000036a0| 09 09 7b 20 4f 70 65 6e | 20 74 68 65 20 50 72 6f |..{ Open| the Pro|
|000036b0| 6a 65 63 74 20 54 61 62 | 6c 65 20 65 78 70 6f 72 |ject Tab|le expor|
|000036c0| 74 20 66 69 6c 65 20 7d | 0d 09 49 46 20 43 45 52 |t file }|..IF CER|
|000036d0| 52 4f 52 28 29 20 3d 20 | 30 0d 09 09 5a 4f 4f 4d |ROR() = |0...ZOOM|
|000036e0| 20 57 49 4e 44 4f 57 09 | 09 09 09 7b 20 5a 6f 6f | WINDOW.|...{ Zoo|
|000036f0| 6d 20 74 68 65 20 77 69 | 6e 64 6f 77 20 74 6f 20 |m the wi|ndow to |
|00003700| 65 6e 73 75 72 65 20 69 | 74 20 66 69 6c 6c 73 20 |ensure i|t fills |
|00003710| 74 68 65 20 73 63 72 65 | 65 6e 20 7d 0d 09 09 70 |the scre|en }...p|
|00003720| 72 6f 6a 5f 74 61 62 6c | 65 5f 72 6f 77 73 20 3d |roj_tabl|e_rows =|
|00003730| 20 47 45 54 5f 52 4f 57 | 53 28 29 09 7b 20 44 65 | GET_ROW|S().{ De|
|00003740| 74 65 72 6d 69 6e 65 20 | 74 68 65 20 6e 75 6d 62 |termine |the numb|
|00003750| 65 72 20 6f 66 20 50 72 | 6f 6a 65 63 74 20 54 61 |er of Pr|oject Ta|
|00003760| 62 6c 65 20 72 6f 77 73 | 20 62 65 66 6f 72 65 20 |ble rows| before |
|00003770| 70 61 73 74 65 20 7d 0d | 09 09 53 45 4c 45 43 54 |paste }.|..SELECT|
|00003780| 20 52 41 4e 47 45 20 48 | 31 2e 2e 48 33 32 37 36 | RANGE H|1..H3276|
|00003790| 38 09 09 7b 20 53 65 6c | 65 63 74 20 61 20 62 6c |8..{ Sel|ect a bl|
|000037a0| 61 6e 6b 20 63 6f 6c 75 | 6d 6e 20 28 50 72 6f 6a |ank colu|mn (Proj|
|000037b0| 65 63 74 20 54 61 62 6c | 65 29 20 7d 0d 09 09 50 |ect Tabl|e) }...P|
|000037c0| 41 53 54 45 09 09 09 09 | 09 7b 20 50 61 73 74 65 |ASTE....|.{ Paste|
|000037d0| 20 74 68 65 20 45 6e 64 | 69 6e 67 20 64 61 74 65 | the End|ing date|
|000037e0| 73 20 69 6e 74 6f 20 74 | 68 65 20 50 72 6f 6a 65 |s into t|he Proje|
|000037f0| 63 74 20 54 61 62 6c 65 | 20 7d 0d 09 45 4c 53 45 |ct Table| }..ELSE|
|00003800| 0d 09 09 73 74 6f 70 5f | 73 63 72 69 70 74 20 3d |...stop_|script =|
|00003810| 20 74 72 75 65 09 09 09 | 7b 20 43 6f 75 6c 64 6e | true...|{ Couldn|
|00003820| 27 74 20 6f 70 65 6e 20 | 74 68 65 20 50 72 6f 6a |'t open |the Proj|
|00003830| 65 63 74 20 54 61 62 6c | 65 20 7d 0d 09 09 43 4c |ect Tabl|e }...CL|
|00003840| 4f 53 45 20 4e 4f 57 09 | 09 09 09 09 7b 20 43 6c |OSE NOW.|....{ Cl|
|00003850| 6f 73 65 20 43 61 73 68 | 20 46 6c 6f 77 20 54 61 |ose Cash| Flow Ta|
|00003860| 62 6c 65 20 77 69 74 68 | 6f 75 74 20 73 61 76 69 |ble with|out savi|
|00003870| 6e 67 20 7d 0d 09 45 4e | 44 20 49 46 0d 0d 09 49 |ng }..EN|D IF...I|
|00003880| 46 20 4e 4f 54 20 73 74 | 6f 70 5f 73 63 72 69 70 |F NOT st|op_scrip|
|00003890| 74 0d 09 49 46 20 70 72 | 6f 6a 5f 74 61 62 6c 65 |t..IF pr|oj_table|
|000038a0| 5f 72 6f 77 73 20 3e 20 | 30 0d 09 09 7b 20 49 6e |_rows > |0...{ In|
|000038b0| 69 74 69 61 6c 69 7a 65 | 20 61 6c 6c 20 74 68 65 |itialize| all the|
|000038c0| 20 42 43 57 50 20 63 65 | 6c 6c 73 20 74 6f 20 7a | BCWP ce|lls to z|
|000038d0| 65 72 6f 20 69 6e 20 63 | 6f 6c 75 6d 6e 20 39 2e |ero in c|olumn 9.|
|000038e0| 20 7d 0d 09 09 46 4f 52 | 20 6c 6f 6f 70 5f 76 61 | }...FOR| loop_va|
|000038f0| 72 20 3d 20 32 20 74 6f | 20 6c 61 73 74 5f 72 6f |r = 2 to| last_ro|
|00003900| 77 20 53 54 45 50 20 31 | 0d 09 09 09 50 55 54 20 |w STEP 1|....PUT |
|00003910| 30 20 49 4e 54 4f 20 4d | 41 4b 45 43 45 4c 4c 28 |0 INTO M|AKECELL(|
|00003920| 39 3b 6c 6f 6f 70 5f 76 | 61 72 29 0d 09 09 45 4e |9;loop_v|ar)...EN|
|00003930| 44 20 46 4f 52 0d 0d 09 | 09 46 4f 52 20 6c 6f 6f |D FOR...|.FOR loo|
|00003940| 70 5f 76 61 72 20 3d 20 | 31 20 54 4f 20 70 72 6f |p_var = |1 TO pro|
|00003950| 6a 5f 74 61 62 6c 65 5f | 72 6f 77 73 20 53 54 45 |j_table_|rows STE|
|00003960| 50 20 31 09 09 09 7b 20 | 53 74 65 70 20 74 68 72 |P 1...{ |Step thr|
|00003970| 6f 75 67 68 20 65 61 63 | 68 20 72 6f 77 20 69 6e |ough eac|h row in|
|00003980| 20 74 68 65 20 74 61 62 | 6c 65 20 7d 0d 09 20 09 | the tab|le }.. .|
|00003990| 09 70 65 72 63 65 6e 74 | 5f 64 6f 6e 65 20 3d 20 |.percent|_done = |
|000039a0| 49 4e 44 49 52 45 43 54 | 28 4d 41 4b 45 43 45 4c |INDIRECT|(MAKECEL|
|000039b0| 4c 28 34 3b 6c 6f 6f 70 | 5f 76 61 72 29 29 09 7b |L(4;loop|_var)).{|
|000039c0| 20 47 65 74 20 74 61 73 | 6b 20 70 65 72 63 65 6e | Get tas|k percen|
|000039d0| 74 5f 64 6f 6e 65 20 7d | 0d 09 20 20 09 09 49 46 |t_done }|..  ..IF|
|000039e0| 20 70 65 72 63 65 6e 74 | 5f 64 6f 6e 65 20 3c 3e | percent|_done <>|
|000039f0| 20 30 09 09 09 09 09 09 | 7b 20 4f 6e 6c 79 20 77 | 0......|{ Only w|
|00003a00| 6f 72 72 79 20 61 62 6f | 75 74 20 74 61 73 6b 20 |orry abo|ut task |
|00003a10| 69 66 20 73 74 61 72 74 | 65 64 20 7d 0d 0d 09 09 |if start|ed }....|
|00003a20| 09 09 7b 20 41 6c 6c 20 | 6f 66 20 74 68 65 20 74 |..{ All |of the t|
|00003a30| 61 73 6b 27 73 20 46 69 | 78 65 64 20 43 6f 73 74 |ask's Fi|xed Cost|
|00003a40| 20 76 61 6c 75 65 20 67 | 65 74 73 20 64 72 6f 70 | value g|ets drop|
|00003a50| 70 65 64 20 69 6e 74 6f | 20 74 68 65 20 41 63 74 |ped into| the Act|
|00003a60| 75 61 6c 20 53 74 61 72 | 74 20 62 75 63 6b 65 74 |ual Star|t bucket|
|00003a70| 2e 20 7d 0d 09 09 09 09 | 62 75 63 6b 65 74 5f 6e |. }.....|bucket_n|
|00003a80| 75 6d 62 65 72 20 3d 20 | 32 09 09 09 09 09 09 7b |umber = |2......{|
|00003a90| 20 73 65 63 6f 6e 64 20 | 42 43 57 50 20 72 6f 77 | second |BCWP row|
|00003aa0| 20 6e 75 6d 62 65 72 20 | 7d 0d 09 09 09 09 74 68 | number |}.....th|
|00003ab0| 65 5f 64 61 74 65 20 3d | 20 49 4e 44 49 52 45 43 |e_date =| INDIREC|
|00003ac0| 54 28 4d 41 4b 45 43 45 | 4c 4c 28 32 3b 6c 6f 6f |T(MAKECE|LL(2;loo|
|00003ad0| 70 5f 76 61 72 29 29 09 | 7b 20 47 65 74 20 74 61 |p_var)).|{ Get ta|
|00003ae0| 73 6b 20 41 63 74 75 61 | 6c 20 53 74 61 72 74 20 |sk Actua|l Start |
|00003af0| 64 61 74 65 20 7d 0d 09 | 09 09 09 57 48 49 4c 45 |date }..|...WHILE|
|00003b00| 20 74 68 65 5f 64 61 74 | 65 20 3e 3d 20 49 4e 44 | the_dat|e >= IND|
|00003b10| 49 52 45 43 54 28 4d 41 | 4b 45 43 45 4c 4c 28 38 |IRECT(MA|KECELL(8|
|00003b20| 3b 62 75 63 6b 65 74 5f | 6e 75 6d 62 65 72 29 29 |;bucket_|number))|
|00003b30| 0d 09 09 09 09 09 62 75 | 63 6b 65 74 5f 6e 75 6d |......bu|cket_num|
|00003b40| 62 65 72 20 3d 20 62 75 | 63 6b 65 74 5f 6e 75 6d |ber = bu|cket_num|
|00003b50| 62 65 72 20 2b 20 31 09 | 09 7b 20 46 69 6e 64 20 |ber + 1.|.{ Find |
|00003b60| 74 68 65 20 63 6f 72 72 | 65 63 74 20 62 75 63 6b |the corr|ect buck|
|00003b70| 65 74 20 7d 0d 09 09 09 | 09 09 49 46 20 62 75 63 |et }....|..IF buc|
|00003b80| 6b 65 74 5f 6e 75 6d 62 | 65 72 20 3e 20 6c 61 73 |ket_numb|er > las|
|00003b90| 74 5f 72 6f 77 09 09 09 | 7b 20 43 68 65 63 6b 20 |t_row...|{ Check |
|00003ba0| 69 66 20 63 6f 73 74 20 | 73 68 6f 75 6c 64 20 62 |if cost |should b|
|00003bb0| 65 20 69 6e 20 6c 61 73 | 74 20 62 75 63 6b 65 74 |e in las|t bucket|
|00003bc0| 20 7d 0d 09 09 09 09 09 | 09 62 75 63 6b 65 74 5f | }......|.bucket_|
|00003bd0| 6e 75 6d 62 65 72 20 3d | 20 6c 61 73 74 5f 72 6f |number =| last_ro|
|00003be0| 77 0d 09 09 09 09 09 09 | 45 58 49 54 20 57 48 49 |w.......|EXIT WHI|
|00003bf0| 4c 45 0d 09 09 09 09 09 | 45 4e 44 20 49 46 0d 09 |LE......|END IF..|
|00003c00| 09 09 09 45 4e 44 20 57 | 48 49 4c 45 0d 09 09 09 |...END W|HILE....|
|00003c10| 09 50 55 54 20 49 4e 44 | 49 52 45 43 54 28 4d 41 |.PUT IND|IRECT(MA|
|00003c20| 4b 45 43 45 4c 4c 28 35 | 3b 6c 6f 6f 70 5f 76 61 |KECELL(5|;loop_va|
|00003c30| 72 29 29 20 2b 09 09 7b | 20 47 65 74 20 74 68 65 |r)) +..{| Get the|
|00003c40| 20 74 61 73 6b 20 46 69 | 78 65 64 20 43 6f 73 74 | task Fi|xed Cost|
|00003c50| 20 7d 0d 09 09 09 09 09 | 49 4e 44 49 52 45 43 54 | }......|INDIRECT|
|00003c60| 28 4d 41 4b 45 43 45 4c | 4c 28 39 3b 62 75 63 6b |(MAKECEL|L(9;buck|
|00003c70| 65 74 5f 6e 75 6d 62 65 | 72 29 29 09 7b 20 41 64 |et_numbe|r)).{ Ad|
|00003c80| 64 20 69 74 20 74 6f 20 | 77 68 61 74 27 73 20 69 |d it to |what's i|
|00003c90| 6e 20 74 68 65 20 62 75 | 63 6b 65 74 20 61 6c 72 |n the bu|cket alr|
|00003ca0| 65 61 64 79 20 7d 0d 09 | 09 09 09 09 49 4e 54 4f |eady }..|....INTO|
|00003cb0| 20 4d 41 4b 45 43 45 4c | 4c 28 39 3b 62 75 63 6b | MAKECEL|L(9;buck|
|00003cc0| 65 74 5f 6e 75 6d 62 65 | 72 29 09 09 7b 20 42 61 |et_numbe|r)..{ Ba|
|00003cd0| 63 6b 20 69 6e 74 6f 20 | 63 6f 73 74 20 62 75 63 |ck into |cost buc|
|00003ce0| 6b 65 74 20 7d 0d 0d 09 | 09 09 09 7b 20 54 68 69 |ket }...|...{ Thi|
|00003cf0| 73 20 73 65 63 74 69 6f | 6e 2d 2d 69 6e 63 6c 75 |s sectio|n--inclu|
|00003d00| 64 69 6e 67 20 74 68 65 | 20 57 48 49 4c 45 20 6c |ding the| WHILE l|
|00003d10| 6f 6f 70 20 62 65 6c 6f | 77 2d 2d 64 69 73 74 72 |oop belo|w--distr|
|00003d20| 69 62 75 74 65 20 74 68 | 65 20 70 6c 61 6e 6e 65 |ibute th|e planne|
|00003d30| 64 20 72 65 73 6f 75 72 | 63 65 20 0d 09 09 09 09 |d resour|ce .....|
|00003d40| 09 63 6f 73 74 73 20 69 | 6e 74 6f 20 61 63 74 75 |.costs i|nto actu|
|00003d50| 61 6c 20 64 61 74 65 20 | 62 75 63 6b 65 74 73 2e |al date |buckets.|
|00003d60| 20 7d 0d 09 09 09 09 7b | 20 44 65 74 65 72 6d 69 | }.....{| Determi|
|00003d70| 6e 65 20 74 68 65 20 61 | 63 74 75 61 6c 20 65 6c |ne the a|ctual el|
|00003d80| 61 70 73 65 64 20 74 69 | 6d 65 20 66 6f 72 20 74 |apsed ti|me for t|
|00003d90| 68 65 20 74 61 73 6b 20 | 73 6f 20 72 65 73 6f 75 |he task |so resou|
|00003da0| 72 63 65 20 63 6f 73 74 | 73 20 63 61 6e 20 62 65 |rce cost|s can be|
|00003db0| 20 64 69 73 74 72 69 62 | 75 74 65 64 0d 09 09 09 | distrib|uted....|
|00003dc0| 09 09 6f 76 65 72 20 74 | 68 69 73 20 74 69 6d 65 |..over t|his time|
|00003dd0| 2e 20 20 53 75 62 74 72 | 61 63 74 69 6e 67 20 74 |.  Subtr|acting t|
|00003de0| 68 65 20 74 61 73 6b 20 | 61 63 74 75 61 6c 20 73 |he task |actual s|
|00003df0| 74 61 72 74 20 66 72 6f | 6d 20 74 68 65 20 66 69 |tart fro|m the fi|
|00003e00| 6e 69 73 68 20 72 65 73 | 75 6c 74 73 20 69 6e 0d |nish res|ults in.|
|00003e10| 09 09 09 09 09 65 6c 61 | 70 73 65 64 20 64 75 72 |.....ela|psed dur|
|00003e20| 61 74 69 6f 6e 20 77 68 | 69 63 68 20 69 73 20 6f |ation wh|ich is o|
|00003e30| 6e 65 20 64 61 79 20 73 | 68 6f 72 74 2c 20 6e 65 |ne day s|hort, ne|
|00003e40| 63 65 73 73 69 74 61 74 | 69 6e 67 20 61 64 64 69 |cessitat|ing addi|
|00003e50| 6e 67 20 31 2e 20 20 54 | 68 69 73 20 70 72 6f 63 |ng 1.  T|his proc|
|00003e60| 65 73 73 0d 09 09 09 09 | 09 72 65 73 75 6c 74 73 |ess.....|.results|
|00003e70| 20 69 6e 20 61 6e 20 61 | 70 70 72 6f 78 69 6d 61 | in an a|pproxima|
|00003e80| 74 69 6f 6e 20 66 6f 72 | 20 74 61 73 6b 73 20 77 |tion for| tasks w|
|00003e90| 68 69 63 68 20 68 61 76 | 65 20 61 20 64 75 72 61 |hich hav|e a dura|
|00003ea0| 74 69 6f 6e 20 6c 65 73 | 73 20 74 68 61 6e 20 74 |tion les|s than t|
|00003eb0| 68 65 20 63 75 72 72 65 | 6e 74 0d 09 09 09 09 09 |he curre|nt......|
|00003ec0| 64 75 72 61 74 69 6f 6e | 20 73 63 61 6c 65 20 75 |duration| scale u|
|00003ed0| 73 65 64 20 69 6e 20 4d | 61 63 50 72 6f 6a 65 63 |sed in M|acProjec|
|00003ee0| 74 2e 20 20 46 6f 72 20 | 65 78 61 6d 70 6c 65 2c |t.  For |example,|
|00003ef0| 20 69 66 20 61 20 6f 6e | 65 2d 68 61 6c 66 2d 64 | if a on|e-half-d|
|00003f00| 61 79 20 74 61 73 6b 20 | 69 73 20 73 74 61 72 74 |ay task |is start|
|00003f10| 65 64 0d 09 09 09 09 09 | 61 6e 64 20 63 6f 6d 70 |ed......|and comp|
|00003f20| 6c 65 74 65 64 20 6f 6e | 20 74 68 65 20 73 61 6d |leted on| the sam|
|00003f30| 65 20 77 6f 72 6b 64 61 | 79 20 69 64 65 6e 74 69 |e workda|y identi|
|00003f40| 63 61 6c 20 64 61 74 65 | 73 20 77 69 6c 6c 20 62 |cal date|s will b|
|00003f50| 65 20 65 78 70 6f 72 74 | 65 64 20 66 6f 72 20 74 |e export|ed for t|
|00003f60| 68 65 20 61 63 74 75 61 | 6c 0d 09 09 09 09 09 73 |he actua|l......s|
|00003f70| 74 61 72 74 20 61 6e 64 | 20 66 69 6e 69 73 68 2c |tart and| finish,|
|00003f80| 20 74 68 65 72 65 62 79 | 20 6d 61 6b 69 6e 67 20 | thereby| making |
|00003f90| 74 68 65 20 65 61 72 6e | 65 64 20 76 61 6c 75 65 |the earn|ed value|
|00003fa0| 20 73 70 72 65 61 64 20 | 74 68 65 20 72 65 73 6f | spread |the reso|
|00003fb0| 75 72 63 65 20 63 6f 73 | 74 0d 09 09 09 09 09 6f |urce cos|t......o|
|00003fc0| 66 20 74 68 61 74 20 74 | 61 73 6b 20 6f 76 65 72 |f that t|ask over|
|00003fd0| 20 74 68 65 20 65 6e 74 | 69 72 65 20 64 61 79 2e | the ent|ire day.|
|00003fe0| 20 7d 0d 09 09 09 09 49 | 46 20 49 4e 44 49 52 45 | }.....I|F INDIRE|
|00003ff0| 43 54 28 4d 41 4b 45 43 | 45 4c 4c 28 37 3b 20 6c |CT(MAKEC|ELL(7; l|
|00004000| 6f 6f 70 5f 76 61 72 29 | 29 20 3d 20 30 0d 09 09 |oop_var)|) = 0...|
|00004010| 09 09 09 61 63 74 75 61 | 6c 5f 65 6c 61 70 73 65 |...actua|l_elapse|
|00004020| 64 5f 74 69 6d 65 20 3d | 20 30 09 09 09 09 09 7b |d_time =| 0.....{|
|00004030| 20 54 61 73 6b 20 41 63 | 74 75 61 6c 20 44 75 72 | Task Ac|tual Dur|
|00004040| 61 74 69 6f 6e 20 7d 0d | 09 09 09 09 45 4c 53 45 |ation }.|....ELSE|
|00004050| 0d 09 09 09 09 09 61 63 | 74 75 61 6c 5f 65 6c 61 |......ac|tual_ela|
|00004060| 70 73 65 64 5f 74 69 6d | 65 20 3d 0d 09 09 09 09 |psed_tim|e =.....|
|00004070| 09 09 49 4e 44 49 52 45 | 43 54 28 4d 41 4b 45 43 |..INDIRE|CT(MAKEC|
|00004080| 45 4c 4c 28 33 3b 6c 6f | 6f 70 5f 76 61 72 29 29 |ELL(3;lo|op_var))|
|00004090| 20 2d 09 20 20 09 7b 20 | 54 61 73 6b 20 41 63 74 | -.  .{ |Task Act|
|000040a0| 75 61 6c 20 46 69 6e 69 | 73 68 20 7d 0d 09 09 09 |ual Fini|sh }....|
|000040b0| 09 09 09 49 4e 44 49 52 | 45 43 54 28 4d 41 4b 45 |...INDIR|ECT(MAKE|
|000040c0| 43 45 4c 4c 28 32 3b 6c | 6f 6f 70 5f 76 61 72 29 |CELL(2;l|oop_var)|
|000040d0| 29 09 20 20 09 7b 20 54 | 61 73 6b 20 41 63 74 75 |).  .{ T|ask Actu|
|000040e0| 61 6c 20 53 74 61 72 74 | 20 7d 0d 09 09 09 09 09 |al Start| }......|
|000040f0| 09 2b 31 0d 09 09 09 09 | 45 4e 44 20 49 46 0d 0d |.+1.....|END IF..|
|00004100| 09 09 09 09 70 65 72 63 | 65 6e 74 5f 64 6f 6e 65 |....perc|ent_done|
|00004110| 5f 66 69 6e 69 73 68 20 | 3d 0d 09 09 09 09 09 28 |_finish |=......(|
|00004120| 28 70 65 72 63 65 6e 74 | 5f 64 6f 6e 65 2f 31 30 |(percent|_done/10|
|00004130| 30 29 20 2a 20 61 63 74 | 75 61 6c 5f 65 6c 61 70 |0) * act|ual_elap|
|00004140| 73 65 64 5f 74 69 6d 65 | 29 20 2b 0d 09 09 09 09 |sed_time|) +.....|
|00004150| 09 49 4e 44 49 52 45 43 | 54 28 4d 41 4b 45 43 45 |.INDIREC|T(MAKECE|
|00004160| 4c 4c 28 32 3b 6c 6f 6f | 70 5f 76 61 72 29 29 09 |LL(2;loo|p_var)).|
|00004170| 20 20 09 7b 20 54 61 73 | 6b 20 41 63 74 75 61 6c |  .{ Tas|k Actual|
|00004180| 20 53 74 61 72 74 20 7d | 0d 0d 09 09 09 09 6e 65 | Start }|......ne|
|00004190| 77 5f 73 74 61 72 74 20 | 3d 20 49 4e 44 49 52 45 |w_start |= INDIRE|
|000041a0| 43 54 28 4d 41 4b 45 43 | 45 4c 4c 28 32 3b 6c 6f |CT(MAKEC|ELL(2;lo|
|000041b0| 6f 70 5f 76 61 72 29 29 | 09 7b 20 54 61 73 6b 20 |op_var))|.{ Task |
|000041c0| 41 63 74 75 61 6c 20 53 | 74 61 72 74 20 7d 0d 0d |Actual S|tart }..|
|000041d0| 09 09 09 09 7b 20 44 6f | 6e 27 74 20 62 6f 74 68 |....{ Do|n't both|
|000041e0| 65 72 20 64 6f 69 6e 67 | 20 74 68 65 20 57 48 49 |er doing| the WHI|
|000041f0| 4c 45 20 6c 6f 6f 70 20 | 69 66 20 74 61 73 6b 20 |LE loop |if task |
|00004200| 64 75 72 61 74 69 6f 6e | 20 69 73 20 7a 65 72 6f |duration| is zero|
|00004210| 20 28 63 61 75 73 65 73 | 20 7a 65 72 6f 20 64 69 | (causes| zero di|
|00004220| 76 69 64 65 29 2e 20 7d | 0d 09 09 09 09 49 46 20 |vide). }|.....IF |
|00004230| 61 63 74 75 61 6c 5f 65 | 6c 61 70 73 65 64 5f 74 |actual_e|lapsed_t|
|00004240| 69 6d 65 20 3d 20 30 0d | 09 09 09 09 09 64 6f 6e |ime = 0.|.....don|
|00004250| 65 20 3d 20 74 72 75 65 | 0d 09 09 09 09 45 4c 53 |e = true|.....ELS|
|00004260| 45 0d 09 09 09 09 09 64 | 6f 6e 65 20 3d 20 66 61 |E......d|one = fa|
|00004270| 6c 73 65 0d 09 09 09 09 | 45 4e 44 20 49 46 0d 0d |lse.....|END IF..|
|00004280| 09 09 09 09 57 48 49 4c | 45 20 64 6f 6e 65 20 3d |....WHIL|E done =|
|00004290| 20 66 61 6c 73 65 0d 09 | 09 09 09 09 62 75 63 6b | false..|....buck|
|000042a0| 65 74 5f 66 69 6e 69 73 | 68 20 3d 20 49 4e 44 49 |et_finis|h = INDI|
|000042b0| 52 45 43 54 28 4d 41 4b | 45 43 45 4c 4c 28 38 3b |RECT(MAK|ECELL(8;|
|000042c0| 62 75 63 6b 65 74 5f 6e | 75 6d 62 65 72 29 29 0d |bucket_n|umber)).|
|000042d0| 09 09 09 09 09 49 46 20 | 62 75 63 6b 65 74 5f 66 |.....IF |bucket_f|
|000042e0| 69 6e 69 73 68 20 3c 20 | 70 65 72 63 65 6e 74 5f |inish < |percent_|
|000042f0| 64 6f 6e 65 5f 66 69 6e | 69 73 68 0d 09 09 09 09 |done_fin|ish.....|
|00004300| 09 09 6e 65 77 5f 66 69 | 6e 69 73 68 20 3d 20 62 |..new_fi|nish = b|
|00004310| 75 63 6b 65 74 5f 66 69 | 6e 69 73 68 0d 09 09 09 |ucket_fi|nish....|
|00004320| 09 09 45 4c 53 45 0d 09 | 09 09 09 09 09 6e 65 77 |..ELSE..|.....new|
|00004330| 5f 66 69 6e 69 73 68 20 | 3d 20 70 65 72 63 65 6e |_finish |= percen|
|00004340| 74 5f 64 6f 6e 65 5f 66 | 69 6e 69 73 68 0d 09 09 |t_done_f|inish...|
|00004350| 09 09 09 09 64 6f 6e 65 | 20 3d 20 74 72 75 65 0d |....done| = true.|
|00004360| 09 09 09 09 09 45 4e 44 | 20 49 46 0d 0d 09 09 09 |.....END| IF.....|
|00004370| 09 09 63 6f 73 74 5f 70 | 6f 72 74 69 6f 6e 20 3d |..cost_p|ortion =|
|00004380| 20 28 28 6e 65 77 5f 66 | 69 6e 69 73 68 20 2d 20 | ((new_f|inish - |
|00004390| 6e 65 77 5f 73 74 61 72 | 74 29 2f 61 63 74 75 61 |new_star|t)/actua|
|000043a0| 6c 5f 65 6c 61 70 73 65 | 64 5f 74 69 6d 65 29 0d |l_elapse|d_time).|
|000043b0| 09 09 09 09 09 09 2a 20 | 49 4e 44 49 52 45 43 54 |......* |INDIRECT|
|000043c0| 28 4d 41 4b 45 43 45 4c | 4c 28 36 3b 6c 6f 6f 70 |(MAKECEL|L(6;loop|
|000043d0| 5f 76 61 72 29 29 09 7b | 20 54 61 73 6b 20 72 65 |_var)).{| Task re|
|000043e0| 73 6f 75 72 63 65 20 63 | 6f 73 74 20 7d 0d 09 09 |source c|ost }...|
|000043f0| 09 09 09 50 55 54 20 49 | 4e 44 49 52 45 43 54 28 |...PUT I|NDIRECT(|
|00004400| 4d 41 4b 45 43 45 4c 4c | 28 39 3b 62 75 63 6b 65 |MAKECELL|(9;bucke|
|00004410| 74 5f 6e 75 6d 62 65 72 | 29 29 09 7b 20 43 75 72 |t_number|)).{ Cur|
|00004420| 72 65 6e 74 20 62 75 63 | 6b 65 74 20 76 61 6c 75 |rent buc|ket valu|
|00004430| 65 20 7d 0d 09 09 09 09 | 09 09 2b 20 63 6f 73 74 |e }.....|..+ cost|
|00004440| 5f 70 6f 72 74 69 6f 6e | 09 09 09 09 09 7b 20 2e |_portion|.....{ .|
|00004450| 2e 2e 70 6c 75 73 20 61 | 64 64 69 74 69 6f 6e 61 |..plus a|dditiona|
|00004460| 6c 20 63 6f 73 74 20 7d | 0d 09 09 09 09 09 09 49 |l cost }|.......I|
|00004470| 4e 54 4f 20 4d 41 4b 45 | 43 45 4c 4c 28 39 3b 62 |NTO MAKE|CELL(9;b|
|00004480| 75 63 6b 65 74 5f 6e 75 | 6d 62 65 72 29 09 7b 20 |ucket_nu|mber).{ |
|00004490| 2e 2e 2e 62 61 63 6b 20 | 69 6e 74 6f 20 62 75 63 |...back |into buc|
|000044a0| 6b 65 74 20 7d 0d 0d 09 | 09 09 09 09 6e 65 77 5f |ket }...|....new_|
|000044b0| 73 74 61 72 74 20 3d 20 | 6e 65 77 5f 66 69 6e 69 |start = |new_fini|
|000044c0| 73 68 09 09 09 09 7b 20 | 50 72 65 70 61 72 65 20 |sh....{ |Prepare |
|000044d0| 66 6f 72 20 6e 65 78 74 | 20 6c 6f 6f 70 20 7d 0d |for next| loop }.|
|000044e0| 09 09 09 09 09 62 75 63 | 6b 65 74 5f 6e 75 6d 62 |.....buc|ket_numb|
|000044f0| 65 72 20 3d 20 62 75 63 | 6b 65 74 5f 6e 75 6d 62 |er = buc|ket_numb|
|00004500| 65 72 20 2b 20 31 09 09 | 7b 20 50 72 65 70 61 72 |er + 1..|{ Prepar|
|00004510| 65 20 66 6f 72 20 6e 65 | 78 74 20 6c 6f 6f 70 20 |e for ne|xt loop |
|00004520| 7d 0d 09 09 09 09 45 4e | 44 20 57 48 49 4c 45 0d |}.....EN|D WHILE.|
|00004530| 09 20 20 09 09 45 4e 44 | 20 49 46 09 09 09 09 09 |.  ..END| IF.....|
|00004540| 09 09 09 09 7b 20 45 6e | 64 20 6c 6f 67 69 63 61 |....{ En|d logica|
|00004550| 6c 20 49 46 20 7d 0d 09 | 09 45 4e 44 20 46 4f 52 |l IF }..|.END FOR|
|00004560| 09 09 09 09 09 09 09 09 | 09 09 7b 20 45 6e 64 20 |........|..{ End |
|00004570| 46 4f 52 20 6c 6f 6f 70 | 20 7d 0d 09 09 53 45 4c |FOR loop| }...SEL|
|00004580| 45 43 54 20 52 41 4e 47 | 45 20 49 31 2e 2e 49 33 |ECT RANG|E I1..I3|
|00004590| 32 37 36 38 09 09 09 09 | 09 7b 20 53 65 6c 65 63 |2768....|.{ Selec|
|000045a0| 74 20 42 43 57 50 20 72 | 65 73 75 6c 74 73 20 63 |t BCWP r|esults c|
|000045b0| 6f 6c 75 6d 6e 20 7d 0d | 09 09 43 4f 50 59 09 09 |olumn }.|..COPY..|
|000045c0| 09 09 09 09 09 09 09 7b | 20 43 6f 70 79 20 74 68 |.......{| Copy th|
|000045d0| 65 20 42 43 57 50 20 72 | 65 73 75 6c 74 73 20 7d |e BCWP r|esults }|
|000045e0| 0d 09 09 43 4c 4f 53 45 | 20 4e 4f 57 09 09 09 09 |...CLOSE| NOW....|
|000045f0| 09 09 09 09 7b 20 43 6c | 6f 73 65 20 74 68 65 20 |....{ Cl|ose the |
|00004600| 50 72 6f 6a 65 63 74 20 | 54 61 62 6c 65 20 77 69 |Project |Table wi|
|00004610| 74 68 6f 75 74 20 73 61 | 76 69 6e 67 20 7d 0d 0d |thout sa|ving }..|
|00004620| 09 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 20 4d |..SELECT| RANGE M|
|00004630| 31 2e 2e 4d 33 32 37 36 | 38 09 09 09 09 09 7b 20 |1..M3276|8.....{ |
|00004640| 53 65 6c 65 63 74 20 74 | 68 65 20 42 43 57 50 20 |Select t|he BCWP |
|00004650| 63 6f 6c 75 6d 6e 20 69 | 6e 20 74 68 65 20 43 61 |column i|n the Ca|
|00004660| 73 68 20 46 6c 6f 77 20 | 73 68 65 65 74 20 7d 0d |sh Flow |sheet }.|
|00004670| 09 09 50 41 53 54 45 09 | 09 09 09 09 09 09 09 7b |..PASTE.|.......{|
|00004680| 20 50 61 73 74 65 20 74 | 68 65 20 42 43 57 50 20 | Paste t|he BCWP |
|00004690| 72 65 73 75 6c 74 73 20 | 7d 0d 0d 09 09 7b 20 41 |results |}....{ A|
|000046a0| 63 63 75 6d 75 6c 61 74 | 65 20 74 68 65 20 42 43 |ccumulat|e the BC|
|000046b0| 57 50 20 72 65 73 75 6c | 74 73 2e 20 7d 0d 09 09 |WP resul|ts. }...|
|000046c0| 46 4f 52 20 6c 6f 6f 70 | 5f 76 61 72 20 3d 20 33 |FOR loop|_var = 3|
|000046d0| 20 54 4f 20 74 69 6d 65 | 5f 6e 6f 77 5f 72 6f 77 | TO time|_now_row|
|000046e0| 20 53 54 45 50 20 31 09 | 09 7b 20 66 72 6f 6d 20 | STEP 1.|.{ from |
|000046f0| 72 6f 77 20 33 20 74 6f | 20 54 69 6d 65 4e 6f 77 |row 3 to| TimeNow|
|00004700| 2c 20 73 74 65 70 20 74 | 68 72 6f 75 67 68 20 65 |, step t|hrough e|
|00004710| 61 63 68 20 72 6f 77 20 | 7d 0d 09 09 09 74 68 65 |ach row |}....the|
|00004720| 5f 63 6f 6e 74 65 6e 74 | 73 20 3d 0d 09 09 09 09 |_content|s =.....|
|00004730| 49 4e 44 49 52 45 43 54 | 28 4d 41 4b 45 43 45 4c |INDIRECT|(MAKECEL|
|00004740| 4c 28 31 33 3b 6c 6f 6f | 70 5f 76 61 72 29 29 09 |L(13;loo|p_var)).|
|00004750| 7b 20 47 65 74 20 74 68 | 65 20 63 6f 6e 74 65 6e |{ Get th|e conten|
|00004760| 74 73 20 6f 66 20 74 68 | 65 20 63 75 72 72 65 6e |ts of th|e curren|
|00004770| 74 20 63 65 6c 6c 20 7d | 0d 09 09 09 50 55 54 20 |t cell }|....PUT |
|00004780| 74 68 65 5f 63 6f 6e 74 | 65 6e 74 73 20 2b 0d 09 |the_cont|ents +..|
|00004790| 09 09 09 49 4e 44 49 52 | 45 43 54 28 4d 41 4b 45 |...INDIR|ECT(MAKE|
|000047a0| 43 45 4c 4c 28 31 33 3b | 20 6c 6f 6f 70 5f 76 61 |CELL(13;| loop_va|
|000047b0| 72 2d 31 29 29 09 7b 20 | 2e 2e 2e 70 6c 75 73 20 |r-1)).{ |...plus |
|000047c0| 74 68 65 20 63 6f 6e 74 | 65 6e 74 73 20 6f 66 20 |the cont|ents of |
|000047d0| 74 68 65 20 63 65 6c 6c | 20 61 62 6f 76 65 20 7d |the cell| above }|
|000047e0| 0d 09 09 09 09 49 4e 54 | 4f 20 4d 41 4b 45 43 45 |.....INT|O MAKECE|
|000047f0| 4c 4c 28 31 33 3b 20 6c | 6f 6f 70 5f 76 61 72 29 |LL(13; l|oop_var)|
|00004800| 09 09 7b 20 2e 2e 2e 62 | 61 63 6b 20 69 6e 74 6f |..{ ...b|ack into|
|00004810| 20 74 68 65 20 63 65 6c | 6c 20 7d 0d 09 09 45 4e | the cel|l }...EN|
|00004820| 44 20 46 4f 52 09 09 09 | 09 09 09 09 09 7b 20 65 |D FOR...|.....{ e|
|00004830| 6e 64 20 74 68 65 20 46 | 4f 52 20 6c 6f 6f 70 20 |nd the F|OR loop |
|00004840| 7d 0d 0d 09 09 7b 20 42 | 6c 61 6e 6b 20 74 68 65 |}....{ B|lank the|
|00004850| 20 63 65 6c 6c 73 20 62 | 65 6c 6f 77 20 54 69 6d | cells b|elow Tim|
|00004860| 65 4e 6f 77 20 69 6e 20 | 74 68 65 20 42 43 57 50 |eNow in |the BCWP|
|00004870| 20 63 6f 6c 75 6d 6e 20 | 7d 0d 09 09 46 4f 52 20 | column |}...FOR |
|00004880| 6c 6f 6f 70 5f 76 61 72 | 20 3d 20 74 69 6d 65 5f |loop_var| = time_|
|00004890| 6e 6f 77 5f 72 6f 77 2b | 31 20 54 4f 20 6c 61 73 |now_row+|1 TO las|
|000048a0| 74 5f 72 6f 77 20 53 54 | 45 50 20 31 0d 09 20 09 |t_row ST|EP 1.. .|
|000048b0| 09 50 55 54 20 22 20 22 | 20 49 4e 54 4f 20 4d 41 |.PUT " "| INTO MA|
|000048c0| 4b 45 43 45 4c 4c 28 31 | 33 3b 20 6c 6f 6f 70 5f |KECELL(1|3; loop_|
|000048d0| 76 61 72 29 09 7b 20 50 | 75 74 20 61 20 62 6c 61 |var).{ P|ut a bla|
|000048e0| 6e 6b 20 69 6e 74 6f 20 | 74 68 65 20 63 65 6c 6c |nk into |the cell|
|000048f0| 20 7d 0d 09 09 45 4e 44 | 20 46 4f 52 0d 09 45 4c | }...END| FOR..EL|
|00004900| 53 45 0d 09 09 73 74 6f | 70 5f 73 63 72 69 70 74 |SE...sto|p_script|
|00004910| 20 3d 20 74 72 75 65 09 | 09 09 09 09 09 7b 20 4e | = true.|.....{ N|
|00004920| 6f 74 20 65 6e 6f 75 67 | 68 20 64 61 74 61 20 74 |ot enoug|h data t|
|00004930| 6f 20 66 69 6e 69 73 68 | 20 73 63 72 69 70 74 20 |o finish| script |
|00004940| 7d 0d 09 09 43 4c 4f 53 | 45 20 4e 4f 57 09 09 09 |}...CLOS|E NOW...|
|00004950| 09 09 09 09 09 7b 20 43 | 6c 6f 73 65 20 50 72 6f |.....{ C|lose Pro|
|00004960| 6a 65 63 74 20 54 61 62 | 6c 65 20 77 69 74 68 6f |ject Tab|le witho|
|00004970| 75 74 20 73 61 76 69 6e | 67 20 7d 0d 09 09 4d 45 |ut savin|g }...ME|
|00004980| 53 53 41 47 45 20 22 54 | 68 65 72 65 20 69 73 20 |SSAGE "T|here is |
|00004990| 6e 6f 74 20 65 6e 6f 75 | 67 68 20 50 72 6f 6a 65 |not enou|gh Proje|
|000049a0| 63 74 20 54 61 62 6c 65 | 20 64 61 74 61 20 74 6f |ct Table| data to|
|000049b0| 20 63 72 65 61 74 65 20 | 61 6e 20 45 61 72 6e 65 | create |an Earne|
|000049c0| 64 20 56 61 6c 75 65 20 | 67 72 61 70 68 2e 22 20 |d Value |graph." |
|000049d0| 0d 09 09 43 4c 4f 53 45 | 20 4e 4f 57 09 09 09 09 |...CLOSE| NOW....|
|000049e0| 09 09 09 09 7b 20 43 6c | 6f 73 65 20 43 61 73 68 |....{ Cl|ose Cash|
|000049f0| 20 46 6c 6f 77 20 54 61 | 62 6c 65 20 77 69 74 68 | Flow Ta|ble with|
|00004a00| 6f 75 74 20 73 61 76 69 | 6e 67 20 7d 0d 09 45 4e |out savi|ng }..EN|
|00004a10| 44 20 49 46 0d 09 45 4e | 44 20 49 46 0d 45 4e 44 |D IF..EN|D IF.END|
|00004a20| 20 46 55 4e 43 54 49 4f | 4e 0d 0d 7b 2a 2a 2a 2a | FUNCTIO|N..{****|
|00004a30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004a40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 20 43 |********|****** C|
|00004a50| 41 4c 43 5f 54 49 4d 45 | 5f 4e 4f 57 20 2a 2a 2a |ALC_TIME|_NOW ***|
|00004a60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004a70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004a80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004a90| 2a 0d 20 20 54 68 69 73 | 20 66 75 6e 63 74 69 6f |*.  This| functio|
|00004aa0| 6e 20 65 73 74 69 6d 61 | 74 65 73 20 22 54 69 6d |n estima|tes "Tim|
|00004ab0| 65 20 4e 6f 77 22 20 62 | 79 20 61 73 73 75 6d 69 |e Now" b|y assumi|
|00004ac0| 6e 67 20 74 68 61 74 20 | 69 74 20 69 73 20 62 65 |ng that |it is be|
|00004ad0| 74 77 65 65 6e 20 74 68 | 65 20 6c 61 73 74 20 74 |tween th|e last t|
|00004ae0| 77 6f 20 75 6e 69 71 75 | 65 20 76 61 6c 75 65 73 |wo uniqu|e values|
|00004af0| 0d 20 20 69 6e 20 74 68 | 65 20 22 41 63 74 75 61 |.  in th|e "Actua|
|00004b00| 6c 20 43 75 6d 75 6c 61 | 74 69 76 65 22 20 63 6f |l Cumula|tive" co|
|00004b10| 6c 75 6d 6e 20 6f 66 20 | 74 68 65 20 43 61 73 68 |lumn of |the Cash|
|00004b20| 20 46 6c 6f 77 20 54 61 | 62 6c 65 2e 0d 20 2a 2a | Flow Ta|ble.. **|
|00004b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b40| 2a 2a 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 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004b90| 2a 2a 7d 0d 0d 46 55 4e | 43 54 49 4f 4e 20 43 41 |**}..FUN|CTION CA|
|00004ba0| 4c 43 5f 54 49 4d 45 5f | 4e 4f 57 28 29 0d 09 64 |LC_TIME_|NOW()..d|
|00004bb0| 6f 6e 65 20 3d 20 66 61 | 6c 73 65 09 09 09 09 09 |one = fa|lse.....|
|00004bc0| 09 09 09 7b 20 53 65 74 | 20 64 6f 6e 65 20 66 6c |...{ Set| done fl|
|00004bd0| 61 67 20 74 6f 20 66 61 | 6c 73 65 20 7d 0d 09 74 |ag to fa|lse }..t|
|00004be0| 69 6d 65 5f 6e 6f 77 5f | 72 6f 77 20 3d 20 32 09 |ime_now_|row = 2.|
|00004bf0| 09 09 09 09 09 09 7b 20 | 49 6e 69 74 69 61 6c 69 |......{ |Initiali|
|00004c00| 7a 65 20 69 6e 20 63 61 | 73 65 20 74 68 65 72 65 |ze in ca|se there|
|00004c10| 20 61 72 65 20 6e 6f 20 | 61 63 74 75 61 6c 20 63 | are no |actual c|
|00004c20| 6f 73 74 73 20 7d 0d 09 | 46 4f 52 20 6c 6f 6f 70 |osts }..|FOR loop|
|00004c30| 5f 76 61 72 20 3d 20 6c | 61 73 74 5f 72 6f 77 20 |_var = l|ast_row |
|00004c40| 54 4f 20 33 20 53 54 45 | 50 20 2d 31 09 09 09 7b |TO 3 STE|P -1...{|
|00004c50| 20 53 74 61 72 74 69 6e | 67 20 66 72 6f 6d 20 74 | Startin|g from t|
|00004c60| 68 65 20 62 6f 74 74 6f | 6d 2c 20 73 74 65 70 20 |he botto|m, step |
|00004c70| 74 68 72 6f 75 67 68 20 | 65 61 63 68 20 72 6f 77 |through |each row|
|00004c80| 20 7d 0d 09 09 49 46 20 | 64 6f 6e 65 20 3d 20 66 | }...IF |done = f|
|00004c90| 61 6c 73 65 09 09 09 09 | 09 09 7b 20 49 66 20 64 |alse....|..{ If d|
|00004ca0| 6f 6e 65 20 69 73 20 65 | 71 75 61 6c 20 74 6f 20 |one is e|qual to |
|00004cb0| 66 61 6c 73 65 2e 2e 2e | 7d 0d 09 09 09 74 68 65 |false...|}....the|
|00004cc0| 5f 63 6f 6e 74 65 6e 74 | 73 20 3d 0d 09 09 09 09 |_content|s =.....|
|00004cd0| 49 4e 44 49 52 45 43 54 | 28 4d 41 4b 45 43 45 4c |INDIRECT|(MAKECEL|
|00004ce0| 4c 28 38 3b 6c 6f 6f 70 | 5f 76 61 72 29 29 09 7b |L(8;loop|_var)).{|
|00004cf0| 20 47 65 74 20 74 68 65 | 20 63 6f 6e 74 65 6e 74 | Get the| content|
|00004d00| 73 20 6f 66 20 74 68 65 | 20 63 75 72 72 65 6e 74 |s of the| current|
|00004d10| 20 63 65 6c 6c 20 7d 0d | 09 09 09 49 46 20 49 4e | cell }.|...IF IN|
|00004d20| 44 49 52 45 43 54 28 4d | 41 4b 45 43 45 4c 4c 28 |DIRECT(M|AKECELL(|
|00004d30| 38 3b 6c 6f 6f 70 5f 76 | 61 72 20 2d 20 31 29 29 |8;loop_v|ar - 1))|
|00004d40| 20 0d 09 09 09 09 3c 3e | 20 74 68 65 5f 63 6f 6e | .....<>| the_con|
|00004d50| 74 65 6e 74 73 09 09 09 | 09 7b 20 49 66 20 74 68 |tents...|.{ If th|
|00004d60| 65 20 76 61 6c 75 65 73 | 20 61 72 65 20 6e 6f 74 |e values| are not|
|00004d70| 20 65 71 75 61 6c 2e 2e | 2e 20 7d 0d 09 09 09 09 | equal..|. }.....|
|00004d80| 74 69 6d 65 5f 6e 6f 77 | 5f 72 6f 77 20 3d 20 6c |time_now|_row = l|
|00004d90| 6f 6f 70 5f 76 61 72 09 | 09 09 7b 20 53 65 74 20 |oop_var.|..{ Set |
|00004da0| 74 68 65 20 54 69 6d 65 | 20 4e 6f 77 20 72 6f 77 |the Time| Now row|
|00004db0| 20 74 6f 20 63 75 72 72 | 65 6e 74 20 72 6f 77 20 | to curr|ent row |
|00004dc0| 7d 0d 09 09 09 09 64 6f | 6e 65 20 3d 20 74 72 75 |}.....do|ne = tru|
|00004dd0| 65 09 09 09 09 09 7b 20 | 53 65 74 20 74 68 65 20 |e.....{ |Set the |
|00004de0| 64 6f 6e 65 20 66 6c 61 | 67 20 74 6f 20 74 72 75 |done fla|g to tru|
|00004df0| 65 20 7d 0d 09 09 09 45 | 4e 44 20 49 46 09 09 09 |e }....E|ND IF...|
|00004e00| 09 09 09 09 7b 20 45 6e | 64 20 6c 6f 67 69 63 61 |....{ En|d logica|
|00004e10| 6c 20 49 46 20 7d 0d 09 | 09 45 4e 44 20 49 46 09 |l IF }..|.END IF.|
|00004e20| 09 09 09 09 09 09 09 7b | 20 45 6e 64 20 6c 6f 67 |.......{| End log|
|00004e30| 69 63 61 6c 20 49 46 20 | 7d 0d 09 45 4e 44 20 46 |ical IF |}..END F|
|00004e40| 4f 52 09 09 09 09 09 09 | 09 09 09 7b 20 45 6e 64 |OR......|...{ End|
|00004e50| 20 46 4f 52 20 6c 6f 6f | 70 20 7d 0d 45 4e 44 20 | FOR loo|p }.END |
|00004e60| 46 55 4e 43 54 49 4f 4e | 0d 0d 7b 2a 2a 2a 2a 2a |FUNCTION|..{*****|
|00004e70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004e80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004e90| 20 46 4f 52 4d 41 54 5f | 54 41 42 4c 45 20 2a 2a | FORMAT_|TABLE **|
|00004ea0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004eb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004ec0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004ed0| 0d 20 20 54 68 69 73 20 | 66 75 6e 63 74 69 6f 6e |.  This |function|
|00004ee0| 20 66 6f 72 6d 61 74 73 | 20 74 68 65 20 74 61 62 | formats| the tab|
|00004ef0| 75 6c 61 72 20 64 61 74 | 61 20 74 6f 20 65 6e 73 |ular dat|a to ens|
|00004f00| 75 72 65 20 74 68 61 74 | 20 74 68 65 20 72 65 73 |ure that| the res|
|00004f10| 75 6c 74 69 6e 67 20 63 | 68 61 72 74 20 77 69 6c |ulting c|hart wil|
|00004f20| 6c 20 68 61 76 65 20 74 | 68 65 20 64 65 73 69 72 |l have t|he desir|
|00004f30| 65 64 0d 20 20 61 74 74 | 72 69 62 75 74 65 73 2e |ed.  att|ributes.|
|00004f40| 0d 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |. ******|********|
|00004f50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004f60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004f70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004f80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00004fa0| 2a 2a 2a 2a 2a 2a 7d 0d | 0d 46 55 4e 43 54 49 4f |******}.|.FUNCTIO|
|00004fb0| 4e 20 46 4f 52 4d 41 54 | 5f 54 41 42 4c 45 28 29 |N FORMAT|_TABLE()|
|00004fc0| 0d 09 48 49 44 45 20 48 | 45 41 44 49 4e 47 53 09 |..HIDE H|EADINGS.|
|00004fd0| 09 09 09 09 09 09 7b 20 | 48 69 64 65 20 63 6f 6c |......{ |Hide col|
|00004fe0| 75 6d 6e 20 61 6e 64 20 | 72 6f 77 20 68 65 61 64 |umn and |row head|
|00004ff0| 69 6e 67 73 20 7d 0d 09 | 48 49 44 45 20 54 4f 4f |ings }..|HIDE TOO|
|00005000| 4c 20 42 4f 58 09 09 09 | 09 09 09 09 7b 20 48 69 |L BOX...|....{ Hi|
|00005010| 64 65 20 74 6f 6f 6c 20 | 70 61 6c 65 74 74 65 20 |de tool |palette |
|00005020| 7d 0d 09 48 49 44 45 20 | 45 4e 54 52 59 20 42 41 |}..HIDE |ENTRY BA|
|00005030| 52 09 09 09 09 09 09 09 | 7b 20 48 69 64 65 20 65 |R.......|{ Hide e|
|00005040| 6e 74 72 79 20 62 61 72 | 20 7d 0d 09 48 49 44 45 |ntry bar| }..HIDE|
|00005050| 20 43 45 4c 4c 20 47 52 | 49 44 09 09 09 09 09 09 | CELL GR|ID......|
|00005060| 09 7b 20 48 69 64 65 20 | 74 68 65 20 63 65 6c 6c |.{ Hide |the cell|
|00005070| 20 67 72 69 64 20 7d 0d | 09 53 45 4c 45 43 54 20 | grid }.|.SELECT |
|00005080| 52 41 4e 47 45 20 41 31 | 2e 2e 41 56 4c 48 31 09 |RANGE A1|..AVLH1.|
|00005090| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 74 68 65 |....{ Se|lect the|
|000050a0| 20 66 69 72 73 74 20 72 | 6f 77 20 7d 0d 09 49 4e | first r|ow }..IN|
|000050b0| 53 45 52 54 09 09 09 09 | 09 09 09 09 7b 20 49 6e |SERT....|....{ In|
|000050c0| 73 65 72 74 20 61 20 6e | 65 77 20 72 6f 77 20 7d |sert a n|ew row }|
|000050d0| 0d 09 6c 61 73 74 5f 72 | 6f 77 20 3d 20 6c 61 73 |..last_r|ow = las|
|000050e0| 74 5f 72 6f 77 20 2b 20 | 31 09 09 09 09 09 7b 20 |t_row + |1.....{ |
|000050f0| 42 75 6d 70 20 6f 6e 65 | 20 74 6f 20 61 63 63 6f |Bump one| to acco|
|00005100| 6d 6d 6f 64 61 74 65 20 | 6e 65 77 20 72 6f 77 20 |mmodate |new row |
|00005110| 7d 0d 09 74 69 6d 65 5f | 6e 6f 77 5f 72 6f 77 20 |}..time_|now_row |
|00005120| 3d 20 74 69 6d 65 5f 6e | 6f 77 5f 72 6f 77 20 2b |= time_n|ow_row +|
|00005130| 20 31 09 09 09 7b 20 42 | 75 6d 70 20 6f 6e 65 20 | 1...{ B|ump one |
|00005140| 74 6f 20 61 63 63 6f 6d | 6d 6f 64 61 74 65 20 6e |to accom|modate n|
|00005150| 65 77 20 72 6f 77 20 7d | 0d 09 50 55 54 20 22 53 |ew row }|..PUT "S|
|00005160| 74 61 72 74 69 6e 67 22 | 20 49 4e 54 4f 20 41 32 |tarting"| INTO A2|
|00005170| 09 09 09 09 09 7b 20 41 | 64 64 20 68 65 61 64 69 |.....{ A|dd headi|
|00005180| 6e 67 20 7d 0d 09 50 55 | 54 20 22 50 6c 61 6e 20 |ng }..PU|T "Plan |
|00005190| 43 6f 73 74 73 22 20 49 | 4e 54 4f 20 42 32 09 09 |Costs" I|NTO B2..|
|000051a0| 09 09 09 7b 20 41 64 64 | 20 68 65 61 64 69 6e 67 |...{ Add| heading|
|000051b0| 20 7d 0d 09 50 55 54 20 | 22 50 6c 61 6e 20 49 6e | }..PUT |"Plan In|
|000051c0| 63 6f 6d 65 22 20 49 4e | 54 4f 20 43 32 09 09 09 |come" IN|TO C2...|
|000051d0| 09 7b 20 41 64 64 20 68 | 65 61 64 69 6e 67 20 7d |.{ Add h|eading }|
|000051e0| 0d 09 50 55 54 20 22 41 | 63 74 75 61 6c 20 43 6f |..PUT "A|ctual Co|
|000051f0| 73 74 73 22 20 49 4e 54 | 4f 20 44 32 09 09 09 09 |sts" INT|O D2....|
|00005200| 7b 20 41 64 64 20 68 65 | 61 64 69 6e 67 20 7d 0d |{ Add he|ading }.|
|00005210| 09 50 55 54 20 22 41 63 | 74 75 61 6c 20 49 6e 63 |.PUT "Ac|tual Inc|
|00005220| 6f 6d 65 22 20 49 4e 54 | 4f 20 45 32 09 09 09 09 |ome" INT|O E2....|
|00005230| 7b 20 41 64 64 20 68 65 | 61 64 69 6e 67 20 7d 0d |{ Add he|ading }.|
|00005240| 09 50 55 54 20 22 45 6e | 64 69 6e 67 22 20 49 4e |.PUT "En|ding" IN|
|00005250| 54 4f 20 46 32 09 09 09 | 09 09 7b 20 41 64 64 20 |TO F2...|..{ Add |
|00005260| 68 65 61 64 69 6e 67 20 | 7d 0d 09 50 55 54 20 22 |heading |}..PUT "|
|00005270| 50 6c 61 6e 20 43 75 6d | 2e 22 20 49 4e 54 4f 20 |Plan Cum|." INTO |
|00005280| 47 32 09 09 09 09 09 7b | 20 41 64 64 20 68 65 61 |G2.....{| Add hea|
|00005290| 64 69 6e 67 20 7d 0d 09 | 50 55 54 20 22 41 63 74 |ding }..|PUT "Act|
|000052a0| 75 61 6c 20 43 75 6d 2e | 22 20 49 4e 54 4f 20 48 |ual Cum.|" INTO H|
|000052b0| 32 09 09 09 09 7b 20 41 | 64 64 20 68 65 61 64 69 |2....{ A|dd headi|
|000052c0| 6e 67 20 7d 0d 09 50 55 | 54 20 22 44 61 74 65 22 |ng }..PU|T "Date"|
|000052d0| 20 49 4e 54 4f 20 4a 32 | 09 09 09 09 09 09 7b 20 | INTO J2|......{ |
|000052e0| 41 64 64 20 68 65 61 64 | 69 6e 67 20 7d 0d 09 50 |Add head|ing }..P|
|000052f0| 55 54 20 22 42 43 57 53 | 22 20 49 4e 54 4f 20 4b |UT "BCWS|" INTO K|
|00005300| 32 20 09 09 09 09 09 09 | 7b 20 41 64 64 20 68 65 |2 ......|{ Add he|
|00005310| 61 64 69 6e 67 20 7d 0d | 09 50 55 54 20 22 41 43 |ading }.|.PUT "AC|
|00005320| 57 50 22 20 49 4e 54 4f | 20 4c 32 20 20 09 09 09 |WP" INTO| L2  ...|
|00005330| 09 09 7b 20 41 64 64 20 | 68 65 61 64 69 6e 67 20 |..{ Add |heading |
|00005340| 7d 0d 09 50 55 54 20 22 | 42 43 57 50 22 20 49 4e |}..PUT "|BCWP" IN|
|00005350| 54 4f 20 4d 32 20 20 09 | 09 09 09 09 7b 20 41 64 |TO M2  .|....{ Ad|
|00005360| 64 20 68 65 61 64 69 6e | 67 20 7d 0d 09 53 45 4c |d headin|g }..SEL|
|00005370| 45 43 54 20 52 41 4e 47 | 45 20 41 32 2e 2e 4d 32 |ECT RANG|E A2..M2|
|00005380| 09 09 09 09 09 09 7b 20 | 53 65 6c 65 63 74 20 74 |......{ |Select t|
|00005390| 69 74 6c 65 20 72 6f 77 | 20 7d 0d 09 54 45 58 54 |itle row| }..TEXT|
|000053a0| 20 53 54 59 4c 45 20 22 | 42 22 09 09 09 09 09 09 | STYLE "|B"......|
|000053b0| 09 7b 20 53 65 74 20 73 | 74 79 6c 65 20 74 6f 20 |.{ Set s|tyle to |
|000053c0| 62 6f 6c 64 20 7d 0d 09 | 41 4c 49 47 4e 20 43 45 |bold }..|ALIGN CE|
|000053d0| 4e 54 45 52 09 09 09 09 | 09 09 09 7b 20 43 65 6e |NTER....|...{ Cen|
|000053e0| 74 65 72 20 74 69 74 6c | 65 73 20 7d 0d 09 53 45 |ter titl|es }..SE|
|000053f0| 4c 45 43 54 20 52 41 4e | 47 45 28 4d 41 4b 45 52 |LECT RAN|GE(MAKER|
|00005400| 41 4e 47 45 28 31 31 3b | 33 3b 31 33 3b 6c 61 73 |ANGE(11;|3;13;las|
|00005410| 74 5f 72 6f 77 29 29 09 | 7b 20 53 65 6c 65 63 74 |t_row)).|{ Select|
|00005420| 20 42 43 57 53 2c 20 41 | 43 57 50 2c 20 42 43 57 | BCWS, A|CWP, BCW|
|00005430| 50 20 63 6f 6c 75 6d 6e | 73 20 7d 0d 09 46 4f 52 |P column|s }..FOR|
|00005440| 4d 41 54 20 43 55 52 52 | 45 4e 43 59 09 09 09 09 |MAT CURR|ENCY....|
|00005450| 09 09 7b 20 43 68 61 6e | 67 65 20 74 68 65 20 64 |..{ Chan|ge the d|
|00005460| 6f 6c 6c 61 72 20 66 6f | 72 6d 61 74 73 20 7d 0d |ollar fo|rmats }.|
|00005470| 09 55 53 45 20 43 4f 4d | 4d 41 53 09 09 09 09 09 |.USE COM|MAS.....|
|00005480| 09 09 7b 20 55 73 65 20 | 63 6f 6d 6d 61 73 20 69 |..{ Use |commas i|
|00005490| 6e 20 66 6f 72 6d 61 74 | 20 7d 0d 09 53 45 4c 45 |n format| }..SELE|
|000054a0| 43 54 20 52 41 4e 47 45 | 28 4d 41 4b 45 52 41 4e |CT RANGE|(MAKERAN|
|000054b0| 47 45 28 31 30 3b 33 3b | 31 30 3b 6c 61 73 74 5f |GE(10;3;|10;last_|
|000054c0| 72 6f 77 29 29 09 7b 20 | 53 65 6c 65 63 74 20 64 |row)).{ |Select d|
|000054d0| 61 74 65 20 63 6f 6c 75 | 6d 6e 20 7d 0d 09 46 4f |ate colu|mn }..FO|
|000054e0| 52 4d 41 54 20 44 41 54 | 45 20 31 09 09 09 09 09 |RMAT DAT|E 1.....|
|000054f0| 09 09 7b 20 53 68 6f 77 | 20 64 61 74 65 73 20 61 |..{ Show| dates a|
|00005500| 73 20 4d 4d 2f 44 44 2f | 59 59 20 7d 0d 09 53 45 |s MM/DD/|YY }..SE|
|00005510| 4c 45 43 54 20 52 41 4e | 47 45 28 4d 41 4b 45 52 |LECT RAN|GE(MAKER|
|00005520| 41 4e 47 45 28 31 3b 32 | 3b 31 33 3b 6c 61 73 74 |ANGE(1;2|;13;last|
|00005530| 5f 72 6f 77 29 29 09 7b | 20 53 65 6c 65 63 74 20 |_row)).{| Select |
|00005540| 74 61 62 6c 65 20 72 61 | 6e 67 65 20 7d 0d 09 54 |table ra|nge }..T|
|00005550| 45 58 54 20 46 4f 4e 54 | 20 22 48 65 6c 76 65 74 |EXT FONT| "Helvet|
|00005560| 69 63 61 22 09 09 09 09 | 09 7b 20 53 65 74 20 74 |ica"....|.{ Set t|
|00005570| 61 62 6c 65 20 66 6f 6e | 74 20 7d 0d 09 43 4f 4c |able fon|t }..COL|
|00005580| 55 4d 4e 20 57 49 44 54 | 48 20 31 2e 36 20 49 4e |UMN WIDT|H 1.6 IN|
|00005590| 43 48 45 53 09 09 09 09 | 09 7b 20 53 65 74 20 63 |CHES....|.{ Set c|
|000055a0| 6f 6c 75 6d 6e 20 77 69 | 64 74 68 20 7d 0d 09 43 |olumn wi|dth }..C|
|000055b0| 45 4c 4c 20 42 4f 52 44 | 45 52 20 22 54 42 4c 52 |ELL BORD|ER "TBLR|
|000055c0| 22 09 09 09 09 09 09 7b | 20 53 65 74 20 63 65 6c |"......{| Set cel|
|000055d0| 6c 20 62 6f 72 64 65 72 | 20 7d 0d 09 53 45 4c 45 |l border| }..SELE|
|000055e0| 43 54 20 52 41 4e 47 45 | 28 4d 41 4b 45 52 41 4e |CT RANGE|(MAKERAN|
|000055f0| 47 45 28 39 3b 31 3b 39 | 3b 6c 61 73 74 5f 72 6f |GE(9;1;9|;last_ro|
|00005600| 77 29 29 09 09 7b 20 53 | 65 6c 65 63 74 20 62 6c |w))..{ S|elect bl|
|00005610| 61 6e 6b 20 63 6f 6c 75 | 6d 6e 20 7d 0d 09 43 45 |ank colu|mn }..CE|
|00005620| 4c 4c 20 42 4f 52 44 45 | 52 20 22 74 62 6c 72 22 |LL BORDE|R "tblr"|
|00005630| 09 09 09 09 09 09 7b 20 | 54 75 72 6e 20 6f 66 66 |......{ |Turn off|
|00005640| 20 63 65 6c 6c 20 62 6f | 72 64 65 72 20 7d 0d 09 | cell bo|rder }..|
|00005650| 43 4f 4c 55 4d 4e 20 57 | 49 44 54 48 20 2e 35 20 |COLUMN W|IDTH .5 |
|00005660| 49 4e 43 48 09 09 09 09 | 09 7b 20 53 65 74 20 63 |INCH....|.{ Set c|
|00005670| 6f 6c 75 6d 6e 20 77 69 | 64 74 68 20 7d 0d 09 53 |olumn wi|dth }..S|
|00005680| 45 4c 45 43 54 20 52 41 | 4e 47 45 20 28 4d 41 4b |ELECT RA|NGE (MAK|
|00005690| 45 52 41 4e 47 45 28 32 | 3b 32 3b 35 3b 6c 61 73 |ERANGE(2|;2;5;las|
|000056a0| 74 5f 72 6f 77 29 29 09 | 7b 20 53 65 6c 65 63 74 |t_row)).|{ Select|
|000056b0| 20 64 6f 6c 6c 61 72 20 | 63 6f 6c 75 6d 6e 73 20 | dollar |columns |
|000056c0| 7d 0d 09 53 45 4c 45 43 | 54 20 4d 4f 52 45 20 52 |}..SELEC|T MORE R|
|000056d0| 41 4e 47 45 20 28 4d 41 | 4b 45 52 41 4e 47 45 28 |ANGE (MA|KERANGE(|
|000056e0| 37 3b 32 3b 38 3b 6c 61 | 73 74 5f 72 6f 77 29 29 |7;2;8;la|st_row))|
|000056f0| 7b 20 53 65 6c 65 63 74 | 20 6d 6f 72 65 20 64 6f |{ Select| more do|
|00005700| 6c 6c 61 72 20 63 6f 6c | 75 6d 6e 73 20 7d 0d 09 |llar col|umns }..|
|00005710| 46 4f 52 4d 41 54 20 43 | 55 52 52 45 4e 43 59 09 |FORMAT C|URRENCY.|
|00005720| 09 09 09 09 09 7b 20 43 | 68 61 6e 67 65 20 74 68 |.....{ C|hange th|
|00005730| 65 20 64 6f 6c 6c 61 72 | 20 66 6f 72 6d 61 74 73 |e dollar| formats|
|00005740| 20 7d 0d 09 55 53 45 20 | 43 4f 4d 4d 41 53 09 09 | }..USE |COMMAS..|
|00005750| 09 09 09 09 09 7b 20 55 | 73 65 20 63 6f 6d 6d 61 |.....{ U|se comma|
|00005760| 73 20 69 6e 20 66 6f 72 | 6d 61 74 20 7d 0d 09 55 |s in for|mat }..U|
|00005770| 4e 53 45 4c 45 43 54 09 | 09 09 09 09 09 09 09 7b |NSELECT.|.......{|
|00005780| 20 55 6e 73 65 6c 65 63 | 74 20 69 74 65 6d 73 20 | Unselec|t items |
|00005790| 7d 0d 45 4e 44 20 46 55 | 4e 43 54 49 4f 4e 0d 0d |}.END FU|NCTION..|
|000057a0| 0d 7b 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |.{******|********|
|000057b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000057c0| 2a 2a 2a 2a 2a 2a 2a 20 | 44 41 54 45 5f 52 45 44 |******* |DATE_RED|
|000057d0| 55 43 54 49 4f 4e 20 2a | 2a 2a 2a 2a 2a 2a 2a 2a |UCTION *|********|
|000057e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000057f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005800| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 0d 20 20 45 6c 69 6d |********|*.  Elim|
|00005810| 69 6e 61 74 65 20 73 6f | 6d 65 20 6f 66 20 74 68 |inate so|me of th|
|00005820| 65 20 64 61 74 65 73 20 | 74 6f 20 66 69 78 20 63 |e dates |to fix c|
|00005830| 72 6f 77 64 69 6e 67 20 | 6f 6e 20 78 20 61 78 69 |rowding |on x axi|
|00005840| 73 2e 0d 20 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |s.. ****|********|
|00005850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005860| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005870| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005880| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000058a0| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 46 55 4e 43 54 |********|}..FUNCT|
|000058b0| 49 4f 4e 20 44 41 54 45 | 5f 52 45 44 55 43 54 49 |ION DATE|_REDUCTI|
|000058c0| 4f 4e 28 29 0d 09 44 45 | 46 49 4e 45 20 6f 75 74 |ON()..DE|FINE out|
|000058d0| 65 72 5f 6c 6f 6f 70 09 | 09 09 09 09 09 7b 20 4f |er_loop.|.....{ O|
|000058e0| 75 74 65 72 20 6c 6f 6f | 70 20 63 6f 75 6e 74 65 |uter loo|p counte|
|000058f0| 72 20 7d 0d 09 44 45 46 | 49 4e 45 20 65 6e 64 5f |r }..DEF|INE end_|
|00005900| 6c 6f 6f 70 09 09 09 09 | 09 09 7b 20 45 6e 64 20 |loop....|..{ End |
|00005910| 6f 66 20 6c 6f 6f 70 20 | 63 6f 75 6e 74 65 72 7d |of loop |counter}|
|00005920| 0d 09 0d 09 49 46 20 6c | 61 73 74 5f 72 6f 77 20 |....IF l|ast_row |
|00005930| 3e 20 31 31 09 09 09 09 | 09 09 7b 20 43 68 65 63 |> 11....|..{ Chec|
|00005940| 6b 20 66 6f 72 20 6d 69 | 6e 69 6d 75 6d 20 23 20 |k for mi|nimum # |
|00005950| 6f 66 20 72 6f 77 73 20 | 7d 0d 09 09 65 6e 64 5f |of rows |}...end_|
|00005960| 6c 6f 6f 70 20 3d 20 49 | 4e 54 28 28 6c 61 73 74 |loop = I|NT((last|
|00005970| 5f 72 6f 77 2d 31 29 2f | 39 29 09 09 7b 20 43 61 |_row-1)/|9)..{ Ca|
|00005980| 6c 63 75 6c 61 74 65 20 | 6e 75 6d 62 65 72 20 6f |lculate |number o|
|00005990| 66 20 63 65 6c 6c 73 20 | 74 6f 20 63 6c 65 61 72 |f cells |to clear|
|000059a0| 20 7d 0d 09 09 46 4f 52 | 20 6f 75 74 65 72 5f 6c | }...FOR| outer_l|
|000059b0| 6f 6f 70 20 3d 20 32 20 | 74 6f 20 65 6e 64 5f 6c |oop = 2 |to end_l|
|000059c0| 6f 6f 70 09 09 7b 20 42 | 65 67 69 6e 20 6f 75 74 |oop..{ B|egin out|
|000059d0| 65 72 20 6c 6f 6f 70 20 | 7d 0d 09 09 09 46 4f 52 |er loop |}....FOR|
|000059e0| 20 6c 6f 6f 70 5f 76 61 | 72 20 3d 20 6f 75 74 65 | loop_va|r = oute|
|000059f0| 72 5f 6c 6f 6f 70 2b 31 | 20 09 09 7b 20 53 74 61 |r_loop+1| ..{ Sta|
|00005a00| 72 74 69 6e 67 20 61 74 | 20 72 6f 77 20 6f 75 74 |rting at| row out|
|00005a10| 65 72 5f 6c 6f 6f 70 2b | 31 2e 2e 2e 20 7d 0d 09 |er_loop+|1... }..|
|00005a20| 09 09 09 54 4f 20 6c 61 | 73 74 5f 72 6f 77 20 53 |...TO la|st_row S|
|00005a30| 54 45 50 20 65 6e 64 5f | 6c 6f 6f 70 20 09 7b 20 |TEP end_|loop .{ |
|00005a40| 2e 2e 2e 73 74 65 70 20 | 74 68 72 6f 75 67 68 20 |...step |through |
|00005a50| 65 76 65 72 79 20 65 6e | 64 5f 6c 6f 6f 70 74 68 |every en|d_loopth|
|00005a60| 20 72 6f 77 20 7d 0d 20 | 09 09 09 09 50 55 54 20 | row }. |....PUT |
|00005a70| 22 20 22 20 49 4e 54 4f | 20 4d 41 4b 45 43 45 4c |" " INTO| MAKECEL|
|00005a80| 4c 28 31 30 3b 20 6c 6f | 6f 70 5f 76 61 72 29 09 |L(10; lo|op_var).|
|00005a90| 7b 20 50 75 74 20 61 20 | 62 6c 61 6e 6b 20 69 6e |{ Put a |blank in|
|00005aa0| 74 6f 20 74 68 65 20 63 | 65 6c 6c 20 7d 0d 09 09 |to the c|ell }...|
|00005ab0| 09 45 4e 44 20 46 4f 52 | 09 09 09 09 09 09 7b 20 |.END FOR|......{ |
|00005ac0| 45 6e 64 20 46 4f 52 20 | 6c 6f 6f 70 20 7d 0d 09 |End FOR |loop }..|
|00005ad0| 09 45 4e 44 20 46 4f 52 | 09 09 09 09 09 09 09 7b |.END FOR|.......{|
|00005ae0| 20 45 6e 64 20 46 4f 52 | 20 6c 6f 6f 70 20 7d 0d | End FOR| loop }.|
|00005af0| 09 45 4e 44 20 49 46 09 | 09 09 09 09 09 09 09 7b |.END IF.|.......{|
|00005b00| 20 45 6e 64 20 6c 6f 67 | 69 63 61 6c 20 49 46 20 | End log|ical IF |
|00005b10| 7d 0d 45 4e 44 20 46 55 | 4e 43 54 49 4f 4e 0d 0d |}.END FU|NCTION..|
|00005b20| 7b 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |{*******|********|
|00005b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005b40| 2a 2a 2a 2a 20 43 41 4c | 43 55 4c 41 54 45 5f 56 |**** CAL|CULATE_V|
|00005b50| 41 52 49 41 4e 43 45 20 | 2a 2a 2a 2a 2a 2a 2a 2a |ARIANCE |********|
|00005b60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005b70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005b80| 2a 2a 2a 2a 2a 2a 0d 20 | 20 54 68 69 73 20 66 75 |******. | This fu|
|00005b90| 6e 63 74 69 6f 6e 20 64 | 65 74 65 72 6d 69 6e 65 |nction d|etermine|
|00005ba0| 73 20 74 68 65 20 63 6f | 73 74 20 76 61 72 69 61 |s the co|st varia|
|00005bb0| 6e 63 65 20 61 6e 64 20 | 73 63 68 65 64 75 6c 65 |nce and |schedule|
|00005bc0| 20 76 61 72 69 61 6e 63 | 65 20 61 74 20 54 69 6d | varianc|e at Tim|
|00005bd0| 65 20 4e 6f 77 2e 0d 20 | 20 44 65 66 69 6e 69 74 |e Now.. | Definit|
|00005be0| 69 6f 6e 73 3a 0d 09 43 | 6f 73 74 20 56 61 72 69 |ions:..C|ost Vari|
|00005bf0| 61 6e 63 65 20 3d 20 28 | 28 42 43 57 50 2d 41 43 |ance = (|(BCWP-AC|
|00005c00| 57 50 29 2f 42 43 57 50 | 29 2a 31 30 30 25 0d 09 |WP)/BCWP|)*100%..|
|00005c10| 53 63 68 65 64 75 6c 65 | 20 56 61 72 69 61 6e 63 |Schedule| Varianc|
|00005c20| 65 20 3d 20 28 28 42 43 | 57 50 2d 42 43 57 53 29 |e = ((BC|WP-BCWS)|
|00005c30| 2f 42 43 57 50 29 2a 31 | 30 30 25 0d 20 20 54 68 |/BCWP)*1|00%.  Th|
|00005c40| 65 20 63 6f 73 74 20 76 | 61 72 69 61 6e 63 65 20 |e cost v|ariance |
|00005c50| 67 69 76 65 73 20 61 6e | 20 69 6e 64 69 63 61 74 |gives an| indicat|
|00005c60| 69 6f 6e 20 6f 66 20 70 | 72 6f 6a 65 63 74 20 63 |ion of p|roject c|
|00005c70| 6f 73 74 20 28 6f 76 65 | 72 72 75 6e 2f 75 6e 64 |ost (ove|rrun/und|
|00005c80| 65 72 72 75 6e 29 20 61 | 74 20 54 69 6d 65 20 4e |errun) a|t Time N|
|00005c90| 6f 77 2e 0d 20 20 54 68 | 65 20 73 63 68 65 64 75 |ow..  Th|e schedu|
|00005ca0| 6c 65 20 76 61 72 69 61 | 6e 63 65 20 69 73 20 61 |le varia|nce is a|
|00005cb0| 6e 20 69 6e 64 69 63 61 | 74 6f 72 20 6f 66 20 70 |n indica|tor of p|
|00005cc0| 72 6f 6a 65 63 74 20 73 | 63 68 65 64 75 6c 65 20 |roject s|chedule |
|00005cd0| 70 72 6f 67 72 65 73 73 | 20 28 65 61 72 6c 79 2f |progress| (early/|
|00005ce0| 6c 61 74 65 29 20 72 65 | 6c 61 74 69 76 65 20 74 |late) re|lative t|
|00005cf0| 6f 20 74 68 65 0d 20 20 | 70 6c 61 6e 6e 65 64 20 |o the.  |planned |
|00005d00| 73 63 68 65 64 75 6c 65 | 2e 20 20 50 6f 73 69 74 |schedule|.  Posit|
|00005d10| 69 76 65 20 76 61 6c 75 | 65 73 20 61 72 65 20 64 |ive valu|es are d|
|00005d20| 65 73 69 72 61 62 6c 65 | 20 28 69 2e 65 2e 2c 20 |esirable| (i.e., |
|00005d30| 75 6e 64 65 72 20 62 75 | 64 67 65 74 20 61 6e 64 |under bu|dget and|
|00005d40| 20 61 68 65 61 64 20 6f | 66 20 73 63 68 65 64 75 | ahead o|f schedu|
|00005d50| 6c 65 29 20 61 6e 64 0d | 20 20 6e 65 67 61 74 69 |le) and.|  negati|
|00005d60| 76 65 20 76 61 6c 75 65 | 73 20 61 72 65 20 75 6e |ve value|s are un|
|00005d70| 64 65 73 69 72 61 62 6c | 65 2e 0d 20 2a 2a 2a 2a |desirabl|e.. ****|
|00005d80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005d90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005da0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005db0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005dc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005dd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00005de0| 7d 0d 0d 46 55 4e 43 54 | 49 4f 4e 20 43 41 4c 43 |}..FUNCT|ION CALC|
|00005df0| 55 4c 41 54 45 5f 56 41 | 52 49 41 4e 43 45 28 29 |ULATE_VA|RIANCE()|
|00005e00| 0d 09 44 45 46 49 4e 45 | 20 6e 6f 77 5f 42 43 57 |..DEFINE| now_BCW|
|00005e10| 53 09 09 09 09 09 09 7b | 20 42 43 57 53 20 61 74 |S......{| BCWS at|
|00005e20| 20 54 69 6d 65 20 4e 6f | 77 20 7d 0d 09 44 45 46 | Time No|w }..DEF|
|00005e30| 49 4e 45 20 6e 6f 77 5f | 41 43 57 50 09 09 09 09 |INE now_|ACWP....|
|00005e40| 09 09 7b 20 41 43 57 50 | 20 61 74 20 54 69 6d 65 |..{ ACWP| at Time|
|00005e50| 20 4e 6f 77 20 7d 0d 09 | 44 45 46 49 4e 45 20 6e | Now }..|DEFINE n|
|00005e60| 6f 77 5f 42 43 57 50 09 | 09 09 09 09 09 7b 20 42 |ow_BCWP.|.....{ B|
|00005e70| 43 57 50 20 61 74 20 54 | 69 6d 65 20 4e 6f 77 20 |CWP at T|ime Now |
|00005e80| 7d 0d 09 44 45 46 49 4e | 45 20 63 6f 73 74 5f 76 |}..DEFIN|E cost_v|
|00005e90| 61 72 09 09 09 09 09 09 | 7b 20 43 6f 73 74 20 76 |ar......|{ Cost v|
|00005ea0| 61 72 69 61 6e 63 65 20 | 61 74 20 54 69 6d 65 20 |ariance |at Time |
|00005eb0| 4e 6f 77 20 7d 0d 09 44 | 45 46 49 4e 45 20 73 63 |Now }..D|EFINE sc|
|00005ec0| 68 65 64 5f 76 61 72 09 | 09 09 09 09 09 7b 20 53 |hed_var.|.....{ S|
|00005ed0| 63 68 65 64 75 6c 65 20 | 76 61 72 69 61 6e 63 65 |chedule |variance|
|00005ee0| 20 61 74 20 54 69 6d 65 | 20 4e 6f 77 20 7d 0d 0d | at Time| Now }..|
|00005ef0| 09 6e 6f 77 5f 42 43 57 | 53 20 3d 20 49 4e 44 49 |.now_BCW|S = INDI|
|00005f00| 52 45 43 54 28 4d 41 4b | 45 43 45 4c 4c 28 31 31 |RECT(MAK|ECELL(11|
|00005f10| 3b 74 69 6d 65 5f 6e 6f | 77 5f 72 6f 77 29 29 0d |;time_no|w_row)).|
|00005f20| 09 6e 6f 77 5f 41 43 57 | 50 20 3d 20 49 4e 44 49 |.now_ACW|P = INDI|
|00005f30| 52 45 43 54 28 4d 41 4b | 45 43 45 4c 4c 28 31 32 |RECT(MAK|ECELL(12|
|00005f40| 3b 74 69 6d 65 5f 6e 6f | 77 5f 72 6f 77 29 29 0d |;time_no|w_row)).|
|00005f50| 09 6e 6f 77 5f 42 43 57 | 50 20 3d 20 49 4e 44 49 |.now_BCW|P = INDI|
|00005f60| 52 45 43 54 28 4d 41 4b | 45 43 45 4c 4c 28 31 33 |RECT(MAK|ECELL(13|
|00005f70| 3b 74 69 6d 65 5f 6e 6f | 77 5f 72 6f 77 29 29 0d |;time_no|w_row)).|
|00005f80| 09 49 46 20 6e 6f 77 5f | 42 43 57 50 20 3d 20 30 |.IF now_|BCWP = 0|
|00005f90| 0d 09 09 63 6f 73 74 5f | 76 61 72 20 3d 20 30 0d |...cost_|var = 0.|
|00005fa0| 09 09 73 63 68 65 64 5f | 76 61 72 20 3d 20 30 0d |..sched_|var = 0.|
|00005fb0| 09 45 4c 53 45 0d 09 09 | 63 6f 73 74 5f 76 61 72 |.ELSE...|cost_var|
|00005fc0| 20 3d 20 28 28 6e 6f 77 | 5f 42 43 57 50 20 2d 20 | = ((now|_BCWP - |
|00005fd0| 6e 6f 77 5f 41 43 57 50 | 29 2f 6e 6f 77 5f 42 43 |now_ACWP|)/now_BC|
|00005fe0| 57 50 29 20 2a 20 31 30 | 30 0d 09 09 73 63 68 65 |WP) * 10|0...sche|
|00005ff0| 64 5f 76 61 72 20 3d 20 | 28 28 6e 6f 77 5f 42 43 |d_var = |((now_BC|
|00006000| 57 50 20 2d 20 6e 6f 77 | 5f 42 43 57 53 29 2f 6e |WP - now|_BCWS)/n|
|00006010| 6f 77 5f 42 43 57 50 29 | 20 2a 20 31 30 30 0d 09 |ow_BCWP)| * 100..|
|00006020| 45 4e 44 20 49 46 0d 09 | 50 55 54 20 63 6f 73 74 |END IF..|PUT cost|
|00006030| 5f 76 61 72 20 49 4e 54 | 4f 20 4d 41 4b 45 43 45 |_var INT|O MAKECE|
|00006040| 4c 4c 28 31 32 3b 6c 61 | 73 74 5f 72 6f 77 2b 32 |LL(12;la|st_row+2|
|00006050| 29 0d 09 50 55 54 20 73 | 63 68 65 64 5f 76 61 72 |)..PUT s|ched_var|
|00006060| 20 49 4e 54 4f 20 4d 41 | 4b 45 43 45 4c 4c 28 31 | INTO MA|KECELL(1|
|00006070| 32 3b 6c 61 73 74 5f 72 | 6f 77 2b 33 29 0d 0d 09 |2;last_r|ow+3)...|
|00006080| 7b 20 50 72 65 70 65 6e | 64 20 61 20 6c 61 62 65 |{ Prepen|d a labe|
|00006090| 6c 20 66 6f 72 20 74 68 | 65 20 63 61 6c 63 75 6c |l for th|e calcul|
|000060a0| 61 74 65 64 20 76 61 6c | 75 65 73 2e 20 7d 0d 09 |ated val|ues. }..|
|000060b0| 50 55 54 20 22 43 6f 73 | 74 20 56 61 72 69 61 6e |PUT "Cos|t Varian|
|000060c0| 63 65 3a 20 22 26 53 54 | 52 49 4e 47 28 49 4e 44 |ce: "&ST|RING(IND|
|000060d0| 49 52 45 43 54 28 4d 41 | 4b 45 43 45 4c 4c 28 31 |IRECT(MA|KECELL(1|
|000060e0| 32 3b 6c 61 73 74 5f 72 | 6f 77 2b 32 29 29 3b 31 |2;last_r|ow+2));1|
|000060f0| 29 26 22 25 22 20 49 4e | 54 4f 20 4d 41 4b 45 43 |)&"%" IN|TO MAKEC|
|00006100| 45 4c 4c 28 31 32 3b 6c | 61 73 74 5f 72 6f 77 2b |ELL(12;l|ast_row+|
|00006110| 32 29 0d 09 50 55 54 20 | 22 53 63 68 65 64 75 6c |2)..PUT |"Schedul|
|00006120| 65 20 56 61 72 69 61 6e | 63 65 3a 20 22 26 53 54 |e Varian|ce: "&ST|
|00006130| 52 49 4e 47 28 49 4e 44 | 49 52 45 43 54 28 4d 41 |RING(IND|IRECT(MA|
|00006140| 4b 45 43 45 4c 4c 28 31 | 32 3b 6c 61 73 74 5f 72 |KECELL(1|2;last_r|
|00006150| 6f 77 2b 33 29 29 3b 31 | 29 26 22 25 22 20 49 4e |ow+3));1|)&"%" IN|
|00006160| 54 4f 20 4d 41 4b 45 43 | 45 4c 4c 28 31 32 3b 6c |TO MAKEC|ELL(12;l|
|00006170| 61 73 74 5f 72 6f 77 2b | 33 29 0d 0d 09 7b 20 50 |ast_row+|3)...{ P|
|00006180| 75 74 20 61 20 62 6f 78 | 20 61 72 6f 75 6e 64 20 |ut a box| around |
|00006190| 74 68 65 20 76 61 72 69 | 61 6e 63 65 20 63 65 6c |the vari|ance cel|
|000061a0| 6c 73 2e 20 7d 0d 09 53 | 45 4c 45 43 54 20 52 41 |ls. }..S|ELECT RA|
|000061b0| 4e 47 45 28 4d 41 4b 45 | 52 41 4e 47 45 28 31 32 |NGE(MAKE|RANGE(12|
|000061c0| 3b 6c 61 73 74 5f 72 6f | 77 2b 32 3b 31 33 3b 6c |;last_ro|w+2;13;l|
|000061d0| 61 73 74 5f 72 6f 77 2b | 33 29 29 09 7b 20 53 65 |ast_row+|3)).{ Se|
|000061e0| 6c 65 63 74 20 76 61 72 | 69 61 6e 63 65 20 63 65 |lect var|iance ce|
|000061f0| 6c 6c 73 20 7d 0d 09 43 | 45 4c 4c 20 42 4f 52 44 |lls }..C|ELL BORD|
|00006200| 45 52 20 22 4f 22 0d 45 | 4e 44 20 46 55 4e 43 54 |ER "O".E|ND FUNCT|
|00006210| 49 4f 4e 0d 0d 7b 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ION..{**|********|
|00006220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 20 43 52 45 41 |********|*** CREA|
|00006240| 54 45 5f 43 48 41 52 54 | 20 2a 2a 2a 2a 2a 2a 2a |TE_CHART| *******|
|00006250| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006260| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006270| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 0d 20 20 43 72 |********|***.  Cr|
|00006280| 65 61 74 65 20 74 68 65 | 20 45 61 72 6e 65 64 20 |eate the| Earned |
|00006290| 56 61 6c 75 65 20 63 68 | 61 72 74 2e 0d 20 2a 2a |Value ch|art.. **|
|000062a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000062f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00006300| 2a 2a 7d 0d 0d 46 55 4e | 43 54 49 4f 4e 20 43 52 |**}..FUN|CTION CR|
|00006310| 45 41 54 45 5f 43 48 41 | 52 54 28 29 0d 09 55 4e |EATE_CHA|RT()..UN|
|00006320| 53 45 4c 45 43 54 09 09 | 09 09 09 09 09 09 09 7b |SELECT..|.......{|
|00006330| 20 55 6e 73 65 6c 65 63 | 74 20 61 6e 79 20 73 65 | Unselec|t any se|
|00006340| 6c 65 63 74 65 64 20 69 | 74 65 6d 73 20 7d 20 0d |lected i|tems } .|
|00006350| 09 41 44 44 20 43 48 41 | 52 54 20 52 41 4e 47 45 |.ADD CHA|RT RANGE|
|00006360| 20 46 52 41 43 28 51 31 | 2e 2e 57 32 31 3b 31 3b | FRAC(Q1|..W21;1;|
|00006370| 30 3b 39 38 3b 31 32 36 | 29 0d 09 09 55 53 49 4e |0;98;126|)...USIN|
|00006380| 47 20 52 41 4e 47 45 28 | 4d 41 4b 45 52 41 4e 47 |G RANGE(|MAKERANG|
|00006390| 45 28 31 30 3b 32 3b 31 | 33 3b 6c 61 73 74 5f 72 |E(10;2;1|3;last_r|
|000063a0| 6f 77 29 29 09 7b 20 2e | 2e 2e 61 6e 64 20 74 68 |ow)).{ .|..and th|
|000063b0| 65 20 64 61 74 61 20 72 | 61 6e 67 65 20 7d 0d 09 |e data r|ange }..|
|000063c0| 53 45 4c 45 43 54 20 4f | 42 4a 45 43 54 20 31 09 |SELECT O|BJECT 1.|
|000063d0| 09 09 09 09 09 09 7b 20 | 53 65 6c 65 63 74 20 74 |......{ |Select t|
|000063e0| 68 65 20 63 68 61 72 74 | 20 7d 0d 09 4c 49 4e 45 |he chart| }..LINE|
|000063f0| 09 09 09 09 09 09 09 09 | 09 09 7b 20 43 68 6f 6f |........|..{ Choo|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.