home *** CD-ROM | disk | FTP | other *** search
-
- Problem One in a series of cash flow worksheets at various stages of
- completion which are used to teach a beginning 1-2-3 class.
- This is the final model in the cash flow series. It contains
- many features of the first 3 but contains many advanced features
- for students to study on their own time. A complete model for
- managing cash flow on a daily basis. Has built-in macros for
- doing what-if graphics, simplifying printing, and other tasks.
-
- 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) .
-
-
-
-
-