The World of Computer Software

home *** CD-ROM | disk | FTP | other *** search

/ The World of Computer Software / World_Of_Computer_Software-02-387-Vol-3of3.iso / 1 / 123u06.zip / 123UTIL.LST next >

Wrap

File List | 1993-01-12 | 106KB | 1,519 lines

Page No. 1 01/12/93 PD/Shareware Products in Library Release Date Product Description ** Type Auditor/Annotator 10/28/88 Documents a spreadsheet by listing contents of cells in English. No contribution is requested unless an updated version with additional documentation is wanted author then requests $15 to cover expenses. 01/24/86 Uses a 1-2-3 Release 1a file as input & produces an extensive description of the contents of the file. Shows all default values, type & contents of all cells in the active range of the spreadsheet. 05/27/89 TurboPascal 5.0 unit to read all labels, values, and the current values of formulas in a 1-2-3 worksheet file, Releases 1a/2 (& Symphony 1/1.1). New file is also in 1-2-3 format. Source code only, not compiled. 02/25/84 A BASIC routine (requires BasicA or GW-Basic to run) which will print a list of the range names & ranges in a 1-2-3 Release 1/1a spreadsheet. Such a good & necessary idea that Lotus built it into Release 2. 12/07/84 Prints the cell formulas, values, or labels in a spreadsheet in the same arrangement as the original spreadsheet. The print file produced by 1-2-3 using the Cell-Formulas option is arranged in one column. This program rearranges it. 10/08/86 A macro & menu driven Release 1a spreadsheet that can be combined into user's spreadsheet. Allows attaching a note of up to 256 characters to any cell. Notes can be viewed, edited, deleted. Should work in all releases. 10/28/88 Add-in for Release 2.x providing a graphic representation of the contents of the spreadsheet. Lists named ranges, allows highlighting of active cells by type. Minimal documentation, small on-line help facility. ** Type Automotive 04/24/89 Written by an Eastman Kodak employee for use of his fellow employees in keeping track of business & personal use of company cars. Has spreadsheets for Releases 1a & 2/2.01, both normal 25-line display & 43-line EGA. Handles 4 weeks, easily expanded. 05/25/88 Menu-driven spreadsheet for 1-2-3 Release 2.x to track needed automobile preventive maintenance. Labelled "Version 1.00 (Beta Test)." 03/17/86 A small 1-2-3 Release 1a worksheet to analyze the projected 10-year cost of car ownership. Based on gas mileage & price, annual mileage, financing, taxes, maintenance costs, insurance, and depreciation assumptions. 06/24/84 A 1-2-3 Release 1a spreadsheet for keeping track of automobile gas mileage. Some documentation contained in spreadsheet. 01/01/80 A Release 1a spreadsheet to help calculate the price of a new car. Includes provision for a list of options, with a feature to easily see the effect of adding and removing various of them, loan costs, trade-in, taxes. Page No. 2 01/12/93 PD/Shareware Products in Library Release Date Product Description ** Type Billing/Estimating 09/06/86 A 1-2-3 Release 1a template that allows professionals and small service companies to enter detail for individual clients, produce bills, and post accounts. Limited documentation, in the spreadsheet. 07/04/84 A 1-2-3 Release 1a template designed to estimate shooting fees for professional photographers. Automates the ASMP estimate/assignment/confirmation form. 10/01/89 A menu-driven 1-2-3 Release 2.x spreadsheet for allocating employee time to client accounts, & tracking client progress. Macros appear to use only commands available in Release 1a, so spreadsheet should be translatable. ** Type Bookkeeping 05/28/84 Set of 4 journals and general ledger in 1-2-3 Release 1a worksheets tied together by a menu worksheet. An accountant's version of a personal cash management system which could also be used for self-employed individuals, small businesses. 12/30/85 A 1-2-3 Release 1a spreadsheet that provides a general purpose transaction processor for summarizing checks or maintaining simple general ledgers. Registration brings an enlarged & enhanced package. 10/12/86 Two 1-2-3 Release 2 spreadsheets. One ages a list of accounts receivables 30, 60 & 90 days. The other provides projections of expected cash flow from lists of recurring and expected receipts and expenses. 07/29/84 A 1-2-3 Release 1a spreadsheet that the author calls a "cash management system." Can be used as a personal checking ledger, a small-business cash journal, or a component of a small-business accounting system. Provides balances by budget category. 07/29/84 A 1-2-3 Release 1a template that details business travel & other expenses for a one-week period. 04/13/85 Release 1a spreadsheet intended as a simple "personal general ledger." Allows daily entry in a number of accounts, compiling them into month-to-date and year-t0-date totals with macros. Useable in Release 2.x if GLTEMP.WKS is renamed GLTEMP.WK1. 05/19/86 Release 1a spreadsheet to track scheduled and actual hours worked, wages received. Includes a brief documentation file. Rudimentary, but useful for those in the author's situation of a part-time job with irregular hours. 05/03/86 Two Release 1a spreadsheets comprising a simple payroll system for up to 25 employees. Calculates FICA, state unemployment, has table for federal & NJ taxes which require updating. Prints checks. Little documentation, fairly easy to run. 05/30/90 Release 2.01+ spreadsheet calculates employee payroll tax deductions. Includes Federal, NY State & City tax tables. Will also calculate the gross necessary to produce a Page No. 3 01/12/93 PD/Shareware Products in Library Release Date Product Description specified net. 09/08/90 Release 2.x spreadsheet does only one thing. It takes the user's input of a numeric value of dollars & cents up to $9,999,999.99 & converts it into words, as on a check or legal document. 08/15/90 Weekly template for business travel, lodging, & meals & entertainment. Created using Release 2.01, should be compatible with Release 2.2 & 3.x as well. 04/11/86 Macro-driven 1-2-3 template that integrates a simplified short term cash flow management system with a simplified general ledger system. ** Type Business Planning 01/18/88 A 1-2-3 Release 2.01 worksheet with menu-driven instructions for an analysis of whether to buy or lease equipment. 07/29/84 A 1-2-3 Release 1a template that calculates the percent profit per unit sold, based on input of unit sales price, price erosion rate, variable unit cost, variable cost learning rate, total fixed costs. 08/19/89 A Release 1a spreadsheet to project up to 4 years of financial activity for a business, detailing first forecast year monthly, 4 additional quarterly. Determines capital needed for profitability. Author warns of minor incompatibilities with Release 2.x. 06/04/90 A 1-2-3 Release 2.x spreadsheet to determine the proper accounting treatment by lessee for a lease under the rules of Statement of Financial Accounting Standards #13. Also provides amortization schedule to be used for capital lease debt. 10/01/89 Four Release 2.01 worksheets for oil & gas production calculations. They are an oil price forecaster, an open hole log analysis of oil & gas wells, a field analysis of whole core descriptions, & a quick-look determination of value of producing property. 10/05/89 Release 2.01 spreadsheet that provides a simple economic evaluation tool for the drilling of a single oil & gas well. ** Type Calendars 07/27/83 A 1-2-3 Release 1a integrated manager's appointment calendar, with a phone directory. Allows tracking of time and expenses. Documentation file. 03/07/88 A 1-2-3 Release 2.01 spreadsheet to keep track of annual & sick leave for federal employees. Macro-driven. Clear documentation, but doc file probably created with WordStar. LIST.COM * filter makes it readable, printable. 02/03/84 A 1-2-3 Release 1a spreadsheet that provides personal & business calendars, telephone lists, to do lists, and miscellaneous "notepads." 10/31/84 A 1-2-3 Release 1a macro-driven spreadsheet that takes the current date, or prompts the user for month, day & year, and converts it into a string with the day of the Page No. 4 01/12/93 PD/Shareware Products in Library Release Date Product Description week & month spelled out. 01/14/89 A 1-2-3 Release 2.x spreadsheet that shows list of names with birthdates (user must understand @DATE function), & calculates age, days to next birthday, and days since birthdate based on current date. No documentation. 11/07/89 A Release 2.x spreadsheet that provides a daily task list. Can be used for manpower/management survey, commercial activity studies, general management analysis. Includes a Sideways format file for printing with Sideways. 08/18/88 A Release 2.01 spreadsheet that creates and prints a personalized calendar for any month chosen by the user. Automatically inserts the days correctly. Allows user to insert information, copy to additional days by macro. 03/14/88 A Release 2.x spreadsheet with a menu-driven appointment calendar. Displays appointments for any selected day in the current year. Will save birthdays & anniversaries from year to year. 03/01/91 Macro for Release 2.01+ that brings up a calendar displaying the current month. The self-explanatory display allows changing to next or previous month, same month of next or previous year, January of same year, or current month in any year specified. 12/09/90 Release 2.01 spreadsheet to track of annual & sick leave for federal employees. Set up for 1991, for those in leave group 1 (4 hours per pay period), but easily revised. A good sample to start from, but no documentation. 02/06/91 1-2-3 2.01 date macro. Accepts 6 or 8 character dates. 10/21/92 Lotus WK1 spreadsheet to track annual & sick leave for federal employees. Set up for 1993. ** Type Collectors 02/27/88 Worksheets for coin collectors suitable for inventories. Pre-loaded with Indian penny, nickles, Silver Dollars, and Lincoln cent data. ** Type Communications 03/01/91 Macro that will prompt for a phone number, or use number in the current cell, & send dialling string with the number to a modem. For Release 2.2, but should also work in 2.01, 3.x. ** Type Compilers 12/01/89 A collection of sub programs to write a Lotus 1-2-3 file from within a QuickBasic 4.0+ or BASCOM 6.0+ program. Includes most frequently used functions. ** Type Data Entry Utility 10/09/87 Add-in for 1-2-3 Release 2/2.01 that allows editing formulas with range names displayed instead of cell coordinates. Shareware version uses about 8.5K of memory registered version about 6.5K, and loads faster. Page No. 5 01/12/93 PD/Shareware Products in Library Release Date Product Description 08/01/88 Add-in for 1-2-3 Release 2/2.01 that allows switching between normal data entry mode and all-labels mode, allowing entry of numbers, formulas & functions as labels without label prefix. Allows choice of left or right aligned or centered. 09/09/91 Release 2.2 macro that converts a date entered in the format MMDDYY with no delimiters into a valid date serial number. Checks for entry of a valid date. Can be used as part of a Macro Library or be called from within other macros. ** Type Database 08/26/85 A menu-driven Release 1a spreadsheet that automates building a database and searching it. Set up for vendors, but easily modifiable. A good example of building a database using a data entry screen. 07/01/91 Add-in for Release 2.x to provide access to external databases via a network SQL server. Requires DOS 3.1 or higher, network software that supports named pipes, & a LAN running Microsoft SQL Server. ** Type Developers' Tools 01/04/92 A partial decoding of the sample pie-chart file which comes on the Lotus 1-2-3 Printgraph disk. ** Type Display Enhancer 10/26/87 A BASIC program that allows changes in the 1-2-3 driver sets to customize colors for 1-2-3 Releases 1a & 2, Symphony 1.1. No documentation file, but some on-line documentation. 09/22/87 Allows setting of user's choice of colors for 1-2-3 and Symphony. Also enables changing the character display & printer tables to display and print IBM graphics line drawing characters instead of Lotus LICS characters. 05/16/85 Instructions for using DEBUG to create two new screen device drivers for 1-2-3 Release 1a for color display of worksheet files. Includes an input file to make the process automatic. 03/12/89 Add-ins for 1-2-3 Release 2/2.01 & Symphony that allow setting of user's choice of colors. Also allow toggling between displaying (& printing) IBM graphics line drawing characters & Lotus LICS characters. Registration is mandatory for business use. 07/26/88 Paradise VGA drivers & instructions for installation for 1-2-3 Release 2/2.01 & Symphony 1.1/1.2/2.0. Enables 800x600 & 640x480 graphics modes & 132 column text. Although doc file refers to drivers on Paradise VGA disk, they are included here. 07/09/88 Driver sets for 1-2-3 Release 2.01 which allow display of extended ASCII characters (for line drawing and shading) for CGA, EGA, and Hercules/MGA graphics adapters. 08/02/88 An alternate driver for 1-2-3 Release 2.01 to enable display of extended ASCII characters (box drawing and Page No. 6 01/12/93 PD/Shareware Products in Library Release Date Product Description accented letters). Driver itself is of unknown origin, current author has added a DOC file and a worksheet including all of the characters. 03/31/86 A patch for the 123.SET file for Release 2.x to enable display of extended ASCII characters (box drawing and accented letters). Requires DOS DEBUG. 06/20/85 Instructions for using DEBUG to create two new screen device drivers for 1-2-3 Release 1a for color display of worksheet files. Includes an input file to make the process automatic. The two drivers have been created, and are included in this ZIP file. 04/05/90 Contains an executable file that prompts user for information to create a new TD.DRV file for Release 1a, or reconfigure 123.SET for Release 2.x, allowing a choice of colors other than Lotus's defaults. Requires CGA, EGA, or VGA display. 10/01/85 A DEBUG script from the October 1985 issue of PC World to patch the TD.DRV file for Release 1a for use with CGA. Allows a choice of colors for worksheet cells & help screens, border & cursor, unprotected cells, and cursor on unprotected cells. 10/20/85 A batch file that used DEBUG to create two different driver files for alternate colors for Release 1a for use with EGA and a color monitor. 03/27/87 A Release 2.01 spreadsheet with macros that allows use of IBM standard graphics characters. Includes instructions for creating the necessary driver. Intended to interest the user in the company's software to allow all dot matrix printers to print these. 08/29/89 Updated video drivers for 1-2-3 Release 3.0 running under IBM OS/2 1.2. 01/24/91 Display drivers for Release 2.x for the IBM 8514A graphics adapter. 01/31/91 TSR that works with Releases 1a, 2.01, 2.2, & (with restrictions) 3.0 to enlarge part of the 1-2-3 display. Automatically determines that 1-2-3 is in use, & depending on the current display, enlarges appropriate portions. 02/10/87 COM file to aid in the customization of the colors used by Lotus for 1-2-3. A screen is displayed that simulates a typical spreadsheet witht he current default colors along with a menu to let you change border colors and number colors. ** Type File Utility 05/01/88 Allows the user to specify any file in any directory to be loaded when starting 1-2-3 Release 2.x. Still permits use of an AUTO123.WK1 file in the default directory to be loaded automatically, or specify the file of choice. 04/04/86 Two 1-2-3 Release 1a spreadsheets to allow the user to specify which of 6 subdirectories is to be used for the current work session's files, and to quickly return to the top level directory to change subdirectories. Page No. 7 01/12/93 PD/Shareware Products in Library Release Date Product Description 01/29/88 Menu-driven spreadsheet for 1-2-3 Release 2.x which allows the user to attach descriptions to files. When the user later retrieves files, they are listed by the description, rather than by the file name. 09/02/86 Two versions included, for 1-2-3 Release 1a and for 2/2.01. Automatically loads when starting 1-2-3. Allows choice of A or C drives for file retrieval save. Very limited, but a good learning tool for the new user. Easily modified by advanced users. 08/01/88 A 1-2-3 Release 1a menu-driven file that allows entering names and descriptions of spreadsheet files. Displays 27 files & descriptions at a time, which can be retrieved with a few keystrokes. 04/19/90 A menu/macro driven 1-2-3 Release 2.x template for building a catalog of files on floppy disks. Replaces the author's DIRCAT, now needs only DOS, BASICA & 1-2-3. Supports DOS 4+, as well as earlier DOS versions. 06/03/83 A 1-2-3 Release 1a front-end menu that elicits information about the author of a spreadsheet, its dates of creation & modification, & the name of a backup file, prior to running the spreadsheet. 03/17/86 Includes two spreadsheets for Release 2 which will speed up retrieval of very large spreadsheets by suppressing all screen changes during the process. This is less of a problem in Release 2.01+. 10/05/89 Release 2.x, macro-driven spreadsheet allows "point-and-shoot" selection of drive & subdirectory to be used as default for work session. Easily modified by user to include as many drives and subdirectories as needed. 10/12/91 Menu-driven spreadsheet for Release 2.2/2.3/3.0/3.1 & 1-2-3/W 1.0. Displays directories & lists of spreadsheets, provides single key retrieval, deletion & viewing of files. ** Type Finance Templates 07/21/87 A spreadsheet for 1-2-3 Release 2.x to calculate average periodic growth rate. Archive includes advertisement for Softsmith Enterprizes programs. 12/12/85 1-2-3 Release 1a template for what-if scenarios for a portfolio of up to four stocks. Whimsically dubbed "UNDERWARE (tm)" by its author who suggests spreading it far and wide. 09/07/84 A macro-driven 1-2-3 Release 1a spreadsheet for listing US EE Savings Bonds with their purchase dates & serial numbers. Through entering of the market rates, the user is provided with current values of the bonds, as well as an up-to-date list. 07/24/88 A small spreadsheet for 1-2-3 Release 2.01 that will calculate the amount of a mortgage payment based on information entered. Also will calculate amount of principal & interest over the life of the loan. Can accomodate balloon payments. Has DOC file. 12/16/88 A 1-2-3 Release 2 spreadsheet that does simple Internal Page No. 8 01/12/93 PD/Shareware Products in Library Release Date Product Description Rate of Return Analyses. Version 3.0. No documentation provided. 01/01/85 A 1-2-3 Release 1a worksheet that does a simple Internal Rate of Return Analysis. No documentation provided. 07/29/84 Version 1.0. A 1-2-3 Release 1a spreadsheet for tracking stock options. Fairly limited, only one paragraph of documentation. 07/29/84 A 1-2-3 Release 1a spreadsheet to calculate Discounted Rate of Return on an investment. Corrects the flaw in 1-2-3's @IRR calculation, which assumes that cash returns can be reinvested at the assumed IRR rate. 07/29/84 A 1-2-3 Release 1a spreadsheet that demonstrates the use of the @PMT & @PV functions in constructing a yearly amortization summary for a loan with amount, rate, and term as variables. 01/01/80 A very rudimentary amortization table in a Release 1a spreadsheet. For loans up to 60 months with amount, rate, as other variables. No documentation, but self-explanatory, easily expanded. May be used in any release. 01/01/80 A simple amortization table in a Release 1a spreadsheet. May be used in all releases. For self-amortizing loans payable monthly, terms up to 30 years with amount, rate, as other variables. No documentation, but self-explanatory. 01/01/80 A Release 1a spreadsheet which may be used in all releases. Allows comparison of two different variable rate mortgages. Provides payment amounts and total interest for a range of possible rates & downpayments for each. Displays graph of results. 10/13/85 Set of 22 Release 1a spreadsheets for financial analysis & statistics. Tied together by a menu spreadsheet. Documentation is minimal. Includes cash flow manager & projection, price volume analysis. 11/18/85 A set of 7 Release 1a spreadsheets for simple business use that originally were downloaded from CompuServe's Lotus forum. Includes discounted cash flow for capital purchase, inventory analysis, absenteeism analysis, task list, mailing label macro. 08/18/84 A Release 1a spreadsheet with a table giving monthly mortgage payments for loans from 1K to 75K in 1K increments, terms from 5 to 15, 20, 25 & 30 years. User only inputs interest rate. Easily expanded. 01/01/80 A very simple Release 1a spreadsheet that calculates a large number of financial ratios in a company: turnover (including receivables & payables), expenses, cost of operations, bad debt & allowances. 10/05/89 A simple Release 2.x spreadsheet to determine if it is worth while to refinance a mortgage at a lower rate. 05/31/90 Menu-driven Release 2.x spreadsheet for creating and analyzing simple balance sheet, income statement, & sources & uses report. Calculates various ratios. Menu options include saving & printing. Page No. 9 01/12/93 PD/Shareware Products in Library Release Date Product Description 10/01/89 A small menu-driven 1-2-3 Release 2.x spreadsheet to calculate the amortization on an installment contract with fixed skipped payments. Provides for terms up to 84 months. 09/19/86 Release 1a spreadsheet to record status of each item in portfolio, monitor performance, & track recommendations. Programmed to allow what-if analyses. 07/31/91 Template for Releases 2.01+ to manage & analyze a stock portfolio. Combines multiple portfolio accounting, charting, & technical analysis tracks current prices & historical data for each position. 08/14/91 Version 1.0. Macro-driven release 1a spreadsheet for monitoring mutual funds. Tracks important past performance data, generates line graphs. Should be usable with any release. 04/09/90 One of 8 spreadsheets sold for $65 as a group. Release 2+ spreadsheet (can use Allways) to support investment decisions via calculation of the NPV of a capital expenditure with a life up to 10 years. Supports all methods of depreciation. 07/26/90 Set of 60 Release 2.x spreadsheets, macro-controlled from one master spreadsheet, for film or television production budgeting & accounting. Provides for 25 different accounting categories. 01/15/90 A macro-driven 1-2-3 Release 2.x spreadsheet that tracks stock purchases, including gain & losses and commissions. Has macros to bring in data from Lotus Signal on a one-shot or continuous basis. No documentation. 06/23/86 Worksheet templates for rental, IRR, IRA calculations, car costs, and trends. 09/20/90 Worksheet templates for checkbook management, cash flow projections, cash flow management, balance sheet, ratio analysis, growth capacity, credit line, asset mng., project management, accounts receivable, general ledger, amortization, leasing, more. 09/14/88 A few sample worksheets for 1-2-3 2.0 for home and business use. Includes loans, income, depreciation, Bank records, and balance sheet. 09/26/88 Simple worksheet which calculates the APR (actual annual percentage rate) given principal, term, "points", nominal interest rate and monthly payment. 10/09/90 1-2-3 based fixed asset depreciation template. Extensive documentation, but corrupt after page nine. 04/16/87 1-2-3 WK1 and WKS worksheets to calculate payments for any loan over any period. Also included is a print menu for amortization schedules for periods of 1,3,4,5,10,15 and 30 years. Asks for borrower's name, interest rate, payments per year, term, etc. 09/11/91 WKS balance sheet template. Current assets, fixed assets, liabilities, owners equity, income statement, gross margin, operating expenses, etc. 01/01/89 Investment property worksheet to determine 1st year depreciation. Page No. 10 01/12/93 PD/Shareware Products in Library Release Date Product Description 01/16/86 Worksheets with payment tables for interest rates from 10.6% to 11.5% and a template for mortgage analysis. 04/19/86 Worksheet with a sample data showing items, the year they were bought, their original cost, useful life in years, depreciated value and replacement (inflated) value for a user supplied inflation rate. ** Type Financial Add-in 09/13/89 Dynamic C Add-in Toolkit. ** Type Games/Sports 04/23/87 Once loaded, this memory resident program executes with ALT-TAB to pop up an imitation 1-2-3 spreadsheet over your game, greeting card or whatever. When you hear the boss's footsteps, just pop it up and try to look innocent! 08/01/88 A 1-2-3 Release 1a worksheet that displays a series of kaleidoscope-like graphics. Graphics adapter required. 08/01/88 A 1-2-3 Release 1a spreadsheet that displays a series of graphics based on the children's Spirograph drawing toy. Graphics adapter required. 04/11/86 A 1-2-3 Release 2.01 worksheet that will calculate batting statistics such as batting average, extra base hits, etc., for players and team. No documentation. 06/24/84 A 1-2-3 Release 1a worksheet for keeping a runner's log. Includes date, miles run, elapsed time, speed, and cumulative mileages & speeds. Some documentation contained in worksheet. 07/23/87 The old game of Hangman goes high tech! A macro-driven 1-2-3 Release 1a spreadsheet that asks user to guess letters in a 12 letter word. Displays correctly guessed letters. Six missed letters hangs the robot. Macro runs *very* slowly. 07/29/84 User provides course par and last 20 scores, and this 1-2-3 Release 1a spreadsheet calculates the USGA handicap. 02/05/90 A Release 1a spreadsheet that displays five different, interesting patterns using complex graph functions. Automatic macros. Author unknown. Macro corrected by Bill Landau for smoother operation. Graphics adapter required. Works in Release 2.x. 01/10/86 Get back at the office prankster! Create a batch file that runs LOTUSGAG instead of LOTUS. Displays a realistic 1-2-3 spreadsheet, which starts to dissolve almost instantly. Letters drop to the bottom and off of the screen & the spreadsheet collapses. 08/20/90 A 1-2-3 Release 2.01 spreadsheet with a simple graphic depiction of a three horse race, drawn from a field of a dozen. Best on a fast CPU. 03/18/90 A 1-2-3 Release 2.01+ spreadsheet with a macro-driven pattern of ones in a 34x18 grid. Each time the macro updates the screen, the pattern changes according to a set of rules given in the documentation. 02/18/90 Release 2.x spreadsheet provides a number of ballistics calculations. Variables include caliber, powder type & Page No. 11 01/12/93 PD/Shareware Products in Library Release Date Product Description weight, muzzle velocity, weight of bullet, altitude, temperature, more. Requested contribution is $10 or cost a case of beer where user lives. 11/03/91 Menu-driven spreadsheet for Rel. 2+, that enables user to generate numbers for a 6 off 49 lottery. Provides various frequency distributions, claims to enhance chances of winning. Documentation in spreadsheet only, with no way to exit! 12/03/91 Menu driven worksheet (developed in Release 2.2) that maintains log of trips, including starting place, destination, route taken, & bike used, as well as calculating gear ratios. Will print out logs, or display information graphically. ** Type Goal Seeking 03/18/88 A macro that can be imported into a 1-2-3 Release 2.x spreadsheet to optimize (specific, highest or lowest value) any given cell. User defines cell to be optimized and cells to be varied within defined limits. User can specify time limits. 05/27/87 Goal-seeking package for 1-2-3, SuperCalc4, Multiplan & VP Planner. Once the correct version of GoalSeeker has been loaded, a "hot-key" brings it up within the spreadsheet. Allows multiple criteria, 1 to 25 iterations of the recalculation. 12/20/87 Analyzes data in spreadsheets and databases, draws conclusions according to predefined rules. Author requests $9 contribution for personal use, $49 otherwise. $49 brings current updated version, future updates for small fee. 04/19/90 Sample spreadsheet & instructions for using Solver in 1-2-3/G. Shows how to use Solver to ensure that prices in a package & "a la carte" are consistent, using the example of a wedding photography studio. 04/17/90 Explanation for using Solver in 1-2-3/G. Using example of saving for college, shows how to clean out useless answers, use the optimizer, & use the Report Answer-Table feature. ** Type Graphics 01/12/87 Allows direct editing of 1-2-3/Symphony graph (.PIC) files. Change fill patterns, manipulate axes, legends, etc. Includes specifications of PIC file format. 11/24/86 Macros to demonstrate creation of nine different graphs: sine wave, ellipse, lemniscate, Levin's functions 1 to 3, and Jeanne's functions 1 to 3. Contained in a 1-2-3 Release 1a spreadsheet. 07/29/84 A 1-2-3 Release 1a spreadsheet that uses macros to create various flow chart box shapes out of hyphens, vertical piping symbols, and slashes. Draws them faster than the user could manually. Does not use ASCII extended characters. 12/14/84 A 1-2-3 Release 1a spreadsheet using Treasury bill data Page No. 12 01/12/93 PD/Shareware Products in Library Release Date Product Description to demonstrate creation of two graphs in one. Requires graphics display. 05/21/91 Add-ins & templates for As-Easy-As spreadsheets. Add-ins add 3-D graphing capability & ability to set multiple column widths in one operation. One template aids in selection life insurance, the other to help decide whether to lease or buy. ** Type Health/Medical 11/08/87 A 1-2-3 Release 2.01 spreadsheet that prompts the user to enter the day, month & year of birth. A graph of the user's monthly bio-rhythms is displayed. Graphics adapter required. 07/29/84 A 1-2-3 Release 1a spreadsheet that takes a date of birth & produces a biorhythm chart for a 30-day period centered on the current date. Requires a graphics adapter to display the chart. 03/25/88 Menu driven Release 2.x spreadsheet that prompts the user for child's name, sex, age & height. Projects height at various ages to maturity in a table and graph. Adapted from B. Goldman's HOWTALL.BAS. Author warns results are accurate to 3 feet, + or -. 08/10/90 A Release 2.x spreadsheet intended as a smoking cessation status & motivational tool. Has 2 "clocks" to show how long the ex-smoker has stopped & gain in life span. Calculates savings based on daily investment of cost of cigarettes for up to 60 years. 08/31/89 A 1-2-3 Release 2.x spreadsheet to help the user determine how much, & what kind, of life insurance is needed. Brief documentation, & explanation of types of life insurance, included in spreadsheet. ** Type Home Finance 03/04/88 1-2-3 Release 2 templates for an address book with label printing, home inventory, checkbook ledger, loan analyzer, budgeting worksheet with graphics. Menu driven. Documentation & help from menu only. 10/11/85 A Release 1a spreadsheet with macros to guide the user through entry of the credit cards, etc., in his wallet. Macros sort and print the information. 03/27/84 A 1-2-3 Release 1a template for a very simple checkbook ledger, which allows analysis of checks for two projects or accounts. 03/11/84 A Release 1a template for a very simple checkbook register. Maintains balance, allows coding of checks and extracting lists by code. Does not provide for reconciliation of bank statement. 12/02/88 Two Release 2.x spreadsheets for tracking expenses by category & income. HOMEACCT permits daily entry of expenses by category & income, creates monthly summary compared to budget. ANNUAL allows consolidation monthly, with y-t-d totals. No documentation. 11/23/86 "Social Security Retirement Benefit Calculation Page No. 13 01/12/93 PD/Shareware Products in Library Release Date Product Description Spreadsheet" is a Release 1a spreadsheet which will provide a rough calculation of projected benefits based on actual earnings history and projection of future earnings. 01/12/88 A Release 2.x spreadsheet to track medical expenses, insurance submissions, & reimbursements. Includes small documentation file. 06/07/88 Two Release 2.x spreadsheets. FAMBGT is for tracking expenses compared to budgeted amounts. PAYBILLS determines if there is a sufficient checkbook balance to pay the bills. Both are macro driven. Small documentation file included. 01/23/87 A Release 2 template for a checkbook ledger, intended mainly to simplify bank statement reconciliation. 08/10/90 A Release 2.x spreadsheet that demonstrates the power of compound interest. User enters information including amount, interest, & starting date. Current value & future values for up to 60 years are shown. 04/03/91 Template for use with Release 2.x for home budgeting. Provides monthly data for income & expenses in user-defined account categories. Allows creation of an annual budget, and year-to-date graphing of monthly actuals versus budget. 05/17/91 A collection of spreadsheets in 1A format, which should be usable with any release. Includes amortization, annual budget, automobile log, blood pressure tracking, frequent flyer miles, utility costs, wwight loss, many more. 02/08/92 Series of Release 1a templates for personal financial management. Includes balance sheet, statement of net worth, budget worksheet, stock tracking file, & "financial health" ratio worksheet. Should be useable, with minor modifications, with any release. ** Type How-To Files 04/21/86 Contains text files which explain how to use DEBUG to remove copy protection from 1-2-3 Releases 1a and 2. 10/20/85 Contains a text file which explains how to use DEBUG to remove the logo screen (which requires user to press a key to continue) from 1-2-3 Release 1a. 11/24/84 Explains how to create a macro that will take name & address data laid out as a database in a spreadsheet, and convert it into mailing address format for printing labels. 01/01/80 Contains a text file which explains how to use DEBUG to bypass the logo screen (which requires user to press a key to continue) from 1-2-3 Release 1a. 01/01/80 A brief explanation of how to print Lotus 1-2-3 worksheet data to a file, & then use the file to create a dBASE III database file. 01/01/80 Contains a text file which explains how to use DEBUG to remove the logo screen (which requires user to press a key to continue) from 1-2-3 Release 1a. 08/29/86 Describes a method for speeding up retrieval of files in Page No. 14 01/12/93 PD/Shareware Products in Library Release Date Product Description Release 2. This should not be necessary in Releases 2.01+. 01/01/80 Source code that can be incorporated in a Turbo Pascal file to transfer data directly from a Turbo Pascal written application to 1-2-3 format. Resultant file should be readable directly by all releases of 1-2-3. 06/11/87 A text file which explains the various steps required to convert Release 1a spreadsheets created under DOS to SuperCalc2 files useable under CP/M, and the reverse procedure. 10/11/92 A large collection of tips and tricks for Quatro Pro. Includes many sample worksheets. Converting dollar amounts to text descriptions, Biorythm chart, numerous macro libraries. ** Type Legal Programs 10/13/84 A 1-2-3 Release 1a template for "structured settlement analysis " designed to help attorneys determine the relative values of different settlement options. 10/20/86 A collection of over 50 Release 1a spreadsheets which would be useful in a law office. Some are specific to law, such as a new client billing record, while others are more general financial spreadsheets. ** Type Macro Generator 07/21/87 Provides the "learn mode" of macro generation available in Symphony to 1-2-3 Release 2/2.01. Allows embedding of pauses, input fields, decisions & command repetitions in a macro. Version 2.3. 12/21/86 A 1-2-3 Release 2.01 spreadsheet with a macro that will record the user's keystrokes to create a macro. Documentation is contained in the spreadsheet. 01/20/85 Two Symphony add-in applications: the first translates most 1-2-3 macros to Symphony macros the second adds the equivalent of the 1-2-3 Range Input command. Intended to help the regular 1-2-3 user who must work in Symphony. 08/08/84 A Release 1a spreadsheet that can be combined into any 1-2-3 spreadsheet and semi-automatically convert it to menu-driven operation. Works best on spreadsheets that have repetitive data entry and printing requirements. ** Type Macro Library 09/30/88 A collection of spreadsheets containing macros for 1-2-3 Release 2.x. Quickly add up a column of figures, calculate the width of a print range, enter a date as 9/30/88 instead of @DATE(88,9,30), easily switch from laser to dot-matrix printer codes. 06/16/86 A package of Symphony support macros which produces a list of serial dates in monthly increments, either across a row or down a column. Can be first, 15th, last, or any other day of month. Also includes a version for 1-2-3 Release 2/2.01. Page No. 15 01/12/93 PD/Shareware Products in Library Release Date Product Description 11/17/86 Three 1-2-3 Release 2.01 files and a Symphony Macro Library file from a 1986 Lotus Developers' Conference. Illustrates some of the capabilities of 1-2-3 and Symphony. 01/03/86 A macro library for 1-2-3 Release 1a/2.x that provides a method to increase the utility and ease of use of large numbers of macros. 01/15/87 Two spreadsheets, one for 1-2-3 Release 1/1a and one for 2/2.01. The latter makes use of the string functions. Both contain macros to generate address labels, plus a few other menu-selected macros. 01/01/80 A 1-2-3 Release 1a spreadsheet with a macro that provides the 1-2-3 equivalent of a FOR-NEXT loop. 01/01/80 A 1-2-3 Release 1a spreadsheet with a macro that demonstrates how Release 1a can insert a string in response to an IF decision. 11/02/86 Spreadsheet & documentation with 20 simple macros. Author states they were tested with Release 2, but should work with Release 1/1A. Includes macros to insert current date & format cell 2 different ways, erase cell at cursor, reset column width, etc. 03/01/91 Release 2.x macro that will record a series of keystrokes, & then "play them back" on demand. The keystrokes can be altered whenever desired. Uses some ingenious macro techniques. 03/01/91 Set of Release 2.x macros that change a label to all caps, all lower case, or first letter of each word capitalized. 03/01/91 Macro for Release 2.2/3.0 that retains range names in a formula being edited, instead of displaying cell addresses. If formula is more than 80 characters, will display the entire formula (up to 240 characters) on 3 lines. 09/16/88 Macros which illustrate a method to have more than 26 macros in a worksheet, insert a date in a printout, data entry, addition, num to label, and months, replace backslash for underlining, more. 11/26/86 Learn macro for 1-2-3 version 2. Requires space of 5 columns x 1020 rows. Can be put anywhere there is room with the /fcceLEARN command. ** Type Mathematics 06/25/87 A Release 2.01 spreadsheet for using Simpson's 1/3 rule for measuring areas. Calculations are macro-driven data can be entered manually or via macro guidance. 03/01/89 A small 1-2-3 Release 2.x spreadsheet to calculate the unknown sides/angles of a triangle when 3 of the 6 variables are known. No documentation included. 11/01/91 A 1-2-3 Release 2.x spreadsheet that will display any base 10 integer as an integer in any base up to 36. Some documentation is included within the spreadsheet. 11/01/91 A 1-2-3 Release 2.x spreadsheet that will determine if a number is a prime, & if not, will show the smallest Page No. 16 01/12/93 PD/Shareware Products in Library Release Date Product Description factor. Some documentation is included within the spreadsheet. ** Type Memory Extender 03/10/86 A fully operational demo version of Micro VMS, but without some of the features. Sets up a "virtual memory system" of up to 640K for 1-2-3 Release 2.x using hard disk or RAM disk to emulate expanded memory. 06/13/87 Allows 1-2-3 Release 2.x & any other program using LIMS to use a RAM disk in extended memory or hard disk to emulate up to 128K of expanded memory. Vendor states this demo version is identical to register version ($49), except latter can emulate 8MB. 12/19/90 Permits users of DESQview to run Lotus 1-2-3 Release 3.1 in a DESQview window while resolving certain keyboard conflicts without problems created by resolving the conflicts with 1-2-3's Change a Program menu. 05/20/91 The Quattro Pro Application Swapper, allows Quattro Pro to load as if it were a TSR. When not being used, Quattro Pro is swapped out to extended memory or hard drive. Can be recalled with a user-selectable hot key. ** Type Misc. Utilities 02/06/86 Help for the novice user of 1-2-3 Release 1a, adaptable for Release 2.x. Provides predefined macros and helps standardize new ones an ASCII character set library an appointment module diary/note jotter module. 02/26/85 Set of 6 menu-driven worksheets for 1-2-3 Release 1a. Each can be registered separately: file manager ($15), macro library ($25), checkbook ledger/budget ($18), installment loan analyzer ($20), mailing list manager ($25), weekly data reporter ($20). 11/30/87 Contains Add-in Manager files for 1-2-3 Release 2/2.01, Lotus Learn Add-in (2/2.01) which creates macros as the user performs a function, and Lotus Speedup Add-in (2.01 only) which optimizes rscalculation in many worksheets. Includes documentation. 06/15/88 For 1-2-3 Release 2/2.01. Contains all of the files that are on the 123 Value Pack Disk: includes Add-in Manager, Speedup, Learn, additional device drivers. Documentation is listed separately (see 123 Value Pack Documentation VPMANUAL.ZIP). 10/17/86 Contains file 123.EXE to replace 123.COM for 1-2-3 Release 2.01. This removes the copy protection and allows running 1-2-3 from the hard disk without installing or using the Value Pack. 03/18/84 A collection of utilities for 1-2-3 Release 1a. ASCII characters will not display in Release 2.x. Includes ASCII character generator, printer control code generator, template for use of Prokey with 1-2-3, various macros. Page No. 17 01/12/93 PD/Shareware Products in Library Release Date Product Description 01/01/80 Provides necessary files to allow Prokey to work with 1-2-3 (Release 1a, possibly later). 11/08/89 Identifies system hardware suggests changes to help run Release 3 provides a glossary of technical terms. Provides a printed report. Find out if you can run Release 3 before buying. 10/20/87 A batch file that changes the prompt when the user shells to DOS from 1-2-3, displaying a reminder to type "Exit" to return to 1-2-3. Restores the prompt to the common $P$G on quitting 1-2-3. Easily adaptable to other prompts, other programs. 07/19/90 Contains a DEBUG patch to allow users of 1-2-3 Release 3.0 to change the user name & company name that appear on the opening screen. Also includes a patch for INSTALL.EXE to allow changing of printers and display devices. 06/20/91 Updated add-in support files for 1-2-3 Release 3.1. These files allow the use of add-ins written with newer versions of the add-in toolkit. 12/22/90 Executable file that permits changing the user & company name & serial number "burned in" to the opening screen of 1-2-3 Release 3.1. Unscrambles the information which is stored in INSTEXT.RI, allows user to change it, & rescrambles just as INSTALL does. 12/27/83 AutoPlate worksheets for mailing list system. 08/14/87 Worksheet showing how to produce 3D graphics? Includes offer for spreadsheet T Shirt. 06/17/88 Provides an alphabetic listing of 1-2-3 files with a one line description to the screen or to the printer. Cell A1 of each worksheet must have a descriptive comment of 50 characters or less. ** Type Mouse Interface 06/26/86 Full name is "Mouse Interface Front End for Lotus 1-2-3." Contains a .COM file and a file with source code. The program's name says it all. 10/27/89 RollerMouse definition file to allow use of the mouse with 1-2-3 Release 3. 09/09/91 Mouse interface for use with TRIUS's As-Easy-As 1-2-3 lookalike spreadsheet. ** Type Print Enhancer 11/01/86 Spreadsheets for 1-2-3 Release 1/1A that contain line drawing & other extended ASCII codes that cannot be generated in 1-2-3 before Release 2, Epson printer codes, password protection for spreadsheets & an .EXE file to load extended ASCII codes to Epson. 02/05/86 Menu-driven template for 1-2-3 Release 1a to simplify selection of line printer, HP Laser printer font & paper. Provides appropriate setup strings. No documentation. 02/19/87 A 1-2-3 Release 1a spreadsheet for users of the older Sideways printing program that could not read spreadsheet files directly. Contains two macros that walk the user Page No. 18 01/12/93 PD/Shareware Products in Library Release Date Product Description through creating a .PRN file that Sideways can use to print. 07/29/84 A macro-invoked menu in a 6 column x 40 row 1-2-3 Release 1a worksheet which can be combined into any 1-2-3 spreadsheet. Calls up menus to set various enhancements for the Epson FX series of printers. User does not have to know setup strings. 09/26/86 File that allows setting paper size & orientation for HP LaserJet printer prior to running 1-2-3. Pascal source code included, along with a few lines of documentation. 06/16/89 A Release 2.x spreadsheet that contains a macro-driven menu to allow setting various print setups for the Citizen MSP40 printer. User does not have to know setup strings. 05/17/89 Printing utility for TRIUS's AS-EASY-AS & compatible spreadsheets. Permits printing in either portrait or landscape orientation, with either of 2 included fonts. Also includes a program to allow user to develop fonts which can be accessed by PIVOT! 12/17/86 Menu-driven template for 1-2-3 Release 1a/2.x to automate setting the default printer string to one of various alternatives. 01/26/91 Collection of templates for Release 2.x with Allways. Includes templates to automate processing & printing of travel report, purchase order, invoice, more. Also eight graphics that Allways can insert in documents. 01/21/88 Fix for printing with Release 2.01+ on a Novell network with a nondedicated server. This corrects the "device unavailable" message that occurs when printing from 1-2-3 or BASIC with some versions of nondedicated NetWare. 11/25/91 Run from the DOS command line prior to printing, adds alternate shaded bars to a 1-2-3 or other printout on an HP laser printer, to emulate computer paper with green bars. Includes executables for landscape & portrait orientations. ** Type Printer Drivers 08/07/86 Three printer drivers for 1-2-3 Release 2/2.01 for using HP LaserJet for printing text and graphics (both high and low density). Includes instructions for use. 03/20/86 Printer drivers for 1-2-3 Release 2.x for using Canon LBP-8 laser printer in both text & graphics modes. No documentation. 04/28/90 Drivers for the HP LaserJet III for 1-2-3 Release 2.2 with Allways. 04/28/90 Drivers for the HP LaserJet III for 1-2-3 Release 3. Version for use under DOS and OS/2. 04/13/89 Drivers for the Hewlett-Packard DeskJet printer for 1-2-3 Releases 2/2.01. Also includes an updated INSTALL.EXE which uses less RAM than the original. 01/26/91 A collection of 23 additional drivers for Allways & Release 2.x. Includes drivers for the LaserJet III & IIID, IBM Laser Printer, Canon LBP8, Apple LaserWriter, a Page No. 19 01/12/93 PD/Shareware Products in Library Release Date Product Description Postscript driver, a driver for the Epson LQ2550, more. 01/26/91 A collection of 69 printer drivers for Release 2.01/2.2 & Symphony 1.2/2.0/2.2. Includes drivers for laser printers & dot matrix printers not originally supported directly by 1-2-3. 03/14/91 Additional printer drivers for Release 3.1. Includes Canon LBP series, HP DeskJet, HP PaintJet, Postscript (color & mono), NEC Pinwriter series, Okidata 290 series, Panasonic KX-P1124/1624 & KX-P1180/1695, & TI 850 series. 12/04/91 Printer drivers for 1-2-3 Releases 2.3/3.1/3.1+, Quattro Pro 1.0-3.01, & other color DOS applications for the HP DeskJet 500C color printer. ** Type Project Manager 01/01/80 A simple Release 1a spreadsheet that allocates each day's time over a number of projects. Gives daily totals, weekly summary by project, including percent of time spent on each project & of 40 hours. Good in any release, some instructions in spreadsheet. ** Type Real Estate 09/21/85 A 1-2-3 Release 1a template for calculation of closing costs in a real estate sale. No documentation. 03/31/89 A Release 2.01 spreadsheet that allows input of various data, and provides a calculation of the mortgage that a buyer can qualify for, and the price he can afford to pay. 10/05/85 A 1-2-3 Release 1a spreadsheet to analyze a real estate purchase. Uses the Lotus Internal Rate of Return function, and does a sensitivity analysis of the property's appreciation. Gives optimal holding time. Documentation in spreadsheet. 07/29/84 A 1-2-3 Release 1a template to perform a 10-year cash flow analysis of rental property. Provides for input of most common expenses. No macros or documentation. 06/11/89 Template that computes the maximum mortgage loan based on income & debt considerations. User enters income, current debt, downpayment, length of mortgage, interest rate, & bank's acceptable ratios. Target monthly payment may also be specified. 02/15/90 Set of linked worksheets for As-Easy-As, Release 4+, for management of up to 8 rental properties with up to 8 tenants each. Provides a one-page summary of income & expenses for each building monthly. 02/22/91 Template that should work in all releases of 1-2-3. Provides an estimate of the affordable purchase price based on user's entry of amount of monthly payment that is affordable & down payment. Also provides amortization table. No documentation. 07/18/91 Template for Release 2.x & Allways produces a professional HUD-1 Settlement Statement on an HP LaserJet IIP or compatible printer. Intended for use by closing attorneys & other professionals. Produces file for use by Quicken to write checks. Page No. 20 01/12/93 PD/Shareware Products in Library Release Date Product Description 01/04/92 Release 2.x templates for use in analyzing proposed multi-family rental projects under HUD-FHA insured loan programs. Includes Section 221(d)(4) new construction & substantial rehab, Section 223(f) purchase or refinance of existing property, others. ** Type Reference 06/13/88 For 1-2-3 Release 2/2.01. Contains complete text of the 123 Value Pack Manual, including Value Pack technical notes. 10/29/85 Title page includes "Electronic Edition, December, 1984." Introduction & Quick Reference with extremely detailed description of the format of 1-2-3 & Symphony worksheet files. ASCII text file. ** Type Science/Engineer 09/21/89 QuatroPro worksheet to calculate vent resonator for loudspeaker designs. ** Type Search & Replace 11/16/88 A 1-2-3 Add-in to search and replace information in a Lotus 1-2-3 spreadsheet, Release 2.x. Add-in Manager and executable installation files included. 03/08/89 Add-in for 1-2-3 Release 2/2.01 to find and/or modify cell entries. Includes a global search & replace, and instructions for using from within a macro. Has 13 page on-disk manual. Registration brings latest version, printed docs. Site license $475. 03/12/88 A standalone program that reads a spreadsheet file, searches for & replaces one or more words or groups of words in labels, writes a new spreadsheet with the replacement. Author states tested on 1-2-3 Release 1, but should work on Rel. 2.x & Symphony. ** Type Security 07/21/87 Provides password protection for spreadsheets, Lotus itself, even the entire computer to some extent. For 1-2-3 Release 2.x. Version 2.3. 12/12/86 Memory resident utility for any spreadsheet, word processor, or other program that keeps current file in memory. User provides keystrokes that save file, & utility saves file every few minutes under filename SAVE.ext. Limited customization possible. 01/07/91 TSR that prevents user from shelling to DOS from 1-2-3 (or any other DOS application) without responding with correct password. 01/19/92 Add-in for 1-2-3/W that automatically saves all open worksheets every 5, 10, or 30 minutes. Will not save a new (untitled) worksheet. ** Type Speedup Program 10/17/87 Add-in for 1-2-3 Release 2.01 that permits users to perform other spreadsheet tasks while a recalc is taking Page No. 21 01/12/93 PD/Shareware Products in Library Release Date Product Description place. This is a demo version that the vendor states is identical to the registered version ($59) except it becomes inoperative after 15 min. ** Type Spreadsheet Linker 07/24/90 Series of Release 2.x spreadsheets to facilitate data entry for a number of subsidiaries, & consolidation into subtotal & total spreadsheets. Maximium of 100 rows & 12 columns in the consolidation area, & 100 subsidiaries & subtotals. ** Type Spreadsheets 03/11/92 A 1-2-3 lookalike, with spreadsheets compatible with Release 2.x. Full 8192 rows by 256 columns, fully mouse compatible. Prints graphs & text on same page, has print preview mode, spreadsheet linking, over 100 macro commands & 100 @ functions. 08/23/90 Three dimensional spreadsheet, 512x512x512. Replaces FormalSoft's QubeCalc, & is a shareware version of ProCube 3D. Price includes $5 shipping & handling. Extensive documentation is in separate file PQL-DOCS. 12/06/90 A limited-size, reasonably fast & powerful spreadsheet with many built-in math & financial functions, graphing capabilities. Intended to be easy to use. Can exchange data, but not formulas, with 1-2-3 via .DIF files. Also includes a text editor. 05/31/91 Memory resident spreadsheet, 256 columns x 256 rows, which can directly access data from 1-2-3 spreadsheets. When popped up over another application can transfer data from 1-2-3 or import data from the application. 06/16/89 A full-featured shareware spreadsheet that can import & export 1-2-3, DIF, & comma delimited ASCII files. Includes a sideways printing program. This file (PCCP.ZIP) contains the main program files, PCCU.ZIP has utility files, PCCD.ZIP documentation. 06/20/89 Documentation for main PC-Calc+ program (PCCP.ZIP) and PC-Calc+ utilities (PCCU.ZIP). 06/16/89 Utilities for main PC-Calc+ program (PCCP.ZIP). Documentation is in PCCD.ZIP. 06/03/86 A very small (11 columns x 22 rows), simple spreadsheet that requires only 48Kbytes of free RAM. This makes it useful when some spreadsheet calculations must be performed while shelled out from an application that leaves little free memory. 11/06/89 A small shareware spreadsheet (64 columns x 256 rows). Has most of the features of the major spreadsheets. The extensive manual on disk is obviously directed at the spreadsheet novice. Manual is in file ECAL4DOC. 07/18/89 The manual is contained in this file. The operating files are in ECAL408. 09/07/90 Uncompressed, this documentation file for the ProQube Lite files in PQLITE is over 400Kbytes. 08/12/91 Full-featured, but smaller, version of AS-EASY-AS 1-2-3 Page No. 22 01/12/93 PD/Shareware Products in Library Release Date Product Description lookalike spreadsheet. Requires only 256K of available RAM, provides 2048 rows by 128 columns. Files compatible with Releases 1a & 2.x. Prints graphics creates 1-2-3 format .PIC files. 02/28/90 Spreadsheet program with many features. 01/31/88 Spreadsheet with a limited word processor. ** Type Statistical 05/29/87 Ten spreadsheets, each with a different statistical test, for 1-2-3 Release 2+. Includes 1-way Analysis of Variance, Chi-squared tests, XY graphs with confidence limits, lifetables, linear & parabolic regressions, t-tests. 10/19/87 21 different 1-2-3 Release 2.01 templates compiled by Glenn Ouchi, PhD, editor-in-chief of Laboratory PC User. Statistical and graphing templates. Also date and time macros. 10/08/85 Volume 1A. Volume 1B is sent to registered users. Each contains 6 1-2-3 Release 1a worksheets, including depreciation using various methods, net present value, profitability & breakeven, rate of return, regression analysis, etc. 02/23/84 A 1-2-3 Release 1a curve fitting macro. Creates a least squares straight line or exponential curve to fit a user-supplied set of data. 12/01/84 A 1-2-3 Release 1a spreadsheet with an industry analysis of a number of companies in the transportation sector. Intended as a demonstration of the uses and power of @DCOUNT and other 1-2-3 database statistical functions. 01/01/80 A 1-2-3 Release 1a spreadsheet that calculates a "2 x 2 Linear Discriminant Function (Fisher's Method) with Confusion Matrix and Estimate of Apparent Error based on full Sample Information." 01/01/80 A simple linear regression template for Release 2.x. Analyzes data from 3 to 2,000 data sets. Will then predict a Y value based on a given X value. Can display a graph of the results of analysis. 06/24/85 Release 1a spreadsheets to create statistical quality control charts: histograms, x-bar, r, x & moving range charts, p-charts, & Pareto charts. They appear to run fine with Release 2.2, should be okay with 2.01, 3. 03/20/89 A Release 1a spreadsheet with a regression analysis for up to 300 sets of variables. No documentation, but some explanation within the spreadsheet itself. For those with some statistical background, but not much experience with 1-2-3. 10/05/85 A Release 1a spreadsheet with various descriptive statistics for a set of data: number of items 3, 6 & 12 period moving averages minimum & maximum values range mean standard deviation Page No. 23 01/12/93 PD/Shareware Products in Library Release Date Product Description variance linear regression. 07/17/87 A Release 2.x spreadsheet that uses macros to plot X-Y data in one of four ways: raw data, linear fit, quadratic fit & cubic fit. Uses power polynomials to fit the data. 04/01/85 A Release 1a spreadsheet that calculates regression on up to 75 sets of X-Y data points. Macro-driven data entry and calculation. No documentation, some instructions in spreadsheet. 09/05/87 A Release 2.x spreadsheet that calculates a forecast of the next period's demand based on the most recent demand, most recent forecast, and smoothing coefficient. ** Type Tax Program 01/09/92 Release 2.x template for 1991 federal 1040, schedules A, B, C, D, E, F, & SE. Includes a number of other forms, including 8829, 4562, 6251, 4797. Does all calculations, prints forms on any printer, although laser printer is recommended. 02/03/89 1-2-3 Release 1a template for 1988 federal 1040, and a total of 24 schedules and forms. 30-page manual on disk. Fully menu driven. Requires some familiarity with Lotus. Does all calculations, prints forms. 07/29/84 A 1-2-3 Release 1a template to calculate the interest due IRS on underpayment of income tax due since any time after July 1979. Takes into account the varying rates of interest since that time. 07/29/84 A 1-2-3 Release 1a spreadsheet that calculates ACRS depreciation based on input from the user. 02/22/91 Macro-driven template for Release 2.01+ for 1990 Canadian Federal & Quebec income taxes. Provides some edits, but is mainly a guide to help fill in the forms & do the calculations. 01/09/91 Template for Release 2.01+ to aid in completing Canadian Federal Tax form T1 for 1990. Has sections corresponding to the 5 steps on the form, 4 Schedule 1s to help in determining options. Macros provide calculations for various deductions & options. 03/03/91 Template the author created for his own use in completing Arizona tax forms. As he states, it is not a professional effort, but may be useful to other Arizona residents. 01/22/91 Contains 2 templates created in Release 2.2 for completing 1990 NY State Form IT-201. One is macro-driven, the other isn't. Brief documentation file included. Author identifies himself only as Bob M., CIS 72750,3125. 01/09/91 Template for Release 1A+ for 1990 Federal form 1040, 8 schedules, & a number of worksheets. Includes 18 page manual on disk. Full registration at $40 includes 23 forms, schedules, & worksheets, enhanced printing support for form 1040. ** Type Teachers' Tools Page No. 24 01/12/93 PD/Shareware Products in Library Release Date Product Description 09/16/87 Template for 1-2-3 Release 1a+. Designed for use by classroom teachers to keep student grades, compute student & class averages for each assignment & for the grading period. ** Type Training 06/12/86 An interactive adventure game tutorial for 1-2-3 Release 1a/2.x and compatibles. Introduces the user to many 1-2-3 commands in an enjoyable format. Free version includes 3 of 16 adventure templates. The complete package is available for $39.95. 10/01/86 Two 1-2-3 Release 2.01 spreadsheets which demonstrate the use of a number of built-in 1-2-3 @ functions. They also provide a complete list of these functions. 08/15/87 Lotus 1-2-3 Release 2.01 worksheet that is a menu-driven tutorial on how to create and use macros. 05/15/87 A 1-2-3 Release 2.01 spreadsheet which demonstrates the use of three @ functions, @DATE, @MOD, & @CHOOSE. Also provides an interesting view on use of Lotus's date functions. 11/22/88 A small Release 2.01 spreadsheet that provides a demonstration of the use of the Range Input command. 09/07/88 Training system for spreadsheet and file management concepts using 1-2-3. Basic concepts, formatting and ranges, what-if modeling, data file operations, and more with sample worksheets. ** Type Translate Utility 02/20/86 Converts ASCII files of fixed length records into columns which can be imported into a 1-2-3 spreadsheet, any version, using FILE IMPORT NUMBERS. 07/01/88 Two programs which can be compiled using Turbo C 1.5 and MSC 5.1. One will allow creating a 1-2-3 spreadsheet from C, the other will read a 1-2-3 spreadsheet into a C program. 03/04/89 Generates an ASCII file intended for use with Borland's Sprint word processor from a 1-2-3 worksheet. 12/09/85 For all releases of 1-2-3. Analyzes and reformats an ASCII data file as a comma-delimited file which can be imported into spreadsheet retaining the label and numeric nature of the original fields. Unlike Parse, formats each record individually. 06/18/86 Allows conversion of an ASCII data file to a comma-delimited file trhrough use of an "instruction" file to designate how fields are to be handled. Instruction file may be used repeatedly. The result file may be imported directly into a 1-2-3 worksheet. 12/12/86 TurboPascal program to print data in a 1-2-3 spreadsheet file, Releases 1a/2. Source code only, not compiled. 03/30/88 "Converts data from Lotus 1-2-3 .WKS files to a comma delimited ascii format text." Allows database programs which cannot import 1-2-3 data directly to use data from 1-2-3 worksheets without retyping data. Page No. 25 01/12/93 PD/Shareware Products in Library Release Date Product Description 08/04/85 A utility to convert Symphony files (version not specified, possibly only 1.0) to 1-2-3 Release 1a files. Includes both compiled and Pascal source code files. 04/18/85 A utility to convert PeachCalc & SuperCalc files into a format that can be used by 1-2-3 Release 1a. 03/15/87 Users who have only Release 1a cannot use files created in Release 2x, even if they contain only data usable by 1a. This program will take a Release 2x or Twin file, and convert it to a file readable by Release 1a. 07/15/89 Uses ASCII files in columnar format as input, produces Release 2.x spreadsheet files. Format for each column in spreadsheet file is specified on command line. 12/28/87 Converts Managing Your Money's BUDGET.ARK file into a PRN file which can be imported into a 1-2-3 spreadsheet, any version, using FILE IMPORT NUMBERS. Also converts BUDGET.ARK for import into Paradox. Includes Turbo Pascal 4.0 source code for both. 01/19/86 A Release 2 spreadsheet that combines macros in from a 1a spreadsheet, and converts all of the /x macros to Release 2 keyword equivalents. Although the /x macros will run under Release 2.x, the author obviously feels the result is a cleaner spreadsheet. 04/23/90 Converts an ASCII file into a 1-2-3 spreadsheet in Release 1a format. Automatically sets column widths, determines labels & values as appropriate. Can be run from a menu, or directly from DOS command line. Supports default data directory. 03/14/90 Reads the contents of a 1-2-3 Release 2.01 spreadsheet, & converts it into a table in WordPerfect format. The resulting table will include tabs that will accomodate proportionally spaced fonts. 01/21/91 Additional modules for the File Translation utility of Release 2.2. For Enable 2.0, SuperCalc 4, and Multiplan. 09/22/90 Additional modules for the File Translation utility of Release 3.1. For Enable 2.0, SuperCalc 4, and Multiplan. 09/08/91 AutoCAD interface to spreasheet files, uses an AutoLISP routine to read data from .WK1, .WKS & .WRK files. Imports tabular data with all formatting intact. 04/22/87 Instructions and tips for creating and using 1-2-3 add-ins. Includes source and executable for a WordStar to 1-2-3 format converter add-in and the files you need to add (and delete) the 1-2-3 Add-In Manager to your driver set. 10/23/86 A file extraction program for use with 1-2-3 spreadsheets. Lets you export delimited files that other programs (and Lotus) are able to import. Makes strings delimited with double quotes and each field separated by a comma. ** Type Windows Interface 06/19/90 Windows icons for non-Windows versions of applications from 4 vendors: PKWare, Ashton-Tate, Lotus 1-2-3, Puma. Page No. 26 01/12/93 PD/Shareware Products in Library Release Date Product Description ** Type Windows Support 09/13/91 Lotus wallpaper for use with Windows 3.0. 09/13/91 Wallpaper for use with Windows 3.0. Has both Lotus & Excel logos, for those who can't decide between 1-2-3/W & Excel. ** Type Word Processor 12/30/84 A Release 1a spreadsheet with menu-driven guidance in creating and printing a simply multi-page letter & envelope. For very simple documents only.