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

next >

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 10 43 61 73 68 20 46 | 6c 6f 77 20 53 63 72 69 |..Cash F|low Scri|
|00000010| 70 74 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |pt......|........|
|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 32 c8 00 | 00 01 bf a4 58 08 a0 a4 |.....2..|....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 9c 08 00 00 |........|........|
|00000080| 42 41 54 5f 42 54 53 43 | 30 31 30 31 02 2b 00 00 |BAT_BTSC|0101.+..|
|00000090| 6e 07 00 00 c8 06 00 00 | c8 06 00 00 c8 06 00 00 |n.......|........|
|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 05 00 06 00 |........|........|
|000000d0| 0b 00 00 00 00 00 00 00 | 18 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 f4 00 02 18 00 00 00 | 00 00 00 00 00 f4 00 04 |........|........|
|000000f0| fd 04 1b 00 00 1b 00 00 | 00 f9 f2 70 00 1b 00 00 |........|...p....|
|00000100| 01 f9 f8 1a 00 00 18 00 | 00 00 00 00 00 08 40 3a |........|......@:|
|00000110| f2 1c 00 1b 00 00 02 f9 | f8 1b 00 00 03 f9 f8 fd |........|........|
|00000120| 04 1b 00 01 1b 00 00 04 | f9 f8 1d 40 00 fd 39 23 |........|...@..9#|
|00000130| 00 35 54 68 65 72 65 20 | 69 73 20 6e 6f 74 20 65 |.5There |is not e|
|00000140| 6e 6f 75 67 68 20 43 61 | 73 68 20 46 6c 6f 77 20 |nough Ca|sh Flow |
|00000150| 64 61 74 61 20 74 6f 20 | 63 72 65 61 74 65 20 61 |data to |create a|
|00000160| 20 67 72 61 70 68 2e fd | 03 01 01 fc f6 00 00 fd | graph..|........|
|00000170| 06 00 00 00 00 00 fd 0e | 08 01 01 01 01 07 07 00 |........|........|
|00000180| 00 00 00 ff 00 fd 17 00 | 06 00 12 4d 50 20 43 61 |........|...MP Ca|
|00000190| 73 68 20 46 6c 6f 77 20 | 54 61 62 6c 65 fe 40 18 |sh Flow |Table.@.|
|000001a0| 00 00 00 00 00 00 00 00 | 39 f2 14 00 fd 04 1a 04 |........|9.......|
|000001b0| 01 18 00 00 00 00 00 00 | f0 3f fa 1d 0c 00 18 00 |........|.?......|
|000001c0| 00 00 00 00 00 00 00 fa | fb f6 00 00 fd 04 1a 04 |........|........|
|000001d0| 01 fd 05 1a 05 00 0d fd | 05 1a 05 00 04 fd 05 1a |........|........|
|000001e0| 05 00 03 fd 05 1a 05 00 | 05 fd 13 08 01 01 01 01 |........|........|
|000001f0| 0c 08 0f 00 00 00 00 00 | 00 ff 7f ff 00 fd 02 0c |........|........|
|00000200| fd 02 0c fd 13 08 01 01 | 01 01 0c 08 0f 00 00 fe |........|........|
|00000210| 7f 00 00 00 00 ff 00 fd | 02 0c 1b 00 00 05 f9 f4 |........|........|
|00000220| 00 00 fd 0f 0f 03 01 00 | 09 48 65 6c 76 65 74 69 |........|.Helveti|
|00000230| 63 61 fd 07 19 01 01 02 | 70 08 fd 14 17 00 08 53 |ca......|p......S|
|00000240| 74 61 72 74 69 6e 67 01 | 07 07 01 00 01 00 ff fd |tarting.|........|
|00000250| 16 17 00 0a 50 6c 61 6e | 20 43 6f 73 74 73 01 07 |....Plan| Costs..|
|00000260| 07 01 00 02 00 ff fd 17 | 17 00 0b 50 6c 61 6e 20 |........|...Plan |
|00000270| 49 6e 63 6f 6d 65 01 07 | 07 01 00 03 00 ff fd 18 |Income..|........|
|00000280| 17 00 0c 41 63 74 75 61 | 6c 20 43 6f 73 74 73 01 |...Actua|l Costs.|
|00000290| 07 07 01 00 04 00 ff fd | 19 17 00 0d 41 63 74 75 |........|....Actu|
|000002a0| 61 6c 20 49 6e 63 6f 6d | 65 01 07 07 01 00 05 00 |al Incom|e.......|
|000002b0| ff fd 12 17 00 06 45 6e | 64 69 6e 67 01 07 07 01 |......En|ding....|
|000002c0| 00 06 00 ff fd 10 17 00 | 04 50 6c 61 6e 01 07 07 |........|.Plan...|
|000002d0| 01 00 07 00 ff fd 12 17 | 00 06 41 63 74 75 61 6c |........|..Actual|
|000002e0| 01 07 07 01 00 08 00 ff | fd 28 17 01 1d 19 0c 43 |........|.(.....C|
|000002f0| 61 73 68 20 46 6c 6f 77 | 20 2d 20 5f 19 08 6d 6d |ash Flow| - _..mm|
|00000300| 2f 64 64 2f 79 79 68 35 | ff 01 07 07 00 00 06 00 |/dd/yyh5|........|
|00000310| ff fd 13 08 01 01 01 01 | 0c 08 0f 00 00 01 00 01 |........|........|
|00000320| 00 08 00 ff 00 fd 07 0f | 03 02 02 0e 00 fd 07 0f |........|........|
|00000330| 03 03 00 01 42 fd 07 0f | 03 03 00 01 49 fd 28 08 |....B...|....I.(.|
|00000340| 01 01 01 01 21 18 00 00 | 00 00 00 00 08 40 18 00 |....!...|.....@..|
|00000350| 00 00 00 00 00 08 40 18 | 00 00 00 00 00 00 18 40 |......@.|.......@|
|00000360| 1a 00 00 d8 ff 00 fd 05 | 0f 05 00 20 fd 06 0f 05 |........|... ....|
|00000370| 02 01 09 fd 28 08 01 01 | 01 01 21 18 00 00 00 00 |....(...|..!.....|
|00000380| 00 00 1c 40 18 00 00 00 | 00 00 00 08 40 18 00 00 |...@....|....@...|
|00000390| 00 00 00 00 1c 40 1a 00 | 00 d8 ff 00 fd 06 0f 05 |.....@..|........|
|000003a0| 00 50 81 fd 28 08 01 01 | 01 01 21 18 00 00 00 00 |.P..(...|..!.....|
|000003b0| 00 00 20 40 18 00 00 00 | 00 00 00 08 40 18 00 00 |.. @....|....@...|
|000003c0| 00 00 00 00 22 40 1a 00 | 00 d8 ff 00 fd 05 0f 05 |...."@..|........|
|000003d0| 00 20 fd 06 0f 05 02 01 | 09 fd 28 08 01 01 01 01 |. ......|..(.....|
|000003e0| 21 18 00 00 00 00 00 00 | 00 40 18 00 00 00 00 00 |!.......|.@......|
|000003f0| 00 00 40 18 00 00 00 00 | 00 00 22 40 1a 00 00 d8 |..@.....|.."@....|
|00000400| ff 00 fd 09 0f 0a 00 04 | 54 4c 42 52 fb f6 00 02 |........|TLBR....|
|00000410| 1a 00 00 18 00 00 00 00 | 00 00 26 40 3a f2 98 00 |........|..&@:...|
|00000420| 1a 00 00 2b 00 00 00 00 | 00 00 f0 3f 2d 00 00 00 |...+....|...?-...|
|00000430| 00 00 00 22 40 95 f4 03 | 02 18 00 00 00 00 00 00 |..."@...|........|
|00000440| 00 40 f4 03 01 1a 03 02 | 18 00 00 00 00 00 00 f0 |.@......|........|
|00000450| 3f 1d 16 00 1a 03 02 18 | 00 00 00 00 00 00 f0 3f |?.......|.......?|
|00000460| f7 1a 03 01 2e f4 03 01 | 1a 03 01 f5 4a 00 1a 03 |........|....J...|
|00000470| 01 2a 00 00 00 00 00 00 | f0 3f f4 00 01 1a 00 00 |.*......|.?......|
|00000480| 1a 03 02 1d 10 00 1a 00 | 00 1a 03 02 f7 1a 00 01 |........|........|
|00000490| 2e f4 00 01 1a 00 01 f5 | 1b 00 fd 15 17 00 01 20 |........|....... |
|000004a0| 01 0f 18 00 00 00 00 00 | 00 1c 40 1a 00 01 d4 ff |........|..@.....|
|000004b0| 1d d5 ff 1d a0 ff fb f6 | 00 00 fd 04 08 01 05 18 |........|........|
|000004c0| 00 00 00 00 00 00 f0 3f | fe 19 d1 fa fb f6 00 00 |.......?|........|
|000004d0| fd 04 08 01 07 fd 59 15 | 00 04 01 31 08 0f 00 00 |......Y.|...1....|
|000004e0| 14 00 0a 00 10 00 18 00 | 00 00 00 00 00 f0 3f 18 |........|......?.|
|000004f0| 00 00 00 00 00 00 00 00 | 18 00 00 00 00 00 80 58 |........|.......X|
|00000500| 40 18 00 00 00 00 00 80 | 5f 40 e3 ff 01 22 18 00 |@.......|_@..."..|
|00000510| 00 00 00 00 00 1c 40 18 | 00 00 00 00 00 00 00 40 |......@.|.......@|
|00000520| 18 00 00 00 00 00 00 22 | 40 1a 00 00 d8 d3 ff fd |......."|@.......|
|00000530| 08 09 01 04 01 81 00 00 | fd 04 16 00 01 fd 05 16 |........|........|
|00000540| 06 0e 03 fd 0c 09 01 04 | 01 81 00 04 00 01 81 00 |........|........|
|00000550| fd 0e 0f 01 01 00 03 00 | 00 00 00 00 40 65 41 fd |........|....@eA.|
|00000560| 06 0f 01 01 02 85 fd 0d | 09 01 04 01 81 00 06 00 |........|........|
|00000570| 01 81 00 00 1a 00 00 18 | 00 00 00 00 00 00 34 40 |........|......4@|
|00000580| 3a f2 08 00 fd 05 16 04 | 02 00 fd 07 16 04 04 01 |:.......|........|
|00000590| 00 80 fd 0f 16 04 04 01 | 01 03 00 00 00 e0 ff ff |........|........|
|000005a0| 6f 41 fd 07 16 04 04 01 | 02 80 fd 06 16 04 04 00 |oA......|........|
|000005b0| 85 fd 0f 16 04 03 01 00 | 03 00 00 00 60 77 77 67 |........|....`wwg|
|000005c0| 41 fd 0f 16 04 03 01 01 | 03 00 00 00 e0 ff ff 6f |A.......|.......o|
|000005d0| 41 fd 07 16 04 03 01 02 | 80 fd 06 16 04 03 00 80 |A.......|........|
|000005e0| fd 0d 09 01 04 01 81 00 | 06 00 01 83 00 00 fd 07 |........|........|
|000005f0| 16 04 04 01 00 80 fd 0f | 16 04 04 01 01 03 00 00 |........|........|
|00000600| 00 e0 ff ff 6f 41 fd 07 | 16 04 04 01 02 81 fd 06 |....oA..|........|
|00000610| 16 04 04 00 85 fd 07 16 | 04 03 01 00 80 fd 0f 16 |........|........|
|00000620| 04 03 01 01 03 00 00 00 | e0 ff ff 6f 41 fd 07 16 |........|...oA...|
|00000630| 04 03 01 02 81 fd 06 16 | 04 03 00 80 fd 08 09 01 |........|........|
|00000640| 04 01 81 00 00 fd 0e 08 | 00 01 01 01 07 07 00 00 |........|........|
|00000650| 06 00 ff 00 fd 04 16 01 | 02 fd 05 16 01 00 04 fd |........|........|
|00000660| 0e 08 01 01 01 01 07 07 | 00 00 11 00 ff 00 fd 0e |........|........|
|00000670| 08 01 01 01 01 07 07 00 | 00 0a 00 ff 00 fd 04 08 |........|........|
|00000680| 01 07 fb f6 00 00 fd 12 | 1d 00 00 00 02 ff ff 02 |........|........|
|00000690| ff ff 00 02 50 19 02 70 | 08 fd 4f 1e 0b 00 3b 43 |....P..p|..O...;C|
|000006a0| 6f 70 79 20 63 68 61 72 | 74 20 74 6f 20 43 6c 69 |opy char|t to Cli|
|000006b0| 70 62 6f 61 72 64 20 61 | 6e 64 20 63 6c 6f 73 65 |pboard a|nd close|
|000006c0| 20 77 6f 72 6b 73 68 65 | 65 74 20 77 69 74 68 6f | workshe|et witho|
|000006d0| 75 74 20 73 61 76 69 6e | 67 3f 00 00 02 b4 00 02 |ut savin|g?......|
|000006e0| b4 00 01 02 e8 17 02 d0 | 02 fd 06 0f 02 00 1c 00 |........|........|
|000006f0| fd 2e 1e 00 01 00 0a 20 | 20 20 20 4e 6f 20 20 20 |....... |   No   |
|00000700| 20 01 00 0b 20 20 20 20 | 59 65 73 20 20 20 20 00 | ...    |Yes    .|
|00000710| 00 00 02 48 12 02 84 03 | 01 02 a0 05 02 38 04 fd |...H....|.....8..|
|00000720| 06 1d 0b 01 82 00 fd 03 | 1d 09 fd 21 21 03 00 00 |........|...!!...|
|00000730| 1b 27 43 61 73 68 20 46 | 6c 6f 77 20 73 63 72 69 |.'Cash F|low scri|
|00000740| 70 74 3a 64 6f 6e 65 27 | 20 3d 20 30 fd 06 1d 0b |pt:done'| = 0....|
|00000750| 01 83 00 fd 03 1d 08 fd | 21 21 03 00 00 1b 27 43 |........|!!....'C|
|00000760| 61 73 68 20 46 6c 6f 77 | 20 73 63 72 69 70 74 3a |ash Flow| script:|
|00000770| 64 6f 6e 65 27 20 3d 20 | 31 fd 03 1d 03 1a 00 02 |done' = |1.......|
|00000780| 18 00 00 00 00 00 00 f0 | 3f 39 f2 13 00 fd 08 09 |........|?9......|
|00000790| 01 04 01 81 00 00 fd 03 | 06 01 fd 03 01 01 fb fc |........|........|
|000007a0| 09 00 6c 61 73 74 5f 72 | 6f 77 00 09 00 6c 6f 6f |..last_r|ow...loo|
|000007b0| 70 5f 76 61 72 01 05 00 | 64 6f 6e 65 02 0d 00 74 |p_var...|done...t|
|000007c0| 69 6d 65 5f 6e 6f 77 5f | 72 6f 77 03 09 00 6e 65 |ime_now_|row...ne|
|000007d0| 67 5f 66 6c 61 67 04 10 | 01 00 4d 41 4b 45 5f 4e |g_flag..|..MAKE_N|
|000007e0| 45 57 5f 53 48 45 45 54 | 94 00 00 00 0e 01 00 46 |EW_SHEET|.......F|
|000007f0| 4f 52 4d 41 54 5f 54 41 | 42 4c 45 f1 00 00 00 0e |ORMAT_TA|BLE.....|
|00000800| 01 00 52 45 4d 4f 56 45 | 5f 44 41 54 45 53 35 03 |..REMOVE|_DATES5.|
|00000810| 00 00 0e 01 00 43 52 45 | 41 54 45 5f 43 48 41 52 |.....CRE|ATE_CHAR|
|00000820| 54 f5 03 00 00 0d 01 00 | 41 53 4b 5f 54 4f 5f 43 |T.......|ASK_TO_C|
|00000830| 4f 50 59 ab 05 00 00 0a | 01 00 47 45 54 5f 52 4f |OPY.....|..GET_RO|
|00000840| 57 53 df 03 00 00 7b 2a | 2a 2a 2a 2a 2a 2a 2a 2a |WS....{*|********|
|00000850| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000860| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 20 43 41 53 |********|**** CAS|
|00000870| 48 20 46 4c 4f 57 20 53 | 43 52 49 50 54 20 2a 2a |H FLOW S|CRIPT **|
|00000880| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000890| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000008a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 0d 0d 20 20 |********|****..  |
|000008b0| 43 6f 70 79 72 69 67 68 | 74 20 a9 20 31 39 39 31 |Copyrigh|t . 1991|
|000008c0| 20 43 6c 61 72 69 73 20 | 43 6f 72 70 2e 20 20 41 | Claris |Corp.  A|
|000008d0| 6c 6c 20 72 69 67 68 74 | 73 20 72 65 73 65 72 76 |ll right|s reserv|
|000008e0| 65 64 2e 0d 0d 20 20 4c | 41 53 54 20 4d 4f 44 49 |ed...  L|AST MODI|
|000008f0| 46 49 45 44 3a 20 20 32 | 2f 31 34 2f 39 31 0d 0d |FIED:  2|/14/91..|
|00000900| 20 20 54 61 62 6c 65 73 | 20 55 73 65 64 3a 0d 09 |  Tables| Used:..|
|00000910| a5 20 20 43 61 73 68 20 | 46 6c 6f 77 20 54 61 62 |.  Cash |Flow Tab|
|00000920| 6c 65 0d 0d 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |le..****|********|
|00000930| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000940| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 44 45 46 49 4e |********|** DEFIN|
|00000950| 45 20 47 4c 4f 42 41 4c | 20 56 41 52 49 41 42 4c |E GLOBAL| VARIABL|
|00000960| 45 53 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |ES *****|********|
|00000970| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000980| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 44 45 46 49 |********|*}..DEFI|
|00000990| 4e 45 20 6c 61 73 74 5f | 72 6f 77 09 09 7b 20 4c |NE last_|row..{ L|
|000009a0| 61 73 74 20 72 6f 77 20 | 6f 66 20 64 61 74 61 20 |ast row |of data |
|000009b0| 6f 6e 20 74 68 65 20 43 | 61 73 68 20 46 6c 6f 77 |on the C|ash Flow|
|000009c0| 20 54 61 62 6c 65 20 7d | 0d 44 45 46 49 4e 45 20 | Table }|.DEFINE |
|000009d0| 6c 6f 6f 70 5f 76 61 72 | 09 09 7b 20 4c 6f 6f 70 |loop_var|..{ Loop|
|000009e0| 20 69 74 65 72 61 74 69 | 6f 6e 20 63 6f 75 6e 74 | iterati|on count|
|000009f0| 65 72 20 7d 0d 44 45 46 | 49 4e 45 20 64 6f 6e 65 |er }.DEF|INE done|
|00000a00| 09 09 09 7b 20 41 72 65 | 20 77 65 20 64 6f 6e 65 |...{ Are| we done|
|00000a10| 20 79 65 74 3f 20 7d 0d | 44 45 46 49 4e 45 20 74 | yet? }.|DEFINE t|
|00000a20| 69 6d 65 5f 6e 6f 77 5f | 72 6f 77 09 09 7b 20 54 |ime_now_|row..{ T|
|00000a30| 68 65 20 72 6f 77 20 6e | 75 6d 62 65 72 20 74 68 |he row n|umber th|
|00000a40| 61 74 20 72 65 70 72 65 | 73 65 6e 74 73 20 74 68 |at repre|sents th|
|00000a50| 65 20 63 75 72 72 65 6e | 74 20 74 69 6d 65 20 7d |e curren|t time }|
|00000a60| 0d 44 45 46 49 4e 45 20 | 6e 65 67 5f 66 6c 61 67 |.DEFINE |neg_flag|
|00000a70| 09 09 7b 20 4e 65 67 61 | 74 69 76 65 20 76 61 6c |..{ Nega|tive val|
|00000a80| 75 65 20 66 6c 61 67 20 | 7d 0d 0d 64 6f 6e 65 20 |ue flag |}..done |
|00000a90| 3d 20 30 09 09 09 09 7b | 20 53 65 74 20 64 6f 6e |= 0....{| Set don|
|00000aa0| 65 20 74 6f 20 66 61 6c | 73 65 20 7d 0d 6e 65 67 |e to fal|se }.neg|
|00000ab0| 5f 66 6c 61 67 20 3d 20 | 30 09 09 09 7b 20 53 65 |_flag = |0...{ Se|
|00000ac0| 74 20 6e 65 67 5f 66 6c | 61 67 20 74 6f 20 66 61 |t neg_fl|ag to fa|
|00000ad0| 6c 73 65 20 7d 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |lse }..{|********|
|00000ae0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000af0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 4d 41 |********|***** MA|
|00000b00| 49 4e 20 53 43 52 49 50 | 54 20 2a 2a 2a 2a 2a 2a |IN SCRIP|T ******|
|00000b10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000b30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 7d 0d 0d 52 |********|****}..R|
|00000b40| 45 50 41 49 4e 54 20 4f | 46 46 09 09 09 09 09 7b |EPAINT O|FF.....{|
|00000b50| 20 54 75 72 6e 20 52 65 | 70 61 69 6e 74 20 6f 66 | Turn Re|paint of|
|00000b60| 66 20 74 6f 20 73 70 65 | 65 64 20 75 70 20 6f 70 |f to spe|ed up op|
|00000b70| 65 72 61 74 69 6f 6e 73 | 20 7d 0d 49 46 20 4d 41 |erations| }.IF MA|
|00000b80| 4b 45 5f 4e 45 57 5f 53 | 48 45 45 54 28 29 09 09 |KE_NEW_S|HEET()..|
|00000b90| 09 09 7b 20 43 72 65 61 | 74 65 20 61 20 6e 65 77 |..{ Crea|te a new|
|00000ba0| 20 77 6f 72 6b 73 68 65 | 65 74 20 66 6f 72 20 66 | workshe|et for f|
|00000bb0| 69 6e 61 6c 20 72 65 73 | 75 6c 74 73 20 7d 0d 09 |inal res|ults }..|
|00000bc0| 43 41 4c 4c 20 46 4f 52 | 4d 41 54 5f 54 41 42 4c |CALL FOR|MAT_TABL|
|00000bd0| 45 28 29 09 09 09 7b 20 | 43 61 6c 6c 20 74 68 65 |E()...{ |Call the|
|00000be0| 20 46 4f 52 4d 41 54 5f | 54 41 42 4c 45 20 66 75 | FORMAT_|TABLE fu|
|00000bf0| 6e 63 74 69 6f 6e 20 7d | 0d 09 49 46 20 6c 61 73 |nction }|..IF las|
|00000c00| 74 5f 72 6f 77 20 3e 20 | 33 09 09 09 7b 20 49 46 |t_row > |3...{ IF|
|00000c10| 20 74 68 65 72 65 20 61 | 72 65 20 6d 6f 72 65 20 | there a|re more |
|00000c20| 74 68 61 6e 20 33 20 72 | 6f 77 73 20 28 74 69 74 |than 3 r|ows (tit|
|00000c30| 6c 65 2c 20 68 65 61 64 | 69 6e 67 73 2c 20 64 61 |le, head|ings, da|
|00000c40| 74 61 29 2e 2e 2e 20 7d | 0d 09 09 43 41 4c 4c 20 |ta)... }|...CALL |
|00000c50| 52 45 4d 4f 56 45 5f 44 | 41 54 45 53 28 29 09 09 |REMOVE_D|ATES()..|
|00000c60| 7b 20 43 61 6c 6c 20 74 | 68 65 20 52 45 4d 4f 56 |{ Call t|he REMOV|
|00000c70| 45 5f 44 41 54 45 53 20 | 66 75 6e 63 74 69 6f 6e |E_DATES |function|
|00000c80| 20 7d 0d 09 09 43 41 4c | 4c 20 43 52 45 41 54 45 | }...CAL|L CREATE|
|00000c90| 5f 43 48 41 52 54 28 29 | 09 09 7b 20 43 61 6c 6c |_CHART()|..{ Call|
|00000ca0| 20 74 68 65 20 43 52 45 | 41 54 45 5f 43 48 41 52 | the CRE|ATE_CHAR|
|00000cb0| 54 20 66 75 6e 63 74 69 | 6f 6e 20 7d 0d 09 09 52 |T functi|on }...R|
|00000cc0| 45 50 41 49 4e 54 20 4f | 4e 09 09 09 7b 20 54 75 |EPAINT O|N...{ Tu|
|00000cd0| 72 6e 20 52 65 70 61 69 | 6e 74 20 6f 6e 20 74 6f |rn Repai|nt on to|
|00000ce0| 20 73 68 6f 77 20 6f 75 | 72 20 63 68 61 72 74 20 | show ou|r chart |
|00000cf0| 7d 0d 09 09 43 41 4c 4c | 20 41 53 4b 5f 54 4f 5f |}...CALL| ASK_TO_|
|00000d00| 43 4f 50 59 28 29 09 09 | 7b 20 43 61 6c 6c 20 74 |COPY()..|{ Call t|
|00000d10| 68 65 20 41 53 4b 5f 54 | 4f 5f 43 4f 50 59 20 66 |he ASK_T|O_COPY f|
|00000d20| 75 6e 63 74 69 6f 6e 20 | 7d 0d 09 45 4c 53 45 09 |unction |}..ELSE.|
|00000d30| 09 09 09 09 09 7b 20 4f | 74 68 65 72 77 69 73 65 |.....{ O|therwise|
|00000d40| 20 7d 0d 09 09 4d 45 53 | 53 41 47 45 20 22 54 68 | }...MES|SAGE "Th|
|00000d50| 65 72 65 20 69 73 20 6e | 6f 74 20 65 6e 6f 75 67 |ere is n|ot enoug|
|00000d60| 68 20 43 61 73 68 20 46 | 6c 6f 77 20 64 61 74 61 |h Cash F|low data|
|00000d70| 20 74 6f 20 63 72 65 61 | 74 65 20 61 20 67 72 61 | to crea|te a gra|
|00000d80| 70 68 2e 22 20 0d 09 09 | 43 4c 4f 53 45 20 4e 4f |ph." ...|CLOSE NO|
|00000d90| 57 09 09 09 09 7b 20 43 | 6c 6f 73 65 20 43 61 73 |W....{ C|lose Cas|
|00000da0| 68 20 46 6c 6f 77 20 54 | 61 62 6c 65 20 77 69 74 |h Flow T|able wit|
|00000db0| 68 6f 75 74 20 73 61 76 | 69 6e 67 20 7d 0d 09 45 |hout sav|ing }..E|
|00000dc0| 4e 44 20 49 46 0d 45 4e | 44 20 49 46 0d 0d 7b 2a |ND IF.EN|D IF..{*|
|00000dd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000de0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000df0| 2a 2a 20 4d 41 4b 45 5f | 4e 45 57 5f 53 48 45 45 |** MAKE_|NEW_SHEE|
|00000e00| 54 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |T ******|********|
|00000e10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000e20| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000e30| 2a 2a 2a 0d 20 20 54 68 | 69 73 20 66 75 6e 63 74 |***.  Th|is funct|
|00000e40| 69 6f 6e 20 63 72 65 61 | 74 65 73 20 61 20 6e 65 |ion crea|tes a ne|
|00000e50| 77 20 77 6f 72 6b 73 68 | 65 65 74 20 69 6e 20 77 |w worksh|eet in w|
|00000e60| 68 69 63 68 20 74 68 65 | 20 66 69 6e 61 6c 20 73 |hich the| final s|
|00000e70| 63 72 69 70 74 20 72 65 | 73 75 6c 74 73 20 77 69 |cript re|sults wi|
|00000e80| 6c 6c 20 62 65 20 64 69 | 73 70 6c 61 79 65 64 2e |ll be di|splayed.|
|00000e90| 0d 20 20 54 68 69 73 20 | 73 74 65 70 20 69 73 20 |.  This |step is |
|00000ea0| 6e 65 63 65 73 73 61 72 | 79 20 73 6f 20 74 68 61 |necessar|y so tha|
|00000eb0| 74 20 74 68 65 20 66 69 | 6e 61 6c 20 77 6f 72 6b |t the fi|nal work|
|00000ec0| 73 68 65 65 74 20 6d 61 | 79 20 62 65 20 6c 65 66 |sheet ma|y be lef|
|00000ed0| 74 20 6f 70 65 6e 20 77 | 68 65 6e 20 72 65 2d 65 |t open w|hen re-e|
|00000ee0| 78 65 63 75 74 69 6e 67 | 0d 20 20 74 68 65 20 73 |xecuting|.  the s|
|00000ef0| 61 6d 65 20 45 78 63 68 | 61 6e 67 65 20 69 74 65 |ame Exch|ange ite|
|00000f00| 6d 20 28 6f 72 20 61 6e | 6f 74 68 65 72 20 77 68 |m (or an|other wh|
|00000f10| 69 63 68 20 75 73 65 73 | 20 74 68 65 20 73 61 6d |ich uses| the sam|
|00000f20| 65 20 65 78 70 6f 72 74 | 20 64 6f 63 75 6d 65 6e |e export| documen|
|00000f30| 74 29 20 77 69 74 68 6f | 75 74 20 63 61 75 73 69 |t) witho|ut causi|
|00000f40| 6e 67 0d 20 20 61 20 63 | 6f 6e 66 6c 69 63 74 20 |ng.  a c|onflict |
|00000f50| 6f 66 20 77 6f 72 6b 73 | 68 65 65 74 20 6e 61 6d |of works|heet nam|
|00000f60| 65 73 2e 0d 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |es.. ***|********|
|00000f70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00000fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 7d 0d 0d 46 55 4e 43 |********|*}..FUNC|
|00000fd0| 54 49 4f 4e 20 4d 41 4b | 45 5f 4e 45 57 5f 53 48 |TION MAK|E_NEW_SH|
|00000fe0| 45 45 54 28 29 0d 09 4e | 45 57 20 57 4f 52 4b 53 |EET()..N|EW WORKS|
|00000ff0| 48 45 45 54 20 22 22 09 | 09 09 09 7b 20 43 72 65 |HEET "".|...{ Cre|
|00001000| 61 74 65 20 61 20 6e 65 | 77 20 75 6e 74 69 74 6c |ate a ne|w untitl|
|00001010| 65 64 20 77 6f 72 6b 73 | 68 65 65 74 20 7d 0d 09 |ed works|heet }..|
|00001020| 53 45 4c 45 43 54 20 52 | 41 4e 47 45 20 41 31 09 |SELECT R|ANGE A1.|
|00001030| 09 09 09 7b 20 4d 61 6b | 65 20 73 75 72 65 20 74 |...{ Mak|e sure t|
|00001040| 68 65 20 6e 65 78 74 20 | 6c 69 6e 65 20 70 75 74 |he next |line put|
|00001050| 73 20 74 68 65 20 69 6e | 66 6f 20 69 6e 20 74 68 |s the in|fo in th|
|00001060| 65 20 63 6f 72 72 65 63 | 74 20 6c 6f 63 61 74 69 |e correc|t locati|
|00001070| 6f 6e 20 7d 0d 09 41 50 | 50 45 4e 44 20 22 4d 50 |on }..AP|PEND "MP|
|00001080| 20 43 61 73 68 20 46 6c | 6f 77 20 54 61 62 6c 65 | Cash Fl|ow Table|
|00001090| 22 09 09 7b 20 41 70 70 | 65 6e 64 20 4d 61 63 50 |"..{ App|end MacP|
|000010a0| 72 6f 6a 65 63 74 20 43 | 61 73 68 20 46 6c 6f 77 |roject C|ash Flow|
|000010b0| 20 65 78 70 6f 72 74 20 | 66 69 6c 65 20 7d 0d 09 | export |file }..|
|000010c0| 49 46 20 43 45 52 52 4f | 52 28 29 20 3d 20 30 09 |IF CERRO|R() = 0.|
|000010d0| 09 09 09 7b 20 57 61 73 | 20 74 68 65 20 43 61 73 |...{ Was| the Cas|
|000010e0| 68 20 46 6c 6f 77 20 64 | 6f 63 75 6d 65 6e 74 20 |h Flow d|ocument |
|000010f0| 66 6f 75 6e 64 3f 20 7d | 0d 09 09 5a 4f 4f 4d 20 |found? }|...ZOOM |
|00001100| 57 49 4e 44 4f 57 09 09 | 09 09 7b 20 4d 61 6b 65 |WINDOW..|..{ Make|
|00001110| 20 73 75 72 65 20 77 69 | 6e 64 6f 77 20 66 69 6c | sure wi|ndow fil|
|00001120| 6c 73 20 74 68 65 20 73 | 63 72 65 65 6e 20 7d 0d |ls the s|creen }.|
|00001130| 09 09 52 45 54 55 52 4e | 20 31 09 09 09 09 09 7b |..RETURN| 1.....{|
|00001140| 20 52 65 74 75 72 6e 20 | 61 20 76 61 6c 75 65 20 | Return |a value |
|00001150| 69 6e 64 69 63 61 74 69 | 6e 67 20 74 68 65 20 73 |indicati|ng the s|
|00001160| 63 72 69 70 74 20 73 68 | 6f 75 6c 64 20 63 6f 6e |cript sh|ould con|
|00001170| 74 69 6e 75 65 20 7d 0d | 09 45 4c 53 45 0d 09 09 |tinue }.|.ELSE...|
|00001180| 52 45 54 55 52 4e 20 30 | 09 09 09 09 09 7b 20 52 |RETURN 0|.....{ R|
|00001190| 65 74 75 72 6e 20 61 20 | 76 61 6c 75 65 20 69 6e |eturn a |value in|
|000011a0| 64 69 63 61 74 69 6e 67 | 20 74 68 65 20 73 63 72 |dicating| the scr|
|000011b0| 69 70 74 20 73 68 6f 75 | 6c 64 20 62 65 20 73 74 |ipt shou|ld be st|
|000011c0| 6f 70 70 65 64 20 7d 0d | 09 45 4e 44 20 49 46 0d |opped }.|.END IF.|
|000011d0| 45 4e 44 20 46 55 4e 43 | 54 49 4f 4e 0d 0d 7b 2a |END FUNC|TION..{*|
|000011e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000011f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001200| 2a 2a 2a 2a 20 46 4f 52 | 4d 41 54 5f 54 41 42 4c |**** FOR|MAT_TABL|
|00001210| 45 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |E ******|********|
|00001220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001240| 2a 2a 2a 2a 0d 20 20 54 | 68 69 73 20 66 75 6e 63 |****.  T|his func|
|00001250| 74 69 6f 6e 20 73 70 65 | 63 69 66 69 65 73 20 74 |tion spe|cifies t|
|00001260| 68 65 20 74 65 78 74 20 | 61 6e 64 20 63 65 6c 6c |he text |and cell|
|00001270| 20 61 74 74 72 69 62 75 | 74 65 73 20 6e 65 65 64 | attribu|tes need|
|00001280| 65 64 20 62 79 20 6f 75 | 72 20 63 68 61 72 74 2e |ed by ou|r chart.|
|00001290| 20 20 54 68 65 20 63 68 | 61 72 74 20 61 74 74 72 |  The ch|art attr|
|000012a0| 69 62 75 74 65 73 20 61 | 72 65 0d 20 20 64 65 74 |ibutes a|re.  det|
|000012b0| 65 72 6d 69 6e 65 64 20 | 62 79 20 74 68 65 20 61 |ermined |by the a|
|000012c0| 74 74 72 69 62 75 74 65 | 73 20 6f 66 20 74 68 6f |ttribute|s of tho|
|000012d0| 73 65 20 63 65 6c 6c 73 | 20 66 72 6f 6d 20 77 68 |se cells| from wh|
|000012e0| 69 63 68 20 69 74 73 20 | 64 61 74 61 20 69 73 20 |ich its |data is |
|000012f0| 64 65 72 69 76 65 64 2e | 0d 20 2a 2a 2a 2a 2a 2a |derived.|. ******|
|00001300| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001310| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001330| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001340| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001350| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 7d 0d |********|******}.|
|00001360| 0d 46 55 4e 43 54 49 4f | 4e 20 46 4f 52 4d 41 54 |.FUNCTIO|N FORMAT|
|00001370| 5f 54 41 42 4c 45 28 29 | 0d 09 5a 4f 4f 4d 20 57 |_TABLE()|..ZOOM W|
|00001380| 49 4e 44 4f 57 09 09 09 | 09 09 09 7b 20 5a 6f 6f |INDOW...|...{ Zoo|
|00001390| 6d 20 74 68 65 20 77 69 | 6e 64 6f 77 20 74 6f 20 |m the wi|ndow to |
|000013a0| 65 6e 73 75 72 65 20 74 | 68 61 74 20 69 74 20 66 |ensure t|hat it f|
|000013b0| 69 6c 6c 73 20 74 68 65 | 20 73 63 72 65 65 6e 20 |ills the| screen |
|000013c0| 7d 0d 09 48 49 44 45 20 | 48 45 41 44 49 4e 47 53 |}..HIDE |HEADINGS|
|000013d0| 09 09 09 09 09 09 7b 20 | 48 69 64 65 20 74 68 65 |......{ |Hide the|
|000013e0| 20 72 6f 77 20 61 6e 64 | 20 63 6f 6c 75 6d 6e 20 | row and| column |
|000013f0| 68 65 61 64 69 6e 67 73 | 20 7d 0d 09 48 49 44 45 |headings| }..HIDE|
|00001400| 20 54 4f 4f 4c 20 42 4f | 58 09 09 09 09 09 09 7b | TOOL BO|X......{|
|00001410| 20 48 69 64 65 20 74 68 | 65 20 74 6f 6f 6c 20 70 | Hide th|e tool p|
|00001420| 61 6c 65 74 74 65 20 61 | 74 20 74 68 65 20 6c 65 |alette a|t the le|
|00001430| 66 74 20 65 64 67 65 20 | 6f 66 20 74 68 65 20 77 |ft edge |of the w|
|00001440| 69 6e 64 6f 77 20 7d 0d | 09 48 49 44 45 20 45 4e |indow }.|.HIDE EN|
|00001450| 54 52 59 20 42 41 52 09 | 09 09 09 09 09 7b 20 48 |TRY BAR.|.....{ H|
|00001460| 69 64 65 20 74 68 65 20 | 65 6e 74 72 79 20 62 61 |ide the |entry ba|
|00001470| 72 20 61 74 20 74 68 65 | 20 74 6f 70 20 6f 66 20 |r at the| top of |
|00001480| 74 68 65 20 77 69 6e 64 | 6f 77 20 7d 0d 09 48 49 |the wind|ow }..HI|
|00001490| 44 45 20 43 45 4c 4c 20 | 47 52 49 44 09 09 09 09 |DE CELL |GRID....|
|000014a0| 09 09 7b 20 48 69 64 65 | 20 74 68 65 20 63 65 6c |..{ Hide| the cel|
|000014b0| 6c 20 67 72 69 64 20 7d | 0d 09 53 45 4c 45 43 54 |l grid }|..SELECT|
|000014c0| 20 52 41 4e 47 45 20 41 | 31 2e 2e 41 56 4c 48 31 | RANGE A|1..AVLH1|
|000014d0| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 74 68 65 |....{ Se|lect the|
|000014e0| 20 66 69 72 73 74 20 72 | 6f 77 20 6f 66 20 74 68 | first r|ow of th|
|000014f0| 65 20 74 61 62 6c 65 20 | 7d 0d 09 49 4e 53 45 52 |e table |}..INSER|
|00001500| 54 09 09 09 09 09 09 09 | 7b 20 49 6e 73 65 72 74 |T.......|{ Insert|
|00001510| 20 61 20 72 6f 77 20 66 | 6f 72 20 6e 61 6d 65 73 | a row f|or names|
|00001520| 20 69 6e 20 74 68 65 20 | 43 61 73 68 20 46 6c 6f | in the |Cash Flo|
|00001530| 77 20 43 68 61 72 74 2e | 20 7d 0d 09 49 4e 53 45 |w Chart.| }..INSE|
|00001540| 52 54 09 09 09 09 09 09 | 09 7b 20 49 6e 73 65 72 |RT......|.{ Inser|
|00001550| 74 20 61 20 72 6f 77 20 | 61 62 6f 76 65 20 6e 61 |t a row |above na|
|00001560| 6d 65 73 20 66 6f 72 20 | 6c 6f 6f 6b 73 20 7d 0d |mes for |looks }.|
|00001570| 09 53 45 4c 45 43 54 20 | 52 41 4e 47 45 20 41 31 |.SELECT |RANGE A1|
|00001580| 2e 2e 41 33 32 37 36 37 | 09 09 09 09 7b 20 53 65 |..A32767|....{ Se|
|00001590| 6c 65 63 74 20 74 68 65 | 20 66 69 72 73 74 20 63 |lect the| first c|
|000015a0| 6f 6c 75 6d 6e 20 6f 66 | 20 74 68 65 20 74 61 62 |olumn of| the tab|
|000015b0| 6c 65 20 7d 0d 09 49 4e | 53 45 52 54 09 09 09 09 |le }..IN|SERT....|
|000015c0| 09 09 09 7b 20 49 6e 73 | 65 72 74 20 61 6e 20 65 |...{ Ins|ert an e|
|000015d0| 6d 70 74 79 20 63 6f 6c | 75 6d 6e 20 66 6f 72 20 |mpty col|umn for |
|000015e0| 6c 6f 6f 6b 73 20 7d 0d | 09 6c 61 73 74 5f 72 6f |looks }.|.last_ro|
|000015f0| 77 20 3d 20 47 45 54 5f | 52 4f 57 53 28 29 09 09 |w = GET_|ROWS()..|
|00001600| 09 09 7b 20 44 65 74 65 | 72 6d 69 6e 65 20 74 68 |..{ Dete|rmine th|
|00001610| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 72 6f 77 73 |e number| of rows|
|00001620| 20 69 6e 20 74 68 65 20 | 74 61 62 6c 65 20 7d 0d | in the |table }.|
|00001630| 09 54 45 58 54 20 46 4f | 4e 54 20 22 48 65 6c 76 |.TEXT FO|NT "Helv|
|00001640| 65 74 69 63 61 22 09 09 | 09 09 7b 20 53 65 74 20 |etica"..|..{ Set |
|00001650| 74 68 65 20 66 6f 6e 74 | 20 74 6f 20 48 65 6c 76 |the font| to Helv|
|00001660| 65 74 69 63 61 20 7d 0d | 09 43 4f 4c 55 4d 4e 20 |etica }.|.COLUMN |
|00001670| 57 49 44 54 48 20 28 31 | 2e 35 20 49 4e 43 48 45 |WIDTH (1|.5 INCHE|
|00001680| 53 20 29 09 09 09 7b 20 | 53 65 74 20 74 68 65 20 |S )...{ |Set the |
|00001690| 63 6f 6c 75 6d 6e 20 77 | 69 64 74 68 20 66 6f 72 |column w|idth for|
|000016a0| 20 74 68 65 20 64 61 74 | 61 20 7d 0d 09 50 55 54 | the dat|a }..PUT|
|000016b0| 20 22 53 74 61 72 74 69 | 6e 67 22 20 49 4e 54 4f | "Starti|ng" INTO|
|000016c0| 20 42 32 09 09 09 09 7b | 20 41 64 64 20 74 68 65 | B2....{| Add the|
|000016d0| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 20 | column |heading |
|000016e0| 7d 0d 09 50 55 54 20 22 | 50 6c 61 6e 20 43 6f 73 |}..PUT "|Plan Cos|
|000016f0| 74 73 22 20 49 4e 54 4f | 20 43 32 09 09 09 09 7b |ts" INTO| C2....{|
|00001700| 20 41 64 64 20 74 68 65 | 20 63 6f 6c 75 6d 6e 20 | Add the| column |
|00001710| 68 65 61 64 69 6e 67 20 | 7d 0d 09 50 55 54 20 22 |heading |}..PUT "|
|00001720| 50 6c 61 6e 20 49 6e 63 | 6f 6d 65 22 20 49 4e 54 |Plan Inc|ome" INT|
|00001730| 4f 20 44 32 09 09 09 7b | 20 41 64 64 20 74 68 65 |O D2...{| Add the|
|00001740| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 20 | column |heading |
|00001750| 7d 0d 09 50 55 54 20 22 | 41 63 74 75 61 6c 20 43 |}..PUT "|Actual C|
|00001760| 6f 73 74 73 22 20 49 4e | 54 4f 20 45 32 09 09 09 |osts" IN|TO E2...|
|00001770| 7b 20 41 64 64 20 74 68 | 65 20 63 6f 6c 75 6d 6e |{ Add th|e column|
|00001780| 20 68 65 61 64 69 6e 67 | 20 7d 0d 09 50 55 54 20 | heading| }..PUT |
|00001790| 22 41 63 74 75 61 6c 20 | 49 6e 63 6f 6d 65 22 20 |"Actual |Income" |
|000017a0| 49 4e 54 4f 20 46 32 09 | 09 09 7b 20 41 64 64 20 |INTO F2.|..{ Add |
|000017b0| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 68 65 61 64 69 |the colu|mn headi|
|000017c0| 6e 67 20 7d 0d 09 50 55 | 54 20 22 45 6e 64 69 6e |ng }..PU|T "Endin|
|000017d0| 67 22 20 49 4e 54 4f 20 | 47 32 20 20 09 09 09 09 |g" INTO |G2  ....|
|000017e0| 7b 20 41 64 64 20 74 68 | 65 20 63 6f 6c 75 6d 6e |{ Add th|e column|
|000017f0| 20 68 65 61 64 69 6e 67 | 20 7d 0d 09 50 55 54 20 | heading| }..PUT |
|00001800| 22 50 6c 61 6e 22 20 49 | 4e 54 4f 20 48 32 09 09 |"Plan" I|NTO H2..|
|00001810| 09 09 09 7b 20 41 64 64 | 20 74 68 65 20 63 6f 6c |...{ Add| the col|
|00001820| 75 6d 6e 20 68 65 61 64 | 69 6e 67 20 7d 0d 09 50 |umn head|ing }..P|
|00001830| 55 54 20 22 41 63 74 75 | 61 6c 22 20 49 4e 54 4f |UT "Actu|al" INTO|
|00001840| 20 49 32 09 09 09 09 7b | 20 41 64 64 20 74 68 65 | I2....{| Add the|
|00001850| 20 63 6f 6c 75 6d 6e 20 | 68 65 61 64 69 6e 67 20 | column |heading |
|00001860| 7d 0d 09 50 55 54 20 22 | 43 61 73 68 20 46 6c 6f |}..PUT "|Cash Flo|
|00001870| 77 20 2d 20 22 20 09 09 | 09 09 09 7b 20 49 6e 73 |w - " ..|...{ Ins|
|00001880| 65 72 74 20 63 68 61 72 | 74 20 74 69 74 6c 65 20 |ert char|t title |
|00001890| 61 6e 64 2e 2e 2e 20 7d | 0d 09 09 26 41 44 41 54 |and... }|...&ADAT|
|000018a0| 45 28 4e 4f 57 28 29 3b | 22 6d 6d 2f 64 64 2f 79 |E(NOW();|"mm/dd/y|
|000018b0| 79 22 29 20 49 4e 54 4f | 20 47 31 20 20 09 7b 20 |y") INTO| G1  .{ |
|000018c0| 2e 2e 2e 64 61 74 65 20 | 69 6e 74 6f 20 63 65 6c |...date |into cel|
|000018d0| 6c 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |l }..SEL|ECT RANG|
|000018e0| 45 20 42 31 2e 2e 49 32 | 09 09 09 09 09 7b 20 53 |E B1..I2|.....{ S|
|000018f0| 65 6c 65 63 74 20 74 68 | 65 20 63 65 6c 6c 73 20 |elect th|e cells |
|00001900| 63 6f 6e 74 61 69 6e 69 | 6e 67 20 74 69 74 6c 65 |containi|ng title|
|00001910| 73 20 7d 0d 09 54 45 58 | 54 20 53 49 5a 45 20 31 |s }..TEX|T SIZE 1|
|00001920| 34 09 09 09 09 09 09 7b | 20 53 70 65 63 69 66 79 |4......{| Specify|
|00001930| 20 74 68 65 20 73 69 7a | 65 20 6f 66 20 74 68 65 | the siz|e of the|
|00001940| 20 74 69 74 6c 65 20 74 | 65 78 74 20 7d 0d 09 54 | title t|ext }..T|
|00001950| 45 58 54 20 53 54 59 4c | 45 20 22 42 22 09 09 09 |EXT STYL|E "B"...|
|00001960| 09 09 09 7b 20 4d 61 6b | 65 20 74 68 65 20 66 6f |...{ Mak|e the fo|
|00001970| 6e 74 20 62 6f 6c 64 20 | 7d 0d 09 54 45 58 54 20 |nt bold |}..TEXT |
|00001980| 53 54 59 4c 45 20 22 49 | 22 09 09 09 09 09 09 7b |STYLE "I|"......{|
|00001990| 20 4d 61 6b 65 20 74 68 | 65 20 66 6f 6e 74 20 69 | Make th|e font i|
|000019a0| 74 61 6c 69 63 20 7d 0d | 09 53 45 4c 45 43 54 20 |talic }.|.SELECT |
|000019b0| 52 41 4e 47 45 28 4d 41 | 4b 45 52 41 4e 47 45 28 |RANGE(MA|KERANGE(|
|000019c0| 33 3b 33 3b 36 3b 6c 61 | 73 74 5f 72 6f 77 29 29 |3;3;6;la|st_row))|
|000019d0| 20 7b 20 53 65 6c 65 63 | 74 20 63 6f 6c 75 6d 6e | { Selec|t column|
|000019e0| 73 20 33 20 74 68 72 6f | 75 67 68 20 36 20 7d 0d |s 3 thro|ugh 6 }.|
|000019f0| 09 46 4f 52 4d 41 54 20 | 43 55 52 52 45 4e 43 59 |.FORMAT |CURRENCY|
|00001a00| 09 09 09 09 09 7b 20 43 | 68 61 6e 67 65 20 74 6f |.....{ C|hange to|
|00001a10| 20 63 75 72 72 65 6e 63 | 79 20 66 6f 72 6d 61 74 | currenc|y format|
|00001a20| 20 7d 0d 09 55 53 45 20 | 43 4f 4d 4d 41 53 09 09 | }..USE |COMMAS..|
|00001a30| 09 09 09 09 7b 20 55 73 | 65 20 63 6f 6d 6d 61 73 |....{ Us|e commas|
|00001a40| 20 69 6e 20 74 68 65 20 | 64 6f 6c 6c 61 72 20 66 | in the |dollar f|
|00001a50| 6f 72 6d 61 74 20 7d 0d | 09 53 45 4c 45 43 54 20 |ormat }.|.SELECT |
|00001a60| 52 41 4e 47 45 28 4d 41 | 4b 45 52 41 4e 47 45 28 |RANGE(MA|KERANGE(|
|00001a70| 37 3b 33 3b 37 3b 6c 61 | 73 74 5f 72 6f 77 29 29 |7;3;7;la|st_row))|
|00001a80| 09 7b 20 53 65 6c 65 63 | 74 20 63 6f 6c 75 6d 6e |.{ Selec|t column|
|00001a90| 20 37 20 7d 0d 09 46 4f | 52 4d 41 54 20 44 41 54 | 7 }..FO|RMAT DAT|
|00001aa0| 45 20 31 09 09 09 09 09 | 09 7b 20 43 68 61 6e 67 |E 1.....|.{ Chang|
|00001ab0| 65 20 74 68 65 20 64 61 | 74 65 20 66 6f 72 6d 61 |e the da|te forma|
|00001ac0| 74 20 7d 0d 09 53 45 4c | 45 43 54 20 52 41 4e 47 |t }..SEL|ECT RANG|
|00001ad0| 45 28 4d 41 4b 45 52 41 | 4e 47 45 28 38 3b 33 3b |E(MAKERA|NGE(8;3;|
|00001ae0| 39 3b 6c 61 73 74 5f 72 | 6f 77 29 29 20 7b 20 53 |9;last_r|ow)) { S|
|00001af0| 65 6c 65 63 74 20 63 6f | 6c 75 6d 6e 73 20 38 20 |elect co|lumns 8 |
|00001b00| 74 68 72 6f 75 67 68 20 | 31 30 20 7d 0d 09 46 4f |through |10 }..FO|
|00001b10| 52 4d 41 54 20 43 55 52 | 52 45 4e 43 59 09 09 09 |RMAT CUR|RENCY...|
|00001b20| 09 09 7b 20 43 68 61 6e | 67 65 20 74 6f 20 63 75 |..{ Chan|ge to cu|
|00001b30| 72 72 65 6e 63 79 20 66 | 6f 72 6d 61 74 20 7d 0d |rrency f|ormat }.|
|00001b40| 09 55 53 45 20 43 4f 4d | 4d 41 53 09 09 09 09 09 |.USE COM|MAS.....|
|00001b50| 09 7b 20 55 73 65 20 63 | 6f 6d 6d 61 73 20 69 6e |.{ Use c|ommas in|
|00001b60| 20 74 68 65 20 64 6f 6c | 6c 61 72 20 66 6f 72 6d | the dol|lar form|
|00001b70| 61 74 20 7d 0d 09 53 45 | 4c 45 43 54 20 52 41 4e |at }..SE|LECT RAN|
|00001b80| 47 45 28 4d 41 4b 45 52 | 41 4e 47 45 28 32 3b 32 |GE(MAKER|ANGE(2;2|
|00001b90| 3b 39 3b 6c 61 73 74 5f | 72 6f 77 29 29 20 7b 20 |;9;last_|row)) { |
|00001ba0| 53 65 6c 65 63 74 20 65 | 6e 74 69 72 65 20 74 61 |Select e|ntire ta|
|00001bb0| 62 6c 65 20 7d 0d 09 43 | 45 4c 4c 20 42 4f 52 44 |ble }..C|ELL BORD|
|00001bc0| 45 52 20 22 54 4c 42 52 | 22 09 09 09 09 09 7b 20 |ER "TLBR|".....{ |
|00001bd0| 50 75 74 20 62 6f 72 64 | 65 72 20 61 72 6f 75 6e |Put bord|er aroun|
|00001be0| 64 20 65 61 63 68 20 63 | 65 6c 6c 20 7d 0d 45 4e |d each c|ell }.EN|
|00001bf0| 44 20 46 55 4e 43 54 49 | 4f 4e 0d 0d 7b 2a 2a 2a |D FUNCTI|ON..{***|
|00001c00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c10| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c20| 2a 2a 20 52 45 4d 4f 56 | 45 5f 44 41 54 45 53 20 |** REMOV|E_DATES |
|00001c30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001c60| 2a 2a 0d 20 20 54 68 69 | 73 20 66 75 6e 63 74 69 |**.  Thi|s functi|
|00001c70| 6f 6e 20 65 6c 69 6d 69 | 6e 61 74 65 73 20 73 6f |on elimi|nates so|
|00001c80| 6d 65 20 6f 66 20 74 68 | 65 20 64 61 74 65 73 20 |me of th|e dates |
|00001c90| 74 6f 20 72 65 64 75 63 | 65 20 63 72 6f 77 64 69 |to reduc|e crowdi|
|00001ca0| 6e 67 20 6f 6e 20 78 20 | 61 78 69 73 2e 0d 20 2a |ng on x |axis.. *|
|00001cb0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001cc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001cd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001ce0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001cf0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001d00| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001d10| 2a 2a 2a 7d 0d 09 0d 46 | 55 4e 43 54 49 4f 4e 20 |***}...F|UNCTION |
|00001d20| 52 45 4d 4f 56 45 5f 44 | 41 54 45 53 28 29 0d 09 |REMOVE_D|ATES()..|
|00001d30| 44 45 46 49 4e 45 20 6f | 75 74 65 72 5f 6c 6f 6f |DEFINE o|uter_loo|
|00001d40| 70 09 09 09 09 09 09 7b | 20 4f 75 74 65 72 20 6c |p......{| Outer l|
|00001d50| 6f 6f 70 20 63 6f 75 6e | 74 65 72 20 7d 0d 09 44 |oop coun|ter }..D|
|00001d60| 45 46 49 4e 45 20 65 6e | 64 5f 6c 6f 6f 70 09 09 |EFINE en|d_loop..|
|00001d70| 09 09 09 09 7b 20 45 6e | 64 20 6f 66 20 6c 6f 6f |....{ En|d of loo|
|00001d80| 70 20 63 6f 75 6e 74 65 | 72 7d 0d 09 0d 09 49 46 |p counte|r}....IF|
|00001d90| 20 6c 61 73 74 5f 72 6f | 77 20 3e 20 31 31 09 09 | last_ro|w > 11..|
|00001da0| 09 09 09 09 7b 20 43 68 | 65 63 6b 20 66 6f 72 20 |....{ Ch|eck for |
|00001db0| 6d 69 6e 69 6d 75 6d 20 | 23 20 6f 66 20 72 6f 77 |minimum |# of row|
|00001dc0| 73 20 7d 0d 09 09 65 6e | 64 5f 6c 6f 6f 70 20 3d |s }...en|d_loop =|
|00001dd0| 20 49 4e 54 28 28 6c 61 | 73 74 5f 72 6f 77 2d 31 | INT((la|st_row-1|
|00001de0| 29 2f 39 29 09 09 7b 20 | 43 61 6c 63 75 6c 61 74 |)/9)..{ |Calculat|
|00001df0| 65 20 6e 75 6d 62 65 72 | 20 6f 66 20 63 65 6c 6c |e number| of cell|
|00001e00| 73 20 74 6f 20 63 6c 65 | 61 72 20 7d 0d 09 09 46 |s to cle|ar }...F|
|00001e10| 4f 52 20 6f 75 74 65 72 | 5f 6c 6f 6f 70 20 3d 20 |OR outer|_loop = |
|00001e20| 32 20 74 6f 20 65 6e 64 | 5f 6c 6f 6f 70 09 09 7b |2 to end|_loop..{|
|00001e30| 20 42 65 67 69 6e 20 6f | 75 74 65 72 20 6c 6f 6f | Begin o|uter loo|
|00001e40| 70 20 7d 0d 09 09 09 46 | 4f 52 20 6c 6f 6f 70 5f |p }....F|OR loop_|
|00001e50| 76 61 72 20 3d 20 6f 75 | 74 65 72 5f 6c 6f 6f 70 |var = ou|ter_loop|
|00001e60| 2b 31 20 09 09 7b 20 53 | 74 61 72 74 69 6e 67 20 |+1 ..{ S|tarting |
|00001e70| 61 74 20 72 6f 77 20 6f | 75 74 65 72 5f 6c 6f 6f |at row o|uter_loo|
|00001e80| 70 2b 31 2e 2e 2e 20 7d | 0d 09 09 09 09 54 4f 20 |p+1... }|.....TO |
|00001e90| 6c 61 73 74 5f 72 6f 77 | 20 53 54 45 50 20 65 6e |last_row| STEP en|
|00001ea0| 64 5f 6c 6f 6f 70 20 09 | 7b 20 2e 2e 2e 73 74 65 |d_loop .|{ ...ste|
|00001eb0| 70 20 74 68 72 6f 75 67 | 68 20 65 76 65 72 79 20 |p throug|h every |
|00001ec0| 65 6e 64 5f 6c 6f 6f 70 | 74 68 20 72 6f 77 20 7d |end_loop|th row }|
|00001ed0| 0d 20 09 09 09 09 50 55 | 54 20 22 20 22 20 49 4e |. ....PU|T " " IN|
|00001ee0| 54 4f 20 4d 41 4b 45 43 | 45 4c 4c 28 37 3b 20 6c |TO MAKEC|ELL(7; l|
|00001ef0| 6f 6f 70 5f 76 61 72 29 | 09 7b 20 50 75 74 20 61 |oop_var)|.{ Put a|
|00001f00| 20 62 6c 61 6e 6b 20 69 | 6e 74 6f 20 74 68 65 20 | blank i|nto the |
|00001f10| 63 65 6c 6c 20 7d 0d 09 | 09 09 45 4e 44 20 46 4f |cell }..|..END FO|
|00001f20| 52 09 09 09 09 09 09 7b | 20 45 6e 64 20 46 4f 52 |R......{| End FOR|
|00001f30| 20 6c 6f 6f 70 20 7d 0d | 09 09 45 4e 44 20 46 4f | loop }.|..END FO|
|00001f40| 52 09 09 09 09 09 09 09 | 7b 20 45 6e 64 20 46 4f |R.......|{ End FO|
|00001f50| 52 20 6c 6f 6f 70 20 7d | 0d 09 45 4e 44 20 49 46 |R loop }|..END IF|
|00001f60| 09 09 09 09 09 09 09 09 | 7b 20 45 6e 64 20 6c 6f |........|{ End lo|
|00001f70| 67 69 63 61 6c 20 49 46 | 20 7d 0d 45 4e 44 20 46 |gical IF| }.END F|
|00001f80| 55 4e 43 54 49 4f 4e 0d | 0d 7b 2a 2a 2a 2a 2a 2a |UNCTION.|.{******|
|00001f90| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001fa0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 20 |********|******* |
|00001fb0| 47 45 54 5f 52 4f 57 53 | 20 2a 2a 2a 2a 2a 2a 2a |GET_ROWS| *******|
|00001fc0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001fd0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00001fe0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 0d |********|*******.|
|00001ff0| 20 20 54 68 69 73 20 66 | 75 6e 63 74 69 6f 6e 20 |  This f|unction |
|00002000| 64 65 74 65 72 6d 69 6e | 65 73 20 74 68 65 20 6e |determin|es the n|
|00002010| 75 6d 62 65 72 20 6f 66 | 20 72 6f 77 73 20 75 73 |umber of| rows us|
|00002020| 65 64 20 6f 6e 20 61 20 | 63 68 61 72 74 2e 20 20 |ed on a |chart.  |
|00002030| 57 65 20 66 69 72 73 74 | 20 73 65 6c 65 63 74 20 |We first| select |
|00002040| 61 6c 6c 20 61 63 74 69 | 76 65 20 63 65 6c 6c 73 |all acti|ve cells|
|00002050| 2e 0d 20 20 57 65 20 74 | 68 65 6e 20 75 73 65 20 |..  We t|hen use |
|00002060| 74 68 65 20 53 45 4c 45 | 43 54 49 4f 4e 20 66 75 |the SELE|CTION fu|
|00002070| 6e 63 74 69 6f 6e 20 74 | 6f 20 72 65 74 75 72 6e |nction t|o return|
|00002080| 20 74 68 65 20 72 61 6e | 67 65 20 61 6e 64 20 74 | the ran|ge and t|
|00002090| 68 65 20 52 4f 57 53 20 | 66 75 6e 63 74 69 6f 6e |he ROWS |function|
|000020a0| 20 74 6f 20 67 65 74 20 | 74 68 65 20 6e 75 6d 62 | to get |the numb|
|000020b0| 65 72 20 6f 66 0d 20 20 | 72 6f 77 73 20 69 6e 20 |er of.  |rows in |
|000020c0| 74 68 61 74 20 72 61 6e | 67 65 2e 20 20 54 68 65 |that ran|ge.  The|
|000020d0| 20 72 65 73 75 6c 74 69 | 6e 67 20 76 61 6c 75 65 | resulti|ng value|
|000020e0| 20 69 73 20 74 68 65 6e | 20 72 65 74 75 72 6e 65 | is then| returne|
|000020f0| 64 20 74 6f 20 74 68 65 | 20 63 61 6c 6c 69 6e 67 |d to the| calling|
|00002100| 20 73 74 61 74 65 6d 65 | 6e 74 2e 0d 20 2a 2a 2a | stateme|nt.. ***|
|00002110| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002120| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002130| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002140| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002150| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002160| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002170| 2a 7d 0d 0d 46 55 4e 43 | 54 49 4f 4e 20 47 45 54 |*}..FUNC|TION GET|
|00002180| 5f 52 4f 57 53 28 29 0d | 09 53 45 4c 45 43 54 20 |_ROWS().|.SELECT |
|00002190| 41 43 54 49 56 45 20 43 | 45 4c 4c 53 09 09 09 09 |ACTIVE C|ELLS....|
|000021a0| 09 09 7b 20 53 65 6c 65 | 63 74 20 6e 6f 6e 2d 62 |..{ Sele|ct non-b|
|000021b0| 6c 61 6e 6b 20 63 65 6c | 6c 73 20 7d 0d 09 52 45 |lank cel|ls }..RE|
|000021c0| 54 55 52 4e 20 52 4f 57 | 53 28 53 45 4c 45 43 54 |TURN ROW|S(SELECT|
|000021d0| 49 4f 4e 28 31 29 29 09 | 09 09 09 7b 20 44 65 74 |ION(1)).|...{ Det|
|000021e0| 65 72 6d 69 6e 65 20 23 | 20 6f 66 20 72 6f 77 73 |ermine #| of rows|
|000021f0| 20 69 6e 20 74 68 65 20 | 73 65 6c 65 63 74 65 64 | in the |selected|
|00002200| 20 72 61 6e 67 65 20 7d | 0d 45 4e 44 20 46 55 4e | range }|.END FUN|
|00002210| 43 54 49 4f 4e 0d 0d 7b | 2a 2a 2a 2a 2a 2a 2a 2a |CTION..{|********|
|00002220| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002230| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 20 43 52 |********|***** CR|
|00002240| 45 41 54 45 5f 43 48 41 | 52 54 20 2a 2a 2a 2a 2a |EATE_CHA|RT *****|
|00002250| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002260| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002270| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0d 20 20 |********|*****.  |
|00002280| 54 68 69 73 20 66 75 6e | 63 74 69 6f 6e 20 63 72 |This fun|ction cr|
|00002290| 65 61 74 65 73 20 6f 75 | 72 20 43 61 73 68 20 46 |eates ou|r Cash F|
|000022a0| 6c 6f 77 20 63 68 61 72 | 74 2e 20 20 54 68 65 20 |low char|t.  The |
|000022b0| 63 68 61 72 74 20 74 79 | 70 65 20 69 73 20 66 69 |chart ty|pe is fi|
|000022c0| 72 73 74 20 73 70 65 63 | 69 66 69 65 64 20 61 73 |rst spec|ified as|
|000022d0| 20 61 20 6c 69 6e 65 20 | 67 72 61 70 68 20 74 68 | a line |graph th|
|000022e0| 65 6e 0d 20 20 74 68 65 | 20 66 6f 72 65 67 72 6f |en.  the| foregro|
|000022f0| 75 6e 64 20 61 6e 64 20 | 62 61 63 6b 67 72 6f 75 |und and |backgrou|
|00002300| 6e 64 20 63 6f 6c 6f 72 | 73 20 61 72 65 20 73 70 |nd color|s are sp|
|00002310| 65 63 69 66 69 65 64 2e | 20 20 54 68 65 20 46 52 |ecified.|  The FR|
|00002320| 41 43 20 66 75 6e 63 74 | 69 6f 6e 20 61 6c 6c 6f |AC funct|ion allo|
|00002330| 77 73 20 75 73 20 74 6f | 20 70 6f 73 69 74 69 6f |ws us to| positio|
|00002340| 6e 20 6f 75 72 0d 20 20 | 67 72 61 70 68 20 61 6e |n our.  |graph an|
|00002350| 79 77 68 65 72 65 20 6f | 6e 20 74 68 65 20 73 63 |ywhere o|n the sc|
|00002360| 72 65 65 6e 20 28 6e 6f | 72 6d 61 6c 6c 79 20 79 |reen (no|rmally y|
|00002370| 6f 75 20 61 72 65 20 6c | 69 6d 69 74 65 64 20 74 |ou are l|imited t|
|00002380| 6f 20 63 65 6c 6c 20 6c | 6f 63 61 74 69 6f 6e 73 |o cell l|ocations|
|00002390| 29 2e 0d 20 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |).. ****|********|
|000023a0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023b0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023c0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023d0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023e0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|000023f0| 2a 2a 2a 2a 2a 2a 2a 2a | 7d 0d 0d 46 55 4e 43 54 |********|}..FUNCT|
|00002400| 49 4f 4e 20 43 52 45 41 | 54 45 5f 43 48 41 52 54 |ION CREA|TE_CHART|
|00002410| 28 29 0d 09 55 4e 53 45 | 4c 45 43 54 09 09 09 09 |()..UNSE|LECT....|
|00002420| 09 09 09 09 09 7b 20 55 | 6e 73 65 6c 65 63 74 20 |.....{ U|nselect |
|00002430| 61 6e 79 20 73 65 6c 65 | 63 74 65 64 20 69 74 65 |any sele|cted ite|
|00002440| 6d 73 20 6f 72 20 63 65 | 6c 6c 73 20 7d 0d 09 41 |ms or ce|lls }..A|
|00002450| 64 64 20 43 68 61 72 74 | 20 52 61 6e 67 65 20 66 |dd Chart| Range f|
|00002460| 72 61 63 28 4b 31 2e 2e | 51 32 31 3b 31 3b 30 3b |rac(K1..|Q21;1;0;|
|00002470| 39 38 3b 31 32 36 29 20 | 09 09 7b 20 43 72 65 61 |98;126) |..{ Crea|
|00002480| 74 65 20 61 20 63 68 61 | 72 74 20 73 70 65 63 69 |te a cha|rt speci|
|00002490| 66 79 69 6e 67 20 74 68 | 65 20 6c 6f 63 61 74 69 |fying th|e locati|
|000024a0| 6f 6e 2e 2e 2e 7d 0d 09 | 09 55 73 69 6e 67 20 52 |on...}..|.Using R|
|000024b0| 41 4e 47 45 28 4d 41 4b | 45 52 41 4e 47 45 28 37 |ANGE(MAK|ERANGE(7|
|000024c0| 3b 32 3b 39 3b 6c 61 73 | 74 5f 72 6f 77 29 29 09 |;2;9;las|t_row)).|
|000024d0| 09 7b 20 2e 2e 2e 61 6e | 64 20 74 68 65 20 64 61 |.{ ...an|d the da|
|000024e0| 74 61 20 72 61 6e 67 65 | 20 7d 0d 09 53 45 4c 45 |ta range| }..SELE|
|000024f0| 43 54 20 4f 42 4a 45 43 | 54 20 31 09 09 09 09 09 |CT OBJEC|T 1.....|
|00002500| 09 09 7b 20 53 65 6c 65 | 63 74 20 74 68 65 20 63 |..{ Sele|ct the c|
|00002510| 68 61 72 74 20 7d 0d 09 | 4c 49 4e 45 09 09 09 09 |hart }..|LINE....|
|00002520| 09 09 09 09 09 09 7b 20 | 4d 61 6b 65 20 74 68 65 |......{ |Make the|
|00002530| 20 63 68 61 72 74 20 61 | 20 6c 69 6e 65 20 67 72 | chart a| line gr|
|00002540| 61 70 68 20 7d 0d 09 56 | 45 52 54 49 43 41 4c 20 |aph }..V|ERTICAL |
|00002550| 43 48 41 52 54 20 50 41 | 52 53 49 4e 47 09 09 09 |CHART PA|RSING...|
|00002560| 09 09 09 7b 20 53 70 65 | 63 69 66 79 20 76 65 72 |...{ Spe|cify ver|
|00002570| 74 69 63 61 6c 20 70 61 | 72 73 69 6e 67 20 7d 0d |tical pa|rsing }.|
|00002580| 09 53 45 4c 45 43 54 20 | 43 48 41 52 54 20 31 20 |.SELECT |CHART 1 |
|00002590| 53 45 52 49 45 53 20 31 | 09 09 09 09 09 09 7b 20 |SERIES 1|......{ |
|000025a0| 53 65 6c 65 63 74 20 74 | 68 65 20 70 6c 61 6e 20 |Select t|he plan |
|000025b0| 6c 69 6e 65 20 69 6e 20 | 6c 65 67 65 6e 64 20 7d |line in |legend }|
|000025c0| 0d 09 4c 49 4e 45 20 46 | 47 20 31 31 31 34 31 31 |..LINE F|G 111411|
|000025d0| 32 30 09 09 09 09 09 09 | 09 7b 20 53 65 74 20 74 |20......|.{ Set t|
|000025e0| 68 65 20 6c 69 6e 65 20 | 63 6f 6c 6f 72 20 7d 0d |he line |color }.|
|000025f0| 09 4c 49 4e 45 20 50 41 | 54 54 45 52 4e 20 35 09 |.LINE PA|TTERN 5.|
|00002600| 09 09 09 09 09 09 09 7b | 20 53 65 74 20 74 68 65 |.......{| Set the|
|00002610| 20 6c 69 6e 65 20 70 61 | 74 74 65 72 6e 20 7d 0d | line pa|ttern }.|
|00002620| 09 53 45 4c 45 43 54 20 | 43 48 41 52 54 20 31 20 |.SELECT |CHART 1 |
|00002630| 41 58 49 53 20 31 09 09 | 09 09 09 09 7b 20 53 65 |AXIS 1..|....{ Se|
|00002640| 6c 65 63 74 20 74 68 65 | 20 78 2d 61 78 69 73 20 |lect the| x-axis |
|00002650| 7d 0d 09 49 46 20 6c 61 | 73 74 5f 72 6f 77 20 3e |}..IF la|st_row >|
|00002660| 20 32 30 09 09 09 09 09 | 09 09 7b 20 49 66 20 74 | 20.....|..{ If t|
|00002670| 68 65 72 65 20 61 72 65 | 20 74 6f 6f 20 6d 61 6e |here are| too man|
|00002680| 79 20 68 61 73 68 20 6d | 61 72 6b 73 20 6f 6e 20 |y hash m|arks on |
|00002690| 74 68 65 2e 2e 2e 7d 0d | 09 09 48 49 44 45 20 41 |the...}.|..HIDE A|
|000026a0| 58 49 53 20 48 41 53 48 | 09 09 09 09 09 09 09 7b |XIS HASH|.......{|
|000026b0| 20 2e 2e 2e 58 2d 61 78 | 69 73 2c 20 68 69 64 65 | ...X-ax|is, hide|
|000026c0| 20 74 68 65 6d 20 64 75 | 65 20 74 6f 20 63 72 6f | them du|e to cro|
|000026d0| 77 64 69 6e 67 20 7d 0d | 09 45 4e 44 20 49 46 0d |wding }.|.END IF.|
|000026e0| 09 41 58 49 53 20 4d 41 | 4a 4f 52 20 47 52 49 44 |.AXIS MA|JOR GRID|
|000026f0| 20 46 47 20 30 09 09 09 | 09 09 09 7b 20 44 65 66 | FG 0...|...{ Def|
|00002700| 69 6e 65 20 4d 61 6a 6f | 72 20 47 72 69 64 20 66 |ine Majo|r Grid f|
|00002710| 6f 72 65 67 72 6f 75 6e | 64 20 63 6f 6c 6f 72 20 |oregroun|d color |
|00002720| 7d 0d 09 41 58 49 53 20 | 4d 41 4a 4f 52 20 47 52 |}..AXIS |MAJOR GR|
|00002730| 49 44 20 42 47 20 31 36 | 37 37 37 32 31 35 09 09 |ID BG 16|777215..|
|00002740| 09 09 09 7b 20 44 65 66 | 69 6e 65 20 4d 61 6a 6f |...{ Def|ine Majo|
|00002750| 72 20 47 72 69 64 20 62 | 61 63 6b 67 72 6f 75 6e |r Grid b|ackgroun|
|00002760| 64 20 63 6f 6c 6f 72 20 | 7d 0d 09 41 58 49 53 20 |d color |}..AXIS |
|00002770| 4d 41 4a 4f 52 20 47 52 | 49 44 20 50 41 54 54 45 |MAJOR GR|ID PATTE|
|00002780| 52 4e 20 30 09 09 09 09 | 09 7b 20 44 65 66 69 6e |RN 0....|.{ Defin|
|00002790| 65 20 4d 61 6a 6f 72 20 | 47 72 69 64 20 70 61 74 |e Major |Grid pat|
|000027a0| 74 65 72 6e 20 7d 0d 09 | 41 58 49 53 20 4d 41 4a |tern }..|AXIS MAJ|
|000027b0| 4f 52 20 47 52 49 44 20 | 57 49 44 54 48 20 35 09 |OR GRID |WIDTH 5.|
|000027c0| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 4d 61 |.....{ D|efine Ma|
|000027d0| 6a 6f 72 20 47 72 69 64 | 20 77 69 64 74 68 20 7d |jor Grid| width }|
|000027e0| 0d 09 41 58 49 53 20 4d | 49 4e 4f 52 20 47 52 49 |..AXIS M|INOR GRI|
|000027f0| 44 20 46 47 20 31 32 33 | 30 33 32 39 31 09 09 09 |D FG 123|03291...|
|00002800| 09 09 7b 20 44 65 66 69 | 6e 65 20 4d 69 6e 6f 72 |..{ Defi|ne Minor|
|00002810| 20 47 72 69 64 20 66 6f | 72 65 67 72 6f 75 6e 64 | Grid fo|reground|
|00002820| 20 63 6f 6c 6f 72 20 7d | 0d 09 41 58 49 53 20 4d | color }|..AXIS M|
|00002830| 49 4e 4f 52 20 47 52 49 | 44 20 42 47 20 31 36 37 |INOR GRI|D BG 167|
|00002840| 37 37 32 31 35 09 09 09 | 09 09 7b 20 44 65 66 69 |77215...|..{ Defi|
|00002850| 6e 65 20 4d 69 6e 6f 72 | 20 47 72 69 64 20 62 61 |ne Minor| Grid ba|
|00002860| 63 6b 67 72 6f 75 6e 64 | 20 63 6f 6c 6f 72 20 7d |ckground| color }|
|00002870| 0d 09 41 58 49 53 20 4d | 49 4e 4f 52 20 47 52 49 |..AXIS M|INOR GRI|
|00002880| 44 20 50 41 54 54 45 52 | 4e 20 30 09 09 09 09 09 |D PATTER|N 0.....|
|00002890| 7b 20 44 65 66 69 6e 65 | 20 4d 69 6e 6f 72 20 47 |{ Define| Minor G|
|000028a0| 72 69 64 20 70 61 74 74 | 65 72 6e 20 7d 0d 09 41 |rid patt|ern }..A|
|000028b0| 58 49 53 20 4d 49 4e 4f | 52 20 47 52 49 44 20 57 |XIS MINO|R GRID W|
|000028c0| 49 44 54 48 20 30 09 09 | 09 09 09 09 7b 20 44 65 |IDTH 0..|....{ De|
|000028d0| 66 69 6e 65 20 4d 69 6e | 6f 72 20 47 72 69 64 20 |fine Min|or Grid |
|000028e0| 77 69 64 74 68 20 7d 0d | 09 53 45 4c 45 43 54 20 |width }.|.SELECT |
|000028f0| 43 48 41 52 54 20 31 20 | 41 58 49 53 20 33 09 09 |CHART 1 |AXIS 3..|
|00002900| 09 09 09 09 7b 20 53 65 | 6c 65 63 74 20 74 68 65 |....{ Se|lect the|
|00002910| 20 79 2d 61 78 69 73 20 | 7d 0d 09 41 58 49 53 20 | y-axis |}..AXIS |
|00002920| 4d 41 4a 4f 52 20 47 52 | 49 44 20 46 47 20 30 09 |MAJOR GR|ID FG 0.|
|00002930| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 4d 61 |.....{ D|efine Ma|
|00002940| 6a 6f 72 20 47 72 69 64 | 20 66 6f 72 65 67 72 6f |jor Grid| foregro|
|00002950| 75 6e 64 20 63 6f 6c 6f | 72 20 7d 0d 09 41 58 49 |und colo|r }..AXI|
|00002960| 53 20 4d 41 4a 4f 52 20 | 47 52 49 44 20 42 47 20 |S MAJOR |GRID BG |
|00002970| 31 36 37 37 37 32 31 35 | 09 09 09 09 09 7b 20 44 |16777215|.....{ D|
|00002980| 65 66 69 6e 65 20 4d 61 | 6a 6f 72 20 47 72 69 64 |efine Ma|jor Grid|
|00002990| 20 62 61 63 6b 67 72 6f | 75 6e 64 20 63 6f 6c 6f | backgro|und colo|
|000029a0| 72 20 7d 0d 09 41 58 49 | 53 20 4d 41 4a 4f 52 20 |r }..AXI|S MAJOR |
|000029b0| 47 52 49 44 20 50 41 54 | 54 45 52 4e 20 31 09 09 |GRID PAT|TERN 1..|
|000029c0| 09 09 09 7b 20 44 65 66 | 69 6e 65 20 4d 61 6a 6f |...{ Def|ine Majo|
|000029d0| 72 20 47 72 69 64 20 70 | 61 74 74 65 72 6e 20 7d |r Grid p|attern }|
|000029e0| 0d 09 41 58 49 53 20 4d | 41 4a 4f 52 20 47 52 49 |..AXIS M|AJOR GRI|
|000029f0| 44 20 57 49 44 54 48 20 | 35 09 09 09 09 09 09 7b |D WIDTH |5......{|
|00002a00| 20 44 65 66 69 6e 65 20 | 4d 61 6a 6f 72 20 47 72 | Define |Major Gr|
|00002a10| 69 64 20 77 69 64 74 68 | 20 7d 0d 09 41 58 49 53 |id width| }..AXIS|
|00002a20| 20 4d 49 4e 4f 52 20 47 | 52 49 44 20 46 47 20 30 | MINOR G|RID FG 0|
|00002a30| 09 09 09 09 09 09 7b 20 | 44 65 66 69 6e 65 20 4d |......{ |Define M|
|00002a40| 69 6e 6f 72 20 47 72 69 | 64 20 66 6f 72 65 67 72 |inor Gri|d foregr|
|00002a50| 6f 75 6e 64 20 63 6f 6c | 6f 72 20 7d 0d 09 41 58 |ound col|or }..AX|
|00002a60| 49 53 20 4d 49 4e 4f 52 | 20 47 52 49 44 20 42 47 |IS MINOR| GRID BG|
|00002a70| 20 31 36 37 37 37 32 31 | 35 09 09 09 09 09 7b 20 | 1677721|5.....{ |
|00002a80| 44 65 66 69 6e 65 20 4d | 69 6e 6f 72 20 47 72 69 |Define M|inor Gri|
|00002a90| 64 20 62 61 63 6b 67 72 | 6f 75 6e 64 20 63 6f 6c |d backgr|ound col|
|00002aa0| 6f 72 20 7d 0d 09 41 58 | 49 53 20 4d 49 4e 4f 52 |or }..AX|IS MINOR|
|00002ab0| 20 47 52 49 44 20 50 41 | 54 54 45 52 4e 20 31 09 | GRID PA|TTERN 1.|
|00002ac0| 09 09 09 09 7b 20 44 65 | 66 69 6e 65 20 4d 69 6e |....{ De|fine Min|
|00002ad0| 6f 72 20 47 72 69 64 20 | 70 61 74 74 65 72 6e 20 |or Grid |pattern |
|00002ae0| 7d 0d 09 41 58 49 53 20 | 4d 49 4e 4f 52 20 47 52 |}..AXIS |MINOR GR|
|00002af0| 49 44 20 57 49 44 54 48 | 20 30 09 09 09 09 09 09 |ID WIDTH| 0......|
|00002b00| 7b 20 44 65 66 69 6e 65 | 20 4d 69 6e 6f 72 20 47 |{ Define| Minor G|
|00002b10| 72 69 64 20 77 69 64 74 | 68 20 7d 0d 09 53 45 4c |rid widt|h }..SEL|
|00002b20| 45 43 54 20 4f 42 4a 45 | 43 54 20 31 09 09 09 09 |ECT OBJE|CT 1....|
|00002b30| 09 09 09 7b 20 53 65 6c | 65 63 74 20 74 68 65 20 |...{ Sel|ect the |
|00002b40| 63 68 61 72 74 20 7d 0d | 09 53 45 4c 45 43 54 20 |chart }.|.SELECT |
|00002b50| 4d 4f 52 45 20 52 41 4e | 47 45 20 47 31 09 09 09 |MORE RAN|GE G1...|
|00002b60| 09 09 09 7b 20 53 65 6c | 65 63 74 20 74 68 65 20 |...{ Sel|ect the |
|00002b70| 63 68 61 72 74 20 74 69 | 74 6c 65 20 63 65 6c 6c |chart ti|tle cell|
|00002b80| 20 7d 0d 09 54 49 54 4c | 45 20 52 41 4e 47 45 09 | }..TITL|E RANGE.|
|00002b90| 09 09 09 09 09 09 09 7b | 20 44 65 73 69 67 6e 61 |.......{| Designa|
|00002ba0| 74 65 20 74 68 65 20 74 | 69 74 6c 65 20 7d 0d 09 |te the t|itle }..|
|00002bb0| 54 49 54 4c 45 20 43 45 | 4e 54 45 52 09 09 09 09 |TITLE CE|NTER....|
|00002bc0| 09 09 09 09 7b 20 43 65 | 6e 74 65 72 20 74 68 65 |....{ Ce|nter the|
|00002bd0| 20 74 69 74 6c 65 20 61 | 74 20 74 68 65 20 74 6f | title a|t the to|
|00002be0| 70 20 6f 66 20 74 68 65 | 20 63 68 61 72 74 20 7d |p of the| chart }|
|00002bf0| 0d 09 53 45 4c 45 43 54 | 20 52 41 4e 47 45 20 52 |..SELECT| RANGE R|
|00002c00| 31 09 09 09 09 09 09 09 | 7b 20 53 65 6c 65 63 74 |1.......|{ Select|
|00002c10| 20 63 65 6c 6c 20 74 6f | 20 6d 6f 76 65 20 76 69 | cell to| move vi|
|00002c20| 65 77 20 74 6f 20 63 68 | 61 72 74 20 61 72 65 61 |ew to ch|art area|
|00002c30| 20 7d 0d 09 53 45 4c 45 | 43 54 20 52 41 4e 47 45 | }..SELE|CT RANGE|
|00002c40| 20 4b 31 09 09 09 09 09 | 09 09 7b 20 53 65 6c 65 | K1.....|..{ Sele|
|00002c50| 63 74 20 63 65 6c 6c 20 | 74 6f 20 6d 6f 76 65 20 |ct cell |to move |
|00002c60| 76 69 65 77 20 74 6f 20 | 63 68 61 72 74 20 61 72 |view to |chart ar|
|00002c70| 65 61 20 7d 0d 09 55 4e | 53 45 4c 45 43 54 09 09 |ea }..UN|SELECT..|
|00002c80| 09 09 09 09 09 09 09 7b | 20 55 6e 73 65 6c 65 63 |.......{| Unselec|
|00002c90| 74 20 61 6e 79 20 73 65 | 6c 65 63 74 65 64 20 63 |t any se|lected c|
|00002ca0| 65 6c 6c 73 20 6f 72 20 | 69 74 65 6d 73 20 7d 0d |ells or |items }.|
|00002cb0| 45 4e 44 20 46 55 4e 43 | 54 49 4f 4e 0d 0d 7b 2a |END FUNC|TION..{*|
|00002cc0| 2a 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 20 41 53 4b | 5f 54 4f 5f 43 4f 50 59 |**** ASK|_TO_COPY|
|00002cf0| 20 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 0d 20 20 54 | 68 69 73 20 66 75 6e 63 |****.  T|his func|
|00002d30| 74 69 6f 6e 20 64 69 73 | 70 6c 61 79 73 20 61 20 |tion dis|plays a |
|00002d40| 6d 6f 64 61 6c 20 64 69 | 61 6c 6f 67 20 62 6f 78 |modal di|alog box|
|00002d50| 20 77 68 69 63 68 20 61 | 73 6b 73 20 69 66 20 79 | which a|sks if y|
|00002d60| 6f 75 20 77 61 6e 74 20 | 74 6f 20 63 6c 6f 73 65 |ou want |to close|
|00002d70| 20 74 68 65 20 66 69 6c | 65 2e 20 20 49 66 20 79 | the fil|e.  If y|
|00002d80| 6f 75 20 63 68 6f 6f 73 | 65 0d 20 20 22 59 65 73 |ou choos|e.  "Yes|
|00002d90| 22 2c 20 74 68 65 20 63 | 68 61 72 74 20 69 73 20 |", the c|hart is |
|00002da0| 63 6f 70 69 65 64 20 74 | 6f 20 74 68 65 20 63 6c |copied t|o the cl|
|00002db0| 69 70 62 6f 61 72 64 20 | 61 6e 64 20 74 68 65 20 |ipboard |and the |
|00002dc0| 66 69 6c 65 20 69 73 20 | 63 6c 6f 73 65 64 2e 20 |file is |closed. |
|00002dd0| 20 49 66 20 79 6f 75 20 | 63 68 6f 6f 73 65 20 22 | If you |choose "|
|00002de0| 4e 6f 22 2c 20 74 68 65 | 20 64 69 61 6c 6f 67 0d |No", the| dialog.|
|00002df0| 20 20 64 69 73 61 70 70 | 65 61 72 73 20 61 6e 64 |  disapp|ears and|
|00002e00| 20 74 68 65 20 73 63 72 | 69 70 74 20 74 65 72 6d | the scr|ipt term|
|00002e10| 69 6e 61 74 65 73 20 77 | 69 74 68 20 74 68 65 20 |inates w|ith the |
|00002e20| 66 69 6c 65 20 6f 70 65 | 6e 2e 0d 20 2a 2a 2a 2a |file ope|n.. ****|
|00002e30| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e40| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e50| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e60| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e70| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e80| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00002e90| 7d 0d 0d 46 55 4e 43 54 | 49 4f 4e 20 41 53 4b 5f |}..FUNCT|ION ASK_|
|00002ea0| 54 4f 5f 43 4f 50 59 28 | 29 0d 09 4e 45 57 20 4d |TO_COPY(|)..NEW M|
|00002eb0| 4f 44 41 4c 20 44 49 41 | 4c 4f 47 20 42 4f 58 20 |ODAL DIA|LOG BOX |
|00002ec0| 41 54 20 28 2d 31 3b 2d | 31 29 28 34 2e 35 20 49 |AT (-1;-|1)(4.5 I|
|00002ed0| 4e 43 48 3b 31 2e 35 20 | 49 4e 43 48 29 7b 20 43 |NCH;1.5 |INCH){ C|
|00002ee0| 72 65 61 74 65 20 61 20 | 63 65 6e 74 65 72 65 64 |reate a |centered|
|00002ef0| 20 6d 6f 64 61 6c 20 64 | 69 61 6c 6f 67 20 62 6f | modal d|ialog bo|
|00002f00| 78 20 7d 0d 09 41 44 44 | 20 54 45 58 54 20 22 43 |x }..ADD| TEXT "C|
|00002f10| 6f 70 79 20 63 68 61 72 | 74 20 74 6f 20 43 6c 69 |opy char|t to Cli|
|00002f20| 70 62 6f 61 72 64 20 61 | 6e 64 20 63 6c 6f 73 65 |pboard a|nd close|
|00002f30| 20 77 6f 72 6b 73 68 65 | 65 74 20 77 69 74 68 6f | workshe|et witho|
|00002f40| 75 74 20 73 61 76 69 6e | 67 3f 22 20 0d 09 09 41 |ut savin|g?" ...A|
|00002f50| 54 20 28 2e 31 32 35 20 | 49 4e 43 48 3b 20 2e 31 |T (.125 |INCH; .1|
|00002f60| 32 35 20 49 4e 43 48 29 | 20 2b 20 28 34 2e 32 35 |25 INCH)| + (4.25|
|00002f70| 20 49 4e 43 48 3b 20 2e | 35 20 49 4e 43 48 29 09 | INCH; .|5 INCH).|
|00002f80| 7b 20 50 6c 61 63 65 20 | 74 65 78 74 20 69 6e 74 |{ Place |text int|
|00002f90| 6f 20 64 69 61 6c 6f 67 | 20 62 6f 78 20 7d 0d 09 |o dialog| box }..|
|00002fa0| 4e 4f 20 4c 49 4e 45 20 | 42 4f 52 44 45 52 09 09 |NO LINE |BORDER..|
|00002fb0| 09 09 09 09 09 09 7b 20 | 54 75 72 6e 20 6f 66 66 |......{ |Turn off|
|00002fc0| 20 6c 69 6e 65 20 62 6f | 72 64 65 72 20 66 6f 72 | line bo|rder for|
|00002fd0| 20 74 65 78 74 20 6f 62 | 6a 65 63 74 20 7d 0d 09 | text ob|ject }..|
|00002fe0| 41 44 44 20 50 55 53 48 | 20 42 55 54 54 4f 4e 20 |ADD PUSH| BUTTON |
|00002ff0| 22 20 20 20 20 4e 6f 20 | 20 20 20 22 3b 20 22 20 |"    No |   "; " |
|00003000| 20 20 20 59 65 73 20 20 | 20 20 22 20 41 54 20 09 |   Yes  |  " AT .|
|00003010| 7b 20 41 64 64 20 4e 6f | 20 61 6e 64 20 59 65 73 |{ Add No| and Yes|
|00003020| 20 62 75 74 74 6f 6e 73 | 20 7d 0d 09 09 28 33 2e | buttons| }...(3.|
|00003030| 32 35 20 49 4e 43 48 3b | 20 2e 36 32 35 20 49 4e |25 INCH;| .625 IN|
|00003040| 43 48 29 20 2b 20 28 31 | 20 49 4e 43 48 3b 20 2e |CH) + (1| INCH; .|
|00003050| 37 35 20 49 4e 43 48 29 | 0d 09 53 45 4c 45 43 54 |75 INCH)|..SELECT|
|00003060| 20 43 4f 4e 54 52 4f 4c | 20 32 09 09 09 09 09 09 | CONTROL| 2......|
|00003070| 09 7b 20 53 65 6c 65 63 | 74 20 4e 6f 20 62 75 74 |.{ Selec|t No but|
|00003080| 74 6f 6e 20 7d 0d 09 44 | 49 41 4c 4f 47 20 43 41 |ton }..D|IALOG CA|
|00003090| 4e 43 45 4c 20 50 55 53 | 48 20 42 55 54 54 4f 4e |NCEL PUS|H BUTTON|
|000030a0| 09 09 09 09 09 7b 20 44 | 65 66 69 6e 65 20 62 75 |.....{ D|efine bu|
|000030b0| 74 74 6f 6e 20 61 73 20 | 61 20 63 61 6e 63 65 6c |tton as |a cancel|
|000030c0| 20 62 75 74 74 6f 6e 20 | 7d 0d 09 53 43 52 49 50 | button |}..SCRIP|
|000030d0| 54 20 22 27 43 61 73 68 | 20 46 6c 6f 77 20 73 63 |T "'Cash| Flow sc|
|000030e0| 72 69 70 74 3a 64 6f 6e | 65 27 20 3d 20 30 22 09 |ript:don|e' = 0".|
|000030f0| 09 09 7b 20 49 66 20 70 | 72 65 73 73 65 64 2c 20 |..{ If p|ressed, |
|00003100| 64 6f 6e 65 20 3d 20 30 | 20 7d 0d 09 53 45 4c 45 |done = 0| }..SELE|
|00003110| 43 54 20 43 4f 4e 54 52 | 4f 4c 20 33 09 09 09 09 |CT CONTR|OL 3....|
|00003120| 09 09 09 7b 20 53 65 6c | 65 63 74 20 59 65 73 20 |...{ Sel|ect Yes |
|00003130| 62 75 74 74 6f 6e 20 7d | 0d 09 44 49 41 4c 4f 47 |button }|..DIALOG|
|00003140| 20 44 45 46 41 55 4c 54 | 20 50 55 53 48 20 42 55 | DEFAULT| PUSH BU|
|00003150| 54 54 4f 4e 09 09 09 09 | 09 7b 20 44 65 66 69 6e |TTON....|.{ Defin|
|00003160| 65 20 62 75 74 74 6f 6e | 20 61 73 20 74 68 65 20 |e button| as the |
|00003170| 64 65 66 61 75 6c 74 20 | 62 75 74 74 6f 6e 20 7d |default |button }|
|00003180| 0d 09 53 43 52 49 50 54 | 20 22 27 43 61 73 68 20 |..SCRIPT| "'Cash |
|00003190| 46 6c 6f 77 20 73 63 72 | 69 70 74 3a 64 6f 6e 65 |Flow scr|ipt:done|
|000031a0| 27 20 3d 20 31 22 09 09 | 09 7b 20 49 66 20 70 72 |' = 1"..|.{ If pr|
|000031b0| 65 73 73 65 64 2c 20 64 | 6f 6e 65 20 3d 20 31 20 |essed, d|one = 1 |
|000031c0| 7d 0d 09 55 53 45 20 44 | 49 41 4c 4f 47 20 42 4f |}..USE D|IALOG BO|
|000031d0| 58 09 09 09 09 09 09 09 | 09 7b 20 44 69 73 70 6c |X.......|.{ Displ|
|000031e0| 61 79 20 64 69 61 6c 6f | 67 20 6f 6e 2d 73 63 72 |ay dialo|g on-scr|
|000031f0| 65 65 6e 20 7d 0d 09 49 | 46 20 64 6f 6e 65 20 3d |een }..I|F done =|
|00003200| 20 31 09 09 09 09 09 09 | 09 09 7b 20 49 66 20 64 | 1......|..{ If d|
|00003210| 6f 6e 65 20 3d 20 31 20 | 28 59 65 73 20 77 61 73 |one = 1 |(Yes was|
|00003220| 20 70 72 65 73 73 65 64 | 29 20 7d 0d 09 09 53 45 | pressed|) }...SE|
|00003230| 4c 45 43 54 20 43 48 41 | 52 54 20 31 09 09 09 09 |LECT CHA|RT 1....|
|00003240| 09 09 09 7b 20 53 65 6c | 65 63 74 20 63 68 61 72 |...{ Sel|ect char|
|00003250| 74 20 7d 0d 09 09 43 4f | 50 59 09 09 09 09 09 09 |t }...CO|PY......|
|00003260| 09 09 09 7b 20 43 6f 70 | 79 20 74 6f 20 74 68 65 |...{ Cop|y to the|
|00003270| 20 63 6c 69 70 62 6f 61 | 72 64 20 7d 0d 09 09 43 | clipboa|rd }...C|
|00003280| 4c 4f 53 45 20 4e 4f 57 | 09 09 09 09 09 09 09 09 |LOSE NOW|........|
|00003290| 7b 20 43 6c 6f 73 65 20 | 73 68 65 65 74 20 77 69 |{ Close |sheet wi|
|000032a0| 74 68 6f 75 74 20 73 61 | 76 69 6e 67 20 7d 0d 09 |thout sa|ving }..|
|000032b0| 45 4e 44 20 49 46 09 09 | 09 09 09 09 09 09 09 7b |END IF..|.......{|
|000032c0| 20 45 6e 64 20 6c 6f 67 | 69 63 61 6c 20 49 46 20 | End log|ical IF |
|000032d0| 7d 0d 45 4e 44 20 46 55 | 4e 43 54 49 4f 4e 0d 0d |}.END FU|NCTION..|
|000032e0| 7b 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 20 45 | 4e 44 20 53 43 52 49 50 |****** E|ND SCRIP|
|00003310| 54 20 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |T ******|********|
|00003320| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003330| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |********|********|
|00003340| 2a 2a 2a 2a 2a 7d 0d 00 | 00 00 00 00 00 00 00 00 |*****}..|........|
|00003350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003380| 00 00 01 00 00 00 01 83 | 00 00 00 83 00 00 00 3c |........|.......<|
|00003390| 73 07 00 00 cd 06 00 00 | cd 06 00 00 cd 06 00 00 |s.......|........|
|000033a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033b0| 10 43 61 73 68 20 46 6c | 6f 77 20 53 63 72 69 70 |.Cash Fl|ow Scrip|
|000033c0| 74 73 02 00 00 00 52 73 | 53 63 52 73 6c 76 01 00 |ts....Rs|ScRslv..|
|000033d0| 00 00 52 73 53 63 52 73 | 6c 76 01 00 00 d0 00 80 |..RsScRs|lv......|
|000033e0| 00 00 00 84 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033f0| 00 00 a4 58 08 a0 00 00 | 32 c8 00 00 01 bf 00 00 |...X....|2.......|
|00003400| 01 f9 f8 1a 00 00 18 00 | 00 00 00 00 00 08 40 3a |........|......@:|
|00003410| f2 1c 00 1b 00 00 02 f9 | f8 1b 00 00 03 f9 f8 fd |........|........|
|00003420| 04 1b 00 01 1b 00 00 04 | f9 f8 1d 40 00 fd 39 23 |........|...@..9#|
|00003430| 00 35 54 68 65 72 65 20 | 69 73 20 6e 6f 74 20 65 |.5There |is not e|
|00003440| 6e 6f 75 67 68 20 43 61 | 73 68 20 46 6c 6f 77 20 |nough Ca|sh Flow |
|00003450| 64 61 74 61 20 74 6f 20 | 63 72 65 61 74 65 20 61 |data to |create a|
|00003460| 20 67 72 61 70 68 2e fd | 03 01 01 fc f6 00 00 fd | graph..|........|
|00003470| 06 00 00 00 00 00 fd 0e | 08 01 01 01 01 07 07 00 |........|........|
|00003480| 00 00 00 7f 85 87 2b d1 | 3f e5 32 30 00 04 00 00 |......+.|?.20....|
|00003490| 00 00 00 00 00 00 a4 58 | 0b 60 a4 58 0b 60 a1 20 |.......X|.`.X.`. |
|000034a0| 06 7d 00 00 91 e8 00 00 | 00 4c 00 06 06 4f 61 73 |.}......|.L...Oas|
|000034b0| 69 73 ba 00 0a 53 75 65 | 20 57 61 72 6e 65 72 00 |is...Sue| Warner.|
|000034c0| 01 36 00 10 43 61 73 68 | 20 46 6c 6f 77 20 53 63 |.6..Cash| Flow Sc|
|000034d0| 72 69 70 74 00 0f 43 68 | 61 6e 67 65 73 20 66 6f |ript..Ch|anges fo|
|000034e0| 72 20 78 31 31 00 00 1a | 43 68 65 63 6b 20 69 6e |r x11...|Check in|
|000034f0| 20 66 6f 72 20 67 6f 6c | 64 65 6e 20 73 75 62 6d | for gol|den subm|
|00003500| 69 74 00 00 00 01 00 00 | 00 01 83 00 00 00 83 00 |it......|........|
|00003510| 00 00 3c 00 04 6e 84 01 | 7a 00 00 00 1c 00 32 00 |..<..n..|z.....2.|
|00003520| 00 63 6b 69 64 00 00 00 | 0a 00 80 00 00 00 00 00 |.ckid...|........|
|00003530| 00 00 00 00 00 09 50 72 | 6f 6a 65 63 74 6f 72 00 |......Pr|ojector.|
|00003540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+