home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Mega Top 1
/
os2_top1.zip
/
os2_top1
/
DOS_GG
/
COMCAT
/
VOL34.ARJ
/
VOL3421
< prev
next >
Wrap
Text File
|
1992-01-07
|
4KB
|
78 lines
Volume 3421 - Released october 1987 - Abstract (C) ProgrammaTheek
ProgrammaTheek volume 3421
gelijk aan N.Y. LUG 305
Titel: MACLIB - Library of 1-2-3 templates
Number Name Size Date Comments
421.01 ADC WKS 7936 11-28-85 ACRS Depreciation Calc.
421.02 ARC WKS 8960 11-28-85 Acc. Rec. Tracker
421.03 AUTO123 WKS 3072 11-25-85 Autostart model for MACLIB
CATALOG 421 1705 12-27-86 This list
421.04 CBB WKS 13184 11-28-85 Check Book Balancer
421.05 CDB WKS 20864 11-28-85 Cash Disbursements
421.06 CFM WKS 8320 11-28-85 Cash Flow Manager
421.07 CFP WKS 20736 11-28-85 Cash Flow Projection
421.08 EIO WKS 3840 11-28-85 EOQ Inventory Ordering
421.09 FFS WKS 10880 11-28-85 5-in-1 Financial Statement
421.10 GCC WKS 5888 11-28-85 Growth Capacity Calc.
421.11 IIB WKS 11520 11-28-85 Interactive Inc-Statement
421.12 IRR WKS 6784 11-28-85 Internal Rate-of-Return
421.13 LCT WKS 9216 11-28-85 Line-of-Credit Tracker
421.14 LNA WKS 12160 11-28-85 Loan Amortization
421.15 LNP WKS 3072 11-28-85 Loan Payoff Calculator
421.16 LOTUSLIB DOC 4736 11-14-86 General info N.Y. LUG Library
421.17 MACLIB WKS 12800 6-16-84 Main macro library
421.18 MACRO_1 WKS 6144 11-28-85 Main description MACLIB
421.19 NVB WKS 10496 11-28-85 New Venture Budget
421.20 OLDBULL WKS 10112 11-28-85 Shareware (& download) rules
421.21 PVA WKS 3840 6-20-84 Price Volume Analysis
421.22 QA1 WKS 3200 11-28-85 Queue Analysis (single)
421.23 QAM WKS 5888 6-20-84 Queue Analysis (multi)
421.24 QGN WKS 20480 11-28-85 Quote Generator
421.25 RAR WKS 7424 11-28-85 Ratio Analyzer
421.26 STC WKS 9728 11-28-85 Statistics Calculator
421.27 VOL3421 ABS 2048 12-27-86 Disk abstract
28 File(s) 67584 bytes free on volume VOL3421
**--Basic MACLIB Design--**
The MACLIB Worksheet file is the holder or integrator for the entire set of
worksheets on this volume. This file has been specially designed to work with
these worksheets.
The MACLIB Worksheet, once it is cleansed of the copyright notice in
the upper left, neatly fits around any of the other worksheets on the
system. The individual worksheets have all been designed to fit into
the range A1..Z220. There is nothing magical about row 220 being the
last one, it was just the size of the largets worksheet.
The actual macros are located consistently in the range AA1..AA2048.
This is done, so that an automatic renaming of the macros may be
accomplished with a '/rnlraa1..aa2048' command.
Let's look at the actual macro that is executed when you decide to
use a menu selection, which is accomplished with {alt-m}.
file for your convenience in downloading and capturing a copy.
1. You point the cursor at the worksheet name of your
choice and depress the {enter} key.
2. The macro executed performs a file retrieve of worksheet xxx.
3. The worksheet retrieved, has two macros defined. One is for
saving the range named 'PAGE', and the other is for resetting
all of the range names for the macros in MACLIB.
4. The second macro is executed by {alt-o}.
5. When the \o macro is executed, it positions the cursor
to the {home} position, overlays the worksheet with the
contents of the MACLIB Worksheet, (since they don't conflict,
the model is not disturbed), renames the macros in Col AA,
adjusts two column widths, and finishes by again positioning
the cursor to the {home} position.
The net of all of this is that you may flip from one worksheet to
another very quickly and it provides a framework for future expansion and
integration between worksheets.