home *** CD-ROM | disk | FTP | other *** search
-
- Problem This is the "CashFlow For 1-2-3" application. It is used on
- disk #72 as the second in a series of cash flow models designed
- to teach students useful macro concepts. Currently set up
- to manage cash flow on a daily basis for one month. Designed to
- be flexible as to the time frame involved and line items. Macro
- library contains graph macros useful for doing what-if cash flow
- planning.
-
- Block Diagram
- __________________________________
- | | Sources
- | | Uses
- | Data Input Section | Debt Pymts
- | | Daily cash flow & Bal.
- |__________________________________|
- | | | |
- | Monthly | | |
- | Recap | Macro | Menu |
- |____________| Library | Screens |
- | | | |
- | Macro | | |
- | Subroutines| | |
- |____________|___________|_________|
-
-
- Tips
- Layout of worksheet maximizes flexibility of Data Input Sect.
- Macro library (L48) a way to organize macros in a worksheet.
- Graph macros (N63) Alt-G - Especially Daily Bal. Line Graph.
- Insert Row macro (N65) Alt-I
- Data Distribution analysis and Alt-D macro for updating(G61&N61)
- Print menu technique (Alt-P) .
-
-
-
-
-