Disk Library

Courtesy of Washington Apple Pi

3 EZ Pieces Part II

BANKCALC #1

APPLE-3-WAP-awz-07a.dsk [Catalog]APPLE-3-WAP-awz-07a2.dsk [Catalog]APPLE-3-WAP-awz-07b.dsk [Catalog]APPLE-3-WAP-awz-07b2.dsk [Catalog]BANKCALC #1INFORMATION ABOUT THIS DISK :     BANKCALC was written by Anthony Powers and published by Micro Book,Inc. of Arlington Heights, Illinois in 1982.  It is a collection of 14VisiCalc models written by community bankers or Banking IndustrySoftware Houses and contributed to the publication.    According to the Introduction:The purpose of this book is to provide bank personnel with Visicalcmodels which can be used immediately.  As the banker gains experience inVC by using these models, he may wish to use them as a base for developinghis own customized programs.     Note that these models can all be pulled into 3EZ Pieces or Appleworksand may be of use to the home user in some form or another. We've put theminto the public domain as part of a continuing attempt to make all formerlycommercial Apple /// products (that are not still on the market in some form)available to the /// community.NOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS      A VISICALC FILE RATHER THAN DIF.     We've included Menu.Maker on this disk so that (after you've booted intoBusiness Basic from another disk or off your hard disk) you can look at thesefiles or print them if you like. This information file is available in bothText and 3EZP/Appleworks format as well.     While these models should hold for the present, please be aware thatthey all came out in the early 1980s and reflect the situation at that time.Some of these models may require some changes based on today's realities. Asthis is a PD offering, buyer beware takes precidence here. You should findsome of these useful.  But there is no implied guarantee that any of thesemodels as presented will return information accurate for the 1990s.NOTE #2:  THE BOOKS THAT ACCOMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE          WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM.On Side One of this disk (III.ZAW.07) you'll find the following Visicalcmodels:MANAGEMENT MODELS-: Model 1:  Variance Analysis of Yields             The identification of the causes of month-to-month income             variance of assets.-: Model 2:  Yield Summary             The calculation of monthly yields and costs.-: Model 3:  Rate Sensitive Statement of Condition             A restatement of the Statement of Condition in terms of rate             Sensitivity.AMORTIZATION MODELS-: Model 4:  Simple Loan Amortization Schedule-: Model 5:  Rate of 78 Amortization Model             A loan amortization schedule with interest calculated using             the rule of 78s.-: Model 6:  Effective Rate Model             Produces a table of effective interest rates resulting from             daily compounding of a nominal interst rate.-: Model 7:  Compound Yield             Creates a table of effective effective annual yields resulting             from daily compounding at a nominal interst rate.ACCOUNTING MODELS-: Model 8:  Fixed Assets Model             Calculates the depreciation for fixed assets using the             Streight Line Method.-: Model 9:  Accrue Expenses             Accrues expenses over a variable number of months and prepares             monthly journal entries for the expenses.Side TwoACCOUNTING MODELS (Continued)-: Model 10:  Charitable Contributions              Maintains a history of donations to specific charaties.LENDING MODELS-: Model 11:  IRA Calculations              Calculates the value of an IRA Account at retirement.-: Model 12:  IRA Vs. CD              Compares an IRA to a CD investment over the same term, and              prepares an IRA disbursement schedule.-: Model 13:  All Saver CD Yields              Develops the appropriate nominal rate for an All Saver CD,              given the permitted effective rate and frequency of              interest payments.-: Model 14:  Credit Analysis-:            A statement spread program for potential commercial              borrowers which performs a financial analysis on the              borrowers financial statements.-:-:

BANKCALC #2

APPLE-3-WAP-awz-08a.dsk [Catalog]APPLE-3-WAP-awz-08b.dsk [Catalog]BANKCALC #2INFORMATION ABOUT THIS DISK :     BANKCALC was written by Anthony Powers and published by Micro Book,Inc. of Arlington Heights, Illinois in 1982.  It is a collection of 14VisiCalc models written by community bankers or Banking IndustrySoftware Houses and contributed to the publication.    According to the Introduction:The purpose of this book is to provide bank personnel with Visicalcmodels which can be used immediately.  As the banker gains experience inVC by using these models, he may wish to use them as a base for developinghis own customized programs.     Note that these models can all be pulled into 3EZ Pieces or Appleworksand may be of use to the home user in some form or another. We've put theminto the public domain as part of a continuing attempt to make all formerlycommercial Apple /// products (that are not still on the market in some form)available to the /// community.NOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS      A VISICALC FILE RATHER THAN DIF.     We've included Menu.Maker on this disk so that (after you've booted intoBusiness Basic from another disk or off your hard disk) you can look at thesefiles or print them if you like. This information file is available in bothText and 3EZP/Appleworks format as well.     While these models should hold for the present, please be aware thatthey all came out in the early 1980s and reflect the situation at that time.Some of these models may require some changes based on today's realities. Asthis is a PD offering, buyer beware takes precidence here. You should findsome of these useful.  But there is no implied guarantee that any of thesemodels as presented will return information accurate for the 1990s.NOTE #2:  THE BOOKS THAT ACCOMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE          WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM.On Side One of this disk (III.ZAW.08) you'll find the following Visicalcmodels:YIELD MODELS-: Model 1:  Commercial Loan Yields             The calculation of monthly yields for all classes of             Commercial Loans.-: Model 2:  Installment Loan Yields             The calculation of monthly yields for all classes of             Installment Loans.-: Model 3:  Real Estate Loan Yields             The calculation of monthly yields for all classes of             Real Estate Loans.-: Model 4:  Money Market Yields             The calculation of monthly yields for all classes of             Money Market Yields.-: Model 5:  Investment Yields             The calculation of monthly yields for all classes of             Investments-: Model 6:  Deposit Costs             The calculation of monthly costs for all classes of             Deposits-: Model 7:  Asset Yields             A monthly management report of all assets and the             monthly yields of earning assets-: Model 8:  Liability Costs             A monthly management report of all liabilities and the             monthly cost of paid liabilities-: Model 9:  Interest Margin             A monthly management report of the spread between earning             assets and paid liabilitiesEARNINGS MODEL-: Model 10:  Earnings Projections              A bank earnings model which projects four years of bank              earnings, based upon historical earnings, current              earnings, and a series of earnings assumptionsSIDE TWOACCOUNTING MODELS-: Model 11:  Accelerated Cost Recovery              The calculation of depreciation on fixed assets for tax              purposes using the new Accelerated Cost Recovery Guideline-: Model 12:  Budget Income Expense              A monthly comparison between budgeted income and expenses,              and the actual monthly results-: Model 13:  Balance Sheet Budget to Actual              A monthly comparison of the asset and liability monthly              budget with the actual monthly results-: Model 14:  Monthly Rates              The calculation of monthly average rates given a series of              daily rates.-: Model 15:  Income Tax              The calculation of the banks monthly provisions of federal              income taxesLENDING MODEL-: Model 16:  Mortgage Amortization              The preparation of a mortgage amortization schedule, and the              development of a price for the mortgage based upon the              present value given a bank's desired rate of return

BANKCALC #3

APPLE-3-WAP-awz-09a.dsk [Catalog]APPLE-3-WAP-awz-09b.dsk [Catalog]BANKCALC #3INFORMATION ABOUT THIS DISK :     BANKCALC was written by Anthony Powers and published by Micro Book,Inc. of Arlington Heights, Illinois in 1983.  It is a collection of 8VisiCalc models written by community bankers or Banking IndustrySoftware Houses and contributed to the publication.    According to the Introduction:The purpose of this book is to provide bank personnel with Visicalcmodels which can be used immediately.  As the banker gains experience inVC by using these models, he may wish to use them as a base for developinghis own customized programs.     Note that these models can all be pulled into 3EZ Pieces or Appleworksand may be of use to the home user in some form or another. We've put theminto the public domain as part of a continuing attempt to make all formerlycommercial Apple /// products (that are not still on the market in some form)available to the /// community.NOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS      A VISICALC FILE RATHER THAN DIF.     We've included Menu.Maker on this disk so that (after you've booted intoBusiness Basic from another disk or off your hard disk) you can look at thesefiles or print them if you like. This information file is available in bothText and 3EZP/Appleworks format as well.     While these models should hold for the present, please be aware thatthey all came out in the early 1980s and reflect the situation at that time.Some of these models may require some changes based on today's realities. Asthis is a PD offering, buyer beware takes precidence here. You should findsome of these useful.  But there is no implied guarantee that any of thesemodels as presented will return information accurate for the 1990s.NOTE #2:  THE BOOKS THAT ACCOMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE          WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM.On Side One of this disk (III.ZAW.09) you'll find the following Visicalcmodels:AMORTIZATION MODELS-: Model 1:  Balloon Payment Loan Amortization             The creation of a loan amortization schedule for a simple             interest loan to be repaid monthly with a level payment             plus a balloon payment in the final month-: Model 2:  Interest Only Loan Amortization             The creation of a loan amortization schedule for a simple             interest loan wherein the initial payments are made             to interest only.  At a predetermined point, the loan             reverts to level interest and principal paymentsCUSTOMER SERVICE MODELS-: Model 3:  Daily Investment Rates             The preparation of a daily schedule for the rates offered             on CDs, IRA's, and Repurchase Agreements.  The schedule             also includes effective rates resulting from daily interest             compounding and interest payments over various time periods-: Model 4:  Daily Teller Transaction Count by Hour             The maintenance of teller transaction counts by hour of the             day and day of the week.  The model is useful in scheduling             the working hours of tellers-: Model 5:  Account Analysis             The preparation of a bill for services used by commercial             customers on both a fee and excess balance basisSIDE TWO:MANAGEMENT MODELS-: Model 6:  Director's Report             The preparation of a monthly set of Director's Reports             including Statement of Condition, Income Statement and a             Key Ratio Report-: Model 7:  Bankers Acceptance             A convenient record maintenance system for the Bankers             Acceptances owned by the bank-: Model 8:  TEFRA             The calculation of tax equivalent yields for municipal             securites under TEFRA, based upon the stated municipal yield             and a series of cost of funds assumptions.

DISK: APPLE-3-WAP-awz-10

APPLE-3-WAP-awz-10a.dsk [Catalog]APPLE-3-WAP-awz-10b.dsk [Catalog]WAP /// SIG PD LIBRARYDISK 3AWZ.10VIDEO CATALOG: DISK 1This disk contains a 3EZ Pieces/Appleworks Video Database of movies.  You canexpand as you like, add comments to current entries or delete those you have nointerest in.Side One has two files covering movies from 1) A-G and 2) H-K.Side Two has one file covering movies from L-PThis disk in NOT self-booting and requires 3EZ Pieces of Appleworks to use.

DISK 3AWZ.11

APPLE-3-WAP-awz-11a.dsk [Catalog]APPLE-3-WAP-awz-11b.dsk [Catalog]WAP /// SIG PD LIBRARYDISK 3AWZ.11VIDEO CATALOG: DISK 2This disk continues with a 3EZ Pieces/Appleworks Video Database of movies. Youcan expand as you like, add comments to current entries or delete those you haveno interest in.Side One has one file covering movies from Q-TSide Two has one file covering movies from U-ZThis disk in NOT self-booting and requires 3EZ Pieces of Appleworks to use.

DISK 3AWZ.12-15

APPLE-3-WAP-awz-12a.dsk [Catalog]APPLE-3-WAP-awz-12b.dsk [Catalog]APPLE-3-WAP-awz-13a.dsk [Catalog]APPLE-3-WAP-awz-13b.dsk [Catalog]APPLE-3-WAP-awz-14a.dsk [Catalog]APPLE-3-WAP-awz-14b.dsk [Catalog]APPLE-3-WAP-awz-15a.dsk [Catalog]APPLE-3-WAP-awz-15b.dsk [Catalog]WAP /// SIG PUBLIC DOMAIN LIBRARYDISKS 3AWZ.12-15 : PARISHWORKSREQUIRES APPLEWORKS OR 3EZ PIECESDISK APPLE-3-WAP-AWZ-12 SIDE ONE IS SELF BOOTINGThese disks have been tried with 3EZ Pieces and all have been shown to loadand work properly.  If you have an additional church-related templatesyou would like to contribute, we'd love to have them!Dave OttaliniJuly, 1993                              ParishWorks                  INSTRUCTIONS FOR SPECIFIC TEMPLATES                  -----------------------------------EXP.CHECK.REG: Expanded Check Register-------------The Expanded Check Register includes manual calculation. Everytime you want the computer to calculate, press <OPEN APPLE> K.You can calculate after each check, or you can wait until youhave entered several or all checks before you calculate. <OPEN APPLE> Kcan be used as often as needed.GIVING.DATA and NAMES  (Contributions Database)---------------------1hese two database files work together for tracking churchcontributions.  Shared with us by Sharon Rivers of Memphis,Tennessee.   Here's Sharon's guidelines:One file is used for the collection of weekly tithes and theother for tither information.  To help keep names and amountsseparated there are two databases.  The pastor or churchtreasurer should be the only ones that have access to thatinformation.  At the end of the year the pastor or treasurercould issue a statement telling each person what was their tithefor tax purposes.On the NAMES database is where the envelope number and name willbe kept.  This would be for issuance of the envelopes and toinsure that each family or person in a family has the opportunityto tithe.  This also provides the church officials a means totrack church income to specific areas.  Examples would be theBuilding Fund, Missionary Programs, Colleges, Disaster Relief,and other plans based upon the needs and desires of the church.Also, the NAMES database could be used for mailing out churchletters and flyers as a labels template is included along withit.Randomly distribute your envelopes trying not to match up nameswith numbers.  This can be sorted later by the computer for yourchurch reports and really doesn't matter.  Again the only purposeit to help keep the church tither's identity a secret from otherchurch members.Provided are spare fields for future expansion for your specificneeds.To facilitate practice with the GIVING.DATA database, you areprovided dummy records.  You can sort the information by the dateor by the number of the person doing the tithe.  Lets do somepractice reports:1.  To find the tithe for just Nov 20th.  Use Open-Apple R to    have Appleworks select on the date required then sort on No    followed by Date to put the database in correct order.File:   Giving.DataPage  1Report: WeeklySelection: Date equals Nov 20 89Date      No    Fund 1    Fund 2    Fund 3    Fund 4 Total--------- ---- -------   -------   -------   ------- -------Nov 20 89 1001    0.00     20.00     20.00      0.00 40.00Nov 20 89 1002   25.00      0.00      0.00     15.00 40.00Nov 20 89 1003    5.00     20.00     20.00      0.00 45.00Nov 20 89 1004    0.00     25.00     25.00      0.00 50.00Nov 20 89 1005    0.00      0.00      0.00     20.00 20.00                 30.00*    65.00*    65.00*    35.00* 195.00*You can see all the tithes sorted by the individual number andtotals down each of the funds.  You can change the names of thefunds to suit your needs.2.  To have a summarized report for any month.  Use Open-Apple R    to have Appleworks select on the month required then sort on    No to put the database in correct order.File:   Giving.DataPage  1Report: MonthlySelection: Date is after Nov  1 89  through  Date is before Nov 30 89Date      No    Fund 1    Fund 2    Fund 3    Fund 4 Total--------- ---- -------   -------   -------   ------- -------Nov  6 89        30.00     65.00     65.00     35.00 195.00Nov 13 89        30.00     65.00     65.00     35.00 195.00Nov 20 89        30.00     65.00     65.00     35.00 195.00Nov 27 89        30.00     65.00     65.00     35.00 195.00                120.00*   260.00*   260.00*   140.00* 780.00*Now you have a full picture for the month of November.  At theend of the year you can provide to your membership a full list oftheir tithes to help them with their tax information by doingthis.3.  To find the tithe for individuals for the year [or any    period] use Open-Apple S to have Appleworks sort on No    followed by Date to put the database in correct order. Then    use Open-Apple R to select on just a single tither like this:File:   Giving.DataPage  1Report: IndividualSelection: No equals 1001Date      No    Fund 1    Fund 2    Fund 3    Fund 4 Total--------- ---- -------   -------   -------   ------- -------Oct  2 89 1001    0.00     20.00     20.00      0.00 40.00Oct  9 89 1001    0.00     20.00     20.00      0.00 40.00Oct 16 89 1001    0.00     20.00     20.00      0.00 40.00Oct 23 89 1001    0.00     20.00     20.00      0.00 40.00Oct 30 89 1001    0.00     20.00     20.00      0.00 40.00Nov  6 89 1001    0.00     20.00     20.00      0.00 40.00Nov 13 89 1001    0.00     20.00     20.00      0.00 40.00Nov 20 89 1001    0.00     20.00     20.00      0.00 40.00Nov 27 89 1001    0.00     20.00     20.00      0.00 40.00                  0.00*   180.00*   180.00*     0.00* 360.00*You can now see just how versatile this can be.  You can have itautomatically give you the yearly reports by using the AutoAnnual report just by sorting on Date followed by No to put thedatabase in correct order.  The report driver will do therest for you.PAYROLL.REGISTR: Payroll Register---------------1.  Load the template file, and change the filename (for example:    MasterPayroll)2.  Set up the payroll file for your company:    A. Enter the FIXED DATA (the data that will not change from       payroll period to payroll period):  for example, the       Employee # (in both in Payroll Register and the Cumulative       Payroll Report), the Employee Name, the Rate of Pay, and       the fixed deductions (the deductions that do not change       from period to period; for example, the Other A, Other B,       and Other C, if these are fixed).    B. Save the file.3.  To prepare the Payroll Register for each period:    A. Load the most recent payroll file to the screen, and       change the filename to reflect the current payroll       period (for example, Payroll3.15.90).    B. Temporarily MOVE the Cumulative Payroll Report (Rows 58       through 110 at the bottom of the file for the long form)       to the Clipboard:     (1)  Move the cell cursor to the beginning of the          Cumulative Payroll Report Row 58.     (2)  Enter the MOVE command:  <OPEN APPLE> m for move.     (3)  From the options listed at the bottom of the          screen, select "To the Clipboard (cut)" by          highlighting the option and pressing <RETURN>.     (4)  Identify the material to be moved by using the          <DOWN ARROW> to highlight through Row 110 (the last          line of the Cumulative Report).     (5)  <RETURN> to indicate that all of the material to be          moved has been identified.     (6)  The computer will warn you that "You are about to clear          or remove protected cells.  Do you really want to do          this?"          Select "Yes."          (The Cumulative Payroll Report leaves your screen, but          it is stored safely on the Clipboard, a temporary          storage space provided by AppleWorks.  The Report will          remain on the Clipboard until you move it back to the          screen later to complete the Cumulative Payroll          Report--or until you turn off the computer, whichever          comes first.)     C. Enter the number of hours worked for ALL EMPLOYEES.NOTE:  Unless this is the first payroll period for which the fileis used, the file currently contains the number of hours from theprevious period. Change the number of hours worked to the currentperiod by moving the cell cursor to the cell, typing the currentnumber of hours, and pressing <RETURN>.You will note that the computer does not AUTOMATICALLY CALCULATEthe wages--instead, this file has been set up to calculate onlywhen the CALCULATE command is entered in Step D, which follows.     D. After all employee work hours have been entered, enter        the CALCULATE command--<OPEN APPLE> K for calculate--so        that the computer will automatically calculate the        Regular Pay, Overtime Pay, and Total Wages for all        employees.     E. Using the Total Wages amount and a tax table, look up and        enter the Federal and State Withholding Taxes (and Other        deductions, as needed).     F. Enter the CALCULATE command again, and the computer will        calculate the Net Pay.     G. SAVE the current Payroll Register:  <OPEN APPLE> S.4.  To prepare the Cumulative Payroll Report:     A. Change the filename to a cumulative report name (for        example:  CumPay13.15.90)     B. Move the Cumulative Payroll Report from the Clipboard:     (1) Move the cell cursor to the beginning of Row 58.     (2) Enter the MOVE command.     (3) From the options listed at the bottom of the screen,         select "From the Clipboard (paste)."     (4) From the options listed, select "Formulas and Values."         The Cumulative Payroll Report now reappears in Rows 58         through 110 of your screen.     C.  Enter the CALCULATE command:  <OPEN APPLE> K.     The computer automatically adds the current payroll to the     previous Cumulative Payroll Report.     D.  Save the file:  <OPEN APPLE> S for save.PETTY.CASH.REG: Petty Cash Register--------------1.  Each payment is recorded in two columns:  the Payments column    and one of the Distribution of Payments columns.2.  After each line is entered in the register, the "Yes" at the    bottom of the screen should have a 1 beside it to signal    that the amounts in the two columns were entered alike.3.  To print the Petty Cash Register WITHOUT the "test" at the    bottom of the file:    A. Move the cell cursor to the line following the double       line.    B. Enter the DELETE command:  <OPEN APPLE> D for delete.    C.  Select "Rows."    D.  Highlight the rows to be deleted, and <RETURN>.MERGING DATABASES by Robert Ericson-----------------"In many applications you will need to merge information fromseveral different sources. This section provides tips for merginginformation from two similar or markedly different databasefiles.  Surprisingly few AppleWorks users even know that this canbe done.TIP: When you merge records from two different files,their original category orders must match.Focus all your attention on the original category orders. Fromthe Review mode you can press Apple-N to see the original order.Print a copy of the category names screen of the source file,then load the destination file. Compare its category names screenwith the hard copy you just printed.Suppose both files have exactly the same original categoryorder. To merge the information, follow these steps:1. Change the name of the Desktop files, just to be safe.   Name the files Source and Destination.2. Using multiple-record layout, copy the records in the   Source file to the clipboard, then from the clipboard to theDestination file.3. Check the multiple-record layout in the Destination file tomake certain that the category information is consistent.Note that when the information is transferred, the categoriesappear in the order of the Destination file's single- andmultiple-record layouts. In the multiple-record layout, thecategory widths are those of the Destination file.You can ignore the single- and multiple-record layouts of theSource and Destination files until the final check. If theymatch, the original category orders may still differ. If theirorders differ before-hand, the Destination file will evaluateeverything in its original category order. Focus all yourattention on the original category orders.TIP: Two Data Base files can be merged even if they havedifferent numbers of categories.Decide what categories you need to transfer from the Source fileto the Destination file. For example, the table below comparesthe original category orders of the Everyone list (the Sourcefile) and the Members list (the Destination file). The categoriesare identical through the eighth category, PHONE. The remainingcategories have no value to the Destination file, except forNOTE, which has information that belongs in the NOTES category inthe Destination file. ------------------------------------------|   Table: Everyone list and Members list  ||          categories compared 3           ||                                          ||      Origin File     Destination File    ||                                          ||      FIRST NAME      LAST NAME           ||      LAST NAME       LAST NAME           ||      PLACE           PLACE               ||      STREET          STREET              ||      TOWN            TOWN                ||      STATE           STATE               ||      ZIP             ZIP                 ||      PHONE           PHONE               ||      NOTE            COMMITTEE           ||      CODE            YEARS               ||      KEYWORD         1986                ||      Rl              1987                ||      R2              1988                ||      R3              NOTES               ||      R4              RESERVED            ||                                          | ------------------------------------------You can proceed with the merge almost as in the last tip. Followthese steps:1. Change the name of the Desktop files if you have not alreadydone so. Name the files Source and Destination.2. Delete all Source file categories after PHONE, except for   NOTE. Don't worry about report formats, because you will   never use this file again.3. Insert five categories between PHONE and NOTE. Name   them anything, and then return to the multiple-record layout.4. Copy the records in the Source file to the clipboard, then   from the clipboard to the Destination file.5. Check the multiple-record layout in the Destination file to   make certain that the category information is consistent.Note that all the records from the Source file have gained theadditional categories of the Destination file. However, theSource files have no information in those categories.The rules for transferring are easy to remember. If the Sourcefile has more categories than the Destination file, theadditional categories win be lost in the merge. If the Sourcefile has fewer categories, it will gain the additional categoriesof the Destination file, but they will contain no information.TIP: When the original category orders of two files do notmatch, print the records to an ASCII file.Suppose the Source file categories begin with LAST NAMEand the Destination file categories begin with FIRST NAME.This presents a problem. In this case, proceed as follows:1. Create a labels-style report format for the Source file in the   original category order of the Destination file. Count and   make a note of the number of categories in the report.2. Select the records you want to print.3. Print the report to an ASCII file.4. Create a new Data Base file from the ASCII file. Enter the   correct number of categories for the new file.5. Using multiple-record layout, copy the records in the   Source file to the clipboard, then from the clipboard to the   Destination file.6. Check the multiple-record layout in the Destination file to   make certain that the category information is consistent.TIP: Merge files to find duplicate entries.If you have ever received two copies of a form letter or mis-takenly sent two copies to the same person, you will appreciatethis technique.  It saves postage, paper, and embarrassment.Suppose you have two mailing lists on separate files. By mergingthe records, you can find and delete duplicate entries. Create amultiple-record layout with FIRST NAME, LAST NAME, STREET, STATE,ZIP, and PLACE in that order. Arrange the records alphabeticallyby first name, then by last name. Scan the LAST NAME column forduplicate entries. The street address column is the next bestreference point.If the files are too large to merge, merge sections at a time.When you find obvious duplication, you may find slightlydifferent spellings. One spelling of a name may be more plausiblethan the other, but such corrections are often matters ofjudgment."    (Used With Permission)        Robert Ericson: APPLEWORKS TIPS AND TECHNIQUES         (Second Edition) ISBN 0-89588-480-1  $19.95                         Symbex Inc.                   2021 Challenger Dr. #100                       Alameda CA 94501                        800-227-2346#

Return to Apple /// Library page